代码拉取完成,页面将自动刷新
/*
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');
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。