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;

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