From 59bb9c20f345544310369f3074fd0e716cc8092c Mon Sep 17 00:00:00 2001
From: Nayd <dnpd.dd@gmail.com>
Date: Sun, 23 Nov 2014 23:53:22 +0000
Subject: DB/Schema/Auth: Change `account`.`os` to varchar(4)

Windows and Mac 64 bit clients send "Wn64" and "Mc64", respectively, and that does not fit in a varchar(3)
---
 sql/base/auth_database.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/base/auth_database.sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 180597a938e..47cac086392 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -45,7 +45,7 @@ CREATE TABLE `account` (
   `mutereason` varchar(255) NOT NULL DEFAULT '',
   `muteby` varchar(50) NOT NULL DEFAULT '',
   `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `os` varchar(3) NOT NULL DEFAULT '',
+  `os` varchar(4) NOT NULL DEFAULT '',
   `recruiter` int(10) unsigned NOT NULL DEFAULT '0',
   `battlenet_account` int(10) unsigned DEFAULT NULL,
   `battlenet_index` tinyint(3) unsigned DEFAULT NULL,
-- 
cgit v1.2.3


From ed3970690ccf6832ac93d1e9ecb95820794ebbad Mon Sep 17 00:00:00 2001
From: Nayd <dnpd.dd@gmail.com>
Date: Tue, 25 Nov 2014 16:44:50 +0000
Subject: DB/Schema/Auth: Also change `battlenet_accounts`.`os` to varchar(4)

Ref 59bb9c20f345544310369f3074fd0e716cc8092c
---
 sql/base/auth_database.sql              | 2 +-
 sql/updates/auth/2014_11_23_00_auth.sql | 1 +
 sql/updates/auth/2014_11_23_01_auth.sql | 1 -
 sql/updates/auth/2014_11_25_00_auth.sql | 1 +
 4 files changed, 3 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/auth/2014_11_23_00_auth.sql
 delete mode 100644 sql/updates/auth/2014_11_23_01_auth.sql
 create mode 100644 sql/updates/auth/2014_11_25_00_auth.sql

(limited to 'sql/base/auth_database.sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 47cac086392..8d71b47fcab 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -216,7 +216,7 @@ CREATE TABLE `battlenet_accounts` (
   `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
   `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `os` varchar(3) NOT NULL DEFAULT '',
+  `os` varchar(4) NOT NULL DEFAULT '',
   `LastCharacterUndelete` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Account System';
diff --git a/sql/updates/auth/2014_11_23_00_auth.sql b/sql/updates/auth/2014_11_23_00_auth.sql
new file mode 100644
index 00000000000..1c68d6a8e06
--- /dev/null
+++ b/sql/updates/auth/2014_11_23_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `account` CHANGE `os` `os` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
diff --git a/sql/updates/auth/2014_11_23_01_auth.sql b/sql/updates/auth/2014_11_23_01_auth.sql
deleted file mode 100644
index 1c68d6a8e06..00000000000
--- a/sql/updates/auth/2014_11_23_01_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `account` CHANGE `os` `os` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
diff --git a/sql/updates/auth/2014_11_25_00_auth.sql b/sql/updates/auth/2014_11_25_00_auth.sql
new file mode 100644
index 00000000000..6594fe0c4fa
--- /dev/null
+++ b/sql/updates/auth/2014_11_25_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `battlenet_accounts` CHANGE `os` `os` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';
-- 
cgit v1.2.3

