IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTS_ADDRESS' AND KSQL_COL_NAME ='FENABLE') ALTER TABLE T_CTS_ADDRESS ADD (FENABLE CHAR(1) DEFAULT '1' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTS_ADDRESS' AND KSQL_COL_NAME ='FSTATUS') ALTER TABLE T_CTS_ADDRESS ADD (FSTATUS VARCHAR(10) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTS_ADDRESS' AND KSQL_COL_NAME ='FMASTERID') ALTER TABLE T_CTS_ADDRESS ADD (FMASTERID BIGINT DEFAULT 0 NOT NULL);
