← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: mattgiuca
  • Date: 2008-07-07 06:00:15 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:817
users.sql: Moved url from offering to subjects table.
    (The commit log in the previous revision which explains how to update your
    DB is still correct).

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
23
23
    subjectid       SERIAL PRIMARY KEY NOT NULL,
24
24
    subj_code       VARCHAR UNIQUE NOT NULL,
25
25
    subj_name       VARCHAR NOT NULL,
26
 
    subj_short_name VARCHAR     -- may be null
 
26
    subj_short_name VARCHAR,    -- may be null
 
27
    url             VARCHAR
27
28
);
28
29
 
29
30
CREATE TABLE offering (
30
31
    offeringid  SERIAL PRIMARY KEY NOT NULL,
31
32
    subject     INT4 REFERENCES subject (subjectid) NOT NULL,
32
33
    year        CHAR(4) NOT NULL,
33
 
    semester    CHAR(1) NOT NULL,
34
 
    url         VARCHAR
 
34
    semester    CHAR(1) NOT NULL
35
35
);
36
36
 
37
37
CREATE TABLE project (