WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql

 --------------------------------------------------------
---  File created - Wednesday-May-08-2019
+--  File created - Thursday-September-12-2019
 --------------------------------------------------------
+DROP TYPE "RELEASE_MANAGER"."RELMGR_NUMBER_TAB_T";
+DROP TYPE "RELEASE_MANAGER"."RELMGR_PKG_DESTROY_ERR_T";
+DROP TYPE "RELEASE_MANAGER"."RELMGR_PKG_DESTROY_ERR_TAB_T";
+DROP TYPE "RELEASE_MANAGER"."RELMGR_VARCHAR2_TAB_T";
+DROP TYPE "RELEASE_MANAGER"."TDICTIONARY";
+DROP SEQUENCE "RELEASE_MANAGER"."MICROSOFTSEQDTPROPERTIES";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BLAT_MOD";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BLAT_SERVER_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BMCON_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BM_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BSA_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_BUILD_PLATFORMS";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_CR_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_GBE_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_GROUP_EMAIL_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_MSG_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_PKG_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_PROJ_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_PV_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_RCON_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_RELEASE_MOD";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_RTAG_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_SCHEDULED_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_SDKTAG_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_SDK_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_SESSION_NUM";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_TESTRUN_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_UNIT_TESTS";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_USER_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_VCS_TYPE";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_VIEW_ID";
+DROP SEQUENCE "RELEASE_MANAGER"."SEQ_VTREE_ID";
+DROP TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG";
+DROP TABLE "RELEASE_MANAGER"."ACTION_LOG";
+DROP TABLE "RELEASE_MANAGER"."ACTION_TYPE";
+DROP TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES";
+DROP TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE";
+DROP TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG";
+DROP TABLE "RELEASE_MANAGER"."ARCHIVE_DATA";
+DROP TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE";
+DROP TABLE "RELEASE_MANAGER"."BLAT_PROJECTS";
+DROP TABLE "RELEASE_MANAGER"."BLAT_RELEASES";
+DROP TABLE "RELEASE_MANAGER"."BLAT_SERVERS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_INSTANCES";
+DROP TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_MACHINES";
+DROP TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG";
+DROP TABLE "RELEASE_MANAGER"."BUILD_ORDER";
+DROP TABLE "RELEASE_MANAGER"."BUILD_PLAN";
+DROP TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG";
+DROP TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2";
+DROP TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG";
+DROP TABLE "RELEASE_MANAGER"."BUILD_STANDARDS";
+DROP TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM";
+DROP TABLE "RELEASE_MANAGER"."CODE_REVIEWS";
+DROP TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL";
+DROP TABLE "RELEASE_MANAGER"."CQ_HISTORY";
+DROP TABLE "RELEASE_MANAGER"."CQ_ISSUES";
+DROP TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE";
+DROP TABLE "RELEASE_MANAGER"."CQ_STATEDEF";
+DROP TABLE "RELEASE_MANAGER"."CQ_USERS";
+DROP TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG";
+DROP TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS";
+DROP TABLE "RELEASE_MANAGER"."DASH_BOARD";
+DROP TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES";
+DROP TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE";
+DROP TABLE "RELEASE_MANAGER"."GBE_MACHTYPE";
+DROP TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS";
+DROP TABLE "RELEASE_MANAGER"."JIRA_ISSUES";
+DROP TABLE "RELEASE_MANAGER"."LICENCES";
+DROP TABLE "RELEASE_MANAGER"."LICENCING";
+DROP TABLE "RELEASE_MANAGER"."LXR_STATE";
+DROP TABLE "RELEASE_MANAGER"."MEMBERS_GROUP";
+DROP TABLE "RELEASE_MANAGER"."MESSAGE_BOARD";
+DROP TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES";
+DROP TABLE "RELEASE_MANAGER"."NOTE_MANAGER";
+DROP TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY";
+DROP TABLE "RELEASE_MANAGER"."PACKAGES";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_METRICS";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS";
+DROP TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS";
+DROP TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS";
+DROP TABLE "RELEASE_MANAGER"."PLANNED";
+DROP TABLE "RELEASE_MANAGER"."PLANNED_VERSIONS";
+DROP TABLE "RELEASE_MANAGER"."PLATFORMS";
+DROP TABLE "RELEASE_MANAGER"."PROCESSES";
+DROP TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS";
+DROP TABLE "RELEASE_MANAGER"."PRODUCT_STATES";
+DROP TABLE "RELEASE_MANAGER"."PROJECTS";
+DROP TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG";
+DROP TABLE "RELEASE_MANAGER"."PROJECT_EXTENTIONS";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_CONFIG";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_CONTENT";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_LINKS";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_METRICS";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED";
+DROP TABLE "RELEASE_MANAGER"."RELEASE_TAGS";
+DROP TABLE "RELEASE_MANAGER"."RM_PACKAGE_ISSUES_DELETE_ME";
+DROP TABLE "RELEASE_MANAGER"."RM_PKG_ISSUES";
+DROP TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES";
+DROP TABLE "RELEASE_MANAGER"."RUN_LEVEL";
+DROP TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE";
+DROP TABLE "RELEASE_MANAGER"."SDK_CONTENT";
+DROP TABLE "RELEASE_MANAGER"."SDK_NAMES";
+DROP TABLE "RELEASE_MANAGER"."SDK_TAGS";
+DROP TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS";
+DROP TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES";
+DROP TABLE "RELEASE_MANAGER"."TEMP_SASH";
+DROP TABLE "RELEASE_MANAGER"."TEMP_TREE_BROWSE";
+DROP TABLE "RELEASE_MANAGER"."TEST_RUN";
+DROP TABLE "RELEASE_MANAGER"."TEST_TYPES";
+DROP TABLE "RELEASE_MANAGER"."UNIT_TESTS";
+DROP TABLE "RELEASE_MANAGER"."VALIDATION_RULES_DELETE_ME";
+DROP TABLE "RELEASE_MANAGER"."VCS_TYPE";
+DROP TABLE "RELEASE_MANAGER"."VIEWS";
+DROP TABLE "RELEASE_MANAGER"."VIEW_DEF";
+DROP TABLE "RELEASE_MANAGER"."VIEW_SETTINGS";
+DROP TABLE "RELEASE_MANAGER"."VTREES";
+DROP TABLE "RELEASE_MANAGER"."VTREES_WORLD";
+DROP TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS";
+DROP TABLE "RELEASE_MANAGER"."WORLDS";
+DROP VIEW "RELEASE_MANAGER"."ENVIRONMENT_VIEW";
+DROP PROCEDURE "RELEASE_MANAGER"."ADD_AUTOBUILD_FAILURE_INFO";
+DROP PROCEDURE "RELEASE_MANAGER"."ADD_COMPONENT";
+DROP PROCEDURE "RELEASE_MANAGER"."ADD_PACKAGE_INTEREST";
+DROP PROCEDURE "RELEASE_MANAGER"."ADD_RUNTIME_DEPENDENCY";
+DROP PROCEDURE "RELEASE_MANAGER"."ADD_VIEW_MEMBERS";
+DROP PROCEDURE "RELEASE_MANAGER"."BASIC_CLONE";
+DROP PROCEDURE "RELEASE_MANAGER"."BUILD_TREE";
+DROP PROCEDURE "RELEASE_MANAGER"."CHANGE_PACKAGE_STATE";
+DROP PROCEDURE "RELEASE_MANAGER"."CHANGE_RELEASE_MODE";
+DROP PROCEDURE "RELEASE_MANAGER"."CHECK_NEW_PATCHES";
+DROP PROCEDURE "RELEASE_MANAGER"."CLEAN_ADVISORY_RIPPLE";
+DROP PROCEDURE "RELEASE_MANAGER"."CLEAN_DO_NOT_RIPPLE";
+DROP PROCEDURE "RELEASE_MANAGER"."CLEAR_ADVISORY_RIPPLE";
+DROP PROCEDURE "RELEASE_MANAGER"."CLONED_PACKAGE_PROCESSES";
+DROP PROCEDURE "RELEASE_MANAGER"."CLONED_PROCESSES";
+DROP PROCEDURE "RELEASE_MANAGER"."DELETE_AUTOBUILD_FAILURE_INFO";
+DROP PROCEDURE "RELEASE_MANAGER"."DEPRECATE_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."DT_DROPUSEROBJECTBYID";
+DROP PROCEDURE "RELEASE_MANAGER"."DT_SETPROPERTYBYID";
+DROP PROCEDURE "RELEASE_MANAGER"."IGNORE_DEPENDENCY_WARNINGS";
+DROP PROCEDURE "RELEASE_MANAGER"."INSERT_INTO_PACKAGE_BUILD_INFO";
+DROP PROCEDURE "RELEASE_MANAGER"."INSERT_MULTIPLE_STICKY_NOTES";
+DROP PROCEDURE "RELEASE_MANAGER"."LEVEL_N_CONFLICTS";
+DROP PROCEDURE "RELEASE_MANAGER"."LEVEL_ONE_CONFLICTS";
+DROP PROCEDURE "RELEASE_MANAGER"."LOCK_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."LOG_ACTION";
+DROP PROCEDURE "RELEASE_MANAGER"."LOG_ACTION_BULK";
+DROP PROCEDURE "RELEASE_MANAGER"."LOG_DAEMON_ACTION";
+DROP PROCEDURE "RELEASE_MANAGER"."LOG_PROJECT_ACTION";
+DROP PROCEDURE "RELEASE_MANAGER"."NEW_ADDITIONAL_NOTE";
+DROP PROCEDURE "RELEASE_MANAGER"."NEW_PACKAGE_NAME";
+DROP PROCEDURE "RELEASE_MANAGER"."NEW_PATCH";
+DROP PROCEDURE "RELEASE_MANAGER"."NEW_UNIT_TEST";
+DROP PROCEDURE "RELEASE_MANAGER"."PAOLO_BUILD_TREE";
+DROP PROCEDURE "RELEASE_MANAGER"."REBUILD_DEPRECATE_STATE";
+DROP PROCEDURE "RELEASE_MANAGER"."REBUILD_ENVIRONMENT";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_COMPONENTS";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_DOCUMENT";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_PACKAGE_INTEREST";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_PATCH";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_PROJECT_VIEW_OWNER";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_RELEASE_CONTENT";
+DROP PROCEDURE "RELEASE_MANAGER"."REMOVE_RUNTIME";
+DROP PROCEDURE "RELEASE_MANAGER"."RENAME_PACKAGE_VERSION";
+DROP PROCEDURE "RELEASE_MANAGER"."RESET_IGNORE_WARNINGS";
+DROP PROCEDURE "RELEASE_MANAGER"."RIPPLE_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."SEED_PACKAGE_NAMES_VERSIONS";
+DROP PROCEDURE "RELEASE_MANAGER"."SET_ADVISORY_RIPPLE";
+DROP PROCEDURE "RELEASE_MANAGER"."SET_PACKAGE_BUILD_ENV";
+DROP PROCEDURE "RELEASE_MANAGER"."SET_PACKAGE_BUILD_ENV_TEMP";
+DROP PROCEDURE "RELEASE_MANAGER"."SET_TO_AUTOBUILDABLE";
+DROP PROCEDURE "RELEASE_MANAGER"."SHIFT_INSTALL_ORDER";
+DROP PROCEDURE "RELEASE_MANAGER"."SPLIT_VERSION";
+DROP PROCEDURE "RELEASE_MANAGER"."SWITCH_REPRODUCIBLE_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."SYNC_PROJECTS_NEW_VERSION";
+DROP PROCEDURE "RELEASE_MANAGER"."TOUCH_RELEASE";
+DROP PROCEDURE "RELEASE_MANAGER"."TOUCH_RELEASE_BULK";
+DROP PROCEDURE "RELEASE_MANAGER"."TO_INSERT_VTREE_ID";
+DROP PROCEDURE "RELEASE_MANAGER"."UNDEPRECATE_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."UNLOCK_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."UNRIPPLE_PACKAGE";
+DROP PROCEDURE "RELEASE_MANAGER"."UNRIPPLE_PACKAGE_INDIRECT";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_ADDITIONAL_NOTE";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_DEPRECATION_STATE";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_MISC_VIEW";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_PACKAGE_DEPENDENCY";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_PACKAGE_STATES";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_PROCESSES";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_RUNTIME_DEPENDENCY";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_UNIT_TEST";
+DROP PROCEDURE "RELEASE_MANAGER"."UPDATE_UNIT_TEST_ACCEPTANCE";
+DROP PACKAGE "RELEASE_MANAGER"."PK_APP_UTILS";
+DROP PACKAGE "RELEASE_MANAGER"."PK_BLATAPI";
+DROP PACKAGE "RELEASE_MANAGER"."PK_BUILDAPI";
+DROP PACKAGE "RELEASE_MANAGER"."PK_ENVIRONMENT";
+DROP PACKAGE "RELEASE_MANAGER"."PK_LICENCING";
+DROP PACKAGE "RELEASE_MANAGER"."PK_PACKAGE";
+DROP PACKAGE "RELEASE_MANAGER"."PK_PLANNED";
+DROP PACKAGE "RELEASE_MANAGER"."PK_PROJECT";
+DROP PACKAGE "RELEASE_MANAGER"."PK_RELEASE";
+DROP PACKAGE "RELEASE_MANAGER"."PK_RMAPI";
+DROP PACKAGE "RELEASE_MANAGER"."PK_WORK_IN_PROGRESS";
+DROP PACKAGE "RELEASE_MANAGER"."RM_ISSUES";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_APP_UTILS";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_BLATAPI";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_BUILDAPI";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_ENVIRONMENT";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_LICENCING";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_PACKAGE";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_PLANNED";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_PROJECT";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_RELEASE";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_RMAPI";
+DROP PACKAGE BODY "RELEASE_MANAGER"."PK_WORK_IN_PROGRESS";
+DROP PACKAGE BODY "RELEASE_MANAGER"."RM_ISSUES";
+DROP FUNCTION "RELEASE_MANAGER"."CAN_EDIT_PKG_IN_PROJECT";
+DROP FUNCTION "RELEASE_MANAGER"."DT_ADDUSEROBJECT";
+DROP FUNCTION "RELEASE_MANAGER"."GET_AUTOMATED_LABEL";
+DROP FUNCTION "RELEASE_MANAGER"."GET_BUILD_NUMBER";
+DROP FUNCTION "RELEASE_MANAGER"."GET_PATCH_VERSION";
+DROP FUNCTION "RELEASE_MANAGER"."GET_PV_FIRST_MODIFIED";
+DROP FUNCTION "RELEASE_MANAGER"."GET_V_EXT";
+DROP FUNCTION "RELEASE_MANAGER"."IN_LIST_NUMBER";
+DROP FUNCTION "RELEASE_MANAGER"."IN_LIST_NUMBER2";
+DROP FUNCTION "RELEASE_MANAGER"."IN_LIST_VARCHAR2";
+DROP FUNCTION "RELEASE_MANAGER"."IS_NUMBER";
+DROP FUNCTION "RELEASE_MANAGER"."IS_VERSION_EXTENSION";
+DROP FUNCTION "RELEASE_MANAGER"."ORA_SYSDATE";
+DROP FUNCTION "RELEASE_MANAGER"."ORA_SYSDATETIME";
+DROP FUNCTION "RELEASE_MANAGER"."PERL_DBD_TESTFUNC";
+DROP FUNCTION "RELEASE_MANAGER"."RELEASE_MODE";
+DROP SYNONYM "RELEASE_MANAGER"."APPLICATIONS";
+DROP SYNONYM "RELEASE_MANAGER"."APPLICATION_PAGES";
+DROP SYNONYM "RELEASE_MANAGER"."CONTROL_OBJECTS";
+DROP SYNONYM "RELEASE_MANAGER"."DATA_PERMISSIONS";
+DROP SYNONYM "RELEASE_MANAGER"."DATA_TABLES";
+DROP SYNONYM "RELEASE_MANAGER"."PAGE_CONTROL_OBJECTS";
+DROP SYNONYM "RELEASE_MANAGER"."PERMISSION_TYPES";
+DROP SYNONYM "RELEASE_MANAGER"."PK_AMUTILS";
+DROP SYNONYM "RELEASE_MANAGER"."PK_SECURITY";
+DROP SYNONYM "RELEASE_MANAGER"."ROLES";
+DROP SYNONYM "RELEASE_MANAGER"."ROLE_PRIVILEGES";
+DROP SYNONYM "RELEASE_MANAGER"."USERS";
+DROP SYNONYM "RELEASE_MANAGER"."USER_APPLICATIONS";
+DROP SYNONYM "RELEASE_MANAGER"."USER_ROLES";
 --------------------------------------------------------
 --  DDL for Type RELMGR_NUMBER_TAB_T
 --------------------------------------------------------
   CREATE OR REPLACE TYPE "RELEASE_MANAGER"."RELMGR_NUMBER_TAB_T" as TABLE of NUMBER
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 38175 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BLAT_MOD
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BLAT_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 261 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BLAT_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 341 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BLAT_SERVER_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BLAT_SERVER_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BMCON_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BMCON_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 361 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BMCON_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 401 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BM_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BM_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 6 NOCACHE  ORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BSA_ID"  MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 48 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BUILD_INSTANCE
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 252972 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 295286 CACHE 20 ORDER  NOCYCLE ;
+--------------------------------------------------------
+--  DDL for Sequence SEQ_BUILD_PLATFORMS
+--------------------------------------------------------
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_PLATFORMS"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 201 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_CR_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 95472 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 96512 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 180075 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 183365 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_GBE_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1245 NOCACHE  ORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 582 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PKG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68263 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 68965 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PROJ_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1041 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PV_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1244788 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1282857 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RCON_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 37110 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 38663 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RELEASE_MOD
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 309203 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 369379 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 39911 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 41076 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SCHEDULED_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30134 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30374 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDKTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1623 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1963 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDK_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 163 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 183 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SESSION_NUM
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1113544 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1126786 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_TESTRUN_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2577583 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 5016624 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_UNIT_TESTS
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 376316 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 378582 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_USER_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VCS_TYPE"  MINVALUE 1 MAXVALUE 255 INCREMENT BY 1 START WITH 63 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VIEW_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10341 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 10381 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VTREE_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36590 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 37755 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Table ABT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"
    (	"BUILD_ID" NUMBER,
 	"RTAG_ID" NUMBER,
 	"PV_ID" NUMBER,
 	"TIMESTAMP" TIMESTAMP (6) DEFAULT CURRENT_TIMESTAMP,
 	"REASON" CHAR(1 BYTE),
-	"STATE" CHAR(1 BYTE) DEFAULT 'B'
+	"STATE" CHAR(1 BYTE) DEFAULT 'B',
+	"BUILD_REF" VARCHAR2(50 BYTE)
    ) 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
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."BUILD_ID" IS 'Unique. Auto generated when row is created.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."RTAG_ID" IS 'Link the build to a Release';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."PV_ID" IS 'Link the build to a Package';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."TIMESTAMP" IS 'When the instance is created';
-   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."REASON" IS 'Reason for the build. Ripple(''R''), Test(''T''), NewVersion(''N''), Restore(''P'')';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."REASON" IS 'Reason for the build. Ripple(''R''), Test(''T''), NewVersion(''N''), Restore(''P''), ForcedRipple(''F'')';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."STATE" IS 'Result of the build. ''B'', ''Buiding'', ''C'', ''Complete'', ''E'', ''Error'', ''S'', ''SysErr''';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCES"."BUILD_REF" IS 'Used to locate build logs';
+--------------------------------------------------------
+--  DDL for Table BUILD_INSTANCE_PLATFORMS
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS"
+   (	"BUILD_ID" NUMBER,
+	"BP_ID" NUMBER
+   ) 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 "RELEASE_MANAGER_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS"."BUILD_ID" IS 'Associated Build Instance';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS"."BP_ID" IS 'Associated Build Platform';
+   COMMENT ON TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS"  IS 'Platforms that the build instance were built for.This will be a subset of those it can be built for.';
 --------------------------------------------------------
 --  DDL for Table BUILD_MACHINES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_MACHINES"
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."RTAG_ID" IS 'Identify target Release';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."BUILD_ORDER" IS 'Sequence for build';
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."PV_ID" IS 'Package to build';
 --------------------------------------------------------
