/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.13-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: 157.90.252.24    Database: uirp-legacy
-- ------------------------------------------------------
-- Server version	10.11.13-MariaDB-0ubuntu0.24.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bank_accounts_new`
--

DROP TABLE IF EXISTS `bank_accounts_new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bank_accounts_new` (
  `id` varchar(50) NOT NULL,
  `amount` int(11) DEFAULT 0,
  `transactions` longtext DEFAULT NULL,
  `auth` longtext DEFAULT NULL,
  `isFrozen` int(11) DEFAULT 0,
  `creator` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bank_accounts_new`
--

LOCK TABLES `bank_accounts_new` WRITE;
/*!40000 ALTER TABLE `bank_accounts_new` DISABLE KEYS */;
INSERT INTO `bank_accounts_new` VALUES
('ambulance',0,'[]','[]',0,NULL),
('ballas',0,'[]','[]',0,NULL),
('bcso',0,'[]','[]',0,NULL),
('bus',0,'[]','[]',0,NULL),
('cardealer',0,'[]','[]',0,NULL),
('cartel',0,'[]','[]',0,NULL),
('families',0,'[]','[]',0,NULL),
('garbage',0,'[]','[]',0,NULL),
('hotdog',0,'[]','[]',0,NULL),
('judge',0,'[]','[]',0,NULL),
('lawyer',0,'[]','[]',0,NULL),
('lostmc',0,'[]','[]',0,NULL),
('mechanic',0,'[]','[]',0,NULL),
('none',0,'[]','[]',0,NULL),
('police',550,'[{\"issuer\":\"Artem Medvedev\",\"time\":1743989385,\"receiver\":\"LSPD\",\"message\":\"//\",\"trans_id\":\"fbdb4dac-a374-41fb-a6f0-0a2d1934b144\",\"title\":\"Personal Account / Z64O720C\",\"amount\":150,\"trans_type\":\"deposit\"}]','[]',0,NULL),
('realestate',0,'[]','[]',0,NULL),
('reporter',0,'[]','[]',0,NULL),
('sasp',0,'[]','[]',0,NULL),
('taxi',0,'[]','[]',0,NULL),
('tow',0,'[]','[]',0,NULL),
('triads',0,'[]','[]',0,NULL),
('trucker',0,'[]','[]',0,NULL),
('unemployed',0,'[]','[]',0,NULL),
('vagos',0,'[]','[]',0,NULL),
('vineyard',0,'[]','[]',0,NULL);
/*!40000 ALTER TABLE `bank_accounts_new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bans`
--

DROP TABLE IF EXISTS `bans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `license` varchar(50) DEFAULT NULL,
  `discord` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `expire` int(11) DEFAULT NULL,
  `bannedby` varchar(255) NOT NULL DEFAULT 'LeBanhammer',
  PRIMARY KEY (`id`),
  KEY `license` (`license`),
  KEY `discord` (`discord`),
  KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bans`
--

LOCK TABLES `bans` WRITE;
/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dealers`
--

DROP TABLE IF EXISTS `dealers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `dealers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '0',
  `coords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `time` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `createdby` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dealers`
--

LOCK TABLES `dealers` WRITE;
/*!40000 ALTER TABLE `dealers` DISABLE KEYS */;
/*!40000 ALTER TABLE `dealers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lapraces`
--

DROP TABLE IF EXISTS `lapraces`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `lapraces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `checkpoints` text DEFAULT NULL,
  `records` text DEFAULT NULL,
  `creator` varchar(50) DEFAULT NULL,
  `distance` int(11) DEFAULT NULL,
  `raceid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `raceid` (`raceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lapraces`
--

LOCK TABLES `lapraces` WRITE;
/*!40000 ALTER TABLE `lapraces` DISABLE KEYS */;
/*!40000 ALTER TABLE `lapraces` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `management_outfits`
--

DROP TABLE IF EXISTS `management_outfits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `management_outfits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `minrank` int(11) NOT NULL DEFAULT 0,
  `name` varchar(50) NOT NULL DEFAULT 'Cool Outfit',
  `gender` varchar(50) NOT NULL DEFAULT 'male',
  `model` varchar(50) DEFAULT NULL,
  `props` text DEFAULT NULL,
  `components` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `management_outfits`
--

LOCK TABLES `management_outfits` WRITE;
/*!40000 ALTER TABLE `management_outfits` DISABLE KEYS */;
/*!40000 ALTER TABLE `management_outfits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_calls`
--

DROP TABLE IF EXISTS `npwd_calls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_calls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `transmitter` varchar(255) NOT NULL,
  `receiver` varchar(255) NOT NULL,
  `is_accepted` tinyint(4) DEFAULT 0,
  `isAnonymous` tinyint(4) NOT NULL DEFAULT 0,
  `start` varchar(255) DEFAULT NULL,
  `end` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_calls`
--

LOCK TABLES `npwd_calls` WRITE;
/*!40000 ALTER TABLE `npwd_calls` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_calls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_darkchat_channel_members`
--

DROP TABLE IF EXISTS `npwd_darkchat_channel_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_darkchat_channel_members` (
  `channel_id` int(11) NOT NULL,
  `user_identifier` varchar(255) NOT NULL,
  `is_owner` tinyint(4) NOT NULL DEFAULT 0,
  KEY `npwd_darkchat_channel_members_npwd_darkchat_channels_id_fk` (`channel_id`) USING BTREE,
  CONSTRAINT `npwd_darkchat_channel_members_npwd_darkchat_channels_id_fk` FOREIGN KEY (`channel_id`) REFERENCES `npwd_darkchat_channels` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_darkchat_channel_members`
--

LOCK TABLES `npwd_darkchat_channel_members` WRITE;
/*!40000 ALTER TABLE `npwd_darkchat_channel_members` DISABLE KEYS */;
INSERT INTO `npwd_darkchat_channel_members` VALUES
(20,'Z64O720C',1);
/*!40000 ALTER TABLE `npwd_darkchat_channel_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_darkchat_channels`
--

DROP TABLE IF EXISTS `npwd_darkchat_channels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_darkchat_channels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_identifier` varchar(191) NOT NULL,
  `label` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `darkchat_channels_channel_identifier_uindex` (`channel_identifier`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_darkchat_channels`
--

LOCK TABLES `npwd_darkchat_channels` WRITE;
/*!40000 ALTER TABLE `npwd_darkchat_channels` DISABLE KEYS */;
INSERT INTO `npwd_darkchat_channels` VALUES
(20,'1','1');
/*!40000 ALTER TABLE `npwd_darkchat_channels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_darkchat_messages`
--

DROP TABLE IF EXISTS `npwd_darkchat_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_darkchat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `user_identifier` varchar(255) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_image` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `darkchat_messages_darkchat_channels_id_fk` (`channel_id`) USING BTREE,
  CONSTRAINT `darkchat_messages_darkchat_channels_id_fk` FOREIGN KEY (`channel_id`) REFERENCES `npwd_darkchat_channels` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_darkchat_messages`
--

LOCK TABLES `npwd_darkchat_messages` WRITE;
/*!40000 ALTER TABLE `npwd_darkchat_messages` DISABLE KEYS */;
INSERT INTO `npwd_darkchat_messages` VALUES
(31,20,'test','Z64O720C','2025-04-07 02:07:40',0);
/*!40000 ALTER TABLE `npwd_darkchat_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_marketplace_listings`
--

DROP TABLE IF EXISTS `npwd_marketplace_listings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_marketplace_listings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `number` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `reported` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_marketplace_listings`
--

LOCK TABLES `npwd_marketplace_listings` WRITE;
/*!40000 ALTER TABLE `npwd_marketplace_listings` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_marketplace_listings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_match_profiles`
--

DROP TABLE IF EXISTS `npwd_match_profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_match_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(90) NOT NULL,
  `image` varchar(255) NOT NULL,
  `bio` varchar(512) DEFAULT NULL,
  `location` varchar(45) DEFAULT NULL,
  `job` varchar(45) DEFAULT NULL,
  `tags` varchar(255) NOT NULL DEFAULT '',
  `voiceMessage` varchar(512) DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `identifier_UNIQUE` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_match_profiles`
--

LOCK TABLES `npwd_match_profiles` WRITE;
/*!40000 ALTER TABLE `npwd_match_profiles` DISABLE KEYS */;
INSERT INTO `npwd_match_profiles` VALUES
(1,'Z64O720C','Artem Medvedev','https://upload.wikimedia.org/wikipedia/commons/a/ac/No_image_available.svg','','','','',NULL,'2025-04-07 01:12:41','2025-04-07 01:12:41');
/*!40000 ALTER TABLE `npwd_match_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_match_views`
--

DROP TABLE IF EXISTS `npwd_match_views`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_match_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `profile` int(11) NOT NULL,
  `liked` tinyint(4) DEFAULT 0,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `match_profile_idx` (`profile`),
  KEY `identifier` (`identifier`),
  CONSTRAINT `match_profile` FOREIGN KEY (`profile`) REFERENCES `npwd_match_profiles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_match_views`
--

LOCK TABLES `npwd_match_views` WRITE;
/*!40000 ALTER TABLE `npwd_match_views` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_match_views` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_messages`
--

DROP TABLE IF EXISTS `npwd_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `conversation_id` varchar(512) NOT NULL,
  `isRead` tinyint(4) NOT NULL DEFAULT 0,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `visible` tinyint(4) NOT NULL DEFAULT 1,
  `author` varchar(255) NOT NULL,
  `is_embed` tinyint(4) NOT NULL DEFAULT 0,
  `embed` varchar(512) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_identifier` (`user_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_messages`
--

LOCK TABLES `npwd_messages` WRITE;
/*!40000 ALTER TABLE `npwd_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_messages_conversations`
--

DROP TABLE IF EXISTS `npwd_messages_conversations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_messages_conversations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_list` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `label` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `last_message_id` int(11) DEFAULT NULL,
  `is_group_chat` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_messages_conversations`
--

LOCK TABLES `npwd_messages_conversations` WRITE;
/*!40000 ALTER TABLE `npwd_messages_conversations` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_messages_conversations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_messages_participants`
--

DROP TABLE IF EXISTS `npwd_messages_participants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_messages_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL,
  `participant` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `unread_count` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `message_participants_npwd_messages_conversations_id_fk` (`conversation_id`) USING BTREE,
  CONSTRAINT `message_participants_npwd_messages_conversations_id_fk` FOREIGN KEY (`conversation_id`) REFERENCES `npwd_messages_conversations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_messages_participants`
--

LOCK TABLES `npwd_messages_participants` WRITE;
/*!40000 ALTER TABLE `npwd_messages_participants` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_messages_participants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_notes`
--

DROP TABLE IF EXISTS `npwd_notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_notes`
--

LOCK TABLES `npwd_notes` WRITE;
/*!40000 ALTER TABLE `npwd_notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_phone_contacts`
--

DROP TABLE IF EXISTS `npwd_phone_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_phone_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `number` varchar(20) DEFAULT NULL,
  `display` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_phone_contacts`
--

LOCK TABLES `npwd_phone_contacts` WRITE;
/*!40000 ALTER TABLE `npwd_phone_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_phone_contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_phone_gallery`
--

DROP TABLE IF EXISTS `npwd_phone_gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_phone_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_phone_gallery`
--

LOCK TABLES `npwd_phone_gallery` WRITE;
/*!40000 ALTER TABLE `npwd_phone_gallery` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_phone_gallery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_twitter_likes`
--

DROP TABLE IF EXISTS `npwd_twitter_likes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_twitter_likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `tweet_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_combination` (`profile_id`,`tweet_id`),
  KEY `profile_idx` (`profile_id`),
  KEY `tweet_idx` (`tweet_id`),
  CONSTRAINT `profile` FOREIGN KEY (`profile_id`) REFERENCES `npwd_twitter_profiles` (`id`),
  CONSTRAINT `tweet` FOREIGN KEY (`tweet_id`) REFERENCES `npwd_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_twitter_likes`
--

LOCK TABLES `npwd_twitter_likes` WRITE;
/*!40000 ALTER TABLE `npwd_twitter_likes` DISABLE KEYS */;
INSERT INTO `npwd_twitter_likes` VALUES
(1,1,1);
/*!40000 ALTER TABLE `npwd_twitter_likes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_twitter_profiles`
--

DROP TABLE IF EXISTS `npwd_twitter_profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_twitter_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_name` varchar(90) NOT NULL,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `avatar_url` varchar(255) DEFAULT 'https://i.fivemanage.com/images/3ClWwmpwkFhL.png',
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `profile_name_UNIQUE` (`profile_name`),
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_twitter_profiles`
--

LOCK TABLES `npwd_twitter_profiles` WRITE;
/*!40000 ALTER TABLE `npwd_twitter_profiles` DISABLE KEYS */;
INSERT INTO `npwd_twitter_profiles` VALUES
(1,'Artem_Medvedev','Z64O720C','https://i.fivemanage.com/images/3ClWwmpwkFhL.png','2025-04-07 01:12:41','2025-04-07 01:12:41');
/*!40000 ALTER TABLE `npwd_twitter_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_twitter_reports`
--

DROP TABLE IF EXISTS `npwd_twitter_reports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_twitter_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `tweet_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_combination` (`profile_id`,`tweet_id`),
  KEY `profile_idx` (`profile_id`),
  KEY `tweet_idx` (`tweet_id`),
  CONSTRAINT `report_profile` FOREIGN KEY (`profile_id`) REFERENCES `npwd_twitter_profiles` (`id`),
  CONSTRAINT `report_tweet` FOREIGN KEY (`tweet_id`) REFERENCES `npwd_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_twitter_reports`
--

LOCK TABLES `npwd_twitter_reports` WRITE;
/*!40000 ALTER TABLE `npwd_twitter_reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `npwd_twitter_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `npwd_twitter_tweets`
--

DROP TABLE IF EXISTS `npwd_twitter_tweets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `npwd_twitter_tweets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `updatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0,
  `identifier` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT 1,
  `images` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `retweet` int(11) DEFAULT NULL,
  `profile_id` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `npwd_twitter_tweets_npwd_twitter_profiles_id_fk` (`profile_id`) USING BTREE,
  CONSTRAINT `npwd_twitter_tweets_npwd_twitter_profiles_id_fk` FOREIGN KEY (`profile_id`) REFERENCES `npwd_twitter_profiles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `npwd_twitter_tweets`
--

LOCK TABLES `npwd_twitter_tweets` WRITE;
/*!40000 ALTER TABLE `npwd_twitter_tweets` DISABLE KEYS */;
INSERT INTO `npwd_twitter_tweets` VALUES
(1,'hey','2025-04-07 02:08:23','2025-04-07 02:08:26',1,'Z64O720C',1,'',NULL,1),
(2,'test@Artem_Medvedev','2025-04-07 02:08:29','2025-04-07 02:08:29',0,'Z64O720C',1,'',NULL,1);
/*!40000 ALTER TABLE `npwd_twitter_tweets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `occasion_vehicles`
--

DROP TABLE IF EXISTS `occasion_vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `occasion_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller` varchar(50) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `plate` varchar(50) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `mods` text DEFAULT NULL,
  `occasionid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `occasionId` (`occasionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `occasion_vehicles`
--

LOCK TABLES `occasion_vehicles` WRITE;
/*!40000 ALTER TABLE `occasion_vehicles` DISABLE KEYS */;
/*!40000 ALTER TABLE `occasion_vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ox_doorlock`
--

DROP TABLE IF EXISTS `ox_doorlock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ox_doorlock` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `data` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ox_doorlock`
--

LOCK TABLES `ox_doorlock` WRITE;
/*!40000 ALTER TABLE `ox_doorlock` DISABLE KEYS */;
INSERT INTO `ox_doorlock` VALUES
(1,'vangelico_jewellery','{\"maxDistance\":2,\"groups\":{\"police\":0},\"doors\":[{\"model\":1425919976,\"coords\":{\"x\":-631.9553833007813,\"y\":-236.33326721191407,\"z\":38.2065315246582},\"heading\":306},{\"model\":9467943,\"coords\":{\"x\":-630.426513671875,\"y\":-238.4375457763672,\"z\":38.2065315246582},\"heading\":306}],\"state\":1,\"coords\":{\"x\":-631.19091796875,\"y\":-237.38540649414063,\"z\":38.2065315246582},\"hideUi\":true}'),
(2,'BigBankThermite1','{\"heading\":160,\"doors\":false,\"maxDistance\":2,\"hideUi\":true,\"groups\":{\"police\":0},\"coords\":{\"x\":251.85757446289063,\"y\":221.0654754638672,\"z\":101.83240509033203},\"model\":-1508355822,\"state\":1,\"autolock\":1800}'),
(3,'BigBankThermite2','{\"coords\":{\"x\":261.3004150390625,\"y\":214.50514221191407,\"z\":101.83240509033203},\"autolock\":1800,\"maxDistance\":2,\"groups\":{\"police\":0},\"model\":-1508355822,\"doors\":false,\"hideUi\":true,\"heading\":250,\"state\":1}'),
(4,'BigBankLPDoor','{\"coords\":{\"x\":256.3115539550781,\"y\":220.65785217285157,\"z\":106.42955780029297},\"autolock\":1800,\"maxDistance\":2,\"model\":-222270721,\"doors\":false,\"lockpick\":true,\"hideUi\":true,\"heading\":340,\"state\":1,\"lockpickDifficulty\":[\"hard\"]}'),
(5,'PaletoThermiteDoor','{\"coords\":{\"x\":-106.47130584716797,\"y\":6476.15771484375,\"z\":31.95479965209961},\"autolock\":1800,\"maxDistance\":2,\"groups\":{\"police\":0},\"model\":1309269072,\"doors\":false,\"hideUi\":true,\"heading\":315,\"state\":1}'),
(6,'BigBankRedCardDoor','{\"coords\":{\"x\":262.1980895996094,\"y\":222.518798828125,\"z\":106.42955780029297},\"autolock\":1800,\"maxDistance\":2,\"groups\":{\"police\":0},\"model\":746855201,\"doors\":false,\"hideUi\":true,\"heading\":250,\"state\":1}');
/*!40000 ALTER TABLE `ox_doorlock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ox_inventory`
--

DROP TABLE IF EXISTS `ox_inventory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ox_inventory` (
  `owner` varchar(60) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `data` longtext DEFAULT NULL,
  `lastupdated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  UNIQUE KEY `owner` (`owner`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ox_inventory`
--

LOCK TABLES `ox_inventory` WRITE;
/*!40000 ALTER TABLE `ox_inventory` DISABLE KEYS */;
/*!40000 ALTER TABLE `ox_inventory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_groups`
--

DROP TABLE IF EXISTS `player_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_groups` (
  `citizenid` varchar(50) NOT NULL,
  `group` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `grade` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`citizenid`,`type`,`group`),
  CONSTRAINT `fk_citizenid` FOREIGN KEY (`citizenid`) REFERENCES `players` (`citizenid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_groups`
--

LOCK TABLES `player_groups` WRITE;
/*!40000 ALTER TABLE `player_groups` DISABLE KEYS */;
INSERT INTO `player_groups` VALUES
('Z64O720C','ballas','gang',1),
('Z64O720C','police','job',4);
/*!40000 ALTER TABLE `player_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_jobs_activity`
--

DROP TABLE IF EXISTS `player_jobs_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_jobs_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job` varchar(255) NOT NULL,
  `last_checkin` int(11) NOT NULL,
  `last_checkout` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id` DESC) USING BTREE,
  KEY `last_checkout` (`last_checkout`) USING BTREE,
  KEY `citizenid_job` (`citizenid`,`job`) USING BTREE,
  CONSTRAINT `player_jobs_activity_ibfk_1` FOREIGN KEY (`citizenid`) REFERENCES `players` (`citizenid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_jobs_activity`
--

LOCK TABLES `player_jobs_activity` WRITE;
/*!40000 ALTER TABLE `player_jobs_activity` DISABLE KEYS */;
/*!40000 ALTER TABLE `player_jobs_activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_mails`
--

DROP TABLE IF EXISTS `player_mails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_mails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `subject` varchar(50) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `read` tinyint(4) DEFAULT 0,
  `mailid` int(11) DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp(),
  `button` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_mails`
--

LOCK TABLES `player_mails` WRITE;
/*!40000 ALTER TABLE `player_mails` DISABLE KEYS */;
/*!40000 ALTER TABLE `player_mails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_outfit_codes`
--

DROP TABLE IF EXISTS `player_outfit_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_outfit_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `outfitid` int(11) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `FK_player_outfit_codes_player_outfits` (`outfitid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_outfit_codes`
--

LOCK TABLES `player_outfit_codes` WRITE;
/*!40000 ALTER TABLE `player_outfit_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `player_outfit_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_outfits`
--

DROP TABLE IF EXISTS `player_outfits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_outfits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `outfitname` varchar(50) NOT NULL DEFAULT '0',
  `model` varchar(50) DEFAULT NULL,
  `props` text DEFAULT NULL,
  `components` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `citizenid_outfitname_model` (`citizenid`,`outfitname`,`model`),
  KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_outfits`
--

LOCK TABLES `player_outfits` WRITE;
/*!40000 ALTER TABLE `player_outfits` DISABLE KEYS */;
/*!40000 ALTER TABLE `player_outfits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_transactions`
--

DROP TABLE IF EXISTS `player_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_transactions` (
  `id` varchar(50) NOT NULL,
  `isFrozen` int(11) DEFAULT 0,
  `transactions` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_transactions`
--

LOCK TABLES `player_transactions` WRITE;
/*!40000 ALTER TABLE `player_transactions` DISABLE KEYS */;
INSERT INTO `player_transactions` VALUES
('Z64O720C',0,'[{\"title\":\"Personal Account / Z64O720C\",\"amount\":1000,\"trans_type\":\"withdraw\",\"message\":\"Artem Medvedev has withdrawed $1000\",\"time\":1744519119,\"issuer\":\"Artem Medvedev\",\"trans_id\":\"cdd3f818-79c2-4d15-8ba5-50ff445a9aa7\",\"receiver\":\"Artem Medvedev\"},{\"title\":\"Personal Account / Z64O720C\",\"amount\":522,\"receiver\":\"Artem Medvedev\",\"message\":\"Artem Medvedev has withdrawed $522\",\"trans_type\":\"withdraw\",\"issuer\":\"Artem Medvedev\",\"trans_id\":\"80ce1884-62f6-4753-83da-0b30dda7a71e\",\"time\":1743996934},{\"title\":\"Personal Account / Z64O720C\",\"amount\":150,\"trans_type\":\"withdraw\",\"message\":\"//\",\"time\":1743989385,\"issuer\":\"Artem Medvedev\",\"trans_id\":\"fbdb4dac-a374-41fb-a6f0-0a2d1934b144\",\"receiver\":\"LSPD\"}]');
/*!40000 ALTER TABLE `player_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `player_vehicles`
--

DROP TABLE IF EXISTS `player_vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `player_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `license` varchar(50) DEFAULT NULL,
  `citizenid` varchar(50) DEFAULT NULL,
  `vehicle` varchar(50) DEFAULT NULL,
  `hash` varchar(50) DEFAULT NULL,
  `mods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `plate` varchar(15) NOT NULL,
  `fakeplate` varchar(50) DEFAULT NULL,
  `garage` varchar(50) DEFAULT NULL,
  `fuel` int(11) DEFAULT 100,
  `engine` float DEFAULT 1000,
  `body` float DEFAULT 1000,
  `state` int(11) DEFAULT 1,
  `depotprice` int(11) NOT NULL DEFAULT 0,
  `drivingdistance` int(50) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `glovebox` longtext DEFAULT NULL,
  `trunk` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plate` (`plate`),
  KEY `citizenid` (`citizenid`),
  CONSTRAINT `player_vehicles_ibfk_1` FOREIGN KEY (`citizenid`) REFERENCES `players` (`citizenid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `player_vehicles`
--

LOCK TABLES `player_vehicles` WRITE;
/*!40000 ALTER TABLE `player_vehicles` DISABLE KEYS */;
INSERT INTO `player_vehicles` VALUES
(1,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','cyclone','1392481335','{\"modFrontWheels\":215,\"modBrakes\":2,\"modArmor\":-1,\"tyres\":[],\"modSteeringWheel\":-1,\"modHorns\":57,\"xenonColor\":255,\"modAerials\":-1,\"modSubwoofer\":-1,\"modWindows\":-1,\"modTurbo\":true,\"wheelSize\":0.69837880134582,\"modXenon\":false,\"modRightFender\":-1,\"interiorColor\":1,\"modShifterLeavers\":-1,\"modArchCover\":-1,\"modDoorR\":-1,\"neonColor\":[255,0,255],\"modEngineBlock\":-1,\"modAirFilter\":-1,\"fuelLevel\":99,\"dirtLevel\":5,\"modDial\":-1,\"oilLevel\":5,\"modTank\":-1,\"model\":1392481335,\"modStruts\":-1,\"modRearBumper\":-1,\"modFender\":-1,\"modTrimA\":-1,\"modCustomTiresR\":false,\"engineHealth\":995,\"tankHealth\":1000,\"neonEnabled\":[false,false,false,false],\"extras\":[],\"modOrnaments\":-1,\"windowTint\":-1,\"bulletProofTyres\":true,\"modDoorSpeaker\":-1,\"modHood\":-1,\"modLightbar\":-1,\"modNitrous\":-1,\"driftTyres\":false,\"modFrontBumper\":3,\"modTrimB\":-1,\"modVanityPlate\":-1,\"tyreSmokeColor\":[254,254,254],\"modEngine\":3,\"modGrille\":-1,\"modSuspension\":2,\"pearlescentColor\":158,\"modDashboard\":-1,\"modFrame\":-1,\"color1\":228,\"modExhaust\":-1,\"doors\":[],\"modHydraulics\":false,\"modSeats\":-1,\"modLivery\":1,\"modCustomTiresF\":false,\"dashboardColor\":0,\"wheelColor\":1,\"color2\":1,\"modSpoilers\":8,\"modRoofLivery\":-1,\"plateIndex\":10,\"modTransmission\":-1,\"paintType1\":7,\"modHydrolic\":-1,\"modSmokeEnabled\":true,\"modSpeakers\":-1,\"paintType2\":7,\"modAPlate\":-1,\"livery\":-1,\"modRoof\":-1,\"bodyHealth\":997,\"modTrunk\":-1,\"modSideSkirt\":3,\"plate\":\"83CBP266\",\"wheels\":8,\"modPlateHolder\":-1,\"wheelWidth\":0.51996052265167,\"modBackWheels\":-1,\"windows\":[4,5]}','83CBP266',NULL,'pillboxgarage',99,995,997,1,1378,NULL,NULL,NULL,NULL),
(2,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','openwheel2','1181339704','{\"model\":1181339704,\"modLightbar\":-1,\"bulletProofTyres\":true,\"modAerials\":-1,\"neonEnabled\":[false,false,false,false],\"modDoorSpeaker\":-1,\"modBrakes\":3,\"modFender\":1,\"dashboardColor\":156,\"wheelColor\":111,\"modPlateHolder\":-1,\"oilLevel\":5,\"tankHealth\":999,\"modTrimB\":-1,\"plate\":\"89HFL585\",\"interiorColor\":9,\"modArmor\":-1,\"engineHealth\":995,\"xenonColor\":12,\"paintType2\":7,\"modXenon\":true,\"modCustomTiresR\":false,\"modTransmission\":3,\"modHydrolic\":-1,\"neonColor\":[255,0,255],\"modDoorR\":-1,\"fuelLevel\":64,\"wheelWidth\":0.63999998569488,\"modEngineBlock\":-1,\"modDial\":-1,\"modRoofLivery\":-1,\"wheels\":10,\"modArchCover\":-1,\"modTurbo\":true,\"modCustomTiresF\":false,\"modFrontBumper\":6,\"modHood\":-1,\"modBackWheels\":-1,\"modFrame\":4,\"pearlescentColor\":0,\"modTrunk\":-1,\"modSideSkirt\":3,\"color1\":219,\"tyres\":[],\"modDashboard\":-1,\"modVanityPlate\":-1,\"modHorns\":1,\"dirtLevel\":7,\"windowTint\":5,\"modExhaust\":2,\"color2\":27,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modRightFender\":-1,\"modWindows\":-1,\"modGrille\":2,\"modTank\":-1,\"tyreSmokeColor\":[254,254,254],\"modSuspension\":-1,\"extras\":[0,0,0,0,0,0,0,0,null,null,0],\"modAPlate\":-1,\"modSmokeEnabled\":true,\"modOrnaments\":-1,\"modSpeakers\":-1,\"windows\":[0,1,2,3,4,5,6,7],\"modSubwoofer\":-1,\"modEngine\":3,\"modRoof\":4,\"modHydraulics\":false,\"modLivery\":4,\"paintType1\":7,\"wheelSize\":0.65999996662139,\"modFrontWheels\":111,\"doors\":[],\"modRearBumper\":-1,\"bodyHealth\":999,\"modSpoilers\":3,\"driftTyres\":false,\"modStruts\":-1,\"livery\":-1,\"modTrimA\":-1,\"plateIndex\":4,\"modSeats\":-1,\"modNitrous\":-1,\"modAirFilter\":-1}','89HFL585',NULL,'pillboxgarage',64,995,999,1,0,NULL,NULL,NULL,NULL),
(3,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','tenf2','274946574','{\"color2\":234,\"modGrille\":-1,\"modStruts\":-1,\"modDoorR\":-1,\"plateIndex\":7,\"extras\":[],\"modTurbo\":true,\"dashboardColor\":156,\"modCustomTiresF\":false,\"color1\":234,\"modArmor\":-1,\"modTrimA\":6,\"pearlescentColor\":4,\"modLivery\":-1,\"modArchCover\":0,\"xenonColor\":12,\"bulletProofTyres\":true,\"modDoorSpeaker\":-1,\"modTrimB\":3,\"modDashboard\":0,\"driftTyres\":false,\"modFrontBumper\":16,\"fuelLevel\":98,\"modSpeakers\":-1,\"wheelColor\":0,\"plate\":\"01KYY524\",\"modPlateHolder\":-1,\"engineHealth\":943,\"modXenon\":true,\"modHorns\":-1,\"modTank\":-1,\"paintType2\":7,\"neonEnabled\":[false,false,false,false],\"modSeats\":13,\"neonColor\":[255,0,255],\"modRightFender\":4,\"modHood\":2,\"modTrunk\":-1,\"dirtLevel\":5,\"modFrontWheels\":47,\"modBackWheels\":-1,\"modNitrous\":-1,\"modSmokeEnabled\":true,\"modTransmission\":2,\"modExhaust\":21,\"livery\":-1,\"modRoofLivery\":-1,\"modVanityPlate\":15,\"wheels\":11,\"model\":274946574,\"modBrakes\":2,\"modSubwoofer\":-1,\"modSuspension\":4,\"modEngine\":3,\"paintType1\":7,\"modDial\":-1,\"modFrame\":-1,\"modAerials\":-1,\"modOrnaments\":-1,\"modRearBumper\":14,\"modRoof\":7,\"interiorColor\":37,\"bodyHealth\":991,\"wheelWidth\":0.61961835622787,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modLightbar\":-1,\"modEngineBlock\":-1,\"windows\":[2,3,4,5],\"wheelSize\":0.68428915739059,\"modWindows\":-1,\"modAPlate\":-1,\"modHydraulics\":false,\"modSideSkirt\":12,\"modCustomTiresR\":false,\"windowTint\":1,\"doors\":[],\"tankHealth\":999,\"modHydrolic\":-1,\"modSpoilers\":8,\"oilLevel\":5,\"tyres\":[],\"tyreSmokeColor\":[254,254,254],\"modAirFilter\":-1,\"modFender\":3}','01KYY524',NULL,'pillboxgarage',98,943,991,1,1655,NULL,NULL,NULL,NULL),
(4,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','cypher','1755697647','{\"modCustomTiresR\":false,\"pearlescentColor\":5,\"modPlateHolder\":-1,\"modHydrolic\":-1,\"modSubwoofer\":-1,\"modEngine\":3,\"modTrimB\":5,\"modLightbar\":-1,\"windows\":[4,5],\"modFrontBumper\":9,\"modSpoilers\":4,\"interiorColor\":0,\"driftTyres\":false,\"modBackWheels\":-1,\"modOrnaments\":-1,\"plate\":\"83PDC228\",\"paintType2\":7,\"modStruts\":15,\"color2\":36,\"wheelColor\":0,\"bulletProofTyres\":true,\"model\":1755697647,\"modHood\":11,\"modBrakes\":2,\"modTrunk\":-1,\"modFrame\":7,\"plateIndex\":8,\"modXenon\":true,\"modVanityPlate\":-1,\"dirtLevel\":4,\"modTransmission\":2,\"tyres\":[],\"modSuspension\":3,\"xenonColor\":12,\"modFrontWheels\":14,\"extras\":[],\"modRearBumper\":2,\"wheelWidth\":0.59963065385818,\"neonEnabled\":[false,false,false,false],\"bodyHealth\":997,\"livery\":-1,\"modLivery\":14,\"modWindows\":-1,\"modSideSkirt\":6,\"modCustomTiresF\":false,\"modAPlate\":-1,\"modDial\":0,\"doors\":[],\"oilLevel\":7,\"modTurbo\":true,\"color1\":189,\"modHorns\":-1,\"paintType1\":7,\"modGrille\":10,\"modExhaust\":7,\"modRoofLivery\":-1,\"wheels\":11,\"engineHealth\":986,\"modEngineBlock\":4,\"tyreSmokeColor\":[254,254,254],\"windowTint\":1,\"modRoof\":6,\"modSteeringWheel\":-1,\"modDoorSpeaker\":-1,\"modSeats\":10,\"modAirFilter\":-1,\"fuelLevel\":47,\"modHydraulics\":false,\"modFender\":0,\"modRightFender\":4,\"modAerials\":-1,\"modArmor\":-1,\"tankHealth\":1000,\"modShifterLeavers\":-1,\"dashboardColor\":156,\"modTrimA\":-1,\"neonColor\":[255,0,255],\"modDoorR\":-1,\"modDashboard\":2,\"modSpeakers\":-1,\"modSmokeEnabled\":true,\"modArchCover\":6,\"modNitrous\":-1,\"modTank\":0,\"wheelSize\":0.69032698869705}','83PDC228',NULL,'pillboxgarage',47,986,997,1,1514,NULL,NULL,NULL,NULL),
(5,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','coquette4','-1728685474','{\"model\":-1728685474,\"modLightbar\":-1,\"bulletProofTyres\":true,\"modAerials\":-1,\"neonEnabled\":[false,false,false,false],\"modDoorSpeaker\":-1,\"modBrakes\":2,\"modFender\":-1,\"dashboardColor\":111,\"wheelColor\":0,\"modPlateHolder\":-1,\"oilLevel\":7,\"tankHealth\":999,\"modTrimB\":-1,\"plate\":\"63FSO115\",\"interiorColor\":2,\"modArmor\":-1,\"engineHealth\":995,\"xenonColor\":255,\"paintType2\":7,\"modXenon\":false,\"modCustomTiresR\":false,\"modTransmission\":2,\"modHydrolic\":-1,\"neonColor\":[255,0,255],\"modDoorR\":-1,\"fuelLevel\":99,\"wheelWidth\":0.57953631877899,\"modEngineBlock\":-1,\"modDial\":-1,\"modRoofLivery\":-1,\"wheels\":12,\"modArchCover\":-1,\"modTurbo\":true,\"modCustomTiresF\":false,\"modFrontBumper\":-1,\"modHood\":3,\"modBackWheels\":-1,\"modFrame\":-1,\"pearlescentColor\":88,\"modTrunk\":-1,\"modSideSkirt\":0,\"color1\":202,\"tyres\":[],\"modDashboard\":-1,\"modVanityPlate\":-1,\"modHorns\":-1,\"dirtLevel\":0,\"windowTint\":1,\"modExhaust\":5,\"color2\":111,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modRightFender\":-1,\"modWindows\":-1,\"modGrille\":1,\"modTank\":-1,\"tyreSmokeColor\":[254,254,254],\"modSuspension\":3,\"extras\":[0],\"modAPlate\":-1,\"modSmokeEnabled\":true,\"modOrnaments\":-1,\"modSpeakers\":-1,\"windows\":[2,3,4,5],\"modSubwoofer\":-1,\"modEngine\":3,\"modRoof\":0,\"modHydraulics\":false,\"modLivery\":-1,\"paintType1\":7,\"wheelSize\":0.66416299343109,\"modFrontWheels\":25,\"doors\":[],\"modRearBumper\":-1,\"bodyHealth\":997,\"modSpoilers\":-1,\"driftTyres\":false,\"modStruts\":-1,\"livery\":-1,\"modTrimA\":-1,\"plateIndex\":11,\"modSeats\":-1,\"modNitrous\":-1,\"modAirFilter\":-1}','63FSO115',NULL,'pillboxgarage',99,995,997,0,1615,NULL,NULL,NULL,NULL),
(6,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','supervolito2','-1671539132','{\"model\":-1671539132,\"modLightbar\":-1,\"bulletProofTyres\":true,\"modAerials\":-1,\"paintType1\":7,\"modDoorSpeaker\":-1,\"modBrakes\":-1,\"modFender\":-1,\"dashboardColor\":0,\"wheelColor\":156,\"modPlateHolder\":-1,\"oilLevel\":8,\"tankHealth\":1000,\"modTrimB\":-1,\"plate\":\"05JEV483\",\"modRearBumper\":-1,\"modArmor\":-1,\"engineHealth\":1000,\"xenonColor\":255,\"paintType2\":7,\"modXenon\":false,\"modDashboard\":-1,\"modTransmission\":-1,\"modHydrolic\":-1,\"neonColor\":[255,0,255],\"modDoorR\":-1,\"fuelLevel\":99,\"wheelWidth\":0.0,\"modEngineBlock\":-1,\"modDial\":-1,\"modRoofLivery\":-1,\"windows\":[4,5,6,7],\"modArchCover\":-1,\"modTurbo\":true,\"dirtLevel\":1,\"modFrontBumper\":-1,\"modHood\":-1,\"modBackWheels\":-1,\"modTank\":-1,\"pearlescentColor\":5,\"modTrunk\":-1,\"wheelSize\":0.0,\"color1\":164,\"tyres\":[],\"modSmokeEnabled\":true,\"modVanityPlate\":-1,\"modHorns\":-1,\"modRoof\":-1,\"windowTint\":1,\"interiorColor\":99,\"modSideSkirt\":-1,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modRightFender\":-1,\"neonEnabled\":[false,false,false,false],\"modGrille\":-1,\"modFrontWheels\":-1,\"tyreSmokeColor\":[254,254,254],\"modCustomTiresF\":false,\"modAirFilter\":-1,\"modAPlate\":-1,\"modWindows\":-1,\"modSuspension\":-1,\"modSpeakers\":-1,\"modNitrous\":-1,\"modSubwoofer\":-1,\"livery\":-1,\"modExhaust\":-1,\"modHydraulics\":false,\"modLivery\":-1,\"modFrame\":-1,\"wheels\":0,\"bodyHealth\":1000,\"doors\":[],\"color2\":120,\"modCustomTiresR\":false,\"extras\":[0,0,null,null,null,null,0],\"driftTyres\":false,\"modStruts\":-1,\"modSpoilers\":-1,\"modTrimA\":-1,\"plateIndex\":4,\"modSeats\":-1,\"modEngine\":-1,\"modOrnaments\":-1}','05JEV483',NULL,NULL,100,1000,1000,0,0,NULL,NULL,NULL,NULL),
(7,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','Z64O720C','volatus','-1845487887','{\"model\":-1845487887,\"modLightbar\":-1,\"bulletProofTyres\":true,\"modAerials\":-1,\"paintType1\":0,\"modDoorSpeaker\":-1,\"modBrakes\":-1,\"modFender\":-1,\"dashboardColor\":0,\"wheelColor\":156,\"modPlateHolder\":-1,\"oilLevel\":8,\"tankHealth\":1000,\"modTrimB\":-1,\"plate\":\"83APY761\",\"modRearBumper\":-1,\"modArmor\":-1,\"engineHealth\":1000,\"xenonColor\":255,\"paintType2\":0,\"modXenon\":false,\"modDashboard\":-1,\"modTransmission\":-1,\"modHydrolic\":-1,\"neonColor\":[255,0,255],\"modDoorR\":-1,\"fuelLevel\":100,\"wheelWidth\":0.0,\"modEngineBlock\":-1,\"modDial\":-1,\"modRoofLivery\":-1,\"windows\":[],\"modArchCover\":-1,\"modTurbo\":false,\"dirtLevel\":0,\"modFrontBumper\":-1,\"modHood\":-1,\"modBackWheels\":-1,\"modTank\":-1,\"pearlescentColor\":62,\"modTrunk\":-1,\"wheelSize\":0.0,\"color1\":73,\"tyres\":[],\"modSmokeEnabled\":false,\"modVanityPlate\":-1,\"modHorns\":-1,\"modRoof\":-1,\"windowTint\":-1,\"interiorColor\":0,\"modSideSkirt\":-1,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modRightFender\":-1,\"neonEnabled\":[false,false,false,false],\"modGrille\":-1,\"modFrontWheels\":-1,\"tyreSmokeColor\":[255,255,255],\"modCustomTiresF\":false,\"modAirFilter\":-1,\"modAPlate\":-1,\"modWindows\":-1,\"modSuspension\":-1,\"modSpeakers\":-1,\"modNitrous\":-1,\"modSubwoofer\":-1,\"livery\":-1,\"modExhaust\":-1,\"modHydraulics\":false,\"modLivery\":-1,\"modFrame\":-1,\"wheels\":0,\"bodyHealth\":1000,\"doors\":[],\"color2\":0,\"modCustomTiresR\":false,\"extras\":[0,0,null,null,null,null,0],\"driftTyres\":false,\"modStruts\":-1,\"modSpoilers\":-1,\"modTrimA\":-1,\"plateIndex\":0,\"modSeats\":-1,\"modEngine\":-1,\"modOrnaments\":-1}','83APY761',NULL,NULL,100,1000,1000,0,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `player_vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `players`
--

DROP TABLE IF EXISTS `players`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(10) unsigned DEFAULT NULL,
  `citizenid` varchar(50) NOT NULL,
  `cid` int(11) DEFAULT NULL,
  `license` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `money` text NOT NULL,
  `charinfo` text DEFAULT NULL,
  `job` text NOT NULL,
  `gang` text DEFAULT NULL,
  `position` text NOT NULL,
  `metadata` text NOT NULL,
  `inventory` longtext DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_logged_out` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`citizenid`),
  KEY `id` (`id`),
  KEY `last_updated` (`last_updated`),
  KEY `license` (`license`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `players`
--

LOCK TABLES `players` WRITE;
/*!40000 ALTER TABLE `players` DISABLE KEYS */;
INSERT INTO `players` VALUES
(1,1,'Z64O720C',1,'license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','androxa','{\"crypto\":5000,\"bank\":4915669,\"cash\":765}','{\"lastname\":\"Medvedev\",\"phone\":\"9722686262\",\"cid\":1,\"birthdate\":\"2002-04-03\",\"account\":\"US05QBX8831447891\",\"nationality\":\"Bulgarian\",\"gender\":0,\"firstname\":\"Artem\",\"backstory\":\"placeholder backstory\"}','{\"type\":\"leo\",\"onduty\":true,\"payment\":150,\"name\":\"police\",\"bankAuth\":true,\"isboss\":true,\"grade\":{\"level\":4,\"name\":\"Chief\"},\"label\":\"LSPD\"}','{\"isboss\":false,\"name\":\"ballas\",\"bankAuth\":false,\"grade\":{\"level\":1,\"name\":\"Enforcer\"},\"label\":\"Ballas\"}','{\"x\":-236.91427612304688,\"y\":-1062.2637939453126,\"z\":26.12890625,\"w\":345.8267822265625}','{\"status\":[],\"bloodtype\":\"B+\",\"isdead\":false,\"ishandcuffed\":false,\"armor\":0,\"tracker\":false,\"licences\":{\"driver\":true,\"id\":true,\"weapon\":false},\"health\":200,\"inlaststand\":false,\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":90482404},\"criminalrecord\":{\"hasRecord\":false},\"phone\":[],\"thirst\":136.19999999999983,\"stress\":0,\"injail\":0,\"craftingrep\":1000,\"jailitems\":[],\"inside\":{\"apartment\":[]},\"attachmentcraftingrep\":0,\"hunger\":95.79999999999927,\"walletid\":\"QB-48065307\",\"fingerprint\":\"E9JK31PD26VYT35\",\"callsign\":101,\"jobrep\":{\"trucker\":0,\"taxi\":0,\"tow\":0,\"hotdog\":0},\"dealerrep\":0}','[{\"name\":\"phone\",\"count\":1,\"slot\":1},{\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":30,\"serial\":\"540479XKW125722\",\"durability\":99.46},\"name\":\"WEAPON_SPECIALCARBINE_MK2\",\"count\":1,\"slot\":2},{\"metadata\":{\"citizenid\":\"Z64O720C\",\"lastname\":\"Medvedev\",\"nationality\":\"Bulgarian\",\"sex\":\"M\",\"badge\":\"none\",\"birthdate\":\"2002-04-03\",\"firstname\":\"Artem\",\"cardtype\":\"driver_license\",\"mugShot\":\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAADYBJREFUeF7tm99v29YVx78WLZkKI1WyXDqOPDdeXDta3XROg2btuocFGIq5cZdm2MvQAQOKYQNaFGj32pf9Ad3DkGLYQ7HH9SnomtZpMMwPQ1DAyFb3hwsnrj03rmXZimgylBnRpOgM515eUlKc9IfozsN6AIHiL/mez/2e++Pc6w4At/B/bB3fAPhGAd+EwH+lDRh7qMBanvS+BDvOf3KNHUsV42ttkb62NmBs7CEc++5RjD04EDg48/4cYrdcdj5yP7+uX7cxt7CEuU+W2HG3bVcBPHS0gOMPHwc5H1hd3xGAuKhm1OA+ATh3YWpXGewaAHL+F8+cgSxnQ4dnPgA8q8khoQAWBgvLyGVyTffX1kp4d2Zu1yDsCoAzTz+BwpEhVuhkS9H1TRvFUim4amolaBtV5LpT7Jrcyd8ob3ClpLtllNYNzHy4O+EQOQByvFA4HACwDB2aETZsak9fAGBltYR0FxgATTeRy6ahVy2o2QyHoBtQ9svo683sGoRIATz+yCjUfJ45P3dlgR2XP11iAHKZDDuaN2pNmnCtKjsnAGSxTonVvtqdZcdkl4wDvTyM1tZ1BiJKiwwAOT+QVzF4hHdvZARBkaUmBQgAxdU19oy07QXPVzZMoLPZPcOwmQKE7TkAmUwGfb09GDs6zMsoy0FhrxfXEO/ip4bGa9gjJ6nGN/3G0LLZecXlIBKSBNMLoWQ7JdTqDpKdfLxQEu9FJIO2FCBJElKpVBOA6xqXaLnIGzqnzp0RAEgRwirkTB3oiUu3AUj7IGTw9wkAgTBsPm6IytoCQIUgBRw7OhKUR+rkDhIABqEzVEQml4Zrhd0gAejpCJ0nEOZ2s2sSldA33bZg16Nynf9OWwBkWcbgff3o6w37bm29HNQ++wudMshxYYNphX3VqhxEbtMPCZd77nix4Nmqtw1PisGu81rfkwoY+w7v72fmF9hx0G8DCvfz6yThvnx/WG0N8U0XvXqoiHKlDDnJG7w10UimFCx8thK8v2TwNiMqa0sB1GKPDYcA6HtfF5d8YYhfz3aHLTgDEg9Dgp13uCDHhVl+Yxic+yGzuFJkl0rVGmY/5d+jsPYA0Nt+m0bOHxs+jEycj+QKQ4d5+ZLNDsNvwwxdY7cJQKPdVr82Hzcs+AAM28bs0kpkENoDQCXz++2zLz7HHWpo9KIEICDZdY7o5T+fi0IA7TWCogRjI0N49qknbitQojOOWFJCohGKJ8Hb4rXubTmw0VznckyCveWw+/aWC2+btxGuw6+JXuX1v1/C7L+X24bQvgIANAIgp526CzrGOxOQknRMwq37Q2CPx4yAgI5w0EPXE/BQc9wAglu34LgcGIPgw9xTAKj2CQJzoDMe1EojAKECkjDVvACQSITdHjkqAHAFOECHC9d1Qgjb/HmqfYLQrkWigJ0AkPOJeBwxmTeKBMCp26DevhEAKYCeE7XcqgACwGrfh+DuSQBPT2DsCJ8LuK4NVe27Y8XURCiIJ2p379fFXa3Cew2pztuCvaWABgDZbJgB2okCAVgrhv34ge7mDFDrO414CMKeB0AKYDX08QzUew8gl+vDe+/PBH7Zm2FOkEaIjsMbQZElyjTMJkePjmJtw0ClomHEV9ieBjBzZR5qKh6EQLlcgtMyeVta4Pk9MTwWAASE4fvCrDFd247zaTAZgdiOxTD67YG9FQLHjwzjN09P4J9X5tE/NAzdT4EZhg5zq1nUOb/fX/6M5/ioV8jn88FDmscnS8JySgggnUrB9keQ780vBvOPnULti16LpBcgAMcLI6DjXMUAOS4gbEvhUNjZsjGQCs8HBgZRvalhZTWc7BRvbEPezxOkZAkvbAVS6TQSfiO4JwD8/AeP4eTjj7KaJ+fJ7gSAnCdrBZDOypi+PH2bAuxNnitMJ+Mwq3zKnE6lkdsXAhy7fwhTl97FucthG/NFa14815YCHj8yjNECT4a0AqBrmUwWy+s6rKqBRJeMfakM0lsGqObJ7hsYhF4toej3CqQE794R2JsmjLUiU4JQAEFoBUC/MTs3j+nFr54ybwvA2KFBHB8dQr8fwyvFIvrzvBEz/bw+ZYg0g/fhZHI2h6VSEScffgSDB/th2yVcWy3j0r9mMdCnwvNXKjWDK6AvlYGu8zRbNpuBtmlCVXvYeblcwdXlImbaWEJrCwAV4ne//iW443nWmFVvcqmbusEgNAKgVR+rAxg8mGfOkwkA9H15tXwbALnOHWeK6s6gat8MnKcvr0+1NxxuG8CvTv2IFUgAgD/0pWvVDR2pDrlJAZISxnCjAoRCqn6WWJzHboVzCxpkUa9Rvq6x2t8TAMbHCsjn+5sAFP2YzB8exDytB1LuL5NjH8Pl09udFEDXE/EENMNExeAN38ihISwtLrHabwRA92Y/voqpj9pbN2xbATQLPDZyOJgNyqnmFJioSXF0TQ5AuSfNPrZtw9QqMDV/rN8pQU7xsYBNidN4OC6wqiachsXVc/+Yxty19tJjbQOggopkCMGwHQdyMiy0vM93xuQNmX3DhjqQZ87zNiAEQBCyvXx5nCAQAMvmQ2XL5I1iXOHTYXKcALRrkQJg0u7NgZwWEOi7LZyv6lBSauA8c8xPiwsFmOsakikFsp8+JwDkPNU+WWkrzCLvGQAiDHYCAD+nb1d1BiKXH4Z1owrlnhQ76pVwqTydy4EAkBEEMi8h7whg7tpK2/Kn349EAfRDZ75/AoWBPJLpNOQ4b7nleAJWTIJn8drbtkysrBah6Rpy2Rw7mg0rPWo2B9WveckPI++WB9d14TgOO9JKA9lrf4tm50hkAMh5gkAAuPMcAuUHhUlKGubyArQNXsvzi1eh1wG1mw9sCEBfrwppnwLvpgWvZsGVJOa8MNflOcU9D0BAIADkOJm0LwX9ykwAoFEBrPa7c5AP8GzSds2Co5VhtawkEYCl9TKmPpwNoLTzJTIFBGEwfBjJBJ/Ckgq8Lp4TpDCgEKjZdgCArlsti50UAomcilhSgauVYTt2oAARAnsWwLM/fAypAyp6ehrSXPUadM2A4S+by/Hwnr1RhqM0z/8TnXwoTavOZGIhxPT3BViGienFIor+PoN2ap/ejVQBJx8YRv6gilwPj2myajlc98vkMoDUB1vn1+SsCrteg1nhu0WYIjbDXoHOlUy4slzdtBCre3sXwKCaQyFPAMJaTmxvQ/dnhszpapjgSHar0Gq8hzCv+47vD/eVZbIZbHdKSO1XQM6TCqybDgMQlUWqACoUzQ3IBATLT2dnu7MgBdimxGpeGCmAAaisoVopIebPlQx/CiwWV9P7FQbgalGLTP6RhwD94HC+DyP5A4GDGSXRJGN73d//50+Hy9f4vgIGobSCRG8/UoqCqmXBtCw44Y4a9szsYgm0QhyVRa4AKtjEI2OfC8Bc5TIWChAv3A3ApY+/eubnTsB2HUDctZkCRGOWkBSYDUlQ219HEAWM+yPAVgUsX9exXI52j+CuhIBQAIXCfLEEAkCmHuqHkklB3t+8bEazwSAE1laQqLtM+o0ABtQMc/5/RgEvPHMmcGrlA56xzfaoyPSoyPY3L3zQwEhYmdqAuITi4jxvEzYqsFIqToyOYHr2KqY/4tejtF0JgUYA8S0XS1f4sJUgOJ6H3MF+aH4YyA1rg9epXfB3gJDz6e4eDIyEO0//8JfzUfrOfityACeOFkAfYWoqC71SDiAoWT5G0FaLyB3Mo9qogNUVyP6Wm/xhnm7PqmGXuRsqiAzA4KFBnPzhSZwsHMD0h2GejgCQEQSjUkbps+ZtLYa/CSoApvYglc0h7StDbLyk+yceHMZ7OnD+zfOYvxpNOEQG4OzZs8wH+docWxoT5km8I7ccF5brADULhj8d1nUNRsPm8QzlEpQYlKQCxU+lSR6fTiuKAvVeFe7gKDt/8YUXIwmHtgGMj4/j7Kvc+cm3J5FdXwrWBUUJmeM+hIQUAzkuzNBb/oOkC4Hz9MxOAJ74Md+QRRAuXrjYFoivDGB8fAJnX/0TDWUC51nMtgAg5xXKDPkQ3Ib5PQPhSTBMPh8gBXgST4KSCqyadVcA9NzUhYt4vg01fGkA5Dj7PHnKJ387AOraGvv3RiXcCQA5T0YAyHmmGB8AyZ8+ZIkHTkAogM7FMsvkhYuYvPAO6Phl7HMBiI2P46fGMf7kOMZP/xT2TQuG5k9zG/YAzr3xGpwtF+6Ww47coXAXmEubn90aLH/5zKo1g6LN1+lkuB/AIdX4CRP61xn6SPuzeOxnzwY+1uwaCxk1x3uLv749iYuTk3hncpKdi3zCnaB8LoAzp8/g7B95jJMZN6oMQGB3AED3CYIAQP8IQWMA2+bvEoRGAOQ8GQGIJ+Jw/a0lTs1hjtOHrBVALBYCZu/7IOj7S889jzfevPuO0h0BTEycxsTET3Bq4jRtUm+CJwCwfD+BaACwcnkK1eJSoAKmgJb/S/W2XVg1rgIC0GgEQekKp38EIe4riENIQvlWASPfOxm8RgAsv0JICY0A6CEaV7x1/i2cP3+efVotADA8MoyJpybw25debnlmZwA7KcAsLqF4eSqQP4UCAYjHQqdIkjsBIOeTshwMhMS+QXheUPsEYODRcfT08/0FZBQCwu4EoNGhV37/StM44j/2GQJqv+jDggAAAABJRU5ErkJggg==\"},\"name\":\"driver_license\",\"count\":1,\"slot\":3},{\"name\":\"water\",\"count\":3,\"slot\":4},{\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":12,\"serial\":\"917074NJK371628\",\"durability\":96.80000000000018},\"name\":\"WEAPON_COMBATPISTOL\",\"count\":1,\"slot\":5},{\"name\":\"money\",\"count\":765,\"slot\":6},{\"name\":\"ammo-9\",\"count\":82,\"slot\":7},{\"name\":\"ammo-rifle\",\"count\":52,\"slot\":8},{\"name\":\"copper\",\"count\":33,\"slot\":9},{\"name\":\"iron\",\"count\":32,\"slot\":10},{\"name\":\"burger\",\"count\":5,\"slot\":11},{\"name\":\"water\",\"count\":1,\"slot\":12},{\"name\":\"burger\",\"count\":1,\"slot\":13},{\"name\":\"lockpick\",\"count\":2,\"slot\":14}]','9722686262','2025-04-14 11:06:25','2025-04-14 11:06:25');
/*!40000 ALTER TABLE `players` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `playerskins`
--

DROP TABLE IF EXISTS `playerskins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `playerskins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `skin` text NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`),
  KEY `active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `playerskins`
--

LOCK TABLES `playerskins` WRITE;
/*!40000 ALTER TABLE `playerskins` DISABLE KEYS */;
INSERT INTO `playerskins` VALUES
(4,'Z64O720C','mp_m_freemode_01','{\"props\":[{\"drawable\":-1,\"prop_id\":0,\"texture\":-1},{\"drawable\":5,\"prop_id\":1,\"texture\":8},{\"drawable\":-1,\"prop_id\":2,\"texture\":-1},{\"drawable\":-1,\"prop_id\":6,\"texture\":-1},{\"drawable\":-1,\"prop_id\":7,\"texture\":-1}],\"hair\":{\"texture\":0,\"color\":11,\"style\":86,\"highlight\":29},\"eyeColor\":2,\"headOverlays\":{\"blemishes\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"beard\":{\"secondColor\":0,\"color\":7,\"opacity\":1,\"style\":10},\"eyebrows\":{\"secondColor\":0,\"color\":5,\"opacity\":1,\"style\":1},\"sunDamage\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"chestHair\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"ageing\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"makeUp\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"lipstick\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"blush\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"complexion\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"bodyBlemishes\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0},\"moleAndFreckles\":{\"secondColor\":0,\"color\":0,\"opacity\":0,\"style\":0}},\"headBlend\":{\"shapeThird\":33,\"thirdMix\":0.2,\"shapeMix\":0.3,\"skinSecond\":12,\"skinFirst\":14,\"skinMix\":0.8,\"shapeFirst\":12,\"shapeSecond\":4,\"skinThird\":0},\"tattoos\":{\"ZONE_RIGHT_ARM\":[{\"label\":\"Armored Arm\",\"hashFemale\":\"MP_Sum2_Tat_045_F\",\"zone\":\"ZONE_RIGHT_ARM\",\"name\":\"TAT_SB_045\",\"hashMale\":\"MP_Sum2_Tat_045_M\",\"opacity\":0.1,\"collection\":\"mpsum2_overlays\"}],\"ZONE_LEFT_ARM\":[{\"label\":\"Demon Drummer\",\"hashFemale\":\"MP_Sum2_Tat_049_F\",\"zone\":\"ZONE_LEFT_ARM\",\"name\":\"TAT_SB_049\",\"hashMale\":\"MP_Sum2_Tat_049_M\",\"opacity\":0.1,\"collection\":\"mpsum2_overlays\"}],\"ZONE_HAIR\":[{\"label\":\"hair-0-186\",\"hashFemale\":\"FM_F_Hair_003_a\",\"zone\":\"ZONE_HAIR\",\"name\":\"hair-0-186\",\"hashMale\":\"FM_M_Hair_003_a\",\"collection\":\"multiplayer_overlays\"}]},\"model\":\"mp_m_freemode_01\",\"faceFeatures\":{\"noseBoneHigh\":0,\"chinHole\":0,\"chinBoneLowering\":0,\"noseWidth\":0,\"eyesOpening\":0,\"neckThickness\":0,\"eyeBrownForward\":0,\"lipsThickness\":0,\"eyeBrownHigh\":0,\"nosePeakLowering\":0,\"cheeksBoneHigh\":0,\"chinBoneSize\":0,\"cheeksBoneWidth\":0,\"cheeksWidth\":0,\"jawBoneWidth\":0,\"nosePeakHigh\":0,\"jawBoneBackSize\":0,\"noseBoneTwist\":0,\"chinBoneLenght\":0,\"nosePeakSize\":0},\"components\":[{\"drawable\":0,\"texture\":0,\"component_id\":0},{\"drawable\":0,\"texture\":0,\"component_id\":1},{\"drawable\":86,\"texture\":0,\"component_id\":2},{\"drawable\":0,\"texture\":0,\"component_id\":3},{\"drawable\":32,\"texture\":15,\"component_id\":4},{\"drawable\":0,\"texture\":0,\"component_id\":5},{\"drawable\":22,\"texture\":3,\"component_id\":6},{\"drawable\":294,\"texture\":3,\"component_id\":7},{\"drawable\":15,\"texture\":0,\"component_id\":8},{\"drawable\":0,\"texture\":0,\"component_id\":9},{\"drawable\":0,\"texture\":0,\"component_id\":10},{\"drawable\":259,\"texture\":0,\"component_id\":11}]}',1);
/*!40000 ALTER TABLE `playerskins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `properties`
--

DROP TABLE IF EXISTS `properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_name` varchar(255) NOT NULL,
  `coords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`coords`)),
  `price` int(11) NOT NULL DEFAULT 0,
  `owner` varchar(50) DEFAULT NULL,
  `interior` varchar(255) NOT NULL,
  `keyholders` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT json_object() CHECK (json_valid(`keyholders`)),
  `rent_interval` int(11) DEFAULT NULL,
  `interact_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT json_object() CHECK (json_valid(`interact_options`)),
  `stash_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT json_object() CHECK (json_valid(`stash_options`)),
  `garage` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`garage`)),
  PRIMARY KEY (`id`),
  KEY `owner` (`owner`),
  CONSTRAINT `properties_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `players` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `properties`
--

LOCK TABLES `properties` WRITE;
/*!40000 ALTER TABLE `properties` DISABLE KEYS */;
INSERT INTO `properties` VALUES
(1,'Richard Majestic Apt 1','{\"x\":-936.1500244140625,\"y\":-378.9100036621094,\"z\":38.95999908447265}',0,'Z64O720C','RichardMajesticApt2','{}',NULL,'[{\"coords\":{\"x\":-900.27001953125,\"y\":-368.6499938964844,\"z\":113.06999969482422},\"type\":\"logout\"},{\"coords\":{\"x\":-903.7899780273438,\"y\":-363.989990234375,\"z\":113.06999969482422},\"type\":\"clothing\"},{\"coords\":{\"x\":-1452.25,\"y\":-522.8900146484375,\"z\":56.93000030517578,\"w\":33.88000106811523},\"type\":\"exit\"}]','[{\"slots\":50,\"coords\":{\"x\":-928.0399780273438,\"y\":-377.2200012207031,\"z\":113.66999816894531},\"maxWeight\":150000}]',NULL);
/*!40000 ALTER TABLE `properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `properties_decorations`
--

DROP TABLE IF EXISTS `properties_decorations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `properties_decorations` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `model` varchar(255) NOT NULL,
  `coords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`coords`)),
  `rotation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`rotation`)),
  PRIMARY KEY (`id`),
  KEY `property_id` (`property_id`),
  CONSTRAINT `properties_decorations_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `properties_decorations`
--

LOCK TABLES `properties_decorations` WRITE;
/*!40000 ALTER TABLE `properties_decorations` DISABLE KEYS */;
/*!40000 ALTER TABLE `properties_decorations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `userId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `license` varchar(50) DEFAULT NULL,
  `license2` varchar(50) DEFAULT NULL,
  `fivem` varchar(20) DEFAULT NULL,
  `discord` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'androxa','license:7b8f7bc668c9006616d7cb66d081d22ca2fc6f17','license2:266e0bdda3f98a56fca20f8bc4251d75a2819f41','fivem:15385361','[REDACTED]),
(2,'^7gos^2khowebrat^1','license:1a65df77e516a1705fa5aeaa371e0d8e366c3f92','license2:1a65df77e516a1705fa5aeaa371e0d8e366c3f92','fivem:16011778','discord:1333545939390173204'),
(3,'smiley','license:df7a62b642995e132f5e4605675825c983f9f2cc','license2:df7a62b642995e132f5e4605675825c983f9f2cc','fivem:15830130','discord:1082296086196133899');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicle_financing`
--

DROP TABLE IF EXISTS `vehicle_financing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `vehicle_financing` (
  `vehicleId` int(11) NOT NULL,
  `balance` int(11) DEFAULT NULL,
  `paymentamount` int(11) DEFAULT NULL,
  `paymentsleft` int(11) DEFAULT NULL,
  `financetime` int(11) DEFAULT NULL,
  PRIMARY KEY (`vehicleId`),
  CONSTRAINT `vehicleId` FOREIGN KEY (`vehicleId`) REFERENCES `player_vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicle_financing`
--

LOCK TABLES `vehicle_financing` WRITE;
/*!40000 ALTER TABLE `vehicle_financing` DISABLE KEYS */;
/*!40000 ALTER TABLE `vehicle_financing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weed_plants`
--

DROP TABLE IF EXISTS `weed_plants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `weed_plants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property` varchar(30) DEFAULT NULL,
  `stage` tinyint(4) NOT NULL DEFAULT 1,
  `sort` varchar(30) NOT NULL,
  `gender` enum('male','female') NOT NULL,
  `food` tinyint(4) NOT NULL DEFAULT 100,
  `health` tinyint(4) NOT NULL DEFAULT 100,
  `stageProgress` tinyint(4) NOT NULL DEFAULT 0,
  `coords` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weed_plants`
--

LOCK TABLES `weed_plants` WRITE;
/*!40000 ALTER TABLE `weed_plants` DISABLE KEYS */;
/*!40000 ALTER TABLE `weed_plants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xt_prison`
--

DROP TABLE IF EXISTS `xt_prison`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xt_prison` (
  `identifier` varchar(100) NOT NULL,
  `jailtime` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`identifier`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xt_prison`
--

LOCK TABLES `xt_prison` WRITE;
/*!40000 ALTER TABLE `xt_prison` DISABLE KEYS */;
INSERT INTO `xt_prison` VALUES
('Z64O720C',0);
/*!40000 ALTER TABLE `xt_prison` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xt_prison_items`
--

DROP TABLE IF EXISTS `xt_prison_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xt_prison_items` (
  `owner` varchar(60) DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  UNIQUE KEY `owner` (`owner`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xt_prison_items`
--

LOCK TABLES `xt_prison_items` WRITE;
/*!40000 ALTER TABLE `xt_prison_items` DISABLE KEYS */;
INSERT INTO `xt_prison_items` VALUES
('Z64O720C','[{\"name\":\"money\",\"weight\":0,\"stack\":true,\"count\":500,\"close\":true,\"metadata\":[],\"label\":\"Money\",\"slot\":1},{\"name\":\"phone\",\"weight\":190,\"stack\":false,\"count\":1,\"close\":true,\"metadata\":[],\"label\":\"Phone\",\"slot\":2},{\"name\":\"id_card\",\"weight\":0,\"stack\":true,\"count\":1,\"close\":true,\"metadata\":{\"sex\":\"M\",\"citizenid\":\"Z64O720C\",\"badge\":\"none\",\"firstname\":\"Artem\",\"mugShot\":\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAAAXNSR0IArs4c6QAADWhJREFUeF7tm01sG8cVx/8yRXppivTSK20kk6FC2JXsQkCg9EORY+fDQBugbYLGuRQFWrTIoQUKpIecCuSYYy8N0FuDHgoUAYqkKAK0yKEKgrq2CTRx3apRpEilooimRInheqUNV0tSLt68meWSVZxGXBkKmgcISy53qXm/+b/ZNzOPfQBu4//Y+j4H8LkCPg+BuzoG5Ad1MeJkRgbFMXUsKo7ldUscLc8Tx+LN6l0Zme7KGHA6Y+JUxhQOTYznUFprO5eIR3xHy+s1jJhpCWATM28tHDiEAwWQP2lgLDsCAqBMG9A6nLJuWRi+R8eaVEB3QM6+V0bh3eKBgTgQAOT4xS+Ni0Zr/ezwYqniKyDoDQHosK6ArFl1lDasA4MQOoCRQR2XHnvA98kFYG+5SCU1rJZqSA/EkUxp4n2pZOHIbcDadsT1+kAC1W0bqYGEf39Ki6B4cxPFcvVAxoVQAeSzJu4/lUHGTKNUqQknovG4ONp2HdlMGuXVGlJJhkBWKrXHAwKRGTZgbzvIDptYXasgO5gSAMgOYkwIDQA5f3F6AtVKDasbLOvskI56gzuTnFcKsLfqAoIAs+UIBdw3bGJ5rSIAiPNSFQ3PQ/4kPzFm3poPXQWhASDnCUIQADU6FuGeTib5GLkN4TxBYNtFsVxBfoQHSmvb9uVPL7QYPyaVha2CUADkhg2cn+RBb3m1jPqOB3engXQqgWifhkRCQ6ViwTR1aDr3vGWxoxpassddpAY0WDUXjswF6ANnp4HE0SgSsRgqW44/mHZQ6eFNaAByIyxdx3EQPxoTEESPt2ICAP05jgvb4wFP2a7LMaIUsvZh5+fqOoJAMNTTpAefO24NBcD5yTHxpSvlKhJH24mNOLnD7xUAF0r6sh1NPqYGWBmVbf48cTTGQHc88ZoAkM3frMJ16dkSjvUMgORPvU/Oc8PZYXfHg0ZO7ER858X5PQCQ87Z0PCIdVw5Tr/P3RlGxHZQ3u/KGHjn0DICe+2dHs5h7f1U0JS8TvftG8+J9fNeFMZLzm1m0uPcWV1bEMR0HMkOBTLHFoVNdXxPHyFEdpVLZv98eSGB2udSj2+3bQwFAX0cQyIY1lmpeAkid4LGBzDg5CtTbIbD0wQoySZZ6aYMzRezyoKisvs3AFIS5Wzx4hgUhNACXHp4SDdO1hO+8OJHkyU3bo84xwLW4p5X9V3S7fP1qia9bq/Mg+fIbhc7v3ee7UABQ7ysAmsbTXd9CAuADajKi53/96j5d7rytZwD0dc88+Tgmx0/73xyLafA8F3Q8clRDLMoyF9b00NphJ+jY3eORSAReg8eBhtdApOnBazbQaPI5yhxYAZcxu8zjSC8WCgByniCQBZ2PRjXQqB6N8rjQaDQ6AIiTffzUiEWj8BoNtNDi62ROQe6S820IhxBAUAEEQFkQQCwWg+d5aNQdXwGRo5pIjclxZUEApISIx71PAATE5hFxpN4nFfRqoShgLwCJBA9+R2LcYAJARkmMZ/NMMaiAbgAqDAgAO65UcBgBPPUEJs9wNtio2zBzo4GO6VwBqrsB5wlIV2KI5scnOpXVEmLaMVbAv1fw8p8PiwICANJDXY89OWgpIgSgIpMgOpcaaidJ4po7AKCPrU0GeGgBkAKCJhXsn2q1Osd9d6cz8WntbHXcT0+FoB16BZTmZ0V7Kx/wI6pW65S0FueQMO/lnk/dk0FldVneU4Qr5wTKaU3jSRLfk0H2NIfaoVLA1BfH8OzTT4iGvbNYRmVzAxubnNrOl9/v6EGtCZwe57WD0+NjqLsOlpZ41XdxqdiRFxiGCe32rvhsMG3AoLQ6wgp6e6GI6wu9rxaH8hRQAApzC6jfcoXzFZXbH9dRq7YnMwoAOU+mAJDzZMEAIQBOlUEaJwYZwhAvmB4KAM9cOIeLj077PdwNwBwy4SUNWAEA9fWyUAABOHVmHO5WTfQ8qYCOubEJVKsVkPN0zOppzC/N+xDGxzh0Jr/As82Za2/j1avXO1T2ad70pICLZ8YwMcFynjo7hiAAOjc0aMIZGIJV5YmMbgyjUVny5d8NgD5ImuwYmQBwPIX5pfYOkQKgrpldKKLQQyj0BGDydB7nzvAcYCST4TZ5PKrXNnmBxO2LoLzBr0eGDGi3WzCGTAyaJgzThOvWUJxb8K+vUotoEK3x406XK0Y+lWQCI+YgyhVeKl9eKeHK4v7Hgp4AUANe+NEPUC6VfAB6imeD1mZVOEUAlI2YBo7wmNYBoLZRFdeTLVY7N0W9DQaRP8NKcxs8SigAv53pLRnqGcBPvvU17t1MBsOZDOKBxxadr9dqWJMKGB4ysHu7DUQpgAAoaPbtzrwg2scpdHpQLqw0XaGoQwPg0uRZjGSydwTgS4AWfD4GAClAHzTgykmPf4/cW/TfSwD0/vq/5jHzz7ng13/q1z0rYHJ8DA+Mj4OOZJrcABFydRxoifY+n3vLQkTGeOK4jsTxNNztGuyaBdtiqUf6E9AGUnDVBokmY0a65lrtyUMYawI9A6B2PfMkJ0EEwQ2kwuR8NwDXrsHM5YXzAlIAgG1ZiGspaANJH4Kzw5mkY3OKnUoa/kLIIZoOMwCyvJEUTgedp54Xzt6qIaGnQb2vzLHbqfLqchFoAvEBhiAc37GE884tniNU5XoAvT40AFQYdAMQLZYxTc4TCGM0D4dAHE+LY81qA0jpOuxNSwBQ1oq29gQwW1w5PEti1FhaFD07mkEsmkJUbmjSWqCnRdCQ8ext26iuV1GtVmEYhjg6gVFfT6eRNYeF7xFNQ8t10ZKLoI7cQms0+Snx0p9mfEi9vAhlDKAGkPMEIQiAzjf6eEUnKnt15cYNv70LCwsi99dPcEgQgNHcfeI1OS/CxuVlcK/Jg+FnBgCt6JISCIByPpZMojY3J3pexHNAAeR8+oQOfXBEfLbr1uFZFhwZQrH+IwICASiuVTBznafdvVpoCmiHwSmxDK7CALIQgsJAhYBqdDcAOj+S0hHTWREEgNaJu3v/0AL47oVJZO8dhWm0t8Ncty6e877TTjsTrFsVxGWdoH+BzJV1CcENzAXsbRuOVUVhqYTSh50rT/tVQqgKIACxRALmCS5pIbPX5J4fPcNP6KgGAGi6CQ01WJX2NTW7cy6Q0A2kBlIg57e2t3Ck6R1eALlBHRP5kQ4FaN4ubDmzE4Navb3koaVNuA5ngD4EWSdA5/S0jt3+9q6SUMBHDCAsC1UB1KhvfOWsaJsKAwUge4rn+aQA6nllQQXUaBVJ1hdYKmzimq8Aume+VA1N/vR9oQMIlsXSP0gnUkjqOkSSQ6luJLBPSNPa9xc7OtPdpWqShCi1oT+1I6guml0uwzpMFSJ7SfHxr074pxUAdaKxzvFu32QZW8325MYYyUIBoM8qlUoHgMsHUDIbugKo4UEAkUYLKT0tVECmAPghIJ8Y1TUGEonz7LFbASubNayEXB5zICGgAFAoUEVXEACFgTbQtXMk5Vxd4xKbRrPhO69CIDekY2XDwmdGAd/5+nlMnMphdmkFdpl7Vj9hIG0YiGopDGba22H17XaOUCmvItYXEWPFlsXrBFHDwOmTJhZvVvD6W+Fkf8GwPZAQUADoH5XXqyi+x6u6BCGCCIxMDtUS7xxp6fbUeIPGhUbLT5xSaR2ZLKfGZL98LZwJ0F0FUG8CVrUNAXW3A0BMFlFVbnIIaP28FZbJ58WTA3I2+JkAQPVB3354QshfGQEgIwi1ahVWqTOJsbr2xwkAOU/WDYDOvfTG23ADYRPszf28DjUEfvzUE8gPJ9FwXUQ13gRVubzjuqA/NFwU5TYYfU6lMbbNqz2pVBLHjicQjyegHZNribJQkj43DROL6xX8470ibvSwFxB6CHxZFkcQACp7cuQCJ/2jSH8cjuxlAhDtB/wsj/KBWuekJpbQ2s7TF6hK0XhCALixXBQAyMKAsG8FTE2dw9SD07jy+muiMX97dwG/+tlzAgApwJNOB2dzdJ0nY9qHILcBbNtGKpUCZE2wFk/ApZpAqhaXuQEBQD/wm8Bq0CPfvITCtasoFK7sJwI+fSqsHKcj/dNPAkAKUEZKUADEuED5fuc+iABAziuLKAUcSzCIPQCotuwHxCcrQG5MnJuawvSDUzj30COibSurJfzlagEzb7QfTT//4SVR4kYFTrQiRNbqb3tIhU4tWRDmfOTCoZlhIK+ncYN+XxGTM0CPagObQEKOJ3SMaHG88Ls/+oAuXngMF6ankMtyqe6bhQIK1wooFGQlaeApspdEPhEAOfzcT5/1710J/Obv4wAIqUsIBCDWz3WCVOrm1nl60w2AnI9pGjSNF0woIxT3uJ4AoCD84e9zeOeDdnmtAkDXEoRgfcGLv3gRhb++ecfQ2BPAuelzmH5wGnTstjsB+P5jUzgrfyOoytx2j7ACov0xUerWau7Cqdd9AMEfxBAA+tVIuyawgSi4LI4hxHF9tYxXAvUAQQB0nSmVoNpNBRlXCldw9dpVcew2H0Aul8P5h87j6aeeviOxOwG4P5/B9x6d8is9CQIBIOeVUZ3gXgDIeVJBvJ+vVBDQbPnO0/nnA/Kn9/8LgKBDr/z+FVy+ehkrq5yJ/genaO9bYzjwYQAAAABJRU5ErkJggg==\",\"birthdate\":\"2002-04-03\",\"lastname\":\"Medvedev\",\"nationality\":\"Bulgarian\",\"cardtype\":\"id_card\"},\"label\":\"Identification Card\",\"slot\":3},{\"name\":\"driver_license\",\"weight\":0,\"stack\":true,\"count\":1,\"close\":true,\"metadata\":{\"sex\":\"M\",\"citizenid\":\"Z64O720C\",\"firstname\":\"Artem\",\"nationality\":\"Bulgarian\",\"birthdate\":\"2002-04-03\",\"lastname\":\"Medvedev\",\"cardtype\":\"driver_license\",\"badge\":\"none\"},\"label\":\"Drivers License\",\"slot\":4},{\"name\":\"WEAPON_PISTOL\",\"weight\":1130,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"275422XHI864397\",\"durability\":100},\"label\":\"Pistol\",\"slot\":5},{\"name\":\"WEAPON_PISTOL_MK2\",\"weight\":1000,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"381950MGW750372\",\"durability\":100},\"label\":\"Pistol MK2\",\"slot\":6},{\"name\":\"WEAPON_COMBATPISTOL\",\"weight\":785,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"585171ZDJ870666\",\"durability\":100},\"label\":\"Combat Pistol\",\"slot\":7},{\"name\":\"WEAPON_APPISTOL\",\"weight\":1400,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"698924HWS662467\",\"durability\":100},\"label\":\"AP Pistol\",\"slot\":8},{\"name\":\"WEAPON_STUNGUN\",\"weight\":227,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"serial\":\"132566PHF968252\",\"durability\":100},\"label\":\"Tazer\",\"slot\":9},{\"name\":\"WEAPON_PISTOL50\",\"weight\":2000,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"346068BKO340540\",\"durability\":100},\"label\":\"Pistol .50\",\"slot\":10},{\"name\":\"WEAPON_SNSPISTOL\",\"weight\":465,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"775810PKU815684\",\"durability\":100},\"label\":\"SNS Pistol\",\"slot\":11},{\"name\":\"WEAPON_HEAVYPISTOL\",\"weight\":1100,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"355206GNP515162\",\"durability\":100},\"label\":\"Heavy Pistol\",\"slot\":12},{\"name\":\"WEAPON_VINTAGEPISTOL\",\"weight\":700,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"558308FII945579\",\"durability\":100},\"label\":\"Vintage Pistol\",\"slot\":13},{\"name\":\"WEAPON_FLAREGUN\",\"weight\":1000,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"409799HDX803302\",\"durability\":100},\"label\":\"Flare Gun\",\"slot\":14},{\"name\":\"WEAPON_MARKSMANPISTOL\",\"weight\":1588,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"462420GMP491657\",\"durability\":100},\"label\":\"Marksman Pistol\",\"slot\":15},{\"name\":\"WEAPON_REVOLVER\",\"weight\":2260,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"231026NWK535000\",\"durability\":100},\"label\":\"Revolver\",\"slot\":16},{\"name\":\"WEAPON_REVOLVER_MK2\",\"weight\":2600,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"503776KOQ634514\",\"durability\":100},\"label\":\"Revolver MK2\",\"slot\":17},{\"name\":\"WEAPON_DOUBLEACTION\",\"weight\":940,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"935196JBE223905\",\"durability\":100},\"label\":\"Double Action Revolver\",\"slot\":18},{\"name\":\"WEAPON_SNSPISTOL_MK2\",\"weight\":465,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"101396GCS266579\",\"durability\":100},\"label\":\"SNS Pistol MK2\",\"slot\":19},{\"name\":\"WEAPON_RAYPISTOL\",\"weight\":1540,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"durability\":100,\"components\":[]},\"label\":\"Up-n-Atomizer\",\"slot\":20},{\"name\":\"WEAPON_CERAMICPISTOL\",\"weight\":800,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"602709ITC948325\",\"durability\":100},\"label\":\"Ceramic Pistol\",\"slot\":21},{\"name\":\"WEAPON_NAVYREVOLVER\",\"weight\":4000,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"429329QQV121128\",\"durability\":100},\"label\":\"Navy Revolver\",\"slot\":22},{\"name\":\"WEAPON_GADGETPISTOL\",\"weight\":1750,\"stack\":false,\"count\":1,\"close\":false,\"metadata\":{\"registered\":\"Artem Medvedev\",\"components\":[],\"ammo\":0,\"serial\":\"756016DOF548298\",\"durability\":100},\"label\":\"Perico Pistol\",\"slot\":23}]');
/*!40000 ALTER TABLE `xt_prison_items` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-06-04 17:48:26
