[代码完善](v2.5): v2.5 beta sql 脚本更新

elunez · elunez · commit 21fea135fc9a · 2020-06-08T18:51:50.000+08:00
diff --git a/sql/sys_ 相关表字段调整.sql b/sql/sys_ 相关表字段调整.sql
@@ -1,5 +1,3 @@
-select * from sys_user
-
 -- sys_user 表变动 start --
 /* id 改为 user_id */
 alter table sys_user CHANGE id user_id BIGINT(20) AUTO_INCREMENT COMMENT 'ID';
diff --git a/sql/删除所有外键.sql b/sql/删除所有外键.sql
@@ -1,22 +1,5 @@
-
 /* 检索并拼接sql语句，复制所有结果删除所有外键 */
-SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,' ;') 
-FROM information_schema.TABLE_CONSTRAINTS c 
+SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,';')
+FROM information_schema.TABLE_CONSTRAINTS c
 WHERE c.TABLE_SCHEMA='eladmin' AND c.CONSTRAINT_TYPE='FOREIGN KEY';
--- start --
-ALTER TABLE eladmin_new.dict_detail DROP FOREIGN KEY dict_detail_ibfk_1 ;
-ALTER TABLE eladmin_new.job DROP FOREIGN KEY job_ibfk_1 ;
-ALTER TABLE eladmin_new.mnt_deploy DROP FOREIGN KEY mnt_deploy_ibfk_1 ;
-ALTER TABLE eladmin_new.mnt_deploy_server DROP FOREIGN KEY mnt_deploy_server_ibfk_1 ;
-ALTER TABLE eladmin_new.mnt_deploy_server DROP FOREIGN KEY mnt_deploy_server_ibfk_2 ;
-ALTER TABLE eladmin_new.roles_depts DROP FOREIGN KEY roles_depts_ibfk_1 ;
-ALTER TABLE eladmin_new.roles_depts DROP FOREIGN KEY roles_depts_ibfk_2 ;
-ALTER TABLE eladmin_new.roles_menus DROP FOREIGN KEY roles_menus_ibfk_1 ;
-ALTER TABLE eladmin_new.roles_menus DROP FOREIGN KEY roles_menus_ibfk_2 ;
-ALTER TABLE eladmin_new.sys_user DROP FOREIGN KEY sys_user_ibfk_1 ;
-ALTER TABLE eladmin_new.sys_user DROP FOREIGN KEY sys_user_ibfk_2 ;
-ALTER TABLE eladmin_new.sys_user DROP FOREIGN KEY sys_user_ibfk_3 ;
-ALTER TABLE eladmin_new.users_roles DROP FOREIGN KEY users_roles_ibfk_1 ;
-ALTER TABLE eladmin_new.users_roles DROP FOREIGN KEY users_roles_ibfk_2 ;
--- end --
 
diff --git a/sql/删除无用表.sql b/sql/删除无用表.sql
@@ -1,2 +1,2 @@
-# 删除头像关联表，将头像信息存入 sys_user 表，执行前先执行 字段调整.
+-- 删除头像关联表，将头像信息存入 sys_user 表，执行前先执行 字段调整. --
 DROP TABLE user_avatar
diff --git a/sql/相关数据更新.sql b/sql/相关数据更新.sql
@@ -1,5 +1,5 @@
 /** 将admin改为管理员 */
-update sys_user set is_admin = 1 WHERE user_id = 1
+update sys_user set is_admin = 1 WHERE user_id = 1;
 UPDATE sys_dept SET pid = NULL WHERE pid = 0;
 UPDATE sys_menu SET pid = NULL WHERE pid = 0;
 -- 创建零时表并复制数据 --

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,3 @@`
`1`		`-select * from sys_user`
`2`		`-`
`3`	`1`	`-- sys_user 表变动 start --`
`4`	`2`	`/* id 改为 user_id */`
`5`	`3`	`alter table sys_user CHANGE id user_id BIGINT(20) AUTO_INCREMENT COMMENT 'ID';`
Original file line number	Diff line number	Diff line change
`@@ -1,2 +1,2 @@`
`1`		`-# 删除头像关联表，将头像信息存入 sys_user 表，执行前先执行字段调整.`
	`1`	`+-- 删除头像关联表，将头像信息存入 sys_user 表，执行前先执行字段调整. --`
`2`	`2`	`DROP TABLE user_avatar`