# ************************************************************
# Sequel Ace SQL dump
# 版本号： 20066
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# 主机: 127.0.0.1 (MySQL 5.5.5-10.6.4-MariaDB)
# 数据库: isolate_site
# 生成时间: 2024-07-19 09:40:46 +0000
# ************************************************************


/*!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 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# 转储表 attachment
# ------------------------------------------------------------

DROP TABLE IF EXISTS `attachment`;

CREATE TABLE `attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT 0 COMMENT '会员ID',
  `file` varchar(500) DEFAULT NULL COMMENT '文件地址，如果是图片或视频，自动生成缩略图，格式为xxx_thumb.xxx',
  `pic` varchar(500) DEFAULT NULL COMMENT '缩略图地址',
  `first_letter` varchar(5) DEFAULT NULL COMMENT '首字母',
  `name` varchar(200) NOT NULL DEFAULT '' COMMENT '文件名',
  `old_name` varchar(200) NOT NULL DEFAULT '' COMMENT '原文件名',
  `resolution` varchar(100) NOT NULL DEFAULT '' COMMENT '分辨率',
  `title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题',
  `alt` varchar(500) NOT NULL DEFAULT '' COMMENT '图片类型专用 alt',
  `des` varchar(500) NOT NULL DEFAULT '' COMMENT '描述 ',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT '备注',
  `size` int(11) DEFAULT NULL COMMENT '文件大小',
  `ext` varchar(10) DEFAULT NULL COMMENT '扩展名',
  `type` tinyint(4) DEFAULT 0 COMMENT '0-其他，1-图片，2-视频 3 音乐',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(4) DEFAULT 0 COMMENT '状态 0-正常，2-删除(如果有人使用此附件，作删除状态，如果没有，直接删除)',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `company_id` (`file`(191)) USING BTREE,
  KEY `company_id_2` (`user_id`) USING BTREE,
  KEY `company_id_type_status` (`type`,`status`) USING BTREE,
  KEY `first_letter` (`first_letter`) USING BTREE,
  KEY `company_id_3` (`alt`(64)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='附件表';



# 转储表 blog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog`;

CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `plate_id` int(11) NOT NULL DEFAULT 0 COMMENT '板块id',
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `title` varchar(1024) NOT NULL DEFAULT '' COMMENT '标题',
  `author` varchar(255) NOT NULL DEFAULT '' COMMENT '作者',
  `content` text DEFAULT NULL COMMENT '内容',
  `outline_bar` text DEFAULT NULL COMMENT '大纲栏json格式',
  `description` varchar(1024) NOT NULL DEFAULT '' COMMENT '文章描述',
  `image_url` varchar(500) NOT NULL DEFAULT '' COMMENT '标题图url',
  `image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '标题图alt',
  `main_image` varchar(500) NOT NULL DEFAULT '' COMMENT '详情主图',
  `main_image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '主图alt',
  `virtual_view` int(11) NOT NULL DEFAULT 0 COMMENT '虚拟浏览',
  `total_view` int(11) NOT NULL COMMENT '总浏览',
  `download_url` varchar(500) NOT NULL DEFAULT '' COMMENT '下载连接',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '连接优化id',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '置顶',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `is_recommend` tinyint(4) NOT NULL COMMENT '是否推荐',
  `expand_content` text DEFAULT NULL COMMENT '自定义拓展',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章';



# 转储表 blog_plate
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog_plate`;

CREATE TABLE `blog_plate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `plate_name` varchar(50) NOT NULL DEFAULT '' COMMENT '板块名称',
  `plate_des` varchar(50) NOT NULL DEFAULT '' COMMENT '板块描述',
  `plate_fields` text NOT NULL COMMENT '板块字段，空表示全部展示',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '板块顺序',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章板块';

LOCK TABLES `blog_plate` WRITE;
/*!40000 ALTER TABLE `blog_plate` DISABLE KEYS */;

INSERT INTO `blog_plate` (`id`, `user_id`, `plate_name`, `plate_des`, `plate_fields`, `seo_id`, `sort`, `status`, `create_time`, `update_time`)
VALUES
	(1,10000,'新闻','','[]',3,0,0,NULL,'2023-09-19 14:25:56'),
	(2,10000,'成功案例','','[]',8,0,0,NULL,'2023-09-19 14:41:59'),
	(3,10000,'问答','','[]',5,0,0,NULL,'2023-09-19 16:04:17'),
	(4,10000,'合作伙伴','','[]',6,0,0,NULL,'2023-09-19 16:08:09'),
	(5,10000,'知识中心','','[]',7,0,0,NULL,'2023-09-19 16:10:45'),
	(6,10000,'解决方案','','[]',4,0,0,NULL,'2023-09-25 15:34:46'),
	(7,10000,'视频中心','','[]',2,0,0,NULL,'2023-09-26 14:51:01');

