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

« back to all changes in this revision

Viewing changes to userdb/migrations/20100727-02.sql

• browse files at revision 1281.1.7
• compare with another revision
• download diff
• download tarball
• view history from revision 1281.1.7

• reverse the comparison (1281.1.7 to 1839)
• stop comparing with revision 1839

Show diffs side-by-side

added

removed

userdb/migrations/20100727-02.sql

1

 

BEGIN;

2

 

 

3

 

ALTER TABLE semester RENAME COLUMN semester TO url_name;

4

 

ALTER TABLE semester ADD COLUMN display_name TEXT;

5

 

ALTER TABLE semester ADD COLUMN code TEXT;

6

 

ALTER TABLE semester ADD CONSTRAINT semester_year_key1

7

 

    UNIQUE (year, code);

8

 

 

9

 

UPDATE semester SET code = UPPER(url_name);

10

 

UPDATE semester SET display_name = 'semester ' || code;

11

 

 

12

 

ALTER TABLE semester ALTER COLUMN display_name SET NOT NULL;

13

 

ALTER TABLE semester ALTER COLUMN code SET NOT NULL;

14

 

 

15

 

COMMIT;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1