go-admin icon indicating copy to clipboard operation
go-admin copied to clipboard

[Question]表结构貌似有调整

Open maliyan opened this issue 4 years ago • 0 comments

问题描述 [详细地描述问题,让大家都能理解]

最近更新了go-admin代码,发现程序不能启动了,提示的错误信息是plugin_name不存在,对比git log,发现admin.sql有改动

  • goadmin_menu:添加了plugin_nameuuid这俩字段
  • goadmin_role_menugoadmin_role_permissionsgoadmin_role_usersgoadmin_user_permissions移除了主键

整理了一下,涉及如下改动,不确定还有没有其他的改动了:

# goadmin_menu
alter table `goadmin_menu` add `plugin_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' after `header`;
alter table `goadmin_menu` add `uuid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL after `plugin_name`;

# goadmin_menu
INSERT INTO `goadmin_menu` (`id`, `parent_id`, `type`, `order`, `title`, `icon`, `uri`, `plugin_name`, `header`, `created_at`, `updated_at`) VALUES (1,0,1,2,'Admin','fa-tasks','','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (2,1,1,2,'Users','fa-users','/info/manager','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (3,1,1,3,'Roles','fa-user','/info/roles','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (4,1,1,4,'Permission','fa-ban','/info/permission','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (5,1,1,5,'Menu','fa-bars','/menu','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (6,1,1,6,'Operation log','fa-history','/info/op','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00'), (7,0,1,1,'Dashboard','fa-bar-chart','/','',NULL,'2019-09-10 00:00:00','2019-09-10 00:00:00');

# goadmin_role_menu
alter table `goadmin_role_menu` drop column `id`;

# goadmin_role_permissions
alter table `goadmin_role_permissions` drop column `id`;

# goadmin_role_users
alter table `goadmin_role_users` drop column `id`;

# goadmin_user_permissions
alter table `goadmin_user_permissions` drop column `id`;


示例代码 [如果有必要,展示代码,线上示例,或仓库]

其他信息 [如截图等其他信息可以贴在这里]

ERROR	engine/engine.go:306	Error 1054: Unknown column 'plugin_name' in 'where clause'

maliyan avatar Oct 09 '20 06:10 maliyan