← 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-02-25 04:44:54 UTC
  • Revision ID: svn-v4:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:1209
userdb/users.sql: Fixed two syntax errors. Jeepers!

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
 
    admin       BOOLEAN NOT NULL DEFAULT false;
 
11
    admin       BOOLEAN NOT NULL DEFAULT false,
12
12
    unixid      INT UNIQUE DEFAULT nextval('login_unixid_seq') NOT NULL,
13
13
    nick        VARCHAR NOT NULL,
14
14
    pass_exp    TIMESTAMP,
36
36
    semesterid  SERIAL PRIMARY KEY NOT NULL,
37
37
    year        CHAR(4) NOT NULL,
38
38
    semester    CHAR(1) NOT NULL,
39
 
    state       TEXT NOT NULL CHECK state IN ('disabled', 'past',
40
 
                                    'current', 'future') DEFAULT 'current',
 
39
    state       TEXT NOT NULL CHECK (state IN ('disabled', 'past',
 
40
                                    'current', 'future')) DEFAULT 'current',
41
41
    UNIQUE (year, semester)
42
42
);
43
43