-
Notifications
You must be signed in to change notification settings - Fork 105
/
Copy pathhouse.sql
387 lines (363 loc) · 30.1 KB
/
house.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50721
Source Host : localhost:3306
Source Database : house
Target Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001
Date: 2018-07-03 16:30:56
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `house`
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'house唯一标识',
`title` varchar(32) NOT NULL,
`price` int(11) unsigned NOT NULL COMMENT '价格',
`area` int(11) unsigned NOT NULL COMMENT '面积',
`room` int(11) unsigned NOT NULL COMMENT '卧室数量',
`floor` int(11) unsigned NOT NULL COMMENT '楼层',
`total_floor` int(11) unsigned NOT NULL COMMENT '总楼层',
`watch_times` int(11) unsigned DEFAULT '0' COMMENT '被看次数',
`build_year` int(4) NOT NULL COMMENT '建立年限',
`status` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '房屋状态 0-未审核 1-审核通过 2-已出租 3-逻辑删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`last_update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近数据更新时间',
`city_en_name` varchar(32) NOT NULL COMMENT '城市标记缩写 如 北京bj',
`region_en_name` varchar(255) NOT NULL COMMENT '地区英文简写 如昌平区 cpq',
`cover` varchar(32) DEFAULT NULL COMMENT '封面',
`direction` int(11) NOT NULL COMMENT '房屋朝向',
`distance_to_subway` int(11) NOT NULL DEFAULT '-1' COMMENT '距地铁距离 默认-1 附近无地铁',
`parlour` int(11) NOT NULL DEFAULT '0' COMMENT '客厅数量',
`district` varchar(32) NOT NULL COMMENT '所在小区',
`admin_id` int(11) NOT NULL COMMENT '所属管理员id',
`bathroom` int(11) NOT NULL DEFAULT '0',
`street` varchar(32) NOT NULL COMMENT '街道',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COMMENT='房屋信息表';
-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES ('15', '富力城 国贸CBD 时尚休闲 商务办公', '6200', '70', '1', '10', '20', '3', '2005', '0', '2018-06-26 21:47:37', '2018-07-03 16:24:49', 'bj', 'hdq', '08', '1', '-1', '0', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('16', '富力城 国贸CBD 时尚休闲 商务办公', '6300', '70', '2', '10', '20', '0', '2012', '3', '2018-06-26 21:47:37', '2018-06-28 19:54:47', 'bj', 'hdq', '02', '1', '-1', '1', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('17', '二环东直门地铁站附近、王府井、天安门、国贸、三里屯、南锣鼓巷', '3000', '35', '1', '5', '10', '3', '2013', '1', '2018-06-26 21:47:37', '2018-07-03 16:27:06', 'bj', 'hdq', '03', '1', '200', '0', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('18', '华贸城 东向一居挑空loft 干净温馨 随时可以签约', '5700', '52', '1', '7', '20', '0', '2012', '1', '2018-06-26 21:47:37', '2018-07-01 15:49:47', 'bj', 'hdq', '04', '2', '1085', '1', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('19', '望春园板楼三居室 自住精装 南北通透 采光好视野棒！', '9200', '132', '3', '6', '14', '0', '2005', '1', '2018-06-26 21:47:37', '2018-07-01 15:11:26', 'bj', 'hdq', '05', '2', '1108', '2', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('20', '高大上的整租两居室 业主诚意出租', '5400', '56', '2', '12', '20', '0', '2012', '1', '2018-06-26 21:47:37', '2018-07-01 15:11:19', 'bj', 'hdq', '06', '2', '20', '1', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('21', '新康园 正规三居室 精装修 家电家具齐全', '1900', '18', '1', '13', '25', '0', '2012', '1', '2018-06-26 21:47:37', '2018-07-01 15:11:22', 'bj', 'hdq', 'FoFd0gROta6iky72BV099kbMJBix', '3', '1302', '0', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('24', '湖光壹号望京华府183-387㎡阔景大宅', '50000', '288', '5', '1', '1', '0', '2015', '1', '2018-06-26 21:47:37', '2018-07-01 15:11:35', 'bj', 'hdq', '08', '5', '200', '3', '融泽嘉园', '2', '0', '龙域西二路');
INSERT INTO `house` VALUES ('25', '大豪房', '3000', '59', '2', '10', '20', '0', '2010', '3', '2018-06-26 21:47:37', '2018-06-28 18:28:45', 'bj', 'cpq', 'FgY-eiEW4Ac6FhugH8lafF6akKvG', '2', '1000', '1', '融泽嘉园', '2', '0', '龙域中街');
INSERT INTO `house` VALUES ('26', '大豪房', '3000', '58', '2', '10', '20', '0', '2018', '1', '2018-06-26 18:33:06', '2018-07-01 15:11:31', 'bj', 'hdq', '10', '2', '1000', '0', '融泽嘉园', '2', '0', '龙城中街');
INSERT INTO `house` VALUES ('27', '上海大豪房', '10000', '100', '1', '3', '10', '0', '2018', '3', '2018-07-01 15:54:50', '2018-07-01 15:58:01', 'bj', 'dcq', 'Fj-BXYRHROuXsKUzvJiyZwxx25sg', '2', '100', '3', '豪校区', '2', '0', '6街道');
-- ----------------------------
-- Table structure for `house_detail`
-- ----------------------------
DROP TABLE IF EXISTS `house_detail`;
CREATE TABLE `house_detail` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(255) DEFAULT NULL COMMENT '详细描述',
`layout_desc` varchar(255) DEFAULT NULL COMMENT '户型介绍',
`traffic` varchar(255) DEFAULT NULL COMMENT '交通出行',
`round_service` varchar(255) DEFAULT NULL COMMENT '周边配套',
`rent_way` int(2) NOT NULL COMMENT '租赁方式',
`address` varchar(32) NOT NULL COMMENT '详细地址 ',
`subway_line_id` int(11) DEFAULT NULL COMMENT '附近地铁线id',
`subway_line_name` varchar(32) DEFAULT NULL COMMENT '附近地铁线名称',
`subway_station_id` int(11) DEFAULT NULL COMMENT '地铁站id',
`subway_station_name` varchar(32) DEFAULT NULL COMMENT '地铁站名',
`house_id` int(11) NOT NULL COMMENT '对应house的id',
PRIMARY KEY (`id`),
UNIQUE KEY `index_on_house_id` (`house_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of house_detail
-- ----------------------------
INSERT INTO `house_detail` VALUES ('21', '国贸CBD商务区,近SOHO现代城,富顿中心,富力城商业街区,乐成中心,潘家园古玩城,八王坟长途客运站,北京游乐园,经由三环路可直达首都机场。附近有双井桥南,双井桥北,双井桥东双井桥西等30多条公交站牌!\n《天安门,故宫,王府井,三里屯,前门,天坛,北海,颐和园,雍和宫,奥林匹克公园,水立方,西单,欢乐谷,燕莎商城等》知名购物区及旅游名胜古迹,是您休闲旅游及商务下榻的理想选择', '房间采光良好,落地窗外景色宜人', '房子处于北京的CBD商务中心区国贸双井!紧邻双井地铁站,步行5分钟即到!这离国贸、中央电视台、潘家园、三里屯、团结湖、日坛使馆区、儿研所、大郊亭都很近', '房子闹中取静,地理位置优越,交通方便,紧邻呼家楼地铁站和东大桥地铁站;去机场可乘坐东直门机场快轨,非常方便｡购物中心有双井购物中心、国贸购物中心和侨福芳草地购物中心、三里屯购物中心等,远道而来的朋友可尽览都市璀璨!', '0', '二号院7号楼', '4', '10号线', '58', '双井', '15');
INSERT INTO `house_detail` VALUES ('22', '国贸CBD商务区,近SOHO现代城,富顿中心,富力城商业街区,乐成中心,潘家园古玩城,八王坟长途客运站,北京游乐园,经由三环路可直达首都机场。附近有双井桥南,双井桥北,双井桥东双井桥西等30多条公交站牌!\n《天安门,故宫,王府井,三里屯,前门,天坛,北海,颐和园,雍和宫,奥林匹克公园,水立方,西单,欢乐谷,燕莎商城等》知名购物区及旅游名胜古迹,是您休闲旅游及商务下榻的理想选择!', '房间采光良好,落地窗外景色宜人', '房子处于北京的CBD商务中心区国贸双井!紧邻双井地铁站,步行5分钟即到', '这离国贸、中央电视台、潘家园、三里屯、团结湖、日坛使馆区、儿研所、大郊亭都很近。房子闹中取静,地理位置优越,交通方便,紧邻呼家楼地铁站和东大桥地铁站;去机场可乘坐东直门机场快轨,非常方便｡购物中心有双井购物中心、国贸购物中心和侨福芳草地购物中心、三里屯购物中心等,远道而来的朋友可尽览都市璀璨！', '0', '1号院1号楼', '1', '13号线', '5', '上地', '16');
INSERT INTO `house_detail` VALUES ('24', '我和我女盆友当房东已经一年了,也是超赞房东,希望能为大家提供舒适的住所~ 房间的大门和房门都是密码门,小区有保安24小时值班,非常安全方便。 通常入住时间是下午三点,提前来的同学可以先寄存行李和洗澡哦~\n\n', '房間非常漂亮,空間很大,鵝黃色的牆壁看起來非常舒服', '位置距離地鐵站不遠', '距故宫、天安门、王府井、三里屯、簋街、南锣鼓巷等景点均可地铁半小时内到达,交通便利~', '0', '1号院2号楼', '1', '13号线', '16', '东直门', '17');
INSERT INTO `house_detail` VALUES ('25', '这个经纪人很懒，没写核心卖点', '此房是一居室的格局，上下两层，面宽，房间亮堂，进门右手厨房，正前方是25平米的客厅，楼上是卧室，带洗手间！ 喧闹和安静隔开，适合居住', '小区距离地铁13号线北苑站500米的距离，交通出行便利....', '小区楼下就是华贸天地娱乐街，保利电影院，眉州东坡，中信银行，麦当劳等娱乐休闲设施齐全', '0', '1号院3号楼', '1', '13号线', '11', '北苑', '18');
INSERT INTO `house_detail` VALUES ('26', '这个经纪人很懒，没写核心卖点', '此房为望春园小区板楼南北通透户型，主卧客厅朝南，次卧朝北，两个客厅双卫，居住很舒适。', '距离地铁5号线立水桥南站630米，有464,465,966,081，621等多条公交线路，交通出行四通八达。', '小区旁有大型购物商场易事达，物美超市，丰宁蔬菜基地，航空总医院、安贞医院北苑分院，中国银行、中国农业银行、中国工商银行、中国交通银行、中国建设银行、招商银行分布。小区旁有天奥健身房，还有立水桥公园..', '0', '6号院1号楼', '1', '13号线', '10', '立水桥', '19');
INSERT INTO `house_detail` VALUES ('27', '高大上的整租两居室 业主诚意出租\n1、客厅挑高、宽敞舒适、阳光充足 2、卧室搭配的很新颖，使用之高 3、厨房带阳台，让您和家人有足够的空间展现私家厨艺', '客厅挑高、宽敞舒适、阳光充足 2、卧室搭配的很新颖，使用之高 3、厨房带阳台，让您和家人有足够的空间展现私家厨艺', '近地铁13号线东直门站', '社区环境好，环境优美，适宜居住，人文素质高，物业管理完善； 2、属于低密度社区 ，适宜居住 3、小区的林密树多，让您感受花园一样的家', '0', '1号院5号楼', '1', '13号线', '16', '东直门', '20');
INSERT INTO `house_detail` VALUES ('28', '房子是正规三室一厅一厨一卫，装修保持的不错，家电家具都齐全。\n', '房子客厅朝北面积比较大，主卧西南朝向，次卧朝北，另一个次卧朝西，两个次卧面积差不多大。', '小区出南门到8号线育新地铁站614米，交通便利，小区500米范围内有物美，三旗百汇，龙旗广场等几个比较大的商场，生活购物便利，出小区北门朝东952米是地铁霍营站，是8号线和 13号线的换乘站，同时还有个S2线，通往怀来。（数据来源百度地图）', '小区西边300米就是物美超市和三旗百汇市场（日常百货、粮油米面、瓜果蔬菜、生鲜海货等等，日常生活很便利，消费成本低），北边200米是龙旗购物广场和永辉超市（保利影院，KFC，麦当劳等，轻松满足娱乐消费）。小区里还有商店，饭店，家政等。', '0', '2号院1号楼', '1', '13号线', '9', '霍营', '21');
INSERT INTO `house_detail` VALUES ('31', '懒死了 不谢', '户型介绍', '交通出行', '周边配套', '0', '3号院1号楼', '1', '13号线', '12', '望京西', '24');
INSERT INTO `house_detail` VALUES ('32', '房屋描述-编辑', '户型介绍', '交通出行', '周边配套-编辑', '0', '3号院2单元1003', '1', '13号线', '8', '回龙观', '25');
INSERT INTO `house_detail` VALUES ('33', '超级big big的豪房', '户型介绍', '交通出行', '学校、语言', '0', '3号楼2单元100', '1', '13号线', '8', '回龙观', '26');
INSERT INTO `house_detail` VALUES ('34', '豪房校区', '客厅挑高、宽敞舒适、阳光充足 2、卧室搭配的很新颖，使用之高 3、厨房带阳台，让您和家人有足够的空间展现私家厨艺', '交通出行', '社区环境好，环境优美，适宜居住，人文素质高，物业管理完善； 2、属于低密度社区 ，适宜居住 3、小区的林密树多，让您感受花园一样的家', '0', '1号院5号楼', '1', '13号线', '5', '上地', '27');
-- ----------------------------
-- Table structure for `house_picture`
-- ----------------------------
DROP TABLE IF EXISTS `house_picture`;
CREATE TABLE `house_picture` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`house_id` int(11) NOT NULL COMMENT '所属房屋id',
`cdn_prefix` varchar(255) NOT NULL COMMENT '图片路径',
`width` int(11) DEFAULT NULL COMMENT '宽',
`height` int(11) DEFAULT NULL COMMENT '高',
`location` varchar(32) DEFAULT NULL COMMENT '所属房屋位置',
`path` varchar(255) NOT NULL COMMENT '文件名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COMMENT='房屋图片信息';
-- ----------------------------
-- Records of house_picture
-- ----------------------------
INSERT INTO `house_picture` VALUES ('68', '19', 'http://pav17qjlw.bkt.clouddn.com/', '911', '683', null, '01');
INSERT INTO `house_picture` VALUES ('69', '19', 'http://pav17qjlw.bkt.clouddn.com/', '1012', '683', null, '02');
INSERT INTO `house_picture` VALUES ('70', '24', 'http://pav17qjlw.bkt.clouddn.com/', '1280', '960', null, '03');
INSERT INTO `house_picture` VALUES ('71', '24', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '04');
INSERT INTO `house_picture` VALUES ('72', '21', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '05');
INSERT INTO `house_picture` VALUES ('73', '21', 'http://pav17qjlw.bkt.clouddn.com/', '455', '683', null, '06');
INSERT INTO `house_picture` VALUES ('74', '20', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '07');
INSERT INTO `house_picture` VALUES ('75', '20', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '08');
INSERT INTO `house_picture` VALUES ('76', '18', 'http://pav17qjlw.bkt.clouddn.com/', '1440', '960', null, '09');
INSERT INTO `house_picture` VALUES ('77', '18', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '10');
INSERT INTO `house_picture` VALUES ('78', '17', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '01');
INSERT INTO `house_picture` VALUES ('79', '17', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '02');
INSERT INTO `house_picture` VALUES ('80', '16', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '03');
INSERT INTO `house_picture` VALUES ('81', '16', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '04');
INSERT INTO `house_picture` VALUES ('82', '16', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '05');
INSERT INTO `house_picture` VALUES ('83', '15', 'http://pav17qjlw.bkt.clouddn.com/', '1024', '683', null, '06');
INSERT INTO `house_picture` VALUES ('85', '15', 'http://pav17qjlw.bkt.clouddn.com/', '1440', '960', null, '08');
INSERT INTO `house_picture` VALUES ('86', '26', 'http://pav17qjlw.bkt.clouddn.com/', '768', '512', null, '09');
INSERT INTO `house_picture` VALUES ('87', '25', 'http://pav17qjlw.bkt.clouddn.com/', '984', '768', null, 'Fosusezn1DsJnDhHfITVV8BFRzkd');
INSERT INTO `house_picture` VALUES ('88', '25', 'http://pav17qjlw.bkt.clouddn.com/', '984', '768', null, 'FgY-eiEW4Ac6FhugH8lafF6akKvG');
INSERT INTO `house_picture` VALUES ('89', '21', 'http://pav17qjlw.bkt.clouddn.com/', '979', '807', null, 'FoFd0gROta6iky72BV099kbMJBix');
INSERT INTO `house_picture` VALUES ('90', '27', 'http://pav17qjlw.bkt.clouddn.com/', '1000', '612', null, 'Fj-BXYRHROuXsKUzvJiyZwxx25sg');
-- ----------------------------
-- Table structure for `house_subscribe`
-- ----------------------------
DROP TABLE IF EXISTS `house_subscribe`;
CREATE TABLE `house_subscribe` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`house_id` int(11) NOT NULL COMMENT '房源id',
`user_id` int(11) NOT NULL COMMENT '用户id',
`desc` varchar(255) DEFAULT NULL COMMENT '用户描述',
`status` int(2) NOT NULL DEFAULT '0' COMMENT '预约状态 1-加入待看清单 2-已预约看房时间 3-看房完成',
`create_time` datetime NOT NULL COMMENT '数据创建时间',
`last_update_time` datetime NOT NULL COMMENT '记录更新时间',
`order_time` datetime DEFAULT NULL COMMENT '预约时间',
`telephone` varchar(11) DEFAULT NULL COMMENT '联系电话',
`admin_id` int(11) NOT NULL COMMENT '房源发布者id',
PRIMARY KEY (`id`),
UNIQUE KEY `index_on_user_and_house` (`house_id`,`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='预约看房信息表';
-- ----------------------------
-- Records of house_subscribe
-- ----------------------------
INSERT INTO `house_subscribe` VALUES ('12', '15', '10', null, '3', '2018-07-01 22:46:03', '2018-07-01 22:46:16', '2018-07-02 00:00:00', '13888888888', '2');
INSERT INTO `house_subscribe` VALUES ('13', '17', '2', null, '3', '2018-07-03 16:25:49', '2018-07-03 16:26:15', '2018-07-04 00:00:00', '18853850556', '2');
-- ----------------------------
-- Table structure for `house_tag`
-- ----------------------------
DROP TABLE IF EXISTS `house_tag`;
CREATE TABLE `house_tag` (
`house_id` int(11) NOT NULL COMMENT '房屋id',
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签id',
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_on_house_id_and_name` (`house_id`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='房屋标签映射关系表';
-- ----------------------------
-- Records of house_tag
-- ----------------------------
INSERT INTO `house_tag` VALUES ('15', '23', '光照充足');
INSERT INTO `house_tag` VALUES ('15', '18', '独立阳台');
INSERT INTO `house_tag` VALUES ('16', '16', '光照充足');
INSERT INTO `house_tag` VALUES ('17', '15', '随时看房');
INSERT INTO `house_tag` VALUES ('17', '14', '集体供暖');
INSERT INTO `house_tag` VALUES ('18', '13', '精装修');
INSERT INTO `house_tag` VALUES ('19', '12', '独立卫生间');
INSERT INTO `house_tag` VALUES ('19', '11', '独立阳台');
INSERT INTO `house_tag` VALUES ('21', '19', '光照充足');
INSERT INTO `house_tag` VALUES ('21', '20', '独立卫生间');
INSERT INTO `house_tag` VALUES ('24', '10', '光照充足');
INSERT INTO `house_tag` VALUES ('24', '3', '精装修');
INSERT INTO `house_tag` VALUES ('24', '8', '集体供暖');
INSERT INTO `house_tag` VALUES ('25', '21', '独立阳台');
INSERT INTO `house_tag` VALUES ('26', '22', '独立阳台');
-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL COMMENT '用户id',
`name` varchar(32) NOT NULL COMMENT '用户角色名',
PRIMARY KEY (`id`),
UNIQUE KEY `user_id_and_name` (`user_id`,`name`) USING BTREE,
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色表';
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '1', 'USER');
INSERT INTO `role` VALUES ('2', '2', 'ADMIN');
INSERT INTO `role` VALUES ('3', '3', 'USER');
INSERT INTO `role` VALUES ('4', '4', 'USER');
INSERT INTO `role` VALUES ('5', '5', 'USER');
INSERT INTO `role` VALUES ('6', '6', 'USER');
INSERT INTO `role` VALUES ('7', '7', 'USER');
INSERT INTO `role` VALUES ('8', '8', 'USER');
INSERT INTO `role` VALUES ('9', '9', 'USER');
INSERT INTO `role` VALUES ('10', '10', 'USER');
INSERT INTO `role` VALUES ('11', '11', 'USER');
-- ----------------------------
-- Table structure for `subway`
-- ----------------------------
DROP TABLE IF EXISTS `subway`;
CREATE TABLE `subway` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL COMMENT '线路名',
`city_en_name` varchar(32) NOT NULL COMMENT '所属城市英文名缩写',
PRIMARY KEY (`id`),
KEY `index_on_city` (`city_en_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of subway
-- ----------------------------
INSERT INTO `subway` VALUES ('1', '13号线', 'bj');
INSERT INTO `subway` VALUES ('2', '1号线', 'bj');
INSERT INTO `subway` VALUES ('3', '2号线', 'bj');
INSERT INTO `subway` VALUES ('4', '10号线', 'bj');
INSERT INTO `subway` VALUES ('5', '8号线', 'bj');
INSERT INTO `subway` VALUES ('6', '9号线', 'bj');
INSERT INTO `subway` VALUES ('7', '7号线', 'bj');
-- ----------------------------
-- Table structure for `subway_station`
-- ----------------------------
DROP TABLE IF EXISTS `subway_station`;
CREATE TABLE `subway_station` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`subway_id` int(11) NOT NULL COMMENT '所属地铁线id',
`name` varchar(32) NOT NULL COMMENT '站点名称',
PRIMARY KEY (`id`),
UNIQUE KEY `unique_station` (`subway_id`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of subway_station
-- ----------------------------
INSERT INTO `subway_station` VALUES ('5', '1', '上地');
INSERT INTO `subway_station` VALUES ('16', '1', '东直门');
INSERT INTO `subway_station` VALUES ('4', '1', '五道口');
INSERT INTO `subway_station` VALUES ('14', '1', '光熙门');
INSERT INTO `subway_station` VALUES ('11', '1', '北苑');
INSERT INTO `subway_station` VALUES ('8', '1', '回龙观');
INSERT INTO `subway_station` VALUES ('2', '1', '大钟寺');
INSERT INTO `subway_station` VALUES ('12', '1', '望京西');
INSERT INTO `subway_station` VALUES ('15', '1', '柳芳');
INSERT INTO `subway_station` VALUES ('3', '1', '知春路');
INSERT INTO `subway_station` VALUES ('10', '1', '立水桥');
INSERT INTO `subway_station` VALUES ('13', '1', '芍药居');
INSERT INTO `subway_station` VALUES ('6', '1', '西二旗');
INSERT INTO `subway_station` VALUES ('1', '1', '西直门');
INSERT INTO `subway_station` VALUES ('9', '1', '霍营');
INSERT INTO `subway_station` VALUES ('7', '1', '龙泽');
INSERT INTO `subway_station` VALUES ('33', '4', '三元家庄');
INSERT INTO `subway_station` VALUES ('51', '4', '三元桥');
INSERT INTO `subway_station` VALUES ('41', '4', '丰台站');
INSERT INTO `subway_station` VALUES ('52', '4', '亮马桥');
INSERT INTO `subway_station` VALUES ('27', '4', '健德门');
INSERT INTO `subway_station` VALUES ('46', '4', '公主坟');
INSERT INTO `subway_station` VALUES ('44', '4', '六里桥');
INSERT INTO `subway_station` VALUES ('53', '4', '农业展览馆');
INSERT INTO `subway_station` VALUES ('62', '4', '分钟寺');
INSERT INTO `subway_station` VALUES ('59', '4', '劲松');
INSERT INTO `subway_station` VALUES ('28', '4', '北土城');
INSERT INTO `subway_station` VALUES ('61', '4', '十里河');
INSERT INTO `subway_station` VALUES ('58', '4', '双井');
INSERT INTO `subway_station` VALUES ('55', '4', '呼家楼');
INSERT INTO `subway_station` VALUES ('54', '4', '团结湖');
INSERT INTO `subway_station` VALUES ('57', '4', '国贸');
INSERT INTO `subway_station` VALUES ('35', '4', '大红门');
INSERT INTO `subway_station` VALUES ('32', '4', '太阳宫');
INSERT INTO `subway_station` VALUES ('29', '4', '安贞门');
INSERT INTO `subway_station` VALUES ('64', '4', '宋家庄');
INSERT INTO `subway_station` VALUES ('20', '4', '巴沟');
INSERT INTO `subway_station` VALUES ('30', '4', '惠新西街南口');
INSERT INTO `subway_station` VALUES ('48', '4', '慈寿寺');
INSERT INTO `subway_station` VALUES ('63', '4', '成寿寺');
INSERT INTO `subway_station` VALUES ('42', '4', '泥洼');
INSERT INTO `subway_station` VALUES ('22', '4', '海淀黄庄');
INSERT INTO `subway_station` VALUES ('60', '4', '潘家园');
INSERT INTO `subway_station` VALUES ('19', '4', '火器营');
INSERT INTO `subway_station` VALUES ('26', '4', '牡丹园');
INSERT INTO `subway_station` VALUES ('24', '4', '知春路');
INSERT INTO `subway_station` VALUES ('23', '4', '知春里');
INSERT INTO `subway_station` VALUES ('34', '4', '石榴庄');
INSERT INTO `subway_station` VALUES ('39', '4', '纪家庙');
INSERT INTO `subway_station` VALUES ('31', '4', '芍药居');
INSERT INTO `subway_station` VALUES ('21', '4', '苏州街');
INSERT INTO `subway_station` VALUES ('38', '4', '草桥');
INSERT INTO `subway_station` VALUES ('45', '4', '莲花桥');
INSERT INTO `subway_station` VALUES ('25', '4', '西土城');
INSERT INTO `subway_station` VALUES ('43', '4', '西局');
INSERT INTO `subway_station` VALUES ('47', '4', '西钓鱼台');
INSERT INTO `subway_station` VALUES ('36', '4', '角门东');
INSERT INTO `subway_station` VALUES ('37', '4', '角门西');
INSERT INTO `subway_station` VALUES ('17', '4', '车道沟');
INSERT INTO `subway_station` VALUES ('56', '4', '金台夕照');
INSERT INTO `subway_station` VALUES ('18', '4', '长春桥');
INSERT INTO `subway_station` VALUES ('40', '4', '首经贸');
-- ----------------------------
-- Table structure for `support_address`
-- ----------------------------
DROP TABLE IF EXISTS `support_address`;
CREATE TABLE `support_address` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`belong_to` varchar(32) NOT NULL DEFAULT '0' COMMENT '上一级行政单位名',
`en_name` varchar(32) NOT NULL COMMENT '行政单位英文名缩写',
`cn_name` varchar(32) NOT NULL COMMENT '行政单位中文名',
`level` varchar(16) NOT NULL COMMENT '行政级别 市-city 地区-region',
`baidu_map_lng` double NOT NULL COMMENT '百度地图经度',
`baidu_map_lat` double NOT NULL COMMENT '百度地图纬度',
PRIMARY KEY (`id`),
UNIQUE KEY `unique_en_name_and_belong_to` (`en_name`,`level`,`belong_to`) USING BTREE COMMENT '每个城市的英文名都是独一无二的'
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of support_address
-- ----------------------------
INSERT INTO `support_address` VALUES ('4', 'bj', 'bj', '北京', 'city', '116.395645', '39.929986');
INSERT INTO `support_address` VALUES ('5', 'sh', 'sh', '上海', 'city', '121.487899', '31.249162');
INSERT INTO `support_address` VALUES ('6', 'hb', 'sjz', '石家庄', 'city', '114.522082', '38.048958');
INSERT INTO `support_address` VALUES ('7', 'hb', 'ts', '唐山', 'city', '118.183451', '39.650531');
INSERT INTO `support_address` VALUES ('8', 'hb', 'hd', '邯郸', 'city', '114.482694', '36.609308');
INSERT INTO `support_address` VALUES ('9', 'bj', 'dcq', '东城区', 'region', '116.42188470126446', '39.93857401298612');
INSERT INTO `support_address` VALUES ('10', 'bj', 'xcq', '西城区', 'region', '116.37319010401802', '39.93428014370851');
INSERT INTO `support_address` VALUES ('12', 'bj', 'hdq', '海淀区', 'region', '116.23967780102151', '40.03316204507791');
INSERT INTO `support_address` VALUES ('13', 'bj', 'cpq', '昌平区', 'region', '116.21645635689414', '40.2217235498323');
INSERT INTO `support_address` VALUES ('14', 'sh', 'ptq', '普陀区', 'region', '121.39844294374956', '31.263742929075534');
INSERT INTO `support_address` VALUES ('15', 'sjz', 'caq', '长安区', 'region', '114.59262155387033', '38.07687479578663');
INSERT INTO `support_address` VALUES ('16', 'sjz', 'qdq', '桥东区', 'region', '114.51078430496142', '38.06338975380927');
INSERT INTO `support_address` VALUES ('17', 'sjz', 'qxq', '桥西区', 'region', '114.43813995531943', '38.033364550068136');
INSERT INTO `support_address` VALUES ('18', 'sjz', 'xhq', '新华区', 'region', '114.4535014286928', '38.117218640478164');
INSERT INTO `support_address` VALUES ('19', 'bj', 'cyq', '朝阳区', 'region', '116.52169489108084', '39.95895316640668');
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户唯一id',
`name` varchar(32) DEFAULT NULL COMMENT '用户名',
`email` varchar(32) DEFAULT NULL COMMENT '电子邮箱',
`phone_number` varchar(15) NOT NULL COMMENT '电话号码',
`password` varchar(32) DEFAULT NULL COMMENT '密码',
`status` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '用户状态 0-正常 1-封禁',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '用户账号创建时间',
`last_login_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登录时间',
`last_update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次更新记录时间',
`avatar` varchar(255) DEFAULT NULL COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `index_on_phone` (`phone_number`) USING BTREE COMMENT '用户手机号',
UNIQUE KEY `index_on_username` (`name`) USING BTREE COMMENT '用户名索引',
UNIQUE KEY `index_on_email` (`email`) USING BTREE COMMENT '电子邮箱索引'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='用户基本信息表';
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'waliwali', 'wali@wali.com', '15111111111', '6fd1aad88b038aeecd9adeccc92b0bd1', '1', '2017-08-25 15:18:20', '2017-08-25 12:00:00', '2017-11-26 10:29:02', 'http://7xo6gy.com1.z0.glb.clouddn.com/99ff568bd61c744bf31185aeddf13580.png');
INSERT INTO `user` VALUES ('2', 'codingchaozhang', 'codingchaozhang@qq.com', '1388888888', '55b3d0936a3fb63168d57a6bda0ddbbf', '1', '2017-08-27 09:07:05', '2017-08-27 09:07:07', '2018-07-03 16:23:14', 'http://7xo6gy.com1.z0.glb.clouddn.com/99ff568bd61c744bf31185aeddf13580.png');
INSERT INTO `user` VALUES ('5', '138****8888', null, '13888888888', null, '0', '2017-11-25 17:56:45', '2017-11-25 17:56:45', '2017-11-25 17:56:45', null);
INSERT INTO `user` VALUES ('8', '151****9677', null, '15110059677', null, '0', '2017-11-25 18:58:18', '2017-11-25 18:58:18', '2017-11-25 18:58:18', null);