IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTRULE' AND KSQL_COL_NAME ='FSHAREAMOUNT')
ALTER TABLE T_ER_APPLYPROJECTRULE ADD (FSHAREAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTRULE' AND KSQL_COL_NAME ='FSHAREAPPAMOUNT')
ALTER TABLE T_ER_APPLYPROJECTRULE ADD (FSHAREAPPAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATERULE' AND KSQL_COL_NAME ='FSHAREAMOUNT')
ALTER TABLE T_ER_COSTESTIMATERULE ADD (FSHAREAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATERULE' AND KSQL_COL_NAME ='FSHAREAPPAMOUNT')
ALTER TABLE T_ER_COSTESTIMATERULE ADD (FSHAREAPPAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );
