phpBB.nl

Code: Selecteer alles

CREATE TABLE `phpbb_themes` ( 
`themes_id` mediumint( 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`) 
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Code: Selecteer alles

INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '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', '', '', '');