5h06NbYv

1DROP TABLE IF EXISTS `allocations`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `allocations` (
5  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6  `node_id` int(10) unsigned NOT NULL,
7  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8  `ip_alias` text COLLATE utf8_unicode_ci,
9  `port` mediumint(8) unsigned NOT NULL,
10  `server_id` int(10) unsigned DEFAULT NULL,
11  `created_at` timestamp NULL DEFAULT NULL,
12  `updated_at` timestamp NULL DEFAULT NULL,
13  PRIMARY KEY (`id`),
14  KEY `allocations_node_id_foreign` (`node_id`),
15  KEY `allocations_server_id_foreign` (`server_id`),
16  CONSTRAINT `allocations_node_id_foreign` FOREIGN KEY (`node_id`) REFERENCES `nodes` (`id`),
17  CONSTRAINT `allocations_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`)
18) ENGINE=InnoDB AUTO_INCREMENT=2342 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19/*!40101 SET character_set_client = @saved_cs_client */;