-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 15, 2018 at 03:07 PM
-- Server version: 5.7.14
-- PHP Version: 7.0.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Database: `miami-vice`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `admin_id` int(11) NOT NULL,
  `admin_label` varchar(16) NOT NULL,
  `admin_level` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`admin_id`, `admin_label`, `admin_level`) VALUES
(1, 'Responsable', 1000);

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

--
-- Table structure for table `adresse_mail`
--

CREATE TABLE `adresse_mail` (
  `ID` int(11) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `Firstname` varchar(30) NOT NULL,
  `Age` int(11) NOT NULL,
  `Mail` varchar(50) NOT NULL,
  `MDP` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `atm`
--

CREATE TABLE `atm` (
  `IDsql` int(11) NOT NULL,
  `ID` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `rot` float NOT NULL,
  `Zone` varchar(28) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `banlist`
--

CREATE TABLE `banlist` (
  `bID` int(11) NOT NULL,
  `bUID` int(11) NOT NULL,
  `gpci` text NOT NULL,
  `bReasoon` text NOT NULL,
  `bAdmin` text NOT NULL,
  `bDate` text NOT NULL,
  `bRazban` text,
  `bNick` text NOT NULL,
  `bPodset` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Table structure for table `biz`
--

CREATE TABLE `biz` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `Proprio` varchar(24) NOT NULL,
  `Nom` varchar(50) NOT NULL,
  `PosX` float NOT NULL,
  `PosY` float NOT NULL,
  `PosZ` float NOT NULL,
  `Prix` int(11) NOT NULL,
  `Vendre` int(11) NOT NULL DEFAULT '0',
  `Type` int(11) NOT NULL DEFAULT '0',
  `Acteur` int(11) NOT NULL,
  `ActeurDebut` int(11) NOT NULL DEFAULT '0',
  `ActeurFin` int(11) NOT NULL DEFAULT '0',
  `ActeurPaye` int(11) NOT NULL DEFAULT '0',
  `Coffre` int(11) NOT NULL DEFAULT '0',
  `Fond_Coffre` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `carcasse`
--

CREATE TABLE `carcasse` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `posRZ` float NOT NULL,
  `vehicleid` int(11) NOT NULL,
  `Moteur` int(11) NOT NULL,
  `Porte` int(11) NOT NULL,
  `Phare` int(11) NOT NULL,
  `Par_Brise` int(11) NOT NULL,
  `Par_Choc_AV` int(11) NOT NULL,
  `Par_Choc_AR` int(11) NOT NULL,
  `Pneu` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `charcaters`
--

CREATE TABLE `charcaters` (
  `ID` int(11) NOT NULL,
  `id_users` int(11) NOT NULL,
  `charcaters_name` varchar(24) NOT NULL,
  `Level` int(11) NOT NULL DEFAULT '0',
  `XP` int(11) NOT NULL DEFAULT '0',
  `Taille` int(11) NOT NULL,
  `Poids` int(11) NOT NULL,
  `Origine` int(11) NOT NULL,
  `Sexe` int(11) NOT NULL,
  `Age` int(11) NOT NULL,
  `Nation` int(11) NOT NULL,
  `Skin` int(11) NOT NULL,
  `posX` float NOT NULL DEFAULT '-1973.84',
  `posY` float NOT NULL DEFAULT '143.622',
  `posZ` float NOT NULL DEFAULT '27.6802',
  `Rot` float NOT NULL DEFAULT '-90',
  `compte` int(11) NOT NULL DEFAULT '0',
  `code_banque` int(11) NOT NULL DEFAULT '0',
  `fond_banque` int(11) NOT NULL DEFAULT '0',
  `Liquide` int(11) NOT NULL DEFAULT '50',
  `Endurance` float NOT NULL DEFAULT '100',
  `Soif` float NOT NULL DEFAULT '100',
  `Faim` float NOT NULL DEFAULT '100',
  `vKey1` int(11) NOT NULL DEFAULT '0',
  `vKey2` int(11) NOT NULL DEFAULT '0',
  `vKey3` int(11) NOT NULL DEFAULT '0',
  `Vie` float NOT NULL DEFAULT '100',
  `Armure` float NOT NULL DEFAULT '0',
  `VW` int(11) NOT NULL DEFAULT '0',
  `IDInt` int(11) NOT NULL DEFAULT '0',
  `TypeInt` int(11) NOT NULL DEFAULT '0',
  `Interior` int(11) NOT NULL DEFAULT '0',
  `BizID` int(11) NOT NULL DEFAULT '0',
  `HouseID` int(11) NOT NULL DEFAULT '0',
  `EntID` int(11) NOT NULL DEFAULT '0',
  `EntLead` int(11) NOT NULL DEFAULT '0',
  `VLOC` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `charcaters`
--

INSERT INTO `charcaters` (`ID`, `id_users`, `charcaters_name`, `Level`, `XP`, `Taille`, `Poids`, `Origine`, `Sexe`, `Age`, `Nation`, `Skin`, `posX`, `posY`, `posZ`, `Rot`, `compte`, `code_banque`, `fond_banque`, `Liquide`, `Endurance`, `Soif`, `Faim`, `vKey1`, `vKey2`, `vKey3`, `Vie`, `Armure`, `VW`, `IDInt`, `TypeInt`, `Interior`, `BizID`, `HouseID`, `EntID`, `EntLead`, `VLOC`) VALUES
(1, 7, 'John_Caprio', 0, 0, 0, 0, 0, 0, 0, 0, 0, -1973.84, 143.622, 27.6802, -90, 0, 0, 0, 50, 100, 100, 100, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 7, 'Charcater_2', 0, 0, 0, 0, 0, 0, 0, 0, 0, -1973.84, 143.622, 27.6802, -90, 0, 0, 0, 50, 100, 100, 100, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `concess`
--

CREATE TABLE `concess` (
  `ID` int(11) NOT NULL,
  `IDsamp` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `Prix` int(11) NOT NULL,
  `Stock` int(11) NOT NULL,
  `TypeLicens` int(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `couriel_maison`
--

CREATE TABLE `couriel_maison` (
  `ID` int(11) NOT NULL,
  `Titre` varchar(30) NOT NULL,
  `Exp` varchar(25) NOT NULL,
  `A` varchar(25) NOT NULL,
  `Text` text NOT NULL,
  `Adresse` varchar(50) NOT NULL,
  `Date` varchar(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `distributeur`
--

CREATE TABLE `distributeur` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `Rot` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `door`
--

CREATE TABLE `door` (
  `ID` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `CPosX` float NOT NULL,
  `CPosY` float NOT NULL,
  `CPosZ` float NOT NULL,
  `CRotX` float NOT NULL,
  `CRotY` float NOT NULL,
  `CRotZ` float NOT NULL,
  `Type` int(11) NOT NULL,
  `TypeFonction` int(11) NOT NULL,
  `ActiveRange` float NOT NULL,
  `Speed` float NOT NULL,
  `OPosX` float NOT NULL,
  `OPosY` float NOT NULL,
  `OPosZ` float NOT NULL,
  `ORotX` float NOT NULL,
  `ORotY` float NOT NULL,
  `ORotZ` float NOT NULL,
  `Interieure` int(11) NOT NULL,
  `VirtualWorld` int(11) NOT NULL,
  `Couple` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `doublecompte`
--

CREATE TABLE `doublecompte` (
  `ID` int(11) NOT NULL,
  `IP` varchar(24) NOT NULL,
  `NBR` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `entreprise`
--

CREATE TABLE `entreprise` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `Type` int(11) NOT NULL,
  `Vendre` int(11) NOT NULL,
  `Proprio` varchar(24) DEFAULT NULL,
  `Nom` varchar(50) DEFAULT NULL,
  `Prix` int(11) NOT NULL DEFAULT '0',
  `gPosX` float NOT NULL DEFAULT '0',
  `gPosY` float NOT NULL DEFAULT '0',
  `gPosZ` float NOT NULL DEFAULT '0',
  `Fond` int(11) NOT NULL DEFAULT '0',
  `Entrepot` int(11) NOT NULL DEFAULT '1',
  `MaxEntrepot` int(11) NOT NULL DEFAULT '10000',
  `QuentEntrepot` int(11) NOT NULL DEFAULT '0',
  `Recrut` int(11) NOT NULL DEFAULT '0',
  `MaxEmpl` int(11) NOT NULL DEFAULT '5',
  `Empl` int(11) NOT NULL DEFAULT '0',
  `PayMin` int(11) NOT NULL DEFAULT '11',
  `PayMiss` int(11) NOT NULL DEFAULT '100'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `entreprise_poste`
--

CREATE TABLE `entreprise_poste` (
  `ID` int(11) NOT NULL,
  `EntID` int(11) NOT NULL,
  `Titre` varchar(50) NOT NULL,
  `Date` varchar(11) NOT NULL,
  `Text` text NOT NULL,
  `Exp` varchar(25) NOT NULL,
  `A` varchar(25) NOT NULL,
  `Adress` varchar(50) NOT NULL,
  `Zone` varchar(28) NOT NULL,
  `EnCour` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `faction`
--

CREATE TABLE `faction` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `FactionName` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank1` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank2` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank3` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank4` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank5` varchar(32) NOT NULL DEFAULT 'Aucun',
  `Rank6` varchar(32) NOT NULL DEFAULT 'Aucun'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fct_mairie_taxe`
--

CREATE TABLE `fct_mairie_taxe` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `TaxeName` varchar(32) NOT NULL,
  `pourcentage` int(11) NOT NULL,
  `min_payday` int(11) NOT NULL,
  `min_fond` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fct_mairie_taxe_vehicle`
--

CREATE TABLE `fct_mairie_taxe_vehicle` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `TaxeName` varchar(32) NOT NULL,
  `VehicleID` int(11) NOT NULL,
  `Prix` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ipacess`
--

CREATE TABLE `ipacess` (
  `ID` int(11) NOT NULL,
  `IP` varchar(16) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ipacess`
--

INSERT INTO `ipacess` (`ID`, `IP`) VALUES
(1, '127.0.0.1');

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

--
-- Table structure for table `joueur_accesoire`
--

CREATE TABLE `joueur_accesoire` (
  `IDSQL` int(11) NOT NULL,
  `Player` varchar(25) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Indexe` int(11) NOT NULL,
  `Bone` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `rotX` float NOT NULL,
  `rotY` float NOT NULL,
  `rotZ` float NOT NULL,
  `Mis` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `joueur_inventaire`
--

CREATE TABLE `joueur_inventaire` (
  `IDSQL` int(11) NOT NULL,
  `Player` varchar(25) NOT NULL,
  `ID` int(11) NOT NULL,
  `TYPE` int(11) NOT NULL,
  `NBR` int(11) NOT NULL,
  `strOpt` varchar(50) DEFAULT NULL,
  `intOpt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `key_beta`
--

CREATE TABLE `key_beta` (
  `ID` int(11) NOT NULL,
  `Cle` varchar(25) NOT NULL,
  `Username` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `log_id` int(11) NOT NULL,
  `log_type` int(11) NOT NULL,
  `log_infos` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `log_admin` int(11) NOT NULL,
  `log_user_ip` varchar(16) NOT NULL,
  `log_date` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`log_id`, `log_type`, `log_infos`, `user_id`, `log_admin`, `log_user_ip`, `log_date`) VALUES
(1, 1, 'connexion au site', 7, 0, '46193', '11-05-2018 23:48'),
(2, 1, 'connexion au site', 7, 0, '46.193.64.130', '11-05-2018 23:49'),
(3, 1, 'deconnexion au site', 7, 0, '46.193.64.130', '11-05-2018 23:50'),
(4, 1, 'connexion au site', 7, 0, '46.193.64.130', '11-05-2018 23:52'),
(5, 1, 'deconnexion du site', 7, 0, '46.193.64.130', '12-05-2018 00:08'),
(6, 1, 'connexion au site', 7, 0, '46.193.64.130', '12-05-2018 00:08'),
(7, 1, 'inscription au site', 9, 0, '77.136.110.73', '12-05-2018 00:16'),
(8, 1, 'connexion au site', 9, 0, '77.136.110.73', '12-05-2018 00:17'),
(9, 1, 'deconnexion du site', 7, 0, '46.193.64.130', '12-05-2018 00:19'),
(10, 1, 'connexion au site', 7, 0, '46.193.64.130', '12-05-2018 00:24'),
(11, 1, 'deconnexion du site', 7, 0, '46.193.64.130', '12-05-2018 00:24'),
(12, 1, 'inscription au site', 10, 0, '91.164.64.128', '12-05-2018 00:36'),
(13, 1, 'demande reset mot de passe', 7, 0, '213.245.37.93', '12-05-2018 16:42'),
(14, 1, 'demande reset mot de passe', 7, 0, '213.245.37.93', '12-05-2018 16:42'),
(15, 1, 'connexion au site', 7, 0, '213.245.37.93', '12-05-2018 16:47'),
(16, 1, 'deconnexion du site', 7, 0, '213.245.37.93', '12-05-2018 16:47'),
(17, 1, 'connexion au site', 7, 0, '213.245.37.93', '12-05-2018 16:48'),
(18, 1, 'deconnexion du site', 7, 0, '213.245.37.93', '12-05-2018 16:48'),
(19, 1, 'connexion au site', 7, 0, '213.245.37.93', '12-05-2018 17:51'),
(20, 1, 'deconnexion du site', 7, 0, '213.245.37.93', '12-05-2018 17:51'),
(21, 1, 'connexion au site', 7, 0, '213.245.37.93', '12-05-2018 17:52'),
(22, 1, 'deconnexion du site', 7, 0, '213.245.37.93', '12-05-2018 18:08');

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

--
-- Table structure for table `log_banque`
--

CREATE TABLE `log_banque` (
  `id` int(11) NOT NULL,
  `Pseudo` varchar(25) NOT NULL,
  `Log` text NOT NULL,
  `Date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loot`
--

CREATE TABLE `loot` (
  `IDSQL` int(11) NOT NULL,
  `IDInv` int(11) NOT NULL,
  `TypeInv` int(11) NOT NULL,
  `Quantite` int(11) NOT NULL DEFAULT '1',
  `Model` int(11) NOT NULL,
  `intOPT` int(11) DEFAULT NULL,
  `strOPT` varchar(50) DEFAULT NULL,
  `PosX` float NOT NULL,
  `PosY` float NOT NULL,
  `PosZ` float NOT NULL,
  `VW` int(11) NOT NULL,
  `interior` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `ID` int(11) NOT NULL,
  `De` varchar(50) NOT NULL,
  `A` varchar(50) NOT NULL,
  `Subject` varchar(100) NOT NULL,
  `Contenue` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `maison`
--

CREATE TABLE `maison` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `Type` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `proprio` varchar(25) NOT NULL,
  `prix` int(11) NOT NULL,
  `Adress` varchar(50) NOT NULL DEFAULT 'None'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `message_deco`
--

CREATE TABLE `message_deco` (
  `ID` int(11) NOT NULL,
  `De` varchar(24) NOT NULL,
  `A` varchar(24) NOT NULL,
  `Date` varchar(17) NOT NULL,
  `Text` varchar(150) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `message_privée`
--

CREATE TABLE `message_privée` (
  `IDSQL` int(11) NOT NULL,
  `Player` varchar(25) NOT NULL,
  `De` varchar(25) NOT NULL,
  `Date` varchar(12) NOT NULL,
  `Lue` int(11) NOT NULL DEFAULT '0',
  `MSG` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pack_cmd`
--

CREATE TABLE `pack_cmd` (
  `IDSql` int(11) NOT NULL,
  `ID` int(11) NOT NULL,
  `Name` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pack_component_cmd`
--

CREATE TABLE `pack_component_cmd` (
  `IDSql` int(11) NOT NULL,
  `packID` int(11) NOT NULL,
  `cmdid` int(11) NOT NULL,
  `CMD` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `parking`
--

CREATE TABLE `parking` (
  `ID` int(11) NOT NULL,
  `IDSamp` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `Rot` float NOT NULL,
  `Dispo` int(1) NOT NULL,
  `vehicle` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `phone`
--

CREATE TABLE `phone` (
  `ID` int(11) NOT NULL,
  `Player` varchar(32) NOT NULL,
  `Num` int(11) NOT NULL,
  `Color` int(11) NOT NULL,
  `Ecr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `phone_repertoire`
--

CREATE TABLE `phone_repertoire` (
  `ID` int(11) NOT NULL,
  `Player` varchar(32) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Num` int(11) DEFAULT NULL,
  `Adress` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `player_msg_information`
--

CREATE TABLE `player_msg_information` (
  `ID` int(11) NOT NULL,
  `PlayerName` varchar(24) NOT NULL,
  `MSG` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `player_pack_cmd`
--

CREATE TABLE `player_pack_cmd` (
  `IDSql` int(11) NOT NULL,
  `PlayerName` varchar(25) NOT NULL,
  `packID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rapport`
--

CREATE TABLE `rapport` (
  `ID` int(11) NOT NULL,
  `Type` int(11) NOT NULL,
  `Player` varchar(25) NOT NULL,
  `Comment` text NOT NULL,
  `MSG_SIGNALED` text,
  `PLAYER_SIGNALED` varchar(25) DEFAULT NULL,
  `Lue` int(11) NOT NULL DEFAULT '0',
  `Date` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `user_username` varchar(16) NOT NULL,
  `user_email` varchar(64) NOT NULL,
  `user_password` varchar(128) NOT NULL,
  `user_register_date` varchar(16) NOT NULL,
  `user_reset_key` varchar(32) NOT NULL,
  `admin_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `users` (`user_id`, `user_username`, `user_email`, `user_password`, `user_register_date`, `user_reset_key`, `admin_id`) VALUES
(7, 'Nitram', 'martin.elouan.77@gmail.com', '$2a$08$xdLb6MimYzhcy2q4yym3FOcFiWFZ3JYPXhZIMjmZTuZPcxgNCXPhO', '', ' ', 0),
(8, 'A6', 'tonymartinezvevo@gmail.com', '$2a$08$7hghUeCKKXgH7s3YuL3J6ewKB86QOOQ14AYmX17TLK6eHt.qbRX3K', '', '', 0),
(9, 'lonekid', 'lonekiddd@gmail.com', '$2a$08$C01592pNSyf9wqBS6J1vZeeu.CKiFQ0YgfV1dQYsBg6ZJJqRYxid2', '12-05-2018 00:16', '', 0),
(10, 'Nicoo', 'acenico@hotmail.fr', '$2a$08$D0C27arWF7fquNx2Svk7XuJrPQfN.Sg5gHw5SqF0RykIP0ASL7hOe', '12-05-2018 00:36', '', 0);

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

--
-- Table structure for table `users_confirmations`
--

CREATE TABLE `users_confirmations` (
  `confirmation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `confirmation_key` varchar(128) NOT NULL,
  `confirmation_status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users_confirmations`
--

INSERT INTO `users_confirmations` (`confirmation_id`, `user_id`, `confirmation_key`, `confirmation_status`) VALUES
(2, 7, 'uR8nQqkVg4xTZ7mW', 1),
(3, 8, 'cXT2Dp3R7gSA5fil', 1),
(4, 9, '4RsFfBk5yJhQ1TtG', 1),
(5, 10, 'nW5BhRPgV0pKmtZO', 0);

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

--
-- Table structure for table `users_logged`
--

CREATE TABLE `users_logged` (
  `ID` int(11) NOT NULL,
  `IP` varchar(25) NOT NULL,
  `Logged` int(11) NOT NULL DEFAULT '0',
  `Time_logged` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_logged`
--

INSERT INTO `users_logged` (`ID`, `IP`, `Logged`, `Time_logged`) VALUES
(2, '127.0.0.1', 1, 1526389060);

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

--
-- Table structure for table `vehicle_part`
--

CREATE TABLE `vehicle_part` (
  `ID` int(11) NOT NULL,
  `vID` int(11) NOT NULL,
  `MODE` int(1) NOT NULL,
  `Model` int(11) NOT NULL,
  `Slot` int(11) DEFAULT NULL,
  `X` float NOT NULL DEFAULT '0',
  `Y` float NOT NULL DEFAULT '0',
  `Z` float NOT NULL DEFAULT '0',
  `RX` float NOT NULL DEFAULT '0',
  `RY` float NOT NULL DEFAULT '0',
  `RZ` float NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `vehicule`
--

CREATE TABLE `vehicule` (
  `ID` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `Couleur1` int(11) NOT NULL,
  `Couleur2` int(11) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `rot` float NOT NULL,
  `Actif` int(11) NOT NULL DEFAULT '1',
  `Moteur` int(11) NOT NULL DEFAULT '0',
  `Alarme` int(11) NOT NULL DEFAULT '0',
  `Phare` int(11) NOT NULL DEFAULT '0',
  `Porte` int(11) NOT NULL DEFAULT '0',
  `Capot` int(11) NOT NULL DEFAULT '0',
  `Coffre` int(11) NOT NULL DEFAULT '0',
  `Clef` int(11) NOT NULL DEFAULT '0',
  `Bride` int(11) NOT NULL DEFAULT '0',
  `Proprio` varchar(24) NOT NULL DEFAULT 'Aucun',
  `Killometre` float NOT NULL DEFAULT '0',
  `Essance` float NOT NULL DEFAULT '100',
  `MaxEssance` float NOT NULL DEFAULT '0',
  `ConsoEssance` float NOT NULL DEFAULT '0',
  `Plaque` varchar(10) DEFAULT NULL,
  `TypeLicense` int(1) NOT NULL DEFAULT '1',
  `MaxSpeed` int(5) NOT NULL,
  `VirtualWorld` int(1) NOT NULL DEFAULT '0',
  `IsTrailer` int(11) NOT NULL DEFAULT '0',
  `Type` int(11) NOT NULL DEFAULT '0',
  `Pneu1` float NOT NULL DEFAULT '100',
  `Pneu2` float NOT NULL DEFAULT '100',
  `Pneu3` float NOT NULL DEFAULT '100',
  `Pneu4` int(11) NOT NULL DEFAULT '100'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `adresse_mail`
--
ALTER TABLE `adresse_mail`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `atm`
--
ALTER TABLE `atm`
  ADD PRIMARY KEY (`IDsql`);

--
-- Indexes for table `banlist`
--
ALTER TABLE `banlist`
  ADD PRIMARY KEY (`bID`);

--
-- Indexes for table `biz`
--
ALTER TABLE `biz`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `carcasse`
--
ALTER TABLE `carcasse`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `charcaters`
--
ALTER TABLE `charcaters`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `concess`
--
ALTER TABLE `concess`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `couriel_maison`
--
ALTER TABLE `couriel_maison`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `distributeur`
--
ALTER TABLE `distributeur`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `door`
--
ALTER TABLE `door`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `doublecompte`
--
ALTER TABLE `doublecompte`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `entreprise`
--
ALTER TABLE `entreprise`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `entreprise_poste`
--
ALTER TABLE `entreprise_poste`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `faction`
--
ALTER TABLE `faction`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `fct_mairie_taxe`
--
ALTER TABLE `fct_mairie_taxe`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `fct_mairie_taxe_vehicle`
--
ALTER TABLE `fct_mairie_taxe_vehicle`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `ipacess`
--
ALTER TABLE `ipacess`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `joueur_accesoire`
--
ALTER TABLE `joueur_accesoire`
  ADD PRIMARY KEY (`IDSQL`);

--
-- Indexes for table `joueur_inventaire`
--
ALTER TABLE `joueur_inventaire`
  ADD PRIMARY KEY (`IDSQL`);

--
-- Indexes for table `key_beta`
--
ALTER TABLE `key_beta`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `log_banque`
--
ALTER TABLE `log_banque`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `loot`
--
ALTER TABLE `loot`
  ADD PRIMARY KEY (`IDSQL`);

--
-- Indexes for table `mail`
--
ALTER TABLE `mail`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `maison`
--
ALTER TABLE `maison`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `message_deco`
--
ALTER TABLE `message_deco`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `message_privée`
--
ALTER TABLE `message_privée`
  ADD PRIMARY KEY (`IDSQL`);

--
-- Indexes for table `pack_cmd`
--
ALTER TABLE `pack_cmd`
  ADD PRIMARY KEY (`IDSql`);

--
-- Indexes for table `pack_component_cmd`
--
ALTER TABLE `pack_component_cmd`
  ADD PRIMARY KEY (`IDSql`);

--
-- Indexes for table `parking`
--
ALTER TABLE `parking`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `phone`
--
ALTER TABLE `phone`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `phone_repertoire`
--
ALTER TABLE `phone_repertoire`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `player_msg_information`
--
ALTER TABLE `player_msg_information`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `player_pack_cmd`
--
ALTER TABLE `player_pack_cmd`
  ADD PRIMARY KEY (`IDSql`);

--
-- Indexes for table `rapport`
--
ALTER TABLE `rapport`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `users_confirmations`
--
ALTER TABLE `users_confirmations`
  ADD PRIMARY KEY (`confirmation_id`);

--
-- Indexes for table `users_logged`
--
ALTER TABLE `users_logged`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `vehicle_part`
--
ALTER TABLE `vehicle_part`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `vehicule`
--
ALTER TABLE `vehicule`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `adresse_mail`
--
ALTER TABLE `adresse_mail`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `atm`
--
ALTER TABLE `atm`
  MODIFY `IDsql` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banlist`
--
ALTER TABLE `banlist`
  MODIFY `bID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `biz`
--
ALTER TABLE `biz`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `carcasse`
--
ALTER TABLE `carcasse`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `charcaters`
--
ALTER TABLE `charcaters`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `concess`
--
ALTER TABLE `concess`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `couriel_maison`
--
ALTER TABLE `couriel_maison`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `distributeur`
--
ALTER TABLE `distributeur`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `door`
--
ALTER TABLE `door`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doublecompte`
--
ALTER TABLE `doublecompte`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `entreprise`
--
ALTER TABLE `entreprise`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `entreprise_poste`
--
ALTER TABLE `entreprise_poste`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faction`
--
ALTER TABLE `faction`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fct_mairie_taxe`
--
ALTER TABLE `fct_mairie_taxe`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fct_mairie_taxe_vehicle`
--
ALTER TABLE `fct_mairie_taxe_vehicle`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ipacess`
--
ALTER TABLE `ipacess`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `joueur_accesoire`
--
ALTER TABLE `joueur_accesoire`
  MODIFY `IDSQL` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `joueur_inventaire`
--
ALTER TABLE `joueur_inventaire`
  MODIFY `IDSQL` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `key_beta`
--
ALTER TABLE `key_beta`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `log_banque`
--
ALTER TABLE `log_banque`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loot`
--
ALTER TABLE `loot`
  MODIFY `IDSQL` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mail`
--
ALTER TABLE `mail`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `maison`
--
ALTER TABLE `maison`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `message_deco`
--
ALTER TABLE `message_deco`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `message_privée`
--
ALTER TABLE `message_privée`
  MODIFY `IDSQL` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pack_cmd`
--
ALTER TABLE `pack_cmd`
  MODIFY `IDSql` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pack_component_cmd`
--
ALTER TABLE `pack_component_cmd`
  MODIFY `IDSql` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `parking`
--
ALTER TABLE `parking`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `phone`
--
ALTER TABLE `phone`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `phone_repertoire`
--
ALTER TABLE `phone_repertoire`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `player_msg_information`
--
ALTER TABLE `player_msg_information`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `player_pack_cmd`
--
ALTER TABLE `player_pack_cmd`
  MODIFY `IDSql` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rapport`
--
ALTER TABLE `rapport`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `users_confirmations`
--
ALTER TABLE `users_confirmations`
  MODIFY `confirmation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `users_logged`
--
ALTER TABLE `users_logged`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `vehicle_part`
--
ALTER TABLE `vehicle_part`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vehicule`
--
ALTER TABLE `vehicule`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
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 */;