/**Begin D:\PDM_UPGRADE\PDM1\OM_constraint.sql **/
EXEC P_ALTERPK 'PK_IM_SIEVESCDITSTENTRY', 'T_IM_SIEVESCDITSTENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCDITSTEN_FID') CREATE INDEX IDX_IM_SIEVESCDITSTEN_FID ON T_IM_SIEVESCDITSTENTRY ( FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVECDITSTEN_FIELDKEY') CREATE INDEX IDX_IM_SIEVECDITSTEN_FIELDKEY ON T_IM_SIEVESCDITSTENTRY ( FSIEVEFIELDKEY );


 EXEC P_ALTERPK 'PK_IM_SIEVESCHEMEST', 'T_IM_SIEVESCHEMEST', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCHEST_FCREATOR') CREATE INDEX IDX_IM_SIEVESCHEST_FCREATOR ON T_IM_SIEVESCHEMEST ( FCREATORID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCHEST_FMDFYTIME') CREATE INDEX IDX_IM_SIEVESCHEST_FMDFYTIME ON T_IM_SIEVESCHEMEST ( FMODIFYTIME );


 EXEC P_ALTERPK 'PK_IM_SIEVESCHEMEST_L', 'T_IM_SIEVESCHEMEST_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCHEMEST_L_FID') CREATE INDEX IDX_IM_SIEVESCHEMEST_L_FID ON T_IM_SIEVESCHEMEST_L ( FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCHEST_L_FLOCALE') CREATE INDEX IDX_IM_SIEVESCHEST_L_FLOCALE ON T_IM_SIEVESCHEMEST_L ( FLOCALEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_SIEVESCHEMEST_L_FNAME') CREATE INDEX IDX_IM_SIEVESCHEMEST_L_FNAME ON T_IM_SIEVESCHEMEST_L ( FNAME );

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