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

« back to all changes in this revision

Viewing changes to userdb/users.sql

  • Committer: dcoles
  • Date: 2008-08-18 04:34:11 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:1021
Database: Adds active column to problem_attempt table.
This allows a group of problem attempts (ie. from previous semesters) to be
marked as 'inactive' and thus counting toward a problem being assessment for
the current semester.

Show diffs side-by-side

added added

removed removed

Lines of Context:
245
245
    date        TIMESTAMP NOT NULL,
246
246
    attempt     VARCHAR NOT NULL,
247
247
    complete    BOOLEAN NOT NULL,
 
248
    active      BOOLEAN NOT NULL DEFAULT true,
248
249
    PRIMARY KEY (problemid,loginid,date)
249
250
);
250
251