/**BEGIN  **/
/**组织  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFENT' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFENT ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**科目  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFACCOUNT' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFACCOUNT ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**数据类型  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDATETYPE' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFDATETYPE ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**往来组织  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFICENTITY' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFICENTITY ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**度量  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFMETRIC' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFMETRIC ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**版本  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFVERSION' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFVERSION ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**自定义维度  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFDEFINED' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFDEFINED ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/** 情景 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFSCENE' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFSCENE ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**预算期间  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFBPERIOD' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFBPERIOD ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**变动类型  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCHANGETYPE' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFCHANGETYPE ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**财年  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFFY' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFFY ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**期间  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPERIOD' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFPERIOD ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**币别  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFCURRENCY' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFCURRENCY ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**过程  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFPROCESS' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFPROCESS ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**线索  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_STRUCTOFAUDITTRIAL' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_STRUCTOFAUDITTRIAL ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);

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

/**视图  **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_VIEWMEMBER' AND KSQL_COL_NAME IN ('FDISABLE'))
ALTER TABLE T_EB_VIEWMEMBER ADD (FDISABLE CHAR(1)  DEFAULT '0' NOT NULL);
/**END **/