Changeset 753 for trunk/app/config

Show
Ignore:
Timestamp:
09/03/08 21:34:40 (3 months ago)
Author:
aarkerio
Message:

New layout

Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r738 r753  
    11CREATE TABLE chats (  -- chats on vgroups 
    22   id serial NOT NULL PRIMARY KEY, 
    3    user_id int NOT NULL REFERENCES users(id), -- teacher id in fact 
     3   student_id int NOT NULL REFERENCES users(id), -- student id in fact 
     4   teacher_id int NOT NULL REFERENCES users(id), -- student id in fact 
    45   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
     6   message varchar(100) NOT NULL, 
    57   "created" timestamp(0) with time zone DEFAULT now() NOT NULL 
    68);