ALTER TABLE `mall_purchase` ADD COLUMN `warehouse_id`  bigint(20) NULL COMMENT '仓库ID' AFTER `logistics_company`;

UPDATE `admin_configs` SET `value` = '[\"/login/captcha\",\"/login/sign\",\"/login/logout\",\"/login/sub/sign\",\"/login/sub/auth\",\"/login/sub/shop\",\"/member/register\",\"/member/email/verify\",\"/member/phone/verify\",\"/google/oauth/callback\",\"/member/external/register\",\"/login/auth\",\"/copyright\",\"/payment/methods\",\"/payment\",\"/login/merchant\",\"/role/get_service_fee_list\",\"/role/get_valid_service_fee\",\"/login/sub/syn/auth\",\"/shop/2b/info\",\"/product/2b/search\",\"/shop/view/2b/list\",\"/cat/2b/list\",\"/sku/stock/new/2b/get\",\"/good/2b/info\",\"/mallconfig/2b/list\",\"/delivery_method/list\",\"/good/2b/postage\",\"/mall_config/2b/get\",\"/good/data/download\",\"/article/2b/get\",\"/label/2b/list\",\"/label/2b/good/list\",\"/label/2b/good/label/list\",\"/good/wholesale/2b/get\"]' WHERE `admin_configs`.`name` = 'router.admin.exceptLogin';

INSERT INTO `admin_menu` (`pid`, `name`, `code`, `icon`, `type`, `perms`, `path`, `component`, `query`, `is_frame`, `is_cache`, `is_visible`, `remark`, `level`, `tree`, `sort`, `status`, `created_at`, `updated_at`) VALUES
    (2006, 'src.views.recharge.receiving_bank', 'bank-manager', 'bars', 'C', '', 'bank', 'system/bank/BankIndex', '', '1', '2', '2', '', 3, '', 1012, '1', '2025-05-27 06:21:17', '2025-05-27 06:21:17');

CREATE TABLE IF NOT EXISTS `admin_bank_info` (
    `bank_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `bank_name` varchar(255) NOT NULL COMMENT '银行名称',
    `company_name` varchar(255) NOT NULL COMMENT '公司名称',
    `bank_account_number` varchar(255) NOT NULL COMMENT '银行账号',
    `beneficial_bank_name` varchar(255) NOT NULL COMMENT '银行名称',
    `beneficial_bank_code` varchar(255) NOT NULL COMMENT '银行代码',
    `swift_code` varchar(255) NOT NULL COMMENT '国际汇款识别码',
    `branch_address` text NOT NULL COMMENT '收款银行地址',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收款银行信息';

CREATE TABLE IF NOT EXISTS `admin_rechare_application` (
    `application_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '申请编号',
    `shop_id` bigint(20) NOT NULL COMMENT '申请店铺编号',
    `user_id` bigint(20) NOT NULL COMMENT '申请人编号',
    `remittance_method` varchar(255) NOT NULL COMMENT '汇款方式',
    `payment` decimal(10,2) NOT NULL COMMENT '充值金额',
    `bank_name` varchar(255) NOT NULL COMMENT '收款银行',
    `remittance_account_name` varchar(255) NOT NULL COMMENT '汇款账户名称',
    `remittance_bank_account_number` varchar(255) NOT NULL COMMENT '汇款人银行账号',
    `ransfer_screenshot` varchar(255) NOT NULL COMMENT '转账截图',
    `ransfer_screenshot1` varchar(255) DEFAULT NULL,
    `ransfer_screenshot2` varchar(255) DEFAULT NULL,
    `ransfer_screenshot3` varchar(255) DEFAULT NULL,
    `ransfer_screenshot4` varchar(255) DEFAULT NULL,
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=审核中2=通过3=拒绝默认1',
    `remark` text COMMENT '备注',
    `create_time` datetime NOT NULL COMMENT '申请时间',
PRIMARY KEY (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值申请表';