ecrp-samp/ecrp-bc_init.sql

-- MySQL dump 10.16  Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ecrp
-- ------------------------------------------------------
-- Server version	10.1.41-MariaDB-0+deb9u1

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `achievements`
--

DROP TABLE IF EXISTS `achievements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `achievements` (
  `uid` int(10) DEFAULT NULL,
  `achievement` varchar(32) DEFAULT NULL,
  UNIQUE KEY `uid` (`uid`,`achievement`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `achievements`
--

LOCK TABLES `achievements` WRITE;
/*!40000 ALTER TABLE `achievements` DISABLE KEYS */;
INSERT INTO `achievements` VALUES (73,'First wheels'),(73,'High roller'),(73,'I\'m rich!');
/*!40000 ALTER TABLE `achievements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `actordb`
--

DROP TABLE IF EXISTS `actordb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `actordb` (
  `ID` int(11) NOT NULL,
  `ActorName` text NOT NULL,
  `ActorVirtual` int(11) NOT NULL,
  `ActorX` float NOT NULL,
  `ActorA` float NOT NULL,
  `ActorY` float NOT NULL,
  `ActorZ` float NOT NULL,
  `Skin` int(11) NOT NULL,
  `AActive` int(11) NOT NULL,
  `Text` text NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `actordb`
--

LOCK TABLES `actordb` WRITE;
/*!40000 ALTER TABLE `actordb` DISABLE KEYS */;
/*!40000 ALTER TABLE `actordb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
  `uid` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `aName` varchar(255) NOT NULL,
  `aLevel` int(11) NOT NULL,
  `totalReports` int(11) NOT NULL,
  `monthlyReports` int(11) NOT NULL,
  `weeklyReports` int(11) NOT NULL,
  `monthlyReset` int(11) NOT NULL,
  `weeklyReset` int(11) NOT NULL,
  UNIQUE KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admins`
--

LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `arrestpoints`
--

DROP TABLE IF EXISTS `arrestpoints`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arrestpoints` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
  `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
  `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
  `VW` int(5) NOT NULL DEFAULT '0',
  `Int` int(5) NOT NULL DEFAULT '0',
  `Type` int(1) NOT NULL DEFAULT '0',
  `jailVW` int(5) NOT NULL DEFAULT '0',
  `jailInt` int(5) NOT NULL DEFAULT '0',
  `jailpos1x` float(10,5) NOT NULL DEFAULT '0.00000',
  `jailpos1y` float(10,5) NOT NULL DEFAULT '0.00000',
  `jailpos1z` float(10,5) NOT NULL DEFAULT '0.00000',
  `jailpos2x` float(10,5) NOT NULL DEFAULT '0.00000',
  `jailpos2y` float(10,5) NOT NULL DEFAULT '0.00000',
  `jailpos2z` float(10,5) NOT NULL DEFAULT '0.00000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `arrestpoints`
--

