/**Begin C:\PDM_UPGRADE\PDM1\SRC_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDCHANGE' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_DEMANDCHANGE ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RATIOCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_RATIOCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RATIOCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_RATIOCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_TIMECHG' AND KSQL_COL_NAME IN ('FPROJECTFID')) 
 ALTER TABLE T_SRC_TIMECHG ADD (FPROJECTFID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_TIMECHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_TIMECHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_TIMECHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_TIMECHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_WINNUMCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_WINNUMCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_WINNUMCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_WINNUMCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_WINNUMCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_WINNUMCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURLIST' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_PURLIST ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURLIST' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PURLIST ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURLIST' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_PURLIST ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_CATEGORYCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_CATEGORYCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_CATEGORYCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_CATEGORYCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_CATEGORYCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_CATEGORYCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DECISIONCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_DECISIONCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DECISIONCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_DECISIONCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECT_F' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PROJECT_F ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MONEYCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_MONEYCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MONEYCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_MONEYCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_OPENAPPLY' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_OPENAPPLY ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_OPENAPPLY' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_OPENAPPLY ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_OPENAPPLY' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_OPENAPPLY ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_ORDERCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_ORDERCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_ORDERCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_ORDERCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PRICECHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_PRICECHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PRICECHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PRICECHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTEND' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PROJECTEND ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTEND' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_PROJECTEND ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURORGCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_PURORGCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURORGCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PURORGCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PURORGCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_PURORGCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RESDETAILS' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_RESDETAILS ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RESDETAILS' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_RESDETAILS ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RESDETAILS' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_RESDETAILS ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_DEMANDCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_DEMANDCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_DEMANDCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERINVALID' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_SUPPLIERINVALID ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERINVALID' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_SUPPLIERINVALID ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERINVALID' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_SUPPLIERINVALID ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MATERIALCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_MATERIALCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MATERIALCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_MATERIALCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SCHEMECHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_SCHEMECHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SCHEMECHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_SCHEMECHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SCHEMECHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_SCHEMECHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDQTYCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_DEMANDQTYCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDQTYCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_DEMANDQTYCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_DEMANDQTYCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_DEMANDQTYCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MATERIALEND' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_MATERIALEND ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MATERIALEND' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_MATERIALEND ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_MATERIALEND' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_MATERIALEND ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RETENDER' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_RETENDER ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RETENDER' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_RETENDER ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RETENDER' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_RETENDER ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_BIDSCHEMECHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_BIDSCHEMECHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_BIDSCHEMECHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_BIDSCHEMECHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_BIDSCHEMECHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_BIDSCHEMECHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_BIDDOC_CHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_BIDDOC_CHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_BIDDOC_CHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_BIDDOC_CHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTMANCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_PROJECTMANCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTMANCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PROJECTMANCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTMANCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_PROJECTMANCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTINFOCHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_PROJECTINFOCHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTINFOCHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_PROJECTINFOCHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_PROJECTINFOCHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_PROJECTINFOCHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RATIOTYPECHG' AND KSQL_COL_NAME IN ('FPROJECTID')) 
 ALTER TABLE T_SRC_RATIOTYPECHG ADD (FPROJECTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RATIOTYPECHG' AND KSQL_COL_NAME IN ('FBIDCHANGEID')) 
 ALTER TABLE T_SRC_RATIOTYPECHG ADD (FBIDCHANGEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_RATIOTYPECHG' AND KSQL_COL_NAME IN ('FBILLSTATUS')) 
 ALTER TABLE T_SRC_RATIOTYPECHG ADD (FBILLSTATUS CHAR(1) DEFAULT ' ' NOT NULL );

/**End C:\PDM_UPGRADE\PDM1\SRC_table.sql **/
