ij71duUT

1DELIMITER ;
2
3-- --------------------------------------------------------
4
5--
6-- Table structure for table `players`
7--
8
9CREATE TABLE IF NOT EXISTS `players` (
10  `uid` int(6) NOT NULL AUTO_INCREMENT,
11  `name` varchar(32) NOT NULL,
12  `aliases` text NOT NULL,
13  `pid` varchar(17) NOT NULL,
14  `cash` int(100) NOT NULL DEFAULT '0',
15  `bankacc` int(100) NOT NULL DEFAULT '0',
16  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
17  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
18  `civ_licenses` text NOT NULL,
19  `cop_licenses` text NOT NULL,
20  `med_licenses` text NOT NULL,
21  `civ_gear` text NOT NULL,
22  `cop_gear` text NOT NULL,
23  `med_gear` text NOT NULL,
24  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
25  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
26  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
27  `arrested` tinyint(1) NOT NULL DEFAULT '0',
28  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
29  `donorlevel` [...]