← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: William Grant
  • Date: 2010-07-27 10:25:59 UTC
  • Revision ID: grantw@unimelb.edu.au-20100727102559-cvt3fhlaiaknd5bp
https://launchpad.net/bugs/610407
Validate uniqueness of Subject.code at the form layer, so we don't crash due to DB constraints.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
51
51
 
52
52
CREATE TABLE semester (
53
53
    semesterid  SERIAL PRIMARY KEY NOT NULL,
54
 
    year        CHAR(4) NOT NULL CHECK (valid_url_name(year)),
55
 
    semester    CHAR(1) NOT NULL CHECK (valid_url_name(semester)),
 
54
    year        TEXT NOT NULL CHECK (valid_url_name(year)),
 
55
    semester    TEXT NOT NULL CHECK (valid_url_name(semester)),
56
56
    state       TEXT NOT NULL CHECK (state IN ('disabled', 'past',
57
57
                                    'current', 'future')) DEFAULT 'current',
58
58
    UNIQUE (year, semester)
190
190
CREATE TABLE project_extension (
191
191
    extensionid SERIAL PRIMARY KEY,
192
192
    assessedid  INT4 REFERENCES assessed (assessedid) NOT NULL,
193
 
    deadline    TIMESTAMP NOT NULL,
 
193
    days        INT NOT NULL,
194
194
    approver    INT4 REFERENCES login (loginid) NOT NULL,
195
195
    notes       VARCHAR
196
196
);