--- mantis-0.sql 2012-10-23 05:47:41.824642741 +0200 +++ mantis-1.sql 2012-10-23 05:59:24.236579980 +0200 @@ -300,7 +300,7 @@ advanced_view BOOLEAN DEFAULT '0' NOT NULL, advanced_update BOOLEAN DEFAULT '0' NOT NULL, refresh_delay INTEGER DEFAULT 0 NOT NULL, -redirect_delay BOOLEAN DEFAULT '0' NOT NULL, +redirect_delay INTEGER DEFAULT 0 NOT NULL, bugnote_order VARCHAR(4) DEFAULT 'ASC' NOT NULL, email_on_new BOOLEAN DEFAULT '0' NOT NULL, email_on_assigned BOOLEAN DEFAULT '0' NOT NULL, @@ -442,12 +442,6 @@ PRIMARY KEY (basename) ); -ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay TYPE INTEGER; - -ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay SET DEFAULT 0; - -ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay SET NOT NULL; - ALTER TABLE mantis_custom_field_table ALTER COLUMN possible_values TYPE TEXT; ALTER TABLE mantis_custom_field_table ALTER COLUMN possible_values SET DEFAULT '';