diff options
| author | Kudlaty <none@none> | 2009-09-13 00:02:14 +0200 |
|---|---|---|
| committer | Kudlaty <none@none> | 2009-09-13 00:02:14 +0200 |
| commit | f55031b2425099f989bccfca2a455c609cbaa403 (patch) | |
| tree | 025fb54339bede92c2df5f4fc073326540585067 /sql | |
| parent | da091a901d747d6c52d58da0168f92dd55aa9dbb (diff) | |
Add support for multirealm. Patch by streetrat.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/realmd.sql | 1 | ||||
| -rw-r--r-- | sql/updates/5642_realmd.sql | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index effad3d3e32..4edaa5c773a 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -182,6 +182,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint(3) unsigned NOT NULL default '0', `allowedSecurityLevel` tinyint(3) unsigned NOT NULL default '0', `population` float unsigned NOT NULL default '0', + `gamebuild` int(11) unsigned NOT NULL default '9947', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System'; diff --git a/sql/updates/5642_realmd.sql b/sql/updates/5642_realmd.sql new file mode 100644 index 00000000000..f1d5575fd18 --- /dev/null +++ b/sql/updates/5642_realmd.sql @@ -0,0 +1,2 @@ +ALTER TABLE `realmlist` + ADD `gamebuild` int(11) unsigned NOT NULL default '9947' AFTER `population`;
\ No newline at end of file |