-
Notifications
You must be signed in to change notification settings - Fork 1
/
shortrent.sql
118 lines (112 loc) · 7.58 KB
/
shortrent.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
/*
MySQL Data Transfer
Source Host: localhost
Source Database: shortrent
Target Host: localhost
Target Database: shortrent
Date: 2014-1-17 ÉÏÎç 10:01:15
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for house_extrainfo
-- ----------------------------
DROP TABLE IF EXISTS `house_extrainfo`;
CREATE TABLE `house_extrainfo` (
`House_ID` int(11) NOT NULL auto_increment,
`Facilities` varchar(255) NOT NULL,
`Bed_Num` int(11) NOT NULL,
`Toilet_Num` int(11) NOT NULL,
`Room_Describe` varchar(255) NOT NULL,
PRIMARY KEY (`House_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for house_info
-- ----------------------------
DROP TABLE IF EXISTS `house_info`;
CREATE TABLE `house_info` (
`House_ID` int(11) NOT NULL auto_increment,
`House_Address` varchar(255) NOT NULL,
`House_Picture` varchar(255) NOT NULL,
`Live_Num` int(11) NOT NULL,
`House_Price` int(11) NOT NULL,
`House_Intro` varchar(255) NOT NULL,
`Check_in_Time` varchar(255) NOT NULL,
`Check_out_Time` varchar(255) NOT NULL,
`House_Type` varchar(255) NOT NULL,
`Rent_Type` varchar(255) NOT NULL,
`House_Area` int(11) NOT NULL,
`Bedroom_Num` int(11) NOT NULL,
PRIMARY KEY (`House_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`User_ID` int(11) NOT NULL auto_increment,
`User_Phone` varchar(255) default NULL,
`User_TName` varchar(255) default NULL,
`User_Address` varchar(255) default NULL,
`Sex` varchar(255) default NULL,
PRIMARY KEY (`User_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for user_register
-- ----------------------------
DROP TABLE IF EXISTS `user_register`;
CREATE TABLE `user_register` (
`User_ID` int(11) NOT NULL auto_increment,
`User_RegName` varchar(255) default NULL,
`Password` varchar(255) default NULL,
`Email` varchar(255) default NULL,
PRIMARY KEY (`User_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for userconnhouse
-- ----------------------------
DROP TABLE IF EXISTS `userconnhouse`;
CREATE TABLE `userconnhouse` (
`House_ID` int(11) NOT NULL auto_increment,
`User_ID` int(11) NOT NULL,
PRIMARY KEY (`House_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `house_extrainfo` VALUES ('1', 'tv=1####computer=1####', '12', '12', '输入房间的详细æè¿°ä¿¡æ¯.有çƒæ°´å™¨ï¼Œç©ºè°ƒwifi');
INSERT INTO `house_extrainfo` VALUES ('2', 'tv=1#air=1##wash=1##kitchen=1#bath=1##', '2', '2', '适åˆä¸€ä¸ªäººå±…ä½ï¼Œä¼˜é›…的环境和适宜的房间ï¼');
INSERT INTO `house_extrainfo` VALUES ('3', 'tv=1####computer=1##bath=1##', '1', '1', 'ä½äºŽæ±‰å£åŒºï¼Œå‘¨è¾¹çŽ¯å¢ƒèˆ’适，交通方便');
INSERT INTO `house_extrainfo` VALUES ('4', 'tv=1#air=1#ice=1#wash=1###bath=1#warm=1#', '2', '1', '处于光谷周边，交通便利。房间设备é½å…¨ï¼Œé€‚宜居ä½');
INSERT INTO `house_extrainfo` VALUES ('5', '#air=1#ice=1#wash=1##kitchen=1#bath=1##', '5', '2', '处于市区当ä¸ï¼Œäº¤é€šä¾¿åˆ©ï¼Œä½†æ˜¯çŽ¯å¢ƒæ¸…幽，安é™ï¼Œæ¡ä»¶èˆ’适，ä¿è¯é€‚åˆå±…ä½');
INSERT INTO `house_extrainfo` VALUES ('6', 'tv=1#air=1#ice=1##computer=1####', '2', '1', '房间阳光很好，有阳å°ï¼Œä»Žé˜³å°çœ‹é£Žæ™¯å¾ˆç¾Žã€‚处于市区，å„ç§æ–¹ä¾¿ã€‚');
INSERT INTO `house_extrainfo` VALUES ('7', 'tv=1#air=1##wash=1#computer=1##bath=1##', '2', '1', 'è“è‰²æ ¼è°ƒï¼Œæ¸…æ–°èˆ’é€‚ã€‚å¤„äºŽå®‰é™åœ°æ®µï¼Œä½†äº¤é€šä¾¿åˆ©ï¼Œç”Ÿæ´»ä¾¿æ·ã€‚且处于大å¦åŸŽå‘¨è¾¹ï¼Œæ°›å›´å¥½ã€‚');
INSERT INTO `house_extrainfo` VALUES ('8', 'tv=1#air=1#ice=1###kitchen=1###', '6', '3', '床大，舒æœï¼Œæ˜Žäº®ï¼Œå®½æ•ž');
INSERT INTO `house_extrainfo` VALUES ('9', 'tv=1#air=1###computer=1#kitchen=1###', '4', '4', 'å‘åŠ çƒio');
INSERT INTO `house_info` VALUES ('1', '湖北çœæ¦æ±‰å¸‚åŽä¸ç§‘技大å¦', 'http://www.sheepvillage.com/upfiles/rooms/1021.jpg', '3', '1500', '套间三间房海边', '2013-1-17', '2013-1-18', '0', '0', '120', '3');
INSERT INTO `house_info` VALUES ('2', '湖北çœæ¦æ±‰å¸‚æ¦æ˜ŒåŒºæ–°ç”Ÿè·¯8å·12æ ‹', 'http://www.anjiala.com/d/file/hometextile/daren/2011-02-23/ecf0df4120d84eb98d5cc3925f26e409.jpg', '2', '3000', '粉色å°å±‹', '2013-1-17', '2013-1-18', '2', '2', '100', '2');
INSERT INTO `house_info` VALUES ('3', '湖北çœæ¦æ±‰å¸‚ç¡šå£åŒºæ±‰è¥¿ä¸‰è·¯å¸¸é’花å›12æ ‹6楼', 'http://pic6.nipic.com/20100420/3595098_143447848766_2.jpg', '1', '200', '适åˆå•äººï¼ŒçŽ¯å¢ƒä¼˜ç¾Žèˆ’适', '2013-1-17', '2013-1-18', '0', '0', '30', '1');
INSERT INTO `house_info` VALUES ('4', '湖北çœæ¦æ±‰å¸‚洪山区关山大é“369-附25剑桥å°åŒº13æ ‹3楼', 'http://shuitou.indigoculture.com/wp-content/uploads/2011/12/shuitounomalroom-0061.jpg', '2', '200', '房屋设备é½å…¨ï¼Œé€‚åˆæƒ…侣居ä½', '2013-1-17', '2013-1-20', '1', '0', '40', '1');
INSERT INTO `house_info` VALUES ('5', '湖北çœæ¦æ±‰å¸‚æ¦æ˜ŒåŒºä¸œæ¹–è·¯168å·é˜³å…‰èŠ±å›å°åŒº3æ ‹5楼', 'http://www.homesy.com.cn/files/chanpin/200904/200942112120637652.jpg', '3', '800', '安é™èˆ’适，适宜居ä½', '2013-1-17', '2013-1-19', '1', '1', '100', '3');
INSERT INTO `house_info` VALUES ('6', '湖北çœæ¦æ±‰å¸‚æ¦æ˜ŒåŒºé¦–义路金色沙滩å°åŒº7æ ‹3楼', 'http://pica.nipic.com/2007-12-26/200712269513783_2.jpg', '2', '300', '房间å‘阳，光线好', '2013-1-17', '2013-1-20', '0', '0', '50', '1');
INSERT INTO `house_info` VALUES ('7', '湖北çœæ¦æ±‰å¸‚æ¦æ˜ŒåŒºæ²™æ¹–路绿光森林å°åŒº3区12æ ‹5楼', 'http://www.cnfina.com/uploadfile/2011/0426/20110426125804436.jpg', '1', '500', 'è“è‰²æ ¼è°ƒçš„æˆ¿é—´ï¼Œå®‰é™èˆ’适', '2013-1-17', '2013-1-21', '2', '0', '30', '1');
INSERT INTO `house_info` VALUES ('8', '湖北çœæ¦æ±‰å¸‚ç¡šå£åŒºæ±‰ä¸è·¯144汉æ£å°åŒº3å•å…ƒ2æ ‹4楼', 'http://pic.to8to.com/case/1212/03/20121203_80866418b85f4c8631095dhspHYH5NPP.jpg', '3', '200', '清新明亮的设计，空间大，适åˆå…¨å®¶å±…ä½', '2013-1-07', '2013-1-15', '2', '1', '250', '3');
INSERT INTO `house_info` VALUES ('9', '湖北çœæ¦æ±‰å¸‚汉阳区ç´å°å¤§é“金蛇', 'http://pic.to8to.com/case/1212/03/20121203_80866418b85f4c8631095dhspHYH5NPP.jpg', '4', '200', '明亮宽敞', '2013-1-17', '2013-1-18', '1', '1', '200', '4');
INSERT INTO `user_info` VALUES ('2', '15623838117', '黄凯', 'åŽä¸ç§‘技大å¦éŸµè‹‘16æ ‹', 'ç”·');
INSERT INTO `user_info` VALUES ('3', '13026197638', '黄å¨', 'åŽä¸ç§‘技大å¦éŸµè‹‘11æ ‹', 'ç”·');
INSERT INTO `user_info` VALUES ('4', '13387503119', '黄æ°', 'åŽä¸ç§‘技大å¦éŸµè‹‘16æ ‹', 'ç”·');
INSERT INTO `user_info` VALUES ('5', '13512345678', '姜昊良', 'åŽä¸ç§‘技大å¦éŸµè‹‘16æ ‹', 'ç”·');
INSERT INTO `user_info` VALUES ('6', '13324567891', '王一æ¡', 'åŽä¸ç§‘技大å¦éŸµè‹‘16æ ‹420', 'ç”·');
INSERT INTO `user_register` VALUES ('2', 'yinshi', '123456', '[email protected]');
INSERT INTO `user_register` VALUES ('3', 'huangwei', '123456', '[email protected]');
INSERT INTO `user_register` VALUES ('4', 'huangjie', '123456', '[email protected]');
INSERT INTO `user_register` VALUES ('5', 'jianghaoliang', '123456', '[email protected]');
INSERT INTO `user_register` VALUES ('6', 'wangyitong', '123456', 'wangyitong');
INSERT INTO `userconnhouse` VALUES ('1', '1');
INSERT INTO `userconnhouse` VALUES ('2', '1');
INSERT INTO `userconnhouse` VALUES ('3', '1');
INSERT INTO `userconnhouse` VALUES ('4', '1');
INSERT INTO `userconnhouse` VALUES ('5', '1');
INSERT INTO `userconnhouse` VALUES ('6', '1');
INSERT INTO `userconnhouse` VALUES ('7', '1');
INSERT INTO `userconnhouse` VALUES ('8', '1');
INSERT INTO `userconnhouse` VALUES ('9', '1');