kahQdPFq

1DROP TABLE IF EXISTS `dimension_server_lobby`;
2CREATE TABLE IF NOT EXISTS `dimension_server_lobby` (
3  `id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
4  `internal_ip` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
5  `port` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
6  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
7  `type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
8  `source_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
9  `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
10  PRIMARY KEY (`id`),
11  UNIQUE KEY `source_key` (`source_key`),
12  KEY `complete` (`complete`)
13) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
14
15
16DROP TABLE IF EXISTS `log_server_concurrency`;
17CREATE TABLE IF NOT EXISTS `log_server_concurrency` (
18  `id` bigint(20) NOT NULL AUTO_INCREMENT,
19  `user_id`  TINYINT unsigned NULL default 0,
20  `server_lobby_id` SMALLINT UNSIGNED NOT NULL,
21  `period_id` SMALLINT UNSIGNED NOT NULL,
22  `value` tinyint unsigned NOT NULL,
23  `value_connected_users` int(11) NOT NULL,
24  `value_in_progress_matches` int(11) NOT NULL,
25  `value_used_capacity` tinyint unsigned NOT NULL,
26  `value_guest_login_open` tinyint unsigned NOT NULL,
27  PRIMARY KEY (`id`),
28  KEY `fk_server_concurrency_dimension_user1` (`user_id`),
29  KEY `fk_server_concurrency_dimension_server_lobby_id1` (`server_lobby_id`),
30  KEY `fk_server_concurrency_dimension_period1` (`period_id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
32
33
34--
35-- Constraints for table `log_acc_reg`
36--
37ALTER TABLE `log_server_concurrency`
38  ADD CONSTRAINT `fk_log_srv_conc_dimension_server_lobby1` FOREIGN KEY (`server_lobby_id`) REFERENCES `dimension_server_lobby` (`server_lobby_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
39  ADD CONSTRAINT `fk_log_acc_reg_dimension_period1` FOREIGN KEY (`period_id`) REFERENCES `dimension_period` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;