Skip to content

Commit cd9c59d

Browse files
committed
同步table
1 parent 3d189dd commit cd9c59d

9 files changed

Lines changed: 23 additions & 25 deletions

File tree

table/sys_Comment.sql

Lines changed: 7 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -23,16 +23,14 @@ DROP TABLE IF EXISTS `Comment`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Comment` (
26-
`id` bigint(15) NOT NULL,
27-
`parentId` bigint(15) DEFAULT NULL,
28-
`momentId` bigint(15) NOT NULL,
26+
`id` bigint(15) NOT NULL AUTO_INCREMENT,
27+
`toId` bigint(15) DEFAULT NULL,
2928
`userId` bigint(15) NOT NULL,
30-
`toUserId` bigint(15) DEFAULT NULL,
31-
`content` varchar(1000) NOT NULL,
29+
`momentId` bigint(15) NOT NULL,
3230
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
33-
`workId` bigint(15) NOT NULL DEFAULT '0' COMMENT '兼容测试以前的Work(被Moment替代)',
31+
`content` varchar(1000) NOT NULL,
3432
PRIMARY KEY (`id`)
35-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33+
) ENGINE=InnoDB AUTO_INCREMENT=1490879678128 DEFAULT CHARSET=utf8;
3634
/*!40101 SET character_set_client = @saved_cs_client */;
3735

3836
--
@@ -41,7 +39,7 @@ CREATE TABLE `Comment` (
4139

4240
LOCK TABLES `Comment` WRITE;
4341
/*!40000 ALTER TABLE `Comment` DISABLE KEYS */;
44-
INSERT INTO `Comment` VALUES (3,0,371,82002,59960,'This is a Content...-3','2017-02-01 11:20:50',371),(4,0,470,38710,82002,'This is a Content...-4','2017-02-01 11:20:50',470),(13,0,58,82005,93793,'This is a Content...-13','2017-02-01 11:20:50',58),(22,221,470,82001,70793,'This is a Content...-22','2017-02-01 11:20:50',470),(44,0,170,82003,93793,'This is a Content...-44','2017-02-01 11:20:50',170),(45,0,301,93793,99700,'This is a Content...-45','2017-02-01 11:20:50',301),(47,4,470,70793,70793,'This is a Content...-47','2017-02-01 11:20:50',470),(51,45,301,82003,70793,'This is a Content...-51','2017-02-01 11:20:50',301),(54,0,170,82004,93793,'This is a Content...-54','2017-02-01 11:20:50',170),(68,0,371,82005,70793,'This is a Content...-68','2017-02-01 11:20:50',371),(76,45,301,93793,70793,'This is a Content...-76','2017-02-01 11:20:50',301),(77,13,58,93793,35234,'This is a Content...-77','2017-02-01 11:20:50',58),(97,13,58,82006,14326,'This is a Content...-97','2017-02-01 11:20:50',58),(99,44,170,70793,7166,'This is a Content...-99','2017-02-01 11:20:50',170),(110,0,371,93793,0,'This is a Content...-110',NULL,371),(114,0,371,82001,NULL,'This is a Content...-114','2017-03-02 05:56:06',371),(115,0,371,38710,0,'This is a Content...-115','2017-03-02 05:56:06',371),(116,0,371,70793,0,'This is a Content...-116','2017-03-02 05:56:06',371),(120,0,301,93793,0,'This is a Content...-110','2017-03-02 05:56:06',301),(124,0,301,82001,0,'This is a Content...-114','2017-03-02 05:56:06',301),(157,NULL,371,93793,70793,'This is a Content...-157','2017-02-01 11:20:50',371),(158,0,301,93793,70793,'This is a Content...-157',NULL,301),(160,0,235,82001,38710,'This is a Content...-160','2017-03-02 05:56:06',235),(161,NULL,592,93793,70793,'This is a Content...-161','2017-02-01 11:20:50',592),(162,0,12,93793,82001,'This is a Content...-162','2017-03-06 05:03:45',12),(163,0,235,82001,38710,'This is a Content...-163','2017-03-02 05:56:06',235),(164,0,12,93793,82001,'This is a Content...-164','2017-03-06 05:03:45',12),(1490442468579,-1,12,82001,NULL,'shsn','2017-03-25 11:47:48',0),(1490442507698,164,12,82001,NULL,'ejej','2017-03-25 11:48:27',0),(1490442521508,-1,58,82001,NULL,'Nice!','2017-03-25 11:48:41',0),(1490442554925,1490442545077,235,82001,NULL,'???','2017-03-25 11:49:14',0),(1490442775869,-1,12,82001,NULL,'??','2017-03-25 11:52:55',0),(1490442899770,-1,15,82001,NULL,'eens','2017-03-25 11:54:59',0),(1490442981277,-1,15,82001,NULL,'666','2017-03-25 11:56:21',0),(1490443006697,-1,594,82001,NULL,'Oh','2017-03-25 11:56:46',0),(1490443019881,161,592,82001,NULL,'@','2017-03-25 11:56:59',0),(1490444578443,162,12,82001,NULL,'OK','2017-03-25 12:22:58',0),(1490444713710,-1,58,38710,NULL,'Good','2017-03-25 12:25:13',0),(1490444760199,1490444735213,1488691759538,38710,NULL,'what?','2017-03-25 12:26:00',0),(1490444813136,0,12,38710,NULL,'Java is the best program language!','2017-03-25 12:26:53',0),(1490444883791,1490442981277,15,38710,NULL,'thank you','2017-03-25 12:28:03',0),(1490444893722,1490442981277,15,38710,NULL,'ok','2017-03-25 12:28:13',0),(1490445055098,-1,511,38710,NULL,'wbw','2017-03-25 12:30:55',0),(1490446627893,-1,12,82001,NULL,'dfg','2017-03-25 12:57:07',0),(1490446645404,-1,12,82001,NULL,'fgv','2017-03-25 12:57:25',0),(1490508758159,110,371,82001,NULL,'hahaha','2017-03-26 06:12:38',0),(1490508772599,110,371,82001,NULL,'hahaha','2017-03-26 06:12:52',0),(1490508777003,-1,371,82001,NULL,'xbsh','2017-03-26 06:12:57',0),(1490510726885,1490444883791,15,82001,38710,'rjrj','2017-03-26 06:45:26',0),(1490510731606,1490442899770,15,82001,82001,'ejdj','2017-03-26 06:45:31',0),(1490510784792,0,15,82001,0,'djdj','2017-03-26 06:46:24',0),(1490510797228,1490444883791,15,82001,38710,'ehehhe','2017-03-26 06:46:37',0),(1490511356796,0,15,82001,0,'ehdh','2017-03-26 06:55:56',0),(1490511363452,1490444893722,15,82001,38710,'ejej','2017-03-26 06:56:03',0),(1490512892186,97,58,82001,82006,'1646','2017-03-26 07:21:32',0),(1490512895453,0,58,82001,0,'??','2017-03-26 07:21:35',0),(1490512933969,0,58,82001,0,'dbdj','2017-03-26 07:22:13',0),(1490514569484,1490443019881,592,82001,0,'zbsj','2017-03-26 07:49:29',0),(1490514575320,0,592,82001,0,'sjsj','2017-03-26 07:49:35',0),(1490517322091,1490442899770,15,82001,0,'dbdj','2017-03-26 08:35:22',0),(1490517326698,0,15,82001,0,'sbeb','2017-03-26 08:35:26',0),(1490517332436,0,15,82001,0,'wjeje','2017-03-26 08:35:32',0),(1490517518421,162,12,82001,93793,'ejej','2017-03-26 08:38:38',0),(1490517527405,162,12,82001,93793,'aaaaa','2017-03-26 08:38:47',0),(1490584531719,0,12,82001,0,'xbdnj','2017-03-27 03:15:31',0),(1490584538032,0,12,82001,0,'hhh','2017-03-27 03:15:38',0),(1490584816450,0,592,82001,0,'oooo','2017-03-27 03:20:16',0);
42+
INSERT INTO `Comment` VALUES (3,0,82002,371,'2017-02-01 11:20:50','This is a Content...-3'),(4,0,38710,470,'2017-02-01 11:20:50','This is a Content...-4'),(13,0,82005,58,'2017-02-01 11:20:50','This is a Content...-13'),(22,221,82001,470,'2017-02-01 11:20:50','This is a Content...-22'),(44,0,82003,170,'2017-02-01 11:20:50','This is a Content...-44'),(45,0,93793,301,'2017-02-01 11:20:50','This is a Content...-45'),(47,4,70793,470,'2017-02-01 11:20:50','This is a Content...-47'),(51,45,82003,301,'2017-02-01 11:20:50','This is a Content...-51'),(54,0,82004,170,'2017-02-01 11:20:50','This is a Content...-54'),(68,0,82005,371,'2017-02-01 11:20:50','This is a Content...-68'),(76,45,93793,301,'2017-02-01 11:20:50','This is a Content...-76'),(77,13,93793,58,'2017-02-01 11:20:50','This is a Content...-77'),(97,13,82006,58,'2017-02-01 11:20:50','This is a Content...-97'),(99,44,70793,170,'2017-02-01 11:20:50','This is a Content...-99'),(110,0,93793,371,NULL,'This is a Content...-110'),(114,0,82001,371,'2017-03-02 05:56:06','This is a Content...-114'),(115,0,38710,371,'2017-03-02 05:56:06','This is a Content...-115'),(116,0,70793,371,'2017-03-02 05:56:06','This is a Content...-116'),(120,0,93793,301,'2017-03-02 05:56:06','This is a Content...-110'),(124,0,82001,301,'2017-03-02 05:56:06','This is a Content...-114'),(157,NULL,93793,371,'2017-02-01 11:20:50','This is a Content...-157'),(158,0,93793,301,NULL,'This is a Content...-157'),(160,0,82001,235,'2017-03-02 05:56:06','This is a Content...-160'),(162,0,93793,12,'2017-03-06 05:03:45','This is a Content...-162'),(163,0,82001,235,'2017-03-02 05:56:06','This is a Content...-163'),(164,0,93793,12,'2017-03-06 05:03:45','This is a Content...-164'),(165,NULL,82001,12,'2017-03-25 11:47:48','shsn'),(166,164,82001,12,'2017-03-25 11:48:27','ejej'),(167,NULL,82001,58,'2017-03-25 11:48:41','Nice!'),(168,1490442545077,82001,235,'2017-03-25 11:49:14','???'),(169,NULL,82001,12,'2017-03-25 11:52:55','??'),(170,NULL,82001,15,'2017-03-25 11:54:59','eens'),(171,NULL,82001,15,'2017-03-25 11:56:21','666'),(172,162,82001,12,'2017-03-25 12:22:58','OK'),(173,NULL,38710,58,'2017-03-25 12:25:13','Good'),(174,172,38710,1488691759538,'2017-03-25 12:26:00','what?'),(175,0,38710,12,'2017-03-25 12:26:53','Java is the best program language!'),(176,166,38710,15,'2017-03-25 12:28:03','thank you'),(177,165,38710,15,'2017-03-25 12:28:13','ok'),(178,NULL,38710,511,'2017-03-25 12:30:55','wbw'),(181,110,82001,371,'2017-03-26 06:12:38','hahaha'),(182,110,82001,371,'2017-03-26 06:12:52','hahaha'),(183,NULL,82001,371,'2017-03-26 06:12:57','xbsh'),(184,175,82001,15,'2017-03-26 06:45:26','rjrj'),(185,164,82001,15,'2017-03-26 06:45:31','ejdj'),(186,187,82001,15,'2017-03-26 06:46:37','ehehhe'),(187,177,82001,15,'2017-03-26 06:56:03','ejej'),(188,97,82001,58,'2017-03-26 07:21:32','1646'),(189,0,82001,58,'2017-03-26 07:21:35','??'),(190,0,82001,58,'2017-03-26 07:22:13','dbdj'),(191,176,82001,592,'2017-03-26 07:49:29','zbsj'),(192,0,82001,592,'2017-03-26 07:49:35','sjsj'),(193,176,82001,15,'2017-03-26 08:35:22','dbdj'),(194,0,82001,15,'2017-03-26 08:35:26','sbeb'),(195,0,82001,15,'2017-03-26 08:35:32','wjeje'),(197,162,82001,12,'2017-03-26 08:38:47','aaaaa'),(199,0,82001,12,'2017-03-27 03:15:38','hhh'),(200,0,82001,592,'2017-03-27 03:20:16','oooo'),(201,0,82001,594,'2017-03-29 03:00:44','come on!'),(202,166,82001,592,'2017-03-29 03:01:08','eej'),(203,178,82001,592,'2017-03-29 03:01:14','znsk'),(204,169,82001,592,'2017-03-29 03:01:32','ghh'),(205,177,82001,592,'2017-03-29 03:01:37','hhh'),(206,54,82001,170,'2017-03-29 03:04:23','ejej'),(207,185,82001,12,'2017-03-29 03:04:40','vgh'),(209,13,82001,58,'2017-03-29 03:05:59','hehj'),(300,97,82001,58,'2017-03-29 03:06:07','hj'),(301,194,82001,235,'2017-03-29 03:06:24','jj'),(302,110,82001,371,'2017-03-29 03:06:41','hjj'),(303,0,82001,594,'2017-03-29 04:24:50','sjsj'),(304,195,82001,592,'2017-03-29 04:48:28','eej'),(305,188,82001,592,'2017-03-29 04:48:32','ssh'),(306,0,82001,593,'2017-03-29 04:48:41','sbs'),(307,161,82001,592,'2017-03-29 04:48:51','ejej'),(308,0,82001,592,'2017-03-29 04:49:02','eheh'),(309,0,82001,592,'2017-03-29 04:49:06','ehsh'),(4000,0,82001,592,'2017-03-29 04:49:13','ejje'),(4001,0,82001,58,'2017-03-29 08:39:52','I would like to say …'),(1490776944301,0,82001,58,'2017-03-29 08:42:24','hello'),(1490776966828,173,82001,58,'2017-03-29 08:42:46','me too'),(1490777876202,192,82001,592,'2017-03-29 08:57:56','ghh'),(1490777879786,0,82001,592,'2017-03-29 08:57:59','bbb'),(1490777890128,0,82001,594,'2017-03-29 08:58:10','aaa'),(1490777905437,0,82001,543,'2017-03-29 08:58:25','rr'),(1490778122719,175,82001,12,'2017-03-29 09:02:02','Yeah! I think so!'),(1490778494751,1490778122719,82001,12,'2017-03-29 09:08:14','reply Android82001'),(1490778681337,166,82001,12,'2017-03-29 09:11:21','gg'),(1490780672012,164,82001,12,'2017-03-29 09:44:32','93793'),(1490780759866,99,82001,170,'2017-03-29 09:45:59','99'),(1490781009548,51,82001,301,'2017-03-29 09:50:09','3'),(1490781032005,45,82001,301,'2017-03-29 09:50:32','93793'),(1490781817044,209,38710,58,'2017-03-29 10:03:37','82001'),(1490781850893,1490776966828,38710,58,'2017-03-29 10:04:10','haha!'),(1490781857242,190,38710,58,'2017-03-29 10:04:17','nice'),(1490781865407,1490781857242,38710,58,'2017-03-29 10:04:25','wow'),(1490781899147,197,38710,12,'2017-03-29 10:04:59','kaka'),(1490781914528,1490780672012,38710,12,'2017-03-29 10:05:14','ops'),(1490793549915,199,82001,12,'2017-03-29 13:19:09','iii'),(1490794439561,1490778681337,82001,12,'2017-03-29 13:33:59','gg?'),(1490794610632,172,82001,12,'2017-03-29 13:36:50','All right'),(1490794937137,1490794919957,82001,12,'2017-03-29 13:42:17','All right ok ok'),(1490794953438,1490794937137,82001,12,'2017-03-29 13:42:33','All right ok ok ll'),(1490794983265,0,82001,12,'2017-03-29 13:43:03','OOOOOOOO'),(1490796241178,0,38710,58,'2017-03-29 14:04:01','Anything else?'),(1490796629591,175,1490796536716,12,'2017-03-29 14:10:29','well'),(1490798710678,110,1490796536716,371,'2017-03-29 14:45:10','110'),(1490800971064,175,1490796536716,12,'2017-03-29 15:22:51','I do'),(1490844756797,1490794983265,82001,12,'2017-03-30 03:32:36','KAKAKKA'),(1490848396072,175,82001,12,'2017-03-30 04:33:16','Lemon'),(1490848581424,166,82001,12,'2017-03-30 04:36:21','82001ejej'),(1490849955567,1490794983265,82001,12,'2017-03-30 04:59:15','fire'),(1490850764448,162,82001,12,'2017-03-30 05:12:44','-162'),(1490850844016,0,82001,12,'2017-03-30 05:14:04','I like it'),(1490850876656,1490800971064,82001,12,'2017-03-30 05:14:36','I do so'),(1490850901463,171,82001,15,'2017-03-30 05:15:01','777'),(1490850911603,0,82001,15,'2017-03-30 05:15:11','gg'),(1490854894566,175,82001,12,'2017-03-30 06:21:34','it does be a good lang'),(1490863443219,1490850844016,82002,12,'2017-03-30 08:44:03','me too!'),(1490863469638,0,82002,15,'2017-03-30 08:44:29','Just do it'),(1490863507114,4,82003,470,'2017-03-30 08:45:07','yes'),(1490863515306,47,82003,470,'2017-03-30 08:45:15','?'),(1490863563124,0,82003,704,'2017-03-30 08:46:03','I want one'),(1490863651493,0,70793,595,'2017-03-30 08:47:31','wow'),(1490863661426,1490780759866,70793,170,'2017-03-30 08:47:41','66'),(1490863676989,0,70793,12,'2017-03-30 08:47:56','Shy'),(1490863711703,0,70793,511,'2017-03-30 08:48:31','I hope I can join'),(1490863717947,178,70793,511,'2017-03-30 08:48:37','what?'),(1490863783276,1490863711703,93793,511,'2017-03-30 08:49:43','haha welcome'),(1490863903900,0,82006,470,'2017-03-30 08:51:43','SOGA'),(1490863915675,0,82006,235,'2017-03-30 08:51:55','Good boy'),(1490863938712,0,82006,12,'2017-03-30 08:52:18','Handsome!'),(1490863978239,1490796241178,82006,58,'2017-03-30 08:52:58','there still remains a question…'),(1490864016738,0,82006,511,'2017-03-30 08:53:36','I want to have a try!'),(1490864023700,0,82006,543,'2017-03-30 08:53:43','oops'),(1490864039264,0,82006,551,'2017-03-30 08:53:59','Wonderful!'),(1490864060358,308,82006,592,'2017-03-30 08:54:20','I an little girl'),(1490864075725,1490864060358,82006,592,'2017-03-30 08:54:35','do you like me?'),(1490864152008,0,82006,58,'2017-03-30 08:55:52','U R ugly( ´?` )'),(1490864254400,1490863915675,82044,235,'2017-03-30 08:57:34','And I have no idea'),(1490864276824,0,82044,12,'2017-03-30 08:57:56','Oh my God!'),(1490864292184,1490864152008,82044,58,'2017-03-30 08:58:12','haha!'),(1490864379424,1490863938712,82001,12,'2017-03-30 08:59:39','Thank you~'),(1490864400210,1490864276824,82001,12,'2017-03-30 09:00:00','Amazing, isnt it?'),(1490874449660,306,82001,593,'2017-03-30 11:47:29','abs'),(1490874908570,1490864023700,82055,543,'2017-03-30 11:55:08','yeah'),(1490874930994,1490777905437,82055,543,'2017-03-30 11:55:30','yy'),(1490874968779,0,82055,12,'2017-03-30 11:56:08','I love it'),(1490875033494,0,82055,301,'2017-03-30 11:57:13','More Comments'),(1490875040761,158,82055,301,'2017-03-30 11:57:20','157'),(1490875046704,120,82055,301,'2017-03-30 11:57:26','110'),(1490875660259,1490863469638,82055,15,'2017-03-30 12:07:40','I prove wht you said(??????)'),(1490879678127,0,82001,543,'2017-03-30 13:14:38','Baby you are a firework!');
4543
/*!40000 ALTER TABLE `Comment` ENABLE KEYS */;
4644
UNLOCK TABLES;
4745
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -54,4 +52,4 @@ UNLOCK TABLES;
5452
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5553
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5654

57-
-- Dump completed on 2017-03-27 12:04:20
55+
-- Dump completed on 2017-03-30 21:29:17

table/sys_Login.sql

Lines changed: 3 additions & 3 deletions
Large diffs are not rendered by default.

0 commit comments

Comments
 (0)