IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_EQNEEDPLANENTRY' AND KSQL_COL_NAME ='FUSELEVEL') 
 ALTER TABLE T_MSPLAN_EQNEEDPLANENTRY ADD (FUSELEVEL VARCHAR(5) DEFAULT 'A' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_EQTNEEDPLANENTRY' AND KSQL_COL_NAME ='FUSELEVEL') 
 ALTER TABLE T_MSPLAN_EQTNEEDPLANENTRY ADD (FUSELEVEL VARCHAR(5) DEFAULT 'A' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_EQXNEEDPLANENTRY' AND KSQL_COL_NAME ='FUSELEVEL') 
 ALTER TABLE T_MSPLAN_EQXNEEDPLANENTRY ADD (FUSELEVEL VARCHAR(5) DEFAULT 'A' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_ORNEEDPLANENTRY' AND KSQL_COL_NAME ='FUSELEVEL') 
 ALTER TABLE T_MSPLAN_ORNEEDPLANENTRY ADD (FUSELEVEL VARCHAR(5) DEFAULT 'A' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_TLNEEDPLANENTRY' AND KSQL_COL_NAME ='FUSELEVEL') 
 ALTER TABLE T_MSPLAN_TLNEEDPLANENTRY ADD (FUSELEVEL VARCHAR(5) DEFAULT 'A' NOT NULL ); 

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_TLNEEDPLANENTRY' AND KSQL_COL_NAME ='FCHECKGBILL') 
 ALTER TABLE T_MSPLAN_TLNEEDPLANENTRY ADD (FCHECKGBILL NVARCHAR(200) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_TLNEEDPLANENTRY' AND KSQL_COL_NAME ='FCHECKGBILLID') 
 ALTER TABLE T_MSPLAN_TLNEEDPLANENTRY ADD (FCHECKGBILLID  BIGINT DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_TLNEEDPLANENTRY' AND KSQL_COL_NAME ='FTOOLSUB') 
 ALTER TABLE T_MSPLAN_TLNEEDPLANENTRY ADD (FTOOLSUB  BIGINT DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_TLNEEDPLANENTRY' AND KSQL_COL_NAME ='FRESOURCETD') 
 ALTER TABLE T_MSPLAN_TLNEEDPLANENTRY ADD (FRESOURCETD  BIGINT DEFAULT 0 NOT NULL );

  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RES_SCHEME' AND KSQL_COL_NAME ='FCHKGPEXEC') 
 ALTER TABLE T_MRP_RES_SCHEME ADD (FCHKGPEXEC VARCHAR(5) DEFAULT '1' NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RESASSESSBILLENTRY' AND KSQL_COL_NAME ='FSUBTOOL') 
 ALTER TABLE T_MRP_RESASSESSBILLENTRY ADD (FSUBTOOL  BIGINT DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RESASSESSBILLENTRY' AND KSQL_COL_NAME ='FRESULT') 
 ALTER TABLE T_MRP_RESASSESSBILLENTRY ADD (FRESULT VARCHAR(5) DEFAULT '1' NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RESASSESSBILLENTRY' AND KSQL_COL_NAME ='FREQBILLID') 
 ALTER TABLE T_MRP_RESASSESSBILLENTRY ADD (FREQBILLID  BIGINT DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RESASSESSBILLENTRY' AND KSQL_COL_NAME ='FREQENTRYID') 
 ALTER TABLE T_MRP_RESASSESSBILLENTRY ADD (FREQENTRYID  BIGINT DEFAULT 0 NOT NULL );