接口

转载

mb5fdb128f2dba9 2019-08-20 23:12:00

DROP TABLE IF EXISTS `APIINFO`;
CREATE TABLE `APIINFO`  (
  `ANF_ID` INT(4) NOT NULL AUTO_INCREMENT,
  `ANF_PID` INT(4) NULL DEFAULT NULL,
  `ANF_NAME` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
  `ANF_HOSTNAME` VARCHAR(200) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
  `ANF_PATH` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
	`ANF_METHOD` INT(4) NOT NULL DEFAULT 1,
  `ANF_DELETED_FLAG` BIT(1) NULL DEFAULT B'0',
  `ANF_MEMO` VARCHAR(200) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
  `ANF_CREATEDT` DATETIME(0) NOT NULL,
  `ANF_UPDATEDT` DATETIME(0) NOT NULL,
	`ANF_CREATEUID` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
	`ANF_UPDATEUID` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
  PRIMARY KEY (`ANF_ID`) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET = UTF8MB4 COLLATE = UTF8MB4_GENERAL_CI ROW_FORMAT = DYNAMIC;


show tables

DROP TABLE IF EXISTS `PROJECT`;
CREATE TABLE `PROJECT`  (
  `PROJECT_ID` INT(4) NOT NULL AUTO_INCREMENT,
  `PROJECT_NAME` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,
  `PROJECT_IMAGE` VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_GENERAL_CI NULL DEFAULT NULL,		
	 PRIMARY KEY (`PROJECT_ID`) USING BTREE
	) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET = UTF8MB4 COLLATE = UTF8MB4_GENERAL_CI ROW_FORMAT = DYNAMIC;

select * from project
insert project(PROJECT_NAME,PROJECT_IMAGE) values('优酷','youku.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('饿了么','eleme.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('抖音','douyin.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('快播','kuaibo.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('快手','kuaishou.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('携程','xiecheng.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('平安','pingan.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('淘宝','taobao.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('天猫','tmall.jpg');
insert project(PROJECT_NAME,PROJECT_IMAGE) values('京东','jingdong.jpg');


Select * from apiinfo

insert APIINFO(anf_pid,anf_name,anf_hostname,anf_path,anf_method,anf_deleted_flag,anf_memo,anf_createdt,anf_updatedt,anf_createuid,anf_updateuid)
values(1,'register','localhost:8087','/register',1,0,'memo',now(),now(),'123','123')


select * from qa_employ

update qa_employ set employ_email = ''