eccs/sql/20230420/merchUserMenu.sql

CREATE TABLE `merch_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `merch_sn` varchar(32) DEFAULT NULL COMMENT '商户号',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户 id',
  `create_sn` varchar(32) DEFAULT NULL COMMENT '创建人编号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `mod_sn` varchar(255) DEFAULT NULL COMMENT '修改人',
  `mod_time` datetime DEFAULT NULL COMMENT '修改时间',
  `tstm` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户用户表';

-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户', '2288', '1', 'merchUser', 'merchant/merchUser/index', 1, 0, 'C', '0', '0', 'biz:merchUser:list', '#', 'admin', sysdate(), '', null, '商户用户菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'biz:merchUser:query',        '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'biz:merchUser:add',          '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'biz:merchUser:edit',         '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'biz:merchUser:remove',       '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('商户用户导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'biz:merchUser:export',       '#', 'admin', sysdate(), '', null, '');