/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_EB_MODIFYNOTE', 'T_EB_MODIFYNOTE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_EB_APPROVELNOTE', 'T_EB_APPROVELNOTE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AUDIT_NOTE_MODEL') CREATE INDEX IDX_AUDIT_NOTE_MODEL ON T_EB_APPROVELNOTE ( FMODELID );

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



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