+--  DDL for Table BUILD_PLATFORMS
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS"
+   (	"BP_ID" NUMBER,
+	"BP_NAME" VARCHAR2(50 BYTE),
+	"BP_ACTIVE" CHAR(1 BYTE) DEFAULT 'Y',
+	"BP_DESCRIPTION" VARCHAR2(1000 BYTE)
+   ) 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 "RELEASE_MANAGER_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS"."BP_ID" IS 'Build Platform Id';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS"."BP_NAME" IS 'Name of the platform';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS"."BP_ACTIVE" IS 'Platform availbale to be configured';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS"."BP_DESCRIPTION" IS 'Description of the platform';
+--------------------------------------------------------
+--  DDL for Table BUILD_PLATFORMS_CONFIG
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG"
+   (	"BP_ID" NUMBER,
+	"GBE_ID" NUMBER
+   ) 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 "RELEASE_MANAGER_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG"."BP_ID" IS 'Link into BUILD_PLATFORMS';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG"."GBE_ID" IS 'Link to GBE_MACHTYPE';
+   COMMENT ON TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG"  IS 'This table controls which BUILD_PLATFORMS can be assigned to a GBE_MACHTYPE';
+--------------------------------------------------------
+--  DDL for Table BUILD_PLATFORMS_CONFIG2
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2"
+   (	"BP_ID" NUMBER,
+	"BMCON_ID" NUMBER
+   ) 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 "RELEASE_MANAGER_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2"."BP_ID" IS 'Link to BUILD_PLATFORMS';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2"."BMCON_ID" IS 'Link to BUILD_MACHINE_CONFIG';
+   COMMENT ON TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2"  IS 'Define the PLATFORMS that are available on a specific BUILD_MACHINE';
+--------------------------------------------------------
 --  DDL for Table BUILD_SERVICE_CONFIG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG"
    (	"SERVICE" VARCHAR2(50 BYTE),
   GRANT UPDATE ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DEPLOYMENT_MANAGER";
   GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DEPLOYMENT_MANAGER";
   GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DEPLOYMENT_MANAGER";
   GRANT DELETE ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DEPLOYMENT_MANAGER";
 --------------------------------------------------------
+--  DDL for Table PACKAGE_VERSION_PLATFORMS
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS"
+   (	"PV_ID" NUMBER,
+	"BP_ID" NUMBER
+   ) 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 "RELEASE_MANAGER_DATA" ;
+   COMMENT ON TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS"  IS 'Platforms that the package version can be built for. A given build instance may not be built for all of these.';
+--------------------------------------------------------
 --  DDL for Table PEGGED_VERSIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS"
    (	"RTAG_ID" NUMBER,
 	"OWNER_PERSONAL_EMAIL" VARCHAR2(1000 BYTE),
 	"CONFIG_SPEC_BRANCH" VARCHAR2(4000 BYTE),
 	"PRODUCT_STATE_USED" CHAR(1 BYTE),
 	"OFFICIAL_ID" NUMBER,
 	"BUILD_AGE" NUMBER DEFAULT 31,
-	"LXR" CHAR(1 BYTE) DEFAULT 'N'
+	"LXR" CHAR(1 BYTE) DEFAULT 'N',
+	"PLAN_THRESHOLD" NUMBER DEFAULT 20,
+	"PLAN_DROP" CHAR(1 BYTE) DEFAULT 'N'
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  NOCOMPRESS LOGGING
   STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_ENV" IS 'Y: Rebuild Package State';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_STAMP" IS 'Not used ?';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."OFFICIAL_ID" IS 'User last changed OFFICIAL state';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."BUILD_AGE" IS 'Days without building before warning is shown';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."LXR" IS 'Y:Enable LXR';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."PLAN_THRESHOLD" IS 'Controls the build plan . Values 0:20:100';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."PLAN_DROP" IS 'Plan Drop request.';
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "RM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "MS_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "DM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "RELEASE_MANAGER_READ";
   GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "DEPLOYMENT_MANAGER";
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."RCON_ID" IS 'Link to the Release_config table';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_BUILD_FILES" IS 'The current build file. Set by the Master, consumed by the Slaves.';
-   COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_RUN_LEVEL" IS 'Daemon indiactes its current state. 1:Cannot Continue, 2:Paused, 3:Active, 4:Idle, 5:Waiting, 6:Publishing';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_RUN_LEVEL" IS 'Daemon indiactes its current state. 1:Cannot Continue, 2:Paused, 3:Active, 4:Idle, 5:Waiting, 6:Publishing, 7:Planning';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."PAUSE" IS 'The daemon should pause at the end of the current build.Null:Run, 1:Pause, 2:Disable';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_PKG_ID_BEING_BUILT" IS 'pkg_id of the package currently being built';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."KEEP_ALIVE" IS 'DateTime of the last database enquiry made by the daemon. Used to locate dead daemons.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_PV_ID" IS 'The PV_ID of the package currently being built.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."LAST_BUILD" IS 'The DateTime that the last build started. This does not include dummy builds. Used to determine unused daemons.';
+;
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RM_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "MS_READONLY";
   GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
+--  DDL for Index PACKAGE_VERSIONS_PLATFORMS_IN
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."PACKAGE_VERSIONS_PLATFORMS_IN" ON "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS" ("PV_ID", "BP_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index PK_LICENCES
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_LICENCES" ON "RELEASE_MANAGER"."LICENCES" ("LICENCE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_INSTANCE_PLATFORMS_INDE
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS_INDE" ON "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS" ("BUILD_ID", "BP_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index PK_VIEWS
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_VIEWS" ON "RELEASE_MANAGER"."VIEWS" ("VIEW_ID")
   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 "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLATFORMS_UK1
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_PLATFORMS_UK1" ON "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_NAME")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_VIEWS
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_VIEWS" ON "RELEASE_MANAGER"."VIEWS" ("VIEW_NAME", "OWNER_ID")
   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 "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLATFORMS_CONFIG2_INDEX1
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2_INDEX1" ON "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" ("BP_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index INX_ACTION_DATE_TIME
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_ACTION_DATE_TIME" ON "RELEASE_MANAGER"."ACTION_LOG" ("ACTION_DATETIME")
   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 "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLATFORMS_CONFIG_INDEX1
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG_INDEX1" ON "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG" ("BP_ID", "GBE_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index INX_PACKAGES_V_NMM
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_PACKAGES_V_NMM" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("V_NMM")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
   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 "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLATFORMS_CONFIG2_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2_PK" ON "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" ("BP_ID", "BMCON_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index INX_DAEMON_INST_SCHED_DATETIME
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."INX_DAEMON_INST_SCHED_DATETIME" ON "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" ("SCHEDULED_DATETIME")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 4194304 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLATFORMS_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_PLATFORMS_PK" ON "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_ID")
+  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 "RELEASE_MANAGER_DATA" ;
+--------------------------------------------------------
 --  DDL for Index UNQ_PACKAGE_VERSIONS
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."UNQ_PACKAGE_VERSIONS" ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PKG_ID", "PKG_VERSION")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   End If;
 END;
+/
 ALTER TRIGGER "RELEASE_MANAGER"."TRIGGER_BUILD_INSTANCE" ENABLE;
 --------------------------------------------------------
+--  DDL for Trigger TRIGGER_BUILD_PLATFORMS
+--------------------------------------------------------
+  CREATE OR REPLACE TRIGGER "RELEASE_MANAGER"."TRIGGER_BUILD_PLATFORMS"
+BEFORE INSERT ON BUILD_PLATFORMS
+for each row
+BEGIN
+    If :new.BP_ID is null then
+      select SEQ_BUILD_PLATFORMS.nextval
+      into :new.BP_ID
+      from DUAL;
+  END IF;
+END;
+/
+ALTER TRIGGER "RELEASE_MANAGER"."TRIGGER_BUILD_PLATFORMS" ENABLE;
+--------------------------------------------------------
 --  DDL for Trigger TRIGGER_SDK_NAMES
 --------------------------------------------------------
   CREATE OR REPLACE TRIGGER "RELEASE_MANAGER"."TRIGGER_SDK_NAMES"
 BEFORE INSERT ON SDK_NAMES
       nPv_id OUT NUMBER,
       nUser_id OUT NUMBER,
       nInProgress OUT NUMBER,
       bExpired IN NUMBER default 1
    ) RETURN NUMBER;
    /*================================================================================================*/
    PROCEDURE cleanup_stranded_daemon_insts;
    /*================================================================================================*/
    PROCEDURE insert_daemon_inst(
       nOp_code IN NUMBER,
    PROCEDURE add_build_machine (
       sdisplay_name          IN   VARCHAR2,
       smachine_hostname      IN   VARCHAR2,
       ngbeid                 IN   NUMBER,
       sdescription           IN   VARCHAR2,
-      sactive                IN CHAR
+      sactive                IN   CHAR,
+      splatform_list         IN  VARCHAR2 default '0'
    );
    /*================================================================================================*/
    PROCEDURE delete_build_machine (sbmcon_id_list IN VARCHAR2);
    /*================================================================================================*/
    PROCEDURE update_build_machine (
       nbmcon_id              IN   NUMBER,
       sdisplay_name          IN   VARCHAR2,
       smachine_hostname      IN   VARCHAR2,
       ngbeid                 IN   NUMBER,
       sdescription           IN   VARCHAR2,
-      sactive                IN CHAR
+      sactive                IN   CHAR,
+      splatform_list         IN  VARCHAR2 default '0'
    );
    /*================================================================================================*/
    PROCEDURE import_daemons ( nSourceRtagId IN NUMBER, nTargetRtagId IN NUMBER, nUserId IN NUMBER  );
    /*================================================================================================*/
    PROCEDURE set_finite_pause ( duration IN NUMBER  );
    PROCEDURE set_build_plan (rtagId IN NUMBER, nStartIndex IN NUMBER, pvList IN VARCHAR2);
+   /*================================================================================================*/
+   PROCEDURE add_build_platform ( sname IN VARCHAR2,sdescription IN VARCHAR2, sactive IN CHAR, sMachType_list IN VARCHAR2);
+   PROCEDURE delete_build_platform (bp_id_list IN VARCHAR2);
+   PROCEDURE update_build_platform ( nbp_id IN NUMBER, sname IN VARCHAR2, sdescription IN VARCHAR2, sactive IN CHAR, sMachType_list IN VARCHAR2);
+   /*================================================================================================*/
+    FUNCTION insert_bi_platforms (nbuildid IN NUMBER, splatforms IN VARCHAR2, bClear IN NUMBER) RETURN VARCHAR2;
+    FUNCTION insert_pv_platforms (npvid IN NUMBER, splatforms IN VARCHAR2, bClear IN NUMBER) RETURN VARCHAR2;
 END pk_buildapi;
+/
 --------------------------------------------------------
       dependenciesimportlist   IN   VARCHAR2,
       isrippled                IN   NUMBER,
       username                 IN   VARCHAR2
+   )
       RETURN NUMBER;
 FUNCTION auto_make_vcsrelease2 (
       rtagid                   IN   NUMBER,
       pkgname                  IN   VARCHAR2,
       vext                     IN   VARCHAR2,
       newpkgversion            IN   VARCHAR2,
    PROCEDURE import_dependencies (
       pvid                     IN   NUMBER,
       dependenciesimportlist   IN   VARCHAR2,
       userid                   IN   NUMBER
    );
     PROCEDURE import_dependencies2 (
     pvid                     IN   NUMBER,
     dependenciesimportlist   IN   relmgr_varchar2_tab_t,
     userid                   IN   NUMBER
     );
    FUNCTION isSVN( pkgid IN NUMBER ) RETURN NUMBER;
    FUNCTION isSVNbyName( pkgname IN VARCHAR2 ) RETURN NUMBER;
-   FUNCTION new_build_instance( rtag_id IN NUMBER, pv_id IN NUMBER, reason IN CHAR ) return NUMBER;
+   FUNCTION new_build_instance( rtag_id IN NUMBER, pv_id IN NUMBER, reason IN CHAR, buildRef IN VARCHAR2 default null) return NUMBER;
    FUNCTION update_build_instance( nbuild_id IN NUMBER, npv_id IN NUMBER default null, nstate IN CHAR default null ) return NUMBER;
+   FUNCTION update_build_ref( nrtag_id IN NUMBER, buildRef IN VARCHAR2, buildRefNew IN VARCHAR2 default null ) return NUMBER;
    FUNCTION insert_test_run( build_id IN NUMBER, name IN VARCHAR2, outcome IN VARCHAR2, platform IN VARCHAR2, stype IN VARCHAR2, duration IN NUMBER default null, message IN CLOB default null) return NUMBER;
 END pk_rmapi;
       WHERE service = 'DPKG_ARCHIVE DISK SPACE USED';
       UPDATE build_service_config
          SET config = ssbommanagement
       WHERE service = 'SBOM MANAGEMENT';
       UPDATE build_service_config
          SET config = lxrserver
       WHERE service = 'LXR SERVER';
    END;
    PROCEDURE add_build_machine (
       sdisplay_name          IN   VARCHAR2,
       smachine_hostname      IN   VARCHAR2,
       ngbeid                 IN   NUMBER,
       sdescription           IN   VARCHAR2,
-      sactive                IN   CHAR
+      sactive                IN   CHAR,
+      splatform_list         IN  VARCHAR2
+   )
    IS
       nrecordnumber   NUMBER;
       nbmcon_id       NUMBER;
+      nsPlatformCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
    BEGIN
+      BEGIN
-      -- Get BMCON_ID
+          -- Get BMCON_ID
-      SELECT seq_bmcon_id.NEXTVAL INTO nbmcon_id FROM DUAL;
+          SELECT seq_bmcon_id.NEXTVAL INTO nbmcon_id FROM DUAL;
-      INSERT INTO build_machine_config(bmcon_id, display_name, machine_hostname,gbe_id,description,active)
+          INSERT INTO build_machine_config(bmcon_id, display_name, machine_hostname,gbe_id,description,active)
-            VALUES (nbmcon_id,sdisplay_name,smachine_hostname,ngbeid,sdescription, NVL(sactive,'N'));
+                VALUES (nbmcon_id,sdisplay_name,smachine_hostname,ngbeid,sdescription, NVL(sactive,'N'));
-   EXCEPTION
+       EXCEPTION
-      WHEN DUP_VAL_ON_INDEX
+          WHEN DUP_VAL_ON_INDEX
-      THEN
+          THEN
-         raise_application_error (-20000,
+             raise_application_error (-20000, 'Cannot have duplicate machines.' );
+       END;
+    DELETE FROM build_platforms_config2
+    WHERE bmcon_id = nbmcon_id;
-                                 'Cannot have duplicate machines.'
+    nsPlatformCollector := in_list_number(splatform_list);
-                                 );
+    FOR i IN 1..nsPlatformCollector.count
+    LOOP
+        INSERT INTO build_platforms_config2 (bp_id,bmcon_id) VALUES (nsPlatformCollector(i), nbmcon_id);
+    END LOOP;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
  PROCEDURE duplicate_daemon_config (
       nbmcon_id              IN   NUMBER,
       sdisplay_name          IN   VARCHAR2,
       smachine_hostname      IN   VARCHAR2,
       ngbeid                 IN   NUMBER,
       sdescription           IN   VARCHAR2,
-      sactive                IN   CHAR
+      sactive                IN   CHAR,
+      splatform_list         IN  VARCHAR2
+   )
    IS
+   nsPlatformCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
    BEGIN
+      BEGIN
-      UPDATE build_machine_config
+          UPDATE build_machine_config
-         SET display_name = sdisplay_name,
+             SET display_name = sdisplay_name,
-             machine_hostname = smachine_hostname,
+                 machine_hostname = smachine_hostname,
-             gbe_id = ngbeid,
+                 gbe_id = ngbeid,
-             description = sdescription,
+                 description = sdescription,
-             active = NVL(sactive, 'N')
+                 active = NVL(sactive, 'N')
-      WHERE bmcon_id = nbmcon_id;
+          WHERE bmcon_id = nbmcon_id;
-   EXCEPTION
+       EXCEPTION
-      WHEN DUP_VAL_ON_INDEX
+          WHEN DUP_VAL_ON_INDEX
-      THEN
+          THEN
-         raise_application_error (-20000,
+             raise_application_error (-20000,'Cannot have duplicate machines.' );
+        END;
+    DELETE FROM build_platforms_config2
+    WHERE bmcon_id = nbmcon_id;
-                                 'Cannot have duplicate machines.'
+    nsPlatformCollector := in_list_number(splatform_list);
-                                 );
+    FOR i IN 1..nsPlatformCollector.count
+    LOOP
+        INSERT INTO build_platforms_config2 (bp_id,bmcon_id) VALUES (nsPlatformCollector(i), nbmcon_id);
+    END LOOP;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
 PROCEDURE import_daemons ( nSourceRtagId IN NUMBER, nTargetRtagId IN NUMBER, nUserId IN NUMBER  ) IS
    -- check that the target does not have daemons configured
    OPEN curTgtReleaseConfigs;
    FETCH curtgtReleaseConfigs INTO recTgtReleaseConfigs;
    bHasDaemons := curTgtReleaseConfigs%FOUND;
    CLOSE curTgtReleaseConfigs;
   IF bHasDaemons THEN
     RAISE_APPLICATION_ERROR (-20000, 'Release must not have daemons configured' );
   END IF;
    /*-------------------------------------------------------*/
       -- Update build plan with order
       INSERT INTO BUILD_PLAN (RTAG_ID, BUILD_ORDER, PV_ID) VALUES (rtagId, SeqNum, nPvIdCollector(i));
       SeqNum := SeqNum + 1;
    END LOOP;
+END;
+/*-------------------------------------------------------------------------------------------------------*/
+   PROCEDURE delete_build_platform (bp_id_list IN VARCHAR2)
+   IS
+   BEGIN
+      DELETE FROM build_platforms
+            WHERE bp_id IN (
+                     SELECT * FROM THE
+                              (SELECT CAST
+                                          (in_list_number (bp_id_list) AS relmgr_number_tab_t
+                                          )
+                                 FROM DUAL
+                              ));
+   END;
+/*-------------------------------------------------------------------------------------------------------*/
+   PROCEDURE add_build_platform (
+      sname                  IN VARCHAR2,
+      sdescription           IN VARCHAR2,
+      sactive                IN CHAR,
+      sMachType_list         IN VARCHAR2
+   )
+    IS
+      nrecordnumber   NUMBER;
+      nbp_id          NUMBER;
+      nsMachTypeCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
+   BEGIN
+       BEGIN
+          -- Get BP_ID
+          SELECT seq_build_platforms.NEXTVAL INTO nbp_id FROM DUAL;
+          INSERT INTO build_platforms (bp_id, bp_name, bp_description,bp_active)
+                VALUES (nbp_id,sname,sdescription, NVL(sactive,'N'));
+       EXCEPTION
+          WHEN DUP_VAL_ON_INDEX
+          THEN
+             raise_application_error (-20000,
+                                     'Cannot have duplicate platform.'
+                                     );
+        END;
+    DELETE FROM build_platforms_config
+    WHERE bp_id = nbp_id;
+    nsmachtypecollector := in_list_number(smachtype_list);
+    FOR i IN 1..nsmachtypecollector.count
+    LOOP
+        INSERT INTO build_platforms_config (bp_id,gbe_id) VALUES (nbp_id,nsmachtypecollector(i));
+    END LOOP;
+   END;
+/*-------------------------------------------------------------------------------------------------------*/
+   PROCEDURE update_build_platform (
+      nbp_id              IN   NUMBER,
+      sname               IN   VARCHAR2,
+      sdescription        IN   VARCHAR2,
+      sactive             IN   CHAR,
+      sMachType_list      IN   VARCHAR2
+   )
+   IS
+   nsMachTypeCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
+BEGIN
+    BEGIN
+        UPDATE build_platforms
+        SET
+            bp_name = sname,
+            bp_description = sdescription,
+            bp_active = nvl(sactive, 'N')
+        WHERE
+            bp_id = nbp_id;
+    EXCEPTION
+        WHEN dup_val_on_index THEN
+            raise_application_error(-20000, 'Cannot have duplicate platform.');
+    END;
+    DELETE FROM build_platforms_config
+    WHERE bp_id = nbp_id;
+    nsmachtypecollector := in_list_number(smachtype_list);
+    FOR i IN 1..nsmachtypecollector.count
+    LOOP
+        INSERT INTO build_platforms_config (bp_id,gbe_id) VALUES (nbp_id,nsmachtypecollector(i));
+    END LOOP;
+END;
+--  Insert or delete platforms into the BUILD_INSTANCE_PLATFORMS table
+--  nbuildid - BuildId to link with
+--  splatforms - CSV list of platforms, If NULL, then the entry will be deleted
+--  bClear - Clear all before adding more
+--  Returns a CVS list of platforms not known
+FUNCTION insert_bi_platforms (
+    nbuildid IN NUMBER, splatforms IN VARCHAR2, bClear IN NUMBER
+) RETURN VARCHAR2 AS
+    idx NUMBER;
+    nbpid NUMBER;
+    citemcollection relmgr_varchar2_tab_t := relmgr_varchar2_tab_t();
+    omessage VARCHAR2(4000);
+BEGIN
+    IF bClear > 0 THEN
+        DELETE FROM build_instance_platforms
+        WHERE build_id = nbuildid;
+    END IF;
+    IF splatforms IS NOT NULL THEN
+        citemcollection := in_list_varchar2(splatforms, ',');
+        -- dbms_output.put_line(splatforms);
+        FOR idx IN 1..citemcollection.count LOOP
+            -- dbms_output.put_line(citemcollection(idx));
+         BEGIN
+            SELECT bp_id
+            INTO nbpid
+            FROM build_platforms
+            WHERE bp_name = citemcollection(idx);
+                INSERT INTO build_instance_platforms (
+                build_id, bp_id
+            ) VALUES (
+                nbuildid, nbpid
+            );
+        EXCEPTION
+            WHEN no_data_found THEN
+                    -- dbms_output.put_line('No Data found' || citemcollection(idx));
+                omessage := omessage
+                            || ','
+                            || citemcollection(idx);
+            WHEN dup_val_on_index THEN
+                    -- dbms_output.put_line('DUPLICATE:' || citemcollection(idx));
+                NULL;
+        END;
+        END LOOP;
+        omessage := substr(omessage, 2);
+        --dbms_output.put_line('NOT FOUND:' || omessage);
+    END IF;
+    RETURN omessage;
+END;
+--  Insert or delete platforms into the PACKAGE_VERSION_PLATFORMS table
+--  npvid - PvId to link with
+--  splatforms - CSV list of platforms, If NULL, then the entry will be deleted
+--  bClear - Clear all before adding more
+--  Returns a CVS list of platforms not known
+FUNCTION insert_pv_platforms (
+    npvid IN NUMBER, splatforms IN VARCHAR2, bClear IN NUMBER
+) RETURN VARCHAR2 AS
+    idx NUMBER;
+    nbpid NUMBER;
+    citemcollection relmgr_varchar2_tab_t := relmgr_varchar2_tab_t();
+    omessage VARCHAR2(4000);
+BEGIN
+    IF bClear > 0 THEN
+        DELETE FROM package_version_platforms
+        WHERE pv_id = npvid;
+    END IF;
+    IF splatforms IS NOT NULL THEN
+        citemcollection := in_list_varchar2(splatforms, ',');
+        -- dbms_output.put_line(splatforms);
+        FOR idx IN 1..citemcollection.count LOOP
+            -- dbms_output.put_line(citemcollection(idx));
+         BEGIN
+            SELECT bp_id
+            INTO nbpid
+            FROM build_platforms
+            WHERE bp_name = citemcollection(idx);
+                INSERT INTO package_version_platforms (
+                pv_id, bp_id
+            ) VALUES (
+                npvid, nbpid
+            );
+        EXCEPTION
+            WHEN no_data_found THEN
+                    -- dbms_output.put_line('No Data found' || citemcollection(idx));
+                omessage := omessage
+                            || ','
+                            || citemcollection(idx);
+            WHEN dup_val_on_index THEN
+                    -- dbms_output.put_line('DUPLICATE:' || citemcollection(idx));
+                NULL;
+        END;
+        END LOOP;
+        omessage := substr(omessage, 2);
+        --dbms_output.put_line('NOT FOUND:' || omessage);
+    END IF;
+    RETURN omessage;
 END;
 END pk_buildapi;
+/
       DELETE FROM planned_versions
             WHERE pkg_id = pkgid AND pkg_version = newpkgversion;
       RETURN pvid;
    END;
 /*-------------------------------------------------------------------------------------------------------*/
 --  import package dependencies (2nd attenpt)
 --  Package dependencies are an array of strings. Each string is of the form
 --    'PkgName','PkgVersion','PkgType'
 --  The use of an array of package dependencies allows packages with very long
                                      || ' '
                                      || pkgversion
                                      || '] does not exist yet and cannot be used!'
                                     );
               END;
               -- Get Build Type (i.e. BuildPackageArchive or LinkPackageArchive)
               IF pkgtype IS NULL
               THEN
                 BEGIN
                    pkgtype := cbuildtypes (pkgid || seperator || vext);
                    IF pkgtype IS NULL
                    THEN
                       -- Set build type to LinkPackageArchive by default
                       pkgtype := 'L';
                    END IF;
                    WHEN NO_DATA_FOUND
                    THEN
                       pkgtype := 'L';
                 END;
               END IF;
               -- Limit to known types
               IF UPPER(pkgtype) like('B%') THEN
                 pkgtype := 'B';
               ELSE
                 pkgtype := 'L';
               END IF;
               -- Insert Dependencies
               update_package_dependency (pvid,
                                          pkgname,
                                          pkgversion,
                                          pkgtype,
              The timestamp will be created
 Paramters:	rtag_id:	Release ID - must exist
             pv_id:    Package ID - must exist
             reason:   Reason code for the build
+            buildRef: Identify build logs
 Returns:	BUILD_ID for the new entry
           Returns -1 on error, PV_ID or RTAG_ID do not exist
 */
-FUNCTION new_build_instance( rtag_id IN NUMBER, pv_id IN NUMBER , reason IN CHAR)
+FUNCTION new_build_instance( rtag_id IN NUMBER, pv_id IN NUMBER , reason IN CHAR, buildRef IN VARCHAR2)
   RETURN NUMBER
   IS
     build_id NUMBER := 0;
   BEGIN
-    INSERT into BUILD_INSTANCES (RTAG_ID, PV_ID, REASON)
+    INSERT into BUILD_INSTANCES (RTAG_ID, PV_ID, REASON, BUILD_REF)
-    values( rtag_id, pv_id, reason)
+    values( rtag_id, pv_id, reason, buildRef)
     returning BUILD_ID into build_id;
     return build_id;
   EXCEPTION
     WHEN OTHERS THEN
       return -1;
         IF SQL%NOTFOUND THEN
           RETURN -3;
         END IF;
     ELSE
       RETURN -4;
+    END IF;
+  END IF;
+  RETURN 1;
+  EXCEPTION
+    WHEN OTHERS THEN
+      RETURN -1;
+  END;
+/*-------------------------------------------------------------------------------------------------------
+Name: update_build_instance
+Description: Update fields in an existing build instance
+Returns: -1 on error
+*/
+FUNCTION update_build_ref( nrtag_id IN NUMBER, buildRef IN VARCHAR2, buildRefNew IN VARCHAR2 ) RETURN NUMBER
+IS
+BEGIN
+  IF ( nrtag_id IS NOT NULL AND nrtag_id > 0 ) THEN
+    UPDATE BUILD_INSTANCES SET BUILD_REF = buildRefNew WHERE nrtag_id = RTAG_ID AND UPPER(BUILD_REF) = UPPER(buildRef);
+    IF SQL%NOTFOUND THEN
+      RETURN -2;
     END IF;
   END IF;
   RETURN 1;
   EXCEPTION
 --  DDL for Synonymn USER_ROLES
 --------------------------------------------------------
   CREATE OR REPLACE SYNONYM "RELEASE_MANAGER"."USER_ROLES" FOR "ACCESS_MANAGER"."USER_ROLES";
 --------------------------------------------------------
---  Constraints for Table RELEASE_TAGS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" ADD CONSTRAINT "PK_RELEASE_TAGS" PRIMARY KEY ("RTAG_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PARENT_RTAG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("REBUILD_STAMP" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("REBUILD_ENV" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("OFFICIAL" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("RTAG_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table PACKAGE_DOCUMENTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("DOC_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table AUTOBUILD_FAILURE
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD PRIMARY KEY ("GROUP_EMAIL_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table RELEASE_METRICS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_METRICS" ADD CONSTRAINT "UNQ_RELEASE_METRICS" UNIQUE ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
 --  Constraints for Table RELEASE_COMPONENTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table SDK_CONTENT
+--  Constraints for Table BUILD_PLATFORMS_CONFIG
 --------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKPKG_STATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG" MODIFY ("GBE_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG" MODIFY ("BP_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table ACTION_TYPE
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" ADD CONSTRAINT "UNQ_ACTTYPE_ID" PRIMARY KEY ("ACTTYPE_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PLANNED
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD CONSTRAINT "UNIQUE_PV_RTAG" UNIQUE ("PV_ID", "RTAG_ID")
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" MODIFY ("VIEW_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table SDK_TAGS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD CONSTRAINT "SDK_TAGS_PK" PRIMARY KEY ("SDKTAG_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDK_STATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDK_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table RELEASE_MODIFIED
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED" ADD CONSTRAINT "RELEASE_MODIFIED_PK" PRIMARY KEY ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PACKAGE_BUILD_ENV
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("BE_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table PROCESSES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PROCESSES" ADD CONSTRAINT "PROCESSES_PK" PRIMARY KEY ("PROC_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PROCESSES" MODIFY ("PROC_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table BUILD_SERVICE_CONFIG
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("CONFIG" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("SERVICE" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table PROJECT_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VTREES" MODIFY ("HIDE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VTREES" MODIFY ("VTREE_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VTREES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VTREES" MODIFY ("VTREE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table GBE_MACHTYPE
+--  Constraints for Table BUILD_INSTANCE_PLATFORMS
 --------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" ADD PRIMARY KEY ("GBE_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("BM_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS" MODIFY ("BP_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("GBE_VALUE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("GBE_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table PACKAGE_INTEREST
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS" MODIFY ("BUILD_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PROJ_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PKG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGES" ADD CONSTRAINT "PK_PACKAGES" PRIMARY KEY ("PKG_ID")
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("DPV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PRODUCT_COMPONENTS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table TEST_TYPES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" ADD CONSTRAINT "PK_TEST_TYPES" PRIMARY KEY ("TEST_TYPE_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" MODIFY ("TEST_TYPE_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" MODIFY ("TEST_TYPE_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table MICROSOFTDTPROPERTIES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" ADD CONSTRAINT "MICROSOFT_PK_DTPROPERTIES" PRIMARY KEY ("ID", "PROPERTY")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("VERSION" CONSTRAINT "MICROSOFT_NN_VERSION" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("PROPERTY" CONSTRAINT "MICROSOFT_NN_PROPERTY" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("ID" CONSTRAINT "MICROSOFT_NN_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table PRODUCT_STATES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PRODUCT_STATES" ADD CONSTRAINT "PRODUCT_STATES_PK" PRIMARY KEY ("STATE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
 --  Constraints for Table CODE_REVIEWS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEWS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table RELEASE_CONTENT
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PKG_STATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERTOR_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERT_STAMP" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("BASE_VIEW_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table WORLDS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."WORLDS" ADD CONSTRAINT "PK_WORLDS" PRIMARY KEY ("WORLD_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."WORLDS" MODIFY ("WORLD_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."WORLDS" MODIFY ("WORLD_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PEGGED_VERSIONS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table ABT_ACTION_LOG
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" MODIFY ("RCON_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table LICENCING
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD CONSTRAINT "LICENCING_PK" PRIMARY KEY ("PV_ID", "LICENCE")
-  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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("LICENCE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table DASH_BOARD
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("TOTAL_PACKAGES" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("AUTOMATED_PACKAGES" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("LAST_BUILD_TIME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("RTAG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("PROJ_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table BUILD_INSTANCES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD CONSTRAINT "BUILD_ID" PRIMARY KEY ("BUILD_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."NOTE_MANAGER" MODIFY ("NID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table BLAT_PROJECTS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" MODIFY ("BLAT_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table NOTIFICATION_HISTORY
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD CONSTRAINT "PK_NOTIFICATION_HISTORY" PRIMARY KEY ("RTAG_ID", "PV_ID", "USER_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("USER_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table ACTION_LOG
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_TIMESTAMP" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table RELEASE_LINKS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("REF_RTAG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table VTREES_WORLD
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("VTREE_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("WORLD_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table DAEMON_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" MODIFY ("RCON_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table BUILD_STANDARDS_ADDENDUM
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_PK" PRIMARY KEY ("BSA_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BS_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table BUILD_MACHINES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINES" ADD CONSTRAINT "BUILD_MACHINES_PK" PRIMARY KEY ("BM_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PLATFORMS" MODIFY ("NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PLATFORMS" MODIFY ("CODE" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table WORK_IN_PROGRESS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table CQ_ISSUES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_STATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_DB" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table BUILD_ORDER
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("STEP_NUM" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table VALIDATION_RULES_DELETE_ME
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."VALIDATION_RULES_DELETE_ME" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VALIDATION_RULES_DELETE_ME" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table CODE_REVIEW_URL
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD CONSTRAINT "CODE_REVIEW_URL_PK" PRIMARY KEY ("CR_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("DATE_OF_REVIEW" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("URL" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PROJ_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("CR_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table RELEASE_CONFIG
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD PRIMARY KEY ("RCON_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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" MODIFY ("RCON_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table PACKAGE_PROCESSES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PACKAGE_BUILD_INFO
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("BM_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table VIEW_SETTINGS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("USER_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table DEPRECATED_PACKAGES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("COMMENTS" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table BUILD_PLAN
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_PK" PRIMARY KEY ("RTAG_ID", "BUILD_ORDER", "PV_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" MODIFY ("RCON_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table DO_NOT_RIPPLE
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table CQ_SOFTWARE_ISSUE
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ADD CONSTRAINT "CQ_SOFTWARE_ISSUE_PK" PRIMARY KEY ("DBID")
-  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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" MODIFY ("DBID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table LICENCES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."LICENCES" ADD CONSTRAINT "PK_LICENCES" PRIMARY KEY ("LICENCE")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("TEST_TYPES_FK" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("TEST_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table BLAT_SERVERS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" ADD CONSTRAINT "BLAT_SERVERS_UK1" UNIQUE ("BLAT_SERVER_NAME")
-  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 "RELEASE_MANAGER_DATA"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" ADD CONSTRAINT "BLAT_SERVERS_PK" PRIMARY KEY ("BLAT_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 "RELEASE_MANAGER_DATA"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_SEQNUM" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_DISPLAY_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_SERVER_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table CQ_STATEDEF
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."CQ_STATEDEF" ADD CONSTRAINT "CQ_STATEDEF_PK" PRIMARY KEY ("ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("LEVEL_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("SESSION_NUM" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table CQ_USERS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" ADD CONSTRAINT "CQ_USERS_PK" PRIMARY KEY ("DBID")
-  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 "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" MODIFY ("DBID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table TEMP_ENV_DEPS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" ADD CONSTRAINT "TEMP_ENV_DEPS_PK" PRIMARY KEY ("PV_ID", "SESSION_NUM", "DPV_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("DPV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("SESSION_NUM" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table RUN_LEVEL_SCHEDULE
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" ADD PRIMARY KEY ("SCHEDULED_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" MODIFY ("SCHEDULED_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table SDK_NAMES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" ADD CONSTRAINT "SDK_NAMES_PK" PRIMARY KEY ("SDK_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
 --  Constraints for Table PROJECT_EXTENTIONS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_EXTENTIONS" MODIFY ("EXT_NAME" NOT NULL ENABLE);
 --------------------------------------------------------
+--  Constraints for Table PACKAGE_VERSIONS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PK_PACKAGE_VERSIONS" PRIMARY KEY ("PV_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("LAST_PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("OWNER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("CREATOR_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("MODIFIER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("DLOCKED" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_VERSION" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table LXR_STATE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD CONSTRAINT "LXR_STATE_PK" PRIMARY KEY ("RTAG_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_MACHINE_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD CONSTRAINT "PK_BUILD_MACHINE_CONFIG" PRIMARY KEY ("BMCON_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("ACTIVE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("GBE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("MACHINE_HOSTNAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("DISPLAY_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("BMCON_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ADVISORY_RIPPLE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PACKAGE_DEPENDENCIES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table JIRA_ISSUES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."JIRA_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ADDITIONAL_NOTES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_USER" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_TITLE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ARCHIVE_DATA
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_ENVIRONMENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ADD CONSTRAINT "PK_BUILD_ENVIRONMENTS" PRIMARY KEY ("BE_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table RELEASE_TAGS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PLAN_DROP" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PLAN_THRESHOLD" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" ADD CONSTRAINT "PK_RELEASE_TAGS" PRIMARY KEY ("RTAG_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("PARENT_RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("REBUILD_STAMP" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("REBUILD_ENV" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("OFFICIAL" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("RTAG_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table AUTOBUILD_FAILURE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD PRIMARY KEY ("GROUP_EMAIL_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table SDK_CONTENT
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKPKG_STATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ACTION_TYPE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" ADD CONSTRAINT "UNQ_ACTTYPE_ID" PRIMARY KEY ("ACTTYPE_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table SDK_TAGS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD CONSTRAINT "SDK_TAGS_PK" PRIMARY KEY ("SDKTAG_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDK_STATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDK_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PACKAGE_BUILD_ENV
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("BE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_SERVICE_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("CONFIG" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("SERVICE" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PACKAGE_VERSION_PLATFORMS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS" MODIFY ("BP_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table GBE_MACHTYPE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" ADD PRIMARY KEY ("GBE_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("BM_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("GBE_VALUE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("GBE_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PACKAGE_INTEREST
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PKG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PRODUCT_COMPONENTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table TEST_TYPES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" ADD CONSTRAINT "PK_TEST_TYPES" PRIMARY KEY ("TEST_TYPE_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" MODIFY ("TEST_TYPE_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" MODIFY ("TEST_TYPE_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table MICROSOFTDTPROPERTIES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" ADD CONSTRAINT "MICROSOFT_PK_DTPROPERTIES" PRIMARY KEY ("ID", "PROPERTY")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("VERSION" CONSTRAINT "MICROSOFT_NN_VERSION" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("PROPERTY" CONSTRAINT "MICROSOFT_NN_PROPERTY" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("ID" CONSTRAINT "MICROSOFT_NN_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table RELEASE_CONTENT
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PKG_STATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERTOR_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERT_STAMP" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("BASE_VIEW_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PEGGED_VERSIONS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ABT_ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" MODIFY ("RCON_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table LICENCING
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD CONSTRAINT "LICENCING_PK" PRIMARY KEY ("PV_ID", "LICENCE")
+  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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("LICENCE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table DASH_BOARD
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("TOTAL_PACKAGES" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("AUTOMATED_PACKAGES" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("LAST_BUILD_TIME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BLAT_PROJECTS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_PROJECTS" MODIFY ("BLAT_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_PLATFORMS_CONFIG2
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" ADD CONSTRAINT "BUILD_PLATFORMS_CONFIG2_PK" PRIMARY KEY ("BP_ID", "BMCON_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 "RELEASE_MANAGER_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" MODIFY ("BMCON_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" MODIFY ("BP_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table NOTIFICATION_HISTORY
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD CONSTRAINT "PK_NOTIFICATION_HISTORY" PRIMARY KEY ("RTAG_ID", "PV_ID", "USER_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table ACTION_LOG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_TIMESTAMP" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table RELEASE_LINKS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("REF_RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table VTREES_WORLD
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("VTREE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("WORLD_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_STANDARDS_ADDENDUM
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_PK" PRIMARY KEY ("BSA_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BS_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table WORK_IN_PROGRESS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table CQ_ISSUES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_STATE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_DB" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BUILD_ORDER
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("STEP_NUM" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table CODE_REVIEW_URL
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD CONSTRAINT "CODE_REVIEW_URL_PK" PRIMARY KEY ("CR_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("DATE_OF_REVIEW" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("URL" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("CR_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table RELEASE_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD PRIMARY KEY ("RCON_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" MODIFY ("RCON_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table PACKAGE_BUILD_INFO
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("BM_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("PV_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table VIEW_SETTINGS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("USER_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table DEPRECATED_PACKAGES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("COMMENTS" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table DO_NOT_RIPPLE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table CQ_SOFTWARE_ISSUE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ADD CONSTRAINT "CQ_SOFTWARE_ISSUE_PK" PRIMARY KEY ("DBID")
+  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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" MODIFY ("DBID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table BLAT_SERVERS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" ADD CONSTRAINT "BLAT_SERVERS_UK1" UNIQUE ("BLAT_SERVER_NAME")
+  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 "RELEASE_MANAGER_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" ADD CONSTRAINT "BLAT_SERVERS_PK" PRIMARY KEY ("BLAT_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 "RELEASE_MANAGER_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_SEQNUM" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_DISPLAY_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_SERVER_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BLAT_SERVERS" MODIFY ("BLAT_ID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table CQ_USERS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" ADD CONSTRAINT "CQ_USERS_PK" PRIMARY KEY ("DBID")
+  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 "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" MODIFY ("DBID" NOT NULL ENABLE);
+--------------------------------------------------------
+--  Constraints for Table RUN_LEVEL_SCHEDULE
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" ADD PRIMARY KEY ("SCHEDULED_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" MODIFY ("SCHEDULED_ID" NOT NULL ENABLE);
+--------------------------------------------------------
 --  Constraints for Table MEMBERS_GROUP
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."MEMBERS_GROUP" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
 --------------------------------------------------------
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" MODIFY ("OP_CODE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" MODIFY ("DAEMON_INSTRUCTIONS_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PACKAGE_VERSIONS
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PK_PACKAGE_VERSIONS" PRIMARY KEY ("PV_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("LAST_PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("OWNER_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("CREATOR_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("MODIFIER_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("DLOCKED" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_VERSION" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table BUILD_ENV_DOCUMENTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table LXR_STATE
+--  Constraints for Table BUILD_PLATFORMS
 --------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD CONSTRAINT "LXR_STATE_PK" PRIMARY KEY ("RTAG_ID")
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS" ADD CONSTRAINT "BUILD_PLATFORMS_UK1" UNIQUE ("BP_NAME")
   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 "RELEASE_MANAGER_INDX"  ENABLE;
+  TABLESPACE "RELEASE_MANAGER_DATA"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table BUILD_MACHINE_CONFIG
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD CONSTRAINT "PK_BUILD_MACHINE_CONFIG" PRIMARY KEY ("BMCON_ID")
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS" ADD CONSTRAINT "BUILD_PLATFORMS_PK" PRIMARY KEY ("BP_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 "RELEASE_MANAGER_INDX"  ENABLE;
+  TABLESPACE "RELEASE_MANAGER_DATA"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("ACTIVE" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS" MODIFY ("BP_ACTIVE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("GBE_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("MACHINE_HOSTNAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("DISPLAY_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS" MODIFY ("BP_NAME" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("BMCON_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS" MODIFY ("BP_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table ADVISORY_RIPPLE
+--  Constraints for Table PACKAGE_PATCHES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("INSTALL_ORDER" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PATCH_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PROJECTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" ADD CONSTRAINT "PK_PROJECTS" PRIMARY KEY ("PROJ_ID")
   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" MODIFY ("PROJ_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table PACKAGE_PATCHES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("INSTALL_ORDER" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PATCH_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table PACKAGE_DEPENDENCIES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table JIRA_ISSUES
+--  Constraints for Table VIEW_DEF
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."JIRA_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table ADDITIONAL_NOTES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_USER" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_TITLE" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table ARCHIVE_DATA
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("PV_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("RTAG_ID" NOT NULL ENABLE);
---------------------------------------------------------
---  Constraints for Table BUILD_ENVIRONMENTS
 --------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ADD CONSTRAINT "PK_BUILD_ENVIRONMENTS" PRIMARY KEY ("BE_ID")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
-  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "RELEASE_MANAGER_INDX"  ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_NAME" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("PKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("VIEW_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VIEWS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" ADD CONSTRAINT "PK_VIEWS" PRIMARY KEY ("VIEW_ID")
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" MODIFY ("BASE_VIEW" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" MODIFY ("OWNER_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" MODIFY ("VIEW_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table VIEW_DEF
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("PKG_ID" NOT NULL ENABLE);
-  ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("VIEW_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Ref Constraints for Table ABT_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" ADD FOREIGN KEY ("RCON_ID")
 	  REFERENCES "RELEASE_MANAGER"."RELEASE_CONFIG" ("RCON_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD CONSTRAINT "BUILD_INSTANCES_FK1" FOREIGN KEY ("RTAG_ID")
 	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE SET NULL ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD CONSTRAINT "BUILD_INSTANCES_FK2" FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
 --------------------------------------------------------
+--  Ref Constraints for Table BUILD_INSTANCE_PLATFORMS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS" ADD CONSTRAINT "BUILD_INSTANCE_PLATFORMS_FK1" FOREIGN KEY ("BUILD_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_INSTANCES" ("BUILD_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCE_PLATFORMS" ADD CONSTRAINT "BUILD_INSTANCE_PLATFORMS_FK2" FOREIGN KEY ("BP_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
 --  Ref Constraints for Table BUILD_MACHINE_CONFIG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD CONSTRAINT "FK_BM_GBE_ID" FOREIGN KEY ("GBE_ID")
 	  REFERENCES "RELEASE_MANAGER"."GBE_MACHTYPE" ("GBE_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK1" FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK2" FOREIGN KEY ("RTAG_ID")
 	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
 --------------------------------------------------------
+--  Ref Constraints for Table BUILD_PLATFORMS_CONFIG
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG" ADD CONSTRAINT "BUILD_PLATFORMS_CONFIG_FK1" FOREIGN KEY ("BP_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG" ADD CONSTRAINT "BUILD_PLATFORMS_CONFIG_FK2" FOREIGN KEY ("GBE_ID")
+	  REFERENCES "RELEASE_MANAGER"."GBE_MACHTYPE" ("GBE_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_PLATFORMS_CONFIG2
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" ADD CONSTRAINT "TABLE1_FK1" FOREIGN KEY ("BP_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLATFORMS_CONFIG2" ADD CONSTRAINT "TABLE1_FK2" FOREIGN KEY ("BMCON_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ("BMCON_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
 --  Ref Constraints for Table BUILD_STANDARDS_ADDENDUM
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_R01" FOREIGN KEY ("BS_ID")
 	  REFERENCES "RELEASE_MANAGER"."BUILD_STANDARDS" ("BS_ID") ENABLE;
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
 --------------------------------------------------------
 --  Ref Constraints for Table PACKAGE_BUILD_INFO
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD CONSTRAINT "PACKAGE_BUILD_INFO_FK1" FOREIGN KEY ("BSA_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ("BSA_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("BM_ID")
 	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINES" ("BM_ID") ENABLE;
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PKG_NAME_EXISTS" FOREIGN KEY ("PKG_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD FOREIGN KEY ("BS_ID")
 	  REFERENCES "RELEASE_MANAGER"."BUILD_STANDARDS" ("BS_ID") ENABLE;
 --------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_VERSION_PLATFORMS
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS" ADD CONSTRAINT "PACKAGE_VERSIONS_PLATFORM_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSION_PLATFORMS" ADD CONSTRAINT "PACKAGE_VERSION_PLATFORMS_FK1" FOREIGN KEY ("BP_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_PLATFORMS" ("BP_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
 --  Ref Constraints for Table PEGGED_VERSIONS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" ADD CONSTRAINT "PEGGED_VERSIONS_PACKAG_FK1" FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
 --------------------------------------------------------
 --  Ref Constraints for Table RELEASE_CONFIG
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD CONSTRAINT "RELEASE_CONFIG_FK1" FOREIGN KEY ("BMCON_ID")
+	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ("BMCON_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD FOREIGN KEY ("RTAG_ID")
 	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
-  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD FOREIGN KEY ("GBE_ID")
-	  REFERENCES "RELEASE_MANAGER"."GBE_MACHTYPE" ("GBE_ID") ENABLE;
 --------------------------------------------------------
 --  Ref Constraints for Table RELEASE_CONTENT
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" ADD CONSTRAINT "RELEASE_CONTENT_FK1" FOREIGN KEY ("SDKTAG_ID")

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql – Rev 7039 → 7340