31 lines
1.2 KiB
MySQL
31 lines
1.2 KiB
MySQL
|
--------------------------------------------------------
|
||
|
|
-- DDL for Table DEPLOYMENT_REQUEST_QUEUE
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
CREATE TABLE "ENVX_OPER"."DEPLOYMENT_REQUEST_QUEUE"
|
||
|
|
( "ID_QUEUE" NUMBER(*,0),
|
||
|
|
"ID_REQUEST" NUMBER(*,0),
|
||
|
|
"QUEUE_DATE" DATE,
|
||
|
|
"QUEUE_ORDER" NUMBER(*,0),
|
||
|
|
"ID_PARENT_QUEUE" NUMBER(*,0),
|
||
|
|
"ID_SCHEDULE" NUMBER(*,0),
|
||
|
|
"ID_SCHEDULE_DETAIL" NUMBER(*,0),
|
||
|
|
"DEPLOY_DATE" DATE,
|
||
|
|
"QUEUE_ALIAS" VARCHAR2(100 BYTE),
|
||
|
|
"STATUS_QUEUE" NUMBER DEFAULT 0,
|
||
|
|
"JOB_NAME" VARCHAR2(100 BYTE),
|
||
|
|
"SYS_STS02RKX$ZJ0KOB9#VHGDFLG37" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("STATUS_QUEUE","JOB_NAME")) VIRTUAL
|
||
|
|
) SEGMENT CREATION IMMEDIATE
|
||
|
|
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
||
|
|
NOCOMPRESS LOGGING
|
||
|
|
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
||
|
|
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
||
|
|
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
||
|
|
TABLESPACE "APEX_3800503980117141" ;
|
||
|
|
|
||
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST_QUEUE"."STATUS_QUEUE" IS '0-programado/
|
||
|
|
1-procesando/
|
||
|
|
2-terminado/
|
||
|
|
3-suspendido ';
|
||
|
|
GRANT SELECT ON "ENVX_OPER"."DEPLOYMENT_REQUEST_QUEUE" TO "ENVX_AUDIT";
|