GitLab

CREATE TABLE `api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '接口名称',
  `cn_name` varchar(20) DEFAULT '' COMMENT '接口中文名称',
  `desc` varchar(50) DEFAULT '' COMMENT '接口描述',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT '接口地址',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '接口状态',
  `create_time` int(11) NOT NULL DEFAULT '0',
  `last_upadte` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='接口表'

INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('overdueClassify', '逾期', '逾期信息', 'https://i.trustutn.org/b/overdueClassify', 1, 0, '2016-08-15 09:35:23');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('loanClassify', '共债', '共债信息', 'https://i.trustutn.org/b/loanClassify', 1, 0, '2016-08-15 09:35:46');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('blacklist', '黑名单', '黑名单信息', 'https://i.trustutn.org/b/blacklist', 1, 0, '2016-08-15 09:36:05');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('logStatistics', '其它机构查询', '其它机构查询情况', 'https://i.trustutn.org/b/logStatistics', 1, 0, '2016-08-15 09:36:55');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('idCheck', '身份证验证', '身份证信息验证', 'https://i.trustutn.org/idCheck', 1, 0, '2016-08-15 09:37:31');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('bankcardauth', '银行卡验证', '银行卡实名验证
', 'https://i.trustutn.org/bankcardauth', 1, 0, '2016-08-15 09:38:51');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phoneinfo', '电话号码信息', '电话号码相关查询', 'https://i.trustutn.org/b/phoneinfo', 1, 0, '2016-09-01 06:25:41');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phonetag', '电话号码标记', '电话号码标记查询', 'https://i.trustutn.org/phonetag', 1, 0, '2016-09-01 06:25:42');
INSERT INTO personal_credit.api (name, cn_name, `desc`, url, status, create_time, last_upadte) VALUES ('phoneMatch', '设备号匹配', '手机号设备号匹配查询', 'https://i.trustutn.org/b/phoneMatch', 1, 0, '2016-09-01 06:25:45');