-- SQLINES DEMO *** Distrib 5.7.17, for macos10.12 (x86_64)
--
-- SQLINES DEMO *** Database: sys
-- SQLINES DEMO *** -------------------------------------
-- SQLINES DEMO *** 7.33-log
/* SQLINES DEMO *** ARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/* SQLINES DEMO *** ARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/* SQLINES DEMO *** LLATION_CONNECTION=@@COLLATION_CONNECTION */;
/* SQLINES DEMO *** tf8 */;
/* SQLINES DEMO *** ME_ZONE=@@TIME_ZONE */;
/* SQLINES DEMO *** NE='+00:00' */;
/* SQLINES DEMO *** IQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/* SQLINES DEMO *** REIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/* SQLINES DEMO *** L_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/* SQLINES DEMO *** L_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- SQLINES DEMO *** or table `Document`
--
DROP TABLE IF EXISTS Document;
/* SQLINES DEMO *** cs_client = @@character_set_client */;
/* SQLINES DEMO *** er_set_client = utf8 */;
-- SQLINES LICENSE FOR EVALUATION USE ONLY
CREATE TABLE Document (
id bigint NOT NULL AUTO_INCREMENT ,
userId bigint NOT NULL ,
testAccountId bigint NOT NULL DEFAULT '0' ,
version tinyint NOT NULL DEFAULT '3' ,
name varchar(100) NOT NULL ,
type varchar(5) NOT NULL DEFAULT 'JSON' ,
url varchar(250) NOT NULL ,
request clob NOT NULL ,
standard clob,
header clob ,
date timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (id)
) ;
/* SQLINES DEMO *** er_set_client = @saved_cs_client */;
--
-- SQLINES DEMO *** table `Document`
--
LOCK TABLES Document WRITE;
/* SQLINES DEMO *** `Document` DISABLE KEYS */;
INSERT INTO Document VALUES (1,82001,82001,1,'','JSON','/login','{n "type": 0, //0- 1-n "phone": "13000082001", //n "password": "123456", //n "version": 1, //n "remember": false //n}',NULL,NULL,'2017-11-26 07:35:19'),(2,82001,0,1,'(type:1)','JSON','/register','{n "Privacy": {n "phone": "13000083333",n "_password": "123456"n },n "User": {n "name": "APIJSONUser"n },n "verify": "6840" // /post/verifyn}',NULL,NULL,'2017-11-26 07:35:19'),(3,82001,0,1,'','JSON','/logout','{}',NULL,NULL,'2017-11-26 09:56:10'),(1511689914599,82001,0,1,'','JSON','/gets','{"tag": "Privacy", "Privacy": {"id": 82001}}',NULL,NULL,'2017-11-26 09:51:54'),(1511796155276,82001,0,1,'','JSON','/post/verify','{n "type": 0, //: 0- 1- 2- 3-n "phone": "13000082001" //n}',NULL,NULL,'2017-11-27 15:23:28'),(1511796208671,82001,0,1,'','JSON','/heads/verify','{n "type": 0, //: 0- 1- 2- 3-n "phone": "13000082001" //n}',NULL,NULL,'2017-11-27 15:23:28'),(1511796589078,82001,82001,1,'(type:2)-+','JSON','/put/password','{n "verify": "10322", // /post/verifyn "Privacy": {n "phone": "13000082001",n "_password": "666666"n }n}',NULL,NULL,'2017-11-27 15:23:28'),(1511796882184,82001,82001,1,'()/','JSON','/put/balance','{"tag": "Privacy", "Privacy": {"id": 82001, "balance+": 100.15, "_payPassword": "123456"}}',NULL,NULL,'2017-11-27 15:34:42'),(1511969417633,82001,82001,1,'/','JSON','/put','{n "Moment": {n "id": 15,n "praiseUserIdList-": [n 82001n ]n },n "tag": "Moment"n}',NULL,NULL,'2017-11-29 15:30:17'),(1511969630372,82001,82001,1,'','JSON','/post','{ "Comment": { "momentId": 15, "content": "" }, "tag": "Comment" }',NULL,NULL,'2017-11-29 15:33:50'),(1511970009072,82001,82001,1,'','JSON','/post','{ "Moment": { "content": "", "pictureList": ["http://static.oschina.net/uploads/user/48/96331_50.jpg" ] }, "tag": "Moment" }',NULL,NULL,'2017-11-29 15:40:09'),(1511970224333,82001,82001,1,'','JSON','/put','{r "User": {r "id": 82001,r "name": ""r },r "tag": "User"r }',NULL,NULL,'2017-11-29 15:43:44'),(1521901518765,88888,0,2,'(): pictureList0','JSON','/get','{ "User": { "id": 38710, "@position": 0, "firstPicture()": "getFromArray(pictureList,@position)" } }',NULL,NULL,'2018-03-24 14:25:18'),(1521901610784,88888,0,2,'(): userIdid>=100 Moment','JSON','/get','{"[]":{"count":10,"Moment":{"@column":"userId;max(id):maxId","@group":"userId","@having":"maxId>=100"}}}',NULL,NULL,'2018-03-24 14:26:50'),(1521901682846,88888,0,2,'(): userIdMoment','JSON','/get','{"[]":{"count":10,"Moment":{"@column":"userId,id","@group":"userId,id"}}}',NULL,NULL,'2018-03-24 14:28:02'),(1521901746809,88888,0,2,'(): nameid User','JSON','/get','{"[]":{"count":10,"User":{"@column":"name,id","@order":"name-,id"}}}',NULL,NULL,'2018-03-24 14:29:06'),(1521901787203,88888,0,2,'(): id,sex,name','JSON','/get','{"User":{"@column":"id,sex,name","id":38710}}',NULL,NULL,'2018-03-24 14:29:47'),(1521902033332,88888,0,2,'(): UserUser','JSON','/get','{"[]":{"query":2,"count":5,"User":{}},"total@":"/[]/total"}',NULL,NULL,'2018-03-24 14:33:53'),(1521902069871,88888,0,2,'(): 3User5','JSON','/get','{"[]":{"count":5,"page":3,"User":{}}}',NULL,NULL,'2018-03-24 14:34:29'),(1521902110680,88888,0,2,'(): User5','JSON','/get','{"[]":{"count":5,"User":{}}}',NULL,NULL,'2018-03-24 14:35:10'),(1521903761689,88888,0,2,'(): ! ','JSON','/head','{"User":{"id!{}":[82001,38710]}}',NULL,NULL,'2018-03-24 15:02:41'),(1521903828410,88888,0,2,'(): | ','JSON','/head','{"User":{"id|{}":">90000,80000,0",n "firstPicture()": "getFromArray(pictureList,0)"n }n }n}',NULL,NULL,'2018-03-24 16:03:13'),(1521907333044,82001,82002,3,'-+30','JSON','/get','{r "User": {r "id": 82002r },r "Moment-firstPicture[]": {r "count": 3,r "Moment": {r "userId@": "User/id",r "@column": "userId,pictureList",r "@having": "json_length(pictureList)>0",r "firstPicture()": "getFromArray(pictureList,0)"r }r }r }',NULL,NULL,'2018-03-24 16:03:13'),(1521907333046,88888,0,2,'','JSON','/get','{ "Moment[]": { "join": "&/User/id@", "Moment": {}, "User": { "id@": "/Moment/userId", "contactIdList": 82001, "@column": "id" } } }',NULL,NULL,'2018-03-24 16:03:13'),(1521907546129,88888,0,2,'','JSON','/get','{n "[]": {n "page": 0,n "count": 2,n "Moment": {n "content$": "%a%"n },n "User": {n "id@": "/Moment/userId",n "@column": "id,name,head"n },n "Comment[]": {n "count": 2,n "Comment": {n "momentId@": "[]/Moment/id"n }n }n }n}',NULL,NULL,'2018-03-24 16:05:46'),(1521907570452,88888,0,2,'','JSON','/get','{n "Moment": {},n "User": {n "id@": "Moment/userId"n }n}',NULL,NULL,'2018-03-24 16:06:10'),(1521907587430,88888,0,2,'','JSON','/get','{n "[]": {n "count": 3,n "User": {n "@column": "id,name"n }n }n}',NULL,NULL,'2018-03-24 16:06:27'),(1521907601299,88888,0,2,'','JSON','/get','{n "User":{n }n}',NULL,NULL,'2018-03-24 16:06:41'),(1522905263828,82001,0,2,'(DELETE): ','JSON','/delete','{n "Moment":{n "id":120n },n "tag":"Moment"n}',NULL,NULL,'2018-03-24 13:27:43'),(1522905599150,82001,0,2,'(PUT): ','JSON','/put','{n "Moment":{n "id":235,n "content":"APIJSON,let interfaces and documents go to hell !"n },n "tag":"Moment"n}',NULL,NULL,'2018-03-24 13:33:19'),(1522905680680,82001,0,2,'(POST): ','JSON','/post','{ "Moment": { "content": "APIJSON,let interfaces and documents go to hell !" }, "tag": "Moment" }',NULL,NULL,'2018-03-24 13:34:40'),(1522905787850,82001,0,2,'(HEADS): / ','JSON','/heads','{n "Login": {n "userId": 38710,"type":1n },n "tag": "Login"n}',NULL,NULL,'2018-03-24 13:36:27'),(1522905868719,82001,0,2,'(GETS): / ','JSON','/gets','{n "Privacy": {n "id": 82001n },n "tag": "Privacy"n}',NULL,NULL,'2018-03-24 13:37:48'),(1522905895591,82001,0,2,'(HEAD): ','JSON','/head','{n "Moment":{n "userId":38710n }n}',NULL,NULL,'2018-03-24 13:38:15'),(1522905913188,82001,0,2,'(GET): ','JSON','/get','{n "Moment":{n "id":235n }n}',NULL,NULL,'2018-03-24 13:38:33'),(1544881887527,88888,0,3,'Moment INNER JOIN User LEFT JOIN Comment','JSON','/get','{n "[]": {n "count": 10,n "page": 0,n "join": "&/User/id@,