/*
Navicat MySQL Data Transfer

Source Server         : Virtual-Reallife local
Source Server Version : 50141
Source Host           : localhost:3306
Source Database       : samp_db

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

Date: 2012-06-19 19:52:42
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `houses`
-- ----------------------------
DROP TABLE IF EXISTS `houses`;
CREATE TABLE `houses` (
  `ID` int(11) NOT NULL,
  `EnterX` float NOT NULL,
  `EnterY` float NOT NULL,
  `EnterZ` float NOT NULL,
  `ExitX` float NOT NULL,
  `ExitY` float NOT NULL,
  `ExitZ` float NOT NULL,
  `Besitzer` varchar(24) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Preis` int(11) NOT NULL,
  `Mieten` int(11) NOT NULL,
  `Lock` int(11) NOT NULL,
  `MietPreis` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of houses
-- ----------------------------
INSERT INTO `houses` VALUES ('1', '0', '0', '5', '0', '0', '5', 'Niemand', 'Test-Haus', '5000', '0', '1', '500');
INSERT INTO `houses` VALUES ('2', '0', '0', '7', '0', '0', '5', 'Ap0llinaris', 'Test-Haus 2', '6000', '0', '1', '800');