Rem    NAME 
Rem      ckupgind.sql
Rem    DESCRIPTION
Rem      Creates Indexes used for Specific PreUpgrades
Rem    RETURNS
Rem 	 None
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    CREATED
Rem	  12/04/1999
Rem    UPDATED
Rem     26/97/1999 - VDESAI - B946709 - MIGRATION HAS MISSING INDEXES ON TEMPORARY UPGRADE TABLES ... UPG_...
Rem

-- -- ---- -- ---- -- ---- -- --
-- Application Systems
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_APP
PROMPT

CREATE UNIQUE INDEX UPG_APP_PK ON UPG_APP (ID)
/


-- -- ---- -- ---- -- ---- -- --
-- Modules
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_MOD
PROMPT

CREATE UNIQUE INDEX UPG_MOD_PK ON UPG_MOD (ID)
/


-- -- ---- -- ---- -- ---- -- --
-- Languages
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_LAN
PROMPT

CREATE UNIQUE INDEX UPG_CI_LAN_PK ON UPG_CI_LAN (ID)
/

-- -- ---- -- ---- -- ---- -- --
-- Extended Element
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_SDD_UEE
PROMPT

CREATE UNIQUE INDEX UPG_SDD_UEE_PK ON UPG_SDD_UEE (ID)
/

-- -- ---- -- ---- -- ---- -- --
-- Extended Structure Element
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_SDD_UES
PROMPT

CREATE UNIQUE INDEX UPG_SDD_UES_PK ON UPG_SDD_UES (ID)
/

-- -- ---- -- ---- -- ---- -- --
-- Module Networks
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_MODMOD
PROMPT

CREATE UNIQUE INDEX UPG_CI_MODMOD_PK ON UPG_CI_MODMOD (ID)
/

CREATE INDEX UPG_CI_MODMOD_I1 ON UPG_CI_MODMOD (CHILD_MODULE_REFERENCE, PARENT_MODULE_REFERENCE, ELEMENT_TYPE_NAME)
/

-- -- ---- -- ---- -- ---- -- --
-- Diagrams
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_DIA
PROMPT

CREATE UNIQUE INDEX UPG_CI_DIA_PK ON UPG_CI_DIA (ID)
/


-- -- ---- -- ---- -- ---- -- --
-- Diagram Element Usages
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_DEU
PROMPT

CREATE UNIQUE INDEX UPG_CI_DEU_PK ON UPG_CI_DEU (ID)
/

CREATE INDEX UPG_CI_DEU_I1 ON UPG_CI_DEU (CIELEMENT_REFERENCE, DIAGRAM_REFERENCE, ELEMENT_TYPE_NAME)
/


-- -- ---- -- ---- -- ---- -- --
-- Module Units
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_MUN
PROMPT

CREATE UNIQUE INDEX UPG_CI_MUN_PK ON UPG_CI_MUN (IRID)
/

CREATE INDEX UPG_CI_MUN_I1 ON UPG_CI_MUN (GENERAL_MODULE_REF)
/

CREATE INDEX UPG_CI_MUN_I2 ON UPG_CI_MUN (MODULE_COMPONENT_REF)
/


-- -- ---- -- ---- -- ---- -- --
-- Module Detail Table Usages
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_MDT
PROMPT

CREATE UNIQUE INDEX UPG_CI_MDTU_PK ON UPG_CI_MDTU (ID)
/

CREATE INDEX UPG_CI_MDTU_I1 ON UPG_CI_MDTU (MODULE_COMPONENT_REFERENCE)
/

CREATE INDEX UPG_CI_MDTU_I2 ON UPG_CI_MDTU (MTI_REFERENCE)
/


-- -- ---- -- ---- -- ---- -- --
--    Data Bound Items
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_ITEMS
PROMPT

CREATE UNIQUE INDEX UPG_CI_ITEMS_PK ON UPG_CI_ITEMS (ID)
/

CREATE INDEX UPG_CI_ITEMS_I1 ON UPG_CI_ITEMS (MODULE_COMPONENT_REFERENCE)
/

CREATE INDEX UPG_CI_ITEMS_I2 ON UPG_CI_ITEMS (DETAIL_TABLE_USAGE_REFERENCE)
/

CREATE INDEX UPG_CI_ITEMS_I3 ON UPG_CI_ITEMS (COLUMN_REFERENCE)
/

-- -- ---- -- ---- -- ---- -- --
--    Item Groups
-- -- ---- -- ---- -- ---- -- --


PROMPT
PROMPT * Creating Indexes on Table UPG_CI_IGR
PROMPT

CREATE UNIQUE INDEX UPG_CI_IGR_PK ON UPG_CI_IGR (ID)
/

CREATE INDEX UPG_CI_IGR_I1 ON UPG_CI_IGR (MODULE_COMPONENT_REFERENCE)
/


-- -- ---- -- ---- -- ---- -- --
--    List Of Values Inclusions
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_LVI
PROMPT

CREATE INDEX UPG_LVI_I1 ON UPG_LVI (GENERAL_MODULE_REF)
/

CREATE INDEX UPG_LVI_I2 ON UPG_LVI (LIST_OF_VALUES_REF)
/

CREATE INDEX UPG_LVI_I3 ON UPG_LVI (ITEM_REF)
/


-- -- ---- -- ---- -- ---- -- --
--    Navigation Action Items
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_CI_NAI
PROMPT

CREATE UNIQUE INDEX UPG_CI_NAI_PK ON UPG_CI_NAI (ID)
/

CREATE INDEX UPG_CI_NAI_I1 ON UPG_CI_NAI (GENERAL_MODULE_REFERENCE)
/

CREATE INDEX UPG_CI_NAI_I2 ON UPG_CI_NAI (ACTION_ITEM_FOR, NAVIGATION_TO, WINDOW_REFERENCE)
/

CREATE INDEX UPG_CI_NAI_I3 ON UPG_CI_NAI (ACTION_ITEM_FOR, NAVIGATION_TO, MCN_REFERENCE)
/

-- -- ---- -- ---- -- ---- -- --
--    Multi-Line Text
-- -- ---- -- ---- -- ---- -- --

PROMPT
PROMPT * Creating Indexes on Table UPG_RM_TEXT_LINES
PROMPT

CREATE INDEX UPG_RM_TEXT_LINES_IND ON UPG_RM_TEXT_LINES (TXT_REF)
/

-- -- ---- -- ---- -- ---- -- --
--    Application logic
-- -- ---- -- ---- -- ---- -- --

CREATE INDEX UPG_APPLICATION_LOGIC_IND ON UPG_APPLICATION_LOGIC (AL_REPOS_ELEMENT)
/

-- -- ---- -- ---- -- ---- -- --
--    User Preferences
-- -- ---- -- ---- -- ---- -- --

CREATE INDEX UPG_CI_UPR_IND ON UPG_CI_UPR (CIELEMENT_REFERENCE)
/
