Skip to content

Commit 2768d7b

Browse files
TommyLemonTommyLemon
committed
同步table
1 parent a56ad31 commit 2768d7b

10 files changed

Lines changed: 69 additions & 14 deletions

‎table/sys_Comment.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-01 12:33:40
57+
-- Dump completed on 2017-03-02 12:31:57

‎table/sys_Login.sql‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -25,10 +25,10 @@ DROP TABLE IF EXISTS `Login`;
2525
CREATE TABLE `Login` (
2626
`id` bigint(10) NOT NULL AUTO_INCREMENT,
2727
`userId` bigint(15) NOT NULL,
28-
`type` tinyint(2) NOT NULL,
28+
`type` tinyint(1) NOT NULL,
2929
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3030
PRIMARY KEY (`id`)
31-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31+
) ENGINE=InnoDB AUTO_INCREMENT=1488428891642 DEFAULT CHARSET=utf8;
3232
/*!40101 SET character_set_client = @saved_cs_client */;
3333

3434
--
@@ -37,6 +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');
4041
/*!40000 ALTER TABLE `Login` ENABLE KEYS */;
4142
UNLOCK TABLES;
4243
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -49,4 +50,4 @@ UNLOCK TABLES;
4950
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5051
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5152

52-
-- Dump completed on 2017-03-01 12:33:41
53+
-- Dump completed on 2017-03-02 12:31:57

‎table/sys_Moment.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-03-01 12:33:41
56+
-- Dump completed on 2017-03-02 12:31:56

‎table/sys_Password.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-03-01 12:33:41
56+
-- Dump completed on 2017-03-02 12:31:57

