Skip to content

Commit 77a58b8

Browse files
TommyLemonTommyLemon
committed
同步table
1 parent 6d2abdb commit 77a58b8

File tree

10 files changed

+30
-33
lines changed

10 files changed

+30
-33
lines changed

‎table/sys_Comment.sql‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -24,11 +24,11 @@ DROP TABLE IF EXISTS `Comment`;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Comment` (
2626
`id` bigint(15) NOT NULL,
27-
`parentId` bigint(15) NOT NULL,
27+
`parentId` bigint(15) DEFAULT NULL,
2828
`momentId` bigint(15) NOT NULL,
2929
`userId` bigint(15) NOT NULL,
30-
`toUserId` bigint(15) NOT NULL,
31-
`content` varchar(1000) DEFAULT NULL,
30+
`toUserId` bigint(15) DEFAULT NULL,
31+
`content` varchar(1000) NOT NULL,
3232
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
3333
`workId` bigint(15) NOT NULL COMMENT '兼容测试以前的Work（被Moment替代）',
3434
PRIMARY KEY (`id`)
@@ -41,7 +41,7 @@ CREATE TABLE `Comment` (
4141

4242
LOCK TABLES `Comment` WRITE;
4343
/*!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),(157,0,371,93793,70793,'This is a Content...-13','2017-02-01 11:20:50',371);
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);
4545
/*!40000 ALTER TABLE `Comment` ENABLE KEYS */;
4646
UNLOCK TABLES;
4747
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -54,4 +54,4 @@ UNLOCK TABLES;
5454
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5555
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5656

57-
-- Dump completed on 2017-03-02 12:31:57
57+
-- Dump completed on 2017-03-05 0:12:23

‎table/sys_Login.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -28,7 +28,7 @@ CREATE TABLE `Login` (
2828
`type` tinyint(1) NOT NULL,
2929
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3030
PRIMARY KEY (`id`)
31-
) ENGINE=InnoDB AUTO_INCREMENT=1488428891642 DEFAULT CHARSET=utf8;
31+
) ENGINE=InnoDB AUTO_INCREMENT=1488643446185 DEFAULT CHARSET=utf8;
3232
/*!40101 SET character_set_client = @saved_cs_client */;
3333

3434
--
@@ -37,7 +37,7 @@ CREATE TABLE `Login` (
3737

3838
LOCK TABLES `Login` WRITE;
3939
/*!40000 ALTER TABLE `Login` DISABLE KEYS */;
40-
INSERT INTO `Login` VALUES (1488364481245,82001,0,'2017-03-01 10:34:41'),(1488364492505,82001,0,'2017-03-01 10:34:52'),(1488364526194,82001,0,'2017-03-01 10:35:26'),(1488364559063,82001,0,'2017-03-01 10:35:59'),(1488364651645,82001,0,'2017-03-01 10:37:31'),(1488364754738,82001,0,'2017-03-01 10:39:14'),(1488364860440,82001,0,'2017-03-01 10:41:00'),(1488364956150,82001,0,'2017-03-01 10:42:36'),(1488364962529,82001,0,'2017-03-01 10:42:42'),(1488365716746,82001,0,'2017-03-01 10:55:16'),(1488365732208,0,0,'2017-03-01 10:55:32'),(1488365796614,82001,0,'2017-03-01 10:56:36'),(1488365830506,82001,0,'2017-03-01 10:57:10'),(1488365865366,82001,0,'2017-03-01 10:57:45'),(1488368913127,82001,0,'2017-03-01 11:48:33'),(1488368925105,82001,0,'2017-03-01 11:48:45'),(1488368950806,82001,0,'2017-03-01 11:49:10'),(1488379391681,1488378558927,0,'2017-03-01 14:43:11'),(1488379908786,1488378449469,0,'2017-03-01 14:51:48'),(1488379961820,1488379935755,0,'2017-03-01 14:52:41'),(1488386227319,1488380023998,0,'2017-03-01 16:37:07'),(1488386452893,82001,0,'2017-03-01 16:40:52'),(1488386525081,82001,0,'2017-03-01 16:42:05'),(1488386595743,82001,0,'2017-03-01 16:43:15'),(1488386713599,82001,0,'2017-03-01 16:45:13'),(1488387166592,1488378449469,0,'2017-03-01 16:52:46'),(1488423710531,1488423676823,0,'2017-03-02 03:01:50'),(1488425664244,82001,0,'2017-03-02 03:34:24'),(1488426261713,82001,0,'2017-03-02 03:44:21'),(1488426370251,82001,0,'2017-03-02 03:46:10'),(1488426526302,82001,0,'2017-03-02 03:48:46'),(1488427645678,82001,0,'2017-03-02 04:07:25'),(1488428692387,82001,0,'2017-03-02 04:24:52'),(1488428867991,1488428734202,0,'2017-03-02 04:27:47'),(1488428891641,82001,0,'2017-03-02 04:28:11');
40+
INSERT INTO `Login` VALUES (1488364481245,82001,0,'2017-03-01 10:34:41'),(1488364492505,82001,0,'2017-03-01 10:34:52'),(1488364526194,82001,0,'2017-03-01 10:35:26'),(1488364559063,82001,0,'2017-03-01 10:35:59'),(1488364651645,82001,0,'2017-03-01 10:37:31'),(1488364754738,82001,0,'2017-03-01 10:39:14'),(1488364860440,82001,0,'2017-03-01 10:41:00'),(1488364956150,82001,0,'2017-03-01 10:42:36'),(1488364962529,82001,0,'2017-03-01 10:42:42'),(1488365716746,82001,0,'2017-03-01 10:55:16'),(1488365732208,0,0,'2017-03-01 10:55:32'),(1488365796614,82001,0,'2017-03-01 10:56:36'),(1488365830506,82001,0,'2017-03-01 10:57:10'),(1488365865366,82001,0,'2017-03-01 10:57:45'),(1488368913127,82001,0,'2017-03-01 11:48:33'),(1488368925105,82001,0,'2017-03-01 11:48:45'),(1488368950806,82001,0,'2017-03-01 11:49:10'),(1488379391681,1488378558927,0,'2017-03-01 14:43:11'),(1488379908786,1488378449469,0,'2017-03-01 14:51:48'),(1488379961820,1488379935755,0,'2017-03-01 14:52:41'),(1488386227319,1488380023998,0,'2017-03-01 16:37:07'),(1488386452893,82001,0,'2017-03-01 16:40:52'),(1488386525081,82001,0,'2017-03-01 16:42:05'),(1488386595743,82001,0,'2017-03-01 16:43:15'),(1488386713599,82001,0,'2017-03-01 16:45:13'),(1488387166592,1488378449469,0,'2017-03-01 16:52:46'),(1488423710531,1488423676823,0,'2017-03-02 03:01:50'),(1488425664244,82001,0,'2017-03-02 03:34:24'),(1488426261713,82001,0,'2017-03-02 03:44:21'),(1488426370251,82001,0,'2017-03-02 03:46:10'),(1488426526302,82001,0,'2017-03-02 03:48:46'),(1488427645678,82001,0,'2017-03-02 04:07:25'),(1488428692387,82001,0,'2017-03-02 04:24:52'),(1488428867991,1488428734202,0,'2017-03-02 04:27:47'),(1488428891641,82001,0,'2017-03-02 04:28:11'),(1488433184521,82001,0,'2017-03-02 05:39:44'),(1488473027806,82001,0,'2017-03-02 16:43:47'),(1488473034915,82001,0,'2017-03-02 16:43:54'),(1488473261705,1488473066471,0,'2017-03-02 16:47:41'),(1488473267045,82001,0,'2017-03-02 16:47:47'),(1488516198007,82001,0,'2017-03-03 04:43:18'),(1488516623869,1488378449469,0,'2017-03-03 04:50:23'),(1488535557623,82001,0,'2017-03-03 10:05:57'),(1488540964229,82001,0,'2017-03-03 11:36:04'),(1488540997715,1488540991808,0,'2017-03-03 11:36:37'),(1488541075533,1488541028865,0,'2017-03-03 11:37:55'),(1488541560585,1488541531131,0,'2017-03-03 11:46:00'),(1488541564781,82001,0,'2017-03-03 11:46:04'),(1488545582698,82001,0,'2017-03-03 12:53:02'),(1488557693251,82001,0,'2017-03-03 16:14:53'),(1488565219244,82001,0,'2017-03-03 18:20:19'),(1488567124406,82001,0,'2017-03-03 18:52:04'),(1488569711657,1488569508197,0,'2017-03-03 19:35:11'),(1488569782719,1488569732797,0,'2017-03-03 19:36:22'),(1488569807192,1488569798561,0,'2017-03-03 19:36:47'),(1488572205502,82001,0,'2017-03-03 20:16:45'),(1488572273190,1488572225956,0,'2017-03-03 20:17:53'),(1488572813536,82001,0,'2017-03-03 20:26:53'),(1488572823466,1488569798561,0,'2017-03-03 20:27:03'),(1488572844863,1488572838263,0,'2017-03-03 20:27:24'),(1488572852849,1488572838263,0,'2017-03-03 20:27:32'),(1488572994566,1488572838263,0,'2017-03-03 20:29:54'),(1488602587483,1488602583693,0,'2017-03-04 04:43:07'),(1488602732477,1488602583693,0,'2017-03-04 04:45:32'),(1488602739644,1488569508197,0,'2017-03-04 04:45:39'),(1488602765243,82001,0,'2017-03-04 04:46:05'),(1488602765244,82001,0,'2017-03-04 08:10:51'),(1488615113957,82001,0,'2017-03-04 08:11:53'),(1488615113958,82001,0,'2017-03-04 08:38:21'),(1488616708677,82001,0,'2017-03-04 08:38:28'),(1488616708678,82001,0,'2017-03-04 08:40:01'),(1488616804092,82001,0,'2017-03-04 08:40:04'),(1488616804093,82012,0,'2017-03-04 09:30:21'),(1488619853762,82012,0,'2017-03-04 09:30:53'),(1488619853763,1488621574081,0,'2017-03-04 09:59:34'),(1488621807871,1488621574081,0,'2017-03-04 10:03:27'),(1488621807872,1488621574081,0,'2017-03-04 10:03:43'),(1488621827734,1488621574081,0,'2017-03-04 10:03:47'),(1488621827735,1488621574081,0,'2017-03-04 10:04:03'),(1488621846267,1488621574081,0,'2017-03-04 10:04:06'),(1488621846268,1488621873562,0,'2017-03-04 10:04:33'),(1488621876782,1488621873562,0,'2017-03-04 10:04:36'),(1488621876783,1488621904086,0,'2017-03-04 10:05:04'),(1488622533567,1488621904086,0,'2017-03-04 10:15:33'),(1488622533568,1488622827857,0,'2017-03-04 10:20:27'),(1488622831418,1488622827857,0,'2017-03-04 10:20:31'),(1488622831419,1488473066471,0,'2017-03-04 10:21:52'),(1488622919890,1488473066471,0,'2017-03-04 10:21:59'),(1488622919891,1488622959038,0,'2017-03-04 10:22:39'),(1488623021260,1488622959038,0,'2017-03-04 10:23:41'),(1488623021261,1488622959038,0,'2017-03-04 10:25:02'),(1488623107782,1488622959038,0,'2017-03-04 10:25:07'),(1488623107783,1488622959038,0,'2017-03-04 14:23:31'),(1488638599393,1488622959038,0,'2017-03-04 14:43:19'),(1488638599394,1488622959038,0,'2017-03-04 15:07:50'),(1488640073476,1488622959038,0,'2017-03-04 15:07:53'),(1488640073477,82001,0,'2017-03-04 15:08:13'),(1488640255125,82001,0,'2017-03-04 15:10:55'),(1488640255126,1488640277910,0,'2017-03-04 15:11:18'),(1488640325578,1488640277910,0,'2017-03-04 15:12:05'),(1488640325579,1488640277910,0,'2017-03-04 15:12:08'),(1488640330490,1488640277910,0,'2017-03-04 15:12:10'),(1488640330491,1488640277910,0,'2017-03-04 15:59:25'),(1488643309485,1488640277910,0,'2017-03-04 16:01:49'),(1488643309486,1488643325534,0,'2017-03-04 16:02:05'),(1488643330578,1488643325534,0,'2017-03-04 16:02:10'),(1488643330579,82001,0,'2017-03-04 16:02:13'),(1488643371023,82001,0,'2017-03-04 16:02:51'),(1488643371024,38710,0,'2017-03-04 16:03:07'),(1488643414030,38710,0,'2017-03-04 16:03:34'),(1488643414031,1488643442503,0,'2017-03-04 16:04:02'),(1488643446184,1488643442503,0,'2017-03-04 16:04:06');
4141
/*!40000 ALTER TABLE `Login` ENABLE KEYS */;
4242
UNLOCK TABLES;
4343
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -50,4 +50,4 @@ UNLOCK TABLES;
5050
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5151
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5252

53-
-- Dump completed on 2017-03-02 12:31:57
53+
-- Dump completed on 2017-03-05 0:12:23

0 commit comments

Comments
 (0)