 (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);
+(78, 'original character', 'Characters not canon to the show''s universe', 'cat', 1),
+(79, 'cheese sandwich', '', 'char', 1);
 
 
 ALTER TABLE `appearances`



ALTER TABLE `appearances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
ALTER TABLE `colorgroups`
  MODIFY `groupid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=267;
ALTER TABLE `colors`
  MODIFY `colorid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1031;
ALTER TABLE `tags`
  MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

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


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