/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_constraint.sql **/


 EXEC P_ALTERPK 'PK_T_EB_REPORTATTACHMENT', 'T_EB_REPORTATTACHMENT', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_REPORTATTACHMENT_P2') CREATE INDEX IDX_EB_REPORTATTACHMENT_P2 ON T_EB_REPORTATTACHMENT ( FTASKPROID );


 EXEC P_ALTERPK 'PK_T_EB_DIMPROPERTYSETTING_L', 'T_EB_DIMPROPERTYSETTING_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_EB_DIM_MEMBERMAP_L', 'T_EB_DIM_MEMBERMAP_L', 'FPKID', '1';

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



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_constraint.sql **/
