From ed3970690ccf6832ac93d1e9ecb95820794ebbad Mon Sep 17 00:00:00 2001 From: Nayd 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') 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