-- phpMyAdmin SQL Dump
-- version 3.3.7deb8
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Gйnйrй le : Dim 08 Mars 2015 а 20:47
-- Version du serveur: 5.1.73
-- Version de PHP: 5.3.3-7+squeeze25
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `Black`
--
-- --------------------------------------------------------
--
-- Structure de la table `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Username` varchar(24) DEFAULT NULL,
`Password` varchar(129) DEFAULT NULL,
`RegisterDate` varchar(36) DEFAULT NULL,
`LoginDate` varchar(36) DEFAULT NULL,
`IP` varchar(16) DEFAULT 'n/a',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=161 ;
-- --------------------------------------------------------
--
-- Structure de la table `arrestpoints`
--
CREATE TABLE IF NOT EXISTS `arrestpoints` (
`arrestID` int(11) NOT NULL AUTO_INCREMENT,
`arrestX` float NOT NULL,
`arrestY` float NOT NULL,
`arrestZ` float NOT NULL,
`arrestInterior` int(11) NOT NULL,
`arrestWorld` int(11) NOT NULL,
PRIMARY KEY (`arrestID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `arrestpoints`
--
INSERT INTO `arrestpoints` (`arrestID`, `arrestX`, `arrestY`, `arrestZ`, `arrestInterior`, `arrestWorld`) VALUES
(2, 1222.21, -1309.7, 796.787, 5, 10000);
-- --------------------------------------------------------
--
-- Structure de la table `atm`
--
CREATE TABLE IF NOT EXISTS `atm` (
`atmID` int(11) NOT NULL,
`atmA` float NOT NULL,
`atmX` float NOT NULL,
`atmY` float NOT NULL,
`atmZ` float NOT NULL,
`atmInterior` int(11) NOT NULL,
`atmWorld` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `atm`
--
INSERT INTO `atm` (`atmID`, `atmA`, `atmX`, `atmY`, `atmZ`, `atmInterior`, `atmWorld`) VALUES
(0, 356.396, 1702.37, -1802.7, 13.5468, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `backpackitems`
--
CREATE TABLE IF NOT EXISTS `backpackitems` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
-- --------------------------------------------------------
--
-- Structure de la table `backpacks`
--
CREATE TABLE IF NOT EXISTS `backpacks` (
`backpackID` int(12) NOT NULL AUTO_INCREMENT,
`backpackPlayer` int(12) DEFAULT '0',
`backpackX` float DEFAULT '0',
`backpackY` float DEFAULT '0',
`backpackZ` float DEFAULT '0',
`backpackInterior` int(12) DEFAULT '0',
`backpackWorld` int(12) DEFAULT '0',
`backpackHouse` int(12) DEFAULT '0',
`backpackVehicle` int(12) DEFAULT '0',
PRIMARY KEY (`backpackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
--
-- Structure de la table `billboards`
--
CREATE TABLE IF NOT EXISTS `billboards` (
`bbID` int(12) NOT NULL AUTO_INCREMENT,
`bbExists` int(12) DEFAULT '0',
`bbName` varchar(32) DEFAULT NULL,
`bbOwner` int(12) NOT NULL DEFAULT '0',
`bbPrice` int(12) NOT NULL DEFAULT '0',
`bbRange` int(12) DEFAULT '10',
`bbPosX` float DEFAULT '0',
`bbPosY` float DEFAULT '0',
`bbPosZ` float DEFAULT '0',
`bbMessage` varchar(230) DEFAULT NULL,
PRIMARY KEY (`bbID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `billboards`
--
-- --------------------------------------------------------
--
-- Structure de la table `blacklist`
--
CREATE TABLE IF NOT EXISTS `blacklist` (
`IP` varchar(16) DEFAULT '0.0.0.0',
`Username` varchar(24) DEFAULT NULL,
`BannedBy` varchar(24) DEFAULT NULL,
`Reason` varchar(128) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `blacklist`
--
-- --------------------------------------------------------
--
-- Structure de la table `businesses`
--
CREATE TABLE IF NOT EXISTS `businesses` (
`bizID` int(12) NOT NULL AUTO_INCREMENT,
`bizName` varchar(32) DEFAULT NULL,
`bizOwner` int(12) DEFAULT '0',
`bizType` int(12) DEFAULT '0',
`bizPrice` int(12) DEFAULT '0',
`bizPosX` float DEFAULT '0',
`bizPosY` float DEFAULT '0',
`bizPosZ` float DEFAULT '0',
`bizPosA` float DEFAULT '0',
`bizIntX` float DEFAULT '0',
`bizIntY` float DEFAULT '0',
`bizIntZ` float DEFAULT '0',
`bizIntA` float DEFAULT '0',
`bizInterior` int(12) DEFAULT '0',
`bizExterior` int(12) DEFAULT '0',
`bizExteriorVW` int(12) DEFAULT '0',
`bizLocked` int(4) DEFAULT '0',
`bizVault` int(12) DEFAULT '0',
`bizProducts` int(12) DEFAULT '0',
`bizPrice1` int(12) DEFAULT '0',
`bizPrice2` int(12) DEFAULT '0',
`bizPrice3` int(12) DEFAULT '0',
`bizPrice4` int(12) DEFAULT '0',
`bizPrice5` int(12) DEFAULT '0',
`bizPrice6` int(12) DEFAULT '0',
`bizPrice7` int(12) DEFAULT '0',
`bizPrice8` int(12) DEFAULT '0',
`bizPrice9` int(12) DEFAULT '0',
`bizPrice10` int(12) DEFAULT '0',
`bizSpawnX` float DEFAULT '0',
`bizSpawnY` float DEFAULT '0',
`bizSpawnZ` float DEFAULT '0',
`bizSpawnA` float DEFAULT '0',
`bizDeliverX` float DEFAULT '0',
`bizDeliverY` float DEFAULT '0',
`bizDeliverZ` float DEFAULT '0',
`bizMessage` varchar(128) DEFAULT NULL,
`bizPrice11` int(12) DEFAULT '0',
`bizPrice12` int(12) DEFAULT '0',
`bizPrice13` int(12) DEFAULT '0',
`bizPrice14` int(12) DEFAULT '0',
`bizPrice15` int(12) DEFAULT '0',
`bizPrice16` int(12) DEFAULT '0',
`bizPrice17` int(12) DEFAULT '0',
`bizPrice18` int(12) DEFAULT '0',
`bizPrice19` int(12) DEFAULT '0',
`bizPrice20` int(12) DEFAULT '0',
`bizShipment` int(4) DEFAULT '0',
PRIMARY KEY (`bizID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
-- --------------------------------------------------------
--
-- Structure de la table `cars`
--
CREATE TABLE IF NOT EXISTS `cars` (
`carID` int(12) NOT NULL AUTO_INCREMENT,
`carModel` int(12) DEFAULT '0',
`carOwner` int(12) DEFAULT '0',
`carPosX` float DEFAULT '0',
`carPosY` float DEFAULT '0',
`carPosZ` float DEFAULT '0',
`carPosR` float DEFAULT '0',
`carColor1` int(12) DEFAULT '0',
`carColor2` int(12) DEFAULT '0',
`carPaintjob` int(12) DEFAULT '-1',
`carLocked` int(4) DEFAULT '0',
`carMod1` int(12) DEFAULT '0',
`carMod2` int(12) DEFAULT '0',
`carMod3` int(12) DEFAULT '0',
`carMod4` int(12) DEFAULT '0',
`carMod5` int(12) DEFAULT '0',
`carMod6` int(12) DEFAULT '0',
`carMod7` int(12) DEFAULT '0',
`carMod8` int(12) DEFAULT '0',
`carMod9` int(12) DEFAULT '0',
`carMod10` int(12) DEFAULT '0',
`carMod11` int(12) DEFAULT '0',
`carMod12` int(12) DEFAULT '0',
`carMod13` int(12) DEFAULT '0',
`carMod14` int(12) DEFAULT '0',
`carImpounded` int(12) DEFAULT '0',
`carWeapon1` int(12) DEFAULT '0',
`carAmmo1` int(12) DEFAULT '0',
`carWeapon2` int(12) DEFAULT '0',
`carAmmo2` int(12) DEFAULT '0',
`carWeapon3` int(12) DEFAULT '0',
`carAmmo3` int(12) DEFAULT '0',
`carWeapon4` int(12) DEFAULT '0',
`carAmmo4` int(12) DEFAULT '0',
`carWeapon5` int(12) DEFAULT '0',
`carAmmo5` int(12) DEFAULT '0',
`carImpoundPrice` int(12) DEFAULT '0',
`carFaction` int(12) DEFAULT '0',
`carJob` int(12) DEFAULT '0',
PRIMARY KEY (`carID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=219 ;
-- --------------------------------------------------------
--
-- Structure de la table `carstorage`
--
CREATE TABLE IF NOT EXISTS `carstorage` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Structure de la table `characters`
--
CREATE TABLE IF NOT EXISTS `characters` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Username` varchar(24) DEFAULT NULL,
`Character` varchar(24) DEFAULT NULL,
`Created` int(4) DEFAULT '0',
`Gender` int(4) DEFAULT '0',
`Birthdate` varchar(32) DEFAULT '01/01/1970',
`Origin` varchar(32) DEFAULT 'Not Specified',
`Skin` int(12) DEFAULT '0',
`Glasses` int(12) DEFAULT '0',
`Hat` int(12) DEFAULT '0',
`Bandana` int(12) DEFAULT '0',
`PosX` float DEFAULT '0',
`PosY` float DEFAULT '0',
`PosZ` float DEFAULT '0',
`PosA` float DEFAULT '0',
`Interior` int(12) DEFAULT '0',
`World` int(12) DEFAULT '0',
`GlassesPos` varchar(100) DEFAULT NULL,
`HatPos` varchar(100) DEFAULT NULL,
`BandanaPos` varchar(100) DEFAULT NULL,
`Hospital` int(12) DEFAULT '-1',
`HospitalInt` int(12) DEFAULT '0',
`Money` int(12) DEFAULT '0',
`BankMoney` int(12) DEFAULT '0',
`OwnsBillboard` int(12) DEFAULT '-1',
`Savings` int(12) DEFAULT '0',
`Admin` int(12) DEFAULT '0',
`JailTime` int(12) DEFAULT '0',
`Muted` int(4) DEFAULT '0',
`CreateDate` int(12) DEFAULT '0',
`LastLogin` int(12) DEFAULT '0',
`Tester` int(4) DEFAULT '0',
`Gun1` int(12) DEFAULT '0',
`Gun2` int(12) DEFAULT '0',
`Gun3` int(12) DEFAULT '0',
`Gun4` int(12) DEFAULT '0',
`Gun5` int(12) DEFAULT '0',
`Gun6` int(12) DEFAULT '0',
`Gun7` int(12) DEFAULT '0',
`Gun8` int(12) DEFAULT '0',
`Gun9` int(12) DEFAULT '0',
`Gun10` int(12) DEFAULT '0',
`Gun11` int(12) DEFAULT '0',
`Gun12` int(12) DEFAULT '0',
`Gun13` int(12) DEFAULT '0',
`Ammo1` int(12) DEFAULT '0',
`Ammo2` int(12) DEFAULT '0',
`Ammo3` int(12) DEFAULT '0',
`Ammo4` int(12) DEFAULT '0',
`Ammo5` int(12) DEFAULT '0',
`Ammo6` int(12) DEFAULT '0',
`Ammo7` int(12) DEFAULT '0',
`Ammo8` int(12) DEFAULT '0',
`Ammo9` int(12) DEFAULT '0',
`Ammo10` int(12) DEFAULT '0',
`Ammo11` int(12) DEFAULT '0',
`Ammo12` int(12) DEFAULT '0',
`Ammo13` int(12) DEFAULT '0',
`House` int(12) DEFAULT '-1',
`Business` int(12) DEFAULT '-1',
`Phone` int(12) DEFAULT '0',
`Lottery` int(12) DEFAULT '0',
`Hunger` int(12) DEFAULT '100',
`Thirst` int(12) DEFAULT '100',
`PlayingHours` int(12) DEFAULT '0',
`Minutes` int(12) DEFAULT '0',
`ArmorStatus` float DEFAULT '0',
`Entrance` int(12) DEFAULT '0',
`Job` int(12) DEFAULT '0',
`Faction` int(12) DEFAULT '-1',
`FactionRank` int(12) DEFAULT '0',
`Prisoned` int(4) DEFAULT '0',
`Warrants` int(12) DEFAULT '0',
`Injured` int(4) DEFAULT '0',
`Health` float DEFAULT '0',
`Channel` int(12) DEFAULT '0',
`Accent` varchar(24) DEFAULT NULL,
`Bleeding` int(4) DEFAULT '0',
`Warnings` int(12) DEFAULT '0',
`Warn1` varchar(32) DEFAULT NULL,
`Warn2` varchar(32) DEFAULT NULL,
`MaskID` int(12) DEFAULT '0',
`FactionMod` int(12) DEFAULT '0',
`Capacity` int(12) DEFAULT '35',
`AdminHide` int(4) DEFAULT '0',
`LotteryB` int(11) NOT NULL,
`SpawnPoint` int(11) NOT NULL,
`Experiance` int(11) DEFAULT '0',
`Niveau` int(11) DEFAULT '0',
`BraquageSac` int(11) DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ;
-- --------------------------------------------------------
--
-- Structure de la table `contacts`
--
CREATE TABLE IF NOT EXISTS `contacts` (
`ID` int(12) DEFAULT '0',
`contactID` int(12) NOT NULL AUTO_INCREMENT,
`contactName` varchar(32) DEFAULT NULL,
`contactNumber` int(12) DEFAULT '0',
PRIMARY KEY (`contactID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Structure de la table `crates`
--
CREATE TABLE IF NOT EXISTS `crates` (
`crateID` int(12) NOT NULL AUTO_INCREMENT,
`crateType` int(12) DEFAULT '0',
`crateX` float DEFAULT '0',
`crateY` float DEFAULT '0',
`crateZ` float DEFAULT '0',
`crateA` float DEFAULT '0',
`crateInterior` int(12) DEFAULT '0',
`crateWorld` int(12) DEFAULT '0',
PRIMARY KEY (`crateID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
-- --------------------------------------------------------
--
-- Structure de la table `dealervehicles`
--
CREATE TABLE IF NOT EXISTS `dealervehicles` (
`ID` int(12) DEFAULT '0',
`vehID` int(12) NOT NULL AUTO_INCREMENT,
`vehModel` int(12) DEFAULT '0',
`vehPrice` int(12) DEFAULT '0',
PRIMARY KEY (`vehID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;
-- --------------------------------------------------------
--
-- Structure de la table `detectors`
--
CREATE TABLE IF NOT EXISTS `detectors` (
`detectorID` int(12) NOT NULL AUTO_INCREMENT,
`detectorX` float DEFAULT '0',
`detectorY` float DEFAULT '0',
`detectorZ` float DEFAULT '0',
`detectorAngle` float DEFAULT '0',
`detectorInterior` int(12) DEFAULT '0',
`detectorWorld` int(12) DEFAULT '0',
PRIMARY KEY (`detectorID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Contenu de la table `detectors`
--
-- --------------------------------------------------------
--
-- Structure de la table `dropped`
--
CREATE TABLE IF NOT EXISTS `dropped` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemX` float DEFAULT '0',
`itemY` float DEFAULT '0',
`itemZ` float DEFAULT '0',
`itemInt` int(12) DEFAULT '0',
`itemWorld` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
`itemAmmo` int(12) DEFAULT '0',
`itemWeapon` int(12) DEFAULT '0',
`itemPlayer` varchar(24) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;
-- --------------------------------------------------------
--
-- Structure de la table `entrances`
--
CREATE TABLE IF NOT EXISTS `entrances` (
`entranceID` int(12) NOT NULL AUTO_INCREMENT,
`entranceName` varchar(32) DEFAULT NULL,
`entranceIcon` int(12) DEFAULT '0',
`entrancePosX` float DEFAULT '0',
`entrancePosY` float DEFAULT '0',
`entrancePosZ` float DEFAULT '0',
`entrancePosA` float DEFAULT '0',
`entranceIntX` float DEFAULT '0',
`entranceIntY` float DEFAULT '0',
`entranceIntZ` float DEFAULT '0',
`entranceIntA` float DEFAULT '0',
`entranceInterior` int(12) DEFAULT '0',
`entranceExterior` int(12) DEFAULT '0',
`entranceExteriorVW` int(12) DEFAULT '0',
`entranceType` int(12) DEFAULT '0',
`entrancePass` varchar(32) DEFAULT NULL,
`entranceLocked` int(12) DEFAULT '0',
`entranceCustom` int(4) DEFAULT '0',
`entranceWorld` int(12) DEFAULT '0',
PRIMARY KEY (`entranceID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;
--
-- Contenu de la table `entrances`
--
INSERT INTO `entrances` (`entranceID`, `entranceName`, `entranceIcon`, `entrancePosX`, `entrancePosY`, `entrancePosZ`, `entrancePosA`, `entranceIntX`, `entranceIntY`, `entranceIntZ`, `entranceIntA`, `entranceInterior`, `entranceExterior`, `entranceExteriorVW`, `entranceType`, `entrancePass`, `entranceLocked`, `entranceCustom`, `entranceWorld`) VALUES
(7, 'Los Santos Police Departement', 0, 1555.5, -1675.56, 16.1953, 268.392, 1587.61, -1709.62, -36.8138, 182.455, 1, 0, 0, 0, '', 0, 0, 0),
(10, 'Los Santos Bank', 0, 800.833, -1738.8, 13.5467, 84.8117, 1456.19, -987.942, 996.105, 90, 6, 0, 0, 2, 'D', 0, 0, 7010),
(12, 'Prйsidence Los Santos', 0, 1310.27, -1367.8, 13.5409, 359.531, 304.017, -141.989, 1004.06, 90, 7, 0, 0, 0, 'Sa', 0, 0, 7012),
(56, 'Mairie Los Santos', 0, 1481.05, -1770.86, 18.7957, 178.388, 390.169, 173.807, 1008.38, 90, 3, 0, 0, 4, '', 0, 0, 7056),
(58, 'San News', 0, 1700.27, -1772.51, 13.6315, 264.769, 1886.76, -900.474, 980.594, 85.4726, 0, 0, 0, 0, '', 0, 1, 7058),
(59, '2 иme Etage', 0, 1866.01, -891.867, 980.732, 91.6697, 1866.52, -891.74, 987.651, 89.163, 0, 0, 7059, 0, '', 0, 0, 7059),
(60, 'FBI', 0, 1654.02, -1655.51, 22.5156, 358.749, 288.839, 167.193, 1007.17, 178.291, 3, 0, 0, 0, '', 0, 0, 7060),
(61, 'C.I.A', 0, 1676.96, -1634.8, 14.2265, 92.0987, 238.648, 140.134, 1003.02, 177.374, 3, 0, 0, 0, '', 0, 0, 7061),
(62, 'Stand de tir', 0, 1739.31, -1583.28, 14.1582, 2.0409, 304.017, -141.989, 1004.06, 90, 7, 0, 0, 5, '', 0, 0, 7062),
(63, 'LSPD - Sous-sol', 0, 1525.7, -1677.88, 5.8906, 90.895, 1577.35, -1743.22, -36.8139, 88.4541, 1, 0, 0, 0, '', 0, 0, 7063),
(64, 'Dealer d''armes', 6, -86.2813, -299.681, 2.7646, 358.401, 2570.05, -1301.92, 1044.12, 270.668, 2, 0, 0, 0, '', 0, 0, 7013),
(67, 'Dock', 0, 1848.23, -1761.18, 13.5468, 142.311, 1307.93, -55.8922, 1002.5, 93.2057, 18, 0, 0, 3, '', 0, 0, 7067),
(68, '#Legendary Motors', 27, 2005.9, -1760.55, 13.539, 179.449, 1999.5, -1765.76, 13.2506, 3.0637, 0, 0, 0, 0, '', 0, 0, 0),
(69, 'Cosa Nostra', 0, 328.897, -1513.14, 36.039, 48.7978, 2214.64, -1150.51, 1025.8, 265.678, 15, 0, 0, 0, '', 0, 0, 7069);
-- --------------------------------------------------------
--
-- Structure de la table `factions`
--
CREATE TABLE IF NOT EXISTS `factions` (
`factionID` int(12) NOT NULL AUTO_INCREMENT,
`factionName` varchar(32) DEFAULT NULL,
`factionColor` int(12) DEFAULT '0',
`factionType` int(12) DEFAULT '0',
`factionRanks` int(12) DEFAULT '0',
`factionLockerX` float DEFAULT '0',
`factionLockerY` float DEFAULT '0',
`factionLockerZ` float DEFAULT '0',
`factionLockerInt` int(12) DEFAULT '0',
`factionLockerWorld` int(12) DEFAULT '0',
`factionWeapon1` int(12) DEFAULT '0',
`factionAmmo1` int(12) DEFAULT '0',
`factionWeapon2` int(12) DEFAULT '0',
`factionAmmo2` int(12) DEFAULT '0',
`factionWeapon3` int(12) DEFAULT '0',
`factionAmmo3` int(12) DEFAULT '0',
`factionWeapon4` int(12) DEFAULT '0',
`factionAmmo4` int(12) DEFAULT '0',
`factionWeapon5` int(12) DEFAULT '0',
`factionAmmo5` int(12) DEFAULT '0',
`factionWeapon6` int(12) DEFAULT '0',
`factionAmmo6` int(12) DEFAULT '0',
`factionWeapon7` int(12) DEFAULT '0',
`factionAmmo7` int(12) DEFAULT '0',
`factionWeapon8` int(12) DEFAULT '0',
`factionAmmo8` int(12) DEFAULT '0',
`factionWeapon9` int(12) DEFAULT '0',
`factionAmmo9` int(12) DEFAULT '0',
`factionWeapon10` int(12) DEFAULT '0',
`factionAmmo10` int(12) DEFAULT '0',
`factionRank1` varchar(32) DEFAULT NULL,
`factionRank2` varchar(32) DEFAULT NULL,
`factionRank3` varchar(32) DEFAULT NULL,
`factionRank4` varchar(32) DEFAULT NULL,
`factionRank5` varchar(32) DEFAULT NULL,
`factionRank6` varchar(32) DEFAULT NULL,
`factionRank7` varchar(32) DEFAULT NULL,
`factionRank8` varchar(32) DEFAULT NULL,
`factionRank9` varchar(32) DEFAULT NULL,
`factionRank10` varchar(32) DEFAULT NULL,
`factionRank11` varchar(32) DEFAULT NULL,
`factionRank12` varchar(32) DEFAULT NULL,
`factionRank13` varchar(32) DEFAULT NULL,
`factionRank14` varchar(32) DEFAULT NULL,
`factionRank15` varchar(32) DEFAULT NULL,
`factionSkin1` int(12) DEFAULT '0',
`factionSkin2` int(12) DEFAULT '0',
`factionSkin3` int(12) DEFAULT '0',
`factionSkin4` int(12) DEFAULT '0',
`factionSkin5` int(12) DEFAULT '0',
`factionSkin6` int(12) DEFAULT '0',
`factionSkin7` int(12) DEFAULT '0',
`factionSkin8` int(12) DEFAULT '0',
`SpawnX` float NOT NULL,
`SpawnY` float NOT NULL,
`SpawnZ` float NOT NULL,
`SpawnInterior` int(11) NOT NULL,
`SpawnVW` int(1) NOT NULL,
PRIMARY KEY (`factionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Contenu de la table `factions`
--
INSERT INTO `factions` (`factionID`, `factionName`, `factionColor`, `factionType`, `factionRanks`, `factionLockerX`, `factionLockerY`, `factionLockerZ`, `factionLockerInt`, `factionLockerWorld`, `factionWeapon1`, `factionAmmo1`, `factionWeapon2`, `factionAmmo2`, `factionWeapon3`, `factionAmmo3`, `factionWeapon4`, `factionAmmo4`, `factionWeapon5`, `factionAmmo5`, `factionWeapon6`, `factionAmmo6`, `factionWeapon7`, `factionAmmo7`, `factionWeapon8`, `factionAmmo8`, `factionWeapon9`, `factionAmmo9`, `factionWeapon10`, `factionAmmo10`, `factionRank1`, `factionRank2`, `factionRank3`, `factionRank4`, `factionRank5`, `factionRank6`, `factionRank7`, `factionRank8`, `factionRank9`, `factionRank10`, `factionRank11`, `factionRank12`, `factionRank13`, `factionRank14`, `factionRank15`, `factionSkin1`, `factionSkin2`, `factionSkin3`, `factionSkin4`, `factionSkin5`, `factionSkin6`, `factionSkin7`, `factionSkin8`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnInterior`, `SpawnVW`) VALUES
(1, 'Los Santos Police Departement.', -256, 1, 5, 1591.01, -1753.53, -36.814, 1, 0, 24, 500, 31, 50, 25, 500, 34, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 286, 285, 280, 283, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Legendary Motors', -256, 6, 5, 2000.92, -1768.07, 13.2505, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'Los Santos Medical Center', -256, 3, 5, -196.663, -1748.87, 675.769, 3, 5003, 42, 2000, 22, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 274, 275, 276, 277, 278, 279, 0, 0, 0, 0, 0, 0, 0),
(4, 'C.I.A', -256, 1, 5, 215.546, 187.762, 1003.03, 3, 7060, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'Groove street', -256, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, '19Th Piru Street.', 3, 5, 5, 2055.87, -1717.78, 13.5546, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 14, 6, 19, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(9, 'Cosa Nostra', -256, 2, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Hells Angels', -256, 5, 5, 1083.14, -1227.01, 15.8203, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 'Cartel De Sinaloa', -256, 5, 5, 2321.47, -1007.47, 1050.21, 9, 5037, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(12, 'Mairie', -256, 4, 5, 351.936, 197.19, 1008.38, 3, 7056, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `furniture`
--
CREATE TABLE IF NOT EXISTS `furniture` (
`ID` int(12) DEFAULT '0',
`furnitureID` int(12) NOT NULL AUTO_INCREMENT,
`furnitureName` varchar(32) DEFAULT NULL,
`furnitureModel` int(12) DEFAULT '0',
`furnitureX` float DEFAULT '0',
`furnitureY` float DEFAULT '0',
`furnitureZ` float DEFAULT '0',
`furnitureRX` float DEFAULT '0',
`furnitureRY` float DEFAULT '0',
`furnitureRZ` float DEFAULT '0',
`furnitureType` int(12) DEFAULT '0',
PRIMARY KEY (`furnitureID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Contenu de la table `furniture`
--
INSERT INTO `furniture` (`ID`, `furnitureID`, `furnitureName`, `furnitureModel`, `furnitureX`, `furnitureY`, `furnitureZ`, `furnitureRX`, `furnitureRY`, `furnitureRZ`, `furnitureType`) VALUES
(31, 5, 'Table 27', 2030, 2256.76, -1212.68, 1047.52, 0, 0, 58.353, 0),
(13, 6, 'Exercise Bike', 2630, 2257.54, -1213.85, 1048, 0, 0, -91.5989, 0),
(13, 7, 'Table 1', 1433, 2257.04, -1209.72, 1048.15, 0, 0, 179.868, 0);
-- --------------------------------------------------------
--
-- Structure de la table `garbage`
--
CREATE TABLE IF NOT EXISTS `garbage` (
`garbageID` int(12) NOT NULL AUTO_INCREMENT,
`garbageModel` int(12) DEFAULT '1236',
`garbageCapacity` int(12) DEFAULT '0',
`garbageX` float DEFAULT '0',
`garbageY` float DEFAULT '0',
`garbageZ` float DEFAULT '0',
`garbageA` float DEFAULT '0',
`garbageInterior` int(12) DEFAULT '0',
`garbageWorld` int(12) DEFAULT '0',
PRIMARY KEY (`garbageID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Contenu de la table `garbage`
--
INSERT INTO `garbage` (`garbageID`, `garbageModel`, `garbageCapacity`, `garbageX`, `garbageY`, `garbageZ`, `garbageA`, `garbageInterior`, `garbageWorld`) VALUES
(6, 1300, 0, 1523.63, -1679.98, 13.5466, 0.18, 0, 0),
(7, 1236, 0, 1543.68, -1450.2, 13.5468, 178.238, 0, 0),
(8, 1300, 0, 1721.38, -1422.12, 13.5468, 358.144, 0, 0),
(13, 1236, 0, 1860.89, -1392.38, 13.5625, 268.911, 0, 0),
(14, 1300, 0, 2039.98, -1418.98, 17.1707, 169.95, 0, 0),
(17, 1236, 0, 2119.55, -1790.12, 13.5546, 179.271, 0, 0),
(18, 1300, 0, 1953.72, -1765.36, 13.5466, 159.831, 0, 0),
(19, 1300, 0, 1778.25, -1861.47, 13.5775, 269.077, 0, 0),
(21, 1236, 0, 1837.22, -1833.72, 13.5853, 178.378, 0, 0),
(22, 1300, 0, 1576.51, -1878.71, 13.5468, 92.6052, 0, 0),
(23, 1300, 0, 1468.58, -1738.63, 13.5466, 355.203, 0, 0),
(24, 1300, 0, 1254.53, -1534.78, 13.8196, 69.1896, 0, 0),
(25, 1300, 0, 1093.98, -1566.11, 13.5468, 88.0808, 0, 0),
(26, 1300, 0, 1189.49, -1344.44, 13.5652, 174.015, 0, 0),
(28, 1300, 0, 804.087, -1718.1, 13.5468, 328.387, 0, 0),
(30, 1300, 0, 1714.77, -1721.57, 13.5468, 16.9734, 0, 0),
(31, 1300, 0, 1068.67, -1353.43, 13.5468, 359.106, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `gates`
--
CREATE TABLE IF NOT EXISTS `gates` (
`gateID` int(12) NOT NULL AUTO_INCREMENT,
`gateModel` int(12) DEFAULT '0',
`gateSpeed` float DEFAULT '0',
`gateTime` int(12) DEFAULT '0',
`gateX` float DEFAULT '0',
`gateY` float DEFAULT '0',
`gateZ` float DEFAULT '0',
`gateRX` float DEFAULT '0',
`gateRY` float DEFAULT '0',
`gateRZ` float DEFAULT '0',
`gateInterior` int(12) DEFAULT '0',
`gateWorld` int(12) DEFAULT '0',
`gateMoveX` float DEFAULT '0',
`gateMoveY` float DEFAULT '0',
`gateMoveZ` float DEFAULT '0',
`gateMoveRX` float DEFAULT '0',
`gateMoveRY` float DEFAULT '0',
`gateMoveRZ` float DEFAULT '0',
`gateLinkID` int(12) DEFAULT '0',
`gateFaction` int(12) DEFAULT '0',
`gatePass` varchar(32) DEFAULT NULL,
`gateRadius` float DEFAULT '0',
PRIMARY KEY (`gateID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Contenu de la table `gates`
--
INSERT INTO `gates` (`gateID`, `gateModel`, `gateSpeed`, `gateTime`, `gateX`, `gateY`, `gateZ`, `gateRX`, `gateRY`, `gateRZ`, `gateInterior`, `gateWorld`, `gateMoveX`, `gateMoveY`, `gateMoveZ`, `gateMoveRX`, `gateMoveRY`, `gateMoveRZ`, `gateLinkID`, `gateFaction`, `gatePass`, `gateRadius`) VALUES
(1, 11416, 3, 0, 1975.73, -1764.38, 14.3127, 0, 0, -91.3395, 0, 0, 1975.68, -1766.52, 16.78, 0, 77.8, -91.3395, -1, 2, '', 20),
(2, 980, 3, 0, 1802.69, -1743.47, 15.3193, 0, 0, 179.875, 0, 0, 1791.11, -1743.45, 15.3193, 0, 0, 179.875, -1, -1, '', 10),
(8, 980, 3, 0, 1843.28, -1852.59, 12.7327, 0, 0, 89.6146, 0, 0, 1843.28, -1852.53, 14.7128, 0, 0, 89.6146, -1, -1, '', 0),
(9, 980, 3, 0, 1043.87, -1025.92, 33.1914, 0, 0, 179.08, 0, 0, 1041.72, -1026.77, 22.1014, -1000, -1000, -1000, -1, -1, '', 0),
(10, 980, 3, 0, 1579.18, -1613.14, 6.0744, 2.3, 0.7, 90.4639, 0, 7062, 1600.82, -1614.75, 13.0973, 0, 0, 117.464, -1, -1, '', 5),
(11, 980, 3, 17, 1587.7, -1638.59, 14.383, -1.9999, 0, -174.27, 0, 7062, 1587.56, -1638.42, 9.6471, 2.9, 0.7999, -174.67, -1, 8, 'N', 1),
(12, 968, 0.1, 0, 1544.69, -1630.67, 13.1627, -0.4999, -89.5999, -90.1151, 0, 0, 1544.69, -1630.67, 13.1627, -0.0999, -15.8999, -89.7151, -1, 1, '', 20),
(13, 971, 3, 0, 1588.96, -1637.9, 15.0427, 0, 0, -179.676, 0, 0, 1596.8, -1638, 15.0427, 0, 0, -179.676, -1, 1, '', 20),
(14, 1495, 3, 0, 1584.1, -1637.89, 12.4604, 0, 0, 182.35, 0, 0, 1584.1, -1637.89, 12.4604, 0, 0, -91.1495, -1, -1, '', 5),
(16, 980, 3, 0, 1024.75, -1029.28, 32.8389, 0, 0, 0.1225, 0, 0, 1024.82, -1029.61, 21.8989, -1000, -1000, -1000, -1, -1, '', 0),
(17, 980, 3, 0, 1621.96, -1861.93, 15.3087, -0.1999, -0.1999, -178.058, 0, 0, 1632.33, -1861.58, 15.2725, -0.1999, -0.1999, -178.058, -1, 1, '', 5),
(18, 1495, 3, 0, 1585.32, -1717.4, -37.854, 0, 0, 359.491, 1, 0, 1585.32, -1717.4, -37.854, 0, 0, -89.8094, -1, 1, '', 5),
(20, 980, 3, 0, 2071.51, -1831.66, 15.0193, -1.3999, 0.3, 90.3, 0, 0, 2073.64, -1832.36, 3.5545, -1000, -1000, -1000, -1, -1, '', 0),
(22, 980, 3, 0, 2571.22, -1301.85, 1045.79, 0, 0, 268.788, 2, 7013, 2572.11, -1301.87, 1034.12, -1000, -1000, -1000, -1, -1, '', 0),
(23, 980, 3, 0, 1141.08, -1207.23, 20.517, 0, 0, 267.752, 0, 0, 1140.66, -1217.8, 20.517, 0, 0, 267.752, -1, 10, '', 20),
(24, 18764, 3, 0, 1080.19, -1208.32, 17.9919, 0, 0, 89.392, 0, 0, 1075.09, -1206.71, 7.9919, -1000, -1000, -1000, -1, -1, '', 5),
(25, 18764, 3, 0, 1079.95, -1203.56, 17.9946, 0, 0, 93.6055, 0, 0, 1083.71, -1205.04, 7.8046, -1000, -1000, -1000, -1, -1, '', 0),
(26, 986, 3, 0, 1119.73, -1159.6, 24.1152, 0, 0, 178.411, 0, 0, 1126.82, -1159.79, 24.1152, 0, 0, 178.411, -1, -1, '', 5),
(29, 3037, 3, 0, 364.266, -1469.98, 32.5765, 0, 0, 125.941, 0, 0, 364.266, -1469.98, 27.9965, 0, 0, 125.941, -1, 9, '', 10),
(30, 3037, 3, 0, 310.264, -1554.46, 32.7229, 0, 0, -127.944, 0, 0, 310.264, -1554.46, 28.783, 0, 0, -127.944, -1, 9, '', 5);
-- --------------------------------------------------------
--
-- Structure de la table `gps`
--
CREATE TABLE IF NOT EXISTS `gps` (
`ID` int(12) DEFAULT '0',
`locationID` int(12) NOT NULL AUTO_INCREMENT,
`locationName` varchar(32) DEFAULT NULL,
`locationX` float DEFAULT '0',
`locationY` float DEFAULT '0',
`locationZ` float DEFAULT '0',
PRIMARY KEY (`locationID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `graffiti`
--
CREATE TABLE IF NOT EXISTS `graffiti` (
`graffitiID` int(12) NOT NULL AUTO_INCREMENT,
`graffitiX` float DEFAULT '0',
`graffitiY` float DEFAULT '0',
`graffitiZ` float DEFAULT '0',
`graffitiAngle` float DEFAULT '0',
`graffitiColor` int(12) DEFAULT '0',
`graffitiText` varchar(64) DEFAULT NULL,
PRIMARY KEY (`graffitiID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Structure de la table `gunracks`
--
CREATE TABLE IF NOT EXISTS `gunracks` (
`rackID` int(12) NOT NULL AUTO_INCREMENT,
`rackHouse` int(12) DEFAULT '0',
`rackX` float DEFAULT '0',
`rackY` float DEFAULT '0',
`rackZ` float DEFAULT '0',
`rackA` float DEFAULT '0',
`rackInterior` int(12) DEFAULT '0',
`rackWorld` int(12) DEFAULT '0',
`rackWeapon1` int(12) DEFAULT '0',
`rackAmmo1` int(12) DEFAULT '0',
`rackWeapon2` int(12) DEFAULT '0',
`rackAmmo2` int(12) DEFAULT '0',
`rackWeapon3` int(12) DEFAULT '0',
`rackAmmo3` int(12) DEFAULT '0',
`rackWeapon4` int(12) DEFAULT '0',
`rackAmmo4` int(12) DEFAULT '0',
PRIMARY KEY (`rackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `gunracks`
--
-- --------------------------------------------------------
--
-- Structure de la table `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`houseID` int(12) NOT NULL AUTO_INCREMENT,
`houseOwner` int(12) DEFAULT '0',
`housePrice` int(12) DEFAULT '0',
`houseAddress` varchar(32) DEFAULT NULL,
`housePosX` float DEFAULT '0',
`housePosY` float DEFAULT '0',
`housePosZ` float DEFAULT '0',
`housePosA` float DEFAULT '0',
`houseIntX` float DEFAULT '0',
`houseIntY` float DEFAULT '0',
`houseIntZ` float DEFAULT '0',
`houseIntA` float DEFAULT '0',
`houseInterior` int(12) DEFAULT '0',
`houseExterior` int(12) DEFAULT '0',
`houseExteriorVW` int(12) DEFAULT '0',
`houseLocked` int(4) DEFAULT '0',
`houseWeapon1` int(12) DEFAULT '0',
`houseAmmo1` int(12) DEFAULT '0',
`houseWeapon2` int(12) DEFAULT '0',
`houseAmmo2` int(12) DEFAULT '0',
`houseWeapon3` int(12) DEFAULT '0',
`houseAmmo3` int(12) DEFAULT '0',
`houseWeapon4` int(12) DEFAULT '0',
`houseAmmo4` int(12) DEFAULT '0',
`houseWeapon5` int(12) DEFAULT '0',
`houseAmmo5` int(12) DEFAULT '0',
`houseWeapon6` int(12) DEFAULT '0',
`houseAmmo6` int(12) DEFAULT '0',
`houseWeapon7` int(12) DEFAULT '0',
`houseAmmo7` int(12) DEFAULT '0',
`houseWeapon8` int(12) DEFAULT '0',
`houseAmmo8` int(12) DEFAULT '0',
`houseWeapon9` int(12) DEFAULT '0',
`houseAmmo9` int(12) DEFAULT '0',
`houseWeapon10` int(12) DEFAULT '0',
`houseAmmo10` int(12) DEFAULT '0',
`houseMoney` int(12) DEFAULT '0',
PRIMARY KEY (`houseID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
-- --------------------------------------------------------
--
-- Structure de la table `housestorage`
--
CREATE TABLE IF NOT EXISTS `housestorage` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Structure de la table `impoundlots`
--
CREATE TABLE IF NOT EXISTS `impoundlots` (
`impoundID` int(12) NOT NULL AUTO_INCREMENT,
`impoundLotX` float DEFAULT '0',
`impoundLotY` float DEFAULT '0',
`impoundLotZ` float DEFAULT '0',
`impoundReleaseX` float DEFAULT '0',
`impoundReleaseY` float DEFAULT '0',
`impoundReleaseZ` float DEFAULT '0',
`impoundReleaseInt` int(12) DEFAULT '0',
`impoundReleaseWorld` int(12) DEFAULT '0',
`impoundReleaseA` float DEFAULT '0',
PRIMARY KEY (`impoundID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Structure de la table `inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`ID` int(12) DEFAULT '0',
`invID` int(12) NOT NULL AUTO_INCREMENT,
`invItem` varchar(32) DEFAULT NULL,
`invModel` int(12) DEFAULT '0',
`invQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`invID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=415 ;
-- --------------------------------------------------------
--
-- Structure de la table `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`jobID` int(12) NOT NULL AUTO_INCREMENT,
`jobPosX` float DEFAULT '0',
`jobPosY` float DEFAULT '0',
`jobPosZ` float DEFAULT '0',
`jobPointX` float DEFAULT '0',
`jobPointY` float DEFAULT '0',
`jobPointZ` float DEFAULT '0',
`jobDeliverX` float DEFAULT '0',
`jobDeliverY` float DEFAULT '0',
`jobDeliverZ` float DEFAULT '0',
`jobInterior` int(12) DEFAULT '0',
`jobWorld` int(12) DEFAULT '0',
`jobType` int(12) DEFAULT '0',
`jobPointInt` int(12) DEFAULT '0',
`jobPointWorld` int(12) DEFAULT '0',
PRIMARY KEY (`jobID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
--
-- Contenu de la table `jobs`
--
INSERT INTO `jobs` (`jobID`, `jobPosX`, `jobPosY`, `jobPosZ`, `jobPointX`, `jobPointY`, `jobPointZ`, `jobDeliverX`, `jobDeliverY`, `jobDeliverZ`, `jobInterior`, `jobWorld`, `jobType`, `jobPointInt`, `jobPointWorld`) VALUES
(13, 2446.43, -2118.8, 13.5468, 2452.66, -2116.49, 13.5529, 0, 0, 0, 0, 0, 1, 0, 0),
(17, 1297.69, -63.7755, 1002.5, 0, 0, 0, 0, 0, 0, 18, 7067, 4, 0, 0),
(18, 790.254, -1620.72, 13.3905, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0),
(19, 2194.4, -1974.56, 13.5592, 2184.69, -1988.42, 13.5499, 0, 0, 0, 0, 0, 7, 0, 0),
(20, 2561.64, -1293.43, 1044.12, 2558.7, -1295.85, 1044.12, 0, 0, 0, 2, 7013, 9, 2, 7013),
(38, 1752.58, -1864.68, 13.5735, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0),
(39, 2038.98, -1949.62, 13.5468, 2017.13, -1977.75, 13.5468, 2050.95, -1966.17, 16.694, 0, 0, 8, 0, 0),
(40, 1331.08, -882.761, 39.5781, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `namechanges`
--
CREATE TABLE IF NOT EXISTS `namechanges` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`OldName` varchar(24) DEFAULT NULL,
`NewName` varchar(24) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Structure de la table `plants`
--
CREATE TABLE IF NOT EXISTS `plants` (
`plantID` int(12) NOT NULL AUTO_INCREMENT,
`plantType` int(12) DEFAULT '0',
`plantDrugs` int(12) DEFAULT '0',
`plantX` float DEFAULT '0',
`plantY` float DEFAULT '0',
`plantZ` float DEFAULT '0',
`plantA` float DEFAULT '0',
`plantInterior` int(12) DEFAULT '0',
`plantWorld` int(12) DEFAULT '0',
PRIMARY KEY (`plantID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
-- --------------------------------------------------------
--
-- Structure de la table `pumps`
--
CREATE TABLE IF NOT EXISTS `pumps` (
`ID` int(12) DEFAULT '0',
`pumpID` int(12) NOT NULL AUTO_INCREMENT,
`pumpPosX` float DEFAULT '0',
`pumpPosY` float DEFAULT '0',
`pumpPosZ` float DEFAULT '0',
`pumpPosA` float DEFAULT '0',
`pumpFuel` int(12) DEFAULT '0',
PRIMARY KEY (`pumpID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
--
-- Contenu de la table `pumps`
--
INSERT INTO `pumps` (`ID`, `pumpID`, `pumpPosX`, `pumpPosY`, `pumpPosZ`, `pumpPosA`, `pumpFuel`) VALUES
(12, 21, 1942.46, -1776.76, 14.0804, 273.092, 6558),
(12, 22, 1942.43, -1774.74, 14.0906, 275.912, 6769),
(12, 25, 1936.73, -1774.85, 14.1702, 91.0382, 6712),
(12, 26, 1936.79, -1776.81, 14.1105, 89.7851, 6800);
-- --------------------------------------------------------
--
-- Structure de la table `speedcameras`
--
CREATE TABLE IF NOT EXISTS `speedcameras` (
`speedID` int(12) NOT NULL AUTO_INCREMENT,
`speedRange` float DEFAULT '0',
`speedLimit` float DEFAULT '0',
`speedX` float DEFAULT '0',
`speedY` float DEFAULT '0',
`speedZ` float DEFAULT '0',
`speedAngle` float DEFAULT '0',
PRIMARY KEY (`speedID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`ID` int(12) DEFAULT '0',
`ticketID` int(12) NOT NULL AUTO_INCREMENT,
`ticketFee` int(12) DEFAULT '0',
`ticketBy` varchar(24) DEFAULT NULL,
`ticketDate` varchar(36) DEFAULT NULL,
`ticketReason` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ticketID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
-- --------------------------------------------------------
--
-- Structure de la table `vendors`
--
CREATE TABLE IF NOT EXISTS `vendors` (
`vendorID` int(12) NOT NULL AUTO_INCREMENT,
`vendorType` int(12) DEFAULT '0',
`vendorX` float DEFAULT '0',
`vendorY` float DEFAULT '0',
`vendorZ` float DEFAULT '0',
`vendorA` float DEFAULT '0',
`vendorInterior` int(12) DEFAULT '0',
`vendorWorld` int(12) DEFAULT '0',
PRIMARY KEY (`vendorID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
-- --------------------------------------------------------
--
-- Structure de la table `warrants`
--
CREATE TABLE IF NOT EXISTS `warrants` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Suspect` varchar(24) DEFAULT NULL,
`Username` varchar(24) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL,
`Description` varchar(128) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `warrants`
--