7SGE4vSn

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 utf8mb4 */;
8
9CREATE DATABASE IF NOT EXISTS `HG` DEFAULT CHARACTER SET utf8mb4 COLLATE; -- ! IMPORTANT ! --
10USE `gameserver4547`; -- ! 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 = utf8mb4;
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 = utf8mb4;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `HG_Whitelist`
53--
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 = utf8mb4;
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 */;