upgradeV3.2.3.sql 1.9 KB

12345678
  1. ALTER TABLE `yshop_store_shop`
  2. ADD COLUMN `is_auto_print` tinyint(1) NULL DEFAULT 0 COMMENT '是否自动打印小票0-否1-是' AFTER `admin_id`;
  3. UPDATE `system_menu` SET `name` = '统计', `permission` = '', `type` = 1, `sort` = 62, `parent_id` = 0, `path` = '/statistics', `icon` = 'ep:management', `component` = '', `component_name` = '', `status` = 0, `visible` = b'1', `keep_alive` = b'1', `always_show` = b'1', `creator` = '1', `create_time` = '2024-07-04 14:37:48', `updater` = '1', `update_time` = '2025-12-05 10:51:41', `deleted` = b'0' WHERE `id` = 2378;
  4. INSERT INTO `system_menu`(`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (2396, '销售概况', '', 2, 0, 2378, 'sales', 'ep:set-up', 'mall/statistics/sales', 'Sales', 0, b'1', b'1', b'1', '1', '2025-12-05 10:50:33', '1', '2025-12-05 10:52:55', b'0');
  5. INSERT INTO `system_menu`(`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (2397, '订单概况', '', 2, 1, 2378, 'ordersta', 'ep:collection-tag', 'mall/statistics/orders', 'Ordersta', 0, b'1', b'1', b'1', '1', '2025-12-05 10:54:41', '1', '2025-12-05 10:54:41', b'0');
  6. INSERT INTO `system_menu`(`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (2398, '商品概况', '', 2, 2, 2378, 'productsta', 'ep:shopping-cart-full', 'mall/statistics/product', 'Productsta', 0, b'1', b'1', b'1', '1', '2025-12-05 10:55:48', '1', '2025-12-05 10:55:48', b'0');