Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Table structure for table `players`
- --
- CREATE TABLE IF NOT EXISTS `players` (
- `uid` int(12) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `playerid` varchar(50) NOT NULL,
- `cash` int(100) NOT NULL DEFAULT '0',
- `bankacc` int(100) NOT NULL DEFAULT '0',
- `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
- `cop_licenses` text,
- `civ_licenses` text,
- `med_licenses` text,
- `cop_gear` text NOT NULL,
- `med_gear` text NOT NULL,
- `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
- `arrested` tinyint(1) NOT NULL DEFAULT '0',
- `aliases` text NOT NULL,
- `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
- `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
- `civ_gear` text NOT NULL,
- `blacklist` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`uid`),
- UNIQUE KEY `playerid` (`playerid`),
- KEY `name` (`name`),
- KEY `blacklist` (`blacklist`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `vehicles`
- --
- CREATE TABLE IF NOT EXISTS `vehicles` (
- `id` int(12) NOT NULL AUTO_INCREMENT,
- `side` varchar(15) NOT NULL,
- `classname` varchar(32) NOT NULL,
- `type` varchar(12) NOT NULL,
- `pid` varchar(32) NOT NULL,
- `alive` tinyint(1) NOT NULL DEFAULT '1',
- `active` tinyint(1) NOT NULL DEFAULT '0',
- `plate` int(20) NOT NULL,
- `color` int(20) NOT NULL,
- `inventory` varchar(500) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `side` (`side`),
- KEY `pid` (`pid`),
- KEY `type` (`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `houses`
- -- Needed for extDB latest update on git
- --
- CREATE TABLE IF NOT EXISTS `houses` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `pid` varchar(32) NOT NULL,
- `pos` varchar(64) DEFAULT NULL,
- `inventory` text,
- `containers` text,
- `owned` tinyint(4) DEFAULT '0',
- PRIMARY KEY (`id`,`pid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `gangs`
- -- Needed for extDB latest update on git
- --
- CREATE TABLE IF NOT EXISTS `gangs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `owner` varchar(32) DEFAULT NULL,
- `name` varchar(32) DEFAULT NULL,
- `members` text,
- `maxmembers` int(2) DEFAULT '8',
- `bank` int(100) DEFAULT '0',
- `active` tinyint(4) DEFAULT '1',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name_UNIQUE` (`name`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement