Show
Ignore:
Timestamp:
05/08/08 11:43:23 (8 months ago)
Author:
aarkerio
Message:

Forums and topics improveds

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/app/config/sql/postgresql/replies.sql

    r436 r461  
    33 reply text NOT NULL, 
    44 created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    5  topic_id integer NOT NULL REFERENCES topics(id) ON DELETE CASCADE, 
    6  user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE, 
     5 topic_id int NOT NULL REFERENCES topics(id) ON DELETE CASCADE, 
     6 vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, -- just one facility to create student's reports 
     7 user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE, 
    78 status int NOT NULL DEFAULT 1 
    89);