-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.12.0.7122
-- --------------------------------------------------------



-- Dumping database structure for crystalrp
DROP DATABASE IF EXISTS `crystalrp`;
CREATE DATABASE IF NOT EXISTS `crystalrp` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;
USE `crystalrp`;

-- Dumping structure for table crystalrp.ak4y_blackmarket
CREATE TABLE IF NOT EXISTS `ak4y_blackmarket` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `currentXP` int(11) DEFAULT NULL,
  `tasks` longtext DEFAULT NULL,
  `taskResetTime` datetime DEFAULT NULL,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_blackmarket: ~1 rows (approximately)
DELETE FROM `ak4y_blackmarket`;
INSERT INTO `ak4y_blackmarket` (`#`, `citizenid`, `currentXP`, `tasks`, `taskResetTime`) VALUES
	(5, 'TEM43359', 0, '[{"taskId":1,"taken":false,"requiredCount":2,"rewardEXP":1500,"hasCount":0},{"taskId":2,"taken":false,"requiredCount":50,"rewardEXP":200,"hasCount":0},{"taskId":3,"taken":false,"requiredCount":8,"rewardEXP":300,"hasCount":0},{"taskId":4,"taken":false,"requiredCount":20,"rewardEXP":400,"hasCount":0},{"taskId":5,"taken":false,"requiredCount":10,"rewardEXP":500,"hasCount":0},{"taskId":6,"taken":false,"requiredCount":5,"rewardEXP":600,"hasCount":0},{"taskId":7,"taken":false,"requiredCount":20,"rewardEXP":700,"hasCount":0},{"taskId":8,"taken":false,"requiredCount":10,"rewardEXP":800,"hasCount":0}]', '2025-11-16 00:00:00');

-- Dumping structure for table crystalrp.ak4y_dailytasks
CREATE TABLE IF NOT EXISTS `ak4y_dailytasks` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `playTime` int(11) DEFAULT NULL,
  `selectedTask` varchar(50) NOT NULL,
  `taskResetTime` datetime NOT NULL,
  `done` int(11) DEFAULT 0,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_dailytasks: ~0 rows (approximately)
DELETE FROM `ak4y_dailytasks`;

-- Dumping structure for table crystalrp.ak4y_dailywheel
CREATE TABLE IF NOT EXISTS `ak4y_dailywheel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(255) NOT NULL DEFAULT '0',
  `nextRoll` varchar(255) NOT NULL,
  `coinAmount` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_dailywheel: ~0 rows (approximately)
DELETE FROM `ak4y_dailywheel`;

-- Dumping structure for table crystalrp.ak4y_dailywheel_codes
CREATE TABLE IF NOT EXISTS `ak4y_dailywheel_codes` (
  `code` varchar(255) DEFAULT NULL,
  `coinAmount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_dailywheel_codes: ~0 rows (approximately)
DELETE FROM `ak4y_dailywheel_codes`;

-- Dumping structure for table crystalrp.ak4y_multichar
CREATE TABLE IF NOT EXISTS `ak4y_multichar` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `license` varchar(255) NOT NULL DEFAULT '0',
  `charCount` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_multichar: ~0 rows (approximately)
DELETE FROM `ak4y_multichar`;

-- Dumping structure for table crystalrp.ak4y_multichar_codes
CREATE TABLE IF NOT EXISTS `ak4y_multichar_codes` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ak4y_multichar_codes: ~0 rows (approximately)
DELETE FROM `ak4y_multichar_codes`;

-- Dumping structure for table crystalrp.apartments
CREATE TABLE IF NOT EXISTS `apartments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `citizenid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.apartments: ~0 rows (approximately)
DELETE FROM `apartments`;

