tnb/zzz/schema/tnb_content_tdb.sql

-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: 192.168.0.210    Database: tnb_content_tdb
-- ------------------------------------------------------
-- Server version	5.7.36

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `audio_file`
--

DROP TABLE IF EXISTS `audio_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audio_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `audio_file_id` varchar(255) NOT NULL,
  `object_id` varchar(255) NOT NULL,
  `duration` int(11) NOT NULL,
  `codec` varchar(255) NOT NULL,
  `bit_rate` bigint(20) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=537 DEFAULT CHARSET=utf8mb4 COMMENT='音频文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `audio_post`
--

DROP TABLE IF EXISTS `audio_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audio_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `audio_id` varchar(255) NOT NULL,
  `audio_file_id` varchar(255) NOT NULL,
  `audio_url` varchar(255) NOT NULL,
  `codec` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `duration` int(11) NOT NULL,
  `scope` int(11) NOT NULL,
  `publish_at` datetime NOT NULL,
  `publish_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`audio_id`) USING BTREE,
  KEY `file_id` (`audio_file_id`) USING BTREE,
  KEY `user_id` (`publish_by`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=465 DEFAULT CHARSET=utf8mb4 COMMENT='音频稿件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_chat_dialog`
--

DROP TABLE IF EXISTS `chat_chat_dialog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_chat_dialog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `chat_id` bigint(20) NOT NULL,
  `chat_type` int(10) NOT NULL,
  `user_id` bigint(20) NOT NULL COMMENT '消息发送者',
  `receiver_id` bigint(20) NOT NULL COMMENT '消息接收者',
  `disturb` bit(1) NOT NULL COMMENT '对话框是否免打扰',
  `top` bit(1) NOT NULL COMMENT '对话框是否置顶',
  `display` bit(1) NOT NULL COMMENT '对话框是否显示',
  `robot` bit(1) NOT NULL,
  `unread_num` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='聊天窗口';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_chat_record`
--

