 (263, 45, 'Mane & Tail', 1),
 (264, 45, 'Iris', 2),
 (265, 45, 'Cutie Mark', 3),
-(266, 45, 'Magic', 4);
+(266, 45, 'Magic', 4),
+(267, 46, 'Coat', 0),
+(268, 46, 'Mane & Tail', 1),
+(269, 46, 'Iris', 2),
+(270, 46, 'Cutie Mark', 3),
+(271, 46, 'Shirt', 4),
+(272, 46, 'Glasses', 5);
 
 CREATE TABLE `colors` (
   `colorid` int(11) NOT NULL,

(75, 'lily longsocks', '', 'char', 1),
(76, 'human', '', 'spec', 1),
(77, 'shining armor', '', 'char', 1),
(78, 'original character', 'Characters not canon to the show''s universe', 'cat', 1);


ALTER TABLE `appearances`



ALTER TABLE `appearances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
ALTER TABLE `colorgroups`
  MODIFY `groupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=273;
ALTER TABLE `colors`
  MODIFY `colorid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1052;
ALTER TABLE `tags`
  MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

ALTER TABLE `colorgroups`
  ADD CONSTRAINT `colorgroups_ibfk_1` FOREIGN KEY (`ponyid`) REFERENCES `appearances` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
