sql installatie file
Geplaatst: 02 jan 2005, 13:57
ik heb de volgende sql aanpassingen die ik moet doen
Kan dit in een installatie file worden gezet, dus dat je alleen maar sql_update.php oid hoeft te runnen?
Code: Selecteer alles
ALTER TABLE `phpbb_themes` ADD `fontcolor4` varchar(6) default NULL;
ALTER TABLE `phpbb_themes` ADD `fontcolor5` varchar(6) default NULL;
ALTER TABLE `phpbb_themes` ADD `fontcolor98` varchar(6) default NULL;
ALTER TABLE `phpbb_themes` ADD `fontcolor99` varchar(6) default NULL;
ALTER TABLE `phpbb_themes_name` ADD `fontcolor4_name` char(50);
ALTER TABLE `phpbb_themes_name` ADD `fontcolor5_name` char(50);
ALTER TABLE `phpbb_themes_name` ADD `fontcolor98_name` char(50);
ALTER TABLE `phpbb_themes_name` ADD `fontcolor99_name` char(50);
UPDATE `phpbb_themes` SET `fontcolor4` = '0000FF' WHERE `themes_id` = '1' LIMIT 1;
UPDATE `phpbb_themes` SET `fontcolor5` = 'C675EC' WHERE `themes_id` = '1' LIMIT 1;
UPDATE `phpbb_themes` SET `fontcolor98` = 'FF0000' WHERE `themes_id` = '1' LIMIT 1;
UPDATE `phpbb_themes` SET `fontcolor99` = '000000' WHERE `themes_id` = '1' LIMIT 1;