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