← 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 09:02:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1824.
  • Revision ID: grantw@unimelb.edu.au-20100727090206-pmf5j6lu6xc892q8
Replace semester.semester with semester.{code,url_name,display_name}.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
52
52
CREATE TABLE semester (
53
53
    semesterid  SERIAL PRIMARY KEY NOT NULL,
54
54
    year        TEXT NOT NULL CHECK (valid_url_name(year)),
55
 
    url_name    TEXT NOT NULL CHECK (valid_url_name(url_name)),
56
 
    code        TEXT NOT NULL,
57
 
    display_name TEXT NOT NULL,
 
55
    semester    TEXT NOT NULL CHECK (valid_url_name(semester)),
58
56
    state       TEXT NOT NULL CHECK (state IN ('disabled', 'past',
59
57
                                    'current', 'future')) DEFAULT 'current',
60
 
    UNIQUE (year, url_name),
61
 
    UNIQUE (year, code)
 
58
    UNIQUE (year, semester)
62
59
);
63
60
 
64
61
CREATE TABLE offering (