-- 2.0.* to 2.1 ALTER TABLE mlf2_userdata ADD category_selection VARCHAR(255) NULL DEFAULT NULL AFTER registered; ALTER TABLE mlf2_entries_cache CHANGE cache_text cache_text MEDIUMTEXT NOT NULL; INSERT INTO mlf2_settings VALUES ('timezone', ''); INSERT INTO mlf2_settings VALUES ('bbcode_flash', '0'); INSERT INTO mlf2_settings VALUES ('flash_default_width', '425'); INSERT INTO mlf2_settings VALUES ('flash_default_height', '344'); INSERT INTO mlf2_settings VALUES ('cookie_validity_days', '30'); INSERT INTO mlf2_settings VALUES ('access_permission_checks', '1'); INSERT INTO mlf2_settings VALUES ('daily_actions_time', '3:30'); INSERT INTO mlf2_settings VALUES ('next_daily_actions', '0'); INSERT INTO mlf2_settings VALUES ('auto_lock_old_threads', '0'); UPDATE mlf2_settings SET value = '2.1' WHERE name = 'version';