/*!40000 ALTER TABLE `blog_plate` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 blog_tag
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog_tag`;

CREATE TABLE `blog_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `tag_name` varchar(255) NOT NULL DEFAULT '' COMMENT '标签名称',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '热门标签',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



# 转储表 blog_tag_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog_tag_relation`;

CREATE TABLE `blog_tag_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `blog_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `tag_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章标签id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表';



# 转储表 blog_type
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog_type`;

CREATE TABLE `blog_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `type_name` varchar(255) NOT NULL DEFAULT '' COMMENT '类型名称',
  `expand_content` text NOT NULL COMMENT '拓展参数',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章类型';



# 转储表 blog_type_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `blog_type_relation`;

CREATE TABLE `blog_type_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `blog_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章类型id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章类型关联表';



# 转储表 com_email_code
# ------------------------------------------------------------

DROP TABLE IF EXISTS `com_email_code`;

CREATE TABLE `com_email_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `code` varchar(50) NOT NULL DEFAULT '' COMMENT '验证码',
  `email` varchar(50) NOT NULL DEFAULT '' COMMENT '邮箱',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '是否验证 状态 1 成功 -1 失败',
  `error` varchar(255) NOT NULL DEFAULT '' COMMENT '错误',
  `expire_time` datetime DEFAULT NULL COMMENT '有效期（创建时间加30分钟）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='验证码';



# 转储表 com_oss_etag
# ------------------------------------------------------------

DROP TABLE IF EXISTS `com_oss_etag`;

CREATE TABLE `com_oss_etag` (
  `etag` varchar(50) NOT NULL DEFAULT '' COMMENT 'MD5值',
  `url` varchar(200) NOT NULL DEFAULT '' COMMENT '地址',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `file_size` int(11) NOT NULL DEFAULT 0 COMMENT '文件大小',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`etag`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `url` (`url`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



# 转储表 com_sms
# ------------------------------------------------------------

DROP TABLE IF EXISTS `com_sms`;

CREATE TABLE `com_sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `phone` varchar(18) NOT NULL DEFAULT '' COMMENT '手机号',
  `code` varchar(10) NOT NULL DEFAULT '' COMMENT '短信内容',
  `template_code` varchar(50) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '状态 1 成功 -1 失败',
  `error` varchar(255) NOT NULL DEFAULT '' COMMENT '错误',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '验证码类型 默认0 1登陆验证码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `expire_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='短信日志表';



# 转储表 dict_function
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dict_function`;

CREATE TABLE `dict_function` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(100) DEFAULT '' COMMENT '功能名称',
  `remark` varchar(1000) DEFAULT '' COMMENT '说明',
  `status` int(11) DEFAULT 0 COMMENT '状态：0=启用,1=禁用,2=删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='功能';



# 转储表 dict_industry
# ------------------------------------------------------------

DROP TABLE IF EXISTS `dict_industry`;

CREATE TABLE `dict_industry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `pid` int(11) NOT NULL DEFAULT 0,
  `name` varchar(100) DEFAULT '' COMMENT '行业名称',
  `remark` varchar(1000) DEFAULT '' COMMENT '说明',
  `status` int(11) DEFAULT 0 COMMENT '状态：0=启用,1=禁用,2=删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='行业';



# 转储表 form_content
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_content`;

CREATE TABLE `form_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `record_id` int(10) unsigned NOT NULL COMMENT '表单提交记录id',
  `form_id` int(11) NOT NULL DEFAULT 0,
  `form_item_id` int(11) NOT NULL DEFAULT 0,
  `content` text NOT NULL COMMENT '内容',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `record_id` (`record_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单值';



# 转储表 form_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_info`;

CREATE TABLE `form_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `data_update_time` datetime DEFAULT NULL,
  `seo_id` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单';



# 转储表 form_item
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_item`;

CREATE TABLE `form_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `form_id` int(11) NOT NULL DEFAULT 0 COMMENT '表单id',
  `type` int(11) NOT NULL DEFAULT 0 COMMENT '表单项类型100-单行文本，101-多行文本，200-单选，201-多选',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '表单项名称',
  `is_forever` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否永久存在，不允许删除',
  `is_required` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否必须',
  `is_email` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否邮箱',
  `is_phone` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否电话',
  `is_url` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否url',
  `is_min` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否最小值',
  `is_max` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否最大值',
  `is_code_valid` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否号码验证',
  `min_val` int(11) NOT NULL DEFAULT 0 COMMENT '最小值',
  `max_val` int(11) NOT NULL DEFAULT 0 COMMENT '最大值',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态：0-正常，1-禁用，2-删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `form_id` (`form_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义的表单项';



# 转储表 form_item_detail
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_item_detail`;

CREATE TABLE `form_item_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `form_id` int(11) NOT NULL DEFAULT 0 COMMENT '公司id',
  `form_item_id` int(11) NOT NULL DEFAULT 0 COMMENT '表单项id',
  `content` varchar(200) NOT NULL DEFAULT '' COMMENT '内容',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态：0-正常，2-删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `form_id` (`form_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='表单项详情';



# 转储表 form_product
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_product`;

CREATE TABLE `form_product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `form_id` int(11) NOT NULL COMMENT '表单id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态：0-正常；2-删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='表单提交商品关联表';



# 转储表 form_product_detail
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_product_detail`;

CREATE TABLE `form_product_detail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_product_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `status` tinyint(4) DEFAULT 0 COMMENT '状态：0-正常；2-删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品表单详情';



# 转储表 form_record
# ------------------------------------------------------------

DROP TABLE IF EXISTS `form_record`;

CREATE TABLE `form_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `form_id` int(11) NOT NULL COMMENT '表单id',
  `relative_id` int(11) DEFAULT NULL COMMENT '关联id',
  `relative_table` varchar(50) DEFAULT NULL COMMENT '关联table',
  `is_read` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 未读 1已读',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP',
  `status` tinyint(4) NOT NULL COMMENT '状态：0-正常；2-删除',
  `sync_data_time` datetime DEFAULT NULL COMMENT '数据同步时间，如果有绑定星光同步表单，则同步后回写时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `form_id` (`form_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='表单信息记录列表';



# 转储表 help
# ------------------------------------------------------------

DROP TABLE IF EXISTS `help`;

CREATE TABLE `help` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `content` text DEFAULT NULL COMMENT '内容',
  `outline_bar` text DEFAULT NULL COMMENT '大纲栏json格式',
  `description` varchar(1024) NOT NULL DEFAULT '' COMMENT '描述',
  `image_url` varchar(500) NOT NULL DEFAULT '' COMMENT '标题图url',
  `image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '标题图alt',
  `main_image` varchar(500) NOT NULL DEFAULT '' COMMENT '详情主图',
  `main_image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '主图alt',
  `video_path` varchar(600) NOT NULL DEFAULT '' COMMENT '根据vedio_type决定：1-内站资源id；2-外站链接地址',
  `video_image_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'vidoe展示图片',
  `video_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '视频类型：1-内站；2-外站链接；0-空',
  `video_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '视频描述',
  `virtual_view` int(11) NOT NULL DEFAULT 0 COMMENT '虚拟浏览',
  `total_view` int(11) NOT NULL COMMENT '总浏览',
  `help_blog_id` int(11) NOT NULL DEFAULT 0 COMMENT '帮助详情id（作废）',
  `download_url` varchar(500) NOT NULL DEFAULT '',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '连接优化id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='帮助中心';



# 转储表 help_tag
# ------------------------------------------------------------

DROP TABLE IF EXISTS `help_tag`;

CREATE TABLE `help_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `tag_name` varchar(255) NOT NULL DEFAULT '' COMMENT '标签名称',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '热门标签',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



# 转储表 help_tag_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `help_tag_relation`;

CREATE TABLE `help_tag_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `help_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '帮助id',
  `tag_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '帮助标签id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='帮助标签关联表';



# 转储表 help_type
# ------------------------------------------------------------

DROP TABLE IF EXISTS `help_type`;

CREATE TABLE `help_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `type_name` varchar(255) NOT NULL DEFAULT '' COMMENT '类型名称',
  `type_img` varchar(500) NOT NULL DEFAULT '' COMMENT '帮助文档分类图片',
  `type_img_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '帮助文档分类图片Alt',
  `expand_content` text NOT NULL,
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='帮助类型';



# 转储表 help_type_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `help_type_relation`;

CREATE TABLE `help_type_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `help_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '帮助id',
  `type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '帮助类型id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='帮助类型关联表';



# 转储表 log_login
# ------------------------------------------------------------

DROP TABLE IF EXISTS `log_login`;

CREATE TABLE `log_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '登录日志',
  `org_id` int(11) NOT NULL DEFAULT 0 COMMENT '组织id',
  `relevance_id` int(11) NOT NULL COMMENT '相关id 登录类型为0 则为sys_user表id 类型为3则是sys_user_wx表id',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP地址',
  `login_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '登录类型 0 普通帐号密码登录 1 短信登录 2微信公众号 3微信小程序 4微信授权登录 5支付宝服务号 6支付宝小程序 7支付宝授权登录 8头条服务号 9头条小程序 10头条授权登录',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user_id` (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='用户登录日志';



# 转储表 meeting
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting`;

CREATE TABLE `meeting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `description` varchar(1024) NOT NULL DEFAULT '' COMMENT '关于展会',
  `content` text DEFAULT NULL COMMENT '内容',
  `start_date` datetime DEFAULT NULL COMMENT '开始时间',
  `end_date` datetime DEFAULT NULL COMMENT '结束时间',
  `image_url` varchar(500) NOT NULL DEFAULT '' COMMENT '标题图url',
  `image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '标题图alt',
  `main_image` varchar(500) NOT NULL DEFAULT '' COMMENT '详情主图',
  `main_image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '主图alt',
  `sub_image_urls` text DEFAULT NULL COMMENT '图集',
  `country` varchar(150) NOT NULL COMMENT '国家',
  `address` varchar(250) NOT NULL DEFAULT '0' COMMENT '地址',
  `virtual_view` int(11) NOT NULL DEFAULT 0 COMMENT '虚拟浏览',
  `total_view` int(11) NOT NULL COMMENT '总浏览',
  `download_url` varchar(500) NOT NULL DEFAULT '' COMMENT '下载连接',
  `video_path` varchar(255) NOT NULL COMMENT '根据vedio_type决定：1-内站资源id；2-外站链接地址',
  `video_image_url` varchar(255) NOT NULL COMMENT 'vidoe展示图片',
  `video_type` tinyint(4) NOT NULL COMMENT '视频类型：1-内站；2-外站链接；0-空',
  `video_desc` varchar(255) NOT NULL COMMENT '视频描述',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '连接优化id',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '置顶',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `is_recommend` tinyint(4) NOT NULL COMMENT '是否推荐',
  `meeting_host` varchar(255) NOT NULL DEFAULT '' COMMENT '主办方',
  `expand_content` text DEFAULT NULL COMMENT '拓展字段',
  `page_route` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章';



# 转储表 meeting_speech_schedule
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting_speech_schedule`;

CREATE TABLE `meeting_speech_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `meeting_id` int(11) NOT NULL DEFAULT 0 COMMENT '所属会议',
  `theme` varchar(150) NOT NULL DEFAULT '' COMMENT '主题',
  `address` varchar(150) NOT NULL DEFAULT '' COMMENT '地点',
  `title` varchar(150) CHARACTER SET utf8mb3 NOT NULL COMMENT '标题',
  `description` varchar(500) NOT NULL DEFAULT '' COMMENT '活动介绍',
  `cover_url` varchar(255) NOT NULL DEFAULT '' COMMENT '封面',
  `cover_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '封面',
  `expert_name` varchar(150) NOT NULL DEFAULT '' COMMENT '演讲者',
  `expert_des` varchar(255) NOT NULL COMMENT '演讲者描述',
  `expert_expert` varchar(255) NOT NULL COMMENT '演讲领域',
  `start_date` datetime DEFAULT NULL COMMENT '开始时间',
  `end_date` datetime DEFAULT NULL COMMENT '结束时间',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会议讲演日程表';



# 转储表 meeting_tag
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting_tag`;

CREATE TABLE `meeting_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `tag_name` varchar(255) NOT NULL DEFAULT '' COMMENT '标签名称',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '热门标签',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `type` tinyint(4) NOT NULL COMMENT '0 普通标签 1调味 2重量 3容量',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



# 转储表 meeting_tag_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting_tag_relation`;

CREATE TABLE `meeting_tag_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `meeting_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `tag_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章标签id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表';



# 转储表 meeting_type
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting_type`;

CREATE TABLE `meeting_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `type_name` varchar(255) NOT NULL DEFAULT '' COMMENT '类型名称',
  `expand_content` text NOT NULL,
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章类型';



# 转储表 meeting_type_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting_type_relation`;

CREATE TABLE `meeting_type_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `meeting_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章类型id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章类型关联表';



# 转储表 product
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `content` text DEFAULT NULL COMMENT '内容',
  `brand` varchar(150) NOT NULL DEFAULT '' COMMENT '品牌',
  `model_nb` varchar(150) NOT NULL DEFAULT '' COMMENT '型号',
  `package` varchar(1024) NOT NULL DEFAULT '' COMMENT '包装方式',
  `spec` varchar(1024) NOT NULL DEFAULT '' COMMENT '规格',
  `description` varchar(1024) NOT NULL DEFAULT '' COMMENT '文章描述',
  `image_url` varchar(500) NOT NULL DEFAULT '' COMMENT '标题图url',
  `image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '标题图alt',
  `main_image` varchar(500) NOT NULL DEFAULT '' COMMENT '详情主图',
  `main_image_alt` varchar(255) NOT NULL DEFAULT '' COMMENT '主图alt',
  `sub_image_urls` text DEFAULT NULL COMMENT '图集',
  `gallery_imgs` text DEFAULT NULL COMMENT 'gallery图集',
  `size_imgs` text DEFAULT NULL COMMENT '尺寸图集',
  `re_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '真实价格',
  `market_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '销售价格',
  `score` decimal(10,0) NOT NULL DEFAULT 0 COMMENT '评分',
  `sku` varchar(150) NOT NULL DEFAULT '',
  `virtual_view` int(11) NOT NULL DEFAULT 0 COMMENT '虚拟浏览',
  `total_view` int(11) NOT NULL COMMENT '总浏览',
  `download_url` text NOT NULL COMMENT '下载连接',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '连接优化id',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '置顶',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `is_recommend` tinyint(4) NOT NULL COMMENT '是否推荐',
  `expand_content` text DEFAULT NULL COMMENT '自定义拓展',
  `currency` varchar(20) NOT NULL DEFAULT 'CNY' COMMENT '币种￥CNY-人民币,$-USD美元,€-EUR欧元',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章';



# 转储表 product_tag
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product_tag`;

CREATE TABLE `product_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `tag_name` varchar(255) NOT NULL DEFAULT '' COMMENT '标签名称',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '热门标签',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `type` tinyint(4) NOT NULL COMMENT '0 普通标签 1调味 2重量 3容量',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



# 转储表 product_tag_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product_tag_relation`;

CREATE TABLE `product_tag_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `tag_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章标签id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表';



# 转储表 product_type
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product_type`;

CREATE TABLE `product_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `p_id` int(11) NOT NULL DEFAULT 0 COMMENT '父类',
  `level` tinyint(11) NOT NULL COMMENT '层级',
  `path` varchar(255) NOT NULL DEFAULT '',
  `path_name` varchar(255) NOT NULL DEFAULT '',
  `bg_img` varchar(500) NOT NULL COMMENT '背景图片链接',
  `description` varchar(1024) NOT NULL DEFAULT '',
  `type_name` varchar(255) NOT NULL DEFAULT '' COMMENT '类型名称',
  `expand_content` text NOT NULL COMMENT '拓展参数',
  `sort` int(11) NOT NULL COMMENT '排序',
  `seo_id` int(11) NOT NULL COMMENT 'seo_id',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='文章类型';



# 转储表 product_type_relation
# ------------------------------------------------------------

DROP TABLE IF EXISTS `product_type_relation`;

CREATE TABLE `product_type_relation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章id',
  `type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '文章类型id',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章类型关联表';



# 转储表 success_case
# ------------------------------------------------------------

DROP TABLE IF EXISTS `success_case`;

CREATE TABLE `success_case` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `title` varchar(150) NOT NULL COMMENT '标题',
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `description` varchar(1024) NOT NULL COMMENT '描述',
  `content` text NOT NULL COMMENT '内容',
  `image_url` varchar(500) NOT NULL COMMENT '标题图url',
  `image_alt` varchar(255) NOT NULL COMMENT '标题图alt',
  `main_image` varchar(500) NOT NULL COMMENT '详情主图',
  `main_image_alt` varchar(255) NOT NULL COMMENT '主图alt',
  `up_data` varchar(1024) NOT NULL COMMENT '提升的数据项json',
  `function_id` int(11) NOT NULL COMMENT '功能id',
  `industry_id` int(11) NOT NULL COMMENT '行业id',
  `company_name` varchar(150) NOT NULL COMMENT '公司名称',
  `company_desc` varchar(500) NOT NULL COMMENT '公司描述',
  `company_logo` varchar(500) NOT NULL COMMENT '公司logo',
  `company_logo_alt` varchar(255) NOT NULL,
  `virtual_view` int(11) NOT NULL DEFAULT 0 COMMENT '虚拟浏览',
  `total_view` int(11) NOT NULL DEFAULT 0 COMMENT '总浏览',
  `is_handpick` tinyint(4) NOT NULL DEFAULT 0 COMMENT '设置为精选',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '连接优化id',
  `sort` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='成功案例';



# 转储表 sys_ad
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_ad`;

CREATE TABLE `sys_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `position_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '位置id',
  `ad_title` varchar(1000) NOT NULL DEFAULT '' COMMENT '标题多个json',
  `ad_file` varchar(500) NOT NULL DEFAULT '' COMMENT '广告文件',
  `ad_description` varchar(1000) NOT NULL DEFAULT '' COMMENT '描述多个json',
  `start_time` datetime NOT NULL COMMENT '投放时间',
  `end_time` datetime NOT NULL COMMENT '投放时间',
  `ad_link` varchar(500) NOT NULL DEFAULT '' COMMENT '广告商链接',
  `ad_link_type` tinyint(4) NOT NULL COMMENT '广告连接类型 0 跳转 1下载',
  `ad_script` text NOT NULL COMMENT '脚本代码',
  `form_id` int(11) NOT NULL DEFAULT 0 COMMENT '自定义表单id',
  `type` tinyint(1) unsigned NOT NULL COMMENT '类型1=图片，2=视频，3=表单 4文字',
  `status` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT '0=正常，2=删除',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `hit_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '展示次数',
  `hit_click_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '点击次数',
  `push_num` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '推送次数(一天内展示x次后才不显示，针对顶部广告)',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `position_id` (`position_id`,`start_time`,`end_time`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='广告表';



# 转储表 sys_ad_position
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_ad_position`;

CREATE TABLE `sys_ad_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(20) NOT NULL DEFAULT '' COMMENT '编号',
  `ad_key` varchar(150) NOT NULL DEFAULT '' COMMENT '广告组件key',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `platform` tinyint(4) NOT NULL DEFAULT 0 COMMENT '展示品台 0 官网 1 客户端展示',
  `page_name` varchar(100) NOT NULL DEFAULT '' COMMENT '页面位置',
  `route_path_key` text NOT NULL COMMENT '页面key json',
  `ad_width` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '广告宽(px)',
  `ad_height` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '广告高(px)',
  `show_num` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '显示条数，多条表示循环显示',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `type` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT '0=默认指定页面广告，1=全局广告位置',
  `status` tinyint(1) unsigned NOT NULL COMMENT '0=正常，2=删除',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `number` (`number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='广告位置配置表';



# 转储表 sys_admin_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_admin_user`;

CREATE TABLE `sys_admin_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `real_name` varchar(50) NOT NULL DEFAULT '' COMMENT '真实名称',
  `phone` varchar(50) NOT NULL DEFAULT '' COMMENT '联系电话',
  `password` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(50) NOT NULL DEFAULT '' COMMENT '加密代码的随机字符串',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `is_super` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否超级管理员 0：不是 1：是',
  `role_id` int(11) NOT NULL DEFAULT 0 COMMENT '角色id',
  `status` int(4) NOT NULL DEFAULT 0,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

LOCK TABLES `sys_admin_user` WRITE;
/*!40000 ALTER TABLE `sys_admin_user` DISABLE KEYS */;

