23 lines
1.2 KiB
MySQL
23 lines
1.2 KiB
MySQL
|
--------------------------------------------------------
|
||
|
|
-- DDL for Table JIRA_JSON
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
CREATE TABLE "ENVX_OPER"."JIRA_JSON"
|
||
|
|
( "ID" NUMBER GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOKEEP NOSCALE ,
|
||
|
|
"FETCHED_AT" TIMESTAMP (6) DEFAULT systimestamp,
|
||
|
|
"DOCUMENT" CLOB
|
||
|
|
) SEGMENT CREATION DEFERRED
|
||
|
|
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
||
|
|
NOCOMPRESS LOGGING
|
||
|
|
TABLESPACE "APEX_3800503980117141"
|
||
|
|
LOB ("DOCUMENT") STORE AS SECUREFILE (
|
||
|
|
TABLESPACE "APEX_3800503980117141" ENABLE STORAGE IN ROW 4000 CHUNK 8192
|
||
|
|
CACHE NOCOMPRESS KEEP_DUPLICATES ) ;
|
||
|
|
GRANT SELECT ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT DELETE ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT INSERT ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT UPDATE ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT REFERENCES ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT DEBUG ON "ENVX_OPER"."JIRA_JSON" TO "APEX_REST_PUBLIC_USER";
|
||
|
|
GRANT SELECT ON "ENVX_OPER"."JIRA_JSON" TO "ENVX_AUDIT";
|