-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : lun. 25 jan. 2021 à 11:11
-- Version du serveur :  10.4.17-MariaDB
-- Version de PHP : 8.0.0

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 */;

--
-- Base de données : `testdev1`
--

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

--
-- Structure de la table `owned_vehicles`
--

CREATE TABLE `owned_vehicles` (
  `owner` varchar(40) NOT NULL,
  `plate` varchar(12) NOT NULL,
  `vehicle` longtext DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'car',
  `job` varchar(20) NOT NULL DEFAULT 'civ',
  `category` varchar(50) DEFAULT NULL,
  `name` varchar(60) NOT NULL DEFAULT 'Unknown',
  `fuel` int(11) NOT NULL DEFAULT 100,
  `stored` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `owned_vehicles`
--

INSERT INTO `owned_vehicles` (`owner`, `plate`, `vehicle`, `type`, `job`, `category`, `name`, `fuel`, `stored`) VALUES
('steam:110000113ffea41', 'BJA 010', '{\"modRoof\":-1,\"modTrimB\":-1,\"modFrontWheels\":-1,\"modRightFender\":-1,\"modTank\":-1,\"modBrakes\":-1,\"modDoorSpeaker\":-1,\"modBackWheels\":-1,\"modSeats\":-1,\"modTransmission\":-1,\"bodyHealth\":994.5,\"modOrnaments\":-1,\"windowTint\":-1,\"extras\":{\"10\":false,\"12\":false},\"modWindows\":-1,\"neonEnabled\":[false,false,false,false],\"modExhaust\":-1,\"modHorns\":-1,\"modSmokeEnabled\":false,\"modEngineBlock\":-1,\"modSuspension\":-1,\"modTrimA\":-1,\"fuelLevel\":97.7,\"modSteeringWheel\":-1,\"modArchCover\":-1,\"modFrontBumper\":-1,\"modSideSkirt\":-1,\"dirtLevel\":6.3,\"modAirFilter\":-1,\"modAerials\":-1,\"modShifterLeavers\":-1,\"modXenon\":false,\"engineHealth\":992.5,\"modTurbo\":false,\"modRearBumper\":-1,\"color2\":0,\"color1\":0,\"modDashboard\":-1,\"modGrille\":-1,\"modFrame\":-1,\"wheels\":3,\"tyreSmokeColor\":[255,255,255],\"modHydrolic\":-1,\"modAPlate\":-1,\"wheelColor\":156,\"modEngine\":-1,\"modPlateHolder\":-1,\"modVanityPlate\":-1,\"modSpeakers\":-1,\"modArmor\":-1,\"modSpoilers\":-1,\"plate\":\"BJA 010\",\"modFender\":-1,\"modTrunk\":-1,\"model\":142944341,\"pearlescentColor\":3,\"modDial\":-1,\"plateIndex\":0,\"modHood\":-1,\"neonColor\":[255,0,255],\"modStruts\":-1,\"modLivery\":-1}', 'car', 'civ', 'suvs', 'Baller', 98, 1),
('steam:110000113ffea41', 'DRK 327', '{\"modSpoilers\":-1,\"fuelLevel\":67.0,\"engineHealth\":1000.0,\"modSeats\":-1,\"modEngine\":-1,\"modFender\":-1,\"modAirFilter\":-1,\"modStruts\":-1,\"modOrnaments\":-1,\"modAPlate\":-1,\"dirtLevel\":8.1,\"modRearBumper\":-1,\"neonEnabled\":[false,false,false,false],\"modHood\":-1,\"model\":1353720154,\"modPlateHolder\":-1,\"modExhaust\":-1,\"modTank\":-1,\"color1\":73,\"modRoof\":-1,\"modHorns\":-1,\"pearlescentColor\":63,\"bodyHealth\":1000.0,\"modXenon\":false,\"modLivery\":-1,\"modDoorSpeaker\":-1,\"plateIndex\":3,\"modFrame\":-1,\"modFrontBumper\":-1,\"neonColor\":[255,0,255],\"modArmor\":-1,\"modVanityPlate\":-1,\"modGrille\":-1,\"modWindows\":-1,\"modShifterLeavers\":-1,\"modTrimB\":-1,\"modBrakes\":-1,\"wheelColor\":156,\"modAerials\":-1,\"modSteeringWheel\":-1,\"modTurbo\":false,\"wheels\":0,\"modDashboard\":-1,\"modSmokeEnabled\":false,\"modDial\":-1,\"modFrontWheels\":-1,\"modRightFender\":-1,\"modTrimA\":-1,\"modSideSkirt\":-1,\"tyreSmokeColor\":[255,255,255],\"windowTint\":-1,\"modTransmission\":-1,\"modSuspension\":-1,\"modEngineBlock\":-1,\"modArchCover\":-1,\"modTrunk\":-1,\"modSpeakers\":-1,\"plate\":\"DRK 327\",\"modBackWheels\":-1,\"color2\":70,\"extras\":[],\"modHydrolic\":-1}', 'car', 'mechanic', 'cars', 'Flatbed', 67, 1),
('steam:110000113ffea41', 'IIK 030', '{\"model\":1126868326,\"plate\":\"IIK 030\"}', 'car', 'civ', 'offroads', 'Bf Injection', 100, 0),
('steam:110000113ffea41', 'ITZ 872', '{\"modArmor\":-1,\"modTrimA\":-1,\"modVanityPlate\":-1,\"wheelColor\":7,\"modAirFilter\":-1,\"modGrille\":-1,\"modTurbo\":false,\"modEngineBlock\":-1,\"modHood\":-1,\"neonColor\":[255,0,255],\"modArchCover\":-1,\"modFender\":-1,\"modRightFender\":-1,\"modStruts\":-1,\"modShifterLeavers\":-1,\"pearlescentColor\":2,\"modLivery\":-1,\"fuelLevel\":90.0,\"modTank\":-1,\"modWindows\":-1,\"modOrnaments\":-1,\"plate\":\"ITZ 872\",\"modTrunk\":-1,\"windowTint\":-1,\"modSmokeEnabled\":false,\"tyreSmokeColor\":[255,255,255],\"wheels\":3,\"modTransmission\":-1,\"modXenon\":false,\"modExhaust\":-1,\"modSpoilers\":-1,\"extras\":{\"12\":true,\"10\":false},\"modAerials\":-1,\"modSuspension\":-1,\"modFrame\":-1,\"modBackWheels\":-1,\"bodyHealth\":927.5,\"modHorns\":-1,\"color1\":111,\"modSeats\":-1,\"modSteeringWheel\":-1,\"model\":1878062887,\"modAPlate\":-1,\"modTrimB\":-1,\"modHydrolic\":-1,\"plateIndex\":0,\"modBrakes\":-1,\"dirtLevel\":4.7,\"color2\":0,\"modRearBumper\":-1,\"modEngine\":-1,\"engineHealth\":1000.0,\"modDial\":-1,\"modDoorSpeaker\":-1,\"modDashboard\":-1,\"modSideSkirt\":-1,\"modFrontBumper\":-1,\"modPlateHolder\":-1,\"modSpeakers\":-1,\"neonEnabled\":[false,false,false,false],\"modRoof\":-1,\"modFrontWheels\":-1}', 'car', 'civ', 'suvs', 'Big Baller', 90, 1),
('steam:110000113ffea41', 'KYN 275', '{\"model\":486987393,\"wheelColor\":156,\"modExhaust\":-1,\"pearlescentColor\":4,\"tyreSmokeColor\":[255,255,255],\"modFrontWheels\":-1,\"modArmor\":-1,\"modAerials\":-1,\"modTrimA\":-1,\"modGrille\":-1,\"modDashboard\":-1,\"modHydrolic\":-1,\"windowTint\":-1,\"modHorns\":-1,\"modOrnaments\":-1,\"modDial\":-1,\"bodyHealth\":998.2,\"modLivery\":-1,\"wheels\":3,\"modSpoilers\":-1,\"modBrakes\":-1,\"modStruts\":-1,\"modDoorSpeaker\":-1,\"modFrame\":-1,\"modTurbo\":false,\"modXenon\":false,\"modEngine\":-1,\"fuelLevel\":97.9,\"modSuspension\":-1,\"modBackWheels\":-1,\"neonEnabled\":[false,false,false,false],\"engineHealth\":998.5,\"modSeats\":-1,\"modSideSkirt\":-1,\"modFrontBumper\":-1,\"neonColor\":[255,0,255],\"modPlateHolder\":-1,\"modFender\":-1,\"modWindows\":-1,\"modTank\":-1,\"modVanityPlate\":-1,\"modAPlate\":-1,\"modRoof\":-1,\"modTransmission\":-1,\"color1\":1,\"modHood\":-1,\"plate\":\"KYN 275\",\"modRearBumper\":-1,\"extras\":{\"11\":true,\"10\":false,\"12\":false},\"dirtLevel\":4.3,\"color2\":1,\"modSpeakers\":-1,\"plateIndex\":0,\"modTrimB\":-1,\"modSmokeEnabled\":false,\"modArchCover\":-1,\"modRightFender\":-1,\"modSteeringWheel\":-1,\"modShifterLeavers\":-1,\"modAirFilter\":-1,\"modEngineBlock\":-1,\"modTrunk\":-1}', 'car', 'civ', 'suvs', 'Huntley S', 98, 1),
('steam:110000113ffea41', 'MOQ 070', '{\"model\":1032823388,\"plate\":\"MOQ 070\"}', 'car', 'civ', 'sports', '9F', 100, 0),
('steam:110000113ffea41', 'MSN 084', '{\"model\":-344943009,\"plate\":\"MSN 084\"}', 'car', 'civ', 'compacts', 'Blista', 100, 0),
('steam:110000113ffea41', 'NUJ 281', '{\"model\":-1216765807,\"plate\":\"NUJ 281\"}', 'car', 'civ', 'supers', 'Adder', 100, 0),
('steam:110000113ffea41', 'QPS 101', '{\"model\":296357396,\"plate\":\"QPS 101\"}', 'car', 'civ', 'vans', 'Burrito', 100, 0),
('steam:110000113ffea41', 'TEI 356', '{\"plateIndex\":0,\"modRearBumper\":-1,\"tyreSmokeColor\":[255,255,255],\"modAirFilter\":-1,\"modTank\":-1,\"modAPlate\":-1,\"modRoof\":-1,\"modGrille\":-1,\"modBackWheels\":-1,\"modFrontWheels\":-1,\"modFrontBumper\":-1,\"modSpeakers\":-1,\"modRightFender\":-1,\"modPlateHolder\":-1,\"neonColor\":[255,0,255],\"modTurbo\":1,\"modHydrolic\":-1,\"fuelLevel\":50.8,\"modEngine\":-1,\"windowTint\":-1,\"modFrame\":-1,\"bodyHealth\":1000.0,\"pearlescentColor\":29,\"modSmokeEnabled\":false,\"modArmor\":-1,\"wheels\":7,\"modXenon\":false,\"modTrimB\":-1,\"modSteeringWheel\":-1,\"plate\":\"TEI 356\",\"modWindows\":-1,\"engineHealth\":1000.0,\"color1\":134,\"dirtLevel\":5.9,\"modLivery\":-1,\"modSideSkirt\":-1,\"neonEnabled\":[false,false,false,false],\"model\":-1829802492,\"modTrunk\":-1,\"modHood\":-1,\"modTrimA\":-1,\"extras\":{\"1\":true},\"wheelColor\":156,\"modSeats\":-1,\"modAerials\":-1,\"modStruts\":-1,\"modBrakes\":-1,\"modDashboard\":-1,\"color2\":40,\"modHorns\":-1,\"modFender\":-1,\"modExhaust\":-1,\"modEngineBlock\":-1,\"modShifterLeavers\":-1,\"modDial\":-1,\"modDoorSpeaker\":-1,\"modTransmission\":-1,\"modSuspension\":-1,\"modVanityPlate\":-1,\"modArchCover\":-1,\"modSpoilers\":-1,\"modOrnaments\":-1}', 'car', 'civ', 'supers', 'Pfister', 51, 1),
('steam:110000113ffea41', 'UUP 838', '{\"model\":-1205801634,\"plate\":\"UUP 838\"}', 'car', 'civ', 'muscles', 'Blade', 100, 0),
('steam:110000113ffea41', 'VBA 995', '{\"model\":330661258,\"plate\":\"VBA 995\"}', 'car', 'civ', 'coupes', 'Cognoscenti Cabrio', 100, 0),
('steam:110000113ffea41', 'VBL 314', '{\"model\":117401876,\"plate\":\"VBL 314\"}', 'car', 'civ', 'sportsclassics', 'Btype', 100, 0),
('steam:110000113ffea41', 'VBT 789', '{\"model\":-1809822327,\"plate\":\"VBT 789\"}', 'car', 'civ', 'sedans', 'Asea', 100, 0),
('steam:110000113ffea41', 'WPR 478', '{\"plate\":\"WPR 478\",\"model\":-344943009}', 'car', 'civ', 'compacts', 'Blista', 100, 0),
('steam:110000113ffea41', 'XLY 419', '{\"model\":-16948145,\"plate\":\"XLY 419\"}', 'car', 'civ', 'vans', 'Bison', 100, 0),
('steam:110000113ffea41', 'XRJ 419', '{\"modTank\":-1,\"modSmokeEnabled\":false,\"modHorns\":-1,\"modVanityPlate\":-1,\"wheelColor\":7,\"modTurbo\":false,\"modSteeringWheel\":-1,\"modFrame\":-1,\"modTrimB\":-1,\"modFender\":-1,\"modArmor\":-1,\"bodyHealth\":941.8,\"dirtLevel\":3.3,\"modDial\":-1,\"color1\":0,\"modRoof\":-1,\"modEngineBlock\":-1,\"modGrille\":-1,\"color2\":0,\"modStruts\":-1,\"model\":1878062887,\"engineHealth\":968.1,\"modSuspension\":-1,\"modDashboard\":-1,\"windowTint\":-1,\"modTrimA\":-1,\"modSeats\":-1,\"pearlescentColor\":2,\"neonEnabled\":[false,false,false,false],\"modBrakes\":-1,\"extras\":{\"10\":true,\"12\":false},\"modFrontBumper\":-1,\"modShifterLeavers\":-1,\"modAirFilter\":-1,\"modFrontWheels\":-1,\"plate\":\"XRJ 419\",\"modDoorSpeaker\":-1,\"modEngine\":-1,\"modRearBumper\":-1,\"modHood\":-1,\"plateIndex\":0,\"modSpeakers\":-1,\"wheels\":3,\"neonColor\":[255,0,255],\"modArchCover\":-1,\"tyreSmokeColor\":[255,255,255],\"modSideSkirt\":-1,\"modSpoilers\":-1,\"modTrunk\":-1,\"modExhaust\":-1,\"modPlateHolder\":-1,\"fuelLevel\":59.6,\"modTransmission\":-1,\"modLivery\":-1,\"modWindows\":-1,\"modRightFender\":-1,\"modHydrolic\":-1,\"modBackWheels\":-1,\"modOrnaments\":-1,\"modAPlate\":-1,\"modXenon\":false,\"modAerials\":-1}', 'car', 'civ', 'suvs', 'Baller Sport', 60, 0),
('steam:110000113ffea41', 'YLI 849', '{\"model\":330661258,\"plate\":\"YLI 849\"}', 'car', 'civ', 'coupes', 'Cognoscenti Cabrio', 100, 0);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `owned_vehicles`
--
ALTER TABLE `owned_vehicles`
  ADD PRIMARY KEY (`plate`);
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 */;
