-- 2.1.4 to 2.2
ALTER TABLE mlf2_userdata DROP time_difference;
ALTER TABLE mlf2_userdata ADD LANGUAGE VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE mlf2_userdata ADD time_zone VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE mlf2_userdata ADD time_difference smallint(4) DEFAULT '0';
ALTER TABLE mlf2_userdata ADD theme VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE mlf2_userdata ADD entries_read TEXT NOT NULL;
INSERT INTO mlf2_settings VALUES ('max_read_items', '200');
INSERT INTO mlf2_settings VALUES ('delete_ips', '0');
INSERT INTO mlf2_settings VALUES ('bbcode_tex', '0');
INSERT INTO mlf2_settings VALUES ('last_changes', '0');
INSERT INTO mlf2_settings VALUES ('ajax_preview', '1');
UPDATE mlf2_settings SET name = 'theme' WHERE name = 'template';
UPDATE mlf2_settings SET name = 'time_zone' WHERE name = 'timezone';
UPDATE mlf2_settings SET value = '0' WHERE name = 'time_difference';
UPDATE mlf2_settings SET value = '2.2' WHERE name = 'version';