INSERT INTO `sys_admin_user` (`id`, `user_name`, `real_name`, `phone`, `password`, `salt`, `last_login_time`, `is_super`, `role_id`, `status`, `update_time`, `create_time`)
VALUES
	(10000,'mp_admin','超级管理员','13555555554','105ed78503c439facd6a191f59884d11','PW7921693290373001','2024-07-19 17:23:26',1,1,0,'2024-07-20 01:23:26','2016-05-11 11:06:16');

/*!40000 ALTER TABLE `sys_admin_user` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 sys_global_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_global_config`;

CREATE TABLE `sys_global_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `global_key` varchar(200) NOT NULL DEFAULT '' COMMENT '全局参数配置key',
  `label` varchar(200) NOT NULL DEFAULT '' COMMENT '全局参数名称',
  `value` text NOT NULL COMMENT '参数值json结构',
  `status` tinyint(4) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='官网全局参数配置';

LOCK TABLES `sys_global_config` WRITE;
/*!40000 ALTER TABLE `sys_global_config` DISABLE KEYS */;

INSERT INTO `sys_global_config` (`id`, `global_key`, `label`, `value`, `status`, `create_time`, `update_time`)
VALUES
	(1,'FORM_RECEIVE_MAIL','表单接收邮箱','{\"smtp_host\":\"更换SMTP HOST\",\"smtp_port\":\"更换SMTP  PORT\",\"mail_user\":\"更换SMTP 邮箱\",\"mail_pwd\":\"更换SMTP 邮箱密码\",\"to_mail\":[\"更换邮件接收邮箱\"]}',0,NULL,'2024-01-19 16:05:13'),
	(2,'WEB_GLOBAL_SEO','全局seo设置','{\"seo_title\":\"\",\"seo_keyword\":\"\",\"seo_describe\":\"\",\"track_code_head\":\"\",\"track_code_body\":\"\"}',0,NULL,'2024-07-19 16:47:58');

