← 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-21 09:09:07 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:923
users.sql: Added groups_student_permissions column to offering table.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
34
34
    semester    CHAR(1) NOT NULL,
35
35
    max_groups_per_student      INT4 DEFAULT 1,
36
36
    max_students_per_group      INT4 DEFAULT 4,
 
37
    groups_student_permissions  VARCHAR NOT NULL
 
38
        CHECK (groups_student_permissions in ('none', 'invite',
 
39
                                              'create'))
 
40
        DEFAULT 'none';
37
41
    UNIQUE (subject, year, semester)
38
42
);
39
43