/**Begin D:\k3Cloud\PDM_UPGRADE\PDM1\MDS_constraint.sql **/
 EXEC P_ALTERPK 'PK_MDS_ADJPLANDATA', 'T_MDS_ADJPLANDATA', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MDS_ADJPLANDATA_BI') CREATE INDEX IDX_MDS_ADJPLANDATA_BI ON T_MDS_ADJPLANDATA ( FBILLNO );


 EXEC P_ALTERPK 'PK_MDS_ADJDATEENTRY', 'T_MDS_ADJDATEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_MDS_ADJENTRY', 'T_MDS_ADJENTRY', 'FENTRYID', '1';

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



/**End D:\k3Cloud\PDM_UPGRADE\PDM1\MDS_constraint.sql **/
