Pux1a55c

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  `Gear` TEXT NOT NULL,
24  PRIMARY KEY (`ID`),
25  UNIQUE KEY `PID` (`PID`)
26) ENGINE = InnoDB DEFAULT CHARSET = utf8;
27
28-- --------------------------------------------------------
29
30--
31-- Table structure for table `HG_Vehicles`
32--
33
34CREATE TABLE IF NOT EXISTS `HG_Vehicles` (
35  `ID` MEDIUMINT NOT NULL AUTO_INCREMENT,
36  `PID` VARCHAR(50) NOT NULL,
37  `Classname` VARCHAR(32) NOT NULL,
38  `Plate` INT(100) NOT NULL,
39  `Alive` TINYINT NOT NULL DEFAULT 1,
40  `Active` TINYINT NOT NULL,
41  `Color` VARCHAR(32) NOT NULL,
42  `Inventory` TEXT NOT NULL,
43  PRIMARY KEY (`ID`),
44  KEY `PID` (`PID`),
45  KEY `Classname` (`Classname`),
46  KEY `Plate` (`Plate`)
47) ENGINE = InnoDB DEFAULT CHARSET = utf8;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `HG_Whitelist`
53
54CREATE TABLE IF NOT EXISTS `HG_Whitelist` (
55  `Civilian` TEXT NOT NULL,
56  `West` TEXT NOT NULL,
57  `Resistance` TEXT NOT NULL,
58  `East` TEXT NOT NULL
59) ENGINE = InnoDB DEFAULT CHARSET = utf8;
60
61INSERT INTO `HG_Whitelist` (
62  `Civilian`,
63  `West`,
64  `Resistance`,
65  `East`
66) VALUES ('[]','[]','[]','[]');
67
68-- --------------------------------------------------------
69
70/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
71/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
72/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;