cpsfzzk-init.sql 17.3 KB
--板块信息
CREATE TABLE `t_auto_hfca_dnxpkp_bkxxxx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `mc`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bm`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xh`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--公司级指标信息
CREATE TABLE `t_auto_hfca_dnxpkp_jmpstx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `ssbk`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `mc`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zbxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qdyxya`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `nf`         datetime(3) DEFAULT NULL,
    `zt`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--三年规划表信息
CREATE TABLE `t_auto_hfca_dnxpkp_snghbx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zb`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zbxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jznd`       datetime(3) DEFAULT NULL,
    `jzndz`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jzytd`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jznda`      datetime(3) DEFAULT NULL,
    `ndmbz`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jzndb`      datetime(3) DEFAULT NULL,
    `ndmbza`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jzndc`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ndmbzb`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sfsd`       tinyint(1) DEFAULT NULL,
    `whlb`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xzyy`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xzsj`       datetime(3) DEFAULT NULL,
    `qtdw`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qtdwfz`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cx`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bz`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qtdwfzr`    varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jzndc1`     datetime(3) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--A3报告
CREATE TABLE `t_auto_hfca_dnxpkp_abgxxx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `fzr`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `mdjxqkh`    varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gzjhzt`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zlkl`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `tjdxwh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xsjdwt`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `nf`         datetime(3) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--A3报告工作计划状态和BIC
CREATE TABLE `t_auto_hfca_dnxpkp_gzjhzt`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `ssabg`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zb`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zbxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cx`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `snd`        datetime(3) DEFAULT NULL,
    `sndz`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bnd`        datetime(3) DEFAULT NULL,
    `bndz`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `hn`         datetime(3) DEFAULT NULL,
    `hndz`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `b`          varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bicbiw`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gszb`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--A3报告推进的行为和步骤
CREATE TABLE `t_auto_hfca_dnxpkp_tjdxwh`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `ssabg`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `tjdxwhbz`   varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zt`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xwbzxh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xh`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--A3报告问题事件
CREATE TABLE `t_auto_hfca_dnxpkp_abgwts`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `xsjdwtsj`   varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zrr`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sj`         datetime(3) DEFAULT NULL,
    `ssabg`      varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--公司级主体计划
CREATE TABLE `t_auto_hfca_dnxpkp_ztjhxx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jhxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qtr`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zrr`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ztjhxdcl`   varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `mb`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `glgsjz`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sstjxw`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gzjhlb`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `nf`         datetime(3) DEFAULT NULL,
    `abg`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sstjdxwhbz` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xwhbzxh`    varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xh`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `glgsjzb`    varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--公司级工作计划
CREATE TABLE `t_auto_hfca_dnxpkp_gzjhxx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `ztjhxh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jhxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gzjhrw`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ksrq`       datetime(3) DEFAULT NULL,
    `jsrq`       datetime(3) DEFAULT NULL,
    `gzjhzr`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `hgzrzg`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sfkq`       tinyint(1) DEFAULT NULL,
    `xmjdzt`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `wcqkms`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `wchfj`      varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xmsfyqsq`   tinyint(1) DEFAULT NULL,
    `yqhsj`      datetime(3) DEFAULT NULL,
    `jlsp`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ssztjh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `xh`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gzjhzrr`    varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `hgzrzgjl`   varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--公司级记分卡
CREATE TABLE `t_auto_hfca_dnxpkp_jfxxxx`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `lxcj`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `syndsjz`    varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qy`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bk`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zb`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zbxh`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cx`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jznd`       datetime(3) DEFAULT NULL,
    `mbytdm`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `syndsj`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sfpp`       tinyint(1) DEFAULT NULL,
    `qtdw`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qtzrr`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bndsjz`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ymbz`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjz`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdb`      tinyint(1) DEFAULT NULL,
    `ymbza`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjza`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdba`     tinyint(1) DEFAULT NULL,
    `ymbzb`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzb`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbb`     tinyint(1) DEFAULT NULL,
    `ymbzc`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzc`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbc`     tinyint(1) DEFAULT NULL,
    `ymbzd`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzd`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbd`     tinyint(1) DEFAULT NULL,
    `ymbze`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjze`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbe`     tinyint(1) DEFAULT NULL,
    `ymbzf`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzf`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbf`     tinyint(1) DEFAULT NULL,
    `ymbzg`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzg`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbg`     tinyint(1) DEFAULT NULL,
    `ymbzh`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzh`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbh`     tinyint(1) DEFAULT NULL,
    `ymbzi`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzi`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbi`     tinyint(1) DEFAULT NULL,
    `ymbzj`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzj`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbj`     tinyint(1) DEFAULT NULL,
    `ymbzk`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysjzk`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ysfdbk`     tinyint(1) DEFAULT NULL,
    `mbytdmbz`   varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zt`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `hgry`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `glgskpi`    varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--公司级记分卡回顾记录
CREATE TABLE `t_auto_hfca_dnxpkp_ujnpkh`
(
    `id`                  varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`           varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at`          datetime(3) NOT NULL COMMENT '创建时间',
    `created_by`          varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at`          datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by`          varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `gsjjfkxx`            varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `year_str`            varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxx`                varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gsjzbxx`             varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `mb_val`              varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `month_em`            varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `month_real_val`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `month_target_val`    varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `month_finish_flag`   tinyint(1) DEFAULT NULL,
    `spjlxx`              varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `process_instance_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `approval_status`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;