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

« back to all changes in this revision

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

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

• reverse the comparison (172 to 999)
• stop comparing with revision 999

Show diffs side-by-side

added

removed

userdb/migrations/20080707-01.sql

1

 

BEGIN;

2

 

 

3

 

CREATE TABLE subject (                                                               

4

 

    subjectid       SERIAL PRIMARY KEY NOT NULL,

5

 

    subj_code       VARCHAR UNIQUE NOT NULL,

6

 

    subj_name       VARCHAR NOT NULL,

7

 

    subj_short_name VARCHAR,    -- may be null

8

 

    url             VARCHAR

9

 

);

10

 

  

11

 

DELETE FROM offering;

12

 

ALTER TABLE offering DROP COLUMN subj_code;

13

 

ALTER TABLE offering DROP COLUMN subj_name;

14

 

ALTER TABLE offering DROP COLUMN url;

15

 

ALTER TABLE offering ADD COLUMN subject INT4 REFERENCES subject (subjectid) NOT NULL;

16

 

 

17

 

COMMIT;

18

 

 

• Older »

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