9uX05k2h

1
2CREATE TABLE IF NOT EXISTS `players` (
3  `uid` int(12) NOT NULL AUTO_INCREMENT,
4  `name` varchar(32) NOT NULL,
5  `aliases` text NOT NULL,
6  `playerid` varchar(64) NOT NULL,
7  `cash` int(100) NOT NULL DEFAULT '0',
8  `bankacc` int(100) NOT NULL DEFAULT '0',
9  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
10  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
11  `civ_licenses` text NOT NULL,
12  `cop_licenses` text NOT NULL,
13  `med_licenses` text NOT NULL,
14  `civ_gear` text NOT NULL,
15  `cop_gear` text NOT NULL,
16  `med_gear` text NOT NULL,
17  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
18  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
19  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
20  `arrested` tinyint(1) NOT NULL DEFAULT '0',
21  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
22  `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
23  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
24  `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
25  `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
26  `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
27  `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
28  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
29  PRIMARY KEY (`uid`),
30  UNIQUE KEY `playerid` (`playerid`),
31  KEY `name` (`name`),
32  KEY `blacklist` (`blacklist`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;