 
 LOCK TABLES `Profile` WRITE;
 /*!40000 ALTER TABLE `Profile` DISABLE KEYS */;
-INSERT INTO `Profile` VALUES (1,1,'Rob','Rob Haverkort','https://www.facebook.com/rob.haverkort'),(2,2,'Stephen','Stephen Mark Cotty','https://www.facebook.com/stephen.m.cotty'),(3,3,'Joseph','Joseph Hocker','https://www.facebook.com/profile.php?id=100005491788904'),(4,6,'Joe','Joe Ross','https://www.facebook.com/joe.ross.7921975'),(5,7,'Duston','Duston Taylor','https://www.facebook.com/profile.php?id=100005336027175'),(6,4,'Brandon','Brandon Tyrell Stewart','https://www.facebook.com/BTyrellStewart'),(7,5,'Leandro','Leandro Puyol','https://www.facebook.com/leandro.puyol'),(8,8,'Koos Koets','Koos Koets',''),(11,9,'Josh','Josh Maki','https://www.facebook.com/joshua.maki'),(12,NULL,'Ben','Ben Wright',NULL),(13,NULL,'Lumar','Lumar Brown',NULL),(14,NULL,'William','William Bailey',NULL),(15,NULL,'Jannick','Jannick Hermans',NULL),(16,NULL,'William','William Rewitzer',NULL),(17,NULL,'Alex','Alex Chavarria',NULL),(18,NULL,'Jasper','Jasper Coppens',NULL),(19,NULL,'Robert','Robert S. Miller',NULL),(20,NULL,'Tomas','Tomas Coates',NULL),(21,NULL,'Asi','Asi Fenerli',NULL),(22,NULL,'Greg','Greg Gorka',NULL),(23,NULL,'Sam','Sam Fullerton',NULL),(24,NULL,'Ronald','Ronald Dip',NULL),(25,NULL,'Jorge','Jorge Xikra',NULL),(26,NULL,'Tyler','Tyler Gidley',NULL),(27,NULL,'Luiz','Luiz Strina',NULL),(28,NULL,'Zoheb','Zoheb Biswas',NULL),(29,NULL,'Joseph','Joseph Bashore',NULL),(30,NULL,'TC','TC Cagri Basaran',NULL),(31,NULL,'Knute','Knute Nesland',NULL),(32,NULL,'Chad','Chad Hackbarth',NULL),(33,NULL,'Jack','Jack Grimes',NULL),(34,NULL,'Steven','Steven Delossantos',NULL),(35,NULL,'Daniel','Daniel Burchell',NULL),(36,NULL,'Ryan','Ryan Shervey',NULL),(37,NULL,'Kane','Kane Ross',NULL),(38,NULL,'Jesse','Jesse Chang',NULL),(39,NULL,'Travis','Travis Mctwigandberries',NULL),(40,NULL,'Tim','Tim Bramble',NULL),(41,NULL,'Dio','Dio Cretus',NULL),(42,NULL,'Drake','Drake Descher',NULL),(43,NULL,'Mike','Mike Becker',NULL),(44,NULL,'Don','Don Ironmonkey',NULL),(45,NULL,'Enid','Enid Solo',NULL),(46,NULL,'Jimmy','Jimmy Le',NULL),(47,NULL,'Basel','Basel Dabbas',NULL),(48,NULL,'Josh','Josh Harnish',NULL),(49,NULL,'Paul','Paul Shap',NULL),(50,NULL,'Brock','Brock Hall',NULL),(51,NULL,'Sean','Sean Beaver',NULL),(52,NULL,'Christos','Christos',NULL),(53,NULL,'Jasper','Jasper Hertle',NULL);
+INSERT INTO `Profile` VALUES (1,1,'Rob','Rob Haverkort','https://www.facebook.com/rob.haverkort'),(2,2,'Stephen','Stephen Mark Cotty','https://www.facebook.com/stephen.m.cotty'),(3,3,'Joseph','Joseph Hocker','https://www.facebook.com/profile.php?id=100005491788904'),(4,6,'Joe','Joe Ross','https://www.facebook.com/joe.ross.7921975'),(5,7,'Duston','Duston Taylor','https://www.facebook.com/profile.php?id=100005336027175'),(6,4,'Brandon','Brandon Tyrell Stewart','https://www.facebook.com/BTyrellStewart'),(7,5,'Leandro','Leandro Puyol','https://www.facebook.com/leandro.puyol'),(8,8,'Koos Koets','Koos Koets',''),(11,9,'Josh','Josh Maki','https://www.facebook.com/joshua.maki'),(12,NULL,'Ben','Ben Wright',NULL),(13,NULL,'Lumar','Lumar Brown',NULL),(14,NULL,'William','William Bailey',NULL),(15,NULL,'Jannick','Jannick Hermans',NULL),(16,NULL,'William','William Rewitzer',NULL),(17,NULL,'Alex','Alex Chavarria',NULL),(18,NULL,'Jasper','Jasper Coppens',NULL),(19,NULL,'Robert','Robert S. Miller',NULL),(20,NULL,'Tomas','Tomas Coates',NULL),(21,NULL,'Asi','Asi Fenerli',NULL),(22,NULL,'Greg','Greg Gorka',NULL),(23,NULL,'Sam','Sam Fullerton',NULL),(24,NULL,'Ronald','Ronald Dip',NULL),(25,NULL,'Jorge','Jorge Xikra',NULL),(26,NULL,'Tyler','Tyler Gidley',NULL),(27,NULL,'Luiz','Luiz Strina',NULL),(28,NULL,'Zoheb','Zoheb Biswas',NULL),(29,NULL,'Joseph','Joseph Bashore',NULL),(30,NULL,'TC','TC Cagri Basaran',NULL),(31,NULL,'Knute','Knute Nesland',NULL),(32,NULL,'Chad','Chad Hackbarth',NULL),(33,NULL,'Jack','Jack Grimes',NULL),(34,NULL,'Steven','Steven Delossantos',NULL),(35,NULL,'Daniel','Daniel Burchell',NULL),(36,NULL,'Ryan','Ryan Shervey',NULL),(37,NULL,'Kane','Kane Ross',NULL),(38,NULL,'Jesse','Jesse Chang',NULL),(39,NULL,'Travis','Travis Mctwigandberries',NULL),(40,NULL,'Tim','Tim Bramble',NULL),(41,NULL,'Dio','Dio Cretus',NULL),(42,NULL,'Drake','Drake Descher',NULL),(43,NULL,'Mike','Mike Becker',NULL),(44,NULL,'Don','Don Ironmonkey',NULL),(45,NULL,'Enid','Enid Solo',NULL),(46,NULL,'Jimmy','Jimmy Le',NULL),(47,NULL,'Basel','Basel Dabbas',NULL),(48,NULL,'Josh','Josh Harnish',NULL),(49,NULL,'Paul','Paul Shap',NULL),(50,NULL,'Brock','Brock Hall',NULL),(51,NULL,'Sean','Sean Beaver',NULL),(52,NULL,'Christos','Christos',NULL),(53,NULL,'Jasper','Jasper Hertle',NULL),(54,NULL,'Quan','Quan Nguyen',NULL);
 /*!40000 ALTER TABLE `Profile` ENABLE KEYS */;
 UNLOCK TABLES;
 

  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4EEA9393A76ED395` (`user_id`),
  CONSTRAINT `FK_4EEA9393A76ED395` FOREIGN KEY (`user_id`) REFERENCES `User` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--


LOCK TABLES `Warclan` WRITE;
/*!40000 ALTER TABLE `Warclan` DISABLE KEYS */;
INSERT INTO `Warclan` VALUES (1,1,1,167,0),(2,5,1,117,0),(7,1,4,168,0),(8,11,4,17,0),(9,1,5,169,0),(10,12,5,50,0),(11,1,6,170,86),(12,13,6,89,75),(13,1,7,170,60),(14,14,7,80,63),(15,1,8,171,61),(16,15,8,111,83),(17,1,9,172,60),(18,16,9,95,80),(19,1,10,173,54),(20,17,10,71,71),(21,1,11,174,47),(22,18,11,121,63),(23,1,12,175,33),(24,19,12,70,68),(25,1,13,176,42),(26,20,13,149,66),(27,1,14,177,56),(28,21,14,78,74),(29,1,15,178,54),(30,22,15,74,82),(31,1,16,179,51),(32,23,16,55,65),(33,1,17,180,64),(34,24,17,140,69),(35,1,18,181,44),(36,25,18,19,61),(37,1,19,182,44),(38,26,19,31,64),(39,1,20,183,17),(40,27,20,6,75),(41,1,21,184,51),(42,28,21,88,81),(43,1,22,185,71),(44,29,22,94,84),(45,1,23,186,61),(46,30,23,117,79),(47,1,24,187,40),(48,31,24,48,60),(49,1,25,188,43),(50,32,25,63,58),(51,1,26,189,53),(52,33,26,101,77),(53,1,27,190,53),(54,34,27,125,75),(55,1,28,191,61),(56,35,28,107,64),(57,1,29,192,71),(58,36,29,141,76),(59,1,30,193,28),(60,37,30,67,50),(61,1,31,194,27),(62,38,31,129,58),(63,1,32,195,71),(64,39,32,205,54),(65,1,33,195,51),(66,40,33,156,61),(67,1,34,196,44),(68,42,34,151,49),(69,1,35,197,43),(70,43,35,73,42),(71,1,36,197,20),(72,44,36,97,41),(73,1,37,198,53),(74,45,37,117,42),(75,1,38,198,17),(76,46,38,28,24),(77,1,39,199,48),(78,47,39,64,45),(79,1,40,199,25),(80,48,40,107,38),(81,1,41,200,25),(82,49,41,26,33),(83,1,42,201,24),(84,50,42,30,34),(85,1,43,202,37),(86,51,43,47,49),(87,1,44,203,40),(88,52,44,45,50),(89,1,45,204,35),(90,53,45,11,54),(91,1,46,205,39),(92,54,46,128,54),(93,1,47,206,38),(94,55,47,77,50),(95,1,48,207,46),(96,56,48,116,67),(97,1,49,208,56),(98,57,49,97,60),(99,1,50,209,54),(100,58,50,118,58),(101,1,51,210,52),(102,59,51,81,63),(103,1,52,211,52),(104,60,52,41,68),(105,1,53,212,58),(106,61,53,96,64),(107,1,54,213,61),(108,62,54,118,60),(109,1,55,213,23),(110,63,55,89,39),(111,1,56,214,38),(112,64,56,69,51),(113,1,57,215,79),(114,67,57,159,78),(115,1,58,215,64),(116,68,58,64,76),(117,1,59,217,54),(118,69,59,112,78),(119,1,60,217,65),(120,70,60,79,81),(121,1,61,218,76),(122,71,61,91,88),(123,1,62,219,93),(124,72,62,111,82);
/*!40000 ALTER TABLE `Warclan` ENABLE KEYS */;
UNLOCK TABLES;

