Mineplex/Mineplex.Database/050-statevents.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

14 lines
353 B
SQL

create or replace table statevents
(
eventId int unsigned not null,
accountId int unsigned not null,
date date not null,
gamemode tinyint unsigned not null,
serverGroup varchar(100) not null,
type tinyint unsigned not null,
value smallint unsigned not null,
primary key (eventId, accountId, date, gamemode, serverGroup, type)
)
charset=latin1;