/*
Navicat MySQL Data Transfer

Source Server         : LocalHost
Source Server Version : 50714
Source Host           : localhost:3306
Source Database       : gta5_gamemode_essential

Target Server Type    : MYSQL
Target Server Version : 50714
File Encoding         : 65001

Date: 2017-08-29 01:34:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name_singulier` varchar(255) DEFAULT NULL,
  `name_pluriel` varchar(255) DEFAULT NULL,
  `item_price_name` varchar(11) DEFAULT NULL,
  `function_use_item` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', 'Tronc d\'arbre', 'Troncs d\'arbres', 'buche', '\"\"');
INSERT INTO `items` VALUES ('2', 'Planche de bois', 'Planches de bois', 'planche', '\"\"');
INSERT INTO `items` VALUES ('3', 'Poisson', 'Poissons', 'poisson', '\"\"');
INSERT INTO `items` VALUES ('4', 'Poisson surgelé', 'Poissons surgelés', 'surgele', '\"\"');
INSERT INTO `items` VALUES ('5', 'Fer', 'Fers', 'fer', '\"\"');
INSERT INTO `items` VALUES ('6', 'Alliage ferreux', 'Alliages ferreux', 'alliage', '()');
INSERT INTO `items` VALUES ('7', 'Blé', 'Blés', 'ble', '\"\"');
INSERT INTO `items` VALUES ('8', 'Farine', 'Farines', 'farine', '\"\"');
INSERT INTO `items` VALUES ('9', 'Lingot', 'Lingots', 'lingot', '\"\"');
INSERT INTO `items` VALUES ('10', 'Blé', 'Blés', 'ble', '\"\"');
INSERT INTO `items` VALUES ('11', 'Meth', 'Méths', 'meth', '\"\"');
INSERT INTO `items` VALUES ('12', 'Meth Transformée', 'Meths transformées', 'metht', '\"\"');
INSERT INTO `items` VALUES ('13', 'Feuille de sassafras', 'Feuilles de sassafras', 'feuille', '\"\"');
INSERT INTO `items` VALUES ('14', 'Ecstasy', 'Ecstasy', 'esctasy', '()');
INSERT INTO `items` VALUES ('15', 'Pierre précieuse', 'Pierres préciseuses', 'pierre', '\"\"');
INSERT INTO `items` VALUES ('16', 'Bijoux', 'Bijoux', 'bijoux', '\"\"');
INSERT INTO `items` VALUES ('17', 'Organe sales', 'Organes sales', 'organesw', '\"\"');
INSERT INTO `items` VALUES ('18', 'Organe stérilisé', 'Organses stérilisés', 'organesx', '\"\"');
INSERT INTO `items` VALUES ('19', 'Bois Brut', 'Bois brutes', 'bois', '\"\"');
INSERT INTO `items` VALUES ('20', 'Planche', 'Planches', 'planche', '\"\"');
INSERT INTO `items` VALUES ('21', 'Poisson', 'Poissons', 'poisson', '\"\"');
INSERT INTO `items` VALUES ('22', 'Filet de poisson', 'Filets de poisson', 'filet', '\"\"');
INSERT INTO `items` VALUES ('23', 'Viande fraiche', 'Viandes fraiches', 'viande', '\"\"');
INSERT INTO `items` VALUES ('24', 'Orge', 'Orges', 'orge', '\"\"');
INSERT INTO `items` VALUES ('25', 'Bière', 'Bières', 'biere', '()');
INSERT INTO `items` VALUES ('26', 'Raisin', 'Raisins', 'raisin', '\"\"');
INSERT INTO `items` VALUES ('27', 'Bouteille de vin', 'Bouteilles de vin', 'vin', '()');
INSERT INTO `items` VALUES ('28', 'Cocaine', 'Cocaines', 'cocaine', '()');
INSERT INTO `items` VALUES ('29', 'Document secret', 'Documents secrets', 'document', '\"\"');
INSERT INTO `items` VALUES ('30', 'Sandwich', 'Sandwich', 'sandwich', '()');
INSERT INTO `items` VALUES ('31', 'Faux papiers', 'Faux papiers', 'papiers', '\"\"');
INSERT INTO `items` VALUES ('32', 'Opium', 'Opium', 'opium', '\"\"');
INSERT INTO `items` VALUES ('33', 'Heroine', 'Heroines', 'heroine', '()');
INSERT INTO `items` VALUES ('34', 'GPS', 'GPS', 'gps', '\"\"');

-- ----------------------------
-- Table structure for j_cords
-- ----------------------------
DROP TABLE IF EXISTS `j_cords`;
CREATE TABLE `j_cords` (
  `id` int(11) NOT NULL,
  `XYZ` varchar(255) NOT NULL,
  `Détail` varchar(255) DEFAULT NULL,
  `X` varchar(255) DEFAULT NULL,
  `Y` varchar(255) DEFAULT NULL,
  `Z` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of j_cords
-- ----------------------------
INSERT INTO `j_cords` VALUES ('1', '{-573.619, 5847.39, 31.1281}', 'Bûcheron [Récolte]', '-573.619', '5847.39', '31.1281');
INSERT INTO `j_cords` VALUES ('2', '{-579.787, 5322.12, 70.2573}', 'Bûcheron [Traitement]', '579.787', '5322.12', '70.2573');
INSERT INTO `j_cords` VALUES ('3', '{-1920.84, 2047.32, 141.736}', 'Bûcheron [Revente]', '1920.84', '2047.32', '141.736');
INSERT INTO `j_cords` VALUES ('4', '{1369.0, -3588.0 , 1}', 'Pêcheur [Récolte]', '{1369.0', '3588.0 ', '1');
INSERT INTO `j_cords` VALUES ('5', '{-262.016, -2498.46, 7.00063}', 'Pêcheur [Traitement]', '262.016', '2498.46', '7.00063');
INSERT INTO `j_cords` VALUES ('6', '-{-39.9791, -2224.79, 8.81167}', 'Pêcheur [Revente]', '39.9791', '2224.79', '8.81167');
INSERT INTO `j_cords` VALUES ('7', '{2650.34, 2862.75, 38.0361}', 'Mineur [Récolte]', '{2650.34', '2862.75', '38.0361');
INSERT INTO `j_cords` VALUES ('8', '{618.961, 2944.4, 50.5652}', 'Mineur [Traitement]', '{618.961', '2944.4', '50.5652');
INSERT INTO `j_cords` VALUES ('9', '{2728.14, 1653.79, 25.5381}', 'Mineur [Revente]', '{2728.14', '1653.79', '25.5381');
INSERT INTO `j_cords` VALUES ('10', '{2153.51, 5175.35, 57.0247}', 'Paysan [Récolte]', '{2153.51', '5175.35', '57.0247');
INSERT INTO `j_cords` VALUES ('11', '{2928.25, 4635.6, 49.5451}', 'Paysan [Traitement]', '{2928.25', '4635.6', '49.5451');
INSERT INTO `j_cords` VALUES ('12', '{405.345, 6487.36, 29.6672}', 'Paysan [Revente]', '{405.345', '6487.36', '29.6672');
INSERT INTO `j_cords` VALUES ('0', '{1}', 'Pole Emploi', null, null, null);

-- ----------------------------
-- Table structure for j_entreprises
-- ----------------------------
DROP TABLE IF EXISTS `j_entreprises`;
CREATE TABLE `j_entreprises` (
  `id` int(11) NOT NULL,
  `positionXYZ` varchar(255) NOT NULL,
  `vehicule` varchar(255) NOT NULL,
  `job_id` int(11) DEFAULT NULL,
  `pdg_id` int(11) DEFAULT NULL,
  `capital` float(255,0) DEFAULT NULL,
  `Nom` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of j_entreprises
-- ----------------------------
INSERT INTO `j_entreprises` VALUES ('1', '{-841.662, 5401.07, 34.6152}', 'phantom', '2', null, null, 'Bûcheron');
INSERT INTO `j_entreprises` VALUES ('2', '{1197.18, -3253.49, 7.09519}', 'tug', '3', null, null, 'Pêcheur');
INSERT INTO `j_entreprises` VALUES ('3', '{966.19, -1933.19, 31.1261}', 'tiptruck2', '4', null, null, 'Mineur');
INSERT INTO `j_entreprises` VALUES ('4', '{1967.03, 4634.1, 41.1018}', 'tractor2', '5', null, null, 'Paysan');
INSERT INTO `j_entreprises` VALUES ('5', '{-353.458, -2265.58, 7.60818}', 'trash', '6', null, null, 'Eboueur');
INSERT INTO `j_entreprises` VALUES ('6', '{2889.61, 4391.44, 50.4517}', 'phantom', '7', null, null, 'Chauffeur de poids lourd');
INSERT INTO `j_entreprises` VALUES ('7', '{174.772, 6642.64, 31.5731}', 'packer', '8', null, null, 'Pompiste');
INSERT INTO `j_entreprises` VALUES ('8', '{-428.632, -1728.28, 19.7838}', 'taxi', '9', null, null, 'Taxi ');
INSERT INTO `j_entreprises` VALUES ('9', '{-428.632, -1728.28, 19.7838}', 'towtruck', '10', null, null, 'Dépanneur');

-- ----------------------------
-- Table structure for j_productions
-- ----------------------------
DROP TABLE IF EXISTS `j_productions`;
CREATE TABLE `j_productions` (
  `id` int(11) NOT NULL,
  `entreprise_id` int(11) NOT NULL,
  `recolte_cords` varchar(255) NOT NULL,
  `traitement_cords` varchar(255) NOT NULL,
  `revente_cords` varchar(255) NOT NULL,
  `vehicle_cords` varchar(255) DEFAULT NULL,
  `item_recolte_id` int(255) NOT NULL,
  `item_traitement_id` int(255) NOT NULL,
  `item_revente_id` int(255) NOT NULL,
  `prix_revente` double(255,0) NOT NULL,
  `Détail` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of j_productions
-- ----------------------------
INSERT INTO `j_productions` VALUES ('1', '1', '{-573.619, 5847.39, 30.1281}', '{-579.787, 5322.12, 70.2573}', '{-1920.84, 2047.32, 140.736}', '{-803.714, 5408.177,  33.975}', '1', '2', '2', '100', 'Bûcheron [Production]');
INSERT INTO `j_productions` VALUES ('2', '2', '{1369.0, -3588.0 , 1}', '{-262.016, -2498.46, 6.00063}', '{-39.9791, -2224.79, 7.81167}', '{1296.87, -3163.01, 5.90627}', '3', '4', '4', '100', 'Pêcheur [Production]');
INSERT INTO `j_productions` VALUES ('3', '3', '{2650.34, 2862.75, 38.0361}', '{618.961, 2944.4, 49.5652}', '{2728.14, 1653.79, 24.5381}', '{985.30, -1923.32,  31.1261}', '5', '6', '6', '100', 'Mineur [Production]');
INSERT INTO `j_productions` VALUES ('4', '4', '{2153.51, 5175.35, 56.0247}', '{2928.25, 4635.6, 48.5451}', '{405.345, 6487.36, 28.6672}', '{1945.37, 4637.47, 40.5787}', '7', '8', '8', '100', 'Paysan [Production]');

-- ----------------------------
-- Table structure for j_tenues
-- ----------------------------
DROP TABLE IF EXISTS `j_tenues`;
CREATE TABLE `j_tenues` (
  `id` int(11) NOT NULL,
  `componentid` int(11) DEFAULT NULL,
  `drawableid` int(11) DEFAULT NULL,
  `textureid` int(11) DEFAULT NULL,
  `paletteid` int(11) DEFAULT NULL,
  `job_id` int(11) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of j_tenues
-- ----------------------------
INSERT INTO `j_tenues` VALUES ('1', '11', '41', '0', '2', '2', '[Bûcheron] - Haut');
INSERT INTO `j_tenues` VALUES ('2', '8', '59', '0', '2', '2', '[Bûcheron] - Torse');
INSERT INTO `j_tenues` VALUES ('3', '4', '7', '0', '2', '2', '[Bûcheron] - Pentalon');
INSERT INTO `j_tenues` VALUES ('4', '6', '25', '0', '2', '2', '[Bûcheron] - Chaussures');
INSERT INTO `j_tenues` VALUES ('5', '3', '66', '0', '2', '2', '[Bûcheron] - Bas');
INSERT INTO `j_tenues` VALUES ('6', '11', '124', '0', '2', '3', '[Pêcheur] - Haut');
INSERT INTO `j_tenues` VALUES ('7', '8', '24', '1', '2', '3', '[Pêcheur] - Torse');
INSERT INTO `j_tenues` VALUES ('8', '4', '47', '1', '2', '3', '[Pêcheur] - Pentalon');
INSERT INTO `j_tenues` VALUES ('9', '6', '25', '0', '2', '3', '[Pêcheur] - Chaussures');
INSERT INTO `j_tenues` VALUES ('10', '3', '108', '0', '2', '3', '[Pêcheur] - Bas');
INSERT INTO `j_tenues` VALUES ('11', '11', '5', '0', '2', '4', '[Mineur] - Haut');
INSERT INTO `j_tenues` VALUES ('12', '8', '59', '0', '2', '4', '[Mineur] - Torse');
INSERT INTO `j_tenues` VALUES ('13', '4', '0', '12', '2', '4', '[Mineur] - Pentalon');
INSERT INTO `j_tenues` VALUES ('14', '6', '25', '0', '2', '4', '[Mineur] - Chaussures');
INSERT INTO `j_tenues` VALUES ('15', '3', '34', '0', '2', '4', '[Mineur] - Bas');
INSERT INTO `j_tenues` VALUES ('16', '11', '97', '0', '2', '5', '[Paysan] - Haut');
INSERT INTO `j_tenues` VALUES ('17', '8', '15', '0', '2', '5', '[Paysan] - Torse');
INSERT INTO `j_tenues` VALUES ('18', '4', '62', '1', '2', '5', '[Paysan] - Pentalon');
INSERT INTO `j_tenues` VALUES ('19', '6', '12', '6', '2', '5', '[Paysan] - Chaussures');
INSERT INTO `j_tenues` VALUES ('20', '3', '0', '0', '2', '5', '[Paysan] - Bas');

-- ----------------------------
-- Table structure for user_inventory
-- ----------------------------
DROP TABLE IF EXISTS `user_inventory`;
CREATE TABLE `user_inventory` (
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`item_id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `user_inventory_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_inventory
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;
