Rem    NAME 
Rem      ckmigind.sql
Rem    DESCRIPTION
Rem      Creates Indexes used for Migration of Designer/2000 IDs to Oracle Repository
Rem    RETURNS
Rem 	 None
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    CREATED
Rem	  30/03/1999
Rem	 UPDATED
Rem     11/08/1999 - VDESAI - B934995 - NEED TO TIE IN SYSTEM LANGUAGES WITH SYSTEM FOLDER
Rem

PROMPT * Creating Migration Indexes

CREATE INDEX JR_ID_MAPS_UK1 ON JR_ID_MAPS(old_id);

CREATE INDEX JR_ID_MAPS_UK2 ON JR_ID_MAPS(irid);

CREATE INDEX JR_ID_MAPS_UK3 ON JR_ID_MAPS(is_a_pac_element);

CREATE INDEX JR_ID_MAPS_UK4 ON JR_ID_MAPS(owning_app);

CREATE INDEX JR_ID_MAPS_UK5 ON JR_ID_MAPS(ivid);

CREATE INDEX JR_ID_MAPS_UK6 ON JR_ID_MAPS(element_type);

CREATE INDEX JR_ID_MAPS_UK7 ON JR_ID_MAPS(part_of_id);

CREATE INDEX JR_ID_MAPS_UK8 ON JR_ID_MAPS(use_of_id);