-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.6-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.0.0.5934
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping database structure for essentialmode
CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `essentialmode`;

-- Dumping structure for table essentialmode.addon_account
CREATE TABLE IF NOT EXISTS `addon_account` (
  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `shared` int(11) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.addon_account: ~0 rows (approximately)
DELETE FROM `addon_account`;
/*!40000 ALTER TABLE `addon_account` DISABLE KEYS */;
INSERT INTO `addon_account` (`name`, `label`, `shared`) VALUES
	('vault_black_money', 'Money Vault', 0);
/*!40000 ALTER TABLE `addon_account` ENABLE KEYS */;

-- Dumping structure for table essentialmode.addon_account_data
CREATE TABLE IF NOT EXISTS `addon_account_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `money` int(11) NOT NULL,
  `owner` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_addon_account_data_account_name_owner` (`account_name`,`owner`),
  KEY `index_addon_account_data_account_name` (`account_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.addon_account_data: ~1 rows (approximately)
DELETE FROM `addon_account_data`;
/*!40000 ALTER TABLE `addon_account_data` DISABLE KEYS */;
INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
	(1, 'vault_black_money', 0, 'steam:1100001158ffdf5'),
	(2, 'vault_black_money', 0, 'steam:110000108968cbd');
/*!40000 ALTER TABLE `addon_account_data` ENABLE KEYS */;

-- Dumping structure for table essentialmode.addon_inventory
CREATE TABLE IF NOT EXISTS `addon_inventory` (
  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `shared` int(11) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.addon_inventory: ~0 rows (approximately)
DELETE FROM `addon_inventory`;
/*!40000 ALTER TABLE `addon_inventory` DISABLE KEYS */;
INSERT INTO `addon_inventory` (`name`, `label`, `shared`) VALUES
	('vault', 'Vault', 0);
/*!40000 ALTER TABLE `addon_inventory` ENABLE KEYS */;

-- Dumping structure for table essentialmode.addon_inventory_items
CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inventory_name` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `count` int(11) NOT NULL,
  `owner` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_addon_inventory_items_inventory_name_name` (`inventory_name`,`name`),
  KEY `index_addon_inventory_items_inventory_name_name_owner` (`inventory_name`,`name`,`owner`),
  KEY `index_addon_inventory_inventory_name` (`inventory_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.addon_inventory_items: ~4 rows (approximately)
DELETE FROM `addon_inventory_items`;
/*!40000 ALTER TABLE `addon_inventory_items` DISABLE KEYS */;
INSERT INTO `addon_inventory_items` (`id`, `inventory_name`, `name`, `count`, `owner`) VALUES
	(1, 'vault', 'zr380', 1, 'steam:110000108968cbd'),
	(2, 'vault', 'impaler4', 1, 'steam:110000108968cbd'),
	(3, 'vault', 'cerberus3', 1, 'steam:110000108968cbd'),
	(4, 'vault', 'monster5', 0, 'steam:110000108968cbd');
/*!40000 ALTER TABLE `addon_inventory_items` ENABLE KEYS */;

-- Dumping structure for table essentialmode.datastore
CREATE TABLE IF NOT EXISTS `datastore` (
  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `shared` int(11) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.datastore: ~5 rows (approximately)
DELETE FROM `datastore`;
/*!40000 ALTER TABLE `datastore` DISABLE KEYS */;
INSERT INTO `datastore` (`name`, `label`, `shared`) VALUES
	('user_ears', 'Ears', 0),
	('user_glasses', 'Glasses', 0),
	('user_helmet', 'Helmet', 0),
	('user_mask', 'Mask', 0),
	('vault', 'Vault', 0);
/*!40000 ALTER TABLE `datastore` ENABLE KEYS */;

-- Dumping structure for table essentialmode.datastore_data
CREATE TABLE IF NOT EXISTS `datastore_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
  `owner` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_datastore_data_name_owner` (`name`,`owner`),
  KEY `index_datastore_data_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.datastore_data: ~10 rows (approximately)
DELETE FROM `datastore_data`;
/*!40000 ALTER TABLE `datastore_data` DISABLE KEYS */;
INSERT INTO `datastore_data` (`id`, `name`, `owner`, `data`) VALUES
	(1, 'user_ears', 'steam:1100001158ffdf5', '{}'),
	(2, 'vault', 'steam:1100001158ffdf5', '{}'),
	(3, 'user_mask', 'steam:1100001158ffdf5', '{}'),
	(4, 'user_helmet', 'steam:1100001158ffdf5', '{}'),
	(5, 'user_glasses', 'steam:1100001158ffdf5', '{}'),
	(6, 'user_ears', 'steam:110000108968cbd', '{}'),
	(7, 'user_glasses', 'steam:110000108968cbd', '{}'),
	(8, 'user_helmet', 'steam:110000108968cbd', '{}'),
	(9, 'vault', 'steam:110000108968cbd', '{}'),
	(10, 'user_mask', 'steam:110000108968cbd', '{"skin":{"mask_2":0,"mask_1":2},"hasMask":true}');
/*!40000 ALTER TABLE `datastore_data` ENABLE KEYS */;

-- Dumping structure for table essentialmode.items
CREATE TABLE IF NOT EXISTS `items` (
  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `weight` int(11) NOT NULL DEFAULT 1,
  `limit` int(10) NOT NULL DEFAULT 0,
  `rare` tinyint(1) NOT NULL DEFAULT 0,
  `can_remove` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.items: ~56 rows (approximately)
DELETE FROM `items`;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` (`name`, `label`, `weight`, `limit`, `rare`, `can_remove`) VALUES
	('bandage', 'Bandage', 2, 0, 0, 1),
	('bandage2', 'Bandage 2', 2, 0, 0, 1),
	('binoculars', 'Binoculars', 1, 0, 0, 1),
	('boxflare', 'Ammo Box Flare', 1, 0, 0, 1),
	('boxmg', 'Ammo Box MG', 1, 0, 0, 1),
	('boxpistol', 'Ammo Box Pistol', 1, 0, 0, 1),
	('boxrifle', 'Ammo Box Rifle', 1, 0, 0, 1),
	('boxshot', 'Ammo Box Shotgun', 1, 0, 0, 1),
	('boxsmg', 'Ammo Box SMG', 1, 0, 0, 1),
	('boxsniper', 'Ammo Box Sniper', 1, 0, 0, 1),
	('bruiser', 'bruiser', 3, 0, 0, 1),
	('bruiser2', 'bruiser2', 3, 0, 0, 1),
	('bruiser3', 'bruiser3', 3, 0, 0, 1),
	('brutus', 'brutus', 3, 0, 0, 1),
	('brutus2', 'brutus2', 3, 0, 0, 1),
	('brutus3', 'brutus3', 3, 0, 0, 1),
	('bulletproof', 'Bullet-Proof Vest', 1, 0, 0, 1),
	('cannabis', 'Cannabis', 3, 0, 0, 1),
	('cerberus', 'cerberus', 5, 0, 0, 1),
	('cerberus2', 'cerberus2', 5, 0, 0, 1),
	('cerberus3', 'cerberus3', 5, 0, 0, 1),
	('deathbike', 'deathbike', 2, 0, 0, 1),
	('deathbike2', 'deathbike2', 2, 0, 0, 1),
	('deathbike3', 'deathbike3', 2, 0, 0, 1),
	('deviant', 'deviant', 4, 0, 0, 1),
	('dominator4', 'dominator4', 4, 0, 0, 1),
	('dominator5', 'dominator5', 4, 0, 0, 1),
	('dominator6', 'dominator6', 4, 0, 0, 1),
	('impaler', 'impaler', 3, 0, 0, 1),
	('impaler2', 'impaler2', 3, 0, 0, 1),
	('impaler3', 'impaler3', 3, 0, 0, 1),
	('impaler4', 'impaler4', 3, 0, 0, 1),
	('imperator', 'imperator', 3, 0, 0, 1),
	('imperator2', 'imperator2', 3, 0, 0, 1),
	('imperator3', 'imperator3', 3, 0, 0, 1),
	('issi4', 'issi4', 3, 0, 0, 1),
	('issi5', 'issi5', 3, 0, 0, 1),
	('issi6', 'issi6', 3, 0, 0, 1),
	('marijuana', 'Marijuana', 2, 0, 0, 1),
	('medikit', 'Medikit', 2, 0, 0, 1),
	('monster3', 'monster3', 5, 0, 0, 1),
	('monster4', 'monster4', 5, 0, 0, 1),
	('monster5', 'monster5', 5, 0, 0, 1),
	('oxygenmask', 'Oxygen Mask', 1, 0, 0, 1),
	('repairkit', 'Repair Kit', 1, 0, 0, 1),
	('scarab', 'scarab', 5, 0, 0, 1),
	('scarab2', 'scarab2', 5, 0, 0, 1),
	('scarab3', 'scarab3', 5, 0, 0, 1),
	('slamvan4', 'slamvan4', 4, 0, 0, 1),
	('slamvan5', 'slamvan5', 4, 0, 0, 1),
	('slamvan6', 'slamvan6', 4, 0, 0, 1),
	('tulip', 'tulip', 3, 0, 0, 1),
	('vamos', 'vamos', 3, 0, 0, 1),
	('zr380', 'zr380', 3, 0, 0, 1),
	('zr3802', 'zr3802', 3, 0, 0, 1),
	('zr3803', 'zr3803', 3, 0, 0, 1);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;

-- Dumping structure for table essentialmode.jobs
CREATE TABLE IF NOT EXISTS `jobs` (
  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.jobs: ~0 rows (approximately)
DELETE FROM `jobs`;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` (`name`, `label`) VALUES
	('unemployed', 'Unemployed');
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;

-- Dumping structure for table essentialmode.job_grades
CREATE TABLE IF NOT EXISTS `job_grades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `grade` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `label` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `salary` int(11) NOT NULL,
  `skin_male` longtext COLLATE utf8mb4_bin NOT NULL,
  `skin_female` longtext COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.job_grades: ~0 rows (approximately)
DELETE FROM `job_grades`;
/*!40000 ALTER TABLE `job_grades` DISABLE KEYS */;
INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
	(1, 'unemployed', 0, 'unemployed', 'Unemployed', 0, '{}', '{}');
/*!40000 ALTER TABLE `job_grades` ENABLE KEYS */;

-- Dumping structure for table essentialmode.phone_app_chat
CREATE TABLE IF NOT EXISTS `phone_app_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(20) NOT NULL,
  `message` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- Dumping data for table essentialmode.phone_app_chat: ~0 rows (approximately)
DELETE FROM `phone_app_chat`;
/*!40000 ALTER TABLE `phone_app_chat` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_app_chat` ENABLE KEYS */;

-- Dumping structure for table essentialmode.phone_calls
CREATE TABLE IF NOT EXISTS `phone_calls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(10) NOT NULL COMMENT 'Name',
  `num` varchar(10) NOT NULL COMMENT 'Phone Number',
  `incoming` int(11) NOT NULL COMMENT 'Define Incoming Call',
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `accepts` int(11) NOT NULL COMMENT 'Accept Call',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;

-- Dumping data for table essentialmode.phone_calls: ~0 rows (approximately)
DELETE FROM `phone_calls`;
/*!40000 ALTER TABLE `phone_calls` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_calls` ENABLE KEYS */;

-- Dumping structure for table essentialmode.phone_messages
CREATE TABLE IF NOT EXISTS `phone_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transmitter` varchar(10) NOT NULL,
  `receiver` varchar(10) NOT NULL,
  `message` varchar(255) NOT NULL DEFAULT '0',
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `isRead` int(11) NOT NULL DEFAULT 0,
  `owner` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;

-- Dumping data for table essentialmode.phone_messages: 0 rows
DELETE FROM `phone_messages`;
/*!40000 ALTER TABLE `phone_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_messages` ENABLE KEYS */;

-- Dumping structure for table essentialmode.phone_users_contacts
CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
  `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table essentialmode.phone_users_contacts: 0 rows
DELETE FROM `phone_users_contacts`;
/*!40000 ALTER TABLE `phone_users_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_users_contacts` ENABLE KEYS */;

-- Dumping structure for table essentialmode.shops
CREATE TABLE IF NOT EXISTS `shops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `item` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.shops: ~36 rows (approximately)
DELETE FROM `shops`;
/*!40000 ALTER TABLE `shops` DISABLE KEYS */;
INSERT INTO `shops` (`id`, `store`, `item`, `price`) VALUES
	(1, 'TwentyFourSeven', 'bruiser', 4000),
	(2, 'TwentyFourSeven', 'bruiser2', 6500),
	(3, 'TwentyFourSeven', 'bruiser3', 5000),
	(4, 'TwentyFourSeven', 'brutus', 5000),
	(5, 'TwentyFourSeven', 'brutus2', 7500),
	(6, 'TwentyFourSeven', 'brutus3', 5000),
	(7, 'TwentyFourSeven', 'deathbike', 2000),
	(8, 'TwentyFourSeven', 'deathbike2', 2000),
	(9, 'TwentyFourSeven', 'deathbike3', 2000),
	(10, 'TwentyFourSeven', 'deviant', 8000),
	(11, 'TwentyFourSeven', 'impaler', 10000),
	(12, 'TwentyFourSeven', 'impaler2', 12000),
	(13, 'TwentyFourSeven', 'impaler3', 15000),
	(14, 'TwentyFourSeven', 'impaler4', 10000),
	(15, 'TwentyFourSeven', 'imperator', 9000),
	(16, 'TwentyFourSeven', 'imperator2', 8500),
	(17, 'TwentyFourSeven', 'imperator3', 10000),
	(18, 'TwentyFourSeven', 'issi4', 15000),
	(19, 'TwentyFourSeven', 'issi5', 15000),
	(20, 'TwentyFourSeven', 'issi6', 15000),
	(21, 'TwentyFourSeven', 'monster3', 20000),
	(22, 'TwentyFourSeven', 'monster4', 19000),
	(23, 'TwentyFourSeven', 'monster5', 20000),
	(24, 'TwentyFourSeven', 'slamvan4', 6000),
	(25, 'TwentyFourSeven', 'slamvan5', 9000),
	(26, 'TwentyFourSeven', 'slamvan6', 5000),
	(27, 'TwentyFourSeven', 'tulip', 19000),
	(28, 'TwentyFourSeven', 'vamos', 20000),
	(29, 'TwentyFourSeven', 'binoculars', 100),
	(30, 'TwentyFourSeven', 'boxpistol', 1400),
	(31, 'TwentyFourSeven', 'boxsmg', 2500),
	(32, 'TwentyFourSeven', 'boxshot', 900),
	(33, 'TwentyFourSeven', 'boxrifle', 10000),
	(34, 'TwentyFourSeven', 'boxflare', 100),
	(35, 'TwentyFourSeven', 'oxygenmask', 1500),
	(36, 'TwentyFourSeven', 'repairkit', 1500);
/*!40000 ALTER TABLE `shops` ENABLE KEYS */;

-- Dumping structure for table essentialmode.shops2
CREATE TABLE IF NOT EXISTS `shops2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store` varchar(100) NOT NULL,
  `item` varchar(100) NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table essentialmode.shops2: ~15 rows (approximately)
DELETE FROM `shops2`;
/*!40000 ALTER TABLE `shops2` DISABLE KEYS */;
INSERT INTO `shops2` (`id`, `store`, `item`, `price`) VALUES
	(1, 'TwentyFourSeven2', 'zr380', 10000),
	(2, 'TwentyFourSeven2', 'zr3802', 15000),
	(3, 'TwentyFourSeven2', 'zr3803', 15000),
	(4, 'TwentyFourSeven2', 'dominator4', 15000),
	(5, 'TwentyFourSeven2', 'dominator5', 20000),
	(6, 'TwentyFourSeven2', 'dominator6', 19000),
	(7, 'TwentyFourSeven2', 'cerberus', 20000),
	(8, 'TwentyFourSeven2', 'cerberus2', 20000),
	(9, 'TwentyFourSeven2', 'cerberus3', 19000),
	(10, 'TwentyFourSeven2', 'scarab', 100000),
	(11, 'TwentyFourSeven2', 'scarab2', 100000),
	(12, 'TwentyFourSeven2', 'scarab3', 100000),
	(13, 'TwentyFourSeven2', 'boxsniper', 15000),
	(14, 'TwentyFourSeven2', 'bulletproof', 20000),
	(15, 'TwentyFourSeven2', 'boxmg', 10000);
/*!40000 ALTER TABLE `shops2` ENABLE KEYS */;

-- Dumping structure for table essentialmode.users
CREATE TABLE IF NOT EXISTS `users` (
  `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
  `skin` longtext COLLATE utf8mb4_bin DEFAULT NULL,
  `job` varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
  `job_grade` int(11) DEFAULT 0,
  `loadout` longtext COLLATE utf8mb4_bin DEFAULT NULL,
  `position` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `bank` int(11) DEFAULT NULL,
  `permission_level` int(11) DEFAULT NULL,
  `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `is_dead` tinyint(1) DEFAULT 0,
  `phone_number` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `rp_xp` int(11) NOT NULL DEFAULT 0,
  `rp_rank` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.users: ~1 rows (approximately)
DELETE FROM `users`;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `loadout`, `position`, `bank`, `permission_level`, `group`, `is_dead`, `phone_number`, `rp_xp`, `rp_rank`) VALUES
	('steam:110000108968cbd', 'license:6cb33edfcd4f47beda45d85d71b28d3b72045dea', 1289, 'RIB', '{"pants_1":0,"blush_1":0,"hair_color_1":0,"eyebrows_4":0,"glasses_1":-1,"beard_1":0,"lipstick_3":0,"glasses_2":0,"makeup_4":0,"bags_1":0,"age_2":0,"beard_4":0,"bodyb_2":0,"bracelets_1":-1,"moles_1":0,"bracelets_2":0,"ears_1":-1,"torso_2":0,"bproof_1":0,"mask_1":0,"beard_2":0,"tshirt_2":0,"torso_1":0,"beard_3":0,"bodyb_1":0,"bproof_2":0,"pants_2":0,"tshirt_1":0,"blush_2":0,"shoes_2":0,"decals_2":0,"lipstick_4":0,"watches_1":-1,"hair_color_2":0,"blemishes_1":0,"sun_1":0,"skin":0,"eyebrows_3":0,"eyebrows_2":0,"complexion_2":0,"arms_2":0,"age_1":0,"hair_1":0,"decals_1":0,"eyebrows_1":0,"shoes_1":0,"chest_1":0,"chest_3":0,"makeup_1":0,"complexion_1":0,"lipstick_2":0,"makeup_2":0,"blush_3":0,"ears_2":0,"arms":0,"moles_2":0,"chest_2":0,"chain_1":0,"lipstick_1":0,"watches_2":0,"makeup_3":0,"sex":0,"bags_2":0,"helmet_1":-1,"mask_2":0,"face":0,"chain_2":0,"helmet_2":0,"sun_2":0,"blemishes_2":0,"hair_2":0}', 'unemployed', 0, '[{"ammo":0,"name":"WEAPON_NIGHTSTICK","label":"Nightstick","components":[]},{"ammo":42,"name":"WEAPON_STUNGUN","label":"Taser","components":[]}]', '{"z":28.8,"y":-1017.4,"x":434.2}', 0, 100, 'superadmin', 0, '507-9013', 1400, 2),
	('steam:1100001158ffdf5', 'license:7dfbdd63c794671c32834bd33929c77da6445e8a', 2876, 'Dave ????', '{"bags_2":0,"moles_2":0,"decals_2":0,"shoes_2":0,"blemishes_2":0,"bodyb_1":0,"bodyb_2":0,"watches_2":0,"blush_3":0,"sun_2":0,"bproof_1":0,"tshirt_1":0,"eyebrows_3":0,"hair_1":0,"torso_2":0,"eyebrows_1":0,"arms":0,"chest_2":0,"arms_2":0,"beard_2":0,"hair_color_1":0,"sex":64,"bproof_2":0,"beard_4":0,"shoes_1":0,"lipstick_2":0,"decals_1":0,"makeup_4":0,"hair_color_2":0,"tshirt_2":0,"lipstick_1":0,"chest_1":0,"blush_1":0,"eyebrows_2":0,"watches_1":-1,"moles_1":0,"glasses_2":0,"bracelets_1":-1,"beard_3":0,"bags_1":0,"complexion_2":0,"complexion_1":0,"chain_1":0,"chain_2":0,"helmet_1":-1,"ears_2":0,"skin":0,"torso_1":0,"age_1":0,"makeup_2":0,"lipstick_3":0,"beard_1":0,"helmet_2":0,"pants_2":0,"glasses_1":-1,"face":0,"pants_1":0,"sun_1":0,"blemishes_1":0,"makeup_3":0,"bracelets_2":0,"eyebrows_4":0,"mask_2":0,"age_2":0,"mask_1":0,"chest_3":0,"lipstick_4":0,"makeup_1":0,"ears_1":-1,"blush_2":0,"hair_2":0}', 'unemployed', 0, '[{"name":"WEAPON_PISTOL","label":"Pistol","components":["clip_default"],"ammo":54}]', '{"x":441.2,"z":30.7,"y":-987.6}', 0, 0, 'user', 0, '615-5767', 8350, 5);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

-- Dumping structure for table essentialmode.user_accounts
CREATE TABLE IF NOT EXISTS `user_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(22) COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `money` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.user_accounts: ~0 rows (approximately)
DELETE FROM `user_accounts`;
/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;
INSERT INTO `user_accounts` (`id`, `identifier`, `name`, `money`) VALUES
	(1, 'steam:1100001158ffdf5', 'black_money', 0);
/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;

-- Dumping structure for table essentialmode.user_inventory
CREATE TABLE IF NOT EXISTS `user_inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(22) COLLATE utf8mb4_bin NOT NULL,
  `item` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.user_inventory: ~112 rows (approximately)
DELETE FROM `user_inventory`;
/*!40000 ALTER TABLE `user_inventory` DISABLE KEYS */;
INSERT INTO `user_inventory` (`id`, `identifier`, `item`, `count`) VALUES
	(1, 'steam:1100001158ffdf5', 'bandage', 0),
	(2, 'steam:1100001158ffdf5', 'bruiser3', 0),
	(3, 'steam:1100001158ffdf5', 'imperator', 0),
	(4, 'steam:1100001158ffdf5', 'dominator4', 0),
	(5, 'steam:1100001158ffdf5', 'deviant', 0),
	(6, 'steam:1100001158ffdf5', 'impaler', 0),
	(7, 'steam:1100001158ffdf5', 'scarab2', 0),
	(8, 'steam:1100001158ffdf5', 'cerberus2', 0),
	(9, 'steam:1100001158ffdf5', 'impaler4', 0),
	(10, 'steam:1100001158ffdf5', 'issi6', 0),
	(11, 'steam:1100001158ffdf5', 'imperator2', 0),
	(12, 'steam:1100001158ffdf5', 'imperator3', 0),
	(13, 'steam:1100001158ffdf5', 'monster4', 0),
	(14, 'steam:1100001158ffdf5', 'impaler2', 0),
	(15, 'steam:1100001158ffdf5', 'deathbike2', 0),
	(16, 'steam:1100001158ffdf5', 'monster3', 0),
	(17, 'steam:1100001158ffdf5', 'medikit', 0),
	(18, 'steam:1100001158ffdf5', 'bandage2', 0),
	(19, 'steam:1100001158ffdf5', 'zr380', 0),
	(20, 'steam:1100001158ffdf5', 'dominator5', 0),
	(21, 'steam:1100001158ffdf5', 'issi5', 0),
	(22, 'steam:1100001158ffdf5', 'slamvan6', 0),
	(23, 'steam:1100001158ffdf5', 'issi4', 0),
	(24, 'steam:1100001158ffdf5', 'cannabis', 0),
	(25, 'steam:1100001158ffdf5', 'slamvan4', 1),
	(26, 'steam:1100001158ffdf5', 'zr3803', 0),
	(27, 'steam:1100001158ffdf5', 'zr3802', 0),
	(28, 'steam:1100001158ffdf5', 'tulip', 0),
	(29, 'steam:1100001158ffdf5', 'vamos', 0),
	(30, 'steam:1100001158ffdf5', 'slamvan5', 0),
	(31, 'steam:1100001158ffdf5', 'brutus2', 0),
	(32, 'steam:1100001158ffdf5', 'dominator6', 0),
	(33, 'steam:1100001158ffdf5', 'scarab3', 0),
	(34, 'steam:1100001158ffdf5', 'bruiser', 0),
	(35, 'steam:1100001158ffdf5', 'brutus', 0),
	(36, 'steam:1100001158ffdf5', 'monster5', 0),
	(37, 'steam:1100001158ffdf5', 'brutus3', 0),
	(38, 'steam:1100001158ffdf5', 'marijuana', 0),
	(39, 'steam:1100001158ffdf5', 'cerberus', 0),
	(40, 'steam:1100001158ffdf5', 'impaler3', 0),
	(41, 'steam:1100001158ffdf5', 'deathbike3', 0),
	(42, 'steam:1100001158ffdf5', 'scarab', 0),
	(43, 'steam:1100001158ffdf5', 'bruiser2', 0),
	(44, 'steam:1100001158ffdf5', 'deathbike', 0),
	(45, 'steam:1100001158ffdf5', 'cerberus3', 0),
	(46, 'steam:1100001158ffdf5', 'oxygenmask', 0),
	(47, 'steam:1100001158ffdf5', 'binoculars', 1),
	(48, 'steam:1100001158ffdf5', 'boxsmg', 0),
	(49, 'steam:1100001158ffdf5', 'boxpistol', 0),
	(50, 'steam:1100001158ffdf5', 'boxrifle', 0),
	(51, 'steam:1100001158ffdf5', 'repairkit', 0),
	(52, 'steam:1100001158ffdf5', 'boxflare', 0),
	(53, 'steam:1100001158ffdf5', 'bulletproof', 0),
	(54, 'steam:1100001158ffdf5', 'boxmg', 0),
	(55, 'steam:1100001158ffdf5', 'boxshot', 0),
	(56, 'steam:1100001158ffdf5', 'boxsniper', 0),
	(57, 'steam:110000108968cbd', 'cerberus3', 0),
	(58, 'steam:110000108968cbd', 'boxsniper', 0),
	(59, 'steam:110000108968cbd', 'medikit', 0),
	(60, 'steam:110000108968cbd', 'dominator6', 0),
	(61, 'steam:110000108968cbd', 'cannabis', 0),
	(62, 'steam:110000108968cbd', 'repairkit', 0),
	(63, 'steam:110000108968cbd', 'vamos', 0),
	(64, 'steam:110000108968cbd', 'dominator5', 0),
	(65, 'steam:110000108968cbd', 'zr380', 0),
	(66, 'steam:110000108968cbd', 'deathbike', 0),
	(67, 'steam:110000108968cbd', 'imperator2', 0),
	(68, 'steam:110000108968cbd', 'boxrifle', 0),
	(69, 'steam:110000108968cbd', 'slamvan5', 0),
	(70, 'steam:110000108968cbd', 'slamvan6', 0),
	(71, 'steam:110000108968cbd', 'impaler4', 0),
	(72, 'steam:110000108968cbd', 'binoculars', 0),
	(73, 'steam:110000108968cbd', 'slamvan4', 0),
	(74, 'steam:110000108968cbd', 'brutus3', 0),
	(75, 'steam:110000108968cbd', 'monster3', 0),
	(76, 'steam:110000108968cbd', 'impaler3', 0),
	(77, 'steam:110000108968cbd', 'bulletproof', 0),
	(78, 'steam:110000108968cbd', 'monster5', 1),
	(79, 'steam:110000108968cbd', 'scarab2', 0),
	(80, 'steam:110000108968cbd', 'dominator4', 0),
	(81, 'steam:110000108968cbd', 'boxpistol', 0),
	(82, 'steam:110000108968cbd', 'boxsmg', 0),
	(83, 'steam:110000108968cbd', 'deathbike3', 0),
	(84, 'steam:110000108968cbd', 'deathbike2', 0),
	(85, 'steam:110000108968cbd', 'zr3802', 0),
	(86, 'steam:110000108968cbd', 'bruiser3', 0),
	(87, 'steam:110000108968cbd', 'oxygenmask', 0),
	(88, 'steam:110000108968cbd', 'bruiser2', 0),
	(89, 'steam:110000108968cbd', 'impaler', 0),
	(90, 'steam:110000108968cbd', 'boxflare', 0),
	(91, 'steam:110000108968cbd', 'scarab3', 0),
	(92, 'steam:110000108968cbd', 'bandage2', 0),
	(93, 'steam:110000108968cbd', 'imperator3', 0),
	(94, 'steam:110000108968cbd', 'marijuana', 0),
	(95, 'steam:110000108968cbd', 'bruiser', 0),
	(96, 'steam:110000108968cbd', 'issi6', 0),
	(97, 'steam:110000108968cbd', 'issi5', 0),
	(98, 'steam:110000108968cbd', 'issi4', 0),
	(99, 'steam:110000108968cbd', 'monster4', 0),
	(100, 'steam:110000108968cbd', 'tulip', 0),
	(101, 'steam:110000108968cbd', 'imperator', 0),
	(102, 'steam:110000108968cbd', 'brutus', 0),
	(103, 'steam:110000108968cbd', 'boxmg', 0),
	(104, 'steam:110000108968cbd', 'zr3803', 0),
	(105, 'steam:110000108968cbd', 'boxshot', 0),
	(106, 'steam:110000108968cbd', 'impaler2', 0),
	(107, 'steam:110000108968cbd', 'cerberus', 0),
	(108, 'steam:110000108968cbd', 'bandage', 0),
	(109, 'steam:110000108968cbd', 'brutus2', 0),
	(110, 'steam:110000108968cbd', 'scarab', 0),
	(111, 'steam:110000108968cbd', 'deviant', 0),
	(112, 'steam:110000108968cbd', 'cerberus2', 0);
/*!40000 ALTER TABLE `user_inventory` ENABLE KEYS */;

-- Dumping structure for table essentialmode.weashops
CREATE TABLE IF NOT EXISTS `weashops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zone` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `item` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table essentialmode.weashops: ~17 rows (approximately)
DELETE FROM `weashops`;
/*!40000 ALTER TABLE `weashops` DISABLE KEYS */;
INSERT INTO `weashops` (`id`, `zone`, `item`, `price`) VALUES
	(1, 'GunShop', 'WEAPON_PISTOL', 300),
	(3, 'GunShop', 'WEAPON_FLASHLIGHT', 60),
	(5, 'GunShop', 'WEAPON_MACHETE', 90),
	(7, 'GunShop', 'WEAPON_NIGHTSTICK', 150),
	(9, 'GunShop', 'WEAPON_BAT', 100),
	(11, 'GunShop', 'WEAPON_STUNGUN', 50),
	(13, 'GunShop', 'WEAPON_MICROSMG', 1400),
	(15, 'GunShop', 'WEAPON_PUMPSHOTGUN', 3400),
	(17, 'GunShop', 'WEAPON_ASSAULTRIFLE', 10000),
	(19, 'GunShop', 'WEAPON_SPECIALCARBINE', 15000),
	(21, 'GunShop', 'WEAPON_SNIPERRIFLE', 22000),
	(23, 'GunShop', 'WEAPON_FIREWORK', 18000),
	(25, 'GunShop', 'WEAPON_GRENADE', 500),
	(27, 'GunShop', 'WEAPON_BZGAS', 200),
	(29, 'GunShop', 'WEAPON_FIREEXTINGUISHER', 100),
	(31, 'GunShop', 'WEAPON_BALL', 50),
	(33, 'GunShop', 'WEAPON_SMOKEGRENADE', 100);
/*!40000 ALTER TABLE `weashops` ENABLE KEYS */;

-- Dumping structure for table essentialmode.weashops2
CREATE TABLE IF NOT EXISTS `weashops2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zone` varchar(255) NOT NULL,
  `item` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table essentialmode.weashops2: ~17 rows (approximately)
DELETE FROM `weashops2`;
/*!40000 ALTER TABLE `weashops2` DISABLE KEYS */;
INSERT INTO `weashops2` (`id`, `zone`, `item`, `price`) VALUES
	(1, 'GunShop', 'WEAPON_PISTOL', 100),
	(2, 'GunShop', 'WEAPON_FLASHLIGHT', 10),
	(3, 'GunShop', 'WEAPON_MACHETE', 30),
	(4, 'GunShop', 'WEAPON_NIGHTSTICK', 75),
	(5, 'GunShop', 'WEAPON_BAT', 55),
	(6, 'GunShop', 'WEAPON_STUNGUN', 30),
	(7, 'GunShop', 'WEAPON_MICROSMG', 700),
	(8, 'GunShop', 'WEAPON_PUMPSHOTGUN', 1200),
	(9, 'GunShop', 'WEAPON_ASSAULTRIFLE', 4600),
	(10, 'GunShop', 'WEAPON_SPECIALCARBINE', 8500),
	(11, 'GunShop', 'WEAPON_SNIPERRIFLE', 9000),
	(12, 'GunShop', 'WEAPON_FIREWORK', 6000),
	(13, 'GunShop', 'WEAPON_GRENADE', 200),
	(14, 'GunShop', 'WEAPON_BZGAS', 50),
	(15, 'GunShop', 'WEAPON_FIREEXTINGUISHER', 30),
	(16, 'GunShop', 'WEAPON_BALL', 10),
	(17, 'GunShop', 'WEAPON_SMOKEGRENADE', 40);
/*!40000 ALTER TABLE `weashops2` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
