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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: Nick Chadwick
  • Date: 2009-02-18 12:50:31 UTC
  • mto: (1099.1.180 new-dispatch)
  • mto: This revision was merged to the branch mainline in revision 1100.
  • Revision ID: chadnickbok@gmail.com-20090218125031-0gwxxfljq1iqipgz
Working on putting worksheets into the database.

This will lead to a nice editor for each worksheet.

This commit also introduces my changes linking problem attempts to
worksheets AND exercises, not just exercises.

Show diffs side-by-side

added added

removed removed

Lines of Context:
204
204
    worksheetid SERIAL PRIMARY KEY,
205
205
    offeringid  INT4 REFERENCES offering (offeringid) NOT NULL,
206
206
    identifier  VARCHAR NOT NULL,
 
207
    name        TEXT NOT NULL,
 
208
    data         TEXT NOT NULL,
207
209
    assessable  BOOLEAN,
208
 
    mtime       TIMESTAMP,
 
210
    order_no    INT4,
209
211
    UNIQUE (offeringid, identifier)
210
212
);
211
213