/*
Navicat MySQL Data Transfer

Source Server         : javaee
Source Server Version : 50625
Source Host           : localhost:3306
Source Database       : myzf

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

Date: 2015-07-21 23:05:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for district
-- ----------------------------
DROP TABLE IF EXISTS `district`;
CREATE TABLE `district` (
  `district_name` varchar(50) DEFAULT NULL,
  `district_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`district_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of district
-- ----------------------------

-- ----------------------------
-- Table structure for houseinfo
-- ----------------------------
DROP TABLE IF EXISTS `houseinfo`;
CREATE TABLE `houseinfo` (
  `user_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `street_id` int(11) DEFAULT NULL,
  `room` int(11) DEFAULT NULL,
  `hall` int(11) DEFAULT NULL,
  `remark` varchar(2000) DEFAULT NULL,
  `price` float(8,2) DEFAULT NULL,
  `title` varchar(70) NOT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `contract_man` varchar(50) DEFAULT NULL,
  `area` float DEFAULT NULL,
  `floor` int(11) DEFAULT NULL,
  `owner_name` char(50) DEFAULT NULL,
  `owner_type` char(50) DEFAULT NULL,
  `house_type` varchar(50) DEFAULT NULL,
  `house_age` int(11) DEFAULT NULL,
  `house_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`house_id`),
  KEY `FK_houseinfo_district` (`district_id`),
  KEY `FK_houseinfo_userid` (`user_id`),
  CONSTRAINT `FK_houseinfo_district` FOREIGN KEY (`district_id`) REFERENCES `district` (`district_id`),
  CONSTRAINT `FK_houseinfo_userid` FOREIGN KEY (`user_id`) REFERENCES `userinfo` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of houseinfo
-- ----------------------------
INSERT INTO `houseinfo` VALUES ('1', null, null, '1', '2', '132', '12.00', '22', '2015-07-21 22:48:56', '12', '123', '12', '12', null, null, null, '123', '1');

-- ----------------------------
-- Table structure for street
-- ----------------------------
DROP TABLE IF EXISTS `street`;
CREATE TABLE `street` (
  `street_name` varchar(50) DEFAULT NULL,
  `district_id` int(11) NOT NULL,
  `street_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`street_id`),
  KEY `FK_street_district` (`district_id`),
  CONSTRAINT `FK_street_district` FOREIGN KEY (`district_id`) REFERENCES `district` (`district_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of street
-- ----------------------------

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `username` varchar(50) NOT NULL,
  `userpass` varchar(50) NOT NULL,
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES ('etc', '123', '1');