-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- 主机： web-mysql -- 生成日期： 2022-01-08 14:55:47 -- 服务器版本： 10.1.32-MariaDB -- PHP 版本： 7.3.22 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 数据库： `churen` -- CREATE DATABASE IF NOT EXISTS `churen` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; USE `churen`; -- -------------------------------------------------------- -- -- 表的结构 `churen_main_config` -- DROP TABLE IF EXISTS `churen_main_config`; CREATE TABLE `churen_main_config` ( `id` int(11) UNSIGNED NOT NULL COMMENT '平台ID', `name` varchar(32) DEFAULT NULL COMMENT '网站名称', `logo` varchar(150) DEFAULT NULL COMMENT '网站LOGO', `seo_keyword` varchar(1000) DEFAULT NULL COMMENT 'SEO关键词', `seo_desc` varchar(1000) DEFAULT NULL COMMENT 'SEO描述', `phone` varchar(100) DEFAULT NULL COMMENT '客服电话', `worktime` varchar(100) DEFAULT NULL COMMENT '工作时间', `wechat` varchar(150) DEFAULT NULL COMMENT '公众号', `foot` text COMMENT '底部信息', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', `site` varchar(200) NOT NULL COMMENT '网站地址', `citys` varchar(1000) NOT NULL COMMENT '开通城市-直接填写城市名称，多个用换行隔开', `video_name` varchar(32) NOT NULL COMMENT '视频名称', `video_desc` varchar(800) NOT NULL COMMENT '视频介绍', `video` varchar(800) NOT NULL COMMENT '上传视频-视频格式MP4，上传大小不能超过4G', `video_pic` varchar(150) NOT NULL COMMENT '封面图-封面图自动生成，也可以直接上传，上传大小不能超过2M，支持JPG、PNG、GIF格式，建议上传JPG格式', `news_name` varchar(100) NOT NULL COMMENT '企业动态标题', `news_desc` varchar(500) NOT NULL COMMENT '企业动态介绍', `news_pic` varchar(150) NOT NULL COMMENT '企业动态图片', `contact_desc` varchar(800) NOT NULL COMMENT '联系我们介绍', `contact` text NOT NULL COMMENT '联系我们配置', `contact_address` varchar(500) NOT NULL COMMENT '公司地址', `contact_address_map` varchar(800) NOT NULL COMMENT '地址地图链接', `douyin` varchar(150) NOT NULL COMMENT '抖音', `weibo` varchar(150) NOT NULL COMMENT '微博' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_main_config` -- INSERT INTO `churen_main_config` (`id`, `name`, `logo`, `seo_keyword`, `seo_desc`, `phone`, `worktime`, `wechat`, `foot`, `state`, `cdate`, `site`, `citys`, `video_name`, `video_desc`, `video`, `video_pic`, `news_name`, `news_desc`, `news_pic`, `contact_desc`, `contact`, `contact_address`, `contact_address_map`, `douyin`, `weibo`) VALUES (1, '厨人易料', '{uploadRes}1/2021/10/20/a710d5276f58b3d4c46ee560423257ce.png', '', '', '40018092831', '10:00~18:00', '{uploadRes}1/2021/12/10/d8bca4a3e2c67f0c0aa1bf80cc771f04.jpg', '

\r\n 京ICP备123456 公安备案：12345 电信经营许可：ICP83123 \r\n

', 1, 1635606416, '西青区大寺', '北京\r\n上海\r\n广州\r\n深圳\r\n重庆\r\n天津', '厨人易料', '厨人易料厨人易料', '{uploadRes}3/2021/12/13/54c9a6381f666e50f76507e1325d33ef.mp4', '{uploadRes}1/2021/12/13/8d74635906e13181887fed69b13f07c5.png', '厨人易料企业动态', '了解更多厨人易料资讯', '{uploadRes}1/2021/12/10/94d5445d641c8d25fb919881ff818a38.png', '欢迎与我们公司联系，为您提供丰富的服务咨询，及全国的技术售后服务', '[{\"order\":\"1\",\"avatar\":\"http:\\/\\/zsmatest.nongxiaohe.com\\/data\\/upload\\/1\\/2021\\/12\\/01\\/f13d8c0817094f3e9b9552b4614e8166.png\",\"info\":\"法务\",\"name\":\"法务人员\",\"contact\":\"22222@qq.com\"},{\"order\":\"2\",\"avatar\":\"http:\\/\\/zsmatest.nongxiaohe.com\\/data\\/upload\\/1\\/2021\\/12\\/01\\/f13d8c0817094f3e9b9552b4614e8166.png\",\"info\":\"技术\",\"name\":\"技术1\",\"contact\":\"323@qq.com\"},{\"order\":\"3\",\"avatar\":\"http:\\/\\/zsmatest.nongxiaohe.com\\/data\\/upload\\/1\\/2021\\/10\\/18\\/bd4d9b2e53c56080112cc54a3bd31006.png\",\"info\":\"商务\",\"name\":\"赵天天\",\"contact\":\"23212313@qq.com\"}]', '北京市大兴区解放南路457号某某开发区多少层 010-000486661111', 'https://m.amap.com/navi/?dest=116.470098,39.992838&destName=%E9%98%9C%E9%80%9A%E8%A5%BF&hideRouteIcon=1&key=f18cb42560b8aa54e3b53a6265bfd764', '{uploadRes}1/2021/12/10/1a68aa40afd03e923695e45c15335bd8.png', '{uploadRes}1/2021/12/10/199746545827f11cf284a6ef0c2d3c1a.png'); -- -------------------------------------------------------- -- -- 表的结构 `churen_main_factory_config` -- DROP TABLE IF EXISTS `churen_main_factory_config`; CREATE TABLE `churen_main_factory_config` ( `id` int(11) UNSIGNED NOT NULL COMMENT '平台ID', `name` varchar(32) DEFAULT NULL COMMENT '供应链名称', `info` varchar(1000) DEFAULT NULL COMMENT '供应链业务描述', `phone` varchar(100) DEFAULT NULL COMMENT '客服电话', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', `kf_name` varchar(100) NOT NULL COMMENT '客服姓名', `foot` text NOT NULL COMMENT '底部信息', `dz_phone` varchar(100) NOT NULL COMMENT '对账专员电话' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_main_factory_config` -- INSERT INTO `churen_main_factory_config` (`id`, `name`, `info`, `phone`, `state`, `cdate`, `kf_name`, `foot`, `dz_phone`) VALUES (1, '供应链管理', '供应链管理', '13910185841', 1, 1635606466, '雪梅', '12', '13910185842'); -- -------------------------------------------------------- -- -- 表的结构 `churen_main_manage_config` -- DROP TABLE IF EXISTS `churen_main_manage_config`; CREATE TABLE `churen_main_manage_config` ( `id` int(11) UNSIGNED NOT NULL COMMENT '平台ID', `name` varchar(32) DEFAULT NULL COMMENT '小程序名称', `info` varchar(1000) DEFAULT NULL COMMENT '小程序业务描述', `logo` varchar(150) DEFAULT NULL COMMENT '小程序LOGO', `applet` varchar(150) DEFAULT NULL COMMENT '小程序二维码', `phone` varchar(100) DEFAULT NULL COMMENT '客服电话', `km` varchar(32) DEFAULT NULL COMMENT '推荐门店公里数-单位是公里，如5公里，填写5即可', `video` varchar(800) DEFAULT NULL COMMENT '视频宣传片-视频格式MP4，上传大小不能超过4G', `file` varchar(150) DEFAULT NULL COMMENT '宣传文件', `rule` text COMMENT '门店合作规则', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', `video_cover` varchar(150) NOT NULL COMMENT '视频封面图-封面图自动生成，也可以更改，上传大小不能超过2M，支持JPG、PNG、GIF格式，建议上传JPG格式', `dz_phone` varchar(100) NOT NULL COMMENT '对账专员电话' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_main_manage_config` -- INSERT INTO `churen_main_manage_config` (`id`, `name`, `info`, `logo`, `applet`, `phone`, `km`, `video`, `file`, `rule`, `state`, `cdate`, `video_cover`, `dz_phone`) VALUES (1, '门店管理', '门店管理小程序业务描述小程序业务描述小程序业务描述小程序业务描述小程序业务描述', '{uploadRes}1/2021/11/06/d5230aa4cdb71fe3e9dda7b32e57320b.png', '{uploadRes}1/2021/11/06/bdd89b682596b2c3386e90fe92306c59.jpg', '400789789', '5', '{uploadRes}3/2021/11/06/92812876bf1db3f61948590720282f4c.mp4', '{uploadRes}4/2021/11/17/396186a1b04a203fea3b5518f072f8a8.pdf', '门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则门店合作规则', 1, 1635606465, '{uploadRes}1/2021/10/20/053fd9593273371c183fc1a0bd731c11.jpg', '2110123123'); -- -------------------------------------------------------- -- -- 表的结构 `churen_main_sell_config` -- DROP TABLE IF EXISTS `churen_main_sell_config`; CREATE TABLE `churen_main_sell_config` ( `id` int(11) UNSIGNED NOT NULL COMMENT '平台ID', `name` varchar(32) DEFAULT NULL COMMENT '小程序名称', `info` varchar(1000) DEFAULT NULL COMMENT '小程序业务描述', `logo` varchar(150) DEFAULT NULL COMMENT '小程序LOGO', `applet` varchar(150) DEFAULT NULL COMMENT '小程序二维码', `phone` varchar(100) DEFAULT NULL COMMENT '客服电话', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', `dz_phone` varchar(100) NOT NULL COMMENT '对账专员电话', `card` varchar(150) NOT NULL COMMENT '礼品卡封面', `per` int(11) NOT NULL DEFAULT '1' COMMENT '平台佣金比例-输入1就是百分之1，分账时，平台自动从支付的金额里抽取1%的手续费', `card_name` varchar(150) NOT NULL DEFAULT '厨人E卡' COMMENT '礼品卡名称' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_main_sell_config` -- INSERT INTO `churen_main_sell_config` (`id`, `name`, `info`, `logo`, `applet`, `phone`, `state`, `cdate`, `dz_phone`, `card`, `per`, `card_name`) VALUES (1, '零售小程序', '零售小程序小程序业务描述小程序业务描述小程序业务描述小程序业务描述', '{uploadRes}1/2021/11/06/29463821c38ed93df668d8527e269382.png', '{uploadRes}1/2021/11/06/06d747b75d25ffb1e46f47302c5b33ab.jpg', '40012341234', 1, 1635606464, '182345678', '{uploadRes}1/2022/01/06/495cf2c73c8bb50be09847265fe40528.png', -1, '厨人E卡'); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_cron` -- DROP TABLE IF EXISTS `churen_manage_cron`; CREATE TABLE `churen_manage_cron` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(32) DEFAULT NULL COMMENT '任务名', `project` varchar(30) DEFAULT NULL COMMENT '项目', `interface` varchar(100) DEFAULT NULL COMMENT '接口（命令行）', `ldate` int(11) NOT NULL DEFAULT '0' COMMENT '执行时间', `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间间隔(为0则执行一次)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_cron` -- INSERT INTO `churen_manage_cron` (`id`, `name`, `project`, `interface`, `ldate`, `time`, `state`, `cdate`) VALUES (1, '跑每日零售订单', 'shop', 'lib/cron.sell', 1641654600, 3600, 1, 1636101717), (2, '跑每日采购订单', 'shop', 'lib/cron.buy', 1641654300, 3600, 1, 1636101746), (3, '生成门店采购对账单', 'cash', 'lib/cron.shop', 1641655800, 3600, 1, 1636453681), (4, '生成工厂对账单', 'cash', 'lib/cron.factory', 1641655860, 3600, 1, 1636453708), (5, '生成仓库对账单', 'cash', 'lib/cron.store', 1641655860, 3600, 1, 1636453769), (6, '销售订单待支付通知', 'shop', 'lib/cron.order', 1641653778, 100, 1, 1636621713), (7, '优惠券到期提醒', 'shop', 'lib/cron.coupon', 1641653915, 300, 1, 1636621737), (8, '统计用户信息', 'passport', 'lib/cron.user', 1641655347, 3600, 1, 1637140982), (9, '更新商品状态', 'shop', 'lib/cron.setGoodsStatus', 1641658540, 7200, 1, 1638065763); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_group` -- DROP TABLE IF EXISTS `churen_manage_group`; CREATE TABLE `churen_manage_group` ( `id` int(11) UNSIGNED NOT NULL COMMENT '组ID', `name` varchar(50) DEFAULT NULL COMMENT '组名称', `area` varchar(255) DEFAULT NULL COMMENT '区域', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_group` -- INSERT INTO `churen_manage_group` (`id`, `name`, `area`, `state`, `cdate`) VALUES (1, '默认分组', NULL, 1, 1634207050); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_menu` -- DROP TABLE IF EXISTS `churen_manage_menu`; CREATE TABLE `churen_manage_menu` ( `id` int(11) UNSIGNED NOT NULL COMMENT '菜单ID', `name` varchar(50) DEFAULT NULL COMMENT '菜单名称', `group_id` int(11) NOT NULL DEFAULT '1' COMMENT '选择分组', `menu_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级菜单', `menu` varchar(800) DEFAULT NULL COMMENT '上级菜单', `key` varchar(100) DEFAULT NULL COMMENT '菜单标识-选填，可以为空，用来标识菜单的唯一性', `link` varchar(150) DEFAULT NULL COMMENT '链接(或路径)-选填，可以为空', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序', `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '开启子菜单', `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请点此查看图标代码', `fast` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否快捷菜单', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_menu` -- INSERT INTO `churen_manage_menu` (`id`, `name`, `group_id`, `menu_id`, `menu`, `key`, `link`, `reorder`, `type`, `icon`, `fast`, `state`, `cdate`) VALUES (1, '主页', 1, -1, '-1', 'console', 'console:主页', 10000, 2, 'layui-icon-home', 2, 1, 1634207090), (2, '控制台', 1, 1, '1', 'console.index', 'http://zsmatest.nongxiaohe.com/package/manage/?l=console', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (3, '后台设置', 5, -1, '-1', 'manage', '/share/lib/php/dever_package/manage/:后台设置', -100, 2, 'glyphicon glyphicon-wrench layui-icon-set-sm', 2, 1, 1634207090), (4, '管理账户设置', 1, 3, '3', 'manage.admin', 'project/database/list?project=manage&table=admin&menu=manage&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (5, '接口列表', 1, 3, '3', 'manage.api', 'project/database/list?project=manage&table=api&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (6, '后台个性化', 1, 3, '3', 'manage.config', 'project/database/list?project=manage&table=config&menu=manage&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (7, '计划任务', 1, 3, '3', 'manage.cron', 'project/database/list?project=manage&table=cron&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (8, '管理组设置', 1, 3, '3', 'manage.group', 'project/database/list?project=manage&table=group&menu=manage&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (9, '管理操作日志', 1, 3, '3', 'manage.log', 'project/database/list?project=manage&table=log&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (10, '管理菜单设置', 1, 3, '3', 'manage.menu', 'project/database/list?project=manage&table=menu&menu=manage&search_option_state=1', 2, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (11, '后台公告管理', 1, 3, '3', 'manage.notice', 'project/database/list?project=manage&table=notice&menu=manage&search_option_state=1', 7, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (12, '字段记录表', 1, 3, '3', 'manage.opt', 'project/database/list?project=manage&table=opt&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (13, '管理角色设置', 1, 3, '3', 'manage.role', 'project/database/list?project=manage&table=role&menu=manage&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090), (14, '用户管理', 5, -1, '-1', 'passport', '/share/lib/php/dever_package/passport/:用户管理', 50, 2, 'glyphicon glyphicon-user layui-icon-username', 2, 1, 1634207098), (15, '默认头像', 1, 14, '14', 'passport.avatar', 'project/database/list?project=passport&table=avatar&menu=passport&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098), (16, '职业设置', 1, 14, '14', 'passport.profession', 'project/database/list?project=passport&table=profession&menu=passport&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098), (17, '项目管理', 1, 14, '14', 'passport.system', 'project/database/list?project=passport&table=system&menu=passport&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098), (18, '用户管理', 1, 14, '14', 'passport.user', 'project/database/list?project=passport&table=user&menu=passport&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098), (19, '上传资源管理', 5, -1, '-1', 'upload', '/share/lib/php/dever_package/upload/:资源库', 10, 2, 'glyphicon glyphicon-upload layui-icon-picture', 2, 1, 1634207104), (20, '资源分类', 1, 19, '19', 'upload.cate', 'project/database/list?project=upload&table=cate&menu=upload&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104), (21, '资源列表', 1, 19, '19', 'upload.file', 'project/database/list?project=upload&table=file&menu=upload&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104), (22, '资源配置', 1, 19, '19', 'upload.upload', 'project/database/list?project=upload&table=upload&menu=upload&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104), (23, '云端配置', 1, 19, '19', 'upload.yun', 'project/database/list?project=upload&table=yun&menu=upload&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104), (24, '行政区域设置', 5, -1, '-1', 'area', '/share/lib/php/dever_package/area/:地区设置', 20, 2, 'glyphicon glyphicon-compressed layui-icon-flag', 2, 1, 1634207108), (25, '城市', 1, 24, '24', 'area.city', 'project/database/list?project=area&table=city&menu=area&search_option_state=1', 11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108), (26, '县区', 1, 24, '24', 'area.county', 'project/database/list?project=area&table=county&menu=area&search_option_state=1', 12, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108), (27, '省份', 1, 24, '24', 'area.province', 'project/database/list?project=area&table=province&menu=area&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108), (28, '零售订单管理', 6, -1, '-1', 'menu_28', '/share/lib/php/dever_package/category/:分类管理', 199, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 1, 1634207116), (29, '栏目管理', 1, 28, '28', 'manage.menu.menu_29', 'project/database/list?project=category&table=column&menu=category&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207116), (30, '分类列表', 1, 28, '28', 'menu_30', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207116), (31, '类别规格关联设置', 2, 53, '53', 'category.attr', 'project/database/list?project=category&table=attr&menu=category&search_option_state=1', 194, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121), (32, '采购订单管理', 6, -1, '-1', 'menu_32', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 1, 1634207121), (33, '商品规格分类设置', 2, 53, '53', 'attr.cate', 'project/database/list?project=attr&table=cate&menu=attr&search_option_state=1', 196, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121), (34, '商品规格设置', 2, 53, '53', 'attr.info', 'project/database/list?project=attr&table=info&menu=attr&search_option_state=1', 197, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121), (35, '积分规则配置', 5, -1, '-1', 'score', '/share/lib/php/dever_package/score/:积分规则配置', 1, 2, 'glyphicon glyphicon-credit-card layui-icon-chat', 2, 1, 1634207126), (36, '用户行为配置', 1, 35, '35', 'score.action', 'project/database/list?project=score&table=action&menu=score&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126), (37, '积分名称设置', 1, 35, '35', 'score.config', 'project/database/list?project=score&table=config&menu=score&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126), (38, '积分等级设置', 1, 35, '35', 'score.level', 'project/database/list?project=score&table=level&menu=score&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126), (39, '消息中心', 4, -1, '-1', 'message', '/share/lib/php/dever_package/message/:消息系统', 100, 2, 'glyphicon glyphicon-dashboard layui-icon-senior', 2, 1, 1634207132), (40, '收件箱', 1, 39, '39', 'message.inbox', 'project/database/list?project=message&table=inbox&menu=message&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132), (41, '发件箱', 1, 39, '39', 'message.outbox', 'project/database/list?project=message&table=outbox&menu=message&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132), (42, '项目管理', 1, 39, '39', 'message.project', 'project/database/list?project=message&table=project&menu=message&search_option_state=1', 30, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132), (43, '推送配置', 1, 39, '39', 'manage.menu.menu_43', 'project/database/list?project=message&table=push&menu=message&search_option_state=1', 97, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207132), (44, '消息类型设置', 1, 39, '39', 'manage.menu.menu_44', 'project/database/list?project=message&table=type&menu=message&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207132), (45, '支付管理', 5, -1, '-1', 'pay', '/share/lib/php/dever_package/pay/:支付管理', 30, 2, 'glyphicon glyphicon-usd layui-icon-diamond', 2, 1, 1634207139), (46, '账户管理', 1, 45, '45', 'pay.account', 'project/database/list?project=pay&table=account&menu=pay&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139), (47, '订单管理', 1, 45, '45', 'pay.order', 'project/database/list?project=pay&table=order&menu=pay&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139), (48, '项目管理', 1, 45, '45', 'pay.project', 'project/database/list?project=pay&table=project&menu=pay&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139), (49, '平台设置', 4, -1, '-1', 'main', '/www/churen/main/:基础设置', 300, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207178), (50, '网站基础信息', 2, 49, '49', 'main.config', 'project/database/list?project=main&table=config&menu=main&search_option_state=1', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178), (51, '帮助中心', 4, 73, '73', 'main.help', 'project/database/list?project=main&table=help&menu=main&search_option_state=1', 199, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178), (52, '单页管理', 1, 49, '49', 'main.page', 'project/database/list?project=main&table=page&menu=main&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178), (53, '商品管理', 2, -1, '-1', 'goods', '/www/churen/app/goods/:商品管理', 500, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207186), (54, '礼品卡配置', 4, 71, '71', 'manage.menu.menu_54', 'project/database/list?project=goods&table=card&menu=goods&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207186), (55, '优惠券配置', 4, 71, '71', 'goods.coupon', 'project/database/list?project=goods&table=coupon&menu=goods&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207186), (56, '商品设置', 2, 53, '53', 'goods.info', 'project/database/list?project=goods&table=info&menu=goods&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207186), (57, '工厂管理', 2, -1, '-1', 'factory', '/www/churen/app/factory/:工厂管理', 600, 2, 'glyphicon glyphicon-tower layui-icon-flag', 2, 1, 1634207199), (58, '工厂列表', 2, 57, '57', 'factory.info', 'project/database/list?project=factory&table=info&menu=factory&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207199), (59, '仓库管理', 2, -1, '-1', 'store', '/www/churen/app/store/:仓库管理', 700, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1634207205), (60, '仓库列表', 2, 59, '59', 'store.info', 'project/database/list?project=store&table=info&menu=store&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207205), (61, '门店管理', 2, -1, '-1', 'menu_61', '/www/churen/app/shop/:门店管理', 800, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207211), (62, '反馈列表', 4, 69, '69', 'shop.feedback', 'project/database/list?project=shop&table=feedback&menu=shop&search_option_state=1', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207211), (63, '焦点图管理', 1, 61, '61', 'manage.menu.menu_63', 'project/database/list?project=shop&table=focus&menu=shop&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207211), (64, '门店列表', 2, 61, '61', 'shop.info', 'project/database/list?project=shop&table=info&menu=shop&search_option_state=1', 900, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207211), (65, '商品栏目管理', 2, 53, '53', 'goods.column', 'project/database/list?project=goods&table=column&menu=goods&search_option_state=1', 199, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634524826), (66, '商品类别管理', 2, 53, '53', 'category.info', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 195, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623901), (67, '第三方登录', 1, -1, '-1', 'manage.menu.menu_67', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1634623901), (68, '第三方管理', 1, 67, '67', 'oauth.account', 'project/database/list?project=oauth&table=account&menu=oauth&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623901), (69, '用户反馈', 4, -1, '-1', 'push', '/share/lib/php/dever_package/push/:推送管理', 199, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1634623901), (70, '推送位管理', 1, 69, '69', 'manage.menu.menu_70', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634623901), (71, '营销设置', 4, -1, '-1', 'act', '/www/churen/app/act/:活动管理', 200, 2, 'glyphicon glyphicon-tower layui-icon-reply-fill', 2, 1, 1634623910), (72, '活动管理', 1, 71, '71', 'act.info', 'project/database/list?project=act&table=info&menu=act&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623910), (73, '内容管理', 4, -1, '-1', 'content', '/www/churen/app/content/:内容管理', 400, 2, 'glyphicon glyphicon-tower layui-icon-tabs', 2, 1, 1634623916), (74, '专题页面', 4, 73, '73', 'content.feature', 'project/database/list?project=content&table=feature&menu=content&search_option_state=1', 195, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623916), (75, '文章页面', 4, 73, '73', 'manage.menu.menu_75', 'project/database/list?project=content&table=news&menu=content&search_option_state=1', 194, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634623916), (76, '结算对账', 6, -1, '-1', 'manage.menu.menu_76', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1634624286), (77, '推荐位管理', 1, 73, '73', 'push.data', 'project/database/list?project=push&table=data&menu=push&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634624286), (78, '街道', 1, 24, '24', 'area.town', 'project/database/list?project=area&table=town&menu=area&search_option_state=1', 13, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961), (79, '社区', 1, 24, '24', 'area.village', 'project/database/list?project=area&table=village&menu=area&search_option_state=1', 14, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961), (80, '推送位管理', 1, 69, '69', 'manage.menu.menu_80', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634710961), (81, '海报管理', 5, -1, '-1', 'menu_81', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 2, 1634710961), (82, '模板设置', 1, 81, '81', 'poster.template', 'project/database/list?project=poster&table=template&menu=poster&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961), (83, '商品标签管理', 2, 53, '53', 'goods.tag', 'project/database/list?project=goods&table=tag&menu=goods&search_option_state=1', 198, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713), (84, '门店订单管理', 6, 32, '32', 'menu_32.menu_84', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713), (85, '零售订单管理', 6, 28, '28', 'shop.sell_order', 'project/database/list?project=shop&table=sell_order&menu=shop&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713), (86, '推送位管理', 1, 3, '3', 'push.info', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713), (87, '公司动态', 4, 73, '73', 'main.news', 'project/database/list?project=main&table=news&menu=main&search_option_state=1', 198, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634802302), (88, '招聘信息', 4, 73, '73', 'main.zhaopin', 'project/database/list?project=main&table=zhaopin&menu=main&search_option_state=1', 196, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634802302), (89, '供应链基础信息', 1, 49, '49', 'main.factory_config', 'project/database/list?project=main&table=factory_config&menu=main&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246), (90, '门店小程序信息', 1, 49, '49', 'main.manage_config', 'project/database/list?project=main&table=manage_config&menu=main&search_option_state=1', 95, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246), (91, '零售小程序信息', 1, 49, '49', 'main.sell_config', 'project/database/list?project=main&table=sell_config&menu=main&search_option_state=1', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246), (92, '新增门店', 2, 61, '61', 'shop.menu_92', 'project/database/update&project=shop&table=info&menu=shop&menu_id=64&search_option_state=1', 1000, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635607001), (93, '新增工厂', 2, 57, '57', '', 'project/database/update&project=factory&&table=info&menu=factory&menu_id=58&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635607648), (94, '新增仓库', 1, 59, '59', '', 'project/database/update&project=store&&table=info&menu=store&menu_id=60&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635607688), (95, '门店合作申请', 1, 61, '61', 'shop.apply', 'project/database/list?project=shop&table=apply&menu=shop&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635686596), (96, '海报管理', 1, -1, '-1', 'manage.menu.menu_96', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 2, 1635686596), (97, '配送服务商', 4, 49, '49', 'main.menu_97', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636450211), (98, '平台订货下单', 6, 32, '32', 'menu_32.menu_98', 'http://zsmatest.nongxiaohe.com/app/factory/?l=lib/manage.cashier', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636450920), (99, '平台订单管理', 1, 32, '32', '', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=2', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636451393), (100, '门店零售结算单', 6, 76, '76', 'menu_76.menu_100', 'project/database/list?project=shop&table=sell_stat_month&menu=shop&search_option_state=1&search_option_type=2', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636451656), (101, '分类管理', 1, -1, '-1', 'manage.menu.menu_101', '/share/lib/php/dever_package/category/:分类管理', 10, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 2, 1636452047), (102, '属性管理', 1, -1, '-1', 'manage.menu.menu_102', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 2, 1636452047), (103, '采购订单', 1, 61, '61', 'manage.menu.menu_103', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636452047), (104, '配送服务商', 1, 61, '61', 'manage.menu.menu_104', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636452047), (105, '第三方登录', 1, -1, '-1', 'manage.menu.menu_105', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1636452047), (106, '门店零售对账单', 1, 76, '76', 'menu_76.menu_106', 'project/database/list?project=shop&table=sell_stat_month&menu=shop&search_option_state=1&search_option_type=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636452354), (107, '门店采购对账单', 6, 76, '76', 'menu_76.menu_107', 'project/database/list?project=shop&table=buy_stat_month&menu=shop&search_option_state=1&search_option_type=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453834), (108, '门店采购结算单', 6, 76, '76', 'menu_76.menu_108', 'project/database/list?project=shop&table=buy_stat_month&menu=shop&search_option_state=1&search_option_type=2', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453860), (109, '仓库对账单', 6, 76, '76', 'menu_76.menu_109', 'project/database/list?project=shop&table=store_stat_month&menu=shop&search_option_state=1', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453890), (110, '工厂对账单', 1, 76, '76', 'menu_76.menu_110', 'project/database/list?project=shop&table=factory_stat_month&menu=shop&search_option_state=1&search_option_type=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453927), (111, '工厂结算单', 1, 76, '76', 'menu_76.menu_111', 'project/database/list?project=shop&table=factory_stat_month&menu=shop&search_option_state=1&search_option_type=2', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453948), (112, '采购订单', 1, 61, '61', 'manage.menu.menu_112', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853), (113, '配送服务商', 1, 61, '61', 'manage.menu.menu_113', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853), (114, '结算对账', 6, -1, '-1', 'cash', '/www/churen/app/cash/:结算对账', 8, 2, 'glyphicon glyphicon-tower layui-icon-form', 2, 1, 1636705853), (115, '门店对账单', 1, 114, '114', 'manage.menu.menu_115', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853), (116, '分类管理', 5, -1, '-1', 'category', '/share/lib/php/dever_package/category/:分类管理', 10, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 1, 1637138455), (117, '出库订单管理', 6, -1, '-1', 'menu_117', '/share/lib/php/dever_package/attr/:属性管理', 9, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 1, 1637138455), (118, '采购额统计', 6, 121, '121', 'menu_121.menu_118', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (119, '门店出库订单', 6, 117, '117', 'menu_117.menu_119', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1&search_option_type=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (120, '销售额统计', 6, 121, '121', 'menu_121.menu_120', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (121, '统计分析', 6, -1, '-1', 'menu_121', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 1, 1637138455), (122, '海报管理', 5, -1, '-1', 'poster', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 1, 1637138455), (123, '工厂对账单', 1, 114, '114', 'cash.factory', 'project/database/list?project=cash&table=factory&menu=cash&search_option_state=1', 70, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (124, '门店结算单', 1, 114, '114', 'cash.menu_124', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1&search_option_search=1&page_type=2&search_option_type=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (125, '仓库对账单', 1, 114, '114', 'cash.store', 'project/database/list?project=cash&table=store&menu=cash&search_option_state=1', 60, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455), (126, '工厂结算单', 1, 114, '114', 'cash.menu_126', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1&search_option_search=3&page_type=2&search_option_source_type=3', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138766), (127, '仓库出库订单', 6, 117, '117', 'menu_117.menu_127', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1&search_option_type=2', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637139739), (128, '零售用户统计', 6, 121, '121', 'menu_121.menu_128', 'project/database/list?project=passport&table=stat&menu=stat&search_option_state=1', -11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637139898), (129, '属性管理', 5, -1, '-1', 'attr', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 1, 1637143356), (130, '采购订单', 1, 61, '61', 'manage.menu.menu_130', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (131, '采购额统计', 1, 61, '61', 'manage.menu.menu_131', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (132, '出库订单', 1, 61, '61', 'manage.menu.menu_132', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (133, '销售额统计', 1, 61, '61', 'manage.menu.menu_133', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (134, '配送服务商', 1, 61, '61', 'manage.menu.menu_134', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (135, '第三方登录', 5, -1, '-1', 'oauth', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 1, 1637143356), (136, '结算单', 1, 114, '114', 'manage.menu.menu_136', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356), (137, '门店对账单', 1, 114, '114', 'cash.shop', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356), (138, 'Token管理', 5, -1, '-1', 'token', '/share/lib/php/dever_package/token/:Token管理', -1, 2, 'glyphicon glyphicon-road layui-icon-engine', 2, 1, 1637143356), (139, '请求日志', 1, 138, '138', 'token.log', 'project/database/list?project=token&table=log&menu=token&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356), (140, '项目管理', 1, 138, '138', 'token.project', 'project/database/list?project=token&table=project&menu=token&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356), (141, '小程序管理', 5, -1, '-1', 'wechat_applet', '/share/lib/php/dever_package/wechat_applet/:小程序管理', 90, 2, 'glyphicon glyphicon-tint layui-icon-release', 2, 1, 1637143367), (142, '模板消息列表', 1, 141, '141', 'wechat_applet.msg', 'project/database/list?project=wechat_applet&table=msg&menu=wechat_applet&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367), (143, '模板消息日志', 1, 141, '141', 'wechat_applet.msg_log', 'project/database/list?project=wechat_applet&table=msg_log&menu=wechat_applet&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367), (144, '发送模板消息', 1, 141, '141', 'wechat_applet.msg_send', 'project/database/list?project=wechat_applet&table=msg_send&menu=wechat_applet&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367), (145, '统计概览', 1, 141, '141', 'wechat_applet.total_base', 'project/database/list?project=wechat_applet&table=total_base&menu=wechat_applet&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367), (146, '资源库', 5, -1, '-1', 'manage.menu.menu_146', '/share/lib/php/dever_package/upload/:资源库', -90, 2, 'glyphicon glyphicon-upload layui-icon-picture', 2, 2, 1637229112), (147, '资源分类', 1, 146, '146', 'upload.cate', 'project/database/list?project=upload&table=cate&menu=upload&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (148, '资源列表', 1, 146, '146', 'upload.file', 'project/database/list?project=upload&table=file&menu=upload&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (149, '资源配置', 1, 146, '146', 'upload.upload', 'project/database/list?project=upload&table=upload&menu=upload&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (150, '云端配置', 1, 146, '146', 'upload.yun', 'project/database/list?project=upload&table=yun&menu=upload&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (151, '地区设置', 5, -1, '-1', 'manage.menu.menu_151', '/share/lib/php/dever_package/area/:地区设置', -10, 2, 'glyphicon glyphicon-compressed layui-icon-flag', 2, 2, 1637229112), (152, '城市', 1, 151, '151', 'area.city', 'project/database/list?project=area&table=city&menu=area&search_option_state=1', 11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (153, '县区', 1, 151, '151', 'area.county', 'project/database/list?project=area&table=county&menu=area&search_option_state=1', 12, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (154, '省份', 1, 151, '151', 'area.province', 'project/database/list?project=area&table=province&menu=area&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (155, '街道', 1, 151, '151', 'area.town', 'project/database/list?project=area&table=town&menu=area&search_option_state=1', 13, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (156, '社区', 1, 151, '151', 'area.village', 'project/database/list?project=area&table=village&menu=area&search_option_state=1', 14, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (157, '分类属性设置', 1, 101, '101', 'category.attr', 'project/database/list?project=category&table=attr&menu=category&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (158, '分类列表', 1, 101, '101', 'category.info', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (159, '属性类别', 1, 102, '102', 'attr.cate', 'project/database/list?project=attr&table=cate&menu=attr&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (160, '属性设置', 1, 102, '102', 'attr.info', 'project/database/list?project=attr&table=info&menu=attr&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (161, '消息系统', 4, -1, '-1', 'message', '/share/lib/php/dever_package/message/:消息系统', -6, 2, 'glyphicon glyphicon-dashboard layui-icon-senior', 2, 1, 1637229112), (162, '收件箱', 1, 161, '161', 'message.inbox', 'project/database/list?project=message&table=inbox&menu=message&search_option_state=1', 18, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (163, '发件箱', 1, 161, '161', 'message.outbox', 'project/database/list?project=message&table=outbox&menu=message&search_option_state=1', 19, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (164, '项目管理', 1, 161, '161', 'message.project', 'project/database/list?project=message&table=project&menu=message&search_option_state=1', 30, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (165, '基础设置', 4, -1, '-1', 'manage.menu.menu_165', '/www/churen/main/:基础设置', 98, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637229112), (166, '网站基础信息', 1, 165, '165', 'main.config', 'project/database/list?project=main&table=config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (167, '供应链基础信息', 1, 165, '165', 'main.factory_config', 'project/database/list?project=main&table=factory_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (168, '帮助中心', 1, 165, '165', 'main.help', 'project/database/list?project=main&table=help&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (169, '门店小程序信息', 1, 165, '165', 'main.manage_config', 'project/database/list?project=main&table=manage_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (170, '文章管理', 1, 165, '165', 'main.news', 'project/database/list?project=main&table=news&menu=main&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (171, '单页管理', 1, 165, '165', 'main.page', 'project/database/list?project=main&table=page&menu=main&search_option_state=1', 2, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (172, '零售小程序信息', 1, 165, '165', 'main.sell_config', 'project/database/list?project=main&table=sell_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (173, '招聘信息', 1, 165, '165', 'main.zhaopin', 'project/database/list?project=main&table=zhaopin&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (174, '礼品卡配置', 1, 53, '53', 'manage.menu.menu_174', 'project/database/list?project=goods&table=card&menu=goods&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637229112), (175, '栏目管理', 1, 53, '53', 'goods.column', 'project/database/list?project=goods&table=column&menu=goods&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (176, '优惠券配置', 1, 53, '53', 'goods.coupon', 'project/database/list?project=goods&table=coupon&menu=goods&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (177, '商品列表', 1, 53, '53', 'goods.info', 'project/database/list?project=goods&table=info&menu=goods&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (178, '标签管理', 1, 53, '53', 'goods.tag', 'project/database/list?project=goods&table=tag&menu=goods&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (179, '门店零售', 2, -1, '-1', 'manage.menu.menu_179', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637229112), (180, '门店合作申请', 1, 179, '179', 'shop.apply', 'project/database/list?project=shop&table=apply&menu=shop&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (181, '采购订单', 1, 179, '179', 'shop.buy_order', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (182, '采购额统计', 1, 179, '179', 'shop.buy_stat', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (183, '反馈管理', 1, 179, '179', 'shop.feedback', 'project/database/list?project=shop&table=feedback&menu=shop&search_option_state=1', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (184, '门店列表', 1, 179, '179', 'shop.info', 'project/database/list?project=shop&table=info&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (185, '出库订单', 1, 179, '179', 'shop.out_order', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (186, '销售订单', 1, 179, '179', 'shop.sell_order', 'project/database/list?project=shop&table=sell_order&menu=shop&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (187, '销售额统计', 1, 179, '179', 'shop.sell_stat', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (188, '配送服务商', 1, 179, '179', 'shop.service', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (189, '推送管理', 4, -1, '-1', 'push', '/share/lib/php/dever_package/push/:推送管理', 199, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1637229112), (190, '首页焦点图下的推送数据管理', 1, 189, '189', 'push.data', 'project/database/list?project=push&table=data&menu=push&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (191, '推送位管理', 1, 189, '189', 'push.info', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (192, '活动管理', 4, -1, '-1', 'act', '/www/churen/app/act/:活动管理', 200, 2, 'glyphicon glyphicon-tower layui-icon-reply-fill', 2, 1, 1637229112), (193, '活动管理', 1, 192, '192', 'act.info', 'project/database/list?project=act&table=info&menu=act&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (194, '专题管理', 1, 73, '73', 'content.feature', 'project/database/list?project=content&table=feature&menu=content&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (195, '文章管理', 1, 73, '73', 'content.news', 'project/database/list?project=content&table=news&menu=content&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (196, '结算单', 1, 76, '76', 'cash.order', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (197, '门店对账单', 1, 76, '76', 'cash.shop', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112), (198, '门店零售', 1, -1, '-1', 'manage.menu.menu_198', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637813857), (199, '订阅消息列表', 1, 141, '141', 'wechat_applet.subscribe', 'project/database/list?project=wechat_applet&table=subscribe&menu=wechat_applet&search_option_state=1', 89, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857), (200, '订阅消息日志', 1, 141, '141', 'wechat_applet.subscribe_log', 'project/database/list?project=wechat_applet&table=subscribe_log&menu=wechat_applet&search_option_state=1', 77, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857), (201, '发送订阅消息', 1, 141, '141', 'wechat_applet.subscribe_send', 'project/database/list?project=wechat_applet&table=subscribe_send&menu=wechat_applet&search_option_state=1', 79, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857), (202, '短信管理', 5, -1, '-1', 'sms', '/share/lib/php/dever_package/sms/:短信管理', -10, 2, 'glyphicon glyphicon-list-alt layui-icon-note', 2, 1, 1638238703), (203, '基本配置', 1, 202, '202', 'sms.config', 'project/database/list?project=sms&table=config&menu=sms&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1638238703), (204, '出库类型设置', 1, 49, '49', 'main.menu_204', 'project/database/list?project=shop&table=out_type&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1638866110), (205, '出库类型', 1, 198, '198', 'shop.out_type', 'project/database/list?project=shop&table=out_type&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343), (206, '礼品卡管理', 1, -1, '-1', 'menu_206', '/www/churen/app/card/:礼品卡管理', 90, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1641294343), (207, '面值配置', 1, 206, '206', 'card.info', 'project/database/list?project=card&table=info&menu=card&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343), (208, '礼品卡订单', 1, 206, '206', 'card.order', 'project/database/list?project=card&table=order&menu=card&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343), (209, '类型配置', 1, 206, '206', 'card.type', 'project/database/list?project=card&table=type&menu=card&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343), (210, '帮助管理', 1, 3, '3', 'manage.help', 'project/database/list?project=manage&table=help&menu=manage&search_option_state=1', 6, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641643287), (211, '门店零售', 1, -1, '-1', 'shop', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1641643287), (212, '礼品卡管理', 1, -1, '-1', 'card', '/www/churen/app/card/:礼品卡管理', 90, 2, 'glyphicon glyphicon-tower layui-icon-gift', 2, 1, 1641643287), (213, '后台操作讲解', 4, 49, '49', 'main.menu_213', 'http://zsmatest.nongxiaohe.com/package/manage/?l=doc/help', -100, 2, 'glyphicon glyphicon-folder-close layui-icon-light', 2, 1, 1641643457); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_menu_group` -- DROP TABLE IF EXISTS `churen_manage_menu_group`; CREATE TABLE `churen_manage_menu_group` ( `id` int(11) UNSIGNED NOT NULL COMMENT '分组ID', `name` varchar(50) DEFAULT NULL COMMENT '分组名称', `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请点此查看图标代码', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_menu_group` -- INSERT INTO `churen_manage_menu_group` (`id`, `name`, `icon`, `reorder`, `state`, `cdate`) VALUES (1, '控制台', 'layui-icon layui-icon-home', 100, 1, 1634207090), (2, '供应链管理', 'glyphicon glyphicon-folder-close', 2, 1, 1634207236), (3, '商品管理', 'glyphicon glyphicon-folder-close', 80, 2, 1634207268), (4, '基础运营', 'glyphicon glyphicon-folder-close', 70, 1, 1634207278), (5, '平台系统管理', 'glyphicon glyphicon-folder-close', 1, 1, 1634207285), (6, '业务管理', 'glyphicon glyphicon-folder-close', 79, 1, 1634207390); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_notice` -- DROP TABLE IF EXISTS `churen_manage_notice`; CREATE TABLE `churen_manage_notice` ( `id` int(11) UNSIGNED NOT NULL COMMENT '公告ID', `name` varchar(32) DEFAULT NULL COMMENT '公告标题', `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `content` text COMMENT '内容', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_notice` -- INSERT INTO `churen_manage_notice` (`id`, `name`, `config`, `reorder`, `content`, `state`, `cdate`) VALUES (1, '最新公告：系统已更新至v1.0.0版本', 1, 1, '最新公告：系统已更新至v1.0.0版本最新公告：系统已更新至v1.0.0版本最新公告：系统已更新至v1.0.0版本', 1, 1634656265); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_opt` -- DROP TABLE IF EXISTS `churen_manage_opt`; CREATE TABLE `churen_manage_opt` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `project` varchar(30) DEFAULT NULL COMMENT '项目', `table` varchar(30) DEFAULT NULL COMMENT '数据表-请输入表的英文名', `method` varchar(32) DEFAULT NULL COMMENT '所属方法名', `col` varchar(500) DEFAULT NULL COMMENT '使用的字段', `col_index` varchar(500) DEFAULT NULL COMMENT '建立索引的字段', `version` int(11) NOT NULL DEFAULT '0' COMMENT '版本号', `num` int(11) NOT NULL DEFAULT '0' COMMENT '执行次数', `time` varchar(30) DEFAULT NULL COMMENT '执行时间', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否建立索引', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据是否存在', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_opt` -- INSERT INTO `churen_manage_opt` (`id`, `project`, `table`, `method`, `col`, `col_index`, `version`, `num`, `time`, `status`, `state`, `cdate`) VALUES (1, 'manage', 'admin', NULL, 'id,state,desc', NULL, 0, 0, '[0.016351938247681S]', 1, 1, 1634812765), (2, 'manage', 'auth', NULL, 'state', NULL, 0, 0, '[0.018131017684937S]', 1, 1, 1634812765), (3, 'manage', 'role', NULL, 'id,state,reorder,desc', NULL, 0, 0, '[0.018597841262817S]', 1, 1, 1634812765), (4, 'manage', 'group', NULL, 'id,state,desc', NULL, 0, 0, '[0.0190589427948S]', 1, 1, 1634812765), (5, 'manage', 'config', NULL, 'id,state,desc', NULL, 0, 0, '[0.037459850311279S]', 1, 1, 1634812765), (6, 'manage', 'menu', NULL, 'state,menu_id,reorder,id,desc,group_id,asc', NULL, 0, 0, '[0.026947975158691S]', 1, 1, 1634812765), (7, 'manage', 'menu_group', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.030562877655029S]', 1, 1, 1634812765), (8, 'manage', 'notice', NULL, 'config,state,desc,id,reorder', NULL, 0, 0, '[0.020024061203003S]', 1, 1, 1634812765), (9, 'main', 'cate', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.035238981246948S]', 1, 1, 1634812773), (10, 'main', 'source', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.035588979721069S]', 1, 1, 1634812773), (11, 'main', 'info', NULL, 'state,desc,reorder,id,status,pdate,cate_id,asc', NULL, 0, 0, '[0.02128791809082S]', 1, 1, 1634812773), (12, 'main', 'page', NULL, 'state,desc,id,type,key', NULL, 0, 0, '[0.019176959991455S]', 1, 1, 1634812774), (13, 'main', 'group', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.031076908111572S]', 1, 1, 1634812774), (14, 'main', 'zhaopin', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.034333944320679S]', 1, 1, 1634812774), (15, 'passport', 'user', NULL, 'id,state,desc,cdate,mobile,username', NULL, 0, 0, '[0.02048397064209S]', 1, 1, 1634821078), (16, 'manage', 'api', NULL, 'site,reorder,id,state,desc,project', NULL, 0, 0, '[0.041147947311401S]', 1, 1, 1634821078), (17, 'manage', 'api_response', NULL, 'api_id,parent_id,name,desc,id', NULL, 0, 0, '[0.56325507164001S]', 1, 1, 1634821078), (18, 'manage', 'api_request', NULL, 'api_id,parent_id,name,desc,id', NULL, 0, 0, '[0.57545399665833S]', 1, 1, 1634821078), (19, 'push', 'info', NULL, 'key,id,state,desc,reorder', NULL, 0, 0, '[0.038268089294434S]', 1, 1, 1634821079), (20, 'push', 'func', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.028899908065796S]', 1, 1, 1634821079), (21, 'push', 'col', NULL, 'state,id,desc,asc,reorder', NULL, 0, 0, '[0.030793905258179S]', 1, 1, 1634821079), (22, 'push', 'data', NULL, 'info_id,state,desc,reorder,id', NULL, 0, 0, '[0.038567066192627S]', 1, 1, 1634821079), (23, 'content', 'feature', NULL, 'id,state,desc,reorder,cdate', NULL, 0, 0, '[0.027836084365845S]', 1, 1, 1634821079), (24, 'act', 'info', NULL, 'id,state,desc,reorder,cdate', NULL, 0, 0, '[0.025110006332397S]', 1, 1, 1634821079), (25, 'content', 'news', NULL, 'id,state,desc,reorder,cdate', NULL, 0, 0, '[0.0258629322052S]', 1, 1, 1634821079), (26, 'goods', 'info', NULL, 'id,state,desc,reorder,price_type,name,status,category,cdate', NULL, 0, 0, '[0.03783392906189S]', 1, 1, 1634821079), (27, 'passport', 'system', NULL, 'state,id,desc,reorder', NULL, 0, 0, '[0.036473035812378S]', 1, 1, 1634821241), (28, 'passport', 'wechat', NULL, 'openid,id,state,desc,system_id,uid,system_source,type', NULL, 0, 0, '[0.027748107910156S]', 1, 1, 1634821241), (29, 'shop', 'user_coupon', NULL, 'uid,city,edate,status,state,asc,desc,id,shop_coupon_id,cash,cdate,coupon_id', NULL, 0, 0, '[0.017729043960571S]', 1, 1, 1634821241), (30, 'goods', 'card_code', NULL, 'uid,card_id,state,desc,id,card,pwd,status', NULL, 0, 0, '[0.018984079360962S]', 1, 1, 1634821241), (31, 'score', 'config', NULL, 'type,state,desc,reorder,id', NULL, 0, 0, '[0.019773006439209S]', 1, 1, 1634821241), (32, 'score', 'user', NULL, 'uid,config_id', NULL, 0, 0, '[0.02032995223999S]', 1, 1, 1634821241), (33, 'message', 'inbox', NULL, 'uid,project_id,status,state,desc,id,asc,type', NULL, 0, 0, '[0.059172868728638S]', 1, 1, 1634821241), (34, 'goods', 'column', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.021888971328735S]', 1, 1, 1634821895), (35, 'shop', 'goods', NULL, 't_1.shop_id,t_2.column_id,desc,t_2.reorder,t_2.id,shop_id,state,id,goods_id,t_2.name,t_2.status,t_2.state,price_type,status,cdate,t_2.price_type,t_2.sell_type,t_1.state', NULL, 0, 0, '[0.086683988571167S]', 1, 1, 1634821895), (36, 'shop', 'goods_sku', NULL, 'shop_id,goods_id,state,desc,id,sku_id,t_1.shop_id,asc,t_2.reorder,t_2.id,t_2.price,t_1.total_num-t_1.sell_num,t_2.name,t_2.status,t_2.state,t_1.state', NULL, 0, 0, '[0.085901021957397S]', 1, 1, 1634821895), (37, 'category', 'info', NULL, 'id,info_id,state,desc,asc,reorder', NULL, 0, 0, '[0.085546970367432S]', 1, 1, 1634821895), (38, 'category', 'attr', NULL, 'category,state,desc,id', NULL, 0, 0, '[0.052905082702637S]', 1, 1, 1634821895), (39, 'attr', 'info', NULL, 'id,state,desc,list_reorder`+`search_reorder`+`view_reorder,list_reorder,search_reorder,view_reorder,cate_id', NULL, 0, 0, '[0.0535569190979S]', 1, 1, 1634821895), (40, 'attr', 'value', NULL, 'info_id,state,desc,reorder,id', NULL, 0, 0, '[0.055800914764404S]', 1, 1, 1634821895), (41, 'goods', 'info_attr_5', NULL, 'id', NULL, 0, 0, '[0.055419921875S]', 1, 1, 1634821895), (42, 'goods', 'info_sku', NULL, 'info_id,state,desc,id,type,reorder,code', NULL, 0, 0, '[0.056395053863525S]', 1, 1, 1634821895), (43, 'goods', 'tag', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.035429954528809S]', 1, 1, 1634821895), (44, 'shop', 'info', NULL, 'state,id,desc,status,city,coupon_city,type,area,name,mobile,reorder,truename,open,method', NULL, 0, 0, '[0.048494100570679S]', 1, 1, 1634821901), (45, 'shop', 'cart', NULL, 'state,uid,shop_id,goods_id,desc,id,sku_id', 'uid,shop_id,goods_id', 1, 0, '[0.018752098083496S]', 2, 1, 1634821901), (46, 'goods', 'info_attr_2', NULL, 'id', NULL, 0, 0, '[0.072206020355225S]', 1, 1, 1634822261), (47, 'upload', 'upload', NULL, 'id,state,desc', NULL, 0, 0, '[0.032238006591797S]', 1, 1, 1634822268), (48, 'area', 'province', NULL, 'id,state,desc,asc,reorder,pinyin_first', NULL, 0, 0, '[0.012929916381836S]', 1, 1, 1634824271), (49, 'area', 'city', NULL, 'id,state,desc,reorder,province_id,asc,pinyin_first', NULL, 0, 0, '[0.020212888717651S]', 1, 1, 1634824271), (50, 'area', 'county', NULL, 'id,state,desc,reorder,city_id,asc,pinyin_first', NULL, 0, 0, '[0.017925977706909S]', 1, 1, 1634824271), (51, 'area', 'town', NULL, 'id,state,desc,reorder,county_id,asc,pinyin_first', NULL, 0, 0, '[0.012199878692627S]', 1, 1, 1634824271), (52, 'goods', 'coupon', NULL, 'state,desc,id,method,asc,cash', NULL, 0, 0, '[0.023277997970581S]', 1, 1, 1634825236), (53, 'shop', 'sell_order', NULL, 'state,desc,id,order_num,code,uid,cdate,status,shop_id,method,pay_method,mobile', NULL, 0, 0, '[0.061884164810181S]', 1, 1, 1634825445), (54, 'goods', 'info_category', NULL, 't_1.category_id,desc,t_2.reorder,t_2.id,info_id', NULL, 0, 0, '[0.028761863708496S]', 1, 1, 1634825457), (55, 'passport', 'profession', NULL, 'id,state,desc,reorder', NULL, 0, 0, '[0.036267042160034S]', 1, 1, 1634826133), (56, 'pay', 'account', NULL, 'id,state,desc,system_source,channel_id', NULL, 0, 0, '[0.021956920623779S]', 1, 1, 1634829077), (57, 'pay', 'order', NULL, 'order_id,id,state,desc,status,name', NULL, 0, 0, '[1.2725150585175S]', 1, 1, 1634829077), (58, 'pay', 'project', NULL, 'id,state,desc', NULL, 0, 0, '[0.031653881072998S]', 1, 1, 1634829077), (59, 'shop', 'sell_order_goods', NULL, 'state,order_id,desc,id,shop_id,status', 'order_id', 1, 0, '[0.022489070892334S]', 2, 1, 1634829077), (60, 'message', 'type', NULL, 'id,state,desc', NULL, 0, 0, '[0.02868914604187S]', 1, 1, 1634829077), (61, 'message', 'push', NULL, 'id,state,desc', NULL, 0, 0, '[0.032596111297607S]', 1, 1, 1634829077), (62, 'shop', 'buy_order', NULL, 'cdate,status,state,desc,id,shop_id,order_num,type,type_id,source_type,source_id,parent_order_id,operdate,fdate,refund_status', NULL, 0, 0, '[0.02432918548584S]', 1, 1, 1634882194), (63, 'main', 'help', NULL, 'state,desc,id,type', NULL, 0, 0, '[0.015724897384644S]', 1, 1, 1634884180), (64, 'main', 'config', NULL, 'id,state', NULL, 0, 0, '[0.014200925827026S]', 1, 1, 1634884181), (65, 'area', 'village', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.031183004379272S]', 1, 1, 1634884897), (66, 'poster', 'template', NULL, 'state,desc,id', NULL, 0, 0, '[0.033179998397827S]', 1, 1, 1634884911), (67, 'score', 'action', NULL, 'state,desc,id,key', NULL, 0, 0, '[0.022011995315552S]', 1, 1, 1634884914), (68, 'score', 'level_type', NULL, 'state,desc,reorder,id', 'reorder', 1, 0, '[0.030886888504028S]', 2, 1, 1634884917), (69, 'score', 'level', NULL, 'state,desc,level,id', 'level', 1, 0, '[0.034116983413696S]', 2, 1, 1634884917), (70, 'pay', 'channel', NULL, 'state,desc,id', NULL, 0, 0, '[0.033015012741089S]', 1, 1, 1634884919), (71, 'store', 'info', NULL, 'state,desc,reorder,id,city,status', NULL, 0, 0, '[0.018442869186401S]', 1, 1, 1634908397), (72, 'factory', 'info', NULL, 'state,desc,reorder,id,city,status', NULL, 0, 0, '[0.042900800704956S]', 1, 1, 1634908400), (73, 'passport', 'invoice', NULL, 'uid,state,desc,type,id', NULL, 0, 0, '[0.017876863479614S]', 1, 1, 1634911299), (74, 'shop', 'coupon', NULL, 'shop_id,city,state,desc,id,coupon_id,method', NULL, 0, 0, '[0.024301052093506S]', 1, 1, 1634913471), (75, 'passport', 'address', NULL, 'uid,state,desc,type,id', NULL, 0, 0, '[0.030328035354614S]', 1, 1, 1634954841), (76, 'shop', 'coupon_act_1', NULL, 'id,shop_id,state,desc,shop_coupon_id', NULL, 0, 0, '[0.032757997512817S]', 1, 1, 1635061399), (77, 'shop', 'user_share', NULL, 'state,status,uid,shop_id,act_id,id', NULL, 0, 0, '[0.02095890045166S]', 1, 1, 1635067677), (78, 'attr', 'cate', NULL, 'state,desc,reorder,id', NULL, 0, 0, '[0.034897089004517S]', 1, 1, 1635133517), (79, 'passport', 'user_system', NULL, 'state,uid,system_id', NULL, 0, 0, '[0.20745301246643S]', 1, 1, 1635146061), (80, 'score', 'action_log', NULL, 'id,action_id,desc', NULL, 0, 0, '[0.021633863449097S]', 1, 1, 1635146061), (81, 'score', 'rule', NULL, 'state,action_id,desc,id,config_id', NULL, 0, 0, '[0.022584915161133S]', 1, 1, 1635146061), (82, 'passport', 'avatar', NULL, 'state,desc,id', NULL, 0, 0, '[0.034768104553223S]', 1, 1, 1635150232), (83, 'goods', 'card', NULL, 'state,desc,id', NULL, 0, 0, '[0.020349025726318S]', 1, 1, 1635158709), (84, 'message', 'project', NULL, 'state,desc,id', NULL, 0, 0, '[0.037107944488525S]', 1, 1, 1635215796), (85, 'message', 'outbox', NULL, 'state,desc,id', NULL, 0, 0, '[0.033354997634888S]', 1, 1, 1635216031), (86, 'goods', 'info_attr_1', NULL, 'id', NULL, 0, 0, '[0.095905065536499S]', 1, 1, 1635236921), (87, 'goods', 'info_attr_4', NULL, 'id', NULL, 0, 0, '[0.042040109634399S]', 1, 1, 1635239648), (88, 'passport', 'code', NULL, 'mobile,day,state,desc,id', NULL, 0, 0, '[0.015817165374756S]', 1, 1, 1635313337), (89, 'goods', 'add_card', NULL, 'id', NULL, 0, 0, '[0.029009103775024S]', 1, 1, 1635313467), (90, 'shop', 'feedback', NULL, 'state,desc,id', NULL, 0, 0, '[0.037269830703735S]', 1, 1, 1635414326), (91, 'shop', 'sell_order_ps', NULL, 'state,order_id,id', NULL, 0, 0, '[0.021478891372681S]', 1, 1, 1635432734), (92, 'main', 'sell_config', NULL, 'id,state', NULL, 0, 0, '[0.015778779983521S]', 1, 1, 1635606464), (93, 'main', 'manage_config', NULL, 'id,state', NULL, 0, 0, '[0.016230821609497S]', 1, 1, 1635606465), (94, 'main', 'factory_config', NULL, 'id,state', NULL, 0, 0, '[0.016642808914185S]', 1, 1, 1635606466), (95, 'upload', 'cate', NULL, 'state,desc,id', NULL, 0, 0, '[0.03155517578125S]', 1, 1, 1635608843), (96, 'upload', 'file', NULL, 'state,desc,cdate,id', NULL, 0, 0, '[0.053497076034546S]', 1, 1, 1635608845), (97, 'shop', 'member', NULL, 'state,id,shop_id,mobile,desc', NULL, 0, 0, '[0.016899108886719S]', 1, 1, 1635666567), (98, 'category', 'project', NULL, 'id,state,desc,reorder', NULL, 0, 0, '[0.041908979415894S]', 1, 1, 1635671025), (99, 'shop', 'apply', NULL, 'state,desc,id,name,mobile,city', NULL, 0, 0, '[0.04826807975769S]', 1, 1, 1635686603), (100, 'shop', 'coupon_act', NULL, 'shop_id,act_id,state,desc,id', NULL, 0, 0, '[0.030133008956909S]', 1, 1, 1635910007), (101, 'shop', 'shop_cart', NULL, 'state,shop_id,goods_id,sku_id,desc,id', NULL, 0, 0, '[0.24695897102356S]', 1, 1, 1636034883), (102, 'shop', 'sell_order_refund', NULL, 'state,shop_id,order_id,order_goods_id,type,id,desc', NULL, 0, 0, '[0.039536952972412S]', 1, 1, 1636095872), (103, 'manage', 'cron', NULL, 'state,desc,id', NULL, 0, 0, '[0.031123161315918S]', 1, 1, 1636101641), (104, 'shop', 'sell_stat', NULL, 'state,desc,day,id,shop_id', NULL, 0, 0, '[0.037158966064453S]', 1, 1, 1636101891), (105, 'shop', 'sell_stat_month', NULL, 'month,state,desc,id,shop_id,type', NULL, 0, 0, '[0.018945932388306S]', 1, 1, 1636101950), (106, 'shop', 'buy_order_goods', NULL, 'state,order_id,desc,id,status,goods_id', 'order_id,status,goods_id', 1, 0, '[0.021275997161865S]', 2, 1, 1636115229), (107, 'shop', 'out_order', NULL, 'shop_id,state,desc,cdate,order_num,id,type,type_id,out_type,status', NULL, 0, 0, '[0.039420127868652S]', 1, 1, 1636187151), (108, 'shop', 'out_order_goods', NULL, 'state,order_id,desc,id', NULL, 0, 0, '[0.021195888519287S]', 1, 1, 1636187159), (109, 'shop', 'buy_order_refund', NULL, 'state,order_id,process,type,order_goods_id,id,desc', NULL, 0, 0, '[0.025911808013916S]', 1, 1, 1636195363), (110, 'shop', 'print', NULL, 'state,shop_id,desc,id,number', NULL, 0, 0, '[0.023906946182251S]', 1, 1, 1636205088), (111, 'factory', 'member', NULL, 'factory_id,state,desc,id,mobile,name', NULL, 0, 0, '[0.013099193572998S]', 1, 1, 1636430165), (112, 'factory', 'goods', NULL, 'factory_id,state,desc,id,goods_id,status,cdate', NULL, 0, 0, '[0.048555135726929S]', 1, 1, 1636430366), (113, 'factory', 'goods_sku', NULL, 'factory_id,goods_id,state,desc,id,sku_id,reorder', NULL, 0, 0, '[0.018685102462769S]', 1, 1, 1636430415), (114, 'store', 'goods', NULL, 'state,desc,id,store_id,goods_id,status', NULL, 0, 0, '[0.033815860748291S]', 1, 1, 1636437756), (115, 'store', 'goods_sku', NULL, 'store_id,goods_id,state,desc,id,sku_id,t_1.store_id,asc,t_2.reorder,t_2.id,t_2.price,t_2.status,t_2.state,t_1.state,t_2.name,t_1.total_num-t_1.sell_num', NULL, 0, 0, '[0.034118890762329S]', 1, 1, 1636437756), (116, 'manage', 'top', NULL, 'state,top_id,id', NULL, 0, 0, '[0.039458036422729S]', 1, 1, 1636448670), (117, 'shop', 'service', NULL, 'state,desc,id,type', NULL, 0, 0, '[0.020807981491089S]', 1, 1, 1636450620), (118, 'shop', 'buy_order_ps', NULL, 'id,state,order_id', 'order_id', 1, 0, '[0.020341873168945S]', 2, 1, 1636451532), (119, 'shop', 'store_stat_month', NULL, 'state,desc,month,id', NULL, 0, 0, '[0.040024995803833S]', 1, 1, 1636454207), (120, 'shop', 'buy_stat_month', NULL, 'type,state,desc,month,id', NULL, 0, 0, '[0.039886951446533S]', 1, 1, 1636454233), (121, 'shop', 'factory_stat_month', NULL, 'type,state,desc,month,id', NULL, 0, 0, '[0.039222955703735S]', 1, 1, 1636454269), (122, 'shop', 'store', NULL, 'state,shop_id,desc,id,store_id', 'shop_id', 1, 0, '[0.019929885864258S]', 2, 1, 1636465528), (123, 'shop', 'factory', NULL, 'state,shop_id,desc,id,factory_id', 'shop_id', 1, 0, '[0.017632961273193S]', 2, 1, 1636465528), (124, 'cash', 'shop', NULL, 'state,desc,id,shop_id,buy_order_id,type,order_num,day', '`desc`,shop_id,buy_order_id,order_num', 1, 0, '[0.027446031570435S]', 2, 1, 1636705857), (125, 'manage', 'log', NULL, 'state,desc,id', NULL, 0, 0, '[0.03895115852356S]', 1, 1, 1636725469), (126, 'cash', 'store', NULL, 'state,desc,day,id,store_id,store_status,type', NULL, 0, 0, '[0.018202066421509S]', 1, 1, 1637138467), (127, 'cash', 'factory', NULL, 'state,desc,day,id,factory_id,factory_status,type', NULL, 0, 0, '[0.018635034561157S]', 1, 1, 1637138468), (128, 'cash', 'order', NULL, 'state,desc,id,source_type,source_id,source_order_id,refund_id,jstype,order_num,type,type_id,status,audit,cdate,source_order_num,operdate', NULL, 0, 0, '[0.035700798034668S]', 1, 1, 1637138918), (129, 'shop', 'buy_stat', NULL, 'state,desc,day,id,area', NULL, 0, 0, '[0.038626909255981S]', 1, 1, 1637139422), (130, 'passport', 'stat', NULL, 'state,desc,day,id', NULL, 0, 0, '[0.044914960861206S]', 1, 1, 1637139941), (131, 'store', 'member', NULL, 'store_id,state,desc,id,mobile,name', NULL, 0, 0, '[0.019269943237305S]', 1, 1, 1637141235), (132, 'upload', 'pic_water', NULL, 'desc,id,state', NULL, 0, 0, '[0.028019189834595S]', 1, 1, 1637141989), (133, 'token', 'log', NULL, 'state,desc,id', NULL, 0, 0, '[0.031818151473999S]', 1, 1, 1637143401), (134, 'token', 'project', NULL, 'state,desc,id,type', NULL, 0, 0, '[0.032193899154663S]', 1, 1, 1637143402), (135, 'token', 'token', NULL, 'project_id,id', NULL, 0, 0, '[0.033852100372314S]', 1, 1, 1637203096), (136, 'goods', 'info_column', NULL, 'info_id', NULL, 0, 0, '[0.030336856842041S]', 1, 1, 1637243660), (137, 'goods', 'info_tag', NULL, 'info_id', NULL, 0, 0, '[0.032646894454956S]', 1, 1, 1637243660), (138, 'attr', 'search', NULL, 'info_id,state,desc,reorder,id', NULL, 0, 0, '[0.035758972167969S]', 1, 1, 1637289384), (139, 'goods', 'info_attr_13', NULL, 'id', NULL, 0, 0, '[0.049408912658691S]', 1, 1, 1637293009), (140, 'goods', 'info_attr_12', NULL, 'id', NULL, 0, 0, '[0.064369916915894S]', 1, 1, 1637293088), (141, 'goods', 'info_attr_12_17', NULL, 'id', NULL, 0, 0, '[0.070143938064575S]', 1, 1, 1637293282), (142, 'goods', 'info_attr_12_18', NULL, 'id', NULL, 0, 0, '[0.079226970672607S]', 1, 1, 1637299002), (143, 'wechat_applet', 'total_base', NULL, 'state,desc,id', NULL, 0, 0, '[0.035454034805298S]', 1, 1, 1637301199), (144, 'wechat_applet', 'msg', NULL, 'state,desc,id,project_id', NULL, 0, 0, '[0.03850793838501S]', 1, 1, 1637810133), (145, 'wechat_applet', 'msg_log', NULL, 'state,desc,id', NULL, 0, 0, '[0.036868095397949S]', 1, 1, 1637810140), (146, 'wechat_applet', 'msg_send', NULL, 'page,state,desc,id', NULL, 0, 0, '[0.035043954849243S]', 1, 1, 1637810141), (147, 'wechat_applet', 'subscribe', NULL, 'state,desc,id,project_id,template_id,cdate,key', NULL, 0, 0, '[0.041363954544067S]', 1, 1, 1637813875), (148, 'wechat_applet', 'subscribe_log', NULL, 'subscribe_id,touser,path,id,state,desc', NULL, 0, 0, '[0.034244060516357S]', 1, 1, 1637820516), (149, 'wechat_applet', 'subscribe_send', NULL, 'page,state,desc,id', NULL, 0, 0, '[0.035498857498169S]', 1, 1, 1637825658), (150, 'upload', 'yun', NULL, 'state,desc,id', NULL, 0, 0, '[0.032202005386353S]', 1, 1, 1637828015), (151, 'manage', 'admin_role', NULL, 'role_id,desc,id', NULL, 0, 0, '[0.019407987594604S]', 1, 1, 1638172051), (152, 'sms', 'config', NULL, 'state,desc,id', NULL, 0, 0, '[0.017199993133545S]', 1, 1, 1638238735), (153, 'sms', 'skin', NULL, 'config_id,state,desc,id,key', NULL, 0, 0, '[0.016633987426758S]', 1, 1, 1638238793), (154, 'sms', 'code', NULL, 'mobile,day,state,desc,id', NULL, 0, 0, '[0.017680168151855S]', 1, 1, 1638238827), (155, 'score', 'action_log_finish', NULL, 'action_id,desc,id', NULL, 0, 0, '[0.034898996353149S]', 1, 1, 1638265085), (156, 'shop', 'out_type', NULL, 'state,desc,id,type', NULL, 0, 0, '[0.038627147674561S]', 1, 1, 1638866142), (157, 'card', 'order', NULL, 'state,desc,id,order_num,cdate,uid,status', NULL, 0, 0, '[0.034497976303101S]', 1, 1, 1641294346), (158, 'card', 'info', NULL, 'state,desc,reorder,id,type_id,status', NULL, 0, 0, '[0.034421920776367S]', 1, 1, 1641294347), (159, 'card', 'type', NULL, 'state,desc,reorder,id,type', NULL, 0, 0, '[0.035923004150391S]', 1, 1, 1641294347), (160, 'card', 'code', NULL, 'uid,card_id,state,desc,id,dh_uid,ddate,card,status', NULL, 0, 0, '[0.018460988998413S]', 1, 1, 1641362420), (161, 'goods', 'info_attr_14', NULL, 'id', NULL, 0, 0, '[0.040608882904053S]', 1, 1, 1641362549), (162, 'goods', 'info_attr_15', NULL, 'id', NULL, 0, 0, '[0.042259931564331S]', 1, 1, 1641362581), (163, 'card', 'add', NULL, 'id', NULL, 0, 0, '[0.030070066452026S]', 1, 1, 1641367905), (164, 'card', 'order_ps', NULL, 'state,order_id,id', NULL, 0, 0, '[0.032845973968506S]', 1, 1, 1641379997), (165, 'card', 'order_card', NULL, 'state,order_id,desc,id', NULL, 0, 0, '[0.032490015029907S]', 1, 1, 1641379997), (166, 'goods', 'info_attr_23_24', NULL, 'id', NULL, 0, 0, '[0.048959970474243S]', 1, 1, 1641477714), (167, 'manage', 'help', NULL, 'state,desc,reorder,id,config', NULL, 0, 0, '[0.02072811126709S]', 1, 1, 1641643301); -- -------------------------------------------------------- -- -- 表的结构 `churen_message_type` -- DROP TABLE IF EXISTS `churen_message_type`; CREATE TABLE `churen_message_type` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(30) DEFAULT NULL COMMENT '类型名称-类型ID值为10以下则为系统消息', `scope` tinyint(1) NOT NULL DEFAULT '1' COMMENT '消息范围', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '同步推送', `push` int(11) NOT NULL DEFAULT '1' COMMENT '推送方式', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_message_type` -- INSERT INTO `churen_message_type` (`id`, `name`, `scope`, `type`, `push`, `state`, `cdate`) VALUES (1, '平台通知', 2, 1, 1, 1, 1634533941), (2, '订单通知', 1, 1, 1, 1, 1634704262), (3, '活动通知', 1, 1, 1, 1, 1636612763), (4, '优惠券通知', 1, 1, 1, 1, 1636612805), (5, '礼品卡通知', 1, 1, 1, 1, 1636612819), (6, '对账通知', 1, 1, 1, 1, 1636612884), (7, '入库订货单通知', 1, 1, 1, 1, 1637833458); -- -------------------------------------------------------- -- -- 表的结构 `churen_passport_system` -- DROP TABLE IF EXISTS `churen_passport_system`; CREATE TABLE `churen_passport_system` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(32) DEFAULT NULL COMMENT '项目名称', `appid` varchar(150) DEFAULT NULL COMMENT '微信小程序APPID', `secret` varchar(150) DEFAULT NULL COMMENT '微信小程序SECRET', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_passport_system` -- INSERT INTO `churen_passport_system` (`id`, `name`, `appid`, `secret`, `reorder`, `state`, `cdate`) VALUES (1, '默认项目', 'wx1d3d2cf9185a75e2', 'eefc0274bad7b03539bf66724d676f21', 1, 1, 1634207098), (2, '门店管理', 'wx0fb9702984cb3a8c', '09b3b697184ecf1016c845948f770820', 1, 1, 1641043298); -- -------------------------------------------------------- -- -- 表的结构 `churen_pay_account` -- DROP TABLE IF EXISTS `churen_pay_account`; CREATE TABLE `churen_pay_account` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(60) DEFAULT NULL COMMENT '账户名称', `type` varchar(30) DEFAULT NULL COMMENT '支付类型', `box` int(11) NOT NULL DEFAULT '1' COMMENT '支付环境-沙箱模式为支付时第三方平台不实际收费，测试环境为不拉取第三方支付', `system_source` tinyint(1) NOT NULL DEFAULT '1' COMMENT '支付平台', `channel_id` int(11) NOT NULL DEFAULT '1' COMMENT '所属渠道', `mchid` varchar(150) DEFAULT NULL COMMENT '商户号', `key` varchar(150) DEFAULT NULL COMMENT '密匙KEY', `appid` varchar(150) DEFAULT NULL COMMENT 'APPID', `appsecret` varchar(300) DEFAULT NULL COMMENT 'APPSECRET', `account` varchar(150) DEFAULT NULL COMMENT '支付账号', `private_key` text COMMENT '商户私钥-HTTPS://DOC.OPEN.ALIPAY.COM/DOC2/DETAIL.HTM?SPM=A219A.7629140.0.0.NBDXFY&TREEID=58&ARTICLEID=103242&DOCTYPE=1', `m_public_key` varchar(1000) DEFAULT NULL COMMENT '商户公钥-HTTPS://B.ALIPAY.COM/ORDER/PIDANDKEY.HTM', `public_key` varchar(1000) DEFAULT NULL COMMENT '支付宝公钥-HTTPS://B.ALIPAY.COM/ORDER/PIDANDKEY.HTM', `appCertPath` varchar(150) DEFAULT NULL COMMENT '支付宝APPCERTPATH', `alipayCertPath` varchar(150) DEFAULT NULL COMMENT '支付宝ALIPAYCERTPATH', `rootCertPath` varchar(150) DEFAULT NULL COMMENT '支付宝ROOTCERTPATH', `file_cert` varchar(150) DEFAULT NULL COMMENT '证书CERT文件-微信支付需要退款时使用', `file_key` varchar(150) DEFAULT NULL COMMENT '证书KEY文件-微信支付需要退款时使用', `timeout` int(11) NOT NULL DEFAULT '600' COMMENT '支付有效期-秒', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '申请时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_pay_account` -- INSERT INTO `churen_pay_account` (`id`, `name`, `type`, `box`, `system_source`, `channel_id`, `mchid`, `key`, `appid`, `appsecret`, `account`, `private_key`, `m_public_key`, `public_key`, `appCertPath`, `alipayCertPath`, `rootCertPath`, `file_cert`, `file_key`, `timeout`, `state`, `cdate`) VALUES (1, 'h5支付', 'wechat', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 600, 1, 1634534012), (2, '安卓支付', 'wechat', 1, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 600, 1, 1634534012), (3, '苹果支付', 'wechat', 1, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 600, 1, 1634534012), (4, '门店管理微信二维码支付', 'yspay', 1, 4, 1, '89810007372106N|DM098308|138K', 'wx1d3d2cf9185a75e2|8a81c1be7d3411ad017dfaba42770781|Ka6AnkXKMAM7MCzfiCWwa7EncNzQDa7jKYbHhxQrpRsnw2Ny', '8a81c1be7d3411ad017dfaba42770781', '08ce73bddcc14e4cb74434ccc184e194', '', '', '', '', '', '', '', '', '', 900, 1, 1634534012), (5, '门店零售微信小程序支付', 'yspay', 1, 5, 1, '89810007372106N|DM098308|138K', 'wx1d3d2cf9185a75e2|8a81c1be7d3411ad017dfaba42770781|Ka6AnkXKMAM7MCzfiCWwa7EncNzQDa7jKYbHhxQrpRsnw2Ny', '8a81c1be7d3411ad017dfaba42770781', '08ce73bddcc14e4cb74434ccc184e194', '', '', '', '', '', '', '', '', '', 900, 1, 1634534012), (6, '微信公众号支付', 'wechat', 1, 6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 600, 1, 1634534012), (7, '门店管理微信小程序支付', 'yspay', 1, 5, 1, '89810007372106N|DM098308|138K', 'wx0fb9702984cb3a8c|09b3b697184ecf1016c845948f770820|Ka6AnkXKMAM7MCzfiCWwa7EncNzQDa7jKYbHhxQrpRsnw2Ny', '8a81c1be7d3411ad017dfaba42770781', '08ce73bddcc14e4cb74434ccc184e194', '', '', '', '', '', '', '', '', '', 900, 1, 1641043415); -- -------------------------------------------------------- -- -- 表的结构 `churen_pay_channel` -- DROP TABLE IF EXISTS `churen_pay_channel`; CREATE TABLE `churen_pay_channel` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(60) DEFAULT NULL COMMENT '渠道名称', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '申请时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_pay_channel` -- INSERT INTO `churen_pay_channel` (`id`, `name`, `state`, `cdate`) VALUES (1, '官方渠道', 1, 1634534012); -- -------------------------------------------------------- -- -- 表的结构 `churen_pay_project` -- DROP TABLE IF EXISTS `churen_pay_project`; CREATE TABLE `churen_pay_project` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(60) DEFAULT NULL COMMENT '项目名称', `key` varchar(150) DEFAULT NULL COMMENT '密匙KEY', `notify` varchar(500) DEFAULT NULL COMMENT '支付完成回调接口', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '申请时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_pay_project` -- INSERT INTO `churen_pay_project` (`id`, `name`, `key`, `notify`, `state`, `cdate`) VALUES (1, '门店小程序购买商品', 'shop_dever_2020', 'shop/lib/sell.success', 1, 1634534016), (2, '门店采购', 'shop_buy_dever_2020', 'mshop/lib/buy.success', 1, 1635862727), (3, '购买礼品卡', 'card_buy_dever_2020', 'card/lib/buy.success', 1, 1641294856); -- -------------------------------------------------------- -- -- 表的结构 `churen_push_col` -- DROP TABLE IF EXISTS `churen_push_col`; CREATE TABLE `churen_push_col` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(32) DEFAULT NULL COMMENT '字段名称', `ename` varchar(32) DEFAULT NULL COMMENT '字段英文名称-用于前台使用', `desc` varchar(200) DEFAULT NULL COMMENT '字段描述', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型', `pic` varchar(20) DEFAULT NULL COMMENT '图片尺寸提醒-请直接输入尺寸，如100*100', `option` varchar(1000) DEFAULT NULL COMMENT '可选项-每行一个选项，多个直接换行', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_push_col` -- INSERT INTO `churen_push_col` (`id`, `name`, `ename`, `desc`, `type`, `pic`, `option`, `reorder`, `state`, `cdate`) VALUES (1, '标题', 'name', '标题', 1, NULL, NULL, 1, 1, 1634623998), (2, '图片', 'pic', '图片', 4, NULL, NULL, 1, 1, 1634623998), (3, '链接', 'link', '链接', 1, NULL, NULL, 1, 1, 1634623998), (4, '价格', 'price', '价格', 1, '', NULL, 1, 1, 1634624005), (5, '页面类型', 'page_type', '页面类型', 6, '', NULL, 1, 2, 1637763808); -- -------------------------------------------------------- -- -- 表的结构 `churen_push_func` -- DROP TABLE IF EXISTS `churen_push_func`; CREATE TABLE `churen_push_func` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(32) DEFAULT NULL COMMENT '功能名称', `api` varchar(200) DEFAULT NULL COMMENT '功能接口-可以直接输入HTTP接口地址，也可以使用DEVER接口，如果接口返回一条数据，就为单条，如果是多条，就是列表', `col` text COMMENT '关联字段', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '功能类型' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_push_func` -- INSERT INTO `churen_push_func` (`id`, `name`, `api`, `col`, `reorder`, `state`, `cdate`, `type`) VALUES (1, '商品', 'goods/info-one', 'W3sib3JkZXIiOiIxIiwibmFtZSI6Im5hbWUiLCJjb2xfaWQiOiIxIn0seyJvcmRlciI6IjIiLCJuYW1lIjoiY292ZXIiLCJjb2xfaWQiOiIyIn0seyJvcmRlciI6IjMiLCJuYW1lIjoicHJpY2UiLCJjb2xfaWQiOiI0In1d', 1, 1, 1634624038, 1), (2, '文章', 'content/news-one', 'W3sib3JkZXIiOiIxIiwibmFtZSI6Im5hbWUiLCJjb2xfaWQiOiIxIn0seyJvcmRlciI6IjIiLCJuYW1lIjoiY292ZXIiLCJjb2xfaWQiOiIyIn1d', 1, 1, 1634624054, 1), (3, '专题', 'content/feature-one', 'W3sib3JkZXIiOiIxIiwibmFtZSI6Im5hbWUiLCJjb2xfaWQiOiIxIn0seyJvcmRlciI6IjIiLCJuYW1lIjoiY292ZXIiLCJjb2xfaWQiOiIyIn1d', 1, 1, 1634624072, 1), (4, '活动', 'act/info-one', 'W3sib3JkZXIiOiIxIiwibmFtZSI6Im5hbWUiLCJjb2xfaWQiOiIxIn0seyJvcmRlciI6IjIiLCJuYW1lIjoiY292ZXIiLCJjb2xfaWQiOiIyIn1d', 1, 1, 1634624088, 1), (5, '自提页面', 'order', '[{\"order\":\"1\",\"name\":\"\",\"col_id\":\"-1\"}]', 1, 1, 1637805144, 2), (6, '购买礼品卡', 'buy_card', '[{\"order\":\"1\",\"name\":\"\",\"col_id\":\"-1\"}]', 1, 1, 1641366247, 2); -- -------------------------------------------------------- -- -- 表的结构 `churen_push_info` -- DROP TABLE IF EXISTS `churen_push_info`; CREATE TABLE `churen_push_info` ( `id` int(11) UNSIGNED NOT NULL COMMENT '推送位ID', `name` varchar(60) DEFAULT NULL COMMENT '推送位标题', `key` varchar(60) DEFAULT NULL COMMENT '推送位标识', `num` int(11) NOT NULL DEFAULT '10' COMMENT '数据显示条数-为空或小于0则取默认值10，只对前台有效，当有分页时，则为每页显示的条数', `func` varchar(300) DEFAULT NULL COMMENT '功能类型', `col` varchar(300) DEFAULT NULL COMMENT '启用的字段', `col_pic` varchar(500) DEFAULT NULL COMMENT '图片尺寸提醒-请直接输入提醒的文字即可，如100*100，如果有多个图片字段，请用换行隔开', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_push_info` -- INSERT INTO `churen_push_info` (`id`, `name`, `key`, `num`, `func`, `col`, `col_pic`, `reorder`, `state`, `cdate`) VALUES (1, '首页焦点图', 'home_focus', 5, '-1,6,5,4,3,2,1', '3,2,1', '', 1, 1, 1634624216), (2, '首页活动推荐', 'home_act', 3, '-1,6,5,4,3,2,1', '3,2,1', '', 1, 1, 1634624216), (3, '首页推荐商品', 'home_hot', 6, '1', '4,3,2,1', '', 1, 1, 1634624216), (4, '首页热门商品', 'home_top', 6, '1', '4,3,2,1', '', 1, 1, 1634624216), (5, '首页弹窗', 'home_alert', 1, '-1,6,5,4,3,2,1', '3,2,1', '', 1, 1, 1637147374), (6, '商品列表焦点图', 'list_banner', 5, '-1,6,5,4,3,2,1', '3,2,1', '', 1, 1, 1637147872); -- -------------------------------------------------------- -- -- 表的结构 `churen_score_config` -- DROP TABLE IF EXISTS `churen_score_config`; CREATE TABLE `churen_score_config` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(32) DEFAULT NULL COMMENT '积分名称', `type` int(11) NOT NULL DEFAULT '2' COMMENT '是否主积分-只能有一个主积分，主积分将作为用户主要积分显示在用户信息中', `callback_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '回调类型', `callback_value` varchar(800) DEFAULT NULL COMMENT '回调地址-积分增减成功后，将自动调取回调，会把USER_LOG表的数据传过去，如果代码中设置了回调，该回调将失效', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序(数值越大越靠前)', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_score_config` -- INSERT INTO `churen_score_config` (`id`, `name`, `type`, `callback_type`, `callback_value`, `reorder`, `state`, `cdate`) VALUES (1, '余额', 1, 1, '', 1, 1, 1634207515); -- -------------------------------------------------------- -- -- 表的结构 `churen_token_project` -- DROP TABLE IF EXISTS `churen_token_project`; CREATE TABLE `churen_token_project` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `name` varchar(60) DEFAULT NULL COMMENT '项目名称', `type` tinyint(11) NOT NULL DEFAULT '1' COMMENT '项目类型', `appid` varchar(150) DEFAULT NULL COMMENT 'APPID-一般为微信APPID、阿里的APPKEY', `secret` varchar(150) DEFAULT NULL COMMENT 'SECRET', `token` varchar(150) DEFAULT NULL COMMENT '通信TOKEN(注意不是ACCESS_TOKEN)', `key` varchar(150) DEFAULT NULL COMMENT '消息加解密密钥', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_token_project` -- INSERT INTO `churen_token_project` (`id`, `name`, `type`, `appid`, `secret`, `token`, `key`, `state`, `cdate`) VALUES (1, '门店零售', 3, 'wx1d3d2cf9185a75e2', 'eefc0274bad7b03539bf66724d676f21', '', '', 1, 1637143442), (2, '门店管理', 3, 'wx0fb9702984cb3a8c', '09b3b697184ecf1016c845948f770820', '', '', 1, 1637143456); -- -- 转储表的索引 -- -- -- 表的索引 `churen_main_config` -- ALTER TABLE `churen_main_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_main_factory_config` -- ALTER TABLE `churen_main_factory_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_main_manage_config` -- ALTER TABLE `churen_main_manage_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_main_sell_config` -- ALTER TABLE `churen_main_sell_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_cron` -- ALTER TABLE `churen_manage_cron` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_group` -- ALTER TABLE `churen_manage_group` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_menu` -- ALTER TABLE `churen_manage_menu` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_menu_group` -- ALTER TABLE `churen_manage_menu_group` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_notice` -- ALTER TABLE `churen_manage_notice` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_opt` -- ALTER TABLE `churen_manage_opt` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_message_type` -- ALTER TABLE `churen_message_type` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_passport_system` -- ALTER TABLE `churen_passport_system` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_pay_account` -- ALTER TABLE `churen_pay_account` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_pay_channel` -- ALTER TABLE `churen_pay_channel` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_pay_project` -- ALTER TABLE `churen_pay_project` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_push_col` -- ALTER TABLE `churen_push_col` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_push_func` -- ALTER TABLE `churen_push_func` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_push_info` -- ALTER TABLE `churen_push_info` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_score_config` -- ALTER TABLE `churen_score_config` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_token_project` -- ALTER TABLE `churen_token_project` ADD PRIMARY KEY (`id`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `churen_main_config` -- ALTER TABLE `churen_main_config` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '平台ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_main_factory_config` -- ALTER TABLE `churen_main_factory_config` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '平台ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_main_manage_config` -- ALTER TABLE `churen_main_manage_config` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '平台ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_main_sell_config` -- ALTER TABLE `churen_main_sell_config` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '平台ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_manage_cron` -- ALTER TABLE `churen_manage_cron` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=10; -- -- 使用表AUTO_INCREMENT `churen_manage_group` -- ALTER TABLE `churen_manage_group` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '组ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_manage_menu` -- ALTER TABLE `churen_manage_menu` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID', AUTO_INCREMENT=214; -- -- 使用表AUTO_INCREMENT `churen_manage_menu_group` -- ALTER TABLE `churen_manage_menu_group` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组ID', AUTO_INCREMENT=7; -- -- 使用表AUTO_INCREMENT `churen_manage_notice` -- ALTER TABLE `churen_manage_notice` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '公告ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_manage_opt` -- ALTER TABLE `churen_manage_opt` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=168; -- -- 使用表AUTO_INCREMENT `churen_message_type` -- ALTER TABLE `churen_message_type` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=8; -- -- 使用表AUTO_INCREMENT `churen_passport_system` -- ALTER TABLE `churen_passport_system` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3; -- -- 使用表AUTO_INCREMENT `churen_pay_account` -- ALTER TABLE `churen_pay_account` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=8; -- -- 使用表AUTO_INCREMENT `churen_pay_channel` -- ALTER TABLE `churen_pay_channel` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_pay_project` -- ALTER TABLE `churen_pay_project` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=4; -- -- 使用表AUTO_INCREMENT `churen_push_col` -- ALTER TABLE `churen_push_col` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=6; -- -- 使用表AUTO_INCREMENT `churen_push_func` -- ALTER TABLE `churen_push_func` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=7; -- -- 使用表AUTO_INCREMENT `churen_push_info` -- ALTER TABLE `churen_push_info` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '推送位ID', AUTO_INCREMENT=7; -- -- 使用表AUTO_INCREMENT `churen_score_config` -- ALTER TABLE `churen_score_config` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2; -- -- 使用表AUTO_INCREMENT `churen_token_project` -- ALTER TABLE `churen_token_project` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3; COMMIT; /*!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 */; -- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- 主机： web-mysql -- 生成日期： 2022-01-08 15:03:14 -- 服务器版本： 10.1.32-MariaDB -- PHP 版本： 7.3.22 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 数据库： `churen` -- CREATE DATABASE IF NOT EXISTS `churen` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; USE `churen`; -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_admin` -- DROP TABLE IF EXISTS `churen_manage_admin`; CREATE TABLE `churen_manage_admin` ( `id` int(11) UNSIGNED NOT NULL COMMENT '管理员ID', `username` varchar(24) DEFAULT NULL COMMENT '管理员名', `email` varchar(150) DEFAULT NULL COMMENT '邮箱-可用于登录，请准确填写，不允许重复', `mobile` varchar(32) DEFAULT NULL COMMENT '手机号', `password` varchar(64) DEFAULT NULL COMMENT '管理员密码', `config` int(11) NOT NULL DEFAULT '1' COMMENT '后台配置', `role` varchar(100) DEFAULT NULL COMMENT '角色', `group` int(11) NOT NULL DEFAULT '1' COMMENT '分组', `top` text COMMENT '头部菜单-这里的头部菜单如果设置，则会覆盖角色中的头部菜单', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '数据状态', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_admin` -- INSERT INTO `churen_manage_admin` (`id`, `username`, `email`, `mobile`, `password`, `config`, `role`, `group`, `top`, `state`, `status`, `cdate`) VALUES (1, 'admin@admin.com', 'admin@admin.com', NULL, '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1, '1', 1, NULL, 1, 1, 1634207045), (2, 'MENGYU', 'mengyu615@126.com', '18710005124', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1, '7,6,3', 1, '0', 1, 1, 1638172032); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_admin_role` -- DROP TABLE IF EXISTS `churen_manage_admin_role`; CREATE TABLE `churen_manage_admin_role` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员ID', `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色ID', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_admin_role` -- INSERT INTO `churen_manage_admin_role` (`id`, `admin_id`, `role_id`, `cdate`) VALUES (1, 1, 1, 1634207045), (17, 2, 7, 1638240226), (18, 2, 6, 1638240226), (19, 2, 3, 1638240226); -- -------------------------------------------------------- -- -- 表的结构 `churen_manage_role` -- DROP TABLE IF EXISTS `churen_manage_role`; CREATE TABLE `churen_manage_role` ( `id` int(11) UNSIGNED NOT NULL COMMENT '角色ID', `name` varchar(24) DEFAULT NULL COMMENT '角色名', `role_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级角色', `self` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否只能管理自己发布的内容-请在需要此项权限的表中增加[数据查询时影响的字段]', `col_select` varchar(30) DEFAULT NULL COMMENT '数据查询时影响的字段-该项影响数据查询，如果在表中增加该字段，则后台在查询数据时自动查询当前管理员的ID下的数据，多个用逗号隔开，与[是否只能管理自己发布的内容]相关', `col_insert` varchar(30) DEFAULT NULL COMMENT '数据插入时影响的字段-该项影响数据插入，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开', `col_update` varchar(30) DEFAULT NULL COMMENT '数据更新时影响的字段-该项影响数据更新，如果在表中增加该字段，则后台操作时自动为该字段赋值为当前管理员的ID，多个用逗号隔开', `oper` varchar(24) DEFAULT NULL COMMENT '操作权限', `auth` text COMMENT '左侧菜单', `top` text COMMENT '头部菜单', `auth_data` text COMMENT '数据权限', `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序-数值越大越靠前', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_manage_role` -- INSERT INTO `churen_manage_role` (`id`, `name`, `role_id`, `self`, `col_select`, `col_insert`, `col_update`, `oper`, `auth`, `top`, `auth_data`, `reorder`, `state`, `status`, `cdate`) VALUES (1, '系统管理员', -1, 2, 'admin', 'admin', 'admin', '1,2,3,4,5', 'all', NULL, NULL, 1, 1, 1, 1634207050), (2, '普通管理员', -1, 2, 'admin', 'admin', 'admin', '1,2,3,4,5', '', NULL, NULL, 1, 1, 1, 1634207050), (3, '仓库管理员', -1, 2, 'admin_founder', 'admin_founder', 'admin_editor', '1,2,3,4,5', '94,60,127,125', NULL, NULL, 1, 1, 1, 1638171716), (4, '工厂管理员', -1, 2, 'admin_founder', 'admin_founder', 'admin_editor', '1,2,3,4', '93,58,126,123', NULL, NULL, 1, 1, 1, 1638171778), (5, '门店管理员', -1, 2, 'admin_founder', 'admin_founder', 'admin_editor', '1,2,3,4,5', '92,64,95,84,119,124,137', NULL, NULL, 1, 1, 1, 1638171854), (6, '平台运营', -1, 2, 'admin_founder', 'admin_founder', 'admin_editor', '1,2,3,4,5', '92,64,95,94,60,93,58,56,175,178,34,33,66,31,176,174,72,55,54,62,85,164,163,162,18,84,98,99,119,127,124,137,126,123,125,120,118,128', NULL, NULL, 1, 1, 1, 1638171962), (7, '内容运营', -1, 2, 'admin_founder', 'admin_founder', 'admin_editor', '1,2,3,4,5', '77,51,87,88,194,195,52,89,50,91,90,97', NULL, NULL, 1, 1, 1, 1638171985); -- -- 转储表的索引 -- -- -- 表的索引 `churen_manage_admin` -- ALTER TABLE `churen_manage_admin` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_admin_role` -- ALTER TABLE `churen_manage_admin_role` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_manage_role` -- ALTER TABLE `churen_manage_role` ADD PRIMARY KEY (`id`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `churen_manage_admin` -- ALTER TABLE `churen_manage_admin` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员ID', AUTO_INCREMENT=3; -- -- 使用表AUTO_INCREMENT `churen_manage_admin_role` -- ALTER TABLE `churen_manage_admin_role` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=20; -- -- 使用表AUTO_INCREMENT `churen_manage_role` -- ALTER TABLE `churen_manage_role` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色ID', AUTO_INCREMENT=8; COMMIT; /*!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 */;