GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing github.com — 同步table，新增Response · Crasader/APIJSON@9b1d33a

File tree

Expand file treeCollapse file tree

Open diff view settings

Filter options

table

Expand file treeCollapse file tree

Open diff view settings

Collapse file

`‎table/sys_Comment.sql‎`

Copy file name to clipboardExpand all lines: table/sys_Comment.sql

+2-2Lines changed: 2 additions & 2 deletions

Large diffs are not rendered by default.

Collapse file

`‎table/sys_Login.sql‎`

Copy file name to clipboardExpand all lines: table/sys_Login.sql

+3-3Lines changed: 3 additions & 3 deletions

Large diffs are not rendered by default.

Collapse file

`‎table/sys_Moment.sql‎`

Copy file name to clipboardExpand all lines: table/sys_Moment.sql

+2-2Lines changed: 2 additions & 2 deletions

Large diffs are not rendered by default.

Collapse file

`‎table/sys_Password.sql‎`

Copy file name to clipboardExpand all lines: table/sys_Password.sql

+2-2Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
@@ -38,7 +38,7 @@ CREATE TABLE `Password` (
`38`	`38`
`39`	`39`	LOCK TABLES `Password` WRITE;
`40`	`40`	/!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'),(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'),(13000038726,'User',NULL,'123456','2017-04-01 02:50:49'),(13000038730,'User',NULL,'123456','2017-03-12 06:01:23'),(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');
	`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'),(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');
`42`	`42`	/!40000 ALTER TABLE `Password` ENABLE KEYS /;
`43`	`43`	`UNLOCK TABLES;`
`44`	`44`	`/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;`
`@@ -51,4 +51,4 @@ UNLOCK TABLES;`
`51`	`51`	`/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;`
`52`	`52`	`/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;`
`53`	`53`
`54`		`--- Dump completed on 2017-04-05 10:14:23`
	`54`	`+-- Dump completed on 2017-04-10 15:21:06`

Collapse file

`‎table/sys_Reponse.sql‎`

Copy file name to clipboard

+56Lines changed: 56 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,56 @@`
	`1`	`+-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)`
	`2`	`+--`
	`3`	`+-- Host: localhost Database: sys`
	`4`	`+-- ------------------------------------------------------`
	`5`	`+-- Server version 5.7.16`
	`6`	`+`
	`7`	`+/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;`
	`8`	`+/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;`
	`9`	`+/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;`
	`10`	`+/!40101 SET NAMES utf8 /;`
	`11`	`+/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;`
	`12`	`+/!40103 SET TIME_ZONE='+00:00' /;`
	`13`	`+/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;`
	`14`	`+/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;`
	`15`	`+/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;`
	`16`	`+/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;`
	`17`	`+`
	`18`	`+--`
	`19`	+-- Table structure for table `Reponse`
	`20`	`+--`
	`21`	`+`
	`22`	+DROP TABLE IF EXISTS `Reponse`;
	`23`	`+/!40101 SET @saved_cs_client = @@character_set_client /;`
	`24`	`+/!40101 SET character_set_client = utf8 /;`
	`25`	+CREATE TABLE `Reponse` (
	`26`	+ `id` int(11) NOT NULL,
	`27`	+ `method` varchar(10) DEFAULT 'GET',
	`28`	+ `tag` varchar(20) NOT NULL,
	`29`	+ `structure` json NOT NULL,
	`30`	+ `description` varchar(10000) DEFAULT NULL,
	`31`	+ `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
	`32`	+ PRIMARY KEY (`id`),
	`33`	+ UNIQUE KEY `id_UNIQUE` (`id`)
	`34`	`+) ENGINE=InnoDB DEFAULT CHARSET=utf8;`
	`35`	`+/!40101 SET character_set_client = @saved_cs_client /;`
	`36`	`+`
	`37`	`+--`
	`38`	+-- Dumping data for table `Reponse`
	`39`	`+--`
	`40`	`+`
	`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 /;
	`45`	`+UNLOCK TABLES;`
	`46`	`+/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;`
	`47`	`+`
	`48`	`+/!40101 SET SQL_MODE=@OLD_SQL_MODE /;`
	`49`	`+/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;`
	`50`	`+/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;`
	`51`	`+/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;`
	`52`	`+/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;`
	`53`	`+/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;`
	`54`	`+/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;`
	`55`	`+`
	`56`	`+-- Dump completed on 2017-04-10 15:21:06`

Collapse file

`‎table/sys_Request.sql‎`

Copy file name to clipboardExpand all lines: table/sys_Request.sql

+7-7Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
@@ -23,15 +23,15 @@ DROP TABLE IF EXISTS `Request`;
`23`	`23`	`/!40101 SET @saved_cs_client = @@character_set_client /;`
`24`	`24`	`/!40101 SET character_set_client = utf8 /;`
`25`	`25`	CREATE TABLE `Request` (
`26`		- `id` int(11) NOT NULL AUTO_INCREMENT,
	`26`	+ `id` int(11) NOT NULL,
`27`	`27`	`method` varchar(10) DEFAULT 'GET',
`28`	`28`	`tag` varchar(20) NOT NULL,
`29`		- `structure` varchar(1000) NOT NULL,
	`29`	+ `structure` json NOT NULL,
`30`	`30`	`description` varchar(10000) DEFAULT NULL,
`31`	`31`	`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`32`		- `mapedStructure` json DEFAULT NULL,
`33`		- PRIMARY KEY (`id`)
`34`		`-) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;`
	`32`	+ PRIMARY KEY (`id`),
	`33`	+ UNIQUE KEY `id_UNIQUE` (`id`)
	`34`	`+) ENGINE=InnoDB DEFAULT CHARSET=utf8;`
`35`	`35`	`/!40101 SET character_set_client = @saved_cs_client /;`
`36`	`36`
`37`	`37`	`--`
@@ -40,7 +40,7 @@ CREATE TABLE `Request` (
`40`	`40`
`41`	`41`	LOCK TABLES `Request` WRITE;
`42`	`42`	/!40000 ALTER TABLE `Request` DISABLE KEYS /;
`43`		-INSERT INTO `Request` VALUES (1,'POST','User','{\"User\":{\"disallowColumns\":\"id\", \"necessaryColumns\":\"name,phone\"}, \"necessaryColumns\":\"password,verify\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ？','2017-02-01 11:19:51',NULL),(2,'POST','Moment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,pictureList\"}',NULL,'2017-02-01 11:19:51',NULL),(3,'POST','Comment','{\"disallowColumns\":\"id\", \"necessaryColumns\":\"userId,momentId,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),(18,'DELETE','User','{\"necessaryColumns\":\"id\"}','','2017-02-01 11:19:51',NULL),(19,'POST_GET','Password','{\"disallowColumns\":\"!\", \"necessaryColumns\":\"table,tableId\"}','String:table, Long: tableId 限制类型？','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),(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),(27,'POST_HEAD','Verify','{}',NULL,'2017-02-18 14:20:43',NULL),(28,'PUT','Moment','{\"disallowColumns\":\"userId,date\", \"necessaryColumns\":\"id\"}',NULL,'2017-02-01 11:19:51',NULL);
	`43`	+INSERT INTO `Request` VALUES (1,'POST','User','{\"User\": {\"disallowColumns\": \"id\", \"necessaryColumns\": \"name,phone\"}, \"necessaryColumns\": \"password,verify\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ？','2017-02-01 11:19:51'),(2,'POST','Moment','{\"disallowColumns\": \"id\", \"necessaryColumns\": \"userId,pictureList\"}',NULL,'2017-02-01 11:19:51'),(3,'POST','Comment','{\"disallowColumns\": \"id\", \"necessaryColumns\": \"userId,momentId,content\"}',NULL,'2017-02-01 11:19:51'),(4,'PUT','User','{\"disallowColumns\": \"phone\", \"necessaryColumns\": \"id\"}',NULL,'2017-02-01 11:19:51'),(6,'PUT','userPhone','{\"User\": {\"disallowColumns\": \"!\", \"necessaryColumns\": \"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51'),(7,'DELETE','Moment','{\"necessaryColumns\": \"id\"}','所有删除都要有currentUserId和loginPassword？','2017-02-01 11:19:51'),(8,'DELETE','Comment','{\"necessaryColumns\": \"id\"}','disallowColumns没必要用于DELETE','2017-02-01 11:19:51'),(9,'PUT','Password','{\"Password\": {\"disallowColumns\": \"!\", \"necessaryColumns\": \"id,value\"}, \"necessaryColumns\": \"oldPassword\"}','对安全要求高，不允许客户端改type,date等字段','2017-02-01 11:19:51'),(10,'PUT','User.phone','{\"User\": {\"disallowColumns\": \"!\", \"necessaryColumns\": \"id,phone\"}}','! 表示其它所有，这里指necessaryColumns所有未包含的字段','2017-02-01 11:19:51'),(13,'POST','MomentWithComment','{\"Moment\": {\"Comment\": {\"disallowColumns\": \"id\", \"necessaryColumns\": \"userId,workId,content\"}, \"disallowColumns\": \"id\", \"necessaryColumns\": \"userId,title,content,picture\"}}','用的极少，可能根本用不上','2017-02-01 11:19:51'),(18,'DELETE','User','{\"necessaryColumns\": \"id\"}','','2017-02-01 11:19:51'),(19,'POST_GET','Password','{\"disallowColumns\": \"!\", \"necessaryColumns\": \"table,tableId\"}','String:table, Long: tableId 限制类型？','2017-02-18 12:03:17'),(20,'POST_GET','Wallet','{\"Wallet\": {\"disallowColumns\": \"!\", \"necessaryColumns\": \"userId\"}, \"necessaryColumns\": \"currentUserId,loginPassword\"}',NULL,'2017-02-18 14:20:43'),(22,'POST_GET','Login','{\"User\": {\"necessaryColumns\": \"phone\"}, \"Password\": {\"disallowColumns\": \"!\", \"necessaryColumns\": \"table,phone,value\"}}',NULL,'2017-02-18 14:20:43'),(23,'POST','Login','{\"disallowColumns\": \"!\", \"necessaryColumns\": \"userId,type\"}',NULL,'2017-02-18 14:20:43'),(24,'POST','Verify','{\"disallowColumns\": \"!\", \"necessaryColumns\": \"id,code\"}',NULL,'2017-02-18 14:20:43'),(25,'POST_GET','Verify','{\"necessaryColumns\": \"id\"}',NULL,'2017-02-18 14:20:43'),(26,'DELETE','Verify','{\"disallowColumns\": \"!\", \"necessaryColumns\": \"id\"}',NULL,'2017-02-18 14:20:43'),(27,'POST_HEAD','Verify','{}',NULL,'2017-02-18 14:20:43'),(28,'PUT','Moment','{\"disallowColumns\": \"userId,date\", \"necessaryColumns\": \"id\"}',NULL,'2017-02-01 11:19:51');
`44`	`44`	/!40000 ALTER TABLE `Request` ENABLE KEYS /;
`45`	`45`	`UNLOCK TABLES;`
`46`	`46`	`/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;`
`@@ -53,4 +53,4 @@ UNLOCK TABLES;`
`53`	`53`	`/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;`
`54`	`54`	`/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;`
`55`	`55`
`56`		`--- Dump completed on 2017-04-05 10:14:22`
	`56`	`+-- Dump completed on 2017-04-10 15:21:06`

0 commit comments

Comments

0 (0)

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.