oracle

CREATE TABLE "API_EXAMPLE" (
  "ID" VARCHAR2(45 BYTE),
  "API_INFO_ID" VARCHAR2(45 BYTE),
  "METHOD" VARCHAR2(45 BYTE),
  "URL" CLOB,
  "REQUEST_HEADER" CLOB,
  "REQUEST_BODY" CLOB,
  "RESPONSE_HEADER" CLOB,
  "RESPONSE_BODY" CLOB,
  "STATUS" VARCHAR2(10 BYTE),
  "OPTIONS" CLOB,
  "EDITOR" VARCHAR2(45 BYTE),
  "CREATE_TIME" VARCHAR2(45 BYTE),
  "ELAPSED_TIME" NUMBER
)

CREATE TABLE "API_INFO" (
  "ID" VARCHAR2(45 BYTE),
  "METHOD" VARCHAR2(45 BYTE),
  "PATH" VARCHAR2(100 BYTE),
  "TYPE" VARCHAR2(5 BYTE),
  "SERVICE" VARCHAR2(45 BYTE),
  "GROUP_NAME" VARCHAR2(45 BYTE),
  "EDITOR" VARCHAR2(45 BYTE),
  "NAME" VARCHAR2(200 BYTE),
  "DATASOURCE" VARCHAR2(45 BYTE),
  "SCRIPT" CLOB,
  "OPTIONS" CLOB,
  "CREATE_TIME" VARCHAR2(45 BYTE),
  "UPDATE_TIME" VARCHAR2(45 BYTE)
)

CREATE TABLE "API_INFO_HISTORY" 
   (	"ID" VARCHAR2(45), 
	"API_INFO_ID" VARCHAR2(45), 
	"METHOD" VARCHAR2(45), 
	"PATH" VARCHAR2(100), 
	"TYPE" VARCHAR2(5), 
	"SERVICE" VARCHAR2(45), 
	"GROUP_NAME" VARCHAR2(45), 
	"EDITOR" VARCHAR2(45), 
	"NAME" VARCHAR2(200), 
	"DATASOURCE" VARCHAR2(45), 
	"SCRIPT" CLOB, 
	"OPTIONS" CLOB, 
	"CREATE_TIME" VARCHAR2(45)
)

//在开启了spring.rocket-api.config-enabled=true才需要此表
CREATE TABLE "API_CONFIG" (
  "ID" VARCHAR2(45),
  "SERVICE" VARCHAR2(45), 
  "CONFIG_CONTEXT" CLOB
)


CREATE TABLE "API_DIRECTORY" (
  "ID" VARCHAR2(45),
  "SERVICE" VARCHAR2(45), 
  "NAME" VARCHAR2(45), 
  "PATH" VARCHAR2(200), 
  "PARENT_ID" VARCHAR2(45) 
)