← Back to branch summary

~azzar1/unity/add-show-desktop-key

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: drtomc
  • Date: 2008-03-06 23:44:56 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:665
userdb: Add a submission table, as per our discussions.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
91
91
    notes       VARCHAR
92
92
);
93
93
 
 
94
CREATE TABLE project_submission (
 
95
    assessedid  INT4 REFERENCES assessed (assessedid) NOT NULL,
 
96
    projectid   INT4 REFERENCES project (projectid) NOT NULL,
 
97
    path        VARCHAR NOT NULL,
 
98
    revision    INT4 NOT NULL
 
99
);
 
100
 
94
101
CREATE TABLE project_mark (
95
102
    assessedid  INT4 REFERENCES assessed (assessedid) NOT NULL,
96
103
    projectid   INT4 REFERENCES project (projectid) NOT NULL,