‎table/sys_Request.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ CREATE TABLE `Request` (
3131
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
3232
`mapedStructure` json DEFAULT NULL,
3333
PRIMARY KEY (`id`)
34-
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
3535
/*!40101 SET character_set_client = @saved_cs_client */;
3636

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

4141
LOCK TABLES `Request` WRITE;
4242
/*!40000 ALTER TABLE `Request` DISABLE KEYS */;
43-
INSERT INTO `Request` VALUES (1,'POST','User','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"name,phone\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ？','2017-02-01 11:19:51',NULL),(2,'POST','Moment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,title,content,picture\"}',NULL,'2017-02-01 11:19:51',NULL),(3,'POST','Comment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,workId,content\"}',NULL,'2017-02-01 11:19:51',NULL),(4,'PUT','User','{\"disallowColumns\":\"phone\", \"necessaryColumns\":\"id\"}',NULL,'2017-02-01 11:19:51',NULL),(6,'PUT','userPhone','{\"User\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51',NULL),(7,'DELETE','Moment','{\"necessaryColumns\":\"id\"}','所有删除都要有currentUserId和loginPassword？','2017-02-01 11:19:51',NULL),(8,'DELETE','Comment','{\"necessaryColumns\":\"id\"}','disallowColumns没必要用于DELETE','2017-02-01 11:19:51',NULL),(9,'PUT','Password','{\"Password\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,value\"}, \"necessaryColumns\":\"oldPassword\"}','对安全要求高，不允许客户端改type,date等字段','2017-02-01 11:19:51',NULL),(10,'PUT','User.phone','{\"User\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51',NULL),(13,'POST','MomentWithComment','{\"Moment\":{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,title,content,picture\", \"Comment\":{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,workId,content\"}}}','用的极少，可能根本用不上','2017-02-01 11:19:51',NULL),(14,'DELETE','Comment[]','{table:\"Comment\", \"id[]\":\",\"}','用的极少。多个table不好处理','2017-02-01 11:19:51',NULL),(15,'POST','User[]','{\"id[]\":\",\"}','用的比较少，导入联系人、添加进群常用。特殊处理：服务端指定table','2017-02-01 11:19:51',NULL),(16,'POST','User[]','{\"[]\":{\"User\":{\"id\":\"\"}}}','不用RequetParser，用单独的方法批量处理','2017-02-01 11:19:51',NULL),(17,'POST','User[]','{\"User\":[\"id\":\"\"]}','解释成16这种','2017-02-01 11:19:51',NULL),(18,'DELETE','User','{\"necessaryColumns\":\"id\"}','','2017-02-01 11:19:51',NULL),(19,'POST_GET','Password','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"table,tableId\"}','table:String, tableId:Long 表示类型？还是String:table反过来写？','2017-02-18 12:03:17',NULL),(20,'POST_GET','Wallet','{\"Wallet\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"userId\"}, \"necessaryColumns\":\"currentUserId,loginPassword\"}',NULL,'2017-02-18 14:20:43',NULL),(21,'POST_GET','Wallet2','*','*表示接受任何形式的请求','2017-02-18 14:26:38',NULL),(22,'POST_GET','Login','{\"Password\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"table,phone,value\"}, \"User\":{\"necessaryColumns\":\"phone\"}}',NULL,'2017-02-18 14:20:43',NULL);
43+
INSERT INTO `Request` VALUES (1,'POST','User','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"name,phone\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ？','2017-02-01 11:19:51',NULL),(2,'POST','Moment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,title,content,picture\"}',NULL,'2017-02-01 11:19:51',NULL),(3,'POST','Comment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,workId,content\"}',NULL,'2017-02-01 11:19:51',NULL),(4,'PUT','User','{\"disallowColumns\":\"phone\", \"necessaryColumns\":\"id\"}',NULL,'2017-02-01 11:19:51',NULL),(6,'PUT','userPhone','{\"User\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51',NULL),(7,'DELETE','Moment','{\"necessaryColumns\":\"id\"}','所有删除都要有currentUserId和loginPassword？','2017-02-01 11:19:51',NULL),(8,'DELETE','Comment','{\"necessaryColumns\":\"id\"}','disallowColumns没必要用于DELETE','2017-02-01 11:19:51',NULL),(9,'PUT','Password','{\"Password\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,value\"}, \"necessaryColumns\":\"oldPassword\"}','对安全要求高，不允许客户端改type,date等字段','2017-02-01 11:19:51',NULL),(10,'PUT','User.phone','{\"User\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51',NULL),(13,'POST','MomentWithComment','{\"Moment\":{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,title,content,picture\", \"Comment\":{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,workId,content\"}}}','用的极少，可能根本用不上','2017-02-01 11:19:51',NULL),(14,'DELETE','Comment[]','{table:\"Comment\", \"id[]\":\",\"}','用的极少。多个table不好处理','2017-02-01 11:19:51',NULL),(15,'POST','User[]','{\"id[]\":\",\"}','用的比较少，导入联系人、添加进群常用。特殊处理：服务端指定table','2017-02-01 11:19:51',NULL),(16,'POST','User[]','{\"[]\":{\"User\":{\"id\":\"\"}}}','不用RequetParser，用单独的方法批量处理','2017-02-01 11:19:51',NULL),(17,'POST','User[]','{\"User\":[\"id\":\"\"]}','解释成16这种','2017-02-01 11:19:51',NULL),(18,'DELETE','User','{\"necessaryColumns\":\"id\"}','','2017-02-01 11:19:51',NULL),(19,'POST_GET','Password','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"table,tableId\"}','table:String, tableId:Long 表示类型？还是String:table反过来写？','2017-02-18 12:03:17',NULL),(20,'POST_GET','Wallet','{\"Wallet\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"userId\"}, \"necessaryColumns\":\"currentUserId,loginPassword\"}',NULL,'2017-02-18 14:20:43',NULL),(21,'POST_GET','Wallet2','*','*表示接受任何形式的请求','2017-02-18 14:26:38',NULL),(22,'POST_GET','Login','{\"Password\":{\"disallowColumns\":\"!\", \"necessaryColumns\":\"table,phone,value\"}, \"User\":{\"necessaryColumns\":\"phone\"}}',NULL,'2017-02-18 14:20:43',NULL),(23,'POST','Login','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"userId,type\"}',NULL,'2017-02-18 14:20:43',NULL),(24,'POST','Verify','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id,code\"}',NULL,'2017-02-18 14:20:43',NULL),(25,'POST_GET','Verify','{\"necessaryColumns\":\"id\"}',NULL,'2017-02-18 14:20:43',NULL),(26,'DELETE','Verify','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"id\"}',NULL,'2017-02-18 14:20:43',NULL);
4444
/*!40000 ALTER TABLE `Request` 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-03-01 12:33:40
56+
-- Dump completed on 2017-03-02 12:31:57

0 commit comments

Comments
 (0)