60E7SvbA

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