create or replace table accountpreferences
(
	id int auto_increment,
	uuid varchar(256) not null,
	filterChat tinyint default 1 not null,
	invisibility tinyint default 0 not null,
	games tinyint default 1 not null,
	visibility tinyint default 1 not null,
	friendChat tinyint default 1 not null,
	privateMessaging tinyint default 1 not null,
	showChat tinyint default 1 not null,
	partyRequests tinyint default 1 not null,
	forcefield tinyint default 0 not null,
	showMacReports tinyint default 0 not null,
	ignoreVelocity tinyint default 0 not null,
	pendingFriendRequests tinyint default 1 not null,
	friendDisplayInventoryUI tinyint default 1 not null,
	friendDisplayOnlineStatus tinyint default 1 not null,
	friendDisplayServerName tinyint default 1 not null,
	friendAllowRequests tinyint default 1 not null,
	friendAllowMessaging tinyint default 1 not null,
	language varchar(45) null,
	primary key (id, uuid)
)
charset=latin1;