ALTER TABLE fud2_users ADD show_avatars ENUM('Y', 'N') NOT NULL DEFAULT 'Y';
ALTER TABLE fud_users CHANGE show_sigs show_sigs ENUM('Y', 'N') NOT NULL DEFAULT 'Y';
ALTER TABLE fud_users DROP show_tool_tips;
ALTER TABLE fud_users ADD u_last_post_id INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE fud_forum ADD index(last_post_id);
UPDATE fud_thread SET locked='Y' WHERE replyallowed='N';
ALTER TABLE fud_thread DROP fud_replyallowed;
ALTER TABLE fud_forum ADD message_threshold INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE fud_msg ADD offset_preview INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE fud_msg ADD length_preview INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE fud_msg ADD file_id_preview INT UNSIGNED NOT NULL DEFAULT 0;