/**Begin D:\\PDM_UPGRADE\PDM_UPGRADE\PDM1\HIES_constraint.sql **/
 EXEC P_ALTERPK 'PK_HIES_SWITCHREGISTRY', 'T_HIES_SWITCHREGISTRY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HIES_SWITCHREGISTRY') CREATE INDEX IDX_HIES_SWITCHREGISTRY ON T_HIES_SWITCHREGISTRY ( FNUMBER );


 EXEC P_ALTERPK 'PK_HIES_SWITCHREGISTRY_L', 'T_HIES_SWITCHREGISTRY_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HIES_SWITCHREGISTRY_L') CREATE INDEX IDX_HIES_SWITCHREGISTRY_L ON T_HIES_SWITCHREGISTRY_L ( FID ,FLOCALEID );

EXEC P_ALTERPK 'PK_HIES_SCHEMESWITCHSERREG', 'T_HIES_SCHEMESWITCHSERREG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HIES_SCHEMESWITCHSERREG') CREATE INDEX IDX_HIES_SCHEMESWITCHSERREG ON T_HIES_SCHEMESWITCHSERREG ( FMSERVICEAPPID );


/**End D:\\PDM_UPGRADE\PDM_UPGRADE\PDM1\HIES_constraint.sql **/
