← Back to branch summary

~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-19 05:47:56 UTC
  • mto: (1099.1.180 new-dispatch)
  • mto: This revision was merged to the branch mainline in revision 1100.
  • Revision ID: chadnickbok@gmail.com-20090219054756-v984vmc7kheiq6xy
Updated the tutorial service, to now allow users to edit worksheets
online.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/users.sql
205
205
    offeringid  INT4 REFERENCES offering (offeringid) NOT NULL,
206
206
    identifier  VARCHAR NOT NULL,
207
207
    name        TEXT NOT NULL,
208
 
    data         TEXT NOT NULL,
209
 
    assessable  BOOLEAN,
210
 
    order_no    INT4,
 
208
    data        TEXT NOT NULL,
 
209
    assessable  BOOLEAN NOT NULL,
 
210
    order_no    INT4 NOT NULL,
 
211
    format      TEXT NOT NUll,
211
212
    UNIQUE (offeringid, identifier)
212
213
);
213
214
 
214
215
CREATE TABLE worksheet_problem (
215
 
    worksheetid INT4 REFERENCES worksheet (worksheetid) NOT NULL,
216
 
    problemid   TEXT REFERENCES problem (identifier) NOT NULL,
217
 
    optional    BOOLEAN,
 
216
    id
 
217
    worksheetid     INT4 REFERENCES worksheet (worksheetid) NOT NULL,
 
218
    problemid       TEXT REFERENCES problem (identifier) NOT NULL,
 
219
    seq_no          INT4,
 
220
    active          BOOLEAN,
 
221
    optional        BOOLEAN,
218
222
    PRIMARY KEY (worksheetid, problemid)
219
223
);
220
224