创建数据库-2019-03-20

/*

Navicat MySQL Data Transfer

Source Server         : local

Source Server Version : 50553

Source Host           : localhost:3306

Source Database       : jujo

Target Server Type    : MYSQL

Target Server Version : 50553

File Encoding         : 65001

Date: 2019-03-21 14:58:54

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for house

-- ----------------------------

DROP TABLE IF EXISTS `house`;

CREATE TABLE `house` (

  `id` int(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',

  `type` char(30) NOT NULL COMMENT '户型',

  `area` char(5) NOT NULL COMMENT '面积',

  `orientation` char(30) NOT NULL COMMENT '朝向',

  `age` int(4) unsigned NOT NULL COMMENT '房龄',

  `floor` int(3) NOT NULL COMMENT '楼层',

  `property` varchar(30) NOT NULL COMMENT '产权',

  `renovation` varchar(300) NOT NULL COMMENT '装修',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of house

-- ----------------------------

INSERT INTO `house` VALUES ('1', '三室一厅', '110', '南北朝向', '8', '12', '商品房', '精装修');

INSERT INTO `house` VALUES ('2', '两室一厅', '86.6', '南北朝向', '3', '8', '商品房', '毛坯');

INSERT INTO `house` VALUES ('8', '两室一厅', '82.6平', '南北朝向', '1', '14', '商品房', '精装修');

INSERT INTO `house` VALUES ('7', '三室两厅', '160平米', '东西朝向', '3', '6', '商品房', '毛坯');

INSERT INTO `house` VALUES ('6', '一室一厅', '60平米', '朝东', '0', '9', '经济房', '毛坯');

INSERT INTO `house` VALUES ('9', '一室一厅', '56平米', '西南朝向', '6', '10', '经济房', '精装修');

INSERT INTO `house` VALUES ('10', '两室一厅', '88平米', '正西朝向', '2', '1', '商品房', '毛坯');

INSERT INTO `house` VALUES ('11', '一室一厅', '60平米', '朝东', '3', '4', '经济房', '精装修');

INSERT INTO `house` VALUES ('12', '三室两厅', '160平米', '东西朝向', '3', '13', '商品房', '毛坯');

INSERT INTO `house` VALUES ('13', '两室一厅', '82.6平', '南北朝向', '1', '21', '商品房', '精装修');

-- ----------------------------

-- Table structure for staff

-- ----------------------------

DROP TABLE IF EXISTS `staff`;

CREATE TABLE `staff` (

  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',

  `name` varchar(30) NOT NULL COMMENT '姓名',

  `age` int(3) unsigned NOT NULL COMMENT '年龄',

  `sex` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '性别:1男0女',

  `position` varchar(20) NOT NULL COMMENT '职位',

  `mobile` char(11) NOT NULL COMMENT '手机',

  `hiredate` int(10) unsigned NOT NULL COMMENT '入职时间',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of staff

-- ----------------------------