[Gforge-commits] gforge/db 200403252.sql,NONE,1.1

[tperdue]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/home/tperdue/share/dev.gforge.org/db

Added Files:
        200403252.sql 
Log Message:
removing theme_prefs table and optimizing away two extra queries...

--- NEW FILE: 200403252.sql ---
ALTER TABLE users ADD COLUMN theme_id INT;
--ALTER TABLE users ALTER COLUMN theme_id SET DEFAULT NOT NULL 1;
--UPDATE users SET theme_id=1
--      WHERE NOT EXISTS (select user_theme FROM theme_prefs WHERE 
user_id=users.user_id);
UPDATE users SET theme_id=
        (select user_theme FROM theme_prefs WHERE user_id=users.user_id)
        WHERE EXISTS (select user_theme FROM theme_prefs WHERE 
user_id=users.user_id);
--
--      If there is no theme_id=1 in the themes table, we could have a problem
--
UPDATE users SET theme_id=(SELECT min(theme_id) FROM themes WHERE enabled=true 
LIMIT 1)
        WHERE theme_id IS NULL;
ALTER TABLE users ADD CONSTRAINT users_themeid
        FOREIGN KEY (theme_id) REFERENCES themes(theme_id) MATCH FULL;
ALTER TABLE users ADD CONSTRAINT users_ccode
        FOREIGN KEY (ccode) REFERENCES country_code(ccode) MATCH FULL;
DROP TABLE theme_prefs;