Changeset 605 for trunk/app/config

Timestamp:

06/13/08 23:34:00 (5 months ago)

Author:

aarkerio

Message:

Add reports

Location:

trunk/app/config/sql/postgresql

Files:

• participations.sql (modified) (1 diff)
• reports.sql (added)

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

@@ -2 +2 @@
    id serial NOT NULL PRIMARY KEY,
    title varchar(80) NOT NULL,
-   user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+   user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE, -- student id
    points smallint NOT NULL DEFAULT 1,
    participation text NOT NULL,