 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 INT DEFAULT 0 NOT NULL);
 
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 INT 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_MSPLAN_DROPCONFIGURE' AND KSQL_COL_NAME ='FBITINDEX') 
 ALTER TABLE T_MSPLAN_DROPCONFIGURE ADD (FBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_DROPCONFIGURE' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
 ALTER TABLE T_MSPLAN_DROPCONFIGURE ADD (FSOURCEBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MSPLAN_DROPCONFIGURE' AND KSQL_COL_NAME ='FSOURCEDATAID') 
 ALTER TABLE T_MSPLAN_DROPCONFIGURE 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 ='FBITINDEX') 
 ALTER TABLE T_MRP_RSREGISTER ADD (FBITINDEX INT 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 INT 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_ALGOREGISTER' AND KSQL_COL_NAME ='FBITINDEX') 
 ALTER TABLE T_MRP_ALGOREGISTER ADD (FBITINDEX INT 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 INT 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_BUSINESSPLAN' AND KSQL_COL_NAME ='FBITINDEX') 
 ALTER TABLE T_MRP_BUSINESSPLAN ADD (FBITINDEX INT 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 INT 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_CALPLANCONFIG' AND KSQL_COL_NAME ='FBITINDEX') 
 ALTER TABLE T_MRP_CALPLANCONFIG ADD (FBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CALPLANCONFIG' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
 ALTER TABLE T_MRP_CALPLANCONFIG ADD (FSOURCEBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CALPLANCONFIG' AND KSQL_COL_NAME ='FSOURCEDATAID') 
 ALTER TABLE T_MRP_CALPLANCONFIG ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);