CREATE TABLE mantis_user_pref_table (
id int NOT NULL IDENTITY (1, 1),
user_id int NOT NULL default '0',
project_id int NOT NULL default '0',
default_profile int NOT NULL default '0',
default_project int NOT NULL default '0',
advanced_report tinyint NOT NULL default '0',
advanced_view tinyint NOT NULL default '0',
advanced_update tinyint NOT NULL default '0',
refresh_delay int NOT NULL default '0',
redirect_delay bit NOT NULL default '0',
bugnote_order varchar(4) NOT NULL default 'ASC',
email_on_new bit NOT NULL default '0',
email_on_assigned bit NOT NULL default '0',
email_on_feedback bit NOT NULL default '0',
email_on_resolved bit NOT NULL default '0',
email_on_closed bit NOT NULL default '0',
email_on_reopened bit NOT NULL default '0',
email_on_bugnote bit NOT NULL default '0',
email_on_status bit NOT NULL default '0',
email_on_priority bit NOT NULL default '0',
email_on_priority_minimum_severity int NOT NULL default '10',
email_on_status_minimum_severity int NOT NULL default '10',
email_on_bugnote_minimum_severity int NOT NULL default '10',
email_on_reopened_minimum_severity int NOT NULL default '10',
email_on_closed_minimum_severity int NOT NULL default '10',
email_on_resolved_minimum_severity int NOT NULL default '10',
email_on_feedback_minimum_severity int NOT NULL default '10',
email_on_assigned_minimum_severity int NOT NULL default '10',
email_on_new_minimum_severity int NOT NULL default '10',
email_bugnote_limit int NOT NULL default '0',
language varchar(32) NOT NULL default 'english',
PRIMARY KEY (id)
)

BUT : problem on adding new account : Syntax error converting the varchar value 'any' to a column of data type int.
For fields : email_onstatus...