Changeset 563 for trunk/app/config

Timestamp:

05/26/08 22:47:53 (6 months ago)

Author:

aarkerio

Message:

Reports

Location:

trunk/app/config/sql/postgresql

Files:

• participations.sql (modified) (1 diff)
• replies.sql (modified) (1 diff)

trunk/app/config/sql/postgresql/participations.sql

@@ -5 +5 @@
    points smallint NOT NULL DEFAULT 1,
    participation text NOT NULL,
-   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE
+   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
+   "created" timestamp(0) with time zone DEFAULT now() NOT NULL
 );
 -- Test model tables ends

trunk/app/config/sql/postgresql/replies.sql

@@ -6 +6 @@
  vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, -- just one facility to create student's reports
  user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
- status int NOT NULL DEFAULT 1
+ status smallint NOT NULL DEFAULT 1,
+ points smallint NOT NULL DEFAULT 1
 );