-- phpMyAdmin SQL Dump
-- version 3.5.3
-- http://www.phpmyadmin.net
--
-- Client: sql-1.verygames.net
-- Généré le: Lun 24 Juin 2013 à 18:12
-- Version du serveur: 5.1.49-3
-- Version de PHP: 5.2.11

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: `dg_site890`
--

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

--
-- Structure de la table `Roleplay_Boutique`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Boutique` (
  `steam_id` varchar(20) NOT NULL,
  `points` int(11) NOT NULL,
  `flame` int(4) NOT NULL,
  `ford` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `Roleplay_Gold`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Gold` (
  `steam_id` varchar(20) NOT NULL,
  `gc` int(100) NOT NULL,
  `gcskin` int(2) NOT NULL,
  `gcpseudo` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `Roleplay_Groups`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Groups` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Owner` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `Roleplay_House`
--

CREATE TABLE IF NOT EXISTS `Roleplay_House` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `occuped` int(2) NOT NULL,
  `timestamp` varchar(50) NOT NULL,
  `price` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Contenu de la table `Roleplay_House`
--

INSERT INTO `Roleplay_House` (`id`, `name`, `occuped`, `timestamp`, `price`) VALUES
(18, 'Villa VIP ', 0, '0', 15000),
(17, 'Appartement 42', 0, '0', 5000),
(16, 'Appartement 41', 0, '0', 5000),
(15, 'Appartement 34', 0, '0', 1500),
(14, 'Appartement 33', 0, '0', 1500),
(13, 'Appartement 32', 0, '0', 1500),
(12, 'Appartement 31', 0, '0', 1500),
(11, 'Appartement 24', 0, '0', 1000),
(10, 'Appartement 23', 0, '0', 1000),
(9, 'Appartement 22', 0, '0', 1000),
(8, 'Appartement 21', 0, '0', 1000),
(7, 'Appartement 14', 0, '0', 750),
(6, 'Appartement 13', 0, '0', 750),
(5, 'Appartement 12', 0, '0', 750),
(4, 'Appartement 11', 0, '0', 750),
(3, 'Appartement 3', 0, '0', 2500),
(2, 'Appartement 2', 0, '0', 2500),
(1, 'Appartement 1', 0, '0', 2500),
(19, 'Laboratoire', 0, '0', 18500);

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

--
-- Structure de la table `Roleplay_Item`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Item` (
  `steam_id` varchar(20) NOT NULL,
  `lsd` int(100) NOT NULL,
  `permis` varchar(1) NOT NULL DEFAULT '0',
  `hero` int(100) NOT NULL,
  `exta` int(100) NOT NULL,
  `cocaine` int(100) NOT NULL,
  `weed` int(100) NOT NULL,
  `entrainement` int(100) NOT NULL,
  `glock` int(100) NOT NULL,
  `usp` int(100) NOT NULL,
  `p228` int(100) NOT NULL,
  `deagle` int(100) NOT NULL,
  `elites` int(100) NOT NULL,
  `fiveseven` int(100) NOT NULL,
  `m3` int(100) NOT NULL,
  `xm1014` int(100) NOT NULL,
  `galil` int(100) NOT NULL,
  `ak47` int(100) NOT NULL,
  `scout` int(100) NOT NULL,
  `sg552` int(100) NOT NULL,
  `awp` int(100) NOT NULL,
  `g3sg1` int(100) NOT NULL,
  `famas` int(100) NOT NULL,
  `m4a1` int(100) NOT NULL,
  `aug` int(100) NOT NULL,
  `sg550` int(100) NOT NULL,
  `mac10` int(100) NOT NULL,
  `tmp` int(100) NOT NULL,
  `mp5` int(100) NOT NULL,
  `ump45` int(100) NOT NULL,
  `p90` int(100) NOT NULL,
  `m249` int(100) NOT NULL,
  `t10` int(100) NOT NULL,
  `t50` int(100) NOT NULL,
  `t100` int(100) NOT NULL,
  `t500` int(100) NOT NULL,
  `kits` int(100) NOT NULL,
  `he` int(100) NOT NULL,
  `fumi` int(100) NOT NULL,
  `flash` int(100) NOT NULL,
  `kevlar` int(100) NOT NULL,
  `cartouche` int(100) NOT NULL,
  `kitcrochetage` int(100) NOT NULL,
  `levelcut` int(4) NOT NULL,
  `flashball` int(4) NOT NULL,
  `imprimerie` int(4) NOT NULL,
  `oeil` int(4) NOT NULL,
  `regen` int(4) NOT NULL,
  `hamburger` int(4) NOT NULL,
  `frites` int(4) NOT NULL,
  `sunday` int(4) NOT NULL,
  `bigmac` int(4) NOT NULL,
  `macflurry` int(4) NOT NULL,
  `lancer` int(5) NOT NULL,
  `distrib` int(5) NOT NULL,
  `sofa` int(5) NOT NULL,
  `biblio` int(5) NOT NULL,
  `dryer` int(5) NOT NULL,
  `kite` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--


--
-- Structure de la table `Roleplay_Job`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Job` (
  `id` int(2) NOT NULL,
  `capital` int(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `Roleplay_Job`
--

INSERT INTO `Roleplay_Job` (`id`, `capital`) VALUES
(13, 500000),
(2, 500000),
(3, 500000),
(20, 500000),
(1, 500000),
(4, 500000),
(5, 500000),
(6, 500000),
(7, 500000),
(9, 500000),
(10, 500000),
(11, 500000),
(12, 500000),
(14, 500000),
(15, 500000),
(16, 500000),
(17, 500000),
(18, 500000),
(18, 500000),
(19, 500000),
(8, 500000);

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

--
-- Structure de la table `Roleplay_Players`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Players` (
  `steam_id` varchar(20) NOT NULL,
  `pseudo` varchar(100) NOT NULL,
  `cash` int(100) NOT NULL,
  `bank` int(100) NOT NULL,
  `jobid` int(10) NOT NULL,
  `jailtime` int(100) NOT NULL,
  `isinjail` int(2) NOT NULL,
  `permislourd` int(11) NOT NULL,
  `permisleger` int(11) NOT NULL,
  `cb` int(2) NOT NULL,
  `rib` int(2) NOT NULL,
  `rankid` int(3) NOT NULL,
  `lastontime` int(50) NOT NULL,
  `groupe` int(4) NOT NULL,
  `house` int(3) NOT NULL,
  `mdp` varchar(1024) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `Roleplay_Players`
--

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

--
-- Structure de la table `Roleplay_Salaire`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Salaire` (
  `jobid` int(1) NOT NULL,
  `rankid` int(1) NOT NULL,
  `salaire` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `Roleplay_Salaire`
--

INSERT INTO `Roleplay_Salaire` (`jobid`, `rankid`, `salaire`) VALUES
(1, 1, 1000),
(2, 1, 1000),
(3, 1, 400),
(4, 1, 400),
(5, 1, 200),
(1, 2, 500),
(2, 2, 500),
(3, 2, 450),
(4, 2, 400),
(5, 2, 300),
(1, 3, 500),
(2, 3, 350),
(3, 3, 400),
(4, 3, 350),
(5, 3, 300),
(1, 4, 500),
(2, 4, 450),
(3, 4, 350),
(4, 4, 250),
(5, 4, 150),
(1, 5, 500),
(2, 5, 450),
(3, 5, 500),
(4, 5, 300),
(5, 5, 200),
(1, 6, 500),
(2, 6, 450),
(3, 6, 400),
(4, 6, 350),
(5, 6, 300),
(1, 7, 500),
(2, 7, 500),
(3, 7, 400),
(4, 7, 300),
(5, 7, 200),
(1, 8, 500),
(2, 8, 450),
(3, 8, 300),
(4, 8, 250),
(5, 8, 200),
(1, 9, 500),
(2, 9, 400),
(3, 9, 350),
(4, 9, 350),
(5, 9, 350),
(1, 10, 500),
(2, 10, 500),
(3, 10, 450),
(4, 10, 350),
(5, 10, 350),
(1, 11, 500),
(2, 11, 500),
(3, 11, 450),
(4, 11, 400),
(5, 11, 300),
(1, 12, 500),
(2, 12, 450),
(3, 12, 400),
(4, 12, 350),
(2, 12, 450),
(1, 13, 500),
(2, 13, 500),
(3, 13, 500),
(4, 13, 500),
(5, 13, 200),
(1, 14, 500),
(2, 14, 400),
(3, 14, 300),
(4, 14, 250),
(5, 14, 150),
(1, 15, 500),
(2, 15, 500),
(3, 15, 500),
(4, 15, 500),
(5, 15, 500),
(1, 16, 500),
(2, 16, 500),
(3, 16, 500),
(4, 16, 500),
(5, 16, 150),
(0, 0, 50),
(1, 17, 500),
(2, 17, 500),
(3, 17, 300),
(4, 17, 200),
(5, 17, 150),
(1, 18, 500),
(2, 18, 500),
(3, 18, 300),
(4, 18, 200),
(5, 18, 100),
(6, 1, 1000),
(6, 10, 500),
(1, 18, 500),
(2, 18, 500),
(3, 18, 300),
(4, 18, 200),
(5, 18, 100),
(1, 19, 500),
(2, 19, 500),
(3, 19, 450),
(4, 19, 350),
(5, 19, 300),
(1, 20, 500),
(2, 20, 400),
(3, 20, 300),
(4, 20, 200),
(5, 20, 100);

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

--
-- Structure de la table `Roleplay_Shownote`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Shownote` (
  `rankid` int(3) NOT NULL,
  `texte` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `Roleplay_Succes`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Succes` (
  `steam_id` varchar(20) NOT NULL,
  `headshot` int(2) NOT NULL,
  `countheadshot` int(100) NOT NULL,
  `successdoor` int(2) NOT NULL,
  `countdoor` int(4) NOT NULL,
  `successjail` int(2) NOT NULL,
  `countjail` int(4) NOT NULL,
  `successpyro` int(2) NOT NULL,
  `countpyro` int(4) NOT NULL,
  `successrct` int(100) NOT NULL,
  `countrct` int(100) NOT NULL,
  `successdonator` int(2) NOT NULL,
  `countdonator` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `Roleplay_Succes`
--

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

--
-- Structure de la table `Roleplay_Time`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Time` (
  `id` int(3) NOT NULL,
  `day` int(3) NOT NULL,
  `month` int(3) NOT NULL,
  `years` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `Roleplay_Time`
--

INSERT INTO `Roleplay_Time` (`id`, `day`, `month`, `years`) VALUES
(1, 24, 6, 2013);

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

--
-- Structure de la table `Roleplay_Voitures`
--

CREATE TABLE IF NOT EXISTS `Roleplay_Voitures` (
  `pseudo` varchar(150) NOT NULL,
  `steam_id` varchar(64) NOT NULL,
  `Lambo` varchar(1) NOT NULL DEFAULT '0',
  `Audi_TT` varchar(1) NOT NULL DEFAULT '0',
  `Audi_S5` varchar(1) NOT NULL DEFAULT '0',
  `Citroen` varchar(1) NOT NULL DEFAULT '0',
  `LandRover` varchar(1) NOT NULL DEFAULT '0',
  `AST_Dbs` varchar(1) NOT NULL DEFAULT '0',
  `couleur` varchar(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


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