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;

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;

• Date formats
  We should really add support for different date formats. In my opinion the i18n isn't for real before it acknowledges that different countries have different ways of writing dates. For instance: in Finland, which is my home country, we write "April 20, 1989" as "20.04.1989". But at the moment fud2 does not seem to know this... Of course this applies also to the user control panel where the birth date setting has the fields in the wrong order.
  
• User profile
  The header defaults to a genitive with "'". This does not work in Swedish, where such a construction simply does not exist. A slight fault in the i18n.
  There is a second problem in the user profile as well. The gender seems to be hardcoded in English, as the setting was in Swedish during the registration but suddenly appears in English in the profile view.