Changeset 441 for trunk/app/config/sql/postgresql/treasures.sql

Timestamp:

04/29/08 17:56:48 (8 months ago)

Author:

aarkerio

Message:

Treasure hunts

Files:

• trunk/app/config/sql/postgresql/treasures.sql (modified) (1 diff)

trunk/app/config/sql/postgresql/treasures.sql

@@ -3 +3 @@
   "id" serial PRIMARY KEY,
   "title" varchar(150) NOT NULL,
+  "points" smallint NOT NULL DEFAULT 3, 
+  "secret" varchar(15) NOT NULL,  -- secret word, stop  
   "instructions" text NOT NULL DEFAULT '',
   "user_id" int NOT NULL REFERENCES users(id) ON DELETE CASCADE,