← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: Matt Giuca
  • Date: 2009-05-12 15:08:45 UTC
  • mto: This revision was merged to the branch mainline in revision 1247.
  • Revision ID: matt.giuca@gmail.com-20090512150845-fg480l1qh7le0ypz
ivle-fetchsubmissions: In a stunningly awful hack, detects pre-Python2.6 and
    changes make_zip to behave correctly for the awful restriction in zipfile
    that you can't add directories.
    (Stops trying to add directories, and hacks in the footer writing if there
    is an empty file).

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
28
28
    subjectid       SERIAL PRIMARY KEY NOT NULL,
29
29
    subj_code       VARCHAR UNIQUE NOT NULL,
30
30
    subj_name       VARCHAR NOT NULL,
31
 
    subj_short_name VARCHAR UNIQUE NOT NULL
 
31
    subj_short_name VARCHAR UNIQUE NOT NULL,
 
32
    url             VARCHAR
32
33
);
33
34
 
34
35
CREATE TABLE semester (
44
45
    offeringid  SERIAL PRIMARY KEY NOT NULL,
45
46
    subject     INT4 REFERENCES subject (subjectid) NOT NULL,
46
47
    semesterid  INTEGER REFERENCES semester (semesterid) NOT NULL,
47
 
    description VARCHAR,
48
 
    url         VARCHAR,
49
48
    groups_student_permissions  VARCHAR NOT NULL DEFAULT 'none',
50
49
    CHECK (groups_student_permissions in ('none', 'invite', 'create')),
51
50
    UNIQUE (subject, semesterid)
67
66
    synopsis    TEXT,
68
67
    url         TEXT,
69
68
    projectsetid  INTEGER REFERENCES project_set (projectsetid) NOT NULL,
70
 
    deadline    TIMESTAMP NOT NULL
 
69
    deadline    TIMESTAMP
71
70
);
72
71
 
73
72
CREATE OR REPLACE FUNCTION check_project_namespacing_insertupdate()