Changeset 386 for trunk/app/config/sql/karamelo_postgres.sql

Timestamp:

04/10/08 21:15:33 (9 months ago)

Author:

aarkerio

Message:

FOrums and vclassrooms

Files:

• trunk/app/config/sql/karamelo_postgres.sql (modified) (4 diffs)

trunk/app/config/sql/karamelo_postgres.sql

@@ -191 +191 @@
  description varchar(500) NOT NULL,
  user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+ vclassroom_id integer NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
  catforum_id integer NOT NULL REFERENCES catforums(id) ON DELETE CASCADE,
  status int NOT NULL DEFAULT 0  -- Activated = 1,  Deactivated=0
 );
+
 
 CREATE TABLE topics ( -- question and aswers in forums  
@@ -554 +556 @@
 );
 
---three table to tests
+-- Test model tables beggins
 CREATE TABLE "tests" (
   "id" serial PRIMARY KEY,
@@ -591 +593 @@
 );
 
-CREATE TABLE results (  -- tests results
+CREATE TABLE results (  -- tests student results
    id serial NOT NULL UNIQUE,
    user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
@@ -598 +600 @@
    PRIMARY KEY (user_id, test_id)
 );
+-- Test model tables ends
+
 
 -- Share it!