diff options
| author | Chaz Brown <iamparadox@netscape.net> | 2009-09-15 01:09:36 -0400 |
|---|---|---|
| committer | Chaz Brown <iamparadox@netscape.net> | 2009-09-15 01:09:36 -0400 |
| commit | c7cc007950d8b991f61b127e9dbd5399ef2e5479 (patch) | |
| tree | d5ad73cc44ca021358d51ae6a3247d63120f461e /sql | |
| parent | 6cb428318af4aba5ebb9d9340284165ca6181065 (diff) | |
Add Server revision to realmd.uptime table
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/realmd.sql | 1 | ||||
| -rw-r--r-- | sql/updates/5670_realmd.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index 1a7c2435b94..a54afc1e391 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -209,6 +209,7 @@ CREATE TABLE `uptime` ( `startstring` varchar(64) NOT NULL default '', `uptime` bigint(20) unsigned NOT NULL default '0', `maxplayers` smallint(5) unsigned NOT NULL default '0', + `revision` VARCHAR(255) NOT NULL DEFAULT 'Trinitycore', PRIMARY KEY (`realmid`,`starttime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system'; diff --git a/sql/updates/5670_realmd.sql b/sql/updates/5670_realmd.sql new file mode 100644 index 00000000000..ba694028ab6 --- /dev/null +++ b/sql/updates/5670_realmd.sql @@ -0,0 +1 @@ +ALTER TABLE `uptime` ADD COLUMN `revision` VARCHAR(255) NOT NULL DEFAULT 'Trinitycore' AFTER `maxplayers`; |