270 lines
21 KiB
SQL
270 lines
21 KiB
SQL
INSERT INTO `eb_system_config_tab` (`id`, `is_store`, `pid`, `title`, `eng_title`, `status`, `info`, `icon`, `type`, `sort`) VALUES
|
||
(NULL, 0, 0, '用户签到配置', 'user_sign_config', 1, 0, '', 0, 0);
|
||
|
||
SELECT `id` as tab1 FROM `eb_system_config_tab` WHERE `eng_title`='user_sign_config' LIMIT 1 into @tab1;
|
||
-- 签到配置
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(NULL, 0, 'sign_status', 'radio', 'input', @tab1, '1=>开启\n0=>关闭', 1, '', 0, 0, '1', '签到开关', '签到开关，商城是否开启签到功能，关闭后隐藏签到入口', 100, 1),
|
||
(NULL, 0, 'sign_mode', 'radio', 'input', @tab1, '-1=>无限制\n1=>周循环\n0=>月循环', 1, '', 0, 0, '\"-1\"', '签到模式', '无限制，累积和连续签到不会清零，周循环，每周一会清理累积和连续的记录为0，重新开启计算，月循环，每月一号会清理累积和连续的记录为0，重新开启计算', 95, 1),
|
||
(NULL, 0, 'sign_remind', 'radio', 'input', @tab1, '1=>开启\n0=>关闭', 1, '', 0, 0, '0', '签到提醒', '是否开启签到提醒，提醒方式为短信、站内信、小程序订阅消息', 90, 1),
|
||
(NULL, 0, 'sign_give_point', 'text', 'number', @tab1, '', 1, '', 0, 0, '10', '签到赠送积分', '签到赠送积分，每日签到赠送的积分值', 75, 1);
|
||
|
||
|
||
SELECT `id` as tab2 FROM `eb_system_config_tab` WHERE `eng_title`='point' LIMIT 1 into @tab2;
|
||
-- 积分配置
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(NULL, 0, 'integral_frozen', 'text', 'input', @tab2, '', 0, '', 100, 0, '\"0\"', '积分冻结(天)', '积分冻结(天)，0为不冻结', 0, 1);
|
||
|
||
-- 商品分类层级配置
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(null, 0, 'product_category_level', 'radio', 'input', 11, '0=>一级\n1=>二级\n2=>三级', 1, '', 0, 0, '1', '商品分类层级', '商城使用商品分类的层级数量（一级\二级\三级）', 90, 1);
|
||
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(NULL, 0, 'refund_time_available', 'text', 'input', 71, '', 1, '', 100, 0, '0', '售后期限', '订单收货之后，在多少天内可以进行退款，超出天数前端不显示退款按钮，设置0则永远显示', 0, 1);
|
||
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(NULL, 0, 'user_extract_max_price', 'text', 'input', 78, '', 0, 'required:true,number:true,min:0', 100, 0, '\"500\"', '提现最高金额', '用户提现最高金额限制', 0, 1);
|
||
|
||
INSERT INTO `eb_system_config` (`id`, `is_store`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES
|
||
(null, 0, 'user_extract_balance_status', 'radio', '', 78, '1=>开启\n0=>关闭', 1, '', 0, 0, '\"1\"', '提现至余额', '佣金转入用户余额', 0, 1);
|
||
|
||
DELETE FROM `eb_system_config` WHERE `menu_name` = 'store_printing_timing';
|
||
|
||
-- 关闭erp
|
||
UPDATE `eb_system_config` set `value` = 0 where `menu_name` = 'erp_open';
|
||
UPDATE `eb_system_config` set `info` = 'APPID', `desc` = '一号通->授权管理->应用管理：APPID' where `menu_name` = 'sms_account';
|
||
UPDATE `eb_system_config` set `info` = 'AppSecret' , `desc` = '一号通->授权管理->应用管理：AppSecret' where `menu_name` = 'sms_token';
|
||
|
||
-- 优惠券使用规则
|
||
ALTER TABLE `eb_store_coupon_issue` ADD `category` tinyint(1) NOT NULL DEFAULT '0' COMMENT '优惠券种类：1 普通券，2会员券' AFTER `cid`;
|
||
ALTER TABLE `eb_store_coupon_issue` ADD `rule` text CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '优惠券规则';
|
||
|
||
-- 定时任务
|
||
INSERT INTO `eb_system_timer` (`name`, `mark`, `type`, `title`, `is_open`, `cycle`, `last_execution_time`, `update_execution_time`, `is_del`, `add_time`) VALUES
|
||
('用户签到提醒', 'sign_remind_time', 4, '用户签到提醒', 1, '10/25', 0, 1705566366, 0, 1698377002);
|
||
|
||
INSERT INTO `eb_system_notification` (`id`, `mark`, `name`, `title`, `is_system`, `is_app`, `is_wechat`, `is_routine`, `is_sms`, `is_ent_wechat`, `system_title`, `system_text`, `app_id`, `wechat_id`, `routine_id`, `sms_id`, `ent_wechat_text`, `variable`, `url`, `type`, `add_time`) VALUES
|
||
(NULL, 'sign_remind_time', '签到提醒', '签到提醒', 1, 0, 0, 1, 1, 0, '签到提醒', '亲，{site_name}提醒您，今日记得签到并领取奖励哦～', 0, 0, '0', '980181', '', '', '', 1, 0);
|
||
|
||
-- 商品分类三级
|
||
ALTER TABLE `eb_store_product_category` ADD `path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '路径' AFTER `cate_name`;
|
||
ALTER TABLE `eb_store_product_category` ADD `level` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '等级' AFTER `path`;
|
||
ALTER TABLE `eb_store_product_category` ADD `adv_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告图片' AFTER `big_pic`;
|
||
ALTER TABLE `eb_store_product_category` ADD `adv_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '广告链接' AFTER `adv_pic`;
|
||
-- 修改历史分类level
|
||
UPDATE `eb_store_product_category` set `level` = 0 where `pid` = 0;
|
||
UPDATE `eb_store_product_category` set `level` = 1 where `pid` > 0;
|
||
-- 修改历史分类path
|
||
UPDATE `eb_store_product_category` set `path` = `pid` where `pid` > 0;
|
||
|
||
|
||
-- 增加表字段
|
||
ALTER TABLE `eb_user` ADD `sign_remind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '签到提醒状态' AFTER `sign_num`;
|
||
|
||
-- 增加表字段
|
||
ALTER TABLE `eb_user_sign` ADD `exp_num` int(11) NOT NULL DEFAULT '0' COMMENT '获得经验' AFTER `balance`;
|
||
ALTER TABLE `eb_user_sign` ADD `exp_balance` int(11) NOT NULL DEFAULT '0' COMMENT '剩余经验' AFTER `exp_num`;
|
||
|
||
|
||
-- 增加表字段
|
||
ALTER TABLE `eb_user_bill` ADD `frozen_time` int(12) NOT NULL DEFAULT '0' COMMENT '积分冻结时间';
|
||
|
||
-- 商品评分
|
||
ALTER TABLE `eb_store_product` ADD `star` DECIMAL(2,1) NOT NULL DEFAULT '3.0' COMMENT '商品评分' AFTER `sort`;
|
||
ALTER TABLE `eb_store_product` ADD `collect` int(10) NOT NULL DEFAULT '0' COMMENT '商品收藏数' AFTER `star`;
|
||
|
||
-- 售后申请
|
||
ALTER TABLE `eb_store_order_refund` ADD `apply_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '申请售后类型:1:仅退款2:退货退款(快递退回)3:退货退款(到店退货)4:平台退款' AFTER `supplier_id`;
|
||
UPDATE `eb_store_order_refund` set `apply_type` = `refund_type` where `refund_type` in (1,2);
|
||
ALTER TABLE `eb_store_order_refund` ADD `apply_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '申请退款金额' AFTER `apply_type`;
|
||
UPDATE `eb_store_order_refund` set `apply_price` = `refund_price`;
|
||
ALTER TABLE `eb_store_order_refund` ADD `refund_goods_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '退货方式1:不退货2:快递退回3:到店退货' AFTER `refund_reason`;
|
||
UPDATE `eb_store_order_refund` set `refund_goods_type` = `apply_type` where `apply_type` in (1,2);
|
||
ALTER TABLE `eb_store_order_refund` CHANGE `refund_type` `refund_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '退款处理类型0:未处理3：拒绝4：同意退货5：已退货6：已退款';
|
||
|
||
-- 订单表增加积分字段
|
||
ALTER TABLE `eb_store_order` ADD `pay_integral` INT(10) NOT NULL DEFAULT '0' COMMENT '实际支付积分' AFTER `pay_postage`;
|
||
ALTER TABLE `eb_store_order` ADD `change_price` DECIMAL(8,2) NOT NULL DEFAULT '0.00' COMMENT '改价优惠金额' AFTER `first_order_price`;
|
||
ALTER TABLE `eb_store_order` ADD `kuaidi_task_id` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '商家寄件任务ID' AFTER `erp_order_id`;
|
||
ALTER TABLE `eb_store_order` ADD `kuaidi_order_id` INT(10) NOT NULL DEFAULT '0' COMMENT '商家寄件订单编号' AFTER `kuaidi_task_id`;
|
||
ALTER TABLE `eb_store_order` ADD `is_stock_up` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否商家寄件 1：是；0 否' AFTER `kuaidi_order_id`;
|
||
|
||
ALTER TABLE `eb_store_order` CHANGE `virtual_info` `virtual_info` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '虚拟商品信息';
|
||
|
||
ALTER TABLE `eb_store_order` MODIFY column `clerk_id` int(11) NOT NULL DEFAULT '0' COMMENT '店员/管理员uid';
|
||
|
||
ALTER TABLE `eb_system_user_level` ADD `color` varchar(32) NOT NULL DEFAULT '' COMMENT ' 字体颜色' AFTER `image`;
|
||
|
||
-- 增加评价分数标签
|
||
ALTER TABLE `eb_store_product_reply` ADD `reply_score` TINYINT(1) NOT NULL DEFAULT '3' COMMENT '评价分数:3赞2中1差' AFTER `reply_type`;
|
||
-- 增加物流评分
|
||
ALTER TABLE `eb_store_product_reply` ADD `delivery_score` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '物流评分' AFTER `service_score`;
|
||
UPDATE `eb_store_product_reply` set `delivery_score` = 5;
|
||
|
||
-- 用户开票表
|
||
ALTER TABLE `eb_store_order_invoice` CHANGE `is_invoice` `is_invoice` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0：未开票 1:已开票 -1:已拒绝';
|
||
|
||
-- 分销员等级表
|
||
ALTER TABLE `eb_agent_level` ADD `color` varchar(32) NOT NULL DEFAULT '' COMMENT ' 字体颜色' AFTER `image`;
|
||
|
||
|
||
DELETE FROM `eb_page_link` where `url` LIKE '/pages/columnGoods/HotNewGoods/index%';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/activity/points_mall/index', `param` = '/pages/activity/points_mall/index' where `url` = '/pages/points_mall/index';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/activity/coupon/index', `param` = '/pages/activity/coupon/index' where `url` = '/pages/users/user_get_coupon/index';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/activity/new_customer/index', `param` = '/pages/activity/new_customer/index' where `url` = '/pages/store/newcomers/index';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/goods/order_list/index?type=4', `param` = '/pages/goods/order_list/index?type=4' where `url` = '/pages/points_mall/exchange_record';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/users/user_vip/index', `param` = '/pages/users/user_vip/index' where `url` = '/pages/annex/vip_grade/index';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/goods/goods_list/index?promotions_type=1', `param` = '/pages/goods/goods_list/index?promotions_type=1' where `url` = '/pages/activity/discount/index?promotions_type=1';
|
||
UPDATE `eb_page_link` set `url` = '/pages/goods/goods_list/index?promotions_type=2', `param` = '/pages/goods/goods_list/index?promotions_type=2' where `url` = '/pages/activity/discount/index?promotions_type=2';
|
||
UPDATE `eb_page_link` set `url` = '/pages/goods/goods_list/index?promotions_type=3', `param` = '/pages/goods/goods_list/index?promotions_type=3' where `url` = '/pages/activity/discount/index?promotions_type=3';
|
||
UPDATE `eb_page_link` set `url` = '/pages/goods/goods_list/index?promotions_type=4', `param` = '/pages/goods/goods_list/index?promotions_type=4' where `url` = '/pages/activity/discount/index?promotions_type=4';
|
||
|
||
UPDATE `eb_page_link` set `url` = '/pages/store_list/index', `param` = '/pages/store_list/index' where `url` = '/pages/store_cate/store_cate';
|
||
|
||
INSERT INTO `eb_page_link` (`id`, `cate_id`, `type`, `name`, `url`, `param`, `example`, `status`, `sort`, `add_time`) VALUES
|
||
(NULL, 6, 8, '搭配套餐列表', '/pages/goods/match_pay/index', ' ', '/pages/goods/match_pay/index', 1, 0, 1626837579);
|
||
|
||
-- 会员权益
|
||
ALTER TABLE `eb_member_right` ADD `content` LONGTEXT NULL DEFAULT NULL COMMENT '权益内容' AFTER `explain`;
|
||
|
||
-- 文章管理表
|
||
ALTER TABLE `eb_article` ADD `likes` INT(10) NOT NULL DEFAULT '0' COMMENT '点赞量' AFTER `visit`;
|
||
|
||
-- 商品点赞和收藏表
|
||
ALTER TABLE `eb_user_relation` CHANGE `category` `category` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '某种类型的商品(普通商品、秒杀商品、文章)';
|
||
|
||
ALTER TABLE `eb_store_product_label` ADD `style_type` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '样式类型1：自定义2：图片' AFTER `label_name`;
|
||
ALTER TABLE `eb_store_product_label` ADD `color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '颜色' AFTER `style_type`;
|
||
ALTER TABLE `eb_store_product_label` ADD `bg_color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景颜色' AFTER `color`;
|
||
ALTER TABLE `eb_store_product_label` ADD `border_color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '边框颜色' AFTER `bg_color`;
|
||
ALTER TABLE `eb_store_product_label` ADD `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图标' AFTER `border_color`;
|
||
ALTER TABLE `eb_store_product_label` ADD `is_show` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '移动端是否展示' AFTER `icon`;
|
||
ALTER TABLE `eb_store_product_label` ADD `status` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '状态是否开启' AFTER `is_show`;
|
||
|
||
-- 付费会员表
|
||
ALTER TABLE `eb_member_ship` ADD `is_label` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '特惠标签' AFTER `pre_price`;
|
||
|
||
-- 模板/订阅消息
|
||
SELECT `id` as sn1 FROM `eb_system_notification` WHERE `mark`='sign_remind_time' LIMIT 1 into @sn1;
|
||
INSERT INTO `eb_template_message` (`id`, `notification_id`, `type`, `tempkey`, `name`, `kid`, `content`, `example`, `tempid`, `add_time`, `status`) VALUES
|
||
(null, @sn1, 0, '25599', '签到提醒', '', '活动名称{{thing3.DATA}}\r\n温馨提示{{thing2.DATA}}', '', '', '1705458018', 1);
|
||
|
||
-- 分类
|
||
ALTER TABLE `eb_category` ADD `integral_min` int(10) NOT NULL DEFAULT '0' COMMENT '积分分类最低';
|
||
ALTER TABLE `eb_category` ADD `integral_max` int(10) NOT NULL DEFAULT '0' COMMENT '积分分类最高';
|
||
|
||
UPDATE `eb_system_config` set `desc` = '一号通的登录账号' WHERE `menu_name` = 'sms_account';
|
||
|
||
-- 门店
|
||
ALTER TABLE `eb_system_store` ADD `background_image` varchar(255) NOT NULL DEFAULT '' COMMENT '门店背景图' AFTER `image`;
|
||
ALTER TABLE `eb_system_store` COMMENT='门店';
|
||
|
||
ALTER TABLE `eb_store_integral` ADD `postage` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '邮费' AFTER `freight`;
|
||
ALTER TABLE `eb_store_integral` ADD `temp_id` INT(10) NOT NULL DEFAULT '0' COMMENT '运费模板ID' AFTER `postage`;
|
||
|
||
--
|
||
-- 表的结构 `eb_system_sign_reward`
|
||
--
|
||
|
||
CREATE TABLE IF NOT EXISTS `eb_system_sign_reward` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型，0连续签到奖励，1累计签到奖励',
|
||
`days` int(11) NOT NULL DEFAULT '0' COMMENT '天数',
|
||
`point` int(11) NOT NULL DEFAULT '0' COMMENT '赠送积分',
|
||
`exp` int(11) NOT NULL DEFAULT '0' COMMENT '赠送经验',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统签到奖励表';
|
||
|
||
--
|
||
-- 表的结构 `eb_store_product_words`
|
||
--
|
||
CREATE TABLE IF NOT EXISTS `eb_store_product_words` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台2:供应商',
|
||
`relation_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店、供应商id',
|
||
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '词',
|
||
`color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '颜色',
|
||
`bg_color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景颜色',
|
||
`border_color` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '边框颜色',
|
||
`icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图标',
|
||
`is_show` tinyint(1) NULL DEFAULT 0 COMMENT '是否显示',
|
||
`sort` smallint(11) NULL DEFAULT 0 COMMENT '排序',
|
||
`is_search` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '大家都在搜',
|
||
`is_hot` tinyint(1) NULL DEFAULT 0 COMMENT '热词',
|
||
`is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT='商品搜索热词';
|
||
|
||
|
||
|
||
-- 对外接口账号表
|
||
ALTER TABLE eb_out_account
|
||
ADD COLUMN `rules` text NULL DEFAULT NULL COMMENT '权限' AFTER `status`,
|
||
ADD COLUMN `push_open` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推送',
|
||
ADD COLUMN `push_account` varchar(255) NOT NULL COMMENT '推送账号',
|
||
ADD COLUMN `push_password` varchar(255) NOT NULL COMMENT '推送密码',
|
||
ADD COLUMN `push_token_url` varchar(255) NOT NULL COMMENT '获取推送token接口',
|
||
ADD COLUMN `user_update_push` varchar(255) NOT NULL COMMENT '用户推送接口',
|
||
ADD COLUMN `order_create_push` varchar(255) NOT NULL DEFAULT '' COMMENT '订单创建推送接口',
|
||
ADD COLUMN `order_pay_push` varchar(255) NOT NULL DEFAULT '' COMMENT '订单支付推送接口',
|
||
ADD COLUMN `refund_create_push` varchar(255) NOT NULL DEFAULT '' COMMENT '售后订单创建推送接口',
|
||
ADD COLUMN `refund_cancel_push` varchar(255) NOT NULL DEFAULT '' COMMENT '售后订单取消推送接口';
|
||
|
||
--
|
||
-- 表的结构 `eb_out_interface`
|
||
--
|
||
|
||
CREATE TABLE IF NOT EXISTS `eb_out_interface` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
||
`pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级pid',
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0菜单，1接口',
|
||
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '接口名称',
|
||
`describe` text NULL DEFAULT NULL COMMENT '功能描述',
|
||
`method` varchar(255) NOT NULL DEFAULT '' COMMENT '接口类型',
|
||
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '接口地址',
|
||
`request_params` LONGTEXT NULL DEFAULT NULL COMMENT '请求参数',
|
||
`return_params` LONGTEXT NULL DEFAULT NULL COMMENT '返回参数',
|
||
`request_example` LONGTEXT NULL DEFAULT NULL COMMENT '请求示例',
|
||
`return_example` LONGTEXT NULL DEFAULT NULL COMMENT '返回示例',
|
||
`error_code` LONGTEXT NULL DEFAULT NULL COMMENT '错误返回',
|
||
`is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='对外接口';
|
||
|
||
|
||
CREATE TABLE IF NOT EXISTS `eb_system_printer` (
|
||
`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
||
`type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '类型：0平台1:门店2:供应商' ,
|
||
`relation_id` INT(10) NOT NULL DEFAULT '0' COMMENT '门店、供应商id' ,
|
||
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '打印机名称' ,
|
||
`plat_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '打印机类型：1：易联运，2：飞蛾云' ,
|
||
`print_event` varchar (255) NOT NULL DEFAULT '2' COMMENT '打印事件1：下单后2：支付后' ,
|
||
`print_num` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '打印联数' ,
|
||
`status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '打印机状态' ,
|
||
`add_time` INT(10) NOT NULL DEFAULT '0' COMMENT '创建时间' ,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打印机';
|
||
|
||
-- 关联打印机ID
|
||
ALTER TABLE `eb_store_config` ADD `print_id` INT(10) NOT NULL DEFAULT '0' COMMENT '关联打印机ID' AFTER `id`;
|
||
|
||
|
||
ALTER TABLE `eb_store_product_attr_value` CHANGE `suk` `suk` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品属性索引值 (attr_value|attr_value[|....])';
|
||
|
||
DELETE FROM `eb_system_group` where `config_name` = 'routine_my_menus';
|
||
|
||
INSERT INTO `eb_system_group` (`id`, `cate_id`, `name`, `info`, `config_name`, `fields`) VALUES
|
||
(54, 0, '个人中心菜单', '个人中心菜单', 'routine_my_menus', '[{\"name\":\"\\u83dc\\u5355\\u540d\",\"title\":\"name\",\"type\":\"input\",\"param\":\"\"},{\"name\":\"\\u56fe\\u6807(48*48)\",\"title\":\"pic\",\"type\":\"upload\",\"param\":\"\"},{\"name\":\"\\u8df3\\u8f6c\\u8def\\u5f84\",\"title\":\"url\",\"type\":\"input\",\"param\":\"\"},{\"name\":\"\\u83dc\\u5355\",\"title\":\"type\",\"type\":\"radio\",\"param\":\"1=>\\u6211\\u7684\\u670d\\u52a1\\n2=>\\u5e73\\u53f0\\u7ba1\\u7406\\n3=>\\u95e8\\u5e97\\u7ba1\\u7406\"}]');
|
||
|
||
INSERT INTO `eb_system_group_data` (`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES
|
||
(null, @tabId, '{\"name\":{\"type\":\"input\",\"value\":\"\\u914d\\u9001\\u5458\"},\"pic\":{\"type\":\"upload\",\"value\":\"\\/uploads\\/system\\/0a73f202109230908134790.png\"},\"url\":{\"type\":\"input\",\"value\":\"\\/pages\\/admin\\/distribution\\/index\"},\"type\":{\"type\":\"radio\",\"value\":\"3\"}}', 1634803318, 3, 1),
|
||
(null, @tabId, '{\"name\":{\"type\":\"input\",\"value\":\"\\\\u95e8\\\\u5e97\\\\u4e2d\\\\u5fc3\"},\"pic\":{\"type\":\"upload\",\"value\":\"\\/uploads\\/system\\/5379f202109230908215868.png\"},\"url\":{\"type\":\"input\",\"value\":\"\\/pages\\/admin\\/work\\/store\"},\"type\":{\"type\":\"radio\",\"value\":\"3\"}}', 1634803318, 4, 1),
|
||
(null, @tabId, '{\"name\":{\"type\":\"input\",\"value\":\"\\\\u5e97\\\\u5458\\\\u63a8\\\\u5e7f\\\\u7801\"},\"pic\":{\"type\":\"upload\",\"value\":\"\\/uploads\\/system\\/store_spread.png\"},\"url\":{\"type\":\"input\",\"value\":\"\\/pages\\/store_spread\\/index\"},\"type\":{\"type\":\"radio\",\"value\":\"3\"}}', 1631500428, 4, 1);
|