-
Committer:
mattgiuca
-
Date:
2008-07-07 05:59:07 UTC
-
Revision ID:
svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:816
users.sql: Updated database schema; split subject and offering tables.
Need to manually apply the following commands to being the database up to
date. Note that this will wipe all data in your "offering" table - which
shouldn't matter because IVLE has never used this table to date.
CREATE TABLE subject (
subjectid SERIAL PRIMARY KEY NOT NULL,
subj_code VARCHAR UNIQUE NOT NULL,
subj_name VARCHAR NOT NULL,
subj_short_name VARCHAR, -- may be null
url VARCHAR
);
DELETE FROM offering;
ALTER TABLE offering DROP COLUMN subj_code;
ALTER TABLE offering DROP COLUMN subj_name;
ALTER TABLE offering DROP COLUMN url;
ALTER TABLE offering ADD COLUMN subject
INT4 REFERENCES subject (subjectid) NOT NULL;