baseXX/update.sql

--
-- 转存表中的数据 `eb_wechat_template` 修改数据
--
UPDATE `eb_wechat_template` SET `tempkey` = 'OPENTM415437052',`name` = '账户资金变动提醒',`content` = '{{first.DATA}}\n交易类型：{{keyword1.DATA}}\n交易金额：{{keyword2.DATA}}\n交易时间：{{keyword3.DATA}}\n账户余额：{{keyword4.DATA}}\n{{remark.DATA}}' WHERE `id` = 6;
--
-- 转存表中的数据 `eb_special_task` 修改数据表
--
ALTER TABLE `eb_special_task` ADD COLUMN `pid` int(12) DEFAULT '0' COMMENT '素材分类';
--
-- 转存表中的数据 `eb_lecturer` 修改数据表
--
ALTER TABLE `eb_lecturer` ADD COLUMN `explain` varchar(255)  DEFAULT '' COMMENT '讲师说明';

--
-- 转存表中的数据 `eb_user` 修改数据表
--
ALTER TABLE `eb_user` ADD COLUMN `member_time` int(11) unsigned DEFAULT '0' COMMENT '成为会员时间';

--
-- 转存表中的数据 `eb_system_menus` 新增数据
--
INSERT INTO `eb_system_menus` (`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES
(685, 482, '', '素材管理', 'admin', '', '', '[]', 0, 1, 1),
(686, 685, '', '素材分类', 'admin', 'special.specialTaskCategory', 'index', '[]', 0, 1, 1),
(687, 685, '', '素材列表', 'admin', 'special.SpecialType', 'sources_index', '[]', 0, 1, 1),
(688, 687, '', '创建编辑素材', 'admin', 'special.SpecialType', 'addSources', '[]', 0, 0, 1),
(689, 687, '', '保存素材', 'admin', 'special.SpecialType', 'save_source', '[]', 0, 0, 1),
(690, 687, '', '删除素材', 'admin', 'special.SpecialType', 'delete', '[]', 0, 0, 1),
(691, 686, '', '编辑素材分类', 'admin', 'special.specialTaskCategory', 'create', '[]', 0, 0, 1),
(692, 686, '', '保存素材分类', 'admin', 'special.specialTaskCategory', 'save', '[]', 0, 0, 1),
(693, 686, '', '删除素材分类', 'admin', 'special.specialTaskCategory', 'delete', '[]', 0, 0, 1),
(694, 399, '', '商品订单', 'admin', 'order.storeOrder', 'productOrder', '[]', 2, 1, 1),
(695, 399, '', '会员订单', 'admin', 'order.storeOrder', 'memberOrder', '[]', 1, 1, 1),
(696, 507, '', '底部菜单', 'admin', 'setting.systemGroupData', 'index', '{\"gid\":\"70\"}', 2, 1, 1),
(697, 286, '', '拼团管理', 'admin', '', '', '[]', 3, 1, 1),
(698, 337, '', '提现配置', 'admin', '', '', '[]', 0, 1, 1),
(699, 0, 'th', '系统管理', 'admin', '', '', '[]', 9, 1, 1);

--
-- 转存表中的数据 `eb_system_menus` 修改数据
--
UPDATE `eb_system_menus` SET `params` = '{\"tab_id\":\"1\",\"type\":\"0\"}',`pid`=699 WHERE `id` = 6;
UPDATE `eb_system_menus` SET `menu_name` = '课程管理',`sort`=20 WHERE `id` = 482;
UPDATE `eb_system_menus` SET `menu_name` = '讲师管理',`sort`=19 WHERE `id` = 544;
UPDATE `eb_system_menus` SET `menu_name` = '直播管理',`sort`=18 WHERE `id` = 513;
UPDATE `eb_system_menus` SET `menu_name` = '实物商品',`sort`=17 WHERE `id` = 530;
UPDATE `eb_system_menus` SET `menu_name` = '订单中心',`sort`=16 WHERE `id` = 399;
UPDATE `eb_system_menus` SET `menu_name` = '用户管理',`sort`=15 WHERE `id` = 151;
UPDATE `eb_system_menus` SET `menu_name` = '营销中心',`sort`=14 WHERE `id` = 286;
UPDATE `eb_system_menus` SET `menu_name` = '新闻资讯',`sort`=13 WHERE `id` = 417;
UPDATE `eb_system_menus` SET `menu_name` = '财务管理',`sort`=12 WHERE `id` = 287;
UPDATE `eb_system_menus` SET `menu_name` = '系统设置',`sort`=2 WHERE `id` = 289;
UPDATE `eb_system_menus` SET `menu_name` = '系统维护',`sort`=1 WHERE `id` = 21;
UPDATE `eb_system_menus` SET `sort`=11 WHERE `id` = 11;
UPDATE `eb_system_menus` SET `sort`=2 WHERE `id` = 289;
UPDATE `eb_system_menus` SET `sort`=1 WHERE `id` = 21;
UPDATE `eb_system_menus` SET `menu_name` = '课程分类',`sort`=3,`pid`=482 WHERE `id` = 429;
UPDATE `eb_system_menus` SET `sort`=3,`pid`=482 WHERE `id` = 430;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 428;
UPDATE `eb_system_menus` SET `menu_name` = '专题管理',`sort`=2 WHERE `id` = 485;
UPDATE `eb_system_menus` SET `menu_name` = '视频专题',`sort`=2 WHERE `id` = 520;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 521;
UPDATE `eb_system_menus` SET `menu_name` = '音频专题',`sort`=3,`pid`=485 WHERE `id` = 522;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 523;
UPDATE `eb_system_menus` SET `menu_name` = '图文专题',`sort`=4,`pid`=485 WHERE `id` = 524;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 525;
UPDATE `eb_system_menus` SET `menu_name` = '专栏专题',`sort`=1,`pid`=485 WHERE `id` = 488;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 484;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 483;
UPDATE `eb_system_menus` SET `menu_name` = '课程订单',`sort`=3 WHERE `id` = 400;
UPDATE `eb_system_menus` SET `menu_name` = '用户管理',`sort`=2 WHERE `id` = 177;
UPDATE `eb_system_menus` SET `sort`=1 WHERE `id` = 493;
UPDATE `eb_system_menus` SET `menu_name` = '付费会员',`sort`=5 WHERE `id` = 491;
UPDATE `eb_system_menus` SET `sort`=4 WHERE `id` = 490;
UPDATE `eb_system_menus` SET `sort`=3 WHERE `id` = 492;
UPDATE `eb_system_menus` SET `sort`=2 WHERE `id` = 505;
UPDATE `eb_system_menus` SET `sort`=1 WHERE `id` = 506;
UPDATE `eb_system_menus` SET `menu_name` = '分销管理',`sort`=4,`pid`=286, `icon`='' WHERE `id` = 337;
UPDATE `eb_system_menus` SET `sort`=2,`pid`=697 WHERE `id` = 379;
UPDATE `eb_system_menus` SET `menu_name` = '拼团弹幕',`sort`=1,`pid`=697 WHERE `id` = 423;
UPDATE `eb_system_menus` SET `menu_name` = '分销列表',`pid`=337 WHERE `id` = 421;
UPDATE `eb_system_menus` SET `sort`=2,`pid`=698 WHERE `id` = 433;
UPDATE `eb_system_menus` SET `sort`=1,`pid`=698 WHERE `id` = 496;
UPDATE `eb_system_menus` SET `sort`=3,`pid`=699 WHERE `id` = 507;
UPDATE `eb_system_menus` SET `is_show`=0 WHERE `id` = 508;
UPDATE `eb_system_menus` SET `menu_name` = '注册登录协议' WHERE `id` = 435;
UPDATE `eb_system_menus` SET `menu_name` = '其他设置',`sort`=2,`pid`=699 WHERE `id` = 502;
UPDATE `eb_system_menus` SET `sort`=1,`pid`=699 WHERE `id` = 175;
UPDATE `eb_system_menus` SET `menu_name` = '首页活动' WHERE `id` = 432;
UPDATE `eb_system_menus` SET `menu_name` = '热门推荐' WHERE `id` = 409;
UPDATE `eb_system_menus` SET `menu_name` = '商品轮播图',`sort`=1,`pid`=507 WHERE `id` = 534;
UPDATE `eb_system_menus` SET `menu_name` = '礼物设置' WHERE `id` = 536;
UPDATE `eb_system_menus` SET `sort`=2 WHERE `id` = 527;
UPDATE `eb_system_menus` SET `sort`=1 WHERE `id` = 519;
UPDATE `eb_system_menus` SET `menu_name` = '商品分类',`sort`=2 WHERE `id` = 532;
UPDATE `eb_system_menus` SET `menu_name` = '商品管理',`sort`=1 WHERE `id` = 531;
UPDATE `eb_system_menus` SET `menu_name` = '模板消息' WHERE `id` = 174;
UPDATE `eb_system_menus` SET `sort`=3 WHERE `id` = 434;
UPDATE `eb_system_menus` SET `sort`=2 WHERE `id` = 435;
UPDATE `eb_system_menus` SET `sort`=1 WHERE `id` = 420;
UPDATE `eb_system_menus` SET `controller`='',`action`='' WHERE `id` = 1;

--
-- 转存表中的数据 `eb_system_config` 配置分类中内容移动
--
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 4;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 5;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 6;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 7;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 35;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 57;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 95;
UPDATE `eb_system_config` SET `config_tab_id` = 1 WHERE `id` = 154;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 155;
UPDATE `eb_system_config` SET `config_tab_id` = 1 WHERE `id` = 168;
UPDATE `eb_system_config` SET `config_tab_id` = 23 WHERE `id` = 179;
UPDATE `eb_system_config` SET `config_tab_id` = 1 WHERE `id` = 180;
UPDATE `eb_system_config` SET `config_tab_id` = 1 WHERE `id` = 181;
UPDATE `eb_system_config` SET `config_tab_id` = 16 WHERE `id` = 188;
UPDATE `eb_system_config` SET `config_tab_id` = 22 WHERE `id` = 77;
UPDATE `eb_system_config` SET `status` = 2 WHERE `id` = 146;

--
-- 转存表中的数据 `eb_system_config_tab` 修改数据
--
UPDATE `eb_system_config_tab` SET  `type` = 0 WHERE `id` = 22;
--
-- 转存表中的数据 `eb_system_config_tab` 修改数据
--
UPDATE `eb_system_config_content` SET  `title` = '注册登录协议' WHERE `id` = 2;

--
-- 转存表中的数据 `eb_special_task_category`
--
CREATE TABLE `eb_special_task_category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pid` int(10) DEFAULT NULL COMMENT '上级ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '分类标题',
  `sort` int(10) DEFAULT '0' COMMENT '排序',
  `is_del` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `add_time` int(50) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='素材分类';

--
-- 转存表中的数据 `eb_special_task_category`
--
INSERT INTO `eb_special_task_category` (`id`, `pid`, `title`, `sort`, `is_del`,`add_time`) VALUES
(1, 0, '图文', 0, 0, 1612496006),
(2, 0, '音频', 0, 0, 1612496017),
(3, 0, '视频', 0, 0, 1612496023);

--
-- 转存表中的数据 `eb_system_group` `eb_system_group_data` 内置底部导航数据
--
INSERT INTO `eb_system_group`(`id`, `name`, `info`, `config_name`, `fields`) VALUES (70, '前端底部导航', '前端底部导航', 'bottom_navigation', '[{\"name\":\"\\u79fb\\u52a8\\u7aef\\u9875\\u9762\\u8fde\\u63a5\",\"title\":\"url\",\"type\":\"input\",\"param\":\"\"},{\"name\":\"\\u9009\\u4e2d\\u65f6\\u56fe\\u7247\",\"title\":\"class\",\"type\":\"upload\",\"param\":\"\"},{\"name\":\"\\u672a\\u9009\\u4e2d\\u65f6\\u56fe\\u7247\",\"title\":\"hove_class\",\"type\":\"upload\",\"param\":\"\"},{\"name\":\"\\u540d\\u79f0\",\"title\":\"name\",\"type\":\"input\",\"param\":\"\"}]');
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (200, 70, '{\"url\":{\"type\":\"input\",\"value\":\"\\/wap\\/index\\/index.html\"},\"class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/03645202102221211256015.png\"},\"hove_class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/8d6c7202102221211183819.png\"},\"name\":{\"type\":\"input\",\"value\":\"\\u9996\\u9875\"}}', 1614741868, 4, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (201, 70, '{\"url\":{\"type\":\"input\",\"value\":\"\\/wap\\/special\\/special_cate.html\"},\"class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/7e5eb202102221210586855.png\"},\"hove_class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/1881a20210222121051213.png\"},\"name\":{\"type\":\"input\",\"value\":\"\\u8bfe\\u7a0b\"}}', 1614743135, 3, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (202, 70, '{\"url\":{\"type\":\"input\",\"value\":\"\\/wap\\/store\\/index.html\"},\"class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/eec38202102221210327209.png\"},\"hove_class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/4b7a920210222121007108.png\"},\"name\":{\"type\":\"input\",\"value\":\"\\u5546\\u57ce\"}}', 1614743246, 2, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (203, 70, '{\"url\":{\"type\":\"input\",\"value\":\"\\/wap\\/my\\/index.html\"},\"class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/4533d202102221209576961.png\"},\"hove_class\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/50710202102221209424541.png\"},\"name\":{\"type\":\"input\",\"value\":\"\\u6211\\u7684\"}}', 1614743277, 1, 1);
--
-- 转存表中的数据 `eb_special_task_category`
--
CREATE TABLE `eb_learning_records` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `uid` int(12) NOT NULL DEFAULT '0' COMMENT 'uid',
  `special_id` int(12) NOT NULL DEFAULT '0' COMMENT '专题id',
  `add_time` int(50) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='专题学习记录';

--
-- 转存表中的数据 `eb_recommend` 首页推荐内置数据
--
INSERT INTO `eb_recommend` (`id`, `typesetting`, `title`, `link`, `type`, `number`, `relation_ids`, `add_time`, `icon`, `image`, `sort`, `is_fixed`, `is_show`, `grade_id`, `show_count`) VALUES
(60, 5, '热门直播', '', 5, 0, '', 0, '', '', 0, 0, 1, 0, 0),
(61, 5, '讲师', '', 6, 0, '', 0, '', '', 0, 0, 1, 0, 0),
(62, 5, '线下活动', '', 7, 0, '', 0, '', '', 0, 0, 1, 0, 0);