/**Begin D:\PDM_UPGRADE\PDM1\HBSS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SAFEURI' AND KSQL_COL_NAME ='FARGS') 
 ALTER TABLE T_HBSS_SAFEURI ADD (FARGS NCLOB );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FBANNERGROUPAPP') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FBANNERGROUPAPP VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FAPPBANNERPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FAPPBANNERPIC VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FBACKGROUNDGROUPAPP') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FBACKGROUNDGROUPAPP VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FAPPBACKGROUNDPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FAPPBACKGROUNDPIC VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FREDIRECTAPPFORMID') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FREDIRECTAPPFORMID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FSYSBACKGROUNDPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FSYSBACKGROUNDPIC VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FSYSBANNERPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FSYSBANNERPIC VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FSYSAPPBANNERPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FSYSAPPBANNERPIC VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FSYSAPPBACKGROUNDPIC') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FSYSAPPBACKGROUNDPIC VARCHAR(255) DEFAULT ' '  NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LOGINCONFIG' AND KSQL_COL_NAME ='FLOGINTYPE') 
 ALTER TABLE T_HBSS_LOGINCONFIG ADD (FLOGINTYPE VARCHAR(50) DEFAULT '1' NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\HBSS_table.sql **/
