diff options
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/2014_11_23_01_auth.sql | 1 |
2 files changed, 2 insertions, 1 deletions
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, diff --git a/sql/updates/auth/2014_11_23_01_auth.sql b/sql/updates/auth/2014_11_23_01_auth.sql new file mode 100644 index 00000000000..1c68d6a8e06 --- /dev/null +++ b/sql/updates/auth/2014_11_23_01_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` CHANGE `os` `os` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; |