# ************************************************************ # 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 */;