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