← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/migrations/20091217-01.sql

  • Committer: Matt Giuca
  • Date: 2010-07-20 12:16:51 UTC
  • mto: This revision was merged to the branch mainline in revision 1818.
  • Revision ID: matt.giuca@gmail.com-20100720121651-rgeeztj6jn1tsrou
Submit page: No longer disables the radio button for closed projects.
Displays them in red rather than grey (grey implies disabled, red implies caution).
Added notice that the deadline has passed, but submission can still be done with a penalty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/migrations/20091217-01.sql
 
1
BEGIN;
 
2
 
 
3
ALTER TABLE offering ADD COLUMN description TEXT;
 
4
ALTER TABLE offering ADD COLUMN url TEXT;
 
5
 
 
6
UPDATE offering SET url = (SELECT url FROM subject WHERE subject.subjectid = offering.subject);
 
7
 
 
8
ALTER TABLE subject DROP COLUMN url;
 
9
 
 
10
COMMIT;