1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| # 商品概览索引优化速度
| USE yami_bbc;
|
| ALTER TABLE `tz_flow_page_analyse`
| ADD INDEX `data_statistics_idx`(`create_date`, `shop_id`, `page_id`) USING BTREE COMMENT '数据统计索引';
|
| ALTER TABLE `tz_flow_page_analyse_user`
| ADD INDEX `foreign_idx`(`flow_page_analyse_id`, `type`) USING BTREE;
|
| ALTER TABLE `tz_prod`
| DROP INDEX `shop_id`,
| ADD INDEX `shop_id`(`shop_id`, `status`) USING BTREE;
|
| # 客户管理相关按钮添加
| INSERT INTO tz_shop_menu (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `name_en`, `hidden`) VALUES
| (474,471,'编辑','','customer:customerList:edit',2,'',0,'Edit',0),
| (475,471,'送优惠券','','admin:coupon:send',2,'',0,'sendCoupon',0);
|
|
