-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Erstellungszeit: 30. Jul 2023 um 18:34
-- Server-Version: 10.4.28-MariaDB
-- PHP-Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Datenbank: `test`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `addon_account`
--

CREATE TABLE `addon_account` (
  `id` int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `label` varchar(100) NOT NULL,
  `shared` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `addon_account`
--

INSERT INTO `addon_account` (`id`, `name`, `label`, `shared`) VALUES
(1, 'society_rednecks', 'Rednecks', 1),
(2, 'society_midnight', 'Midnight', 1),
(3, 'society_ndrangheta', 'Ndrangheta', 1),
(4, 'society_yakuza', 'Yakuza', 1),
(5, 'society_triaden', 'Triaden', 1),
(6, 'society_orga', 'Organisazija', 1),
(7, 'society_ballas', 'Ballas', 1),
(8, 'society_lcn', 'LCN', 1),
(9, 'society_brigada', 'Brigada', 1),
(10, 'society_crips', 'Crips', 1),
(11, 'society_sinaloa', 'Sinaloa', 1),
(12, 'society_unemployed', 'Unemployed', 1),
(13, 'society_vagos', 'Vagos', 1),
(14, 'society_grove', 'Grove', 1),
(15, 'society_lostmc', 'LostMc', 1),
(16, 'society_bloods', 'Bloods', 1),
(17, 'society_aztecas', 'Aztecas', 1),
(18, 'society_mg13', 'MG13', 1),
(19, 'society_ambulance', 'Medic', 1),
(20, 'society_police', 'LSPD', 1),
(21, 'society_army', 'Army', 1),
(22, 'society_cardealer', 'Concessionnaire', 1),
(23, 'society_cardealer', 'Concessionnaire', 1),
(24, 'society_hustlers', 'Hustlers', 1),
(25, 'property_black_money', 'Argent Sale Propriété', 0),
(26, 'society_irish', 'Irish', 1),
(27, 'society_bratwa', 'Bratwa', 1),
(28, 'society_camorra', 'Camorra', 1),
(29, 'society_18th', '18th street', 1),
(30, 'society_hoover', 'Hoover', 1),
(31, 'society_casino', 'Casino', 1),
(32, 'society_hoh', 'HoH', 1),
(33, 'society_peckham', 'Peckham', 1),
(34, 'society_mg13', 'MG13', 1),
(35, 'society_sheriff', 'Sheriff', 1),
(36, 'society_mg13', 'MG13', 1),
(37, 'society_doj', 'DOJ', 1),
(38, 'society_mg13', 'MG13', 1),
(39, 'society_mg13', 'MG13', 1),
(40, 'society_mg13', 'MG13', 1),
(41, 'society_mg13', 'MG13', 1),
(42, 'society_mg13', 'MG13', 1),
(43, 'society_tribe', 'Skanidavien Tribe', 1),
(44, 'society_grypsera', 'Grypsera', 1),
(45, 'society_bgd', 'BGD', 1),
(46, 'society_cardealer', 'Concessionnaire', 1),
(47, 'property_black_money', 'Argent Sale Propriété', 0),
(48, 'motels_bed_black_money', 'Motels Schwarzgeld Bett', 0),
(49, 'motels_black_money', 'Motels Schwarzgeld ', 0),
(50, 'society_mg13', 'MG13', 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `addon_account_data`
--

CREATE TABLE `addon_account_data` (
  `id` int(11) NOT NULL,
  `account_name` varchar(100) DEFAULT NULL,
  `money` int(22) NOT NULL,
  `owner` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `addon_account_data`
--

INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
(7060, 'society_rednecks', 0, NULL),
(7061, 'society_midnight', 20290000, NULL),
(7062, 'society_ndrangheta', 0, NULL),
(7063, 'society_yakuza', 0, NULL),
(7064, 'society_triaden', 0, NULL),
(7065, 'society_orga', 0, NULL),
(7066, 'society_ballas', 0, NULL),
(7067, 'society_lcn', 0, NULL),
(7068, 'society_brigada', 10100, NULL),
(7069, 'society_crips', 0, NULL),
(7070, 'society_sinaloa', 0, NULL),
(7071, 'society_unemployed', 0, NULL),
(7072, 'society_vagos', 4010000, NULL),
(7073, 'society_grove', 0, NULL),
(7074, 'society_lostmc', 0, NULL),
(7075, 'society_bloods', 0, NULL),
(7076, 'society_aztecas', 0, NULL),
(7077, 'society_mg13', 2147483647, NULL),
(7078, 'society_ambulance', 0, NULL),
(7079, 'society_police', 10, NULL),
(7080, 'society_army', 0, NULL),
(7081, 'society_cardealer', 0, NULL),
(7082, 'society_hustlers', 0, NULL),
(7083, 'society_irish', 0, NULL),
(7084, 'society_bratwa', 0, NULL),
(7085, 'society_camorra', 0, NULL),
(7086, 'society_18th', 0, NULL),
(7087, 'society_hoover', 0, NULL),
(7088, 'society_casino', 8236365, NULL),
(7089, 'society_hoh', 0, NULL),
(7090, 'society_peckham', 0, NULL),
(7091, 'society_sheriff', 0, NULL),
(7092, 'society_doj', 0, NULL),
(7093, 'society_tribe', 0, NULL),
(7094, 'society_grypsera', 0, NULL),
(7095, 'society_bgd', 0, NULL),

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `addon_inventory`
--

CREATE TABLE `addon_inventory` (
  `id` int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `label` varchar(255) NOT NULL,
  `shared` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `addon_inventory`
--

INSERT INTO `addon_inventory` (`id`, `name`, `label`, `shared`) VALUES
(1, 'society_pd', 'Police', 1),
(2, 'society_vagos', 'Vagos', 1),
(3, 'society_ndrangheta', 'Ndrangheta', 1),
(4, 'society_sinaloa', 'Sinaloa', 1),
(5, 'society_unemployed', 'Unemployed', 1),
(6, 'society_rednecks', 'Rednecks', 1),
(7, 'society_aztecas', 'Aztecas', 1),
(8, 'society_crips', 'Crips', 1),
(9, 'society_triaden', 'Triaden', 1),
(10, 'society_yakuza', 'Yakuza', 1),
(11, 'society_bloods', 'Bloods', 1),
(12, 'society_lostmc', 'LostMc', 1),
(13, 'society_midnight', 'Midnight', 1),
(14, 'society_mg13', 'MG13', 1),
(15, 'society_lcn', 'LCN', 1),
(16, 'society_grove', 'Grove', 1),
(17, 'society_orga', 'Organisazija', 1),
(18, 'society_brigada', 'Brigada', 1),
(19, 'society_ballas', 'Ballas', 1),
(20, 'society_ambulance', 'Medic', 1),
(21, 'society_police', 'LSPD', 1),
(22, 'society_army', 'Army', 1),
(23, 'society_cardealer', 'Concesionnaire', 1),
(24, 'society_cardealer', 'Concesionnaire', 1),
(25, 'society_hustlers', 'Hustlers', 1),
(26, 'property', 'Propriété', 0),
(27, 'society_irish', 'Irish', 1),
(28, 'society_bratwa', 'Bratwa', 1),
(29, 'society_camorra', 'Camorra', 1),
(30, 'society_18th', '18th street', 1),
(31, 'society_hoover', 'Hoover', 1),
(32, 'society_casino', 'Casino', 1),
(33, 'society_casino_fridge', 'Casino (Eisschrank)', 1),
(34, 'society_hoh', 'HoH', 1),
(35, 'society_peckham', 'Peckham', 1),
(36, 'society_sheriff', 'Sheriff', 1),
(37, 'society_fib', 'FIB', 1),
(38, 'society_doj', 'DOJ', 1),
(39, 'society_glace', 'Glace', 1),
(40, 'society_rifa', 'Rifa', 1),
(41, 'society_vatos', 'Vatos', 1),
(42, 'society_grypsera', 'Grypsera', 1),
(43, 'society_tribe', 'Skanidavien Tribe', 1),
(44, 'society_bgd', 'BGD', 1),
(45, 'society_cardealer', 'Concesionnaire', 1),
(46, 'property', 'Propriété', 0),
(47, 'motels', 'Motels Inventar', 0),
(48, 'motels_bed', 'Motels Bett Inventar', 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `addon_inventory_items`
--

CREATE TABLE `addon_inventory_items` (
  `id` int(11) NOT NULL,
  `inventory_name` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `count` int(11) NOT NULL,
  `owner` varchar(60) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `addon_inventory_items`
--

INSERT INTO `addon_inventory_items` (`id`, `inventory_name`, `name`, `count`, `owner`) VALUES
(2, 'society_fib', 'fibbulletproof', 0, NULL),
(3, 'society_orga', 'bulletproof', 0, NULL),
(4, 'society_lcn', 'bulletproof', 110, NULL),
(5, 'society_lcn', 'fackel', 0, NULL),
(6, 'society_hustlers', 'bulletproof', 0, NULL),
(7, 'society_hustlers', 'fackel', 0, NULL),
(9, 'society_irish', 'bulletproof', 0, NULL),
(13, 'society_hoover', 'fackel', 0, NULL),
(14, 'society_hoover', 'bulletproof', 200, NULL),
(15, 'society_tribe', 'bulletproof', 620, NULL),
(16, 'society_tribe', 'medikit', 170, NULL),
(17, 'society_peckham', 'fackel', 0, NULL),
(18, 'society_peckham', 'bulletproof', 0, NULL),
(19, 'society_aztecas', 'bulletproof', 0, NULL),
(20, 'society_aztecas', 'fackel', 0, NULL),
(22, 'society_bratwa', 'waffenteile', 0, NULL),
(23, 'society_sinaloa', 'kupferbarren', 28, NULL),
(24, 'society_sinaloa', 'bulletproof', 160, NULL),
(25, 'society_sinaloa', 'stahl', 0, NULL),
(26, 'society_tribe', 'fackel', 3, NULL),
(27, 'society_ballas', 'bulletproof', 540, NULL),
(28, 'society_triaden', 'bulletproof', 0, NULL),
(29, 'society_triaden', 'fackel', 0, NULL),
(30, 'society_orga', 'waffenteile', 0, NULL),
(31, 'society_hoh', 'medikit', 0, NULL),
(32, 'society_hoh', 'bulletproof', 0, NULL),
(33, 'society_triaden', 'baggy', 0, NULL),
(36, 'society_triaden', 'koks', 0, NULL),
(37, 'society_triaden', 'schweissgeraet', 0, NULL),
(38, 'society_triaden', 'brechstange', 0, NULL),
(39, 'society_sinaloa', 'waffenteile', 0, NULL),
(40, 'society_hoh', 'phone', 0, NULL),
(41, 'society_hoh', 'repairkit', 0, NULL),
(42, 'society_tribe', 'mehl', 310, NULL),
(43, 'society_orga', 'kupferbarren', 0, NULL),
(45, 'society_vatos', 'bulletproof', 0, NULL),
(46, 'society_sinaloa', 'wuerfel', 1, NULL),
(47, 'society_aztecas', 'kevlar', 47, NULL),
(48, 'society_aztecas', 'weizen', 0, NULL),
(49, 'society_aztecas', 'spray', 0, NULL),
(52, 'society_vagos', 'bulletproof', 0, NULL),
(57, 'society_hustlers', 'lootdropkiste', 0, NULL),
(58, 'society_hustlers', 'brechstange', 0, NULL),
(59, 'society_rifa', 'kevlar', 1, NULL),
(60, 'society_hustlers', 'joint', 0, NULL),
(61, 'society_mg13', 'bulletproof', 0, NULL),
(62, 'society_mg13', 'fackel', 0, NULL),
(63, 'society_peckham', 'schweissgeraet', 20, NULL),
(64, 'society_peckham', 'baggy', 33, NULL),
(65, 'society_mg13', 'medikit', 0, NULL),
(66, 'society_mg13', 'repairkit', 0, NULL),
(67, 'society_lostmc', 'bulletproof', 40, NULL),
(68, 'society_glace', 'spray', 0, NULL),
(69, 'society_fib', 'lspdbulletproof', 10, NULL),
(70, 'society_brigada', 'brechstange', 0, NULL),
(71, 'society_brigada', 'fackel', 0, NULL),
(72, 'society_brigada', 'stahl', 0, NULL),
(73, 'society_rednecks', 'bulletproof', 0, NULL),
(74, 'society_orga', 'medikit', 0, NULL),
(75, 'society_orga', 'erstehilfekoffer', 0, NULL),
(76, 'society_orga', 'kevlar', 183, NULL),
(77, 'society_lcn', 'fish', 0, NULL),
(78, 'society_lcn', 'medikit', 149, NULL),
(79, 'society_midnight', 'medikit', 160, NULL),
(80, 'society_midnight', 'bulletproof', 36, NULL),
(81, 'society_ballas', 'ehering', 0, NULL),
(82, 'society_ballas', 'medikit', 625, NULL),
(83, 'society_orga', 'phone', 0, NULL),
(84, 'society_orga', 'repairkit', 0, NULL),
(85, 'society_midnight', 'repairkit', 0, NULL),
(86, 'society_midnight', 'fackel', 0, NULL),
(87, 'society_midnight', 'scratch_ticket', 0, NULL),
(88, 'society_rednecks', 'medikit', 0, NULL),
(89, 'society_grove', 'medikit', 259, NULL),
(90, 'society_grove', 'turtle', 0, NULL),
(91, 'society_grove', 'fishingrod', 0, NULL),
(92, 'society_grove', 'bulletproof', 196, NULL),
(93, 'society_brigada', 'bulletproof', 0, NULL),
(94, 'society_brigada', 'medikit', 0, NULL),
(95, 'society_orga', 'kabelbinder', 0, NULL),
(96, 'society_orga', 'schere', 0, NULL),
(97, 'society_vagos', 'medikit', 119, NULL),
(98, 'society_vagos', 'repairkit', 80, NULL),
(99, 'society_orga', 'fishingrod', 0, NULL),
(100, 'society_triaden', 'medikit', 0, NULL),
(101, 'society_hoover', 'medikit', 200, NULL),
(102, 'society_orga', 'metall', 0, NULL),
(103, 'society_midnight', 'schweissgeraet', 0, NULL),
(104, 'society_army', 'armybulletproof', 4, NULL),
(105, 'society_army', 'medikit', 4, NULL),
(106, 'society_brigada', 'waffenbox_bullpuprifle', 0, NULL),
(107, 'society_brigada', 'waffenbox_advancedrifle', 0, NULL),
(108, 'society_yakuza', 'waffenbox_advancedrifle', 0, NULL),
(109, 'society_yakuza', 'waffenbox_bullpuprifle', 0, NULL),
(110, 'society_yakuza', 'medikit', 0, NULL),
(111, 'society_yakuza', 'bulletproof', 0, NULL),
(112, 'society_mg13', 'waffenbox_advancedrifle', 0, NULL),
(113, 'society_mg13', 'waffenbox_bullpuprifle', 0, NULL),
(114, 'society_mg13', 'waffenbox_specialcarbine_mk2', 0, NULL),
(115, 'society_triaden', 'waffenbox_advancedrifle', 0, NULL),
(116, 'society_triaden', 'waffenbox_bullpuprifle', 0, NULL),
(117, 'society_lostmc', 'metall', 0, NULL),
(118, 'society_lostmc', 'kevlar', 0, NULL),
(119, 'society_lostmc', 'waffenbox_specialcarbine_mk2', 0, NULL),
(120, 'society_lostmc', 'waffenbox_advancedrifle', 6, NULL),
(121, 'society_midnight', 'erstehilfekoffer', 0, NULL),
(122, 'society_midnight', 'waffenteile', 0, NULL),
(123, 'society_midnight', 'waffenbox_advancedrifle', 0, NULL),
(124, 'society_midnight', 'phone', 0, NULL),
(125, 'society_grove', 'waffenbox_specialcarbine_mk2', 27, NULL),
(126, 'society_orga', 'waffenbox_specialcarbine_mk2', 0, NULL),
(127, 'society_orga', 'mehl', 0, NULL),
(128, 'society_midnight', 'kabelbinder', 0, NULL),
(129, 'society_midnight', 'schere', 0, NULL),
(130, 'society_midnight', 'metall', 0, NULL),
(131, 'society_midnight', 'spitzhacke', 0, NULL),
(132, 'society_yakuza', 'waffenbox_specialcarbine_mk2', 0, NULL),
(133, 'society_yakuza', 'waffenteile', 0, NULL),
(134, 'society_vagos', 'waffenbox_specialcarbine_mk2', 0, NULL),
(135, 'society_triaden', 'waffenbox_specialcarbine_mk2', 0, NULL),
(136, 'society_triaden', 'waffenteile', 0, NULL),
(137, 'society_grove', 'waffenteile', 110, NULL),
(138, 'society_lostmc', 'fish', 1, NULL),
(139, 'society_lostmc', 'phone', 0, NULL),
(140, 'society_lostmc', 'medikit', 156, NULL),
(141, 'society_lostmc', 'repairkit', 45, NULL),
(142, 'society_sinaloa', 'waffenbox_specialcarbine_mk2', 14, NULL),
(143, 'society_sinaloa', 'medikit', 180, NULL),
(144, 'society_rednecks', 'waffenbox_bullpuprifle', 0, NULL),
(145, 'society_rednecks', 'waffenbox_advancedrifle', 0, NULL),
(146, 'society_grove', 'waffenbox_advancedrifle', 0, NULL),
(147, 'society_sinaloa', 'waffenbox_advancedrifle', 20, NULL),
(148, 'society_tribe', 'waffenbox_specialcarbine_mk2', 41, NULL),
(149, 'society_tribe', 'kevlar', 1284, NULL),
(150, 'society_tribe', 'metall', 1820, NULL),
(151, 'society_tribe', 'waffenbox_advancedrifle', 35, NULL),
(152, 'society_tribe', 'waffenteile', 161, NULL),
(153, 'society_midnight', 'waffenbox_bullpuprifle', 13, NULL),
(154, 'society_ballas', 'waffenbox_bullpuprifle', 22, NULL),
(155, 'society_vagos', 'fishingrod', 2, NULL),
(156, 'society_vagos', 'erstehilfekoffer', 115, NULL),
(157, 'society_vagos', 'kevlar', 350, NULL),
(158, 'society_vagos', 'waffenteile', 27, NULL),
(159, 'society_vagos', 'spray', 4, NULL),
(160, 'society_vagos', 'metall', 335, NULL),
(161, 'society_vagos', 'mehl', 194, NULL),
(162, 'society_vagos', 'phone', 83, NULL),
(163, 'society_vagos', 'kabelbinder', 90, NULL),
(164, 'society_vagos', 'schere', 90, NULL),
(165, 'society_hoover', 'waffenbox_bullpuprifle', 19, NULL);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `aircrafts`
--

CREATE TABLE `aircrafts` (
  `name` varchar(60) NOT NULL,
  `model` varchar(60) NOT NULL,
  `price` int(11) NOT NULL,
  `category` varchar(60) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `aircrafts`
--

INSERT INTO `aircrafts` (`name`, `model`, `price`, `category`) VALUES
('Buzzard', 'buzzard2', 150000, 'heli'),
('Cuban 800', 'cuban800', 75000, 'plane'),
('Dodo', 'dodo', 80000, 'plane'),
('Duster', 'duster', 85000, 'plane'),
('Frogger', 'frogger', 125000, 'heli'),
('Havok', 'havok', 60000, 'heli'),
('Luxor', 'luxor', 1500000, 'plane'),
('Mallard', 'stunt', 120000, 'plane'),
('Mammatus', 'mammatus', 130000, 'plane'),
('Maverick', 'maverick', 90000, 'heli'),
('SuperVolito', 'supervolito', 250000, 'heli'),
('SuperVolito Carbon', 'supervolito2', 300000, 'heli'),
('Swift', 'swift', 500000, 'heli'),
('Ultra Light', 'microlight', 45000, 'plane'),
('Velum', 'velum2', 150000, 'plane'),
('Vestra', 'vestra', 165000, 'plane'),
('Volatus', 'volatus', 1000000, 'heli');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `aircraft_categories`
--

CREATE TABLE `aircraft_categories` (
  `name` varchar(60) NOT NULL,
  `label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `aircraft_categories`
--

INSERT INTO `aircraft_categories` (`name`, `label`) VALUES
('heli', 'Helikopter'),
('plane', 'Flugzeuge');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `billing`
--

CREATE TABLE `billing` (
  `id` int(11) NOT NULL,
  `identifier` varchar(40) NOT NULL,
  `sender` varchar(40) NOT NULL,
  `target_type` varchar(50) NOT NULL,
  `target` varchar(40) NOT NULL,
  `label` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;s
-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `camper_data`
--

CREATE TABLE `camper_data` (
  `item` varchar(255) DEFAULT NULL,
  `count` int(255) DEFAULT NULL,
  `plate` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `casino_cache`
--

CREATE TABLE `casino_cache` (
  `ID` int(11) NOT NULL,
  `Settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_slovak_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `casino_cache`
--

INSERT INTO `casino_cache` (`ID`, `Settings`) VALUES
(1, '{\"PodiumPriceProps\":\"\"}');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `casino_players`
--

CREATE TABLE `casino_players` (
  `ID` int(11) NOT NULL,
  `identifier` varchar(128) NOT NULL,
  `properties` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `casino_players`
--

INSERT INTO `casino_players` (`ID`, `identifier`, `properties`) VALUES
(0, 'steam:11000014b17fd85', '{\"activeTime\":38459051,\"lastSave\":42060384,\"vipUntil\":0,\"luckyWheelCooldownUntil\":1689159526,\"firstTime\":false,\"logins\":11}');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `chico_warehouse`
--

CREATE TABLE `chico_warehouse` (
  `id` int(11) NOT NULL,
  `identifier` varchar(100) DEFAULT NULL,
  `warehouseidentifier` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `pin` varchar(60) DEFAULT NULL,
  `data` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;

--
-- Daten für Tabelle `chico_warehouse`
--

INSERT INTO `chico_warehouse` (`id`, `identifier`, `warehouseidentifier`, `type`, `pin`, `data`) VALUES
(1, 'steam:11000014b17fd85', 1, 3, '1234', '[{\"name\":\"case\",\"label\":\"Case\",\"count\":\"7\",\"type\":\"item\"},{\"name\":\"medikit\",\"label\":\"Verbandskasten\",\"count\":\"7\",\"type\":\"item\"},{\"name\":\"black_money\",\"label\":\"Schwarzgeld\",\"count\":\"6\",\"type\":\"money\"},{\"name\":\"WEAPON_SPECIALCARBINE\",\"label\":\"Spezialkarabiner\",\"count\":\"1\",\"type\":\"weapon\"},{\"name\":\"WEAPON_HEAVYPISTOL\",\"label\":\"Schwere Pistole\",\"count\":\"1\",\"type\":\"weapon\"},{\"name\":\"phone\",\"label\":\"Handy\",\"count\":\"1\",\"type\":\"item\"}]'),
(3, 'steam:11000014180345d', 2, 1, '333', '[]'),
(4, 'steam:11000014bf91daf', 1, 3, '273', '[]'),
(6, 'steam:11000013f2d5d3c', 3, 1, 'emre', '[]'),
(7, 'steam:110000144544cab', 3, 3, '13', '[]'),
(9, 'steam:11000014bf91daf', 3, 3, '330', '[]'),
(10, 'steam:110000116f27ddd', 3, 3, 'ichliebejonah', '[]'),
(11, 'steam:11000013f5b1ce8', 3, 3, '330', '[]');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `codes`
--

CREATE TABLE `codes` (
  `code` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `args1` varchar(255) NOT NULL,
  `args2` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `d-jump`
--

CREATE TABLE `d-jump` (
  `id` int(11) NOT NULL,
  `identifier` varchar(155) DEFAULT NULL,
  `score` int(15) DEFAULT NULL,
  `username` varchar(155) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `d-jump`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `darkchat_messages`
--

CREATE TABLE `darkchat_messages` (
  `id` int(11) NOT NULL,
  `owner` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT '',
  `messages` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `datastore`
--

CREATE TABLE `datastore` (
  `name` varchar(60) NOT NULL,
  `label` varchar(255) NOT NULL,
  `shared` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `datastore`
--

INSERT INTO `datastore` (`name`, `label`, `shared`) VALUES
('motels', 'Motels Datastore', 0),
('motels_bed', 'Motels Bett Datastore', 0),
('property', 'Property', 0),
('society_18th', '18th street', 1),
('society_ambulance', 'Medic', 1),
('society_army', 'Army', 1),
('society_aztecas', 'Aztecas', 1),
('society_ballas', 'Ballas', 1),
('society_bgd', 'BGD', 1),
('society_bloods', 'Bloods', 1),
('society_bratwa', 'Bratwa', 1),
('society_brigada', 'Brigada', 1),
('society_camorra', 'Camorra', 1),
('society_cardealer', 'Concessionnaire', 1),
('society_casino', 'Casino', 1),
('society_crips', 'Crips', 1),
('society_doj', 'DOJ', 1),
('society_fib', 'FIB', 1),
('society_glace', 'Glace', 1),
('society_grove', 'Grove', 1),
('society_grypsera', 'Grypsera', 1),
('society_hoh', 'HoH', 1),
('society_hoover', 'Hoover', 1),
('society_hustlers', 'Hustlers', 1),
('society_irish', 'Irish', 1),
('society_lcn', 'LCN', 1),
('society_lostmc', 'LostMc', 1),
('society_mg13', 'MG13', 1),
('society_midnight', 'Midnight', 1),
('society_ndrangheta', 'Ndrangheta', 1),
('society_orga', 'Organisazija', 1),
('society_peckham', 'Peckham', 1),
('society_police', 'LSPD', 1),
('society_rednecks', 'Rednecks', 1),
('society_rifa', 'Rifa', 1),
('society_sheriff', 'Sheriff', 1),
('society_sinaloa', 'Sinaloa', 1),
('society_triaden', 'Triaden', 1),
('society_tribe', 'Skanidavien Tribe', 1),
('society_unemployed', 'Unemployed', 1),
('society_vagos', 'Vagos', 1),
('society_vatos', 'Vatos', 1),
('society_yakuza', 'Yakuza', 1),
('user_ears', 'Ears', 0),
('user_glasses', 'Glasses', 0),
('user_helmet', 'Helmet', 0),
('user_mask', 'Mask', 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `datastore_data`
--

CREATE TABLE `datastore_data` (
  `id` int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `owner` varchar(60) DEFAULT NULL,
  `data` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_ffa`
--

CREATE TABLE `data_ffa` (
  `zoneID` char(50) DEFAULT NULL,
  `identifier` char(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_minigw`
--

CREATE TABLE `data_minigw` (
  `zoneID` char(50) DEFAULT NULL,
  `identifier` char(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `data_minigw`
--



-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `dnz_casino_reward`
--

CREATE TABLE `dnz_casino_reward` (
  `id` int(11) NOT NULL,
  `identifier` varchar(100) NOT NULL,
  `time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `dnz_donatorcodes`
--

CREATE TABLE `dnz_donatorcodes` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '0',
  `codevalue` int(11) DEFAULT 0,
  `used` int(11) NOT NULL DEFAULT 0,
  `usedbyname` varchar(50) NOT NULL DEFAULT '0',
  `usedby` varchar(50) NOT NULL DEFAULT '0',
  `useddate` varchar(50) DEFAULT NULL,
  `createdby` varchar(50) DEFAULT NULL,
  `createdbyname` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `dnz_donatorcodes`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ffa`
--

CREATE TABLE `ffa` (
  `identifier` char(50) NOT NULL,
  `kills` int(11) DEFAULT NULL,
  `deaths` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `ffa`
--
-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `frakshops`
--

CREATE TABLE `frakshops` (
  `id` int(11) NOT NULL,
  `fraktion` text NOT NULL DEFAULT 'unbesetzt'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `frakshops`
--

INSERT INTO `frakshops` (`id`, `fraktion`) VALUES
(1, 'Vagos'),
(2, 'Vagos'),
(3, 'MG13');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `frak_drugs`
--

CREATE TABLE `frak_drugs` (
  `identifier` varchar(55) NOT NULL,
  `drug` varchar(255) NOT NULL,
  `time` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `frak_drugs`
--

INSERT INTO `frak_drugs` (`identifier`, `drug`, `time`) VALUES
('steam:11000013f1ca8b7', 'kokspack', '1676606657'),
('steam:11000014b26506a', 'lsdpack', '1676334689'),
('steam:11000014f25037f', 'kokspack', '1676424597'),
('steam:11000015a2ad017', 'kokspack', '1676606162');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `frak_labore`
--

CREATE TABLE `frak_labore` (
  `id` int(11) NOT NULL,
  `name` longtext NOT NULL,
  `owner` longtext NOT NULL DEFAULT 'none'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `frak_labore`
--

INSERT INTO `frak_labore` (`id`, `name`, `owner`) VALUES
(0, 'Lsd', 'lcn'),
(1, 'Koks', 'vagos'),
(2, 'Meth', 'ballas'),
(3, 'Ecstasy', 'ballas'),
(4, 'Morphinroute', 'grove');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `frak_shops`
--

CREATE TABLE `frak_shops` (
  `id` int(11) NOT NULL,
  `fraktion` text NOT NULL DEFAULT 'unbesetzt'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `frak_shops`
--

INSERT INTO `frak_shops` (`id`, `fraktion`) VALUES
(1, 'Ballas'),
(2, 'Vagos'),
(3, 'Ballas');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `frak_vehicles`
--

CREATE TABLE `frak_vehicles` (
  `id` int(11) NOT NULL,
  `society` varchar(25) NOT NULL,
  `name` longtext DEFAULT NULL,
  `label` varchar(25) NOT NULL,
  `model` varchar(20) NOT NULL,
  `plate` varchar(100) DEFAULT NULL,
  `tuning` longtext NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gangwar`
--

CREATE TABLE `gangwar` (
  `id` int(11) NOT NULL,
  `name` longtext NOT NULL,
  `owner` longtext NOT NULL DEFAULT 'Unbesetzt',
  `job_name` longtext NOT NULL DEFAULT 'unbesetzt'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `gangwar`
--

INSERT INTO `gangwar` (`id`, `name`, `owner`, `job_name`) VALUES
(1, 'Sandy Landebahn', 'Unbesetzt', 'unbesetzt'),
(2, 'Paleto Bay', 'Unbesetzt', 'unbesetzt'),
(3, 'Mirror Park', 'Unbesetzt', 'unbesetzt'),
(4, 'Lifeinvader', 'Unbesetzt', 'unbesetzt'),
(5, 'Golfplatz', 'Unbesetzt', 'unbesetzt'),
(6, 'Davies', 'Unbesetzt', 'unbesetzt'),
(7, 'Harmony', 'Unbesetzt', 'unbesetzt'),
(8, 'Pipeline', 'Unbesetzt', 'unbesetzt'),
(9, 'Grapeseed Highway', 'Unbesetzt', 'unbesetzt'),
(10, 'Staatsbank', 'Unbesetzt', 'unbesetzt'),
(11, 'Skatepark', 'Unbesetzt', 'unbesetzt'),
(12, 'Pier', 'Unbesetzt', 'unbesetzt'),
(13, 'Hafen', 'Unbesetzt', 'unbesetzt'),
(14, 'Sandy', 'Unbesetzt', 'unbesetzt'),
(15, 'Skatepark', 'Unbesetzt', 'unbesetzt'),
(16, 'Friedhof', 'Unbesetzt', 'unbesetzt'),
(17, 'Theater', 'Unbesetzt', 'unbesetzt'),
(18, 'Pacific Bluffs', 'Unbesetzt', 'unbesetzt'),
(19, 'Windpark', 'Unbesetzt', 'unbesetzt'),
(20, 'Military Base', 'Unbesetzt', 'unbesetzt'),
(21, 'Vinewood Hills', 'Unbesetzt', 'unbesetzt'),
(22, 'Fleischerei', 'Unbesetzt', 'unbesetzt'),
(23, 'Windpark', 'Unbesetzt', 'unbesetzt');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gas_stations`
--

CREATE TABLE `gas_stations` (
  `id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL DEFAULT 'Tankstelle',
  `owner_id` varchar(100) DEFAULT NULL,
  `price_liter` float NOT NULL DEFAULT 0,
  `coordinate_x` double NOT NULL DEFAULT 0,
  `coordinate_y` double NOT NULL DEFAULT 0,
  `coordinate_z` double NOT NULL DEFAULT 0,
  `fuel` double(22,2) DEFAULT 0.00,
  `bank_balance` double(22,2) NOT NULL DEFAULT 10000.00,
  `fuel_limit` double(22,2) DEFAULT 2000.00,
  `buy_price` double(22,2) DEFAULT 3.50
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `gas_stations`
--

INSERT INTO `gas_stations` (`id`, `name`, `owner_id`, `price_liter`, `coordinate_x`, `coordinate_y`, `coordinate_z`, `fuel`, `bank_balance`, `fuel_limit`, `buy_price`) VALUES
(1, 'Tankstelle', NULL, 5, 49.418701171875, 2778.79296875, 58.042999267578125, 1000.00, 10000.00, 2000.00, 3.50),
(2, 'Tankstelle', NULL, 5, 263.8940124511719, 2606.462890625, 44.983001708984375, 912.20, 10439.00, 2000.00, 3.50),
(3, 'Tankstelle', 'steam:110000144544cab', 5, 1039.9580078125, 2671.134033203125, 39.54999923706055, 1000.00, 10000.00, 2000.00, 3.50),
(4, 'Tankstelle', 'steam:110000144544cab', 5, 1207.260009765625, 2660.175048828125, 37.89899826049805, 1000.00, 10000.00, 2000.00, 3.50),
(5, 'Tankstelle', NULL, 5, 2539.68505859375, 2594.19189453125, 37.944000244140625, 949.50, 10252.50, 2000.00, 3.50),
(6, 'Tankstelle', NULL, 5, 2679.85791015625, 3263.946044921875, 55.2400016784668, 916.70, 10416.50, 2000.00, 3.50),
(7, 'Tankstelle', 'steam:110000111b96586', 7, 2005.0550537109375, 3773.886962890625, 32.40299987792969, 1000.00, 0.00, 2000.00, 5.00),
(8, 'Tixmix #1', 'steam:11000013759de60', 200, 1687.156005859375, 4929.39208984375, 42.077999114990234, 902.00, 29600.00, 2000.00, 3.50),
(9, 'Tixmix #1', 'steam:11000013759de60', 5, 1701.31396484375, 6416.02783203125, 32.76300048828125, 913.90, 10430.50, 2000.00, 3.50),
(10, 'Tixmix #1', 'steam:11000013759de60', 5, 179.85699462890625, 6602.8388671875, 31.868000030517578, 1000.00, 10000.00, 2000.00, 3.50),
(11, 'Baby Girl Türkische Prenzessin', 'steam:11000015afe1b18', 1, -94.46189880371094, 6419.59423828125, 31.48900032043457, 1000.00, 100000.00, 2000.00, 1.00),
(12, 'TOTENFICKER', 'steam:11000013f5b1ce8', 200, -2554.99609375, 2334.39990234375, 33.077999114990234, 916.70, 26660.00, 2000.00, 3.50),
(13, 'Tixmix #1', 'steam:11000013759de60', 200, -1800.375, 803.6610107421875, 138.6510009765625, 918.20, 16360.00, 600.00, 200.00),
(14, 'Tankstelle', 'steam:11000014b17fd85', 5, -1437.6219482421875, -276.74700927734375, 46.207000732421875, 603.60, 11982.00, 2000.00, 1.00),
(15, 'Tankstelle', 'steam:110000111b96586', 5, -2096.242919921875, -320.2860107421875, 13.168000221252441, 903.30, 10483.50, 2000.00, 5.00),
(16, 'Tankstelle', 'steam:110000111b96586', 7, -724.6190185546875, -935.1630859375, 19.21299934387207, -2.90, 17020.30, 2000.00, 5.00),
(17, 'Beraat', 'steam:11000015afe1b18', 5, -526.0189819335938, -1211.0030517578125, 18.18400001525879, 586.10, 12069.50, 2000.00, 3.50),
(18, 'Tankstelle', 'steam:11000015301513a', 5, -70.21479797363281, -1761.7919921875, 29.534000396728516, 106.40, 14468.00, 2000.00, 3.50),
(19, 'Tankstelle', 'steam:110000111b96586', 5, 265.64801025390625, -1261.3089599609375, 29.29199981689453, -4.50, 15022.50, 2000.00, 3.50),
(20, 'Deine sichere Tankstelle', 'steam:11000014462f4d3', 6, 819.6530151367188, -1028.845947265625, 26.402999877929688, 583.50, 15499.00, 2000.00, 4.00),
(21, 'Tankstelle', 'steam:11000015afe1b18', 5, 1208.9510498046875, -1402.5670166015625, 35.2239990234375, 724.90, 11375.50, 2000.00, 3.50),
(22, 'chico', 'steam:11000014b17fd85', 5, 1181.3809814453125, -330.84698486328125, 69.31600189208984, 861.20, 16249.00, 1.00, 1.00),
(23, 'Tankstelle', 'steam:11000014b17fd85', 5, 620.843017578125, 269.1000061035156, 103.08899688720703, -3.80, 15019.00, 2000.00, 3.50),
(24, 'Tankstelle', NULL, 5, 2581.321044921875, 362.03900146484375, 108.46800231933594, 903.80, 10481.00, 2000.00, 3.50),
(25, 'Deine sichere Tankstelle', 'steam:11000014462f4d3', 6, 176.63099670410156, -1562.0250244140625, 29.26300048828125, 673.60, 11958.40, 2000.00, 4.00),
(27, 'Tankstelle', NULL, 5, -319.2919921875, -1471.7149658203125, 30.548999786376953, 1000.00, 10000.00, 2000.00, 3.50),
(28, 'Tankstelle', NULL, 5, 1784.323974609375, 3330.550048828125, 41.25299835205078, 771.60, 11142.00, 2000.00, 3.50);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_app_chat`
--

CREATE TABLE `gksphone_app_chat` (
  `id` int(11) NOT NULL,
  `channel` varchar(20) NOT NULL,
  `message` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_bank_transfer`
--

CREATE TABLE `gksphone_bank_transfer` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `identifier` longtext DEFAULT NULL,
  `price` longtext NOT NULL,
  `name` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `gksphone_bank_transfer`
--

INSERT INTO `gksphone_bank_transfer` (`id`, `type`, `identifier`, `price`, `name`, `time`) VALUES
(1, 1, 'steam:11000014b17fd85', '100', 'Valet Fee', '2023-07-01 13:01:26');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_blockednumber`
--

CREATE TABLE `gksphone_blockednumber` (
  `id` int(11) NOT NULL,
  `identifier` longtext NOT NULL,
  `hex` longtext NOT NULL,
  `number` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_calls`
--

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

--
-- Daten für Tabelle `gksphone_calls`
--

INSERT INTO `gksphone_calls` (`id`, `owner`, `num`, `incoming`, `time`, `accepts`) VALUES
(1, '6614562', '5565643', 1, '2023-07-01 13:03:50', 1),
(2, '5565643', '6614562', 0, '2023-07-01 13:03:50', 1),
(3, '6614562', '5565643', 1, '2023-07-01 13:03:51', 1),
(4, '5565643', '6614562', 0, '2023-07-01 13:03:51', 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_gallery`
--

CREATE TABLE `gksphone_gallery` (
  `id` int(11) NOT NULL,
  `hex` longtext NOT NULL,
  `image` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_gotur`
--

CREATE TABLE `gksphone_gotur` (
  `id` int(11) NOT NULL,
  `label` longtext NOT NULL,
  `price` int(11) DEFAULT 0,
  `count` int(11) NOT NULL,
  `item` longtext NOT NULL,
  `kapat` varchar(50) DEFAULT 'false',
  `adet` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_gps`
--

CREATE TABLE `gksphone_gps` (
  `id` int(11) NOT NULL,
  `hex` longtext NOT NULL,
  `nott` longtext DEFAULT NULL,
  `gps` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_group_message`
--

CREATE TABLE `gksphone_group_message` (
  `id` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(50) NOT NULL,
  `groupname` varchar(255) NOT NULL,
  `messages` longtext NOT NULL,
  `contacts` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_insto_accounts`
--

CREATE TABLE `gksphone_insto_accounts` (
  `id` int(11) NOT NULL,
  `forename` longtext NOT NULL,
  `surname` longtext NOT NULL,
  `username` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` longtext NOT NULL,
  `avatar_url` longtext DEFAULT NULL,
  `takip` longtext DEFAULT '[]'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_insto_instas`
--

CREATE TABLE `gksphone_insto_instas` (
  `id` int(11) NOT NULL,
  `authorId` int(11) NOT NULL,
  `realUser` longtext DEFAULT NULL,
  `message` longtext NOT NULL,
  `image` longtext NOT NULL,
  `filters` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_insto_likes`
--

CREATE TABLE `gksphone_insto_likes` (
  `id` int(11) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `inapId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_insto_story`
--

CREATE TABLE `gksphone_insto_story` (
  `id` int(11) NOT NULL,
  `authorId` int(11) NOT NULL,
  `realUser` longtext DEFAULT NULL,
  `stories` longtext NOT NULL,
  `isRead` varchar(256) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_job_message`
--

CREATE TABLE `gksphone_job_message` (
  `id` int(11) NOT NULL,
  `name` longtext NOT NULL,
  `number` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `photo` longtext DEFAULT NULL,
  `gps` varchar(255) NOT NULL,
  `owner` int(11) NOT NULL DEFAULT 0,
  `jobm` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_mails`
--

CREATE TABLE `gksphone_mails` (
  `id` int(11) NOT NULL,
  `citizenid` varchar(255) NOT NULL DEFAULT '0',
  `sender` varchar(255) NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL DEFAULT '0',
  `image` text NOT NULL,
  `message` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_messages`
--

CREATE TABLE `gksphone_messages` (
  `id` int(11) NOT NULL,
  `transmitter` varchar(50) NOT NULL,
  `receiver` varchar(50) NOT NULL,
  `message` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `isRead` int(11) NOT NULL DEFAULT 0,
  `owner` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_messages_group`
--

CREATE TABLE `gksphone_messages_group` (
  `id` int(11) NOT NULL,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(50) NOT NULL,
  `groupname` varchar(255) NOT NULL,
  `gimage` longtext NOT NULL,
  `contacts` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_news`
--

CREATE TABLE `gksphone_news` (
  `id` int(11) NOT NULL,
  `hex` longtext DEFAULT NULL,
  `haber` longtext DEFAULT NULL,
  `baslik` longtext DEFAULT NULL,
  `resim` longtext DEFAULT NULL,
  `video` longtext DEFAULT NULL,
  `zaman` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_tinderacc`
--

CREATE TABLE `gksphone_tinderacc` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `passaword` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `identifier` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_tindermatch`
--

CREATE TABLE `gksphone_tindermatch` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `friend_id` int(11) NOT NULL DEFAULT 0,
  `is_match` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_tindermessage`
--

CREATE TABLE `gksphone_tindermessage` (
  `id` int(11) NOT NULL,
  `message` text NOT NULL,
  `tinderes` text NOT NULL,
  `owner` int(11) NOT NULL DEFAULT 0,
  `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_twitter_accounts`
--

CREATE TABLE `gksphone_twitter_accounts` (
  `id` int(11) NOT NULL,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `password` varchar(64) NOT NULL DEFAULT '0',
  `avatar_url` longtext DEFAULT NULL,
  `profilavatar` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_twitter_likes`
--

CREATE TABLE `gksphone_twitter_likes` (
  `id` int(11) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `tweetId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_twitter_tweets`
--

CREATE TABLE `gksphone_twitter_tweets` (
  `id` int(11) NOT NULL,
  `authorId` int(11) NOT NULL,
  `realUser` varchar(50) DEFAULT NULL,
  `message` varchar(256) NOT NULL,
  `image` longtext DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_vehicle_sales`
--

CREATE TABLE `gksphone_vehicle_sales` (
  `id` int(11) NOT NULL,
  `owner` longtext NOT NULL,
  `ownerphone` varchar(255) NOT NULL,
  `plate` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `image` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `gksphone_yellow`
--

CREATE TABLE `gksphone_yellow` (
  `id` int(11) NOT NULL,
  `phone_number` varchar(50) DEFAULT NULL,
  `firstname` varchar(256) DEFAULT NULL,
  `lastname` varchar(256) DEFAULT NULL,
  `message` longtext NOT NULL,
  `image` longtext DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `instagram_account`
--

CREATE TABLE `instagram_account` (
  `id` varchar(90) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `avatar` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `verify` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `instagram_followers`
--

CREATE TABLE `instagram_followers` (
  `username` varchar(50) NOT NULL,
  `followed` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `instagram_posts`
--

CREATE TABLE `instagram_posts` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `image` text NOT NULL,
  `description` varchar(255) NOT NULL,
  `location` varchar(50) NOT NULL,
  `filter` varchar(50) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `likes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `instagram_stories`
--

CREATE TABLE `instagram_stories` (
  `owner` varchar(50) NOT NULL,
  `data` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=armscii8 COLLATE=armscii8_bin;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `insta_stories`
--

CREATE TABLE `insta_stories` (
  `username` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `filter` varchar(50) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `items`
--

CREATE TABLE `items` (
  `name` varchar(50) NOT NULL,
  `label` varchar(50) NOT NULL,
  `limit` int(11) NOT NULL DEFAULT -1,
  `rare` int(11) NOT NULL DEFAULT 0,
  `can_remove` int(11) NOT NULL DEFAULT 1,
  `weight` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `items`
--

INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`, `weight`) VALUES
('algen', 'Algen', -1, 0, 1, 1),
('armybulletproof', 'Army Schutzweste', -1, 0, 1, 1),
('baggy', 'Baggy', -1, 0, 1, 1),
('bandage', 'Bandage', -1, 0, 1, 1),
('batterie', 'Batterie', -1, 0, 1, 1),
('beer', 'Beer', 6, 0, 1, 1),
('black_phone', 'Black Phone', -1, 0, 1, 10),
('blue_phone', 'Blue Phone', -1, 0, 1, 10),
('bread', 'Bread', -1, 0, 1, 1),
('brechstange', 'Brechstange', -1, 0, 1, 1),
('bulletproof', 'Schutzweste', -1, 0, 1, 1),
('case', 'Case', -1, 0, 1, 1),
('casino_beer', 'Casino Beer', -1, 0, 1, 0),
('casino_burger', 'Casino Burger', -1, 0, 1, 0),
('casino_chips', 'Casino Chips', -1, 0, 1, 0),
('casino_coffee', 'Casino Coffee', -1, 0, 1, 0),
('casino_coke', 'Casino Kofola', -1, 0, 1, 0),
('casino_donut', 'Casino Donut', -1, 0, 1, 0),
('casino_ego_chaser', 'Casino Ego Chaser', -1, 0, 1, 0),
('casino_luckypotion', 'Casino Lucky Potion', -1, 0, 1, 0),
('casino_psqs', 'Casino Ps & Qs', -1, 0, 1, 0),
('casino_sandwitch', 'Casino Sandwitch', -1, 0, 1, 0),
('casino_sprite', 'Casino Sprite', -1, 0, 1, 0),
('classic_phone', 'Classic Phone', -1, 0, 1, 10),
('dailycase', 'Dailycase', -1, 0, 1, 1),
('drogenkiste', 'Drogenkiste', -1, 0, 1, 1),
('ecstasy', 'Ecstasy', -1, 0, 1, 1),
('ecstasypulver', 'Ecstasy Pulver', -1, 0, 1, 1),
('ehering', 'Ehering', -1, 0, 1, 1),
('eisenerz', 'Eisenerz', -1, 0, 1, 1),
('ephedrin', 'Ephedrin', -1, 0, 1, 1),
('erstehilfekoffer', 'Erstehilfekoffer', -1, 0, 1, 1),
('fackel', 'Fackel', -1, 0, 1, 1),
('fernglas', 'Fernglas', -1, 0, 1, 1),
('fibbulletproof', 'FIB Schutzweste', -1, 0, 1, 1),
('fish', 'Fisch', -1, 0, 1, 1),
('fishbait', 'Fisch Köder', -1, 0, 1, 1),
('fishingrod', 'Angel', -1, 0, 1, 1),
('froesche', 'Frösche', -1, 0, 1, 1),
('frosch', 'Frosch', -1, 0, 1, 1),
('gold', 'Gold', -1, 0, 1, 1),
('goldbarren', 'Goldbarren', -1, 0, 1, 1),
('gold_phone', 'Gold Phone', -1, 0, 1, 10),
('greenlight_phone', 'Green Light Phone', -1, 0, 1, 10),
('green_phone', 'Green Phone', -1, 0, 1, 10),
('heroinpack', 'Heroinpack', -1, 0, 1, 1),
('joint', 'Joint', -1, 0, 1, 1),
('kabelbinder', 'Kabelbinder', -1, 0, 1, 1),
('kevlar', 'Kevlar', -1, 0, 1, 1),
('koks', 'Koks', -1, 0, 1, 1),
('koksblatt', 'Koksblatt', -1, 0, 1, 1),
('kokspack', 'Kokspack', -1, 0, 1, 1),
('krokodil', 'Krokodil', -1, 0, 1, 1),
('kupferbarren', 'Kupferbarren', -1, 0, 1, 1),
('kupfererz', 'Kupfererz', -1, 0, 1, 1),
('lootdropkiste', 'Loodrop Kisten', -1, 0, 1, 1),
('lsd', 'Lsd', -1, 0, 1, 1),
('lsdpack', 'Lsd Pack', -1, 0, 1, 1),
('lspdbulletproof', 'LSPD Schutzweste', -1, 0, 1, 1),
('medikit', 'Verbandskasten', -1, 0, 1, 1),
('mehl', 'Mehl', -1, 0, 1, 1),
('metall', 'Metall', -1, 0, 1, 1),
('meth', 'Meth', -1, 0, 1, 1),
('methbag', 'Meth Pack', -1, 0, 1, 1),
('morphin', 'Morphin', -1, 0, 1, 1),
('phone', 'Handy', -1, 0, 1, 1),
('phone_hack', 'Phone Hack', -1, 0, 1, 10),
('phone_module', 'Phone Module', -1, 0, 1, 10),
('pink_phone', 'Pink Phone', -1, 0, 1, 10),
('pulver', 'Pulver', -1, 0, 1, 1),
('purple_phone', 'Purple Phone', -1, 0, 1, 10),
('red_phone', 'Red Phone', -1, 0, 1, 10),
('repairkit', 'Reparaturkasten', -1, 0, 1, 1),
('ring', 'Ring', -1, 0, 1, 1),
('rotwein', 'Rotwein', -1, 0, 1, 1),
('sand', 'Sand', -1, 0, 1, 1),
('schalli', 'Schalldämpfer', -1, 0, 1, 1),
('schere', 'Schere', -1, 0, 1, 1),
('schraube', 'Schraube', -1, 0, 1, 1),
('schraubenschluessel', 'Schraubenschlüssel', -1, 0, 1, 1),
('schwamm', 'Schwamm', -1, 0, 1, 1),
('schweissgeraet', 'Schweißgerät', -1, 0, 1, 1),
('scratch_ticket', 'Rubbelos', -1, 0, 1, 1),
('shark', 'Hai', -1, 0, 1, 1),
('sheriffbulletproof', 'LSSD Schutzweste', -1, 0, 1, 1),
('sickle', 'Sichel', -1, 0, 1, 1),
('spitzhacke', 'Spitzhacke', -1, 0, 1, 1),
('spray', 'Spray', -1, 0, 1, 1),
('spray_remover', 'Spray entferner', -1, 0, 1, 1),
('stahl', 'Stahl', -1, 0, 1, 1),
('stein', 'Stein', -1, 0, 1, 1),
('tabak', 'Tabak', -1, 0, 1, 1),
('tequila', 'Tequila', 2, 0, 1, 1),
('turtle', 'Schildkröte', -1, 0, 1, 1),
('turtlebait', 'Schildkröten Köder', -1, 0, 1, 1),
('vodka', 'Vodka', 2, 0, 1, 1),
('waffenbox_advancedrifle', 'WaffenBox_ADV', -1, 0, 1, 1),
('waffenbox_assaultrifle', 'WaffenBox_AK', -1, 0, 1, 1),
('waffenbox_assaultrifle_mk2', 'WaffenBox_AK_MK2', -1, 0, 1, 1),
('waffenbox_bat', 'WaffenBox_BaseBall', -1, 0, 1, 1),
('waffenbox_bottle', 'WaffenBox_Flasche', -1, 0, 1, 1),
('waffenbox_bullpuprifle', 'WaffenBox_BullpupRifle', -1, 0, 1, 1),
('waffenbox_bullpuprifle_mk2', 'WaffenBox_Bullpuprifle_MK2', -1, 0, 1, 1),
('waffenbox_carbinerifle', 'WaffenBox_Karabiner', -1, 0, 1, 1),
('waffenbox_carbinerifle_mk2', 'WaffenBox_Karabiner_MK2', -1, 0, 1, 1),
('waffenbox_specialcarbine', 'WaffenBox_Spezi', -1, 0, 1, 1),
('waffenbox_specialcarbine_mk2', 'WaffenBox_Spezi_MK2', -1, 0, 1, 1),
('waffenteile', 'Waffenteile', -1, 0, 1, 1),
('water', 'Water', -1, 0, 1, 1),
('weed', 'Weed', -1, 0, 1, 1),
('weedpack', 'Weedpack', -1, 0, 1, 1),
('WeihnachtsCase', 'WeihnachtsCase', -1, 0, 1, 1),
('weintrauben', 'Weintrauben', -1, 0, 1, 1),
('weizen', 'Weizen', -1, 0, 1, 1),
('wet_black_phone', 'Wet Black Phone', -1, 0, 1, 10),
('wet_blue_phone', 'Wet Blue Phone', -1, 0, 1, 10),
('wet_classic_phone', 'Wet Classic Phone', -1, 0, 1, 10),
('wet_gold_phone', 'Wet Gold Phone', -1, 0, 1, 10),
('wet_greenlight_phone', 'Wet Green Light Phone', -1, 0, 1, 10),
('wet_green_phone', 'Wet Green Phone', -1, 0, 1, 10),
('wet_pink_phone', 'Wet Pink Phone', -1, 0, 1, 10),
('wet_purple_phone', 'Wet Purple Phone', -1, 0, 1, 10),
('wet_red_phone', 'Wet Red Phone', -1, 0, 1, 10),
('wet_white_phone', 'Wet White Phone', -1, 0, 1, 10),
('whisky', 'Whisky', 2, 0, 1, 1),
('white_phone', 'White Phone', -1, 0, 1, 10),
('wine', 'Wine', 2, 0, 1, 1),
('wuerfel', 'Würfel', -1, 0, 1, 1),
('zigarette', 'Zigarette', -1, 0, 1, 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `jobs`
--

CREATE TABLE `jobs` (
  `name` varchar(50) NOT NULL,
  `label` varchar(50) DEFAULT NULL,
  `whitelisted` int(1) DEFAULT 0,
  `lagerhalle` int(1) NOT NULL DEFAULT 0,
  `handyservice` varchar(2) NOT NULL DEFAULT '0',
  `hasapp` int(2) NOT NULL DEFAULT 0,
  `onlyboss` int(2) NOT NULL DEFAULT 0,
  `number` varchar(10) NOT NULL DEFAULT '1',
  `motdchange` varchar(155) DEFAULT '',
  `motd` varchar(155) DEFAULT '',
  `member` varchar(11) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `jobs`
--

INSERT INTO `jobs` (`name`, `label`, `whitelisted`, `lagerhalle`, `handyservice`, `hasapp`, `onlyboss`, `number`, `motdchange`, `motd`, `member`) VALUES
('ambulance', 'LSMD', 0, 1, '0', 0, 0, '1', '', '', ''),
('army', 'Army', 0, 0, '0', 0, 0, '1', '', '', ''),
('aztecas', 'Aztecas', 0, 1, '0', 0, 0, '1', '', '', ''),
('bahama', 'Bahama', 0, 0, '0', 0, 0, '1', '', '', ''),
('ballas', 'Ballas', 0, 1, '0', 0, 0, '1', '', '', ''),
('bgd', 'BGD', 1, 0, '0', 0, 0, '1', '', '', ''),
('bloods', 'Bloods', 1, 1, '0', 0, 0, '1', '', '', ''),
('bratwa', 'Bratwa', 0, 0, '0', 0, 0, '1', '', '', ''),
('brigada', 'Brigada', 1, 0, '0', 0, 0, '1', '', '', ''),
('cardealer', 'Concessionnaire', 0, 0, '0', 0, 0, '1', '', '', ''),
('casino', 'Casino', 1, 0, '0', 0, 0, '1', '', '', ''),
('doj', 'DOJ', 1, 0, '0', 0, 0, '1', '', '', ''),
('fib', 'FIB', 1, 0, '0', 0, 0, '1', '', '', ''),
('glace', 'Glace', 1, 0, '0', 0, 0, '1', '', '', ''),
('grove', 'Grove', 0, 1, '0', 0, 0, '1', '', '', ''),
('grypsera', 'Grypsera', 1, 0, '0', 0, 0, '1', '', '', ''),
('hoh', 'HoH', 1, 1, '0', 0, 0, '1', '', '', ''),
('hoover', 'Hoover', 0, 1, '0', 0, 0, '1', '', '', ''),
('hustlers', 'Hustlers', 0, 1, '0', 0, 0, '1', '', '', ''),
('irish', 'Irish', 0, 0, '0', 0, 0, '1', '', '', ''),
('jokerz', 'Jokerz', 1, 1, '0', 0, 0, '1', '', '', ''),
('lcn', 'LCN', 0, 1, '0', 0, 0, '1', '', '', ''),
('lostmc', 'LostMC', 0, 1, '0', 0, 0, '1', '', '', ''),
('mg13', 'MG13', 1, 1, '0', 0, 0, '1', '', '', ''),
('midnight', 'Midnight', 0, 1, '0', 0, 0, '1', '', '', ''),
('orga', 'Organisazija', 0, 1, '0', 0, 0, '1', '', '', ''),
('peckham', 'Peckham', 1, 1, '0', 0, 0, '1', '', '', ''),
('police', 'LSPD', 0, 0, '0', 0, 0, '1', '', '', ''),
('rednecks', 'Rednecks', 0, 1, '0', 0, 0, '1', '', '', ''),
('refiner', 'Raffinerie', 0, 0, '0', 0, 0, '1', '', '', ''),
('rifa', 'Rifa', 1, 1, '0', 0, 0, '1', '', '', ''),
('sheriff', 'Sheriff', 1, 0, '0', 0, 0, '1', '', '', ''),
('sinaloa', 'Sinaloa', 1, 1, '0', 0, 0, '1', '', '', ''),
('triaden', 'Triaden', 0, 1, '0', 0, 0, '1', '', '', ''),
('tribe', 'Skanidavien Tribe', 1, 1, '0', 0, 0, '1', '', '', ''),
('unemployed', 'Unemployed', 0, 0, '0', 0, 0, '1', '', '', ''),
('vagos', 'Vagos', 1, 1, '0', 0, 0, '1', '', '', ''),
('vatos', 'Vatos', 1, 1, '0', 0, 0, '1', '', '', ''),
('yakuza', 'Yakuza', 0, 0, '0', 0, 0, '1', '', '', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `job_grades`
--

CREATE TABLE `job_grades` (
  `id` int(11) NOT NULL,
  `job_name` varchar(50) DEFAULT NULL,
  `grade` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `label` varchar(50) NOT NULL,
  `salary` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `job_grades`
--

INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`) VALUES
(1, 'unemployed', 0, 'unemployed', 'Unemployed', 50),
(4, 'lostmc', 0, 'member', 'Member', 50),
(5, 'lostmc', 1, 'boss', 'Leader', 50),
(10, 'grove', 1, 'boss', 'Leader', 50),
(11, 'grove', 0, 'member', 'Member', 50),
(12, 'vagos', 0, 'member', 'Member', 50),
(13, 'vagos', 1, 'boss', 'Leader', 50),
(14, 'brigada', 1, 'boss', 'leader', 50),
(15, 'brigada', 0, 'member', 'member', 50),
(18, 'bloods', 1, 'boss', 'Leader', 50),
(19, 'bloods', 0, 'member', 'Member', 50),
(20, 'midnight', 1, 'boss', 'Leader', 50),
(21, 'midnight', 0, 'member', 'Member', 50),
(22, 'lcn', 1, 'boss', 'Leader', 50),
(23, 'lcn', 0, 'member', 'member', 50),
(26, 'orga', 1, 'boss', 'Leader', 50),
(27, 'orga', 0, 'member', 'Member', 50),
(28, 'triaden', 1, 'boss', 'Leader', 50),
(29, 'triaden', 0, 'member', 'Member', 50),
(30, 'yakuza', 1, 'boss', 'Leader', 50),
(31, 'yakuza', 0, 'member', 'Member', 50),
(34, 'aztecas', 1, 'boss', 'Leader', 50),
(35, 'aztecas', 0, 'member', 'Member', 50),
(36, 'ballas', 1, 'boss', 'Leader', 50),
(37, 'ballas', 0, 'member', 'Member', 50),
(38, 'rednecks', 0, 'member', 'Member', 50),
(39, 'rednecks', 1, 'boss', 'Leader', 50),
(40, 'ambulance', 0, 'ambulance', 'Mediziner', 500),
(41, 'ambulance', 1, 'doctor', 'Doktor', 750),
(42, 'ambulance', 2, 'chiefdoctor', 'Chefarzt', 750),
(43, 'ambulance', 3, 'boss', 'Chef', 4000),
(53, 'police', 0, 'member', 'Rekrut', 500),
(54, 'police', 1, 'swat', 'Swat', 750),
(55, 'police', 2, 'leader', 'Leader', 750),
(56, 'police', 3, 'boss', 'Chief of Police', 750),
(68, 'army', 0, 'member', 'Member', 500),
(69, 'army', 1, 'leader', 'leader', 750),
(70, 'army', 2, 'boss', 'Boss', 750),
(74, 'hustlers', 1, 'boss', 'Leader', 50),
(75, 'hustlers', 0, 'member', 'Member', 50),
(76, 'irish', 1, 'boss', 'Leader', 50),
(77, 'irish', 0, 'member', 'Member', 50),
(78, 'bratwa', 1, 'boss', 'Leader', 50),
(79, 'bratwa', 0, 'member', 'Member', 50),
(84, 'hoover', 1, 'boss', 'Leader', 50),
(85, 'hoover', 0, 'member', 'Member', 50),
(86, 'casino', 0, 'guard', 'Sicherheitsdienst', 50),
(87, 'casino', 1, 'croupier', 'Croupier', 50),
(88, 'casino', 2, 'boss', 'Besitzer', 50),
(89, 'bahama', 0, 'member', 'Angestellter', 50),
(90, 'bahama', 1, 'boss', 'Boss', 50),
(91, 'hoh', 0, 'member', 'Member', 50),
(92, 'hoh', 1, 'boss', 'Leader', 50),
(93, 'peckham', 0, 'member', 'Member', 50),
(94, 'peckham', 1, 'boss', 'Leader', 50),
(95, 'mg13', 0, 'member', 'Member', 50),
(96, 'mg13', 1, 'boss', 'Leader', 50),
(97, 'sheriff', 0, 'member', 'Member', 500),
(98, 'sheriff', 1, 'boss', 'Leader', 750),
(99, 'sheriff', 2, 'boss', 'Boss', 750),
(100, 'fib', 0, 'member', 'Member', 500),
(101, 'fib', 1, 'boss', 'Leader', 750),
(102, 'fib', 2, 'boss', 'Boss', 750),
(103, 'doj', 0, 'member', 'Member', 500),
(104, 'doj', 1, 'boss', 'Leader', 500),
(105, 'doj', 2, 'boss', 'Präsident', 750),
(106, 'glace', 0, 'member', 'Member', 50),
(107, 'glace', 1, 'boss', 'Leader', 50),
(108, 'rifa', 0, 'member', 'Member', 50),
(109, 'rifa', 1, 'boss', 'Leader', 50),
(110, 'vatos', 0, 'member', 'Member', 50),
(111, 'vatos', 1, 'boss', 'Leader', 50),
(112, 'sinaloa', 0, 'member', 'Member', 50),
(113, 'sinaloa', 1, 'boss', 'Leader', 50),
(114, 'grypsera', 0, 'member', 'Member', 50),
(115, 'grypsera', 1, 'boss', 'Leader', 50),
(116, 'tribe', 0, 'member', 'Member', 50),
(117, 'tribe', 1, 'boss', 'Leader', 50),
(118, 'bgd', 0, 'member', 'Member', 50),
(119, 'bgd', 1, 'boss', 'Leader', 50),
(120, 'jokerz', 0, 'member', 'Member', 50),
(121, 'jokerz', 1, 'boss', 'Leader', 50),
(122, 'mg13', 0, 'member', 'Member', 500),
(123, 'mg13', 1, 'boss', 'Leader', 500);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `leaderboard`
--

CREATE TABLE `leaderboard` (
  `id` int(11) NOT NULL,
  `identifier` text DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `kills` int(11) DEFAULT NULL,
  `deaths` int(11) DEFAULT NULL,
  `score` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `licenses`
--

CREATE TABLE `licenses` (
  `type` varchar(60) NOT NULL,
  `label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `licenses`
--

INSERT INTO `licenses` (`type`, `label`) VALUES
('dmv', 'Theorie Lizenz'),
('drive', 'PKW-Lizenz'),
('drive_bike', 'Motorrad-Lizenz'),
('drive_truck', 'LKW-Lizenz'),
('ehk', 'EHK-Lizenz');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `marktplatz`
--

CREATE TABLE `marktplatz` (
  `id` int(11) NOT NULL,
  `identifier` varchar(60) NOT NULL,
  `name` varchar(60) NOT NULL,
  `label` varchar(60) NOT NULL,
  `count` varchar(60) NOT NULL,
  `price` varchar(60) NOT NULL,
  `description` varchar(60) NOT NULL,
  `sold` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `motels`
--

CREATE TABLE `motels` (
  `id` bigint(255) NOT NULL,
  `ident` varchar(50) NOT NULL,
  `motel_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nkn_sportsbet_adminpanel`
--

CREATE TABLE `nkn_sportsbet_adminpanel` (
  `gameid` varchar(255) NOT NULL,
  `creatoridentifier` varchar(255) DEFAULT NULL,
  `creatorname` varchar(255) DEFAULT NULL,
  `teamonename` varchar(255) DEFAULT NULL,
  `teamonewappen` varchar(255) DEFAULT NULL,
  `teamonequote` varchar(255) DEFAULT NULL,
  `teamtwoname` varchar(255) DEFAULT NULL,
  `teamtwowappen` varchar(255) DEFAULT NULL,
  `teamtwoquote` varchar(255) DEFAULT NULL,
  `xquote` varchar(255) DEFAULT NULL,
  `liganame` varchar(255) DEFAULT NULL,
  `ligawappen` varchar(255) DEFAULT NULL,
  `starttime` varchar(255) DEFAULT NULL,
  `starttimeh` int(11) DEFAULT NULL,
  `starttimem` int(11) DEFAULT NULL,
  `endedgame` int(11) NOT NULL DEFAULT 0,
  `winner` varchar(50) DEFAULT NULL,
  `startetgame` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nkn_sportsbet_bets`
--

CREATE TABLE `nkn_sportsbet_bets` (
  `scheinid` varchar(255) NOT NULL,
  `identifier` varchar(50) DEFAULT NULL,
  `schein` longtext DEFAULT NULL,
  `winlose` varchar(50) DEFAULT NULL,
  `einsatz` int(11) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_bank_logs`
--

CREATE TABLE `nova_phone_bank_logs` (
  `id` int(11) NOT NULL,
  `sender` text NOT NULL,
  `receiver` text NOT NULL,
  `amount` int(11) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_bank_logs`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_calllogs`
--

CREATE TABLE `nova_phone_calllogs` (
  `id` int(11) NOT NULL,
  `caller` text NOT NULL,
  `target` text NOT NULL,
  `accepted` tinyint(4) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_calllogs`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_contacts`
--

CREATE TABLE `nova_phone_contacts` (
  `id` int(11) NOT NULL,
  `user` text NOT NULL,
  `name` text NOT NULL,
  `image` text NOT NULL,
  `notice` text NOT NULL,
  `number` text NOT NULL,
  `favorite` tinyint(4) NOT NULL DEFAULT 0,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_contacts`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_factionmotd`
--

CREATE TABLE `nova_phone_factionmotd` (
  `id` int(11) NOT NULL,
  `faction` text NOT NULL,
  `motd` text NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_factionmotd`
--

INSERT INTO `nova_phone_factionmotd` (`id`, `faction`, `motd`, `createdAt`) VALUES
(74, 'ambulance', 'FUNKPFLICHT\nFunk = 2', '2023-07-01 15:20:35'),
(75, 'army', 'unser funk ist kanal 9', '2023-07-01 15:20:35'),
(76, 'aztecas', 'None', '2023-07-01 15:20:35'),
(77, 'bahama', 'None', '2023-07-01 15:20:35'),
(78, 'ballas', 'Funk 73.21', '2023-07-01 15:20:35'),
(79, 'bgd', 'None', '2023-07-01 15:20:35'),
(80, 'bloods', 'None', '2023-07-01 15:20:35'),
(81, 'bratwa', 'None', '2023-07-01 15:20:35'),
(82, 'brigada', 'FUNK 871', '2023-07-01 15:20:35'),
(83, 'casino', 'None', '2023-07-01 15:20:35'),
(84, 'cardealer', 'None', '2023-07-01 15:20:35'),
(85, 'doj', 'None', '2023-07-01 15:20:35'),
(86, 'fib', ' Funk: 5 Funkpflicht!\n', '2023-07-01 15:20:35'),
(87, 'glace', 'Funk : 183 \n\nGlace auf die 1 ihr wixxer', '2023-07-01 15:20:35'),
(88, 'grove', 'funk 435\n', '2023-07-01 15:20:35'),
(89, 'grypsera', 'None', '2023-07-01 15:20:35'),
(90, 'hoh', 'None', '2023-07-01 15:20:35'),
(91, 'hoover', 'Funk: 17.24', '2023-07-01 15:20:35'),
(92, 'hustlers', 'None', '2023-07-01 15:20:35'),
(93, 'irish', 'None', '2023-07-01 15:20:35'),
(94, 'lcn', 'Funk: 999!!!!', '2023-07-01 15:20:35'),
(95, 'lostmc', 'Funk : 31.31', '2023-07-01 15:20:35'),
(96, 'mg13', 'Funk: 69.187', '2023-07-01 15:20:35'),
(97, 'midnight', 'Funk: 1337\nFUNK IST PFLICHT wenn mann on ist und in gw ist ', '2023-07-01 15:20:35'),
(98, 'orga', '', '2023-07-01 15:20:35'),
(99, 'peckham', 'None', '2023-07-01 15:20:35'),
(100, 'police', 'PD Funk     : 1', '2023-07-01 15:20:35'),
(101, 'rednecks', 'None', '2023-07-01 15:20:35'),
(102, 'refiner', 'None', '2023-07-01 15:20:35'),
(103, 'rifa', 'None', '2023-07-01 15:20:35'),
(104, 'sheriff', 'SD FUNK: 6987', '2023-07-01 15:20:35'),
(105, 'sinaloa', 'FUNK: 10.29', '2023-07-01 15:20:35'),
(106, 'triaden', 'Funk 939', '2023-07-01 15:20:35'),
(107, 'tribe', 'Funk: 1875', '2023-07-01 15:20:35'),
(108, 'unemployed', 'None', '2023-07-01 15:20:35'),
(109, 'vagos', 'Funk : 94.02\n', '2023-07-01 15:20:35'),
(110, 'vatos', 'None', '2023-07-01 15:20:35'),
(111, 'yakuza', 'Funk 449 !', '2023-07-01 15:20:35'),
(112, 'jokerz', 'None', '2023-07-03 17:37:44');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_frakbank`
--

CREATE TABLE `nova_phone_frakbank` (
  `id` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `faction` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_frakbank`
--

INSERT INTO `nova_phone_frakbank` (`id`, `money`, `faction`) VALUES
(86, 0, 'ambulance'),
(87, 20000, 'army'),
(88, 0, 'aztecas'),
(89, 0, 'bahama'),
(90, 0, 'ballas'),
(91, 0, 'bgd'),
(92, 0, 'bloods'),
(93, 0, 'bratwa'),
(94, 0, 'brigada'),
(95, 0, 'cardealer'),
(96, 0, 'casino'),
(97, 0, 'doj'),
(98, 1, 'fib'),
(99, 0, 'glace'),
(100, 0, 'grove'),
(101, 0, 'grypsera'),
(102, 0, 'hoh'),
(103, 0, 'hoover'),
(104, 0, 'hustlers'),
(105, 0, 'irish'),
(106, 0, 'lcn'),
(107, 100711421, 'lostmc'),
(108, 3000, 'mg13'),
(109, 9555, 'midnight'),
(110, 0, 'orga'),
(111, 0, 'peckham'),
(112, 0, 'police'),
(113, 0, 'rednecks'),
(114, 0, 'refiner'),
(115, 0, 'rifa'),
(116, 2, 'sheriff'),
(117, 0, 'sinaloa'),
(118, 0, 'triaden'),
(119, 0, 'tribe'),
(120, 0, 'unemployed'),
(121, 650000, 'vagos'),
(122, 0, 'vatos'),
(123, 1, 'yakuza'),
(124, 0, 'jokerz');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_messages`
--

CREATE TABLE `nova_phone_messages` (
  `id` int(11) NOT NULL,
  `sender` text NOT NULL,
  `number` text NOT NULL,
  `message` text NOT NULL,
  `isGPS` tinyint(4) NOT NULL DEFAULT 0,
  `isImage` tinyint(4) NOT NULL DEFAULT 0,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Daten für Tabelle `nova_phone_messages`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `nova_phone_snake`
--

CREATE TABLE `nova_phone_snake` (
  `id` int(11) NOT NULL,
  `player` text NOT NULL,
  `score` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `nova_phone_snake`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `owned_vehicles`
--

CREATE TABLE `owned_vehicles` (
  `owner` varchar(60) NOT NULL,
  `plate` varchar(12) NOT NULL,
  `vehicle` longtext DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'car',
  `job` varchar(20) DEFAULT NULL,
  `stored` tinyint(1) NOT NULL DEFAULT 0,
  `isFav` int(1) NOT NULL DEFAULT 0,
  `nickname` varchar(255) DEFAULT NULL,
  `carseller` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `owned_vehicles`
--
-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pcomputer_akten`
--

CREATE TABLE `pcomputer_akten` (
  `id` int(11) NOT NULL,
  `char_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `incident` longtext DEFAULT NULL,
  `charges` longtext DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pcomputer_haftbefehle`
--

CREATE TABLE `pcomputer_haftbefehle` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `char_id` int(11) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  `report_title` varchar(255) DEFAULT NULL,
  `charges` longtext DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `expire` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pcomputer_persuche`
--

CREATE TABLE `pcomputer_persuche` (
  `id` int(11) NOT NULL,
  `char_id` int(11) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `mugshot_url` varchar(255) DEFAULT NULL,
  `bail` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pcomputer_vehsuche`
--

CREATE TABLE `pcomputer_vehsuche` (
  `id` int(11) NOT NULL,
  `plate` varchar(255) DEFAULT NULL,
  `stolen` bit(1) DEFAULT b'0',
  `notes` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pcomputer_verbrechen`
--

CREATE TABLE `pcomputer_verbrechen` (
  `id` int(11) NOT NULL,
  `char_id` int(11) DEFAULT NULL,
  `offense` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_accounts`
--

CREATE TABLE `phone_accounts` (
  `app` varchar(50) NOT NULL,
  `id` varchar(80) NOT NULL,
  `name` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `birthdate` varchar(50) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `interested` text NOT NULL,
  `avatar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_alertjobs`
--

CREATE TABLE `phone_alertjobs` (
  `id` int(11) NOT NULL,
  `job` varchar(255) NOT NULL,
  `alerts` text DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_chatrooms`
--

CREATE TABLE `phone_chatrooms` (
  `id` int(10) UNSIGNED NOT NULL,
  `room_code` varchar(10) NOT NULL,
  `room_name` varchar(15) NOT NULL,
  `room_owner_id` varchar(50) DEFAULT NULL,
  `room_owner_name` varchar(60) DEFAULT NULL,
  `room_members` text DEFAULT NULL,
  `room_pin` varchar(50) DEFAULT NULL,
  `unpaid_balance` decimal(10,2) DEFAULT 0.00,
  `is_masked` tinyint(1) DEFAULT 0,
  `is_pinned` tinyint(1) DEFAULT 0,
  `created` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `phone_chatrooms`
--

INSERT INTO `phone_chatrooms` (`id`, `room_code`, `room_name`, `room_owner_id`, `room_owner_name`, `room_members`, `room_pin`, `unpaid_balance`, `is_masked`, `is_pinned`, `created`) VALUES
(1, 'social', 'Social', 'official', 'Government', NULL, NULL, 0.00, 0, 1, '2023-07-01 15:09:44'),
(2, 'lounge', 'The Lounge', 'official', 'Government', NULL, NULL, 0.00, 0, 1, '2023-07-01 15:09:44'),
(3, 'events', 'Events', 'official', 'Government', NULL, NULL, 0.00, 0, 1, '2023-07-01 15:09:44');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_chatroom_messages`
--

CREATE TABLE `phone_chatroom_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `room_id` int(10) UNSIGNED DEFAULT NULL,
  `member_id` varchar(50) DEFAULT NULL,
  `member_name` varchar(50) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `is_pinned` tinyint(1) DEFAULT 0,
  `created` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_chats`
--

CREATE TABLE `phone_chats` (
  `app` varchar(50) NOT NULL,
  `author` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL,
  `created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_invoices`
--

CREATE TABLE `phone_invoices` (
  `id` int(10) NOT NULL,
  `citizenid` varchar(50) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `society` tinytext DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `sendercitizenid` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_messages`
--

CREATE TABLE `phone_messages` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `number` varchar(50) NOT NULL,
  `owner` varchar(50) DEFAULT NULL,
  `messages` text NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `read` int(11) DEFAULT NULL,
  `created` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phone_notifies`
--

CREATE TABLE `phone_notifies` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `msg_content` text NOT NULL,
  `msg_head` varchar(50) NOT NULL DEFAULT '',
  `app_name` text NOT NULL,
  `msg_time` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `player_contacts`
--

CREATE TABLE `player_contacts` (
  `id` int(11) NOT NULL,
  `identifier` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `number` varchar(50) DEFAULT NULL,
  `iban` varchar(50) NOT NULL DEFAULT '0',
  `display` varchar(50) DEFAULT NULL,
  `note` text NOT NULL,
  `pp` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `player_gallery`
--

CREATE TABLE `player_gallery` (
  `id` int(11) NOT NULL,
  `identifier` text NOT NULL,
  `resim` text NOT NULL,
  `data` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `player_mails`
--

CREATE TABLE `player_mails` (
  `id` int(11) NOT NULL,
  `identifier` varchar(50) DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `subject` varchar(50) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `read` tinyint(4) DEFAULT 0,
  `mailid` int(11) DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp(),
  `button` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `player_notes`
--

CREATE TABLE `player_notes` (
  `id` int(11) NOT NULL,
  `identifier` text NOT NULL,
  `baslik` text NOT NULL,
  `aciklama` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `simple_lagerhalle`
--

CREATE TABLE `simple_lagerhalle` (
  `identifier` varchar(255) DEFAULT NULL,
  `items` longtext DEFAULT NULL CHECK (json_valid(`items`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `simple_lagerhalle`
--

INSERT INTO `simple_lagerhalle` (`identifier`, `items`) VALUES
('steam:11000014b17fd85', '[]');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `simple_lagerhallen`
--

CREATE TABLE `simple_lagerhallen` (
  `identifier` varchar(255) DEFAULT NULL,
  `lagerName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `simple_lagerhallen`
--

INSERT INTO `simple_lagerhallen` (`identifier`, `lagerName`) VALUES
('steam:11000014b17fd85', 'Lagerhalle');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `simple_lagerhallen_transactions`
--

CREATE TABLE `simple_lagerhallen_transactions` (
  `identifier` varchar(255) DEFAULT NULL,
  `datum` varchar(255) DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `art` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `simple_lagerhallen_transactions`
--

INSERT INTO `simple_lagerhallen_transactions` (`identifier`, `datum`, `item`, `price`, `art`) VALUES
('steam:11000014b17fd85', '11.06.2023', 'Lagerhalle', 570000, 'Kauf');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sprays`
--

CREATE TABLE `sprays` (
  `id` int(11) NOT NULL,
  `x` float(8,4) NOT NULL,
  `y` float(8,4) NOT NULL,
  `z` float(8,4) NOT NULL,
  `rx` float(8,4) NOT NULL,
  `ry` float(8,4) NOT NULL,
  `rz` float(8,4) NOT NULL,
  `scale` float(8,4) NOT NULL,
  `text` varchar(32) NOT NULL,
  `font` varchar(32) NOT NULL,
  `color` int(3) NOT NULL,
  `interior` int(3) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tinder_accounts`
--

CREATE TABLE `tinder_accounts` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL DEFAULT '0',
  `pp` text NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '0',
  `gender` varchar(50) NOT NULL,
  `targetGender` varchar(50) NOT NULL DEFAULT '0',
  `hobbies` varchar(50) NOT NULL DEFAULT '0',
  `age` varchar(50) NOT NULL DEFAULT '0',
  `description` varchar(50) NOT NULL DEFAULT '0',
  `password` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tinder_likes`
--

CREATE TABLE `tinder_likes` (
  `id` int(11) NOT NULL,
  `phone` varchar(1024) NOT NULL,
  `likeds` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tinder_messages`
--

CREATE TABLE `tinder_messages` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL,
  `messages` varchar(1024) DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `trucks`
--

CREATE TABLE `trucks` (
  `name` varchar(60) NOT NULL,
  `model` varchar(60) NOT NULL,
  `price` int(11) NOT NULL,
  `category` varchar(60) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `trucks`
--

INSERT INTO `trucks` (`name`, `model`, `price`, `category`) VALUES
('Airport Bus', 'airbus', 50000, 'trans'),
('Benson', 'benson', 55000, 'box'),
('Biff', 'biff', 30000, 'other'),
('Boxville 1', 'boxville', 45000, 'box'),
('Boxville 2', 'boxville2', 45000, 'box'),
('Boxville 3', 'boxville3', 45000, 'box'),
('Boxville 4', 'boxville4', 45000, 'box'),
('Dozer', 'bulldozer', 20000, 'other'),
('Bus', 'bus', 50000, 'trans'),
('Dashound', 'coach', 50000, 'trans'),
('Hauler', 'hauler', 100000, 'haul'),
('Mixer 1', 'mixer', 30000, 'other'),
('Mixer 2', 'mixer2', 30000, 'other'),
('Mule 1', 'mule', 40000, 'box'),
('Mule 2', 'mule2', 40000, 'box'),
('Mule 3', 'mule3', 40000, 'box'),
('Packer', 'packer', 100000, 'haul'),
('Festival Bus', 'pbus2', 125000, 'trans'),
('Phantom', 'phantom', 105000, 'haul'),
('Phantom Custom', 'phantom3', 110000, 'haul'),
('Pounder', 'pounder', 55000, 'box'),
('Rental Bus', 'rentalbus', 35000, 'trans'),
('Rubble', 'rubble', 30000, 'other'),
('Scrap Truck', 'scrap', 10000, 'other'),
('Tipper 1', 'tiptruck', 30000, 'other'),
('Tipper 2', 'tiptruck2', 30000, 'other'),
('Tour Bus', 'tourbus', 35000, 'trans'),
('Field Master', 'tractor2', 15000, 'other');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `truck_categories`
--

CREATE TABLE `truck_categories` (
  `name` varchar(60) NOT NULL,
  `label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `truck_categories`
--

INSERT INTO `truck_categories` (`name`, `label`) VALUES
('box', 'Boxed Trucks'),
('haul', 'Haulers'),
('other', 'Other Trucks'),
('trans', 'Transport Trucks');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `trunk_inventory`
--

CREATE TABLE `trunk_inventory` (
  `id` int(11) NOT NULL,
  `plate` varchar(12) NOT NULL,
  `data` text NOT NULL,
  `owned` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `trunk_inventory`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `twitter_account`
--

CREATE TABLE `twitter_account` (
  `id` varchar(90) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `avatar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `twitter_hashtags`
--

CREATE TABLE `twitter_hashtags` (
  `id` int(11) NOT NULL,
  `name` varchar(80) NOT NULL,
  `created` varchar(50) NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `twitter_mentions`
--

CREATE TABLE `twitter_mentions` (
  `id` int(11) NOT NULL,
  `id_tweet` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `mentioned` text NOT NULL,
  `created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `twitter_tweets`
--

CREATE TABLE `twitter_tweets` (
  `id` int(5) NOT NULL,
  `username` varchar(80) NOT NULL,
  `message` longtext NOT NULL,
  `hashtags` varchar(50) NOT NULL,
  `mentions` varchar(50) NOT NULL,
  `created` varchar(50) NOT NULL,
  `image` text NOT NULL,
  `likes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `users`
--

CREATE TABLE `users` (
  `id` int(255) NOT NULL,
  `identifier` varchar(50) NOT NULL,
  `steamname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accounts` longtext DEFAULT NULL,
  `job` varchar(50) DEFAULT 'unemployed',
  `job_grade` int(11) DEFAULT 0,
  `inventory` longtext DEFAULT NULL,
  `loadout` longtext DEFAULT NULL,
  `group` varchar(50) DEFAULT 'user',
  `firstname` varchar(50) DEFAULT '',
  `lastname` varchar(50) DEFAULT '',
  `dateofbirth` varchar(25) DEFAULT '',
  `***` varchar(10) DEFAULT '',
  `height` varchar(5) DEFAULT '',
  `is_dead` tinyint(1) DEFAULT 0,
  `last_property` varchar(255) DEFAULT 'none',
  `tattoos` longtext DEFAULT NULL,
  `jail` int(11) NOT NULL DEFAULT 0,
  `neu` int(1) DEFAULT 1,
  `playtime` int(100) NOT NULL DEFAULT 0,
  `position` varchar(255) DEFAULT '{"x":-1139.0469,"y":-2807.3494,"z":27.7088,"heading":236.3182}',
  `skin` longtext DEFAULT NULL,
  `phone_number` longtext DEFAULT NULL,
  `fraksperre` varchar(50) DEFAULT NULL,
  `fps` int(1) DEFAULT 0,
  `reward` int(1) DEFAULT NULL,
  `geschwindigkeit` varchar(100) NOT NULL DEFAULT '100',
  `armor` int(2) NOT NULL DEFAULT 0,
  `tobias_guide` int(11) DEFAULT 0,
  `status` longtext DEFAULT NULL,
  `dnz_coins` int(255) DEFAULT 0,
  `dnz_coins_spent` int(255) DEFAULT 0,
  `phone_number2` varchar(10) DEFAULT '1',
  `last_motel` varchar(50) DEFAULT NULL,
  `last_motel_room` varchar(50) DEFAULT NULL,
  `einreise` int(1) NOT NULL DEFAULT 0,
  `apps` text DEFAULT NULL,
  `widget` text DEFAULT NULL,
  `bt` text DEFAULT NULL,
  `charinfo` text DEFAULT NULL,
  `metadata` mediumtext DEFAULT NULL,
  `cryptocurrency` longtext DEFAULT NULL,
  `cryptocurrencytransfers` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Daten für Tabelle `users`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `user_licenses`
--

CREATE TABLE `user_licenses` (
  `id` int(11) NOT NULL,
  `type` varchar(60) NOT NULL,
  `owner` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `user_licenses`
--
-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `vehicle_keys`
--

CREATE TABLE `vehicle_keys` (
  `id` int(11) NOT NULL,
  `identifier` varchar(22) NOT NULL,
  `plate` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `weaponcraft`
--

CREATE TABLE `weaponcraft` (
  `job` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` tinyint(4) DEFAULT 0,
  `crafted` tinyint(4) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `weaponcraft`
--

INSERT INTO `weaponcraft` (`job`, `level`, `crafted`) VALUES
('ambulance', 0, 0),
('army', 0, 0),
('aztecas', 19, 14),
('ballas', 18, 1),
('bgd', 2, 4),
('bloods', 0, 1),
('bratwa', 5, 0),
('brigada', 30, 12),
('casino', 0, 0),
('doj', 0, 0),
('fib', 0, 8),
('glace', 8, 3),
('grove', 15, 8),
('grypsera', 2, 13),
('hoh', 3, 0),
('hoover', 8, 3),
('hustlers', 11, 5),
('irish', 1, 5),
('jokerz', 0, 0),
('lcn', 25, 4),
('lostmc', 23, 13),
('mg13', 22, 3),
('midnight', 32, 2),
('orga', 16, 9),
('peckham', 5, 0),
('police', 0, 0),
('rednecks', 4, 8),
('rifa', 28, 5),
('sheriff', 0, 0),
('sinaloa', 7, 6),
('triaden', 12, 7),
('tribe', 22, 13),
('unemployed', 0, 7),
('vagos', 47, 0),
('vatos', 5, 0),
('yakuza', 4, 3);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_accounts`
--

CREATE TABLE `whatsapp_accounts` (
  `id` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `avatar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_chats`
--

CREATE TABLE `whatsapp_chats` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL,
  `created` varchar(50) NOT NULL,
  `messages` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_groups`
--

CREATE TABLE `whatsapp_groups` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `image` text NOT NULL,
  `created` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_groups_messages`
--

CREATE TABLE `whatsapp_groups_messages` (
  `id` int(11) NOT NULL,
  `id_group` varchar(50) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `created` varchar(50) NOT NULL,
  `read` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_groups_users`
--

CREATE TABLE `whatsapp_groups_users` (
  `number_group` varchar(50) NOT NULL,
  `admin` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `whatsapp_stories`
--

CREATE TABLE `whatsapp_stories` (
  `phone` varchar(50) NOT NULL,
  `image` text NOT NULL,
  `created` varchar(50) NOT NULL,
  `description` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `filter` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `yellowpages_posts`
--

CREATE TABLE `yellowpages_posts` (
  `id` int(11) NOT NULL,
  `owner` text NOT NULL,
  `mesaj` text NOT NULL,
  `isim` text NOT NULL,
  `telno` text NOT NULL,
  `resim` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `addon_account`
--
ALTER TABLE `addon_account`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `addon_account_data`
--
ALTER TABLE `addon_account_data`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `addon_inventory`
--
ALTER TABLE `addon_inventory`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `addon_inventory_items`
--
ALTER TABLE `addon_inventory_items`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `aircrafts`
--
ALTER TABLE `aircrafts`
  ADD PRIMARY KEY (`name`);

--
-- Indizes für die Tabelle `billing`
--
ALTER TABLE `billing`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `casino_cache`
--
ALTER TABLE `casino_cache`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `casino_players`
--
ALTER TABLE `casino_players`
  ADD PRIMARY KEY (`ID`);

--
-- Indizes für die Tabelle `chico_warehouse`
--
ALTER TABLE `chico_warehouse`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `codes`
--
ALTER TABLE `codes`
  ADD PRIMARY KEY (`code`);

--
-- Indizes für die Tabelle `d-jump`
--
ALTER TABLE `d-jump`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `darkchat_messages`
--
ALTER TABLE `darkchat_messages`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `id` (`id`) USING BTREE;

--
-- Indizes für die Tabelle `datastore`
--
ALTER TABLE `datastore`
  ADD PRIMARY KEY (`name`);

--
-- Indizes für die Tabelle `datastore_data`
--
ALTER TABLE `datastore_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `index_datastore_data_name_owner` (`name`,`owner`),
  ADD KEY `index_datastore_data_name` (`name`);

--
-- Indizes für die Tabelle `dnz_casino_reward`
--
ALTER TABLE `dnz_casino_reward`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `dnz_donatorcodes`
--
ALTER TABLE `dnz_donatorcodes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `frakshops`
--
ALTER TABLE `frakshops`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `frak_drugs`
--
ALTER TABLE `frak_drugs`
  ADD PRIMARY KEY (`identifier`);

--
-- Indizes für die Tabelle `frak_labore`
--
ALTER TABLE `frak_labore`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `frak_shops`
--
ALTER TABLE `frak_shops`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `frak_vehicles`
--
ALTER TABLE `frak_vehicles`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gangwar`
--
ALTER TABLE `gangwar`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gas_stations`
--
ALTER TABLE `gas_stations`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gksphone_app_chat`
--
ALTER TABLE `gksphone_app_chat`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gksphone_bank_transfer`
--
ALTER TABLE `gksphone_bank_transfer`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_blockednumber`
--
ALTER TABLE `gksphone_blockednumber`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_calls`
--
ALTER TABLE `gksphone_calls`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gksphone_gallery`
--
ALTER TABLE `gksphone_gallery`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_gotur`
--
ALTER TABLE `gksphone_gotur`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_gps`
--
ALTER TABLE `gksphone_gps`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_group_message`
--
ALTER TABLE `gksphone_group_message`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `groupid` (`groupid`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_insto_accounts`
--
ALTER TABLE `gksphone_insto_accounts`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `username` (`username`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_insto_instas`
--
ALTER TABLE `gksphone_insto_instas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_gksphone_insto_instas_gksphone_insto_accounts` (`authorId`);

--
-- Indizes für die Tabelle `gksphone_insto_likes`
--
ALTER TABLE `gksphone_insto_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_gksphone_insto_likes_gksphone_insto_accounts` (`authorId`),
  ADD KEY `FK_gksphone_insto_likes_gksphone_insto_instas` (`inapId`);

--
-- Indizes für die Tabelle `gksphone_insto_story`
--
ALTER TABLE `gksphone_insto_story`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `FK_gksphone_insto_story_gksphone_insto_accounts` (`authorId`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_job_message`
--
ALTER TABLE `gksphone_job_message`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_mails`
--
ALTER TABLE `gksphone_mails`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_messages`
--
ALTER TABLE `gksphone_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `gksphone_messages_group`
--
ALTER TABLE `gksphone_messages_group`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_news`
--
ALTER TABLE `gksphone_news`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_tinderacc`
--
ALTER TABLE `gksphone_tinderacc`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_tindermatch`
--
ALTER TABLE `gksphone_tindermatch`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_tindermessage`
--
ALTER TABLE `gksphone_tindermessage`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_twitter_accounts`
--
ALTER TABLE `gksphone_twitter_accounts`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `username` (`username`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_twitter_likes`
--
ALTER TABLE `gksphone_twitter_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_gksphone_twitter_likes_gksphone_twitter_accounts` (`authorId`),
  ADD KEY `FK_gksphone_twitter_likes_gksphone_twitter_tweets` (`tweetId`);

--
-- Indizes für die Tabelle `gksphone_twitter_tweets`
--
ALTER TABLE `gksphone_twitter_tweets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_gksphone_twitter_tweets_gksphone_twitter_accounts` (`authorId`);

--
-- Indizes für die Tabelle `gksphone_vehicle_sales`
--
ALTER TABLE `gksphone_vehicle_sales`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `gksphone_yellow`
--
ALTER TABLE `gksphone_yellow`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `instagram_posts`
--
ALTER TABLE `instagram_posts`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `instagram_stories`
--
ALTER TABLE `instagram_stories`
  ADD PRIMARY KEY (`owner`) USING BTREE;

--
-- Indizes für die Tabelle `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`name`);

--
-- Indizes für die Tabelle `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`name`) USING BTREE;

--
-- Indizes für die Tabelle `job_grades`
--
ALTER TABLE `job_grades`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `id` (`id`) USING BTREE;

--
-- Indizes für die Tabelle `leaderboard`
--
ALTER TABLE `leaderboard`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `licenses`
--
ALTER TABLE `licenses`
  ADD PRIMARY KEY (`type`);

--
-- Indizes für die Tabelle `marktplatz`
--
ALTER TABLE `marktplatz`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `identifier` (`identifier`),
  ADD KEY `label` (`label`),
  ADD KEY `name` (`name`),
  ADD KEY `count` (`count`),
  ADD KEY `price` (`price`),
  ADD KEY `description` (`description`),
  ADD KEY `sold` (`sold`);

--
-- Indizes für die Tabelle `motels`
--
ALTER TABLE `motels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `motel_id` (`motel_id`),
  ADD KEY `ident` (`ident`);

--
-- Indizes für die Tabelle `nkn_sportsbet_adminpanel`
--
ALTER TABLE `nkn_sportsbet_adminpanel`
  ADD PRIMARY KEY (`gameid`);

--
-- Indizes für die Tabelle `nkn_sportsbet_bets`
--
ALTER TABLE `nkn_sportsbet_bets`
  ADD PRIMARY KEY (`scheinid`);

--
-- Indizes für die Tabelle `nova_phone_bank_logs`
--
ALTER TABLE `nova_phone_bank_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_calllogs`
--
ALTER TABLE `nova_phone_calllogs`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_contacts`
--
ALTER TABLE `nova_phone_contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_factionmotd`
--
ALTER TABLE `nova_phone_factionmotd`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_frakbank`
--
ALTER TABLE `nova_phone_frakbank`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_messages`
--
ALTER TABLE `nova_phone_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `nova_phone_snake`
--
ALTER TABLE `nova_phone_snake`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `owned_vehicles`
--
ALTER TABLE `owned_vehicles`
  ADD PRIMARY KEY (`plate`),
  ADD KEY `job` (`job`);

--
-- Indizes für die Tabelle `pcomputer_akten`
--
ALTER TABLE `pcomputer_akten`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `pcomputer_haftbefehle`
--
ALTER TABLE `pcomputer_haftbefehle`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `pcomputer_persuche`
--
ALTER TABLE `pcomputer_persuche`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `pcomputer_vehsuche`
--
ALTER TABLE `pcomputer_vehsuche`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `pcomputer_verbrechen`
--
ALTER TABLE `pcomputer_verbrechen`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `phone_alertjobs`
--
ALTER TABLE `phone_alertjobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `job` (`job`);

--
-- Indizes für die Tabelle `phone_chatrooms`
--
ALTER TABLE `phone_chatrooms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `room_code` (`room_code`);

--
-- Indizes für die Tabelle `phone_chatroom_messages`
--
ALTER TABLE `phone_chatroom_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `phone_invoices`
--
ALTER TABLE `phone_invoices`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `phone_messages`
--
ALTER TABLE `phone_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `phone_notifies`
--
ALTER TABLE `phone_notifies`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `player_contacts`
--
ALTER TABLE `player_contacts`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `identifier` (`identifier`) USING BTREE;

--
-- Indizes für die Tabelle `player_gallery`
--
ALTER TABLE `player_gallery`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `player_mails`
--
ALTER TABLE `player_mails`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `identifier` (`identifier`) USING BTREE;

--
-- Indizes für die Tabelle `player_notes`
--
ALTER TABLE `player_notes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `simple_lagerhalle`
--
ALTER TABLE `simple_lagerhalle`
  ADD UNIQUE KEY `identifier` (`identifier`);

--
-- Indizes für die Tabelle `sprays`
--
ALTER TABLE `sprays`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `tinder_accounts`
--
ALTER TABLE `tinder_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `tinder_likes`
--
ALTER TABLE `tinder_likes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `tinder_messages`
--
ALTER TABLE `tinder_messages`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `trucks`
--
ALTER TABLE `trucks`
  ADD PRIMARY KEY (`model`);

--
-- Indizes für die Tabelle `truck_categories`
--
ALTER TABLE `truck_categories`
  ADD PRIMARY KEY (`name`);

--
-- Indizes für die Tabelle `trunk_inventory`
--
ALTER TABLE `trunk_inventory`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plate` (`plate`);

--
-- Indizes für die Tabelle `twitter_hashtags`
--
ALTER TABLE `twitter_hashtags`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `twitter_mentions`
--
ALTER TABLE `twitter_mentions`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indizes für die Tabelle `twitter_tweets`
--
ALTER TABLE `twitter_tweets`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `identifier` (`identifier`);

--
-- Indizes für die Tabelle `user_licenses`
--
ALTER TABLE `user_licenses`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `vehicle_keys`
--
ALTER TABLE `vehicle_keys`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `weaponcraft`
--
ALTER TABLE `weaponcraft`
  ADD PRIMARY KEY (`job`);

--
-- Indizes für die Tabelle `whatsapp_chats`
--
ALTER TABLE `whatsapp_chats`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `whatsapp_groups`
--
ALTER TABLE `whatsapp_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `whatsapp_groups_messages`
--
ALTER TABLE `whatsapp_groups_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `yellowpages_posts`
--
ALTER TABLE `yellowpages_posts`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `addon_account`
--
ALTER TABLE `addon_account`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT für Tabelle `addon_account_data`
--
ALTER TABLE `addon_account_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21361;

--
-- AUTO_INCREMENT für Tabelle `addon_inventory`
--
ALTER TABLE `addon_inventory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT für Tabelle `addon_inventory_items`
--
ALTER TABLE `addon_inventory_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=166;

--
-- AUTO_INCREMENT für Tabelle `billing`
--
ALTER TABLE `billing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=519;

--
-- AUTO_INCREMENT für Tabelle `casino_cache`
--
ALTER TABLE `casino_cache`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `chico_warehouse`
--
ALTER TABLE `chico_warehouse`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT für Tabelle `d-jump`
--
ALTER TABLE `d-jump`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT für Tabelle `darkchat_messages`
--
ALTER TABLE `darkchat_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT für Tabelle `datastore_data`
--
ALTER TABLE `datastore_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46872;

--
-- AUTO_INCREMENT für Tabelle `dnz_casino_reward`
--
ALTER TABLE `dnz_casino_reward`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `dnz_donatorcodes`
--
ALTER TABLE `dnz_donatorcodes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT für Tabelle `frak_vehicles`
--
ALTER TABLE `frak_vehicles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=231;

--
-- AUTO_INCREMENT für Tabelle `gangwar`
--
ALTER TABLE `gangwar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT für Tabelle `gas_stations`
--
ALTER TABLE `gas_stations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT für Tabelle `gksphone_app_chat`
--
ALTER TABLE `gksphone_app_chat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_bank_transfer`
--
ALTER TABLE `gksphone_bank_transfer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `gksphone_blockednumber`
--
ALTER TABLE `gksphone_blockednumber`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_calls`
--
ALTER TABLE `gksphone_calls`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT für Tabelle `gksphone_gallery`
--
ALTER TABLE `gksphone_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_gotur`
--
ALTER TABLE `gksphone_gotur`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_gps`
--
ALTER TABLE `gksphone_gps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_group_message`
--
ALTER TABLE `gksphone_group_message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_insto_accounts`
--
ALTER TABLE `gksphone_insto_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_insto_instas`
--
ALTER TABLE `gksphone_insto_instas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_insto_likes`
--
ALTER TABLE `gksphone_insto_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_insto_story`
--
ALTER TABLE `gksphone_insto_story`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_job_message`
--
ALTER TABLE `gksphone_job_message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_mails`
--
ALTER TABLE `gksphone_mails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_messages`
--
ALTER TABLE `gksphone_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_messages_group`
--
ALTER TABLE `gksphone_messages_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_news`
--
ALTER TABLE `gksphone_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_tinderacc`
--
ALTER TABLE `gksphone_tinderacc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_tindermatch`
--
ALTER TABLE `gksphone_tindermatch`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_tindermessage`
--
ALTER TABLE `gksphone_tindermessage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_twitter_accounts`
--
ALTER TABLE `gksphone_twitter_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_twitter_likes`
--
ALTER TABLE `gksphone_twitter_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_twitter_tweets`
--
ALTER TABLE `gksphone_twitter_tweets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_vehicle_sales`
--
ALTER TABLE `gksphone_vehicle_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `gksphone_yellow`
--
ALTER TABLE `gksphone_yellow`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `instagram_posts`
--
ALTER TABLE `instagram_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT für Tabelle `job_grades`
--
ALTER TABLE `job_grades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

--
-- AUTO_INCREMENT für Tabelle `leaderboard`
--
ALTER TABLE `leaderboard`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `marktplatz`
--
ALTER TABLE `marktplatz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2730;

--
-- AUTO_INCREMENT für Tabelle `motels`
--
ALTER TABLE `motels`
  MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_bank_logs`
--
ALTER TABLE `nova_phone_bank_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2770;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_calllogs`
--
ALTER TABLE `nova_phone_calllogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9420;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_contacts`
--
ALTER TABLE `nova_phone_contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=387;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_factionmotd`
--
ALTER TABLE `nova_phone_factionmotd`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_frakbank`
--
ALTER TABLE `nova_phone_frakbank`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_messages`
--
ALTER TABLE `nova_phone_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2625;

--
-- AUTO_INCREMENT für Tabelle `nova_phone_snake`
--
ALTER TABLE `nova_phone_snake`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=429;

--
-- AUTO_INCREMENT für Tabelle `pcomputer_akten`
--
ALTER TABLE `pcomputer_akten`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `pcomputer_haftbefehle`
--
ALTER TABLE `pcomputer_haftbefehle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `pcomputer_persuche`
--
ALTER TABLE `pcomputer_persuche`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `pcomputer_vehsuche`
--
ALTER TABLE `pcomputer_vehsuche`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `pcomputer_verbrechen`
--
ALTER TABLE `pcomputer_verbrechen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `phone_alertjobs`
--
ALTER TABLE `phone_alertjobs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `phone_chatrooms`
--
ALTER TABLE `phone_chatrooms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT für Tabelle `phone_chatroom_messages`
--
ALTER TABLE `phone_chatroom_messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `phone_invoices`
--
ALTER TABLE `phone_invoices`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `phone_messages`
--
ALTER TABLE `phone_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT für Tabelle `phone_notifies`
--
ALTER TABLE `phone_notifies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT für Tabelle `player_contacts`
--
ALTER TABLE `player_contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT für Tabelle `player_gallery`
--
ALTER TABLE `player_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT für Tabelle `player_mails`
--
ALTER TABLE `player_mails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `player_notes`
--
ALTER TABLE `player_notes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `sprays`
--
ALTER TABLE `sprays`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=586;

--
-- AUTO_INCREMENT für Tabelle `tinder_accounts`
--
ALTER TABLE `tinder_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT für Tabelle `tinder_likes`
--
ALTER TABLE `tinder_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT für Tabelle `tinder_messages`
--
ALTER TABLE `tinder_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT für Tabelle `trunk_inventory`
--
ALTER TABLE `trunk_inventory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4617;

--
-- AUTO_INCREMENT für Tabelle `twitter_hashtags`
--
ALTER TABLE `twitter_hashtags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT für Tabelle `twitter_mentions`
--
ALTER TABLE `twitter_mentions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT für Tabelle `twitter_tweets`
--
ALTER TABLE `twitter_tweets`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT für Tabelle `users`
--
ALTER TABLE `users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102652;

--
-- AUTO_INCREMENT für Tabelle `user_licenses`
--
ALTER TABLE `user_licenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7641;

--
-- AUTO_INCREMENT für Tabelle `vehicle_keys`
--
ALTER TABLE `vehicle_keys`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `whatsapp_chats`
--
ALTER TABLE `whatsapp_chats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT für Tabelle `whatsapp_groups`
--
ALTER TABLE `whatsapp_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT für Tabelle `whatsapp_groups_messages`
--
ALTER TABLE `whatsapp_groups_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `yellowpages_posts`
--
ALTER TABLE `yellowpages_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `gksphone_group_message`
--
ALTER TABLE `gksphone_group_message`
  ADD CONSTRAINT `FK_phonegroupmessage` FOREIGN KEY (`groupid`) REFERENCES `gksphone_messages_group` (`id`);

--
-- Constraints der Tabelle `gksphone_insto_instas`
--
ALTER TABLE `gksphone_insto_instas`
  ADD CONSTRAINT `FK_gksphone_insto_instas_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`);

--
-- Constraints der Tabelle `gksphone_insto_likes`
--
ALTER TABLE `gksphone_insto_likes`
  ADD CONSTRAINT `FK_gksphone_insto_likes_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`),
  ADD CONSTRAINT `FK_gksphone_insto_likes_gksphone_insto_instas` FOREIGN KEY (`inapId`) REFERENCES `gksphone_insto_instas` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `gksphone_insto_story`
--
ALTER TABLE `gksphone_insto_story`
  ADD CONSTRAINT `FK_gksphone_insto_story_gksphone_insto_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_insto_accounts` (`id`);

--
-- Constraints der Tabelle `gksphone_twitter_likes`
--
ALTER TABLE `gksphone_twitter_likes`
  ADD CONSTRAINT `FK_gksphone_twitter_likes_gksphone_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_twitter_accounts` (`id`),
  ADD CONSTRAINT `FK_gksphone_twitter_likes_gksphone_twitter_tweets` FOREIGN KEY (`tweetId`) REFERENCES `gksphone_twitter_tweets` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `gksphone_twitter_tweets`
--
ALTER TABLE `gksphone_twitter_tweets`
  ADD CONSTRAINT `FK_gksphone_twitter_tweets_gksphone_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `gksphone_twitter_accounts` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;