LOCK TABLES `arrestpoints` WRITE;
/*!40000 ALTER TABLE `arrestpoints` DISABLE KEYS */;
/*!40000 ALTER TABLE `arrestpoints` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `atms`
--

DROP TABLE IF EXISTS `atms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `atms` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `pos_x` float DEFAULT NULL,
  `pos_y` float DEFAULT NULL,
  `pos_z` float DEFAULT NULL,
  `pos_r` float DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `atms`
--

LOCK TABLES `atms` WRITE;
/*!40000 ALTER TABLE `atms` DISABLE KEYS */;
/*!40000 ALTER TABLE `atms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auctions`
--

DROP TABLE IF EXISTS `auctions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auctions` (
  `id` int(11) NOT NULL,
  `BiddingFor` varchar(64) NOT NULL DEFAULT '(none)',
  `InProgress` int(11) NOT NULL DEFAULT '0',
  `Bid` int(11) NOT NULL DEFAULT '0',
  `Bidder` int(11) NOT NULL DEFAULT '0',
  `Expires` int(11) NOT NULL DEFAULT '0',
  `Wining` varchar(24) NOT NULL DEFAULT '(none)',
  `Increment` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auctions`
--

LOCK TABLES `auctions` WRITE;
/*!40000 ALTER TABLE `auctions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auctions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backpack`
--

DROP TABLE IF EXISTS `backpack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `backpack` (
  `pid` int(11) NOT NULL,
  `type` int(2) NOT NULL,
  `store1` int(2) DEFAULT NULL,
  `store2` int(2) DEFAULT NULL,
  `food` int(11) NOT NULL DEFAULT '0',
  `food2` int(11) NOT NULL DEFAULT '0',
  `mats` int(11) NOT NULL DEFAULT '0',
  `pot` int(5) DEFAULT '0',
  `crack` int(5) DEFAULT '0',
  `heroine` int(5) DEFAULT '0',
  `weap1` varchar(50) DEFAULT NULL,
  `weap2` varchar(50) DEFAULT NULL,
  `weap3` varchar(50) DEFAULT NULL,
  `weap4` varchar(50) DEFAULT NULL,
  `weap5` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backpack`
--

LOCK TABLES `backpack` WRITE;
/*!40000 ALTER TABLE `backpack` DISABLE KEYS */;
/*!40000 ALTER TABLE `backpack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bans`
--

DROP TABLE IF EXISTS `bans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bans` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(24) DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `bannedby` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `reason` varchar(128) DEFAULT NULL,
  `permanent` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bans`
--

LOCK TABLES `bans` WRITE;
/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `businesses`
--

DROP TABLE IF EXISTS `businesses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `businesses` (
  `id` int(10) NOT NULL,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `type` tinyint(2) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `entryfee` int(10) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `timestamp` int(10) DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `int_x` float DEFAULT '0',
  `int_y` float DEFAULT '0',
  `int_z` float DEFAULT '0',
  `int_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `outsideint` tinyint(2) DEFAULT '0',
  `outsidevw` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `products` int(10) DEFAULT '500',
  `materials` int(10) DEFAULT '0',
  `color` int(10) DEFAULT '-256',
  `description` varchar(128) DEFAULT 'None'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `businesses`
--

LOCK TABLES `businesses` WRITE;
/*!40000 ALTER TABLE `businesses` DISABLE KEYS */;
INSERT INTO `businesses` VALUES (1,0,'Nobody',0,600000,0,0,0,59.385,1221.7,18.865,-88.001,-27.438,-57.611,1003.55,0,6,3000001,0,0,1325,497,0,-256,'None'),(2,0,'Nobody',2,750000,0,0,0,-180.991,1063.52,19.742,89.85,161.367,-96.495,1001.8,0,18,3000002,0,0,3000,497,0,-256,'None'),(3,0,'Nobody',0,600000,0,0,0,-181.282,1034.78,19.742,91.754,-27.438,-57.611,1003.55,0,6,3000003,0,0,8500,493,0,-256,'None'),(4,0,'Nobody',6,475000,0,0,0,-180.15,1087.82,19.742,46.465,501.869,-68.005,998.758,179.612,11,3000004,0,0,0,500,0,-256,'None'),(9,0,'Nobody',4,500000,0,0,0,212.522,-202.383,1.578,179.413,372.179,-133.198,1001.49,182.065,5,3000009,0,0,300,499,0,-256,'None'),(11,0,'Nobody',0,600000,0,0,0,203.471,-202.059,1.578,-176.827,-27.438,-57.611,1003.55,0,6,3000011,0,0,0,500,0,-256,'None'),(12,0,'Nobody',4,500000,0,0,0,171.872,-200.838,1.57,-125.126,363.328,-74.65,1001.51,315,10,3000012,0,0,0,500,0,-256,'None'),(15,0,'Nobody',4,500000,0,0,0,1367.52,248.369,19.567,66.382,363.328,-74.65,1001.51,315,10,3000015,0,0,0,500,0,-256,'None'),(17,0,'Nobody',4,500000,0,0,0,-53.8,1189.09,19.359,4.025,363.328,-74.65,1001.51,315,10,3000017,0,0,3657,486,0,-256,'None'),(20,0,'Nobody',4,500000,5000,0,1570081168,-144.09,1224.31,19.899,179.596,363.328,-74.65,1001.51,315,10,3000020,0,0,5000,500,0,-256,'None'),(21,0,'Nobody',1,800000,0,0,0,-316.067,829.813,14.242,-90.78,316.287,-169.647,999.601,0,6,3000021,0,0,0,500,0,-256,'None'),(25,0,'Nobody',3,600000,0,0,0,-206.017,1152.91,19.89,-87.019,773.78,-78.258,1000.66,0,7,3000025,0,0,0,500,0,-256,'None');
/*!40000 ALTER TABLE `businesses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `businesses.new`
--

DROP TABLE IF EXISTS `businesses.new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `businesses.new` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `type` tinyint(2) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `entryfee` int(10) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `timestamp` int(10) DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `int_x` float DEFAULT '0',
  `int_y` float DEFAULT '0',
  `int_z` float DEFAULT '0',
  `int_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `outsideint` tinyint(2) DEFAULT '0',
  `outsidevw` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `products` int(10) DEFAULT '500',
  `materials` int(10) DEFAULT '0',
  `color` int(10) DEFAULT '-256',
  `description` varchar(128) DEFAULT 'None',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `businesses.new`
--

LOCK TABLES `businesses.new` WRITE;
/*!40000 ALTER TABLE `businesses.new` DISABLE KEYS */;
INSERT INTO `businesses.new` VALUES (30,0,'Nobody',0,135500,0,0,0,59.195,1221.63,18.866,-103.002,-27.438,-57.611,1003.55,0,6,3000030,0,0,400,499,0,-256,'None'),(32,0,'Nobody',0,300000,0,0,0,-19.153,1175.58,19.563,0,316.287,-169.647,999.601,0,6,3000032,0,0,1475,497,0,-256,'None'),(33,0,'Nobody',6,385000,0,0,0,-314.369,1774.78,43.641,130.306,1133.11,-15.311,1000.68,0,12,3000033,0,0,0,500,0,-256,'None'),(34,0,'Nobody',0,190000,0,0,0,-746.182,1590.12,26.975,133.966,-27.438,-57.611,1003.55,0,6,3000034,0,0,0,500,0,-256,'None'),(35,0,'Nobody',0,350000,0,0,0,-799.557,1501.34,21.667,185.099,316.287,-169.647,999.601,0,6,3000035,0,0,750,499,0,-256,'None'),(36,0,'Nobody',4,250000,0,0,0,-857.929,1535.66,22.587,323.565,-228.757,1401.24,27.766,270,18,3000036,0,0,0,500,0,-256,'None'),(37,0,'Nobody',1,325000,0,0,0,-1508.93,2610.36,55.836,180.678,316.287,-169.647,999.601,0,6,3000037,0,0,0,500,0,-256,'None'),(38,0,'Nobody',7,150000,0,0,0,-1457.98,2590.56,55.984,358.252,-2240.7,128.301,1035.41,270,6,3000038,0,0,0,500,0,-256,'None'),(40,0,'Nobody',3,250000,0,0,0,-179.99,1087.9,19.742,41.916,363.328,-74.65,1001.51,315,10,3000040,0,0,0,500,0,-256,'None'),(41,0,'Nobody',2,300000,0,0,0,-1449.76,2592.46,55.836,0.254,204.386,-168.459,1000.52,0,14,3000041,0,0,0,500,0,-256,'None'),(42,0,'Nobody',0,225000,0,0,0,-1271.69,2713.19,50.266,118.807,-27.438,-57.611,1003.55,0,6,3000042,0,0,0,500,0,-256,'None'),(43,0,'Nobody',6,300000,0,0,0,-323.444,2675.67,63.68,90.575,501.869,-68.005,998.758,179.612,11,3000043,0,0,0,500,0,-256,'None'),(44,0,'Nobody',4,300000,0,0,0,-144.004,1225.02,19.899,-2.74,377.073,-193.057,1000.64,0,17,3000044,0,0,0,500,0,-256,'None'),(45,0,'Nobody',4,300000,0,0,0,-53.771,1189.01,19.359,-179.094,459.768,-88.664,999.555,90,4,3000045,0,0,1032,492,0,-256,'None'),(46,0,'Nobody',1,400000,0,0,0,-316.16,830.056,14.242,92.466,316.287,-169.647,999.601,0,6,3000046,0,0,0,500,0,-256,'None'),(47,0,'Nobody',7,525000,0,0,0,-144.657,1078.7,20.492,170.549,-2240.7,128.301,1035.41,270,6,3000047,0,0,0,500,0,-256,'None'),(48,0,'Nobody',1,250000,0,0,0,776.725,1871.41,4.907,88.518,316.287,-169.647,999.601,0,6,3000048,0,0,0,500,0,-256,'None'),(49,0,'Nobody',2,350000,0,0,0,-180.562,1063.56,19.742,82.463,161.367,-96.495,1001.8,0,18,3000049,0,0,0,500,0,-256,'None'),(50,0,'Nobody',7,550000,0,0,0,-180.356,1163.35,19.742,-90.509,-2240.7,128.301,1035.41,270,6,3000050,0,0,0,500,0,-256,'None'),(51,0,'Nobody',5,350000,0,0,0,-205.959,1053.51,19.734,259.755,834.152,7.41,1004.19,90,3,3000051,0,0,0,500,0,-256,'None'),(52,0,'Nobody',7,250000,0,0,0,-89.177,1378.33,10.47,103.178,-228.757,1401.24,27.766,270,18,3000052,0,0,0,500,0,-256,'None'),(53,0,'Nobody',4,500000,0,0,0,-1213.97,1830.51,41.93,130.622,363.328,-74.65,1001.51,315,10,3000053,0,0,0,500,0,-256,'None'),(54,0,'Nobody',0,600000,0,0,0,-1465.55,1873.44,32.633,5.378,-27.438,-57.611,1003.55,0,6,3000054,0,0,0,500,0,-256,'None'),(55,0,'Nobody',4,190000,0,0,0,-1941.82,2379.69,49.695,110.428,459.768,-88.664,999.555,90,4,3000055,0,0,0,500,0,-256,'None'),(56,0,'Nobody',2,220000,0,0,0,-2492.46,2363.27,10.277,87.235,204.386,-168.459,1000.52,0,14,3000056,0,0,0,500,0,-256,'None'),(57,0,'Nobody',0,200000,0,0,0,-2518.68,2318.69,4.984,178.095,-25.973,-187.895,1003.55,0,17,3000057,0,0,0,500,0,-256,'None'),(58,0,'Nobody',-1,600000,0,0,0,-180.976,1034.94,19.742,-93.302,2841.51,2444.66,1786.48,90.338,0,3000058,0,0,0,500,0,-256,'None');
/*!40000 ALTER TABLE `businesses.new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `changes`
--

DROP TABLE IF EXISTS `changes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changes` (
  `slot` tinyint(2) DEFAULT NULL,
  `text` varchar(64) DEFAULT NULL,
  UNIQUE KEY `slot` (`slot`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `changes`
--

LOCK TABLES `changes` WRITE;
/*!40000 ALTER TABLE `changes` DISABLE KEYS */;
/*!40000 ALTER TABLE `changes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `charges`
--

DROP TABLE IF EXISTS `charges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `charges` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `chargedby` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `reason` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `charges`
--

LOCK TABLES `charges` WRITE;
/*!40000 ALTER TABLE `charges` DISABLE KEYS */;
/*!40000 ALTER TABLE `charges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clothing`
--

DROP TABLE IF EXISTS `clothing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clothing` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `modelid` smallint(5) DEFAULT NULL,
  `boneid` tinyint(2) DEFAULT NULL,
  `attached` tinyint(1) DEFAULT NULL,
  `pos_x` float DEFAULT NULL,
  `pos_y` float DEFAULT NULL,
  `pos_z` float DEFAULT NULL,
  `rot_x` float DEFAULT NULL,
  `rot_y` float DEFAULT NULL,
  `rot_z` float DEFAULT NULL,
  `scale_x` float DEFAULT NULL,
  `scale_y` float DEFAULT NULL,
  `scale_z` float DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clothing`
--

LOCK TABLES `clothing` WRITE;
/*!40000 ALTER TABLE `clothing` DISABLE KEYS */;
INSERT INTO `clothing` VALUES (1,69,'Striped boater hat',18946,2,1,0.142,-0.009,0.001,3.9,0,0,1,1.015,1.02),(2,69,'White bowler hat',19488,2,0,0.139,-0.009,0.003,0,91,90.2,1,1,1),(3,69,'Brown beret',18922,2,0,0.162,-0.009,-0.003,0,0,0,1.006,1.049,1.068),(4,69,'Shop basket',19592,5,0,0.062,0.014,0.04,0,-107.1,-9.1,0.542,0.634,0.86),(5,69,'Cigarette',19625,5,0,0.112,0.03,-0.017,0,0,54.9,1,1,1),(6,69,'Scarf',19469,17,1,0.037,0.033,-0.024,0,0,-17,1,1.069,1.107),(7,69,'Flashlight',18641,5,0,0.09,0.021,-0.079,-6,0,0,1,1,1),(8,69,'Brown tinted shades',19557,2,0,0.101,0.027,0.004,0,0,-7.9,1,1,1),(9,69,'Clear sunglasses',19022,2,1,0.072,0.03,0.001,88.7,84.2,1.5,0.963,1,1),(10,68,'Flashlight',18641,2,1,0.07,0.059,-0.038,89.3,0,0,1,1,0.815),(11,68,'Gas mask',19472,2,1,-0.014,0.14,0.001,88.3,90.9,2.1,1,1.12,1.419),(12,68,'Camera',19623,1,0,0.225,0.038,-0.094,-9.6,-179.9,-154.1,1.079,0.992,1),(13,68,'Police radio',19942,2,1,0.082,0.008,-0.078,96,111.2,-11.2,1,1,0.699),(14,68,'Wrench',18633,5,1,0.109,0.005,-0.168,-98.1,-130.5,2.1,2.19,3,1.401),(15,68,'Hammer',18635,5,0,-0.147,-0.002,0,-177.1,-3.1,-24,3,1.874,3),(16,68,'Black helmet',19116,2,0,0.179,0.011,0.001,-1.7,0,0,1,1.133,1.109),(17,68,'Shop basket',19592,1,0,0.081,0.092,0.099,-86.8,0,-93.3,0.264,0.655,0.728),(18,68,'Police radio',19942,1,1,0.007,-0.093,0.065,0,86.6,-177.9,3,2.089,3),(19,69,'Camera',19623,6,1,0.153,0.017,0.004,0,0,0,1,1,1);
/*!40000 ALTER TABLE `clothing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crates`
--

DROP TABLE IF EXISTS `crates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crates` (
  `id` int(11) NOT NULL,
  `Active` int(11) NOT NULL DEFAULT '0',
  `CrateX` float NOT NULL DEFAULT '0',
  `CrateY` float NOT NULL DEFAULT '0',
  `CrateZ` float NOT NULL DEFAULT '0',
  `GunQuantity` int(11) NOT NULL DEFAULT '50',
  `InVehicle` int(11) NOT NULL DEFAULT '0',
  `Int` int(11) NOT NULL DEFAULT '0',
  `VW` int(11) NOT NULL DEFAULT '0',
  `PlacedBy` varchar(24) NOT NULL DEFAULT 'Unknown'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crates`
--

LOCK TABLES `crates` WRITE;
/*!40000 ALTER TABLE `crates` DISABLE KEYS */;
/*!40000 ALTER TABLE `crates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crews`
--

DROP TABLE IF EXISTS `crews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crews` (
  `id` tinyint(2) DEFAULT NULL,
  `crewid` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`crewid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crews`
--

LOCK TABLES `crews` WRITE;
/*!40000 ALTER TABLE `crews` DISABLE KEYS */;
/*!40000 ALTER TABLE `crews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dealerships`
--

DROP TABLE IF EXISTS `dealerships`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dealerships` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `type` int(10) NOT NULL,
  `range` varchar(10) NOT NULL,
  `posx` varchar(10) NOT NULL,
  `posy` varchar(10) NOT NULL,
  `posz` varchar(10) NOT NULL,
  `spawnposx` varchar(10) NOT NULL,
  `spawnposy` varchar(10) NOT NULL,
  `spawnposz` varchar(10) NOT NULL,
  `spawnposfa` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dealerships`
--

LOCK TABLES `dealerships` WRITE;
/*!40000 ALTER TABLE `dealerships` DISABLE KEYS */;
INSERT INTO `dealerships` VALUES (7,'Cheap',0,'50.0','166.961','1171.642','14.758','163.142','1165.524','14.77','147.531'),(8,'Flat',0,'30.0','515.724','2361.447','30.385','524.186','2356.019','30.565','155.401'),(9,'Used',0,'50.0','206.255','-258.511','1.578','214.745','-228.999','1.779','356.67'),(10,'Bikers',1,'30.0','1339.003','287.312','19.561','1344.312','281.693','19.561','249.21'),(11,'Airfield',2,'50.0','381.925','2528.877','16.584','349.708','2542.381','16.741','175.248'),(13,'Seaways',3,'50.0','-642.501','1288.62','2.143','-642.501','1288.62','2.143','292.016');
/*!40000 ALTER TABLE `dealerships` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dealervehs`
--

DROP TABLE IF EXISTS `dealervehs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dealervehs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `model` int(5) NOT NULL,
  `price` int(10) NOT NULL,
  `posx` varchar(10) NOT NULL,
  `posy` varchar(10) NOT NULL,
  `posz` varchar(10) NOT NULL,
  `facingangle` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dealervehs`
--

LOCK TABLES `dealervehs` WRITE;
/*!40000 ALTER TABLE `dealervehs` DISABLE KEYS */;
INSERT INTO `dealervehs` VALUES (1,401,10000,'167.524','1178.198','14.758','164.621'),(3,496,17500,'171.98','1175.93','14.765','166.119'),(5,500,27500,'180.098','1162.777','14.758','93.062'),(8,421,15000,'181.652','1166.276','14.758','83.021'),(9,580,32500,'182.889','1169.658','14.758','89.363'),(10,549,12500,'181.639','1173.851','14.758','121.579'),(11,405,27500,'157.462','1174.778','15.289','270.481'),(12,445,30000,'157.313','1178.914','15.272','268.644'),(13,475,32500,'157.134','1182.759','15.26','279.984'),(14,542,35000,'156.519','1187.39','15.291','281.147'),(15,404,37500,'157.373','1190.914','15.226','274.153'),(16,483,50000,'535.863','2364.182','30.574','124.077'),(17,482,55000,'527.289','2373.516','30.241','133.215'),(18,489,70000,'532.946','2370.715','30.403','130.758'),(19,554,37500,'522.466','2377.763','30.189','149.038'),(22,508,57500,'513.206','2381.112','30.195','158.985'),(23,440,55000,'518.177','2378.393','30.211','163.441'),(24,507,225000,'198.956','-268.615','1.584','0.893'),(26,579,245000,'202.397','-268.649','1.584','356.886'),(27,562,265000,'217.173','-267.308','1.578','0.264'),(28,560,260000,'213.231','-267.715','1.578','3.662'),(29,565,260000,'208.814','-268.424','1.578','3.154'),(31,426,90000,'219.676','-252.36','1.578','179.929'),(32,419,100000,'215.987','-251.896','1.578','184.14'),(34,412,120000,'210.597','-252.058','1.578','180.967'),(35,458,190000,'206.598','-251.795','1.578','181.945'),(36,466,95000,'202.994','-251.321','1.578','180.828'),(38,477,200000,'198.795','-251.555','1.578','179.599'),(39,546,75000,'219.79','-242.108','1.578','0.564'),(40,555,150000,'216.049','-242.289','1.578','0.908'),(42,559,150000,'212.482','-242.708','1.578','1.875'),(43,566,85000,'208.472','-242.607','1.578','356.899'),(46,567,125000,'202.476','-242.461','1.578','0.179'),(47,587,130000,'196.811','-242.935','1.578','1.821'),(51,461,75000,'1338.733','280.927','19.561','331.993'),(52,462,20000,'1337.232','281.446','19.561','330.469'),(53,463,40000,'1335.531','282.562','19.561','332.485'),(54,468,55000,'1333.29','283.464','19.561','330.051'),(55,471,65200,'1331.058','284.506','19.555','333.006'),(57,521,0,'1329.527','285.49','19.555','327.512'),(59,586,30000,'1331.893','291.857','19.555','250.258'),(61,581,65000,'1331.02','289.772','19.555','249.777'),(63,469,750000,'365.427','2537.032','16.664','179.263'),(64,487,1250000,'377.132','2536.658','16.548','179.263'),(85,452,750000,'-619.122','1291.019','-0.351','291.993'),(86,454,1250000,'-621.678','1301.116','-0.488','287.988'),(87,473,580000,'-624.979','1309.169','-0.553','275.174');
/*!40000 ALTER TABLE `dealervehs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `divisions`
--

DROP TABLE IF EXISTS `divisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `divisions` (
  `id` tinyint(2) DEFAULT NULL,
  `divisionid` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`divisionid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `divisions`
--

LOCK TABLES `divisions` WRITE;
/*!40000 ALTER TABLE `divisions` DISABLE KEYS */;
INSERT INTO `divisions` VALUES (0,0,'Special Enforcement Bureau'),(0,1,'Detective Bureau'),(0,2,'Traffic Enforcement'),(0,3,'Drug/Gang Enforcement'),(0,4,'Training & Recruitment');
/*!40000 ALTER TABLE `divisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `entrances`
--

DROP TABLE IF EXISTS `entrances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entrances` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `iconid` smallint(5) DEFAULT '1239',
  `locked` tinyint(1) DEFAULT '0',
  `radius` float DEFAULT '3',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `int_x` float DEFAULT '0',
  `int_y` float DEFAULT '0',
  `int_z` float DEFAULT '0',
  `int_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `outsideint` tinyint(2) DEFAULT '0',
  `outsidevw` int(10) DEFAULT '0',
  `adminlevel` tinyint(2) DEFAULT '0',
  `factiontype` tinyint(2) DEFAULT '0',
  `vip` tinyint(2) DEFAULT '0',
  `vehicles` tinyint(1) DEFAULT '0',
  `freeze` tinyint(1) DEFAULT '0',
  `password` varchar(64) DEFAULT 'None',
  `label` tinyint(1) DEFAULT '1',
  `mapicon` tinyint(3) NOT NULL DEFAULT '0',
  `gang` tinyint(2) DEFAULT '-1',
  `type` tinyint(2) DEFAULT '0',
  `color` int(10) DEFAULT '-256',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `entrances`
--

LOCK TABLES `entrances` WRITE;
/*!40000 ALTER TABLE `entrances` DISABLE KEYS */;
INSERT INTO `entrances` VALUES (8,0,NULL,'Fort Carson Motel',19523,1,3,-176.597,1112.08,19.742,-50.98,2214.88,-1150.4,1025.8,268.237,15,4000008,0,0,0,0,0,0,0,'None',1,0,-1,0,1711276287),(9,0,NULL,'R.V. Park',1239,0,3,-792.387,1627.78,27.156,-90.955,422.44,2536.37,10,87.656,10,4000009,0,0,0,0,0,0,0,'None',1,0,-1,0,-256),(10,0,NULL,'BCSD Sub-Station',1239,0,3,-1390.05,2638.66,55.984,1.43,1494.45,1303.88,1093.29,353.019,3,4000010,0,0,0,1,0,0,0,'None',1,0,-1,0,-256),(13,0,NULL,'Special Enforcement Bureau',1247,0,3,938.297,1733.09,8.852,92.164,238.552,138.772,1003.02,356.158,3,4000013,0,0,0,0,0,0,0,'None',1,0,-1,0,-256),(14,0,NULL,'Second Floor',1239,0,3,1453.27,-1802.69,2349.7,-177.129,1453.39,-1802.68,2643.3,350.314,0,0,0,0,0,0,0,0,0,'None',1,0,-1,0,-256);
/*!40000 ALTER TABLE `entrances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factionlockers`
--

DROP TABLE IF EXISTS `factionlockers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factionlockers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `factionid` tinyint(2) DEFAULT NULL,
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `iconid` smallint(5) DEFAULT '1239',
  `label` tinyint(1) DEFAULT '1',
  `weapon_kevlar` tinyint(1) DEFAULT '1',
  `weapon_medkit` tinyint(1) DEFAULT '1',
  `weapon_nitestick` varchar(1) DEFAULT '0',
  `weapon_mace` tinyint(1) DEFAULT '0',
  `weapon_deagle` tinyint(1) DEFAULT '1',
  `weapon_shotgun` tinyint(1) DEFAULT '1',
  `weapon_mp5` tinyint(1) DEFAULT '1',
  `weapon_m4` tinyint(1) DEFAULT '1',
  `weapon_spas12` tinyint(1) DEFAULT '1',
  `weapon_sniper` tinyint(1) DEFAULT '1',
  `weapon_camera` tinyint(1) DEFAULT '0',
  `weapon_fire_extinguisher` tinyint(1) DEFAULT '0',
  `weapon_painkillers` tinyint(1) DEFAULT '0',
  `price_kevlar` smallint(5) DEFAULT '100',
  `price_medkit` smallint(5) DEFAULT '50',
  `price_nitestick` smallint(5) DEFAULT '0',
  `price_mace` smallint(5) DEFAULT '0',
  `price_deagle` smallint(5) DEFAULT '850',
  `price_shotgun` smallint(5) DEFAULT '1000',
  `price_mp5` smallint(5) DEFAULT '1500',
  `price_m4` smallint(5) DEFAULT '2500',
  `price_spas12` smallint(5) DEFAULT '3500',
  `price_sniper` smallint(5) DEFAULT '5000',
  `price_camera` smallint(5) DEFAULT '0',
  `price_fire_extinguisher` smallint(5) DEFAULT '0',
  `price_painkillers` smallint(5) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factionlockers`
--

LOCK TABLES `factionlockers` WRITE;
/*!40000 ALTER TABLE `factionlockers` DISABLE KEYS */;
INSERT INTO `factionlockers` VALUES (1,0,1432.12,1484.49,-29.654,2,5,1239,1,1,1,'1',0,1,0,1,1,1,1,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0),(6,1,-25.281,157.691,999.057,1,1,1239,1,1,1,'0',0,0,1,0,0,0,0,0,1,1,1,1,0,0,850,0,1500,2500,3500,5000,0,0,0),(7,2,-102.575,1077.99,-34.639,0,0,1239,1,1,1,'0',0,1,1,0,0,0,0,1,0,0,100,50,0,0,850,1000,1500,2500,3500,5000,0,0,0),(8,0,1492.71,1308.09,1093.29,3,4000010,1239,1,1,1,'0',0,1,1,1,1,1,1,0,0,0,100,50,0,0,850,1000,1500,2500,3500,5000,0,0,0),(9,0,221.645,183.545,1003.03,3,4000013,1239,1,1,1,'0',0,1,1,1,1,0,1,0,0,0,100,50,0,0,850,1000,1500,2500,3500,5000,0,0,0);
/*!40000 ALTER TABLE `factionlockers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factionpay`
--

DROP TABLE IF EXISTS `factionpay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factionpay` (
  `id` tinyint(2) DEFAULT NULL,
  `rank` tinyint(2) DEFAULT NULL,
  `amount` int(10) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`rank`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factionpay`
--

LOCK TABLES `factionpay` WRITE;
/*!40000 ALTER TABLE `factionpay` DISABLE KEYS */;
INSERT INTO `factionpay` VALUES (0,8,30000),(0,7,27000),(0,6,25000),(0,5,20000),(0,4,18000),(0,3,17000),(0,2,16000),(0,1,15000),(0,0,7000);
/*!40000 ALTER TABLE `factionpay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factionranks`
--

DROP TABLE IF EXISTS `factionranks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factionranks` (
  `id` tinyint(2) DEFAULT NULL,
  `rank` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`rank`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factionranks`
--

LOCK TABLES `factionranks` WRITE;
/*!40000 ALTER TABLE `factionranks` DISABLE KEYS */;
INSERT INTO `factionranks` VALUES (0,6,'Major'),(0,5,'Captain'),(0,4,'Lieutenant'),(0,3,'Seargent'),(0,2,'Deputy II'),(0,1,'Deputy I'),(0,8,'Sheriff'),(0,7,'Deputy Sheriff'),(0,0,'Trainee'),(1,5,'District Chief'),(1,4,'Captain'),(1,3,'Senior Paramedic'),(1,7,'Commissioner'),(1,6,'Assistant Commissioner'),(1,2,'Paramedic'),(1,1,'Trainee'),(2,6,'Assistant Director'),(2,5,'Network Producer'),(2,7,'Director'),(2,4,'Assistant Network Producer'),(2,3,'Network Editor'),(2,2,'Network Anchor'),(2,1,'Local Reporter'),(2,0,'Local Editor');
/*!40000 ALTER TABLE `factionranks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factions`
--

DROP TABLE IF EXISTS `factions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factions` (
  `id` tinyint(2) DEFAULT NULL,
  `name` varchar(48) DEFAULT NULL,
  `leader` varchar(24) DEFAULT 'No-one',
  `type` tinyint(2) DEFAULT '0',
  `color` int(10) DEFAULT '-1',
  `rankcount` tinyint(2) DEFAULT '6',
  `lockerx` float DEFAULT '0',
  `lockery` float DEFAULT '0',
  `lockerz` float DEFAULT '0',
  `lockerinterior` tinyint(2) DEFAULT '0',
  `lockerworld` int(10) DEFAULT '0',
  `turftokens` int(10) DEFAULT NULL,
  `shortname` varchar(64) DEFAULT NULL,
  `motd` varchar(128) DEFAULT NULL,
  `budget` int(8) DEFAULT '0',
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factions`
--

LOCK TABLES `factions` WRITE;
/*!40000 ALTER TABLE `factions` DISABLE KEYS */;
INSERT INTO `factions` VALUES (0,'Bone County Sheriff\'s Department','TBA',1,-6750208,9,0,0,0,0,0,NULL,'SASD',NULL,0),(1,'Bone County Fire & Medical Department','No-one',2,-57766400,8,0,0,0,0,0,NULL,NULL,NULL,0),(2,'HI-K69 News Agency ','Heidi_Aukje_Grundel',3,16776960,8,0,0,0,0,0,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `factions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factionskins`
--

DROP TABLE IF EXISTS `factionskins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factionskins` (
  `id` tinyint(2) DEFAULT NULL,
  `slot` tinyint(2) DEFAULT NULL,
  `skinid` smallint(3) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`slot`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factionskins`
--

LOCK TABLES `factionskins` WRITE;
/*!40000 ALTER TABLE `factionskins` DISABLE KEYS */;
INSERT INTO `factionskins` VALUES (0,0,311),(0,1,310),(0,2,309),(0,3,302),(0,4,285),(0,5,284),(0,6,283),(0,7,303),(0,8,282),(0,9,288);
/*!40000 ALTER TABLE `factionskins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `flags`
--

DROP TABLE IF EXISTS `flags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flags` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `flaggedby` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `flags`
--

LOCK TABLES `flags` WRITE;
/*!40000 ALTER TABLE `flags` DISABLE KEYS */;
/*!40000 ALTER TABLE `flags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `furniture`
--

DROP TABLE IF EXISTS `furniture`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `furniture` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `houseid` int(10) DEFAULT NULL,
  `modelid` smallint(5) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `price` int(10) DEFAULT NULL,
  `pos_x` float DEFAULT NULL,
  `pos_y` float DEFAULT NULL,
  `pos_z` float DEFAULT NULL,
  `rot_x` float DEFAULT NULL,
  `rot_y` float DEFAULT NULL,
  `rot_z` float DEFAULT NULL,
  `interior` tinyint(2) DEFAULT NULL,
  `world` int(10) DEFAULT NULL,
  `door_opened` tinyint(1) DEFAULT '0',
  `door_locked` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `furniture`
--

LOCK TABLES `furniture` WRITE;
/*!40000 ALTER TABLE `furniture` DISABLE KEYS */;
/*!40000 ALTER TABLE `furniture` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gangranks`
--

DROP TABLE IF EXISTS `gangranks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gangranks` (
  `id` tinyint(2) DEFAULT NULL,
  `rank` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`rank`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gangranks`
--

LOCK TABLES `gangranks` WRITE;
/*!40000 ALTER TABLE `gangranks` DISABLE KEYS */;
/*!40000 ALTER TABLE `gangranks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gangs`
--

DROP TABLE IF EXISTS `gangs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gangs` (
  `id` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT 'None',
  `motd` varchar(128) DEFAULT 'None',
  `leader` varchar(24) DEFAULT 'No-one',
  `color` int(10) DEFAULT '-256',
  `strikes` tinyint(1) DEFAULT '0',
  `level` tinyint(2) DEFAULT '1',
  `points` int(10) DEFAULT '0',
  `turftokens` int(10) DEFAULT '0',
  `stash_x` float DEFAULT '0',
  `stash_y` float DEFAULT '0',
  `stash_z` float DEFAULT '0',
  `stashinterior` tinyint(2) DEFAULT '0',
  `stashworld` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `pistolammo` int(10) DEFAULT '0',
  `shotgunammo` int(10) DEFAULT '0',
  `smgammo` int(10) DEFAULT '0',
  `arammo` int(10) DEFAULT '0',
  `rifleammo` int(10) DEFAULT '0',
  `hpammo` int(10) DEFAULT '0',
  `poisonammo` int(10) DEFAULT '0',
  `fmjammo` int(10) DEFAULT '0',
  `weapon_9mm` int(10) DEFAULT '0',
  `weapon_sdpistol` int(10) DEFAULT '0',
  `weapon_deagle` int(10) DEFAULT '0',
  `weapon_shotgun` int(10) DEFAULT '0',
  `weapon_spas12` int(10) DEFAULT '0',
  `weapon_sawnoff` int(10) DEFAULT '0',
  `weapon_tec9` int(10) DEFAULT '0',
  `weapon_uzi` int(10) DEFAULT '0',
  `weapon_mp5` int(10) DEFAULT '0',
  `weapon_ak47` int(10) DEFAULT '0',
  `weapon_m4` int(10) DEFAULT '0',
  `weapon_rifle` int(10) DEFAULT '0',
  `weapon_sniper` int(10) DEFAULT '0',
  `weapon_molotov` int(10) DEFAULT '0',
  `armsdealer` tinyint(1) DEFAULT '0',
  `drugdealer` tinyint(1) DEFAULT '0',
  `arms_x` float DEFAULT '0',
  `arms_y` float DEFAULT '0',
  `arms_z` float DEFAULT '0',
  `arms_a` float DEFAULT '0',
  `drug_x` float DEFAULT '0',
  `drug_y` float DEFAULT '0',
  `drug_z` float DEFAULT '0',
  `drug_a` float DEFAULT '0',
  `armsworld` int(10) DEFAULT '0',
  `drugworld` int(10) DEFAULT '0',
  `drugweed` int(10) DEFAULT '0',
  `drugcocaine` int(10) DEFAULT '0',
  `drugmeth` int(10) DEFAULT '0',
  `armsmaterials` int(10) DEFAULT '0',
  `armsprice_1` int(10) DEFAULT '0',
  `armsprice_2` int(10) DEFAULT '0',
  `armsprice_3` int(10) DEFAULT '0',
  `armsprice_4` int(10) DEFAULT '0',
  `armsprice_5` int(10) DEFAULT '0',
  `armsprice_6` int(10) DEFAULT '0',
  `armsprice_7` int(10) DEFAULT '0',
  `armsprice_8` int(10) DEFAULT '0',
  `armsprice_9` int(10) NOT NULL DEFAULT '0',
  `armsprice_10` int(10) NOT NULL DEFAULT '0',
  `armsprice_11` int(10) NOT NULL DEFAULT '0',
  `armsprice_12` tinyint(2) NOT NULL DEFAULT '0',
  `weed_price` int(10) DEFAULT '0',
  `cocaine_price` int(10) DEFAULT '0',
  `meth_price` int(10) DEFAULT '0',
  `matlevel` tinyint(3) NOT NULL DEFAULT '0',
  `gunlevel` tinyint(3) NOT NULL DEFAULT '0',
  `alliance` tinyint(4) NOT NULL DEFAULT '-1',
  `rivals` tinyint(4) DEFAULT '-1',
  `war1` tinyint(2) NOT NULL DEFAULT '0',
  `war2` tinyint(2) NOT NULL DEFAULT '0',
  `war3` tinyint(2) NOT NULL DEFAULT '0',
  `rank_9mm` tinyint(2) NOT NULL DEFAULT '1',
  `rank_sdpistol` tinyint(2) NOT NULL DEFAULT '1',
  `rank_deagle` tinyint(2) NOT NULL DEFAULT '2',
  `rank_shotgun` tinyint(2) NOT NULL DEFAULT '1',
  `rank_spas12` tinyint(2) NOT NULL DEFAULT '4',
  `rank_sawnoff` tinyint(2) NOT NULL DEFAULT '4',
  `rank_tec9` tinyint(2) NOT NULL DEFAULT '1',
  `rank_uzi` tinyint(2) NOT NULL DEFAULT '1',
  `rank_mp5` tinyint(2) NOT NULL DEFAULT '2',
  `rank_ak47` tinyint(2) NOT NULL DEFAULT '3',
  `rank_m4` tinyint(2) NOT NULL DEFAULT '4',
  `rank_rifle` tinyint(2) NOT NULL DEFAULT '2',
  `rank_sniper` tinyint(2) NOT NULL DEFAULT '5',
  `rank_molotov` tinyint(2) NOT NULL DEFAULT '5',
  `rank_vest` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gangs`
--

LOCK TABLES `gangs` WRITE;
/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gangskins`
--

DROP TABLE IF EXISTS `gangskins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gangskins` (
  `id` tinyint(2) DEFAULT NULL,
  `slot` tinyint(2) DEFAULT NULL,
  `skinid` smallint(3) DEFAULT NULL,
  UNIQUE KEY `id` (`id`,`slot`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gangskins`
--

LOCK TABLES `gangskins` WRITE;
/*!40000 ALTER TABLE `gangskins` DISABLE KEYS */;
/*!40000 ALTER TABLE `gangskins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gangsold`
--

DROP TABLE IF EXISTS `gangsold`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gangsold` (
  `id` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT 'None',
  `motd` varchar(128) DEFAULT 'None',
  `leader` varchar(24) DEFAULT 'No-one',
  `color` int(10) DEFAULT '-256',
  `strikes` tinyint(1) DEFAULT '0',
  `level` tinyint(2) DEFAULT '1',
  `points` int(10) DEFAULT '0',
  `turftokens` int(10) DEFAULT '0',
  `stash_x` float DEFAULT '0',
  `stash_y` float DEFAULT '0',
  `stash_z` float DEFAULT '0',
  `stashinterior` tinyint(2) DEFAULT '0',
  `stashworld` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `pistolammo` int(10) DEFAULT '0',
  `shotgunammo` int(10) DEFAULT '0',
  `smgammo` int(10) DEFAULT '0',
  `arammo` int(10) DEFAULT '0',
  `rifleammo` int(10) DEFAULT '0',
  `hpammo` int(10) DEFAULT '0',
  `poisonammo` int(10) DEFAULT '0',
  `fmjammo` int(10) DEFAULT '0',
  `weapon_9mm` int(10) DEFAULT '0',
  `weapon_sdpistol` int(10) DEFAULT '0',
  `weapon_deagle` int(10) DEFAULT '0',
  `weapon_shotgun` int(10) DEFAULT '0',
  `weapon_spas12` int(10) DEFAULT '0',
  `weapon_sawnoff` int(10) DEFAULT '0',
  `weapon_tec9` int(10) DEFAULT '0',
  `weapon_uzi` int(10) DEFAULT '0',
  `weapon_mp5` int(10) DEFAULT '0',
  `weapon_ak47` int(10) DEFAULT '0',
  `weapon_m4` int(10) DEFAULT '0',
  `weapon_rifle` int(10) DEFAULT '0',
  `weapon_sniper` int(10) DEFAULT '0',
  `weapon_molotov` int(10) DEFAULT '0',
  `armsdealer` tinyint(1) DEFAULT '0',
  `drugdealer` tinyint(1) DEFAULT '0',
  `arms_x` float DEFAULT '0',
  `arms_y` float DEFAULT '0',
  `arms_z` float DEFAULT '0',
  `arms_a` float DEFAULT '0',
  `drug_x` float DEFAULT '0',
  `drug_y` float DEFAULT '0',
  `drug_z` float DEFAULT '0',
  `drug_a` float DEFAULT '0',
  `armsworld` int(10) DEFAULT '0',
  `drugworld` int(10) DEFAULT '0',
  `drugweed` int(10) DEFAULT '0',
  `drugcocaine` int(10) DEFAULT '0',
  `drugmeth` int(10) DEFAULT '0',
  `armsmaterials` int(10) DEFAULT '0',
  `armsprice_1` int(10) DEFAULT '0',
  `armsprice_2` int(10) DEFAULT '0',
  `armsprice_3` int(10) DEFAULT '0',
  `armsprice_4` int(10) DEFAULT '0',
  `armsprice_5` int(10) DEFAULT '0',
  `armsprice_6` int(10) DEFAULT '0',
  `armsprice_7` int(10) DEFAULT '0',
  `armsprice_8` int(10) DEFAULT '0',
  `armsprice_9` int(10) NOT NULL DEFAULT '0',
  `armsprice_10` int(10) NOT NULL DEFAULT '0',
  `armsprice_11` int(10) NOT NULL DEFAULT '0',
  `armsprice_12` tinyint(2) NOT NULL DEFAULT '0',
  `weed_price` int(10) DEFAULT '0',
  `cocaine_price` int(10) DEFAULT '0',
  `meth_price` int(10) DEFAULT '0',
  `matlevel` tinyint(3) NOT NULL DEFAULT '0',
  `gunlevel` tinyint(3) NOT NULL DEFAULT '0',
  `alliance` tinyint(4) NOT NULL DEFAULT '-1',
  `war1` tinyint(2) NOT NULL DEFAULT '0',
  `war2` tinyint(2) NOT NULL DEFAULT '0',
  `war3` tinyint(2) NOT NULL DEFAULT '0',
  `rank_9mm` tinyint(2) NOT NULL DEFAULT '1',
  `rank_sdpistol` tinyint(2) NOT NULL DEFAULT '1',
  `rank_deagle` tinyint(2) NOT NULL DEFAULT '2',
  `rank_shotgun` tinyint(2) NOT NULL DEFAULT '1',
  `rank_spas12` tinyint(2) NOT NULL DEFAULT '4',
  `rank_sawnoff` tinyint(2) NOT NULL DEFAULT '4',
  `rank_tec9` tinyint(2) NOT NULL DEFAULT '1',
  `rank_uzi` tinyint(2) NOT NULL DEFAULT '1',
  `rank_mp5` tinyint(2) NOT NULL DEFAULT '2',
  `rank_ak47` tinyint(2) NOT NULL DEFAULT '3',
  `rank_m4` tinyint(2) NOT NULL DEFAULT '4',
  `rank_rifle` tinyint(2) NOT NULL DEFAULT '2',
  `rank_sniper` tinyint(2) NOT NULL DEFAULT '5',
  `rank_molotov` tinyint(2) NOT NULL DEFAULT '5',
  `rank_vest` tinyint(2) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gangsold`
--

LOCK TABLES `gangsold` WRITE;
/*!40000 ALTER TABLE `gangsold` DISABLE KEYS */;
/*!40000 ALTER TABLE `gangsold` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gangtags`
--

DROP TABLE IF EXISTS `gangtags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gangtags` (
  `gangid` int(11) NOT NULL,
  `text` text NOT NULL,
  `fontid` int(11) NOT NULL,
  `pname` text NOT NULL,
  `color` int(11) NOT NULL,
  `x` float(11,4) NOT NULL DEFAULT '0.0000',
  `y` float(11,4) NOT NULL DEFAULT '0.0000',
  `z` float(11,4) NOT NULL DEFAULT '0.0000',
  `rx` float(11,4) NOT NULL DEFAULT '0.0000',
  `ry` float(11,4) NOT NULL DEFAULT '0.0000',
  `rz` float(11,4) NOT NULL DEFAULT '0.0000',
  `ID` int(11) NOT NULL,
  `pdbid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gangtags`
--

LOCK TABLES `gangtags` WRITE;
/*!40000 ALTER TABLE `gangtags` DISABLE KEYS */;
/*!40000 ALTER TABLE `gangtags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `garages`
--

DROP TABLE IF EXISTS `garages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `garages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT NULL,
  `type` tinyint(1) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `freeze` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` int(10) DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `exit_x` float DEFAULT '0',
  `exit_y` float DEFAULT '0',
  `exit_z` float DEFAULT '0',
  `exit_a` float DEFAULT '0',
  `world` int(10) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `garages`
--

LOCK TABLES `garages` WRITE;
/*!40000 ALTER TABLE `garages` DISABLE KEYS */;
INSERT INTO `garages` VALUES (16,0,NULL,0,100000,0,0,0,-306.146,1118.4,19.749,357.28,-306.289,1115.4,19.749,177.28,2000016),(17,0,NULL,0,60000,0,0,0,-363.82,1102.71,19.749,86.858,-360.825,1102.55,19.749,-93.142,2000017);
/*!40000 ALTER TABLE `garages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gates`
--

DROP TABLE IF EXISTS `gates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gates` (
  `ID` int(11) NOT NULL,
  `HID` int(11) NOT NULL DEFAULT '-1',
  `Speed` float NOT NULL DEFAULT '10',
  `Range` float NOT NULL DEFAULT '10',
  `Model` int(11) NOT NULL DEFAULT '18631',
  `VW` int(11) NOT NULL DEFAULT '0',
  `Int` int(11) NOT NULL DEFAULT '0',
  `Pass` varchar(24) NOT NULL DEFAULT '',
  `PosX` float NOT NULL DEFAULT '0',
  `PosY` float NOT NULL DEFAULT '0',
  `PosZ` float NOT NULL DEFAULT '0',
  `RotX` float NOT NULL DEFAULT '0',
  `RotY` float NOT NULL DEFAULT '0',
  `RotZ` float NOT NULL DEFAULT '0',
  `PosXM` float NOT NULL DEFAULT '0',
  `PosYM` float NOT NULL DEFAULT '0',
  `PosZM` float NOT NULL DEFAULT '0',
  `RotXM` float NOT NULL DEFAULT '0',
  `RotYM` float NOT NULL DEFAULT '0',
  `RotZM` float NOT NULL DEFAULT '0',
  `Allegiance` int(11) NOT NULL DEFAULT '0',
  `GroupType` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(2) NOT NULL DEFAULT '-1',
  `GangID` int(2) NOT NULL DEFAULT '-1',
  `RenderHQ` int(11) NOT NULL DEFAULT '1',
  `Timer` int(1) NOT NULL DEFAULT '0',
  `Automate` int(11) NOT NULL,
  `Locked` int(11) NOT NULL,
  `TIndex` int(11) NOT NULL,
  `TModel` int(11) NOT NULL,
  `TColor` int(11) NOT NULL,
  `Facility` int(11) NOT NULL,
  `TTXD` varchar(32) NOT NULL,
  `TTexture` varchar(42) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gates`
--

LOCK TABLES `gates` WRITE;
/*!40000 ALTER TABLE `gates` DISABLE KEYS */;
/*!40000 ALTER TABLE `gates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `graffiti`
--

DROP TABLE IF EXISTS `graffiti`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `graffiti`
--

LOCK TABLES `graffiti` WRITE;
/*!40000 ALTER TABLE `graffiti` DISABLE KEYS */;
/*!40000 ALTER TABLE `graffiti` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gunracks`
--

DROP TABLE IF EXISTS `gunracks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gunracks` (
  `1` int(11) NOT NULL,
  `rackID` int(11) NOT NULL,
  `rackHouse` int(11) NOT NULL,
  `rackX` int(11) NOT NULL,
  `rackY` int(11) NOT NULL,
  `rackZ` int(11) NOT NULL,
  `rackA` int(11) NOT NULL,
  `rackInterior` int(11) NOT NULL,
  `rackWorld` int(11) NOT NULL,
  `rackObjects` int(11) NOT NULL,
  `rackWeapon1` int(11) NOT NULL,
  `rackWeapon2` int(11) NOT NULL,
  `rackWeapon3` int(11) NOT NULL,
  `rackWeapon4` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gunracks`
--

LOCK TABLES `gunracks` WRITE;
/*!40000 ALTER TABLE `gunracks` DISABLE KEYS */;
/*!40000 ALTER TABLE `gunracks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `houses`
--

DROP TABLE IF EXISTS `houses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `houses` (
  `id` int(10) NOT NULL,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `type` tinyint(2) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `rentprice` int(10) DEFAULT '0',
  `level` tinyint(2) DEFAULT '1',
  `locked` tinyint(1) DEFAULT '0',
  `timestamp` int(10) DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `int_x` float DEFAULT '0',
  `int_y` float DEFAULT '0',
  `int_z` float DEFAULT '0',
  `int_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `outsideint` int(10) DEFAULT '0',
  `outsidevw` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `weapon_1` tinyint(2) DEFAULT '0',
  `weapon_2` tinyint(2) DEFAULT '0',
  `weapon_3` tinyint(2) DEFAULT '0',
  `weapon_4` tinyint(2) DEFAULT '0',
  `weapon_5` tinyint(2) DEFAULT '0',
  `weapon_6` tinyint(2) DEFAULT '0',
  `weapon_7` tinyint(2) DEFAULT '0',
  `weapon_8` tinyint(2) DEFAULT '0',
  `weapon_9` tinyint(2) DEFAULT '0',
  `weapon_10` tinyint(2) DEFAULT '0',
  `ammo_1` smallint(5) DEFAULT '0',
  `ammo_2` smallint(5) DEFAULT '0',
  `ammo_3` smallint(5) DEFAULT '0',
  `ammo_4` smallint(5) DEFAULT '0',
  `ammo_5` smallint(5) DEFAULT '0',
  `ammo_6` tinyint(2) DEFAULT '0',
  `ammo_7` tinyint(2) DEFAULT '0',
  `ammo_8` tinyint(2) DEFAULT '0',
  `ammo_9` tinyint(2) DEFAULT '0',
  `ammo_10` tinyint(2) DEFAULT '0',
  `pistolammo` smallint(5) DEFAULT '0',
  `shotgunammo` smallint(5) DEFAULT '0',
  `smgammo` smallint(5) DEFAULT '0',
  `arammo` smallint(5) DEFAULT '0',
  `rifleammo` smallint(5) DEFAULT '0',
  `hpammo` smallint(5) DEFAULT '0',
  `poisonammo` smallint(5) DEFAULT '0',
  `fmjammo` smallint(5) DEFAULT '0',
  `delivery` tinyint(2) DEFAULT '1',
  `lights` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `houses`
--

LOCK TABLES `houses` WRITE;
/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
INSERT INTO `houses` VALUES (574,0,'Nobody',0,25000,0,1,0,1579283686,26.18,1181.52,19.257,90.496,1439.43,1471.55,-9.724,270.219,1,1000574,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(575,0,'Nobody',0,25000,0,1,0,0,26.18,1174.45,19.393,87.049,1439.43,1471.55,-9.724,270.219,1,1000575,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(576,0,'Nobody',0,25000,0,1,0,0,26.18,1167.73,19.523,86.422,1439.43,1471.55,-9.724,270.219,1,1000576,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(577,0,'Nobody',0,25000,0,1,0,0,26.179,1161.09,19.639,89.242,1439.43,1471.55,-9.724,270.219,1,1000577,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(578,0,'Nobody',0,25000,0,1,0,0,-0.893,1165.42,19.547,-97.483,1439.43,1471.55,-9.724,270.219,1,1000578,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(579,0,'Nobody',1,125000,0,1,0,0,-26.697,1215.24,19.352,-178.212,1571.89,1800.5,-19.579,270,2,1000579,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(580,0,'Nobody',0,25000,0,1,0,0,-0.895,1172.26,19.495,-91.843,1439.43,1471.55,-9.724,270.219,1,1000580,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(581,0,'Nobody',1,125000,0,1,0,0,-17.322,1215.28,19.353,-174.139,1571.89,1800.5,-19.579,270,2,1000581,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(582,0,'Nobody',0,25000,0,1,0,0,-0.895,1178.76,19.449,-98.423,1439.43,1471.55,-9.724,270.219,1,1000582,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(583,0,'Nobody',0,25000,0,1,0,0,-0.894,1185.75,19.402,-96.229,1439.43,1471.55,-9.724,270.219,1,1000583,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(584,0,'Nobody',1,125000,0,1,0,0,-17.334,1215.31,22.465,179.281,1571.89,1800.5,-19.579,270,2,1000584,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(585,0,'Nobody',1,125000,0,1,0,0,-26.711,1215.37,22.465,-177.272,1571.89,1800.5,-19.579,270,2,1000585,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(586,0,'Nobody',0,25000,0,1,0,0,13.888,1210.76,19.345,91.122,1439.43,1471.55,-9.724,270.219,1,1000586,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(587,0,'Nobody',1,125000,0,1,0,0,-35.978,1215.07,22.465,-175.706,1571.89,1800.5,-19.579,270,2,1000587,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(588,0,'Nobody',0,25000,0,1,0,1578789223,13.887,1219.81,19.339,95.196,1439.43,1471.55,-9.724,270.219,1,1000588,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(589,0,'Nobody',0,25000,0,1,0,0,13.885,1229.39,19.341,85.795,1439.43,1471.55,-9.724,270.219,1,1000589,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(590,0,'Nobody',0,25000,0,1,0,0,13.868,1210.97,22.503,94.256,1439.43,1471.55,-9.724,270.219,1,1000590,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(591,0,'Nobody',0,25000,0,1,0,0,13.887,1220.12,22.503,90.182,1439.43,1471.55,-9.724,270.219,1,1000591,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(592,0,'Nobody',0,25000,0,1,0,0,13.887,1229.33,22.503,95.509,1439.43,1471.55,-9.724,270.219,1,1000592,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(593,0,'Nobody',0,25000,0,1,0,0,-63.387,1210.95,19.665,-176.53,1439.43,1471.55,-9.724,270.219,1,1000593,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(594,0,'Nobody',0,25000,0,1,0,0,-68.073,1221.5,19.662,90.723,1439.43,1471.55,-9.724,270.219,1,1000594,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(595,0,'Nobody',0,25000,0,1,0,0,-68.073,1223.76,19.649,90.723,1439.43,1471.55,-9.724,270.219,1,1000595,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(596,0,'Nobody',2,525000,0,1,0,0,-258.255,1168.89,20.94,87.34,1651.51,1559.87,-19.716,270,10,1000596,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(597,0,'Nobody',0,25000,0,1,0,0,-63.443,1210.94,22.437,176.264,1439.43,1471.55,-9.724,270.219,1,1000597,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(598,0,'Nobody',2,525000,0,1,0,0,-258.247,1151.06,20.94,91.727,1651.51,1559.87,-19.716,270,10,1000598,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(599,0,'Nobody',2,525000,0,1,0,0,-260.696,1119.9,20.94,93.943,1651.51,1559.87,-19.716,270,10,1000599,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(600,0,'Nobody',0,25000,0,1,0,0,-68.076,1221.52,22.44,88.529,1439.43,1471.55,-9.724,270.219,1,1000600,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(601,0,'Nobody',0,25000,0,1,0,0,-68.073,1223.64,22.44,88.529,1439.43,1471.55,-9.724,270.219,1,1000601,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(602,0,'Nobody',1,250000,0,1,0,0,-298.28,1115.56,20.94,-172.683,1571.89,1800.5,-19.678,267.807,2,1000602,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(603,0,'Nobody',0,25000,0,1,0,0,-63.175,1234.38,22.44,0.167,1439.43,1471.55,-9.724,270.219,1,1000603,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(604,0,'Nobody',0,25000,0,1,0,0,-63.132,1234.39,19.527,0.795,1439.43,1471.55,-9.724,270.219,1,1000604,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(605,0,'Nobody',0,25000,0,1,0,0,-78.17,1234.41,19.742,-88.819,1439.43,1471.55,-9.724,270.219,1,1000605,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(606,0,'Nobody',2,525000,0,1,0,0,-290.388,1176.67,20.94,-93.722,1651.51,1559.87,-19.716,270,10,1000606,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(607,0,'Nobody',0,25000,0,1,0,0,-88.768,1229.73,19.742,-179.06,1439.43,1471.55,-9.724,270.219,1,1000607,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(608,0,'Nobody',0,25000,0,1,0,0,-90.847,1229.74,19.742,-179.06,1439.43,1471.55,-9.724,270.219,1,1000608,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(609,0,'Nobody',2,525000,0,1,0,0,-324.4,1165.67,20.94,-175.189,1651.51,1559.87,-19.716,270,10,1000609,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(610,0,'Nobody',0,25000,0,1,0,0,-101.611,1234.23,19.742,87.253,1439.43,1471.55,-9.724,270.219,1,1000610,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(611,0,'Nobody',1,250000,0,1,0,0,-360.385,1141.66,20.94,-92.178,1571.89,1800.5,-19.678,267.807,2,1000611,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(612,0,'Nobody',0,25000,0,1,0,0,-101.608,1234.49,22.44,85.999,1439.43,1471.55,-9.724,270.219,1,1000612,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(613,0,'Nobody',0,25000,0,1,0,0,-90.984,1229.74,22.44,174.047,1439.43,1471.55,-9.724,270.219,1,1000613,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(614,0,'Nobody',0,25000,0,1,0,0,-88.78,1229.73,22.44,174.047,1439.43,1471.55,-9.724,270.219,1,1000614,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(615,0,'Nobody',2,525000,0,1,0,0,-369.676,1169.16,20.272,-126.645,1651.51,1559.87,-19.716,270,10,1000615,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(616,0,'Nobody',0,25000,0,1,0,0,-78.168,1234.46,22.44,-94.146,1439.43,1471.55,-9.724,270.219,1,1000616,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(617,0,'Nobody',1,250000,0,1,0,0,-362.779,1110.59,20.94,-89.045,1571.89,1800.5,-19.678,267.807,2,1000617,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(618,0,'Nobody',1,300000,0,1,0,0,-328.767,1118.89,20.94,89.87,1571.89,1800.5,-19.678,267.807,2,1000618,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(619,0,'Nobody',1,250000,0,1,0,0,-258.842,1083.07,20.94,1.69,1571.89,1800.5,-19.678,267.807,2,1000619,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(620,0,'Nobody',2,525000,0,1,0,0,-258.248,1043.8,20.94,94.131,1651.51,1559.87,-19.716,270,10,1000620,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(621,0,'Nobody',2,525000,0,1,0,0,-278.81,1003.45,20.94,-2.07,1651.51,1559.87,-19.716,270,10,1000621,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(622,0,'Nobody',2,525000,0,1,0,0,-247.691,1001.08,20.94,0.13,1651.51,1559.87,-19.716,270,10,1000622,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(623,0,'Nobody',0,25000,0,1,0,0,-127.428,974.466,19.852,-92.822,1439.43,1471.55,-9.724,270.219,1,1000623,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(624,0,'Nobody',2,525000,0,1,0,0,-45.081,1081.35,20.94,2.141,1651.51,1559.87,-19.716,270,10,1000624,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(626,0,'Nobody',2,525000,0,1,0,0,-35.956,1115.35,20.94,-179.258,1651.51,1559.87,-19.716,270,10,1000626,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(627,0,'Nobody',0,25000,0,1,0,0,-66.955,971.596,19.886,89.226,1439.43,1471.55,-9.724,270.219,1,1000627,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(628,0,'Nobody',2,525000,0,1,0,0,-17.95,1115.62,20.94,105.542,1651.51,1559.87,-19.716,270,10,1000628,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(629,0,'Nobody',2,525000,0,1,0,0,12.73,1113.24,20.94,-176.124,1651.51,1559.87,-19.716,270,10,1000629,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(630,0,'Nobody',2,525000,0,1,0,0,1.753,1076.21,20.94,95.852,1651.51,1559.87,-19.716,270,10,1000630,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(631,0,'Nobody',0,25000,0,1,0,0,-37.684,962.414,20.051,-89.375,1439.43,1471.55,-9.724,270.219,1,1000631,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(632,0,'Nobody',0,25000,0,1,0,0,-12.842,974.739,19.796,-90.965,1439.43,1471.55,-9.724,270.219,1,1000632,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(633,0,'Nobody',0,25000,0,1,0,0,-4.198,951.023,19.703,-4.171,1439.43,1471.55,-9.724,270.219,1,1000633,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(634,0,'Nobody',2,525000,0,1,0,0,-32.129,1038.28,20.94,-176.125,1651.51,1559.87,-19.716,270,10,1000634,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(635,0,'Nobody',0,25000,0,1,0,0,-15.123,934.293,21.106,177.564,1439.43,1471.55,-9.724,270.219,1,1000635,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(636,0,'Nobody',0,25000,0,1,0,0,31.464,923.608,23.601,-67.755,1439.43,1471.55,-9.724,270.219,1,1000636,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(637,0,'Nobody',0,25000,0,1,0,0,17.942,908.991,23.957,9.012,1439.43,1471.55,-9.724,270.219,1,1000637,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(638,0,'Nobody',0,25000,0,1,0,0,20.739,948.833,20.317,-7.931,1439.43,1471.55,-9.724,270.219,1,1000638,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(639,0,'Nobody',0,25000,0,1,0,0,22.65,968.136,19.84,-2.628,1439.43,1471.55,-9.724,270.219,1,1000639,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(640,0,'Nobody',0,25000,0,1,0,0,70.155,973.939,15.755,172.817,1439.43,1471.55,-9.724,270.219,1,1000640,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(641,0,'Nobody',0,25000,0,1,0,0,65.01,1005.24,13.761,-1.688,1439.43,1471.55,-9.724,270.219,1,1000641,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(642,0,'Nobody',0,25000,0,1,0,0,-52.779,894.165,22.387,-12.005,1439.43,1471.55,-9.724,270.219,1,1000642,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(643,0,'Nobody',0,25000,0,1,0,0,-54.867,918.715,22.371,-9.835,1439.43,1471.55,-9.724,270.219,1,1000643,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(644,0,'Nobody',0,25000,0,1,0,0,-56.623,935.256,21.207,-9.521,1439.43,1471.55,-9.724,270.219,1,1000644,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(645,0,'Nobody',0,25000,0,1,0,0,-83.03,933.125,20.693,-169.95,1439.43,1471.55,-9.724,270.219,1,1000645,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(646,0,'Nobody',0,25000,0,1,0,0,-86.682,915.689,21.107,88.866,1439.43,1471.55,-9.724,270.219,1,1000646,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(647,0,'Nobody',0,25000,0,1,0,0,-91.865,887.219,21.254,54.713,1439.43,1471.55,-9.724,270.219,1,1000647,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(648,0,'Nobody',0,25000,0,1,0,0,-122.988,874.795,18.731,5.519,1439.43,1471.55,-9.724,270.219,1,1000648,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(649,0,'Nobody',0,25000,0,1,0,0,-152.51,881.583,18.439,-69.369,1439.43,1471.55,-9.724,270.219,1,1000649,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(650,0,'Nobody',0,25000,0,1,0,0,-121.221,857.503,18.582,-4.195,1439.43,1471.55,-9.724,270.219,1,1000650,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(651,0,'Nobody',0,25000,0,1,0,0,-123.49,917.801,19.957,115.813,1439.43,1471.55,-9.724,270.219,1,1000651,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(652,0,'Nobody',0,25000,0,1,0,0,-152.971,907.086,19.301,174.094,1439.43,1471.55,-9.724,270.219,1,1000652,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(653,0,'Nobody',0,25000,0,1,0,0,-151.144,933.984,19.723,-179.96,1439.43,1471.55,-9.724,270.219,1,1000653,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(657,0,'Nobody',0,25000,0,1,0,0,9.378,1382.37,9.281,18.067,1439.43,1471.55,-9.724,270.219,1,1000657,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(658,0,'Nobody',0,25000,0,1,0,0,5.014,1380.69,9.281,30.914,1439.43,1471.55,-9.724,270.219,1,1000658,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(659,0,'Nobody',0,25000,0,1,0,0,-1.089,1394.82,9.172,37.471,1439.43,1471.55,-9.724,270.219,1,1000659,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(660,0,'Nobody',0,25000,0,1,0,0,-17.046,1391.23,9.281,49.377,1439.43,1471.55,-9.724,270.219,1,1000660,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(661,0,'Nobody',0,25000,0,1,0,0,-20.659,1388.26,9.281,35.277,1439.43,1471.55,-9.724,270.219,1,1000661,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(662,0,'Nobody',-1,25000,0,1,0,0,-29.382,1363.33,9.281,53.764,1.934,-3.153,999.428,271.163,2,1000662,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(663,0,'Nobody',0,25000,0,1,0,0,-21.157,1348.15,9.172,7.704,1439.43,1471.55,-9.724,270.219,1,1000663,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(664,0,'Nobody',0,25000,0,1,0,0,4.588,1344.3,9.281,57.524,1439.43,1471.55,-9.724,270.219,1,1000664,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(666,0,'Nobody',0,25000,0,1,0,0,78.677,1161.96,18.664,2.296,1439.43,1471.55,-9.724,270.219,1,1000666,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(667,0,'Nobody',0,25000,0,1,0,0,76.439,1161.96,18.664,2.296,1439.43,1471.55,-9.724,270.219,1,1000667,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(668,0,'Nobody',0,25000,0,1,0,0,70.456,1161.96,18.664,1.042,1439.43,1471.55,-9.724,270.219,1,1000668,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(669,0,'Nobody',0,25000,0,1,0,0,68.281,1161.96,18.664,1.042,1439.43,1471.55,-9.724,270.219,1,1000669,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(670,0,'Nobody',0,25000,0,1,0,0,68.537,1161.96,20.94,-10.888,1439.43,1471.55,-9.724,270.219,1,1000670,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(671,0,'Nobody',0,25000,0,1,0,0,70.554,1161.96,20.94,-4.308,1439.43,1471.55,-9.724,270.219,1,1000671,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(672,0,'Nobody',0,25000,0,1,0,0,76.413,1161.96,20.94,4.153,1439.43,1471.55,-9.724,270.219,1,1000672,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(673,0,'Nobody',0,25000,0,1,0,0,78.467,1161.96,20.94,-0.86,1439.43,1471.55,-9.724,270.219,1,1000673,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(674,0,'Nobody',0,25000,0,1,0,0,84.621,1161.97,20.94,-1.174,1439.43,1471.55,-9.724,270.219,1,1000674,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(675,0,'Nobody',0,25000,0,1,0,0,86.63,1161.96,20.94,-1.174,1439.43,1471.55,-9.724,270.219,1,1000675,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(676,0,'Nobody',0,25000,0,1,0,0,99.285,1163.89,18.664,93.767,1439.43,1471.55,-9.724,270.219,1,1000676,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(677,0,'Nobody',0,25000,0,1,0,0,99.283,1161.89,18.657,79.98,1439.43,1471.55,-9.724,270.219,1,1000677,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(678,0,'Nobody',0,25000,0,1,0,0,99.284,1163.9,20.94,89.38,1439.43,1471.55,-9.724,270.219,1,1000678,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(679,0,'Nobody',0,25000,0,1,0,0,99.286,1161.81,20.94,89.38,1439.43,1471.55,-9.724,270.219,1,1000679,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(680,0,'Nobody',0,25000,0,1,0,0,99.283,1169.87,20.94,91.573,1439.43,1471.55,-9.724,270.219,1,1000680,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(681,0,'Nobody',0,25000,0,1,0,0,99.284,1171.91,20.94,91.573,1439.43,1471.55,-9.724,270.219,1,1000681,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(682,0,'Nobody',0,25000,0,1,0,0,99.286,1177.95,20.94,86.873,1439.43,1471.55,-9.724,270.219,1,1000682,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(683,0,'Nobody',0,25000,0,1,0,0,99.286,1179.97,20.94,86.873,1439.43,1471.55,-9.724,270.219,1,1000683,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(684,0,'Nobody',0,25000,0,1,0,0,99.282,1177.82,18.664,93.163,1439.43,1471.55,-9.724,270.219,1,1000684,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(685,0,'Nobody',0,25000,0,1,0,0,99.282,1179.95,18.664,93.163,1439.43,1471.55,-9.724,270.219,1,1000685,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(686,0,'Nobody',0,25000,0,1,0,0,99.284,1171.91,18.664,90.97,1439.43,1471.55,-9.724,270.219,1,1000686,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(687,0,'Nobody',0,25000,0,1,0,0,99.286,1169.8,18.664,90.97,1439.43,1471.55,-9.724,270.219,1,1000687,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(688,0,'Nobody',0,25000,0,1,0,0,86.53,1161.96,18.657,-6.164,1439.43,1471.55,-9.724,270.219,1,1000688,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(689,0,'Nobody',0,25000,0,1,0,0,84.361,1161.96,18.657,-6.164,1439.43,1471.55,-9.724,270.219,1,1000689,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(690,0,'Nobody',0,25000,0,1,0,0,21.459,1344.17,9.281,21.922,1439.43,1471.55,-9.724,270.219,1,1000690,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(691,0,'Nobody',0,25000,0,1,0,0,25.762,1346.04,9.281,19.415,1439.43,1471.55,-9.724,270.219,1,1000691,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(692,0,'Nobody',1,125000,0,1,0,0,-92.57,970.016,19.982,12.103,1571.89,1800.5,-19.579,270,2,1000692,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(694,0,'Nobody',1,125000,0,1,0,0,-36.064,1215.41,19.352,-179.277,1571.89,1800.5,-19.579,270,2,1000694,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(696,0,'Nobody',1,125000,0,1,0,0,300.121,1141.22,9.137,-90.539,1571.89,1800.5,-19.678,270,2,1000696,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(697,0,'Nobody',0,25000,0,1,0,0,397.284,1157.62,8.348,-93.359,1439.43,1471.55,-9.824,270,1,1000697,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(698,0,'Nobody',1,125000,0,1,0,0,500.833,1116.19,15.036,-98.709,1571.89,1800.5,-19.678,270,2,1000698,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(700,0,'Nobody',0,25000,0,1,0,0,709.906,1194.72,13.396,-98.709,1439.43,1471.55,-9.824,270,1,1000700,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(701,0,'Nobody',0,25000,0,1,0,0,710.365,1208.05,13.848,-178.61,1439.43,1471.55,-9.824,270,1,1000701,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(0,0,'Nobody',2,1200000,0,5,0,0,-245.068,1213.46,19.742,-0.8,1651.51,1559.87,-19.816,270,10,1000000,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,0,0,0,0,0,0,0,0,0,0,0,1,1);
/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `houses.new`
--

DROP TABLE IF EXISTS `houses.new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `houses.new` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `type` tinyint(2) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `rentprice` int(10) DEFAULT '0',
  `level` tinyint(2) DEFAULT '1',
  `locked` tinyint(1) DEFAULT '0',
  `timestamp` int(10) DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `int_x` float DEFAULT '0',
  `int_y` float DEFAULT '0',
  `int_z` float DEFAULT '0',
  `int_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `outsideint` int(10) DEFAULT '0',
  `outsidevw` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `weapon_1` tinyint(2) DEFAULT '0',
  `weapon_2` tinyint(2) DEFAULT '0',
  `weapon_3` tinyint(2) DEFAULT '0',
  `weapon_4` tinyint(2) DEFAULT '0',
  `weapon_5` tinyint(2) DEFAULT '0',
  `weapon_6` tinyint(2) DEFAULT '0',
  `weapon_7` tinyint(2) DEFAULT '0',
  `weapon_8` tinyint(2) DEFAULT '0',
  `weapon_9` tinyint(2) DEFAULT '0',
  `weapon_10` tinyint(2) DEFAULT '0',
  `ammo_1` smallint(5) DEFAULT '0',
  `ammo_2` smallint(5) DEFAULT '0',
  `ammo_3` smallint(5) DEFAULT '0',
  `ammo_4` smallint(5) DEFAULT '0',
  `ammo_5` smallint(5) DEFAULT '0',
  `ammo_6` tinyint(2) DEFAULT '0',
  `ammo_7` tinyint(2) DEFAULT '0',
  `ammo_8` tinyint(2) DEFAULT '0',
  `ammo_9` tinyint(2) DEFAULT '0',
  `ammo_10` tinyint(2) DEFAULT '0',
  `pistolammo` smallint(5) DEFAULT '0',
  `shotgunammo` smallint(5) DEFAULT '0',
  `smgammo` smallint(5) DEFAULT '0',
  `arammo` smallint(5) DEFAULT '0',
  `rifleammo` smallint(5) DEFAULT '0',
  `hpammo` smallint(5) DEFAULT '0',
  `poisonammo` smallint(5) DEFAULT '0',
  `fmjammo` smallint(5) DEFAULT '0',
  `delivery` tinyint(2) DEFAULT '1',
  `lights` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=783 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `houses.new`
--

LOCK TABLES `houses.new` WRITE;
/*!40000 ALTER TABLE `houses.new` DISABLE KEYS */;
INSERT INTO `houses.new` VALUES (711,73,'Rafael_Martinez',0,8000,0,1,0,1579504886,86.38,1162.39,18.657,-13.705,1439.25,1471.73,-9.724,181.471,1,1000711,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(713,0,'Nobody',0,8000,0,1,0,0,76.775,1161.96,18.664,-9.67,1439.26,1471.38,-9.724,181.471,1,1000713,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(714,0,'Nobody',0,8000,0,1,0,0,70.166,1161.96,18.664,-45.312,1439.21,1471.87,-9.724,177.397,1,1000714,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(715,0,'Nobody',0,8000,0,1,0,0,99.277,1163.7,18.664,82.538,1439.18,1471.78,-9.724,177.734,1,1000715,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(716,0,'Nobody',0,8000,0,1,0,0,69.023,1161.98,20.94,-28.259,1439.43,1471.55,-9.724,187.134,1,1000716,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(717,0,'Nobody',0,8000,0,1,0,0,78.358,1161.96,20.94,29.708,1439.32,1471.85,-9.724,188.051,1,1000717,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(719,0,'Nobody',0,8000,0,1,0,0,99.277,1179.56,18.664,91.938,1439.25,1471.82,-9.724,171.444,1,1000719,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(720,0,'Nobody',0,8000,0,1,0,0,99.285,1178.22,20.94,79.381,1439.37,1471.76,-9.724,177.711,1,1000720,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(721,0,'Nobody',0,8000,0,1,0,0,86.293,1161.96,20.94,29.708,1439.21,1471.73,-9.724,173.974,1,1000721,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(722,0,'Nobody',0,8000,0,1,0,0,99.285,1163.52,20.94,97.241,1439.37,1471.76,-9.724,177.711,1,1000722,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(723,0,'Nobody',0,8000,0,1,0,0,99.285,1171.5,20.94,95.988,1439.3,1471.84,-9.724,164.261,1,1000723,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(724,0,'Nobody',0,9000,0,1,0,0,-17.493,1215.41,19.353,179.966,1439.34,1471.73,-9.724,180.868,1,1000724,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(725,0,'Nobody',0,9000,0,1,0,0,-26.811,1215.37,19.352,171.923,1439.28,1471.61,-9.724,174.914,1,1000725,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(726,0,'Nobody',0,9000,0,1,0,0,13.888,1229.28,19.341,93.974,1439.31,1471.64,-9.724,179.277,1,1000726,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(727,0,'Nobody',0,9000,0,2,0,0,-36.122,1215.38,19.352,177.994,1439.16,1471.83,-9.724,180.554,1,1000727,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(728,0,'Nobody',0,9000,0,2,0,0,13.881,1219.93,19.339,-94.172,1439.43,1471.55,-9.824,270,1,1000728,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(729,0,'Nobody',0,9000,0,2,0,0,-17.548,1215.39,22.465,169.848,1439.27,1471.76,-9.724,175.854,1,1000729,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(730,0,'Nobody',0,9000,0,2,0,0,-26.787,1215.38,22.465,184.191,1439.47,1471.73,-9.724,184.001,1,1000730,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(731,0,'Nobody',0,9000,0,2,0,0,-36.026,1215.33,22.465,183.251,1439.33,1471.77,-9.724,180.241,1,1000731,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(738,0,'Nobody',0,6000,0,1,0,0,-68.074,1221.88,19.66,89.15,1439.29,1471.87,-9.724,179.614,1,1000738,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(740,0,'Nobody',0,25000,0,1,0,0,-63.367,1234.41,22.44,3.754,1439.42,1471.81,-9.724,180.241,1,1000740,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(741,0,'Nobody',0,9000,0,1,0,0,-68.109,1223.61,22.44,93.995,1439.26,1471.82,-9.724,179.614,1,1000741,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(742,0,'Nobody',0,25000,0,1,0,0,-63.254,1210.94,22.437,178.451,1439.17,1471.86,-9.724,178.361,1,1000742,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(744,0,'Nobody',1,95000,0,1,0,0,-369.812,1169.3,20.272,-121.126,1572.11,1800.49,-19.578,90.627,2,1000744,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(746,0,'Nobody',1,75000,0,1,0,0,-290.628,1176.72,20.94,-11.323,1571.89,1800.5,-19.678,270,2,1000746,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(747,0,'Nobody',0,6000,0,1,0,0,2242.37,-1170.7,1029.8,-89.021,1439.43,1471.55,-9.824,270,1,1000747,15,4000008,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,0,0,0,0,0,0,0,0,0,1,1),(748,0,'Nobody',0,6000,0,1,0,0,2225.54,-1189.96,1029.8,177.701,1439.43,1471.55,-9.824,270,1,1000748,15,4000008,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,0,0,0,0,0,0,0,0,0,1,1),(749,0,'Nobody',0,6000,0,1,0,0,2209.73,-1187.38,1029.8,5.92,1439.43,1471.55,-9.824,270,1,1000749,15,4000008,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,0,0,0,0,0,0,0,0,0,1,1),(750,0,'Nobody',0,25000,0,1,0,0,2191.9,-1173.08,1029.8,262.139,1439.4,1471.64,-9.724,177.421,1,1000750,15,4000008,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,0,0,0,0,0,0,0,0,0,1,1),(751,0,'Nobody',-1,4500,0,1,0,0,-766.368,1613.79,27.117,-5.884,2.044,-3.067,999.428,84.27,2,1000751,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(760,0,'Nobody',1,97500,0,1,0,0,-1532.54,2656.84,56.281,-98.142,1571.89,1800.5,-19.678,270,2,1000760,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(761,0,'Nobody',2,350000,0,1,0,0,-911.093,2686.17,42.37,-137.468,1651.51,1559.87,-19.816,270,10,1000761,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(762,0,'Nobody',0,70000,0,1,0,0,-1466.22,2693.13,56.27,-90.401,1439.43,1471.55,-9.824,270,1,1000762,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(763,0,'Nobody',0,15000,0,1,0,0,-310.99,2726.68,62.872,90.319,1439.43,1471.55,-9.824,270,1,1000763,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(764,0,'Nobody',0,15000,0,1,0,0,-168.601,2707.18,62.529,-102.948,1439.43,1471.55,-9.824,270,1,1000764,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(765,0,'Nobody',0,25000,0,1,0,0,-201.68,2771.99,62.204,-174.539,1439.43,1471.55,-9.824,270,1,1000765,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(766,0,'Nobody',1,67000,0,1,0,0,-219.737,2767.06,62.688,-2.266,1571.89,1800.5,-19.678,270,2,1000766,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(767,0,'Nobody',0,16700,0,1,0,0,-258.042,2782.95,62.688,-6.622,1439.43,1471.55,-9.824,270,1,1000767,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(768,0,'Nobody',0,9500,0,1,0,0,-287.455,2757.84,62.512,81.037,1439.43,1471.55,-9.824,270,1,1000768,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(769,0,'Nobody',0,70000,0,1,0,0,-1482.36,2702.71,56.254,6.984,1439.43,1471.55,-9.824,270,1,1000769,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(770,0,'Nobody',1,125000,0,1,0,0,-324.439,1165.56,20.94,-0.034,1572.15,1800.57,-19.578,88.747,2,1000770,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(772,0,'Nobody',0,40000,0,1,0,0,-247.846,1001.08,20.94,176.917,1439.43,1471.55,-9.824,270,1,1000772,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(773,0,'Nobody',0,50000,0,1,0,0,-39.115,1074.19,20.94,86.612,1439.43,1471.55,-9.824,270,1,1000773,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(774,0,'Nobody',0,50000,0,1,0,0,-41.887,1122.73,20.94,-96.063,1439.43,1471.55,-9.824,270,1,1000774,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(775,0,'Nobody',0,125000,0,1,0,0,-18.225,1115.67,20.94,-3.269,1439.43,1471.55,-9.824,270,1,1000775,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(776,0,'Nobody',0,125000,0,1,0,0,1.742,1076.21,20.94,-92.276,1439.43,1471.55,-9.824,270,1,1000776,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,0,0,0,0,0,0,0,0,0,0,0,1,1),(778,0,'Nobody',1,275000,0,1,0,0,-2437.44,2354.95,5.443,17.624,1571.89,1800.5,-19.678,270,2,1000778,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,0,0,0,0,0,0,0,0,0,0,0,1,1);
/*!40000 ALTER TABLE `houses.new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kills`
--

DROP TABLE IF EXISTS `kills`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kills` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `killer_uid` int(10) DEFAULT NULL,
  `target_uid` int(10) DEFAULT NULL,
  `killer` varchar(24) DEFAULT NULL,
  `target` varchar(24) DEFAULT NULL,
  `reason` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kills`
--

LOCK TABLES `kills` WRITE;
/*!40000 ALTER TABLE `kills` DISABLE KEYS */;
INSERT INTO `kills` VALUES (31,74,68,'Nicolas_Joshua','tBKwtWS','Combat shotgun','2020-01-20 16:07:57'),(32,74,68,'Nicolas_Joshua','tBKwtWS','Combat shotgun','2020-01-20 16:08:06'),(33,74,68,'Nicolas_Joshua','tBKwtWS','Shotgun','2020-01-20 16:08:44'),(34,74,68,'Nicolas_Joshua','tBKwtWS','Shotgun','2020-01-20 16:09:01'),(35,74,73,'Nicolas_Joshua','Rafael_Martinez','Shotgun','2020-01-20 16:13:57'),(36,74,68,'Nicolas_Joshua','tBKwtWS','Shotgun','2020-01-20 16:14:01');
/*!40000 ALTER TABLE `kills` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `landobjects`
--

DROP TABLE IF EXISTS `landobjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `landobjects` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `landid` int(10) DEFAULT NULL,
  `modelid` smallint(5) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `price` int(10) DEFAULT NULL,
  `pos_x` float DEFAULT NULL,
  `pos_y` float DEFAULT NULL,
  `pos_z` float DEFAULT NULL,
  `rot_x` float DEFAULT NULL,
  `rot_y` float DEFAULT NULL,
  `rot_z` float DEFAULT NULL,
  `door_opened` tinyint(1) DEFAULT '0',
  `door_locked` tinyint(1) DEFAULT '0',
  `move_x` float DEFAULT '0',
  `move_y` float DEFAULT '0',
  `move_z` float DEFAULT '0',
  `move_rx` float DEFAULT '0',
  `move_ry` float DEFAULT '0',
  `move_rz` float DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `landobjects`
--

LOCK TABLES `landobjects` WRITE;
/*!40000 ALTER TABLE `landobjects` DISABLE KEYS */;
INSERT INTO `landobjects` VALUES (469,0,638,'Wide plant',250,1275.3,-1385.7,13.047,0,0,91.172,0,0,1276.78,-1385.67,3.077,-1000,-1000,-1000),(471,0,638,'Wide plant',250,1284.07,-1385.51,13.137,0,0,91.172,0,0,1276.64,-1385.67,3.047,-1000,-1000,-1000),(472,0,638,'Wide plant',250,1279.7,-1385.61,13.047,0,0,91.172,0,0,1275.68,-1385.69,3.047,-1000,-1000,-1000),(473,0,1622,'Security camera',50,1288.19,-1367.95,17.878,0,0,86.83,0,0,1287.82,-1367.93,7.878,-1000,-1000,-1000),(474,0,1622,'Security camera',50,1286.8,-1291.92,17.888,0,0,0.13,0,0,1287.82,-1367.93,7.878,-1000,-1000,-1000),(476,0,1622,'Security camera',50,1286.78,-1366.57,17.878,0,0,0.13,0,0,1286.78,-1366.97,7.878,-1000,-1000,-1000),(477,0,1622,'Security camera',50,1287.88,-1290.44,17.868,0,0,-90.07,0,0,1286.61,-1291.66,7.768,-1000,-1000,-1000),(478,0,638,'Wide plant',250,1275.42,-1290.22,13.179,0,0,-89.825,0,0,1275.41,-1290.22,3.179,-1000,-1000,-1000),(479,0,638,'Wide plant',250,1283.49,-1290.19,13.219,0,0,-89.825,0,0,1275.41,-1290.22,3.179,-1000,-1000,-1000),(480,0,638,'Wide plant',250,1279.36,-1290.21,13.179,0,0,-89.825,0,0,1275.41,-1290.22,3.179,-1000,-1000,-1000),(482,0,1300,'Cement trashcan',50,1270.31,-1345.02,12.848,0,0,-179.663,0,0,1270.31,-1345.02,2.848,-1000,-1000,-1000),(483,0,1349,'Shopping cart',50,1271.68,-1313.54,13.074,0,0,90.309,0,0,1270.91,-1329.46,3.064,-1000,-1000,-1000),(484,0,1211,'Fire hydrant',50,1270.41,-1330.45,12.877,0,0,-179.899,0,0,1270.41,-1330.56,2.897,-1000,-1000,-1000),(485,0,11727,'Round light',50,1287.16,-1347.36,14.793,0,0,-90.034,0,0,1287.17,-1347.35,4.793,-1000,-1000,-1000),(486,0,11727,'Round light',50,1287.16,-1352.28,14.793,0,0,-90.034,0,0,1287.16,-1347.36,4.793,-1000,-1000,-1000),(487,0,11727,'Round light',50,1287.17,-1331.62,14.793,0,0,-90.034,0,0,1287.16,-1347.36,4.793,-1000,-1000,-1000),(489,0,11727,'Round light',50,1287.18,-1310.9,14.793,0,0,-90.034,0,0,1287.17,-1326.72,4.793,-1000,-1000,-1000),(490,0,11727,'Round light',50,1287.18,-1305.75,14.793,0,0,-90.034,0,0,1287.18,-1310.9,4.793,-1000,-1000,-1000),(496,0,1775,'Sprunk machine',1000,1286.7,-1339.37,13.703,0,0,-89.725,0,0,1286.7,-1339.37,3.703,-1000,-1000,-1000),(497,0,1776,'Candy machine',1000,1286.74,-1318.71,13.649,0,0,-90.886,0,0,1286.74,-1318.71,3.649,-1000,-1000,-1000),(503,0,19374,'wall022',100,1270.35,-1332.83,10.983,89.7,0,179.73,0,0,1270.35,-1332.96,1.012,-1000,-1000,-1000),(504,0,19374,'wall022',100,1270.31,-1336.33,10.964,89.7,0,179.73,0,0,1270.35,-1332.96,0.982,-1000,-1000,-1000),(505,0,19374,'wall022',100,1270.28,-1339.92,10.947,89.7,0,179.73,0,0,1270.31,-1336.57,0.963,-1000,-1000,-1000),(506,0,19374,'wall022',100,1270.24,-1343.53,10.927,89.7,0,179.73,0,0,1270.28,-1340.16,0.945,-1000,-1000,-1000),(507,0,1211,'Fire hydrant',50,1287.98,-1286.38,12.923,0,0,-0.908,0,0,1272.84,-1286.1,2.923,-1000,-1000,-1000),(508,0,1371,'Hippo trashcan',50,1288.63,-1372.84,13.41,0,0,217.847,0,0,1288.63,-1372.84,3.41,-1000,-1000,-1000),(509,0,2114,'Basketball',50,1288.74,-1373.88,12.829,50.9,-48.3,-16.955,0,0,1288.24,-1374.69,2.779,-1000,-1000,-1000),(510,0,11733,'Rocking horse',50,1288.02,-1375.3,12.681,0,0,-30.35,0,0,1288.02,-1375.3,2.681,-1000,-1000,-1000),(511,0,19625,'Cigarette',50,1265.85,-1359.03,12.492,0,0,-141.592,0,0,1265.85,-1359.03,2.492,-1000,-1000,-1000),(512,0,19995,'Clip',50,1270.33,-1383.41,13.911,-2.4,-91.2,163.669,0,0,1270.33,-1383.41,3.911,-1000,-1000,-1000),(513,0,2866,'Takeaway trash',50,1270.35,-1344.98,13.298,0,0,-179.158,0,0,1270.35,-1344.98,3.298,-1000,-1000,-1000),(514,0,2840,'Burger shot trash',50,1270.24,-1345.07,13.468,-177.4,0,175.052,0,0,1270.22,-1345.07,3.468,-1000,-1000,-1000),(516,0,2670,'Assorted trash #7',50,1265.43,-1359.07,12.398,0,0,128.038,0,0,1265.34,-1357.68,4.508,-1000,-1000,-1000),(517,0,2930,'Door with bars',100,1270.97,-1312.62,13.69,90.9,62.2,117.782,0,1,1271.13,-1313.43,4.204,-1000,-1000,-1000),(519,0,2930,'Door with bars',100,1272.36,-1312.62,13.671,90.9,62.2,117.782,0,1,1271.12,-1312.62,3.688,-1000,-1000,-1000),(520,0,2930,'Door with bars',100,1272.42,-1312.69,13.677,-179.2,179.6,89.982,1,0,1271.12,-1312.62,3.688,-1000,-1000,-1000),(521,0,1349,'Shopping cart',50,1271.68,-1314.04,13.074,0,0,90.309,0,0,1271.68,-1313.54,3.074,-1000,-1000,-1000),(522,0,1349,'Shopping cart',50,1271.68,-1314.55,13.074,0,0,90.309,0,0,1271.68,-1314.04,3.074,-1000,-1000,-1000),(523,0,1349,'Shopping cart',50,1271.68,-1315.03,13.074,0,0,90.309,0,0,1271.68,-1314.55,3.074,-1000,-1000,-1000),(524,0,1349,'Shopping cart',50,1271.68,-1315.5,13.074,0,0,90.309,0,0,1271.68,-1315.03,3.074,-1000,-1000,-1000),(525,0,2840,'Burger shot trash',50,1288.68,-1372.68,13.57,-2,92.7,-138.04,0,0,1288.68,-1372.68,3.57,-1000,-1000,-1000),(527,0,2663,'Burger shot bag',50,1288.6,-1372.92,13.633,-2.6,0.1,-140.928,0,0,1288.6,-1372.92,3.633,-1000,-1000,-1000),(528,0,2056,'Target #1',50,1270.35,-1383.24,13.924,-90.2,0,122.742,0,0,1270.35,-1383.24,3.924,-1000,-1000,-1000),(529,0,19362,'wall010',100,1277.16,-1379.75,10.482,-0.8,0,139.121,0,0,1277.19,-1379.71,0.483,-1000,-1000,-1000),(530,0,19362,'wall010',100,1277.14,-1373.33,10.511,-0.4,0,139.121,0,0,1277.19,-1379.71,0.483,-1000,-1000,-1000),(531,0,19362,'wall010',100,1277.04,-1367.47,10.541,-0.4,0,139.121,0,0,1277.17,-1373.29,0.511,-1000,-1000,-1000),(532,0,19362,'wall010',100,1277,-1361.08,10.575,-0.4,0,139.121,0,0,1277,-1367.52,0.541,-1000,-1000,-1000),(533,0,19362,'wall010',100,1276.93,-1354.42,10.61,-0.3,0,139.121,0,0,1277,-1361.08,0.575,-1000,-1000,-1000),(534,0,1349,'Shopping cart',50,1271.75,-1316.46,13.074,0,0,102.509,0,0,1271.68,-1315.5,3.074,-1000,-1000,-1000),(535,0,1622,'Security camera',50,1287.23,-1346.48,21.955,0,0,-92.094,0,0,1287.12,-1346.42,9.635,-1000,-1000,-1000),(537,0,19328,'Monkey juice poster',50,1288.2,-1367.21,14.068,0,0,-1.376,0,0,1288.2,-1367.21,4.068,-1000,-1000,-1000),(538,0,2729,'T-Shirt poster',50,1287.12,-1312.3,14.298,0,0,-89.897,0,0,1287.11,-1308.34,6.398,-1000,-1000,-1000),(539,0,2736,'Zip poster',50,1287.21,-1308.38,16.017,0,0,-90.011,0,0,1287.21,-1308.38,6.547,-1000,-1000,-1000),(540,0,2719,'99c binco poster',50,1287.14,-1332.89,14.548,0,0,-89.824,0,0,1287.14,-1332.89,4.548,-1000,-1000,-1000),(541,0,2658,'Suburban poster',50,1287.15,-1303.94,14.227,0,0,-89.757,0,0,1287.15,-1303.94,4.227,-1000,-1000,-1000),(542,0,2656,'Black prolaps poster',50,1287.13,-1353.34,14.311,0,0,-89.844,0,0,1287.13,-1353.34,4.311,-1000,-1000,-1000),(543,0,2655,'Eris poster',50,1287.14,-1346.2,14.313,0,0,-89.964,0,0,1287.14,-1346.2,4.313,-1000,-1000,-1000),(544,0,2697,'White prolaps poster',50,1287.92,-1290.81,14.248,0.1,0,179.828,0,0,1287.92,-1290.82,4.248,-1000,-1000,-1000),(551,0,19912,'Plain metal bar gate',1000,1279.65,-1291.6,12.293,89.7,-13.2,103.26,0,0,1279.7,-1291.59,2.213,89.7,-13.2,103.26),(556,0,19912,'Plain metal bar gate',1000,1279.7,-1291.57,2.206,-89.8,-93.1,-2.791,0,0,1279.7,-1291.61,12.266,-90.1,-93.1,-2.491),(559,0,19362,'wall010',100,1273.5,-1337.95,10.608,-0.3,0,89.821,0,0,1276.93,-1354.42,0.61,-1000,-1000,-1000),(560,0,19362,'wall010',100,1277.01,-1303.32,10.586,-0.3,0,89.821,0,0,1273.5,-1337.95,0.608,-1000,-1000,-1000),(561,0,19362,'wall010',100,1282.25,-1303.34,10.613,-0.3,0,89.821,0,0,1277.01,-1303.32,0.586,-1000,-1000,-1000),(562,0,19362,'wall010',100,1279.54,-1303.33,10.599,-0.3,0,89.821,0,0,1282.25,-1303.34,0.613,-1000,-1000,-1000),(563,0,19362,'wall010',100,1279.42,-1324.32,10.615,0,0,-0.079,0,0,1273.5,-1337.95,0.608,-1000,-1000,-1000),(565,0,19362,'wall010',100,1276.77,-1327.3,10.605,-0.3,0,89.821,0,0,1273.5,-1337.95,0.608,-1000,-1000,-1000),(567,0,19362,'wall010',100,1279.43,-1317.79,10.605,0,0,-0.079,0,0,1279.42,-1324.32,0.615,-1000,-1000,-1000),(568,0,1300,'Cement trashcan',50,1274.21,-1293.07,12.858,0,0,91.474,0,0,1274.21,-1293.07,2.858,-1000,-1000,-1000),(569,0,1300,'Cement trashcan',50,1287.78,-1384.36,13.12,0,0,-89.029,0,0,1287.78,-1384.36,3.12,-1000,-1000,-1000),(570,0,1364,'Bush plant and bench',500,1271.57,-1354.21,13.085,0,0,90.458,0,0,1271.57,-1354.21,3.245,-1000,-1000,-1000),(571,0,1364,'Bush plant and bench',500,1269.07,-1378.54,12.966,0,0,-89.858,0,0,1269.07,-1378.54,3.116,-1000,-1000,-1000),(572,0,19362,'wall010',100,1277.06,-1303.32,0.516,0.0000003874,0,89.821,0,0,1277.01,-1303.32,0.586,-1000,-1000,-1000),(573,0,19362,'wall010',100,1282.3,-1303.34,0.513,0.2,0,89.821,0,0,1282.25,-1303.34,0.613,-1000,-1000,-1000),(574,0,19380,'wall028',100,1279.66,-1296.16,2.18,0.0000000298,89.9,89.845,0,0,1279.66,-1296.16,-7.82,-1000,-1000,-1000),(576,0,19362,'wall010',100,1279.41,-1303.33,0.508,-0.0000000298,0,89.821,0,0,1277.06,-1303.32,-9.484,-1000,-1000,-1000),(577,0,2860,'Open pizza box',50,1287.81,-1384.32,13.499,13.2,-49.3,151.845,0,0,1287.74,-1384.29,3.519,-1000,-1000,-1000),(578,0,2860,'Open pizza box',50,1274,-1293.22,12.482,0,0,-4.247,0,0,1274,-1293.22,2.482,-1000,-1000,-1000),(579,0,2663,'Burger shot bag',50,1274.31,-1293.21,13.434,-30.7,0,-115.63,0,0,1274.31,-1293.21,3.434,-1000,-1000,-1000),(580,0,2840,'Burger shot trash',50,1274.14,-1292.96,13.383,0,113.6,159.755,0,0,1274.15,-1292.93,3.383,-1000,-1000,-1000),(581,0,14410,'Long concrete stairs',50,1297.41,-1297.13,3.032,0,0,-90.236,0,0,1291.56,-1297.11,-4.568,-1000,-1000,-1000),(583,0,19380,'wall028',100,1289.01,-1297.1,2.199,0.0000000298,89.9,89.845,0,0,1279.63,-1306.66,-7.838,-1000,-1000,-1000),(588,0,19380,'wall028',100,1310.16,-1361,12.479,0.0000000298,90,90.845,0,0,1310.19,-1349.39,2.479,-1000,-1000,-1000),(589,0,19380,'wall028',100,1310.01,-1350.49,12.479,0.0000000298,90,90.845,0,0,1310.16,-1361,2.479,-1000,-1000,-1000),(590,0,19380,'wall028',100,1309.86,-1340.02,12.479,0.0000000298,90,90.845,0,0,1310.01,-1350.49,2.479,-1000,-1000,-1000),(591,0,19380,'wall028',100,1309.71,-1329.52,12.479,0.0000000298,90,90.845,0,0,1309.86,-1340.02,2.479,-1000,-1000,-1000),(592,0,19380,'wall028',100,1279.63,-1306.66,2.162,0.0000000298,89.9,89.845,0,0,1279.66,-1296.16,-7.82,-1000,-1000,-1000),(593,0,19380,'wall028',100,1309.56,-1319.02,12.479,0.0000000298,90,90.845,0,0,1309.71,-1329.52,2.479,-1000,-1000,-1000),(594,0,14410,'Long concrete stairs',50,1308.71,-1306.67,9.378,0,0,-178.922,0,0,1308.77,-1306.66,-0.692,-1000,-1000,-1000),(595,0,14416,'Short concrete stairs',50,1312.78,-1309.83,13.525,0,0,0.592,0,0,1312.78,-1309.83,3.525,-1000,-1000,-1000),(596,0,19380,'wall028',100,1309.2,-1294.33,6.129,0.0000000298,90,90.845,0,0,1309.56,-1319.02,2.479,-1000,-1000,-1000),(597,0,19362,'wall010',100,1273.5,-1337.95,10.608,-0.3,0,89.821,0,0,1273.5,-1337.95,0.608,-1000,-1000,-1000),(603,0,1364,'Bush plant and bench',500,1271.57,-1354.21,13.085,0,0,90.458,0,0,1271.57,-1354.21,3.085,-1000,-1000,-1000),(604,0,3361,'Wooden stairs',50,1286.11,-1363.11,14.551,0,0,-90.074,0,0,1286.11,-1363.15,4.551,-1000,-1000,-1000),(605,0,19360,'wall008',100,1286.73,-1356.48,16.691,0,90.5,89.506,0,0,1285.56,-1357.56,6.667,-1000,-1000,-1000),(606,0,19360,'wall008',100,1286.75,-1353.62,16.846,0,90.5,89.506,0,0,1286.73,-1356.44,6.671,-1000,-1000,-1000),(609,0,19360,'wall008',100,1286.78,-1350.73,17,0,90.5,89.506,0,0,1286.76,-1352.94,6.81,-1000,-1000,-1000),(610,0,19360,'wall008',100,1286.8,-1347.89,17.155,0,90.5,89.506,0,0,1286.79,-1349.44,6.959,-1000,-1000,-1000),(611,0,19360,'wall008',100,1286.83,-1345.14,17.311,0,90.5,89.506,0,0,1286.82,-1345.94,7.108,-1000,-1000,-1000),(612,0,19360,'wall008',100,1288.22,-1344.53,17.436,0,90.5,89.506,0,0,1286.83,-1345.14,7.311,-1000,-1000,-1000),(619,0,2631,'Plain red carpet',250,1270.22,-1333.28,12.345,0,0,90.202,0,0,1270.22,-1333.28,2.345,-1000,-1000,-1000),(620,0,2631,'Plain red carpet',250,1270.24,-1337.63,12.345,0,0,90.202,0,0,1270.22,-1333.28,2.345,-1000,-1000,-1000),(621,0,2631,'Plain red carpet',250,1270.26,-1342.1,12.345,0,0,90.202,0,0,1270.24,-1337.63,2.345,-1000,-1000,-1000),(632,0,19439,'wall079',100,1285.13,-1345.13,17.716,90,-0.5,179.928,0,0,1284.99,-1358.67,6.686,-1000,-1000,-1000),(633,0,19439,'wall079',100,1285.1,-1348.63,17.556,90,-0.5,179.928,0,0,1285.13,-1345.13,7.716,-1000,-1000,-1000),(634,0,19439,'wall079',100,1285.07,-1352.13,17.396,90,-0.5,179.928,0,0,1285.09,-1348.63,7.556,-1000,-1000,-1000),(640,0,19360,'wall008',100,1286.85,-1341.64,17.428,0,90,90.006,0,0,1286.83,-1345.14,7.311,-1000,-1000,-1000),(648,0,19439,'wall079',100,1285.15,-1341.64,17.716,90,-0.0000000298,179.928,0,0,1285.13,-1345.13,7.716,-1000,-1000,-1000),(710,0,1349,'Shopping cart',50,1271.68,-1314.04,13.074,0,0,90.309,0,0,1271.68,-1314.04,3.074,-1000,-1000,-1000),(711,0,1349,'Shopping cart',50,1271.68,-1314.04,13.074,0,0,90.309,0,0,1271.68,-1314.04,3.074,-1000,-1000,-1000),(712,0,19439,'wall079',100,1285.02,-1358.6,17.076,90,-0.5,179.928,0,0,1285.04,-1355.63,7.236,-1000,-1000,-1000),(713,0,19439,'wall079',100,1285.04,-1355.63,17.236,90,-0.5,179.928,0,0,1285.07,-1352.13,7.396,-1000,-1000,-1000),(718,0,19452,'wall092',100,1291.98,-1334.65,17.78,0.1,90,90.023,0,0,1291.98,-1341.63,7.78,-1000,-1000,-1000),(719,0,19452,'wall092',100,1291.98,-1338.15,17.78,0.1,90,90.023,0,0,1291.98,-1334.65,7.78,-1000,-1000,-1000),(720,0,19452,'wall092',100,1291.98,-1341.65,17.78,0.1,90,90.023,0,0,1291.98,-1338.15,7.78,-1000,-1000,-1000),(721,0,19452,'wall092',100,1291.98,-1345.14,17.78,0.1,90,90.023,0,0,1291.98,-1341.65,7.78,-1000,-1000,-1000),(722,0,19452,'wall092',100,1291.98,-1331.15,17.78,0.1,90,90.023,0,0,1291.98,-1334.65,7.78,-1000,-1000,-1000),(724,0,19452,'wall092',100,1291.98,-1327.65,17.78,0.1,90,90.023,0,0,1291.98,-1331.15,7.78,-1000,-1000,-1000),(725,0,19452,'wall092',100,1291.98,-1324.15,17.78,0.1,90,90.023,0,0,1291.98,-1327.65,7.78,-1000,-1000,-1000),(726,0,19452,'wall092',100,1291.98,-1320.65,17.78,0.1,90,90.023,0,0,1291.98,-1324.15,7.78,-1000,-1000,-1000),(727,0,19452,'wall092',100,1291.98,-1317.15,17.78,0.1,90,90.023,0,0,1291.98,-1320.65,7.78,-1000,-1000,-1000),(728,0,19452,'wall092',100,1291.98,-1313.66,17.78,0.1,90,90.023,0,0,1291.98,-1317.15,7.78,-1000,-1000,-1000),(729,0,19452,'wall092',100,1291.98,-1310.16,17.78,0.1,90,90.023,0,0,1291.98,-1313.66,7.78,-1000,-1000,-1000),(730,0,19452,'wall092',100,1291.98,-1306.84,17.78,0.1,90,90.023,0,0,1291.98,-1310.16,7.78,-1000,-1000,-1000),(812,0,19360,'wall008',100,1286.85,-1334.64,17.428,0,90,90.006,0,0,1286.85,-1338.14,7.428,-1000,-1000,-1000),(813,0,19360,'wall008',100,1286.85,-1331.15,17.428,0,90,90.006,0,0,1286.85,-1334.64,7.428,-1000,-1000,-1000),(815,0,11727,'Round light',50,1287.17,-1326.72,14.793,0,0,-90.034,0,0,1287.17,-1326.72,4.793,-1000,-1000,-1000),(816,0,19360,'wall008',100,1286.85,-1324.15,17.428,0,90,90.006,0,0,1286.85,-1327.65,7.428,-1000,-1000,-1000),(817,0,19360,'wall008',100,1286.85,-1320.66,17.428,0,90,90.006,0,0,1286.85,-1324.15,7.428,-1000,-1000,-1000),(818,0,19360,'wall008',100,1286.85,-1317.17,17.428,0,90,90.006,0,0,1286.85,-1320.66,7.428,-1000,-1000,-1000),(819,0,19360,'wall008',100,1286.85,-1313.68,17.428,0,90,90.006,0,0,1286.85,-1317.17,7.428,-1000,-1000,-1000),(820,0,19360,'wall008',100,1286.85,-1310.18,17.428,0,90,90.006,0,0,1286.85,-1313.68,7.428,-1000,-1000,-1000),(821,0,19360,'wall008',100,1286.85,-1306.88,17.428,0,90,90.006,0,0,1286.85,-1310.18,7.428,-1000,-1000,-1000),(822,0,19439,'wall079',100,1285.15,-1338.14,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1341.64,7.716,-1000,-1000,-1000),(823,0,19439,'wall079',100,1285.15,-1334.64,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1338.14,7.716,-1000,-1000,-1000),(824,0,19439,'wall079',100,1285.15,-1331.15,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1334.64,7.716,-1000,-1000,-1000),(825,0,19439,'wall079',100,1285.15,-1327.65,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1331.15,7.716,-1000,-1000,-1000),(826,0,19439,'wall079',100,1285.15,-1324.16,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1327.65,7.716,-1000,-1000,-1000),(827,0,19439,'wall079',100,1285.15,-1320.66,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1324.16,7.716,-1000,-1000,-1000),(828,0,19439,'wall079',100,1285.16,-1317.16,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1320.66,7.716,-1000,-1000,-1000),(829,0,19439,'wall079',100,1285.16,-1313.67,17.716,90,-0.0000000298,179.928,0,0,1285.16,-1317.16,7.716,-1000,-1000,-1000),(830,0,19439,'wall079',100,1285.17,-1310.17,17.716,90,-0.0000000298,179.928,0,0,1285.16,-1313.67,7.716,-1000,-1000,-1000),(837,0,19439,'wall079',100,1285.18,-1306.87,17.716,90,-0.0000000298,179.928,0,0,1285.17,-1310.17,7.716,-1000,-1000,-1000),(838,0,19439,'wall079',100,1286.85,-1305.18,17.716,90,-89.2,179.928,0,0,1285.17,-1310.17,7.716,-1000,-1000,-1000),(842,0,19360,'wall008',100,1286.85,-1338.14,17.428,0,90,90.006,0,0,1286.85,-1334.64,7.428,-1000,-1000,-1000),(844,0,19360,'wall008',100,1288.47,-1343.78,17.558,0,90,90.006,0,0,1288.45,-1345.15,7.491,-1000,-1000,-1000),(845,0,19360,'wall008',100,1288.2,-1345.95,17.328,0,90.5,89.506,0,0,1288.21,-1345.15,7.441,-1000,-1000,-1000),(847,0,19360,'wall008',100,1288.44,-1345.49,17.404,0,90.5,89.506,0,0,1288.44,-1345.49,7.364,-1000,-1000,-1000),(850,0,19360,'wall008',100,1288.47,-1340.28,17.558,0,90,90.006,0,0,1288.47,-1343.78,7.558,-1000,-1000,-1000),(851,0,19360,'wall008',100,1288.47,-1336.78,17.558,0,90,90.006,0,0,1288.47,-1340.28,7.558,-1000,-1000,-1000),(852,0,19360,'wall008',100,1288.47,-1333.28,17.558,0,90,90.006,0,0,1288.47,-1336.78,7.558,-1000,-1000,-1000),(853,0,19360,'wall008',100,1288.47,-1333.28,17.558,0,90,90.006,0,0,1288.47,-1333.28,7.558,-1000,-1000,-1000),(854,0,19360,'wall008',100,1288.47,-1329.78,17.558,0,90,90.006,0,0,1288.47,-1333.28,7.558,-1000,-1000,-1000),(855,0,19360,'wall008',100,1288.23,-1327.87,17.778,0,90,90.006,0,0,1288.47,-1329.78,7.558,-1000,-1000,-1000),(857,0,19360,'wall008',100,1288.47,-1320.86,17.558,0,90,90.006,0,0,1288.47,-1322.78,7.558,-1000,-1000,-1000),(858,0,19360,'wall008',100,1288.47,-1317.36,17.558,0,90,90.006,0,0,1288.47,-1319.28,7.558,-1000,-1000,-1000),(859,0,19360,'wall008',100,1288.47,-1313.86,17.558,0,90,90.006,0,0,1288.47,-1315.78,7.558,-1000,-1000,-1000),(860,0,19360,'wall008',100,1288.47,-1310.36,17.558,0,90,90.006,0,0,1288.47,-1312.29,7.558,-1000,-1000,-1000),(861,0,19360,'wall008',100,1288.47,-1306.86,17.558,0,90,90.006,0,0,1288.47,-1308.79,7.558,-1000,-1000,-1000),(872,0,19394,'wall042',100,1291.44,-1329.72,19.623,0,0,-89.962,0,0,1295.42,-1307.78,9.863,-1000,-1000,-1000),(879,0,19411,'wall059',100,1288.23,-1329.72,19.622,0,0,90.001,0,0,1288.14,-1329.08,8.822,-1000,-1000,-1000),(927,0,19360,'wall008',100,1286.85,-1327.65,17.428,0,90,90.006,0,0,1286.85,-1327.65,7.428,-1000,-1000,-1000),(928,0,19360,'wall008',100,1288.23,-1321.74,17.778,0,90,90.006,0,0,1288.23,-1327.41,7.778,-1000,-1000,-1000),(929,0,19360,'wall008',100,1288.23,-1327.87,17.598,0,90,90.006,0,0,1288.23,-1327.41,7.778,-1000,-1000,-1000),(930,0,19360,'wall008',100,1288.23,-1321.74,17.598,0,90,90.006,0,0,1288.23,-1327.41,7.598,-1000,-1000,-1000),(931,0,19394,'wall042',100,1291.44,-1319.9,19.623,0,0,-89.962,0,0,1291.32,-1329.07,9.623,-1000,-1000,-1000),(932,0,19411,'wall059',100,1288.23,-1319.91,19.622,0,0,90.001,0,0,1288.23,-1329.07,9.622,-1000,-1000,-1000),(933,0,19411,'wall059',100,1286.71,-1328.03,19.622,0,0,0.0009901,0,0,1288.23,-1329.07,9.622,-1000,-1000,-1000),(934,0,19411,'wall059',100,1286.71,-1321.61,19.622,0,0,0.0009901,0,0,1286.71,-1327.38,9.622,-1000,-1000,-1000),(935,0,19411,'wall059',100,1286.71,-1324.82,19.622,0,0,0.0009901,0,0,1286.71,-1327.38,9.622,-1000,-1000,-1000),(957,0,19360,'wall008',100,1288.23,-1324.79,17.768,0,90,90.006,0,0,1288.23,-1321.74,7.778,-1000,-1000,-1000),(958,0,19360,'wall008',100,1288.23,-1324.79,17.598,0,90,90.006,0,0,1288.23,-1324.79,7.768,-1000,-1000,-1000),(959,0,19360,'wall008',100,1288.77,-1356.5,16.721,0,90.5,89.906,0,0,1286.73,-1356.48,6.691,-1000,-1000,-1000),(968,0,19365,'wall013',100,1292.95,-1328.02,19.629,0,0,-179.955,0,0,1292.99,-1327.85,9.619,-1000,-1000,-1000),(969,0,19365,'wall013',100,1292.95,-1324.81,19.629,0,0,-179.955,0,0,1292.99,-1328,9.629,-1000,-1000,-1000),(970,0,19365,'wall013',100,1292.95,-1321.6,19.629,0,0,-179.955,0,0,1292.99,-1324.79,9.629,-1000,-1000,-1000),(976,0,638,'Wide plant',250,1287.54,-1345.31,18.572,0,0,-179.978,0,0,1287.54,-1345.31,8.572,-1000,-1000,-1000),(977,0,638,'Wide plant',250,1287.56,-1342.29,18.514,0,0,179.915,0,0,1287.57,-1342.29,8.514,-1000,-1000,-1000),(979,0,638,'Wide plant',250,1287.56,-1339.28,18.514,0,0,179.915,0,0,1287.56,-1342.29,8.514,-1000,-1000,-1000),(980,0,638,'Wide plant',250,1287.56,-1336.23,18.514,0,0,179.915,0,0,1287.56,-1339.28,8.514,-1000,-1000,-1000),(982,0,638,'Wide plant',250,1288.54,-1334.05,18.518,0,-0.5,89.915,0,0,1287.56,-1336.23,8.514,-1000,-1000,-1000),(984,0,638,'Wide plant',250,1294.98,-1334.06,18.518,0,-0.5,89.915,0,0,1288.54,-1334.05,8.518,-1000,-1000,-1000),(986,0,2030,'Round stone table',500,1293.78,-1344.53,18.263,0,0,234.086,0,0,1293.78,-1344.53,8.263,-1000,-1000,-1000),(988,0,2030,'Round stone table',500,1290.1,-1340.05,18.263,0,0,234.086,0,0,1293.78,-1344.53,8.263,-1000,-1000,-1000),(989,0,2030,'Round stone table',500,1293.72,-1337.01,18.263,0,0,234.086,0,0,1290.1,-1340.05,8.263,-1000,-1000,-1000),(999,0,19439,'wall079',100,1285.15,-1327.65,17.716,90,-0.0000000298,179.928,0,0,1285.15,-1327.65,7.716,-1000,-1000,-1000),(1000,0,19357,'wall005',100,1288.38,-1321.6,20.994,0,-90.1,0.011,0,0,1288.55,-1324.83,10.994,-1000,-1000,-1000),(1003,0,19357,'wall005',100,1288.38,-1324.81,20.994,0,-90.1,0.011,0,0,1288.38,-1321.43,10.994,-1000,-1000,-1000),(1004,0,19357,'wall005',100,1288.38,-1328.02,20.994,0,-90.1,0.011,0,0,1288.38,-1324.64,10.994,-1000,-1000,-1000),(1005,0,19357,'wall005',100,1291.29,-1321.59,21.009,0,-90.1,0.011,0,0,1288.38,-1321.59,10.994,-1000,-1000,-1000),(1007,0,19357,'wall005',100,1291.29,-1324.8,21.009,0,-90.1,0.011,0,0,1291.29,-1321.59,11.009,-1000,-1000,-1000),(1008,0,19357,'wall005',100,1291.29,-1328.01,21.009,0,-90.1,0.011,0,0,1291.29,-1324.8,11.009,-1000,-1000,-1000),(1009,0,3802,'Window plant #1',200,1284.44,-1310.94,16.977,0,0,-179.218,0,0,1284.44,-1310.94,6.977,-1000,-1000,-1000);
/*!40000 ALTER TABLE `landobjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lands`
--

DROP TABLE IF EXISTS `lands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lands` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `price` int(10) DEFAULT '0',
  `min_x` float DEFAULT '0',
  `min_y` float DEFAULT '0',
  `max_x` float DEFAULT '0',
  `max_y` float DEFAULT '0',
  `heightx` float DEFAULT '0',
  `heighty` float NOT NULL DEFAULT '0',
  `level` tinyint(2) DEFAULT '1',
  `heightz` float NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lands`
--

LOCK TABLES `lands` WRITE;
/*!40000 ALTER TABLE `lands` DISABLE KEYS */;
INSERT INTO `lands` VALUES (0,69,'Heidi_Aukje_Grundel',9000000,1265.12,-1391.56,1325.53,-1285.35,1265.12,-1391.56,3,13.207,13);
/*!40000 ALTER TABLE `lands` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `locations` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `pos_x` float NOT NULL,
  `pos_y` float NOT NULL,
  `pos_z` float NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations`
--

LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_admin`
--

DROP TABLE IF EXISTS `log_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_admin` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_admin`
--

LOCK TABLES `log_admin` WRITE;
/*!40000 ALTER TABLE `log_admin` DISABLE KEYS */;
INSERT INTO `log_admin` VALUES (47,'2020-01-20 00:32:22','Cybernetic_Organism (uid: 68) has given Cybernetic_Organism (uid: 68) their own Freeway.'),(48,'2020-01-20 16:12:15','Nicolas_Joshua (uid: 74) has made Rafael_Martinez (uid: 73) a dynamic admin.'),(49,'2020-01-20 16:12:39','Nicolas_Joshua (uid: 74) has made tBKwtWS (uid: 68) a website developer.'),(50,'2020-01-20 16:12:56','Nicolas_Joshua (uid: 74) has made Rafael_Martinez (uid: 73) a developer.'),(51,'2020-01-20 16:13:02','Rafael_Martinez (uid: 73) has made tBKwtWS (uid: 68) a faction moderator.'),(52,'2020-01-20 16:13:07','Rafael_Martinez (uid: 73) has made tBKwtWS (uid: 68) a gang moderator.'),(53,'2020-01-20 16:13:12','Rafael_Martinez (uid: 73) has made tBKwtWS (uid: 68) a ban appealer.'),(54,'2020-01-20 16:13:20','Rafael_Martinez (uid: 73) has made tBKwtWS (uid: 68) admin perosnnel.');
/*!40000 ALTER TABLE `log_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_bans`
--

DROP TABLE IF EXISTS `log_bans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_bans` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_bans`
--

LOCK TABLES `log_bans` WRITE;
/*!40000 ALTER TABLE `log_bans` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_bans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_cheat`
--

DROP TABLE IF EXISTS `log_cheat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_cheat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_cheat`
--

LOCK TABLES `log_cheat` WRITE;
/*!40000 ALTER TABLE `log_cheat` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_cheat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_contracts`
--

DROP TABLE IF EXISTS `log_contracts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_contracts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_contracts`
--

LOCK TABLES `log_contracts` WRITE;
/*!40000 ALTER TABLE `log_contracts` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_contracts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_cp`
--

DROP TABLE IF EXISTS `log_cp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_cp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `executer` text,
  `description` text,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_cp`
--

LOCK TABLES `log_cp` WRITE;
/*!40000 ALTER TABLE `log_cp` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_cp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_dicebet`
--

DROP TABLE IF EXISTS `log_dicebet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_dicebet` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_dicebet`
--

LOCK TABLES `log_dicebet` WRITE;
/*!40000 ALTER TABLE `log_dicebet` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_dicebet` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_faction`
--

DROP TABLE IF EXISTS `log_faction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_faction` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_faction`
--

LOCK TABLES `log_faction` WRITE;
/*!40000 ALTER TABLE `log_faction` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_faction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_gang`
--

DROP TABLE IF EXISTS `log_gang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_gang` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_gang`
--

LOCK TABLES `log_gang` WRITE;
/*!40000 ALTER TABLE `log_gang` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_gang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_give`
--

DROP TABLE IF EXISTS `log_give`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_give` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_give`
--

LOCK TABLES `log_give` WRITE;
/*!40000 ALTER TABLE `log_give` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_give` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_givecookie`
--

DROP TABLE IF EXISTS `log_givecookie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_givecookie` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_givecookie`
--

LOCK TABLES `log_givecookie` WRITE;
/*!40000 ALTER TABLE `log_givecookie` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_givecookie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_givegun`
--

DROP TABLE IF EXISTS `log_givegun`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_givegun` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_givegun`
--

LOCK TABLES `log_givegun` WRITE;
/*!40000 ALTER TABLE `log_givegun` DISABLE KEYS */;
INSERT INTO `log_givegun` VALUES (47,'2020-01-20 04:20:07','Sebastian_Prince (uid: 72) gives a Sniper to Sebastian_Prince (uid: 72)'),(48,'2020-01-20 16:08:37','Nicolas_Joshua (uid: 74) gives a Sawn-off shotgun to Nicolas_Joshua (uid: 74)'),(49,'2020-01-20 16:08:39','Nicolas_Joshua (uid: 74) gives a Shotgun to Nicolas_Joshua (uid: 74)');
/*!40000 ALTER TABLE `log_givegun` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_givemoney`
--

DROP TABLE IF EXISTS `log_givemoney`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_givemoney` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_givemoney`
--

LOCK TABLES `log_givemoney` WRITE;
/*!40000 ALTER TABLE `log_givemoney` DISABLE KEYS */;
INSERT INTO `log_givemoney` VALUES (51,'2020-01-20 04:44:09','Rafael_Martinez (uid: 73) has used /givemoney to give $5000 to Rafael_Martinez (uid: 73).'),(52,'2020-01-20 08:15:40','Rafael_Martinez (uid: 73) has used /givemoney to give $666 to Rafael_Martinez (uid: 73).'),(53,'2020-01-20 08:15:41','Rafael_Martinez (uid: 73) has used /givemoney to give $666 to Rafael_Martinez (uid: 73).'),(54,'2020-01-20 08:15:42','Rafael_Martinez (uid: 73) has used /givemoney to give $666 to Rafael_Martinez (uid: 73).'),(55,'2020-01-20 08:15:46','Rafael_Martinez (uid: 73) has used /givemoney to give $66666 to Rafael_Martinez (uid: 73).'),(56,'2020-01-20 08:25:27','Stranger_25806 (uid: 73) has used /givemoney to give $99999999 to Stranger_25806 (uid: 73).');
/*!40000 ALTER TABLE `log_givemoney` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_makeadmin`
--

DROP TABLE IF EXISTS `log_makeadmin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_makeadmin` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_makeadmin`
--

LOCK TABLES `log_makeadmin` WRITE;
/*!40000 ALTER TABLE `log_makeadmin` DISABLE KEYS */;
INSERT INTO `log_makeadmin` VALUES (55,'2020-01-20 05:18:41','Rafael_Martinez (uid: 73) set Rafael_Martinez\'s (uid: 73) admin level to 9'),(56,'2020-01-20 14:29:25','Cybernetic_Organism (uid: 68) set Nicolas_Joshua\'s (uid: 74) admin level to 9'),(57,'2020-01-20 16:15:16','Rafael_Martinez (uid: 73) set Rafael_Martinez\'s (uid: 73) admin level to 9'),(58,'2020-01-20 16:15:38','Nicolas_Joshua (uid: 74) set Nicolas_Joshua\'s (uid: 74) admin level to 8');
/*!40000 ALTER TABLE `log_makeadmin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_makehelper`
--

DROP TABLE IF EXISTS `log_makehelper`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_makehelper` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_makehelper`
--

LOCK TABLES `log_makehelper` WRITE;
/*!40000 ALTER TABLE `log_makehelper` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_makehelper` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_namechanges`
--

DROP TABLE IF EXISTS `log_namechanges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_namechanges` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_namechanges`
--

LOCK TABLES `log_namechanges` WRITE;
/*!40000 ALTER TABLE `log_namechanges` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_namechanges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_namehistory`
--

DROP TABLE IF EXISTS `log_namehistory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_namehistory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `oldname` varchar(24) DEFAULT NULL,
  `newname` varchar(24) DEFAULT NULL,
  `changedby` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_namehistory`
--

LOCK TABLES `log_namehistory` WRITE;
/*!40000 ALTER TABLE `log_namehistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_namehistory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_property`
--

DROP TABLE IF EXISTS `log_property`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_property` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_property`
--

LOCK TABLES `log_property` WRITE;
/*!40000 ALTER TABLE `log_property` DISABLE KEYS */;
INSERT INTO `log_property` VALUES (52,'2020-01-20 04:44:12','Rafael_Martinez (uid: 73) purchased Room (id: 711) for $8000.'),(53,'2020-01-20 08:23:27','Stranger_25806 (uid: 73) purchased a Yosemite for $37500.'),(54,'2020-01-20 08:25:37','Stranger_25806 (uid: 73) purchased a Sparrow for $750000.'),(55,'2020-01-20 08:27:27','Stranger_25806 (uid: 73) purchased a Sparrow for $750000.');
/*!40000 ALTER TABLE `log_property` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_punishments`
--

DROP TABLE IF EXISTS `log_punishments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_punishments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_punishments`
--

LOCK TABLES `log_punishments` WRITE;
/*!40000 ALTER TABLE `log_punishments` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_punishments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_referrals`
--

DROP TABLE IF EXISTS `log_referrals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_referrals` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_referrals`
--

LOCK TABLES `log_referrals` WRITE;
/*!40000 ALTER TABLE `log_referrals` DISABLE KEYS */;
/*!40000 ALTER TABLE `log_referrals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_setstat`
--

DROP TABLE IF EXISTS `log_setstat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_setstat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_setstat`
--

LOCK TABLES `log_setstat` WRITE;
/*!40000 ALTER TABLE `log_setstat` DISABLE KEYS */;
INSERT INTO `log_setstat` VALUES (76,'2020-01-20 04:20:06','Sebastian_Prince (uid: 72) set Sebastian_Prince\'s (uid: 72) hours to 2'),(77,'2020-01-20 16:08:34','Nicolas_Joshua (uid: 74) set Nicolas_Joshua\'s (uid: 74) hours to 9555');
/*!40000 ALTER TABLE `log_setstat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_vip`
--

DROP TABLE IF EXISTS `log_vip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_vip` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_vip`
--

LOCK TABLES `log_vip` WRITE;
/*!40000 ALTER TABLE `log_vip` DISABLE KEYS */;
INSERT INTO `log_vip` VALUES (12,'2020-01-20 03:18:47','Sebastian_Prince (uid: 72) has given Sebastian_Prince (uid: 72) a Royal donator package for 1 days.'),(13,'2020-01-20 04:54:30','Rafael_Martinez (uid: 73) has given Rafael_Martinez (uid: 73) a Royal donator package for 1 days.');
/*!40000 ALTER TABLE `log_vip` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phonebook`
--

DROP TABLE IF EXISTS `phonebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phonebook` (
  `name` varchar(24) DEFAULT NULL,
  `number` int(10) DEFAULT NULL,
  UNIQUE KEY `number` (`number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phonebook`
--

LOCK TABLES `phonebook` WRITE;
/*!40000 ALTER TABLE `phonebook` DISABLE KEYS */;
/*!40000 ALTER TABLE `phonebook` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `playerbackpack`
--

DROP TABLE IF EXISTS `playerbackpack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `playerbackpack` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `BackpackOwner` int(11) NOT NULL DEFAULT '-1',
  `BackpackSize` int(11) NOT NULL DEFAULT '0',
  `HouseStored` int(11) NOT NULL DEFAULT '0',
  `VehicleStored` int(11) NOT NULL DEFAULT '0',
  `Cash` int(11) NOT NULL DEFAULT '0',
  `Crack` int(11) NOT NULL DEFAULT '0',
  `Pot` int(11) NOT NULL DEFAULT '0',
  `Mats` int(11) NOT NULL DEFAULT '0',
  `Gun0` int(11) NOT NULL DEFAULT '0',
  `Gun1` int(11) NOT NULL DEFAULT '0',
  `Gun2` int(11) NOT NULL DEFAULT '0',
  `Gun3` int(11) NOT NULL DEFAULT '0',
  `Gun4` int(11) NOT NULL DEFAULT '0',
  `Spraycans` int(11) NOT NULL DEFAULT '0',
  `Ropes` int(11) NOT NULL DEFAULT '0',
  `Skins` int(1) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `playerbackpack`
--

LOCK TABLES `playerbackpack` WRITE;
/*!40000 ALTER TABLE `playerbackpack` DISABLE KEYS */;
/*!40000 ALTER TABLE `playerbackpack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `points`
--

DROP TABLE IF EXISTS `points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `points` (
  `id` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `capturedby` varchar(24) DEFAULT 'No-one',
  `capturedgang` tinyint(2) DEFAULT '-1',
  `type` tinyint(2) DEFAULT '0',
  `profits` int(10) DEFAULT '0',
  `time` tinyint(2) DEFAULT '24',
  `point_x` float DEFAULT '0',
  `point_y` float DEFAULT '0',
  `point_z` float DEFAULT '0',
  `pointinterior` tinyint(2) DEFAULT '0',
  `pointworld` int(10) DEFAULT '0',
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `points`
--

LOCK TABLES `points` WRITE;
/*!40000 ALTER TABLE `points` DISABLE KEYS */;
/*!40000 ALTER TABLE `points` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts_acp`
--

DROP TABLE IF EXISTS `posts_acp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts_acp` (
  `title` varchar(64) NOT NULL,
  `date` date NOT NULL,
  `description` text NOT NULL,
  `postedby` varchar(24) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts_acp`
--

LOCK TABLES `posts_acp` WRITE;
/*!40000 ALTER TABLE `posts_acp` DISABLE KEYS */;
/*!40000 ALTER TABLE `posts_acp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shots`
--

DROP TABLE IF EXISTS `shots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shots` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `playerid` smallint(3) DEFAULT NULL,
  `weaponid` tinyint(2) DEFAULT NULL,
  `hittype` tinyint(2) DEFAULT NULL,
  `hitid` int(10) DEFAULT NULL,
  `hitplayer` varchar(24) DEFAULT NULL,
  `pos_x` float DEFAULT NULL,
  `pos_y` float DEFAULT NULL,
  `pos_z` float DEFAULT NULL,
  `timestamp` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shots`
--

LOCK TABLES `shots` WRITE;
/*!40000 ALTER TABLE `shots` DISABLE KEYS */;
/*!40000 ALTER TABLE `shots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `speedcameras`
--

DROP TABLE IF EXISTS `speedcameras`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `speedcameras` (
  `1` int(11) NOT NULL,
  `speedRange` int(11) NOT NULL,
  `speedLimit` int(11) NOT NULL,
  `speedObjects` int(11) NOT NULL,
  `speedID` int(11) NOT NULL,
  `speedX` int(11) NOT NULL,
  `speedY` int(11) NOT NULL,
  `speedZ` int(11) NOT NULL,
  `speedAngle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `speedcameras`
--

LOCK TABLES `speedcameras` WRITE;
/*!40000 ALTER TABLE `speedcameras` DISABLE KEYS */;
INSERT INTO `speedcameras` VALUES (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,0,0),(0,0,0,0,0,0,0,0,0),(0,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `speedcameras` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `texts`
--

DROP TABLE IF EXISTS `texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `texts` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sender_number` int(10) DEFAULT NULL,
  `recipient_number` int(10) DEFAULT NULL,
  `sender` varchar(24) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `texts`
--

LOCK TABLES `texts` WRITE;
/*!40000 ALTER TABLE `texts` DISABLE KEYS */;
/*!40000 ALTER TABLE `texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `turfs`
--

DROP TABLE IF EXISTS `turfs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turfs` (
  `id` tinyint(2) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `capturedby` varchar(24) DEFAULT 'No-one',
  `capturedgang` tinyint(2) DEFAULT '-1',
  `type` tinyint(2) DEFAULT '0',
  `time` tinyint(2) DEFAULT '12',
  `min_x` float DEFAULT '0',
  `min_y` float DEFAULT '0',
  `max_x` float DEFAULT '0',
  `max_y` float DEFAULT '0',
  `height` float DEFAULT '0',
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `turfs`
--

LOCK TABLES `turfs` WRITE;
/*!40000 ALTER TABLE `turfs` DISABLE KEYS */;
/*!40000 ALTER TABLE `turfs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `passwordchanged` tinyint(1) NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(24) DEFAULT NULL,
  `password` varchar(129) DEFAULT NULL,
  `regdate` datetime DEFAULT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `setup` tinyint(1) DEFAULT '1',
  `gender` tinyint(1) DEFAULT '0',
  `age` tinyint(3) DEFAULT '18',
  `skin` smallint(3) DEFAULT '299',
  `camera_x` float DEFAULT '0',
  `camera_y` float DEFAULT '0',
  `camera_z` float DEFAULT '0',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `cash` int(10) DEFAULT '5000',
  `bank` int(10) DEFAULT '10000',
  `paycheck` int(10) DEFAULT '0',
  `level` int(10) DEFAULT '1',
  `exp` int(10) DEFAULT '0',
  `minutes` tinyint(2) DEFAULT '0',
  `hours` int(10) DEFAULT '0',
  `adminlevel` int(10) DEFAULT '0',
  `adminname` varchar(24) DEFAULT 'None',
  `helperlevel` tinyint(2) DEFAULT '0',
  `health` float DEFAULT '100',
  `armor` float DEFAULT '0',
  `upgradepoints` int(10) DEFAULT '0',
  `warnings` tinyint(3) DEFAULT '0',
  `injured` tinyint(1) DEFAULT '0',
  `hospital` tinyint(1) DEFAULT '0',
  `spawnhealth` float DEFAULT '50',
  `spawnarmor` float DEFAULT '0',
  `jailtype` tinyint(1) DEFAULT '0',
  `jailtime` int(10) DEFAULT '0',
  `newbiemuted` tinyint(1) DEFAULT '0',
  `helpmuted` tinyint(1) DEFAULT '0',
  `admuted` tinyint(1) DEFAULT '0',
  `livemuted` tinyint(1) DEFAULT '0',
  `globalmuted` tinyint(1) DEFAULT '0',
  `reportmuted` tinyint(2) DEFAULT '0',
  `reportwarns` tinyint(2) DEFAULT '0',
  `fightstyle` tinyint(2) DEFAULT '4',
  `locked` tinyint(1) DEFAULT '0',
  `accent` varchar(16) DEFAULT 'None',
  `cookies` int(10) DEFAULT '0',
  `phone` int(10) DEFAULT '0',
  `job` int(10) DEFAULT '-1',
  `secondjob` tinyint(2) DEFAULT '-1',
  `crimes` int(10) DEFAULT '0',
  `arrested` int(10) DEFAULT '0',
  `wantedlevel` tinyint(2) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `seeds` int(10) DEFAULT '0',
  `ephedrine` int(10) DEFAULT '0',
  `muriaticacid` int(10) DEFAULT '0',
  `bakingsoda` int(10) DEFAULT '0',
  `cigars` int(10) DEFAULT '0',
  `walkietalkie` tinyint(1) DEFAULT '0',
  `channel` int(10) DEFAULT '0',
  `rentinghouse` int(10) DEFAULT '0',
  `spraycans` int(10) DEFAULT '0',
  `boombox` tinyint(1) DEFAULT '0',
  `mp3player` tinyint(1) DEFAULT '0',
  `phonebook` tinyint(1) DEFAULT '0',
  `fishingrod` tinyint(1) DEFAULT '0',
  `fishingbait` int(10) DEFAULT '0',
  `fishweight` int(10) DEFAULT '0',
  `components` int(10) DEFAULT '0',
  `courierskill` int(10) DEFAULT '0',
  `fishingskill` int(10) DEFAULT '0',
  `guardskill` int(10) DEFAULT '0',
  `weaponskill` int(10) DEFAULT '0',
  `mechanicskill` int(10) DEFAULT '0',
  `lawyerskill` int(10) DEFAULT '0',
  `detectiveskill` int(10) DEFAULT '0',
  `smugglerskill` int(10) DEFAULT '0',
  `toggletextdraws` tinyint(1) DEFAULT '0',
  `togglebug` tinyint(1) DEFAULT '0',
  `toggleooc` tinyint(1) DEFAULT '0',
  `togglephone` tinyint(1) DEFAULT '0',
  `toggleadmin` tinyint(1) DEFAULT '0',
  `togglehelper` tinyint(1) DEFAULT '0',
  `togglenewbie` tinyint(1) DEFAULT '0',
  `togglewt` tinyint(1) DEFAULT '0',
  `toggleradio` tinyint(1) DEFAULT '0',
  `togglevip` tinyint(1) DEFAULT '0',
  `togglemusic` tinyint(1) DEFAULT '0',
  `togglefaction` tinyint(1) DEFAULT '0',
  `togglegang` tinyint(1) DEFAULT '0',
  `togglenews` tinyint(1) DEFAULT '0',
  `toggleglobal` tinyint(1) DEFAULT '1',
  `togglecam` tinyint(1) DEFAULT '0',
  `carlicense` tinyint(1) DEFAULT '0',
  `vippackage` tinyint(2) DEFAULT '0',
  `viptime` int(10) DEFAULT '0',
  `vipcooldown` int(10) DEFAULT '0',
  `weapon_0` tinyint(2) DEFAULT '0',
  `weapon_1` tinyint(2) DEFAULT '0',
  `weapon_2` tinyint(2) DEFAULT '0',
  `weapon_3` tinyint(2) DEFAULT '0',
  `weapon_4` tinyint(2) DEFAULT '0',
  `weapon_5` tinyint(2) DEFAULT '0',
  `weapon_6` tinyint(2) DEFAULT '0',
  `weapon_7` tinyint(2) DEFAULT '0',
  `weapon_8` tinyint(2) DEFAULT '0',
  `weapon_9` tinyint(2) DEFAULT '0',
  `weapon_10` tinyint(2) DEFAULT '0',
  `weapon_11` tinyint(2) DEFAULT '0',
  `weapon_12` tinyint(2) DEFAULT '0',
  `ammo_0` smallint(5) DEFAULT '0',
  `ammo_1` smallint(5) DEFAULT '0',
  `ammo_2` smallint(5) DEFAULT '0',
  `ammo_3` smallint(5) DEFAULT '0',
  `ammo_4` smallint(5) DEFAULT '0',
  `ammo_5` smallint(5) DEFAULT '0',
  `ammo_6` smallint(5) DEFAULT '0',
  `ammo_7` smallint(5) DEFAULT '0',
  `ammo_8` smallint(5) DEFAULT '0',
  `ammo_9` smallint(5) DEFAULT '0',
  `ammo_10` smallint(5) DEFAULT '0',
  `ammo_11` smallint(5) DEFAULT '0',
  `ammo_12` smallint(5) DEFAULT '0',
  `faction` tinyint(2) DEFAULT '-1',
  `gang` tinyint(2) DEFAULT '-1',
  `factionrank` tinyint(2) DEFAULT '0',
  `gangrank` tinyint(2) DEFAULT '0',
  `division` tinyint(2) DEFAULT '-1',
  `contracted` int(10) DEFAULT '0',
  `contractby` varchar(24) DEFAULT 'Nobody',
  `bombs` int(10) DEFAULT '0',
  `completedhits` int(10) DEFAULT '0',
  `failedhits` int(10) DEFAULT '0',
  `reports` int(10) DEFAULT '0',
  `helprequests` int(10) DEFAULT '0',
  `speedometer` tinyint(1) DEFAULT '1',
  `factionmod` tinyint(1) DEFAULT '0',
  `gangmod` tinyint(1) DEFAULT '0',
  `banappealer` tinyint(1) DEFAULT '0',
  `helpermanager` tinyint(1) DEFAULT '0',
  `dynamicadmin` tinyint(1) DEFAULT '0',
  `adminpersonnel` tinyint(1) DEFAULT '0',
  `weedplanted` tinyint(1) DEFAULT '0',
  `weedtime` int(10) DEFAULT '0',
  `weedgrams` int(10) DEFAULT '0',
  `weed_x` float DEFAULT '0',
  `weed_y` float DEFAULT '0',
  `weed_z` float DEFAULT '0',
  `weed_a` float DEFAULT '0',
  `inventoryupgrade` int(10) DEFAULT '0',
  `addictupgrade` int(10) DEFAULT '0',
  `traderupgrade` int(10) DEFAULT '0',
  `assetupgrade` int(10) DEFAULT '0',
  `pistolammo` smallint(5) DEFAULT '0',
  `shotgunammo` smallint(5) DEFAULT '0',
  `smgammo` smallint(5) DEFAULT '0',
  `arammo` smallint(5) DEFAULT '0',
  `rifleammo` smallint(5) DEFAULT '0',
  `hpammo` smallint(5) DEFAULT '0',
  `poisonammo` smallint(5) DEFAULT '0',
  `fmjammo` smallint(5) DEFAULT '0',
  `ammotype` tinyint(2) DEFAULT '0',
  `ammoweapon` tinyint(2) DEFAULT '0',
  `dmwarnings` tinyint(2) DEFAULT '0',
  `weaponrestricted` int(10) DEFAULT '0',
  `referral_uid` int(10) DEFAULT '0',
  `refercount` int(10) DEFAULT '0',
  `watch` tinyint(1) DEFAULT '0',
  `gps` tinyint(1) DEFAULT '0',
  `prisonedby` varchar(24) DEFAULT 'No-one',
  `prisonreason` varchar(128) DEFAULT 'None',
  `togglehud` tinyint(1) DEFAULT '1',
  `clothes` smallint(3) DEFAULT '-1',
  `showturfs` tinyint(1) DEFAULT '0',
  `showlands` tinyint(1) DEFAULT '0',
  `watchon` tinyint(1) DEFAULT '0',
  `gpson` tinyint(1) DEFAULT '0',
  `doublexp` int(10) DEFAULT '0',
  `couriercooldown` int(10) DEFAULT '0',
  `pizzacooldown` int(10) DEFAULT '0',
  `detectivecooldown` int(10) DEFAULT '0',
  `gascan` tinyint(1) DEFAULT NULL,
  `duty` int(1) DEFAULT NULL,
  `bandana` tinyint(10) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `FormerAdmin` tinyint(3) NOT NULL DEFAULT '0',
  `customtitle` varchar(128) NOT NULL,
  `customcolor` int(10) NOT NULL DEFAULT '-256',
  `scanneron` tinyint(1) DEFAULT '0',
  `rimkits` int(10) DEFAULT '0',
  `bodykits` int(10) DEFAULT '0',
  `policescanner` tinyint(1) DEFAULT '0',
  `firstaid` int(10) DEFAULT '0',
  `extraSongs` int(11) NOT NULL DEFAULT '0',
  `top10` tinyint(1) NOT NULL DEFAULT '1',
  `totalfires` int(10) DEFAULT '0',
  `totalpatients` int(10) DEFAULT '0',
  `money_earned` bigint(20) DEFAULT '0',
  `money_spent` bigint(20) DEFAULT '0',
  `rope` int(10) DEFAULT '0',
  `insurance` tinyint(1) DEFAULT '0',
  `adminhide` tinyint(1) DEFAULT '0',
  `passportphone` int(10) DEFAULT '0',
  `passportskin` smallint(3) DEFAULT '0',
  `passportlevel` int(10) DEFAULT '0',
  `passportname` varchar(24) DEFAULT 'None',
  `passport` tinyint(1) DEFAULT '0',
  `globalmutetime` int(10) DEFAULT '0',
  `reportmutetime` int(10) DEFAULT '0',
  `newbiemutetime` int(10) DEFAULT '0',
  `togglereports` tinyint(1) DEFAULT '0',
  `thiefcooldown` int(10) DEFAULT '0',
  `crackcooldown` int(10) DEFAULT '0',
  `laborupgrade` int(10) DEFAULT '0',
  `scripter` tinyint(1) DEFAULT '0',
  `factionleader` tinyint(1) DEFAULT '0',
  `thiefskill` int(10) DEFAULT '0',
  `togglewhisper` tinyint(1) DEFAULT '0',
  `landkeys` tinyint(3) NOT NULL DEFAULT '-1',
  `rarecooldown` int(8) DEFAULT '0',
  `diamonds` smallint(5) DEFAULT '0',
  `bugged` tinyint(1) DEFAULT '0',
  `gameaffairs` tinyint(1) DEFAULT '0',
  `crew` tinyint(2) DEFAULT '-1',
  `newbies` mediumint(5) DEFAULT '0',
  `rollerskates` tinyint(2) DEFAULT '0',
  `marriedto` int(10) DEFAULT '-1',
  `humanresources` tinyint(1) DEFAULT '0',
  `complaintmod` tinyint(1) DEFAULT '0',
  `webdev` tinyint(1) DEFAULT '0',
  `graphic` tinyint(1) DEFAULT '0',
  `vehlock` tinyint(1) DEFAULT '0',
  `sprunk` int(10) DEFAULT '0',
  `truckinglevel` int(10) DEFAULT '0',
  `truckingxp` int(10) DEFAULT '0',
  `santagifts` int(10) DEFAULT '0',
  `seckey` int(11) unsigned NOT NULL,
  `togglepoint` tinyint(4) NOT NULL DEFAULT '0',
  `togglepm` tinyint(1) DEFAULT '0',
  `toggleturfs` tinyint(1) DEFAULT '0',
  `togglepoints` tinyint(1) DEFAULT '0',
  `tuckinglevel` int(10) NOT NULL DEFAULT '1',
  `notoriety` int(11) DEFAULT '0',
  `gunlicense` int(11) NOT NULL DEFAULT '0',
  `togglevehicle` tinyint(1) NOT NULL DEFAULT '0',
  `hunger` int(10) NOT NULL DEFAULT '100',
  `thirst` int(10) NOT NULL DEFAULT '100',
  `mask` int(10) DEFAULT '0',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,68,'Cybernetic_Organism','DF3210C97BB5895B32A09C3CD9A905248FD2F34720711152C92EE6D1828E3122B0844C565536C5214B5F2C137FF638BD86F03EBC412DDDDD4018F968819BEEC0','2020-01-19 23:50:45','2020-01-20 19:06:36','86.83.121.29',0,1,99,248,-73.693,1179.96,20.383,-72.145,1183.1,19.742,90,0,0,3525,10000,0,1,0,63,0,99,'tBKwtWS',0,100,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,198408220,5,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,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,0,1,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,0,0,0,0,0,0,-1,-1,0,0,-1,0,'Nobody',0,0,0,0,0,1,1,1,1,0,0,1,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,0,1,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'DevOps',-256,0,0,0,0,0,0,1,0,0,0,1475,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,82,75,NULL),(1,69,'Heidi_Aukje_Grundel','DF3210C97BB5895B32A09C3CD9A905248FD2F34720711152C92EE6D1828E3122B0844C565536C5214B5F2C137FF638BD86F03EBC412DDDDD4018F968819BEEC0','2020-01-19 23:51:41','2020-01-20 06:02:57','127.43.141.29',0,2,23,150,-105.564,1100.16,20.681,-99.864,1100.05,19.159,272.917,0,0,4673,11966,0,1,3,3,3,7,'Violent Violet',0,85.005,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,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,0,0,0,0,0,0,-1,-1,0,0,-1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,0,0,0,0,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,327,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,71,64,NULL),(1,71,'Sam_Alderman','7FB993563A5021ECAB5BBE2CB54F563B40A15EF8A53D26DC11DD8B911CB3BF423E41FA43E20902F990A73A308168BFD4C68785842E9A967D2ECA8BF11C254A9D','2020-01-20 02:33:02','2020-01-20 04:07:44','92.238.234.77',0,2,31,216,-181.196,1136.21,20.508,-181.196,1132.89,19.742,90,0,0,5000,41310,0,1,2,39,2,2,'None',0,97.891,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,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,0,0,0,0,0,0,0,-1,8,0,1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,72,0,0,0,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,67,61,0),(1,72,'Sebastian_Prince','D9F0D392FAD348BE1BE4724BF42D74A01AF2E3B4D0198A2EE266D8C22DE3067E432B59002EA472FF5B14E4DA733A056AEACFFB7F14653ADE0542B19053F03B87','2020-01-20 02:33:20','2020-01-20 17:19:05','209.33.119.159',0,1,25,59,-162.624,1207.72,21.316,-160.389,1208.19,19.742,282.096,0,0,5000,68666,0,1,2,30,3,8,'None',0,95.05,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,3,1579573127,0,0,0,0,0,0,0,34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,8,0,-1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,0,0,0,0,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,1,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,72,61,0),(1,73,'Rafael_Martinez','A4E4DA1EE33498F43A3A4FC2C85E502031D0FF8EFB81F35730F8D7B41537B3D7BCB49AC61372E2C6FF370472738F0FD212EF606542707F62051F1233048A70DF','2020-01-20 04:11:07','2020-01-20 15:36:30','197.25.201.104',0,1,28,299,-84.093,1223.65,21.84,-90.431,1220.77,19.396,350.325,0,0,98529308,12183,0,1,3,1,3,9,'None',0,12.14,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,3,1579578870,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,0,0,0,-1,6,0,-1,0,'Nobody',0,0,0,0,0,1,0,0,0,0,1,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,0,0,1,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'noob',0,0,0,0,0,0,0,1,0,0,100073663,1549355,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,1,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,39,23,1),(1,74,'Nicolas_Joshua','4E0658D00F47D86D19A0E792E4BB94B16DB2E902D307DA5637F57CF60E7A174CB4BB6D7095621745B2065DF0C87B77AF69F5D0FBD63359AD3CC6B72F076C3E1E','2020-01-20 14:27:54','2020-01-20 17:53:56','156.212.102.134',0,1,24,7,-0.018,1524.63,1482.09,-3.097,1524.67,1457.48,259.4,0,4,4600,10000,0,1,0,24,9555,8,'None',0,95.05,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,24,25,0,31,34,0,0,0,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,-1,0,0,-1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,0,0,0,0,'No-one','None',1,-1,0,1,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,400,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,96,95,1),(1,75,'Michael_Joshua','A95C11ACF740AD97393AF4FE6DEC5B1163B4F46D55045AC43BC0B75C42D8E0D6384943BBE6155BBC126CC3731D11F5F5C220A7E868F21A36FA176F8A2726F714','2020-01-20 17:02:28','2020-01-20 17:02:28','41.107.241.190',0,1,23,171,-174.473,1107.29,22.223,-174.438,1107.94,19.742,176.99,0,0,5000,10000,0,1,0,7,0,0,'None',0,90.1,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,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,0,0,0,0,0,0,-1,-1,0,0,-1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,0,0,0,0,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,90,87,0),(1,76,'Jason_Rezar','7CB56D946458B0E9DED44CFF909DA333070C1B139CEBB804D8AA9DF762D45207D0FBAFC4FCCFB1124F0530305C2DE2894999C4E3584BA161895E9167F6B839BC','2020-01-20 18:27:18','2020-01-20 18:27:18','5.206.232.254',0,1,19,299,-300.71,1058.43,21.082,-304.012,1055.95,19.734,70.814,0,0,5000,10000,0,1,0,4,0,0,'None',0,100,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,0,4,0,'None',0,0,-1,-1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,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,0,0,0,0,0,0,-1,-1,0,0,-1,0,'Nobody',0,0,0,0,0,1,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,0,0,0,0,0,0,0,0,'No-one','None',1,-1,0,0,0,0,0,0,0,0,NULL,0,0,NULL,0,'',-256,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,'None',0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,99,100,0);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicles`
--

DROP TABLE IF EXISTS `vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ownerid` int(10) DEFAULT '0',
  `owner` varchar(24) DEFAULT 'Nobody',
  `modelid` smallint(3) DEFAULT '0',
  `price` int(10) DEFAULT '0',
  `tickets` int(10) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `plate` varchar(32) DEFAULT 'None',
  `fuel` tinyint(3) DEFAULT '100',
  `health` float DEFAULT '1000',
  `pos_x` float DEFAULT '0',
  `pos_y` float DEFAULT '0',
  `pos_z` float DEFAULT '0',
  `pos_a` float DEFAULT '0',
  `color1` smallint(3) DEFAULT '0',
  `color2` smallint(3) DEFAULT '0',
  `paintjob` tinyint(2) DEFAULT '-1',
  `interior` tinyint(2) DEFAULT '0',
  `world` int(10) DEFAULT '0',
  `neon` smallint(5) DEFAULT '0',
  `neonenabled` tinyint(1) DEFAULT '0',
  `trunk` tinyint(1) DEFAULT '0',
  `mod_1` smallint(4) DEFAULT '0',
  `mod_2` smallint(4) DEFAULT '0',
  `mod_3` smallint(4) DEFAULT '0',
  `mod_4` smallint(4) DEFAULT '0',
  `mod_5` smallint(4) DEFAULT '0',
  `mod_6` smallint(4) DEFAULT '0',
  `mod_7` smallint(4) DEFAULT '0',
  `mod_8` smallint(4) DEFAULT '0',
  `mod_9` smallint(4) DEFAULT '0',
  `mod_10` smallint(4) DEFAULT '0',
  `mod_11` smallint(4) DEFAULT '0',
  `mod_12` smallint(4) DEFAULT '0',
  `mod_13` smallint(4) DEFAULT '0',
  `mod_14` smallint(4) DEFAULT '0',
  `cash` int(10) DEFAULT '0',
  `materials` int(10) DEFAULT '0',
  `weed` int(10) DEFAULT '0',
  `cocaine` int(10) DEFAULT '0',
  `meth` int(10) DEFAULT '0',
  `painkillers` int(10) DEFAULT '0',
  `weapon_1` tinyint(2) DEFAULT '0',
  `weapon_2` tinyint(2) DEFAULT '0',
  `weapon_3` tinyint(2) DEFAULT '0',
  `ammo_1` smallint(5) DEFAULT '0',
  `ammo_2` smallint(5) DEFAULT '0',
  `ammo_3` smallint(5) DEFAULT '0',
  `gangid` tinyint(2) DEFAULT '-1',
  `factiontype` tinyint(2) DEFAULT '0',
  `vippackage` tinyint(2) NOT NULL DEFAULT '0',
  `job` tinyint(2) DEFAULT '-1',
  `respawndelay` int(10) DEFAULT '0',
  `pistolammo` smallint(5) DEFAULT '0',
  `shotgunammo` smallint(5) DEFAULT '0',
  `smgammo` smallint(5) DEFAULT '0',
  `arammo` smallint(5) DEFAULT '0',
  `rifleammo` smallint(5) DEFAULT '0',
  `hpammo` smallint(5) DEFAULT '0',
  `poisonammo` smallint(5) DEFAULT '0',
  `fmjammo` smallint(5) DEFAULT '0',
  `alarm` tinyint(2) NOT NULL DEFAULT '0',
  `weapon_4` tinyint(2) NOT NULL DEFAULT '0',
  `weapon_5` tinyint(2) NOT NULL DEFAULT '0',
  `siren` tinyint(2) DEFAULT '0',
  `rank` tinyint(3) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicles`
--

LOCK TABLES `vehicles` WRITE;
/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
INSERT INTO `vehicles` VALUES (1,0,'Nobody',597,0,0,0,'None',100,1000,-210.213,999.939,19.432,88.845,123,1,-1,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,0,0,0,0,0,0,-1,1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(2,0,'Nobody',597,0,0,0,'None',100,1000,-210.437,995.866,19.354,91.259,123,1,-1,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,0,0,0,0,0,0,-1,1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(10,0,'Nobody',416,0,0,0,'None',100,1000,-304.298,1007.51,19.708,270.218,-1,-1,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(11,0,'Nobody',416,0,0,0,'None',100,1000,-304.04,1011.97,19.707,269.242,-1,-1,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(12,0,'Nobody',407,0,0,0,'None',100,1000,-304.628,1015.93,19.844,267.762,-1,-1,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(13,0,'Nobody',407,0,0,0,'None',100,1000,-304.485,1019.98,19.829,270.112,-1,-1,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(14,0,'Nobody',490,0,0,0,'None',100,1000,-304.737,1023.64,19.722,271.161,1,3,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(15,0,'Nobody',490,0,0,0,'None',100,1000,-304.691,1027.97,19.728,271.921,1,3,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(16,0,'Nobody',426,0,0,0,'None',100,1000,-304.343,1032.65,19.375,271.521,3,3,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(17,0,'Nobody',426,0,0,0,'None',100,1000,-304.563,1036.22,19.382,268.538,3,3,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(18,0,'Nobody',582,0,0,0,'None',100,1000,-77.095,1077.28,19.797,0.85,106,1,-1,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,0,0,0,0,0,0,-1,3,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(19,0,'Nobody',582,0,0,0,'None',100,1000,-80.522,1076.96,19.798,359.192,106,1,-1,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,0,0,0,0,0,0,-1,3,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(20,0,'Nobody',582,0,0,0,'None',100,1000,-83.966,1077.08,19.799,0.108,106,1,-1,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,0,0,0,0,0,0,-1,3,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(21,0,'Nobody',582,0,0,0,'None',100,1000,-87.274,1076.47,19.839,0.26,106,1,-1,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,0,0,0,0,0,0,-1,3,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(24,0,'Nobody',420,0,0,0,'None',100,1000,-243.421,2609.01,62.481,179.05,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(25,0,'Nobody',420,0,0,0,'None',100,1000,-240.407,2608.8,62.473,177.823,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(26,0,'Nobody',420,0,0,0,'None',100,1000,-237.382,2608.83,62.474,178.753,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(27,0,'Nobody',420,0,0,0,'None',100,1000,-234.56,2608.67,62.473,174.762,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(28,0,'Nobody',420,0,0,0,'None',100,1000,-243.623,2595.49,62.482,359.71,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(29,0,'Nobody',563,0,0,0,'None',100,1000,-333.654,1050.62,26.74,358.688,3,3,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(30,0,'Nobody',487,0,0,0,'None',100,1000,-306.001,1046.69,26.262,357.093,3,1,-1,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,0,0,0,0,0,0,-1,2,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(34,68,'Cybernetic_Organism',463,0,0,0,'None',94,964.858,-119.644,1250.52,17.365,7.693,0,0,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(35,0,'Nobody',598,0,0,0,'None',100,1000,-1398.91,2650.34,55.263,89.699,-1,-1,-1,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,0,0,0,0,0,0,-1,1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,1,0),(36,0,'Nobody',599,0,0,0,'None',100,1000,-1398.97,2643.91,55.67,89.538,-1,-1,-1,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,0,0,0,0,0,0,-1,1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(41,0,'Nobody',427,0,0,0,'None',100,1000,951.355,1752.04,8.895,270.579,-1,-1,-1,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,0,0,0,0,0,0,-1,1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(42,0,'Nobody',427,0,0,0,'None',100,1000,951.291,1756.86,8.895,270.798,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(43,0,'Nobody',490,0,0,0,'None',100,1000,951.02,1748.6,8.598,270.056,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(44,0,'Nobody',528,0,0,0,'None',100,1000,950.752,1742.99,8.693,270.549,-1,-1,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(45,73,'Stranger_25806',554,37500,0,0,'None',100,1000,524.186,2356.02,30.565,155.401,0,0,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(46,73,'Stranger_25806',469,750000,0,0,'None',100,1000,390.723,2538.68,16.543,179.275,0,0,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(47,73,'Stranger_25806',469,750000,0,0,'None',100,1000,349.708,2542.38,16.741,175.248,0,0,-1,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,0,0,0,0,0,0,-1,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weapons`
--

DROP TABLE IF EXISTS `weapons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `weapons` (
  `uid` int(10) DEFAULT NULL,
  `slot` tinyint(2) DEFAULT NULL,
  `weaponid` tinyint(2) DEFAULT NULL,
  `ammo` smallint(5) DEFAULT NULL,
  UNIQUE KEY `uid` (`uid`,`slot`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weapons`
--

LOCK TABLES `weapons` WRITE;
/*!40000 ALTER TABLE `weapons` DISABLE KEYS */;
/*!40000 ALTER TABLE `weapons` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-01-20 19:08:29