text: -- DROP DATABASE IF EXISTS admin_template;
  --
  -- CREATE DATABASE admin_template;
  
  -- --------------------------sys_menu 菜单权限表---------------------------------------
  USE admin_template;
  DROP TABLE IF EXISTS sys_menu;
  -- 系统菜单权限表
  CREATE TABLE sys_menu (
      menu_id bigint NOT NULL COMMENT '当前菜单 ID',
      parent_id bigint NOT NULL COMMENT '当前菜单父菜单 ID',
  	name_zh varchar(20) NOT NULL COMMENT '中文菜单名称',
  	name_en varchar(40) NOT NULL COMMENT '英文菜单名称',
  	type tinyint NOT NULL COMMENT '菜单类型，0 表示目录，1 表示菜单项，2 表示按钮',
  	url varchar(100) NOT NULL COMMENT '访问路径',
  	icon varchar(100) DEFAULT NULL COMMENT '菜单图标',
  	order_num int DEFAULT NULL COMMENT '菜单项顺序',
      create_time datetime DEFAULT NULL COMMENT '创建时间',
      update_time datetime DEFAULT NULL COMMENT '修改时间',
      delete_flag tinyint DEFAULT NULL COMMENT '逻辑删除标志，0 表示未删除， 1 表示删除',
      PRIMARY KEY(menu_id)
  ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT='系统菜单权限表';
  
  -- 插入数据
  INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name_zh`, `name_en`, `type`, `url`, `icon`, `order_num`, `create_time`, `update_time`, `delete_flag`)
  VALUES (1278601251755451111, 0, '系统管理', 'System Control', 0, '', 'el-icon-setting', 0,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755452211, 1278601251755451111, '用户管理', 'User Control', 1, 'sys/UserList', 'el-icon-user', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755453311, 1278601251755451111, '角色管理', 'Role Control', 1, 'sys/RoleControl', 'el-icon-price-tag', 2,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755454411, 1278601251755451111, '菜单管理', 'Menu Control', 1, 'sys/MenuControl', 'el-icon-menu', 3,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
  
      (1278601251755452221, 1278601251755452211, '添加', 'Add', 2, '', '', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755452231, 1278601251755452211, '删除', 'Delete', 2, '', '', 2,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755452241, 1278601251755452211, '修改', 'Update', 2, '', '', 3,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755452251, 1278601251755452211, '查看', 'List', 2, '', '', 4,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
  
      (1278601251755453321, 1278601251755453311, '添加', 'Add', 2, '', '', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755453331, 1278601251755453311, '删除', 'Delete', 2, '', '', 2,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755453341, 1278601251755453311, '修改', 'Update', 2, '', '', 3,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755453351, 1278601251755453311, '查看', 'List', 2, '', '', 4,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
  
      (1278601251755454421, 1278601251755454411, '添加', 'Add', 2, '', '', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755454431, 1278601251755454411, '删除', 'Delete', 2, '', '', 2,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755454441, 1278601251755454411, '修改', 'Update', 2, '', '', 3,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755454451, 1278601251755454411, '查看', 'List', 2, '', '', 4,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
  
      (1278601251755455511, 0, '帮助', 'help', 0, '', 'el-icon-info', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755455521, 1278601251755455511, '百度', 'Baidu', 1, 'https://www.baidu.com/', 'el-icon-menu', 1,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0),
      (1278601251755455531, 1278601251755455511, '博客', 'Blog', 1, 'https://www.cnblogs.com/l-y-h/', 'el-icon-menu', 2,'2020-07-02 16:07:48', '2020-07-02 16:07:48', 0);
  
  -- --------------------------sys_menu 菜单权限表---------------------------------------
  