REM $Header: afsvcidc.sql 26.0 2002/11/27 03:00:45 sacsharm ship $
REM ***********************************************************************
REM   NAME
REM       afsvcidc.sql 
REM   DESCRIPTION
REM       Adds indexes to all GSC tables
REM   USAGE
REM       sqlplus apps/apps @afsvcidc applsys fnd
REM ********************************************************************
REM Connect to base account
REM (autopatch will run all scripts in apps account)

REM  dbdrv: none

connect &1/&2;

REM Continue in case of error where constraints aready exist
WHENEVER SQLERROR CONTINUE;

-- M:\sacsharm\wfsvc.ind
--
-- Generated for Oracle 8.1 on Tue Nov 19  12:59:13 2002 by Server Generator 6.5.82.2.0

-- Indexes for PKs have been commented out, only ones for FKs are left
-- Because indexes for PKs are automatically created by db
  
--PROMPT Creating Index 'FND_SVC_COMPONENTS_U1'
--CREATE UNIQUE INDEX FND_SVC_COMPONENTS_U1 ON FND_SVC_COMPONENTS
-- (COMPONENT_ID)
--/

PROMPT Creating Index 'FND_SVC_COMPONENTS_U2'
CREATE UNIQUE INDEX FND_SVC_COMPONENTS_U2 ON FND_SVC_COMPONENTS
 (COMPONENT_NAME)
/

--PROMPT Creating Index 'FND_SVC_COMP_REQUESTS_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_REQUESTS_U1 ON FND_SVC_COMP_REQUESTS
-- (COMPONENT_REQUEST_ID)
--/

PROMPT Creating Index 'FND_SVC_COMP_REQUESTS_N1'
CREATE INDEX FND_SVC_COMP_REQUESTS_N1 ON FND_SVC_COMP_REQUESTS
 (COMPONENT_ID)
/

--PROMPT Creating Index 'FND_SVC_COMP_PARAMS_TL_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_PARAMS_TL_U1 ON FND_SVC_COMP_PARAMS_TL
-- (PARAMETER_ID
-- ,LANGUAGE)
--/

--PROMPT Creating Index 'FND_SVC_COMP_TYPES_B_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_TYPES_B_U1 ON FND_SVC_COMP_TYPES_B
-- (COMPONENT_TYPE)
--/

--PROMPT Creating Index 'FND_SVC_COMP_TYPES_TL_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_TYPES_TL_U1 ON FND_SVC_COMP_TYPES_TL
-- (COMPONENT_TYPE
-- ,LANGUAGE)
--/

PROMPT Creating Index 'FND_SVC_COMP_PARAM_VALS_U2'
CREATE UNIQUE INDEX FND_SVC_COMP_PARAM_VALS_U2 ON FND_SVC_COMP_PARAM_VALS
 (COMPONENT_ID
 ,PARAMETER_ID)
/

--PROMPT Creating Index 'FND_SVC_COMP_PARAM_VALS_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_PARAM_VALS_U1 ON FND_SVC_COMP_PARAM_VALS
-- (COMPONENT_PARAMETER_ID)
--/

PROMPT Creating Index 'FND_SVC_COMP_PARAM_VALS_N1'
CREATE INDEX FND_SVC_COMP_PARAM_VALS_N1 ON FND_SVC_COMP_PARAM_VALS
 (COMPONENT_ID)
/

PROMPT Creating Index 'FND_SVC_COMP_REQUESTS_H_N1'
CREATE INDEX FND_SVC_COMP_REQUESTS_H_N1 ON FND_SVC_COMP_REQUESTS_H
 (COMPONENT_ID)
/

--PROMPT Creating Index 'FND_SVC_COMP_REQUESTS_H_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_REQUESTS_H_U1 ON FND_SVC_COMP_REQUESTS_H
-- (REQUEST_HISTORY_ID)
--/

PROMPT Creating Index 'FND_SVC_COMP_PARAMS_B_N1'
CREATE INDEX FND_SVC_COMP_PARAMS_B_N1 ON FND_SVC_COMP_PARAMS_B
 (COMPONENT_TYPE)
/

--PROMPT Creating Index 'FND_SVC_COMP_PARAMS_B_U1'
--CREATE UNIQUE INDEX FND_SVC_COMP_PARAMS_B_U1 ON FND_SVC_COMP_PARAMS_B
-- (PARAMETER_ID)
--/

commit;
exit;