2022-8-3.sql 973 B

1234567
  1. INSERT INTO `blade_menu` (`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `component`, `remark`, `is_deleted`) VALUES (1553954064117567490, 1512050627038707713, 'delivery', '交割管理', '交割管理', '/rush/delivery', 'iconfont iconicon_shakehands', 3, 1, 0, 1, NULL, '', 0);
  2. INSERT INTO `blade_menu` (`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `component`, `remark`, `is_deleted`) VALUES (1553955133560229890, 1553954064117567490, 'delivery_view', '查看', 'view', '/shopping/delivery/view', 'iconfont iconicon_affiliations_li', 1, 2, 0, 1, NULL, '', 0);
  3. ALTER TABLE `t_user_bank_cards`
  4. ADD COLUMN `is_bind` int(11) NULL COMMENT '是否绑定' AFTER `create_time`,
  5. ADD COLUMN `request_no` varchar(255) NULL DEFAULT 0 COMMENT '绑定请求号' AFTER `is_bind`,
  6. ADD COLUMN `customer_id` varchar(16) NULL COMMENT '第三方用户id' AFTER `request_no`;