IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_RULE_INSTANCE' AND KSQL_COL_NAME ='FTRACEID')
ALTER TABLE T_EB_RULE_INSTANCE ADD (FTRACEID  VARCHAR(50) DEFAULT ' ' NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_RULE_INSTANCE_DETAIL' AND KSQL_COL_NAME ='FSEQUENCE')
ALTER TABLE T_EB_RULE_INSTANCE_DETAIL ADD (FSEQUENCE  BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_RULE_INSTANCE_DETAIL' AND KSQL_COL_NAME ='FAFFECTROW')
ALTER TABLE T_EB_RULE_INSTANCE_DETAIL ADD (FAFFECTROW  BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_RULE_INSTANCE_DETAIL' AND KSQL_COL_NAME ='FSUM')
ALTER TABLE T_EB_RULE_INSTANCE_DETAIL ADD (FSUM  BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_RULE_INSTANCE_DETAIL' AND KSQL_COL_NAME ='FISSYN')
ALTER TABLE T_EB_RULE_INSTANCE_DETAIL ADD (FISSYN  VARCHAR(50) DEFAULT ' ' NOT NULL );