From efeb54139edddbf33851fb363abd5ce779bffcab Mon Sep 17 00:00:00 2001 From: Duarte Duarte Date: Fri, 31 Jan 2014 04:34:32 +0000 Subject: SQL: Update old .sql files to keep consistency with auth_database.sql Also update characters_database.sql (generated by mysqldump) --- sql/updates/auth/2013_08_30_00_auth_misc.sql | 34 ++++++++++++++-------------- sql/updates/auth/2013_11_11_00_auth_logs.sql | 3 +-- 2 files changed, 18 insertions(+), 19 deletions(-) (limited to 'sql/updates') diff --git a/sql/updates/auth/2013_08_30_00_auth_misc.sql b/sql/updates/auth/2013_08_30_00_auth_misc.sql index 1e790ce7e28..d433c479c63 100644 --- a/sql/updates/auth/2013_08_30_00_auth_misc.sql +++ b/sql/updates/auth/2013_08_30_00_auth_misc.sql @@ -1,23 +1,23 @@ -- Add new permissions DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 200 AND 216; INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(200, 'Command: .rbac'), -(201, 'Command: .rbac account'), -(202, 'Command: .rbac account group'), -(203, 'Command: .rbac account group add'), -(204, 'Command: .rbac account group remove'), -(205, 'Command: .rbac account role'), -(206, 'Command: .rbac account role grant'), -(207, 'Command: .rbac account role deny'), -(208, 'Command: .rbac account role revoke'), -(209, 'Command: .rbac account permission'), -(210, 'Command: .rbac account permission grant'), -(211, 'Command: .rbac account permission deny'), -(212, 'Command: .rbac account permission revoke'), -(213, 'Command: .rbac list'), -(214, 'Command: .rbac list groups'), -(215, 'Command: .rbac list roles'), -(216, 'Command: .rbac list permissions'); +(200, 'Command: rbac'), +(201, 'Command: rbac account'), +(202, 'Command: rbac account group'), +(203, 'Command: rbac account group add'), +(204, 'Command: rbac account group remove'), +(205, 'Command: rbac account role'), +(206, 'Command: rbac account role grant'), +(207, 'Command: rbac account role deny'), +(208, 'Command: rbac account role revoke'), +(209, 'Command: rbac account permission'), +(210, 'Command: rbac account permission grant'), +(211, 'Command: rbac account permission deny'), +(212, 'Command: rbac account permission revoke'), +(213, 'Command: rbac list'), +(214, 'Command: rbac list groups'), +(215, 'Command: rbac list roles'), +(216, 'Command: rbac list permissions'); -- Add Permissions to "Administrator Commands Role" DELETE FROM `rbac_role_permissions` WHERE `roleId` = 4 AND `permissionId` BETWEEN 200 AND 216; diff --git a/sql/updates/auth/2013_11_11_00_auth_logs.sql b/sql/updates/auth/2013_11_11_00_auth_logs.sql index 4e4daa10e4b..dddda0d6743 100644 --- a/sql/updates/auth/2013_11_11_00_auth_logs.sql +++ b/sql/updates/auth/2013_11_11_00_auth_logs.sql @@ -1,2 +1 @@ -ALTER TABLE `logs` CHANGE `type` `type` varchar(250); - +ALTER TABLE `logs` CHANGE `type` `type` varchar(250) NOT NULL; -- cgit v1.2.3