← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/users.sql

https://launchpad.net/bugs/526956
https://launchpad.net/bugs/526960
Allow hiding of worksheets from students, and hiding of worksheet marks out of 5. Also add column for per-offering worksheet cutoff date, as yet unimplemented.

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,
67
69
    groups_student_permissions  VARCHAR NOT NULL DEFAULT 'none',
68
70
    CHECK (groups_student_permissions in ('none', 'invite', 'create')),
69
71
    UNIQUE (subject, semesterid)
227
229
    name        TEXT NOT NULL,
228
230
    data        TEXT NOT NULL,
229
231
    assessable  BOOLEAN NOT NULL,
 
232
    published   BOOLEAN NOT NULL DEFAULT true,
230
233
    seq_no      INT4 NOT NULL,
231
234
    format      TEXT NOT NUll,
232
235
    UNIQUE (offeringid, identifier)