mysql db

[raymondvlieland]

kan iemand mij een phpbb themes dropout geven van de db heb hem per ongeluk verwijderd

[Bee]

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 ;

en daarna

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', '', '', '');