diff options
| author | Gyx <2359980687@qq.com> | 2012-01-10 10:07:22 +0800 |
|---|---|---|
| committer | Gyx <2359980687@qq.com> | 2012-01-10 10:07:22 +0800 |
| commit | 3230fc4d024b91a2fb5d60807e17daae19c0cc9a (patch) | |
| tree | c5b9720f2ad87fe59b6d31ce53eaf045174671cc | |
| parent | c84de34ab674f5c67bf7843a33e9ee63b5c0b124 (diff) | |
P10: Update account expansion default 3 for 4.x
Signed-off-by: Gyx <2359980687@qq.com>
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/2012_01_10_00_auth_account_4x.sql | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index a5c224f7390..efa8c4ba7bc 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -60,7 +60,7 @@ CREATE TABLE `account` ( `locked` tinyint(3) unsigned NOT NULL default '0', `last_login` timestamp NOT NULL default '0000-00-00 00:00:00', `online` tinyint(4) NOT NULL default '0', - `expansion` tinyint(3) unsigned NOT NULL default '2', + `expansion` tinyint(3) unsigned NOT NULL default '3', `mutetime` bigint(40) NOT NULL default '0', `locale` tinyint(3) unsigned NOT NULL default '0', `recruiter` int(11) NOT NULL default '0', diff --git a/sql/updates/auth/2012_01_10_00_auth_account_4x.sql b/sql/updates/auth/2012_01_10_00_auth_account_4x.sql new file mode 100644 index 00000000000..1e9016575fc --- /dev/null +++ b/sql/updates/auth/2012_01_10_00_auth_account_4x.sql @@ -0,0 +1 @@ +ALTER TABLE `account` CHANGE COLUMN `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '3'; |