
 EXEC P_ALTERPK 'PK_MSPLAN_CONTAINERCHECK', 'T_MSPLAN_CONTAINERCHECK', 'FID', '1';
 EXEC P_ALTERPK 'PK_MSPLAN_CONTAINERCHECK_L', 'T_MSPLAN_CONTAINERCHECK_L', 'FPKID', '1';
  EXEC P_ALTERPK 'PK_MSPLAN_CONTAINERCHECK_E', 'T_MSPLAN_CONTAINERCHECK_E', 'FENTRYID', '1';
  
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MSPLAN_CONTAINERCHECK_NUM') CREATE INDEX IDX_MSPLAN_CONTAINERCHECK_NUM ON T_MSPLAN_CONTAINERCHECK ( FNUMBER );
   
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_MSPLAN_CONTAINERCHECK_L_0') CREATE INDEX IDX_MSPLAN_CONTAINERCHECK_L_0 ON T_MSPLAN_CONTAINERCHECK_L ( FID, FLOCALEID );

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

