YH6xF7S5

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET TIME_ZONE = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9CREATE DATABASE IF NOT EXISTS `HG` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
10USE `HG`; -- ! IMPORTANT ! --
11
12--
13-- Table structure for table `HG_Players`
14--
15
16CREATE TABLE IF NOT EXISTS `HG_Players` (
17  `ID` MEDIUMINT NOT NULL AUTO_INCREMENT,
18  `PID` VARCHAR(32) NOT NULL,
19  `Money` INT(100) NOT NULL DEFAULT '0',
20  `Bank` INT(100) NOT NULL DEFAULT '0',
21  `XP` TEXT NOT NULL,
22  `Kills` INT(100) NOT NULL DEFAULT '0',
23  `copLevel` enum('0','1') NOT NULL DEFAULT '0',
24  `Gear` TEXT NOT NULL,
25  PRIMARY KEY (`ID`),
26  UNIQUE KEY `PID` (`PID`)
27) ENGINE = InnoDB DEFAULT CHARSET = utf8;
28
29-- --------------------------------------------------------
30
31--
32-- Table structure for table `HG_Vehicles`
33--
34
35CREATE TABLE IF NOT EXISTS `HG_Vehicles` (
36  `ID` MEDIUMINT NOT NULL AUTO_INCREMENT,
37  `PID` VARCHAR(50) NOT NULL,
38  `Classname` VARCHAR(32) NOT NULL,
39  `Plate` INT(100) NOT NULL,
40  `Alive` TINYINT NOT NULL DEFAULT 1,
41  `Active` TINYINT NOT NULL,
42  `Color` VARCHAR(32) NOT NULL,
43  `Inventory` TEXT NOT NULL,
44  PRIMARY KEY (`ID`),
45  KEY `PID` (`PID`),
46  KEY `Classname` (`Classname`),
47  KEY `Plate` (`Plate`)
48) ENGINE = InnoDB DEFAULT CHARSET = utf8;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `HG_Whitelist`
54
55CREATE TABLE IF NOT EXISTS `HG_Whitelist` (
56  `Civilian` TEXT NOT NULL,
57  `West` TEXT NOT NULL,
58  `Resistance` TEXT NOT NULL,
59  `East` TEXT NOT NULL
60) ENGINE = InnoDB DEFAULT CHARSET = utf8;
61
62INSERT INTO `HG_Whitelist` (
63  `Civilian`,
64  `West`,
65  `Resistance`,
66  `East`
67) VALUES ('[]','[]','[]','[]');
68
69-- --------------------------------------------------------
70
71/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
72/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
73/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;