-- 租赁合同增加字段：累计租金、本年累计租金、累计利息、本年累计利息

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FACCUMRENT')
ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FACCUMRENT DECIMAL(19,4) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FADDUPYEARRENT')
ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FADDUPYEARRENT DECIMAL(19,4) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FACCUMINTEREST')
ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FACCUMINTEREST DECIMAL(19,4) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_CONTRACT_NEW' AND KSQL_COL_NAME ='FADDUPYEARINTEREST')
ALTER TABLE T_FA_LEASE_CONTRACT_NEW ADD (FADDUPYEARINTEREST DECIMAL(19,4) DEFAULT 0 NOT NULL );