Mineplex/Mineplex.Database/008-accountpreferences.sql
Daniel Waggner fc179e824b Database go brrrrrrr
No idea why, but the database deleted all of the information...  These files are also logged in the Discord Changelog channel and are uploaded to mediafire... Nevertheless, here they are anyhow (plus a bunch of empty tables that I'm too lazy to take out of this commit)
2021-05-28 22:22:21 -07:00

27 lines
933 B
SQL

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;