go-admin
go-admin copied to clipboard
[Question]表结构貌似有调整
问题描述 [详细地描述问题,让大家都能理解]
最近更新了go-admin代码,发现程序不能启动了,提示的错误信息是plugin_name
不存在,对比git log,发现admin.sql
有改动
-
goadmin_menu
:添加了plugin_name
、uuid
这俩字段 -
goadmin_role_menu
、goadmin_role_permissions
、goadmin_role_users
、goadmin_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'