 (221, 36, 'Sweater', 4),
 (222, 36, 'Sweater Buttons / Hair Beads', 5),
 (223, 36, 'Glasses', 6),
-(224, 36, 'Magic', 7);
+(224, 36, 'Magic', 7),
+(225, 37, 'Coat', 0),
+(226, 37, 'Mane & Tail', 1),
+(227, 37, 'Iris', 2),
+(229, 38, 'Coat', 0),
+(230, 38, 'Mane & Tail', 1),
+(231, 38, 'Iris', 2);
 
 CREATE TABLE `colors` (
   `colorid` int(11) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tags` (`tid`, `name`, `title`, `type`, `uses`) VALUES
(1, 'unicorn', '', 'spec', 14),
(2, 'earth pony', '', 'spec', 8),
(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', 23),
(8, 'background character', 'Ponies whose only purpose is filling crowds, with no to minimal speaking roles', 'cat', 1),
(9, 'antagonist', '', 'cat', 3),
(10, 'pet', '', 'cat', 0),
(11, 'male', '', 'gen', 6),
(12, 'female', '', 'gen', 28),
(14, 'twilight sparkle', '', 'char', 1),
(15, 'gala dress', 'All gala dress colors', 'app', 0),
(16, 'human', 'Refers to Equestria Girls characters', 'spec', 0),

(65, 's5e2', '', 'ep', 4),
(66, 'big macintosh', '', 'char', 1),
(67, 'sibling', '', 'cat', 3),
(68, 'moondancer', '', 'char', 1),
(70, 'filly', '', 'cat', 2),
(72, 'dinky doo', '', 'char', 1),
(73, 'berry pinch', '', 'char', 1);


ALTER TABLE `colorgroups`
