IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_planebill' AND KSQL_COL_NAME ='kddownloadlink')
ALTER TABLE t_er_planebill ADD (kddownloadlink VARCHAR(2000) DEFAULT ' ' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_er_planecheckingbill' AND KSQL_COL_NAME ='kddownloadlink')
ALTER TABLE T_er_planecheckingbill ADD (kddownloadlink VARCHAR(2000) DEFAULT ' ' NOT NULL);