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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: Matt Giuca
  • Date: 2010-07-22 03:57:16 UTC
  • mto: This revision was merged to the branch mainline in revision 1820.
  • Revision ID: matt.giuca@gmail.com-20100722035716-7p5t3c349lqwasqk
Database: Modified project_extension table; replaced 'deadline TIMESTAMP' with 'days INT'. This means the extension is a time delta on top of the existing deadline, not a replacement deadline.
Added a migration (userdb/migrations/20100722-01.sql) and updated ivle.database.

Show diffs side-by-side

added added

removed removed

Lines of Context:
190
190
CREATE TABLE project_extension (
191
191
    extensionid SERIAL PRIMARY KEY,
192
192
    assessedid  INT4 REFERENCES assessed (assessedid) NOT NULL,
193
 
    deadline    TIMESTAMP NOT NULL,
 
193
    days        INT NOT NULL,
194
194
    approver    INT4 REFERENCES login (loginid) NOT NULL,
195
195
    notes       VARCHAR
196
196
);