Changeset 502 for trunk/app/config/sql/postgresql/result_treasures.sql

Timestamp:

05/17/08 15:51:23 (8 months ago)

Author:

aarkerio

Message:

Loque sea

Files:

• trunk/app/config/sql/postgresql/result_treasures.sql (modified) (1 diff)

trunk/app/config/sql/postgresql/result_treasures.sql

@@ -3 +3 @@
    user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    points smallint NOT NULL,
-   treasure_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
+   treasure_id int NOT NULL REFERENCES treasures (id) ON DELETE CASCADE,
    vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
    PRIMARY KEY (user_id, treasure_id, vclassroom_id)