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

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

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

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

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

