← 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: 2009-02-24 13:29:44 UTC
  • Revision ID: grantw@unimelb.edu.au-20090224132944-lm29zd1li1rjg77p
Privileges (apart from admin) are now offering-local, not global.

Offering privileges are granted by Enrolment.role, and global admin
by User.admin. ivle.caps is dead.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
8
8
    state       VARCHAR NOT NULL CHECK (state in ('no_agreement', 'pending',
9
9
                                              'enabled', 'disabled'))
10
10
                                 DEFAULT 'no_agreement',
11
 
    rolenm      VARCHAR NOT NULL CHECK (rolenm in ('anyone', 'student',
12
 
                                                   'marker', 'tutor',
13
 
                                                   'lecturer', 'admin')),
 
11
    admin       BOOLEAN NOT NULL DEFAULT false;
14
12
    unixid      INT UNIQUE DEFAULT nextval('login_unixid_seq') NOT NULL,
15
13
    nick        VARCHAR NOT NULL,
16
14
    pass_exp    TIMESTAMP,
129
127
CREATE TABLE enrolment (
130
128
    loginid     INT4 REFERENCES login (loginid),
131
129
    offeringid  INT4 REFERENCES offering (offeringid),
 
130
    role        TEXT NOT NULL CHECK (role IN ('student', 'tutor',
 
131
                                              'lecturer')) DEFAULT 'student',
132
132
    result      INT,
133
133
    special_result VARCHAR,
134
134
    supp_result INT,