← 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-02-24 01:32:50 UTC
  • Revision ID: grantw@unimelb.edu.au-20100224013250-3pfbslg7a5i2eb8g
Refactor UserAdminView to use BaseFormView.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
64
64
    semesterid  INTEGER REFERENCES semester (semesterid) NOT NULL,
65
65
    description VARCHAR,
66
66
    url         VARCHAR,
67
 
    show_worksheet_marks BOOLEAN NOT NULL DEFAULT false,
68
 
    worksheet_cutoff TIMESTAMP,
69
67
    groups_student_permissions  VARCHAR NOT NULL DEFAULT 'none',
70
68
    CHECK (groups_student_permissions in ('none', 'invite', 'create')),
71
69
    UNIQUE (subject, semesterid)
229
227
    name        TEXT NOT NULL,
230
228
    data        TEXT NOT NULL,
231
229
    assessable  BOOLEAN NOT NULL,
232
 
    published   BOOLEAN NOT NULL DEFAULT true,
233
230
    seq_no      INT4 NOT NULL,
234
231
    format      TEXT NOT NUll,
235
232
    UNIQUE (offeringid, identifier)