SQL: Update old .sql files to keep consistency with auth_database.sql

Also update characters_database.sql (generated by mysqldump)

2 files changed, 18 insertions, 19 deletions

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;