-- 报表分项增加查询设置querysetting字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_REPORTSHARE' AND KSQL_COL_NAME ='fQUERYSETTING')
ALTER TABLE T_EB_REPORTSHARE ADD (fQUERYSETTING NCLOB);

-- 预算用户参数增加templatemodelData字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_USERPARAMETER' AND KSQL_COL_NAME ='FTEMPLATEMODELDATA')
ALTER TABLE T_EB_USERPARAMETER ADD (FTEMPLATEMODELDATA NCLOB);

-- 报表查询实体增加查询设置字段（用于记录维度隐藏显示、元素类型、成员展示方式、隐藏显示空数据行）
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_REPORTQUERY' AND KSQL_COL_NAME ='fQUERYSETTING')
ALTER TABLE T_EB_REPORTQUERY ADD (fQUERYSETTING NCLOB);


 