ALTER TABLE `master_colors`
  ADD COLUMN `pantone_code` varchar(20) NOT NULL DEFAULT '' AFTER `hex_code`;

UPDATE `master_colors` SET `pantone_code` = '19-4052 TCX' WHERE `color_name` = 'Navy';
UPDATE `master_colors` SET `pantone_code` = '11-0602 TCX' WHERE `color_name` = 'White';
UPDATE `master_colors` SET `pantone_code` = '19-0303 TCX' WHERE `color_name` = 'Black';
UPDATE `master_colors` SET `pantone_code` = '18-1763 TCX' WHERE `color_name` = 'Red';
UPDATE `master_colors` SET `pantone_code` = '18-3943 TCX' WHERE `color_name` = 'Royal Blue';
UPDATE `master_colors` SET `pantone_code` = '14-4318 TCX' WHERE `color_name` = 'Sky Blue';
UPDATE `master_colors` SET `pantone_code` = '13-2010 TCX' WHERE `color_name` = 'Light Pink';
UPDATE `master_colors` SET `pantone_code` = '17-2034 TCX' WHERE `color_name` = 'Hot Pink';
UPDATE `master_colors` SET `pantone_code` = '19-1535 TCX' WHERE `color_name` = 'Maroon';
UPDATE `master_colors` SET `pantone_code` = '19-1536 TCX' WHERE `color_name` = 'Burgundy';
UPDATE `master_colors` SET `pantone_code` = '18-6024 TCX' WHERE `color_name` = 'Forest Green';
UPDATE `master_colors` SET `pantone_code` = '17-0530 TCX' WHERE `color_name` = 'Olive';
UPDATE `master_colors` SET `pantone_code` = '15-1132 TCX' WHERE `color_name` = 'Khaki';
UPDATE `master_colors` SET `pantone_code` = '12-0605 TCX' WHERE `color_name` = 'Beige';
UPDATE `master_colors` SET `pantone_code` = '17-4402 TCX' WHERE `color_name` = 'Grey';
UPDATE `master_colors` SET `pantone_code` = '18-0615 TCX' WHERE `color_name` = 'Charcoal';
UPDATE `master_colors` SET `pantone_code` = '14-0848 TCX' WHERE `color_name` = 'Yellow';
UPDATE `master_colors` SET `pantone_code` = '15-1150 TCX' WHERE `color_name` = 'Orange';
UPDATE `master_colors` SET `pantone_code` = '16-1546 TCX' WHERE `color_name` = 'Coral';
UPDATE `master_colors` SET `pantone_code` = '18-3027 TCX' WHERE `color_name` = 'Purple';
UPDATE `master_colors` SET `pantone_code` = '14-3812 TCX' WHERE `color_name` = 'Lavender';
UPDATE `master_colors` SET `pantone_code` = '15-5519 TCX' WHERE `color_name` = 'Turquoise';
UPDATE `master_colors` SET `pantone_code` = '17-4421 TCX' WHERE `color_name` = 'Teal';
UPDATE `master_colors` SET `pantone_code` = '13-6111 TCX' WHERE `color_name` = 'Mint';
UPDATE `master_colors` SET `pantone_code` = '11-0105 TCX' WHERE `color_name` = 'Cream';
UPDATE `master_colors` SET `pantone_code` = '11-0107 TCX' WHERE `color_name` = 'Ivory';
UPDATE `master_colors` SET `pantone_code` = '18-1142 TCX' WHERE `color_name` = 'Brown';
UPDATE `master_colors` SET `pantone_code` = '15-1225 TCX' WHERE `color_name` = 'Tan';
UPDATE `master_colors` SET `pantone_code` = '16-1334 TCX' WHERE `color_name` = 'Camel';
UPDATE `master_colors` SET `pantone_code` = '18-6018 TCX' WHERE `color_name` = 'Bottle Green';
