← 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-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:
userdb/migrations/20090212-01.sql
37
37
    worksheetid SERIAL PRIMARY KEY,
38
38
    offeringid  INT4 REFERENCES offering (offeringid) NOT NULL,
39
39
    identifier  VARCHAR NOT NULL,
 
40
    name        TEXT NOT NULL,
 
41
    data         TEXT NOT NULL,
40
42
    assessable  BOOLEAN,
41
 
    mtime       TIMESTAMP,
 
43
    order_no    INT4,
42
44
    UNIQUE (offeringid, identifier)
43
45
);
44
46