-
Notifications
You must be signed in to change notification settings - Fork 21
/
structure and data.sql
237 lines (181 loc) · 44.3 KB
/
structure and data.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
/*
SQLyog Ultimate v8.7
MySQL - 5.5.0-m2-community : Database - weibo
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`weibo` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `weibo`;
/*Table structure for table `atme` */
DROP TABLE IF EXISTS `atme`;
CREATE TABLE `atme` (
`amId` int(11) NOT NULL AUTO_INCREMENT,
`atWho` varchar(12) NOT NULL,
`profId` int(11) DEFAULT NULL,
`comId` int(11) DEFAULT NULL,
PRIMARY KEY (`amId`),
KEY `FK_Reference_8` (`profId`),
KEY `FK_Reference_9` (`comId`),
CONSTRAINT `FK_Reference_8` FOREIGN KEY (`profId`) REFERENCES `profile` (`profId`),
CONSTRAINT `FK_Reference_9` FOREIGN KEY (`comId`) REFERENCES `comment` (`comId`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8;
/*Data for the table `atme` */
insert into `atme`(`amId`,`atWho`,`profId`,`comId`) values (1,'有田十三',48,NULL),(2,'守刚求带饭',48,NULL),(3,'涛苑',49,NULL),(4,'有田十三',50,NULL),(5,'有田十三',51,NULL),(6,'有田十三',54,NULL),(7,'有田十三',55,NULL),(8,'有田十三',56,NULL),(12,'有田十三',69,NULL),(13,'有田十三',70,NULL),(19,'有田十三',74,NULL),(20,'涛苑',74,NULL),(21,'田小冰',75,NULL),(22,'有田十三',75,NULL),(23,'涛苑',75,NULL),(24,'田小冰',76,NULL),(25,'有田十三',76,NULL),(26,'涛苑',76,NULL),(27,'田小冰',77,NULL),(28,'有田十三',77,NULL),(29,'涛苑',77,NULL),(30,'田小冰',78,NULL),(31,'有田十三',78,NULL),(32,'涛苑',78,NULL),(33,'有田十三',83,NULL),(34,'有田十三',86,NULL),(35,'有田十三',87,NULL),(36,'飞翔的狗哥',87,NULL),(38,'有田十三',88,NULL),(39,'有田十三',90,NULL),(40,'田小冰',55,NULL),(41,'涛苑',94,NULL),(44,'Ice1017',88,NULL),(45,'有田十三',88,NULL),(47,'Ice1017',100,NULL),(48,'Ice1017',101,NULL),(49,'有田十三',101,NULL),(50,'有田十三',102,NULL),(51,'Ice1017',102,NULL),(52,'有田十三',103,NULL),(53,'Ice1017',103,NULL),(59,'田小冰',105,NULL),(60,'有田十三',105,NULL),(61,'涛苑',105,NULL),(62,'强强',105,NULL),(63,'飞翔的狗哥',105,NULL),(64,'田小冰',106,NULL),(65,'有田十三',106,NULL),(66,'涛苑',106,NULL),(67,'强强',106,NULL),(68,'Ice1017',106,NULL),(69,'飞翔的狗哥',106,NULL),(70,'守刚守刚棒棒的',107,NULL),(71,'田小冰',NULL,122),(73,'涛苑',NULL,124),(83,'田小冰',NULL,138),(84,'有田十三',NULL,139),(86,'田小冰',108,NULL),(87,'涛苑',108,NULL),(88,'强强',108,NULL),(89,'Ice1017',108,NULL),(90,'飞翔的狗哥',108,NULL),(91,'田小冰',NULL,144),(92,'田小冰',112,NULL),(93,'有田十三',112,NULL),(94,'强强',112,NULL),(95,'Ice1017',112,NULL),(96,'飞翔的狗哥',112,NULL),(103,'田小冰',115,NULL),(104,'田小冰',116,NULL),(105,'有田十三',116,NULL),(106,'涛苑',NULL,150),(107,'田小冰',117,NULL),(108,'有田十三',117,NULL),(109,'紫菱',NULL,154),(112,'田小冰',124,NULL),(113,'有田十三',124,NULL),(114,'飞翔的狗哥',125,NULL),(115,'nbfujx',126,NULL),(116,'薛弟',126,NULL),(117,'田小冰',130,NULL),(118,'有田十三',130,NULL),(119,'薛弟',NULL,163),(120,'淫笑',NULL,166),(121,'淫笑',NULL,167),(122,'飞翔的狗哥',NULL,168),(130,'有田十三',139,NULL),(131,'有田十三',NULL,180),(132,'田小冰',NULL,186),(133,'nbfujx',143,NULL),(134,'薛弟',143,NULL),(135,'有田十三',143,NULL),(136,'有田十三',144,NULL),(137,'stongan',145,NULL),(142,'呵呵',NULL,198),(143,'有田十三',NULL,216),(144,'薛弟',NULL,220),(145,'呵呵',NULL,221),(146,'呵呵',NULL,223),(147,'我是淫笑我怕谁',NULL,224),(149,'田小冰',180,NULL),(150,'有田十三',180,NULL),(151,'有田十三',184,NULL),(152,'钱钱不是万能的',NULL,242),(154,'有田十三',189,NULL),(155,'呵呵',NULL,246),(157,'有田十三',197,NULL);
/*Table structure for table `comment` */
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`comId` int(11) NOT NULL AUTO_INCREMENT,
`profId` int(11) NOT NULL,
`comTime` datetime NOT NULL,
`comFrom` int(11) NOT NULL,
`comContent` varchar(140) NOT NULL,
`comComId` int(11) DEFAULT NULL,
PRIMARY KEY (`comId`),
KEY `FK_Reference_4` (`profId`),
KEY `FK_Reference_5` (`comFrom`),
CONSTRAINT `FK_Reference_4` FOREIGN KEY (`profId`) REFERENCES `profile` (`profId`),
CONSTRAINT `FK_Reference_5` FOREIGN KEY (`comFrom`) REFERENCES `userinfo` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8;
/*Data for the table `comment` */
insert into `comment`(`comId`,`profId`,`comTime`,`comFrom`,`comContent`,`comComId`) values (2,37,'2011-10-27 00:00:00',1,'我的啊',0),(17,38,'2011-10-29 20:21:48',1,'敢不敢评论完给我删了。',0),(18,36,'2011-10-29 20:22:47',1,'评论一个我看看？',0),(20,24,'2011-10-29 21:24:38',1,'评论这个看能不能删。这可不是我的微博哦亲。',0),(22,24,'2011-10-29 22:16:51',2,'日求。我就不信转不过来。',0),(23,38,'2011-10-29 22:21:40',1,'求给力压。',0),(24,38,'2011-10-29 22:24:56',3,'给力头像啊。。',0),(25,35,'2011-10-29 22:32:05',1,'求评论啊。。。',0),(29,35,'2011-10-29 22:33:11',1,'啊啊',0),(31,35,'2011-10-29 23:41:38',1,'美女，求交往。。。',0),(32,35,'2011-10-29 23:42:05',3,'回复@有田十三:恩不要嘛。。。',31),(34,38,'2011-10-31 16:00:42',2,'回复@有田十三:菊花。',23),(35,38,'2011-10-31 16:02:24',1,'回复@涛苑: 樊韬远2求。',34),(38,38,'2011-10-31 20:28:26',1,'回复@涛苑: 爱情',36),(44,38,'2011-10-31 20:34:14',1,'回复@涛苑: 评论这一页的找不到。',43),(45,38,'2011-10-31 20:35:05',1,'回复@涛苑: 首页能找得到不?',43),(48,38,'2011-10-31 20:39:09',1,'回复@涛苑: 这样呢？',46),(50,38,'2011-10-31 21:10:51',1,'回复@中中: 啊你个2求。',49),(52,24,'2011-10-31 21:17:47',1,'回复@涛苑: 啊评论成功了吧。。。',47),(54,43,'2011-11-03 21:06:18',1,'守刚看能不能看到。',0),(64,43,'2011-11-05 20:00:09',1,'回复@守刚球带饭: a',62),(65,41,'2011-11-10 23:29:27',1,'回复@ddddd: 嗷嗷嗷',63),(67,41,'2011-11-14 22:19:49',1,'回复@涛苑: 这不能有问题吧？',61),(68,45,'2011-11-15 22:02:47',1,'评论评论啊。',0),(69,21,'2011-11-15 22:03:11',1,'日球。',0),(71,56,'2011-11-17 16:56:50',1,' 真的假的。。。',0),(73,41,'2011-11-17 16:58:11',1,'回复@再丑也要谈恋爱: 好你妹。',63),(97,56,'2011-11-18 22:40:18',1,'a',0),(98,56,'2011-11-18 22:41:18',1,'a',0),(99,56,'2011-11-18 22:41:24',1,'',0),(106,55,'2011-11-18 22:46:13',1,'a',0),(107,51,'2011-11-18 22:48:23',1,'aaa',0),(108,70,'2011-11-24 01:04:04',1,'我了个去。。。',0),(109,86,'2011-11-27 22:13:06',1,'你个傻逼。。',0),(110,88,'2011-11-29 23:07:35',1,'你再说一个看看？',0),(111,88,'2011-11-29 23:09:19',14,'回复@有田十三: 我怎么@不到你啊···',110),(112,88,'2011-11-29 23:10:38',1,'回复@Ice1017: 因为我还没做全乎。。。您就将就着用吧。。',111),(113,88,'2011-11-29 23:12:37',14,'回复@有田十三: 我回复你都木有回复成功的提示···BUG···啊··还没有鄙视的表情···',112),(114,88,'2011-11-29 23:12:55',14,'哦哦 这样的啊···你是傻的我知道啊\r\n',112),(115,88,'2011-11-29 23:16:57',2,'回复@Ice1017: 啊表情还在做。。',114),(116,88,'2011-11-29 23:19:23',2,'回复@涛苑: 啊啊啊',115),(117,87,'2011-11-29 23:19:43',2,'啊',0),(118,87,'2011-11-29 23:19:50',2,'回复@涛苑: 啊',117),(119,88,'2011-11-29 23:19:55',2,'回复@涛苑: 爱仕达',116),(120,90,'2011-11-29 23:21:39',14,'ni cai 2 ne ``xiao 2b',0),(121,88,'2011-11-30 22:26:19',1,'回复@涛苑: a ',119),(122,56,'2011-12-01 00:22:28',1,'回复@田小冰: 测试1',72),(124,87,'2011-12-01 00:26:38',1,'回复@涛苑: 测试1',117),(125,107,'2011-12-01 00:27:01',1,'测试2',0),(138,56,'2011-12-01 01:01:43',1,'回复@田小冰: 呵呵。',123),(139,107,'2011-12-01 01:07:29',1,'回复@有田十三: 啊',125),(140,106,'2011-12-01 12:47:43',1,'测试',0),(144,56,'2011-12-05 19:25:36',1,'回复@田小冰: [给力][奥特曼][懒得理你][花心][围观]',123),(145,69,'2011-12-10 17:39:32',3,'嘿嘿。',0),(147,107,'2011-12-10 20:03:23',1,'[懒得理你]',0),(150,88,'2011-12-10 21:14:35',14,'回复@涛苑: [给力]',115),(151,114,'2011-12-10 21:16:40',15,'[花心]',0),(152,118,'2011-12-10 23:37:49',16,'很好~~！！',0),(154,118,'2011-12-10 23:43:02',16,'回复@紫菱: enen',152),(156,115,'2011-12-10 23:58:51',16,'[嘿嘿]~~恩恩',0),(163,110,'2011-12-12 00:03:21',1,'回复@薛弟: [围观]',159),(164,129,'2011-12-12 17:35:54',1,'[奥特曼]',0),(165,132,'2011-12-14 14:05:16',15,'[花心]',0),(166,132,'2011-12-15 12:12:28',9,'回复@淫笑: [讨厌]',165),(167,114,'2011-12-15 12:12:50',9,'回复@淫笑: [花心]',151),(168,114,'2011-12-15 12:30:37',1,'回复@飞翔的狗哥: a',167),(180,114,'2011-12-17 22:30:55',3,'回复@有田十三: [围观]',177),(185,91,'2011-12-18 21:03:52',1,'a',0),(186,114,'2011-12-19 01:59:55',1,'回复@田小冰:[围观]',180),(187,38,'2011-12-19 02:02:45',1,'[给力]',0),(188,117,'2011-12-19 02:12:39',1,'[奥特曼]',0),(189,147,'2011-12-19 15:47:47',28,'all right',0),(190,147,'2011-12-19 15:48:50',28,'顶上',0),(191,145,'2011-12-19 17:14:22',31,'[嘿嘿]呵呵呵',0),(197,144,'2011-12-19 19:40:00',31,'呀呀呀',0),(198,144,'2011-12-19 19:40:11',31,'回复@呵呵:啦啦啦',197),(204,151,'2011-12-19 19:44:17',31,'[围观]',0),(207,145,'2011-12-19 19:46:41',31,'',0),(215,116,'2011-12-19 21:17:41',1,'[奥特曼]',0),(216,116,'2011-12-19 21:17:45',1,'回复@有田十三: [奥特曼]',215),(218,139,'2011-12-19 22:31:57',32,'3333[花心]',0),(219,139,'2011-12-19 22:35:23',32,'[奥特曼][奥特曼]',0),(220,139,'2011-12-19 22:35:43',32,'回复@薛弟: [奥特曼]',219),(221,145,'2011-12-19 22:45:17',27,'回复@呵呵: hello',207),(223,133,'2011-12-19 22:46:20',27,'回复@呵呵: [鄙视]',196),(224,133,'2011-12-19 22:46:26',1,'回复@我是淫笑我怕谁: [奥特曼]',223),(241,131,'2011-12-21 17:49:34',25,'[围观]',0),(242,131,'2011-12-22 18:06:13',1,'回复@钱钱不是万能的:[奥特曼]',241),(245,181,'2011-12-22 12:49:13',31,'[奥特曼]',0),(246,181,'2011-12-22 12:50:28',1,'回复@呵呵:[阴险]点爆一次一分啊。',245),(247,181,'2011-12-22 12:50:51',31,'恩呢~~~',246);
/*Table structure for table `count` */
DROP TABLE IF EXISTS `count`;
CREATE TABLE `count` (
`userId` int(11) NOT NULL,
`fansCount` bigint(20) NOT NULL,
`msgCount` bigint(20) NOT NULL,
`atProfileCount` bigint(20) NOT NULL,
`atCommentCount` bigint(20) NOT NULL,
`noticeCount` bigint(20) NOT NULL,
`commentCount` bigint(20) NOT NULL,
PRIMARY KEY (`userId`),
CONSTRAINT `FK_Reference_10` FOREIGN KEY (`userId`) REFERENCES `userinfo` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `count` */
insert into `count`(`userId`,`fansCount`,`msgCount`,`atProfileCount`,`atCommentCount`,`noticeCount`,`commentCount`) values (1,17,17,36,3,5,15),(2,5,1,10,2,0,0),(3,12,3,15,4,1,18),(15,1,2,0,2,1,0),(22,2,1,0,0,1,0),(23,0,0,0,0,0,0),(24,0,1,0,0,1,0),(25,1,0,0,0,2,0),(27,0,0,0,2,2,1),(28,0,0,0,0,2,0),(29,0,0,0,0,2,0),(30,0,0,0,0,2,0),(31,1,0,0,4,6,2),(32,1,1,0,0,2,0),(34,0,0,0,0,0,0),(35,0,0,0,0,4,0),(36,0,0,0,0,1,0);
/*Table structure for table `fans_manage` */
DROP TABLE IF EXISTS `fans_manage`;
CREATE TABLE `fans_manage` (
`fmId` int(11) NOT NULL AUTO_INCREMENT,
`fansId` int(11) NOT NULL,
`followId` int(11) NOT NULL,
`groupId` int(11) NOT NULL,
PRIMARY KEY (`fmId`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;
/*Data for the table `fans_manage` */
insert into `fans_manage`(`fmId`,`fansId`,`followId`,`groupId`) values (3,3,2,0),(13,9,2,0),(14,9,3,0),(15,9,4,0),(16,9,5,0),(19,13,3,0),(20,13,5,0),(23,12,1,0),(24,12,3,0),(39,1,4,0),(40,1,2,0),(41,9,1,0),(45,4,9,0),(46,1,3,0),(47,1,7,0),(48,1,5,0),(50,1,9,0),(55,14,1,0),(56,14,3,0),(57,14,2,0),(58,14,5,0),(59,14,4,0),(60,14,9,0),(61,14,7,0),(62,14,8,0),(63,14,12,0),(64,14,10,0),(65,14,11,0),(66,14,13,0),(68,2,14,0),(69,15,3,0),(70,15,9,0),(71,15,7,0),(73,16,1,0),(75,1,16,0),(77,17,1,0),(78,17,3,0),(79,1,17,0),(81,17,2,0),(82,17,9,0),(83,17,5,0),(84,1,18,0),(85,1,8,0),(87,1,10,0),(89,3,7,0),(91,13,7,0),(92,14,16,0),(93,14,17,0),(94,14,18,0),(96,15,5,0),(99,3,1,0),(101,1,13,0),(102,1,15,0),(105,1,11,0),(106,13,1,0),(107,15,1,0),(108,5,1,0),(109,18,1,0),(111,1,14,0),(115,26,9,0),(116,29,1,0),(117,29,3,0),(118,29,9,0),(119,29,8,0),(120,31,1,0),(121,31,9,0),(126,31,5,0),(153,32,1,0),(154,32,9,0),(155,32,3,0),(156,32,5,0),(157,32,2,0),(158,32,7,0),(159,31,8,0),(160,31,10,0),(161,31,11,0),(162,31,13,0),(163,31,14,0),(164,31,16,0),(165,31,17,0),(166,31,18,0),(167,31,12,0),(168,31,15,0),(169,31,22,0),(170,31,23,0),(171,31,24,0),(172,31,25,0),(173,31,26,0),(174,33,1,0),(175,33,9,0),(176,33,3,0),(177,32,8,0),(178,32,14,0),(179,32,4,0),(180,32,17,0),(182,27,1,0),(183,27,9,0),(184,27,2,0),(185,27,8,0),(186,27,3,0),(187,27,33,0),(188,27,5,0),(189,27,17,0),(190,27,15,0),(191,33,17,0),(192,33,5,0),(193,33,2,0),(194,33,7,0),(195,33,4,0),(196,27,32,0),(197,1,12,0),(198,1,23,0),(199,1,24,0),(206,1,33,0),(207,25,1,0),(208,22,31,0),(209,30,1,0),(210,30,7,0),(211,30,8,0),(212,7,5,0),(213,7,3,0),(214,1,22,0),(216,32,27,0);
/*Table structure for table `follow_group` */
DROP TABLE IF EXISTS `follow_group`;
CREATE TABLE `follow_group` (
`groupId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`groupName` varchar(1000) NOT NULL,
PRIMARY KEY (`groupId`),
KEY `FK_Reference_3` (`userId`),
CONSTRAINT `FK_Reference_3` FOREIGN KEY (`userId`) REFERENCES `userinfo` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Data for the table `follow_group` */
insert into `follow_group`(`groupId`,`userId`,`groupName`) values (1,1,'分组A'),(3,1,'分组B'),(4,1,'嘿嘿'),(5,1,'1231');
/*Table structure for table `login` */
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`loginName` varchar(12) NOT NULL,
`password` varchar(12) NOT NULL,
`loginType` bigint(20) DEFAULT NULL,
PRIMARY KEY (`loginName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `login` */
insert into `login`(`loginName`,`password`,`loginType`) values ('20091610524','123456',0),('20091610525','123456',0),('admin','admin',1),('caoqiuyan','123123',0),('chenmu','123123',0),('fangjiajia','12345678',0),('fty','123',0),('ftyfty','123456',0),('gaoqian','123123',0),('ice1017','13142500',0),('jacqueline1','089888263450',0),('liuniaochi','123123',0),('nbfujx','123456',0),('njzydj999','13992866229',0),('pp','123',0),('qhyjj123','19901112',0),('qiangge','123123',0),('shentong','shentong',0),('shougang','123123',0),('ss','ss',0),('ssg','123',0),('stongan','199225',0),('tb','123',0),('titan','123',0),('wangyu','123123',0),('xuexue','654321',0),('xugang','123123',0),('yinxiao','123123',0),('yin_xiao','123456',0),('yunyun','123456789',0),('yunyun_520','123456',0),('zengge','123123',0),('zxingxing','123123',0);
/*Table structure for table `msg_notice` */
DROP TABLE IF EXISTS `msg_notice`;
CREATE TABLE `msg_notice` (
`msgId` int(11) NOT NULL AUTO_INCREMENT,
`msgTime` datetime NOT NULL,
`msgFrom` int(11) NOT NULL,
`msgTo` int(11) NOT NULL,
`msgContent` varchar(500) NOT NULL,
`msgType` tinyint(4) NOT NULL,
`msgRead` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`msgId`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
/*Data for the table `msg_notice` */
insert into `msg_notice`(`msgId`,`msgTime`,`msgFrom`,`msgTo`,`msgContent`,`msgType`,`msgRead`) values (1,'2011-11-21 00:47:00',1,3,'1',0,NULL),(2,'2011-11-21 13:27:28',1,3,'啊啊啊。肚子疼。。。',0,NULL),(3,'2011-11-21 13:27:55',3,1,'吃药',0,NULL),(4,'2011-11-21 19:01:00',3,1,'田冰发送给田泱的私心。',0,NULL),(5,'2011-11-27 22:42:33',4,1,'你妹子。求激情裸聊。',0,NULL),(6,'2011-11-28 17:15:46',1,1,'123',0,NULL),(7,'2011-11-28 17:17:50',1,1,'你妈',0,NULL),(8,'2011-11-28 17:19:22',1,1,'尼玛',0,NULL),(9,'2011-11-28 17:19:33',1,1,'尼玛',0,NULL),(10,'2011-11-28 17:22:02',1,1,'123',0,NULL),(11,'2011-11-28 17:24:31',1,1,'12',0,NULL),(13,'2011-11-29 19:28:44',1,3,'啊啊啊啊',0,NULL),(14,'2011-12-10 21:13:58',14,2,'你这厮，吃洒家一拳。',0,NULL),(15,'2011-12-10 23:56:00',16,1,'呵呵',0,NULL),(16,'2011-12-11 01:02:39',1,17,'您的头像叼爆了。。。',0,NULL),(17,'2011-12-11 01:03:38',17,1,'HI 求包养',0,NULL),(18,'2011-12-11 01:13:07',17,17,'123333',0,NULL),(19,'2011-12-11 20:47:24',1,14,'呵呵。',4,1),(21,'2011-12-11 22:57:00',1,17,'按时打算',1,1),(22,'2011-12-11 23:02:49',1,18,'你妹。',0,1),(28,'2011-12-17 22:15:38',3,1,'1',3,1),(29,'2011-12-17 22:16:04',3,1,'2',3,1),(31,'2011-12-17 21:42:28',3,1,'1',3,1),(36,'2011-12-19 03:21:34',1,18,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa',0,1),(40,'2011-12-19 03:59:17',1,18,'<img src=\"/Weibo/Images/emotions/geili.gif\" title=\"给力\">nimei',0,1),(41,'2011-12-19 04:00:28',1,17,'<img src=\"/Weibo/Images/emotions/hei.gif\" title=\"嘿嘿\">~~~',0,1),(44,'2011-12-19 04:11:13',1,15,'<img src=\"/Weibo/Images/emotions/wg.gif\" title=\"围观\">',0,1),(45,'2011-12-19 03:39:04',1,1,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">12',1,1),(49,'2011-12-19 13:58:02',0,24,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',0,1),(50,'2011-12-19 14:03:42',0,25,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(51,'2011-12-19 15:32:42',0,27,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(52,'2011-12-19 15:36:16',0,28,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(53,'2011-12-19 15:41:40',0,29,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(54,'2011-12-19 15:44:38',29,1,'hello weibno',0,1),(57,'2011-12-19 15:59:27',0,30,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(58,'2011-12-19 17:09:49',0,31,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(59,'2011-12-19 19:36:11',31,1,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\"><img src=\"/Weibo/Images/emotions/laugh.gif\" title=\"哈哈\">',0,1),(60,'2011-12-19 21:23:33',0,17,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(61,'2011-12-19 15:45:01',1,1,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">HEY MAN',3,1),(62,'2011-12-19 04:12:32',1,15,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',2,1),(64,'2011-12-19 04:03:29',1,17,'1',2,1),(67,'2011-12-19 01:08:13',0,1,'ss',5,1),(69,'2011-12-20 01:15:59',32,1,'13123123',0,1),(70,'2011-12-20 01:18:26',32,17,'2222',0,1),(71,'2011-12-20 19:41:44',32,17,'3333',0,1),(72,'2011-12-20 19:42:09',32,1,'求回复一发',0,1),(73,'2011-12-20 23:03:25',33,17,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',0,1),(74,'2011-12-20 23:34:42',0,34,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(75,'2011-12-21 01:20:45',1,32,'<img src=\"/Weibo/Images/emotions/geili.gif\" title=\"给力\">',0,1),(76,'2011-12-21 02:00:57',1,22,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',0,1),(79,'2011-12-21 17:52:13',3,3,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',3,1),(80,'2011-12-21 17:54:19',1,33,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',0,1),(81,'2011-12-21 22:10:38',0,35,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(82,'2011-12-21 22:26:15',0,35,'<img src=\"/Weibo/Images/emotions/wg.gif\" title=\"围观\">',5,1),(83,'2011-12-21 22:27:47',0,1,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',5,1),(85,'2011-12-21 22:36:38',0,35,'<img src=\"/Weibo/Images/emotions/wg.gif\" title=\"围观\">',5,1),(86,'2011-12-21 23:07:54',1,1,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',0,1),(93,'2011-12-22 00:33:45',0,0,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">javascript:validateMsgSubmit(\'msg\');',5,1),(94,'2011-12-22 19:38:29',1,24,'HEY，man',0,1),(95,'2011-12-23 01:02:17',25,1,'你好啊。<img src=\"/Weibo/Images/emotions/hs.gif\" title=\"花心\">',0,1),(96,'2011-12-22 12:46:17',31,22,'<img src=\"/Weibo/Images/emotions/geili.gif\" title=\"给力\">',0,1),(97,'2011-12-22 13:07:42',0,16,'<img src=\"/Weibo/Images/emotions/bs.gif\" title=\"鄙视\">',5,1),(98,'2011-12-22 13:08:12',0,31,'',5,1),(99,'2011-12-22 13:08:35',0,31,'<img src=\"/Weibo/Images/emotions/wg.gif\" title=\"围观\">',5,1),(100,'2011-12-22 13:09:03',0,0,'<img src=\"/Weibo/Images/emotions/yx.gif\" title=\"阴险\">',5,1),(101,'2011-12-22 13:15:45',0,31,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',5,1),(102,'2011-12-22 13:34:37',0,36,'欢迎您加入我们的微博大家庭，祝您越V越开心，越V越漂亮',5,1),(103,'2011-12-24 21:53:05',32,17,'<img src=\"/Weibo/Images/emotions/otm.gif\" title=\"奥特曼\">',0,1),(104,'2011-12-24 22:24:36',0,0,'http://win-oltcugd6l6m:8080/Weibo/Admin/noticeList.action?pageNumber=1',5,1);
/*Table structure for table `profile` */
DROP TABLE IF EXISTS `profile`;
CREATE TABLE `profile` (
`profId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`profContent` varchar(300) DEFAULT NULL,
`profTime` datetime NOT NULL,
`tcId` int(11) DEFAULT NULL,
`ImageRef` varchar(10) DEFAULT NULL,
PRIMARY KEY (`profId`),
KEY `FK_Reference_1` (`userId`),
CONSTRAINT `FK_Reference_1` FOREIGN KEY (`userId`) REFERENCES `userinfo` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8;
/*Data for the table `profile` */
insert into `profile`(`profId`,`userId`,`profContent`,`profTime`,`tcId`,`ImageRef`) values (8,2,'樊韬远的微博1','1991-12-13 00:00:00',0,NULL),(9,2,'樊韬远的微博2','1991-12-13 00:00:00',0,NULL),(15,1,'难道是字符集的问题？','2011-10-20 20:17:56',0,NULL),(16,1,'啊明显不是。。。我了个去。','2011-10-20 20:18:16',0,NULL),(17,1,'星星2求。','2011-10-20 20:18:50',0,NULL),(18,1,'要是没问题怎么办。','2011-10-20 20:20:59',0,NULL),(19,2,'樊韬远求注册啊。','2011-10-20 20:30:22',0,NULL),(20,2,'注册完就可以用马甲发围脖了。。。','2011-10-20 20:30:40',0,NULL),(21,2,'你敢不敢给我学快点。','2011-10-20 20:33:22',0,NULL),(22,1,'这个是有田十三 21点18分发的。','2011-10-20 21:18:27',0,NULL),(23,3,'这是小彭21点十九分发的。','2011-10-20 21:18:56',0,NULL),(24,2,'这是樊韬远20分发的。','2011-10-20 21:19:24',0,NULL),(26,2,'鸟毛23分又来过。','2011-10-20 21:23:10',0,NULL),(27,3,'樊韬远23分的时候把那个搞定了。','2011-10-20 21:24:03',0,NULL),(28,3,'改了改分页一上午。','2011-10-22 12:09:19',0,NULL),(29,3,'实践证明是改对了。。','2011-10-22 12:09:39',0,NULL),(30,3,'发个微博试试。','2011-10-22 12:11:16',0,NULL),(32,1,'你大爷的。总算把时间设置好了。','2011-10-22 14:58:19',0,NULL),(33,3,'凑个5条微博来试试','2011-10-23 20:18:46',0,NULL),(34,3,'还有两条啊','2011-10-23 20:18:54',0,NULL),(35,3,'这个应该是第二页的了。','2011-10-23 20:19:09',0,NULL),(36,1,'在发一条试试？','2011-10-23 20:47:00',0,NULL),(37,1,'哎？没第四页了？','2011-10-23 20:47:23',0,NULL),(38,1,'发个微博。坐等评论啊。亲。','2011-10-28 22:36:49',0,NULL),(39,5,'田2','2011-11-01 19:17:28',0,NULL),(40,4,'占楼。','2011-11-01 19:45:08',0,NULL),(41,1,'困呀。。。','2011-11-01 19:45:30',0,NULL),(43,4,'狗哥你这个二球。','2011-11-03 21:05:45',0,NULL),(44,1,'发个微博。','2011-11-05 22:07:07',0,NULL),(45,1,'啊','2011-11-05 22:12:23',0,NULL),(48,1,'@有田十三@守刚求带饭','2011-11-17 11:01:04',0,NULL),(49,1,'@涛苑','2011-11-17 11:23:22',0,NULL),(50,2,'@有田十三','2011-11-17 12:24:48',0,NULL),(51,5,'@有田十三','2011-11-17 12:25:02',0,NULL),(54,1,'@有田十三@有田十三','2011-11-17 16:52:25',40,NULL),(55,3,'@有田十三','2011-11-17 16:54:55',0,NULL),(56,3,'啊啊啊@有田十三 好喜欢你啊。','2011-11-17 16:55:15',41,NULL),(63,1,'啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊','2011-11-21 19:39:41',0,NULL),(64,1,'123','2011-11-21 22:58:45',42,NULL),(68,2,'我擦擦。。。//@有田十三: 你妹的。//@有田十三: 够格你个2求、','2011-11-21 23:37:20',47,NULL),(69,3,'@有田十三 你好啊。@有田十三 @有田十三 @有田十三 @有田十三 ','2011-11-21 23:48:53',0,NULL),(70,1,'@有田十三 啊。','2011-11-21 23:49:38',0,'70.jpg'),(72,1,'求AT。','2011-11-22 00:11:45',50,NULL),(74,1,'@涛苑//@有田十三: 求AT。','2011-11-22 23:19:26',56,NULL),(75,2,'@田小冰//@有田十三: @涛苑//@有田十三: 求AT。','2011-11-22 23:20:09',57,NULL),(76,1,'嘿嘿。//@涛苑: @田小冰//@有田十三: @涛苑//@有田十三: 求AT。','2011-11-24 00:15:52',58,NULL),(77,1,'神马情况？？？//@有田十三: 嘿嘿。//@涛苑: @田小冰//@有田十三: @涛苑//@有田十三: 求AT。','2011-11-24 01:20:11',59,NULL),(78,1,'收藏别乱闪啊。。//@有田十三: 嘿嘿。//@涛苑: @田小冰//@有田十三: @涛苑//@有田十三: 求AT。','2011-11-25 00:27:23',64,NULL),(79,1,'你妹子','2011-11-25 22:01:19',67,NULL),(81,8,'爱仕达','2011-11-26 22:25:32',0,NULL),(82,13,'你妹的。','2011-11-27 20:52:43',0,NULL),(83,12,'啊？//@有田十三: 你妹子','2011-11-27 21:05:11',68,NULL),(84,9,'程程VICKEY，我喜欢你。','2011-11-27 22:11:11',0,NULL),(85,1,'你尼玛想多了吧。。。','2011-11-27 22:11:59',69,NULL),(86,9,'要你管啊。。//@有田十三: 你尼玛想多了吧。。。','2011-11-27 22:12:21',70,NULL),(87,1,'呵呵。//@飞翔的狗哥: 要你管啊。。//@有田十三: 你尼玛想多了吧。。。','2011-11-29 20:49:30',73,NULL),(88,14,'傻死了···@有田十三','2011-11-29 23:03:11',0,NULL),(89,1,'你再说就打你了啊。','2011-11-29 23:07:47',75,NULL),(90,2,'田冰你真2.。。//@有田十三: 你再说就打你了啊。','2011-11-29 23:16:06',76,NULL),(91,14,'w shi yige kuaile de xiao 2 b','2011-11-29 23:38:18',0,NULL),(92,1,'转发没？','2011-11-30 00:43:58',78,NULL),(93,14,'求转发啊。','2011-11-30 00:49:11',79,NULL),(94,13,'@涛苑','2011-11-30 00:51:51',80,NULL),(97,2,'测试。1','2011-11-30 22:30:14',82,NULL),(100,1,'测试3','2011-11-30 23:17:07',85,NULL),(101,14,'测试4.//@有田十三: 测试3','2011-11-30 23:18:03',86,NULL),(102,1,'测试5//@Ice1017: 测试4.//@有田十三: 测试3','2011-12-01 00:04:16',87,NULL),(103,14,'测试6//@有田十三: 测试5//@Ice1017: 测试4.//@有田十三: 测试3','2011-12-01 00:04:54',88,NULL),(105,14,'@飞翔的狗哥//@强强: @涛苑','2011-12-01 00:06:23',90,NULL),(106,1,'@Ice1017 @飞翔的狗哥 @田小冰 //@Ice1017: @飞翔的狗哥//@强强: @涛苑','2011-12-01 00:08:42',91,NULL),(107,1,'@守刚守刚棒棒的','2011-12-01 00:21:24',0,NULL),(108,1,'//@有田十三: @Ice1017 @飞翔的狗哥 @田小冰 //@Ice1017: @飞翔的狗哥//@强强: @涛苑','2011-12-01 12:59:01',96,NULL),(110,1,'[鄙视][给力][奥特曼]','2011-12-02 21:50:09',0,NULL),(111,3,'嘿嘿。','2011-12-10 16:50:15',0,NULL),(112,2,'[伤心]//@有田十三: //@有田十三: @Ice1017 @飞翔的狗哥 @田小冰 //@Ice1017: @飞翔的狗哥//@强强: @涛苑','2011-12-10 17:01:18',97,NULL),(114,3,'两个快乐的小二逼。[扣鼻屎]','2011-12-10 17:35:06',0,'114.jpg'),(115,1,'@有田十三','2011-12-10 20:19:46',101,NULL),(116,12,'[懒得理你]//@有田十三: @有田十三','2011-12-10 20:20:31',102,NULL),(117,9,'[奥特曼]//@有田十三: @有田十三','2011-12-10 22:59:05',104,NULL),(118,16,'很开心，很好玩！！！','2011-12-10 23:36:52',0,NULL),(119,16,'呀呀呀','2011-12-10 23:40:31',105,NULL),(120,16,'[扣鼻屎]','2011-12-10 23:43:28',0,NULL),(121,17,'开始测试','2011-12-11 00:49:06',0,NULL),(123,17,'SB 傅鸟毛 要来搞破坏','2011-12-11 01:10:52',0,NULL),(124,17,'//@有田十三: @有田十三','2011-12-11 01:18:32',109,NULL),(125,18,'顺便说点什么吧...','2011-12-11 01:19:23',112,NULL),(126,1,'[围观]@nbfujx','2011-12-11 01:21:15',113,NULL),(127,18,'你妹的没删除功能','2011-12-11 01:23:04',0,NULL),(129,18,'//@nbfujx: 顺便说点什么吧...','2011-12-11 01:23:43',115,NULL),(130,17,'//@薛弟: //@有田十三: @有田十三','2011-12-11 01:30:40',116,NULL),(131,1,'美女分享','2011-12-11 22:06:46',0,'131.jpg'),(132,5,'多多关照。[哈哈]','2011-12-14 13:55:16',0,'132.jpg'),(133,9,'薇薇薇薇。。。。。[花心][花心][花心]','2011-12-14 14:06:31',0,NULL),(139,3,'[哈哈]@有田十三','2011-12-17 22:25:58',0,NULL),(140,27,'[阴险]薛薛有没有上微博啊?','2011-12-19 15:34:15',0,NULL),(141,26,'屁都么有 太烂了 ','2011-12-19 15:35:03',0,NULL),(142,29,'hello weibo','2011-12-19 15:42:16',0,NULL),(143,29,'来测试//@有田十三: [围观]@nbfujx','2011-12-19 15:43:07',150,NULL),(144,29,'@有田十三 hello world','2011-12-19 15:45:08',0,NULL),(145,1,'[奥特曼]Thx for your advise','2011-12-19 15:46:07',151,NULL),(146,28,'hello everybody！','2011-12-19 15:47:28',0,NULL),(147,28,'顺便说点什么吧...','2011-12-19 15:47:35',152,NULL),(148,30,'我的身份证是000000000000000000','2011-12-19 16:00:16',0,NULL),(151,31,'[给力]','2011-12-19 19:28:03',0,NULL),(157,31,'[给力][鄙视][讨厌][嘿嘿][懒得理你][扣鼻屎][伤心][哈哈][阴险]','2011-12-19 19:51:46',0,NULL),(172,32,'我又来了[嘿嘿]','2011-12-19 21:27:16',0,NULL),(173,32,'[懒得理你]呵呵','2011-12-19 21:30:03',0,NULL),(174,27,'薛海峰,你好啊!!!','2011-12-19 22:44:19',0,NULL),(180,32,'//@薛弟: //@薛弟: //@有田十三: @有田十三','2011-12-20 19:49:42',181,NULL),(181,1,'[图片分享]','2011-12-21 17:12:17',0,'181.png'),(184,7,'[花心]','2011-12-21 17:52:09',184,NULL),(186,5,'模拟数据也有到位噢亲。[哈哈]','2011-12-21 17:53:31',0,NULL),(189,3,'[给力]@有田十三','2011-12-22 02:40:42',0,'189.jpg'),(191,31,'呀呀','2011-12-22 12:56:42',0,'191.jpg'),(193,1,'[奥特曼][花心][扣鼻屎][哈哈]','2011-12-22 18:05:50',0,NULL),(195,32,'顺便说点什么吧...','2011-12-22 22:46:14',188,NULL),(196,32,'[围观]233[奥特曼][给力]','2011-12-22 23:10:22',0,NULL),(197,32,'[围观]','2011-12-24 21:49:03',189,NULL);
/*Table structure for table `transmit_collection` */
DROP TABLE IF EXISTS `transmit_collection`;
CREATE TABLE `transmit_collection` (
`tcId` int(11) NOT NULL AUTO_INCREMENT,
`tcTime` datetime NOT NULL,
`tcProfId` int(11) NOT NULL,
`tcFrom` int(11) NOT NULL,
`tcOriginal` int(11) DEFAULT NULL,
PRIMARY KEY (`tcId`),
KEY `FK_Reference_6` (`tcProfId`),
KEY `FK_Reference_7` (`tcFrom`),
CONSTRAINT `FK_Reference_6` FOREIGN KEY (`tcProfId`) REFERENCES `profile` (`profId`),
CONSTRAINT `FK_Reference_7` FOREIGN KEY (`tcFrom`) REFERENCES `userinfo` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8;
/*Data for the table `transmit_collection` */
insert into `transmit_collection`(`tcId`,`tcTime`,`tcProfId`,`tcFrom`,`tcOriginal`) values (6,'2011-11-14 20:59:03',35,1,0),(18,'2011-11-15 21:25:44',43,1,0),(20,'2011-11-15 21:25:46',40,1,0),(21,'2011-11-15 21:25:48',37,1,0),(22,'2011-11-15 21:25:49',36,1,0),(23,'2011-11-15 21:26:01',19,1,0),(25,'2011-11-15 21:26:03',21,1,0),(26,'2011-11-15 21:26:03',18,1,0),(29,'2011-11-15 21:59:13',45,1,0),(30,'2011-11-15 22:02:01',38,1,0),(31,'2011-11-15 22:03:45',37,2,0),(33,'2011-11-17 12:22:44',48,1,0),(40,'2011-11-18 23:22:34',54,1,56),(41,'2011-11-18 23:22:34',56,1,54),(42,'2011-11-21 22:58:45',63,1,63),(47,'2011-11-21 23:44:04',68,1,57),(49,'2011-11-21 23:50:10',69,1,69),(50,'2011-11-22 00:11:45',70,1,70),(56,'2011-11-22 23:19:25',72,1,70),(57,'2011-11-22 23:20:09',74,2,70),(58,'2011-11-24 00:15:52',75,1,70),(63,'2011-11-25 00:26:04',76,1,0),(64,'2011-11-25 00:27:23',76,1,70),(65,'2011-11-25 00:27:47',77,1,0),(67,'2011-11-25 22:01:18',39,1,39),(68,'2011-11-27 21:05:11',79,12,39),(69,'2011-11-27 22:11:59',84,1,84),(70,'2011-11-27 22:12:21',85,9,84),(71,'2011-11-27 22:47:46',86,4,0),(73,'2011-11-29 20:49:30',86,1,84),(74,'2011-11-29 22:01:21',78,1,0),(75,'2011-11-29 23:07:47',88,1,88),(76,'2011-11-29 23:16:06',89,2,88),(78,'2011-11-30 00:43:57',91,1,91),(79,'2011-11-30 00:49:11',91,14,91),(80,'2011-11-30 00:51:51',55,13,55),(83,'2011-11-30 22:57:59',88,1,88),(85,'2011-11-30 23:17:07',91,1,91),(86,'2011-11-30 23:18:03',100,14,91),(87,'2011-12-01 00:04:16',101,1,91),(88,'2011-12-01 00:04:54',102,14,91),(89,'2011-12-01 00:05:39',94,14,55),(90,'2011-12-01 00:06:23',94,14,55),(91,'2011-12-01 00:08:42',105,1,55),(94,'2011-12-01 12:38:05',103,1,0),(95,'2011-12-01 12:47:04',107,1,0),(96,'2011-12-01 12:59:01',106,1,55),(97,'2011-12-10 17:01:18',108,2,55),(99,'2011-12-10 17:36:58',69,3,0),(101,'2011-12-10 20:19:46',114,1,114),(102,'2011-12-10 20:20:31',115,12,114),(103,'2011-12-10 20:57:28',116,1,0),(104,'2011-12-10 22:59:05',115,9,114),(105,'2011-12-10 23:40:31',118,16,118),(106,'2011-12-10 23:42:44',119,16,0),(107,'2011-12-11 01:07:42',121,1,0),(109,'2011-12-11 01:18:32',115,17,114),(110,'2011-12-11 01:19:05',124,17,0),(111,'2011-12-11 01:19:09',84,18,0),(112,'2011-12-11 01:19:23',84,18,84),(113,'2011-12-11 01:21:15',123,1,123),(115,'2011-12-11 01:23:43',127,18,127),(116,'2011-12-11 01:30:40',124,17,114),(118,'2011-12-13 00:47:27',22,1,0),(119,'2011-12-14 14:06:08',132,9,0),(140,'2011-12-15 20:09:33',114,1,0),(145,'2011-12-15 23:21:53',93,1,0),(147,'2011-12-18 01:09:34',139,1,0),(148,'2011-12-18 20:22:33',124,1,0),(149,'2011-12-19 02:10:28',133,1,0),(150,'2011-12-19 15:43:07',126,29,123),(151,'2011-12-19 15:46:07',144,1,144),(152,'2011-12-19 15:47:35',146,28,146),(153,'2011-12-19 17:14:31',145,31,0),(158,'2011-12-19 19:58:35',157,31,0),(175,'2011-12-19 23:00:51',151,31,0),(180,'2011-12-20 19:48:04',130,32,0),(181,'2011-12-20 19:49:41',130,32,114),(183,'2011-12-20 23:56:52',112,1,0),(184,'2011-12-22 17:52:09',131,7,131),(185,'2011-12-23 02:36:13',131,1,0),(186,'2011-12-22 18:06:04',189,1,0),(189,'2011-12-24 21:49:03',181,32,181);
/*Table structure for table `userinfo` */
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`loginName` varchar(12) NOT NULL,
`nickName` varchar(12) NOT NULL,
`trueName` varchar(8) DEFAULT NULL,
`Province` varchar(12) NOT NULL,
`City` varchar(12) NOT NULL,
`Sex` varchar(3) NOT NULL,
`Birthday` date DEFAULT NULL,
`Email` varchar(20) DEFAULT NULL,
`QQ` varchar(12) DEFAULT NULL,
`MSN` varchar(12) DEFAULT NULL,
`introduce` varchar(20) DEFAULT NULL,
`identifier` varchar(20) DEFAULT NULL,
`schoolType` bigint(20) DEFAULT NULL,
`schoolName` varchar(20) DEFAULT NULL,
`college` varchar(20) DEFAULT NULL,
`schoolTime` bigint(20) DEFAULT NULL,
`workProv` varchar(12) DEFAULT NULL,
`workCity` varchar(12) DEFAULT NULL,
`workplace` varchar(20) DEFAULT NULL,
`workTimeFrom` bigint(20) DEFAULT NULL,
`workTimeTo` bigint(20) DEFAULT NULL,
`department` varchar(12) DEFAULT NULL,
`tag` varchar(50) DEFAULT NULL,
`comPower` tinyint(1) DEFAULT NULL,
`msgPower` tinyint(1) DEFAULT NULL,
`searchPower` tinyint(1) DEFAULT NULL,
`blacklist` varchar(50) DEFAULT NULL,
`myFace` varchar(30) DEFAULT NULL,
`regTime` datetime NOT NULL,
PRIMARY KEY (`userId`),
KEY `FK_Reference_2` (`loginName`),
CONSTRAINT `FK_Reference_2` FOREIGN KEY (`loginName`) REFERENCES `login` (`loginName`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*Data for the table `userinfo` */
insert into `userinfo`(`userId`,`loginName`,`nickName`,`trueName`,`Province`,`City`,`Sex`,`Birthday`,`Email`,`QQ`,`MSN`,`introduce`,`identifier`,`schoolType`,`schoolName`,`college`,`schoolTime`,`workProv`,`workCity`,`workplace`,`workTimeFrom`,`workTimeTo`,`department`,`tag`,`comPower`,`msgPower`,`searchPower`,`blacklist`,`myFace`,`regTime`) values (1,'titan','有田十三','田泱','山西','阳泉','1','2011-12-21','61123072@qq.com','61123072',NULL,'牛逼不需解释。','140303198909040032',1,'湖南大学','软件学院',2008,'广东',NULL,'华为云计算研究中心',2008,2011,'GUI','',0,0,1,NULL,'/Weibo/Images/Faces/1.jpg','2011-12-17 22:25:58'),(2,'fty','涛苑','樊涛','直辖市','天津','1','2011-11-17',NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/2.jpg','2011-12-17 22:25:58'),(3,'pp','田小冰','田冰','青海','格尔木','2','2010-12-01','','','','有田十三有田十三有田十三！！','140303198909040032',1,'湖南大学','金融学院',2009,'广东','深圳','中国光大银行',2009,2011,'市场企划',NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/3.jpg','2011-12-17 22:25:58'),(4,'ssg','守刚球带饭','盛守刚','黑龙江','七台河','1','2000-07-01','644140554@qq.com','644140554','','轻轻地我能了，正如我的地盘听我的。','140303198909040032',2,'阳泉市第一中学','你妹的高中哪来的院系啊。',2009,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/4.jpg','2011-12-17 22:25:58'),(5,'ss','薇薇','杨雅雯','湖南','株洲','2','2010-12-01','','','','怎么个事这算。为什么上课时举手很难？','140303198909040032',NULL,'湖南大学','广播影视艺术学院',2009,'湖南省','长沙市','金鹰卫视',0,NULL,'播音主持',NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/5.jpg','2011-12-17 22:25:58'),(7,'tb','豆沙包',NULL,'河南','驻马店','2',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/7.jpg','2011-12-17 22:25:58'),(8,'wangyu','铅笔','','浙江','金华','1','2011-11-26','','','','','140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/8.png','2011-12-17 22:25:58'),(9,'caoqiuyan','飞翔的狗哥',NULL,'吉林','吉林','1',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/9.jpg','2011-12-17 22:25:58'),(10,'chenmu','陈沐不是沉木','陈沐','内蒙古','乌海','1','2011-11-29','736646709@qq.com','61123073','','求测试啊。。。','140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-17 22:25:58'),(11,'shougang','守刚守刚棒棒的',NULL,'山东','青岛','1',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-17 22:25:58'),(12,'liuniaochi','鱼翅刘',NULL,'江苏','淮安','1',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/12.jpg','2011-12-17 22:25:58'),(13,'qiangge','强强',NULL,'广东','梅州','2',NULL,NULL,NULL,NULL,NULL,'110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-17 22:25:58'),(14,'Ice1017','Ice1017','bing','山西','太原','1','2011-08-01','','','','aio``','412822199103057984',1,'','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/14.jpg','2011-12-17 22:25:58'),(15,'yinxiao','淫笑',NULL,'浙江','嘉兴','1',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-17 22:25:58'),(16,'yunyun_520','紫菱',NULL,'湖南','长沙','2',NULL,NULL,NULL,NULL,NULL,'632126198910091824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'娃儿',NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/16.gif','2011-12-17 22:25:58'),(17,'xuexue','薛弟','薛海锋','广西','柳州','1','1990-10-17','125843597@qq.com','125843597','','越测越牛B','450204199010170312',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/17.jpg','2011-12-17 22:25:58'),(18,'nbfujx','nbfujx',NULL,'浙江','宁波','1',NULL,NULL,NULL,NULL,NULL,'1234567',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-17 22:25:58'),(22,'zxingxing','雨柔',NULL,'山西','长治','2','1993-10-17','336458412@qq.com','336458412',NULL,'唐雨柔国产单机RPG游戏《仙剑奇侠传五》','140303198909040032',NULL,'净天教','天舞尊者',384,NULL,NULL,'青荷镇',NULL,NULL,'唐府',NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/22.jpg','2011-12-17 22:25:58'),(23,'xugang','风骚的走位',NULL,'广东','梅州','1',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/23.jpg','2011-12-17 22:25:58'),(24,'zengge','曾轶可','','湖南','常德','1','2011-12-22','','',NULL,'霸气纯爷们，铁血真汉子。','140303198909040032',1,'吉林华桥外国语学院','外国语学院',2009,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/24.jpg','2011-12-17 22:25:58'),(25,'gaoqian','钱钱不是万能的',NULL,'广东','阳江','2',NULL,NULL,NULL,NULL,NULL,'140303198909040032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/25.jpg','2011-12-17 22:25:58'),(26,'njzydj999','李栋','李栋','陕西','我哪知道','1','2011-12-19',NULL,NULL,NULL,NULL,'140303198909090032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-19 15:15:00'),(27,'yin_xiao','我是淫笑我怕谁',NULL,'浙江','宁波','2',NULL,NULL,NULL,NULL,NULL,'199011234567566',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-19 15:32:42'),(28,'jacqueline1','香北',NULL,'湖南','长沙','2',NULL,NULL,NULL,NULL,NULL,'460200199107060000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-19 15:36:16'),(29,'stongan','stongan',NULL,'湖南','长沙','1',NULL,NULL,NULL,NULL,NULL,'348576477584854456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-19 15:41:40'),(30,'shentong','shentong','','直辖市','北京','1','2011-12-22','','',NULL,'','000000000000000000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-19 15:59:27'),(31,'yunyun','呵呵','谷谷','湖南','长沙','2','2011-12-19','854520810@qq.com','854520810',NULL,'呀呀','632126198910091824',1,'湖南大学','软件学院',0,'湖南',NULL,'湖南大学软件学院',2009,9999,'软件学院',NULL,1,1,1,NULL,'/Weibo/Images/Faces/31.jpg','2011-12-19 17:09:48'),(32,'20091610525','薛弟弟','','直辖市','北京','1','2011-12-22','','',NULL,'','450204111111111111',1,'','',2002,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/32.jpg','2011-12-19 21:23:33'),(33,'20091610524','岗港',NULL,'新疆','乌鲁木齐','1',NULL,NULL,NULL,NULL,NULL,'450204111111111111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-19 23:13:56'),(34,'ftyfty','beaman',NULL,'直辖市','天津','1',NULL,NULL,NULL,NULL,NULL,'123456789012345',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-20 23:34:41'),(35,'qhyjj123','huang123',NULL,'直辖市','北京','1',NULL,NULL,NULL,NULL,NULL,'50010219901112025X',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/boy.gif','2011-12-21 22:10:37'),(36,'fangjiajia','敏敏',NULL,'湖南','长沙','2',NULL,NULL,NULL,NULL,NULL,'632126198910091824',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/Weibo/Images/Faces/girl.gif','2011-12-22 13:34:37');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;