/*
Navicat MySQL Data Transfer

Source Server         : test
Source Server Version : 80028
Source Host           : localhost:3306
Source Database       : house

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

Date: 2022-06-29 15:02:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `adminsid` int NOT NULL AUTO_INCREMENT,
  `adminspwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `adminsname` varchar(50) DEFAULT NULL,
  `adminstel` varchar(50) DEFAULT NULL,
  `adminsstate` int NOT NULL,
  PRIMARY KEY (`adminsid`)
) ENGINE=InnoDB AUTO_INCREMENT=13446 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES ('13431', '123456678909', 'monica', '13125566808', '1');
INSERT INTO `admins` VALUES ('13432', '0987', 'ross', '13124456789', '0');
INSERT INTO `admins` VALUES ('13434', '31', 'joey', '13125585393', '1');
INSERT INTO `admins` VALUES ('13435', '1234567', 'chandler', '13124456700', '0');
INSERT INTO `admins` VALUES ('13443', '12131', '111', '13125585393', '0');

-- ----------------------------
-- Table structure for houses
-- ----------------------------
DROP TABLE IF EXISTS `houses`;
CREATE TABLE `houses` (
  `houseid` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `price` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `areas` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `orientid` int DEFAULT NULL,
  `typeid` int DEFAULT NULL,
  `adminsid` int DEFAULT NULL,
  `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `housestate` int DEFAULT NULL COMMENT '0正常 1下架',
  PRIMARY KEY (`houseid`),
  KEY `fk_adminsid` (`adminsid`),
  KEY `fk_orientid` (`orientid`),
  KEY `fk_typeid` (`typeid`),
  CONSTRAINT `fk_adminsid` FOREIGN KEY (`adminsid`) REFERENCES `admins` (`adminsid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_orientid` FOREIGN KEY (`orientid`) REFERENCES `housesorient` (`orientid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_typeid` FOREIGN KEY (`typeid`) REFERENCES `housestype` (`typeid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of houses
-- ----------------------------
INSERT INTO `houses` VALUES ('54', '这是一个房屋1呀', '300000', '80', '这是一条描述哇1', '', '18', '2019', '13435', '2022-06-29 09:53:49', '0');
INSERT INTO `houses` VALUES ('55', '房屋1', '400000', '90', '描述2', 'h_1656469581905.jpg', '17', '2021', '13435', '2022-06-29 10:26:21', '0');
INSERT INTO `houses` VALUES ('57', '房屋3', '500000', '100', '描述3', 'h_1656335789920.jpg', '18', '2019', '13435', '2022-06-27 21:16:29', '0');
INSERT INTO `houses` VALUES ('58', '房屋4', '400000', '77', '', 'h_1656326575890.jpg', '18', '2022', '13435', '2022-06-27 18:42:55', '0');
INSERT INTO `houses` VALUES ('59', '房屋5', '400000', '80', '描述', 'h_1656335708327.gif', '18', '2022', '13434', '2022-06-27 21:15:08', '1');
INSERT INTO `houses` VALUES ('61', '房屋6', '600000', '80', '', 'h_1656327935060.jpg', '18', '2021', '13435', '2022-06-27 19:05:35', '0');
INSERT INTO `houses` VALUES ('62', '房屋7', '600000', '90', '这是一条说明', 'h_1656335926586.gif', '18', '2022', '13435', '2022-06-27 21:18:46', '1');
INSERT INTO `houses` VALUES ('63', '1', '', '', '', 'h_1656470405157.jpg', '25', '2023', '13443', '2022-06-29 10:40:05', '0');
INSERT INTO `houses` VALUES ('66', '111111', '', '', '', 'h_1656485844177.jpg', '22', '2022', '13434', '2022-06-29 14:57:24', '0');

-- ----------------------------
-- Table structure for housesorient
-- ----------------------------
DROP TABLE IF EXISTS `housesorient`;
CREATE TABLE `housesorient` (
  `orientid` int NOT NULL AUTO_INCREMENT,
  `orientname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`orientid`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of housesorient
-- ----------------------------
INSERT INTO `housesorient` VALUES ('14', '坐北朝南');
INSERT INTO `housesorient` VALUES ('15', '坐东北朝西南');
INSERT INTO `housesorient` VALUES ('16', '坐西南朝东北');
INSERT INTO `housesorient` VALUES ('17', '坐南朝北');
INSERT INTO `housesorient` VALUES ('18', '坐东南朝西北');
INSERT INTO `housesorient` VALUES ('19', '坐东朝西');
INSERT INTO `housesorient` VALUES ('22', '坐西北朝东南');
INSERT INTO `housesorient` VALUES ('23', '坐东南朝西北');
INSERT INTO `housesorient` VALUES ('24', '朝阳');
INSERT INTO `housesorient` VALUES ('25', '不朝阳');

-- ----------------------------
-- Table structure for housestype
-- ----------------------------
DROP TABLE IF EXISTS `housestype`;
CREATE TABLE `housestype` (
  `typeid` int NOT NULL AUTO_INCREMENT,
  `typename` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2028 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of housestype
-- ----------------------------
INSERT INTO `housestype` VALUES ('2017', '别墅');
INSERT INTO `housestype` VALUES ('2018', '经济适用房');
INSERT INTO `housestype` VALUES ('2019', '复式住宅');
INSERT INTO `housestype` VALUES ('2020', '住宅：三室一厅');
INSERT INTO `housestype` VALUES ('2021', '住宅：两室一厅');
INSERT INTO `housestype` VALUES ('2022', '住宅：一室一厅');
INSERT INTO `housestype` VALUES ('2023', '学区房');
INSERT INTO `housestype` VALUES ('2024', '东北');
INSERT INTO `housestype` VALUES ('2027', '别墅1');