forked from tolinks/oo
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathops.sql
155 lines (109 loc) · 48.7 KB
/
ops.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
/*
SQLyog Enterprise - MySQL GUI v7.11
MySQL - 5.0.90 -community-nt : Database - ops
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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' */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ops` /*!40100 DEFAULT CHARACTER SET ucs2 */;
/*Table structure for table `action` */
DROP TABLE IF EXISTS `action`;
CREATE TABLE `action` (
`id` int(10) unsigned zerofill NOT NULL auto_increment COMMENT '动作名称（例如增加，删除）',
`path` varchar(200) NOT NULL COMMENT '相对于主目录的路径',
`createTime` datetime NOT NULL COMMENT '创建时间',
`moduleId` int(11) default NULL,
`actionName` varchar(200) default NULL,
`orders` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
/*Data for the table `action` */
insert into `action`(`id`,`path`,`createTime`,`moduleId`,`actionName`,`orders`) values (0000000053,'manage/user-manage!checkUserName.action','2010-07-21 15:47:49',14,'检测用户名',9),(0000000049,'manage/user-manage!setRoleByUser.action','2010-07-21 15:45:11',14,'分配权限',5),(0000000050,'manage/user-manage!toSetRoleByUser.action','2010-07-21 15:46:02',14,'去分配权限',7),(0000000051,'manage/user-manage!toAlter.action','2010-07-21 15:47:07',14,'去修改用户',6),(0000000046,'manage/user-manage!delete.action','2010-07-21 15:44:08',14,'删除人员',2),(0000000047,'manage/user-manage!alter.action','2010-07-21 15:44:32',14,'修改人员',3),(0000000048,'manage/user-manage.action','2010-07-21 15:44:47',14,'查询人员',4),(0000000052,'manage/user-manage!login.action','2010-07-21 15:47:32',14,'后台登录',8),(0000000045,'manage/user-manage!save.action','2010-07-21 15:43:29',14,'增加人员',1),(0000000037,'manage/role-manage!save.action','2010-07-21 15:29:01',11,'增加角色',1),(0000000038,'manage/role-manage!delete.action','2010-07-21 15:29:31',11,'删除角色',2),(0000000039,'manage/role-manage!alter.action','2010-07-21 15:30:02',11,'修改角色',3),(0000000040,'manage/role-manage.action','2010-07-21 15:31:23',11,'查询角色',4),(0000000041,'manage/role-manage!toAlter.action','2010-07-21 15:32:19',11,'去修改角色',5),(0000000042,'manage/role-manage!setActionByRole.action','2010-07-21 15:33:12',11,'分配权限',6),(0000000043,'manage/role-manage!toSetActionByRole.action','2010-07-21 15:33:37',11,'去分配权限',7),(0000000054,'manage/module-manage!save.action','2010-07-21 15:49:24',12,'增加模块',1),(0000000055,'manage/module-manage!delete.action','2010-07-21 15:50:03',12,'删除模块',2),(0000000056,'manage/module-manage!delete.action','2010-07-21 15:54:40',12,'删除模块',2),(0000000057,'manage/module-manage!alter.action','2010-07-21 15:54:56',12,'修改模块',3),(0000000058,'manage/module-manage.action','2010-07-21 15:55:12',12,'查询模块',4),(0000000059,'manage/module-manage!toAlter.action','2010-07-21 15:55:53',12,'去修改模块',5),(0000000060,'manage/action-manage!save.action','2010-07-21 15:56:40',13,'增加权限',1),(0000000061,'manage/action-manage!alter.action','2010-07-21 15:57:07',13,'修改权限',3),(0000000062,'manage/action-manage!delete.action','2010-07-21 15:57:22',13,'删除权限',2),(0000000063,'manage/action-manage.action','2010-07-21 15:58:19',13,'查询权限',4),(0000000064,'manage/action-manage!toAlter.action','2010-07-21 15:59:10',13,'去修改权限',5),(0000000065,'manage/action-manage!toSave.action','2010-07-21 15:59:28',13,'去保存权限',6),(0000000066,'manage/role-manage!toSetMenuByRole.action','2010-07-27 17:01:11',11,'去分配菜单',8),(0000000067,'manage/role-manage!setMenuByRole.action','2010-07-27 17:01:44',11,'分配菜单',9),(0000000068,'manage/menu-manage.action','2010-07-27 17:14:47',17,'查询菜单',4),(0000000069,'manage/menu-manage!save.action','2010-07-27 17:15:50',17,'增加菜单',1),(0000000070,'manage/menu-manage!delete.action','2010-07-27 17:16:20',17,'删除菜单',2),(0000000071,'manage/menu-manage!alter.action','2010-07-27 17:16:45',17,'修改菜单',3),(0000000072,'manage/menu-manage!toAlter.action','2010-07-27 17:17:22',17,'去修改菜单',6),(0000000073,'manage/menu-manage!toSave.action','2010-07-27 17:24:22',17,'去增加菜单',5),(0000000075,'manage/role-manage!updateCacheByRole.action','2010-07-28 10:48:20',11,'更新角色缓存',10),(0000000076,'manage/user-manage!loginOut.action','2010-07-28 11:25:48',14,'登出',10);
/*Table structure for table `menu` */
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`id` int(11) NOT NULL auto_increment COMMENT '菜单自动增长id',
`menuName` varchar(50) NOT NULL COMMENT '显示名称',
`parentId` int(11) default NULL COMMENT '父id',
`url` varchar(100) default NULL COMMENT '链接url',
`imageUrl` varchar(100) default NULL COMMENT '图片url',
`dept` int(11) default NULL COMMENT '第几层，方便查询',
`createTime` datetime default NULL COMMENT '创建时间',
`orders` varchar(11) NOT NULL default '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=ucs2;
/*Data for the table `menu` */
insert into `menu`(`id`,`menuName`,`parentId`,`url`,`imageUrl`,`dept`,`createTime`,`orders`) values (4,'用户管理',0,'','',0,'2010-07-23 00:00:00','1'),(5,'人员管理',4,'manage/user-manage.action','',0,'2010-07-23 00:00:00','1.1'),(6,'角色管理',4,'manage/role-manage.action','',0,'2010-07-23 00:00:00','1.2'),(7,'模块管理',4,'manage/module-manage.action','',0,'2010-07-23 00:00:00','1.3'),(8,'权限管理',4,'manage/action-manage.action','',0,'2010-07-23 00:00:00','1.4'),(9,'菜单管理',4,'manage/menu-manage.action','',0,'2010-07-23 00:00:00','1.5'),(10,'日程管理',0,'','',0,'2010-07-23 00:00:00','2'),(11,'我的日程',10,'','',0,'2010-07-23 00:00:00','2.1'),(12,'测试',10,'','',0,'2010-07-23 16:16:41','2.2'),(13,'测试1',12,'','',0,'2010-07-23 17:02:14','2.2.1'),(14,'测试2',13,'','',0,'2010-07-23 17:09:16','2.2.1.1');
/*Table structure for table `module` */
DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
`id` int(11) NOT NULL auto_increment,
`moduleName` varchar(765) NOT NULL,
`moduleInfo` text,
`createTime` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*Data for the table `module` */
insert into `module`(`id`,`moduleName`,`moduleInfo`,`createTime`) values (14,'人员管理','人员的基本信息管理','2010-07-21 15:42:41'),(11,'角色管理','管理角色的基本信息','2010-07-20 17:03:27'),(12,'模块管理','管理模块的基本信息','2010-07-20 17:03:45'),(13,'权限管理','管理权限的基本信息','2010-07-20 17:04:07'),(17,'菜单管理','菜单的基本信息管理','2010-07-27 17:13:08');
/*Table structure for table `role` */
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL auto_increment COMMENT 'id',
`roleName` varchar(20) NOT NULL COMMENT '角色名称',
`roleInfo` text COMMENT '角色介绍',
`createTime` datetime default NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
/*Data for the table `role` */
insert into `role`(`id`,`roleName`,`roleInfo`,`createTime`) values (20,'admin','系统管理员','2010-05-18 13:44:23'),(39,'测试','测试','2010-07-23 16:00:43');
/*Table structure for table `roleaction` */
DROP TABLE IF EXISTS `roleaction`;
CREATE TABLE `roleaction` (
`roleId` int(11) NOT NULL COMMENT '角色Id',
`actionId` varchar(50) NOT NULL COMMENT '关联action中的action',
KEY `FK_bbs_roleaction` (`roleId`),
KEY `FK_bbs_roleaction1` (`actionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
/*Data for the table `roleaction` */
insert into `roleaction`(`roleId`,`actionId`) values (39,'54'),(39,'51'),(20,'59'),(20,'75'),(20,'54'),(20,'55'),(20,'63'),(20,'56'),(20,'62'),(20,'76'),(20,'66'),(20,'43'),(20,'73'),(20,'45'),(20,'37'),(20,'69'),(20,'71'),(20,'40'),(20,'52'),(20,'64'),(20,'42'),(20,'48'),(20,'58'),(20,'57'),(20,'60'),(20,'47'),(20,'67'),(20,'61'),(20,'72'),(39,'67'),(39,'66'),(39,'52'),(39,'63'),(39,'64'),(39,'65'),(39,'40'),(39,'43'),(39,'38'),(39,'48'),(39,'57'),(39,'47'),(39,'62'),(39,'58'),(39,'75'),(39,'39'),(39,'55'),(39,'45'),(39,'61'),(39,'41'),(39,'53'),(39,'56'),(39,'50'),(39,'42'),(39,'60'),(39,'46'),(20,'70'),(20,'46'),(20,'49'),(20,'51'),(20,'68'),(20,'41'),(20,'38'),(20,'65'),(20,'50'),(20,'39'),(39,'49'),(39,'59'),(20,'53'),(39,'37');
/*Table structure for table `rolemenu` */
DROP TABLE IF EXISTS `rolemenu`;
CREATE TABLE `rolemenu` (
`roleId` int(11) default NULL,
`menuId` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=ucs2;
/*Data for the table `rolemenu` */
insert into `rolemenu`(`roleId`,`menuId`) values (20,9),(20,11),(20,4),(20,5),(20,7),(20,6),(20,8),(20,12),(20,14),(20,13),(20,10),(39,6),(39,10),(39,11),(39,4),(39,9);
/*Table structure for table `userinfo` */
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`id` int(11) unsigned zerofill NOT NULL auto_increment COMMENT '自动增长Id',
`userName` varchar(20) NOT NULL COMMENT '用户名',
`userPassword` varchar(20) NOT NULL COMMENT '用户密码',
`sex` varchar(2) default NULL COMMENT '性别 1为男，2为女',
`email` varchar(20) default NULL COMMENT 'email',
`qq` varchar(11) default NULL COMMENT 'qq',
`isEnable` int(11) default NULL COMMENT '是否可用',
`online` bigint(20) default '0' COMMENT '在线时长',
`Score` int(11) default '0' COMMENT '积分',
`createTime` datetime NOT NULL COMMENT '注册时间',
`content` text COMMENT '个性签名',
`isBetter` int(11) NOT NULL default '0' COMMENT '是否为高级用户 1是 0 为不是高级用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=415 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
/*Data for the table `userinfo` */
insert into `userinfo`(`id`,`userName`,`userPassword`,`sex`,`email`,`qq`,`isEnable`,`online`,`Score`,`createTime`,`content`,`isBetter`) values (00000000002,'admin','jianguo^&*(98',NULL,NULL,NULL,NULL,0,0,'2010-04-02 12:12:12',NULL,1),(00000000001,'天天网友','asdf','1','jiege82000@163.com','1234234234',NULL,0,0,'2010-04-15 17:00:00','爱上对方撒地方撒地方色地方',0),(00000000007,'254640332','4789602708',NULL,'254640332@qq.com','254640332',NULL,0,NULL,'2010-04-17 22:17:52',NULL,0),(00000000008,'13820402455','15030845155','1','jiege82000@163.com','410511791',NULL,0,NULL,'2010-04-17 22:42:03','描述中......未曾。。。色地方',0),(00000000010,'wei24551','wei24551',NULL,'','QQ421813889',NULL,0,NULL,'2010-04-19 02:02:22',NULL,0),(00000000012,'kingking9342','336699',NULL,'','364923543',NULL,0,NULL,'2010-04-19 10:58:23',NULL,0),(00000000013,'asdf','asdf',NULL,'','1234567',NULL,0,NULL,'2010-04-21 18:15:14',NULL,0),(00000000015,'13793449678','13793449678',NULL,'','472017171',NULL,0,NULL,'2010-04-22 06:43:52',NULL,0),(00000000413,'aa','bb','1','jiege82000@163.com','',NULL,0,NULL,'2010-07-21 16:16:20','这家伙很懒，什么都没有留下。',0),(00000000019,'香烟燃着寂寞','26997154',NULL,'WJGX8730@163.com','542329874',NULL,0,NULL,'2010-04-23 16:36:26',NULL,0),(00000000020,'506524485','5686913202',NULL,'506524485@qq.com','5686913202',NULL,0,NULL,'2010-04-23 18:09:55',NULL,0),(00000000058,'20088002','hongnv2008',NULL,'','hongnv2008',NULL,0,NULL,'2010-04-28 14:08:42',NULL,0),(00000000023,'zsn0814','zsnn',NULL,'','846457928',NULL,0,NULL,'2010-04-23 19:51:34',NULL,0),(00000000024,'guye1023','ght901003',NULL,'guye1023@163.com','379887523',NULL,0,NULL,'2010-04-23 21:41:09',NULL,0),(00000000028,'13581658354','13581058354',NULL,'','13581058354',NULL,0,NULL,'2010-04-24 00:19:25',NULL,0),(00000000029,'我有我的快乐','19870128',NULL,'','13911690448',NULL,0,NULL,'2010-04-24 02:14:54',NULL,0),(00000000030,'360688510','123456',NULL,'360688510@qq.COM','360688510',NULL,0,NULL,'2010-04-24 02:30:06',NULL,0),(00000000032,'947055832','st4a11s6d10e4g',NULL,'','18771709434',NULL,0,NULL,'2010-04-24 17:25:34',NULL,0),(00000000033,'874962642','Qq13318904909',NULL,'','15024051553',NULL,0,NULL,'2010-04-24 20:38:20',NULL,0),(00000000034,'78148069','531963444',NULL,'aa13728103928@qq.com','13410346030',NULL,0,NULL,'2010-04-24 22:52:59',NULL,0),(00000000035,'906065313','12345',NULL,'906065313qq@.com','15101159765',NULL,0,NULL,'2010-04-24 23:28:16',NULL,0),(00000000036,'xinyuncao','82976171',NULL,'zggayesong@163.com','664886144',NULL,0,NULL,'2010-04-25 15:28:37',NULL,0),(00000000037,'song','8907519',NULL,'844344657@qq.com','8907519',NULL,0,NULL,'2010-04-25 20:25:39',NULL,0),(00000000038,'13787101100','101100',NULL,'','GG',NULL,0,NULL,'2010-04-25 22:49:23',NULL,0),(00000000039,'318729056','506151584',NULL,'249704856@qq.com','249704856',NULL,0,NULL,'2010-04-25 23:39:35',NULL,0),(00000000040,'msjy','msjy',NULL,'','1156300422',NULL,0,NULL,'2010-04-26 00:31:41',NULL,0),(00000000041,'play840307','zhao840307',NULL,'tang532437@126.com','296329500',NULL,0,NULL,'2010-04-26 08:15:34',NULL,0),(00000000042,'家里人大政协','4471106',NULL,'','1010740310',NULL,0,NULL,'2010-04-26 12:02:20',NULL,0),(00000000043,'xtso520ok','xtso86',NULL,'xtso520ok@163.com','719730391',NULL,0,NULL,'2010-04-26 13:58:41',NULL,0),(00000000044,'ml830629','830629',NULL,'ml830629@163.com','279112367',NULL,0,NULL,'2010-04-26 14:57:40',NULL,0),(00000000045,'15179359137','334106',NULL,'','251101264',NULL,0,NULL,'2010-04-26 17:38:04',NULL,0),(00000000047,'15963','15963',NULL,'','352931953',NULL,0,NULL,'2010-04-26 21:24:21',NULL,0),(00000000048,'wanglei','1127',NULL,'645051683@qq.com','645051683',NULL,0,NULL,'2010-04-26 22:09:29',NULL,0),(00000000049,'303728036','328623271',NULL,'','303728036',NULL,0,NULL,'2010-04-26 23:14:55',NULL,0),(00000000050,'482444H','huaii',NULL,'','945847093',NULL,0,NULL,'2010-04-26 23:57:05',NULL,0),(00000000051,'snoont','7793825',NULL,'snoont@tom.com','263519270',NULL,0,NULL,'2010-04-27 09:12:46',NULL,0),(00000000052,'llpchf','123456789',NULL,'llpchf.love@163.com','584746862',NULL,0,NULL,'2010-04-27 10:41:56',NULL,0),(00000000053,'天天听听歌','689555',NULL,'','317710014',NULL,0,NULL,'2010-04-27 13:30:55',NULL,0),(00000000054,'406067359','85117645',NULL,'','406067359',NULL,0,NULL,'2010-04-27 23:28:19',NULL,0),(00000000055,'A11010','584520',NULL,'','529739267',NULL,0,NULL,'2010-04-28 07:51:07',NULL,0),(00000000056,'lovezheng','woaini',NULL,'519287787@qq.com','519287787',NULL,0,NULL,'2010-04-28 08:14:13',NULL,0),(00000000057,'A5722240','0000',NULL,'','0000',NULL,0,NULL,'2010-04-28 08:38:51',NULL,0),(00000000059,'671454331','63297427',NULL,'','371496648',NULL,0,NULL,'2010-04-28 14:09:32',NULL,0),(00000000060,'172944186','172944186',NULL,'','172944186',NULL,0,NULL,'2010-04-28 16:10:35',NULL,0),(00000000061,'74265247464','7426524',NULL,'','694262502',NULL,0,NULL,'2010-04-28 16:29:26',NULL,0),(00000000062,'shitou','19860428liuCOM..',NULL,NULL,NULL,NULL,0,0,'2010-04-28 18:07:22',NULL,0),(00000000063,'我是宋哲','578919976',NULL,'578919976@qq.com','578919976',NULL,0,NULL,'2010-04-28 20:07:14',NULL,0),(00000000064,'音乐我爱听',' 4932278886',NULL,'','493227886',NULL,0,NULL,'2010-04-28 20:36:05',NULL,0),(00000000065,' 041331','1331',NULL,'','511713680',NULL,0,NULL,'2010-04-28 20:36:48',NULL,0),(00000000066,'041331','1331',NULL,'','511713680',NULL,0,NULL,'2010-04-28 20:39:23',NULL,0),(00000000067,'爱听音乐','cy14617',NULL,'1113822707@qq.com','1113822707',NULL,0,NULL,'2010-04-28 20:54:54',NULL,0),(00000000068,'wzw2lt','326819',NULL,'16475065@qq.com','164757065',NULL,0,NULL,'2010-04-28 21:24:31',NULL,0),(00000000069,'434971561','qingshang@82151',NULL,'','434971561',NULL,0,NULL,'2010-04-28 21:46:09',NULL,0),(00000000070,'慕容小鹏','852088',NULL,'379060111@QQ.COM','852088',NULL,0,NULL,'2010-04-28 22:08:02',NULL,0),(00000000071,'hby8201210','hby8201210',NULL,'','120142134',NULL,0,NULL,'2010-04-28 22:30:55',NULL,0),(00000000072,'☆夏のあ','709394',NULL,'','503143461',NULL,0,NULL,'2010-04-28 22:44:32',NULL,0),(00000000073,'wh358','1986824',NULL,'912567363@qq.com','912567363',NULL,0,NULL,'2010-04-28 23:01:39',NULL,0),(00000000075,'lzq8712','123465',NULL,'lzq8712@163.com','120968071',NULL,0,NULL,'2010-04-28 23:06:01',NULL,0),(00000000076,'puk1234567','137886400',NULL,'msn1234567msn@msn.cn','357496345',NULL,0,NULL,'2010-04-28 23:07:49',NULL,0),(00000000077,'012150','012150',NULL,'','13824375784',NULL,0,NULL,'2010-04-28 23:15:39',NULL,0),(00000000078,'a passerby','13877411604',NULL,'','149147233',NULL,0,NULL,'2010-04-29 00:30:55',NULL,0),(00000000079,'314388939','wploveforever',NULL,'314388939@qq.com','314388939',NULL,0,NULL,'2010-04-29 00:52:24',NULL,0),(00000000080,'41316064','41316064',NULL,'','41316064',NULL,0,NULL,'2010-04-29 01:23:39',NULL,0),(00000000081,'13620525368','fjw19910724',NULL,'a825686115@qq.com','825686115',NULL,0,NULL,'2010-04-29 02:00:21',NULL,0),(00000000082,'xiang','123456',NULL,'','531561840',NULL,0,NULL,'2010-04-29 06:22:16',NULL,0),(00000000083,'519464838','8491435',NULL,'','519464838',NULL,0,NULL,'2010-04-29 08:19:44',NULL,0),(00000000084,'lxh05','15443393',NULL,'','15443393',NULL,0,NULL,'2010-04-29 08:39:49',NULL,0),(00000000085,'SMT146113','881211',NULL,'','918437756',NULL,0,NULL,'2010-04-29 08:40:38',NULL,0),(00000000086,'471796235','XiaoJIe258369',NULL,'','471796235',NULL,0,NULL,'2010-04-29 08:45:09',NULL,0),(00000000087,'CAOJIFA','247131',NULL,'179680536@qq.com','247131',NULL,0,NULL,'2010-04-29 09:09:39',NULL,0),(00000000088,'QQ632730763','890316',NULL,'','632730763',NULL,0,NULL,'2010-04-29 09:09:47',NULL,0),(00000000089,'yejayzhu','zhujun',NULL,'245940462@qq.com','245940462',NULL,0,NULL,'2010-04-29 09:43:56',NULL,0),(00000000090,'1083653431','zhaopeng35487396',NULL,'1083653431@qq.com','1083653431',NULL,0,NULL,'2010-04-29 10:50:54',NULL,0),(00000000091,'j358502339','358502339',NULL,'358502339@.qq.com','358502339',NULL,0,NULL,'2010-04-29 11:36:59',NULL,0),(00000000092,'变换之风','1112358',NULL,'','654041383',NULL,0,NULL,'2010-04-29 11:50:22',NULL,0),(00000000094,'warzerg','124704661',NULL,NULL,NULL,NULL,0,0,'2010-04-02 12:30:30',NULL,0),(00000000095,'236027367','linjunjie910609',NULL,'','236027367',NULL,0,NULL,'2010-04-29 13:04:05',NULL,0),(00000000096,'寄情怀我们','747483068',NULL,'','07592738559',NULL,0,NULL,'2010-04-29 14:29:51',NULL,0),(00000000097,'412926','19770804',NULL,'309925540,@qq.com','309925540',NULL,0,NULL,'2010-04-29 14:44:34',NULL,0),(00000000098,'翼龙重天','151544',NULL,'','15154454546',NULL,0,NULL,'2010-04-29 14:51:00',NULL,0),(00000000099,'cj88211042','71067108',NULL,'cj88211042@163.com','QQ：88211042',NULL,0,NULL,'2010-04-29 15:03:23',NULL,0),(00000000100,'Baidu','3320297',NULL,'','451801239',NULL,0,NULL,'2010-04-29 15:17:45',NULL,0),(00000000101,'a3223378','123456',NULL,'415463554@QQ.com','415463554',NULL,0,NULL,'2010-04-29 15:43:36',NULL,0),(00000000102,'sunny','jiahui520',NULL,'1109138773@qq.com','1109138773',NULL,0,NULL,'2010-04-29 16:43:56',NULL,0),(00000000103,'xidouzi','0611007',NULL,'xidou2007@126.com','1104662315',NULL,0,NULL,'2010-04-29 17:00:34',NULL,0),(00000000104,'wainizly','wwj789456',NULL,'453586534@qq.com','453586534',NULL,0,NULL,'2010-04-29 18:32:17',NULL,0),(00000000105,'冰冰加油','1986wo',NULL,'','1060109361',NULL,0,NULL,'2010-04-29 18:44:35',NULL,0),(00000000106,'hfg199m','qq10086',NULL,'hfg1990@gmail.com','757768677',NULL,0,NULL,'2010-04-29 19:47:34',NULL,0),(00000000107,'CHENHUA','536538',NULL,'13690840800@139.com','952700794',NULL,0,NULL,'2010-04-29 19:53:23',NULL,0),(00000000108,'913326603','121310',NULL,'913326603@qq.com','913326603',NULL,0,NULL,'2010-04-29 20:54:40',NULL,0),(00000000109,'121310','121310',NULL,'13544122567@139.com','913326603',NULL,0,NULL,'2010-04-29 20:55:55',NULL,0),(00000000110,'phf6271','phf6271',NULL,'565808226@qq.com','565808226',NULL,0,NULL,'2010-04-29 21:50:22',NULL,0),(00000000111,'546554500','a546554500',NULL,'546554500@qq.com','546554500',NULL,0,NULL,'2010-04-29 22:35:38',NULL,0),(00000000112,'KISS',' 05962091101',NULL,'','13635277525',NULL,0,NULL,'2010-04-29 22:38:22',NULL,0),(00000000113,'732783622','13927292175',NULL,'','732783622',NULL,0,NULL,'2010-04-29 23:05:22',NULL,0),(00000000114,'904166331','lyly727322',NULL,'','904166331',NULL,0,NULL,'2010-04-29 23:06:36',NULL,0),(00000000115,'1234','1204758971',NULL,'','1204758971',NULL,0,NULL,'2010-04-29 23:26:19',NULL,0),(00000000116,'qq773211013','86693665',NULL,'773211013@qq.com','773211013',NULL,0,NULL,'2010-04-30 01:02:42',NULL,0),(00000000117,'9909','9909',NULL,'762345758@qq.com','QQ762345758',NULL,0,NULL,'2010-04-30 01:15:56',NULL,0),(00000000118,'343949615','198751',NULL,'343949615@qq.com','343949615',NULL,0,NULL,'2010-04-30 02:13:56',NULL,0),(00000000119,'digego','di6657397',NULL,'','1006195226',NULL,0,NULL,'2010-04-30 02:15:19',NULL,0),(00000000120,'756638022','511436',NULL,'','756638022',NULL,0,NULL,'2010-04-30 03:12:45',NULL,0),(00000000121,'melody','123123',NULL,'zhangdadalu@163.com','QQ457157213',NULL,0,NULL,'2010-04-30 03:45:07',NULL,0),(00000000122,'75231','75231',NULL,'','415230213',NULL,0,NULL,'2010-04-30 06:21:18',NULL,0),(00000000123,'huoyan','999998',NULL,'shishang07@163.com','297398288',NULL,0,NULL,'2010-04-30 07:47:36',NULL,0),(00000000124,'草原传说','65435080',NULL,'12559388301.@com','1255938830',NULL,0,NULL,'2010-04-30 08:40:02',NULL,0),(00000000125,'EEE666','666666',NULL,'','916162132',NULL,0,NULL,'2010-04-30 09:22:37',NULL,0),(00000000126,'zcqqc','qrzdwkyo',NULL,'zcqqc@qq.com','315140038',NULL,0,NULL,'2010-04-30 09:49:42',NULL,0),(00000000127,'346489105','19910312liu',NULL,'346489105@163.COM','346489105',NULL,0,NULL,'2010-04-30 10:10:44',NULL,0),(00000000128,'freewfs','wfs100405',NULL,'','617849920',NULL,0,NULL,'2010-04-30 10:25:46',NULL,0),(00000000129,'12345','198569',NULL,'396587161@QQ.com','396587161',NULL,0,NULL,'2010-04-30 11:54:03',NULL,0),(00000000130,'dj55679','as21426352',NULL,'','QQ250354321',NULL,0,NULL,'2010-04-30 12:55:01',NULL,0),(00000000131,'67017281','ttpod',NULL,'67017281@qq.com','67017281',NULL,0,NULL,'2010-04-30 13:16:21',NULL,0),(00000000132,'zcy_coffee','251213580',NULL,'','15137265',NULL,0,NULL,'2010-04-30 13:50:28',NULL,0),(00000000133,'634792102','2115695',NULL,'634792105@qq.com','634792105',NULL,0,NULL,'2010-04-30 14:16:54',NULL,0),(00000000134,'168168','168168',NULL,'65927209@qq.com','168168',NULL,0,NULL,'2010-04-30 14:37:08',NULL,0),(00000000135,'yxh080502','2012',NULL,'308620759@qq.com','2012',NULL,0,NULL,'2010-04-30 15:31:27',NULL,0),(00000000136,'tylergage ','245521',NULL,'420927256@qq.com ','QQ420927256',NULL,0,NULL,'2010-04-30 15:54:37',NULL,0),(00000000137,'梦中的你你你','962697',NULL,'','743586340',NULL,0,NULL,'2010-04-30 16:03:08',NULL,0),(00000000138,'710046998','5381126',NULL,'710046998@qq.com','710046998',NULL,0,NULL,'2010-04-30 16:22:23',NULL,0),(00000000139,'zjxha','36243513',NULL,'zjxha.2008@qq.com','36243513',NULL,0,NULL,'2010-04-30 17:30:09',NULL,0),(00000000140,'584541884','584541884',NULL,'','584541884',NULL,0,NULL,'2010-04-30 19:02:17',NULL,0),(00000000141,'永不睡觉的人','ai1687399707',NULL,'781250267@qq.com','781250267',NULL,0,NULL,'2010-04-30 19:26:21',NULL,0),(00000000142,'QQ809433688','88845636',NULL,'','809433688',NULL,0,NULL,'2010-04-30 21:21:05',NULL,0),(00000000143,'lifeng','2058',NULL,'539692058@qq.com','539692058',NULL,0,NULL,'2010-04-30 21:44:25',NULL,0),(00000000144,'leixiaohe','7664589',NULL,'leixiaohe@163.com','358589655',NULL,0,NULL,'2010-04-30 22:03:33',NULL,0),(00000000145,'jslkhrk','24691356',NULL,'','136657488',NULL,0,NULL,'2010-04-30 22:08:45',NULL,0),(00000000146,'13719497735','8817565',NULL,'544013602qq@.com','544013602',NULL,0,NULL,'2010-05-01 00:09:32',NULL,0),(00000000147,'gaojie5588','147258369',NULL,'254068505@qq.com','254068505',NULL,0,NULL,'2010-05-01 01:06:01',NULL,0),(00000000148,'9325934','8657072',NULL,'','110',NULL,0,NULL,'2010-05-01 01:16:15',NULL,0),(00000000149,'天天不动听','13560481626',NULL,'tcl095@163.com','403373077',NULL,0,NULL,'2010-05-01 04:27:52',NULL,0),(00000000150,'jiahe1224','jiahe4221',NULL,'','781671011',NULL,0,NULL,'2010-05-01 04:58:27',NULL,0),(00000000151,'13598197890','13598197890',NULL,'','742536591',NULL,0,NULL,'2010-05-01 05:32:07',NULL,0),(00000000152,'422753173','422753173',NULL,'','422753173',NULL,0,NULL,'2010-05-01 06:35:10',NULL,0),(00000000153,'505836126','15831659380',NULL,'505836126@163.com','505836126',NULL,0,NULL,'2010-05-01 07:06:55',NULL,0),(00000000154,'100200','100200',NULL,'tmj12241@hotmail.com','409272452',NULL,0,NULL,'2010-05-01 07:56:28',NULL,0),(00000000155,'qq601045398','123gl123',NULL,'','601045398',NULL,0,NULL,'2010-05-01 08:05:30',NULL,0),(00000000156,'470518226','470518226',NULL,'470518226@qq.com','1358946721',NULL,0,NULL,'2010-05-01 08:10:19',NULL,0),(00000000157,'493227886','493227886',NULL,'','493227886',NULL,0,NULL,'2010-05-01 08:39:35',NULL,0),(00000000158,'R2828520','28227520',NULL,'349326513@qq.com','349326513',NULL,0,NULL,'2010-05-01 09:15:23',NULL,0),(00000000159,'FC8888','zw13410381209',NULL,'zw198777@qq.com','380905128',NULL,0,NULL,'2010-05-01 09:49:07',NULL,0),(00000000160,'44974785','522501314',NULL,'44974785@163.com','44974785',NULL,0,NULL,'2010-05-01 10:11:54',NULL,0),(00000000161,'lomu12','1234501',NULL,'www.595004313@qq.com','QQ595004313',NULL,0,NULL,'2010-05-01 10:18:17',NULL,0),(00000000162,'lier','0105390',NULL,'363005403@qq.com','363005403',NULL,0,NULL,'2010-05-01 10:58:07',NULL,0),(00000000163,'deguo701988','19701208px',NULL,'','19701208px',NULL,0,NULL,'2010-05-01 12:01:28',NULL,0),(00000000164,'260900596','abcde123',NULL,'','260900596',NULL,0,NULL,'2010-05-01 12:19:20',NULL,0),(00000000165,'liu6851437','94911033830',NULL,'','314447695',NULL,0,NULL,'2010-05-01 12:20:12',NULL,0),(00000000166,'55725','142536',NULL,'','13265855725',NULL,0,NULL,'2010-05-01 12:32:52',NULL,0),(00000000167,'00000','0000',NULL,'','790508259',NULL,0,NULL,'2010-05-01 13:45:52',NULL,0),(00000000168,'我爱天天','1234',NULL,'Ply88@21cn.com','83235558',NULL,0,NULL,'2010-05-01 13:49:21',NULL,0),(00000000169,'328926972','h00000000',NULL,'hgq023@163.com','328926972',NULL,0,NULL,'2010-05-01 15:53:52',NULL,0),(00000000170,'568685508','568685508',NULL,'','568685508',NULL,0,NULL,'2010-05-01 15:54:47',NULL,0),(00000000171,'sxp200422','611414',NULL,'sxp200422@163.com','381783693',NULL,0,NULL,'2010-05-01 16:22:25',NULL,0),(00000000172,'950126','shan950126viphao',NULL,'','408966079',NULL,0,NULL,'2010-05-01 17:18:33',NULL,0),(00000000173,'wangpeng666','7438306',NULL,'82223704@qq.com','7438306',NULL,0,NULL,'2010-05-01 18:44:17',NULL,0),(00000000174,'mo514577170','15812451302',NULL,'514577170@qq.com','514577170',NULL,0,NULL,'2010-05-01 20:09:42',NULL,0),(00000000175,'13916006940','zun891106',NULL,'995570065@qq.com','995570065',NULL,0,NULL,'2010-05-01 20:16:43',NULL,0),(00000000176,'171709140','951@wdc',NULL,'15195142040@163.com','171709140',NULL,0,NULL,'2010-05-01 20:31:52',NULL,0),(00000000177,'cenrujing','www123',NULL,'','1060663539',NULL,0,NULL,'2010-05-01 20:45:00',NULL,0),(00000000178,'889527','963741',NULL,'','514427331',NULL,0,NULL,'2010-05-01 20:49:04',NULL,0),(00000000179,'QQ2776633','qq2776633',NULL,'609352043@qq.com','609352043',NULL,0,NULL,'2010-05-01 21:08:39',NULL,0),(00000000180,'Imzhh','5511324',NULL,'imzhh@foxmail.com','492730763',NULL,0,NULL,'2010-05-01 21:13:39',NULL,0),(00000000181,'LKL66','lkl554161312DJ',NULL,'554161312@qq.com','554161312',NULL,0,NULL,'2010-05-01 21:57:36',NULL,0),(00000000182,'huan715509','715509',NULL,'','715509',NULL,0,NULL,'2010-05-01 22:32:47',NULL,0),(00000000183,'880620','yuchong19880620',NULL,'1125912234@qq.com','1145912234',NULL,0,NULL,'2010-05-01 22:45:36',NULL,0),(00000000184,'guochao421','421421',NULL,'','1019264551',NULL,0,NULL,'2010-05-01 22:49:03',NULL,0),(00000000185,'wuqingru','365842427',NULL,'13414753967@139.com','13414753967',NULL,0,NULL,'2010-05-01 23:00:32',NULL,0),(00000000186,'lgjian','qq284696866',NULL,'284696866@.qq.com','284696866',NULL,0,NULL,'2010-05-01 23:36:03',NULL,0),(00000000187,'540759762','1357911',NULL,'','540759762',NULL,0,NULL,'2010-05-01 23:45:14',NULL,0),(00000000188,'13076412626','KUN700236',NULL,'','904180617',NULL,0,NULL,'2010-05-01 23:51:38',NULL,0),(00000000189,'OLD A','86030323',NULL,'','245384260',NULL,0,NULL,'2010-05-02 05:19:45',NULL,0),(00000000190,'snow','1278910465tang',NULL,'','574365156',NULL,0,NULL,'2010-05-02 07:17:00',NULL,0),(00000000191,'898707014','820740',NULL,'','898707014',NULL,0,NULL,'2010-05-02 07:39:03',NULL,0),(00000000192,'Yfd800621','0800621',NULL,'173804851qq@.com','173804581',NULL,0,NULL,'2010-05-02 08:43:22',NULL,0),(00000000193,'QQ2776632','qq2776633',NULL,'609352043@qq.com','609352043',NULL,0,NULL,'2010-05-02 09:20:55',NULL,0),(00000000194,'1138046059','1138046059',NULL,'1138046059@qq.com','1138046059',NULL,0,NULL,'2010-05-02 10:07:31',NULL,0),(00000000195,'一缘难尽','449153',NULL,'gggsd@126.com','449153',NULL,0,NULL,'2010-05-02 10:46:20',NULL,0),(00000000196,'hjb544013639','199166',NULL,'hjb544013639@126.com','563726649',NULL,0,NULL,'2010-05-02 11:11:13',NULL,0),(00000000197,'jinzexin','283459539',NULL,'jinzexin2005@163.com','283459539',NULL,0,NULL,'2010-05-02 11:37:26',NULL,0),(00000000198,'512324','123456',NULL,'','1211611014',NULL,0,NULL,'2010-05-02 11:58:16',NULL,0),(00000000199,'西部骇客','19701028',NULL,'','1206079566',NULL,0,NULL,'2010-05-02 12:33:25',NULL,0),(00000000201,'动听天天','549826',NULL,'306614954@qq.com','306614954',NULL,0,NULL,'2010-05-02 13:52:36',NULL,0),(00000000202,'JIANLI','353535',NULL,'1078687164 @qq.com ','1078687164',NULL,0,NULL,'2010-05-02 13:57:22',NULL,0),(00000000203,'aaa1066519178','15920109467',NULL,'','1066519178',NULL,0,NULL,'2010-05-02 15:19:32',NULL,0),(00000000204,'地狱使者','huangdeng',NULL,'755303293@qq.com','QQ755303293',NULL,0,NULL,'2010-05-02 15:33:22',NULL,0),(00000000205,'weizhixue','8013223',NULL,'724623567@qq.com','724623567',NULL,0,NULL,'2010-05-02 17:27:10',NULL,0),(00000000206,'chishaoxin','1990512240',NULL,'836537185@QQ.COM','836537185',NULL,0,NULL,'2010-05-02 17:50:20',NULL,0),(00000000207,'323235','15009208617',NULL,'','Q1009096727',NULL,0,NULL,'2010-05-02 18:11:42',NULL,0),(00000000208,'gmjd.aptwdk','1234',NULL,'957239257@qq.com','957239257',NULL,0,NULL,'2010-05-02 18:13:35',NULL,0),(00000000209,'xxzdgg','19910923',NULL,'13664917110@139.com','1010394978',NULL,0,NULL,'2010-05-02 18:21:28',NULL,0),(00000000210,'beijuyw','9905',NULL,'beijuyw@163.com','454014330',NULL,0,NULL,'2010-05-02 19:07:36',NULL,0),(00000000211,'tfand','511323',NULL,'taofeng@tfand.cn','39009317',NULL,0,NULL,'2010-05-02 19:27:25',NULL,0),(00000000212,'qq1170417960','251314251314',NULL,'1170417960@qq.com','18601592458',NULL,0,NULL,'2010-05-02 20:01:41',NULL,0),(00000000213,'Lidaxia','990623',NULL,'13531811364@139.Com','QQ870742250',NULL,0,NULL,'2010-05-02 20:23:02',NULL,0),(00000000214,'475369893','475369893',NULL,'475369893@qq.com','475369893',NULL,0,NULL,'2010-05-02 20:45:17',NULL,0),(00000000215,'Fate/stay night','521402wahkiouun',NULL,'','964785436',NULL,0,NULL,'2010-05-02 22:54:39',NULL,0),(00000000216,'13411015252','5252',NULL,'','5252',NULL,0,NULL,'2010-05-02 23:14:50',NULL,0),(00000000217,'zxg123456','123456',NULL,'','724010916',NULL,0,NULL,'2010-05-03 00:09:29',NULL,0),(00000000218,'linsoudon','910312',NULL,'471374229@.qq.con','471374229',NULL,0,NULL,'2010-05-03 00:18:53',NULL,0),(00000000219,'liyulin5111','32598788',NULL,'www.2116.com@qq.com','13544513489',NULL,0,NULL,'2010-05-03 01:32:57',NULL,0),(00000000220,'4444','13931779767',NULL,'','857395857',NULL,0,NULL,'2010-05-03 05:55:15',NULL,0),(00000000221,'momohuhu258','mayanxia258',NULL,'1107406972@qq.com','qq',NULL,0,NULL,'2010-05-03 08:05:09',NULL,0),(00000000222,'364077','364077',NULL,'1258157236@qq.com','1258157236',NULL,0,NULL,'2010-05-03 08:19:47',NULL,0),(00000000223,'176648669','8196685',NULL,'','176648669',NULL,0,NULL,'2010-05-03 09:51:58',NULL,0),(00000000224,'780566922','1179371289',NULL,'780566922@qq.com','1179371289',NULL,0,NULL,'2010-05-03 10:16:29',NULL,0),(00000000225,'13559015664','123456',NULL,'','458408352',NULL,0,NULL,'2010-05-03 12:34:40',NULL,0),(00000000226,'Cwg123','199052100',NULL,'460793919@pp.com','460793919',NULL,0,NULL,'2010-05-03 13:24:26',NULL,0),(00000000227,'419637503','5664278',NULL,'419637503@qq.com','419637503',NULL,0,NULL,'2010-05-03 13:59:37',NULL,0),(00000000228,'15080697736','pengyangyu',NULL,'842131938@qq.com','842131938',NULL,0,NULL,'2010-05-03 15:13:03',NULL,0),(00000000229,'47339108','95968120981',NULL,'www.47339108@qq.com','47339108',NULL,0,NULL,'2010-05-03 15:38:00',NULL,0),(00000000230,'152250799','306700890',NULL,'152250799@qq.com','306700890',NULL,0,NULL,'2010-05-03 16:10:36',NULL,0),(00000000231,'947248136','1314520',NULL,'947248136@qq.com','1314520',NULL,0,NULL,'2010-05-03 17:30:46',NULL,0),(00000000232,'137677591','8639076',NULL,'hourubin@qq.com','137677591',NULL,0,NULL,'2010-05-03 19:41:14',NULL,0),(00000000233,'cage','3483895',NULL,'','373772078',NULL,0,NULL,'2010-05-03 20:15:44',NULL,0),(00000000234,'疯狂的男孩儿','aa1989232323',NULL,'1018473568@qq.com','1018473568',NULL,0,NULL,'2010-05-03 21:38:16',NULL,0),(00000000235,'470200204','926327',NULL,'','470200204',NULL,0,NULL,'2010-05-03 22:11:24',NULL,0),(00000000236,'wanjy','860312',NULL,'287132783@qq.com','13930532787',NULL,0,NULL,'2010-05-03 22:58:12',NULL,0),(00000000237,'534915481','13878789800',NULL,'','534915481',NULL,0,NULL,'2010-05-03 23:02:40',NULL,0),(00000000238,'cy1912051236','742277081',NULL,'742277081@QQ.COM','13632957544',NULL,0,NULL,'2010-05-03 23:17:09',NULL,0),(00000000239,'h659822146','19142',NULL,'','659822146',NULL,0,NULL,'2010-05-03 23:56:30',NULL,0),(00000000240,'hyhlj','881220',NULL,'','250318681',NULL,0,NULL,'2010-05-04 00:15:24',NULL,0),(00000000241,'乐山乐水','123456',NULL,'603060453@.com.cn','QQ',NULL,0,NULL,'2010-05-04 01:49:08',NULL,0),(00000000242,'jieanly','111227',NULL,'','471047097',NULL,0,NULL,'2010-05-04 02:10:00',NULL,0),(00000000243,'hehe210417','51800000',NULL,'lidan210417@163.com','274184801',NULL,0,NULL,'2010-05-04 06:56:20',NULL,0),(00000000245,'976731361','452838141',NULL,'420294084@qq.com','420294084',NULL,0,NULL,'2010-05-04 08:26:16',NULL,0),(00000000246,'935279510','1234567890a',NULL,'9265279510@qq.com','935279510',NULL,0,NULL,'2010-05-04 09:15:46',NULL,0),(00000000248,'jun123','008953',NULL,'773093492@.cn','773093492',NULL,0,NULL,'2010-05-04 10:40:02',NULL,0),(00000000249,'292736946','0535647007',NULL,'','292836946',NULL,0,NULL,'2010-05-04 11:01:42',NULL,0),(00000000250,'qzk137','13725154593',NULL,'','495092274',NULL,0,NULL,'2010-05-04 11:34:05',NULL,0),(00000000251,'229729569','lj910127',NULL,'','229729569',NULL,0,NULL,'2010-05-04 11:50:21',NULL,0),(00000000252,'mygodyuhao','yh19910520',NULL,'','930306708',NULL,0,NULL,'2010-05-04 12:29:20',NULL,0),(00000000253,'7468011944','265688',NULL,'','746801194',NULL,0,NULL,'2010-05-04 13:32:28',NULL,0),(00000000254,'Robin','886688',NULL,'15293157075@139.com','1250529313',NULL,0,NULL,'2010-05-04 13:55:14',NULL,0),(00000000255,'wulidong','525035100',NULL,'','13430194',NULL,0,NULL,'2010-05-04 13:59:36',NULL,0),(00000000256,'yedangzhao','478891',NULL,'','415299383',NULL,0,NULL,'2010-05-04 16:11:39',NULL,0),(00000000257,'a276244119','a2619446',NULL,'tyff002@163.com','27624419',NULL,0,NULL,'2010-05-04 16:38:42',NULL,0),(00000000258,'bobu2010','xue0305mei',NULL,'bobu2222@sina.com','278620979',NULL,0,NULL,'2010-05-04 17:04:56',NULL,0),(00000000259,'13432377870','767459420',NULL,'251225826@qq.com','qq251225826',NULL,0,NULL,'2010-05-04 18:27:33',NULL,0),(00000000260,'zhengyanqing ','812959414',NULL,'812959414@qq.com','812959414',NULL,0,NULL,'2010-05-04 18:41:51',NULL,0),(00000000261,'fan8501126','8501126',NULL,'fan8501126@163.com','420974123',NULL,0,NULL,'2010-05-04 18:52:58',NULL,0),(00000000262,'wap29526154','29526154',NULL,'','29526154',NULL,0,NULL,'2010-05-04 19:13:17',NULL,0),(00000000263,'hundouluo','123456',NULL,'','350000673',NULL,0,NULL,'2010-05-04 20:20:28',NULL,0),(00000000264,'1208666369','nameb41',NULL,'1208666369@qq.com','1208666369',NULL,0,NULL,'2010-05-04 20:45:49',NULL,0),(00000000265,'8953','008953',NULL,'773093492@.cn','773093492',NULL,0,NULL,'2010-05-04 20:55:10',NULL,0),(00000000266,'995534922','kyz515200',NULL,'','360358883',NULL,0,NULL,'2010-05-04 21:29:29',NULL,0),(00000000267,'huan171080','huan171080huan',NULL,'','954448048',NULL,0,NULL,'2010-05-04 22:28:28',NULL,0),(00000000268,'AIYL','95520',NULL,'','95520',NULL,0,NULL,'2010-05-04 22:30:09',NULL,0),(00000000269,'80723585','7953819',NULL,'','80723585',NULL,0,NULL,'2010-05-04 22:41:57',NULL,0),(00000000270,'a2579111','qq604781363',NULL,'a2579111@163.com','qq604781363',NULL,0,NULL,'2010-05-04 23:04:52',NULL,0),(00000000271,'7758258','199210',NULL,'','1182150059',NULL,0,NULL,'2010-05-05 00:32:57',NULL,0),(00000000272,'750540064','15859627178',NULL,'750540064@qq.com','750540064',NULL,0,NULL,'2010-05-05 02:59:28',NULL,0),(00000000273,'125809761','2101303770',NULL,'','254183770',NULL,0,NULL,'2010-05-05 04:11:13',NULL,0),(00000000274,'lihonghong521','19861207',NULL,'','1169260778',NULL,0,NULL,'2010-05-05 05:04:41',NULL,0),(00000000275,'Ysf5889','Ysf663636',NULL,'','15105002237',NULL,0,NULL,'2010-05-05 07:10:49',NULL,0),(00000000276,'kingfang111219','iloveutoo',NULL,'17808462@qq.com','17808462',NULL,0,NULL,'2010-05-05 09:13:31',NULL,0),(00000000277,'jzyRicky','19900505',NULL,'','877419835',NULL,0,NULL,'2010-05-05 09:28:00',NULL,0),(00000000278,'jlgaojie','jl382821592',NULL,'382821592@.qq.com','382821592',NULL,0,NULL,'2010-05-05 10:16:20',NULL,0),(00000000279,'kang','15017871680',NULL,'','461573031',NULL,0,NULL,'2010-05-05 12:46:45',NULL,0),(00000000280,'心照不宣','46285',NULL,'','742524209',NULL,0,NULL,'2010-05-05 13:14:20',NULL,0),(00000000281,'450289','998992',NULL,'','418667159',NULL,0,NULL,'2010-05-05 13:33:11',NULL,0),(00000000282,'王国之战','198910',NULL,'','1406694255',NULL,0,NULL,'2010-05-05 14:43:09',NULL,0),(00000000283,'6681088','6692500',NULL,'','Q715671953',NULL,0,NULL,'2010-05-05 15:23:33',NULL,0),(00000000284,'19860309','198639',NULL,'','15255212781',NULL,0,NULL,'2010-05-05 17:16:04',NULL,0),(00000000285,'773492914','x773492914',NULL,'','773492914',NULL,0,NULL,'2010-05-05 18:05:24',NULL,0),(00000000286,'qq245400615','5202560668',NULL,'','qq245400615',NULL,0,NULL,'2010-05-05 18:28:19',NULL,0),(00000000287,'77932097','6886026',NULL,'','QQ:77932097',NULL,0,NULL,'2010-05-05 19:49:13',NULL,0),(00000000288,'诺基亚 N72','1990122609',NULL,'','1226',NULL,0,NULL,'2010-05-05 19:50:08',NULL,0),(00000000289,'博士达音响','991321236',NULL,'','7294948374',NULL,0,NULL,'2010-05-05 19:51:36',NULL,0),(00000000290,'344238792','344238792',NULL,'','344238792',NULL,0,NULL,'2010-05-05 22:12:51',NULL,0),(00000000291,'淡然一笑','350621',NULL,'','1029073321',NULL,0,NULL,'2010-05-05 22:13:46',NULL,0),(00000000292,'6832246','6832246',NULL,'','344238792',NULL,0,NULL,'2010-05-05 22:14:50',NULL,0),(00000000294,'630231730','302302',NULL,'630231730@qq.com','630231730',NULL,0,NULL,'2010-05-05 23:21:59',NULL,0),(00000000295,'jian','123456',NULL,'15920912485@139.com','123456',NULL,0,NULL,'2010-05-06 00:02:35',NULL,0),(00000000296,'249100335','249100335',NULL,'','249100335',NULL,0,NULL,'2010-05-06 00:28:28',NULL,0),(00000000297,'leishuaipeng','076100',NULL,'412117280@qq.com','412117280',NULL,0,NULL,'2010-05-06 00:39:56',NULL,0),(00000000298,'leishuaipeng111','076100',NULL,'412117280@qq.com','412117280',NULL,0,NULL,'2010-05-06 00:41:17',NULL,0),(00000000299,'kami89','113631765',NULL,'450074760@qq.com','450074760',NULL,0,NULL,'2010-05-06 05:38:15',NULL,0),(00000000300,'willsonjin','1314ttdt',NULL,'','371028913',NULL,0,NULL,'2010-05-06 07:14:50',NULL,0),(00000000301,'13588741367','123456',NULL,'','934923612',NULL,0,NULL,'2010-05-06 07:27:15',NULL,0),(00000000302,'5320XM','680803',NULL,'619397592@qq.com','619397592',NULL,0,NULL,'2010-05-06 07:50:32',NULL,0),(00000000303,'928420421','15237706280',NULL,'1058971441@qq.com','1058971441',NULL,0,NULL,'2010-05-06 09:18:44',NULL,0),(00000000304,'13450618030','453313764',NULL,'','13537011291',NULL,0,NULL,'2010-05-06 09:48:29',NULL,0),(00000000305,'zhangxiang','zhangxiang',NULL,NULL,NULL,NULL,0,NULL,'2010-05-06 10:30:55',NULL,0),(00000000306,'15006420071','870507',NULL,'756787973@qq.com','756787973',NULL,0,NULL,'2010-05-06 10:32:55',NULL,0),(00000000307,'15245909973','13694603206',NULL,'','843356390',NULL,0,NULL,'2010-05-06 11:36:34',NULL,0),(00000000308,'2311552','2311552',NULL,'','630200698',NULL,0,NULL,'2010-05-06 12:29:06',NULL,0),(00000000309,'liulingy0425','4634002',NULL,'liulingy0425@163.com','764644470',NULL,0,NULL,'2010-05-06 13:18:04',NULL,0),(00000000310,'micki ','232372',NULL,'','280398802',NULL,0,NULL,'2010-05-06 15:21:06',NULL,0),(00000000311,'pan1026','15975346pan',NULL,'','15106020157',NULL,0,NULL,'2010-05-06 15:44:33',NULL,0),(00000000312,'shang','191213',NULL,'shangweijing@126.com','455265827',NULL,0,NULL,'2010-05-06 16:08:48',NULL,0),(00000000313,'f4101448','13728701734',NULL,'350500482@qq.com','350500482',NULL,0,NULL,'2010-05-06 16:24:48',NULL,0),(00000000314,'ITF-TKD','89757',NULL,'','401082241',NULL,0,NULL,'2010-05-06 17:32:11',NULL,0),(00000000315,'15941488228','15941488228',NULL,'944567621@qq.com','944567621',NULL,0,NULL,'2010-05-06 17:36:03',NULL,0),(00000000316,'深海蓝鲸','haiyang945ya',NULL,'','452045607',NULL,0,NULL,'2010-05-06 18:53:02',NULL,0),(00000000317,'a529834068','502172725',NULL,'a529834068@163.com','13221880521',NULL,0,NULL,'2010-05-06 20:48:16',NULL,0),(00000000318,'15819052445','t872296681',NULL,'','QQ872296681',NULL,0,NULL,'2010-05-06 22:28:12',NULL,0),(00000000319,'wjs325','429004',NULL,'1272195172@qq.com','1272195172',NULL,0,NULL,'2010-05-07 01:16:41',NULL,0),(00000000320,'zhangbianfei','13673668661zbf',NULL,'zhangbianfei@qq.com','279725778',NULL,0,NULL,'2010-05-07 07:22:03',NULL,0),(00000000321,'8610152','8670152',NULL,'','QQ474066894',NULL,0,NULL,'2010-05-07 09:45:35',NULL,0),(00000000322,'guohuan','521123',NULL,'15869616302@139.com','565643351',NULL,0,NULL,'2010-05-07 10:20:37',NULL,0),(00000000323,'完美结局','yujie0421',NULL,'183303356@qq.com','13857370872',NULL,0,NULL,'2010-05-07 11:53:04',NULL,0),(00000000324,'青春无敌','983188',NULL,'','494356621',NULL,0,NULL,'2010-05-07 12:32:32',NULL,0),(00000000325,'fztyp','02161985',NULL,'fztyp@qq.com','251379851',NULL,0,NULL,'2010-05-07 13:44:14',NULL,0),(00000000326,'12586924456','253862',NULL,'','7262835',NULL,0,NULL,'2010-05-07 15:05:46',NULL,0),(00000000327,'123456','AAABD',NULL,'','15827286844',NULL,0,NULL,'2010-05-07 19:35:44',NULL,0),(00000000328,'8858593','lianghong',NULL,'','8858593',NULL,0,NULL,'2010-05-07 20:09:06',NULL,0),(00000000329,'ljw1227','ljw85217639',NULL,'','875946663',NULL,0,NULL,'2010-05-07 22:40:30',NULL,0),(00000000330,'JyZkr','123456',NULL,'','996009119',NULL,0,NULL,'2010-05-07 23:22:27',NULL,0),(00000000331,'SJ897482256','Dragon123',NULL,'897482256@qq.com','897482256',NULL,0,NULL,'2010-05-08 00:51:29',NULL,0),(00000000332,'546720751','jinmaoshu',NULL,'546720751@qq.com','546720751',NULL,0,NULL,'2010-05-08 01:14:21',NULL,0),(00000000333,'woshizongxiong','314159',NULL,'767316701@qq.com','767316701',NULL,0,NULL,'2010-05-08 05:39:58',NULL,0),(00000000334,'HHWW','52787',NULL,'342106614@qq.com','342106614',NULL,0,NULL,'2010-05-08 06:49:27',NULL,0),(00000000335,'3816','610711',NULL,'381608007@qq.com','381608007',NULL,0,NULL,'2010-05-08 07:46:56',NULL,0),(00000000336,'水漠孤寒','867512110',NULL,'','15290151897',NULL,0,NULL,'2010-05-08 10:40:05',NULL,0),(00000000337,'631046746','901215',NULL,'631046746@qq.com','631046746',NULL,0,NULL,'2010-05-08 11:18:31',NULL,0),(00000000338,'54211609','54211609',NULL,'wwwaaatt@163.com.cn','QQ646559062',NULL,0,NULL,'2010-05-08 13:06:11',NULL,0),(00000000339,'jackychen','jackychen',NULL,'294064764@qq.com','294064764',NULL,0,NULL,'2010-05-08 14:12:28',NULL,0),(00000000340,'zms1911426','19840522',NULL,'zms1911426@sohu.com','535726886 ',NULL,0,NULL,'2010-05-08 17:02:34',NULL,0),(00000000341,'xupengbiao','921887765',NULL,'','921887765',NULL,0,NULL,'2010-05-08 20:27:02',NULL,0),(00000000342,'F611','F6118009',NULL,'','541816000',NULL,0,NULL,'2010-05-08 21:17:43',NULL,0),(00000000343,'Sailing','S736203',NULL,'','648002919',NULL,0,NULL,'2010-05-08 22:07:51',NULL,0),(00000000344,'889802','889802',NULL,'','136398745',NULL,0,NULL,'2010-05-08 23:08:53',NULL,0),(00000000345,'暗恋你 一辈子','mawenan123',NULL,'','316817079',NULL,0,NULL,'2010-05-08 23:52:35',NULL,0),(00000000347,'ly2468','liuyi19870317',NULL,'','876873214',NULL,0,NULL,'2010-05-09 11:40:32',NULL,0),(00000000348,'ly2468liuyi','liuyi19870317',NULL,'','876873214',NULL,0,NULL,'2010-05-09 11:41:35',NULL,0),(00000000349,'天天动听','ADGJMJMG',NULL,'','13580996053',NULL,0,NULL,'2010-05-09 11:51:27',NULL,0),(00000000350,'loveshuaiwei','w4071457',NULL,'307893956@qq.com','307893956',NULL,0,NULL,'2010-05-09 13:15:02',NULL,0),(00000000351,'forever ','zdd3322706',NULL,'','673745922',NULL,0,NULL,'2010-05-09 13:50:19',NULL,0),(00000000352,'3258916892','8888',NULL,'','QQ946010050',NULL,0,NULL,'2010-05-09 17:13:38',NULL,0),(00000000411,'ergreg','asdf','1','jiege82000@163.com','98773',NULL,0,NULL,'2010-07-16 13:55:07','afsdgregergergresdfafdgsdf',0),(00000000354,'wenkelin','wenkelin',NULL,'wk19860919@163.com','254374293',NULL,0,NULL,'2010-05-09 19:23:13',NULL,0),(00000000355,'399475375','040112',NULL,'399475375@qq.com.cn','13489197510',NULL,0,NULL,'2010-05-09 20:02:55',NULL,0),(00000000357,'491912865','872401073',NULL,'491912865@qq.com','491912865',NULL,0,NULL,'2010-05-09 22:08:09',NULL,0),(00000000358,'520206','83278205',NULL,'','729265406',NULL,0,NULL,'2010-05-09 22:33:26',NULL,0),(00000000359,'1987SU','19870904',NULL,'','389066755',NULL,0,NULL,'2010-05-09 23:37:14',NULL,0),(00000000360,'fuyangthomas','miaomiao',NULL,'yuepengyang@ovi.com','501251898',NULL,0,NULL,'2010-05-09 23:53:02',NULL,0),(00000000361,'jiajia4059','907289640',NULL,'','112720369',NULL,0,NULL,'2010-05-10 04:46:06',NULL,0),(00000000362,'暧昧碎碎念','112233',NULL,'94134753@qq.com','94134753',NULL,0,NULL,'2010-05-10 05:12:45',NULL,0),(00000000363,'玩，玩，玩','1994382009',NULL,'1239137081@163.com','1239137081',NULL,0,NULL,'2010-05-10 06:56:20',NULL,0),(00000000364,'735116986','13409715082',NULL,'','735116986',NULL,0,NULL,'2010-05-10 07:55:50',NULL,0),(00000000365,'Zhangli','123456789',NULL,'154347064@qq.com.cn','154347064',NULL,0,NULL,'2010-05-10 10:26:37',NULL,0),(00000000366,'tjso','453446615',NULL,'','453446615',NULL,0,NULL,'2010-05-10 10:54:00',NULL,0),(00000000367,'Vae.10','ainixiaozhuan',NULL,'','732046386',NULL,0,NULL,'2010-05-10 21:58:30',NULL,0),(00000000368,'ssochao','13584818263',NULL,'ssochao@126.com','493664367',NULL,0,NULL,'2010-05-10 23:10:52',NULL,0),(00000000369,'mogzhope','84397839',NULL,'','772784221',NULL,0,NULL,'2010-05-10 23:25:19',NULL,0),(00000000370,'13706075624','075624',NULL,'522205181@qq.com','522205181',NULL,0,NULL,'2010-05-11 00:14:32',NULL,0),(00000000371,'miyongjun','mi6923081',NULL,'','QQ',NULL,0,NULL,'2010-05-11 01:06:22',NULL,0),(00000000372,'865865','8888',NULL,'','1028317148',NULL,0,NULL,'2010-05-11 10:18:32',NULL,0),(00000000374,'mchm14','883300',NULL,'','372356064',NULL,0,NULL,'2010-05-11 13:43:00',NULL,0),(00000000375,'452702946','452702946',NULL,'','452702946',NULL,0,NULL,'2010-05-11 22:42:55',NULL,0),(00000000376,'jiezai13580','338958',NULL,'jiezai13580@163.com','646472512',NULL,0,NULL,'2010-05-12 00:49:12',NULL,0),(00000000377,'掉色々逐浪','13660805271',NULL,'','469860381',NULL,0,NULL,'2010-05-12 01:28:21',NULL,0),(00000000378,'monkey','123483594789',NULL,'','450341184',NULL,0,NULL,'2010-05-12 09:08:58',NULL,0),(00000000379,'13502565109','841129',NULL,'','479195922',NULL,0,NULL,'2010-05-12 09:18:38',NULL,0),(00000000380,'liaoxingan','1231303',NULL,'','358553426',NULL,0,NULL,'2010-05-12 11:24:21',NULL,0),(00000000381,'1193862583','123456',NULL,'451279098@qq.com','123456',NULL,0,NULL,'2010-05-12 12:48:00',NULL,0),(00000000382,'12803loov','820320',NULL,'12803966967@qq.com','15876053121',NULL,0,NULL,'2010-05-12 19:57:07',NULL,0),(00000000385,'sevenalways','leave',NULL,'35287943@163.com','35287943',NULL,0,NULL,'2010-05-13 00:22:39',NULL,0),(00000000388,'chenwen131','81021023',NULL,'snake131@163.com','360009505',NULL,0,NULL,'2010-05-13 08:06:20',NULL,0),(00000000389,'gutianyu','woaini1314chunv',NULL,'goodgutianyu@163.com','292540723',NULL,0,NULL,'2010-05-13 09:10:38',NULL,0),(00000000390,'18601125527','125527',NULL,'','1101635204',NULL,0,NULL,'2010-05-13 10:17:44',NULL,0),(00000000391,'zhaobeilong','123456',NULL,NULL,NULL,NULL,0,NULL,'2010-05-28 14:38:42',NULL,0),(00000000392,'qwer','123456',NULL,NULL,NULL,NULL,0,NULL,'2010-06-10 12:04:18',NULL,0);
/*Table structure for table `userrole` */
DROP TABLE IF EXISTS `userrole`;
CREATE TABLE `userrole` (
`userId` int(11) NOT NULL COMMENT '用户id',
`roleId` int(11) NOT NULL COMMENT '角色Id',
KEY `FK_bbs_userrole` (`roleId`),
KEY `FK_bbs_userrole1` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
/*Data for the table `userrole` */
insert into `userrole`(`userId`,`roleId`) values (7,20),(2,20),(8,20),(23,20),(391,20),(1,20),(13,20),(37,39);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;