Skip to content

Commit 1f9baed

Browse files
TommyLemonTommyLemon
committed
更新table
1 parent 68c456c commit 1f9baed

12 files changed

+22
-22
lines changed

‎table/sys_Comment.sql‎

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

‎table/sys_Document.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -25,10 +25,10 @@ DROP TABLE IF EXISTS `Document`;
2525
CREATE TABLE `Document` (
2626
`id` bigint(15) NOT NULL COMMENT '唯一标识',
2727
`userId` bigint(15) NOT NULL COMMENT '用户id\n应该用adminId，只有当登录账户是管理员时才能操作文档。\n需要先建Admin表，新增登录等相关接口。',
28-
`version` tinyint(4) NOT NULL DEFAULT '2' COMMENT '版本号',
28+
`version` tinyint(4) NOT NULL DEFAULT '0' COMMENT '接口版本号\n<=0 - 不限制版本，任意版本都可用这个接口\n>0 - 在这个版本添加的接口',
2929
`name` varchar(50) NOT NULL,
3030
`url` varchar(250) DEFAULT NULL,
31-
`request` json NOT NULL COMMENT '请求',
31+
`request` text NOT NULL COMMENT '请求\n用json格式会导致强制排序，而请求中引用赋值只能引用上面的字段，必须有序。',
3232
`description` varchar(1000) DEFAULT NULL,
3333
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
3434
PRIMARY KEY (`id`)
@@ -41,7 +41,7 @@ CREATE TABLE `Document` (
4141

4242
LOCK TABLES `Document` WRITE;
4343
/*!40000 ALTER TABLE `Document` DISABLE KEYS */;
44-
INSERT INTO `Document` VALUES (1,82001,2,'登录','/login','{\"type\": 0, \"phone\": \"13000082001\", \"version\": 1, \"password\": \"123456\"}',NULL,'2017-11-26 07:35:19'),(2,82002,2,'注册','/register','{\"User\": {\"name\": \"APIJSONUser\"}, \"verify\": \"1234\", \"Privacy\": {\"phone\": \"13000082222\", \"_password\": \"123456\"}}',NULL,NULL),(3,0,2,'退出登录','/logout','{}',NULL,'2017-11-26 09:56:10'),(1511689914599,82001,2,'获取用户隐私信息','/gets','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001}}',NULL,'2017-11-26 09:51:54');
44+
INSERT INTO `Document` VALUES (1,0,1,'登录','/login','{\"type\": 0, \"phone\": \"13000082001\", \"version\": 1, \"password\": \"123456\"}',NULL,'2017-11-26 07:35:19'),(2,0,1,'注册(先获取验证码type:1)','/register','{\n \"Privacy\": {\n \"phone\": \"13000083333\",\n \"_password\": \"123456\"\n },\n \"User\": {\n \"name\": \"APIJSONUser\"\n },\n \"verify\": \"6840\"\n}',NULL,NULL),(3,0,1,'退出登录','/logout','{}',NULL,'2017-11-26 09:56:10'),(1511689914599,0,1,'获取用户隐私信息','/gets','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001}}',NULL,'2017-11-26 09:51:54'),(1511796155277,0,1,'获取验证码','/post/verify','{\"type\": 0, \"phone\": \"13000082001\"}',NULL,'2017-11-27 15:22:35'),(1511796208670,0,1,'检查验证码是否存在','/heads/verify','{\"type\": 0, \"phone\": \"13000082001\"}',NULL,'2017-11-27 15:23:28'),(1511796589079,0,1,'修改登录密码(先获取验证码type:2)-手机号+验证码','/put/password','{\"verify\": \"10322\", \"Privacy\": {\"phone\": \"13000082001\", \"_password\": \"666666\"}}',NULL,'2017-11-27 15:29:49'),(1511796882184,0,1,'充值(需要支付密码)/提现','/put/balance','{\"tag\": \"Privacy\", \"Privacy\": {\"id\": 82001, \"balance+\": 100.15, \"_payPassword\": \"123456\"}}',NULL,'2017-11-27 15:34:42'),(1511963330795,0,2,'获取文档列表','/get','{\n \"Document[]\": {\n \"Document\": {\n \"@role\": \"login\",\n \"@order\": \"version-,date-\"\n }\n }\n}',NULL,'2017-11-29 13:48:50'),(1511963677325,82001,1,'获取用户','/get','{\"User\": {\"id\": 82001}}',NULL,'2017-11-29 13:54:37'),(1511963722970,82001,1,'获取用户列表(\"id{}\":contactIdList)-朋友页','/get','{\n \"User[]\": {\n \"count\": 10,\n \"page\": 0,\n \"User\": {\n \"@column\": \"id,sex,name,tag,head\",\n \"@order\": \"name+\",\n \"id{}\": [\n 82002,\n 82004,\n 70793\n ]\n }\n }\n}',NULL,'2017-11-29 13:55:22'),(1511963990072,82001,1,'获取动态Moment+User+praiseUserList','/get','{\n \"Moment\": {\n \"id\": 15\n },\n \"User\": {\n \"id@\": \"Moment/userId\",\n \"@column\": \"id,name,head\"\n },\n \"User[]\": {\n \"count\": 10,\n \"User\": {\n \"id{}@\": \"Moment/praiseUserIdList\",\n \"@column\": \"id,name\"\n }\n }\n}',NULL,'2017-11-29 13:59:50'),(1511964176689,82001,1,'获取评论列表-动态详情页Comment+User','/get','{\n \"[]\": {\n \"count\": 20,\n \"page\": 0,\n \"Comment\": {\n \"@order\": \"date+\",\n \"momentId\": 15\n },\n \"User\": {\n \"id@\": \"/Comment/userId\",\n \"@column\": \"id,name,head\"\n }\n }\n}',NULL,'2017-11-29 14:02:56'),(1511967853340,82001,1,'获取动态列表Moment+User+User:parise[]+Comment[]','/get','{\n \"[]\": {\n \"count\": 5,\n \"page\": 0,\n \"Moment\": {\n \"@order\": \"date-\"\n },\n \"User\": {\n \"id@\": \"/Moment/userId\",\n \"@column\": \"id,name,head\"\n },\n \"User[]\": {\n \"count\": 10,\n \"User\": {\n \"id{}@\": \"[]/Moment/praiseUserIdList\",\n \"@column\": \"id,name\"\n }\n },\n \"[]\": {\n \"count\": 6,\n \"Comment\": {\n \"@order\": \"date+\",\n \"momentId@\": \"[]/Moment/id\"\n },\n \"User\": {\n \"id@\": \"/Comment/userId\",\n \"@column\": \"id,name\"\n }\n }\n }\n}',NULL,'2017-11-29 15:04:13'),(1511969181104,82001,1,'添加朋友','/put','{\n \"User\": {\n \"id\": 82001,\n \"contactIdList+\": [93793]\n },\n \"tag\": \"User\"\n}',NULL,'2017-11-29 15:26:21'),(1511969417633,82001,1,'点赞/取消点赞','/put','{\n \"Moment\": {\n \"id\": 15,\n \"praiseUserIdList-\": [\n 82001\n ]\n },\n \"tag\": \"Moment\"\n}',NULL,'2017-11-29 15:30:17'),(1511969630372,82001,1,'新增评论','/post','{\n \"Comment\": {\n \"userId\": 82001,\n \"momentId\": 15,\n \"content\": \"测试新增评论\"\n },\n \"tag\": \"Comment\"\n}',NULL,'2017-11-29 15:33:50'),(1511970009072,82001,1,'新增动态','/post','{\n \"Moment\": {\n \"userId\": 82001,\n \"content\": \"测试新增动态\",\n \"pictureList\": [\"http://static.oschina.net/uploads/user/48/96331_50.jpg\"\n ]\n },\n \"tag\": \"Moment\"\n}',NULL,'2017-11-29 15:40:09'),(1511970224333,82001,1,'修改用户信息','/put','{\n \"User\": {\n \"id\": 82001,\n \"name\": \"测试改名\"\n },\n \"tag\": \"User\"\n}',NULL,'2017-11-29 15:43:44');
4545
/*!40000 ALTER TABLE `Document` 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-11-26 19:43:31
57+
-- Dump completed on 2017-11-30 0:05:23

‎table/sys_Login.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-11-26 19:43:31
53+
-- Dump completed on 2017-11-30 0:05:22

‎table/sys_Moment.sql‎

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

‎table/sys_Praise.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-11-26 19:43:30
53+
-- Dump completed on 2017-11-30 0:05:22

‎table/sys_Request.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-11-26 19:43:30
56+
-- Dump completed on 2017-11-30 0:05:21

‎table/sys_Response.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-11-26 19:43:32
56+
-- Dump completed on 2017-11-30 0:05:23

‎table/sys_Test.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -47,4 +47,4 @@ UNLOCK TABLES;
4747
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4848
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
4949

50-
-- Dump completed on 2017-11-26 19:43:31
50+
-- Dump completed on 2017-11-30 0:05:22

‎table/sys_Verify.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ CREATE TABLE `Verify` (
2929
`verify` int(6) NOT NULL COMMENT '验证码',
3030
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
3131
PRIMARY KEY (`id`)
32-
) ENGINE=InnoDB AUTO_INCREMENT=1511407551441 DEFAULT CHARSET=utf8;
32+
) ENGINE=InnoDB AUTO_INCREMENT=1511969005318 DEFAULT CHARSET=utf8;
3333
/*!40101 SET character_set_client = @saved_cs_client */;
3434

3535
--
@@ -38,7 +38,7 @@ CREATE TABLE `Verify` (
3838

3939
LOCK TABLES `Verify` WRITE;
4040
/*!40000 ALTER TABLE `Verify` DISABLE KEYS */;
41-
INSERT INTO `Verify` VALUES (1,0,13000003871,2858,'2017-08-13 11:28:05'),(2,0,13000011111,1199,'2017-10-05 16:22:30'),(3,0,13000031000,10442,'2017-05-04 09:30:02'),(4,0,13000031001,9445,'2017-05-04 09:31:30'),(6,0,13000038752,5879,'2017-04-22 13:03:37'),(7,0,13000038758,10077,'2017-04-22 13:09:06'),(8,0,13000038777,9175,'2017-05-02 17:51:45'),(9,0,13000038778,1191,'2017-05-02 17:56:13'),(10,0,13000038779,10350,'2017-05-02 18:09:41'),(11,0,13000038780,4200,'2017-05-02 18:10:00'),(12,0,13000038781,6674,'2017-05-02 18:18:02'),(13,0,13000038888,8186,'2017-04-29 15:35:33'),(14,0,13000038999,6167,'2017-05-03 18:27:16'),(15,0,13000039999,8566,'2017-05-04 07:31:38'),(16,0,13000066666,6533,'2017-10-15 08:13:55'),(19,0,13000082011,7026,'2017-07-03 04:47:03'),(20,0,13000082013,1229,'2017-06-17 14:04:59'),(21,0,13000082081,6760,'2017-05-04 07:32:01'),(22,0,13000082111,5650,'2017-06-18 13:36:07'),(23,0,13000082222,9150,'2017-08-13 15:49:32'),(24,0,13000082333,3870,'2017-08-13 15:49:57'),(25,0,13000093794,7563,'2017-04-23 08:29:20'),(26,0,13000099999,7739,'2017-07-23 15:53:25'),(1508066865532,1,13000082001,8005,'2017-10-15 11:27:45'),(1508072060590,1,13000082009,1121,'2017-10-15 12:54:20'),(1508072096335,1,13000082008,1495,'2017-10-15 12:54:56'),(1508072156293,1,13000082007,7710,'2017-10-15 12:55:56'),(1508072196911,1,13000082031,9802,'2017-10-15 12:56:36'),(1508072543063,0,13000093793,3584,'2017-10-15 13:02:23'),(1508072747213,0,13000070793,5260,'2017-10-15 13:05:47'),(1508072788782,1,13000082045,8191,'2017-10-15 13:06:28'),(1508072814874,1,13000082023,9574,'2017-10-15 13:06:54'),(1508072818273,1,13000082024,7824,'2017-10-15 13:06:58'),(1509026206702,1,15734087934,5754,'2017-10-26 13:56:46'),(1510492736134,1,13000083871,8276,'2017-11-12 13:18:56'),(1510495615328,1,13000082000,3585,'2017-11-12 14:06:55'),(1510501854799,2,13000038710,4742,'2017-11-12 15:50:54'),(1510501857729,0,13000038710,7434,'2017-11-12 15:50:57'),(1510974668506,0,13000082001,2732,'2017-11-18 03:11:08'),(1511407551440,1,17610725819,3155,'2017-11-23 03:25:51');
41+
INSERT INTO `Verify` VALUES (1,0,13000003871,2858,'2017-08-13 11:28:05'),(2,0,13000011111,1199,'2017-10-05 16:22:30'),(3,0,13000031000,10442,'2017-05-04 09:30:02'),(4,0,13000031001,9445,'2017-05-04 09:31:30'),(6,0,13000038752,5879,'2017-04-22 13:03:37'),(7,0,13000038758,10077,'2017-04-22 13:09:06'),(8,0,13000038777,9175,'2017-05-02 17:51:45'),(9,0,13000038778,1191,'2017-05-02 17:56:13'),(10,0,13000038779,10350,'2017-05-02 18:09:41'),(11,0,13000038780,4200,'2017-05-02 18:10:00'),(12,0,13000038781,6674,'2017-05-02 18:18:02'),(13,0,13000038888,8186,'2017-04-29 15:35:33'),(14,0,13000038999,6167,'2017-05-03 18:27:16'),(15,0,13000039999,8566,'2017-05-04 07:31:38'),(16,0,13000066666,6533,'2017-10-15 08:13:55'),(19,0,13000082011,7026,'2017-07-03 04:47:03'),(20,0,13000082013,1229,'2017-06-17 14:04:59'),(21,0,13000082081,6760,'2017-05-04 07:32:01'),(22,0,13000082111,5650,'2017-06-18 13:36:07'),(23,0,13000082222,9150,'2017-08-13 15:49:32'),(24,0,13000082333,3870,'2017-08-13 15:49:57'),(25,0,13000093794,7563,'2017-04-23 08:29:20'),(26,0,13000099999,7739,'2017-07-23 15:53:25'),(1508072060590,1,13000082009,1121,'2017-10-15 12:54:20'),(1508072096335,1,13000082008,1495,'2017-10-15 12:54:56'),(1508072156293,1,13000082007,7710,'2017-10-15 12:55:56'),(1508072196911,1,13000082031,9802,'2017-10-15 12:56:36'),(1508072543063,0,13000093793,3584,'2017-10-15 13:02:23'),(1508072747213,0,13000070793,5260,'2017-10-15 13:05:47'),(1508072788782,1,13000082045,8191,'2017-10-15 13:06:28'),(1508072814874,1,13000082023,9574,'2017-10-15 13:06:54'),(1508072818273,1,13000082024,7824,'2017-10-15 13:06:58'),(1509026206702,1,15734087934,5754,'2017-10-26 13:56:46'),(1510492736134,1,13000083871,8276,'2017-11-12 13:18:56'),(1510495615328,1,13000082000,3585,'2017-11-12 14:06:55'),(1510501854799,2,13000038710,4742,'2017-11-12 15:50:54'),(1510501857729,0,13000038710,7434,'2017-11-12 15:50:57'),(1511407551440,1,17610725819,3155,'2017-11-23 03:25:51'),(1511761890745,1,13708222312,6007,'2017-11-27 05:51:30'),(1511833743328,2,13000082001,7005,'2017-11-28 01:49:03'),(1511965845624,1,13000082001,4731,'2017-11-29 14:30:45'),(1511965874243,1,13000082111,6391,'2017-11-29 14:31:14'),(1511965892760,1,13000082333,1478,'2017-11-29 14:31:32'),(1511969005317,0,13000082001,9841,'2017-11-29 15:23:25');
4242
/*!40000 ALTER TABLE `Verify` ENABLE KEYS */;
4343
UNLOCK TABLES;
4444
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -51,4 +51,4 @@ UNLOCK TABLES;
5151
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5252
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5353

54-
-- Dump completed on 2017-11-26 19:43:29
54+
-- Dump completed on 2017-11-30 0:05:19

‎table/sys__Visit.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -48,4 +48,4 @@ UNLOCK TABLES;
4848
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4949
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5050

51-
-- Dump completed on 2017-11-26 19:43:29
51+
-- Dump completed on 2017-11-30 0:05:20

0 commit comments

Comments
 (0)