DROP TABLE IF EXISTS `chat_chat_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_chat_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `record_id` bigint(20) DEFAULT NULL,
  `chat_id` bigint(20) NOT NULL,
  `chat_type` int(11) NOT NULL,
  `sender_id` bigint(20) NOT NULL,
  `receiver_id` bigint(20) NOT NULL,
  `msg_type` int(10) NOT NULL,
  `read` bit(1) NOT NULL,
  `revoke` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sender_id` (`sender_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_code_block_message`
--

DROP TABLE IF EXISTS `chat_code_block_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_code_block_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `record_id` bigint(20) NOT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_file_message`
--

DROP TABLE IF EXISTS `chat_file_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_file_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `file_type` int(11) DEFAULT NULL,
  `record_id` bigint(20) NOT NULL,
  `upload_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sender_id` (`upload_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_hongbao`
--

DROP TABLE IF EXISTS `chat_hongbao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_hongbao` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `hongbao_id` bigint(20) NOT NULL,
  `reciever_type` int(11) NOT NULL,
  `reciever_id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `num` int(11) NOT NULL,
  `remain` int(11) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `create_by` bigint(20) NOT NULL,
  `create_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`hongbao_id`) USING BTREE,
  KEY `user_id` (`create_by`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='红包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_hongbao_receiver`
--

DROP TABLE IF EXISTS `chat_hongbao_receiver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_hongbao_receiver` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `hongbao_id` bigint(20) NOT NULL,
  `reciever_id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `remark` varchar(255) NOT NULL,
  `create_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`hongbao_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='红包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_setting`
--

DROP TABLE IF EXISTS `chat_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `keyboard_event_notify` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notify_cue_tone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_bag_img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_color` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_p0dbxwvogoamsrntdo066xlhj` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `chat_text_message`
--

DROP TABLE IF EXISTS `chat_text_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_text_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `record_id` bigint(20) NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `file_job_detail`
--

DROP TABLE IF EXISTS `file_job_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_job_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `job_id` bigint(20) NOT NULL,
  `job_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `start_at` datetime(6) NOT NULL,
  `end_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `oss_type` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务详情';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `file_store_config`
--

DROP TABLE IF EXISTS `file_store_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_store_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `oss_type` int(11) NOT NULL,
  `endpoint` varchar(255) NOT NULL,
  `access_key_id` varchar(255) NOT NULL,
  `access_key_secret` varchar(255) NOT NULL,
  `region` varchar(255) DEFAULT NULL,
  `bucket_name` varchar(255) DEFAULT NULL,
  `role_arn` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `oss_type` (`oss_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='OSS 存储节点配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_area`
--

DROP TABLE IF EXISTS `geo_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_area` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `deep` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `ext_path` varchar(255) NOT NULL,
  `geo` geometry DEFAULT NULL,
  `polygon` geometry NOT NULL,
  `polygon_envelope` geometry DEFAULT NULL,
  PRIMARY KEY (`id`),
  SPATIAL KEY `polygon` (`polygon`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_bus_station`
--

DROP TABLE IF EXISTS `geo_bus_station`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_bus_station` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `lng` bigint(20) NOT NULL,
  `lat` bigint(20) NOT NULL,
  `station_name` varchar(255) NOT NULL,
  `pm` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `line_name` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19165 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_camera_photo`
--

DROP TABLE IF EXISTS `geo_camera_photo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_camera_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) NOT NULL,
  `object_id` varchar(255) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `photo_url` varchar(255) NOT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `software` varchar(255) DEFAULT NULL,
  `shot_at` datetime(6) DEFAULT NULL,
  `geo` geometry NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `photo_url` (`photo_url`)
) ENGINE=InnoDB AUTO_INCREMENT=44909 DEFAULT CHARSET=utf8mb4 COMMENT=' 相册中照片的位置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_earth`
--

DROP TABLE IF EXISTS `geo_earth`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_earth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `template` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='GoogleEarth kml 模板';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_item`
--

DROP TABLE IF EXISTS `geo_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `total` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_job_location`
--

DROP TABLE IF EXISTS `geo_job_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_job_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `company_name` varchar(255) NOT NULL,
  `issue_date` datetime(6) NOT NULL,
  `job_href` varchar(255) NOT NULL,
  `job_describe` text NOT NULL,
  `salary_min` int(11) NOT NULL,
  `salary_max` int(11) NOT NULL,
  `salary_str` varchar(255) NOT NULL,
  `geo` geometry NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=utf8mb4 COMMENT='工作位置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_mall_reply`
--

DROP TABLE IF EXISTS `geo_mall_reply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_mall_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `item_type` int(11) NOT NULL COMMENT '商品类型',
  `item_id` varchar(255) NOT NULL,
  `reply_id` varchar(255) NOT NULL,
  `reply_content` text NOT NULL,
  `append_content` text,
  `extra` text,
  `username` varchar(255) NOT NULL,
  `avatar_url` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reply_id` (`reply_id`),
  KEY `item_id` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COMMENT='天猫商品评论';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_mall_reply_photo`
--

DROP TABLE IF EXISTS `geo_mall_reply_photo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_mall_reply_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reply_id` varchar(255) NOT NULL,
  `upload_id` varchar(255) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `photo_url` varchar(255) NOT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `software` varchar(255) DEFAULT NULL,
  `shot_at` datetime(6) DEFAULT NULL,
  `geo` geometry NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `photo_url` (`photo_url`),
  KEY `reply_id` (`reply_id`)
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COMMENT='天猫商品评论中的照片';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_point`
--

DROP TABLE IF EXISTS `geo_point`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `geo` geometry NOT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_polygon`
--

DROP TABLE IF EXISTS `geo_polygon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_polygon` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `deep` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ext_name` varchar(255) DEFAULT NULL,
  `geo` geometry DEFAULT NULL,
  `polygon` polygon DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `geo_scope`
--

DROP TABLE IF EXISTS `geo_scope`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_scope` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `lng_east` decimal(10,6) NOT NULL,
  `lng_west` decimal(10,6) NOT NULL,
  `lat_north` decimal(10,6) NOT NULL,
  `lat_south` decimal(10,6) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='省市县地理坐标';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `image_file`
--

DROP TABLE IF EXISTS `image_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `image_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `album_id` bigint(20) NOT NULL,
  `channel_code` int(11) DEFAULT NULL,
  `image_file_id` varchar(255) NOT NULL COMMENT '原始对象的 objectId',
  `object_id` varchar(255) NOT NULL,
  `format` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `horizontal` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object_id` (`object_id`) USING BTREE,
  KEY `image_file_id` (`image_file_id`),
  KEY `url` (`url`),
  KEY `album_id` (`album_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9505274 DEFAULT CHARSET=utf8mb4 COMMENT='图片文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `image_post`
--

DROP TABLE IF EXISTS `image_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `image_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `album_id` bigint(20) NOT NULL,
  `album_name` varchar(255) NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `cover_url` varchar(255) NOT NULL,
  `total` int(11) NOT NULL,
  `scope` int(11) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`album_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17923 DEFAULT CHARSET=utf8mb4 COMMENT='相册';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_delivery`
--

DROP TABLE IF EXISTS `mall_delivery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_delivery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `delivery_id` bigint(20) NOT NULL,
  `address` varchar(2048) NOT NULL,
  `owner` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收货地址';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_logistics`
--

DROP TABLE IF EXISTS `mall_logistics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_logistics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `order_id` bigint(20) NOT NULL,
  `tpl` varchar(2048) NOT NULL COMMENT 'third party logistics',
  `logistics_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单物流';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_logistics_progress`
--

DROP TABLE IF EXISTS `mall_logistics_progress`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_logistics_progress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `logistics_id` bigint(20) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `current` varchar(255) NOT NULL,
  `create_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `location` geometry DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单物流进度';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_order`
--

DROP TABLE IF EXISTS `mall_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `order_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `delivery_id` bigint(20) NOT NULL,
  `price` double NOT NULL,
  `amount` int(11) NOT NULL,
  `owner` bigint(20) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_product`
--

DROP TABLE IF EXISTS `mall_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `item_id` bigint(20) NOT NULL COMMENT '商品类型',
  `item_url` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `pic_url` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `month_sale` varchar(255) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `shop_id` bigint(20) DEFAULT NULL,
  `seller_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_id` (`item_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COMMENT='淘宝商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mall_product_snapshot`
--

DROP TABLE IF EXISTS `mall_product_snapshot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mall_product_snapshot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `order_id` bigint(20) NOT NULL,
  `item_id` bigint(20) NOT NULL COMMENT '商品类型',
  `title` varchar(255) NOT NULL,
  `pic_url` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `amount` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单商品快照';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_play_record`
--

DROP TABLE IF EXISTS `vod_play_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_play_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `current_time` double NOT NULL,
  `create_at` bigint(20) DEFAULT NULL,
  `ended` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `video_id` (`video_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21468 DEFAULT CHARSET=utf8mb4 COMMENT='视频播放记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_post_album`
--

DROP TABLE IF EXISTS `vod_post_album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_post_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `album_id` bigint(20) NOT NULL,
  `album_name` varchar(255) NOT NULL,
  `cover_url` varchar(255) DEFAULT NULL,
  `post_type` int(11) NOT NULL,
  `total` int(11) DEFAULT NULL,
  `scope` int(11) DEFAULT NULL,
  `create_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `favlist_id` (`album_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏夹';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_post_item`
--

DROP TABLE IF EXISTS `vod_post_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_post_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) NOT NULL,
  `post_id` varchar(255) NOT NULL,
  `pos` int(11) DEFAULT NULL,
  `added_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `favlist_id` (`album_id`,`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4501 DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏夹的内容';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_search_record`
--

DROP TABLE IF EXISTS `vod_search_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_search_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `user_id` int(11) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `keyword` (`keyword`)
) ENGINE=InnoDB AUTO_INCREMENT=461 DEFAULT CHARSET=utf8mb4 COMMENT='搜索记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_site_notice`
--

DROP TABLE IF EXISTS `vod_site_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_site_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `content` text NOT NULL,
  `create_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='站点公告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_category`
--

DROP TABLE IF EXISTS `vod_video_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `pid` int(11) NOT NULL COMMENT '分区级别【1 一级分区， 2 二级分区】',
  `region_id` int(11) DEFAULT NULL COMMENT 'bilibili region id',
  `name` varchar(255) NOT NULL COMMENT '分区名',
  `icon` varchar(255) DEFAULT NULL COMMENT '前端图标',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='视频分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_category_post`
--

DROP TABLE IF EXISTS `vod_video_category_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_category_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `video_id` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `video_file_id` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4,
  `category_pid` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `quality` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `codec` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `horizontal` bit(1) DEFAULT NULL,
  `cover_url` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `scope` int(11) NOT NULL COMMENT '视频可见范围',
  `status` int(11) DEFAULT NULL COMMENT '视频贴状态',
  `publish_at` datetime NOT NULL,
  `publish_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`category_id`,`publish_by`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=171212 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='视频分区稿件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_error`
--

DROP TABLE IF EXISTS `vod_video_error`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_error` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `error_code` int(11) NOT NULL,
  `error_info` varchar(255) NOT NULL,
  `solved` bit(1) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`video_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='视频稿件错误';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_file`
--

DROP TABLE IF EXISTS `vod_video_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `video_file_id` varchar(255) NOT NULL,
  `object_id` varchar(255) NOT NULL,
  `video_codec` varchar(255) DEFAULT NULL,
  `vbit_rate` bigint(20) NOT NULL,
  `audio_codec` varchar(255) DEFAULT NULL,
  `abit_rate` bigint(20) NOT NULL,
  `url_type` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `format` varchar(255) DEFAULT NULL,
  `format_name` varchar(255) DEFAULT NULL,
  `quality` varchar(255) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `horizontal` bit(1) NOT NULL,
  `duration` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object_id` (`object_id`) USING BTREE,
  KEY `video_file_id` (`video_file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=698558 DEFAULT CHARSET=utf8mb4 COMMENT='视频文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_post`
--

DROP TABLE IF EXISTS `vod_video_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `video_id` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `video_file_id` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `description` text CHARACTER SET utf8mb4,
  `category_pid` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `quality` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `codec` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `horizontal` bit(1) NOT NULL,
  `cover_url` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `scope` int(11) NOT NULL COMMENT '视频可见范围',
  `status` int(11) NOT NULL COMMENT '视频贴状态',
  `publish_at` datetime NOT NULL,
  `publish_by` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`video_id`) USING BTREE,
  UNIQUE KEY `video_file_id` (`video_file_id`) USING BTREE,
  KEY `user_id` (`publish_by`) USING BTREE,
  KEY `status` (`status`),
  KEY `scope` (`scope`),
  KEY `category_pid` (`category_pid`),
  KEY `category_id` (`category_id`),
  KEY `duration` (`duration`),
  KEY `pub_date` (`publish_at`),
  KEY `query_max` (`category_pid`,`category_id`,`scope`,`status`) USING BTREE,
  FULLTEXT KEY `index_title` (`title`) /*!50100 WITH PARSER `ngram` */ 
) ENGINE=InnoDB AUTO_INCREMENT=3043505 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='视频稿件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_statistic`
--

DROP TABLE IF EXISTS `vod_video_statistic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_statistic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` bit(1) NOT NULL DEFAULT b'0',
  `create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `video_id` varchar(255) NOT NULL,
  `view` int(11) NOT NULL,
  `danmaku` int(11) NOT NULL,
  `comment` int(11) NOT NULL,
  `favorite` int(11) NOT NULL,
  `share` int(11) NOT NULL,
  `thumb_up` int(11) NOT NULL,
  `thumb_down` int(11) NOT NULL,
  `coin` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_rfuvf3osnlaakifjdao0a8e2x` (`video_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3027544 DEFAULT CHARSET=utf8mb4 COMMENT='视频稿件数据';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_tag`
--

DROP TABLE IF EXISTS `vod_video_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` varchar(255) NOT NULL,
  `tag_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`tag_name`),
  UNIQUE KEY `tag_id` (`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1102652 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='视频标签';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `vod_video_tags`
--

DROP TABLE IF EXISTS `vod_video_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vod_video_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `video_id` varchar(255) NOT NULL,
  `tag_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`),
  KEY `video_id` (`video_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29207972 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='视频稿件包含的标签';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-12-15 22:47:21