Changeset 395 for trunk/app/config

Timestamp:

04/14/08 10:20:01 (8 months ago)

Author:

aarkerio

Message:

Fixed test controller

Files:

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

trunk/app/config/sql/karamelo_postgres.sql

@@ -318 +318 @@
     "created" timestamp(0) with time zone DEFAULT now() NOT NULL,
     "status" smallint DEFAULT 0 NOT NULL,
-    "user_id" integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
-    "ecourse_id" integer NOT NULL REFERENCES ecourses(id) ON DELETE CASCADE,
-    "secret" varchar(6),   -- secreto code to allow students register by themselves
-    "access" smallint NOT NULL DEFAULT 0
+    "user_id" int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    "ecourse_id" int NOT NULL REFERENCES ecourses(id) ON DELETE CASCADE,
+    "secret" varchar(6),   -- secret code to allow students register by themselves
+    "access" smallint NOT NULL DEFAULT 0 -- public / only with code
 );
 
@@ -569 +569 @@
 CREATE TABLE "tests_vclassrooms" (
  "id" serial PRIMARY KEY,
- "test_id" int NOT NULL REFERENCES tests(id),
- "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id),
+ "test_id" int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
+ "vclassroom_id" int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
   UNIQUE  ("test_id", "vclassroom_id")
 );