Changeset 441 for trunk/app/config

Show
Ignore:
Timestamp:
04/29/08 17:56:48 (7 months ago)
Author:
aarkerio
Message:

Treasure hunts

Location:
trunk/app/config/sql/postgresql
Files:
1 added
1 modified

Legend:

Unmodified
Added
Removed

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

    r436 r441  
    33  "id" serial PRIMARY KEY, 
    44  "title" varchar(150) NOT NULL, 
     5  "points" smallint NOT NULL DEFAULT 3,  
     6  "secret" varchar(15) NOT NULL,  -- secret word, stop   
    57  "instructions" text NOT NULL DEFAULT '', 
    68  "user_id" int NOT NULL REFERENCES users(id) ON DELETE CASCADE,