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

Also update characters_database.sql (generated by mysqldump)

3 files changed, 22 insertions, 23 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index f880f009893..86d08ca954b 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -221,12 +221,12 @@ DROP TABLE IF EXISTS `banned_addons`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `banned_addons` (
-  `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
+  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `Name` varchar(255) NOT NULL,
   `Version` varchar(255) NOT NULL DEFAULT '',
   `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`Id`),
-  UNIQUE KEY `idx_name_ver` (`Name`, `Version`)
+  UNIQUE KEY `idx_name_ver` (`Name`,`Version`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1662,7 +1662,7 @@ CREATE TABLE `guild` (
   `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `info` VARCHAR(500) NOT NULL DEFAULT '',
+  `info` varchar(500) NOT NULL DEFAULT '',
   `motd` varchar(128) NOT NULL DEFAULT '',
   `createdate` int(10) unsigned NOT NULL DEFAULT '0',
   `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
@@ -2456,4 +2456,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2013-02-04 16:22:06
+-- Dump completed on 2014-01-26 14:39:20
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;