/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FQYXTZSYMZQY') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FQYXTZSYMZQY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FCDRGXHLSDMZ') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FCDRGXHLSDMZ DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FYXZLXSLMZ') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FYXZLXSLMZ DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FFHXXWLYHJN') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FFHXXWLYHJN DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FSFYHJNSDS') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FSFYHJNSDS DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FJZMZLX') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FJZMZLX VARCHAR(30) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FJZFD') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FJZFD DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FMZZZDFQYDFFXBF') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FMZZZDFQYDFFXBF DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_HSQJSBB_B_2018' AND KSQL_COL_NAME ='FBQSJYBSDSE') 
 ALTER TABLE T_TCCIT_HSQJSBB_B_2018 ADD (FBQSJYBSDSE DECIMAL(23,10) DEFAULT 0 NOT NULL );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_table.sql **/