-- Dumping structure for table crystalrp.av_vehicleshop
CREATE TABLE IF NOT EXISTS `av_vehicleshop` (
  `name` varchar(50) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.av_vehicleshop: ~0 rows (approximately)
DELETE FROM `av_vehicleshop`;

-- Dumping structure for table crystalrp.bank_accounts
CREATE TABLE IF NOT EXISTS `bank_accounts` (
  `record_id` bigint(255) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(250) DEFAULT NULL,
  `business` varchar(50) DEFAULT NULL,
  `businessid` int(11) DEFAULT NULL,
  `gangid` varchar(50) DEFAULT NULL,
  `amount` bigint(255) NOT NULL DEFAULT 0,
  `account_type` enum('Current','Savings','business','Gang') NOT NULL DEFAULT 'Current',
  PRIMARY KEY (`record_id`),
  UNIQUE KEY `citizenid` (`citizenid`),
  KEY `business` (`business`),
  KEY `businessid` (`businessid`),
  KEY `gangid` (`gangid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- Dumping data for table crystalrp.bank_accounts: ~0 rows (approximately)
DELETE FROM `bank_accounts`;

-- Dumping structure for table crystalrp.bank_accounts_new
CREATE TABLE IF NOT EXISTS `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=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.bank_accounts_new: ~0 rows (approximately)
DELETE FROM `bank_accounts_new`;

-- Dumping structure for table crystalrp.bank_cards
CREATE TABLE IF NOT EXISTS `bank_cards` (
  `record_id` bigint(255) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `cardNumber` varchar(50) DEFAULT NULL,
  `cardPin` varchar(50) DEFAULT NULL,
  `cardActive` tinyint(4) DEFAULT 1,
  `cardLocked` tinyint(4) DEFAULT 0,
  `cardType` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`citizenid`),
  KEY `record_id` (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- Dumping data for table crystalrp.bank_cards: ~0 rows (approximately)
DELETE FROM `bank_cards`;

-- Dumping structure for table crystalrp.bank_statements
CREATE TABLE IF NOT EXISTS `bank_statements` (
  `record_id` bigint(255) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `account` varchar(50) DEFAULT NULL,
  `business` varchar(50) DEFAULT NULL,
  `businessid` int(11) DEFAULT NULL,
  `gangid` varchar(50) DEFAULT NULL,
  `deposited` int(11) DEFAULT NULL,
  `withdraw` int(11) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`record_id`),
  KEY `business` (`business`),
  KEY `businessid` (`businessid`),
  KEY `gangid` (`gangid`)
) ENGINE=InnoDB AUTO_INCREMENT=10016 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- Dumping data for table crystalrp.bank_statements: ~0 rows (approximately)
DELETE FROM `bank_statements`;

-- Dumping structure for table crystalrp.bans
CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.bans: ~0 rows (approximately)
DELETE FROM `bans`;

-- Dumping structure for table crystalrp.bbv_blips
CREATE TABLE IF NOT EXISTS `bbv_blips` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=520 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.bbv_blips: ~0 rows (approximately)
DELETE FROM `bbv_blips`;

-- Dumping structure for table crystalrp.blessed_tunershop
CREATE TABLE IF NOT EXISTS `blessed_tunershop` (
  `#` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `plate` varchar(50) DEFAULT NULL,
  `engine` varchar(50) DEFAULT NULL,
  `wheel` longtext DEFAULT NULL,
  `driftkit` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`#`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.blessed_tunershop: ~0 rows (approximately)
DELETE FROM `blessed_tunershop`;

-- Dumping structure for table crystalrp.boombox_songs
CREATE TABLE IF NOT EXISTS `boombox_songs` (
  `citizenid` varchar(64) NOT NULL,
  `label` varchar(30) NOT NULL,
  `link` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.boombox_songs: ~0 rows (approximately)
DELETE FROM `boombox_songs`;

-- Dumping structure for table crystalrp.casino_cache
CREATE TABLE IF NOT EXISTS `casino_cache` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_slovak_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.casino_cache: ~1 rows (approximately)
DELETE FROM `casino_cache`;
INSERT INTO `casino_cache` (`ID`, `Settings`) VALUES
	(1, '{"PodiumPriceProps":{"pearlescentColor":111,"modAirFilter":-1,"plateIndex":0,"engineHealth":1,"modFender":-1,"color1":111,"modArchCover":-1,"modBackWheels":-1,"modTrunk":-1,"extras":{"1":false},"modFrontWheels":-1,"modBrakes":2,"modHorns":57,"modTank":-1,"modArmor":4,"xenonColor":12,"modGrille":-1,"model":819197656,"fuelLevel":1,"modHood":0,"modSteeringWheel":-1,"color2":111,"modExhaust":0,"bodyHealth":1,"modPlateHolder":-1,"modTrimB":-1,"modSeats":-1,"modSuspension":-1,"modWindows":-1,"dirtLevel":1,"modDoorSpeaker":-1,"modAPlate":-1,"wheels":5,"modRoof":2,"modDial":-1,"modSmokeEnabled":1,"modFrontBumper":1,"modSpeakers":-1,"modTransmission":2,"modXenon":1,"modStruts":-1,"neonEnabled":[false,false,false,false],"modSpoilers":3,"tyreSmokeColor":[1,1,1],"windowTint":6,"modLivery":1,"modFrame":-1,"modEngine":3,"wheelColor":111,"modVanityPlate":-1,"modAerials":-1,"podiumName":"SHEAVA","modTrimA":-1,"modRearBumper":0,"modSideSkirt":-1,"modOrnaments":-1,"tankHealth":1,"modRightFender":-1,"modShifterLeavers":-1,"modEngineBlock":-1,"neonColor":[255,0,255],"modHydrolic":-1,"modDashboard":-1,"modTurbo":1}}');

-- Dumping structure for table crystalrp.casino_players
CREATE TABLE IF NOT EXISTS `casino_players` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(128) NOT NULL,
  `properties` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.casino_players: ~6 rows (approximately)
DELETE FROM `casino_players`;
INSERT INTO `casino_players` (`ID`, `identifier`, `properties`) VALUES
	(35, 'WKL81749', '{"firstTime":false,"luckyWheelCooldownUntil":1735587618,"vipUntil":0,"logins":7,"activeTime":331365,"chips":0,"lastSave":3944239,"lastDailyBonus":"12/29/24"}'),
	(36, 'TEM43359', '{"vipUntil":0,"lastSave":19077743,"firstTime":false,"lastDailyBonus":"12/30/24","luckyWheelCooldownUntil":1735757317,"logins":3,"activeTime":18732389,"chips":15460}'),
	(37, 'SXF16791', '{"firstTime":false,"activeTime":1527339,"lastSave":5143525,"luckyWheelCooldownUntil":1735961132,"lastDailyBonus":"01/03/25","logins":1,"vipUntil":0,"chips":9250}'),
	(38, 'MZH23055', '{"vipUntil":0,"luckyWheelCooldownUntil":1736075817,"lastSave":30605483,"activeTime":29805307,"chips":0,"firstTime":false,"logins":1}'),
	(39, 'APB01636', '{"chips":1020,"logins":3,"luckyWheelCooldownUntil":1736338751,"firstTime":false,"vipUntil":0,"activeTime":3376572,"lastSave":3439854}'),
	(40, 'ZDF30906', '{"lastSave":4092930,"firstTime":false,"lastDailyBonus":"01/07/25","luckyWheelCooldownUntil":1736339799,"vipUntil":0,"logins":2,"activeTime":464121}');

-- Dumping structure for table crystalrp.communityservice
CREATE TABLE IF NOT EXISTS `communityservice` (
  `identifier` varchar(100) NOT NULL,
  `actions_remaining` int(10) NOT NULL,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.communityservice: ~0 rows (approximately)
DELETE FROM `communityservice`;

-- Dumping structure for table crystalrp.crypto
CREATE TABLE IF NOT EXISTS `crypto` (
  `crypto` varchar(50) NOT NULL DEFAULT 'qbit',
  `worth` int(11) NOT NULL DEFAULT 0,
  `history` text DEFAULT NULL,
  PRIMARY KEY (`crypto`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.crypto: ~0 rows (approximately)
DELETE FROM `crypto`;

-- Dumping structure for table crystalrp.crypto_transactions
CREATE TABLE IF NOT EXISTS `crypto_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `message` varchar(50) DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.crypto_transactions: ~0 rows (approximately)
DELETE FROM `crypto_transactions`;

-- Dumping structure for table crystalrp.dailygifts
CREATE TABLE IF NOT EXISTS `dailygifts` (
  `identifier` longtext DEFAULT NULL,
  `index` int(11) DEFAULT NULL,
  `collected` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.dailygifts: ~0 rows (approximately)
DELETE FROM `dailygifts`;

-- Dumping structure for table crystalrp.darkchat_messages
CREATE TABLE IF NOT EXISTS `darkchat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` text NOT NULL,
  `owner` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT '',
  `messages` text DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.darkchat_messages: ~0 rows (approximately)
DELETE FROM `darkchat_messages`;

-- Dumping structure for table crystalrp.dealers
CREATE TABLE IF NOT EXISTS `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=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.dealers: ~0 rows (approximately)
DELETE FROM `dealers`;

-- Dumping structure for table crystalrp.dream_jobs
CREATE TABLE IF NOT EXISTS `dream_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `experience` int(11) NOT NULL,
  `pickaxe` int(11) NOT NULL,
  `job` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.dream_jobs: ~17 rows (approximately)
DELETE FROM `dream_jobs`;
INSERT INTO `dream_jobs` (`id`, `identifier`, `experience`, `pickaxe`, `job`) VALUES
	(9, 'APB01636', 0, 1, 'miner'),
	(10, 'FWI31344', 0, 1, 'miner'),
	(11, 'IVE21097', 0, 1, 'miner'),
	(12, 'CPQ84937', 0, 1, 'miner'),
	(13, 'EFY95341', 0, 1, 'miner'),
	(14, 'SSQ54649', 0, 1, 'miner'),
	(15, 'OWY18016', 0, 1, 'miner'),
	(16, 'PDN28580', 0, 1, 'miner'),
	(17, 'DFS18015', 0, 1, 'miner'),
	(18, 'DDI30587', 0, 1, 'miner'),
	(19, 'NDF00315', 0, 1, 'miner'),
	(20, 'HFY79706', 0, 1, 'miner'),
	(21, 'KEE73782', 0, 1, 'miner'),
	(22, 'DHW44817', 0, 1, 'miner'),
	(23, 'CKY95174', 0, 1, 'miner'),
	(24, 'UZF83326', 0, 1, 'miner'),
	(25, 'CEE84594', 0, 1, 'miner');

-- Dumping structure for table crystalrp.favorite_channels
CREATE TABLE IF NOT EXISTS `favorite_channels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` varchar(50) DEFAULT NULL,
  `frequency` float(5,1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.favorite_channels: ~0 rows (approximately)
DELETE FROM `favorite_channels`;

-- Dumping structure for table crystalrp.gksphone_app_chat
CREATE TABLE IF NOT EXISTS `gksphone_app_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sendcid` longtext NOT NULL,
  `channel` varchar(20) NOT NULL,
  `message` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=807 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_app_chat: ~0 rows (approximately)
DELETE FROM `gksphone_app_chat`;

-- Dumping structure for table crystalrp.gksphone_bank_transfer
CREATE TABLE IF NOT EXISTS `gksphone_bank_transfer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  `identifier` longtext DEFAULT NULL,
  `price` longtext NOT NULL,
  `name` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=161150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_bank_transfer: ~30 rows (approximately)
DELETE FROM `gksphone_bank_transfer`;
INSERT INTO `gksphone_bank_transfer` (`id`, `type`, `identifier`, `price`, `name`, `time`) VALUES
	(161120, 1, 'QDS83432', '100', 'Aracınızı çağırdınız $100', '2024-12-12 17:24:29'),
	(161121, 1, 'WHZ71107', '100', 'Aracınızı çağırdınız $100', '2024-12-12 23:44:31'),
	(161122, 1, 'QDS83432', '100', 'Aracınızı çağırdınız $100', '2024-12-13 01:58:25'),
	(161123, 1, 'QDS83432', '100', 'Aracınızı çağırdınız $100', '2024-12-13 02:42:06'),
	(161124, 1, 'QDS83432', '100', 'Aracınızı çağırdınız $100', '2024-12-13 02:45:40'),
	(161125, 1, 'QDS83432', '100', 'Aracınızı çağırdınız $100', '2024-12-13 02:46:41'),
	(161126, 1, 'HWH38496', '100', 'Aracınızı çağırdınız $100', '2024-12-13 14:50:44'),
	(161127, 1, 'HWA90637', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:00'),
	(161128, 1, 'CFH18616', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:07'),
	(161129, 1, 'HWH38496', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:09'),
	(161130, 1, 'HWA90637', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:24'),
	(161131, 1, 'HWH38496', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:27'),
	(161132, 1, 'HWH38496', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:18:46'),
	(161133, 1, 'HWA90637', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:19:01'),
	(161134, 1, 'HWH38496', '100', 'Aracınızı çağırdınız $100', '2024-12-13 22:19:09'),
	(161135, 1, 'HWA90637', '100', 'Aracınızı çağırdınız $100', '2024-12-14 03:10:01'),
	(161136, 1, 'CFM02968', '100', 'Aracınızı çağırdınız $100', '2024-12-17 22:19:45'),
	(161137, 1, 'BCT78863', '100', 'Aracınızı çağırdınız $100', '2024-12-19 15:12:40'),
	(161138, 1, 'BCT78863', '100', 'Aracınızı çağırdınız $100', '2024-12-19 15:17:43'),
	(161139, 1, 'HWA90637', '100', 'You bought your car for $100', '2024-12-30 04:59:18'),
	(161140, 1, 'NEJ17289', '100', 'Aracınızı çağırdınız $100', '2025-01-06 10:23:06'),
	(161141, 1, 'NEJ17289', '100', 'Aracınızı çağırdınız $100', '2025-01-06 12:33:54'),
	(161142, 1, 'APB01636', '100', 'Aracınızı çağırdınız $100', '2025-01-07 12:28:08'),
	(161143, 1, 'APB01636', '100', 'Aracınızı çağırdınız $100', '2025-01-07 13:51:25'),
	(161144, 1, 'HFY79706', '100', 'Aracınızı çağırdınız $100', '2025-03-09 03:53:23'),
	(161145, 1, 'HFY79706', '100', 'Aracınızı çağırdınız $100', '2025-03-09 04:11:55'),
	(161146, 1, 'DHW44817', '100', 'Aracınızı çağırdınız $100', '2025-03-09 05:54:28'),
	(161147, 1, 'CKY95174', '100', 'Aracınızı çağırdınız $100', '2025-03-09 05:57:38'),
	(161148, 1, 'AHY06468', '100', 'Aracınızı çağırdınız $100', '2025-03-18 22:47:09'),
	(161149, 1, 'AHY06468', '100', 'Aracınızı çağırdınız $100', '2025-03-19 15:55:06');

-- Dumping structure for table crystalrp.gksphone_blockednumber
CREATE TABLE IF NOT EXISTS `gksphone_blockednumber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` longtext NOT NULL,
  `hex` longtext NOT NULL,
  `number` longtext NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1755 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_blockednumber: ~0 rows (approximately)
DELETE FROM `gksphone_blockednumber`;

-- Dumping structure for table crystalrp.gksphone_calls
CREATE TABLE IF NOT EXISTS `gksphone_calls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` longtext NOT NULL COMMENT 'Num tel proprio',
  `num` longtext NOT NULL COMMENT 'Num reférence du contact',
  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=302759 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_calls: ~0 rows (approximately)
DELETE FROM `gksphone_calls`;

-- Dumping structure for table crystalrp.gksphone_ebay
CREATE TABLE IF NOT EXISTS `gksphone_ebay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext NOT NULL,
  `price` int(11) DEFAULT 0,
  `count` int(11) NOT NULL,
  `item` longtext NOT NULL,
  `kapat` varchar(50) DEFAULT 'false',
  `adet` int(11) DEFAULT 0,
  `cid` varchar(9999) DEFAULT NULL,
  `store` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_ebay: ~0 rows (approximately)
DELETE FROM `gksphone_ebay`;

-- Dumping structure for table crystalrp.gksphone_gallery
CREATE TABLE IF NOT EXISTS `gksphone_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hex` longtext NOT NULL,
  `image` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7471 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_gallery: ~1 rows (approximately)
DELETE FROM `gksphone_gallery`;
INSERT INTO `gksphone_gallery` (`id`, `hex`, `image`, `time`) VALUES
	(7470, 'ZDF30906', 'https://cdn.discordapp.com/attachments/1324062255251456113/1324482121536110734/screenshot.jpg?ex=67784f99&is=6776fe19&hm=bcfce5a5c4abe78b32b96634c84abde0f782fc598c8032bf47304cf03d7fbacc&', '2025-01-02 20:59:07');

-- Dumping structure for table crystalrp.gksphone_gameleaderboard
CREATE TABLE IF NOT EXISTS `gksphone_gameleaderboard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tetris` int(11) NOT NULL DEFAULT 0,
  `snake` int(11) NOT NULL DEFAULT 0,
  `twenty` int(11) NOT NULL DEFAULT 0,
  `owner` varchar(500) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `owner` (`owner`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=541 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_gameleaderboard: ~1 rows (approximately)
DELETE FROM `gksphone_gameleaderboard`;
INSERT INTO `gksphone_gameleaderboard` (`id`, `tetris`, `snake`, `twenty`, `owner`, `name`) VALUES
	(540, 103, 1, 2960, 'UAW69493', 'Ümitcan  Uygun');

-- Dumping structure for table crystalrp.gksphone_gotur
CREATE TABLE IF NOT EXISTS `gksphone_gotur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext NOT NULL,
  `price` int(11) DEFAULT 0,
  `count` int(11) NOT NULL,
  `item` longtext NOT NULL,
  `kapat` varchar(50) DEFAULT 'false',
  `adet` int(11) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_gotur: ~0 rows (approximately)
DELETE FROM `gksphone_gotur`;

-- Dumping structure for table crystalrp.gksphone_gps
CREATE TABLE IF NOT EXISTS `gksphone_gps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hex` longtext NOT NULL,
  `nott` longtext DEFAULT NULL,
  `gps` longtext DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_gps: ~0 rows (approximately)
DELETE FROM `gksphone_gps`;

-- Dumping structure for table crystalrp.gksphone_group_message
CREATE TABLE IF NOT EXISTS `gksphone_group_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupid` int(11) NOT NULL,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(50) NOT NULL,
  `groupname` varchar(255) NOT NULL,
  `messages` longtext NOT NULL,
  `contacts` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE,
  KEY `groupid` (`groupid`) USING BTREE,
  CONSTRAINT `FK_phonegroupmessage` FOREIGN KEY (`groupid`) REFERENCES `gksphone_messages_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=577 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.gksphone_group_message: ~0 rows (approximately)
DELETE FROM `gksphone_group_message`;

-- Dumping structure for table crystalrp.gksphone_instocomment
CREATE TABLE IF NOT EXISTS `gksphone_instocomment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL DEFAULT 0,
  `userid` int(11) NOT NULL DEFAULT 0,
  `message` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_instocomment: ~0 rows (approximately)
DELETE FROM `gksphone_instocomment`;

-- Dumping structure for table crystalrp.gksphone_insto_accounts
CREATE TABLE IF NOT EXISTS `gksphone_insto_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forename` longtext NOT NULL,
  `surname` longtext NOT NULL,
  `username` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` longtext NOT NULL,
  `avatar_url` longtext DEFAULT NULL,
  `takip` longtext DEFAULT NULL,
  `averify` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1510 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table crystalrp.gksphone_insto_accounts: ~1 rows (approximately)
DELETE FROM `gksphone_insto_accounts`;
INSERT INTO `gksphone_insto_accounts` (`id`, `forename`, `surname`, `username`, `password`, `avatar_url`, `takip`, `averify`) VALUES
	(1509, 'mesut', 'güneri', 'mesut344244', 'yemliha2005', '/html/static/img/icons/valeuser.png', NULL, 0);

-- Dumping structure for table crystalrp.gksphone_insto_instas
CREATE TABLE IF NOT EXISTS `gksphone_insto_instas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authorId` int(11) NOT NULL,
  `realUser` longtext DEFAULT NULL,
  `message` longtext NOT NULL,
  `image` longtext NOT NULL,
  `filters` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `FK_gksphone_insto_instas_gksphone_insto_accounts` (`authorId`),
  CONSTRAINT `FK_gksphone_insto_instas_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=375 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.gksphone_insto_instas: ~0 rows (approximately)
DELETE FROM `gksphone_insto_instas`;

-- Dumping structure for table crystalrp.gksphone_insto_likes
CREATE TABLE IF NOT EXISTS `gksphone_insto_likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authorId` int(11) DEFAULT NULL,
  `inapId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_gksphone_insto_likes_gksphone_insto_accounts` (`authorId`),
  KEY `FK_gksphone_insto_likes_gksphone_insto_instas` (`inapId`),
  CONSTRAINT `FK_gksphone_insto_likes_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`),
  CONSTRAINT `FK_gksphone_insto_likes_gksphone_insto_instas` FOREIGN KEY (`inapId`) REFERENCES `gksphone_insto_instas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=470 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table crystalrp.gksphone_insto_likes: ~0 rows (approximately)
DELETE FROM `gksphone_insto_likes`;

-- Dumping structure for table crystalrp.gksphone_insto_story
CREATE TABLE IF NOT EXISTS `gksphone_insto_story` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authorId` int(11) NOT NULL,
  `realUser` longtext DEFAULT NULL,
  `stories` longtext NOT NULL,
  `isRead` varchar(256) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK_gksphone_insto_story_gksphone_insto_accounts` (`authorId`) USING BTREE,
  CONSTRAINT `FK_gksphone_insto_story_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.gksphone_insto_story: ~0 rows (approximately)
DELETE FROM `gksphone_insto_story`;

-- Dumping structure for table crystalrp.gksphone_invoices
CREATE TABLE IF NOT EXISTS `gksphone_invoices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `society` tinytext DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `sendercitizenid` varchar(50) DEFAULT NULL,
  `label` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `citizenid` (`citizenid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4093 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_invoices: ~2 rows (approximately)
DELETE FROM `gksphone_invoices`;
INSERT INTO `gksphone_invoices` (`id`, `citizenid`, `amount`, `society`, `sender`, `sendercitizenid`, `label`) VALUES
	(4091, 'XRS51596', 100000, 'police', 'Rıco', 'QOU80537', NULL),
	(4092, 'DVD07998', 1000, 'police', 'Boklu ', 'FNU16178', NULL);

-- Dumping structure for table crystalrp.gksphone_job_message
CREATE TABLE IF NOT EXISTS `gksphone_job_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext NOT NULL,
  `number` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `photo` longtext DEFAULT NULL,
  `gps` varchar(255) NOT NULL,
  `owner` int(11) NOT NULL DEFAULT 0,
  `jobm` varchar(255) NOT NULL,
  `anon` varchar(50) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1793 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_job_message: ~0 rows (approximately)
DELETE FROM `gksphone_job_message`;

-- Dumping structure for table crystalrp.gksphone_mails
CREATE TABLE IF NOT EXISTS `gksphone_mails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(255) NOT NULL DEFAULT '0',
  `sender` varchar(255) NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL DEFAULT '0',
  `image` text DEFAULT NULL,
  `message` text NOT NULL,
  `button` text DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=97953 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_mails: ~4 rows (approximately)
DELETE FROM `gksphone_mails`;
INSERT INTO `gksphone_mails` (`id`, `citizenid`, `sender`, `subject`, `image`, `message`, `button`, `time`) VALUES
	(97949, 'HFY79706', 'Hastane', 'Hastane Maliyetleri', '/html/static/img/icons/mail.png', 'Sayın Mr. Asd, <br /><br />Son hastane ziyaretinin masraflarını içeren bir e-posta aldınız.<br />Nihai maliyetler ortaya çıktı: <strong>$500</strong><br /><br />Gecmiş Olsun!', 'null', '2025-03-17 20:35:55'),
	(97950, 'WLF54664', 'Hastane', 'Hastane Maliyetleri', '/html/static/img/icons/mail.png', 'Sayın Mr. Santo, <br /><br />Son hastane ziyaretinin masraflarını içeren bir e-posta aldınız.<br />Nihai maliyetler ortaya çıktı: <strong>$500</strong><br /><br />Gecmiş Olsun!', 'null', '2025-03-17 22:28:45'),
	(97951, 'HFY79706', 'Hastane', 'Hastane Maliyetleri', '/html/static/img/icons/mail.png', 'Sayın Mr. Asd, <br /><br />Son hastane ziyaretinin masraflarını içeren bir e-posta aldınız.<br />Nihai maliyetler ortaya çıktı: <strong>$500</strong><br /><br />Gecmiş Olsun!', 'null', '2025-03-17 23:15:15'),
	(97952, 'VCW52710', 'Hastane', 'Hastane Maliyetleri', '/html/static/img/icons/mail.png', 'Sayın Mr. Dsadas, <br /><br />Son hastane ziyaretinin masraflarını içeren bir e-posta aldınız.<br />Nihai maliyetler ortaya çıktı: <strong>$500</strong><br /><br />Gecmiş Olsun!', 'null', '2025-03-20 21:18:47');

-- Dumping structure for table crystalrp.gksphone_messages
CREATE TABLE IF NOT EXISTS `gksphone_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transmitter` varchar(50) NOT NULL,
  `receiver` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `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=168842 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_messages: 0 rows
DELETE FROM `gksphone_messages`;

-- Dumping structure for table crystalrp.gksphone_messages_group
CREATE TABLE IF NOT EXISTS `gksphone_messages_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(50) NOT NULL,
  `groupname` varchar(255) NOT NULL,
  `gimage` longtext NOT NULL,
  `contacts` longtext NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_messages_group: ~0 rows (approximately)
DELETE FROM `gksphone_messages_group`;

-- Dumping structure for table crystalrp.gksphone_news
CREATE TABLE IF NOT EXISTS `gksphone_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hex` longtext DEFAULT NULL,
  `haber` longtext DEFAULT NULL,
  `baslik` longtext DEFAULT NULL,
  `resim` longtext DEFAULT NULL,
  `video` longtext DEFAULT NULL,
  `zaman` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_news: ~0 rows (approximately)
DELETE FROM `gksphone_news`;

-- Dumping structure for table crystalrp.gksphone_racing
CREATE TABLE IF NOT EXISTS `gksphone_racing` (
  `identifier` varchar(60) NOT NULL,
  `track_id` int(11) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `best_lap` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`identifier`,`track_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_racing: ~0 rows (approximately)
DELETE FROM `gksphone_racing`;

-- Dumping structure for table crystalrp.gksphone_settings
CREATE TABLE IF NOT EXISTS `gksphone_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` longtext NOT NULL,
  `crypto` varchar(535) DEFAULT '{}',
  `phone_number` varchar(50) DEFAULT NULL,
  `avatar_url` longtext DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25418 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gksphone_settings: ~119 rows (approximately)
DELETE FROM `gksphone_settings`;
INSERT INTO `gksphone_settings` (`id`, `identifier`, `crypto`, `phone_number`, `avatar_url`) VALUES
	(25298, 'HWH38496', '{}', '7806549710', NULL),
	(25299, 'HWA90637', '{}', '1081612733', NULL),
	(25300, 'ORO13170', '{}', '8062695579', NULL),
	(25302, 'QDS83432', '{}', '66666', NULL),
	(25303, 'VRQ42008', '{}', '816350', NULL),
	(25304, 'WHZ71107', '{}', '432173', NULL),
	(25305, 'CFH18616', '{}', '264689', NULL),
	(25306, 'QHJ46697', '{}', '375974', NULL),
	(25307, 'CLE45988', '{}', '194688', NULL),
	(25308, 'RMP06314', '{}', '247921', NULL),
	(25309, 'RFV35162', '{}', '712297', NULL),
	(25310, 'LJJ08401', '{}', '257883', NULL),
	(25311, 'WIJ29990', '{}', '533862', NULL),
	(25312, 'LFE75676', '{}', '398916', NULL),
	(25313, 'NVN17629', '{}', '810680', NULL),
	(25314, 'URV08797', '{}', '696301', NULL),
	(25315, 'BSI53923', '{}', '762950', NULL),
	(25316, 'YAH62223', '{}', '335787', NULL),
	(25317, 'DLA92312', '{}', '208243', NULL),
	(25318, 'BCT78863', '{}', '789964', NULL),
	(25319, 'JWG24183', '{}', '934929', NULL),
	(25320, 'USY54784', '{}', '666356', NULL),
	(25321, 'MAN23839', '{}', '838656', NULL),
	(25322, 'KON61685', '{}', '714994', NULL),
	(25323, 'SWM62619', '{}', '174987', NULL),
	(25324, 'CFM02968', '{}', '903654', NULL),
	(25325, 'UDZ51313', '{}', '546118', NULL),
	(25326, 'NUM98527', '{}', '555534', NULL),
	(25327, 'EPD54844', '{}', '739210', NULL),
	(25328, 'HKW23968', '{}', '310126', NULL),
	(25329, 'CCT99472', '{}', '944951', NULL),
	(25330, 'XHZ81419', '{}', '586221', NULL),
	(25331, 'IFQ10355', '{}', '126913', NULL),
	(25332, 'USQ49385', '{}', '641194', NULL),
	(25333, 'LBZ29973', '{}', '137662', NULL),
	(25334, 'COP67516', '{}', '359138', NULL),
	(25335, 'OHX07476', '{}', '298728', NULL),
	(25336, 'ARD80754', '{}', '144291', NULL),
	(25337, 'BFT15110', '{}', '668710', NULL),
	(25338, 'HJD86468', '{}', '395957', NULL),
	(25339, 'MKN11380', '{}', '224911', NULL),
	(25340, 'MJJ35010', '{}', '668836', NULL),
	(25341, 'WKL81749', '{}', '459136', NULL),
	(25342, 'AUO56318', '{}', '372240', NULL),
	(25343, 'LOT03634', '{}', '489988', NULL),
	(25344, 'TEM43359', '{}', '288772', NULL),
	(25345, 'LVG01978', '{}', '252266', NULL),
	(25346, 'RIV10887', '{}', '631702', NULL),
	(25347, 'AVC93665', '{}', '628357', NULL),
	(25348, 'RCW84276', '{}', '971257', NULL),
	(25349, 'VTB89229', '{}', '564342', NULL),
	(25350, 'GOE83795', '{}', '976374', NULL),
	(25351, 'BQR15906', '{}', '440152', NULL),
	(25352, 'LET77898', '{}', '308338', NULL),
	(25353, 'CUW89856', '{}', '951877', NULL),
	(25354, 'NMU52707', '{}', '125464', NULL),
	(25355, 'JOJ60978', '{}', '761297', NULL),
	(25356, 'LXN39219', '{}', '846960', NULL),
	(25357, 'DDK73929', '{}', '861887', NULL),
	(25358, 'TYU58000', '{}', '749113', NULL),
	(25359, 'TTJ64953', '{}', '414535', NULL),
	(25360, 'LSA69495', '{}', '783677', NULL),
	(25361, 'YRB06722', '{}', '461590', NULL),
	(25362, 'UAK73475', '{}', '841136', NULL),
	(25363, 'KRD98892', '{}', '638135', NULL),
	(25364, 'QAC48150', '{}', '287884', NULL),
	(25365, 'ZDF30906', '{}', '476301', NULL),
	(25366, 'NEJ17289', '{}', '332588', NULL),
	(25367, 'HFY79706', '{}', '188202', NULL),
	(25368, 'FWI31344', '{}', '531722', NULL),
	(25369, 'HEQ78385', '{}', '508141', NULL),
	(25370, 'APB01636', '{}', '993955', NULL),
	(25371, 'HPQ03117', '{}', '708138', NULL),
	(25372, 'SXF16791', '{}', '810540', NULL),
	(25373, 'MZH23055', '{}', '865812', NULL),
	(25374, 'MQZ35496', '{}', '469195', NULL),
	(25375, 'WZV30598', '{}', '787625', NULL),
	(25376, 'BRJ18661', '{}', '593984', NULL),
	(25377, 'UEG71426', '{}', '279800', NULL),
	(25378, 'CCR30530', '{}', '322670', NULL),
	(25379, 'RIM03351', '{}', '281654', NULL),
	(25380, 'LZW30510', '{}', '637316', NULL),
	(25381, 'NSV21630', '{}', '308734', NULL),
	(25382, 'HXJ50396', '{}', '619356', NULL),
	(25383, 'GEE26175', '{}', '765259', NULL),
	(25384, 'RVW04033', '{}', '830727', NULL),
	(25385, 'VBP74885', '{}', '813311', NULL),
	(25386, 'BIT19030', '{}', '475815', NULL),
	(25387, 'IVE21097', '{}', '246476', NULL),
	(25388, 'KEE73782', '{}', '657844', NULL),
	(25389, 'NQZ34705', '{}', '714449', NULL),
	(25390, 'AVJ04523', '{}', '495374', NULL),
	(25391, 'IPV68228', '{}', '961494', NULL),
	(25392, 'VNU89082', '{}', '266864', NULL),
	(25393, 'KVA03550', '{}', '486996', NULL),
	(25394, 'UPJ00165', '{}', '178166', NULL),
	(25395, 'KSP57436', '{}', '708411', NULL),
	(25396, 'CPQ84937', '{}', '987248', NULL),
	(25397, 'NDF00315', '{}', '455260', NULL),
	(25398, 'DHW44817', '{}', '981564', NULL),
	(25399, 'CKY95174', '{}', '859367', NULL),
	(25400, 'UZF83326', '{}', '233244', NULL),
	(25401, 'CEE84594', '{}', '673673', NULL),
	(25402, 'WIE15154', '{}', '367489', NULL),
	(25403, 'UAW69493', '{}', '507798', NULL),
	(25404, 'VCW52710', '{}', '276217', NULL),
	(25405, 'WLF54664', '{}', '833395', NULL),
	(25406, 'JYS78192', '{}', '267432', NULL),
	(25407, 'AEY78871', '{}', '887322', NULL),
	(25408, 'NPF75386', '{}', '589111', NULL),
	(25409, 'OKT69470', '{}', '918946', NULL),
	(25410, 'VQO03826', '{}', '298947', NULL),
	(25411, 'OAR69061', '{}', '185888', NULL),
	(25412, 'XRF14123', '{}', '533482', NULL),
	(25413, 'BEL96112', '{}', '434569', NULL),
	(25414, 'BTO14085', '{}', '734316', NULL),
	(25415, 'AHY06468', '{}', '218627', NULL),
	(25416, 'CCT80766', '{}', '298881', NULL),
	(25417, 'MUR16142', '{}', '165592', NULL);

-- Dumping structure for table crystalrp.gksphone_tinderacc
CREATE TABLE IF NOT EXISTS `gksphone_tinderacc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `passaword` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `identifier` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_tinderacc: ~0 rows (approximately)
DELETE FROM `gksphone_tinderacc`;

-- Dumping structure for table crystalrp.gksphone_tindermatch
CREATE TABLE IF NOT EXISTS `gksphone_tindermatch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `friend_id` int(11) NOT NULL DEFAULT 0,
  `is_match` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7296 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_tindermatch: ~0 rows (approximately)
DELETE FROM `gksphone_tindermatch`;

-- Dumping structure for table crystalrp.gksphone_tindermessage
CREATE TABLE IF NOT EXISTS `gksphone_tindermessage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `tinderes` text NOT NULL,
  `owner` int(11) NOT NULL DEFAULT 0,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_tindermessage: ~0 rows (approximately)
DELETE FROM `gksphone_tindermessage`;

-- Dumping structure for table crystalrp.gksphone_twt_followers
CREATE TABLE IF NOT EXISTS `gksphone_twt_followers` (
  `follow_id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `followid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`follow_id`) USING BTREE,
  KEY `userid` (`userid`) USING BTREE,
  KEY `FK_gksphone_twt_follower_gksphone_twt_users` (`followid`) USING BTREE,
  CONSTRAINT `FK_gksphone_twt_follower_gksphone_twt_users` FOREIGN KEY (`followid`) REFERENCES `gksphone_twt_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_gksphone_twt_followers_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=409 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_followers: ~0 rows (approximately)
DELETE FROM `gksphone_twt_followers`;

-- Dumping structure for table crystalrp.gksphone_twt_hastags
CREATE TABLE IF NOT EXISTS `gksphone_twt_hastags` (
  `hastag_id` int(11) NOT NULL AUTO_INCREMENT,
  `hastag` varchar(250) NOT NULL DEFAULT '',
  `postid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`hastag_id`) USING BTREE,
  KEY `postid` (`postid`) USING BTREE,
  CONSTRAINT `FK_gksphone_twt_hastags_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_hastags: ~0 rows (approximately)
DELETE FROM `gksphone_twt_hastags`;

-- Dumping structure for table crystalrp.gksphone_twt_likepost
CREATE TABLE IF NOT EXISTS `gksphone_twt_likepost` (
  `like_id` int(11) NOT NULL AUTO_INCREMENT,
  `postid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`like_id`) USING BTREE,
  KEY `userid` (`userid`) USING BTREE,
  KEY `postid` (`postid`) USING BTREE,
  CONSTRAINT `FK_gksphone_twt_likepost_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_gksphone_twt_likepost_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3157 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_likepost: ~0 rows (approximately)
DELETE FROM `gksphone_twt_likepost`;

-- Dumping structure for table crystalrp.gksphone_twt_posts
CREATE TABLE IF NOT EXISTS `gksphone_twt_posts` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` longtext NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `content` longtext NOT NULL,
  `media` longtext DEFAULT NULL,
  `poll_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `comment` int(11) NOT NULL DEFAULT 0,
  `commentid` int(11) NOT NULL DEFAULT 0,
  `pinned` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`post_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  CONSTRAINT `gksphone_twt_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `gksphone_twt_users` (`user_id`),
  CONSTRAINT `poll_options` CHECK (json_valid(`poll_options`))
) ENGINE=InnoDB AUTO_INCREMENT=4176 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_posts: ~2 rows (approximately)
DELETE FROM `gksphone_twt_posts`;
INSERT INTO `gksphone_twt_posts` (`post_id`, `identifier`, `user_id`, `content`, `media`, `poll_options`, `end_date`, `comment`, `commentid`, `pinned`, `created_at`) VALUES
	(4174, 'ZDF30906', 3377, 'dsadsadsadas', NULL, NULL, NULL, 0, 0, 0, '2025-01-02 20:57:58'),
	(4175, 'ZDF30906', 3377, 'dsadsadsdsadsadas', NULL, NULL, NULL, 0, 0, 0, '2025-01-02 20:58:01');

-- Dumping structure for table crystalrp.gksphone_twt_retweet
CREATE TABLE IF NOT EXISTS `gksphone_twt_retweet` (
  `retwettsid` int(11) NOT NULL AUTO_INCREMENT,
  `postid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`retwettsid`) USING BTREE,
  KEY `userid` (`userid`) USING BTREE,
  KEY `postid` (`postid`) USING BTREE,
  CONSTRAINT `FK_gksphone_twt_retweet_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_gksphone_twt_retweet_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=402 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_retweet: ~0 rows (approximately)
DELETE FROM `gksphone_twt_retweet`;

-- Dumping structure for table crystalrp.gksphone_twt_users
CREATE TABLE IF NOT EXISTS `gksphone_twt_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` longtext NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `displayname` varchar(255) NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `is_verified` int(11) NOT NULL DEFAULT 0,
  `verifedbuytime` timestamp NULL DEFAULT current_timestamp(),
  `banned` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `unique_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3379 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_twt_users: ~2 rows (approximately)
DELETE FROM `gksphone_twt_users`;
INSERT INTO `gksphone_twt_users` (`user_id`, `identifier`, `username`, `password`, `displayname`, `avatar`, `banner`, `is_verified`, `verifedbuytime`, `banned`, `created_at`) VALUES
	(3377, 'ZDF30906', 'dsadsadsa', '123444', 'ddsadsa', '/html/static/img/icons/valeuser.png', '', 0, '2025-01-02 20:57:54', 0, '2025-01-02 20:57:54'),
	(3378, 'LZW30510', 'babarp', 'babarp', 'babarp', '/html/static/img/icons/valeuser.png', '', 0, '2025-01-06 19:45:05', 0, '2025-01-06 19:45:05');

-- Dumping structure for table crystalrp.gksphone_users_contacts
CREATE TABLE IF NOT EXISTS `gksphone_users_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `display` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=93638 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_users_contacts: 0 rows
DELETE FROM `gksphone_users_contacts`;

-- Dumping structure for table crystalrp.gksphone_vehicle_sales
CREATE TABLE IF NOT EXISTS `gksphone_vehicle_sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(255) NOT NULL,
  `plate` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `image` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_vehicle_sales: ~0 rows (approximately)
DELETE FROM `gksphone_vehicle_sales`;

-- Dumping structure for table crystalrp.gksphone_wanted
CREATE TABLE IF NOT EXISTS `gksphone_wanted` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `fullname` varchar(50) NOT NULL,
  `reason` varchar(250) DEFAULT NULL,
  `appearance` varchar(250) DEFAULT NULL,
  `lastseen` varchar(250) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.gksphone_wanted: ~0 rows (approximately)
DELETE FROM `gksphone_wanted`;

-- Dumping structure for table crystalrp.gksphone_yellow
CREATE TABLE IF NOT EXISTS `gksphone_yellow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(50) DEFAULT NULL,
  `firstname` varchar(256) DEFAULT NULL,
  `message` longtext NOT NULL,
  `image` longtext DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `filter` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=96223 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.gksphone_yellow: ~1 rows (approximately)
DELETE FROM `gksphone_yellow`;
INSERT INTO `gksphone_yellow` (`id`, `phone_number`, `firstname`, `message`, `image`, `time`, `filter`) VALUES
	(96222, '434569', 'Cznn Daltonn', 'heyse  abı ulasısın', '', '2025-03-20 03:49:57', 'mechanic');

-- Dumping structure for table crystalrp.gloveboxitems
CREATE TABLE IF NOT EXISTS `gloveboxitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plate` varchar(255) DEFAULT NULL,
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`items`)),
  PRIMARY KEY (`id`),
  KEY `plate` (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.gloveboxitems: ~0 rows (approximately)
DELETE FROM `gloveboxitems`;

-- Dumping structure for table crystalrp.houselocations
CREATE TABLE IF NOT EXISTS `houselocations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `coords` text DEFAULT NULL,
  `owned` tinyint(1) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `tier` tinyint(4) DEFAULT NULL,
  `garage` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.houselocations: ~0 rows (approximately)
DELETE FROM `houselocations`;

-- Dumping structure for table crystalrp.house_plants
CREATE TABLE IF NOT EXISTS `house_plants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `building` varchar(50) DEFAULT NULL,
  `stage` varchar(50) DEFAULT 'stage-a',
  `sort` varchar(50) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `food` int(11) DEFAULT 100,
  `health` int(11) DEFAULT 100,
  `progress` int(11) DEFAULT 0,
  `coords` text DEFAULT NULL,
  `plantid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `building` (`building`),
  KEY `plantid` (`plantid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.house_plants: ~0 rows (approximately)
DELETE FROM `house_plants`;

-- Dumping structure for table crystalrp.inc_banking_ibans
CREATE TABLE IF NOT EXISTS `inc_banking_ibans` (
  `identifier` varchar(46) NOT NULL,
  `iban` varchar(255) DEFAULT '',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.inc_banking_ibans: ~5 rows (approximately)
DELETE FROM `inc_banking_ibans`;
INSERT INTO `inc_banking_ibans` (`identifier`, `iban`) VALUES
	('APB01636', 'IC-5578540'),
	('MQZ35496', 'IC-9271662'),
	('TEM43359', 'IC-7886036'),
	('WKL81749', 'IC-6219498'),
	('ZDF30906', 'IC-4678791');

-- Dumping structure for table crystalrp.inc_banking_loans
CREATE TABLE IF NOT EXISTS `inc_banking_loans` (
  `identifier` varchar(46) NOT NULL,
  `amount` int(11) DEFAULT 0,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.inc_banking_loans: ~0 rows (approximately)
DELETE FROM `inc_banking_loans`;

-- Dumping structure for table crystalrp.inc_banking_recent
CREATE TABLE IF NOT EXISTS `inc_banking_recent` (
  `identifier` varchar(46) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `information` varchar(255) DEFAULT NULL,
  `money` float DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.inc_banking_recent: ~0 rows (approximately)
DELETE FROM `inc_banking_recent`;

-- Dumping structure for table crystalrp.izzy_radio
CREATE TABLE IF NOT EXISTS `izzy_radio` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `player` varchar(255) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL DEFAULT '[]',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.izzy_radio: ~2 rows (approximately)
DELETE FROM `izzy_radio`;
INSERT INTO `izzy_radio` (`id`, `player`, `data`) VALUES
	(3, 'HFY79706', '[]'),
	(4, 'HZK30117', '[]');

-- Dumping structure for table crystalrp.lonebanking
CREATE TABLE IF NOT EXISTS `lonebanking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `account_number` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.lonebanking: ~6 rows (approximately)
DELETE FROM `lonebanking`;
INSERT INTO `lonebanking` (`id`, `citizenid`, `account_number`) VALUES
	(1, 'FNU16178', '6828515770'),
	(2, 'FNU16178', '7533584188'),
	(3, 'TMV37328', '5307817231'),
	(4, 'HZK30117', '5214521861'),
	(5, 'QNB34275', '8094902475'),
	(6, 'QNB34275', '7837636320');

-- Dumping structure for table crystalrp.lonebanking_transactions
CREATE TABLE IF NOT EXISTS `lonebanking_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_number` varchar(10) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.lonebanking_transactions: ~9 rows (approximately)
DELETE FROM `lonebanking_transactions`;
INSERT INTO `lonebanking_transactions` (`id`, `account_number`, `type`, `amount`, `description`, `date`) VALUES
	(1, '5214521861', 'Para Çekme', -1000, 'Para Çekme', '2025-11-02 00:51:17'),
	(2, '6828515770', 'Para Çekme', -1000, 'Para Çekme', '2025-11-02 14:37:15'),
	(3, '6828515770', 'Para Yatırma', 1000, 'Para Yatırma', '2025-11-02 14:37:21'),
	(4, '8094902475', 'Para Yatırma', 100000, 'Para Yatırma', '2025-11-04 09:49:17'),
	(5, '8094902475', 'Para Yatırma', 100000, 'Para Yatırma', '2025-11-04 09:49:20'),
	(6, '8094902475', 'Para Yatırma', 100000, 'Para Yatırma', '2025-11-04 09:49:21'),
	(7, '8094902475', 'Para Yatırma', 47408, 'Para Yatırma', '2025-11-04 09:49:32'),
	(8, '5214521861', 'Para Yatırma', 1000, 'Para Yatırma', '2025-11-04 19:43:15'),
	(9, '5214521861', 'Para Çekme', -100000, 'Para Çekme', '2025-11-04 19:43:23');

-- Dumping structure for table crystalrp.management_funds
CREATE TABLE IF NOT EXISTS `management_funds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(50) NOT NULL,
  `amount` int(100) NOT NULL,
  `type` enum('boss','gang') NOT NULL DEFAULT 'boss',
  PRIMARY KEY (`id`),
  UNIQUE KEY `job_name` (`job_name`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=1048661 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.management_funds: ~4 rows (approximately)
DELETE FROM `management_funds`;
INSERT INTO `management_funds` (`id`, `job_name`, `amount`, `type`) VALUES
	(1048187, 'ambulance', 19500, 'boss'),
	(1048188, 'lojistik', 10445000, 'boss'),
	(1048191, 'mechanic', 0, 'boss'),
	(1048208, 'cardealer', 912320653, 'boss');

-- Dumping structure for table crystalrp.management_outfits
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.management_outfits: ~0 rows (approximately)
DELETE FROM `management_outfits`;

-- Dumping structure for table crystalrp.mdt_announcements
CREATE TABLE IF NOT EXISTS `mdt_announcements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `creator` varchar(50) NOT NULL,
  `contents` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK_mdt_announcements_players` (`creator`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_announcements: ~2 rows (approximately)
DELETE FROM `mdt_announcements`;
INSERT INTO `mdt_announcements` (`id`, `creator`, `contents`, `createdAt`) VALUES
	(1, 'VCW52710', '<p>SELAM</p>', '2025-03-17 01:04:19'),
	(2, 'VCW52710', '<p>OROSPU EVLADI JOYKA</p>', '2025-03-21 00:32:06');

-- Dumping structure for table crystalrp.mdt_bolos
CREATE TABLE IF NOT EXISTS `mdt_bolos` (
  `plate` varchar(50) NOT NULL,
  `reason` text NOT NULL,
  `expiresAt` datetime NOT NULL,
  UNIQUE KEY `plate` (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_bolos: ~0 rows (approximately)
DELETE FROM `mdt_bolos`;

-- Dumping structure for table crystalrp.mdt_incidents
CREATE TABLE IF NOT EXISTS `mdt_incidents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_incidents: ~0 rows (approximately)
DELETE FROM `mdt_incidents`;

-- Dumping structure for table crystalrp.mdt_incidents_charges
CREATE TABLE IF NOT EXISTS `mdt_incidents_charges` (
  `incidentid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  `charge` varchar(100) DEFAULT NULL,
  `type` enum('misdemeanor','felony','infraction') NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT 1,
  `time` int(10) unsigned DEFAULT NULL,
  `fine` int(10) unsigned DEFAULT NULL,
  `points` int(10) unsigned DEFAULT NULL,
  KEY `FK_mdt_incidents_charges_mdt_incidents_criminals` (`incidentid`),
  KEY `FK_mdt_incidents_charges_mdt_incidents_criminals_2` (`citizenid`),
  KEY `FK_mdt_incidents_charges_mdt_offenses` (`charge`),
  CONSTRAINT `FK_mdt_incidents_charges_mdt_incidents_criminals_2` FOREIGN KEY (`citizenid`) REFERENCES `mdt_incidents_criminals` (`citizenid`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_mdt_incidents_charges_mdt_offenses` FOREIGN KEY (`charge`) REFERENCES `mdt_offenses` (`label`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_incidents_charges: ~0 rows (approximately)
DELETE FROM `mdt_incidents_charges`;

-- Dumping structure for table crystalrp.mdt_incidents_criminals
CREATE TABLE IF NOT EXISTS `mdt_incidents_criminals` (
  `incidentid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  `reduction` tinyint(3) unsigned DEFAULT NULL,
  `warrantExpiry` date DEFAULT NULL,
  `processed` tinyint(4) DEFAULT NULL,
  `pleadedGuilty` tinyint(4) DEFAULT NULL,
  KEY `incidentid` (`incidentid`),
  KEY `FK_mdt_incidents_incidents_players` (`citizenid`),
  CONSTRAINT `mdt_incidents_criminals_ibfk_2` FOREIGN KEY (`incidentid`) REFERENCES `mdt_incidents` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_incidents_criminals: ~0 rows (approximately)
DELETE FROM `mdt_incidents_criminals`;

-- Dumping structure for table crystalrp.mdt_incidents_evidence
CREATE TABLE IF NOT EXISTS `mdt_incidents_evidence` (
  `incidentid` int(10) unsigned NOT NULL,
  `label` varchar(50) NOT NULL DEFAULT '',
  `image` varchar(90) NOT NULL DEFAULT '',
  KEY `incidentid` (`incidentid`),
  CONSTRAINT `FK_mdt_incidents_evidence_mdt_incidents` FOREIGN KEY (`incidentid`) REFERENCES `mdt_incidents` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_incidents_evidence: ~0 rows (approximately)
DELETE FROM `mdt_incidents_evidence`;

-- Dumping structure for table crystalrp.mdt_incidents_officers
CREATE TABLE IF NOT EXISTS `mdt_incidents_officers` (
  `incidentid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  KEY `FK_mdt_incidents_officers_players` (`citizenid`),
  KEY `incidentid` (`incidentid`),
  CONSTRAINT `FK_mdt_incidents_officers_mdt_incidents` FOREIGN KEY (`incidentid`) REFERENCES `mdt_incidents` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_incidents_officers: ~0 rows (approximately)
DELETE FROM `mdt_incidents_officers`;

-- Dumping structure for table crystalrp.mdt_offenses
CREATE TABLE IF NOT EXISTS `mdt_offenses` (
  `label` varchar(100) NOT NULL,
  `type` enum('misdemeanor','felony','infraction') NOT NULL,
  `category` enum('OFFENSES AGAINST PERSONS','OFFENSES INVOLVING THEFT','OFFENSES INVOLVING FRAUD','OFFENSES INVOLVING DAMAGE TO PROPERTY','OFFENSES AGAINST PUBLIC ADMINISTRATION','OFFENSES AGAINST PUBLIC ORDER','OFFENSES AGAINST HEALTH AND MORALS','OFFENSES AGAINST PUBLIC SAFETY','OFFENSES INVOLVING THE OPERATION OF A VEHICLE','OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE') NOT NULL,
  `description` varchar(250) NOT NULL,
  `time` int(10) unsigned NOT NULL DEFAULT 0,
  `fine` int(10) unsigned NOT NULL DEFAULT 0,
  `points` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_offenses: ~104 rows (approximately)
DELETE FROM `mdt_offenses`;
INSERT INTO `mdt_offenses` (`label`, `type`, `category`, `description`, `time`, `fine`, `points`) VALUES
	('Animal Cruelty', 'misdemeanor', 'OFFENSES AGAINST HEALTH AND MORALS', 'Intentionally inflicting harm or failing to provide adequate care to animals.', 90, 5000, 0),
	('Armed Robbery', 'felony', 'OFFENSES INVOLVING THEFT', 'Robbery with the use of a weapon.', 360, 25000, 0),
	('Arson', 'felony', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'The criminal act of deliberately setting fire to property.', 360, 20000, 0),
	('Assault', 'misdemeanor', 'OFFENSES AGAINST PERSONS', 'Unlawfully attacking another person.', 30, 1000, 0),
	('Battery', 'misdemeanor', 'OFFENSES AGAINST PERSONS', 'Applying force to another, resulting in harmful or offensive contact.', 60, 3000, 0),
	('Bribery', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Offering, giving, receiving, or soliciting anything of value to influence the actions of an official or other person in charge of a public or legal duty.', 180, 15000, 0),
	('Building Code Violation', 'misdemeanor', 'OFFENSES AGAINST PUBLIC SAFETY', 'Violating local building regulations, potentially creating safety hazards.', 30, 2000, 0),
	('Burglary', 'felony', 'OFFENSES INVOLVING THEFT', 'Entering a building unlawfully with intent to commit a felony or a theft.', 90, 5000, 0),
	('Credit Card Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'Unauthorized use of a credit card to obtain goods of value.', 90, 5000, 0),
	('Criminal Mischief', 'misdemeanor', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Intentional or knowing damage to anothers property.', 90, 3000, 0),
	('Criminal Possession of Weapon Class A', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Possession of a Class A weapon, such as a machine gun, assault rifle, or destructive device.', 360, 20000, 0),
	('Criminal Possession of Weapon Class B', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Possession of a Class B weapon, such as a sawed-off shotgun or handgun.', 180, 15000, 0),
	('Criminal Possession of Weapon Class C', 'misdemeanor', 'OFFENSES AGAINST PUBLIC SAFETY', 'Possession of a Class C weapon, such as a rifle or shotgun.', 90, 5000, 0),
	('Criminal Possession of Weapon Class D', 'misdemeanor', 'OFFENSES AGAINST PUBLIC SAFETY', 'Possession of a Class D weapon, such as a knife or club.', 30, 1000, 0),
	('Curfew Violation', 'infraction', 'OFFENSES AGAINST PUBLIC ORDER', 'Failing to adhere to government-imposed curfew regulations, typically enforced to maintain public order during emergencies.', 0, 300, 0),
	('Damaging Public Utilities', 'felony', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Intentionally damaging or interfering with services of public utility providers.', 180, 10000, 0),
	('Destroying Habitat', 'felony', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Deliberate destruction of environments that support wildlife.', 180, 15000, 0),
	('Destruction of Signs', 'infraction', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'The act of destroying or defacing road signs or other public signs.', 0, 500, 0),
	('Disorderly Conduct', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Engaging in behavior that disrupts public peace, including fighting, making excessive noise, or causing a public disturbance.', 30, 1000, 0),
	('Disrupting Wildlife with Noise Pollution', 'misdemeanor', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Causing noise that can harm wildlife behavior and natural habitat.', 60, 3000, 0),
	('Driving Under the Influence (DUI)', 'felony', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Operating a vehicle while under the influence of alcohol or drugs.', 90, 7000, 3),
	('Driving with a Suspended License', 'misdemeanor', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Driving when your drivers license has been suspended or revoked.', 30, 2000, 2),
	('Driving with Obstructed View', 'infraction', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Driving a vehicle with objects blocking the drivers view or control.', 0, 300, 0),
	('Driving Without a License', 'misdemeanor', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Operating a vehicle without a valid driving license.', 0, 1000, 2),
	('Drug Possession', 'misdemeanor', 'OFFENSES AGAINST HEALTH AND MORALS', 'Possession of illegal drugs or controlled substances without a prescription.', 60, 2000, 0),
	('DUI with Bodily Injury', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Driving under the influence of alcohol or drugs and causing bodily harm.', 180, 15000, 3),
	('Election Fraud', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Illegal interference with the process of an election.', 240, 20000, 0),
	('Embezzlement', 'felony', 'OFFENSES INVOLVING THEFT', 'Theft or misappropriation of funds placed in ones trust or belonging to ones employer.', 180, 15000, 0),
	('Failure to Yield', 'infraction', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Failing to yield the right of way to other road users where required.', 0, 250, 1),
	('False Advertising', 'misdemeanor', 'OFFENSES INVOLVING FRAUD', 'Advertising products or services in a misleading or deceptive way.', 30, 2000, 0),
	('Falsifying Records', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Altering, concealing, falsifying, or destroying a document to obstruct the investigation or other official matters.', 90, 5000, 0),
	('Feeding Wildlife Illegally', 'infraction', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Feeding wildlife in areas where it is prohibited by law.', 0, 500, 0),
	('Firearm Possession without Permit', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Owning or carrying a firearm without the necessary permits.', 180, 10000, 0),
	('Gambling Operation', 'felony', 'OFFENSES AGAINST HEALTH AND MORALS', 'Operating or participating in illegal gambling activities, including unlicensed casinos or sports betting.', 180, 15000, 0),
	('Graffiti', 'misdemeanor', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Writing or drawings scribbled, scratched, or sprayed illicitly on a wall or other surface in a public place.', 60, 2500, 0),
	('Grand Theft Auto', 'felony', 'OFFENSES INVOLVING THEFT', 'Theft of an automobile.', 180, 10000, 0),
	('Harassment', 'infraction', 'OFFENSES AGAINST PERSONS', 'Engaging in a pattern of unwanted conduct that alarms or seriously annoys another person, without claiming a legitimate purpose.', 0, 500, 0),
	('Hate Crime', 'felony', 'OFFENSES AGAINST PERSONS', 'A crime motivated by racial, sexual, or other prejudice.', 180, 10000, 0),
	('Hazardous Waste Dumping', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Disposing of hazardous materials in a manner that endangers public health and the environment.', 180, 15000, 0),
	('Healthcare Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'Filing dishonest healthcare claims to obtain a profit.', 180, 15000, 0),
	('Hit and Run', 'felony', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Leaving the scene of an accident without providing contact information or assisting the injured.', 180, 10000, 3),
	('Human Trafficking', 'felony', 'OFFENSES AGAINST PERSONS', 'Illegal trade of human beings for the purposes of forced labor or sexual exploitation.', 720, 50000, 0),
	('Identity Theft', 'felony', 'OFFENSES INVOLVING THEFT', 'The fraudulent acquisition and use of a persons private identifying information.', 180, 10000, 0),
	('Illegal Assembly', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Gathering of people with the intent of engaging in activities that breach public peace or order.', 60, 3000, 0),
	('Illegal Dumping', 'misdemeanor', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Disposing of waste illegally in non-designated areas.', 90, 5000, 0),
	('Illegal Fireworks', 'misdemeanor', 'OFFENSES AGAINST HEALTH AND MORALS', 'Possessing, using, or selling fireworks without appropriate authorization.', 30, 2000, 0),
	('Illegal Fishing', 'misdemeanor', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Fishing without a license or in restricted areas.', 30, 2000, 0),
	('Illegal Gambling', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Organizing, participating in, or operating games of chance in public or private settings without legal authorization.', 90, 5000, 0),
	('Illegal Hunting', 'misdemeanor', 'OFFENSES AGAINST PUBLIC SAFETY', 'Hunting wildlife in restricted areas or during off-seasons without proper permits.', 60, 3000, 0),
	('Illegal Lobbying', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Lobbying without proper registration or when specifically prohibited.', 120, 8000, 0),
	('Illegal Logging', 'felony', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Unauthorized cutting down of trees in protected areas.', 180, 15000, 0),
	('Illegal Pet Trade', 'felony', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Engaging in the sale or purchase of wild animals as pets illegally.', 360, 20000, 0),
	('Illegal Street Racing', 'misdemeanor', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Participating in unauthorized speed contests on public roads.', 90, 5000, 3),
	('Illegal Substance Sale', 'felony', 'OFFENSES AGAINST HEALTH AND MORALS', 'Selling or distributing illegal drugs or other prohibited substances.', 180, 10000, 0),
	('Illegal Tattooing', 'infraction', 'OFFENSES AGAINST HEALTH AND MORALS', 'Tattooing individuals without proper licensing or on minors without legal consent.', 0, 1000, 0),
	('Improper Transport of Hazardous Materials', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Transporting hazardous materials without adhering to safety regulations and legal requirements.', 240, 15000, 0),
	('Inciting a Riot', 'felony', 'OFFENSES AGAINST PUBLIC ORDER', 'Encouraging, promoting, or participating in violent or disruptive behavior that turns into a mass disturbance.', 90, 7000, 0),
	('Insurance Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'The act of falsifying or exaggerating the facts of an accident to an insurance company to obtain payment that would not otherwise be made.', 180, 10000, 0),
	('Kidnapping', 'felony', 'OFFENSES AGAINST PERSONS', 'Unlawfully seizing and carrying away a person by force.', 360, 20000, 0),
	('Larceny', 'misdemeanor', 'OFFENSES INVOLVING THEFT', 'Unlawful taking of personal property.', 60, 2000, 0),
	('Littering', 'infraction', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Carelessly discarding trash or other materials on public or private property.', 0, 250, 0),
	('Littering in Natural Reserves', 'misdemeanor', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Disposing of waste in a natural reserve, negatively affecting wildlife.', 30, 2000, 0),
	('Loitering', 'infraction', 'OFFENSES AGAINST PUBLIC ORDER', 'Remaining idle in a public place for an extended period without a clear reason, often seen as a nuisance.', 0, 250, 0),
	('Mail Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'The use of postal services to commit fraud.', 180, 10000, 0),
	('Manslaughter', 'felony', 'OFFENSES AGAINST PERSONS', 'Killing another person without intention during the commission of a non-felony.', 180, 15000, 0),
	('Misrepresentation', 'misdemeanor', 'OFFENSES INVOLVING FRAUD', 'Deliberately providing false information in a business transaction.', 90, 3000, 0),
	('Misuse of Public Funds', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Using public money for unauthorized, illegal, or unethical purposes.', 180, 15000, 0),
	('Murder', 'felony', 'OFFENSES AGAINST PERSONS', 'Unlawful premeditated killing of one human being by another.', 999, 50000, 0),
	('Negligent Discharge of a Firearm', 'misdemeanor', 'OFFENSES AGAINST PUBLIC SAFETY', 'Accidentally discharging a firearm due to careless handling.', 60, 3000, 0),
	('Obstruction of Justice', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'The crime of obstructing prosecutors or other (usually government) officials.', 180, 10000, 0),
	('Perjury', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'The offense of willfully telling an untruth in a court after having taken an oath or affirmation.', 180, 10000, 0),
	('Petty Theft', 'misdemeanor', 'OFFENSES INVOLVING THEFT', 'The theft of relatively low value items.', 30, 500, 0),
	('Phishing', 'infraction', 'OFFENSES INVOLVING FRAUD', 'Attempting to acquire sensitive information such as usernames, passwords, and credit card details by masquerading as a trustworthy entity in an electronic communication.', 0, 500, 0),
	('Poaching', 'felony', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Illegal hunting, killing, or capturing of wild animals.', 180, 10000, 0),
	('Possession of Explosives', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Illegally possessing or improperly handling explosive materials.', 360, 20000, 0),
	('Prostitution', 'misdemeanor', 'OFFENSES AGAINST HEALTH AND MORALS', 'Engaging in, soliciting, or arranging sexual activities in exchange for payment.', 90, 3000, 0),
	('Public Corruption', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'The abuse of public office for private gain.', 360, 25000, 0),
	('Public Indecency', 'misdemeanor', 'OFFENSES AGAINST HEALTH AND MORALS', 'Performing acts of a sexual nature in public spaces or exposing oneself inappropriately.', 30, 1000, 0),
	('Public Intoxication', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Appearing in public places while significantly impaired by alcohol or drugs, posing a potential danger to self and others.', 0, 500, 0),
	('Public Nudity', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Intentionally exposing oneself in a public space, not complying with local decency laws.', 60, 2000, 0),
	('Receiving Stolen Property', 'misdemeanor', 'OFFENSES INVOLVING THEFT', 'Receiving, buying, or possessing property known to be stolen.', 90, 4000, 0),
	('Reckless Driving', 'misdemeanor', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Driving with a willful disregard for the safety of persons or property.', 60, 3000, 4),
	('Reckless Endangerment', 'felony', 'OFFENSES AGAINST PUBLIC SAFETY', 'Engaging in conduct that poses a significant risk of serious physical injury to others.', 90, 7000, 0),
	('Sabotage', 'felony', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Deliberately destroying, damaging, or obstructing something, especially for political or military advantage.', 360, 25000, 0),
	('Securities Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'Fraudulent practices in the stock and commodities markets, including insider trading.', 360, 25000, 0),
	('Sexual Assault', 'felony', 'OFFENSES AGAINST PERSONS', 'An act in which a person sexually touches another person without their consent.', 360, 20000, 0),
	('Shoplifting', 'misdemeanor', 'OFFENSES INVOLVING THEFT', 'The act of stealing goods from a store.', 30, 1000, 0),
	('Smoking Ban Violation', 'infraction', 'OFFENSES AGAINST HEALTH AND MORALS', 'Smoking in non-smoking areas or violating local smoking regulations.', 0, 250, 0),
	('Stalking', 'misdemeanor', 'OFFENSES AGAINST PERSONS', 'Repeatedly following or harassing another person and making threats.', 90, 5000, 0),
	('Tax Evasion', 'felony', 'OFFENSES INVOLVING FRAUD', 'The illegal nonpayment or underpayment of tax.', 180, 10000, 0),
	('Ticket Scalping', 'infraction', 'OFFENSES INVOLVING THEFT', 'Selling tickets for an event without a proper license and often at a rate exceeding the face value.', 0, 200, 0),
	('Traffic Obstruction', 'infraction', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Obstructing traffic flow intentionally or unintentionally.', 0, 500, 0),
	('Traffic Violation', 'infraction', 'OFFENSES AGAINST PUBLIC SAFETY', 'Violating traffic laws such as speeding, running red lights, or illegal parking.', 0, 500, 1),
	('Trespassing with Damage', 'misdemeanor', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Entering anothers property without permission and causing damage.', 30, 2000, 0),
	('Unauthorized Disclosure of Confidential Information', 'infraction', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'Improperly revealing confidential or classified information without authorization.', 0, 1000, 0),
	('Underage Drinking', 'infraction', 'OFFENSES AGAINST HEALTH AND MORALS', 'Consuming or possessing alcohol by individuals under the legal drinking age.', 0, 500, 0),
	('Unlawful Protest', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Protesting without required permissions or in violation of legal restrictions, potentially leading to public disorder.', 30, 2000, 0),
	('Use of Harmful Pesticides', 'misdemeanor', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Using pesticides that are known to cause significant harm to wildlife.', 90, 5000, 0),
	('Vagrancy', 'misdemeanor', 'OFFENSES AGAINST PUBLIC ORDER', 'Living in public spaces without a permanent home or employment, often associated with public nuisance behaviors.', 30, 1000, 0),
	('Vandalism', 'misdemeanor', 'OFFENSES INVOLVING DAMAGE TO PROPERTY', 'Deliberately destroying or damaging property.', 30, 1000, 0),
	('Vehicle Manslaughter', 'felony', 'OFFENSES INVOLVING THE OPERATION OF A VEHICLE', 'Causing the death of another through negligent or reckless driving.', 360, 20000, 0),
	('Wildlife Smuggling', 'felony', 'OFFENSES INVOLVING THE WELL-BEING OF WILDLIFE', 'Illegally exporting or importing protected or endangered species.', 360, 25000, 0),
	('Wire Fraud', 'felony', 'OFFENSES INVOLVING FRAUD', 'Fraud involving the use of electronic communications.', 180, 15000, 0),
	('Witness Tampering', 'felony', 'OFFENSES AGAINST PUBLIC ADMINISTRATION', 'The attempt to alter or prevent the testimony of witnesses within criminal or civil proceedings.', 240, 15000, 0);

-- Dumping structure for table crystalrp.mdt_profiles
CREATE TABLE IF NOT EXISTS `mdt_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `image` varchar(90) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `callsign` varchar(10) DEFAULT NULL,
  `apu` tinyint(4) DEFAULT NULL,
  `air` tinyint(4) DEFAULT NULL,
  `mc` tinyint(4) DEFAULT NULL,
  `k9` tinyint(4) DEFAULT NULL,
  `fto` tinyint(4) DEFAULT NULL,
  `fingerprint` varchar(90) DEFAULT NULL,
  `lastActive` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdt_profiles_pk2` (`citizenid`),
  UNIQUE KEY `mdt_profiles_pk` (`callsign`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_profiles: ~2 rows (approximately)
DELETE FROM `mdt_profiles`;
INSERT INTO `mdt_profiles` (`id`, `citizenid`, `image`, `notes`, `callsign`, `apu`, `air`, `mc`, `k9`, `fto`, `fingerprint`, `lastActive`) VALUES
	(1, 'VCW52710', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-21 00:08:13'),
	(3, 'HFY79706', NULL, '<p><strong>ORospu evladı</strong></p><p></p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-21 07:04:32');

-- Dumping structure for table crystalrp.mdt_recent_activity
CREATE TABLE IF NOT EXISTS `mdt_recent_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `type` enum('created','updated','deleted') NOT NULL,
  `date` datetime DEFAULT current_timestamp(),
  `activityid` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_recent_activity: ~2 rows (approximately)
DELETE FROM `mdt_recent_activity`;
INSERT INTO `mdt_recent_activity` (`id`, `citizenid`, `category`, `type`, `date`, `activityid`) VALUES
	(3, 'VCW52710', 'incidents', 'deleted', '2025-03-17 01:02:32', 1),
	(4, 'HFY79706', 'profiles', 'updated', '2025-03-17 01:03:18', NULL);

-- Dumping structure for table crystalrp.mdt_reports
CREATE TABLE IF NOT EXISTS `mdt_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_reports: ~1 rows (approximately)
DELETE FROM `mdt_reports`;
INSERT INTO `mdt_reports` (`id`, `title`, `description`, `author`, `date`) VALUES
	(1, 'selam', NULL, 'Dsadas Dsadas', '2025-03-17 01:02:04');

-- Dumping structure for table crystalrp.mdt_reports_citizens
CREATE TABLE IF NOT EXISTS `mdt_reports_citizens` (
  `reportid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  KEY `FK_mdt_reports_players` (`citizenid`),
  KEY `reportid` (`reportid`),
  CONSTRAINT `FK_mdt_reports_players_mdt_reports` FOREIGN KEY (`reportid`) REFERENCES `mdt_reports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_reports_citizens: ~0 rows (approximately)
DELETE FROM `mdt_reports_citizens`;

-- Dumping structure for table crystalrp.mdt_reports_evidence
CREATE TABLE IF NOT EXISTS `mdt_reports_evidence` (
  `reportid` int(10) unsigned NOT NULL,
  `label` varchar(50) NOT NULL DEFAULT '',
  `image` varchar(90) NOT NULL DEFAULT '',
  KEY `reportid` (`reportid`),
  CONSTRAINT `FK_mdt_reports_evidence_mdt_reports` FOREIGN KEY (`reportid`) REFERENCES `mdt_reports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_reports_evidence: ~0 rows (approximately)
DELETE FROM `mdt_reports_evidence`;

-- Dumping structure for table crystalrp.mdt_reports_officers
CREATE TABLE IF NOT EXISTS `mdt_reports_officers` (
  `reportid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  KEY `FK_mdt_reports_officers_players` (`citizenid`),
  KEY `reportid` (`reportid`),
  CONSTRAINT `FK_mdt_reports_officers_mdt_reports` FOREIGN KEY (`reportid`) REFERENCES `mdt_reports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_reports_officers: ~0 rows (approximately)
DELETE FROM `mdt_reports_officers`;

-- Dumping structure for table crystalrp.mdt_vehicles
CREATE TABLE IF NOT EXISTS `mdt_vehicles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plate` varchar(50) NOT NULL,
  `image` varchar(90) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `known_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`known_information`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `plate` (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_vehicles: ~0 rows (approximately)
DELETE FROM `mdt_vehicles`;

-- Dumping structure for table crystalrp.mdt_warrants
CREATE TABLE IF NOT EXISTS `mdt_warrants` (
  `incidentid` int(10) unsigned NOT NULL,
  `citizenid` varchar(50) NOT NULL,
  `expiresAt` datetime NOT NULL,
  KEY `mdt_warrants_mdt_incidents_id_fk` (`incidentid`),
  CONSTRAINT `mdt_warrants_mdt_incidents_id_fk` FOREIGN KEY (`incidentid`) REFERENCES `mdt_incidents` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.mdt_warrants: ~0 rows (approximately)
DELETE FROM `mdt_warrants`;

-- Dumping structure for table crystalrp.m_hud_playlists
CREATE TABLE IF NOT EXISTS `m_hud_playlists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` longtext DEFAULT NULL,
  `name` longtext NOT NULL,
  `cover` longtext DEFAULT NULL,
  `likes` longtext NOT NULL,
  `creatorname` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.m_hud_playlists: ~0 rows (approximately)
DELETE FROM `m_hud_playlists`;

-- Dumping structure for table crystalrp.m_hud_playlist_songs
CREATE TABLE IF NOT EXISTS `m_hud_playlist_songs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `playlist_id` int(11) DEFAULT NULL,
  `url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `coverUrl` longtext DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.m_hud_playlist_songs: ~0 rows (approximately)
DELETE FROM `m_hud_playlist_songs`;

-- Dumping structure for table crystalrp.m_hud_stress
CREATE TABLE IF NOT EXISTS `m_hud_stress` (
  `identifier` varchar(46) DEFAULT NULL,
  `stress` int(11) DEFAULT NULL,
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.m_hud_stress: ~0 rows (approximately)
DELETE FROM `m_hud_stress`;

-- Dumping structure for table crystalrp.nc_playtimeshop
CREATE TABLE IF NOT EXISTS `nc_playtimeshop` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(255) NOT NULL DEFAULT '0',
  `coin` int(11) DEFAULT NULL,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.nc_playtimeshop: ~0 rows (approximately)
DELETE FROM `nc_playtimeshop`;

-- Dumping structure for table crystalrp.nc_playtimeshop_codes
CREATE TABLE IF NOT EXISTS `nc_playtimeshop_codes` (
  `#` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `credit` int(11) DEFAULT NULL,
  PRIMARY KEY (`#`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.nc_playtimeshop_codes: ~0 rows (approximately)
DELETE FROM `nc_playtimeshop_codes`;

-- Dumping structure for table crystalrp.ox_inventory
CREATE TABLE IF NOT EXISTS `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=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.ox_inventory: ~2 rows (approximately)
DELETE FROM `ox_inventory`;
INSERT INTO `ox_inventory` (`owner`, `name`, `data`, `lastupdated`) VALUES
	('DVD07998', 'Kişisel Depo - DVD07998', '[{"name":"ammo-heavysniper","count":958,"slot":1},{"name":"driver_license","count":1,"metadata":{"type":"Class C Driver License","firstname":"Efe","lastname":"Sarsılmaz","birthdate":"1999-10-12"},"slot":3},{"name":"phone","count":1,"slot":4},{"name":"money","count":25000,"slot":5},{"name":"id_card","count":1,"metadata":{"nationality":"Turkey","firstname":"Efe","birthdate":"1999-10-12","lastname":"Sarsılmaz","gender":0},"slot":6},{"name":"ammo-smg","count":983,"slot":7}]', '2025-11-04 20:25:31'),
	('WJC37394', 'Kişisel Depo - WJC37394', '[{"name":"WEAPON_TOLVECTOR","slot":1,"metadata":{"registered":"Zantree Can","components":[],"durability":100,"ammo":0,"serial":"995927XUS129717"},"count":1},{"name":"ammo-9","slot":2,"count":114},{"name":"heavyarmor","slot":3,"count":126},{"name":"WEAPON_TOLVECTOR","slot":4,"metadata":{"registered":"Zantree Can","components":[],"durability":100,"ammo":0,"serial":"679477RZH981144"},"count":1},{"name":"WEAPON_TOLVECTOR","slot":5,"metadata":{"registered":"Zantree Can","components":[],"durability":94.35999999999999,"ammo":232,"serial":"392333ILS740584"},"count":1},{"name":"aluminum","slot":6,"count":1},{"name":"phone","slot":7,"count":1},{"name":"WEAPON_TOLVECTOR","slot":8,"metadata":{"registered":"Zantree Can","components":[],"durability":100,"ammo":0,"serial":"920756XHF104567"},"count":1},{"name":"WEAPON_G19","slot":9,"metadata":{"registered":"Zantree Can","components":[],"durability":98.84999999999995,"ammo":137,"serial":"860789LGX754068"},"count":1}]', '2025-11-03 18:50:00');

-- Dumping structure for table crystalrp.pa_vehicleshop_showroom_vehicles
CREATE TABLE IF NOT EXISTS `pa_vehicleshop_showroom_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dealershipId` int(11) DEFAULT NULL,
  `data` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.pa_vehicleshop_showroom_vehicles: ~0 rows (approximately)
DELETE FROM `pa_vehicleshop_showroom_vehicles`;

-- Dumping structure for table crystalrp.pa_vehicleshop_stocks
CREATE TABLE IF NOT EXISTS `pa_vehicleshop_stocks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(50) NOT NULL DEFAULT '0',
  `stock` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.pa_vehicleshop_stocks: ~0 rows (approximately)
DELETE FROM `pa_vehicleshop_stocks`;

-- Dumping structure for table crystalrp.phone_accounts
CREATE TABLE IF NOT EXISTS `phone_accounts` (
  `app` varchar(50) NOT NULL,
  `id` varchar(80) NOT NULL,
  `name` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `birthdate` varchar(50) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `interested` text NOT NULL,
  `avatar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_accounts: ~0 rows (approximately)
DELETE FROM `phone_accounts`;

-- Dumping structure for table crystalrp.phone_alertjobs
CREATE TABLE IF NOT EXISTS `phone_alertjobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job` varchar(255) NOT NULL,
  `alerts` longtext DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `job` (`job`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_alertjobs: ~0 rows (approximately)
DELETE FROM `phone_alertjobs`;

-- Dumping structure for table crystalrp.phone_backups
CREATE TABLE IF NOT EXISTS `phone_backups` (
  `id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_backups_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_backups: ~14 rows (approximately)
DELETE FROM `phone_backups`;
INSERT INTO `phone_backups` (`id`, `phone_number`) VALUES
	('FJY17019', '5201461820'),
	('FNU16178', '6027776998'),
	('GYY38354', '2059796133'),
	('HLY83785', '2059167594'),
	('HZK30117', '2051560108'),
	('JAX11032', '6021027870'),
	('QNB34275', '5205368163'),
	('QOU80537', '5209228674'),
	('RPB30164', '5208447399'),
	('RST11039', '5207625696'),
	('TMV37328', '2055336998'),
	('WJC37394', '4805337298'),
	('XDL74210', '2055766058'),
	('XRS51596', '6021865085');

-- Dumping structure for table crystalrp.phone_chats
CREATE TABLE IF NOT EXISTS `phone_chats` (
  `app` varchar(50) NOT NULL,
  `author` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL,
  `created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_chats: ~0 rows (approximately)
DELETE FROM `phone_chats`;

-- Dumping structure for table crystalrp.phone_clock_alarms
CREATE TABLE IF NOT EXISTS `phone_clock_alarms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `hours` int(2) NOT NULL DEFAULT 0,
  `minutes` int(2) NOT NULL DEFAULT 0,
  `label` varchar(50) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_clock_alarms_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_clock_alarms: ~0 rows (approximately)
DELETE FROM `phone_clock_alarms`;

-- Dumping structure for table crystalrp.phone_crypto
CREATE TABLE IF NOT EXISTS `phone_crypto` (
  `id` varchar(100) NOT NULL,
  `coin` varchar(15) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `invested` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`coin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_crypto: ~0 rows (approximately)
DELETE FROM `phone_crypto`;

-- Dumping structure for table crystalrp.phone_darkchat_accounts
CREATE TABLE IF NOT EXISTS `phone_darkchat_accounts` (
  `phone_number` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_darkchat_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_darkchat_accounts: ~0 rows (approximately)
DELETE FROM `phone_darkchat_accounts`;

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

-- Dumping data for table crystalrp.phone_darkchat_channels: ~0 rows (approximately)
DELETE FROM `phone_darkchat_channels`;

-- Dumping structure for table crystalrp.phone_darkchat_members
CREATE TABLE IF NOT EXISTS `phone_darkchat_members` (
  `channel_name` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  PRIMARY KEY (`channel_name`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_darkchat_members_ibfk_1` FOREIGN KEY (`channel_name`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_members_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_darkchat_members: ~0 rows (approximately)
DELETE FROM `phone_darkchat_members`;

-- Dumping structure for table crystalrp.phone_darkchat_messages
CREATE TABLE IF NOT EXISTS `phone_darkchat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(50) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel` (`channel`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_darkchat_messages_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_darkchat_messages: ~0 rows (approximately)
DELETE FROM `phone_darkchat_messages`;

-- Dumping structure for table crystalrp.phone_gallery
CREATE TABLE IF NOT EXISTS `phone_gallery` (
  `citizenid` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_gallery: ~0 rows (approximately)
DELETE FROM `phone_gallery`;

-- Dumping structure for table crystalrp.phone_instagram_accounts
CREATE TABLE IF NOT EXISTS `phone_instagram_accounts` (
  `display_name` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `profile_image` varchar(500) DEFAULT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `post_count` int(11) NOT NULL DEFAULT 0,
  `story_count` int(11) NOT NULL DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `phone_number` varchar(15) NOT NULL,
  `private` tinyint(1) DEFAULT 0,
  `verified` tinyint(1) DEFAULT 0,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_instagram_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_accounts: ~0 rows (approximately)
DELETE FROM `phone_instagram_accounts`;

-- Dumping structure for table crystalrp.phone_instagram_comments
CREATE TABLE IF NOT EXISTS `phone_instagram_comments` (
  `id` varchar(10) NOT NULL,
  `post_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL DEFAULT '',
  `like_count` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `phone_instagram_posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_comments: ~0 rows (approximately)
DELETE FROM `phone_instagram_comments`;

-- Dumping structure for table crystalrp.phone_instagram_follows
CREATE TABLE IF NOT EXISTS `phone_instagram_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_instagram_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_follows: ~0 rows (approximately)
DELETE FROM `phone_instagram_follows`;

-- Dumping structure for table crystalrp.phone_instagram_follow_requests
CREATE TABLE IF NOT EXISTS `phone_instagram_follow_requests` (
  `requester` varchar(20) NOT NULL,
  `requestee` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_instagram_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_follow_requests: ~0 rows (approximately)
DELETE FROM `phone_instagram_follow_requests`;

-- Dumping structure for table crystalrp.phone_instagram_likes
CREATE TABLE IF NOT EXISTS `phone_instagram_likes` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `is_comment` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_likes: ~0 rows (approximately)
DELETE FROM `phone_instagram_likes`;

-- Dumping structure for table crystalrp.phone_instagram_messages
CREATE TABLE IF NOT EXISTS `phone_instagram_messages` (
  `id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `recipient` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_instagram_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_messages: ~0 rows (approximately)
DELETE FROM `phone_instagram_messages`;

-- Dumping structure for table crystalrp.phone_instagram_notifications
CREATE TABLE IF NOT EXISTS `phone_instagram_notifications` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `post_id` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_instagram_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_notifications: ~0 rows (approximately)
DELETE FROM `phone_instagram_notifications`;

-- Dumping structure for table crystalrp.phone_instagram_posts
CREATE TABLE IF NOT EXISTS `phone_instagram_posts` (
  `id` varchar(10) NOT NULL,
  `media` text DEFAULT NULL,
  `caption` varchar(500) NOT NULL DEFAULT '',
  `location` varchar(50) DEFAULT NULL,
  `like_count` int(11) NOT NULL DEFAULT 0,
  `comment_count` int(11) NOT NULL DEFAULT 0,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_posts_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_posts: ~0 rows (approximately)
DELETE FROM `phone_instagram_posts`;

-- Dumping structure for table crystalrp.phone_instagram_stories
CREATE TABLE IF NOT EXISTS `phone_instagram_stories` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `image` varchar(500) NOT NULL,
  `metadata` longtext DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_stories_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_stories: ~0 rows (approximately)
DELETE FROM `phone_instagram_stories`;

-- Dumping structure for table crystalrp.phone_instagram_stories_views
CREATE TABLE IF NOT EXISTS `phone_instagram_stories_views` (
  `story_id` varchar(50) NOT NULL,
  `viewer` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`story_id`,`viewer`),
  KEY `viewer` (`viewer`),
  CONSTRAINT `phone_instagram_stories_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `phone_instagram_stories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_stories_views_ibfk_2` FOREIGN KEY (`viewer`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_instagram_stories_views: ~0 rows (approximately)
DELETE FROM `phone_instagram_stories_views`;

-- Dumping structure for table crystalrp.phone_invoices
CREATE TABLE IF NOT EXISTS `phone_invoices` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `society` tinytext DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `sendercitizenid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.phone_invoices: ~0 rows (approximately)
DELETE FROM `phone_invoices`;

-- Dumping structure for table crystalrp.phone_last_phone
CREATE TABLE IF NOT EXISTS `phone_last_phone` (
  `id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_last_phone_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_last_phone: ~0 rows (approximately)
DELETE FROM `phone_last_phone`;

-- Dumping structure for table crystalrp.phone_logged_in_accounts
CREATE TABLE IF NOT EXISTS `phone_logged_in_accounts` (
  `phone_number` varchar(15) NOT NULL,
  `app` varchar(50) NOT NULL,
  `username` varchar(100) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`phone_number`,`app`,`username`),
  CONSTRAINT `phone_logged_in_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_logged_in_accounts: ~0 rows (approximately)
DELETE FROM `phone_logged_in_accounts`;

-- Dumping structure for table crystalrp.phone_mail_accounts
CREATE TABLE IF NOT EXISTS `phone_mail_accounts` (
  `address` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_mail_accounts: ~0 rows (approximately)
DELETE FROM `phone_mail_accounts`;

-- Dumping structure for table crystalrp.phone_mail_deleted
CREATE TABLE IF NOT EXISTS `phone_mail_deleted` (
  `message_id` int(10) unsigned NOT NULL,
  `address` varchar(100) NOT NULL,
  PRIMARY KEY (`message_id`,`address`),
  KEY `address` (`address`),
  CONSTRAINT `phone_mail_deleted_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `phone_mail_messages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_mail_deleted_ibfk_2` FOREIGN KEY (`address`) REFERENCES `phone_mail_accounts` (`address`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_mail_deleted: ~0 rows (approximately)
DELETE FROM `phone_mail_deleted`;

-- Dumping structure for table crystalrp.phone_mail_messages
CREATE TABLE IF NOT EXISTS `phone_mail_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `recipient` varchar(100) NOT NULL,
  `sender` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `attachments` longtext DEFAULT NULL,
  `actions` longtext DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_recipient` (`recipient`),
  KEY `idx_sender` (`sender`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_mail_messages: ~0 rows (approximately)
DELETE FROM `phone_mail_messages`;

-- Dumping structure for table crystalrp.phone_maps_locations
CREATE TABLE IF NOT EXISTS `phone_maps_locations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) NOT NULL,
  `x_pos` float NOT NULL,
  `y_pos` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_maps_locations_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_maps_locations: ~0 rows (approximately)
DELETE FROM `phone_maps_locations`;

-- Dumping structure for table crystalrp.phone_marketplace_posts
CREATE TABLE IF NOT EXISTS `phone_marketplace_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `attachments` text DEFAULT NULL,
  `price` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_marketplace_posts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_marketplace_posts: ~0 rows (approximately)
DELETE FROM `phone_marketplace_posts`;

-- Dumping structure for table crystalrp.phone_messages
CREATE TABLE IF NOT EXISTS `phone_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(46) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `number` varchar(50) NOT NULL,
  `owner` varchar(50) DEFAULT NULL,
  `messages` text NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `read` int(11) DEFAULT NULL,
  `created` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_messages: ~0 rows (approximately)
DELETE FROM `phone_messages`;

-- Dumping structure for table crystalrp.phone_message_channels
CREATE TABLE IF NOT EXISTS `phone_message_channels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_group` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(50) DEFAULT NULL,
  `last_message` varchar(50) NOT NULL DEFAULT '',
  `last_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_message_channels: ~1 rows (approximately)
DELETE FROM `phone_message_channels`;
INSERT INTO `phone_message_channels` (`id`, `is_group`, `name`, `last_message`, `last_message_timestamp`) VALUES
	(1, 0, NULL, '', '2025-11-02 15:38:01');

-- Dumping structure for table crystalrp.phone_message_members
CREATE TABLE IF NOT EXISTS `phone_message_members` (
  `channel_id` int(11) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `is_owner` tinyint(1) NOT NULL DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  `unread` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`channel_id`,`phone_number`),
  KEY `idx_members_phone_number` (`phone_number`),
  CONSTRAINT `phone_message_members_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_message_members: ~0 rows (approximately)
DELETE FROM `phone_message_members`;

-- Dumping structure for table crystalrp.phone_message_messages
CREATE TABLE IF NOT EXISTS `phone_message_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) NOT NULL,
  `sender` varchar(15) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_message_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_message_messages: ~0 rows (approximately)
DELETE FROM `phone_message_messages`;

-- Dumping structure for table crystalrp.phone_music_playlists
CREATE TABLE IF NOT EXISTS `phone_music_playlists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) NOT NULL,
  `cover` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_playlists_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_music_playlists: ~0 rows (approximately)
DELETE FROM `phone_music_playlists`;

-- Dumping structure for table crystalrp.phone_music_saved_playlists
CREATE TABLE IF NOT EXISTS `phone_music_saved_playlists` (
  `playlist_id` int(10) unsigned NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`playlist_id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_saved_playlists_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_music_saved_playlists_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_music_saved_playlists: ~0 rows (approximately)
DELETE FROM `phone_music_saved_playlists`;

-- Dumping structure for table crystalrp.phone_music_songs
CREATE TABLE IF NOT EXISTS `phone_music_songs` (
  `song_id` varchar(100) NOT NULL,
  `playlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`song_id`,`playlist_id`),
  KEY `playlist_id` (`playlist_id`),
  CONSTRAINT `phone_music_songs_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_music_songs: ~0 rows (approximately)
DELETE FROM `phone_music_songs`;

-- Dumping structure for table crystalrp.phone_news
CREATE TABLE IF NOT EXISTS `phone_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(50) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_news: ~0 rows (approximately)
DELETE FROM `phone_news`;

-- Dumping structure for table crystalrp.phone_notes
CREATE TABLE IF NOT EXISTS `phone_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` longtext DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notes_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_notes: ~0 rows (approximately)
DELETE FROM `phone_notes`;

-- Dumping structure for table crystalrp.phone_notifications
CREATE TABLE IF NOT EXISTS `phone_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `app` varchar(50) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `content` varchar(500) DEFAULT NULL,
  `thumbnail` varchar(500) DEFAULT NULL,
  `avatar` varchar(500) DEFAULT NULL,
  `show_avatar` tinyint(1) DEFAULT 0,
  `custom_data` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notifications_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_notifications: ~0 rows (approximately)
DELETE FROM `phone_notifications`;

-- Dumping structure for table crystalrp.phone_notifies
CREATE TABLE IF NOT EXISTS `phone_notifies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(50) NOT NULL,
  `msg_content` text NOT NULL,
  `msg_head` varchar(50) NOT NULL DEFAULT '',
  `app_name` text NOT NULL,
  `msg_time` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table crystalrp.phone_notifies: ~0 rows (approximately)
DELETE FROM `phone_notifies`;

-- Dumping structure for table crystalrp.phone_phones
CREATE TABLE IF NOT EXISTS `phone_phones` (
  `id` varchar(100) NOT NULL,
  `owner_id` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `pin` varchar(4) DEFAULT NULL,
  `face_id` varchar(100) DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `is_setup` tinyint(1) DEFAULT 0,
  `assigned` tinyint(1) DEFAULT 0,
  `battery` int(11) NOT NULL DEFAULT 100,
  `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_phones: ~25 rows (approximately)
DELETE FROM `phone_phones`;
INSERT INTO `phone_phones` (`id`, `owner_id`, `phone_number`, `name`, `pin`, `face_id`, `settings`, `is_setup`, `assigned`, `battery`, `last_seen`) VALUES
	('ATL68952', 'ATL68952', '9077515158', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-04 15:13:23'),
	('BNN74169', 'BNN74169', '9077765004', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-03 18:01:16'),
	('DER51835', 'DER51835', '4801005376', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-03 19:48:48'),
	('DVD07998', 'DVD07998', '9074381292', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-04 20:02:12'),
	('FJY17019', 'FJY17019', '5201461820', 'Honty\'s Phone', NULL, NULL, '{"weather":{"celcius":false},"time":{"twelveHourClock":false},"version":"2.3.7","notifications":[],"sound":{"callVolume":0.5,"texttone":"default","silent":false,"volume":0.5,"ringtone":"default"},"phone":{"showCallerId":true},"wallpaper":{"blur":false,"background":"cloud8"},"storage":{"total":128000000,"used":8576331},"name":"Honty\'s Phone","display":{"automatic":false,"brightness":1,"theme":"dark","size":0.7},"doNotDisturb":false,"locale":"en","airplaneMode":false,"streamerMode":false,"latestVersion":"2.3.7","apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"security":{"faceId":false,"pinCode":false}}', 1, 0, 100, '2025-11-03 19:30:21'),
	('FNU16178', 'FNU16178', '6027776998', 'Boklu \'s Phone', NULL, NULL, '{"wallpaper":{"blur":false,"background":"cloud8"},"display":{"size":0.7,"automatic":false,"theme":"dark","brightness":1},"notifications":[],"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"latestVersion":"2.3.7","doNotDisturb":false,"streamerMode":false,"airplaneMode":false,"sound":{"volume":0.5,"callVolume":0.5,"texttone":"default","ringtone":"default","silent":false},"locale":"tr","security":{"faceId":false,"pinCode":false},"lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"weather":{"celcius":false},"phone":{"showCallerId":true},"time":{"twelveHourClock":false},"version":"2.3.7","storage":{"used":8576331,"total":128000000},"name":"Boklu \'s Phone"}', 1, 0, 100, '2025-11-04 15:17:38'),
	('GYY38354', 'GYY38354', '2059796133', 'Zizi\'s Phone', NULL, NULL, '{"display":{"theme":"dark","size":0.7,"brightness":1,"automatic":false},"notifications":[],"storage":{"total":128000000,"used":8576331},"weather":{"celcius":false},"time":{"twelveHourClock":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"streamerMode":false,"sound":{"silent":false,"ringtone":"default","volume":0.5,"callVolume":0.5,"texttone":"default"},"airplaneMode":false,"phone":{"showCallerId":true},"name":"Zizi\'s Phone","latestVersion":"2.3.7","lockscreen":{"color":"gradient","fontStyle":1,"layout":1},"locale":"tr","doNotDisturb":false,"version":"2.3.7","security":{"pinCode":false,"faceId":false},"wallpaper":{"blur":false,"background":"cloud8"}}', 1, 0, 100, '2025-11-03 21:02:06'),
	('HFZ11174', 'HFZ11174', '9079515661', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-03 17:05:35'),
	('HLY83785', 'HLY83785', '2059167594', 'Sefa\'s Phone', NULL, NULL, '{"locale":"tr","lockscreen":{"color":"gradient","fontStyle":1,"layout":1},"sound":{"silent":false,"texttone":"default","volume":0.5,"ringtone":"default","callVolume":0.5},"storage":{"used":8576331,"total":128000000},"display":{"automatic":false,"theme":"light","brightness":1,"size":0.7},"wallpaper":{"background":"cloud8","blur":false},"streamerMode":false,"airplaneMode":false,"latestVersion":"2.3.7","phone":{"showCallerId":true},"time":{"twelveHourClock":false},"version":"2.3.7","security":{"pinCode":false,"faceId":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services","TikTok","YellowPages","MarketPlace","Crypto","DarkChat","Tinder"]],"doNotDisturb":false,"notifications":[],"weather":{"celcius":false},"name":"Sefa\'s Phone"}', 1, 0, 100, '2025-11-04 19:29:15'),
	('HZK30117', 'HZK30117', '2051560108', 'Asda\'s Phone', NULL, NULL, '{"display":{"theme":"dark","size":0.7,"brightness":1,"automatic":false},"notifications":[],"storage":{"used":8576331,"total":128000000},"weather":{"celcius":false},"time":{"twelveHourClock":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"streamerMode":false,"wallpaper":{"background":"cloud8","blur":false},"airplaneMode":false,"phone":{"showCallerId":true},"name":"Asda\'s Phone","latestVersion":"2.3.7","lockscreen":{"color":"gradient","layout":1,"fontStyle":1},"sound":{"silent":false,"ringtone":"default","volume":0.5,"callVolume":0.5,"texttone":"default"},"doNotDisturb":false,"version":"2.3.7","security":{"faceId":false,"pinCode":false},"locale":"tr"}', 1, 0, 100, '2025-11-04 19:37:34'),
	('JAX11032', 'JAX11032', '6021027870', 'Petro\'s Phone', NULL, NULL, '{"weather":{"celcius":false},"time":{"twelveHourClock":false},"version":"2.3.7","latestVersion":"2.3.7","sound":{"callVolume":0.5,"texttone":"default","silent":false,"ringtone":"default","volume":0.5},"lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"wallpaper":{"blur":false,"background":"cloud8"},"storage":{"total":128000000,"used":8576331},"name":"Petro\'s Phone","display":{"size":0.7,"brightness":1,"automatic":false,"theme":"dark"},"doNotDisturb":false,"locale":"tr","airplaneMode":false,"streamerMode":false,"security":{"faceId":false,"pinCode":false},"notifications":[],"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"phone":{"showCallerId":true}}', 1, 0, 100, '2025-11-03 20:01:17'),
	('JYB49700', 'JYB49700', '4805542833', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-04 14:04:45'),
	('QNB34275', 'QNB34275', '5205368163', 'Mustafa Ahmet\'s Phone', NULL, NULL, '{"time":{"twelveHourClock":false},"wallpaper":{"blur":false,"background":"cloud8"},"storage":{"used":8576331,"total":128000000},"sound":{"ringtone":"default","silent":false,"volume":0.5,"texttone":"default","callVolume":0.5},"lockscreen":{"layout":1,"color":"gradient","fontStyle":1},"version":"2.3.7","latestVersion":"2.3.7","streamerMode":false,"airplaneMode":false,"display":{"theme":"dark","size":0.7,"automatic":false,"brightness":1},"notifications":[],"name":"Mustafa Ahmet\'s Phone","locale":"tr","weather":{"celcius":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"security":{"faceId":false,"pinCode":false},"phone":{"showCallerId":true},"doNotDisturb":false}', 1, 0, 100, '2025-11-04 08:39:55'),
	('QOU80537', 'QOU80537', '5209228674', 'Rıco\'s Phone', '2222', NULL, '{"doNotDisturb":false,"sound":{"ringtone":"default","volume":0.5,"silent":false,"callVolume":0.5,"texttone":"default"},"name":"Rıco\'s Phone","weather":{"celcius":false},"wallpaper":{"background":"cloud8","blur":false},"display":{"theme":"light","automatic":false,"brightness":1,"size":0.7},"notifications":[],"streamerMode":false,"locale":"de","phone":{"showCallerId":true},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services","YellowPages"]],"security":{"pinCode":true,"faceId":false},"version":"2.3.7","storage":{"used":8576331,"total":128000000},"airplaneMode":false,"time":{"twelveHourClock":false},"latestVersion":"2.3.7","lockscreen":{"fontStyle":1,"layout":1,"color":"gradient"}}', 1, 0, 100, '2025-11-03 14:12:43'),
	('RBG67155', 'RBG67155', '5206408894', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-03 18:23:34'),
	('RPB30164', 'RPB30164', '5208447399', 'Fypenos\'s Phone', NULL, NULL, '{"doNotDisturb":false,"storage":{"total":128000000,"used":8576331},"wallpaper":{"background":"cloud8","blur":false},"notifications":[],"version":"2.3.7","locale":"tr","time":{"twelveHourClock":false},"streamerMode":false,"lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"weather":{"celcius":false},"name":"Fypenos\'s Phone","sound":{"texttone":"default","callVolume":0.5,"volume":0.5,"silent":false,"ringtone":"default"},"display":{"brightness":1,"automatic":false,"size":0.7,"theme":"dark"},"latestVersion":"2.3.7","security":{"pinCode":false,"faceId":false},"airplaneMode":false,"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"phone":{"showCallerId":true}}', 1, 0, 100, '2025-11-04 13:14:48'),
	('RST11039', 'RST11039', '5207625696', 'Yigits\'s Phone', '1111', 'RST11039', '{"doNotDisturb":false,"storage":{"total":128000000,"used":8576331},"wallpaper":{"background":"cloud8","blur":false},"notifications":[],"version":"2.3.7","streamerMode":false,"time":{"twelveHourClock":false},"locale":"tr","lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"weather":{"celcius":false},"name":"Yigits\'s Phone","latestVersion":"2.3.7","display":{"brightness":1,"automatic":false,"theme":"dark","size":0.7},"sound":{"volume":0.5,"callVolume":0.5,"texttone":"default","silent":false,"ringtone":"default"},"security":{"faceId":true,"pinCode":true},"airplaneMode":false,"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"phone":{"showCallerId":true}}', 1, 0, 100, '2025-11-03 18:15:59'),
	('TMV37328', 'TMV37328', '2055336998', 'Sada\'s Phone', '2323', NULL, '{"storage":{"used":8576331,"total":128000000},"sound":{"silent":false,"ringtone":"default","texttone":"default","callVolume":0.5,"volume":0.5},"streamerMode":false,"security":{"faceId":false,"pinCode":true},"latestVersion":"2.3.7","version":"2.3.7","locale":"tr","doNotDisturb":false,"name":"Sada\'s Phone","phone":{"showCallerId":true},"weather":{"celcius":false},"time":{"twelveHourClock":false},"airplaneMode":false,"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services","YellowPages"]],"display":{"brightness":1,"automatic":false,"size":0.7,"theme":"dark"},"notifications":[],"wallpaper":{"background":"cloud8","blur":false},"lockscreen":{"layout":1,"color":"gradient","fontStyle":1}}', 1, 0, 100, '2025-11-03 15:42:34'),
	('UON85276', 'UON85276', '6021425469', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-02 15:52:24'),
	('UYV17385', 'UYV17385', '5205633344', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-02 19:55:16'),
	('WGI37560', 'WGI37560', '5201257258', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-04 21:16:39'),
	('WJC37394', 'WJC37394', '4805337298', 'Zantree\'s Phone', NULL, NULL, '{"doNotDisturb":false,"sound":{"ringtone":"default","texttone":"default","callVolume":0.5,"silent":false,"volume":0.5},"name":"Zantree\'s Phone","time":{"twelveHourClock":false},"wallpaper":{"background":"cloud8","blur":false},"display":{"automatic":false,"theme":"dark","brightness":1,"size":0.7},"notifications":[],"streamerMode":false,"locale":"en","phone":{"showCallerId":true},"lockscreen":{"fontStyle":1,"layout":1,"color":"gradient"},"version":"2.3.7","airplaneMode":false,"storage":{"total":128000000,"used":8576331},"latestVersion":"2.3.7","weather":{"celcius":false},"security":{"faceId":false,"pinCode":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]]}', 1, 0, 100, '2025-11-04 16:10:56'),
	('XDL74210', 'XDL74210', '2055766058', 'Eric\'s Phone', '1111', NULL, '{"weather":{"celcius":false},"time":{"twelveHourClock":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services","DarkChat","TikTok","MarketPlace","Twitter","YellowPages"]],"latestVersion":"2.3.7","sound":{"callVolume":0.5,"silent":false,"volume":0.5,"texttone":"default","ringtone":"default"},"phone":{"showCallerId":true},"wallpaper":{"blur":false,"background":"cloud8"},"storage":{"total":128000000,"used":8576331},"name":"Eric\'s Phone","display":{"size":0.7,"brightness":1,"automatic":false,"theme":"dark"},"doNotDisturb":false,"locale":"tr","airplaneMode":false,"streamerMode":false,"version":"2.3.7","notifications":[],"security":{"faceId":false,"pinCode":true},"lockscreen":{"fontStyle":1,"layout":1,"color":"gradient"}}', 1, 0, 100, '2025-11-04 20:52:39'),
	('XRS51596', 'XRS51596', '6021865085', 'Sf\'s Phone', NULL, NULL, '{"doNotDisturb":false,"sound":{"ringtone":"default","volume":0.5,"callVolume":0.5,"silent":false,"texttone":"default"},"name":"Sf\'s Phone","weather":{"celcius":false},"wallpaper":{"background":"cloud8","blur":false},"display":{"automatic":false,"size":0.7,"brightness":1,"theme":"dark"},"notifications":[],"streamerMode":false,"locale":"tr","phone":{"showCallerId":true},"lockscreen":{"fontStyle":1,"layout":1,"color":"gradient"},"security":{"faceId":false,"pinCode":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Garage","Home","Maps","Notes","Calculator","VoiceMemo","Music","Services"]],"storage":{"used":8576331,"total":128000000},"latestVersion":"2.3.7","time":{"twelveHourClock":false},"airplaneMode":false,"version":"2.3.7"}', 1, 0, 100, '2025-11-03 15:24:33'),
	('YQQ65276', 'YQQ65276', '2055035265', NULL, NULL, NULL, NULL, 0, 0, 100, '2025-11-04 14:55:25');

-- Dumping structure for table crystalrp.phone_phone_blocked_numbers
CREATE TABLE IF NOT EXISTS `phone_phone_blocked_numbers` (
  `phone_number` varchar(15) NOT NULL,
  `blocked_number` varchar(15) NOT NULL,
  PRIMARY KEY (`phone_number`,`blocked_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_phone_blocked_numbers: ~0 rows (approximately)
DELETE FROM `phone_phone_blocked_numbers`;

-- Dumping structure for table crystalrp.phone_phone_calls
CREATE TABLE IF NOT EXISTS `phone_phone_calls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caller` varchar(15) NOT NULL,
  `callee` varchar(15) NOT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `answered` tinyint(1) DEFAULT 0,
  `hide_caller_id` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_calls_missed` (`callee`,`answered`),
  KEY `idx_calls_callee_id` (`callee`),
  KEY `idx_calls_caller_id` (`caller`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_phone_calls: ~9 rows (approximately)
DELETE FROM `phone_phone_calls`;
INSERT INTO `phone_phone_calls` (`id`, `caller`, `callee`, `duration`, `answered`, `hide_caller_id`, `timestamp`) VALUES
	(1, '2051560108', '2059796133', 25, 1, 0, '2025-11-03 20:17:43'),
	(2, '2051560108', '2059796133', 19, 1, 0, '2025-11-03 20:18:06'),
	(3, '2051560108', '2059796133', 0, 0, 0, '2025-11-04 00:28:26'),
	(4, '2051560108', '2059796133', 0, 0, 0, '2025-11-04 00:29:02'),
	(5, '6027776998', '2051560108', 56, 1, 0, '2025-11-04 00:34:50'),
	(6, '6027776998', '2051560108', 17, 1, 0, '2025-11-04 00:35:16'),
	(7, '6027776998', '2051560108', 0, 0, 0, '2025-11-04 11:25:22'),
	(8, '2051560108', '2059796133', 0, 0, 0, '2025-11-04 20:23:13'),
	(9, '2051560108', '2055336998', 0, 0, 0, '2025-11-04 20:23:42');

-- Dumping structure for table crystalrp.phone_phone_contacts
CREATE TABLE IF NOT EXISTS `phone_phone_contacts` (
  `contact_phone_number` varchar(15) NOT NULL,
  `firstname` varchar(50) NOT NULL DEFAULT '',
  `lastname` varchar(50) NOT NULL DEFAULT '',
  `profile_image` varchar(500) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `favourite` tinyint(1) DEFAULT 0,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`contact_phone_number`,`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_phone_contacts: ~2 rows (approximately)
DELETE FROM `phone_phone_contacts`;
INSERT INTO `phone_phone_contacts` (`contact_phone_number`, `firstname`, `lastname`, `profile_image`, `email`, `address`, `favourite`, `phone_number`) VALUES
	('2051560108', 'Asda\'s Phone', '', NULL, NULL, NULL, 0, '6027776998'),
	('2059796133', 'Zizi\'s Phone', '', NULL, NULL, NULL, 0, '2051560108');

-- Dumping structure for table crystalrp.phone_phone_voicemail
CREATE TABLE IF NOT EXISTS `phone_phone_voicemail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caller` varchar(15) NOT NULL,
  `callee` varchar(15) NOT NULL,
  `url` varchar(500) NOT NULL,
  `duration` int(11) NOT NULL,
  `hide_caller_id` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_phone_voicemail: ~0 rows (approximately)
DELETE FROM `phone_phone_voicemail`;

-- Dumping structure for table crystalrp.phone_photos
CREATE TABLE IF NOT EXISTS `phone_photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `link` varchar(500) NOT NULL,
  `is_video` tinyint(1) DEFAULT 0,
  `size` float NOT NULL DEFAULT 0,
  `metadata` varchar(20) DEFAULT NULL,
  `is_favourite` tinyint(1) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photos_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_photos: ~0 rows (approximately)
DELETE FROM `phone_photos`;

-- Dumping structure for table crystalrp.phone_photo_albums
CREATE TABLE IF NOT EXISTS `phone_photo_albums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(100) NOT NULL,
  `shared` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photo_albums_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_photo_albums: ~0 rows (approximately)
DELETE FROM `phone_photo_albums`;

-- Dumping structure for table crystalrp.phone_photo_album_members
CREATE TABLE IF NOT EXISTS `phone_photo_album_members` (
  `album_id` int(11) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  PRIMARY KEY (`album_id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photo_album_members_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `phone_photo_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_photo_album_members_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_photo_album_members: ~0 rows (approximately)
DELETE FROM `phone_photo_album_members`;

-- Dumping structure for table crystalrp.phone_photo_album_photos
CREATE TABLE IF NOT EXISTS `phone_photo_album_photos` (
  `album_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  PRIMARY KEY (`album_id`,`photo_id`),
  KEY `photo_id` (`photo_id`),
  CONSTRAINT `phone_photo_album_photos_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `phone_photo_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_photo_album_photos_ibfk_2` FOREIGN KEY (`photo_id`) REFERENCES `phone_photos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_photo_album_photos: ~0 rows (approximately)
DELETE FROM `phone_photo_album_photos`;

-- Dumping structure for table crystalrp.phone_services_channels
CREATE TABLE IF NOT EXISTS `phone_services_channels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `company` varchar(50) NOT NULL,
  `last_message` varchar(100) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_services_channels: ~0 rows (approximately)
DELETE FROM `phone_services_channels`;

-- Dumping structure for table crystalrp.phone_services_messages
CREATE TABLE IF NOT EXISTS `phone_services_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `channel_id` int(10) unsigned NOT NULL,
  `sender` varchar(15) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `x_pos` int(11) DEFAULT NULL,
  `y_pos` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_services_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_services_channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_services_messages: ~0 rows (approximately)
DELETE FROM `phone_services_messages`;

-- Dumping structure for table crystalrp.phone_tiktok_accounts
CREATE TABLE IF NOT EXISTS `phone_tiktok_accounts` (
  `name` varchar(30) NOT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `avatar` varchar(500) DEFAULT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `verified` tinyint(1) DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `like_count` int(11) NOT NULL DEFAULT 0,
  `video_count` int(11) NOT NULL DEFAULT 0,
  `twitter` varchar(20) DEFAULT NULL,
  `instagram` varchar(20) DEFAULT NULL,
  `show_likes` tinyint(1) DEFAULT 1,
  `phone_number` varchar(15) NOT NULL,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_tiktok_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_accounts: ~0 rows (approximately)
DELETE FROM `phone_tiktok_accounts`;

-- Dumping structure for table crystalrp.phone_tiktok_channels
CREATE TABLE IF NOT EXISTS `phone_tiktok_channels` (
  `id` varchar(10) NOT NULL,
  `last_message` varchar(50) NOT NULL,
  `member_1` varchar(20) NOT NULL,
  `member_2` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `member_1` (`member_1`,`member_2`),
  KEY `member_2` (`member_2`),
  CONSTRAINT `phone_tiktok_channels_ibfk_1` FOREIGN KEY (`member_1`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_channels_ibfk_2` FOREIGN KEY (`member_2`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_channels: ~0 rows (approximately)
DELETE FROM `phone_tiktok_channels`;

-- Dumping structure for table crystalrp.phone_tiktok_comments
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments` (
  `id` varchar(10) NOT NULL,
  `reply_to` varchar(10) DEFAULT NULL,
  `video_id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `comment` varchar(550) NOT NULL,
  `likes` int(11) NOT NULL DEFAULT 0,
  `replies` int(11) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `video_id` (`video_id`),
  KEY `username` (`username`),
  KEY `reply_to` (`reply_to`),
  CONSTRAINT `phone_tiktok_comments_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_3` FOREIGN KEY (`reply_to`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_comments: ~0 rows (approximately)
DELETE FROM `phone_tiktok_comments`;

-- Dumping structure for table crystalrp.phone_tiktok_comments_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments_likes` (
  `username` varchar(20) NOT NULL,
  `comment_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`comment_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_2` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_comments_likes: ~0 rows (approximately)
DELETE FROM `phone_tiktok_comments_likes`;

-- Dumping structure for table crystalrp.phone_tiktok_follows
CREATE TABLE IF NOT EXISTS `phone_tiktok_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_tiktok_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_follows: ~0 rows (approximately)
DELETE FROM `phone_tiktok_follows`;

-- Dumping structure for table crystalrp.phone_tiktok_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_likes` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_likes_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_likes: ~0 rows (approximately)
DELETE FROM `phone_tiktok_likes`;

-- Dumping structure for table crystalrp.phone_tiktok_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_messages` (
  `id` varchar(10) NOT NULL,
  `channel_id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `content` varchar(500) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_tiktok_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_messages: ~0 rows (approximately)
DELETE FROM `phone_tiktok_messages`;

-- Dumping structure for table crystalrp.phone_tiktok_notifications
CREATE TABLE IF NOT EXISTS `phone_tiktok_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `video_id` varchar(10) DEFAULT NULL,
  `comment_id` varchar(10) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  KEY `video_id` (`video_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_3` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_4` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_notifications: ~0 rows (approximately)
DELETE FROM `phone_tiktok_notifications`;

-- Dumping structure for table crystalrp.phone_tiktok_pinned_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_pinned_videos` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_pinned_videos: ~0 rows (approximately)
DELETE FROM `phone_tiktok_pinned_videos`;

-- Dumping structure for table crystalrp.phone_tiktok_saves
CREATE TABLE IF NOT EXISTS `phone_tiktok_saves` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_saves_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_saves_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_saves: ~0 rows (approximately)
DELETE FROM `phone_tiktok_saves`;

-- Dumping structure for table crystalrp.phone_tiktok_unread_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_unread_messages` (
  `username` varchar(20) NOT NULL,
  `channel_id` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`username`,`channel_id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_2` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_unread_messages: ~0 rows (approximately)
DELETE FROM `phone_tiktok_unread_messages`;

-- Dumping structure for table crystalrp.phone_tiktok_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_videos` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `src` varchar(500) NOT NULL,
  `caption` varchar(100) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `music` text DEFAULT NULL,
  `likes` int(11) NOT NULL DEFAULT 0,
  `comments` int(11) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  `saves` int(11) NOT NULL DEFAULT 0,
  `pinned_comment` varchar(10) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_tiktok_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_videos: ~0 rows (approximately)
DELETE FROM `phone_tiktok_videos`;

-- Dumping structure for table crystalrp.phone_tiktok_views
CREATE TABLE IF NOT EXISTS `phone_tiktok_views` (
  `username` varchar(20) NOT NULL,
  `video_id` varchar(10) NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_views_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_views_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tiktok_views: ~0 rows (approximately)
DELETE FROM `phone_tiktok_views`;

-- Dumping structure for table crystalrp.phone_tinder_accounts
CREATE TABLE IF NOT EXISTS `phone_tinder_accounts` (
  `name` varchar(50) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `photos` text DEFAULT NULL,
  `bio` varchar(500) DEFAULT NULL,
  `dob` date NOT NULL,
  `is_male` tinyint(1) NOT NULL,
  `interested_men` tinyint(1) NOT NULL,
  `interested_women` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `last_seen` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`phone_number`),
  CONSTRAINT `phone_tinder_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tinder_accounts: ~0 rows (approximately)
DELETE FROM `phone_tinder_accounts`;

-- Dumping structure for table crystalrp.phone_tinder_matches
CREATE TABLE IF NOT EXISTS `phone_tinder_matches` (
  `phone_number_1` varchar(15) NOT NULL,
  `phone_number_2` varchar(15) NOT NULL,
  `latest_message` varchar(1000) DEFAULT NULL,
  `latest_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`phone_number_1`,`phone_number_2`),
  KEY `phone_number_2` (`phone_number_2`),
  CONSTRAINT `phone_tinder_matches_ibfk_1` FOREIGN KEY (`phone_number_1`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_matches_ibfk_2` FOREIGN KEY (`phone_number_2`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tinder_matches: ~0 rows (approximately)
DELETE FROM `phone_tinder_matches`;

-- Dumping structure for table crystalrp.phone_tinder_messages
CREATE TABLE IF NOT EXISTS `phone_tinder_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(15) NOT NULL,
  `recipient` varchar(15) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_tinder_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tinder_messages: ~0 rows (approximately)
DELETE FROM `phone_tinder_messages`;

-- Dumping structure for table crystalrp.phone_tinder_swipes
CREATE TABLE IF NOT EXISTS `phone_tinder_swipes` (
  `swiper` varchar(15) NOT NULL,
  `swipee` varchar(15) NOT NULL,
  `liked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`swiper`,`swipee`),
  KEY `swipee` (`swipee`),
  CONSTRAINT `phone_tinder_swipes_ibfk_1` FOREIGN KEY (`swiper`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_swipes_ibfk_2` FOREIGN KEY (`swipee`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_tinder_swipes: ~0 rows (approximately)
DELETE FROM `phone_tinder_swipes`;

-- Dumping structure for table crystalrp.phone_tweets
CREATE TABLE IF NOT EXISTS `phone_tweets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `firstName` varchar(25) DEFAULT NULL,
  `lastName` varchar(25) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp(),
  `url` text DEFAULT NULL,
  `picture` varchar(512) DEFAULT './img/default.png',
  `tweetId` varchar(25) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.phone_tweets: ~0 rows (approximately)
DELETE FROM `phone_tweets`;

-- Dumping structure for table crystalrp.phone_twitter_accounts
CREATE TABLE IF NOT EXISTS `phone_twitter_accounts` (
  `display_name` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(100) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `bio` varchar(100) DEFAULT NULL,
  `profile_image` varchar(500) DEFAULT NULL,
  `profile_header` varchar(500) DEFAULT NULL,
  `pinned_tweet` varchar(50) DEFAULT NULL,
  `verified` tinyint(1) DEFAULT 0,
  `follower_count` int(11) NOT NULL DEFAULT 0,
  `following_count` int(11) NOT NULL DEFAULT 0,
  `private` tinyint(1) DEFAULT 0,
  `date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_twitter_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_accounts: ~0 rows (approximately)
DELETE FROM `phone_twitter_accounts`;

-- Dumping structure for table crystalrp.phone_twitter_follows
CREATE TABLE IF NOT EXISTS `phone_twitter_follows` (
  `followed` varchar(20) NOT NULL,
  `follower` varchar(20) NOT NULL,
  `notifications` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_twitter_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_follows: ~0 rows (approximately)
DELETE FROM `phone_twitter_follows`;

-- Dumping structure for table crystalrp.phone_twitter_follow_requests
CREATE TABLE IF NOT EXISTS `phone_twitter_follow_requests` (
  `requester` varchar(20) NOT NULL,
  `requestee` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_twitter_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_follow_requests: ~0 rows (approximately)
DELETE FROM `phone_twitter_follow_requests`;

-- Dumping structure for table crystalrp.phone_twitter_hashtags
CREATE TABLE IF NOT EXISTS `phone_twitter_hashtags` (
  `hashtag` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `last_used` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`hashtag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_hashtags: ~0 rows (approximately)
DELETE FROM `phone_twitter_hashtags`;

-- Dumping structure for table crystalrp.phone_twitter_likes
CREATE TABLE IF NOT EXISTS `phone_twitter_likes` (
  `tweet_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_likes: ~0 rows (approximately)
DELETE FROM `phone_twitter_likes`;

-- Dumping structure for table crystalrp.phone_twitter_messages
CREATE TABLE IF NOT EXISTS `phone_twitter_messages` (
  `id` varchar(10) NOT NULL,
  `sender` varchar(20) NOT NULL,
  `recipient` varchar(20) NOT NULL,
  `content` varchar(1000) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_twitter_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_messages: ~0 rows (approximately)
DELETE FROM `phone_twitter_messages`;

-- Dumping structure for table crystalrp.phone_twitter_notifications
CREATE TABLE IF NOT EXISTS `phone_twitter_notifications` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `from` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `tweet_id` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_twitter_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_notifications: ~0 rows (approximately)
DELETE FROM `phone_twitter_notifications`;

-- Dumping structure for table crystalrp.phone_twitter_promoted
CREATE TABLE IF NOT EXISTS `phone_twitter_promoted` (
  `tweet_id` varchar(50) NOT NULL,
  `promotions` int(11) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tweet_id`),
  CONSTRAINT `phone_twitter_promoted_ibfk_1` FOREIGN KEY (`tweet_id`) REFERENCES `phone_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_promoted: ~0 rows (approximately)
DELETE FROM `phone_twitter_promoted`;

-- Dumping structure for table crystalrp.phone_twitter_retweets
CREATE TABLE IF NOT EXISTS `phone_twitter_retweets` (
  `tweet_id` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_retweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_retweets: ~0 rows (approximately)
DELETE FROM `phone_twitter_retweets`;

-- Dumping structure for table crystalrp.phone_twitter_tweets
CREATE TABLE IF NOT EXISTS `phone_twitter_tweets` (
  `id` varchar(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `content` varchar(280) DEFAULT NULL,
  `attachments` text DEFAULT NULL,
  `reply_to` varchar(50) DEFAULT NULL,
  `like_count` int(11) DEFAULT 0,
  `reply_count` int(11) DEFAULT 0,
  `retweet_count` int(11) DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_tweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_twitter_tweets: ~0 rows (approximately)
DELETE FROM `phone_twitter_tweets`;

-- Dumping structure for table crystalrp.phone_voice_memos_recordings
CREATE TABLE IF NOT EXISTS `phone_voice_memos_recordings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `file_url` varchar(500) NOT NULL,
  `file_length` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_voice_memos_recordings_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_voice_memos_recordings: ~0 rows (approximately)
DELETE FROM `phone_voice_memos_recordings`;

-- Dumping structure for table crystalrp.phone_wallet_transactions
CREATE TABLE IF NOT EXISTS `phone_wallet_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `amount` int(11) NOT NULL,
  `company` varchar(50) NOT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_wallet_transactions_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_wallet_transactions: ~0 rows (approximately)
DELETE FROM `phone_wallet_transactions`;

-- Dumping structure for table crystalrp.phone_yellow_pages_posts
CREATE TABLE IF NOT EXISTS `phone_yellow_pages_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `attachment` varchar(500) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crystalrp.phone_yellow_pages_posts: ~2 rows (approximately)
DELETE FROM `phone_yellow_pages_posts`;
INSERT INTO `phone_yellow_pages_posts` (`id`, `phone_number`, `title`, `description`, `attachment`, `price`, `timestamp`) VALUES
	(1, '2055336998', 'EMİR KAZGAN ALLAHI BENİM', 'EMİR KAZGAN ALLAHI BENİM', NULL, 31, '2025-11-02 15:37:49'),
	(2, '5209228674', 'ACILISSSSSSSSSSSSSSSSSSSSSSSSSSSSSS', 'S', NULL, NULL, '2025-11-02 21:29:04');

-- Dumping structure for table crystalrp.players
CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `cid` int(11) DEFAULT NULL,
  `license` varchar(255) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci 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(),
  `craftxp` int(11) DEFAULT 0,
  `aranma` mediumtext DEFAULT '[]',
  `motel_type` longtext DEFAULT 'basic',
  `iban` char(50) DEFAULT NULL,
  `pedname` longtext DEFAULT NULL,
  `pedcount` int(11) DEFAULT 0,
  `addiction` text DEFAULT NULL,
  `ranks` longtext DEFAULT NULL,
  `evidences` longtext DEFAULT NULL,
  `mdt_ems_picture` longtext DEFAULT NULL,
  `mdt_ems_searched` int(11) DEFAULT 0,
  `apps` text DEFAULT NULL,
  `widget` text DEFAULT NULL,
  `bt` text DEFAULT NULL,
  `cryptocurrency` longtext DEFAULT NULL,
  `cryptocurrencytransfers` text DEFAULT NULL,
  `phonePos` text DEFAULT NULL,
  `spotify` text DEFAULT NULL,
  `ringtone` text DEFAULT NULL,
  `first_screen_showed` int(11) DEFAULT NULL,
  `socialSupport` varchar(255) NOT NULL DEFAULT '0',
  `warns` int(11) NOT NULL DEFAULT 0,
  `warzone` longtext NOT NULL DEFAULT '[]',
  `playtime` int(11) NOT NULL DEFAULT 0,
  `frkn_fuelstation_control` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`citizenid`),
  KEY `id` (`id`),
  KEY `last_updated` (`last_updated`),
  KEY `license` (`license`)
) ENGINE=InnoDB AUTO_INCREMENT=2999 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table crystalrp.players: ~43 rows (approximately)
DELETE FROM `players`;
INSERT INTO `players` (`id`, `citizenid`, `cid`, `license`, `name`, `money`, `charinfo`, `job`, `gang`, `position`, `metadata`, `inventory`, `phone_number`, `last_updated`, `craftxp`, `aranma`, `motel_type`, `iban`, `pedname`, `pedcount`, `addiction`, `ranks`, `evidences`, `mdt_ems_picture`, `mdt_ems_searched`, `apps`, `widget`, `bt`, `cryptocurrency`, `cryptocurrencytransfers`, `phonePos`, `spotify`, `ringtone`, `first_screen_showed`, `socialSupport`, `warns`, `warzone`, `playtime`, `frkn_fuelstation_control`) VALUES
	(1596, 'AEY78871', 1, 'license:04215906f5a4c85a762e63fe26f7bebf17773b6f', 'semihGNGR.01', '{"bank":150000,"crypto":0,"cash":9900}', '{"cid":"1","phone":"887322","lastname":"Güngör","gender":0,"birthdate":"2010-03-03","nationality":"Turkey","account":"US02QBCore3740187034","iban":797809,"backstory":"placeholder backstory","firstname":"Semih"}', '{"onduty":true,"grade":{"name":"Freelancer","level":0},"isboss":false,"name":"unemployed","payment":10,"label":"Civilian","type":"none"}', '{"name":"none","grade":{"name":"none","level":0},"isboss":false,"label":"No Gang Affiliaton"}', '{"x":-1847.5648193359376,"y":-415.20001220703127,"z":45.3714599609375}', '{"playtime":1,"hunger":97,"FFAStats":{"matchwin":0,"body":0,"legs":0,"killcount":0,"deathcount":0,"arms":0,"headrate":0,"head":0},"commandbinds":[],"isdead":false,"ishandcuffed":false,"fitbit":[],"thirst":98,"armor":0,"attachmentcraftingrep":0,"phonedata":{"InstalledApps":[],"SerialNumber":50542581},"inside":{"apartment":[]},"tracker":false,"inlaststand":false,"criminalrecord":{"hasRecord":false},"phone":[],"walletid":"QB-74003808","callsign":"NO CALLSIGN","status":[],"bloodtype":"B+","fingerprint":"UG585O11voE2163","jailitems":[],"stress":0,"playtimereward":false,"dealerrep":0,"licences":{"business":false,"weapon":false,"driver":true},"injail":0,"jobrep":{"tow":0,"trucker":0,"taxi":0,"hotdog":0},"craftingrep":0}', '[{"count":9900,"slot":1,"name":"money"},{"count":1,"slot":2,"metadata":{"gender":0,"firstname":"Semih","lastname":"Güngör","birthdate":"2010-03-03","nationality":"Turkey","citizenid":"AEY78871"},"name":"id_card"},{"count":1,"slot":3,"metadata":{"type":"Class C Driver License","firstname":"Semih","lastname":"Güngör","birthdate":"2010-03-03"},"name":"driver_license"},{"count":10,"slot":4,"name":"water"},{"count":1,"slot":5,"name":"phone"},{"count":10,"slot":6,"name":"burger"}]', NULL, '2025-03-14 15:31:19', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1845, 'AHY06468', 1, 'license:585f4223ffddc61254cd8fd0bd9653d392cedae0', 'Pablo Escobar', '{"crypto":0,"bank":150120,"cash":9545510000}', '{"gender":0,"backstory":"placeholder backstory","firstname":"Esco","iban":12251,"phone":"218627","lastname":"Gaviria","cid":"1","birthdate":"1995-11-20","nationality":"Colombia","account":"US08QBCore3445383730"}', '{"type":"none","onduty":true,"isboss":true,"payment":100,"label":"Extra Mechanic","name":"illegalmechanic","grade":{"name":"Patron","level":2}}', '{"isboss":false,"label":"No Gang Affiliaton","name":"none","grade":{"name":"none","level":0}}', '{"x":493.1340637207031,"y":-446.78240966796877,"z":29.2967529296875}', '{"licences":{"weapon":false,"driver":true,"business":false},"jobrep":{"taxi":0,"hotdog":0,"trucker":0,"tow":0},"FFAStats":{"legs":0,"killcount":0,"deathcount":0,"head":0,"arms":0,"headrate":0,"matchwin":0,"body":0},"fingerprint":"ew483Y76Rwh7656","hunger":94,"callsign":"NO CALLSIGN","walletid":"QB-32755591","inlaststand":false,"status":[],"commandbinds":[],"ishandcuffed":false,"phone":[],"phonedata":{"InstalledApps":[],"SerialNumber":66083004},"stress":0,"thirst":96,"attachmentcraftingrep":0,"fitbit":[],"playtimereward":false,"playtime":120,"dealerrep":0,"tracker":false,"isdead":false,"injail":0,"inside":{"apartment":[]},"craftingrep":0,"jailitems":[],"criminalrecord":{"hasRecord":false},"armor":0,"bloodtype":"AB+"}', '[{"name":"ammo-9","slot":1,"count":6},{"name":"phone","slot":2,"count":1},{"metadata":{"registered":"Esco Gaviria","durability":99.21999999999999,"components":[],"serial":"753140EIM185016","ammo":12},"name":"WEAPON_G19","slot":3,"count":1},{"metadata":{"type":"Class C Driver License","birthdate":"1995-11-20","lastname":"Gaviria","firstname":"Esco"},"name":"driver_license","slot":4,"count":1},{"metadata":{"firstname":"Esco","gender":0,"nationality":"Colombia","lastname":"Gaviria","birthdate":"1995-11-20"},"name":"id_card","slot":5,"count":1},{"name":"money","slot":6,"count":9545510000}]', NULL, '2025-03-20 23:55:48', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2826, 'ATL68952', 1, 'license:38a65a54ff5b4be94caa603aa85d4e1f35b9cfc6', 'Finishig', '{"cash":1.00000000001001e30,"crypto":0,"bank":150020}', '{"backstory":"placeholder backstory","firstname":"Abbas","phone":"564357","iban":144552,"account":"US04QBCore5562530478","cid":"1","birthdate":"1993-05-14","lastname":"Yanbakan","nationality":"Brazil","gender":0}', '{"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"onduty":true,"isboss":false,"payment":10,"type":"none"}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-682.5626220703125,"y":-1057.4901123046876,"z":15.5640869140625}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"bloodtype":"AB+","FFAStats":{"arms":0,"headrate":0,"body":0,"matchwin":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","phonedata":{"SerialNumber":42557191,"InstalledApps":[]},"fingerprint":"Zw321h77GRt8688","attachmentcraftingrep":0,"tracker":false,"injail":0,"commandbinds":[],"walletid":"QB-54515020","ishandcuffed":false,"inside":{"apartment":[]},"craftingrep":0,"stress":0,"phone":[],"dealerrep":0,"armor":0,"inlaststand":false,"jailitems":[],"thirst":100,"hunger":100,"criminalrecord":{"hasRecord":false},"isdead":false,"fitbit":[]}', '[{"name":"money","count":1.00000000001001e30,"slot":1},{"name":"phone","count":1,"slot":2},{"name":"id_card","count":1,"metadata":{"nationality":"Brazil","firstname":"Abbas","birthdate":"1993-05-14","lastname":"Yanbakan","gender":0},"slot":3},{"name":"driver_license","count":1,"metadata":{"firstname":"Abbas","type":"Class C Driver License","lastname":"Yanbakan","birthdate":"1993-05-14"},"slot":4},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"641712YOR564317","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":5},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"482513DZU668470","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":6},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"100751YYJ419499","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":7},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"979446VGG508477","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":8},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"367264DZY582381","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":9},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"811720ZSN542119","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":10},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"182891CSR394358","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":11},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"714545YWD410442","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":12},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"542957XUG202182","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":13},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"477337OAT594070","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":14},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"488069LWL856806","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":15},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"734612LTK937395","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":16},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"363085QQE965797","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":17},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"263176HCE767872","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":18},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"842522ESG109726","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":19},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"170253LPY753064","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":20},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"377792BRM338103","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":21},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"959287GOE115565","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":22},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"365629CUN919037","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":23},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"586458HJJ121809","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":24},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"775490OKF228231","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":25},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"687323VHM571656","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":26},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"314952GZN918033","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":27},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"757872ZVO470330","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":28},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"303083YCY242879","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":29},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"501191ZWD282649","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":30},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"335442SSX823225","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":31},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"673404OXJ524659","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":32},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"520453IRP621338","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":33},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"747735DPW388600","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":34},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"932132ALB506535","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":35},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"976058KZQ935112","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":36},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"672907JBK387029","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":37},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"210379LDF388580","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":38},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"169355URC856448","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":39},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"566695WIQ323266","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":40},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"627274OBI506657","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":41},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"255483UVI524184","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":42},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"944026NUH584597","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":43},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"989081HJW377108","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":44},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"810583KLT739428","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":45},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"793401EDR758798","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":46},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"359256KUG246427","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":47},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"862525FGQ707823","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":48},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"460824IQN188652","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":49},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"632006GZD789544","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":50},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"294974QPP522708","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":51},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"578516IEN906902","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":52},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"731410ZGT616650","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":53},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"792028ZOG653287","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":54},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"179312LJH928772","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":55},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"475736GDE577465","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":56},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"653634KDZ130816","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":57},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"626201ISU125102","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":58},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"226554PLN323617","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":59},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"204914CCE607387","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":60},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"354928OCB458318","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":61},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"339290YQQ481714","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":62},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"196568TPS393107","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":63},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"854400CKL572475","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":64},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"523263WWR553890","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":65},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"108047EMZ796113","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":66},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"121517KUC401685","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":67},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"204052UDO913073","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":68},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"896356LHU815430","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":69},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"474171JKU707396","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":70},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"257357HJI363930","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":71},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"988281EGK636048","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":72},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"647255SPN225491","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":73},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"727939XBL644293","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":74},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"601308CRX395669","registered":"Abbas Yanbakan","ammo":0,"components":[],"durability":100},"slot":75}]', NULL, '2025-11-04 15:35:43', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1797, 'BEL96112', 1, 'license:4e4770721d962667da920aec6e7b4247bb25d782', 'Umut', '{"crypto":0,"bank":149700,"cash":9980}', '{"nationality":"United Arab Emirates","cid":"1","backstory":"placeholder backstory","account":"US02QBCore6196879153","firstname":"Cznn","gender":0,"phone":"434569","iban":969595,"lastname":"Daltonn","birthdate":"2004-02-05"}', '{"label":"Civilian","type":"none","isboss":false,"grade":{"name":"Freelancer","level":0},"name":"unemployed","payment":10,"onduty":true}', '{"grade":{"name":"none","level":0},"name":"none","label":"No Gang Affiliaton","isboss":false}', '{"x":-1455.191162109375,"y":-753.7977905273438,"z":23.2813720703125}', '{"callsign":"NO CALLSIGN","status":[],"playtimereward":false,"craftingrep":0,"thirst":96,"jailitems":[],"phonedata":{"SerialNumber":85801511,"InstalledApps":[]},"FFAStats":{"body":0,"matchwin":0,"headrate":0,"deathcount":0,"killcount":0,"legs":0,"arms":0,"head":0},"phone":[],"fingerprint":"xK636g17rgM0847","stress":0,"bloodtype":"A-","armor":0,"walletid":"QB-92473935","criminalrecord":{"hasRecord":false},"dealerrep":0,"jobrep":{"hotdog":0,"trucker":0,"taxi":0,"tow":0},"inside":{"apartment":[]},"attachmentcraftingrep":0,"tracker":false,"playtime":3,"isdead":false,"injail":0,"commandbinds":[],"fitbit":[],"licences":{"driver":true,"weapon":false,"business":false},"ishandcuffed":false,"hunger":94,"inlaststand":false}', '[{"count":9980,"slot":1,"name":"money"},{"count":1,"slot":2,"name":"phone"},{"count":1,"metadata":{"lastname":"Daltonn","birthdate":"2004-02-05","gender":0,"firstname":"Cznn","nationality":"United Arab Emirates"},"slot":3,"name":"id_card"},{"count":1,"metadata":{"lastname":"Daltonn","birthdate":"2004-02-05","firstname":"Cznn","type":"Class C Driver License"},"slot":4,"name":"driver_license"},{"count":1,"metadata":{"label":"LIGHTV2069"},"slot":5,"name":"rentalpapers"},{"count":1,"metadata":{"label":"LIGHTV5010"},"slot":6,"name":"rentalpapers"}]', NULL, '2025-03-20 03:52:23', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2303, 'BNN74169', 1, 'license:05d4ed4aa64596922124c0a93d08633b9f41ad40', 'CaSaBlaNcA x ZeuS', '{"bank":150735,"cash":53023,"crypto":0}', '{"gender":0,"firstname":"Zeus","nationality":"Afghanistan","iban":166054,"birthdate":"2000-03-06","cid":"1","phone":"971303","account":"US09QBCore5497975312","lastname":"NiNjA","backstory":"placeholder backstory"}', '{"grade":{"level":15,"name":"Chief"},"isboss":true,"label":"LSPD","name":"police","onduty":true,"payment":245,"type":"leo"}', '{"grade":{"level":0,"name":"none"},"isboss":false,"name":"none","label":"No Gang Affiliaton"}', '{"x":-815.4197998046875,"y":-1131.046142578125,"z":8.82421875}', '{"injail":0,"armor":0,"dealerrep":0,"status":[],"inlaststand":false,"stress":0,"bloodtype":"B+","jailitems":[],"attachmentcraftingrep":0,"walletid":"QB-87314221","criminalrecord":{"hasRecord":false},"fingerprint":"PU873t74Jjp8160","FFAStats":{"matchwin":0,"legs":0,"arms":0,"killcount":0,"head":0,"deathcount":0,"body":0,"headrate":0},"jobrep":{"taxi":0,"tow":0,"trucker":0,"hotdog":0},"callsign":"NO CALLSIGN","commandbinds":[],"licences":{"driver":true,"weapon":false,"business":false},"ishandcuffed":false,"craftingrep":0,"isdead":true,"phonedata":{"InstalledApps":[],"SerialNumber":84882370},"phone":[],"hunger":100,"fitbit":[],"thirst":100,"inside":{"apartment":[]},"tracker":false}', '[{"count":1,"name":"WEAPON_SMG","metadata":{"durability":63.2,"serial":"247624MOC898793","ammo":104,"components":[],"registered":"Rico Ewdas"},"slot":1},{"count":26,"name":"ammo-smg","slot":2},{"count":1,"name":"id_card","metadata":{"birthdate":"2000-03-06","lastname":"NiNjA","gender":0,"nationality":"Afghanistan","firstname":"Zeus"},"slot":3},{"count":1,"name":"driver_license","metadata":{"birthdate":"2000-03-06","lastname":"NiNjA","firstname":"Zeus","type":"Class C Driver License"},"slot":4},{"count":53023,"name":"money","slot":5},{"count":1,"name":"namlu","slot":6},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":0,"serial":"323978PLA497821","ammo":54,"components":[],"registered":"Rıco Karımdır"},"slot":7},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"serial":"221940NIZ756506","ammo":0,"components":[],"registered":"Rico Ewdas"},"slot":8},{"count":1,"name":"tutamac","slot":9},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"serial":"593820UAM145869","ammo":0,"components":[],"registered":"Rico Ewdas"},"slot":10},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"serial":"415311ZUX338056","ammo":0,"components":[],"registered":"Rico Ewdas"},"slot":11},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"serial":"979305QLP119191","ammo":0,"components":[],"registered":"Rico Ewdas"},"slot":12},{"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"serial":"616576ENR728118","ammo":0,"components":[],"registered":"Rıco Karımdır"},"slot":13},{"count":2,"name":"yay","slot":14},{"count":1,"name":"phone","slot":15},{"count":2,"name":"sarjor","slot":16},{"count":1,"name":"tetik","slot":17},{"count":1,"name":"WEAPON_G19","metadata":{"durability":97.47999999999994,"serial":"122173EZI804876","ammo":126,"components":[],"registered":"Fypenos G"},"slot":18},{"count":10,"name":"ammo-9","slot":19}]', NULL, '2025-11-03 18:12:48', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1800, 'BTO14085', 1, 'license:6a29fce8a3ca66dfce88ed4aed3e586ed5bba20e', 'akinustun0', '{"bank":80010,"cash":9990,"crypto":0}', '{"firstname":"Cumali","backstory":"placeholder backstory","birthdate":"1997-05-01","phone":"734316","account":"US02QBCore6389923396","gender":0,"nationality":"Turkey","cid":"1","iban":472935,"lastname":"Koçovalı"}', '{"onduty":true,"payment":10,"name":"unemployed","grade":{"level":0,"name":"Freelancer"},"type":"none","label":"Civilian","isboss":false}', '{"grade":{"level":0,"name":"none"},"isboss":false,"label":"No Gang Affiliaton","name":"none"}', '{"x":3565.239501953125,"y":3646.140625,"z":41.3275146484375}', '{"status":[],"playtime":17,"injail":0,"bloodtype":"B-","walletid":"QB-63996078","fitbit":[],"phone":[],"isdead":false,"licences":{"driver":true,"weapon":false,"business":false},"playtimereward":false,"thirst":94,"stress":0,"tracker":false,"FFAStats":{"killcount":0,"arms":0,"head":0,"profile":"https://avatars.steamstatic.com/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_full.jpg","matchwin":0,"deathcount":0,"ingame":true,"legs":0,"headrate":0,"body":0},"commandbinds":[],"criminalrecord":{"hasRecord":false},"fingerprint":"Vk578w70XgQ1969","armor":0,"callsign":"NO CALLSIGN","attachmentcraftingrep":0,"craftingrep":0,"ishandcuffed":false,"jailitems":[],"dealerrep":0,"inside":{"apartment":[]},"hunger":91,"inlaststand":false,"phonedata":{"InstalledApps":[],"SerialNumber":57662093},"jobrep":{"trucker":0,"taxi":0,"tow":0,"hotdog":0}}', '[{"slot":1,"count":9990,"name":"money"},{"slot":2,"count":1,"name":"phone"},{"metadata":{"nationality":"Turkey","firstname":"Cumali","gender":0,"birthdate":"1997-05-01","lastname":"Koçovalı"},"slot":3,"count":1,"name":"id_card"},{"metadata":{"firstname":"Cumali","lastname":"Koçovalı","birthdate":"1997-05-01","type":"Class C Driver License"},"slot":4,"count":1,"name":"driver_license"},{"metadata":{"label":"LIGHTV8471"},"slot":5,"count":1,"name":"rentalpapers"}]', NULL, '2025-03-18 11:09:49', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1868, 'CCT80766', 1, 'license:ea953d08df4d6ca535a4d21695d07de869a67a9e', '! Doruk', '{"cash":10000,"crypto":0,"bank":150030}', '{"firstname":"Rafa","lastname":"Silva","phone":"298881","nationality":"Turkey","cid":"1","iban":970570,"birthdate":"2000-01-22","gender":0,"backstory":"placeholder backstory","account":"US04QBCore1373379673"}', '{"grade":{"name":"Freelancer","level":0},"label":"Civilian","type":"none","name":"unemployed","isboss":false,"payment":10,"onduty":true}', '{"name":"none","isboss":false,"label":"No Gang Affiliaton","grade":{"name":"none","level":0}}', '{"x":-615.019775390625,"y":-565.1736450195313,"z":34.958251953125}', '{"thirst":84,"status":[],"injail":0,"FFAStats":{"body":0,"head":0,"deathcount":0,"legs":0,"matchwin":0,"arms":0,"headrate":0,"killcount":0},"craftingrep":0,"commandbinds":[],"tracker":false,"bloodtype":"O+","phone":[],"phonedata":{"SerialNumber":73710294,"InstalledApps":[]},"stress":0,"licences":{"business":false,"weapon":false,"driver":true},"playtimereward":false,"isdead":false,"ishandcuffed":false,"playtime":120,"inside":{"apartment":[]},"armor":0,"attachmentcraftingrep":0,"fitbit":[],"callsign":"NO CALLSIGN","walletid":"QB-99425045","inlaststand":false,"criminalrecord":{"hasRecord":false},"jobrep":{"hotdog":0,"tow":0,"trucker":0,"taxi":0},"dealerrep":0,"fingerprint":"iY265i24mwf3830","jailitems":[],"hunger":76}', '[{"name":"money","slot":1,"count":10000},{"name":"phone","slot":2,"count":1},{"metadata":{"firstname":"Rafa","gender":0,"lastname":"Silva","birthdate":"2000-01-22","nationality":"Turkey"},"name":"id_card","slot":3,"count":1},{"metadata":{"firstname":"Rafa","birthdate":"2000-01-22","type":"Class C Driver License","lastname":"Silva"},"name":"driver_license","slot":4,"count":1}]', NULL, '2025-03-19 16:54:20', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2242, 'DER51835', 1, 'license:fb9bafa16730e620ba108210f4f623683935e33e', ' axed', '{"cash":0,"crypto":0,"bank":149050}', '{"account":"US01QBCore6445287443","birthdate":"2001-02-01","cid":"1","backstory":"placeholder backstory","nationality":"United Arab Emirates","gender":0,"phone":"333449","firstname":"Axed","iban":541208,"lastname":"Baba"}', '{"label":"Civilian","payment":10,"grade":{"level":0,"name":"Freelancer"},"isboss":false,"name":"unemployed","type":"none","onduty":true}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-227.38021850585938,"y":-1131.7978515625,"z":22.3714599609375}', '{"jobrep":{"tow":0,"taxi":0,"hotdog":0,"trucker":0},"FFAStats":{"deathcount":0,"arms":0,"body":0,"killcount":0,"matchwin":0,"headrate":0,"head":0,"legs":0},"dealerrep":0,"armor":0,"attachmentcraftingrep":0,"ishandcuffed":false,"injail":0,"phone":[],"inside":{"apartment":[]},"walletid":"QB-15525855","stress":0,"isdead":false,"status":[],"hunger":100,"fingerprint":"eb303u08gxb5295","tracker":false,"callsign":"NO CALLSIGN","jailitems":[],"inlaststand":false,"fitbit":[],"craftingrep":0,"licences":{"driver":true,"business":false,"weapon":false},"phonedata":{"SerialNumber":62998834,"InstalledApps":[]},"criminalrecord":{"hasRecord":false},"commandbinds":[],"bloodtype":"B-","thirst":100}', NULL, NULL, '2025-11-03 19:58:31', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2468, 'DVD07998', 1, 'license:5dfe5f48ff9b14901a40705e7b26b2f2b42ca953', 'X AWP', '{"cash":0,"crypto":0,"bank":151960}', '{"backstory":"placeholder backstory","firstname":"Efe","phone":"971164","iban":855480,"lastname":"Sarsılmaz","cid":"1","birthdate":"1999-10-12","account":"US03QBCore1207921430","nationality":"Turkey","gender":0}', '{"label":"LSPD","payment":245,"grade":{"level":15,"name":"Chief"},"onduty":true,"name":"police","type":"leo","isboss":true}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":502.4043884277344,"y":-3032.32080078125,"z":6.060791015625}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"bloodtype":"AB+","FFAStats":{"body":0,"headrate":0,"matchwin":0,"arms":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"phonedata":{"InstalledApps":[],"SerialNumber":58560497},"callsign":"NO CALLSIGN","jailitems":[],"fingerprint":"sp660w40xDL3212","jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"tracker":false,"injail":0,"commandbinds":[],"walletid":"QB-48612540","ishandcuffed":false,"inside":{"apartment":[]},"hunger":85,"fitbit":[],"phone":[],"dealerrep":0,"armor":100,"attachmentcraftingrep":0,"stress":0,"thirst":90,"inlaststand":false,"criminalrecord":{"hasRecord":false},"craftingrep":0,"isdead":false}', '[{"name":"WEAPON_APPISTOL","count":1,"metadata":{"serial":"749143MMZ697276","registered":"Efe Sarsılmaz","ammo":85,"components":[],"durability":83.30000000000011},"slot":1},{"name":"WEAPON_CARBINERIFLE","count":1,"metadata":{"serial":"708176CND589246","registered":"Efe Sarsılmaz","ammo":195,"components":[],"durability":97.74999999999996},"slot":2},{"name":"ammo-rifle","count":1481,"slot":3},{"name":"WEAPON_HEAVYSNIPER","count":1,"metadata":{"serial":"239360UJR204016","registered":"Efe Sarsılmaz","ammo":187,"components":[],"durability":97.5},"slot":4},{"name":"ammo-heavysniper","count":118,"slot":5},{"name":"pistol_ammo2","count":94,"slot":6},{"name":"ammo-rifle2","count":50,"slot":7},{"name":"ammo-smg","count":500,"slot":8},{"name":"ammo-9","count":100,"slot":9},{"name":"ammo-shotgun","count":50,"slot":10},{"name":"phone","count":1,"slot":11},{"name":"WEAPON_MUSKET","count":1,"metadata":{"serial":"879860BBT764956","registered":"Efe Sarsılmaz","ammo":0,"components":[],"durability":100},"slot":12},{"name":"WEAPON_APPISTOL","count":1,"metadata":{"serial":"692713NTU924252","registered":"Efe Sarsılmaz","ammo":0,"components":[],"durability":100},"slot":13},{"name":"WEAPON_APPISTOL","count":1,"metadata":{"serial":"716594SWP208971","registered":"Efe Sarsılmaz","ammo":0,"components":[],"durability":100},"slot":14},{"name":"WEAPON_GLOCK","count":1,"metadata":{"serial":"793532QKC211597","registered":"Zantree Can","ammo":73,"components":[],"durability":96.98999999999994},"slot":15},{"name":"security_card_02","count":1,"slot":16},{"name":"ammo-sniper","count":250,"slot":17},{"name":"heavyarmor2","count":3,"slot":18},{"name":"handcuffs","count":10,"slot":21},{"name":"pkelepceanahtar","count":1,"slot":22},{"name":"WEAPON_STUNGUN","count":1,"metadata":{"serial":"101465PLC585052","registered":"Zantree Can","components":[],"durability":100},"slot":23}]', NULL, '2025-11-04 20:26:56', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2997, 'EIH18257', 1, 'license:743d1329c84c50587593410bfd0f02e858c89d89', 'kashi', '{"crypto":0,"cash":25000,"bank":150010}', '{"firstname":"Russell","iban":901423,"phone":"480802","heigth":"199","lastname":"Crowe","backstory":"placeholder backstory","cid":1,"account":"US04QBCore4289287637","nationality":"Afghanistan","birthdate":"2000-02-22","gender":0}', '{"type":"none","grade":{"level":0,"name":"Freelancer"},"onduty":true,"name":"unemployed","payment":10,"isboss":false,"label":"Civilian"}', '{"name":"none","label":"No Gang Affiliaton","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-1736.2021484375,"y":-1110.158203125,"z":13.03662109375}', '{"thirst":82,"callsign":"NO CALLSIGN","injail":0,"bloodtype":"B+","fitbit":[],"tracker":false,"craftingrep":0,"dealerrep":0,"armor":0,"commandbinds":[],"fingerprint":"bj471l26xOu1542","criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"phone":[],"attachmentcraftingrep":0,"FFAStats":{"arms":0,"headrate":0,"body":0,"matchwin":0,"head":0,"legs":0,"deathcount":0,"killcount":0},"walletid":"QB-57598209","jailitems":[],"isdead":false,"inlaststand":false,"status":[],"phonedata":{"InstalledApps":[],"SerialNumber":38977960},"stress":0,"hunger":73,"ishandcuffed":false,"licences":{"weapon":false,"business":false,"driver":true},"jobrep":{"tow":0,"trucker":0,"hotdog":0,"taxi":0}}', '[{"name":"money","slot":1,"count":25000}]', NULL, '2025-11-15 17:34:05', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2643, 'FJY17019', 1, 'license:752ca54455c8134d65a50584bb9657832a747d66', 'QuentyTR', '{"cash":24990,"crypto":0,"bank":5020}', '{"account":"US08QBCore9083841278","birthdate":"1991-02-08","cid":"1","backstory":"placeholder backstory","nationality":"Poland","iban":413022,"phone":"886278","firstname":"Honty","lastname":"Curse","gender":0}', '{"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"isboss":false,"payment":10,"type":"none","onduty":true}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":1083.3494873046876,"y":-243.8241729736328,"z":68.7421875}', '{"jobrep":{"tow":0,"taxi":0,"hotdog":0,"trucker":0},"FFAStats":{"legs":0,"arms":0,"body":0,"killcount":0,"headrate":0,"matchwin":0,"head":0,"deathcount":0},"commandbinds":[],"armor":0,"attachmentcraftingrep":0,"ishandcuffed":false,"phonedata":{"InstalledApps":[],"SerialNumber":78852970},"phone":[],"inside":{"apartment":[]},"walletid":"QB-29618186","licences":{"driver":true,"business":false,"weapon":false},"inlaststand":false,"isdead":false,"hunger":91,"fingerprint":"PJ527U34ixx3450","tracker":false,"callsign":"NO CALLSIGN","craftingrep":0,"dealerrep":0,"fitbit":[],"thirst":94,"jailitems":[],"stress":0,"criminalrecord":{"hasRecord":false},"status":[],"bloodtype":"AB-","injail":0}', '[{"name":"money","slot":1,"count":24990},{"name":"phone","slot":2,"count":1},{"name":"id_card","slot":3,"metadata":{"birthdate":"1991-02-08","nationality":"Poland","firstname":"Honty","gender":0,"lastname":"Curse"},"count":1},{"name":"driver_license","slot":4,"metadata":{"lastname":"Curse","firstname":"Honty","birthdate":"1991-02-08","type":"Class C Driver License"},"count":1},{"name":"rentalpapers","slot":5,"metadata":{"label":"RT4535"},"count":1}]', NULL, '2025-11-03 19:30:40', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2000, 'FNU16178', 1, 'license:f48b1763874dc421ce69e0968937af91708b8fb5', 'Emir Kazgan', '{"cash":0,"crypto":0,"bank":154250}', '{"backstory":"placeholder backstory","firstname":"Boklu ","phone":"777894","lastname":"Gegege","birthdate":"2005-02-10","cid":"1","iban":936971,"account":"US06QBCore4713438325","nationality":"United Arab Emirates","gender":0}', '{"label":"LSPD","payment":200,"grade":{"level":4,"name":"Officer III+|"},"onduty":true,"isboss":false,"type":"leo","name":"police"}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-73.95164489746094,"y":-819.125244140625,"z":326.173583984375}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"killcount":0,"matchwin":0,"body":0,"arms":0,"head":0,"deathcount":0,"legs":0,"headrate":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","bloodtype":"O+","fingerprint":"pY120w15Wit9927","isdead":false,"injail":0,"inlaststand":false,"commandbinds":[],"walletid":"QB-88558897","jailitems":[],"inside":{"apartment":[]},"phonedata":{"InstalledApps":[],"SerialNumber":51235671},"stress":0,"phone":[],"hunger":67,"armor":100,"dealerrep":0,"attachmentcraftingrep":0,"thirst":78,"fitbit":[],"criminalrecord":{"hasRecord":false},"craftingrep":0,"ishandcuffed":false}', '[{"name":"phone","count":1,"slot":1}]', NULL, '2025-11-04 22:53:38', 0, '{"saat":1762687380,"durum":true,"suansaat":1762255380,"sebep":"oçluk suçu"}', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2699, 'GYY38354', 1, 'license:2f8fa1931edacd24b68d5e7d27fcfa00895681c7', '! Zizi', '{"bank":150010,"cash":25000,"crypto":0}', '{"lastname":"Best","backstory":"placeholder backstory","birthdate":"2003-04-10","gender":0,"phone":"646444","firstname":"Zizi","cid":"1","nationality":"Antarctica","account":"US07QBCore8299490638","iban":618309}', '{"label":"Civilian","grade":{"level":0,"name":"Freelancer"},"onduty":true,"isboss":false,"type":"none","payment":10,"name":"unemployed"}', '{"isboss":false,"grade":{"level":0,"name":"none"},"label":"No Gang Affiliaton","name":"none"}', '{"x":-1750.10107421875,"y":-1068.949462890625,"z":0.3487548828125}', '{"phonedata":{"SerialNumber":21777376,"InstalledApps":[]},"ishandcuffed":false,"inlaststand":false,"thirst":92,"walletid":"QB-85209391","FFAStats":{"body":0,"headrate":0,"legs":0,"matchwin":0,"arms":0,"killcount":0,"deathcount":0,"head":0},"isdead":true,"phone":[],"armor":0,"craftingrep":0,"bloodtype":"B-","criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"injail":0,"jailitems":[],"callsign":"NO CALLSIGN","dealerrep":0,"licences":{"business":false,"driver":true,"weapon":false},"status":[],"attachmentcraftingrep":0,"hunger":88,"jobrep":{"trucker":0,"taxi":0,"hotdog":0,"tow":0},"tracker":false,"stress":0,"fitbit":[],"fingerprint":"Cr015g62MTQ6127","commandbinds":[]}', '[{"slot":1,"name":"money","count":25000},{"slot":2,"name":"phone","count":1},{"slot":3,"name":"id_card","metadata":{"gender":0,"nationality":"Antarctica","birthdate":"2003-04-10","lastname":"Best","firstname":"Zizi"},"count":1},{"slot":4,"name":"driver_license","metadata":{"type":"Class C Driver License","firstname":"Zizi","lastname":"Best","birthdate":"2003-04-10"},"count":1}]', NULL, '2025-11-03 21:06:04', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1545, 'HFY79706', 1, 'license:46ef691a75a59edb8365b594f7ebb2fe41d4a1c1', 'HeySE', '{"cash":0,"crypto":0,"bank":206495}', '{"backstory":"placeholder backstory","birthdate":"2025-01-09","lastname":"Asd","cid":"1","gender":0,"account":"US01QBCore1506542723","firstname":"Asd","phone":"188202","nationality":"Antigua and Barbuda","iban":697955}', '{"type":"leo","label":"LSPD","onduty":true,"grade":{"name":"Chief","level":15},"isboss":true,"payment":245,"name":"police"}', '{"isboss":false,"label":"No Gang Affiliaton","grade":{"level":0,"name":"none"},"name":"none"}', '{"x":-1838.4132080078126,"y":-1191.9296875,"z":12.918701171875}', '{"inside":{"apartment":[]},"hunger":28,"stress":0,"armor":0,"phonedata":{"SerialNumber":12941345,"InstalledApps":[]},"attachmentcraftingrep":0,"tracker":false,"jobrep":{"trucker":0,"tow":0,"taxi":0,"hotdog":0},"fitbit":[],"bloodtype":"B+","isdead":false,"commandbinds":[],"injail":0,"dealerrep":0,"fingerprint":"CW536p35otA7117","ishandcuffed":false,"thirst":52,"FFAStats":{"matchwin":0,"deathcount":0,"head":0,"body":0,"headrate":0,"killcount":0,"legs":0,"arms":0,"profile":"https://avatars.steamstatic.com/5e7460801808805694fe02a312c0d9596b9c180c_full.jpg"},"phone":[],"walletid":"QB-20280981","callsign":"NO CALLSIGN","playtimereward":true,"licences":{"driver":true,"business":false,"weapon":false},"jailitems":[],"status":[],"inlaststand":false,"criminalrecord":{"hasRecord":false},"playtime":120,"craftingrep":0}', '[{"slot":1,"count":1,"name":"WEAPON_GLOCK","metadata":{"serial":"461861PDD692398","components":[],"durability":99.66,"registered":"Asd Asd","ammo":0}},{"slot":2,"count":20,"name":"heavyarmor2"},{"slot":3,"count":26,"name":"pistol_ammo2"},{"slot":4,"count":1,"name":"radio"},{"slot":5,"count":20,"name":"bandage"},{"slot":6,"count":1,"name":"WEAPON_STUNGUN","metadata":{"components":[],"durability":100,"registered":"Asd Asd","serial":"232396EMX837492"}},{"slot":7,"count":10,"name":"handcuffs"},{"slot":8,"count":1,"name":"pkelepceanahtar"},{"slot":9,"count":20,"name":"medkit"},{"slot":10,"count":1,"name":"bodycam"},{"slot":11,"count":1,"name":"phone"}]', NULL, '2025-03-21 04:07:56', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2505, 'HFZ11174', 1, 'license:a16f2a38f83e0d610ba71984f21b2799e004dd23', 'aydem', '{"bank":150310,"cash":25000,"crypto":0}', '{"gender":0,"firstname":"Abori ","nationality":"Benin","iban":211141,"birthdate":"1974-05-09","cid":"1","phone":"985687","account":"US05QBCore2598833219","lastname":"Gabori","backstory":"placeholder backstory"}', '{"grade":{"level":4,"name":"Yönetici"},"isboss":true,"payment":150,"label":"Mechanic","onduty":true,"name":"mechanic","type":"mechanic"}', '{"grade":{"level":0,"name":"none"},"isboss":false,"name":"none","label":"No Gang Affiliaton"}', '{"x":-1141.97802734375,"y":-238.89230346679688,"z":37.2667236328125}', '{"injail":0,"armor":100,"dealerrep":0,"status":[],"inlaststand":false,"stress":0,"bloodtype":"O-","jailitems":[],"attachmentcraftingrep":0,"jobrep":{"trucker":0,"tow":0,"taxi":0,"hotdog":0},"isdead":false,"licences":{"weapon":false,"driver":true,"business":false},"FFAStats":{"matchwin":0,"legs":0,"arms":0,"body":0,"head":0,"deathcount":0,"killcount":0,"headrate":0},"fitbit":[],"criminalrecord":{"hasRecord":false},"hunger":91,"walletid":"QB-94440863","ishandcuffed":false,"fingerprint":"EX843g51ZRn6278","callsign":"NO CALLSIGN","phonedata":{"InstalledApps":[],"SerialNumber":49624237},"phone":[],"craftingrep":0,"commandbinds":[],"thirst":94,"inside":{"apartment":[]},"tracker":false}', '[{"count":25000,"name":"money","slot":1},{"count":1,"name":"WEAPON_G19","metadata":{"durability":98.96999999999997,"serial":"382680UZM459100","ammo":149,"components":[],"registered":"Zantree Can"},"slot":2},{"count":6,"name":"ammo-9","slot":3},{"count":9,"name":"heavyarmor","slot":4},{"count":1,"name":"id_card","metadata":{"birthdate":"1974-05-09","lastname":"Gabori","gender":0,"nationality":"Benin","firstname":"Abori "},"slot":5},{"count":1,"name":"driver_license","metadata":{"birthdate":"1974-05-09","lastname":"Gabori","type":"Class C Driver License","firstname":"Abori "},"slot":6}]', NULL, '2025-11-03 17:40:05', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2890, 'HLY83785', 1, 'license:4ac60ccea9385b8acb5a01c7e55ebe1bde321308', 'yaşlıkurt', '{"cash":25000,"crypto":0,"bank":150000}', '{"backstory":"placeholder backstory","firstname":"Sefa","phone":"409380","iban":475374,"account":"US08QBCore4470195745","cid":"1","birthdate":"2001-03-03","lastname":"Kaya","nationality":"Turkey","gender":0}', '{"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"onduty":true,"isboss":false,"payment":10,"type":"none"}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-57.67911529541015,"y":-1094.6109619140626,"z":26.4154052734375}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"bloodtype":"AB+","FFAStats":{"arms":0,"headrate":0,"body":0,"matchwin":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","phonedata":{"SerialNumber":28355351,"InstalledApps":[]},"fingerprint":"QW489V52kLk5367","attachmentcraftingrep":0,"tracker":false,"injail":0,"commandbinds":[],"walletid":"QB-94044203","ishandcuffed":false,"inside":{"apartment":[]},"craftingrep":0,"stress":0,"phone":[],"dealerrep":0,"armor":0,"inlaststand":false,"jailitems":[],"thirst":96,"hunger":94,"criminalrecord":{"hasRecord":false},"isdead":false,"fitbit":[]}', '[{"name":"money","count":25000,"slot":1},{"name":"phone","count":1,"slot":2},{"name":"id_card","count":1,"metadata":{"nationality":"Turkey","firstname":"Sefa","birthdate":"2001-03-03","lastname":"Kaya","gender":0},"slot":3},{"name":"driver_license","count":1,"metadata":{"firstname":"Sefa","type":"Class C Driver License","lastname":"Kaya","birthdate":"2001-03-03"},"slot":4}]', NULL, '2025-11-04 19:29:14', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2004, 'HZK30117', 1, 'license:5db03ae1816a7f7039d8accb337a1bf7b2c3e13e', '! 𝘓𝘦𝘸𝘯𝘪', '{"cash":0,"crypto":0,"bank":58380}', '{"backstory":"placeholder backstory","firstname":"Asda","phone":"508190","iban":987307,"account":"US05QBCore2216803916","cid":"1","birthdate":"1977-11-11","lastname":"Sdasasf","nationality":"Afghanistan","gender":0}', '{"label":"LSPD","payment":200,"grade":{"level":4,"name":"Officer III+|"},"onduty":true,"name":"police","type":"leo","isboss":false}', '{"isboss":false,"name":"none","label":"No Gang Affiliaton","grade":{"level":0,"name":"none"}}', '{"x":1279.4241943359376,"y":-602.6505737304688,"z":69.095947265625}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"body":0,"arms":0,"killcount":0,"matchwin":0,"head":0,"deathcount":0,"legs":0,"headrate":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","phonedata":{"InstalledApps":[],"SerialNumber":77941209},"fingerprint":"UK646q23LPJ2024","jailitems":[],"craftingrep":0,"inlaststand":false,"commandbinds":[],"walletid":"QB-96521101","ishandcuffed":false,"inside":{"apartment":[]},"injail":0,"fitbit":[],"phone":[],"hunger":73,"armor":0,"dealerrep":0,"attachmentcraftingrep":0,"thirst":82,"bloodtype":"B+","criminalrecord":{"hasRecord":false},"isdead":false,"stress":0}', '[{"name":"WEAPON_TOLVECTOR","count":1,"metadata":{"serial":"938532GDH573102","registered":"Asda Sdasasf","ammo":114,"components":[],"durability":98.01999999999998},"slot":1},{"name":"ammo-9","count":990,"slot":2}]', NULL, '2025-11-04 22:55:31', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2678, 'JAX11032', 1, 'license:5979918657e7e7c79ebf24859645fd9424a21baf', 'banarustunaderlercanisi', '{"crypto":0,"bank":150020,"cash":25000}', '{"backstory":"placeholder backstory","lastname":"Moroz","nationality":"Ukraine","account":"US02QBCore6755745187","iban":516592,"cid":"1","birthdate":"2000-08-25","phone":"339156","gender":0,"firstname":"Petro"}', '{"grade":{"level":0,"name":"Freelancer"},"name":"unemployed","type":"none","onduty":true,"payment":10,"isboss":false,"label":"Civilian"}', '{"isboss":false,"grade":{"level":0,"name":"none"},"name":"none","label":"No Gang Affiliaton"}', '{"x":-439.8725280761719,"y":1078.2462158203126,"z":351.886474609375}', '{"walletid":"QB-65302533","fingerprint":"Hu646H17KFh7778","tracker":false,"attachmentcraftingrep":0,"armor":0,"inlaststand":false,"fitbit":[],"commandbinds":[],"jobrep":{"trucker":0,"hotdog":0,"tow":0,"taxi":0},"isdead":false,"FFAStats":{"killcount":0,"matchwin":0,"head":0,"headrate":0,"legs":0,"deathcount":0,"arms":0,"body":0},"hunger":91,"stress":0,"bloodtype":"A-","criminalrecord":{"hasRecord":false},"thirst":94,"status":[],"licences":{"driver":true,"weapon":false,"business":false},"dealerrep":0,"callsign":"NO CALLSIGN","jailitems":[],"injail":0,"inside":{"apartment":[]},"ishandcuffed":false,"phone":[],"craftingrep":0,"phonedata":{"InstalledApps":[],"SerialNumber":14121797}}', '[{"name":"money","count":25000,"slot":1},{"name":"phone","count":1,"slot":2},{"name":"id_card","metadata":{"birthdate":"2000-08-25","gender":0,"nationality":"Ukraine","lastname":"Moroz","firstname":"Petro"},"count":1,"slot":3},{"name":"driver_license","metadata":{"type":"Class C Driver License","birthdate":"2000-08-25","lastname":"Moroz","firstname":"Petro"},"count":1,"slot":4}]', NULL, '2025-11-03 20:16:52', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(3004, 'JND68700', 1, 'license:cd5b6b574e0faf91f80aefa9dd79cfe1b96720e7', 'CLipper', '{"crypto":0,"cash":24825,"bank":150000}', '{"nationality":"Bahrain","cid":1,"iban":619037,"firstname":"Allah ","gender":0,"phone":"395608","backstory":"placeholder backstory","heigth":"180","birthdate":"2000-12-02","lastname":"Baba","account":"US03QBCore4230170668"}', '{"grade":{"level":0,"name":"Freelancer"},"payment":10,"label":"Civilian","type":"none","name":"unemployed","isboss":false,"onduty":true}', '{"grade":{"level":0,"name":"none"},"name":"none","label":"No Gang Affiliaton","isboss":false}', '{"x":309.25714111328127,"y":-585.3362426757813,"z":43.2652587890625}', '{"fitbit":[],"inlaststand":false,"isdead":false,"armor":0,"hunger":94,"thirst":96,"criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"phonedata":{"InstalledApps":[],"SerialNumber":99513647},"FFAStats":{"arms":0,"legs":0,"deathcount":0,"head":0,"headrate":0,"body":0,"matchwin":0,"killcount":0},"licences":{"weapon":false,"driver":true,"business":false},"stress":0,"attachmentcraftingrep":0,"commandbinds":[],"jailitems":[],"walletid":"QB-27541754","fingerprint":"cE049Z71BBV5040","bloodtype":"A+","callsign":"NO CALLSIGN","phone":[],"dealerrep":0,"craftingrep":0,"tracker":false,"ishandcuffed":false,"injail":0,"status":[],"jobrep":{"taxi":0,"trucker":0,"tow":0,"hotdog":0}}', '[{"name":"money","count":24825,"slot":1}]', NULL, '2025-11-15 17:14:28', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2582, 'JYB49700', 1, 'license:e684cfcb8133f966fcb68342b8250129fc8b3cbc', 'streamer BaRTu\'S', '{"cash":25000,"crypto":0,"bank":150020}', '{"backstory":"placeholder backstory","firstname":"Cyrus","phone":"655292","account":"US04QBCore1936148256","lastname":"Olivia","cid":"1","birthdate":"1999-09-12","iban":678953,"nationality":"Turkey","gender":0}', '{"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"onduty":true,"type":"none","payment":10,"isboss":false}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-56.0571403503418,"y":-1111.2791748046876,"z":26.4322509765625}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"arms":0,"headrate":0,"matchwin":0,"body":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","injail":0,"fingerprint":"vC277s99hRW8522","bloodtype":"AB+","hunger":88,"inlaststand":false,"commandbinds":[],"walletid":"QB-66282304","ishandcuffed":false,"inside":{"apartment":[]},"stress":0,"attachmentcraftingrep":0,"phone":[],"jailitems":[],"armor":0,"dealerrep":0,"fitbit":[],"thirst":92,"craftingrep":0,"criminalrecord":{"hasRecord":false},"isdead":false,"phonedata":{"InstalledApps":[],"SerialNumber":92990621}}', '[{"name":"money","count":25000,"slot":1},{"name":"phone","count":1,"slot":2},{"name":"id_card","count":1,"metadata":{"nationality":"Turkey","firstname":"Cyrus","birthdate":"1999-09-12","lastname":"Olivia","gender":0},"slot":3},{"name":"driver_license","count":1,"metadata":{"type":"Class C Driver License","firstname":"Cyrus","lastname":"Olivia","birthdate":"1999-09-12"},"slot":4},{"name":"WEAPON_SMG","count":1,"metadata":{"serial":"559546AWV407352","registered":"Cyrus Olivia","ammo":35,"components":[],"durability":79.99999999999999},"slot":5},{"name":"ammo-9","count":13,"slot":6},{"name":"ammo-smg","count":108,"slot":7},{"name":"WEAPON_G19","count":1,"metadata":{"serial":"112645UPQ744105","registered":"Cyrus Olivia","ammo":51,"components":[],"durability":99.96999999999999},"slot":9}]', NULL, '2025-11-04 14:17:56', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1579, 'JYS78192', 1, 'license:183db3628f22ef1e7432ae039ad0c67870a9897c', 'oyunbagımlısı', '{"bank":150010,"crypto":0,"cash":0}', '{"cid":"1","phone":"267432","lastname":"ALLAH BABASI","gender":0,"birthdate":"2025-03-05","nationality":"Azerbaijan","account":"US09QBCore1814542516","iban":379178,"backstory":"placeholder backstory","firstname":"ALLAH BABASI"}', '{"onduty":true,"grade":{"name":"Freelancer","level":0},"isboss":false,"name":"unemployed","payment":10,"label":"Civilian","type":"none"}', '{"name":"none","grade":{"name":"none","level":0},"isboss":false,"label":"No Gang Affiliaton"}', '{"x":288.3692321777344,"y":-549.7582397460938,"z":43.2314453125}', '{"playtime":16,"hunger":91,"FFAStats":{"matchwin":0,"body":0,"legs":0,"killcount":0,"deathcount":0,"arms":0,"headrate":0,"head":0},"commandbinds":[],"isdead":false,"ishandcuffed":false,"fitbit":[],"thirst":94,"armor":0,"attachmentcraftingrep":0,"phonedata":{"InstalledApps":[],"SerialNumber":94056340},"inside":{"apartment":[]},"tracker":false,"inlaststand":false,"criminalrecord":{"hasRecord":false},"phone":[],"walletid":"QB-92542737","callsign":"NO CALLSIGN","status":[],"bloodtype":"B+","fingerprint":"Vz534I00lQc9453","jailitems":[],"stress":0,"playtimereward":false,"dealerrep":0,"licences":{"business":false,"weapon":false,"driver":true},"injail":0,"jobrep":{"tow":0,"trucker":0,"taxi":0,"hotdog":0},"craftingrep":0}', '[{"count":1,"slot":1,"metadata":{"registered":"ALLAH BABASI ALLAH BABASI","ammo":0,"serial":"604382EUJ483641","durability":100,"components":[]},"name":"WEAPON_G19"},{"count":1,"slot":2,"metadata":{"registered":"Flame Santo","ammo":0,"serial":"299357BFB310911","durability":100,"components":[]},"name":"WEAPON_G19"}]', NULL, '2025-03-14 14:11:44', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1936, 'KOA75427', 1, 'license:96309372a482fff2224e6f7ea743be20b4b058a2', 'HOT x paul', '{"crypto":0,"bank":150000,"cash":10000}', '{"nationality":"Antigua and Barbuda","cid":"1","backstory":"placeholder backstory","account":"US06QBCore5412726016","firstname":"Brave","gender":0,"birthdate":"2010-02-04","iban":738471,"lastname":"Anch","phone":"546118"}', '{"label":"Civilian","type":"none","isboss":false,"grade":{"level":0,"name":"Freelancer"},"name":"unemployed","payment":10,"onduty":true}', '{"label":"No Gang Affiliaton","name":"none","grade":{"level":0,"name":"none"},"isboss":false}', '{"x":-763.3054809570313,"y":330.3692321777344,"z":199.4630126953125}', '{"callsign":"NO CALLSIGN","isdead":false,"playtimereward":false,"craftingrep":0,"thirst":98,"phone":[],"phonedata":{"SerialNumber":72579854,"InstalledApps":[]},"status":[],"licences":{"driver":true,"weapon":false,"business":false},"fingerprint":"yI831h11TRl5054","attachmentcraftingrep":0,"bloodtype":"A-","armor":0,"walletid":"QB-34472452","criminalrecord":{"hasRecord":false},"dealerrep":0,"jobrep":{"hotdog":0,"trucker":0,"taxi":0,"tow":0},"inside":{"apartment":[]},"jailitems":[],"tracker":false,"playtime":0,"stress":0,"injail":0,"commandbinds":[],"fitbit":[],"FFAStats":{"headrate":0,"matchwin":0,"arms":0,"killcount":0,"legs":0,"body":0,"deathcount":0,"head":0},"ishandcuffed":false,"hunger":97,"inlaststand":false}', '[{"count":10000,"slot":1,"name":"money"},{"count":1,"slot":2,"name":"phone"},{"count":1,"metadata":{"lastname":"Anch","nationality":"Antigua and Barbuda","gender":0,"firstname":"Brave","birthdate":"2010-02-04"},"slot":3,"name":"id_card"},{"count":1,"metadata":{"lastname":"Anch","firstname":"Brave","birthdate":"2010-02-04","type":"Class C Driver License"},"slot":4,"name":"driver_license"}]', NULL, '2025-03-20 08:07:33', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1546, 'MQZ35496', 1, 'license:dfdc40e688cbda25d43279e83b5781cf6df18fac', 'dernier', '{"cash":0,"bank":150190,"crypto":0}', '{"gender":0,"backstory":"placeholder backstory","firstname":"Selçuk","lastname":"Kürt","phone":"469195","cid":"1","iban":19625,"birthdate":"2025-01-01","nationality":"Argentina","account":"US02QBCore2159503882"}', '{"type":"none","onduty":true,"isboss":false,"payment":10,"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"}}', '{"grade":{"level":0,"name":"none"},"label":"No Gang Affiliaton","name":"none","isboss":false}', '{"x":-70.94505310058594,"y":-792.6329345703125,"z":219.3458251953125}', '{"licences":{"driver":true,"weapon":false,"business":false},"jobrep":{"hotdog":0,"taxi":0,"trucker":0,"tow":0},"FFAStats":{"ingame":false,"head":0,"deathcount":0,"headrate":0,"legs":0,"killcount":0,"arms":0,"profile":"https://avatars.steamstatic.com/6dae2652c12a6d5ea21805ebaab9c0cdaf0cc0dd_full.jpg","matchwin":0,"body":0},"fingerprint":"EJ042n32ubW5716","bloodtype":"B-","callsign":"NO CALLSIGN","walletid":"QB-35376078","inlaststand":false,"status":[],"commandbinds":[],"craftingrep":0,"playtimereward":false,"phonedata":{"SerialNumber":73819153,"InstalledApps":[]},"criminalrecord":{"hasRecord":false},"thirst":96,"isdead":false,"fitbit":[],"playtime":120,"attachmentcraftingrep":0,"ishandcuffed":false,"hunger":94,"inside":{"apartment":[]},"stress":0,"armor":100,"dealerrep":0,"jailitems":[],"phone":[],"injail":0,"tracker":false}', '[{"metadata":{"registered":"Selçuk Kürt","durability":100,"ammo":0,"components":[],"serial":"655903PXY365965"},"name":"WEAPON_PISTOL","slot":1,"count":1}]', NULL, '2025-03-20 21:39:05', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1879, 'MUR16142', 1, 'license:67ade502587f49ebc29b1ff224ecac8cb74363b9', 'ahmet', '{"cash":10000,"crypto":0,"bank":150000}', '{"firstname":"Xavi Lee","lastname":"Diamond","phone":"165592","nationality":"Turkey","cid":"1","iban":446217,"birthdate":"2006-02-03","gender":0,"backstory":"placeholder backstory","account":"US07QBCore1627621853"}', '{"grade":{"name":"Freelancer","level":0},"label":"Civilian","type":"none","name":"unemployed","isboss":false,"payment":10,"onduty":true}', '{"name":"none","isboss":false,"label":"No Gang Affiliaton","grade":{"name":"none","level":0}}', '{"x":-763.3054809570313,"y":330.3692321777344,"z":199.4630126953125}', '{"thirst":98,"status":[],"injail":0,"FFAStats":{"body":0,"head":0,"deathcount":0,"legs":0,"matchwin":0,"arms":0,"headrate":0,"killcount":0},"craftingrep":0,"commandbinds":[],"tracker":false,"bloodtype":"A-","phone":[],"phonedata":{"SerialNumber":57231664,"InstalledApps":[]},"stress":0,"licences":{"business":false,"weapon":false,"driver":true},"playtimereward":false,"isdead":false,"ishandcuffed":false,"playtime":0,"inside":{"apartment":[]},"armor":0,"attachmentcraftingrep":0,"fitbit":[],"callsign":"NO CALLSIGN","walletid":"QB-25776654","inlaststand":false,"criminalrecord":{"hasRecord":false},"jobrep":{"hotdog":0,"tow":0,"trucker":0,"taxi":0},"dealerrep":0,"fingerprint":"xw624J23bGc0984","jailitems":[],"hunger":97}', '[{"name":"money","slot":1,"count":10000},{"name":"phone","slot":2,"count":1},{"metadata":{"firstname":"Xavi Lee","gender":0,"lastname":"Diamond","birthdate":"2006-02-03","nationality":"Turkey"},"name":"id_card","slot":3,"count":1},{"metadata":{"firstname":"Xavi Lee","birthdate":"2006-02-03","type":"Class C Driver License","lastname":"Diamond"},"name":"driver_license","slot":4,"count":1}]', NULL, '2025-03-19 17:25:32', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1605, 'NPF75386', 1, 'license:dce928fb42f6c45f1abab099c9a9125e1252aafa', 'Anderson Talisca', '{"bank":150020,"cash":10000,"crypto":0}', '{"lastname":"FAFSAFA","backstory":"placeholder backstory","birthdate":"2025-03-04","phone":"589111","account":"US04QBCore3962750320","gender":0,"nationality":"Afghanistan","iban":28190,"firstname":"SFA","cid":"1"}', '{"type":"none","label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"payment":10,"onduty":true,"isboss":false}', '{"grade":{"level":0,"name":"none"},"isboss":false,"label":"No Gang Affiliaton","name":"none"}', '{"x":-1153.84619140625,"y":-2811.428466796875,"z":15.142822265625}', '{"status":[],"playtime":36,"dealerrep":0,"bloodtype":"AB-","walletid":"QB-32743651","criminalrecord":{"hasRecord":false},"phone":[],"isdead":false,"licences":{"business":false,"weapon":false,"driver":true},"fitbit":[],"ishandcuffed":false,"injail":0,"tracker":false,"FFAStats":{"head":0,"body":0,"headrate":0,"deathcount":0,"arms":0,"killcount":0,"matchwin":0,"legs":0},"commandbinds":[],"playtimereward":false,"fingerprint":"TA581d27aTb4759","armor":0,"stress":0,"attachmentcraftingrep":0,"craftingrep":0,"callsign":"NO CALLSIGN","jailitems":[],"thirst":86,"inside":{"apartment":[]},"hunger":79,"inlaststand":false,"phonedata":{"InstalledApps":[],"SerialNumber":20645305},"jobrep":{"trucker":0,"taxi":0,"tow":0,"hotdog":0}}', '[{"metadata":{"registered":"SFA FAFSAFA","ammo":0,"durability":100,"serial":"857477LGH264067","components":[]},"slot":1,"count":1,"name":"WEAPON_G19"},{"metadata":{"type":"Class C Driver License","lastname":"FAFSAFA","birthdate":"2025-03-04","firstname":"SFA"},"slot":3,"count":1,"name":"driver_license"},{"slot":4,"count":10,"name":"water"},{"slot":5,"count":1,"name":"phone"},{"slot":6,"count":10,"name":"burger"},{"metadata":{"registered":"SFA FAFSAFA","ammo":0,"durability":100,"serial":"770463MXW465185","components":[]},"slot":7,"count":1,"name":"WEAPON_G19"},{"metadata":{"citizenid":"NPF75386","nationality":"Afghanistan","gender":0,"firstname":"SFA","birthdate":"2025-03-04","lastname":"FAFSAFA"},"slot":8,"count":1,"name":"id_card"},{"slot":9,"count":10000,"name":"money"}]', NULL, '2025-03-18 18:39:15', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1624, 'OAR69061', 1, 'license:119fd94bf55132ed58b98886688b0bfce4ae5947', 'Vegor', '{"bank":150020,"crypto":0,"cash":10000}', '{"gender":0,"iban":514637,"cid":"1","birthdate":"2025-03-05","backstory":"placeholder backstory","lastname":"Saxon","nationality":"Afghanistan","phone":"185888","account":"US02QBCore7100240065","firstname":"Frank"}', '{"grade":{"name":"Freelancer","level":0},"type":"none","isboss":false,"name":"unemployed","label":"Civilian","onduty":true,"payment":10}', '{"grade":{"name":"none","level":0},"label":"No Gang Affiliaton","name":"none","isboss":false}', '{"x":-1649.4066162109376,"y":-314.3736267089844,"z":50.5948486328125}', '{"playtime":18,"inside":{"apartment":[]},"jobrep":{"taxi":0,"trucker":0,"tow":0,"hotdog":0},"commandbinds":[],"armor":0,"ishandcuffed":false,"tracker":false,"bloodtype":"B-","fitbit":[],"thirst":92,"phone":[],"criminalrecord":{"hasRecord":false},"walletid":"QB-59304920","status":[],"jailitems":[],"injail":0,"hunger":91,"callsign":"NO CALLSIGN","FFAStats":{"deathcount":0,"headrate":0,"matchwin":0,"arms":0,"body":0,"killcount":0,"head":0,"legs":0},"dealerrep":0,"phonedata":{"SerialNumber":96134003,"InstalledApps":[]},"isdead":false,"licences":{"driver":true,"weapon":false,"business":false},"attachmentcraftingrep":0,"fingerprint":"PP715G49XLj4530","inlaststand":false,"craftingrep":0,"stress":0,"playtimereward":false}', '[{"count":10000,"slot":1,"name":"money"},{"metadata":{"gender":0,"lastname":"Saxon","firstname":"Frank","citizenid":"OAR69061","nationality":"Afghanistan","birthdate":"2025-03-05"},"count":1,"slot":2,"name":"id_card"},{"count":9,"slot":3,"name":"burger"},{"count":1,"slot":4,"name":"phone"},{"count":10,"slot":5,"name":"water"},{"metadata":{"firstname":"Frank","type":"Class C Driver License","birthdate":"2025-03-05","lastname":"Saxon"},"count":1,"slot":6,"name":"driver_license"}]', NULL, '2025-03-16 10:17:57', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1617, 'OKT69470', 1, 'license:dcba2bb81d5ef2085578c0e5ee2af626ecfdee97', '001', '{"bank":150000,"cash":10000,"crypto":0}', '{"firstname":"Arda","backstory":"placeholder backstory","cid":"1","birthdate":"2000-01-12","phone":"918946","iban":181289,"lastname":"Gotveren","nationality":"Turkey","gender":0,"account":"US07QBCore9277824032"}', '{"name":"unemployed","isboss":false,"label":"Civilian","type":"none","grade":{"name":"Freelancer","level":0},"onduty":true,"payment":10}', '{"name":"none","grade":{"name":"none","level":0},"isboss":false,"label":"No Gang Affiliaton"}', '{"x":-1877.8154296875,"y":-373.3977966308594,"z":48.5391845703125}', '{"jailitems":[],"injail":0,"hunger":97,"stress":0,"criminalrecord":{"hasRecord":false},"playtimereward":false,"playtime":5,"bloodtype":"AB-","walletid":"QB-18332060","jobrep":{"trucker":0,"taxi":0,"hotdog":0,"tow":0},"FFAStats":{"deathcount":0,"legs":0,"headrate":0,"killcount":0,"head":0,"matchwin":0,"arms":0,"body":0},"fingerprint":"IQ872q48DLm8405","commandbinds":[],"isdead":false,"tracker":false,"craftingrep":0,"thirst":98,"inlaststand":false,"ishandcuffed":false,"phonedata":{"InstalledApps":[],"SerialNumber":34264156},"fitbit":[],"attachmentcraftingrep":0,"dealerrep":0,"phone":[],"armor":0,"licences":{"business":false,"weapon":false,"driver":true},"callsign":"NO CALLSIGN","status":[],"inside":{"apartment":[]}}', '[{"count":10000,"name":"money","slot":1},{"count":1,"name":"driver_license","metadata":{"lastname":"Gotveren","firstname":"Arda","birthdate":"2000-01-12","type":"Class C Driver License"},"slot":2},{"count":1,"name":"id_card","metadata":{"lastname":"Gotveren","firstname":"Arda","gender":0,"citizenid":"OKT69470","nationality":"Turkey","birthdate":"2000-01-12"},"slot":3},{"count":10,"name":"water","slot":4},{"count":1,"name":"phone","slot":5},{"count":10,"name":"burger","slot":6}]', NULL, '2025-03-15 22:09:02', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2752, 'QNB34275', 1, 'license:5005090b6c15274ca4fdfda7e31322fb849b6839', 'megafirerulete', '{"bank":497248,"cash":0,"crypto":0}', '{"lastname":"Timo","backstory":"placeholder backstory","birthdate":"1983-04-06","gender":0,"phone":"687956","firstname":"Mustafa Ahmet","account":"US02QBCore2259719695","nationality":"United Arab Emirates","cid":"1","iban":418605}', '{"label":"Civilian","grade":{"level":0,"name":"Freelancer"},"payment":10,"isboss":false,"type":"none","onduty":true,"name":"unemployed"}', '{"label":"No Gang Affiliaton","grade":{"level":0,"name":"none"},"isboss":false,"name":"none"}', '{"x":342.01318359375,"y":-1046.7427978515626,"z":29.3641357421875}', '{"status":[],"ishandcuffed":false,"inlaststand":false,"thirst":62,"commandbinds":[],"FFAStats":{"arms":0,"body":0,"legs":0,"killcount":0,"head":0,"matchwin":0,"deathcount":0,"headrate":0},"isdead":false,"phone":[],"armor":75,"phonedata":{"InstalledApps":[],"SerialNumber":27413704},"bloodtype":"B-","criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"licences":{"weapon":false,"business":false,"driver":true},"walletid":"QB-35004582","jailitems":[],"callsign":"NO CALLSIGN","jobrep":{"trucker":0,"hotdog":0,"taxi":0,"tow":0},"attachmentcraftingrep":0,"dealerrep":0,"hunger":43,"craftingrep":0,"injail":0,"stress":0,"fitbit":[],"fingerprint":"bZ456H92kVA1601","tracker":false}', '[{"slot":1,"name":"fishingrod","count":1},{"slot":2,"name":"phone","count":1},{"slot":3,"name":"driver_license","metadata":{"birthdate":"1983-04-06","type":"Class C Driver License","lastname":"Timo","firstname":"Mustafa Ahmet"},"count":1},{"slot":4,"name":"id_card","metadata":{"gender":0,"nationality":"United Arab Emirates","firstname":"Mustafa Ahmet","lastname":"Timo","birthdate":"1983-04-06"},"count":1},{"slot":5,"name":"yay","count":6},{"slot":6,"name":"tutamac","count":1},{"slot":7,"name":"tetik","count":5},{"slot":8,"name":"sarjor","count":1},{"slot":11,"name":"karapara","count":901417},{"slot":12,"name":"kaydirak","count":2},{"slot":13,"name":"namlu","count":1},{"slot":14,"name":"karpuz","count":283}]', NULL, '2025-11-04 10:50:14', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2302, 'QOU80537', 1, 'license:bb74c63887960eb35b000c29e402fe295c876841', 'casablanca x lewis', '{"cash":54599,"crypto":0,"bank":150970}', '{"lastname":"Karımdır","firstname":"Rıco","nationality":"Bangladesh","account":"US01QBCore8432478244","birthdate":"1980-01-01","iban":571139,"gender":0,"backstory":"placeholder backstory","phone":"139120","cid":"1"}', '{"type":"leo","isboss":true,"payment":245,"label":"LSPD","name":"police","onduty":true,"grade":{"name":"Chief","level":15}}', '{"name":"none","label":"No Gang Affiliaton","isboss":false,"grade":{"name":"none","level":0}}', '{"x":1029.982421875,"y":-2289.876953125,"z":32.5318603515625}', '{"FFAStats":{"body":0,"matchwin":0,"deathcount":0,"head":0,"headrate":0,"killcount":0,"legs":0,"arms":0},"jobrep":{"taxi":0,"tow":0,"trucker":0,"hotdog":0},"criminalrecord":{"hasRecord":false},"stress":0,"armor":100,"commandbinds":[],"phone":[],"tracker":false,"phonedata":{"SerialNumber":42278919,"InstalledApps":[]},"ishandcuffed":false,"hunger":97,"fitbit":[],"attachmentcraftingrep":0,"thirst":98,"injail":0,"inlaststand":false,"isdead":false,"bloodtype":"A+","jailitems":[],"dealerrep":0,"craftingrep":0,"licences":{"weapon":false,"driver":true,"business":false},"callsign":"NO CALLSIGN","status":[],"fingerprint":"Fm626U49Cai9325","inside":{"apartment":[]},"walletid":"QB-40535559"}', '[{"slot":1,"name":"phone","count":1},{"slot":2,"metadata":{"durability":93.84999999999964,"serial":"695657CCQ156253","ammo":176,"registered":"Boklu  Gegege","components":[]},"name":"WEAPON_G19","count":1},{"slot":3,"metadata":{"durability":99.09999999999998,"serial":"622919MWU464047","components":[],"registered":"Boklu  Gegege","ammo":0},"name":"WEAPON_G19","count":1},{"slot":4,"name":"pistol_ammo2","count":5},{"slot":5,"metadata":{"durability":99.59999999999998,"serial":"300475POL137199","components":[],"registered":"Rıco Karımdır","ammo":11},"name":"WEAPON_GLOCK","count":1},{"slot":6,"name":"weed_seed","count":1},{"slot":7,"name":"money","count":54599},{"slot":8,"name":"phone","count":1},{"slot":9,"name":"heavyarmor","count":1},{"slot":11,"metadata":{"nationality":"United Arab Emirates","firstname":"Sf","birthdate":"1994-05-05","lastname":"Sf","gender":0},"name":"id_card","count":1},{"slot":12,"metadata":{"type":"Class C Driver License","birthdate":"1994-05-05","lastname":"Sf","firstname":"Sf"},"name":"driver_license","count":1}]', NULL, '2025-11-03 14:37:26', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2562, 'RBG67155', 1, 'license:1b06f3bf6faaa70192f4400056bcc9942b4227d4', 'yanları al üstü kalsın', '{"cash":25000,"crypto":0,"bank":150020}', '{"account":"US08QBCore6583506767","birthdate":"2000-05-05","cid":"1","backstory":"placeholder backstory","nationality":"Singapore","gender":0,"phone":"619927","firstname":"William","iban":370625,"lastname":"Salvos"}', '{"label":"Civilian","payment":10,"grade":{"level":0,"name":"Freelancer"},"isboss":false,"name":"unemployed","type":"none","onduty":true}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-613.4373779296875,"y":-827.6307373046875,"z":25.3538818359375}', '{"jobrep":{"tow":0,"trucker":0,"hotdog":0,"taxi":0},"FFAStats":{"legs":0,"arms":0,"body":0,"killcount":0,"matchwin":0,"headrate":0,"head":0,"deathcount":0},"dealerrep":0,"armor":100,"attachmentcraftingrep":0,"ishandcuffed":false,"injail":0,"phone":[],"commandbinds":[],"walletid":"QB-13539995","isdead":false,"hunger":100,"status":[],"craftingrep":0,"fingerprint":"zE687h65IiM7212","tracker":false,"stress":0,"licences":{"driver":true,"business":false,"weapon":false},"callsign":"NO CALLSIGN","fitbit":[],"inlaststand":false,"jailitems":[],"phonedata":{"InstalledApps":[],"SerialNumber":20260241},"criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"bloodtype":"A+","thirst":100}', '[{"name":"WEAPON_G19","slot":1,"metadata":{"registered":"William Salvos","components":[],"durability":98.9499999999999,"ammo":237,"serial":"824534PIT448888"},"count":1},{"name":"ammo-9","slot":3,"count":31},{"name":"phone","slot":9,"count":1},{"name":"money","slot":10,"count":25000},{"name":"id_card","slot":8,"metadata":{"gender":0,"nationality":"Singapore","firstname":"William","birthdate":"2000-05-05","lastname":"Salvos"},"count":1},{"name":"driver_license","slot":14,"metadata":{"lastname":"Salvos","birthdate":"2000-05-05","firstname":"William","type":"Class C Driver License"},"count":1}]', NULL, '2025-11-03 18:53:18', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2035, 'RPB30164', 1, 'license:8a1a2d20975857143a32b90abb1c9214e8f2e135', 'dümbük5', '{"bank":150020,"cash":25000,"crypto":0}', '{"lastname":"G","backstory":"placeholder backstory","birthdate":"1980-02-07","gender":0,"firstname":"Fypenos","phone":"463120","nationality":"United Arab Emirates","cid":"1","account":"US04QBCore2058977986","iban":670848}', '{"label":"Civilian","grade":{"level":0,"name":"Freelancer"},"payment":10,"isboss":false,"type":"none","onduty":true,"name":"unemployed"}', '{"isboss":false,"grade":{"level":0,"name":"none"},"label":"No Gang Affiliaton","name":"none"}', '{"x":-1741.2791748046876,"y":-173.5120849609375,"z":57.7222900390625}', '{"status":[],"ishandcuffed":false,"inlaststand":false,"thirst":98,"commandbinds":[],"FFAStats":{"headrate":0,"body":0,"legs":0,"killcount":0,"arms":0,"matchwin":0,"deathcount":0,"head":0},"isdead":false,"phone":[],"armor":0,"tracker":false,"bloodtype":"AB+","criminalrecord":{"hasRecord":false},"inside":{"apartment":[]},"stress":0,"phonedata":{"InstalledApps":[],"SerialNumber":44498998},"fitbit":[],"licences":{"business":false,"driver":true,"weapon":false},"walletid":"QB-32560978","attachmentcraftingrep":0,"dealerrep":0,"hunger":97,"craftingrep":0,"injail":0,"jobrep":{"trucker":0,"hotdog":0,"taxi":0,"tow":0},"jailitems":[],"fingerprint":"Ll582r93nch7182","callsign":"NO CALLSIGN"}', '[{"slot":1,"name":"WEAPON_G19","metadata":{"durability":95.2399999999999,"components":[],"serial":"575980KHF607790","registered":"Fypenos G","ammo":185},"count":1},{"slot":3,"name":"WEAPON_SWITCHBLADE","metadata":{"durability":97.20000000000016,"components":[]},"count":1},{"slot":6,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"855848DEG950932","registered":"Fypenos G","ammo":0},"count":1},{"slot":9,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"853948QTU620372","registered":"Fypenos G","ammo":0},"count":1},{"slot":11,"name":"money","count":25000},{"slot":12,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"359953GCD277549","registered":"Fypenos G","ammo":0},"count":1},{"slot":13,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"417114CHI135092","registered":"Fypenos G","ammo":0},"count":1},{"slot":14,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"471215HTO684223","registered":"Fypenos G","ammo":0},"count":1},{"slot":15,"name":"id_card","metadata":{"gender":0,"nationality":"United Arab Emirates","birthdate":"1980-02-07","lastname":"G","firstname":"Fypenos"},"count":1},{"slot":16,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"243351BLH477330","registered":"Fypenos G","ammo":0},"count":1},{"slot":18,"name":"phone","count":1},{"slot":19,"name":"driver_license","metadata":{"type":"Class C Driver License","firstname":"Fypenos","lastname":"G","birthdate":"1980-02-07"},"count":1},{"slot":17,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"374312FEO821064","registered":"Fypenos G","ammo":0},"count":1},{"slot":20,"name":"WEAPON_G19","metadata":{"durability":100,"components":[],"serial":"846843MVJ383901","registered":"Fypenos G","ammo":0},"count":1}]', NULL, '2025-11-04 13:27:17', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2492, 'RST11039', 1, 'license:7959f12c548961295aee03be49259245237e944f', 'lowin', '{"cash":0,"crypto":0,"bank":149520}', '{"account":"US06QBCore5473189414","birthdate":"2005-02-03","cid":"1","backstory":"placeholder backstory","nationality":"Afghanistan","lastname":"Cooz","phone":"456219","firstname":"Yigits","iban":807479,"gender":0}', '{"label":"Civilian","name":"unemployed","type":"none","onduty":true,"payment":10,"isboss":false,"grade":{"name":"Freelancer","level":0}}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"name":"none","level":0}}', '{"x":-765.8373413085938,"y":-1123.213134765625,"z":10.7113037109375}', '{"jobrep":{"trucker":0,"taxi":0,"hotdog":0,"tow":0},"FFAStats":{"headrate":0,"arms":0,"head":0,"killcount":0,"legs":0,"matchwin":0,"body":0,"deathcount":0},"dealerrep":0,"armor":0,"attachmentcraftingrep":0,"ishandcuffed":false,"craftingrep":0,"phone":[],"inside":{"apartment":[]},"walletid":"QB-81458685","thirst":100,"commandbinds":[],"status":[],"hunger":100,"fingerprint":"wC561W90TzO9683","tracker":false,"phonedata":{"SerialNumber":72588681,"InstalledApps":[]},"callsign":"NO CALLSIGN","inlaststand":false,"fitbit":[],"isdead":false,"jailitems":[],"stress":0,"criminalrecord":{"hasRecord":false},"licences":{"driver":true,"business":false,"weapon":false},"bloodtype":"A+","injail":0}', '[{"name":"phone","slot":1,"count":1}]', NULL, '2025-11-03 18:21:18', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1994, 'TMV37328', 1, 'license:214e91eb4883e92c37b8bf78014cfe670ada09f9', 'venusinc', '{"bank":150340,"crypto":0,"cash":24680}', '{"lastname":"Sdada","firstname":"Sada","nationality":"Albania","account":"US06QBCore9397513411","birthdate":"2003-09-18","gender":0,"iban":805234,"backstory":"placeholder backstory","phone":"586855","cid":"1"}', '{"isboss":false,"label":"Adalet Bakanlığı","name":"doj2","grade":{"level":1,"name":"Marshall"},"payment":100,"onduty":true,"type":"leo"}', '{"isboss":false,"grade":{"level":0,"name":"none"},"label":"No Gang Affiliaton","name":"none"}', '{"x":-907.3450317382813,"y":-3310.879150390625,"z":13.9296875}', '{"callsign":"NO CALLSIGN","jobrep":{"taxi":0,"tow":0,"trucker":0,"hotdog":0},"dealerrep":0,"stress":0,"inlaststand":false,"commandbinds":[],"injail":0,"tracker":false,"phonedata":{"InstalledApps":[],"SerialNumber":31672209},"ishandcuffed":false,"hunger":97,"isdead":false,"attachmentcraftingrep":0,"armor":0,"craftingrep":0,"phone":[],"FFAStats":{"arms":0,"headrate":0,"deathcount":0,"legs":0,"body":0,"killcount":0,"head":0,"matchwin":0},"bloodtype":"A-","criminalrecord":{"hasRecord":false},"jailitems":[],"thirst":98,"licences":{"weapon":false,"driver":true,"business":false},"fitbit":[],"status":[],"fingerprint":"Sx464g19TpA1621","inside":{"apartment":[]},"walletid":"QB-14660774"}', '[{"slot":1,"name":"phone","count":1},{"slot":2,"name":"money","count":24680},{"slot":3,"metadata":{"durability":99.82,"serial":"637677SIT356169","registered":"Sada Sdada","components":[],"ammo":36},"name":"WEAPON_G19","count":1},{"slot":4,"name":"ammo-9","count":51}]', NULL, '2025-11-03 16:10:48', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2182, 'UON85276', 1, 'license:9dd81456c86f563ed878195ba5b27b7046ae0873', '889', '{"crypto":0,"cash":25000,"bank":150000}', '{"gender":0,"cid":"1","nationality":"Afghanistan","birthdate":"1974-05-11","account":"US01QBCore1275765280","lastname":"LUE","phone":"384115","backstory":"placeholder backstory","firstname":"Ruzgar ","iban":435657}', '{"type":"none","payment":10,"grade":{"level":0,"name":"Freelancer"},"onduty":true,"isboss":false,"label":"Civilian","name":"unemployed"}', '{"grade":{"level":0,"name":"none"},"isboss":false,"name":"none","label":"No Gang Affiliaton"}', '{"x":441.0725402832031,"y":231.6659393310547,"z":103.1494140625}', '{"status":[],"jobrep":{"taxi":0,"trucker":0,"hotdog":0,"tow":0},"FFAStats":{"arms":0,"body":0,"killcount":0,"legs":0,"matchwin":0,"deathcount":0,"head":0,"headrate":0},"fitbit":[],"hunger":97,"ishandcuffed":false,"criminalrecord":{"hasRecord":false},"phonedata":{"InstalledApps":[],"SerialNumber":93458089},"fingerprint":"cj082S38iCf5065","tracker":false,"walletid":"QB-63315025","isdead":false,"commandbinds":[],"jailitems":[],"inside":{"apartment":[]},"callsign":"NO CALLSIGN","armor":0,"licences":{"weapon":false,"business":false,"driver":true},"thirst":98,"bloodtype":"A+","injail":0,"craftingrep":0,"dealerrep":0,"phone":[],"attachmentcraftingrep":0,"inlaststand":false,"stress":0}', '[{"slot":1,"count":25000,"name":"money"},{"slot":2,"count":1,"name":"phone"},{"slot":3,"metadata":{"firstname":"Ruzgar ","lastname":"LUE","gender":0,"birthdate":"1974-05-11","nationality":"Afghanistan"},"count":1,"name":"id_card"},{"slot":4,"metadata":{"firstname":"Ruzgar ","type":"Class C Driver License","birthdate":"1974-05-11","lastname":"LUE"},"count":1,"name":"driver_license"}]', NULL, '2025-11-02 15:52:44', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2082, 'UYV17385', 1, 'license:0d2a1c0316dab516fd2a79832e3173e5a78cb2f6', 'Cooz I Rico', '{"bank":151255,"crypto":0,"cash":0}', '{"lastname":"Ewdas","firstname":"Rico","nationality":"Andorra","account":"US04QBCore9769307746","birthdate":"2003-02-06","iban":387039,"gender":0,"backstory":"placeholder backstory","phone":"798357","cid":"1"}', '{"grade":{"name":"Chief","level":15},"isboss":true,"name":"police","payment":245,"label":"LSPD","onduty":true,"type":"leo"}', '{"name":"none","label":"No Gang Affiliaton","isboss":false,"grade":{"name":"none","level":0}}', '{"x":-73.4109878540039,"y":-817.5164794921875,"z":326.173583984375}', '{"FFAStats":{"body":0,"matchwin":0,"deathcount":0,"head":0,"headrate":0,"killcount":0,"legs":0,"arms":0},"jobrep":{"taxi":0,"tow":0,"trucker":0,"hotdog":0},"criminalrecord":{"hasRecord":false},"stress":0,"injail":0,"commandbinds":[],"phone":[],"tracker":false,"phonedata":{"InstalledApps":[],"SerialNumber":51130486},"ishandcuffed":false,"hunger":94,"isdead":false,"attachmentcraftingrep":0,"armor":100,"craftingrep":0,"thirst":96,"inlaststand":false,"bloodtype":"B-","jailitems":[],"dealerrep":0,"callsign":"NO CALLSIGN","licences":{"weapon":false,"driver":true,"business":false},"fitbit":[],"status":[],"fingerprint":"ya310K41xrQ0257","inside":{"apartment":[]},"walletid":"QB-83527183"}', '[{"slot":1,"metadata":{"durability":52.8,"serial":"812519OQZ608768","components":[],"registered":"Rico Ewdas","ammo":61},"name":"WEAPON_SMG","count":1},{"slot":2,"name":"ammo-smg","count":80},{"slot":3,"metadata":{"registered":"Rico Ewdas","serial":"337084HLX601752","components":[],"durability":55.2,"ammo":31},"name":"WEAPON_SMG","count":1},{"slot":4,"name":"armor","count":3},{"slot":5,"name":"heavyarmor","count":2},{"slot":6,"metadata":{"label":"RT2768"},"name":"rentalpapers","count":1},{"slot":7,"metadata":{"durability":49.60000000000004,"serial":"189363KXH862853","components":[],"registered":"Rico Ewdas","ammo":147},"name":"WEAPON_SMG","count":1},{"slot":10,"name":"bandage","count":1},{"slot":11,"metadata":{"durability":100,"serial":"783725MVK406570","components":[],"registered":"Rico Ewdas","ammo":0},"name":"WEAPON_SMG","count":1},{"slot":12,"metadata":{"registered":"Rico Ewdas","serial":"993754OTA109283","components":[],"durability":70.39999999999999,"ammo":263},"name":"WEAPON_SMG","count":1},{"slot":16,"metadata":{"durability":100,"serial":"780247PRJ596181","components":[],"registered":"Rico Ewdas","ammo":0},"name":"WEAPON_SMG","count":1},{"slot":17,"metadata":{"durability":46.40000000000006,"serial":"230469HCR242590","components":[],"registered":"Rico Ewdas","ammo":110},"name":"WEAPON_SMG","count":1}]', NULL, '2025-11-02 20:01:15', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1548, 'VCW52710', 1, 'license:a09c32b16a27352ba120ddff9d0abca4f09855d0', 'sasasa', '{"crypto":0,"bank":205353,"cash":97249}', '{"gender":0,"backstory":"placeholder backstory","firstname":"Dsadas","iban":800551,"phone":"276217","lastname":"Dsadas","cid":"1","birthdate":"2025-03-12","nationality":"Afghanistan","account":"US01QBCore4419949576"}', '{"type":"leo","onduty":true,"isboss":true,"payment":245,"label":"LSPD","name":"police","grade":{"name":"Assistant Chief","level":14}}', '{"isboss":false,"label":"No Gang Affiliaton","name":"none","grade":{"name":"none","level":0}}', '{"x":267.20440673828127,"y":-610.5230712890625,"z":42.5911865234375}', '{"licences":{"weapon":false,"driver":true,"business":false},"jobrep":{"taxi":0,"hotdog":0,"trucker":0,"tow":0},"FFAStats":{"legs":0,"killcount":0,"body":0,"head":0,"deathcount":0,"arms":0,"matchwin":0,"headrate":0},"fingerprint":"GG460u64xRL9120","hunger":88,"callsign":"NO CALLSIGN","walletid":"QB-93108977","inlaststand":false,"status":[],"commandbinds":[],"ishandcuffed":false,"phone":[],"phonedata":{"InstalledApps":[],"SerialNumber":73098089},"stress":0,"thirst":92,"armor":0,"fitbit":[],"playtimereward":true,"playtime":120,"dealerrep":0,"tracker":false,"isdead":false,"injail":0,"inside":{"apartment":[]},"craftingrep":0,"jailitems":[],"attachmentcraftingrep":0,"criminalrecord":{"hasRecord":false},"bloodtype":"O-"}', '[{"name":"money","slot":1,"count":97249},{"name":"lowgrademaleseed","slot":2,"count":24},{"name":"empty_weed_bag","slot":3,"count":25},{"name":"phone","slot":4,"count":1},{"name":"karapara","slot":5,"count":318134}]', NULL, '2025-03-20 21:43:12', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1620, 'VQO03826', 1, 'license:5a1ff3a35a2ac9e62f18c9ef8c4e2f2efe09f999', 'eren', '{"bank":150000,"cash":9990,"crypto":0}', '{"firstname":"Eren ","backstory":"placeholder backstory","cid":"1","birthdate":"2000-02-03","phone":"298947","iban":951663,"lastname":"Cabbar","nationality":"Turks and Caicos Islands","gender":0,"account":"US09QBCore9758199766"}', '{"name":"unemployed","isboss":false,"label":"Civilian","type":"none","grade":{"name":"Freelancer","level":0},"onduty":true,"payment":10}', '{"name":"none","grade":{"name":"none","level":0},"isboss":false,"label":"No Gang Affiliaton"}', '{"x":-793.6879272460938,"y":-1238.7032470703126,"z":7.3245849609375}', '{"jailitems":[],"injail":0,"hunger":94,"stress":0,"criminalrecord":{"hasRecord":false},"playtimereward":false,"playtime":7,"bloodtype":"O+","walletid":"QB-29307875","jobrep":{"trucker":0,"taxi":0,"hotdog":0,"tow":0},"FFAStats":{"deathcount":0,"legs":0,"headrate":0,"killcount":0,"head":0,"matchwin":0,"arms":0,"body":0},"fingerprint":"vC053g50ftd6884","commandbinds":[],"isdead":false,"tracker":false,"craftingrep":0,"thirst":96,"inlaststand":false,"ishandcuffed":false,"phonedata":{"InstalledApps":[],"SerialNumber":52356816},"fitbit":[],"attachmentcraftingrep":0,"dealerrep":0,"phone":[],"armor":0,"licences":{"business":false,"weapon":false,"driver":true},"callsign":"NO CALLSIGN","status":[],"inside":{"apartment":[]}}', '[{"count":9990,"name":"money","slot":1},{"count":1,"name":"driver_license","metadata":{"lastname":"Cabbar","firstname":"Eren ","birthdate":"2000-02-03","type":"Class C Driver License"},"slot":2},{"count":1,"name":"id_card","metadata":{"lastname":"Cabbar","firstname":"Eren ","gender":0,"citizenid":"VQO03826","nationality":"Turks and Caicos Islands","birthdate":"2000-02-03"},"slot":3},{"count":10,"name":"water","slot":4},{"count":1,"name":"phone","slot":5},{"count":10,"name":"burger","slot":6},{"count":1,"name":"rentalpapers","metadata":{"label":"LIGHTV1070"},"slot":7}]', NULL, '2025-03-16 00:39:59', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2537, 'WGI37560', 1, 'license:51b88cfa30ab7f73e465fea5b656d943fe8e042c', 'Alzein Nicolas', '{"cash":0,"crypto":0,"bank":149600}', '{"backstory":"placeholder backstory","firstname":"Nicolas","phone":"162117","iban":509258,"lastname":"Torres","cid":"1","account":"US06QBCore7830646386","birthdate":"1997-11-13","nationality":"Qatar","gender":0}', '{"type":"none","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"onduty":true,"label":"Civilian","isboss":false,"payment":10}', '{"isboss":false,"name":"none","label":"No Gang Affiliaton","grade":{"level":0,"name":"none"}}', '{"x":-3112.786865234375,"y":1062.738525390625,"z":20.3494873046875}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"body":0,"headrate":0,"arms":0,"matchwin":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"phonedata":{"InstalledApps":[],"SerialNumber":82506465},"callsign":"NO CALLSIGN","ishandcuffed":false,"fingerprint":"IM328g39rXc3952","craftingrep":0,"dealerrep":0,"injail":0,"commandbinds":[],"walletid":"QB-63009489","jailitems":[],"inside":{"apartment":[]},"inlaststand":false,"stress":0,"phone":[],"fitbit":[],"armor":0,"bloodtype":"A-","jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"thirst":98,"hunger":97,"criminalrecord":{"hasRecord":false},"isdead":false,"attachmentcraftingrep":0}', '[{"name":"phone","count":1,"slot":1},{"name":"weed_seed","count":3,"slot":2}]', NULL, '2025-11-04 21:40:38', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2222, 'WJC37394', 1, 'license:bf12cd7bd0d2b67148e146755969f37e71710e13', 'Benı Nıye Sevmedın?', '{"cash":10010000000000000000.0,"crypto":0,"bank":151885}', '{"backstory":"placeholder backstory","firstname":"Zantree","phone":"690579","iban":725512,"birthdate":"1996-04-02","cid":"1","lastname":"Can","account":"US09QBCore9934834623","nationality":"Andorra","gender":0}', '{"label":"LSPD","payment":245,"grade":{"level":15,"name":"Chief"},"onduty":true,"name":"police","type":"leo","isboss":true}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":16.20659446716308,"y":-952.6681518554688,"z":36.188232421875}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"bloodtype":"A-","FFAStats":{"headrate":0,"body":0,"matchwin":0,"arms":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","phonedata":{"SerialNumber":47351814,"InstalledApps":[]},"fingerprint":"DY036A25Wom9675","dealerrep":0,"tracker":false,"injail":0,"commandbinds":[],"walletid":"QB-25177726","ishandcuffed":false,"inside":{"apartment":[]},"attachmentcraftingrep":0,"fitbit":[],"phone":[],"hunger":70,"armor":100,"stress":0,"inlaststand":false,"thirst":80,"craftingrep":0,"criminalrecord":{"hasRecord":false},"isdead":false,"jailitems":[]}', '[{"name":"WEAPON_GLOCK","count":1,"metadata":{"serial":"245827POL414242","durability":99.92,"ammo":162,"components":[],"registered":"Zantree Can"},"slot":1},{"name":"bandage","count":161,"slot":2},{"name":"heavyarmor2","count":25,"slot":3},{"name":"pistol_ammo2","count":20,"slot":5},{"name":"WEAPON_FLASHLIGHT","count":1,"metadata":{"components":[],"durability":100},"slot":6},{"name":"orange","count":8,"slot":8},{"name":"WEAPON_NIGHTSTICK","count":1,"metadata":{"components":[],"durability":89.9000000000001},"slot":9},{"name":"radio","count":1,"slot":10},{"name":"bodycam","count":1,"slot":11},{"name":"phone","count":1,"slot":12},{"name":"gps","count":1,"slot":13},{"name":"karpuz","count":1,"slot":14},{"name":"rentalpapers","count":1,"metadata":{"label":"RT2213"},"slot":15},{"name":"rentalpapers","count":1,"metadata":{"label":"RT4319"},"slot":16},{"name":"money","count":10010000000000000000.0,"slot":18}]', NULL, '2025-11-04 17:04:41', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1574, 'WLF54664', 1, 'license:2ba6022d9eccdd57eef9a31cda577bdfe0a1f324', 'Flame', '{"crypto":0,"bank":199750,"cash":0}', '{"backstory":"placeholder backstory","lastname":"Santo","iban":101490,"gender":0,"phone":"833395","birthdate":"1997-08-08","nationality":"United Arab Emirates","firstname":"Flame","account":"US04QBCore4284802668","cid":"1"}', '{"isboss":false,"label":"Civilian","name":"unemployed","type":"none","grade":{"level":0,"name":"Freelancer"},"onduty":true,"payment":10}', '{"isboss":false,"grade":{"level":0,"name":"none"},"label":"No Gang Affiliaton","name":"none"}', '{"x":992.5450439453125,"y":229.8329620361328,"z":103.924560546875}', '{"playtimereward":true,"jailitems":[],"injail":0,"isdead":false,"phone":[],"tracker":false,"callsign":"NO CALLSIGN","craftingrep":0,"commandbinds":[],"licences":{"driver":true,"business":false,"weapon":false},"bloodtype":"AB-","attachmentcraftingrep":0,"hunger":16,"phonedata":{"InstalledApps":[],"SerialNumber":22658959},"inside":{"apartment":[]},"inlaststand":false,"dealerrep":0,"criminalrecord":{"hasRecord":false},"ishandcuffed":false,"status":[],"jobrep":{"hotdog":0,"trucker":0,"taxi":0,"tow":0},"fitbit":[],"FFAStats":{"matchwin":0,"head":0,"arms":0,"killcount":0,"headrate":0,"legs":0,"body":0,"deathcount":0},"stress":0,"armor":0,"thirst":44,"playtime":120,"fingerprint":"kr569j01PCO2724","walletid":"QB-79901535"}', '[{"slot":1,"name":"phone","count":1}]', NULL, '2025-03-18 02:46:40', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2603, 'XDL74210', 1, 'license:52bd660490afcf8518d4384f3f31ee6ce1aefb49', 'Letra x wazzed', '{"cash":0,"crypto":0,"bank":149110}', '{"backstory":"placeholder backstory","firstname":"Eric","phone":"983318","iban":298243,"birthdate":"2004-08-05","cid":"1","account":"US09QBCore4469228978","lastname":"Ryner","nationality":"Thailand","gender":0}', '{"label":"Civilian","name":"unemployed","grade":{"level":0,"name":"Freelancer"},"onduty":true,"type":"none","payment":10,"isboss":false}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":1295.98681640625,"y":-569.4725341796875,"z":71.3707275390625}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"arms":0,"headrate":0,"matchwin":0,"body":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","injail":0,"fingerprint":"Eq356A23RHS4737","bloodtype":"O+","hunger":100,"inlaststand":false,"commandbinds":[],"walletid":"QB-35811773","ishandcuffed":false,"inside":{"apartment":[]},"stress":0,"attachmentcraftingrep":0,"phone":[],"jailitems":[],"armor":0,"dealerrep":0,"fitbit":[],"thirst":100,"craftingrep":0,"criminalrecord":{"hasRecord":false},"isdead":false,"phonedata":{"InstalledApps":[],"SerialNumber":13010873}}', '[{"name":"phone","count":1,"slot":1}]', NULL, '2025-11-04 22:15:01', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(1661, 'XRF14123', 1, 'license:595eb5e362bd732e733661bc4acb940eccee5c76', 'a8119', '{"bank":150000,"cash":10000,"crypto":0}', '{"backstory":"placeholder backstory","lastname":"Vercetti","phone":"533482","gender":0,"birthdate":"2025-03-01","iban":64761,"firstname":"Ege","account":"US07QBCore9987816890","nationality":"Andorra","cid":"1"}', '{"name":"unemployed","onduty":true,"type":"none","label":"Civilian","isboss":false,"grade":{"name":"Freelancer","level":0},"payment":10}', '{"name":"none","isboss":false,"grade":{"name":"none","level":0},"label":"No Gang Affiliaton"}', '{"x":-1837.4110107421876,"y":-380.9010925292969,"z":49.3143310546875}', '{"armor":0,"thirst":98,"phonedata":{"SerialNumber":72901230,"InstalledApps":[]},"FFAStats":{"head":0,"arms":0,"legs":0,"deathcount":0,"matchwin":0,"headrate":0,"killcount":0,"body":0},"inside":{"apartment":[]},"isdead":false,"playtime":2,"jailitems":[],"playtimereward":false,"injail":0,"bloodtype":"A-","fitbit":[],"craftingrep":0,"hunger":97,"criminalrecord":{"hasRecord":false},"walletid":"QB-76442694","ishandcuffed":false,"stress":0,"fingerprint":"lw007r17qve9936","inlaststand":false,"tracker":false,"jobrep":{"hotdog":0,"tow":0,"trucker":0,"taxi":0},"attachmentcraftingrep":0,"dealerrep":0,"licences":{"driver":true,"weapon":false,"business":false},"phone":[],"callsign":"NO CALLSIGN","commandbinds":[],"status":[]}', '[{"count":10000,"name":"money","slot":1},{"count":1,"name":"phone","slot":2},{"metadata":{"gender":0,"birthdate":"2025-03-01","firstname":"Ege","nationality":"Andorra","lastname":"Vercetti","citizenid":"XRF14123"},"count":1,"name":"id_card","slot":3},{"metadata":{"birthdate":"2025-03-01","lastname":"Vercetti","type":"Class C Driver License","firstname":"Ege"},"count":1,"name":"driver_license","slot":4},{"count":10,"name":"water","slot":5},{"count":10,"name":"burger","slot":6}]', NULL, '2025-03-17 14:35:28', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2361, 'XRS51596', 1, 'license:6002acbea3093c2a140f675b189cf5aa803393fa', 'Wozy', '{"bank":150030,"cash":0,"crypto":0}', '{"lastname":"Sf","firstname":"Sf","nationality":"United Arab Emirates","account":"US01QBCore2566538713","birthdate":"1994-05-05","iban":790149,"gender":0,"backstory":"placeholder backstory","phone":"965422","cid":"1"}', '{"type":"none","isboss":false,"payment":10,"label":"Civilian","name":"unemployed","onduty":true,"grade":{"name":"Freelancer","level":0}}', '{"name":"none","label":"No Gang Affiliaton","isboss":false,"grade":{"name":"none","level":0}}', '{"x":-542.5186767578125,"y":-603.5076904296875,"z":62.4908447265625}', '{"FFAStats":{"body":0,"matchwin":0,"deathcount":0,"head":0,"headrate":0,"killcount":0,"legs":0,"arms":0},"jobrep":{"taxi":0,"tow":0,"trucker":0,"hotdog":0},"criminalrecord":{"hasRecord":false},"stress":0,"armor":100,"commandbinds":[],"phone":[],"tracker":false,"phonedata":{"SerialNumber":20082168,"InstalledApps":[]},"ishandcuffed":false,"hunger":100,"fitbit":[],"attachmentcraftingrep":0,"thirst":100,"injail":0,"inlaststand":false,"isdead":false,"bloodtype":"B-","jailitems":[],"dealerrep":0,"craftingrep":0,"licences":{"weapon":false,"driver":true,"business":false},"callsign":"NO CALLSIGN","status":[],"fingerprint":"TO616O08NTQ1583","inside":{"apartment":[]},"walletid":"QB-16562053"}', NULL, NULL, '2025-11-03 15:30:04', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0),
	(2134, 'YQQ65276', 1, 'license:1fa4cbe35478320523abdc8b229bf803826cd457', 'baran', '{"cash":0,"crypto":0,"bank":149500}', '{"backstory":"placeholder backstory","firstname":"Baran","phone":"343233","account":"US04QBCore3011639382","iban":654804,"cid":"1","birthdate":"1980-01-01","lastname":"Tuncer","nationality":"Afghanistan","gender":0}', '{"label":"Civilian","payment":10,"grade":{"level":0,"name":"Freelancer"},"onduty":true,"isboss":false,"type":"none","name":"unemployed"}', '{"label":"No Gang Affiliaton","name":"none","isboss":false,"grade":{"level":0,"name":"none"}}', '{"x":-100.78681182861328,"y":-781.4241943359375,"z":44.5457763671875}', '{"status":[],"licences":{"driver":true,"weapon":false,"business":false},"tracker":false,"FFAStats":{"headrate":0,"arms":0,"matchwin":0,"body":0,"head":0,"deathcount":0,"legs":0,"killcount":0},"jobrep":{"hotdog":0,"trucker":0,"tow":0,"taxi":0},"callsign":"NO CALLSIGN","injail":0,"fingerprint":"ik721K68zze7193","bloodtype":"O-","dealerrep":0,"inlaststand":false,"commandbinds":[],"walletid":"QB-19651257","ishandcuffed":false,"inside":{"apartment":[]},"jailitems":[],"attachmentcraftingrep":0,"phone":[],"isdead":true,"armor":0,"fitbit":[],"hunger":100,"thirst":100,"phonedata":{"SerialNumber":24758751,"InstalledApps":[]},"criminalrecord":{"hasRecord":false},"craftingrep":0,"stress":0}', '[{"name":"phone","count":1,"slot":1}]', NULL, '2025-11-04 14:58:01', 0, '[]', 'basic', NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, '[]', 0, 0);

-- Dumping structure for table crystalrp.playerskins
