Advertisement
Bacon_Space

BSRP

May 10th, 2024
912
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 109.43 KB | None | 0 0
  1. CREATE TABLE `apartments` (
  2.   `id` INT(11) NOT NULL,
  3.   `name` VARCHAR(255) DEFAULT NULL,
  4.   `type` VARCHAR(255) DEFAULT NULL,
  5.   `label` VARCHAR(255) DEFAULT NULL,
  6.   `citizenid` VARCHAR(11) DEFAULT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  8.  
  9. --
  10. -- Dumping data for table `apartments`
  11. --
  12.  
  13. INSERT INTO `apartments` (`id`, `name`, `type`, `label`, `citizenid`) VALUES
  14. (1, 'apartment43212', 'apartment4', 'South Rockford Drive 8123', 'BYV87342'),
  15. (2, 'apartment18123', 'apartment1', 'South Rockford Drive 8123', 'UFQ88534'),
  16. (4, 'apartment14670', 'apartment1', 'South Rockford Drive 4670', 'UGE35348'),
  17. (5, 'apartment1707', 'apartment1', 'South Rockford Drive', 'SSL19978');
  18.  
  19. -- --------------------------------------------------------
  20.  
  21. --
  22. -- Table structure for table `bank_accounts`
  23. --
  24.  
  25. CREATE TABLE `bank_accounts` (
  26.   `id` INT(11) NOT NULL,
  27.   `citizenid` VARCHAR(11) DEFAULT NULL,
  28.   `account_name` VARCHAR(50) DEFAULT NULL,
  29.   `account_balance` INT(11) NOT NULL DEFAULT 0,
  30.   `account_type` enum('shared','job','gang') NOT NULL,
  31.   `users` longtext DEFAULT '[]'
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  33.  
  34. --
  35. -- Dumping data for table `bank_accounts`
  36. --
  37.  
  38. INSERT INTO `bank_accounts` (`id`, `citizenid`, `account_name`, `account_balance`, `account_type`, `users`) VALUES
  39. (1, NULL, 'blackhand', 0, 'gang', '[]');
  40.  
  41. -- --------------------------------------------------------
  42.  
  43. --
  44. -- Table structure for table `bank_statements`
  45. --
  46.  
  47. CREATE TABLE `bank_statements` (
  48.   `id` INT(11) NOT NULL,
  49.   `citizenid` VARCHAR(11) DEFAULT NULL,
  50.   `account_name` VARCHAR(50) DEFAULT 'checking',
  51.   `amount` INT(11) DEFAULT NULL,
  52.   `reason` VARCHAR(50) DEFAULT NULL,
  53.   `statement_type` enum('deposit','withdraw') DEFAULT NULL,
  54.   `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  56.  
  57. --
  58. -- Dumping data for table `bank_statements`
  59. --
  60.  
  61. INSERT INTO `bank_statements` (`id`, `citizenid`, `account_name`, `amount`, `reason`, `statement_type`, `date`) VALUES
  62. (1, 'UFQ88534', 'checking', 400, 'For a car', 'deposit', '2024-04-08 16:04:19'),
  63. (2, 'BYV87342', 'checking', 5000, 'For a Car', 'withdraw', '2024-04-08 21:45:47');
  64.  
  65. -- --------------------------------------------------------
  66.  
  67. --
  68. -- Table structure for table `bans`
  69. --
  70.  
  71. CREATE TABLE `bans` (
  72.   `id` INT(11) NOT NULL,
  73.   `name` VARCHAR(50) DEFAULT NULL,
  74.   `license` VARCHAR(50) DEFAULT NULL,
  75.   `discord` VARCHAR(50) DEFAULT NULL,
  76.   `ip` VARCHAR(50) DEFAULT NULL,
  77.   `reason` text DEFAULT NULL,
  78.   `expire` INT(11) DEFAULT NULL,
  79.   `bannedby` VARCHAR(255) NOT NULL DEFAULT 'LeBanhammer'
  80. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `computers_mail_accounts`
  86. --
  87.  
  88. CREATE TABLE `computers_mail_accounts` (
  89.   `id` INT(11) NOT NULL,
  90.   `identifier` VARCHAR(40) NOT NULL,
  91.   `username` VARCHAR(16) NOT NULL,
  92.   `password` VARCHAR(32) NOT NULL
  93. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  94.  
  95. --
  96. -- Dumping data for table `computers_mail_accounts`
  97. --
  98.  
  99. INSERT INTO `computers_mail_accounts` (`id`, `identifier`, `username`, `password`) VALUES
  100. (1, '3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Test', 'test'),
  101. (2, '3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Sparky King', 'random1');
  102.  
  103. -- --------------------------------------------------------
  104.  
  105. --
  106. -- Table structure for table `computers_mail_mails`
  107. --
  108.  
  109. CREATE TABLE `computers_mail_mails` (
  110.   `id` INT(11) NOT NULL,
  111.   `from` VARCHAR(16) NOT NULL,
  112.   `to` VARCHAR(16) NOT NULL,
  113.   `object` VARCHAR(32) DEFAULT NULL,
  114.   `text` VARCHAR(4096) DEFAULT NULL,
  115.   `answer_to` INT(11) DEFAULT NULL,
  116.   `timestamp` INT(11) DEFAULT unix_timestamp(),
  117.   `read` tinyint(1) DEFAULT NULL
  118. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  119.  
  120. -- --------------------------------------------------------
  121.  
  122. --
  123. -- Table structure for table `computers_market`
  124. --
  125.  
  126. CREATE TABLE `computers_market` (
  127.   `id` INT(11) NOT NULL,
  128.   `seller` VARCHAR(40) NOT NULL,
  129.   `title` VARCHAR(16) NOT NULL,
  130.   `description` VARCHAR(512) DEFAULT NULL,
  131.   `timestamp` INT(11) DEFAULT unix_timestamp()
  132. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  133.  
  134. -- --------------------------------------------------------
  135.  
  136. --
  137. -- Table structure for table `crypto`
  138. --
  139.  
  140. CREATE TABLE `crypto` (
  141.   `crypto` VARCHAR(50) NOT NULL DEFAULT 'qbit',
  142.   `worth` INT(11) NOT NULL DEFAULT 0,
  143.   `history` text DEFAULT NULL
  144. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
  145.  
  146. --
  147. -- Dumping data for table `crypto`
  148. --
  149.  
  150. INSERT INTO `crypto` (`crypto`, `worth`, `history`) VALUES
  151. ('qbit', 990, '[{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":990,\"PreviousWorth\":998}]');
  152.  
  153. -- --------------------------------------------------------
  154.  
  155. --
  156. -- Table structure for table `crypto_transactions`
  157. --
  158.  
  159. CREATE TABLE `crypto_transactions` (
  160.   `id` INT(11) NOT NULL,
  161.   `citizenid` VARCHAR(11) DEFAULT NULL,
  162.   `title` VARCHAR(50) DEFAULT NULL,
  163.   `message` VARCHAR(50) DEFAULT NULL,
  164.   `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP()
  165. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  166.  
  167. --
  168. -- Dumping data for table `crypto_transactions`
  169. --
  170.  
  171. INSERT INTO `crypto_transactions` (`id`, `citizenid`, `title`, `message`, `date`) VALUES
  172. (1, 'BYV87342', 'Credit', 'You have purchased 1 Qbit(s)!', '2024-04-12 05:13:07'),
  173. (2, 'BYV87342', 'Debit', 'You have sold 1 Qbit(s)!', '2024-04-12 05:13:13');
  174.  
  175. -- --------------------------------------------------------
  176.  
  177. --
  178. -- Table structure for table `dealers`
  179. --
  180.  
  181. CREATE TABLE `dealers` (
  182.   `id` INT(11) NOT NULL,
  183.   `name` VARCHAR(50) NOT NULL DEFAULT '0',
  184.   `coords` longtext DEFAULT NULL,
  185.   `time` longtext DEFAULT NULL,
  186.   `createdby` VARCHAR(50) NOT NULL DEFAULT '0'
  187. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  188.  
  189. -- --------------------------------------------------------
  190.  
  191. --
  192. -- Table structure for table `dpkeybinds`
  193. --
  194.  
  195. CREATE TABLE `dpkeybinds` (
  196.   `id` VARCHAR(50) DEFAULT NULL,
  197.   `keybind1` VARCHAR(50) DEFAULT 'num4',
  198.   `emote1` VARCHAR(255) DEFAULT '',
  199.   `keybind2` VARCHAR(50) DEFAULT 'num5',
  200.   `emote2` VARCHAR(255) DEFAULT '',
  201.   `keybind3` VARCHAR(50) DEFAULT 'num6',
  202.   `emote3` VARCHAR(255) DEFAULT '',
  203.   `keybind4` VARCHAR(50) DEFAULT 'num7',
  204.   `emote4` VARCHAR(255) DEFAULT '',
  205.   `keybind5` VARCHAR(50) DEFAULT 'num8',
  206.   `emote5` VARCHAR(255) DEFAULT '',
  207.   `keybind6` VARCHAR(50) DEFAULT 'num9',
  208.   `emote6` VARCHAR(255) DEFAULT ''
  209. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
  210.  
  211. -- --------------------------------------------------------
  212.  
  213. --
  214. -- Table structure for table `gloveboxitems`
  215. --
  216.  
  217. CREATE TABLE `gloveboxitems` (
  218.   `id` INT(11) NOT NULL,
  219.   `plate` VARCHAR(8) NOT NULL DEFAULT '[]',
  220.   `items` longtext DEFAULT NULL
  221. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  222.  
  223. --
  224. -- Dumping data for table `gloveboxitems`
  225. --
  226.  
  227. INSERT INTO `gloveboxitems` (`id`, `plate`, `items`) VALUES
  228. (1, '3PM529YQ', '[]'),
  229. (2, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"}]'),
  230. (3, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"}]'),
  231. (4, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  232. (5, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  233. (6, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  234. (7, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  235. (8, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  236. (9, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  237. (10, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
  238. (11, '4UK308JV', '[]');
  239.  
  240. -- --------------------------------------------------------
  241.  
  242. --
  243. -- Table structure for table `houselocations`
  244. --
  245.  
  246. CREATE TABLE `houselocations` (
  247.   `id` INT(11) NOT NULL,
  248.   `name` VARCHAR(255) DEFAULT NULL,
  249.   `label` VARCHAR(255) DEFAULT NULL,
  250.   `coords` text DEFAULT NULL,
  251.   `owned` tinyint(1) DEFAULT NULL,
  252.   `price` INT(11) DEFAULT NULL,
  253.   `tier` tinyint(4) DEFAULT NULL,
  254.   `garage` text DEFAULT NULL
  255. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  256.  
  257. -- --------------------------------------------------------
  258.  
  259. --
  260. -- Table structure for table `house_plants`
  261. --
  262.  
  263. CREATE TABLE `house_plants` (
  264.   `id` INT(11) NOT NULL,
  265.   `building` VARCHAR(50) DEFAULT NULL,
  266.   `stage` INT(11) DEFAULT 1,
  267.   `sort` VARCHAR(50) DEFAULT NULL,
  268.   `gender` VARCHAR(50) DEFAULT NULL,
  269.   `food` INT(11) DEFAULT 100,
  270.   `health` INT(11) DEFAULT 100,
  271.   `progress` INT(11) DEFAULT 0,
  272.   `coords` text DEFAULT NULL,
  273.   `plantid` VARCHAR(50) DEFAULT NULL
  274. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  275.  
  276. -- --------------------------------------------------------
  277.  
  278. --
  279. -- Table structure for table `lapraces`
  280. --
  281.  
  282. CREATE TABLE `lapraces` (
  283.   `id` INT(11) NOT NULL,
  284.   `name` VARCHAR(50) DEFAULT NULL,
  285.   `checkpoints` text DEFAULT NULL,
  286.   `records` text DEFAULT NULL,
  287.   `creator` VARCHAR(50) DEFAULT NULL,
  288.   `distance` INT(11) DEFAULT NULL,
  289.   `raceid` VARCHAR(50) DEFAULT NULL
  290. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  291.  
  292. -- --------------------------------------------------------
  293.  
  294. --
  295. -- Table structure for table `mdt_bolos`
  296. --
  297.  
  298. CREATE TABLE `mdt_bolos` (
  299.   `id` INT(11) NOT NULL,
  300.   `author` VARCHAR(50) DEFAULT NULL,
  301.   `title` VARCHAR(50) DEFAULT NULL,
  302.   `plate` VARCHAR(50) DEFAULT NULL,
  303.   `owner` VARCHAR(50) DEFAULT NULL,
  304.   `individual` VARCHAR(50) DEFAULT NULL,
  305.   `detail` text DEFAULT NULL,
  306.   `tags` text DEFAULT NULL,
  307.   `gallery` text DEFAULT NULL,
  308.   `officersinvolved` text DEFAULT NULL,
  309.   `time` VARCHAR(20) DEFAULT NULL,
  310.   `jobtype` VARCHAR(25) NOT NULL DEFAULT 'police'
  311. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  312.  
  313. --
  314. -- Dumping data for table `mdt_bolos`
  315. --
  316.  
  317. INSERT INTO `mdt_bolos` (`id`, `author`, `title`, `plate`, `owner`, `individual`, `detail`, `tags`, `gallery`, `officersinvolved`, `time`, `jobtype`) VALUES
  318. (1, 'Server Admin', 'Bolo #1', 'None', 'None', 'Devin King', '<p>Keep An Eye Out For Devin King</p>', '[\"The Crimson Blades\"]', '[]', '[\"(K10) Sparky King\"]', '1714156679804', 'police');
  319.  
  320. -- --------------------------------------------------------
  321.  
  322. --
  323. -- Table structure for table `mdt_bulletin`
  324. --
  325.  
  326. CREATE TABLE `mdt_bulletin` (
  327.   `id` INT(11) NOT NULL,
  328.   `title` text NOT NULL,
  329.   `desc` text NOT NULL,
  330.   `author` VARCHAR(50) NOT NULL,
  331.   `time` VARCHAR(20) NOT NULL,
  332.   `jobtype` VARCHAR(25) DEFAULT 'police'
  333. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  334.  
  335. -- --------------------------------------------------------
  336.  
  337. --
  338. -- Table structure for table `mdt_clocking`
  339. --
  340.  
  341. CREATE TABLE `mdt_clocking` (
  342.   `id` INT(10) NOT NULL,
  343.   `user_id` VARCHAR(50) NOT NULL DEFAULT '',
  344.   `firstname` VARCHAR(255) NOT NULL DEFAULT '',
  345.   `lastname` VARCHAR(255) NOT NULL DEFAULT '',
  346.   `clock_in_time` VARCHAR(255) NOT NULL DEFAULT '',
  347.   `clock_out_time` VARCHAR(50) DEFAULT NULL,
  348.   `total_time` INT(10) NOT NULL DEFAULT 0
  349. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  350.  
  351. --
  352. -- Dumping data for table `mdt_clocking`
  353. --
  354.  
  355. INSERT INTO `mdt_clocking` (`id`, `user_id`, `firstname`, `lastname`, `clock_in_time`, `clock_out_time`, `total_time`) VALUES
  356. (7, 'SSL19978', 'Server', 'Admin', '2024-04-26 14:38:29', '2024-04-26 16:22:39', 6250);
  357.  
  358. -- --------------------------------------------------------
  359.  
  360. --
  361. -- Table structure for table `mdt_convictions`
  362. --
  363.  
  364. CREATE TABLE `mdt_convictions` (
  365.   `id` INT(11) NOT NULL,
  366.   `cid` VARCHAR(50) DEFAULT NULL,
  367.   `linkedincident` INT(11) NOT NULL DEFAULT 0,
  368.   `warrant` VARCHAR(50) DEFAULT NULL,
  369.   `guilty` VARCHAR(50) DEFAULT NULL,
  370.   `processed` VARCHAR(50) DEFAULT NULL,
  371.   `associated` VARCHAR(50) DEFAULT '0',
  372.   `charges` text DEFAULT NULL,
  373.   `fine` INT(11) DEFAULT 0,
  374.   `sentence` INT(11) DEFAULT 0,
  375.   `recfine` INT(11) DEFAULT 0,
  376.   `recsentence` INT(11) DEFAULT 0,
  377.   `time` VARCHAR(20) DEFAULT NULL
  378. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  379.  
  380. -- --------------------------------------------------------
  381.  
  382. --
  383. -- Table structure for table `mdt_data`
  384. --
  385.  
  386. CREATE TABLE `mdt_data` (
  387.   `id` INT(11) NOT NULL,
  388.   `cid` VARCHAR(20) NOT NULL,
  389.   `information` mediumtext DEFAULT NULL,
  390.   `tags` text NOT NULL,
  391.   `gallery` text NOT NULL,
  392.   `jobtype` VARCHAR(25) DEFAULT 'police',
  393.   `pfp` text DEFAULT NULL,
  394.   `fingerprint` VARCHAR(50) DEFAULT NULL
  395. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  396.  
  397. -- --------------------------------------------------------
  398.  
  399. --
  400. -- Table structure for table `mdt_impound`
  401. --
  402.  
  403. CREATE TABLE `mdt_impound` (
  404.   `id` INT(11) NOT NULL,
  405.   `vehicleid` INT(11) NOT NULL,
  406.   `linkedreport` INT(11) NOT NULL,
  407.   `fee` INT(11) DEFAULT NULL,
  408.   `time` VARCHAR(255) NOT NULL
  409. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  410.  
  411. -- --------------------------------------------------------
  412.  
  413. --
  414. -- Table structure for table `mdt_incidents`
  415. --
  416.  
  417. CREATE TABLE `mdt_incidents` (
  418.   `id` INT(11) NOT NULL,
  419.   `author` VARCHAR(50) NOT NULL DEFAULT '',
  420.   `title` VARCHAR(50) NOT NULL DEFAULT '0',
  421.   `details` longtext NOT NULL,
  422.   `tags` text NOT NULL,
  423.   `officersinvolved` text NOT NULL,
  424.   `civsinvolved` text NOT NULL,
  425.   `evidence` text NOT NULL,
  426.   `time` VARCHAR(20) DEFAULT NULL,
  427.   `jobtype` VARCHAR(25) NOT NULL DEFAULT 'police'
  428. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  429.  
  430. -- --------------------------------------------------------
  431.  
  432. --
  433. -- Table structure for table `mdt_logs`
  434. --
  435.  
  436. CREATE TABLE `mdt_logs` (
  437.   `id` INT(11) NOT NULL,
  438.   `text` text NOT NULL,
  439.   `time` VARCHAR(20) DEFAULT NULL,
  440.   `jobtype` VARCHAR(25) DEFAULT 'police'
  441. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  442.  
  443. --
  444. -- Dumping data for table `mdt_logs`
  445. --
  446.  
  447. INSERT INTO `mdt_logs` (`id`, `text`, `time`, `jobtype`) VALUES
  448. (1, 'A new BOLO was created by Server Admin with the title (Bolo #1) and ID (0)', '1714156679000', 'police');
  449.  
  450. -- --------------------------------------------------------
  451.  
  452. --
  453. -- Table structure for table `mdt_reports`
  454. --
  455.  
  456. CREATE TABLE `mdt_reports` (
  457.   `id` INT(11) NOT NULL,
  458.   `author` VARCHAR(50) DEFAULT NULL,
  459.   `title` VARCHAR(255) DEFAULT NULL,
  460.   `type` VARCHAR(50) DEFAULT NULL,
  461.   `details` longtext DEFAULT NULL,
  462.   `tags` text DEFAULT NULL,
  463.   `officersinvolved` text DEFAULT NULL,
  464.   `civsinvolved` text DEFAULT NULL,
  465.   `gallery` text DEFAULT NULL,
  466.   `time` VARCHAR(20) DEFAULT NULL,
  467.   `jobtype` VARCHAR(25) DEFAULT 'police'
  468. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  469.  
  470. -- --------------------------------------------------------
  471.  
  472. --
  473. -- Table structure for table `mdt_vehicleinfo`
  474. --
  475.  
  476. CREATE TABLE `mdt_vehicleinfo` (
  477.   `id` INT(11) NOT NULL,
  478.   `plate` VARCHAR(50) DEFAULT NULL,
  479.   `information` text NOT NULL DEFAULT '',
  480.   `stolen` tinyint(1) NOT NULL DEFAULT 0,
  481.   `code5` tinyint(1) NOT NULL DEFAULT 0,
  482.   `image` text NOT NULL DEFAULT '',
  483.   `points` INT(11) DEFAULT 0
  484. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  485.  
  486. -- --------------------------------------------------------
  487.  
  488. --
  489. -- Table structure for table `mdt_weaponinfo`
  490. --
  491.  
  492. CREATE TABLE `mdt_weaponinfo` (
  493.   `id` INT(11) NOT NULL,
  494.   `serial` VARCHAR(50) DEFAULT NULL,
  495.   `owner` VARCHAR(50) DEFAULT NULL,
  496.   `information` text NOT NULL DEFAULT '',
  497.   `weapClass` VARCHAR(50) DEFAULT NULL,
  498.   `weapModel` VARCHAR(50) DEFAULT NULL,
  499.   `image` VARCHAR(255) DEFAULT NULL
  500. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  501.  
  502. --
  503. -- Dumping data for table `mdt_weaponinfo`
  504. --
  505.  
  506. INSERT INTO `mdt_weaponinfo` (`id`, `serial`, `owner`, `information`, `weapClass`, `weapModel`, `image`) VALUES
  507. (1, '73Xzy1Gr331QiTS', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  508. (2, '96Yfm7ax619aTzB', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  509. (3, '48YUG2yT672dkka', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  510. (4, '94dNP3bx658grQR', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  511. (5, '61mwR3eG335vnyr', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  512. (6, '32Zym4KO659Bhyd', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
  513. (7, '47Szs8IM182gOZq', 'Server Admin', 'Purchased at Ammunation', '1', 'Knife', 'https://cfx-nui-qb-inventory/html/images/weapon_knife.png'),
  514. (8, '77bOu7dN572XvAT', 'Server Admin', 'Purchased at Ammunation', '1', 'Bat', 'https://cfx-nui-qb-inventory/html/images/weapon_bat.png'),
  515. (9, '21fAS9NG825mfei', 'Server Admin', 'Purchased at Ammunation', '1', 'Hatchet', 'https://cfx-nui-qb-inventory/html/images/weapon_hatchet.png');
  516.  
  517. -- --------------------------------------------------------
  518.  
  519. --
  520. -- Table structure for table `multijobs`
  521. --
  522.  
  523. CREATE TABLE `multijobs` (
  524.   `citizenid` VARCHAR(100) NOT NULL,
  525.   `jobdata` text DEFAULT NULL
  526. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
  527.  
  528. --
  529. -- Dumping data for table `multijobs`
  530. --
  531.  
  532. INSERT INTO `multijobs` (`citizenid`, `jobdata`) VALUES
  533. ('SSL19978', '{\"mechanic\":4,\"police\":4,\"tow\":0,\"realestate\":1}');
  534.  
  535. -- --------------------------------------------------------
  536.  
  537. --
  538. -- Table structure for table `occasion_vehicles`
  539. --
  540.  
  541. CREATE TABLE `occasion_vehicles` (
  542.   `id` INT(11) NOT NULL,
  543.   `seller` VARCHAR(50) DEFAULT NULL,
  544.   `price` INT(11) DEFAULT NULL,
  545.   `description` longtext DEFAULT NULL,
  546.   `plate` VARCHAR(50) DEFAULT NULL,
  547.   `model` VARCHAR(50) DEFAULT NULL,
  548.   `mods` text DEFAULT NULL,
  549.   `occasionid` VARCHAR(50) DEFAULT NULL
  550. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  551.  
  552. -- --------------------------------------------------------
  553.  
  554. --
  555. -- Table structure for table `pefcl_accounts`
  556. --
  557.  
  558. CREATE TABLE `pefcl_accounts` (
  559.   `id` INT(11) NOT NULL,
  560.   `number` VARCHAR(255) DEFAULT NULL,
  561.   `accountName` VARCHAR(255) DEFAULT NULL,
  562.   `isDefault` tinyint(1) DEFAULT 0,
  563.   `ownerIdentifier` VARCHAR(255) DEFAULT NULL,
  564.   `role` VARCHAR(255) DEFAULT 'owner',
  565.   `balance` INT(11) DEFAULT 25000,
  566.   `type` VARCHAR(255) DEFAULT 'personal',
  567.   `createdAt` datetime NOT NULL,
  568.   `updatedAt` datetime NOT NULL,
  569.   `deletedAt` datetime DEFAULT NULL
  570. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  571.  
  572. -- --------------------------------------------------------
  573.  
  574. --
  575. -- Table structure for table `pefcl_cash`
  576. --
  577.  
  578. CREATE TABLE `pefcl_cash` (
  579.   `id` INT(11) NOT NULL,
  580.   `amount` INT(11) DEFAULT 2000,
  581.   `ownerIdentifier` VARCHAR(255) DEFAULT NULL,
  582.   `createdAt` datetime NOT NULL,
  583.   `updatedAt` datetime NOT NULL
  584. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  585.  
  586. -- --------------------------------------------------------
  587.  
  588. --
  589. -- Table structure for table `pefcl_external_accounts`
  590. --
  591.  
  592. CREATE TABLE `pefcl_external_accounts` (
  593.   `id` INT(11) NOT NULL,
  594.   `number` VARCHAR(255) DEFAULT NULL,
  595.   `name` VARCHAR(255) DEFAULT NULL,
  596.   `userId` VARCHAR(255) DEFAULT NULL,
  597.   `createdAt` datetime NOT NULL,
  598.   `updatedAt` datetime NOT NULL
  599. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  600.  
  601. -- --------------------------------------------------------
  602.  
  603. --
  604. -- Table structure for table `pefcl_invoices`
  605. --
  606.  
  607. CREATE TABLE `pefcl_invoices` (
  608.   `id` INT(11) NOT NULL,
  609.   `message` VARCHAR(255) NOT NULL,
  610.   `from` VARCHAR(255) NOT NULL,
  611.   `to` VARCHAR(255) NOT NULL,
  612.   `fromIdentifier` VARCHAR(255) NOT NULL,
  613.   `toIdentifier` VARCHAR(255) NOT NULL,
  614.   `receiverAccountIdentifier` VARCHAR(255) DEFAULT NULL,
  615.   `amount` INT(11) DEFAULT 0,
  616.   `status` VARCHAR(255) DEFAULT 'PENDING',
  617.   `expiresAt` datetime NOT NULL,
  618.   `createdAt` datetime NOT NULL,
  619.   `updatedAt` datetime NOT NULL
  620. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  621.  
  622. -- --------------------------------------------------------
  623.  
  624. --
  625. -- Table structure for table `pefcl_shared_accounts`
  626. --
  627.  
  628. CREATE TABLE `pefcl_shared_accounts` (
  629.   `id` INT(11) NOT NULL,
  630.   `userIdentifier` VARCHAR(255) DEFAULT NULL,
  631.   `name` VARCHAR(255) DEFAULT NULL,
  632.   `role` VARCHAR(255) DEFAULT 'contributor',
  633.   `createdAt` datetime NOT NULL,
  634.   `updatedAt` datetime NOT NULL,
  635.   `deletedAt` datetime DEFAULT NULL,
  636.   `accountId` INT(11) DEFAULT NULL
  637. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  638.  
  639. -- --------------------------------------------------------
  640.  
  641. --
  642. -- Table structure for table `pefcl_transactions`
  643. --
  644.  
  645. CREATE TABLE `pefcl_transactions` (
  646.   `id` INT(11) NOT NULL,
  647.   `message` VARCHAR(255) DEFAULT NULL,
  648.   `amount` INT(11) DEFAULT 0,
  649.   `type` VARCHAR(255) DEFAULT 'Outgoing',
  650.   `createdAt` datetime NOT NULL,
  651.   `updatedAt` datetime NOT NULL,
  652.   `toAccountId` INT(11) DEFAULT NULL,
  653.   `fromAccountId` INT(11) DEFAULT NULL
  654. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  655.  
  656. -- --------------------------------------------------------
  657.  
  658. --
  659. -- Table structure for table `phone_gallery`
  660. --
  661.  
  662. CREATE TABLE `phone_gallery` (
  663.   `citizenid` VARCHAR(11) NOT NULL,
  664.   `image` VARCHAR(255) NOT NULL,
  665.   `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP()
  666. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  667.  
  668. -- --------------------------------------------------------
  669.  
  670. --
  671. -- Table structure for table `phone_invoices`
  672. --
  673.  
  674. CREATE TABLE `phone_invoices` (
  675.   `id` INT(10) NOT NULL,
  676.   `citizenid` VARCHAR(11) DEFAULT NULL,
  677.   `amount` INT(11) NOT NULL DEFAULT 0,
  678.   `society` tinytext DEFAULT NULL,
  679.   `sender` VARCHAR(50) DEFAULT NULL,
  680.   `sendercitizenid` VARCHAR(50) DEFAULT NULL
  681. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  682.  
  683. -- --------------------------------------------------------
  684.  
  685. --
  686. -- Table structure for table `phone_messages`
  687. --
  688.  
  689. CREATE TABLE `phone_messages` (
  690.   `id` INT(11) NOT NULL,
  691.   `citizenid` VARCHAR(11) DEFAULT NULL,
  692.   `number` VARCHAR(50) DEFAULT NULL,
  693.   `messages` text DEFAULT NULL
  694. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  695.  
  696. -- --------------------------------------------------------
  697.  
  698. --
  699. -- Table structure for table `phone_tweets`
  700. --
  701.  
  702. CREATE TABLE `phone_tweets` (
  703.   `id` INT(11) NOT NULL,
  704.   `citizenid` VARCHAR(11) DEFAULT NULL,
  705.   `firstName` VARCHAR(25) DEFAULT NULL,
  706.   `lastName` VARCHAR(25) DEFAULT NULL,
  707.   `message` text DEFAULT NULL,
  708.   `date` datetime DEFAULT CURRENT_TIMESTAMP(),
  709.   `url` text DEFAULT NULL,
  710.   `picture` VARCHAR(512) DEFAULT './img/default.png',
  711.   `tweetId` VARCHAR(25) NOT NULL
  712. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  713.  
  714. --
  715. -- Dumping data for table `phone_tweets`
  716. --
  717.  
  718. INSERT INTO `phone_tweets` (`id`, `citizenid`, `firstName`, `lastName`, `message`, `date`, `url`, `picture`, `tweetId`) VALUES
  719. (1, 'BYV87342', 'Sparky', 'King', 'hello', '2024-04-08 01:21:29', '', 'default', 'TWEET-96019152'),
  720. (2, 'UFQ88534', 'Devin', 'King', 'Hey', '2024-04-11 13:22:07', '', 'default', 'TWEET-19905322'),
  721. (3, 'SSL19978', 'Server', 'Admin', 'hello', '2024-04-21 03:20:43', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-30944245'),
  722. (4, 'SSL19978', 'Server', 'Admin', 'hey', '2024-04-21 22:08:09', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-30848675'),
  723. (5, 'SSL19978', 'Server', 'Admin', 'Hello #losSantos', '2024-04-26 18:41:33', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-11214906');
  724.  
  725. -- --------------------------------------------------------
  726.  
  727. --
  728. -- Table structure for table `players`
  729. --
  730.  
  731. CREATE TABLE `players` (
  732.   `id` INT(11) NOT NULL,
  733.   `citizenid` VARCHAR(50) NOT NULL,
  734.   `cid` INT(11) DEFAULT NULL,
  735.   `license` VARCHAR(255) NOT NULL,
  736.   `name` VARCHAR(255) NOT NULL,
  737.   `money` text NOT NULL,
  738.   `charinfo` text DEFAULT NULL,
  739.   `job` text NOT NULL,
  740.   `gang` text DEFAULT NULL,
  741.   `position` text NOT NULL,
  742.   `metadata` text NOT NULL,
  743.   `inventory` longtext DEFAULT NULL,
  744.   `last_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
  745. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  746.  
  747. --
  748. -- Dumping data for table `players`
  749. --
  750.  
  751. INSERT INTO `players` (`id`, `citizenid`, `cid`, `license`, `name`, `money`, `charinfo`, `job`, `gang`, `position`, `metadata`, `inventory`, `last_updated`) VALUES
  752. (1, 'BYV87342', 1, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"crypto\":0,\"cash\":5447,\"bank\":2445}', '{\"nationality\":\"Canada\",\"cid\":1,\"firstname\":\"Sparky\",\"phone\":\"1628475836\",\"account\":\"US07QBCore3715874485\",\"birthdate\":\"1994-06-08\",\"lastname\":\"King\",\"gender\":0,\"backstory\":\"placeholder backstory\"}', '{\"type\":\"lawyer\",\"grade\":{\"name\":\"Surgeon\",\"level\":3},\"isboss\":false,\"name\":\"lawyer\",\"payment\":125,\"onduty\":true,\"label\":\"Law Firm\"}', '{\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"name\":\"none\",\"level\":0},\"isboss\":false}', '{\"x\":2383.489990234375,\"y\":3079.74072265625,\"z\":48.151611328125}', '{\"isdead\":false,\"thirst\":35.40000000000005,\"fitbit\":[],\"tracker\":false,\"walletid\":\"QB-39171774\",\"injail\":0,\"cardeliveryxp\":0,\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":23617045},\"status\":[],\"licences\":{\"driver\":true,\"weapon\":false,\"business\":false},\"callsign\":\"K10\",\"hunger\":28.59999999999994,\"fingerprint\":\"sU530E20PgQ1216\",\"bloodtype\":\"A-\",\"inlaststand\":false,\"criminalrecord\":{\"hasRecord\":false},\"ishandcuffed\":false,\"craftingrep\":0,\"armor\":0,\"phone\":[],\"attachmentcraftingrep\":0,\"jobrep\":{\"hotdog\":0,\"taxi\":0,\"trucker\":0,\"tow\":0},\"jailitems\":[],\"dealerrep\":0,\"inside\":{\"apartment\":[]},\"stress\":21}', '[{\"info\":{\"gender\":0,\"citizenid\":\"BYV87342\",\"birthdate\":\"1994-06-08\",\"firstname\":\"Sparky\",\"lastname\":\"King\",\"nationality\":\"Canada\"},\"type\":\"item\",\"name\":\"id_card\",\"slot\":1,\"amount\":1},{\"info\":{\"birthdate\":\"1994-06-08\",\"firstname\":\"Sparky\",\"lastname\":\"King\",\"type\":\"Class C Driver License\"},\"type\":\"item\",\"name\":\"driver_license\",\"slot\":2,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"phone\",\"slot\":3,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"lockpick\",\"slot\":4,\"amount\":79},{\"info\":[],\"type\":\"item\",\"name\":\"casino_member\",\"slot\":5,\"amount\":1},{\"info\":{\"quality\":100,\"ammo\":0,\"serie\":\"73EsD6OC139ABGP\"},\"type\":\"weapon\",\"name\":\"weapon_bullpupshotgun\",\"slot\":6,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"casino_vip\",\"slot\":7,\"amount\":1}]', '2024-04-22 20:42:56'),
  753. (488, 'SSL19978', 3, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"crypto\":0,\"cash\":2039,\"bank\":40155}', '{\"birthdate\":\"1994-06-08\",\"phone\":\"2421790572\",\"gender\":0,\"account\":\"US01QBCore4598166048\",\"isNew\":true,\"lastname\":\"Admin\",\"firstname\":\"Server\",\"backstory\":\"placeholder backstory\",\"cid\":\"3\",\"nationality\":\"Canada\"}', '{\"label\":\"Law Enforcement\",\"grade\":{\"name\":\"Chief\",\"level\":4},\"payment\":150,\"name\":\"police\",\"isboss\":true,\"type\":\"leo\",\"onduty\":true}', '{\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"name\":\"none\",\"level\":0},\"isboss\":false}', '{\"x\":1153.74072265625,\"y\":-326.80877685546877,\"z\":69.197021484375}', '{\"hunger\":94.59999999999997,\"inlaststand\":false,\"phone\":{\"profilepicture\":\"https://kappa.lol/Ss3-t.2024-04-20-1713656574.png\"},\"licences\":{\"business\":false,\"driver\":true,\"weapon\":false},\"isdead\":false,\"injail\":0,\"bloodtype\":\"AB-\",\"callsign\":\"K-11\",\"jobrep\":{\"tow\":0,\"hotdog\":0,\"trucker\":0,\"taxi\":0},\"dealerrep\":0,\"phonedata\":{\"SerialNumber\":63889063,\"InstalledApps\":[]},\"fitbit\":[],\"criminalrecord\":{\"hasRecord\":false},\"tracker\":false,\"craftingrep\":0,\"jailitems\":[],\"stress\":0,\"ishandcuffed\":false,\"walletid\":\"QB-71842115\",\"armor\":0,\"inside\":{\"apartment\":[]},\"thirst\":54.40000000000003,\"attachmentcraftingrep\":0,\"status\":[],\"fingerprint\":\"PC245c42lmN9759\"}', '[{\"amount\":1,\"type\":\"item\",\"slot\":1,\"name\":\"phone\",\"info\":[]},{\"amount\":1,\"type\":\"item\",\"slot\":2,\"name\":\"id_card\",\"info\":{\"citizenid\":\"SSL19978\",\"firstname\":\"Server\",\"nationality\":\"Canada\",\"lastname\":\"Admin\",\"gender\":0,\"birthdate\":\"1994-06-08\"}},{\"amount\":1,\"created\":1713736717,\"type\":\"item\",\"slot\":3,\"name\":\"driver_license\",\"info\":{\"firstname\":\"Server\",\"quality\":100,\"lastname\":\"Admin\",\"birthdate\":\"1994-06-08\",\"type\":\"Class C Driver License\"}},{\"amount\":2,\"created\":1714155290,\"type\":\"item\",\"slot\":4,\"name\":\"lockpick\",\"info\":{\"quality\":100}},{\"amount\":1,\"created\":1713995356,\"type\":\"weapon\",\"slot\":6,\"name\":\"weapon_knife\",\"info\":{\"serie\":\"47Szs8IM182gOZq\",\"quality\":100}},{\"amount\":1,\"created\":1713995360,\"type\":\"weapon\",\"slot\":7,\"name\":\"weapon_bat\",\"info\":{\"serie\":\"77bOu7dN572XvAT\",\"quality\":100}},{\"amount\":1,\"created\":1713995362,\"type\":\"weapon\",\"slot\":8,\"name\":\"weapon_hatchet\",\"info\":{\"serie\":\"21fAS9NG825mfei\",\"quality\":100}}]', '2024-04-26 20:22:39'),
  754. (33, 'UFQ88534', 2, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"cash\":0,\"crypto\":0,\"bank\":5706}', '{\"gender\":0,\"nationality\":\"Canada\",\"phone\":\"7196594927\",\"account\":\"US07QBCore8090813475\",\"backstory\":\"placeholder backstory\",\"cid\":2,\"birthdate\":\"1994-06-08\",\"firstname\":\"Devin\",\"lastname\":\"King\"}', '{\"onduty\":true,\"isboss\":false,\"grade\":{\"name\":\"Journalist\",\"level\":0},\"name\":\"reporter\",\"payment\":50,\"label\":\"Reporter\",\"type\":\"none\"}', '{\"name\":\"blackhand\",\"grade\":{\"name\":\"Grandmaster\",\"level\":3},\"label\":\"The Black Hand\",\"isboss\":true}', '{\"x\":1299.6263427734376,\"y\":-1708.0087890625,\"z\":55.076904296875}', '{\"ishandcuffed\":false,\"thirst\":92.4,\"phone\":[],\"craftingrep\":0,\"injail\":0,\"callsign\":\"NO CALLSIGN\",\"criminalrecord\":{\"hasRecord\":false},\"status\":[],\"cardeliveryxp\":0,\"inside\":{\"apartment\":[]},\"jailitems\":[],\"fitbit\":[],\"dealerrep\":0,\"tracker\":false,\"stress\":4,\"hunger\":91.6,\"isdead\":false,\"licences\":{\"business\":false,\"driver\":true,\"weapon\":false},\"walletid\":\"QB-85515212\",\"armor\":0,\"inlaststand\":false,\"fingerprint\":\"nH614F83OKz6032\",\"bloodtype\":\"B-\",\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":55262045},\"jobrep\":{\"hotdog\":0,\"taxi\":0,\"tow\":0,\"trucker\":0},\"attachmentcraftingrep\":0}', '[{\"info\":[],\"type\":\"item\",\"amount\":1,\"slot\":1,\"name\":\"phone\"},{\"info\":{\"firstname\":\"Devin\",\"type\":\"Class C Driver License\",\"lastname\":\"King\",\"birthdate\":\"1994-06-08\"},\"type\":\"item\",\"amount\":1,\"slot\":2,\"name\":\"driver_license\"},{\"info\":{\"nationality\":\"Canada\",\"gender\":0,\"firstname\":\"Devin\",\"lastname\":\"King\",\"citizenid\":\"UFQ88534\",\"birthdate\":\"1994-06-08\"},\"type\":\"item\",\"amount\":1,\"slot\":3,\"name\":\"id_card\"},{\"info\":[],\"type\":\"item\",\"amount\":1,\"slot\":4,\"name\":\"tunerlaptop\"}]', '2024-04-11 13:31:34'),
  755. (429, 'UGE35348', 1, 'license:7c6d790889bab7b0a0b8f4e4c1d81dbfe9516f90', 'TFEARZONE', '{\"cash\":500,\"bank\":4660,\"crypto\":0}', '{\"firstname\":\"Michael\",\"birthdate\":\"1989-09-25\",\"gender\":0,\"lastname\":\"Anderson\",\"backstory\":\"placeholder backstory\",\"nationality\":\"British\",\"cid\":\"1\",\"account\":\"US09QBCore8214428943\",\"isNew\":true,\"phone\":\"9875848111\"}', '{\"onduty\":true,\"isboss\":false,\"label\":\"Towing\",\"payment\":50,\"name\":\"tow\",\"grade\":{\"level\":0,\"name\":\"Driver\"},\"type\":\"none\"}', '{\"isboss\":false,\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"level\":0,\"name\":\"none\"}}', '{\"x\":-40.36483383178711,\"y\":-1097.116455078125,\"z\":26.4154052734375}', '{\"armor\":0,\"inlaststand\":false,\"fitbit\":[],\"isdead\":false,\"walletid\":\"QB-95796597\",\"callsign\":\"NO CALLSIGN\",\"jailitems\":[],\"stress\":0,\"jobrep\":{\"trucker\":0,\"tow\":0,\"hotdog\":0,\"taxi\":0},\"phone\":[],\"status\":[],\"licences\":{\"driver\":true,\"weapon\":false,\"business\":false},\"craftingrep\":0,\"attachmentcraftingrep\":0,\"hunger\":36.99999999999996,\"injail\":0,\"criminalrecord\":{\"hasRecord\":false},\"bloodtype\":\"A-\",\"thirst\":43.00000000000004,\"ishandcuffed\":false,\"tracker\":false,\"fingerprint\":\"Hi897Q67ZXd0403\",\"inside\":{\"apartment\":[]},\"dealerrep\":0,\"phonedata\":{\"SerialNumber\":16899837,\"InstalledApps\":[]}}', '[{\"slot\":39,\"name\":\"id_card\",\"info\":{\"lastname\":\"Anderson\",\"birthdate\":\"1989-09-25\",\"nationality\":\"British\",\"citizenid\":\"UGE35348\",\"gender\":0,\"firstname\":\"Michael\"},\"type\":\"item\",\"amount\":1},{\"slot\":40,\"name\":\"phone\",\"info\":[],\"type\":\"item\",\"amount\":1},{\"slot\":38,\"name\":\"driver_license\",\"info\":{\"type\":\"Class C Driver License\",\"birthdate\":\"1989-09-25\",\"lastname\":\"Anderson\",\"firstname\":\"Michael\"},\"type\":\"item\",\"amount\":1}]', '2024-04-20 19:41:59');
  756.  
  757. -- --------------------------------------------------------
  758.  
  759. --
  760. -- Table structure for table `playerskins`
  761. --
  762.  
  763. CREATE TABLE `playerskins` (
  764.   `id` INT(11) NOT NULL,
  765.   `citizenid` VARCHAR(11) NOT NULL,
  766.   `model` VARCHAR(255) NOT NULL,
  767.   `skin` text NOT NULL,
  768.   `active` tinyint(4) NOT NULL DEFAULT 1
  769. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  770.  
  771. --
  772. -- Dumping data for table `playerskins`
  773. --
  774.  
  775. INSERT INTO `playerskins` (`id`, `citizenid`, `model`, `skin`, `active`) VALUES
  776. (4, 'UFQ88534', '1885233650', '{\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"mask\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eyebrows\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"pants\":{\"defaultItem\":0,\"texture\":0,\"item\":1,\"defaultTexture\":0},\"facemix\":{\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"defaultShapeMix\":0.0},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"hair\":{\"defaultItem\":0,\"texture\":7,\"item\":20,\"defaultTexture\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"item\":86,\"defaultTexture\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"item\":4,\"defaultTexture\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"item\":25,\"defaultTexture\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"bag\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"decals\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"item\":1,\"defaultTexture\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0}}', 1),
  777. (5, 'BYV87342', '1885233650', '{\"nose_2\":{\"texture\":0,\"defaultItem\":0,\"item\":1,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"nose_1\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"shoes\":{\"texture\":0,\"defaultItem\":1,\"item\":81,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"torso2\":{\"texture\":0,\"defaultItem\":0,\"item\":413,\"defaultTexture\":0},\"face\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"mask\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"watch\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"bag\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"facemix\":{\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0,\"shapeMix\":0},\"face2\":{\"texture\":0,\"defaultItem\":0,\"item\":1,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"nose_0\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"defaultItem\":0,\"item\":50,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"eyebrows\":{\"texture\":4,\"defaultItem\":-1,\"item\":9,\"defaultTexture\":1},\"chimp_hole\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"arms\":{\"texture\":0,\"defaultItem\":0,\"item\":6,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"hair\":{\"texture\":6,\"defaultItem\":0,\"item\":18,\"defaultTexture\":0},\"eyebrown_high\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"defaultItem\":-1,\"item\":8,\"defaultTexture\":0},\"t-shirt\":{\"texture\":0,\"defaultItem\":1,\"item\":15,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"defaultItem\":0,\"item\":7,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"cheek_2\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0}}', 1),
  778. (8, 'UGE35348', '1885233650', '{\"accessory\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"t-shirt\":{\"defaultTexture\":0,\"item\":72,\"defaultItem\":1,\"texture\":4},\"nose_5\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_1\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"hair\":{\"defaultTexture\":0,\"item\":19,\"defaultItem\":0,\"texture\":20},\"torso2\":{\"defaultTexture\":0,\"item\":6,\"defaultItem\":0,\"texture\":11},\"face\":{\"defaultTexture\":0,\"item\":43,\"defaultItem\":0,\"texture\":0},\"arms\":{\"defaultTexture\":0,\"item\":179,\"defaultItem\":0,\"texture\":5},\"nose_1\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"nose_2\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_2\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"neck_thikness\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"eye_color\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"chimp_bone_width\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"lipstick\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"bracelet\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"pants\":{\"defaultTexture\":0,\"item\":76,\"defaultItem\":0,\"texture\":5},\"decals\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_bone_lenght\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"ageing\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eye_opening\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"lips_thickness\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"moles\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eyebrown_high\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"jaw_bone_width\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"eyebrown_forward\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_3\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"hat\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eyebrows\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"nose_3\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"nose_0\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_hole\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"beard\":{\"defaultTexture\":1,\"item\":10,\"defaultItem\":-1,\"texture\":2},\"mask\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_bone_lowering\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"shoes\":{\"defaultTexture\":0,\"item\":71,\"defaultItem\":1,\"texture\":1},\"watch\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"bag\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"makeup\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"glass\":{\"defaultTexture\":0,\"item\":15,\"defaultItem\":0,\"texture\":9},\"face2\":{\"defaultTexture\":0,\"item\":42,\"defaultItem\":0,\"texture\":0},\"nose_4\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"facemix\":{\"shapeMix\":0.68,\"skinMix\":0.48,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"ear\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"blush\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"jaw_bone_back_lenght\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"vest\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0}}', 1),
  779. (12, 'SSL19978', '1885233650', '{\"neck_thikness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_0\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"arms\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":20},\"accessory\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eyebrown_forward\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hat\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"bracelet\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":1},\"nose_4\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"beard\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"shoes\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":51},\"lipstick\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"nose_5\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"facemix\":{\"defaultSkinMix\":0.0,\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0},\"moles\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eyebrown_high\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"lips_thickness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eye_color\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"ageing\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"chimp_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"watch\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"makeup\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"cheek_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"bag\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"decals\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"t-shirt\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"face\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hair\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":9,\"item\":10},\"pants\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":24},\"chimp_bone_lowering\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eye_opening\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"nose_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":3,\"item\":317},\"mask\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eyebrows\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1}}', 1);
  780.  
  781. -- --------------------------------------------------------
  782.  
  783. --
  784. -- Table structure for table `player_contacts`
  785. --
  786.  
  787. CREATE TABLE `player_contacts` (
  788.   `id` INT(11) NOT NULL,
  789.   `citizenid` VARCHAR(11) DEFAULT NULL,
  790.   `name` VARCHAR(50) DEFAULT NULL,
  791.   `number` VARCHAR(50) DEFAULT NULL,
  792.   `iban` VARCHAR(50) NOT NULL DEFAULT '0'
  793. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  794.  
  795. -- --------------------------------------------------------
  796.  
  797. --
  798. -- Table structure for table `player_houses`
  799. --
  800.  
  801. CREATE TABLE `player_houses` (
  802.   `id` INT(255) NOT NULL,
  803.   `house` VARCHAR(50) NOT NULL,
  804.   `identifier` VARCHAR(50) DEFAULT NULL,
  805.   `citizenid` VARCHAR(11) DEFAULT NULL,
  806.   `keyholders` text DEFAULT NULL,
  807.   `decorations` text DEFAULT NULL,
  808.   `stash` text DEFAULT NULL,
  809.   `outfit` text DEFAULT NULL,
  810.   `logout` text DEFAULT NULL
  811. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  812.  
  813. -- --------------------------------------------------------
  814.  
  815. --
  816. -- Table structure for table `player_mails`
  817. --
  818.  
  819. CREATE TABLE `player_mails` (
  820.   `id` INT(11) NOT NULL,
  821.   `citizenid` VARCHAR(11) DEFAULT NULL,
  822.   `sender` VARCHAR(50) DEFAULT NULL,
  823.   `subject` VARCHAR(50) DEFAULT NULL,
  824.   `message` text DEFAULT NULL,
  825.   `read` tinyint(4) DEFAULT 0,
  826.   `mailid` INT(11) DEFAULT NULL,
  827.   `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP(),
  828.   `button` text DEFAULT NULL
  829. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  830.  
  831. --
  832. -- Dumping data for table `player_mails`
  833. --
  834.  
  835. INSERT INTO `player_mails` (`id`, `citizenid`, `sender`, `subject`, `message`, `read`, `mailid`, `date`, `button`) VALUES
  836. (1, 'DJD56142', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 756400, '2024-04-08 03:29:34', '[]'),
  837. (2, 'DXT09752', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 760214, '2024-04-08 03:29:34', '[]'),
  838. (3, 'SRI85140', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 311054, '2024-04-08 03:29:34', '[]'),
  839. (9, 'DJD56142', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 752068, '2024-04-24 21:51:09', '[]'),
  840. (10, 'DXT09752', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 731652, '2024-04-24 21:51:09', '[]'),
  841. (11, 'SRI85140', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 713018, '2024-04-24 21:51:09', '[]');
  842.  
  843. -- --------------------------------------------------------
  844.  
  845. --
  846. -- Table structure for table `player_outfits`
  847. --
  848.  
  849. CREATE TABLE `player_outfits` (
  850.   `id` INT(11) NOT NULL,
  851.   `citizenid` VARCHAR(11) DEFAULT NULL,
  852.   `outfitname` VARCHAR(50) NOT NULL,
  853.   `model` VARCHAR(50) DEFAULT NULL,
  854.   `skin` text DEFAULT NULL,
  855.   `outfitId` VARCHAR(50) NOT NULL
  856. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  857.  
  858. --
  859. -- Dumping data for table `player_outfits`
  860. --
  861.  
  862. INSERT INTO `player_outfits` (`id`, `citizenid`, `outfitname`, `model`, `skin`, `outfitId`) VALUES
  863. (1, 'BYV87342', 'Sparky', '1885233650', '{\"t-shirt\":{\"defaultTexture\":0,\"item\":15,\"texture\":0,\"defaultItem\":1},\"moles\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"cheek_3\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eyebrows\":{\"defaultTexture\":1,\"item\":9,\"texture\":4,\"defaultItem\":-1},\"watch\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"ageing\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"nose_3\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_1\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"cheek_1\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_high\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lenght\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"makeup\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"eyebrown_forward\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"bracelet\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"chimp_bone_width\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_0\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"torso2\":{\"defaultTexture\":0,\"item\":413,\"texture\":0,\"defaultItem\":0},\"face2\":{\"defaultTexture\":0,\"item\":1,\"texture\":0,\"defaultItem\":0},\"shoes\":{\"defaultTexture\":0,\"item\":81,\"texture\":0,\"defaultItem\":1},\"nose_2\":{\"defaultTexture\":0,\"item\":1,\"texture\":0,\"defaultItem\":0},\"vest\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"jaw_bone_width\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"beard\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"accessory\":{\"defaultTexture\":0,\"item\":50,\"texture\":0,\"defaultItem\":0},\"hat\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"nose_4\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"pants\":{\"defaultTexture\":0,\"item\":7,\"texture\":0,\"defaultItem\":0},\"jaw_bone_back_lenght\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"decals\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_5\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_hole\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"neck_thikness\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lowering\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"bag\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eye_opening\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"lips_thickness\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"hair\":{\"defaultTexture\":0,\"item\":18,\"texture\":6,\"defaultItem\":0},\"mask\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"face\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"ear\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"lipstick\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"glass\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"arms\":{\"defaultTexture\":0,\"item\":6,\"texture\":0,\"defaultItem\":0},\"eye_color\":{\"defaultTexture\":0,\"item\":8,\"texture\":0,\"defaultItem\":-1},\"cheek_2\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"blush\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1}}', 'outfit-6-6238'),
  864. (2, 'UFQ88534', 'Daven  King', '1885233650', '{\"nose_3\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_hole\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"blush\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"shoes\":{\"item\":25,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":1},\"cheek_1\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"t-shirt\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":1},\"decals\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"lipstick\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"beard\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"moles\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"nose_1\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lowering\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"ear\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"cheek_2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrows\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"vest\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eye_color\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"mask\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"ageing\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"neck_thikness\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"nose_4\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_forward\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"arms\":{\"item\":4,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"bag\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"pants\":{\"item\":1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"jaw_bone_width\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"glass\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_high\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"hat\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"eye_opening\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"hair\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"makeup\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"nose_2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"facemix\":{\"defaultShapeMix\":0.0,\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0},\"nose_5\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_width\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"nose_0\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"bracelet\":{\"item\":1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"face2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"watch\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"jaw_bone_back_lenght\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lenght\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"torso2\":{\"item\":86,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"cheek_3\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"accessory\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"lips_thickness\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"face\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0}}', 'outfit-10-9340'),
  865. (3, 'UFQ88534', 'Devin King', '1885233650', '{\"hair\":{\"defaultItem\":0,\"texture\":7,\"defaultTexture\":0,\"item\":20},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"facemix\":{\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0,\"shapeMix\":0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":4},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"decals\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"mask\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"bag\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":86},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrows\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":25},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"pants\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1}}', 'outfit-9-6712'),
  866. (4, 'BYV87342', 'Sparky', '1885233650', '{\"hair\":{\"defaultItem\":0,\"texture\":6,\"defaultTexture\":0,\"item\":18},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"facemix\":{\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"defaultShapeMix\":0.0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":6},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"decals\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"mask\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":15},\"bag\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":413},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":50},\"eyebrows\":{\"defaultItem\":-1,\"texture\":4,\"defaultTexture\":1,\"item\":9},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":8},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":81},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"pants\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0}}', 'outfit-2-6982'),
  867. (5, 'SSL19978', 'Server Admin', '1885233650', '{\"eye_opening\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"pants\":{\"defaultItem\":0,\"item\":71,\"texture\":0,\"defaultTexture\":0},\"arms\":{\"defaultItem\":0,\"item\":18,\"texture\":0,\"defaultTexture\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_3\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"lipstick\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"beard\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"glass\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"bag\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"mask\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"watch\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"hair\":{\"defaultItem\":0,\"item\":10,\"texture\":9,\"defaultTexture\":0},\"eyebrows\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"eye_color\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"nose_1\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"face\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"bracelet\":{\"defaultItem\":-1,\"item\":1,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"facemix\":{\"defaultSkinMix\":0.0,\"shapeMix\":0,\"defaultShapeMix\":0.0,\"skinMix\":0},\"hat\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"moles\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"eyebrown_high\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_hole\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_5\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"ageing\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"nose_4\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"neck_thikness\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"ear\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"decals\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_0\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"lips_thickness\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"t-shirt\":{\"defaultItem\":1,\"item\":10,\"texture\":2,\"defaultTexture\":0},\"shoes\":{\"defaultItem\":1,\"item\":1,\"texture\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_1\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"vest\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"makeup\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"accessory\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"blush\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"torso2\":{\"defaultItem\":0,\"item\":118,\"texture\":0,\"defaultTexture\":0},\"nose_2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"face2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_3\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0}}', 'outfit-10-6454'),
  868. (6, 'SSL19978', 'Cop', '1885233650', '{\"decals\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"neck_thikness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_0\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hair\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":9,\"item\":10},\"cheek_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eyebrown_high\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"watch\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"face2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"beard\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"arms\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":20},\"torso2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":8,\"item\":317},\"face\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"facemix\":{\"defaultShapeMix\":0.0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"skinMix\":0},\"hat\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":3,\"item\":58},\"bracelet\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":1},\"chimp_bone_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"moles\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"nose_4\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"glass\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"t-shirt\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"chimp_bone_lowering\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":51},\"eye_color\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"bag\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"mask\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"pants\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":24},\"lipstick\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"lips_thickness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_5\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"eyebrows\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1}}', 'outfit-7-5491'),
  869. (7, 'SSL19978', 'Server Admin', '1885233650', '{\"eyebrown_high\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_hole\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"item\":1,\"defaultItem\":-1,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"mask\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"torso2\":{\"texture\":0,\"item\":118,\"defaultItem\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"bag\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"t-shirt\":{\"texture\":2,\"item\":10,\"defaultItem\":1,\"defaultTexture\":0},\"face\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"nose_0\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"watch\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"item\":71,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrows\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"face2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"arms\":{\"texture\":0,\"item\":18,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"shoes\":{\"texture\":0,\"item\":1,\"defaultItem\":1,\"defaultTexture\":0},\"hair\":{\"texture\":9,\"item\":10,\"defaultItem\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0}}', 'outfit-6-4127'),
  870. (8, 'SSL19978', 'Server Cop', '1885233650', '{\"eyebrown_high\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"arms\":{\"texture\":0,\"item\":20,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_hole\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"item\":1,\"defaultItem\":-1,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"shoes\":{\"texture\":0,\"item\":51,\"defaultItem\":1,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"torso2\":{\"texture\":3,\"item\":317,\"defaultItem\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"bag\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"t-shirt\":{\"texture\":0,\"item\":58,\"defaultItem\":1,\"defaultTexture\":0},\"face\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"watch\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"nose_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"item\":24,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrows\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"face2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_0\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"item\":58,\"defaultItem\":-1,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"mask\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hair\":{\"texture\":9,\"item\":10,\"defaultItem\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0}}', 'outfit-9-8508');
  871.  
  872. -- --------------------------------------------------------
  873.  
  874. --
  875. -- Table structure for table `player_vehicles`
  876. --
  877.  
  878. CREATE TABLE `player_vehicles` (
  879.   `id` INT(11) NOT NULL,
  880.   `license` VARCHAR(50) DEFAULT NULL,
  881.   `citizenid` VARCHAR(50) DEFAULT NULL,
  882.   `vehicle` VARCHAR(50) DEFAULT NULL,
  883.   `hash` VARCHAR(50) DEFAULT NULL,
  884.   `mods` longtext DEFAULT NULL,
  885.   `plate` VARCHAR(50) NOT NULL,
  886.   `fakeplate` VARCHAR(50) DEFAULT NULL,
  887.   `garage` VARCHAR(50) DEFAULT NULL,
  888.   `fuel` INT(11) DEFAULT 100,
  889.   `engine` FLOAT DEFAULT 1000,
  890.   `body` FLOAT DEFAULT 1000,
  891.   `state` INT(11) DEFAULT 1,
  892.   `depotprice` INT(11) NOT NULL DEFAULT 0,
  893.   `drivingdistance` INT(50) DEFAULT NULL,
  894.   `status` text DEFAULT NULL,
  895.   `balance` INT(11) NOT NULL DEFAULT 0,
  896.   `paymentamount` INT(11) NOT NULL DEFAULT 0,
  897.   `paymentsleft` INT(11) NOT NULL DEFAULT 0,
  898.   `financetime` INT(11) NOT NULL DEFAULT 0
  899. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  900.  
  901. --
  902. -- Dumping data for table `player_vehicles`
  903. --
  904.  
  905. INSERT INTO `player_vehicles` (`id`, `license`, `citizenid`, `vehicle`, `hash`, `mods`, `plate`, `fakeplate`, `garage`, `fuel`, `engine`, `body`, `state`, `depotprice`, `drivingdistance`, `status`, `balance`, `paymentamount`, `paymentsleft`, `financetime`) VALUES
  906. (8, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'UFQ88534', 'tampa', '972671128', '{\"color2\":0,\"modSmokeEnabled\":false,\"dirtLevel\":0.0,\"modArmor\":-1,\"modSpeakers\":-1,\"modWindows\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modPlateHolder\":-1,\"neonEnabled\":[false,false,false,false],\"modFender\":-1,\"modCustomTiresF\":false,\"plate\":\"3PM529YQ\",\"modBrakes\":-1,\"modAPlate\":-1,\"modBackWheels\":-1,\"modTransmission\":-1,\"modHydrolic\":-1,\"modTurbo\":false,\"windowTint\":-1,\"pearlescentColor\":0,\"modKit21\":-1,\"modDial\":-1,\"modShifterLeavers\":-1,\"plateIndex\":0,\"modTrimA\":-1,\"wheelColor\":0,\"modCustomTiresR\":false,\"modTrunk\":-1,\"modHood\":-1,\"modTrimB\":-1,\"modKit19\":-1,\"modDoorSpeaker\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modSpoilers\":-1,\"modVanityPlate\":-1,\"modSteeringWheel\":-1,\"modSuspension\":-1,\"modSideSkirt\":-1,\"modExhaust\":-1,\"modOrnaments\":-1,\"liveryRoof\":-1,\"modRightFender\":-1,\"modLivery\":-1,\"modAirFilter\":-1,\"wheels\":1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modKit17\":-1,\"neonColor\":[255,255,255],\"model\":972671128,\"wheelSize\":1.0,\"modDashboard\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"dashboardColor\":0,\"extras\":[],\"modKit49\":-1,\"modStruts\":-1,\"modTank\":-1,\"modAerials\":-1,\"engineHealth\":992.1159651706275,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"modEngine\":-1,\"bodyHealth\":995.2932781095246,\"wheelWidth\":1.0,\"modGrille\":-1,\"oilLevel\":4.76596940834568,\"tyreSmokeColor\":[255,255,255],\"color1\":17,\"modFrontWheels\":-1,\"modFrontBumper\":-1,\"fuelLevel\":84.19879288077384,\"modFrame\":-1,\"modRearBumper\":-1,\"modSeats\":-1,\"modHorns\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modRoof\":-1,\"tankHealth\":999.2649192831461,\"xenonColor\":255,\"interiorColor\":0,\"modKit47\":-1,\"modArchCover\":-1}', '3PM529YQ', NULL, 'bennys', 84, 993, 996, 1, 0, NULL, '{\"axle\":100,\"fuel\":100,\"clutch\":100,\"radiator\":100,\"brakes\":100}', 0, 0, 0, 0),
  907. (13, 'license:7c6d790889bab7b0a0b8f4e4c1d81dbfe9516f90', 'UGE35348', 'tribike3', '-400295096', '{\"modExhaust\":-1,\"modDashboard\":-1,\"modStruts\":-1,\"modHorns\":-1,\"interiorColor\":0,\"plateIndex\":4,\"modAerials\":-1,\"modTransmission\":-1,\"modTrunk\":-1,\"modSmokeEnabled\":false,\"oilLevel\":0.0,\"wheelWidth\":0.0,\"modSpoilers\":-1,\"modFrontBumper\":-1,\"modOrnaments\":-1,\"color1\":132,\"fuelLevel\":100.08535757525947,\"xenonColor\":255,\"modSpeakers\":-1,\"modDial\":-1,\"modKit19\":-1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"wheelColor\":156,\"modBrakes\":-1,\"extras\":[],\"modCustomTiresF\":false,\"modXenon\":false,\"engineHealth\":1000.0592475178704,\"modCustomTiresR\":false,\"modKit21\":-1,\"modWindows\":-1,\"model\":-400295096,\"tireHealth\":{\"1\":1000.0,\"2\":0.0,\"3\":0.0,\"0\":1000.0},\"windowStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"6\":false,\"7\":false,\"0\":false},\"modAPlate\":-1,\"modFrame\":-1,\"liveryRoof\":-1,\"modVanityPlate\":-1,\"modRightFender\":-1,\"modTrimA\":-1,\"modKit47\":-1,\"modEngine\":-1,\"modHood\":-1,\"dirtLevel\":6.35462587779425,\"modFender\":-1,\"modSuspension\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modKit49\":-1,\"neonColor\":[255,0,255],\"neonEnabled\":[false,false,false,false],\"modArmor\":-1,\"modLivery\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"color2\":132,\"modBackWheels\":-1,\"plate\":\"4UK308JV\",\"modTank\":-1,\"modTurbo\":false,\"wheelSize\":0.0,\"modHydrolic\":-1,\"modEngineBlock\":-1,\"pearlescentColor\":132,\"modSteeringWheel\":-1,\"bodyHealth\":1000.0592475178704,\"dashboardColor\":0,\"modTrimB\":-1,\"modGrille\":-1,\"tyreSmokeColor\":[255,255,255],\"modArchCover\":-1,\"modSideSkirt\":-1,\"modDoorSpeaker\":-1,\"tankHealth\":1000.0592475178704,\"modAirFilter\":-1,\"modKit17\":-1,\"wheels\":6,\"modRearBumper\":-1,\"modSeats\":-1,\"modPlateHolder\":-1,\"modFrontWheels\":-1,\"windowTint\":-1,\"modRoof\":-1,\"modShifterLeavers\":-1}', '4UK308JV', NULL, 'pillboxgarage', 100, 1000, 1000, 1, 0, NULL, NULL, 0, 0, 0, 0),
  908. (14, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'polgauntlet', '-1233767450', '{\"neonEnabled\":[false,false,false,false],\"liveryRoof\":-1,\"modSuspension\":-1,\"modPlateHolder\":-1,\"modSeats\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modKit49\":-1,\"modCustomTiresF\":false,\"modTrimB\":-1,\"wheelSize\":0.0,\"modWindows\":-1,\"modFrame\":-1,\"modKit21\":-1,\"modStruts\":-1,\"modBrakes\":-1,\"modFender\":-1,\"engineHealth\":1000.0592475178704,\"modRoof\":-1,\"wheels\":0,\"modAPlate\":-1,\"modSteeringWheel\":-1,\"modAirFilter\":-1,\"modSpoilers\":-1,\"modVanityPlate\":-1,\"interiorColor\":2,\"modHood\":-1,\"xenonColor\":255,\"modCustomTiresR\":false,\"modShifterLeavers\":-1,\"modTrimA\":-1,\"tankHealth\":1000.0592475178704,\"modHydrolic\":-1,\"modEngineBlock\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modBackWheels\":-1,\"color1\":0,\"modExhaust\":-1,\"plateIndex\":4,\"modSideSkirt\":-1,\"modDashboard\":-1,\"modEngine\":-1,\"modKit47\":-1,\"modOrnaments\":-1,\"oilLevel\":4.76596940834568,\"modSmokeEnabled\":false,\"tyreSmokeColor\":[255,255,255],\"modTurbo\":false,\"modLivery\":-1,\"fuelLevel\":65.13491524739108,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"pearlescentColor\":0,\"modFrontWheels\":-1,\"dashboardColor\":0,\"modRightFender\":-1,\"modRearBumper\":-1,\"neonColor\":[255,0,255],\"extras\":{\"2\":false,\"3\":false,\"4\":true,\"1\":false},\"modKit19\":-1,\"plate\":\"69DDL280\",\"modGrille\":-1,\"dirtLevel\":8.73761058196709,\"wheelColor\":0,\"modHorns\":-1,\"modArmor\":-1,\"model\":-1233767450,\"windowTint\":-1,\"modSpeakers\":-1,\"modFrontBumper\":-1,\"bodyHealth\":1000.0592475178704,\"color2\":111,\"modAerials\":-1,\"modTrunk\":-1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modDial\":-1,\"modKit17\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modArchCover\":-1,\"modXenon\":false,\"wheelWidth\":0.0,\"modDoorSpeaker\":-1,\"modTransmission\":-1,\"modTank\":-1}', '69DDL280', NULL, 'Alta Garage', 100, 1000, 1000, 1, 0, NULL, '{\"axle\":98,\"radiator\":100,\"fuel\":100,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0),
  909. (15, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'landstalker2', '-838099166', '{\"modFrame\":-1,\"dashboardColor\":0,\"modSmokeEnabled\":false,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"color1\":1,\"modAerials\":-1,\"engineHealth\":1000.0592475178704,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modFrontBumper\":-1,\"windowTint\":-1,\"tankHealth\":999.2649192831461,\"wheelSize\":1.0,\"oilLevel\":4.76596940834568,\"modAirFilter\":-1,\"wheels\":3,\"modSpeakers\":-1,\"color2\":120,\"neonColor\":[255,0,255],\"modDashboard\":-1,\"modTransmission\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"xenonColor\":255,\"modTank\":-1,\"modArchCover\":-1,\"modRearBumper\":-1,\"modHood\":-1,\"wheelWidth\":1.0,\"modPlateHolder\":-1,\"wheelColor\":156,\"modShifterLeavers\":-1,\"modRoof\":-1,\"modKit17\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modArmor\":-1,\"modLivery\":-1,\"modFender\":-1,\"interiorColor\":0,\"modTrimA\":-1,\"modTurbo\":false,\"model\":-838099166,\"neonEnabled\":[false,false,false,false],\"modStruts\":-1,\"modOrnaments\":-1,\"extras\":[],\"modEngine\":-1,\"modGrille\":-1,\"modFrontWheels\":-1,\"modSuspension\":-1,\"liveryRoof\":-1,\"fuelLevel\":97.70237287108663,\"modSeats\":-1,\"modSpoilers\":-1,\"modDial\":-1,\"modHydrolic\":-1,\"modExhaust\":-1,\"modKit19\":-1,\"plateIndex\":0,\"pearlescentColor\":4,\"modVanityPlate\":-1,\"modCustomTiresF\":false,\"modKit21\":-1,\"tyreSmokeColor\":[255,255,255],\"modKit49\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":true,\"5\":true,\"6\":true,\"7\":true,\"0\":true},\"modDoorSpeaker\":-1,\"modCustomTiresR\":false,\"modWindows\":-1,\"dirtLevel\":2.38298470417284,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"plate\":\"83LMP166\",\"modSteeringWheel\":-1,\"bodyHealth\":992.9102934053518,\"modTrimB\":-1,\"modSideSkirt\":-1,\"modHorns\":-1,\"modTrunk\":-1,\"modAPlate\":-1,\"modBrakes\":-1,\"modRightFender\":-1,\"modKit47\":-1,\"modBackWheels\":-1}', '83LMP166', NULL, 'bennys', 98, 1001, 993, 1, 0, NULL, '{\"axle\":100,\"radiator\":100,\"fuel\":100,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0),
  910. (16, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'rancherxl', '1645267888', '{\"modFrame\":-1,\"dashboardColor\":0,\"modSmokeEnabled\":false,\"tireHealth\":{\"1\":987.7645263671875,\"2\":999.75,\"3\":999.25,\"0\":998.75},\"color1\":82,\"modAerials\":-1,\"engineHealth\":921.4207522801665,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modFrontBumper\":-1,\"windowTint\":-1,\"tankHealth\":3993.088035958963,\"wheelSize\":1.0,\"oilLevel\":4.76596940834568,\"modAirFilter\":-1,\"wheels\":4,\"modSpeakers\":-1,\"color2\":0,\"neonColor\":[255,0,255],\"modDashboard\":-1,\"modTransmission\":2,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"xenonColor\":255,\"modTank\":-1,\"modArchCover\":-1,\"modRearBumper\":-1,\"modHood\":-1,\"wheelWidth\":1.0,\"modPlateHolder\":-1,\"wheelColor\":156,\"modShifterLeavers\":-1,\"modRoof\":-1,\"modKit17\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modArmor\":-1,\"modLivery\":-1,\"modFender\":-1,\"interiorColor\":119,\"modTrimA\":-1,\"modTurbo\":1,\"model\":1645267888,\"neonEnabled\":[false,false,false,false],\"modStruts\":-1,\"modOrnaments\":-1,\"extras\":{\"12\":true,\"11\":true,\"10\":false},\"modEngine\":3,\"modGrille\":-1,\"modFrontWheels\":-1,\"modSuspension\":3,\"liveryRoof\":-1,\"fuelLevel\":72.28386935990962,\"modSeats\":-1,\"modSpoilers\":-1,\"modDial\":-1,\"modHydrolic\":-1,\"modExhaust\":-1,\"modKit19\":-1,\"plateIndex\":3,\"pearlescentColor\":19,\"modVanityPlate\":-1,\"modCustomTiresF\":false,\"modKit21\":-1,\"tyreSmokeColor\":[255,255,255],\"modKit49\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modDoorSpeaker\":-1,\"modCustomTiresR\":false,\"modWindows\":-1,\"dirtLevel\":0.0,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"plate\":\"02TUX087\",\"modSteeringWheel\":-1,\"bodyHealth\":933.3356758010307,\"modTrimB\":-1,\"modSideSkirt\":-1,\"modHorns\":57,\"modTrunk\":-1,\"modAPlate\":-1,\"modBrakes\":2,\"modRightFender\":-1,\"modKit47\":-1,\"modBackWheels\":-1}', '02TUX087', NULL, 'pillboxgarage', 73, 922, 934, 1, 0, NULL, '{\"axle\":98,\"radiator\":100,\"fuel\":94,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0);
  911.  
  912. -- --------------------------------------------------------
  913.  
  914. --
  915. -- Table structure for table `player_warns`
  916. --
  917.  
  918. CREATE TABLE `player_warns` (
  919.   `id` INT(11) NOT NULL,
  920.   `senderIdentifier` VARCHAR(50) DEFAULT NULL,
  921.   `targetIdentifier` VARCHAR(50) DEFAULT NULL,
  922.   `reason` text DEFAULT NULL,
  923.   `warnId` VARCHAR(50) DEFAULT NULL
  924. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  925.  
  926. -- --------------------------------------------------------
  927.  
  928. --
  929. -- Table structure for table `properties`
  930. --
  931.  
  932. CREATE TABLE `properties` (
  933.   `property_id` INT(11) NOT NULL,
  934.   `owner_citizenid` VARCHAR(50) DEFAULT NULL,
  935.   `street` VARCHAR(100) DEFAULT NULL,
  936.   `region` VARCHAR(100) DEFAULT NULL,
  937.   `description` longtext DEFAULT NULL,
  938.   `has_access` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`has_access`)),
  939.   `extra_imgs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`extra_imgs`)),
  940.   `furnitures` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`furnitures`)),
  941.   `for_sale` tinyint(1) NOT NULL DEFAULT 1,
  942.   `price` INT(11) NOT NULL DEFAULT 0,
  943.   `shell` VARCHAR(50) NOT NULL,
  944.   `apartment` VARCHAR(50) DEFAULT NULL,
  945.   `door_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`door_data`)),
  946.   `garage_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`garage_data`))
  947. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  948.  
  949. -- --------------------------------------------------------
  950.  
  951. --
  952. -- Table structure for table `renzu_tuner`
  953. --
  954.  
  955. CREATE TABLE `renzu_tuner` (
  956.   `id` INT(11) NOT NULL,
  957.   `plate` VARCHAR(60) DEFAULT NULL,
  958.   `mileages` INT(11) DEFAULT 0,
  959.   `vehiclestats` longtext DEFAULT NULL,
  960.   `defaulthandling` longtext DEFAULT NULL,
  961.   `vehicleupgrades` longtext DEFAULT NULL,
  962.   `vehicletires` longtext DEFAULT NULL,
  963.   `drivetrain` VARCHAR(60) DEFAULT NULL,
  964.   `advancedflags` longtext DEFAULT NULL,
  965.   `ecu` longtext DEFAULT NULL,
  966.   `nodegrade` INT(11) DEFAULT 0,
  967.   `currentengine` VARCHAR(60) DEFAULT NULL
  968. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  969.  
  970. --
  971. -- Dumping data for table `renzu_tuner`
  972. --
  973.  
  974. INSERT INTO `renzu_tuner` (`id`, `plate`, `mileages`, `vehiclestats`, `defaulthandling`, `vehicleupgrades`, `vehicletires`, `drivetrain`, `advancedflags`, `ecu`, `nodegrade`, `currentengine`) VALUES
  975. (1, '3PM529YQ', 167, '{\"engine_fuelinjector\":100.01614089772107,\"engine_camshaft\":100.02625000000004,\"engine_connectingrods\":100.0088061255962,\"engine_pistons\":99.98870994210248,\"oem_suspension\":99.59332098431888,\"oem_brakes\":99.3925514698029,\"engine_flywheel\":100.0125114565343,\"transmition_clutch\":99.6335562860966,\"engine_sparkplug\":99.63629229016606,\"engine_airfilter\":100.06000000000003,\"oem_gearbox\":99.65500000000003,\"engine_valves\":98.83859622463587,\"engine_gasket\":99.63703539818528,\"engine_block\":100.06000000000003,\"engine_crankshaft\":100.03093024015429,\"engine_oil\":100.02625000000004}', '{\"fSuspensionRaise\":0,\"fTractionCurveMin\":1.79999995231628,\"fDriveInertia\":1,\"fHandBrakeForce\":0.80000001192092,\"fSuspensionLowerLimit\":-0.14000000059604,\"fTractionCurveMax\":2.25,\"fRollCentreHeightFront\":0.20000000298023,\"fSuspensionReboundDamp\":1.29999995231628,\"fTractionCurveLateral\":22.5,\"fSuspensionBiasFront\":0.47999998927116,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fAntiRollBarBiasFront\":0.57499998807907,\"fSuspensionUpperLimit\":0.11999999731779,\"fAntiRollBarForce\":0.40000000596046,\"nInitialDriveGears\":4,\"fRollCentreHeightRear\":0.20000000298023,\"fInitialDriveMaxFlatVel\":140,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fTractionLossMult\":1,\"fSuspensionForce\":2.20000004768371,\"fInitialDriveForce\":0.27000001072883,\"fLowSpeedTractionLossMult\":1.29999995231628,\"fBrakeForce\":0.80000001192092,\"fSuspensionCompDamp\":0.80000007152557}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
  976. (2, '9DK850PC', 11, '{\"oem_brakes\":100.01,\"engine_connectingrods\":100.01,\"oem_suspension\":100.01,\"engine_valves\":100.01,\"engine_fuelinjector\":100.01,\"engine_block\":100.01,\"transmition_clutch\":100.01,\"engine_camshaft\":99.98535887233914,\"oem_gearbox\":100.01,\"engine_gasket\":100.01,\"engine_oil\":100.01,\"engine_sparkplug\":100.01,\"engine_pistons\":100.01,\"engine_flywheel\":100.01,\"engine_crankshaft\":100.01,\"engine_airfilter\":99.98402610749007}', '{\"fSuspensionForce\":2.29999995231628,\"fSuspensionBiasFront\":0.5,\"fLowSpeedTractionLossMult\":1,\"fHandBrakeForce\":0.60000002384185,\"fTractionCurveMin\":2.34999990463256,\"fTractionCurveLateral\":22.5,\"fDriveInertia\":1,\"fRollCentreHeightFront\":0.31999999284744,\"fAntiRollBarBiasFront\":0.44999998807907,\"fInitialDriveForce\":0.30000001192092,\"fSuspensionLowerLimit\":-0.10000000149011,\"fSuspensionUpperLimit\":0.05000000074505,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fInitialDriveMaxFlatVel\":145,\"fTractionCurveMax\":2.5,\"fSuspensionRaise\":0,\"fAntiRollBarForce\":0.69999998807907,\"fBrakeForce\":0.89999997615814,\"fSuspensionCompDamp\":1.79999995231628,\"fRollCentreHeightRear\":0.33000001311302,\"nInitialDriveGears\":5,\"fTractionLossMult\":1,\"fSuspensionReboundDamp\":2.09999990463256}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
  977. (3, '86AHL419', 0, '[]', '{\"fRollCentreHeightRear\":0.18250000476837,\"fSuspensionBiasFront\":0.49000000953674,\"fInitialDriveMaxFlatVel\":220.95001220703126,\"fClutchChangeRateScaleDownShift\":8.89999961853027,\"fBrakeForce\":1.54999995231628,\"fTractionCurveLateral\":22.5,\"fAntiRollBarForce\":0.92500001192092,\"fInitialDriveForce\":0.38449999690055,\"fTractionCurveMin\":2.41000008583068,\"fLowSpeedTractionLossMult\":1.14999997615814,\"fTractionCurveMax\":2.58500003814697,\"fTractionLossMult\":1,\"fSuspensionForce\":2.20000004768371,\"fSuspensionReboundDamp\":1.89999997615814,\"fSuspensionUpperLimit\":0.15000000596046,\"fRollCentreHeightFront\":0.21899999678134,\"fSuspensionRaise\":0.07500000298023,\"fDriveInertia\":1,\"fSuspensionCompDamp\":2.29999995231628,\"fSuspensionLowerLimit\":-0.10000000149011,\"fClutchChangeRateScaleUpShift\":10.89999961853027,\"fHandBrakeForce\":0.625,\"nInitialDriveGears\":6,\"fAntiRollBarBiasFront\":0.37999999523162}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
  978. (4, '80PIP283', 11, '{\"transmition_clutch\":100.01,\"engine_oil\":100.01,\"engine_flywheel\":100.01,\"engine_pistons\":100.01,\"engine_camshaft\":100.01,\"engine_fuelinjector\":100.01,\"engine_crankshaft\":100.01,\"oem_gearbox\":100.01,\"oem_brakes\":100.01,\"engine_valves\":100.01,\"engine_connectingrods\":100.01,\"engine_block\":100.01,\"engine_airfilter\":100.01,\"engine_sparkplug\":100.01,\"oem_suspension\":100.01,\"engine_gasket\":100.01}', '{\"fRollCentreHeightRear\":0.60000002384185,\"fSuspensionBiasFront\":0.44999998807907,\"fInitialDriveMaxFlatVel\":235,\"fClutchChangeRateScaleDownShift\":4.80000019073486,\"fBrakeForce\":0.60000002384185,\"fTractionCurveLateral\":19,\"fAntiRollBarForce\":0.89999997615814,\"fInitialDriveForce\":0.20000000298023,\"fTractionCurveMin\":1.64999997615814,\"fLowSpeedTractionLossMult\":1.5,\"fTractionCurveMax\":2,\"fTractionLossMult\":0.20000000298023,\"fSuspensionForce\":1.20000004768371,\"fSuspensionReboundDamp\":1.20000004768371,\"fSuspensionUpperLimit\":0.15999999642372,\"fRollCentreHeightFront\":0.6700000166893,\"fSuspensionRaise\":0,\"fDriveInertia\":0.5,\"fSuspensionCompDamp\":1.20000004768371,\"fSuspensionLowerLimit\":-0.15999999642372,\"fClutchChangeRateScaleUpShift\":4.80000019073486,\"fHandBrakeForce\":0.31999999284744,\"nInitialDriveGears\":7,\"fAntiRollBarBiasFront\":0.56000000238418}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
  979. (5, '69DDL280', 0, '[]', '{\"fInitialDriveMaxFlatVel\":155,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fSuspensionLowerLimit\":-0.10000000149011,\"fTractionLossMult\":1,\"fSuspensionRaise\":0,\"fRollCentreHeightFront\":0.14000000059604,\"fSuspensionUpperLimit\":0.05000000074505,\"fSuspensionForce\":2.29999995231628,\"fTractionCurveMax\":2.34999990463256,\"fRollCentreHeightRear\":0.15999999642372,\"fBrakeForce\":0.89999997615814,\"nInitialDriveGears\":5,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fTractionCurveMin\":2.09999990463256,\"fInitialDriveForce\":0.36000001430511,\"fAntiRollBarBiasFront\":0.44999998807907,\"fSuspensionReboundDamp\":2.09999990463256,\"fSuspensionCompDamp\":1.79999995231628,\"fLowSpeedTractionLossMult\":0.40000000596046,\"fTractionCurveLateral\":22.5,\"fHandBrakeForce\":0.60000002384185,\"fAntiRollBarForce\":0.69999998807907,\"fSuspensionBiasFront\":0.5,\"fDriveInertia\":1}', '[]', NULL, NULL, NULL, NULL, 0, NULL);
  980.  
  981. -- --------------------------------------------------------
  982.  
  983. --
  984. -- Table structure for table `stashitems`
  985. --
  986.  
  987. CREATE TABLE `stashitems` (
  988.   `id` INT(11) NOT NULL,
  989.   `stash` VARCHAR(255) NOT NULL DEFAULT '[]',
  990.   `items` longtext DEFAULT NULL
  991. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  992.  
  993. --
  994. -- Dumping data for table `stashitems`
  995. --
  996.  
  997. INSERT INTO `stashitems` (`id`, `stash`, `items`) VALUES
  998. (1, 'apartment18123', '[]'),
  999. (2, 'tray', '[]'),
  1000. (3, 'tray', '[]'),
  1001. (4, 'tray', '[]'),
  1002. (5, 'tray', '[]'),
  1003. (6, 'tray2', '[]'),
  1004. (7, 'storge2', '[{\"name\":\"burgershot_bread\",\"slot\":1,\"weight\":100,\"label\":\"Bread\",\"useable\":true,\"image\":\"burgershot_bread.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_sauce\",\"slot\":2,\"weight\":100,\"label\":\"Sauce\",\"useable\":true,\"image\":\"burgershot_sauce.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_tomato\",\"slot\":3,\"weight\":100,\"label\":\"Tomato\",\"useable\":true,\"image\":\"burgershot_tomato.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_cheddar\",\"slot\":4,\"weight\":100,\"label\":\"Cheddar\",\"useable\":true,\"image\":\"burgershot_cheddar.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_curly\",\"slot\":5,\"weight\":100,\"label\":\"Curly\",\"useable\":true,\"image\":\"burgershot_curly.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":6,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_lavash\",\"slot\":7,\"weight\":100,\"label\":\"Lavash\",\"useable\":true,\"image\":\"burgershot_lavash.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_bigcardboard\",\"slot\":8,\"weight\":100,\"label\":\"Big Size Cardboard\",\"useable\":true,\"image\":\"burgershot_bigcardboard.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":9,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":10,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"}]'),
  1005. (8, 'apartment14670', '[]'),
  1006. (9, 'apartment14670', '[]'),
  1007. (10, 'boss_taxi', '[]'),
  1008. (13, 'apartment1707', '[]'),
  1009. (14, 'apartment1707', '[{\"amount\":1,\"created\":1714155191,\"info\":{\"quality\":100},\"useable\":true,\"weight\":1,\"type\":\"item\",\"name\":\"lspdbadge\",\"image\":\"lspdbadge.png\",\"slot\":1,\"label\":\"Police Badge\",\"unique\":false},{\"amount\":1,\"created\":1714155818,\"info\":{\"quality\":100},\"useable\":true,\"weight\":0,\"type\":\"item\",\"name\":\"lawyerpass\",\"image\":\"lawyerpass.png\",\"slot\":2,\"label\":\"Lawyer Pass\",\"unique\":true}]'),
  1010. (15, 'apartment1707', '[]'),
  1011. (16, 'apartment1707', '[]'),
  1012. (17, '1', '[]');
  1013.  
  1014. -- --------------------------------------------------------
  1015.  
  1016. --
  1017. -- Table structure for table `trunkitems`
  1018. --
  1019.  
  1020. CREATE TABLE `trunkitems` (
  1021.   `id` INT(11) NOT NULL,
  1022.   `plate` VARCHAR(8) NOT NULL DEFAULT '[]',
  1023.   `items` longtext DEFAULT NULL
  1024. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement