Changeset 444 for trunk/app/config

Timestamp:

05/01/08 23:19:28 (7 months ago)

Author:

aarkerio

Message:

Add new tables for students result

Location:

trunk/app/config/sql/postgresql

Files:

• participations.sql (added)
• result_treasures.sql (added)
• result_webquests.sql (added)
• topics.sql (modified) (1 diff)

trunk/app/config/sql/postgresql/topics.sql

@@ -4 +4 @@
  message text NOT NULL,
  created timestamp(0) with time zone DEFAULT now() NOT NULL,
- forum_id integer NOT NULL REFERENCES forums(id) ON DELETE CASCADE,
+ forum_id int NOT NULL REFERENCES forums(id) ON DELETE CASCADE,
+ vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, -- just one facility to create student's reports
  user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
- status int NOT NULL DEFAULT 1,
- views int NOT NULL DEFAULT 0  -- number of times the topic has been seen
+ status smallint NOT NULL DEFAULT 1,
+ views smallint NOT NULL DEFAULT 0  -- number of times the topic has been seen
 );