Hébergeur de fichiers indépendant

gta5 gamemode essential.sql

À propos

Type de fichier
Fichier SQL de 15 Ko (text/plain)
Confidentialité
Fichier public, envoyé le 17 juin 2017 à 16:56, depuis l'adresse IP 92.92.x.x (France)
Sécurité
Ne contient aucun Virus ou Malware connus - Dernière vérification: 2 jours
Statistiques
La présente page de téléchargement a été vue 741 fois depuis l'envoi du fichier
Page de téléchargement

Aperçu du fichier


-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Client :  127.0.0.1
-- Généré le :  Sam 17 Juin 2017 à 14:56
-- Version du serveur :  5.7.14
-- Version de PHP :  5.6.25

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

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

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

--
-- Structure de la table `bans`
--

CREATE TABLE `bans` (
  `id` int(10) UNSIGNED NOT NULL,
  `banned` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '0',
  `banner` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
  `reason` varchar(150) CHARACTER SET utf8mb4 NOT NULL DEFAULT '0',
  `expires` datetime NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `coordinates`
--

CREATE TABLE `coordinates` (
  `identifier` varchar(30) CHARACTER SET utf8mb4 NOT NULL,
  `x` double DEFAULT NULL,
  `y` double DEFAULT NULL,
  `z` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `coordinates`
--

INSERT INTO `coordinates` (`identifier`, `x`, `y`, `z`) VALUES
('steam:11000010b16f79d', 307.5695495605469, -1434.0152587890625, 29.905757904052734),
('steam:11000010b4821ca', -1408.091064453125, -1314.89013671875, 3.180938959121704);

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

--
-- Structure de la table `items`
--

CREATE TABLE `items` (
  `id` int(11) UNSIGNED NOT NULL,
  `libelle` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
  `value` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `items`
--

INSERT INTO `items` (`id`, `libelle`, `value`, `type`) VALUES
(1, 'Bouteille d\'eau', 20, 1),
(2, 'Sandwich', 20, 2),
(3, 'Filet Mignon', 20, 2),
(4, 'Cannabis', 0, 0),
(5, 'Cannabis roulé', 0, 0),
(6, 'Feuille Coka', 0, 0),
(7, 'Coka', 0, 0),
(8, 'Coka', 0, 0),
(9, 'Ephedrine ', 0, 0),
(10, 'Matière illégale', 0, 0),
(11, 'Matière illégale', 0, 0),
(12, 'Meth', 0, 0),
(13, 'Organe', 0, 0),
(14, 'Organe emballé', 0, 0),
(15, 'Organe analysé', 0, 0),
(16, 'Organe livrable', 0, 0),
(17, 'Cuivre', 0, 0),
(18, 'Fer', 0, 0),
(19, 'Diamants', 0, 0),
(20, 'Cuivre traité', 0, 0),
(21, 'Fer traité', 0, 0),
(22, 'Diamants traité', 0, 0),
(23, 'Roche', 0, 0),
(24, 'Roche traitée', 0, 0),
(25, 'Poisson', 5, 2),
(26, 'Corps', 0, 0),
(27, 'Corps traité', 0, 0);

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

--
-- Structure de la table `jobs`
--

CREATE TABLE `jobs` (
  `job_id` int(11) NOT NULL,
  `job_name` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
  `salary` int(11) NOT NULL DEFAULT '500'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `jobs`
--

INSERT INTO `jobs` (`job_id`, `job_name`, `salary`) VALUES
(1, 'Sans Emploi', 0),
(2, 'Nettoyeur de piscine', 0),
(3, 'Éboueur', 0),
(4, 'Mineur', 0),
(5, 'Chauffeur de taxi', 500),
(6, 'Livreur de bois', 0),
(7, 'Livreur de citerne', 0),
(8, 'Livreur de conteneur', 0),
(9, 'Livreur de médicament', 0),
(10, 'Policier', 0),
(11, 'Fossoyeur', 0),
(12, 'Préposé à la morgue', 0),
(13, 'Ambulancier', 500);

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

--
-- Structure de la table `outfits`
--

CREATE TABLE `outfits` (
  `identifier` varchar(30) CHARACTER SET utf8mb4 NOT NULL,
  `skin` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT 'mp_m_freemode_01',
  `face` int(11) NOT NULL DEFAULT '0',
  `face_text` int(11) NOT NULL DEFAULT '0',
  `hair` int(11) NOT NULL DEFAULT '0',
  `hair_text` int(11) NOT NULL DEFAULT '0',
  `pants` int(11) NOT NULL DEFAULT '0',
  `pants_text` int(11) NOT NULL DEFAULT '0',
  `shoes` int(11) NOT NULL DEFAULT '0',
  `shoes_text` int(11) NOT NULL DEFAULT '0',
  `torso` int(11) NOT NULL DEFAULT '0',
  `torso_text` int(11) NOT NULL DEFAULT '0',
  `shirt` int(11) NOT NULL DEFAULT '0',
  `shirt_text` int(11) NOT NULL DEFAULT '0',
  `three` int(11) NOT NULL DEFAULT '0',
  `three_text` int(11) NOT NULL DEFAULT '0',
  `seven` int(11) NOT NULL DEFAULT '0',
  `seven_text` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `outfits`
--

INSERT INTO `outfits` (`identifier`, `skin`, `face`, `face_text`, `hair`, `hair_text`, `pants`, `pants_text`, `shoes`, `shoes_text`, `torso`, `torso_text`, `shirt`, `shirt_text`, `three`, `three_text`, `seven`, `seven_text`) VALUES
('steam:11000010b16f79d', 'mp_m_freemode_01', 38, 0, 19, 3, 23, 2, 1, 11, 25, 5, 6, 7, 11, 0, 22, 8),
('steam:11000010b4821ca', 'mp_m_freemode_01', 0, 0, 3, 0, 7, 4, 12, 4, 5, 0, 15, 0, 5, 0, 17, 0);

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

--
-- Structure de la table `phonebook`
--

CREATE TABLE `phonebook` (
  `id` int(11) NOT NULL,
  `pidentifier` varchar(30) CHARACTER SET utf8mb4 DEFAULT '',
  `phonenumber` varchar(30) CHARACTER SET utf8mb4 DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `police`
--

CREATE TABLE `police` (
  `police_id` int(11) NOT NULL,
  `police_name` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
  `salary` int(11) NOT NULL DEFAULT '500'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `police`
--

INSERT INTO `police` (`police_id`, `police_name`, `salary`) VALUES
(1, 'Cadet', 500),
(2, 'Brigadier', 500),
(3, 'Sergent', 500),
(4, 'Lieutenant', 500),
(5, 'Capitaine', 500),
(6, 'Commandant', 500),
(7, 'Colonel', 500),
(8, 'Rien', 0);

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `ID` int(11) NOT NULL,
  `identifier` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `group` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '0',
  `permission_level` int(11) NOT NULL DEFAULT '0',
  `money` double NOT NULL DEFAULT '0',
  `bankbalance` int(32) DEFAULT '0',
  `job` int(11) DEFAULT '1',
  `police` int(11) DEFAULT '0',
  `enService` int(11) DEFAULT '0',
  `dirtymoney` double(11,0) NOT NULL DEFAULT '0',
  `isFirstConnection` int(11) DEFAULT '1',
  `nom` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `prenom` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `telephone` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`ID`, `identifier`, `group`, `permission_level`, `money`, `bankbalance`, `job`, `police`, `enService`, `dirtymoney`, `isFirstConnection`, `nom`, `prenom`, `telephone`) VALUES
(1, 'steam:11000010b16f79d', 'owner', 4, 0, 10000000, 1, 0, 0, 0, 1, 'Pireli', 'Aren', '976-1010'),
(2, 'steam:11000010b4821ca', 'owner', 4, 0, 1500000, 1, 0, 0, 0, 1, 'Pireli', 'Sofiane', '128-4010');

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

--
-- Structure de la table `user_appartement`
--

CREATE TABLE `user_appartement` (
  `id` int(11) NOT NULL,
  `identifier` varchar(60) NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `money` int(11) NOT NULL DEFAULT '0',
  `dirtymoney` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `user_inventory`
--

CREATE TABLE `user_inventory` (
  `user_id` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `item_id` int(11) UNSIGNED NOT NULL,
  `quantity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `user_inventory`
--

INSERT INTO `user_inventory` (`user_id`, `item_id`, `quantity`) VALUES
('steam:11000010b16f79d', 1, 0),
('steam:11000010b16f79d', 2, 0),
('steam:11000010b16f79d', 3, 0),
('steam:11000010b16f79d', 4, 0),
('steam:11000010b16f79d', 5, 0),
('steam:11000010b16f79d', 6, 0),
('steam:11000010b16f79d', 7, 0),
('steam:11000010b16f79d', 8, 0),
('steam:11000010b16f79d', 9, 0),
('steam:11000010b16f79d', 10, 0),
('steam:11000010b16f79d', 11, 0),
('steam:11000010b16f79d', 12, 0),
('steam:11000010b16f79d', 13, 0),
('steam:11000010b16f79d', 14, 0),
('steam:11000010b16f79d', 15, 0),
('steam:11000010b16f79d', 16, 0),
('steam:11000010b16f79d', 17, 0),
('steam:11000010b16f79d', 18, 0),
('steam:11000010b16f79d', 19, 0),
('steam:11000010b16f79d', 20, 0),
('steam:11000010b16f79d', 21, 0),
('steam:11000010b16f79d', 22, 0),
('steam:11000010b16f79d', 23, 0),
('steam:11000010b16f79d', 24, 0),
('steam:11000010b16f79d', 25, 0),
('steam:11000010b16f79d', 26, 0),
('steam:11000010b16f79d', 27, 0),
('steam:11000010b4821ca', 1, 0),
('steam:11000010b4821ca', 2, 0),
('steam:11000010b4821ca', 3, 0),
('steam:11000010b4821ca', 4, 0),
('steam:11000010b4821ca', 5, 0),
('steam:11000010b4821ca', 6, 0),
('steam:11000010b4821ca', 7, 0),
('steam:11000010b4821ca', 8, 0),
('steam:11000010b4821ca', 9, 0),
('steam:11000010b4821ca', 10, 0),
('steam:11000010b4821ca', 11, 0),
('steam:11000010b4821ca', 12, 0),
('steam:11000010b4821ca', 13, 0),
('steam:11000010b4821ca', 14, 0),
('steam:11000010b4821ca', 15, 0),
('steam:11000010b4821ca', 16, 0),
('steam:11000010b4821ca', 17, 0),
('steam:11000010b4821ca', 18, 0),
('steam:11000010b4821ca', 19, 0),
('steam:11000010b4821ca', 20, 0),
('steam:11000010b4821ca', 21, 0),
('steam:11000010b4821ca', 22, 0),
('steam:11000010b4821ca', 23, 0),
('steam:11000010b4821ca', 24, 0),
('steam:11000010b4821ca', 25, 0),
('steam:11000010b4821ca', 26, 0),
('steam:11000010b4821ca', 27, 0);

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

--
-- Structure de la table `user_vehicle`
--

CREATE TABLE `user_vehicle` (
  `ID` int(10) NOT NULL,
  `identifier` varchar(30) CHARACTER SET utf8mb4 NOT NULL,
  `vehicle_name` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_model` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_price` int(60) DEFAULT NULL,
  `vehicle_plate` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_state` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_colorprimary` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_colorsecondary` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `vehicle_pearlescentcolor` varchar(60) CHARACTER SET utf8mb4 NOT NULL,
  `vehicle_wheelcolor` varchar(60) CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `user_vehicle`
--

INSERT INTO `user_vehicle` (`ID`, `identifier`, `vehicle_name`, `vehicle_model`, `vehicle_price`, `vehicle_plate`, `vehicle_state`, `vehicle_colorprimary`, `vehicle_colorsecondary`, `vehicle_pearlescentcolor`, `vehicle_wheelcolor`) VALUES
(1, 'steam:11000010b16f79d', 'Faggio', 'faggio2', 4000, 'CTZNF79D', 'Rentré', '4', '0', '111', '156'),
(2, 'steam:11000010b4821ca', 'Faggio', 'faggio2', 4000, 'CTZN21CA', 'Sorti', '4', '0', '111', '156'),
(3, 'steam:11000010b4821ca', 'Sultan RS', 'sultanrs', 795000, 'CTZN21CA', 'Sorti', '64', '64', '70', '158'),
(4, 'steam:11000010b16f79d', 'Reaper', 'reaper', 1595000, 'CTZNF79D', 'Sorti', '3', '3', '5', '156'),
(8, 'steam:11000010b4821ca', 'Stirling GT', 'feltzer3', 975000, 'CTZN21CA', 'Sorti', '3', '3', '134', '156'),
(9, 'steam:11000010b16f79d', 'Akuma', 'AKUMA', 9000, 'CTZNF79D', 'Sorti', '0', '2', '4', '156');

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

--
-- Structure de la table `user_weapons`
--

CREATE TABLE `user_weapons` (
  `ID` int(10) NOT NULL,
  `identifier` varchar(30) CHARACTER SET utf8mb4 NOT NULL,
  `weapon_model` varchar(60) CHARACTER SET utf8mb4 NOT NULL,
  `withdraw_cost` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Index pour les tables exportées
--

--
-- Index pour la table `bans`
--
ALTER TABLE `bans`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `coordinates`
--
ALTER TABLE `coordinates`
  ADD PRIMARY KEY (`identifier`);

--
-- Index pour la table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`,`libelle`,`value`,`type`),
  ADD UNIQUE KEY `id` (`id`,`libelle`,`value`,`type`),
  ADD KEY `id_2` (`id`);

--
-- Index pour la table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`job_id`);

--
-- Index pour la table `outfits`
--
ALTER TABLE `outfits`
  ADD PRIMARY KEY (`identifier`);

--
-- Index pour la table `phonebook`
--
ALTER TABLE `phonebook`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `police`
--
ALTER TABLE `police`
  ADD PRIMARY KEY (`police_id`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`ID`);

--
-- Index pour la table `user_appartement`
--
ALTER TABLE `user_appartement`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `user_inventory`
--
ALTER TABLE `user_inventory`
  ADD PRIMARY KEY (`user_id`,`item_id`),
  ADD KEY `item_id` (`item_id`);

--
-- Index pour la table `user_vehicle`
--
ALTER TABLE `user_vehicle`
  ADD PRIMARY KEY (`ID`);

--
-- Index pour la table `user_weapons`
--
ALTER TABLE `user_weapons`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `bans`
--
ALTER TABLE `bans`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `items`
--
ALTER TABLE `items`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT pour la table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `job_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT pour la table `phonebook`
--
ALTER TABLE `phonebook`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `police`
--
ALTER TABLE `police`
  MODIFY `police_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `user_appartement`
--
ALTER TABLE `user_appartement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `user_vehicle`
--
ALTER TABLE `user_vehicle`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT pour la table `user_weapons`
--
ALTER TABLE `user_weapons`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;
--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `user_inventory`
--
ALTER TABLE `user_inventory`
  ADD CONSTRAINT `user_inventory_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`);

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


Partager le fichier


Télécharger gta5_gamemode_essential.sql


Télécharger gta5_gamemode_essential.sql