ALTER TABLE `templates` ADD COLUMN `header_text_color` VARCHAR(7) NOT NULL DEFAULT '#333333' AFTER `header_bg_color`;
ALTER TABLE `templates` ADD COLUMN `header_link_color` VARCHAR(7) NOT NULL DEFAULT '#3498db' AFTER `header_text_color`;
ALTER TABLE `templates` ADD COLUMN `nav_bg_color` VARCHAR(7) NOT NULL DEFAULT '#2c3e50' AFTER `header_link_color`;
ALTER TABLE `templates` ADD COLUMN `nav_text_color` VARCHAR(7) NOT NULL DEFAULT '#ecf0f1' AFTER `nav_bg_color`;
ALTER TABLE `templates` ADD COLUMN `nav_hover_bg_color` VARCHAR(7) NOT NULL DEFAULT '#34495e' AFTER `nav_text_color`;

UPDATE `templates` 
SET 
    `header_text_color` = '#333333',
    `header_link_color` = '#3498db',
    `nav_bg_color` = '#2c3e50',
    `nav_text_color` = '#ecf0f1',
    `nav_hover_bg_color` = '#34495e'
WHERE 1=1;
