
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_COUNTRY')
ALTER TABLE T_SEC_USER_H ADD (FNS_COUNTRY BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_NAMESTYLE')
ALTER TABLE T_SEC_USER_H ADD (FNS_NAMESTYLE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_FIRSTNAME')
ALTER TABLE T_SEC_USER_H ADD (FNS_FIRSTNAME VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_MIDDLENAME')
ALTER TABLE T_SEC_USER_H ADD (FNS_MIDDLENAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_LASTNAME')
ALTER TABLE T_SEC_USER_H ADD (FNS_LASTNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_TITLE')
ALTER TABLE T_SEC_USER_H ADD (FNS_TITLE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_ABBR')
ALTER TABLE T_SEC_USER_H ADD (FNS_ABBR VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_NICKNAME')
ALTER TABLE T_SEC_USER_H ADD (FNS_NICKNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_POSTTITLE')
ALTER TABLE T_SEC_USER_H ADD (FNS_POSTTITLE VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_CUSTOMFIELD1')
ALTER TABLE T_SEC_USER_H ADD (FNS_CUSTOMFIELD1 VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_CUSTOMFIELD2')
ALTER TABLE T_SEC_USER_H ADD (FNS_CUSTOMFIELD2 VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_CUSTOMFIELD3')
ALTER TABLE T_SEC_USER_H ADD (FNS_CUSTOMFIELD3 VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SEC_USER_H' AND KSQL_COL_NAME ='FNS_CUSTOMFIELD4')
ALTER TABLE T_SEC_USER_H ADD (FNS_CUSTOMFIELD4 VARCHAR(50) DEFAULT ' ' NOT NULL );