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`;