IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
ALTER TABLE T_MRP_BFTRANSFER ADD (FSOURCEBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FBITINDEX') 
ALTER TABLE T_MRP_BFTRANSFER ADD (FBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FSOURCEDATAID') 
ALTER TABLE T_MRP_BFTRANSFER ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSREGISTER' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
ALTER TABLE T_MRP_RSREGISTER ADD (FSOURCEBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSREGISTER' AND KSQL_COL_NAME ='FBITINDEX') 
ALTER TABLE T_MRP_RSREGISTER ADD (FBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSREGISTER' AND KSQL_COL_NAME ='FSOURCEDATAID') 
ALTER TABLE T_MRP_RSREGISTER ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BUSINESSPLAN' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
ALTER TABLE T_MRP_BUSINESSPLAN ADD (FSOURCEBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BUSINESSPLAN' AND KSQL_COL_NAME ='FBITINDEX') 
ALTER TABLE T_MRP_BUSINESSPLAN ADD (FBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BUSINESSPLAN' AND KSQL_COL_NAME ='FSOURCEDATAID') 
ALTER TABLE T_MRP_BUSINESSPLAN ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ALGOREGISTER' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
ALTER TABLE T_MRP_ALGOREGISTER ADD (FSOURCEBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ALGOREGISTER' AND KSQL_COL_NAME ='FBITINDEX') 
ALTER TABLE T_MRP_ALGOREGISTER ADD (FBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ALGOREGISTER' AND KSQL_COL_NAME ='FSOURCEDATAID') 
ALTER TABLE T_MRP_ALGOREGISTER ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSDATACONFIG' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
ALTER TABLE T_MRP_RSDATACONFIG ADD (FSOURCEBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSDATACONFIG' AND KSQL_COL_NAME ='FBITINDEX') 
ALTER TABLE T_MRP_RSDATACONFIG ADD (FBITINDEX BIGINT DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSDATACONFIG' AND KSQL_COL_NAME ='FSOURCEDATAID') 
ALTER TABLE T_MRP_RSDATACONFIG ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);
