IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPES' AND KSQL_COL_NAME IN ('FORINUMBER'))
 ALTER TABLE T_HBSS_CONTRACTTYPES ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPES' AND KSQL_COL_NAME IN ('FORINAME'))
 ALTER TABLE T_HBSS_CONTRACTTYPES ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPES' AND KSQL_COL_NAME IN ('FORISTATUS'))
 ALTER TABLE T_HBSS_CONTRACTTYPES ADD (FORISTATUS VARCHAR(2) DEFAULT '0' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPES_L' AND KSQL_COL_NAME IN ('FORINAME'))
 ALTER TABLE T_HBSS_CONTRACTTYPES_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );


 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPECAT' AND KSQL_COL_NAME IN ('FISSYSPRESET'))
 ALTER TABLE T_HBSS_CONTRACTTYPECAT ADD (FISSYSPRESET CHAR(1) DEFAULT '0' NOT NULL );
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPECAT' AND KSQL_COL_NAME IN ('FORINUMBER'))
 ALTER TABLE T_HBSS_CONTRACTTYPECAT ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPECAT' AND KSQL_COL_NAME IN ('FORINAME'))
 ALTER TABLE T_HBSS_CONTRACTTYPECAT ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPECAT' AND KSQL_COL_NAME IN ('FORISTATUS'))
 ALTER TABLE T_HBSS_CONTRACTTYPECAT ADD (FORISTATUS VARCHAR(2) DEFAULT '0' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONTRACTTYPECAT_L' AND KSQL_COL_NAME IN ('FORINAME'))
 ALTER TABLE T_HBSS_CONTRACTTYPECAT_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );