dev/2020/2020-020(OK)/2020-020-xpp-001.sql

USE DCP;
DROP TABLE IF EXISTS `cms_information_click`;
CREATE TABLE `cms_information_click`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'id',
  `information_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '资讯id',
  `information_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '资讯类型',
  `hits` int(11) DEFAULT NULL COMMENT '点击数',
  `hit_time` datetime(0) DEFAULT NULL COMMENT '点击时间',
  `search_num` int(11) DEFAULT NULL COMMENT '搜索次数',
  `search_time` datetime(0) DEFAULT NULL COMMENT '搜索时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_date` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
  `update_date` datetime(0) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_cms_info_view_misc`(`create_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '资讯_资讯信息点击表' ROW_FORMAT = Dynamic;

ALTER TABLE `cms_information_click`
ADD COLUMN `language` varchar(255) COMMENT '语言' AFTER `search_time`;