/*!40000 ALTER TABLE `sys_global_config` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 sys_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_log`;

CREATE TABLE `sys_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operation_id` int(11) NOT NULL COMMENT '操作人，后台帐户',
  `different_content` text NOT NULL,
  `teble_name` varchar(255) NOT NULL COMMENT '异动表',
  `log_type` tinyint(4) NOT NULL COMMENT '日志类型 0 系统登录日志',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='操作日志';

LOCK TABLES `sys_log` WRITE;
/*!40000 ALTER TABLE `sys_log` DISABLE KEYS */;

INSERT INTO `sys_log` (`id`, `operation_id`, `different_content`, `teble_name`, `log_type`, `create_time`)
VALUES
	(1,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 16:08:34'),
	(2,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 16:17:41'),
	(3,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 16:22:49'),
	(4,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 17:18:52'),
	(5,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 17:18:54'),
	(6,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 17:18:54'),
	(7,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 17:21:01'),
	(8,10000,'用户ID：10000;ip地址：127.0.0.1;','sys_admin_user',0,'2024-07-19 17:23:26');

/*!40000 ALTER TABLE `sys_log` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 sys_menu_func
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_menu_func`;

CREATE TABLE `sys_menu_func` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) NOT NULL DEFAULT 0 COMMENT '父id',
  `menu_func_name` varchar(50) NOT NULL DEFAULT '' COMMENT '菜单功能名称',
  `route_path` varchar(50) NOT NULL DEFAULT '' COMMENT '路由路径',
  `path` varchar(50) NOT NULL DEFAULT '' COMMENT '路径',
  `path_name` varchar(255) NOT NULL DEFAULT '' COMMENT '路径名称',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '类型 0 菜单 1功能',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='后台菜单表';

LOCK TABLES `sys_menu_func` WRITE;
/*!40000 ALTER TABLE `sys_menu_func` DISABLE KEYS */;

INSERT INTO `sys_menu_func` (`id`, `p_id`, `menu_func_name`, `route_path`, `path`, `path_name`, `type`, `status`, `create_time`, `update_time`)
VALUES
	(1,0,'系统管理','system','1','系统管理',0,0,'2021-02-09 10:07:45','2021-02-09 10:07:45'),
	(2,1,'后台账号管理','system.manage_admin','1,2','系统管理,后台账号管理',0,0,'2021-02-09 10:08:25','2021-02-09 10:09:28'),
	(3,2,'账号管理','system.manage_admin.user_index','1,2,3','系统管理,后台账号管理,账号管理',0,0,'2021-02-09 10:09:20','2021-02-09 10:09:29'),
	(4,2,'角色管理','system.manage_admin.user_role','1,2,4','系统管理,后台账号管理,角色管理',0,0,'2021-02-09 10:10:02','2021-02-09 10:10:02'),
	(31,1,'系统参数管理','system.manage_system','1,31','系统管理,系统参数管理',0,0,'2023-08-29 14:37:29','2023-08-29 14:37:29'),
	(32,31,'系统菜单管理','system.manage_system.sys_menu','1,31,32','系统管理,系统参数管理,系统菜单管理',0,0,'2023-08-29 14:37:56','2023-08-29 14:37:56'),
	(33,31,'全局配置设置','system.manage_system.manage_global','1,31,33','系统管理,系统参数管理,全局配置设置',0,0,'2023-08-29 14:39:36','2023-08-29 14:39:36'),
	(34,0,'创建帐号','create_admin_user','34','创建帐号',1,0,'2023-08-29 14:44:40','2023-08-29 14:44:40'),
	(35,0,'删除帐号','del_admin_user','35','删除帐号',1,0,'2023-08-29 14:48:42','2023-08-29 14:48:42'),
	(36,0,'内容管理','website','36','内容管理',0,0,'2023-09-12 10:39:07','2023-09-12 10:39:07'),
	(37,36,'文章管理','website.manage_blog','36,37','内容管理,文章管理',0,0,'2023-09-12 10:39:29','2023-09-12 10:39:29'),
	(38,37,'文章列表','website.manage_blog.blog_list','36,37,38','内容管理,文章管理,文章列表',0,0,'2023-09-12 10:39:58','2023-09-12 10:39:59'),
	(39,37,'文章编辑','website.manage_blog.blog_edit','36,37,39','内容管理,文章管理,文章编辑',0,0,'2023-09-12 10:43:59','2023-09-12 10:43:59'),
	(40,37,'文章新增','website.manage_blog.blog_add','36,37,40','内容管理,文章管理,文章新增',0,0,'2023-09-12 10:47:53','2023-09-12 10:47:53'),
	(41,37,'文章类型','website.manage_blog.blog_type','36,37,41','内容管理,文章管理,文章类型',0,0,'2023-09-12 10:50:06','2023-09-12 10:50:06'),
	(42,37,'文章标签','website.manage_blog.blog_tag','36,37,42','内容管理,文章管理,文章标签',0,0,'2023-09-12 10:52:25','2023-09-12 10:52:26'),
	(55,36,'网站页面管理','website.manage_static_page','36,55','内容管理,网站页面管理',0,0,'2023-09-12 10:59:41','2023-09-12 10:59:41'),
	(56,55,'网站页面列表','website.manage_static_page.static_page_list','36,55,56','内容管理,网站页面管理,网站页面列表',0,0,'2023-09-12 10:59:56','2023-09-12 10:59:56'),
	(57,55,'网站页面编辑','website.manage_static_page.static_page_edit','36,55,57','内容管理,网站页面管理,网站页面编辑',0,0,'2023-09-12 11:00:17','2023-09-12 11:00:17'),
	(58,36,'表单管理','website.form','36,58','内容管理,表单管理',0,0,'2023-09-12 11:00:40','2023-09-12 11:00:40'),
	(59,58,'询盘表单管理','website.form.form_list','36,58,59','内容管理,表单管理,询盘表单管理',0,0,'2023-09-12 11:01:02','2023-09-12 11:01:02'),
	(60,58,'表单编辑','website.form.form_edit','36,58,60','内容管理,表单管理,表单编辑',0,0,'2023-09-12 11:01:25','2023-09-12 11:01:25'),
	(61,58,'询盘管理','website.form.form_edit.record_list','36,58,61','内容管理,表单管理,询盘管理',0,0,'2023-09-12 11:01:39','2023-09-12 11:01:39'),
	(64,0,'素材','media','64','素材',0,0,'2023-09-12 11:03:08','2023-09-12 11:03:08'),
	(65,64,'素材管理','media.list','64,65','素材,素材管理',0,0,'2023-09-12 11:03:22','2023-09-12 11:03:22'),
	(66,55,'网站页面新增','website.manage_static_page.static_page_add','36,55,66','内容管理,网站页面管理,网站页面新增',0,0,'2023-09-12 11:27:15','2023-09-12 11:27:15'),
	(67,36,'产品管理','website.manage_product','36,67','内容管理,产品管理',0,0,'2023-09-24 11:49:19','2023-09-24 11:49:19'),
	(68,67,'产品列表','website.manage_product.product_list','36,67,68','内容管理,产品管理,产品列表',0,0,'2023-09-24 11:49:45','2023-09-24 11:49:46'),
	(69,67,'产品编辑','website.manage_product.product_edit','36,67,69','内容管理,产品管理,产品编辑',0,0,'2023-09-24 11:50:00','2023-09-24 11:50:01'),
	(70,67,'产品新增','website.manage_product.product_add','36,67,70','内容管理,产品管理,产品新增',0,0,'2023-09-24 11:50:16','2023-09-24 11:50:17'),
	(71,67,'产品类型','website.manage_product.product_type','36,67,71','内容管理,产品管理,产品类型',0,0,'2023-09-24 11:50:40','2023-09-24 11:50:40'),
	(72,67,'产品标签','website.manage_product.product_tag','36,67,72','内容管理,产品管理,产品标签',0,0,'2023-09-24 11:50:57','2023-09-24 11:50:58'),
	(73,36,'会议管理','website.manage_meeting','36,73','内容管理,会议管理',0,0,'2023-09-24 11:52:01','2023-09-24 11:53:05'),
	(74,73,'会议列表','website.manage_meeting.meeting_list','36,73,74','内容管理,会议管理,会议列表',0,0,'2023-09-24 11:52:18','2023-09-24 11:53:17'),
	(75,73,'会议编辑','website.manage_meeting.meeting_edit','36,73,75','内容管理,会议管理,会议编辑',0,0,'2023-09-24 11:53:38','2023-09-24 11:53:38'),
	(76,73,'会议新增','website.manage_meeting.meeting_add','36,73,76','内容管理,会议管理,会议新增',0,0,'2023-09-24 11:53:55','2023-09-24 11:53:55'),
	(77,73,'会议类型','website.manage_meeting.meeting_type','36,73,77','内容管理,会议管理,会议类型',0,0,'2023-09-24 11:54:13','2023-09-24 11:54:13'),
	(78,73,'会议标签','website.manage_meeting.meeting_tag','36,73,78','内容管理,会议管理,会议标签',0,0,'2023-09-24 11:54:30','2023-09-24 11:54:30'),
	(79,0,'静态页面自定义项新增','static_page_user_defined_add','79','静态页面自定义项新增',1,0,'2023-10-13 09:18:33','2023-10-13 09:18:34'),
	(80,0,'静态页面自定义项删除','static_page_user_defined_del','80','静态页面自定义项删除',1,0,'2023-10-13 09:18:46','2023-10-13 09:18:47');

/*!40000 ALTER TABLE `sys_menu_func` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 sys_menu_func_auth
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_menu_func_auth`;

CREATE TABLE `sys_menu_func_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_func_id` varchar(255) NOT NULL,
  `role_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `menu_role_id` (`menu_func_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='后台菜单权限';

LOCK TABLES `sys_menu_func_auth` WRITE;
/*!40000 ALTER TABLE `sys_menu_func_auth` DISABLE KEYS */;

INSERT INTO `sys_menu_func_auth` (`id`, `menu_func_id`, `role_id`, `status`, `create_time`, `update_time`)
VALUES
	(112,'1',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(113,'2',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(114,'3',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(115,'4',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(116,'31',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(117,'32',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(118,'33',1,0,'2023-08-29 14:43:17','2023-08-29 14:43:17'),
	(119,'1',2,0,'2023-08-29 14:43:24','2023-08-29 14:43:24'),
	(120,'2',2,2,'2023-08-29 14:43:24','2024-05-16 16:53:02'),
	(121,'3',2,2,'2023-08-29 14:43:24','2024-05-16 16:53:02'),
	(122,'4',2,2,'2023-08-29 14:43:24','2024-05-16 16:53:02'),
	(123,'31',2,0,'2023-08-29 14:43:24','2023-08-29 14:43:24'),
	(124,'32',2,0,'2023-08-29 14:43:24','2023-08-29 14:43:24'),
	(125,'33',2,0,'2023-08-29 14:43:24','2023-08-29 14:43:24'),
	(126,'34',1,0,'2023-08-29 14:45:37','2023-08-29 14:45:37'),
	(127,'35',1,0,'2023-08-29 14:48:56','2023-08-29 14:48:56'),
	(128,'36',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(129,'37',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(130,'38',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(131,'39',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(132,'40',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(133,'42',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(134,'41',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(135,'43',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(147,'55',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(148,'56',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(149,'57',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(150,'59',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(151,'60',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(152,'61',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(155,'64',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(156,'65',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(157,'58',1,0,'2023-09-12 11:03:58','2023-09-12 11:03:58'),
	(158,'36',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(159,'38',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(160,'37',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(161,'39',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(162,'40',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(163,'42',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(164,'41',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(177,'55',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(178,'56',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(179,'57',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(180,'58',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(181,'59',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(182,'60',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(183,'61',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(186,'64',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(187,'65',2,0,'2023-09-12 11:04:26','2023-09-12 11:04:26'),
	(188,'66',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(189,'68',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(190,'70',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(191,'69',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(192,'67',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(193,'71',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(194,'72',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(195,'73',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(196,'74',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(197,'75',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(198,'76',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(199,'77',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(200,'78',2,0,'2023-10-09 17:37:04','2023-10-09 17:37:04'),
	(201,'66',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(202,'67',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(203,'69',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(204,'68',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(205,'70',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(206,'72',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(207,'71',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(208,'73',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(209,'74',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(210,'75',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(211,'76',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(212,'77',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(213,'78',1,0,'2023-10-09 17:37:18','2023-10-09 17:37:18'),
	(214,'80',1,0,'2023-10-13 09:18:58','2023-10-13 09:18:58'),
	(215,'79',1,0,'2023-10-13 09:18:58','2023-10-13 09:18:58'),
	(216,'37',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(217,'38',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(218,'40',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(219,'39',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(220,'41',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(221,'42',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(234,'55',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(235,'56',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(236,'57',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(239,'65',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(240,'66',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(241,'64',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(242,'67',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(243,'68',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(244,'70',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(245,'69',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(246,'71',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(247,'72',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(248,'74',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(249,'73',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(250,'75',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(251,'76',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(252,'78',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(253,'77',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21'),
	(254,'36',3,0,'2024-05-16 16:47:21','2024-05-16 16:47:21');

/*!40000 ALTER TABLE `sys_menu_func_auth` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 sys_role
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 正常 1禁用 2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;

INSERT INTO `sys_role` (`id`, `role_name`, `status`, `create_time`, `update_time`)
VALUES
	(1,'超级管理员',0,'2020-12-20 17:33:49','2024-05-16 16:48:48'),
	(2,'管理员',0,'2021-05-22 14:00:44','2024-05-16 16:48:57'),
	(3,'工作人员',0,'2024-05-16 16:45:35','2024-05-16 16:45:35');

/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 web_seo
# ------------------------------------------------------------

DROP TABLE IF EXISTS `web_seo`;

CREATE TABLE `web_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `urla` varchar(255) NOT NULL DEFAULT '' COMMENT '优化连接',
  `relation_table` varchar(50) NOT NULL DEFAULT '' COMMENT '关联表',
  `relation_id` int(11) NOT NULL COMMENT '优化数据id',
  `seo_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo 标题',
  `seo_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo 关键词',
  `seo_describe` varchar(500) NOT NULL DEFAULT '' COMMENT 'seo 描述',
  `track_code_head` text DEFAULT NULL COMMENT '第三方代码head',
  `track_code_body` text DEFAULT NULL COMMENT '第三方代码body',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

LOCK TABLES `web_seo` WRITE;
/*!40000 ALTER TABLE `web_seo` DISABLE KEYS */;

INSERT INTO `web_seo` (`id`, `user_id`, `urla`, `relation_table`, `relation_id`, `seo_title`, `seo_keyword`, `seo_describe`, `track_code_head`, `track_code_body`, `status`, `create_time`, `update_time`)
VALUES
	(1,10000,'index','website_static_page',1,'','','',NULL,NULL,0,'2023-09-25 15:34:46','2023-09-25 15:34:46'),
	(2,10000,'视频中心','blog_plate',7,'','','',NULL,NULL,0,'2023-09-26 14:51:01','2023-09-26 14:51:01'),
	(3,10000,'新闻','blog_plate',1,'','','',NULL,NULL,0,'2023-09-19 14:25:56','2023-09-19 14:25:56'),
	(4,10000,'解决方案','blog_plate',2,'','','',NULL,NULL,0,'2023-09-19 14:41:59','2023-09-19 14:41:59'),
	(5,10000,'问答','blog_plate',3,'','','',NULL,NULL,0,'2023-09-19 16:04:17','2023-09-19 16:04:17'),
	(6,10000,'合作伙伴','blog_plate',4,'','','',NULL,NULL,0,'2023-09-19 16:08:09','2023-09-19 16:08:09'),
	(7,10000,'知识中心','blog_plate',5,'','','',NULL,NULL,0,'2023-09-19 16:10:45','2023-09-19 16:10:45'),
	(8,10000,'成功案例','blog_plate',6,'','','',NULL,NULL,0,'2023-09-25 15:34:46','2023-09-25 15:34:46');

/*!40000 ALTER TABLE `web_seo` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 web_static_page
# ------------------------------------------------------------

DROP TABLE IF EXISTS `web_static_page`;

CREATE TABLE `web_static_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '静态页面类型 0 普通页面 1动态页面详情页面 2 公共参数',
  `page_name` varchar(100) NOT NULL DEFAULT '' COMMENT '页面名称',
  `route_path` varchar(100) NOT NULL DEFAULT '' COMMENT '路由地址',
  `page_content` mediumtext NOT NULL COMMENT '内容参数json结构',
  `seo_id` int(11) NOT NULL DEFAULT 0 COMMENT '优化连接id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

LOCK TABLES `web_static_page` WRITE;
/*!40000 ALTER TABLE `web_static_page` DISABLE KEYS */;

INSERT INTO `web_static_page` (`id`, `user_id`, `type`, `page_name`, `route_path`, `page_content`, `seo_id`, `sort`, `status`, `create_time`, `update_time`)
VALUES
	(1,10000,0,'Home','home.index','',585,0,0,'2024-03-04 14:47:00','2024-05-13 09:37:49'),
	(2,10000,1,'layout_menu','layout_menu.index','\"[{\\\"name\\\":\\\"HOME\\\",\\\"router\\\":\\\"home\\\",\\\"type\\\":1,\\\"href\\\":\\\"\\\",\\\"is_hide\\\":false,\\\"key\\\":\\\"\\\",\\\"child\\\":[]}]\"',0,0,0,'2024-07-08 15:55:54','2024-07-19 16:09:29');

/*!40000 ALTER TABLE `web_static_page` ENABLE KEYS */;
UNLOCK TABLES;


# 转储表 web_utm
# ------------------------------------------------------------

DROP TABLE IF EXISTS `web_utm`;

CREATE TABLE `web_utm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `website_url` varchar(255) NOT NULL COMMENT '网站url',
  `short_url` varchar(255) NOT NULL COMMENT '短地址',
  `campaign_id` varchar(255) NOT NULL COMMENT '广告系列ID',
  `campaign_name` varchar(255) NOT NULL COMMENT '活动名称',
  `campaign_source` varchar(255) NOT NULL COMMENT '活动来源',
  `campaign_term` varchar(255) NOT NULL COMMENT '活动术语',
  `campaign_medium` varchar(255) NOT NULL COMMENT '活动媒介',
  `campaign_content` varchar(255) NOT NULL COMMENT '活动内容',
  `pv` int(11) NOT NULL DEFAULT 0 COMMENT 'pv',
  `uv` int(11) NOT NULL DEFAULT 0 COMMENT 'uv',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='操作日志';




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
