Mp1MLewJ

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.5.25-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL version:             7.0.0.4053
6-- Date/time:                    2012-09-05 16:27:39
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
12
13-- Dumping structure for table gamedb.server_status
14CREATE TABLE IF NOT EXISTS `server_status` (
15  `status` enum('0','1','2') NOT NULL DEFAULT '0',
16  `users_online` int(11) NOT NULL DEFAULT '0',
17  `rooms_loaded` int(11) NOT NULL DEFAULT '0',
18  `server_ver` text NOT NULL,
19  `stamp` double NOT NULL,
20  `userpeak` int(11) NOT NULL DEFAULT '0'
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23-- Dumping data for table gamedb.server_status: ~1 rows (approximately)
24/*!40000 ALTER TABLE `server_status` DISABLE KEYS */;
25INSERT INTO `server_status` (`status`, `users_online`, `rooms_loaded`, `server_ver`, `stamp`, `userpeak`) VALUES
26	('1', 0, 0, 'Phoenix v3.9.0 (Build 14623)', 1346858850, 0);
27/*!40000 ALTER TABLE `server_status` ENABLE KEYS */;
28
29
30-- Dumping structure for table gamedb.system_stats
31CREATE TABLE IF NOT EXISTS `system_stats` (
32  `id` int(5) NOT NULL AUTO_INCREMENT,
33  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34  `users` int(5) NOT NULL DEFAULT '0',
35  `rooms` int(5) NOT NULL DEFAULT '0',
36  PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39-- Dumping data for table gamedb.system_stats: ~0 rows (approximately)
40/*!40000 ALTER TABLE `system_stats` DISABLE KEYS */;
41/*!40000 ALTER TABLE `system_stats` ENABLE KEYS */;
42/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
43/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;