 LOCK TABLES `specialisations` WRITE;
 /*!40000 ALTER TABLE `specialisations` DISABLE KEYS */;
 
-INSERT INTO `specialisations` (`id`, `name`, `created`, `modified`)
-VALUES
-	(1,'Healing','2016-08-31 16:00:00','2016-08-31 16:00:00'),
-	(2,'Support','2016-08-31 16:00:00','2016-08-31 16:00:00'),
-	(3,'Hybrid damage','2016-08-31 16:00:00','2016-08-31 16:00:00'),
-	(4,'Magic damage','2016-08-31 16:00:00','2016-08-31 16:00:00'),
-	(5,'Physical damage','2016-08-31 16:00:00','2016-08-31 16:00:00'),
-	(7,'Tank','2016-08-31 16:00:00','2016-08-31 16:00:00');
+INSERT INTO `specialisations` (`id`, `name`, `stats`, `team_pick_order`, `created`, `modified`)
+VALUES
+	(1,'Healing','spr,mag,hp',4,'2016-08-31 16:00:00','2016-08-31 16:00:00'),
+	(2,'Support','mag,def,mp',5,'2016-08-31 16:00:00','2016-08-31 16:00:00'),
+	(3,'Hybrid damage','atk,mag,mp',6,'2016-08-31 16:00:00','2016-08-31 16:00:00'),
+	(4,'Magic damage','mag,spr,mp',3,'2016-08-31 16:00:00','2016-08-31 16:00:00'),
+	(5,'Physical damage','atk,def,hp',2,'2016-08-31 16:00:00','2016-08-31 16:00:00'),
+	(7,'Tank','def,spr,hp',1,'2016-08-31 16:00:00','2016-08-31 16:00:00');
 
 /*!40000 ALTER TABLE `specialisations` ENABLE KEYS */;
 UNLOCK TABLES;

  `user_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `level` int(11) DEFAULT '1',
  `rarity` int(11) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),

LOCK TABLES `acquires` WRITE;
/*!40000 ALTER TABLE `acquires` DISABLE KEYS */;

INSERT INTO `acquires` (`id`, `user_id`, `unit_id`, `level`, `rarity_id`, `created`, `modified`)
VALUES
	(1,1,1,66,5,'2016-09-02 09:57:35','2016-09-06 08:44:25'),
	(3,1,2,25,5,'2016-09-02 13:22:16','2016-09-06 08:51:44'),
	(4,1,76,63,5,'2016-09-02 13:23:24','2016-09-09 11:34:55'),
	(5,1,3,33,5,'2016-09-02 13:23:45','2016-09-09 12:17:13'),
	(6,1,28,36,4,'2016-09-02 13:24:00','2016-09-06 08:54:33'),
	(7,1,52,28,5,'2016-09-02 13:24:14','2016-09-09 11:32:16'),
	(8,1,60,55,4,'2016-09-02 13:27:51','2016-09-09 11:36:35'),
	(9,1,23,18,3,'2016-09-02 13:28:03','2016-09-02 13:28:03'),
	(10,1,31,23,3,'2016-09-02 13:28:15','2016-09-06 08:52:01'),
	(11,1,7,30,2,'2016-09-02 13:28:24','2016-09-06 08:57:59'),
	(12,1,8,30,2,'2016-09-02 13:28:36','2016-09-06 08:58:13'),
	(13,1,16,23,3,'2016-09-02 13:28:47','2016-09-09 12:00:22'),
	(14,1,56,6,3,'2016-09-02 13:28:57','2016-09-09 11:33:49'),
	(15,1,57,1,3,'2016-09-02 13:29:06','2016-09-06 09:02:19'),
	(16,1,27,10,4,'2016-09-02 13:29:17','2016-09-02 13:29:17'),
	(17,1,33,60,4,'2016-09-02 13:29:27','2016-09-02 13:29:27'),
	(18,1,35,60,4,'2016-09-02 13:29:40','2016-09-02 13:29:40'),
	(19,1,37,8,4,'2016-09-02 13:29:52','2016-09-02 13:29:52'),
	(20,1,66,3,5,'2016-09-02 13:30:02','2016-09-06 08:53:37'),
	(21,1,78,1,4,'2016-09-02 13:30:16','2016-09-02 13:30:16'),
	(22,1,13,1,3,'2016-09-02 13:30:26','2016-09-02 13:30:26'),
	(23,1,15,40,3,'2016-09-02 13:30:35','2016-09-02 13:30:35'),
	(24,1,18,1,3,'2016-09-02 13:30:47','2016-09-02 13:30:47'),
	(25,1,19,15,3,'2016-09-02 13:30:58','2016-09-09 11:34:40'),
	(26,1,20,13,3,'2016-09-02 13:31:09','2016-09-02 13:31:09'),
	(27,1,26,1,3,'2016-09-02 13:31:20','2016-09-02 13:31:20'),
	(28,1,29,1,3,'2016-09-02 13:31:30','2016-09-02 13:31:30'),
	(29,1,30,8,3,'2016-09-02 13:31:41','2016-09-09 11:36:51'),
	(30,1,32,18,3,'2016-09-02 13:31:50','2016-09-09 12:02:24'),
	(31,1,36,1,3,'2016-09-02 13:32:00','2016-09-02 13:32:00'),
	(32,1,55,12,3,'2016-09-02 13:32:09','2016-09-09 11:38:29'),
	(33,1,58,1,3,'2016-09-02 13:32:29','2016-09-02 13:32:29'),
	(34,1,4,30,2,'2016-09-02 13:37:15','2016-09-02 13:37:15'),
	(35,1,5,30,2,'2016-09-02 13:37:51','2016-09-02 13:37:51'),
