diff options
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`; |