Skip to content

Commit 3b3cf08

Browse files
TommyLemonTommyLemon
committed
还原原有User数据，并把结构改成现在的
1 parent 9b7815d commit 3b3cf08

1 file changed

Lines changed: 5 additions & 5 deletions

File tree

‎table/sys_User.sql‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -23,15 +23,15 @@ DROP TABLE IF EXISTS `User`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `User` (
26-
`id` bigint(20) NOT NULL AUTO_INCREMENT,
26+
`id` bigint(20) NOT NULL,
2727
`sex` int(11) NOT NULL DEFAULT '0',
2828
`name` varchar(20) DEFAULT NULL,
2929
`phone` varchar(14) DEFAULT NULL,
3030
`certified` tinyint(1) NOT NULL DEFAULT '0',
3131
`head` varchar(300) DEFAULT NULL,
32-
`picture` text,
32+
`picture` varchar(3000) DEFAULT NULL,
3333
PRIMARY KEY (`id`)
34-
) ENGINE=InnoDB AUTO_INCREMENT=1485245724392 DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3535
/*!40101 SET character_set_client = @saved_cs_client */;
3636

3737
--
@@ -40,7 +40,7 @@ CREATE TABLE `User` (
4040

4141
LOCK TABLES `User` WRITE;
4242
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
43-
INSERT INTO `User` VALUES (38710,0,'Lemon','1234560000',0,'','\"{\"id\":2}\"'),(93851,0,NULL,NULL,0,NULL,NULL),(93852,0,NULL,NULL,0,NULL,NULL),(93853,0,NULL,NULL,0,NULL,NULL),(93854,0,NULL,NULL,0,NULL,NULL),(93855,0,NULL,NULL,0,NULL,NULL),(93856,0,NULL,NULL,0,NULL,NULL),(93857,0,NULL,NULL,0,NULL,NULL),(93858,0,NULL,NULL,0,NULL,NULL),(93862,0,'Tommy','1234567890',0,'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000',NULL),(93863,0,'Tommy','1234567890',0,'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000',NULL),(93864,0,'Tommy','1234567890',0,'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000',NULL),(93865,0,'Tommy','1234567890',0,'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000',NULL),(93866,0,'Tommy','1234567890',0,'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000',NULL),(93867,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(93868,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485244029274,0,'Lemon','111111111',1,'',NULL),(1485244029275,1,NULL,NULL,0,NULL,NULL),(1485244239112,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485244740949,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245116758,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png','[\"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000\",\"http://common.cnblogs.com/images/icon_weibo_24.png\",\"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000\"]'),(1485245228383,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245677197,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245703707,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245714355,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245716302,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245718554,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL),(1485245724391,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL);
43+
INSERT INTO `User` VALUES (10000,1,'DeleteUserName','11111111111',0,'',NULL),(38710,0,'Name-38710','1300038710',0,'http://www.tooopen.com/view/38710.html',NULL),(70793,0,'Name-70793','1300070793',0,'http://www.tooopen.com/view/70793.html',''),(82001,0,'Name-82002','1300082002',1,'http://www.tooopen.com/view/82002.html',''),(82002,1,'Name-82002','1300082002',1,'http',''),(82003,1,'Name-82002','1300082002',1,'http://www.tooopen.com/view/82002.html',''),(82005,1,'Name-82002','1300082002',0,'http://www.tooopen.com/view/82002.html','[\"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000\",\"http://common.cnblogs.com/images/icon_weibo_24.png\",\"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000\"]'),(82006,1,'Name-82002','1300082002',0,'http://www.tooopen.com/view/82002.html',''),(82012,0,'Name-82002','1300082002',0,'http://www.tooopen.com/view/82002.html',''),(90814,0,'Name-90814','1300090814',1,'http://www.tooopen.com/view/90814.html',''),(93793,0,'Name-93793','1300093793',1,'http://www.tooopen.com/view/93793.html',''),(93794,0,'Lemon','999999999',0,NULL,NULL),(1485246481130,0,'Tommy','1234567890',0,'http://common.cnblogs.com/images/icon_weibo_24.png',NULL);
4444
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
4545
UNLOCK TABLES;
4646
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2017-01-24 16:19:12
56+
-- Dump completed on 2017-01-24 16:28:33

0 commit comments

Comments
 (0)