· 8 years ago · Nov 25, 2017, 07:08 AM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : Salja-Home
5Source Server Version : 50515
6Source Host : localhost:3306
7Source Database : realmd
8
9Target Server Type : MYSQL
10Target Server Version : 50515
11File Encoding : 65001
12
13Date: 2011-09-01 14:22:44
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `uptime`
20-- ----------------------------
21DROP TABLE IF EXISTS `uptime`;
22CREATE TABLE `uptime` (
23 `realmid` int(11) unsigned NOT NULL,
24 `starttime` bigint(20) unsigned NOT NULL DEFAULT '0',
25 `startstring` varchar(64) NOT NULL DEFAULT '',
26 `uptime` bigint(20) unsigned NOT NULL DEFAULT '0',
27 `maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0',
28 PRIMARY KEY (`realmid`,`starttime`)
29) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
30
31-- ----------------------------
32-- Records of uptime
33-- ----------------------------
34INSERT INTO `uptime` VALUES ('1', '1314813938', '2011-08-31 20:05:38', '0', '0');
35INSERT INTO `uptime` VALUES ('1', '1314823357', '2011-08-31 22:42:37', '600', '1');
36INSERT INTO `uptime` VALUES ('1', '1314876980', '2011-09-01 13:36:20', '600', '1');
37INSERT INTO `uptime` VALUES ('1', '1314878212', '2011-09-01 13:56:52', '1201', '1');