Skip to content

Commit 326d235

Browse files
TommyLemonTommyLemon
committed
同步table
1 parent 1af9ab2 commit 326d235

File tree

11 files changed

+104
-44
lines changed

11 files changed

+104
-44
lines changed

‎table/sys_Comment.sql‎

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

‎table/sys_Login.sql‎

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

‎table/sys_Moment.sql‎

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

‎table/sys_Password.sql‎

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -23,13 +23,15 @@ DROP TABLE IF EXISTS `Password`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Password` (
26+
`_index` int(11) NOT NULL AUTO_INCREMENT,
2627
`id` bigint(15) NOT NULL,
2728
`model` varchar(20) NOT NULL DEFAULT 'User' COMMENT 'table是关键字不能用!',
2829
`type` varchar(20) DEFAULT NULL,
2930
`password` varchar(20) NOT NULL,
3031
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31-
PRIMARY KEY (`id`)
32-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32+
PRIMARY KEY (`id`),
33+
UNIQUE KEY `_index_UNIQUE` (`_index`)
34+
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
3335
/*!40101 SET character_set_client = @saved_cs_client */;
3436

3537
--
@@ -38,7 +40,7 @@ CREATE TABLE `Password` (
3840

3941
LOCK TABLES `Password` WRITE;
4042
/*!40000 ALTER TABLE `Password` DISABLE KEYS */;
41-
INSERT INTO `Password` VALUES (12345678900,'User','0','123456','2017-02-01 11:21:50'),(12345678901,'User','0','123456','2017-02-01 11:21:50'),(12345678902,'User','0','123456','2017-02-01 11:21:50'),(12345678903,'User','0','123456','2017-02-01 11:21:50'),(12345678904,'User','0','apijson','2017-02-01 11:21:50'),(12345678905,'User','0','apijson','2017-02-01 11:21:50'),(12345678906,'User','0','123456','2017-02-01 11:21:50'),(12345678907,'User','0','123456','2017-02-01 11:21:50'),(12345678908,'User','0','123456','2017-02-01 11:21:50'),(12345678909,'User','0','123456','2017-02-01 11:21:50'),(12345678910,'User','0','123456','2017-02-01 11:21:50'),(12345678911,'User','0','123456','2017-02-01 11:21:50'),(12345678912,'User','0','123456','2017-02-01 11:21:50'),(12345678913,'User','0','123456','2017-02-01 11:21:50'),(12345678914,'User','0','123456','2017-02-01 11:21:50'),(12345678915,'User','0','123456','2017-02-01 11:21:50'),(12345678916,'User','0','123456','2017-02-01 11:21:50'),(12345678917,'User','0','123456','2017-02-01 11:21:50'),(12345678918,'User','0','123456','2017-02-01 11:21:50'),(12345678919,'User','0','123456','2017-02-19 13:57:56'),(13000038600,'User',NULL,'123456','2017-03-27 03:26:32'),(13000038601,'User',NULL,'123456','2017-03-27 03:27:06'),(13000038710,'User','1','apijson','2017-02-01 11:21:50'),(13000038711,'User',NULL,'123456','2017-03-04 16:04:02'),(13000038712,'User',NULL,'123456','2017-03-05 09:51:51'),(13000038713,'User',NULL,'123456','2017-03-05 09:52:52'),(13000038714,'User',NULL,'123456','2017-03-05 09:53:37'),(13000038715,'User',NULL,'123456','2017-03-05 09:57:54'),(13000038716,'User',NULL,'123456','2017-03-25 05:44:11'),(13000038717,'User',NULL,'123456','2017-03-25 07:32:19'),(13000038718,'User',NULL,'123456','2017-04-09 04:58:51'),(13000038719,'User',NULL,'123456','2017-04-09 02:51:03'),(13000038720,'User',NULL,'123456','2017-03-05 15:25:42'),(13000038721,'User',NULL,'123456','2017-03-06 12:29:03'),(13000038722,'User',NULL,'123456','2017-03-30 13:23:40'),(13000038723,'User',NULL,'123456','2017-03-30 13:24:14'),(13000038725,'User',NULL,'123456','2017-04-09 08:58:23'),(13000038726,'User',NULL,'123456','2017-04-01 02:50:49'),(13000038729,'User',NULL,'123456','2017-04-10 04:31:46'),(13000038730,'User',NULL,'123456','2017-03-12 06:01:23'),(13000038731,'User',NULL,'123456','2017-04-10 13:28:13'),(13000038750,'User',NULL,'123456','2017-03-12 11:23:04'),(13000038751,'User',NULL,'123456','2017-03-29 05:01:20'),(13000038752,'User',NULL,'123456','2017-03-29 05:04:49'),(13000038753,'User',NULL,'123456','2017-03-29 14:08:56'),(13000038755,'User',NULL,'123456','2017-04-02 11:03:36'),(13000038790,'User',NULL,'123456','2017-03-27 03:22:32'),(13000070793,'User','0','apijson','2017-02-01 11:21:50'),(13000082000,'User',NULL,'123456','2017-04-02 12:46:10'),(13000082001,'User','1','123456','2017-02-01 11:21:50'),(13000082002,'User','1','123456','2017-02-01 11:21:50'),(13000082003,'User','1','123456','2017-02-01 11:21:50'),(13000082004,'User','0','123456','2017-02-01 11:21:50'),(13000082005,'User','0','123456','2017-02-01 11:21:50'),(13000082006,'User','0','123456','2017-02-01 11:21:50'),(13000082010,'User',NULL,'123456','2017-03-04 15:11:17'),(13000082012,'User','0','123456','2017-02-01 11:21:50'),(13000082015,'User','0','123456','2017-03-04 09:59:34'),(13000082016,'User','0','123456','2017-03-04 10:04:33'),(13000082017,'User','0','123456','2017-03-04 10:05:04'),(13000082018,'User','0','123456','2017-03-04 10:20:27'),(13000082019,'User','0','123456','2017-03-02 16:44:26'),(13000082020,'User','0','123456','2017-03-04 10:22:39'),(13000082021,'User',NULL,'123456','2017-03-04 16:02:05'),(13000082030,'User',NULL,'123456','2017-03-11 15:04:00'),(13000082033,'User',NULL,'123456','2017-03-19 14:49:15'),(13000082040,'User',NULL,'123456','2017-03-11 15:32:25'),(13000082050,'User',NULL,'123456','2017-03-21 14:10:18'),(13000082051,'User',NULL,'123456','2017-03-31 15:21:10'),(13000082056,'User',NULL,'123456','2017-04-02 11:06:48'),(13000082060,'User',NULL,'123456','2017-03-30 12:10:55'),(13000082100,'User',NULL,'123456','2017-03-21 15:22:22'),(13000082101,'User',NULL,'123456','2017-03-21 15:24:05'),(13000082102,'User',NULL,'123456','2017-03-25 07:39:37'),(13000082105,'User',NULL,'123456','2017-04-04 03:56:43'),(13000082111,'User',NULL,'123456','2017-04-03 09:15:48'),(13000090814,'User','1','123456','2017-02-01 11:21:50'),(13000093793,'User','1','123456','2017-02-01 11:21:50'),(99999999999,'User','0','123456','2017-02-01 11:21:50');
43+
INSERT INTO `Password` VALUES (1,12345678900,'User','0','123456','2017-02-01 11:21:50'),(2,12345678901,'User','0','123456','2017-02-01 11:21:50'),(3,12345678902,'User','0','123456','2017-02-01 11:21:50'),(4,12345678903,'User','0','123456','2017-02-01 11:21:50'),(5,12345678904,'User','0','apijson','2017-02-01 11:21:50'),(6,12345678905,'User','0','apijson','2017-02-01 11:21:50'),(7,12345678906,'User','0','123456','2017-02-01 11:21:50'),(8,12345678907,'User','0','123456','2017-02-01 11:21:50'),(9,12345678908,'User','0','123456','2017-02-01 11:21:50'),(10,12345678909,'User','0','123456','2017-02-01 11:21:50'),(11,12345678910,'User','0','123456','2017-02-01 11:21:50'),(12,12345678911,'User','0','123456','2017-02-01 11:21:50'),(13,12345678912,'User','0','123456','2017-02-01 11:21:50'),(14,12345678913,'User','0','123456','2017-02-01 11:21:50'),(15,12345678914,'User','0','123456','2017-02-01 11:21:50'),(16,12345678915,'User','0','123456','2017-02-01 11:21:50'),(17,12345678916,'User','0','123456','2017-02-01 11:21:50'),(18,12345678917,'User','0','123456','2017-02-01 11:21:50'),(19,12345678918,'User','0','123456','2017-02-01 11:21:50'),(20,12345678919,'User','0','123456','2017-02-19 13:57:56'),(21,13000038710,'User','1','apijson','2017-02-01 11:21:50'),(22,13000038711,'User',NULL,'123456','2017-03-04 16:04:02'),(23,13000038712,'User',NULL,'123456','2017-03-05 09:51:51'),(24,13000038713,'User',NULL,'123456','2017-03-05 09:52:52'),(25,13000038714,'User',NULL,'123456','2017-03-05 09:53:37'),(26,13000038715,'User',NULL,'123456','2017-03-05 09:57:54'),(27,13000038716,'User',NULL,'123456','2017-03-25 05:44:11'),(28,13000038717,'User',NULL,'123456','2017-03-25 07:32:19'),(29,13000038720,'User',NULL,'123456','2017-03-05 15:25:42'),(30,13000038721,'User',NULL,'123456','2017-03-06 12:29:03'),(31,13000038730,'User',NULL,'123456','2017-03-12 06:01:23'),(32,13000038750,'User',NULL,'123456','2017-03-12 11:23:04'),(33,13000038790,'User',NULL,'123456','2017-03-27 03:22:32'),(34,13000070793,'User','0','apijson','2017-02-01 11:21:50'),(35,13000082001,'User','1','123456','2017-02-01 11:21:50'),(36,13000082002,'User','1','123456','2017-02-01 11:21:50'),(37,13000082003,'User','1','123456','2017-02-01 11:21:50'),(38,13000082004,'User','0','123456','2017-02-01 11:21:50'),(39,13000082005,'User','0','123456','2017-02-01 11:21:50'),(40,13000082006,'User','0','123456','2017-02-01 11:21:50'),(41,13000082010,'User',NULL,'123456','2017-03-04 15:11:17'),(42,13000082012,'User','0','123456','2017-02-01 11:21:50'),(43,13000082015,'User','0','123456','2017-03-04 09:59:34'),(44,13000082016,'User','0','123456','2017-03-04 10:04:33'),(45,13000082017,'User','0','123456','2017-03-04 10:05:04'),(46,13000082018,'User','0','123456','2017-03-04 10:20:27'),(47,13000082019,'User','0','123456','2017-03-02 16:44:26'),(48,13000082020,'User','0','123456','2017-03-04 10:22:39'),(49,13000082021,'User',NULL,'123456','2017-03-04 16:02:05'),(50,13000082030,'User',NULL,'123456','2017-03-11 15:04:00'),(51,13000082033,'User',NULL,'123456','2017-03-19 14:49:15'),(52,13000082040,'User',NULL,'123456','2017-03-11 15:32:25'),(53,13000082050,'User',NULL,'123456','2017-03-21 14:10:18'),(54,13000082051,'User',NULL,'123456','2017-03-31 15:21:10'),(55,13000082100,'User',NULL,'123456','2017-03-21 15:22:22'),(56,13000082101,'User',NULL,'123456','2017-03-21 15:24:05'),(57,13000082102,'User',NULL,'123456','2017-03-25 07:39:37'),(58,13000090814,'User','1','123456','2017-02-01 11:21:50'),(59,13000093793,'User','1','123456','2017-02-01 11:21:50'),(60,99999999999,'User','0','123456','2017-02-01 11:21:50');
4244
/*!40000 ALTER TABLE `Password` ENABLE KEYS */;
4345
UNLOCK TABLES;
4446
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -51,4 +53,4 @@ UNLOCK TABLES;
5153
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5254
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5355

54-
-- Dump completed on 2017-04-10 23:24:28
56+
-- Dump completed on 2017-04-23 16:15:46

‎table/sys_Request.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ CREATE TABLE `Request` (
3131
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
3232
PRIMARY KEY (`id`),
3333
UNIQUE KEY `id_UNIQUE` (`id`)
34-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='每次启动服务器时加载整个表到内存。';
3535
/*!40101 SET character_set_client = @saved_cs_client */;
3636

3737
--
@@ -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-04-10 23:24:27
56+
-- Dump completed on 2017-04-23 16:15:42

table/sys_Reponse.sql renamed to table/sys_Response.sql

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -16,13 +16,13 @@
1616
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1717

1818
--
19-
-- Table structure for table `Reponse`
19+
-- Table structure for table `Response`
2020
--
2121

22-
DROP TABLE IF EXISTS `Reponse`;
22+
DROP TABLE IF EXISTS `Response`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
25-
CREATE TABLE `Reponse` (
25+
CREATE TABLE `Response` (
2626
`id` int(11) NOT NULL,
2727
`method` varchar(10) DEFAULT 'GET',
2828
`tag` varchar(20) NOT NULL,
@@ -31,17 +31,17 @@ CREATE TABLE `Reponse` (
3131
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
3232
PRIMARY KEY (`id`),
3333
UNIQUE KEY `id_UNIQUE` (`id`)
34-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='每次启动服务器时加载整个表到内存。';
3535
/*!40101 SET character_set_client = @saved_cs_client */;
3636

3737
--
38-
-- Dumping data for table `Reponse`
38+
-- Dumping data for table `Response`
3939
--
4040

41-
LOCK TABLES `Reponse` WRITE;
42-
/*!40000 ALTER TABLE `Reponse` DISABLE KEYS */;
43-
INSERT INTO `Reponse` VALUES (1,NULL,'User','{\"add\": {\"extra\": \"Response is effective!\"}, \"put\": {\"certified\": 0}, \"remove\": \"phone\"}','remove-移除字段；add-如果没有对应字段就添加字段；replace-如果有就替换；put-添加或替换字段','2017-02-01 11:19:51');
44-
/*!40000 ALTER TABLE `Reponse` ENABLE KEYS */;
41+
LOCK TABLES `Response` WRITE;
42+
/*!40000 ALTER TABLE `Response` DISABLE KEYS */;
43+
INSERT INTO `Response` VALUES (1,NULL,'User','{\"add\": {\"extra\": \"Response is effective!\"}, \"put\": {\"certified\": 0}, \"remove\": \"phone\"}','remove-移除字段；add-如果没有对应字段就添加字段；replace-如果有就替换；put-添加或替换字段','2017-02-01 11:19:51');
44+
/*!40000 ALTER TABLE `Response` ENABLE KEYS */;
4545
UNLOCK TABLES;
4646
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4747

@@ -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-04-10 23:24:27
56+
-- Dump completed on 2017-04-23 16:15:47

0 commit comments

Comments
 (0)