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

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


 EXEC P_ALTERPK 'PK_MSPLAN_TLXNEEDPLANENTRY', 'T_MSPLAN_TLXNEEDPLANENTRY', 'FENTRYID', '1';

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



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