   `ponyid` int(11) NOT NULL,
   `label` varchar(255) NOT NULL,
   `order` tinyint(4) NOT NULL DEFAULT '0'
-) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8;
 
 INSERT INTO `colorgroups` (`groupid`, `ponyid`, `label`, `order`) VALUES
 (17, 6, 'Coat', 0),

(387, 107, 'Shadow Outline', '#4A295A', 3),
(388, 107, 'Shadow Fill 1', '#69377D', 4),
(389, 107, 'Shadow Fill 2', '#9568AA', 5),
(390, 58, 'Hairband', '#EC3F41', 2),
(391, 68, 'Blue Fill', '#1B98D1', 5),
(392, 70, 'Cloud Fill', '#FFFFFF', 1),
(393, 70, 'Blue Streak', '#1B98D1', 4);

CREATE TABLE IF NOT EXISTS `ponies` (
  `id` int(11) NOT NULL,
  `label` tinytext NOT NULL,
  `notes` tinytext NOT NULL,
  `added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;

INSERT INTO `ponies` (`id`, `label`, `notes`, `added`) VALUES
(1, 'Applejack', '', '2015-09-21 18:46:54'),
(2, 'Fluttershy', '', '2015-09-21 18:54:47'),
(3, 'Pinkie Pie', '', '2015-09-21 18:52:26'),
(4, 'Rainbow Dash', '', '2015-09-21 19:01:33'),
(5, 'Rarity', '', '2015-09-21 19:18:24'),
(6, 'Twilight Sparkle', 'Far legs use darker colors', '2015-08-24 19:04:32'),
(7, 'Spike', '', '2015-09-21 19:43:59'),
(100, 'Minuette', '', '2015-07-25 14:49:44'),
(102, 'Derpy / Muffins', 'From S509 - Slice of Life', '2015-08-26 03:53:49'),
(103, 'Lyra Heartstrings', 'From S5E09 - Slice of Life', '2015-08-26 04:08:33'),
(104, 'Whoa Nelly', 'From S5E14 "Canterlot Boutique"', '2015-09-17 03:43:22'),
(105, 'Fashion Plate', 'From S5E14 Canterlot Boutique', '2015-09-17 04:02:26'),
(106, 'Sassy Saddles', 'From S5E14 Canterlot Boutique', '2015-09-17 04:22:20'),
(113, 'Twinkleshine', '', '2015-09-21 20:25:31'),
(114, 'Lemon Hearts', '', '2015-09-21 20:30:06'),
(115, 'Granny Smith', '', '2015-09-21 20:37:57'),
(116, 'Fleetfoot', '', '2015-09-21 20:58:56'),
(117, 'Stormy Flare', 'From S5E15', '2015-09-22 05:20:14');

CREATE TABLE IF NOT EXISTS `tagged` (
  `tid` int(11) NOT NULL,

(104, 117, 'Iris (One highlight)', 2),
(105, 117, 'Cutie Mark', 3),
(106, 117, 'Earrings/Necklace', 5),
(107, 117, 'Sweater', 4),
(108, 118, 'Coat', 0),
(109, 118, 'Mane & Tail', 1),
(110, 118, 'Iris', 2),
(111, 118, 'Cutie Mark', 3),
(112, 118, 'Jacket', 0),
(113, 118, 'Scarf', 0),
(114, 118, 'Badge', 0),
(115, 118, 'Teeth (different from normal)', 0),
(116, 119, 'Coat', 0),
(117, 119, 'Mane & Tail', 1),
(118, 119, 'Iris', 2),
(119, 119, 'Cutie Mark', 3),
(120, 119, 'Magic', 0),
(121, 119, 'Hair Tie', 0),
(122, 120, 'Coat', 0),
(123, 120, 'Mane & Tail', 1),
(124, 120, 'Iris', 2),
(126, 121, 'Coat', 0),
(127, 121, 'Mane & Tail', 1),
(128, 121, 'Iris', 2),
(130, 120, 'Bow', 0),
(131, 122, 'Coat', 0),
(132, 122, 'Mane & Tail', 1),
(133, 122, 'Iris', 2);

CREATE TABLE IF NOT EXISTS `colors` (
  `colorid` int(11) NOT NULL,
