alter table prefs add column showContacts char default '0';
alter table prefs add column showCC char default '1';
alter table prefs add column closeAfterSend char default '1';
alter table colors add column font_family varchar(255);
alter table colors add column font_size int(2) default '12';
alter table colors add column small_font_size int(2) default '10';
alter table colors add column menu_font_size int(2) default '12';
alter table colors add column main_head_bg varchar(15) default '#333377';
alter table colors add column main_head_txt varchar(15) default '#FFFFFF';
alter table contacts add column msn text;
alter table contacts add column yahoo text;
alter table contacts add column jabber text;
alter table prefs add column showNav char default '1';
alter table prefs add column folderlistWidth int(3) default '150';
alter table colors add column main_darkbg varchar(15) default '#5B5B79';
alter table colors add column main_light_txt varchar(15) default '#FFFFFF';
alter table prefs add column hideUnsubscribed char default '';
alter table prefs add column compose_inside char default '';
alter table prefs add column show_quota char default '';
alter table prefs add column showNumUnread char default '';
alter table prefs add column refresh_folderlist char default '';
alter table prefs add column folderlist_interval int(3) default '150';
alter table prefs add column radar_interval int(3) default '150';
alter table colors add column folderlist_font_size int(2) default '12';
alter table prefs add column theme varchar(128) default 'default';
alter table prefs add column main_toolbar varchar(3) default 'b';
alter table prefs add column alt_identities text;
CREATE TABLE identities(
	id int NOT NULL auto_increment,
    owner mediumint(9) NOT NULL,
	name varchar(128),
	email varchar(128),
	replyto varchar(128),
	sig text,
	PRIMARY KEY (id),
	KEY id (id),
	KEY owner (owner)
);


syntax highlighted by Code2HTML, v. 0.9.1