-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Client :  localhost
-- Généré le :  Jeu 24 Juillet 2014 à 20:18
-- Version du serveur :  5.5.34-cll-lve
-- Version de PHP :  5.4.23

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

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

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

--
-- Structure de la table `factioninventory`
--

CREATE TABLE IF NOT EXISTS `factioninventory` (
  `fid` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


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

--
-- Structure de la table `factions`
--

CREATE TABLE IF NOT EXISTS `factions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `cash` int(11) NOT NULL,
  `rank1` varchar(64) NOT NULL,
  `rank2` varchar(64) NOT NULL,
  `rank3` varchar(64) NOT NULL,
  `rank4` varchar(64) NOT NULL,
  `rank5` varchar(64) NOT NULL,
  `rank6` varchar(64) NOT NULL,
  `rank7` varchar(64) NOT NULL,
  `rank8` varchar(64) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Structure de la table `garages`
--

CREATE TABLE IF NOT EXISTS `garages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vw` int(11) NOT NULL,
  `locked` int(11) NOT NULL,
  `owner` varchar(48) NOT NULL,
  `price` int(11) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `interieur` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Structure de la table `graffiti`
--

CREATE TABLE IF NOT EXISTS `graffiti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auteur` varchar(48) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `rX` float NOT NULL,
  `rY` float NOT NULL,
  `rZ` float NOT NULL,
  `font` varchar(48) NOT NULL,
  `color` int(11) NOT NULL,
  `text` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Structure de la table `houses`
--

CREATE TABLE IF NOT EXISTS `houses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(64) NOT NULL,
  `price` int(11) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `interieur` int(11) NOT NULL,
  `vw` int(11) NOT NULL,
  `iX` float NOT NULL,
  `iY` float NOT NULL,
  `iZ` float NOT NULL,
  `iinterieur` int(11) NOT NULL,
  `locked` int(5) NOT NULL,
  `alarm` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Structure de la table `interiors`
--

CREATE TABLE IF NOT EXISTS `interiors` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `iX` float NOT NULL,
  `iY` float NOT NULL,
  `iZ` float NOT NULL,
  `faction` int(5) NOT NULL,
  `ilock` int(1) NOT NULL,
  `interieur` int(5) NOT NULL,
  `vw` int(5) NOT NULL,
  `iint` int(5) NOT NULL,
  `ivw` int(5) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Structure de la table `playeraccessory`
--

CREATE TABLE IF NOT EXISTS `playeraccessory` (
  `pid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `model` int(11) NOT NULL,
  `emplacement` int(11) NOT NULL,
  `dX` float NOT NULL,
  `dY` float NOT NULL,
  `dZ` float NOT NULL,
  `rX` float NOT NULL,
  `rY` float NOT NULL,
  `rZ` float NOT NULL,
  `tX` float NOT NULL,
  `tY` float NOT NULL,
  `tZ` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Structure de la table `playerexperience`
--

CREATE TABLE IF NOT EXISTS `playerexperience` (
  `pid` int(11) NOT NULL,
  `experience` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `playerinventory`
--

CREATE TABLE IF NOT EXISTS `playerinventory` (
  `pid` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Structure de la table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `password` varchar(256) NOT NULL DEFAULT '1fez68eg4z6ze1ze2zfpasdepass1d544adz9',
  `email` varchar(128) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `ip` varchar(16) NOT NULL,
  `ipins` varchar(16) NOT NULL,
  `sex` int(2) NOT NULL,
  `age` int(5) NOT NULL,
  `cash` int(11) NOT NULL,
  `bank` int(11) NOT NULL,
  `admin` int(2) NOT NULL,
  `level` int(11) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `A` float NOT NULL,
  `health` float NOT NULL,
  `armour` float NOT NULL,
  `interior` int(11) NOT NULL,
  `vw` int(11) NOT NULL,
  `skin` int(5) NOT NULL,
  `faction` int(5) NOT NULL,
  `rank` int(5) NOT NULL,
  `playedtime` int(11) NOT NULL,
  `banned` int(1) NOT NULL,
  `reason` varchar(40) NOT NULL,
  `faim` float NOT NULL,
  `soif` float NOT NULL,
  `tel` int(11) NOT NULL,
  `taille` int(11) NOT NULL,
  `poids` int(11) NOT NULL,
  `cheveux` varchar(128) NOT NULL,
  `vetements` varchar(128) NOT NULL,
  `signes` varchar(128) NOT NULL,
  `rapide` varchar(96) NOT NULL,
  `death` int(2) NOT NULL,
  `deathX` float NOT NULL,
  `deathY` float NOT NULL,
  `deathZ` float NOT NULL,
  `deathInt` int(5) NOT NULL,
  `deathVw` int(5) NOT NULL,
  `deathType` int(5) NOT NULL,
  `deathBy` varchar(24) NOT NULL,
  `permis` int(1) NOT NULL,
  `point` int(5) NOT NULL,
  `td` int(1) NOT NULL,
  `online` int(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Structure de la table `vehicleinventory`
--

CREATE TABLE IF NOT EXISTS `vehicleinventory` (
  `vid` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(48) NOT NULL,
  `model` int(11) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `R` float NOT NULL,
  `interieur` int(5) NOT NULL,
  `vw` int(5) NOT NULL,
  `plaque` varchar(16) NOT NULL,
  `type` int(5) NOT NULL,
  `faction` int(5) NOT NULL,
  `vlock` int(1) NOT NULL,
  `prix` int(11) NOT NULL,
  `couleur1` int(3) NOT NULL,
  `couleur2` int(3) NOT NULL,
  `paintjob` int(2) NOT NULL,
  `job` int(5) NOT NULL,
  `moteur` int(1) NOT NULL,
  `fuel` float NOT NULL,
  `km` float NOT NULL,
  `poids` int(11) NOT NULL,
  `volume` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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