ZuQ3bDBC

1DROP TABLE IF EXISTS `uptime`;
2CREATE TABLE `uptime` (
3  `realmid` int(11) unsigned NOT NULL,
4  `starttime` bigint(20) unsigned NOT NULL DEFAULT '0',
5  `startstring` varchar(64) NOT NULL DEFAULT '',
6  `uptime` bigint(20) unsigned NOT NULL DEFAULT '0',
7  `maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0',
8  PRIMARY KEY (`realmid`,`starttime`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
10
11-- ----------------------------
12-- Records of uptime
13-- ----------------------------
14INSERT INTO `uptime` VALUES ('1', '1314813938', '2011-08-31 20:05:38', '0', '0');
15INSERT INTO `uptime` VALUES ('1', '1314823357', '2011-08-31 22:42:37', '600', '1');
16INSERT INTO `uptime` VALUES ('1', '1314876980', '2011-09-01 13:36:20', '600', '1');
17INSERT INTO `uptime` VALUES ('1', '1314878212', '2011-09-01 13:56:52', '1201', '1');