~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 1425
• compare with another revision
• download diff
• download tarball
• view history from revision 1425

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

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