aboutsummaryrefslogtreecommitdiff
path: root/sql/realmd.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/realmd.sql')
-rw-r--r--sql/realmd.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql
index b7b55cc15d9..fcd7d166359 100644
--- a/sql/realmd.sql
+++ b/sql/realmd.sql
@@ -175,6 +175,29 @@ INSERT INTO `realmlist` VALUES
(1,'Trinity','127.0.0.1',8085,1,0,1,0,0);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
+
+--
+-- Table structure for table `uptime`
+--
+
+DROP TABLE IF EXISTS `uptime`;
+CREATE TABLE `uptime` (
+ `realmid` int(11) unsigned NOT NULL,
+ `starttime` bigint(20) unsigned NOT NULL default '0',
+ `startstring` varchar(64) NOT NULL default '',
+ `uptime` bigint(20) unsigned NOT NULL default '0',
+ `maxplayers` smallint(5) unsigned NOT NULL default '0',
+ PRIMARY KEY (`realmid`,`starttime`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
+
+--
+-- Dumping data for table `uptime`
+--
+
+LOCK TABLES `uptime` WRITE;
+/*!40000 ALTER TABLE `uptime` DISABLE KEYS */;
+/*!40000 ALTER TABLE `uptime` ENABLE KEYS */;
+UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;