-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: dbs_housesystem
-- ------------------------------------------------------
-- Server version	5.5.16

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 `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(6) NOT NULL AUTO_INCREMENT,
  `X` float DEFAULT NULL,
  `Y` float DEFAULT NULL,
  `Z` float DEFAULT NULL,
  `INTERIOR` int(10) DEFAULT NULL,
  `INTX` float DEFAULT NULL,
  `INTY` float DEFAULT NULL,
  `INTZ` float DEFAULT NULL,
  `MONEY` int(20) DEFAULT '0',
  `WEAP1` varchar(45) DEFAULT '0',
  `WEAP2` varchar(45) DEFAULT '0',
  `WEAP3` varchar(45) DEFAULT '0',
  `LOCKED` int(2) DEFAULT '0',
  `PRICE` int(10) DEFAULT '0',
  `OWNER` varchar(32) DEFAULT 'no-one',
  `RENTABLE` int(2) DEFAULT '0',
  `RENTALPRICE` int(10) DEFAULT '0',
  `RENT1` varchar(32) DEFAULT 'no-one',
  `RENT2` varchar(32) DEFAULT 'no-one',
  `RENT3` varchar(32) DEFAULT 'no-one',
  `RENT4` varchar(32) DEFAULT 'no-one',
  `RENT5` varchar(32) DEFAULT 'no-one',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=latin1;
/*!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 (2,2486.47,-1645.59,14.0772,8,2365.22,-1135.56,1050.88,66494,'17, 180','27, 540','30, 180',1,125000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(4,2498.38,-1643.09,13.7826,11,2282.94,-1140.12,1050.9,0,'0','0','0',1,47500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(5,2513.08,-1650.87,14.0938,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,45000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(6,980.46,-677.281,121.976,5,140.18,1366.72,1083.86,0,'0','0','0',0,225000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(7,1045.12,-642.39,120.117,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,125000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(8,1095.13,-647.346,113.648,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,225000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(9,808.783,-759.234,76.5314,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,205000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(10,785.892,-828.174,70.2896,1,223.054,1287.36,1082.14,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(11,300.233,-1154.44,81.3911,4,-261.038,1456.65,1084.37,0,'0','0','0',0,245000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(12,251.43,-1220.36,76.1024,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,240000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(13,253.173,-1270.03,74.4308,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,221000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(14,219.673,-1250.49,78.3328,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,180000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(15,167.897,-1308.19,70.3513,5,140.18,1366.72,1083.86,0,'0','0','0',0,245000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(16,228.195,-1405.22,51.6094,6,2333.07,-1077.06,1049.02,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(17,255.072,-1366.74,53.1094,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,123000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(18,416.467,-1154.38,76.6876,4,-261.038,1456.65,1084.37,0,'0','0','0',0,165500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(19,497.614,-1094.54,82.3592,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,125000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(20,558.771,-1075.89,72.922,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,132500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(21,612.063,-1085.83,58.8267,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,115000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(22,647.873,-1058.18,52.5799,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,90500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(23,699.845,-1060.17,49.4217,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,145000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(24,672.378,-1019.64,55.7596,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,90000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(25,731.14,-1013.05,52.7379,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,125000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(26,836.44,-894.26,68.7689,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,110000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(27,827.944,-858.348,70.3308,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,145000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(28,937.697,-848.106,93.6664,4,261.05,1284.76,1080.26,0,'0','0','0',0,80000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(29,977.403,-771.047,112.203,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,135500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(30,1111.99,-742.21,100.133,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,165000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(31,1093.8,-806.798,107.42,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,225500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(32,1298.6,-798.762,84.1406,5,1261.12,-785.38,1091.91,0,'0','0','0',0,1550000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(33,1331.81,-632.511,109.135,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,265000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(34,1442.49,-629.62,95.7186,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,185000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(35,1496.98,-688.24,95.5083,5,140.18,1366.72,1083.86,0,'0','0','0',0,295000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(36,1527.21,-773.11,80.5781,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,185000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(37,1534.84,-800.023,72.8495,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(38,1539.75,-851.328,64.3361,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,175000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(39,1468.47,-905.51,54.8359,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,165000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(40,1421.87,-885.607,50.6635,4,261.05,1284.76,1080.26,0,'0','0','0',0,145000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(41,1284.43,-1067.32,31.6719,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,195000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(42,1284.84,-1090.22,28.2578,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,195000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(43,1242.74,-1099.44,27.9766,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,195000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(44,1242.62,-1076.42,31.5547,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,195000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(45,1183.47,-1099.1,28.2578,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,212500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(46,1142.12,-1092.87,28.1875,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,212000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(47,1142.31,-1070.07,31.7656,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,213000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(48,1182.92,-1076.14,31.6719,6,2196.71,-1204.36,1049.02,0,'0','0','0',0,210000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(49,1103.16,-1092.36,28.4688,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,195000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(50,1103.03,-1069.32,31.8899,9,83.037,1322.62,1083.87,0,'0','0','0',0,198000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(51,1127.9,-1022.58,34.9922,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,220000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(52,1118.04,-1022.4,34.9922,8,2365.22,-1135.56,1050.88,0,'0','0','0',0,221000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(53,652.521,-1619.94,15,4,261.05,1284.76,1080.26,0,'0','0','0',0,156000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(54,656.066,-1636.17,15.8617,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,165000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(55,657.228,-1652.55,15.4062,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,156000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(56,652.396,-1693.97,14.5592,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,161000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(57,653.591,-1713.95,14.7648,10,2270.08,-1210.49,1047.56,0,'0','0','0',0,165410,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(58,693.545,-1705.79,3.81948,4,261.05,1284.76,1080.26,0,'0','0','0',0,135000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(59,694.915,-1690.49,4.34612,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,125000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(60,693.757,-1645.86,4.09375,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(61,697.281,-1627.02,3.74917,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(62,692.834,-1602.77,15.0469,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,65000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(63,660.46,-1599.42,15,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,79000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(64,766.923,-1605.88,13.8039,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,78000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(65,768.08,-1655.74,5.60938,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,97000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(66,769.227,-1696.64,5.15542,4,261.05,1284.76,1080.26,0,'0','0','0',0,98000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(67,769.07,-1726.8,13.4321,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(68,769.228,-1745.84,13.0773,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,78000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(69,791.384,-1754.09,13.4394,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,78000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(70,797.937,-1729.38,13.5469,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(71,793.979,-1707.61,14.0382,5,2233.66,-1114.98,1050.88,0,'0','0','0',0,50000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(72,794.85,-1691.76,14.4633,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,54000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(73,790.812,-1661.6,13.484,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(74,1980.83,-1718.99,17.0304,9,2317.76,-1026.43,1050.22,0,'0','0','0',0,165000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(75,1980.99,-1682.81,17.0537,9,83.037,1322.62,1083.87,0,'0','0','0',0,147000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(76,2017.79,-1629.82,13.7121,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,79000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(77,2016.44,-1641.7,14.1129,5,2233.66,-1114.98,1050.88,0,'0','0','0',0,56000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(78,2013.58,-1656.45,14.1363,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,80000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(79,2017.39,-1703.23,14.2344,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,78000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(80,2016.2,-1716.88,14.125,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(81,2015.35,-1732.63,14.2344,5,2233.66,-1114.98,1050.88,0,'0','0','0',0,56000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(82,2067.39,-1731.6,13.8762,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,56000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(83,2066.6,-1717.04,13.8058,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(84,2065.85,-1703.44,14.1484,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,98000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(85,2066.78,-1656.53,14.1328,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,78000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(86,2067.56,-1643.82,14.1363,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,68000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(87,2067.75,-1628.87,14.2066,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,68700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(88,2244.28,-1638.07,15.9074,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,76800,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(89,2257.1,-1644.18,15.5234,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,68700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(90,2282.28,-1641.22,15.8898,1,223.054,1287.36,1082.14,0,'0','0','0',0,65400,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(91,2306.86,-1679.13,14.3316,1,223.054,1287.36,1082.14,0,'0','0','0',0,75000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(92,2327.24,-1682.01,14.9297,1,2217.77,-1076.21,1050.48,0,'0','0','0',0,65400,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(93,2326.76,-1716.96,13.9074,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,69700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(94,2308.9,-1714.38,14.9801,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,13500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(95,2368.32,-1675.35,14.1682,6,2308.76,-1212.55,1049.02,0,'0','0','0',0,68700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(96,2393.07,-1646.04,13.9051,4,261.05,1284.76,1080.26,0,'0','0','0',0,98700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(97,2409.03,-1674.53,14.2141,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,97850,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(98,2413.86,-1647.08,14.0119,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,89700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(99,2451.98,-1641.41,14.0662,6,-68.8399,1351.48,1080.21,0,'0','0','0',0,78900,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(100,2459.53,-1691.66,13.5446,8,-42.6093,1405.8,1084.43,0,'0','0','0',0,78500,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(101,2402.46,-1715.48,14.1328,6,-68.8399,1351.48,1080.21,0,'0','0','0',0,67800,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(102,2385.37,-1712.34,14.2422,6,2333.07,-1077.06,1049.02,0,'0','0','0',0,68700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(103,2514.31,-1691.62,14.046,4,261.05,1284.76,1080.26,0,'0','0','0',0,87600,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(104,2495.39,-1691.06,14.7656,3,2495.98,-1692.42,1014.74,0,'0','0','0',0,165000,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(105,2524.58,-1658.54,15.824,8,-42.6093,1405.8,1084.43,0,'0','0','0',0,69800,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(106,2523.16,-1679.36,15.497,2,2237.5,-1080.94,1049.02,0,'0','0','0',0,98700,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one'),(107,2469.42,-1646.38,13.7801,11,2282.94,-1140.12,1050.9,0,'0','0','0',0,75800,'no-one',0,0,'no-one','no-one','no-one','no-one','no-one');
/*!40000 ALTER TABLE `houses` 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 2012-07-17 18:13:21