
#-----[ SQL ]------------------------------------------
# If you use a beta release of EasyMOD, this instructions will be executed!
# Please read author notes to update your database.
#
ALTER TABLE phpbb_themes ADD online_color varchar(6) NOT NULL;
ALTER TABLE phpbb_themes ADD offline_color varchar(6) NOT NULL;
ALTER TABLE phpbb_themes ADD hidden_color varchar(6) NOT NULL;
UPDATE phpbb_themes SET online_color = '008500' WHERE themes_id >= '1';
UPDATE phpbb_themes SET offline_color = 'DF0000' WHERE themes_id >= '1';
UPDATE phpbb_themes SET hidden_color = 'EBD400' WHERE themes_id >= '1';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('online_time', '60');