Code:CREATE TABLE nuke_bbthemes (
themes_id mediumint(8) unsigned NOT NULL auto_increment,
template_name varchar(30) NOT NULL default '',
style_name varchar(30) NOT NULL default '',
head_stylesheet varchar(100) default NULL,
body_background varchar(100) default NULL,
body_bgcolor varchar(6) default NULL,
body_text varchar(6) default NULL,
body_link varchar(6) default NULL,
body_vlink varchar(6) default NULL,
body_alink varchar(6) default NULL,
body_hlink varchar(6) default NULL,
tr_color1 varchar(6) default NULL,
tr_color2 varchar(6) default NULL,
tr_color3 varchar(6) default NULL,
tr_class1 varchar(25) default NULL,
tr_class2 varchar(25) default NULL,
tr_class3 varchar(25) default NULL,
th_color1 varchar(6) default NULL,
th_color2 varchar(6) default NULL,
th_color3 varchar(6) default NULL,
th_class1 varchar(25) default NULL,
th_class2 varchar(25) default NULL,
th_class3 varchar(25) default NULL,
td_color1 varchar(6) default NULL,
td_color2 varchar(6) default NULL,
td_color3 varchar(6) default NULL,
td_class1 varchar(25) default NULL,
td_class2 varchar(25) default NULL,
td_class3 varchar(25) default NULL,
fontface1 varchar(50) default NULL,
fontface2 varchar(50) default NULL,
fontface3 varchar(50) default NULL,
fontsize1 tinyint(4) default NULL,
fontsize2 tinyint(4) default NULL,
fontsize3 tinyint(4) default NULL,
fontcolor1 varchar(6) default NULL,
fontcolor2 varchar(6) default NULL,
fontcolor3 varchar(6) default NULL,
span_class1 varchar(25) default NULL,
span_class2 varchar(25) default NULL,
span_class3 varchar(25) default NULL,
img_size_poll smallint(5) unsigned default NULL,
img_size_privmsg smallint(5) unsigned default NULL,
PRIMARY KEY (themes_id)
);
INSERT INTO nuke_bbthemes VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', '0E3259', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL);
CREATE TABLE nuke_bbthemes_name (
themes_id smallint(5) unsigned NOT NULL default '0',
tr_color1_name char(50) default NULL,
tr_color2_name char(50) default NULL,
tr_color3_name char(50) default NULL,
tr_class1_name char(50) default NULL,
tr_class2_name char(50) default NULL,
tr_class3_name char(50) default NULL,
th_color1_name char(50) default NULL,
th_color2_name char(50) default NULL,
th_color3_name char(50) default NULL,
th_class1_name char(50) default NULL,
th_class2_name char(50) default NULL,
th_class3_name char(50) default NULL,
td_color1_name char(50) default NULL,
td_color2_name char(50) default NULL,
td_color3_name char(50) default NULL,
td_class1_name char(50) default NULL,
td_class2_name char(50) default NULL,
td_class3_name char(50) default NULL,
fontface1_name char(50) default NULL,
fontface2_name char(50) default NULL,
fontface3_name char(50) default NULL,
fontsize1_name char(50) default NULL,
fontsize2_name char(50) default NULL,
fontsize3_name char(50) default NULL,
fontcolor1_name char(50) default NULL,
fontcolor2_name char(50) default NULL,
fontcolor3_name char(50) default NULL,
span_class1_name char(50) default NULL,
span_class2_name char(50) default NULL,
span_class3_name char(50) default NULL,
PRIMARY KEY (themes_id)
);
INSERT INTO nuke_bbthemes_name VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
|