OOZIE-1887 Remove the utils dir (kvntrieu via rkanter)
Project: http://git-wip-us.apache.org/repos/asf/oozie/repo Commit: http://git-wip-us.apache.org/repos/asf/oozie/commit/abb2e186 Tree: http://git-wip-us.apache.org/repos/asf/oozie/tree/abb2e186 Diff: http://git-wip-us.apache.org/repos/asf/oozie/diff/abb2e186 Branch: refs/heads/oya Commit: abb2e186ec0f2f200a0d64ef5174caf023b17424 Parents: c8748d2 Author: Robert Kanter <[email protected]> Authored: Fri Mar 10 12:24:30 2017 -0800 Committer: Robert Kanter <[email protected]> Committed: Fri Mar 10 12:24:30 2017 -0800 ---------------------------------------------------------------------- release-log.txt | 1 + utils/dbutils/updatescripts/dbscripts-2.2.5.sql | 330 --------------- utils/dbutils/updatescripts/dbscripts-3.0.0.sql | 409 ------------------ utils/dbutils/updatescripts/dbscripts-3.0.1.sql | 414 ------------------ utils/dbutils/updatescripts/dbscripts-3.1.0.sql | 417 ------------------- utils/dbutils/updatescripts/readme.txt | 7 - .../updatescripts-2.x-to-3.0.0.sql | 101 ----- .../updatescripts-2.x-to-3.0.1.sql | 104 ----- .../updatescripts-3.0.0-to-3.0.1.sql | 23 - .../updatescripts-3.x-to-3.1.0.sql | 20 - .../upgradescript-2.x-to-3.0.0.sql | 37 -- 11 files changed, 1 insertion(+), 1862 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/release-log.txt ---------------------------------------------------------------------- diff --git a/release-log.txt b/release-log.txt index 5c55cad..b5365f8 100644 --- a/release-log.txt +++ b/release-log.txt @@ -1,5 +1,6 @@ -- Oozie 4.4.0 release (trunk - unreleased) +OOZIE-1887 Remove the utils dir (kvntrieu via rkanter) OOZIE-2540 Create a PySpark example (abhishekbafna via rkanter) OOZIE-807 Docs can be explicit about multiple sub-workflow definitions being possible (qwertymaniac via rkanter) OOZIE-2811 Add support for filtering out properties from SparkConfigurationService (gezapeti via rkanter) http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-2.2.5.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/dbscripts-2.2.5.sql b/utils/dbutils/updatescripts/dbscripts-2.2.5.sql deleted file mode 100644 index 46b5e90..0000000 --- a/utils/dbutils/updatescripts/dbscripts-2.2.5.sql +++ /dev/null @@ -1,330 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -# please replace "OOZIEDB" to your schema name - -CREATE TABLE "OOZIEDB"."VALIDATE_CONN" - ("ID" NUMBER NOT NULL ENABLE, -"DUMMY" NUMBER, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED -PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING -TABLESPACE "OOZIEDB"; - -CREATE TABLE "OOZIEDB"."COORD_ACTIONS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"ACTION_NUMBER" NUMBER, -"ACTION_XML" CLOB, -"CONSOLE_URL" VARCHAR2(255), -"CREATED_CONF" CLOB, -"ERROR_CODE" VARCHAR2(255), -"ERROR_MESSAGE" VARCHAR2(255), -"EXTERNAL_STATUS" VARCHAR2(255), -"MISSING_DEPENDENCIES" CLOB, -"RUN_CONF" CLOB, -"TIME_OUT" NUMBER, -"TRACKER_URI" VARCHAR2(255), -"JOB_TYPE" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"CREATED_TIME" TIMESTAMP (6), -"EXTERNAL_ID" VARCHAR2(255), -"JOB_ID" VARCHAR2(255), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"NOMINAL_TIME" TIMESTAMP (6), -"RERUN_TIME" TIMESTAMP (6), -"SLA_XML" CLOB, -"STATUS" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("ACTION_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("CREATED_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("RUN_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."COORD_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"BUNDLE_ID" VARCHAR2(255), -"CONCURRENCY" NUMBER, -"CONF" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"FREQUENCY" NUMBER, -"GROUP_NAME" VARCHAR2(255), -"LAST_ACTION_NUMBER" NUMBER, -"TIME_OUT" NUMBER, -"TIME_ZONE" VARCHAR2(255), -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"EXECUTION" VARCHAR2(255), -"JOB_XML" CLOB, -"LAST_ACTION" TIMESTAMP (6), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"NEXT_MATD_TIME" TIMESTAMP (6), -"ORIG_JOB_XML" CLOB, -"PAUSE_TIME" TIMESTAMP (6), -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"SUSPENDED_TIME" TIMESTAMP (6), -"TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."SLA_EVENTS" - ("EVENT_ID" NUMBER NOT NULL ENABLE, -"ALERT_CONTACT" VARCHAR2(255), -"ALERT_FREQUENCY" VARCHAR2(255), -"ALERT_PERCENTAGE" VARCHAR2(255), -"APP_NAME" VARCHAR2(255), -"DEV_CONTACT" VARCHAR2(255), -"GROUP_NAME" VARCHAR2(255), -"JOB_DATA" CLOB, -"NOTIFICATION_MSG" CLOB, -"PARENT_CLIENT_ID" VARCHAR2(255), -"PARENT_SLA_ID" VARCHAR2(255), -"QA_CONTACT" VARCHAR2(255), -"SE_CONTACT" VARCHAR2(255), -"SLA_ID" VARCHAR2(255), -"UPSTREAM_APPS" CLOB, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"APP_TYPE" VARCHAR2(255), -"EVENT_TYPE" VARCHAR2(255), -"EXPECTED_END" TIMESTAMP (6), -"EXPECTED_START" TIMESTAMP (6), -"JOB_STATUS" VARCHAR2(255), -"STATUS_TIMESTAMP" TIMESTAMP (6), - PRIMARY KEY ("EVENT_ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("JOB_DATA") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("NOTIFICATION_MSG") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("UPSTREAM_APPS") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."WF_ACTIONS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"CONF" CLOB, -"CONSOLE_URL" VARCHAR2(255), -"CRED" VARCHAR2(255), -"DATA" CLOB, -"ERROR_CODE" VARCHAR2(255), -"ERROR_MESSAGE" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"EXTERNAL_STATUS" VARCHAR2(255), -"NAME" VARCHAR2(255), -"RETRIES" NUMBER, -"TRACKER_URI" VARCHAR2(255), -"TRANSITION" VARCHAR2(255), -"TYPE" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"END_TIME" TIMESTAMP (6), -"EXECUTION_PATH" VARCHAR2(255), -"LAST_CHECK_TIME" TIMESTAMP (6), -"LOG_TOKEN" VARCHAR2(255), -"PENDING" NUMBER, -"PENDING_AGE" TIMESTAMP (6), -"SIGNAL_VALUE" VARCHAR2(255), -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"WF_ID" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("DATA") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ERROR_MESSAGE") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."WF_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"CONF" CLOB, -"GROUP_NAME" VARCHAR2(255), -"PARENTID" VARCHAR2(255), -"RUN" NUMBER, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"EXTERNAL_ID" VARCHAR2(255), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"LOG_TOKEN" VARCHAR2(255), -"PROTO_ACTION_CONF" CLOB, -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"WF_INSTANCE" BLOB, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("WF_INSTANCE") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE" - ("ID" NUMBER NOT NULL ENABLE, -"SEQUENCE_VALUE" NUMBER, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED -PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING -TABLESPACE "OOZIEDB"; - http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.0.0.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/dbscripts-3.0.0.sql b/utils/dbutils/updatescripts/dbscripts-3.0.0.sql deleted file mode 100644 index c7e03fd..0000000 --- a/utils/dbutils/updatescripts/dbscripts-3.0.0.sql +++ /dev/null @@ -1,409 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -# please replace "OOZIEDB" to your schema name - -CREATE TABLE "OOZIEDB"."VALIDATE_CONN" - ("ID" NUMBER NOT NULL ENABLE, -"DUMMY" NUMBER, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED -PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING -TABLESPACE "OOZIEDB"; - -CREATE TABLE "OOZIEDB"."COORD_ACTIONS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"ACTION_NUMBER" NUMBER, -"ACTION_XML" CLOB, -"CONSOLE_URL" VARCHAR2(255), -"CREATED_CONF" CLOB, -"ERROR_CODE" VARCHAR2(255), -"ERROR_MESSAGE" VARCHAR2(255), -"EXTERNAL_STATUS" VARCHAR2(255), -"MISSING_DEPENDENCIES" CLOB, -"RUN_CONF" CLOB, -"TIME_OUT" NUMBER, -"TRACKER_URI" VARCHAR2(255), -"JOB_TYPE" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"CREATED_TIME" TIMESTAMP (6), -"EXTERNAL_ID" VARCHAR2(255), -"JOB_ID" VARCHAR2(255), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"NOMINAL_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"RERUN_TIME" TIMESTAMP (6), -"SLA_XML" CLOB, -"STATUS" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("ACTION_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("CREATED_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("RUN_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."COORD_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"BUNDLE_ID" VARCHAR2(255), -"CONCURRENCY" NUMBER, -"CONF" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"FREQUENCY" NUMBER, -"GROUP_NAME" VARCHAR2(255), -"LAST_ACTION_NUMBER" NUMBER, -"TIME_OUT" NUMBER, -"TIME_ZONE" VARCHAR2(255), -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"EXECUTION" VARCHAR2(255), -"JOB_XML" CLOB, -"LAST_ACTION" TIMESTAMP (6), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"NEXT_MATD_TIME" TIMESTAMP (6), -"ORIG_JOB_XML" CLOB, -"PAUSE_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"SUSPENDED_TIME" TIMESTAMP (6), -"TIME_UNIT" VARCHAR2(255), -"MAT_THROTTLING" NUMBER, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."SLA_EVENTS" - ("EVENT_ID" NUMBER NOT NULL ENABLE, -"ALERT_CONTACT" VARCHAR2(255), -"ALERT_FREQUENCY" VARCHAR2(255), -"ALERT_PERCENTAGE" VARCHAR2(255), -"APP_NAME" VARCHAR2(255), -"DEV_CONTACT" VARCHAR2(255), -"GROUP_NAME" VARCHAR2(255), -"JOB_DATA" CLOB, -"NOTIFICATION_MSG" CLOB, -"PARENT_CLIENT_ID" VARCHAR2(255), -"PARENT_SLA_ID" VARCHAR2(255), -"QA_CONTACT" VARCHAR2(255), -"SE_CONTACT" VARCHAR2(255), -"SLA_ID" VARCHAR2(255), -"UPSTREAM_APPS" CLOB, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"APP_TYPE" VARCHAR2(255), -"EVENT_TYPE" VARCHAR2(255), -"EXPECTED_END" TIMESTAMP (6), -"EXPECTED_START" TIMESTAMP (6), -"JOB_STATUS" VARCHAR2(255), -"STATUS_TIMESTAMP" TIMESTAMP (6), - PRIMARY KEY ("EVENT_ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("JOB_DATA") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("NOTIFICATION_MSG") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("UPSTREAM_APPS") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."WF_ACTIONS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"CONF" CLOB, -"CONSOLE_URL" VARCHAR2(255), -"CRED" VARCHAR2(255), -"DATA" CLOB, -"ERROR_CODE" VARCHAR2(255), -"ERROR_MESSAGE" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"EXTERNAL_STATUS" VARCHAR2(255), -"NAME" VARCHAR2(255), -"RETRIES" NUMBER, -"TRACKER_URI" VARCHAR2(255), -"TRANSITION" VARCHAR2(255), -"TYPE" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"END_TIME" TIMESTAMP (6), -"EXECUTION_PATH" VARCHAR2(255), -"LAST_CHECK_TIME" TIMESTAMP (6), -"LOG_TOKEN" VARCHAR2(255), -"PENDING" NUMBER, -"PENDING_AGE" TIMESTAMP (6), -"SIGNAL_VALUE" VARCHAR2(255), -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"WF_ID" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("DATA") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ERROR_MESSAGE") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."WF_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"CONF" CLOB, -"GROUP_NAME" VARCHAR2(255), -"PARENTID" VARCHAR2(255), -"RUN" NUMBER, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"EXTERNAL_ID" VARCHAR2(255), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"LOG_TOKEN" VARCHAR2(255), -"PROTO_ACTION_CONF" CLOB, -"SLA_XML" CLOB, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"WF_INSTANCE" BLOB, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("WF_INSTANCE") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - -CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE" - ("ID" NUMBER NOT NULL ENABLE, -"SEQUENCE_VALUE" NUMBER, - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED -PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING -TABLESPACE "OOZIEDB"; - -CREATE TABLE "OOZIEDB"."BUNDLE_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"CONF" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"GROUP_NAME" VARCHAR2(255), -"TIME_OUT" NUMBER, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"JOB_XML" CLOB, -"KICKOFF_TIME" TIMESTAMP (6), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"ORIG_JOB_XML" CLOB, -"PAUSE_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"SUSPENDED_TIME" TIMESTAMP (6), -"TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - - -CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS" - ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE, -"BUNDLE_ID" VARCHAR2(255), -"COORD_ID" VARCHAR2(255), -"COORD_NAME" VARCHAR2(255), -"CRITICAL" NUMBER, -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"STATUS" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), - PRIMARY KEY ("BUNDLE_ACTION_ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB"; - http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.0.1.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/dbscripts-3.0.1.sql b/utils/dbutils/updatescripts/dbscripts-3.0.1.sql deleted file mode 100644 index e0d84b5..0000000 --- a/utils/dbutils/updatescripts/dbscripts-3.0.1.sql +++ /dev/null @@ -1,414 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -# please replace "OOZIEDB" to your schema name - - CREATE TABLE "OOZIEDB"."COORD_ACTIONS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "ACTION_NUMBER" NUMBER, - "ACTION_XML" CLOB, - "CONSOLE_URL" VARCHAR2(255), - "CREATED_CONF" CLOB, - "ERROR_CODE" VARCHAR2(255), - "ERROR_MESSAGE" VARCHAR2(255), - "EXTERNAL_STATUS" VARCHAR2(255), - "MISSING_DEPENDENCIES" CLOB, - "RUN_CONF" CLOB, - "TIME_OUT" NUMBER, - "TRACKER_URI" VARCHAR2(255), - "JOB_TYPE" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "CREATED_TIME" TIMESTAMP (6), - "EXTERNAL_ID" VARCHAR2(255), - "JOB_ID" VARCHAR2(255), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "NOMINAL_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "RERUN_TIME" TIMESTAMP (6), - "SLA_XML" CLOB, - "STATUS" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("ACTION_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("CREATED_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("RUN_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."COORD_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "BUNDLE_ID" VARCHAR2(255), - "CONCURRENCY" NUMBER, - "CONF" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "FREQUENCY" NUMBER, - "GROUP_NAME" VARCHAR2(255), - "LAST_ACTION_NUMBER" NUMBER, - "TIME_OUT" NUMBER, - "TIME_ZONE" VARCHAR2(255), - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "EXECUTION" VARCHAR2(255), - "JOB_XML" CLOB, - "LAST_ACTION" TIMESTAMP (6), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "NEXT_MATD_TIME" TIMESTAMP (6), - "ORIG_JOB_XML" CLOB, - "PAUSE_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "SUSPENDED_TIME" TIMESTAMP (6), - "TIME_UNIT" VARCHAR2(255), - "MAT_THROTTLING" NUMBER, - "DONE_MATERIALIZATION" NUMBER, - "APP_NAMESPACE" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."SLA_EVENTS" - ( "EVENT_ID" NUMBER NOT NULL ENABLE, - "ALERT_CONTACT" VARCHAR2(255), - "ALERT_FREQUENCY" VARCHAR2(255), - "ALERT_PERCENTAGE" VARCHAR2(255), - "APP_NAME" VARCHAR2(255), - "DEV_CONTACT" VARCHAR2(255), - "GROUP_NAME" VARCHAR2(255), - "JOB_DATA" CLOB, - "NOTIFICATION_MSG" CLOB, - "PARENT_CLIENT_ID" VARCHAR2(255), - "PARENT_SLA_ID" VARCHAR2(255), - "QA_CONTACT" VARCHAR2(255), - "SE_CONTACT" VARCHAR2(255), - "SLA_ID" VARCHAR2(255), - "UPSTREAM_APPS" CLOB, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "APP_TYPE" VARCHAR2(255), - "EVENT_TYPE" VARCHAR2(255), - "EXPECTED_END" TIMESTAMP (6), - "EXPECTED_START" TIMESTAMP (6), - "JOB_STATUS" VARCHAR2(255), - "STATUS_TIMESTAMP" TIMESTAMP (6), - PRIMARY KEY ("EVENT_ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("JOB_DATA") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("NOTIFICATION_MSG") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("UPSTREAM_APPS") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."WF_ACTIONS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "CONF" CLOB, - "CONSOLE_URL" VARCHAR2(255), - "CRED" VARCHAR2(255), - "DATA" CLOB, - "ERROR_CODE" VARCHAR2(255), - "ERROR_MESSAGE" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "EXTERNAL_STATUS" VARCHAR2(255), - "NAME" VARCHAR2(255), - "RETRIES" NUMBER, - "TRACKER_URI" VARCHAR2(255), - "TRANSITION" VARCHAR2(255), - "TYPE" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "END_TIME" TIMESTAMP (6), - "EXECUTION_PATH" VARCHAR2(255), - "LAST_CHECK_TIME" TIMESTAMP (6), - "LOG_TOKEN" VARCHAR2(255), - "PENDING" NUMBER, - "PENDING_AGE" TIMESTAMP (6), - "SIGNAL_VALUE" VARCHAR2(255), - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "WF_ID" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("DATA") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ERROR_MESSAGE") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."WF_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "CONF" CLOB, - "GROUP_NAME" VARCHAR2(255), - "PARENTID" VARCHAR2(255), - "RUN" NUMBER, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "EXTERNAL_ID" VARCHAR2(255), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "LOG_TOKEN" VARCHAR2(255), - "PROTO_ACTION_CONF" CLOB, - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "WF_INSTANCE" BLOB, - "PARENT_ID" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("WF_INSTANCE") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."BUNDLE_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "CONF" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "GROUP_NAME" VARCHAR2(255), - "TIME_OUT" NUMBER, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "JOB_XML" CLOB, - "KICKOFF_TIME" TIMESTAMP (6), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "ORIG_JOB_XML" CLOB, - "PAUSE_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "SUSPENDED_TIME" TIMESTAMP (6), - "TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS" - ( "BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE, - "BUNDLE_ID" VARCHAR2(255), - "COORD_ID" VARCHAR2(255), - "COORD_NAME" VARCHAR2(255), - "CRITICAL" NUMBER, - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "STATUS" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - PRIMARY KEY ("BUNDLE_ACTION_ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" ; - - CREATE TABLE "OOZIEDB"."VALIDATE_CONN" - ( "ID" NUMBER NOT NULL ENABLE, - "DUMMY" NUMBER, - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED - PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING - TABLESPACE "OOZIEDB" ; - - CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE" - ( "ID" NUMBER NOT NULL ENABLE, - "SEQUENCE_VALUE" NUMBER, - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED - PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING - TABLESPACE "OOZIEDB"; - - CREATE SEQUENCE "OOZIEDB"."EVENT_SEQ" - MINVALUE 1 MAXVALUE 9999999999999999999999999999 - INCREMENT BY 1 START WITH 351 CACHE 50 NOORDER NOCYCLE; http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.1.0.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/dbscripts-3.1.0.sql b/utils/dbutils/updatescripts/dbscripts-3.1.0.sql deleted file mode 100644 index 5162a8c..0000000 --- a/utils/dbutils/updatescripts/dbscripts-3.1.0.sql +++ /dev/null @@ -1,417 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -# please replace "OOZIEDB" to your schema name - - CREATE TABLE "OOZIEDB"."COORD_ACTIONS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "ACTION_NUMBER" NUMBER, - "ACTION_XML" CLOB, - "CONSOLE_URL" VARCHAR2(255), - "CREATED_CONF" CLOB, - "ERROR_CODE" VARCHAR2(255), - "ERROR_MESSAGE" VARCHAR2(255), - "EXTERNAL_STATUS" VARCHAR2(255), - "MISSING_DEPENDENCIES" CLOB, - "RUN_CONF" CLOB, - "TIME_OUT" NUMBER, - "TRACKER_URI" VARCHAR2(255), - "JOB_TYPE" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "CREATED_TIME" TIMESTAMP (6), - "EXTERNAL_ID" VARCHAR2(255), - "JOB_ID" VARCHAR2(255), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "NOMINAL_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "RERUN_TIME" TIMESTAMP (6), - "SLA_XML" CLOB, - "STATUS" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("ACTION_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("CREATED_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("RUN_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."COORD_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "BUNDLE_ID" VARCHAR2(255), - "CONCURRENCY" NUMBER, - "CONF" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "FREQUENCY" NUMBER, - "GROUP_NAME" VARCHAR2(255), - "LAST_ACTION_NUMBER" NUMBER, - "TIME_OUT" NUMBER, - "TIME_ZONE" VARCHAR2(255), - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "EXECUTION" VARCHAR2(255), - "JOB_XML" CLOB, - "LAST_ACTION" TIMESTAMP (6), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "NEXT_MATD_TIME" TIMESTAMP (6), - "ORIG_JOB_XML" CLOB, - "PAUSE_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "SUSPENDED_TIME" TIMESTAMP (6), - "TIME_UNIT" VARCHAR2(255), - "MAT_THROTTLING" NUMBER, - "DONE_MATERIALIZATION" NUMBER, - "APP_NAMESPACE" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."SLA_EVENTS" - ( "EVENT_ID" NUMBER NOT NULL ENABLE, - "ALERT_CONTACT" VARCHAR2(255), - "ALERT_FREQUENCY" VARCHAR2(255), - "ALERT_PERCENTAGE" VARCHAR2(255), - "APP_NAME" VARCHAR2(255), - "DEV_CONTACT" VARCHAR2(255), - "GROUP_NAME" VARCHAR2(255), - "JOB_DATA" CLOB, - "NOTIFICATION_MSG" CLOB, - "PARENT_CLIENT_ID" VARCHAR2(255), - "PARENT_SLA_ID" VARCHAR2(255), - "QA_CONTACT" VARCHAR2(255), - "SE_CONTACT" VARCHAR2(255), - "SLA_ID" VARCHAR2(255), - "UPSTREAM_APPS" CLOB, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "APP_TYPE" VARCHAR2(255), - "EVENT_TYPE" VARCHAR2(255), - "EXPECTED_END" TIMESTAMP (6), - "EXPECTED_START" TIMESTAMP (6), - "JOB_STATUS" VARCHAR2(255), - "STATUS_TIMESTAMP" TIMESTAMP (6), - PRIMARY KEY ("EVENT_ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("JOB_DATA") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("NOTIFICATION_MSG") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("UPSTREAM_APPS") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."WF_ACTIONS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "CONF" CLOB, - "CONSOLE_URL" VARCHAR2(255), - "CRED" VARCHAR2(255), - "DATA" CLOB, - "ERROR_CODE" VARCHAR2(255), - "ERROR_MESSAGE" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "EXTERNAL_STATUS" VARCHAR2(255), - "NAME" VARCHAR2(255), - "RETRIES" NUMBER, - "TRACKER_URI" VARCHAR2(255), - "TRANSITION" VARCHAR2(255), - "TYPE" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "END_TIME" TIMESTAMP (6), - "EXECUTION_PATH" VARCHAR2(255), - "LAST_CHECK_TIME" TIMESTAMP (6), - "LOG_TOKEN" VARCHAR2(255), - "PENDING" NUMBER, - "PENDING_AGE" TIMESTAMP (6), - "SIGNAL_VALUE" VARCHAR2(255), - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "WF_ID" VARCHAR2(255), - "USER_RETRY_COUNT" NUMBER, - "USER_RETRY_MAX" NUMBER, - "USER_RETRY_INTERVAL" NUMBER, - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("DATA") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ERROR_MESSAGE") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."WF_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "CONF" CLOB, - "GROUP_NAME" VARCHAR2(255), - "PARENTID" VARCHAR2(255), - "RUN" NUMBER, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "EXTERNAL_ID" VARCHAR2(255), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "LOG_TOKEN" VARCHAR2(255), - "PROTO_ACTION_CONF" CLOB, - "SLA_XML" CLOB, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "WF_INSTANCE" BLOB, - "PARENT_ID" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("SLA_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("WF_INSTANCE") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."BUNDLE_JOBS" - ( "ID" VARCHAR2(255) NOT NULL ENABLE, - "APP_NAME" VARCHAR2(255), - "APP_PATH" VARCHAR2(255), - "CONF" CLOB, - "EXTERNAL_ID" VARCHAR2(255), - "GROUP_NAME" VARCHAR2(255), - "TIME_OUT" NUMBER, - "USER_NAME" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - "AUTH_TOKEN" CLOB, - "CREATED_TIME" TIMESTAMP (6), - "END_TIME" TIMESTAMP (6), - "JOB_XML" CLOB, - "KICKOFF_TIME" TIMESTAMP (6), - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "ORIG_JOB_XML" CLOB, - "PAUSE_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "START_TIME" TIMESTAMP (6), - "STATUS" VARCHAR2(255), - "SUSPENDED_TIME" TIMESTAMP (6), - "TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( - TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION - NOCACHE 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)) ; - - CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS" - ( "BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE, - "BUNDLE_ID" VARCHAR2(255), - "COORD_ID" VARCHAR2(255), - "COORD_NAME" VARCHAR2(255), - "CRITICAL" NUMBER, - "LAST_MODIFIED_TIME" TIMESTAMP (6), - "PENDING" NUMBER, - "STATUS" VARCHAR2(255), - "BEAN_TYPE" VARCHAR2(31), - PRIMARY KEY ("BUNDLE_ACTION_ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - 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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" ; - - CREATE TABLE "OOZIEDB"."VALIDATE_CONN" - ( "ID" NUMBER NOT NULL ENABLE, - "DUMMY" NUMBER, - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED - PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING - TABLESPACE "OOZIEDB" ; - - CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE" - ( "ID" NUMBER NOT NULL ENABLE, - "SEQUENCE_VALUE" NUMBER, - PRIMARY KEY ("ID") - USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS - TABLESPACE "OOZIEDB" ENABLE - ) SEGMENT CREATION DEFERRED - PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING - TABLESPACE "OOZIEDB"; - - CREATE SEQUENCE "OOZIEDB"."EVENT_SEQ" - MINVALUE 1 MAXVALUE 9999999999999999999999999999 - INCREMENT BY 1 START WITH 351 CACHE 50 NOORDER NOCYCLE; http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/readme.txt ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/readme.txt b/utils/dbutils/updatescripts/readme.txt deleted file mode 100644 index 44840d2..0000000 --- a/utils/dbutils/updatescripts/readme.txt +++ /dev/null @@ -1,7 +0,0 @@ -dbscripts-3.0.0.sql will be used to create all the tables if we have new schema. - -updatescripts-2.x-to-3.0.0.sql will be used to update the tables from 2.x to 3.0.0. - -upgradescript-2.x-to-3.0.0.sql will be used to change the previous statuses to new statuses when we will update the current running system of 2.x to 3.0.0 - -For all the scripts please change the db name and run the script. http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql b/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql deleted file mode 100644 index 9c8a06c..0000000 --- a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql +++ /dev/null @@ -1,101 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -ALTER TABLE COORD_ACTIONS ADD PENDING NUMBER DEFAULT 0; -ALTER TABLE COORD_JOBS ADD PENDING NUMBER DEFAULT 0; -ALTER TABLE COORD_JOBS ADD MAT_THROTTLING NUMBER DEFAULT 12; -ALTER TABLE WF_JOBS ADD PARENTID VARCHAR2(255); - -# please replace "OOZIEDB" to your schema name - -CREATE TABLE "OOZIEDB"."BUNDLE_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"CONF" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"GROUP_NAME" VARCHAR2(255), -"TIME_OUT" NUMBER, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"JOB_XML" CLOB, -"KICKOFF_TIME" TIMESTAMP (6), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"ORIG_JOB_XML" CLOB, -"PAUSE_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"SUSPENDED_TIME" TIMESTAMP (6), -"TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - - -CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS" - ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE, -"BUNDLE_ID" VARCHAR2(255), -"COORD_ID" VARCHAR2(255), -"COORD_NAME" VARCHAR2(255), -"CRITICAL" NUMBER, -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"STATUS" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), - PRIMARY KEY ("BUNDLE_ACTION_ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB"; - http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql b/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql deleted file mode 100644 index 3620e07..0000000 --- a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql +++ /dev/null @@ -1,104 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -ALTER TABLE WF_JOBS ADD PARENT_ID VARCHAR2(255); -ALTER TABLE WF_ACTIONS MODIFY EXECUTION_PATH VARCHAR2(1024); -ALTER TABLE COORD_JOBS ADD PENDING NUMBER DEFAULT 0; -ALTER TABLE COORD_JOBS ADD MAT_THROTTLING NUMBER DEFAULT 12; -ALTER TABLE COORD_JOBS ADD DONE_MATERIALIZATION NUMBER DEFAULT 0; -ALTER TABLE COORD_JOBS ADD APP_NAMESPACE VARCHAR2(255) DEFAULT 'uri:oozie:coordinator:0.1'; -ALTER TABLE COORD_ACTIONS ADD PENDING NUMBER DEFAULT 0; - -# please replace "OOZIEDB" to your schema name - -CREATE TABLE "OOZIEDB"."BUNDLE_JOBS" - ("ID" VARCHAR2(255) NOT NULL ENABLE, -"APP_NAME" VARCHAR2(255), -"APP_PATH" VARCHAR2(255), -"CONF" CLOB, -"EXTERNAL_ID" VARCHAR2(255), -"GROUP_NAME" VARCHAR2(255), -"TIME_OUT" NUMBER, -"USER_NAME" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), -"AUTH_TOKEN" CLOB, -"CREATED_TIME" TIMESTAMP (6), -"END_TIME" TIMESTAMP (6), -"JOB_XML" CLOB, -"KICKOFF_TIME" TIMESTAMP (6), -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"ORIG_JOB_XML" CLOB, -"PAUSE_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"START_TIME" TIMESTAMP (6), -"STATUS" VARCHAR2(255), -"SUSPENDED_TIME" TIMESTAMP (6), -"TIME_UNIT" VARCHAR2(255), - PRIMARY KEY ("ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB" - LOB ("CONF") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("AUTH_TOKEN") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)) - LOB ("ORIG_JOB_XML") STORE AS BASICFILE ( -TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION -NOCACHE 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)); - - -CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS" - ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE, -"BUNDLE_ID" VARCHAR2(255), -"COORD_ID" VARCHAR2(255), -"COORD_NAME" VARCHAR2(255), -"CRITICAL" NUMBER, -"LAST_MODIFIED_TIME" TIMESTAMP (6), -"PENDING" NUMBER, -"STATUS" VARCHAR2(255), -"BEAN_TYPE" VARCHAR2(31), - PRIMARY KEY ("BUNDLE_ACTION_ID") -USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS -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 "OOZIEDB" ENABLE - ) 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 "OOZIEDB"; - http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql b/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql deleted file mode 100644 index 6a6a4fc..0000000 --- a/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql +++ /dev/null @@ -1,23 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -ALTER TABLE WF_JOBS DROP PARENTID; -ALTER TABLE WF_JOBS ADD PARENT_ID VARCHAR2(255); -ALTER TABLE WF_ACTIONS MODIFY EXECUTION_PATH VARCHAR2(1024); -ALTER TABLE COORD_JOBS ADD DONE_MATERIALIZATION NUMBER DEFAULT 0; -ALTER TABLE COORD_JOBS ADD APP_NAMESPACE VARCHAR2(255); \ No newline at end of file
