dingdong/db.sql

INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (2, NULL, '', NULL, '', b'1', b'1', '', '系统菜单', NULL, '', b'1', 1);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (6, NULL, '', NULL, '', b'1', b'1', 'fas fa-user', '用户管理', 2, '/userList', b'0', 2);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (4, NULL, '', NULL, '', b'1', b'1', 'fas fa-code', '代码生成', 3, '/genCodeList', b'0', 5);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (5, NULL, '', NULL, '', b'1', b'1', 'fas fa-bug', '接口调试', 3, '/api', b'0', 6);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (10, NULL, '', NULL, '', b'1', b'1', '', '菜单配置', 9, '/menus', b'0', 7);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (14, NULL, '', NULL, '', b'1', b'1', '', '参数配置', 9, '/sysConfigList', b'0', 8);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (3, NULL, '', NULL, '', b'1', b'1', 'fas fa-desktop', '开发', 2, '', b'0', 4);
INSERT INTO `menu`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `active`, `enabled`, `icon`, `name`, `parent`, `path`, `root`, `sort`) VALUES (9, NULL, '', NULL, '', b'1', b'1', 'fas fa-cog', '配置', 2, '', b'0', 3);

INSERT INTO `user_authority`(`user_id`, `authority_name`) VALUES (1, 'ROLE_ADMIN');
INSERT INTO `user_authority`(`user_id`, `authority_name`) VALUES (1, 'ROLE_USER');

INSERT INTO `user`(`id`, `created_at`, `created_by`, `modified_at`, `modified_by`, `avatar`, `city`, `country`, `email`, `enabled`, `language`, `nickname`, `open_id`, `password`, `phone`, `province`, `sex`, `username`) VALUES (1, '2020-03-07 18:34:36', 'system', '2020-03-07 18:34:36', 'system', 'https://zhumj.oss-cn-hangzhou.aliyuncs.com/image/user.jpg', NULL, NULL, NULL, b'1', NULL, '管理员', NULL, '$2a$10$F1djCtmdF3T0qsviWw50/utajZSe4EJMMUD.Ey5BhEIpoDhanBMuC', NULL, NULL, NULL, 'root');

INSERT INTO `user_authority`(`user_id`, `authority_name`) VALUES (1, 'ROLE_ADMIN');
INSERT INTO `user_authority`(`user_id`, `authority_name`) VALUES (1, 'ROLE_USER');