· 7 years ago · Jan 27, 2019, 02:32 AM
1CREATE TABLE IF NOT EXISTS "MYSQL_PLAYERS" (\
2 SQLID int(11) NOT NULL AUTO_INCREMENT,\
3 Username varchar(25) NOT NULL,\
4 Password varchar(129) NOT NULL,\
5 Email varchar(60) NOT NULL DEFAULT 'Nema',\
6 Admin mediumint(11) NOT NULL DEFAULT '0',\
7 Helper mediumint(11) NOT NULL DEFAULT '0',\
8 Kills mediumint(8) NOT NULL DEFAULT '0',\
9 Deaths mediumint(8) NOT NULL DEFAULT '0',\
10 Level mediumint(8) NOT NULL DEFAULT '0',\
11 Money int(11) NOT NULL DEFAULT '0',\
12 PosX float NOT NULL DEFAULT '0',\
13 PosY float NOT NULL DEFAULT '0',\
14 PosZ float NOT NULL DEFAULT '0',\
15 Angle float NOT NULL DEFAULT '0',\
16 Age mediumint(8) NOT NULL DEFAULT '0',\
17 Sex mediumint(8) NOT NULL DEFAULT '0',\
18 State mediumint(8) NOT NULL DEFAULT '0',\
19 Spawn mediumint(8) NOT NULL DEFAULT '0',\
20 Skin mediumint(8) NOT NULL DEFAULT '0',\
21 Tutorial mediumint(8) NOT NULL DEFAULT '0',\
22 ConnectTime mediumint(8) NOT NULL DEFAULT '0',\
23 Respects mediumint(8) NOT NULL DEFAULT '0',\
24 PayDayMin mediumint(8) NOT NULL DEFAULT '0',\
25 RegisterDate varchar(30) NOT NULL DEFAULT '00/00/0000',\
26 LastLogin varchar(30) NOT NULL DEFAULT '00/00/0000',\
27 BankMoney int(11) NOT NULL DEFAULT '0',\
28 StaffCode mediumint(8) NOT NULL DEFAULT '0',\
29 Jailed mediumint(8) NOT NULL DEFAULT '0',\
30 JailedTime mediumint(8) NOT NULL DEFAULT '0',\
31 Mute mediumint(8) NOT NULL DEFAULT '0',\
32 Warn mediumint(8) NOT NULL DEFAULT '0',\
33 Promoter mediumint(8) NOT NULL DEFAULT '0',\
34 Interior int(11) NOT NULL DEFAULT '0',\
35 VirtualWorld int(11) NOT NULL DEFAULT '0',\
36 PrisonReason varchar(32) NOT NULL DEFAULT 'Nema',\
37 Crashed mediumint(8) NOT NULL DEFAULT '0',\
38 PlayerClass mediumint(8) NOT NULL DEFAULT '0',\
39 Helmet mediumint(8) NOT NULL DEFAULT '0',\
40 PRIMARY KEY (SQLID), UNIQUE KEY Username (Username))