C2XaWsq6

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               10.2.12-MariaDB-log - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             9.4.0.5125
6-- --------------------------------------------------------
7 
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13 
14 
15-- Dumping database structure for base
16CREATE DATABASE IF NOT EXISTS `base` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `base`;
18 
19-- Dumping structure for table base.characters
20CREATE TABLE IF NOT EXISTS `characters` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `steam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
23  `finishedSetup` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'false',
24  `charCurrent` int(1) DEFAULT 0,
25  `charOne` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
26  `charTwo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
27  `charThree` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
30 
31-- Data exporting was unselected.
32-- Dumping structure for table base.characters_inventory
33CREATE TABLE IF NOT EXISTS `characters_inventory` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `steam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
36  `charNumber` int(1) DEFAULT 1,
37  `inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40 
41-- Data exporting was unselected.
42-- Dumping structure for table base.characters_vehicles
43CREATE TABLE IF NOT EXISTS `characters_vehicles` (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `steam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
46  `charNumber` int(1) DEFAULT 1,
47  `vehicles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50 
51-- Data exporting was unselected.
52-- Dumping structure for table base.users
53CREATE TABLE IF NOT EXISTS `users` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `steam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
56  `license` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
57  `steamName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
58  `adminGroup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
61 
62-- Data exporting was unselected.
63/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
64/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;