/**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_QYSDS_A107011' AND KSQL_COL_NAME ='FTZXZBASEDATA') 
 ALTER TABLE T_TCCIT_QYSDS_A107011 ADD (FTZXZBASEDATA BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FSTATUS') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FSTATUS VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FFZJGYHBASEDATA') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FFZJGYHBASEDATA BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FXSMZDFYHFD') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FXSMZDFYHFD DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FXSMZDFYHJE') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FXSMZDFYHJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FQNLJYXSMZDFYHJE') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FQNLJYXSMZDFYHJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FYMZDFYHTZFPJE') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FYMZDFYHTZFPJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FQNLJFPJE') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FQNLJFPJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A109010_FZ' AND KSQL_COL_NAME ='FSJFPSDSE') 
 ALTER TABLE T_TCCIT_QYSDS_A109010_FZ ADD (FSJFPSDSE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A000000_GD' AND KSQL_COL_NAME ='FGJBASEDATA') 
 ALTER TABLE T_TCCIT_QYSDS_A000000_GD ADD (FGJBASEDATA BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FZYJSRSJYBTSDSE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FZYJSRSJYBTSDSE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FDFJSRYBTSDSE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FDFJSRYBTSDSE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FYHFD') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FYHFD DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FBNYJMJE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FBNYJMJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FBNLJYJMJE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FBNLJYJMJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FYYHCSDDFJSRYBTJE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FYYHCSDDFJSRYBTJE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FZJJJFZJJQNJMZE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FZJJJFZJJQNJMZE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FDFJSRSJYBTSDE') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FDFJSRSJYBTSDE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FBNSJYBTSDSENEW') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FBNSJYBTSDSENEW DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A100000' AND KSQL_COL_NAME ='FYHFS') 
 ALTER TABLE T_TCCIT_QYSDS_A100000 ADD (FYHFS VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_TCCIT_QYSDS_A000000' AND KSQL_COL_NAME ='FSSGMJJHYBASEDATA') 
 ALTER TABLE T_TCCIT_QYSDS_A000000 ADD (FSSGMJJHYBASEDATA BIGINT DEFAULT 0 NOT NULL );

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