← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/migrations/20090212-01.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/migrations/20090212-01.sql
38
38
    offeringid  INT4 REFERENCES offering (offeringid) NOT NULL,
39
39
    identifier  VARCHAR NOT NULL,
40
40
    name        TEXT NOT NULL,
41
 
    data         TEXT NOT NULL,
42
 
    assessable  BOOLEAN,
43
 
    order_no    INT4,
 
41
    data        TEXT NOT NULL,
 
42
    assessable  BOOLEAN NOT NULL,
 
43
    order_no    INT4 NOT NULL,
 
44
    format      ENUM,
44
45
    UNIQUE (offeringid, identifier)
45
46
);
46
47
 
47
48
CREATE TABLE worksheet_problem (
48
 
    worksheetid INT4 REFERENCES worksheet (worksheetid) NOT NULL,
49
 
    problemid   TEXT REFERENCES problem (identifier) NOT NULL,
50
 
    optional    BOOLEAN,
 
49
    worksheetid     INT4 REFERENCES worksheet (worksheetid) NOT NULL,
 
50
    problemid       TEXT REFERENCES problem (identifier) NOT NULL,
 
51
    optional        BOOLEAN,
 
52
    seq_no          INT4, 
 
53
    active          BOOLEAN,
51
54
    PRIMARY KEY (worksheetid, problemid)
52
55
);
53
56