20 lines
528 B
MySQL
20 lines
528 B
MySQL
|
create or replace table accounts
|
||
|
|
(
|
||
|
|
id int auto_increment,
|
||
|
|
uuid varchar(100) not null,
|
||
|
|
name varchar(40) not null,
|
||
|
|
gems int default 2500 null,
|
||
|
|
lastLogin timestamp default current_timestamp() not null,
|
||
|
|
totalPlayTime tinytext null,
|
||
|
|
gold int default 1000 not null,
|
||
|
|
coins int default 5000 null,
|
||
|
|
donorRank varchar(20) null,
|
||
|
|
`rank` varchar(20) default 'ALL' null,
|
||
|
|
rankPerm tinyint null,
|
||
|
|
rankExpire timestamp default current_timestamp() not null on update current_timestamp(),
|
||
|
|
constraint id
|
||
|
|
unique (id)
|
||
|
|
)
|
||
|
|
charset=latin1;
|
||
|
|
|