 
 
 ALTER TABLE `colorgroups`
-  MODIFY `groupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=239;
+  MODIFY `groupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246;
 ALTER TABLE `colors`
-  MODIFY `colorid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=924;
+  MODIFY `colorid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=957;
 ALTER TABLE `ponies`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
 ALTER TABLE `tags`
-  MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
+  MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
 
 ALTER TABLE `colorgroups`
   ADD CONSTRAINT `colorgroups_ibfk_1` FOREIGN KEY (`ponyid`) REFERENCES `ponies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;


INSERT INTO `tags` (`tid`, `name`, `title`, `type`, `uses`) VALUES
(1, 'unicorn', '', 'spec', 16),
(2, 'earth pony', '', 'spec', 9),
(3, 'pegasus', '', 'spec', 8),
(4, 'alicorn', '', 'spec', 3),
(5, 'bat pony', '', 'spec', 0),
(6, 'mane six', 'Ponies who are one of the show''s six main characters', 'cat', 7),
(7, 'minor character', 'Ponies who had a speaking role and/or interacted with the mane six', 'cat', 24),
(8, 'background character', 'Ponies whose only purpose is filling crowds, with no to minimal speaking roles', 'cat', 3),
(9, 'antagonist', '', 'cat', 3),
(10, 'pet', '', 'cat', 0),
(11, 'male', '', 'gen', 7),
(12, 'female', '', 'gen', 30),
(14, 'twilight sparkle', '', 'char', 1),
(15, 'gala dress', 'All gala dress colors', 'app', 0),
(16, 'human', 'Refers to Equestria Girls characters', 'spec', 0),

(9, 13, 'Princess Luna', '', NULL, '2015-09-29 18:55:38'),
(10, NULL, 'Minuette', 'For convenience, the color of the glass on her cutie mark is solid rather than transparent, thus the sand should be above.', NULL, '2015-07-25 14:49:44'),
(11, NULL, 'Derpy / Muffins', '', NULL, '2015-08-26 03:53:49'),
(12, NULL, 'Lyra Heartstrings', '', NULL, '2015-08-26 04:08:33'),
(13, NULL, 'Whoa Nelly', '', NULL, '2015-09-17 03:43:22'),
(14, NULL, 'Fashion Plate', '', NULL, '2015-09-17 04:02:26'),
(15, NULL, 'Sassy Saddles', '', NULL, '2015-09-17 04:22:20'),
