   `title` tinytext NOT NULL,
   `type` enum('spec','gen','cat','app','ep','char') DEFAULT NULL,
   `uses` int(11) NOT NULL DEFAULT '0'
-) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
 
 INSERT INTO `tags` (`tid`, `name`, `title`, `type`, `uses`) VALUES
-(1, 'unicorn', '', 'spec', 8),
-(2, 'earth pony', '', 'spec', 3),
-(3, 'pegasus', '', 'spec', 5),
-(4, 'alicorn', '', 'spec', 2),
+(1, 'unicorn', '', 'spec', 10),
+(2, 'earth pony', '', 'spec', 4),
+(3, 'pegasus', '', 'spec', 7),
+(4, 'alicorn', '', 'spec', 1),
 (5, 'bat pony', '', 'spec', 0),
-(6, 'mane six', 'Ponies who are one of the show''s six main characters', 'cat', 6),
-(7, 'minor character', 'Ponies who had a speaking role and/or interacted with the mane six', 'cat', 10),
+(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', 15),
 (8, 'background character', 'Ponies whose only purpose is filling crowds, with no to minimal speaking roles', 'cat', 1),
 (9, 'antagonist', '', 'cat', 0),
 (10, 'pet', '', 'cat', 0),
-(11, 'male', '', 'gen', 1),
-(12, 'female', '', 'gen', 16),
-(14, 'twilight sparkle', '', 'char', 2),
-(15, 'gala dress', 'All gala dress colors', 'app', 1),
+(11, 'male', '', 'gen', 3),
+(12, 'female', '', 'gen', 20),
+(14, 'twilight sparkle', '', 'char', 1),
+(15, 'gala dress', 'All gala dress colors', 'app', 0),
 (16, 'human', 'Refers to Equestria Girls characters', 'spec', 0),
 (19, 's1e1', '', 'ep', 0),
 (20, 's1e26', '', 'ep', 0),
 (21, 's5e12', '', 'ep', 0),
-(22, 'applejack', '', 'char', 0),
-(23, 'pinkie pie', '', 'char', 0),
-(24, 'fluttershy', '', 'char', 0),
-(25, 'rainbow dash', '', 'char', 0),
-(26, 'rarity', '', 'char', 0);
+(22, 'applejack', '', 'char', 1),
+(23, 'pinkie pie', '', 'char', 1),
+(24, 'fluttershy', '', 'char', 1),
+(25, 'rainbow dash', '', 'char', 1),
+(26, 'rarity', '', 'char', 1),
+(27, 'wonderbolt', 'Wonderbolt characters', 'cat', 2),
+(28, 'parent', 'Parents of other characters', 'cat', 2),
+(29, 'dragon', '', 'spec', 1),
+(30, 'spike', '', 'char', 1),
+(31, 'minuette', '', 'char', 1),
+(32, 'lyra heartstrings', '', 'char', 1),
+(33, 'fashion plate', '', 'char', 1),
+(34, 'sassy saddles', '', 'char', 1),
+(35, 'twinkleshine', '', 'char', 1),
+(36, 'lemon hearts', '', 'char', 1),
+(37, 'granny smith', '', 'char', 1),
+(38, 'fleetfoot', '', 'char', 1),
+(39, 'stormy flare', '', 'char', 1),
+(40, 'wind rider', '', 'char', 1),
+(41, 'sugar belle', '', 'char', 0),
+(42, 's5e15', '', 'ep', 2),
+(43, 's5e14', '', 'ep', 2),
+(44, 'foal', '', 'cat', 3),
+(45, 'cutie mark crusader', '', 'cat', 3),
+(46, 'apple bloom', '', 'char', 0),
+(47, 'scootaloo', '', 'char', 0),
+(48, 'sweetie belle', '', 'char', 0);
 
 
 ALTER TABLE `colorgroups`

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

DROP DATABASE `mlpvc-colorguide`;
CREATE DATABASE `mlpvc-colorguide` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

  `ponyid` int(11) NOT NULL,
  `label` varchar(255) NOT NULL,
  `order` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8;

INSERT INTO `colorgroups` (`groupid`, `ponyid`, `label`, `order`) VALUES
(17, 6, 'Coat', 0),
