-- 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 `Function`

--

DROP TABLE IF EXISTS [Function];

/* SQLINES DEMO *** cs_client = @@character_set_client */;

/* SQLINES DEMO *** er_set_client = utf8 */;

-- SQLINES LICENSE FOR EVALUATION USE ONLY

CREATE TABLE Function (

[id] bigint NOT NULL IDENTITY,

[userId] bigint NOT NULL ,

[name] varchar(50) NOT NULL ,

[arguments] varchar(100) DEFAULT NULL ,

[demo] json NOT NULL ,

[detail] varchar(1000) NOT NULL ,

[type] varchar(50) NOT NULL DEFAULT 'Object' ,

[version] smallint NOT NULL DEFAULT '0' ,

[tag] varchar(20) DEFAULT NULL ,

[methods] varchar(50) DEFAULT NULL ,

[date] datetime2(0) NOT NULL DEFAULT GETDATE() ,

[back] varchar(45) DEFAULT NULL ,

PRIMARY KEY ([id])

) ;

/* SQLINES DEMO *** er_set_client = @saved_cs_client */;

--

-- SQLINES DEMO *** table `Function`

--

LOCK TABLES [Function] WRITE;

/* SQLINES DEMO *** `Function` DISABLE KEYS */;

INSERT INTO Function VALUES (3,0,'countArray','array','{"array": [1, 2, 3]}','获取数组长度。没写调用键值对，会自动补全 "result()": "countArray(array)"','Object',0,NULL,NULL,'2018-10-13 08:23:23',NULL),(4,0,'countObject','object','{"object": {"key0": 1, "key1": 2}}','获取对象长度。','Object',0,NULL,NULL,'2018-10-13 08:23:23',NULL),(5,0,'isContain','array,value','{"array": [1, 2, 3], "value": 2}','判断是否数组包含值。','Object',0,NULL,NULL,'2018-10-13 08:23:23',NULL),(6,0,'isContainKey','object,key','{"key": "id", "object": {"id": 1}}','判断是否对象包含键。','Object',0,NULL,NULL,'2018-10-13 08:30:31',NULL),(7,0,'isContainValue','object,value','{"value": 1, "object": {"id": 1}}','判断是否对象包含值。','Object',0,NULL,NULL,'2018-10-13 08:30:31',NULL),(8,0,'getFromArray','array,position','{"array": [1, 2, 3], "result()": "getFromArray(array,1)"}','根据下标获取数组里的值。position 传数字时直接作为值，而不是从所在对象 request 中取值','Object',0,NULL,NULL,'2018-10-13 08:30:31',NULL),(9,0,'getFromObject','object,key','{"key": "id", "object": {"id": 1}}','根据键获取对象里的值。','Object',0,NULL,NULL,'2018-10-13 08:30:31',NULL),(10,0,'deleteCommentOfMoment','momentId','{"momentId": 1}','根据动态 id 删除它的所有评论','Object',0,'Moment','DELETE','2019-08-17 18:46:56',NULL),(11,0,'verifyIdList','array','{"array": [1, 2, 3], "result()": "verifyIdList(array)"}','校验类型为 id 列表','Object',0,NULL,NULL,'2019-08-17 19:58:33',NULL),(12,0,'verifyURLList','array','{"array": ["http://123.com/1.jpg", "http://123.com/a.png", "http://www.abc.com/test.gif"], "result()": "verifyURLList(array)"}','校验类型为 URL 列表','Object',0,NULL,NULL,'2019-08-17 19:58:33',NULL),(13,0,'getWithDefault','value,defaultValue','{"value": null, "defaultValue": 1}','如果 value 为 null，则返回 defaultValue','Object',0,NULL,NULL,'2019-08-20 15:26:36',NULL),(14,0,'removeKey','key','{"key": "s", "key2": 2}','从对象里移除 key','Object',0,NULL,NULL,'2019-08-20 15:26:36',NULL),(15,0,'getFunctionDemo',NULL,'{}','获取远程函数的 Demo','Object',0,NULL,NULL,'2019-08-20 15:26:36',NULL),(16,0,'getFunctionDetail',NULL,'{}','获取远程函数的详情','Object',0,NULL,NULL,'2019-08-20 15:26:36',NULL);

/* SQLINES DEMO *** `Function` ENABLE KEYS */;

UNLOCK TABLES;

/* SQLINES DEMO *** NE=@OLD_TIME_ZONE */;

/* SQLINES DEMO *** E=@OLD_SQL_MODE */;

/* SQLINES DEMO *** _KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/* SQLINES DEMO *** CHECKS=@OLD_UNIQUE_CHECKS */;

/* SQLINES DEMO *** ER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/* SQLINES DEMO *** ER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/* SQLINES DEMO *** ON_CONNECTION=@OLD_COLLATION_CONNECTION */;

/* SQLINES DEMO *** ES=@OLD_SQL_NOTES */;

-- SQLINES DEMO *** 2021-06-21 23:26:20