1 drop table theme_prefs;
4 -- Re-add themes table, which I hastily dropped in 3pre2
7 theme_id SERIAL UNIQUE,
8 dirname character varying(80),
9 fullname character varying(80)
12 CREATE TABLE theme_prefs (
13 user_id integer DEFAULT '0' NOT NULL,
14 user_theme integer DEFAULT '0' NOT NULL,
15 body_font character(80) DEFAULT '',
16 body_size character(5) DEFAULT '',
17 titlebar_font character(80) DEFAULT '',
18 titlebar_size character(5) DEFAULT '',
19 color_titlebar_back character(7) DEFAULT '',
20 color_ltback1 character(7) DEFAULT '',
23 CREATE INDEX themeprefs_userid ON theme_prefs(user_id);
25 --INSERT INTO themes (dirname, fullname) VALUES ('default', 'Default Theme');
26 --These themes have to be converted to new Layout.class.php
27 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_codex', 'Savannah CodeX');
28 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_forest', 'Savannah Forest');
29 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_reverse', 'Savannah Reverse');
30 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_sad', 'Savannah Sad');
31 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_savannah', 'Savannah Original');
32 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_slashd', 'Savannah SlashDot');
33 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_startrek', 'Savannah StarTrek');
34 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_transparent', 'Savannah Transparent');
35 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_water', 'Savannah Water');
36 --INSERT INTO themes (dirname, fullname) VALUES ('savannah_www.gnu.org', 'Savannah www.gnu.org');