/* Database changes to prepare ecommerce_wetcover prior to running ProdTypeScript.php
in order to generate product type attributes for the Wetcover Tools products

First, we select the database, then backup the product_attribute_link table by copying it */

USE `ecommerce_wetcover`;

create table if not exists product_attribute_link_bk select * from product_attribute_link;


-- --------------------------------------------------------

--
-- Table structure for table `aa_import_tmp`
--

CREATE TABLE `aa_import_tmp` (
  `merchandise_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `merchandise_name` varchar(50) NOT NULL,
  `prod_type` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aa_import_tmp`
--

INSERT INTO `aa_import_tmp` (`merchandise_id`, `product_id`, `merchandise_name`, `prod_type`) VALUES
(3, 3, 'Tool 223', 'Keyboard'),
(5, 5, 'Tool 214', 'Keyboard'),
(8, 8, 'Tool 146', 'Keyboard'),
(10, 10, 'Tool 133', 'Keyboard'),
(12, 12, 'Tool 280', 'Keyboard'),
(14, 14, 'Tool 104', 'Keyboard'),
(16, 16, 'Tool 180', 'Keyboard'),
(20, 20, 'Tool 250', 'Keyboard'),
(27, 27, 'Tool 370', 'Keyboard'),
(29, 29, 'Tool 361', 'Keyboard'),
(31, 31, 'Tool 345', 'Keyboard'),
(33, 33, 'Tool 49', 'Keyboard'),
(37, 37, 'Tool 52', 'Keyboard'),
(40, 40, 'Tool 56', 'Keyboard'),
(44, 44, 'Tool 70', 'Keyboard'),
(46, 46, 'Tool 183', 'Keyboard'),
(49, 49, 'Tool 75', 'Keyboard'),
(53, 53, 'Tool 399', 'Keyboard'),
(55, 55, 'Tool 101', 'Keyboard'),
(60, 60, 'Tool 194', 'Keyboard'),
(64, 64, 'Tool 87', 'Keyboard'),
(69, 69, 'Tool 251', 'Keyboard'),
(71, 71, 'Tool 63', 'Keyboard'),
(74, 74, 'Tool 109', 'Keyboard'),
(76, 76, 'Tool 108', 'Keyboard'),
(78, 78, 'Tool 35', 'Keyboard'),
(80, 80, 'Tool 127', 'Keyboard'),
(84, 84, 'Tool 196', 'Keyboard'),
(87, 87, 'Tool 337', 'Keyboard'),
(89, 89, 'Tool 159', 'Keyboard'),
(91, 91, 'Tool 40', 'Keyboard'),
(93, 93, 'Tool 199', 'Keyboard'),
(95, 95, 'Tool 116', 'Keyboard'),
(97, 97, 'Tool 294', 'Keyboard'),
(99, 99, 'Tool 294 (C/D)', 'Keyboard'),
(101, 101, 'Tool 403', 'Keyboard'),
(106, 106, 'Tool 224', 'Keyboard'),
(108, 108, 'Tool 102', 'Keyboard'),
(111, 111, 'Tool 80', 'Keyboard'),
(114, 114, 'Tool 30', 'Keyboard'),
(116, 116, 'Tool 141', 'Keyboard'),
(138, 138, 'Tool 98', 'Keyboard'),
(142, 142, 'Tool 247', 'Keyboard'),
(159, 159, 'Tool 88', 'Keyboard'),
(163, 163, 'Tool 14', 'Keyboard'),
(169, 169, 'Tool 145', 'Keyboard'),
(174, 174, 'Tool 165', 'Keyboard'),
(176, 176, 'Tool 28', 'Keyboard'),
(179, 179, 'Tool 306', 'Keyboard'),
(193, 193, 'Tool 29', 'Keyboard'),
(200, 200, 'Tool 200', 'Keyboard'),
(224, 224, 'Tool 161', 'Keyboard'),
(231, 231, 'Tool 286', 'Keyboard'),
(236, 236, 'Tool 166', 'Keyboard'),
(238, 238, 'Tool 46', 'Keyboard'),
(247, 247, 'Tool 190', 'Keyboard'),
(261, 261, 'Tool 294 C/D', 'Keyboard'),
(265, 265, 'Tool 115', 'Keyboard'),
(267, 267, 'Tool 202', 'Keyboard'),
(276, 276, 'Tool 390', 'Keyboard'),
(279, 279, 'Tool 326', 'Keyboard'),
(284, 284, 'Tool 271', 'Keyboard'),
(286, 286, 'Tool 298', 'Keyboard'),
(290, 290, 'Tool 374', 'Keyboard'),
(292, 292, 'Tool 354', 'Keyboard'),
(295, 295, 'Tool 402', 'Keyboard'),
(297, 297, 'Tool 373', 'Keyboard'),
(300, 300, 'Tool 149', 'Keyboard'),
(302, 302, 'Tool 169', 'Keyboard'),
(307, 307, 'Tool 253', 'Keyboard'),
(310, 310, 'Tool 394', 'Keyboard'),
(312, 312, 'Tool 394A', 'Keyboard'),
(315, 315, 'Tool 391', 'Keyboard'),
(323, 323, 'Tool 58', 'Keyboard'),
(341, 341, 'Tool 352', 'Keyboard'),
(344, 344, 'Tool 357', 'Keyboard'),
(347, 347, 'Tool 287', 'Keyboard'),
(349, 349, 'Tool 327B', 'Keyboard'),
(351, 351, 'Tool 327A', 'Keyboard'),
(353, 353, 'Tool 289', 'Keyboard'),
(355, 355, 'Tool 327', 'Keyboard'),
(357, 357, 'Tool 320 (C/D)', 'Keyboard'),
(359, 359, 'Tool 162', 'Keyboard'),
(361, 361, 'Tool 320A', 'Keyboard'),
(364, 364, 'Tool 319a', 'Keyboard'),
(367, 367, 'Tool 319', 'Keyboard'),
(369, 369, 'Tool 320', 'Keyboard'),
(373, 373, 'Tool 39', 'Keyboard'),
(375, 375, 'Tool 25', 'Keyboard'),
(379, 379, 'Tool 38', 'Keyboard'),
(381, 381, 'Tool 178', 'Keyboard'),
(386, 386, 'Tool 156', 'Keyboard'),
(388, 388, 'Tool 157', 'Keyboard'),
(390, 390, 'Tool 241', 'Keyboard'),
(397, 397, 'Tool 41', 'Keyboard'),
(410, 410, 'Tool 140', 'Keyboard'),
(414, 414, 'Tool 64', 'Keyboard'),
(417, 417, 'Tool 284', 'Keyboard'),
(419, 419, 'Tool 284b', 'Keyboard'),
(429, 429, 'Tool 138', 'Keyboard'),
(431, 431, 'Tool 61', 'Keyboard'),
(450, 450, 'Tool 62', 'Keyboard'),
(454, 454, 'Tool 232', 'Keyboard'),
(464, 464, 'Tool 307', 'Keyboard'),
(468, 468, 'Tool 76', 'Keyboard'),
(470, 470, 'Tool 81', 'Keyboard'),
(473, 473, 'Tool 158', 'Keyboard'),
(475, 475, 'Tool 160', 'Keyboard'),
(477, 477, 'Tool 137', 'Keyboard'),
(479, 479, 'Tool 315', 'Keyboard'),
(481, 481, 'Tool 123', 'Keyboard'),
(483, 483, 'Tool 91', 'Keyboard'),
(489, 489, 'Tool 193', 'Keyboard'),
(492, 492, 'Tool 97', 'Keyboard'),
(494, 494, 'Tool 356', 'Keyboard'),
(496, 496, 'Tool 266', 'Keyboard'),
(502, 502, 'Tool 82', 'Keyboard'),
(507, 507, 'Tool 93', 'Keyboard'),
(512, 512, 'Tool 219', 'Keyboard'),
(514, 514, 'Tool 181', 'Keyboard'),
(521, 521, 'Tool 189', 'Keyboard'),
(524, 524, 'Tool 213', 'Keyboard'),
(528, 528, 'Tool 323', 'CARD'),
(532, 532, 'Tool 362', 'Keyboard'),
(534, 534, 'Tool 57', 'Keyboard'),
(537, 537, 'Tool 83', 'Keyboard'),
(539, 539, 'Tool 118', 'Keyboard'),
(541, 541, 'Tool 143', 'Keyboard'),
(545, 545, 'Tool 66', 'Keyboard'),
(550, 550, 'Tool 155', 'Keyboard'),
(553, 553, 'Tool 191', 'Keyboard'),
(555, 555, 'Tool 68', 'Keyboard'),
(557, 557, 'Tool 150', 'Keyboard'),
(560, 560, 'Tool 264', 'Keyboard'),
(563, 563, 'Tool 132', 'CARD'),
(566, 566, 'Tool 205', 'Keyboard'),
(572, 572, 'Tool 125', 'Keyboard'),
(574, 574, 'Tool 148', 'Keyboard'),
(589, 589, 'Tool 67', 'Keyboard'),
(594, 594, 'Tool 142', 'Keyboard'),
(601, 601, 'Tool 295', 'Keyboard'),
(603, 603, 'Tool 329', 'Keyboard'),
(606, 606, 'Tool 341', 'Keyboard'),
(610, 610, 'Tool 144', 'Keyboard'),
(617, 617, 'Tool 221', 'Keyboard'),
(620, 620, 'Tool 300', 'Keyboard'),
(623, 623, 'Tool 255', 'Keyboard'),
(625, 625, 'Tool 218', 'Keyboard'),
(631, 631, 'Tool 110', 'Keyboard'),
(635, 635, 'Tool 230', 'Keyboard'),
(640, 640, 'Tool 176', 'Keyboard'),
(642, 642, 'Tool 134', 'Keyboard'),
(644, 644, 'Tool 175', 'Keyboard'),
(648, 648, 'Tool 114', 'Keyboard'),
(652, 652, 'Tool 198', 'Keyboard'),
(673, 673, 'Tool 154', 'Keyboard'),
(675, 675, 'Tool 51', 'Keyboard'),
(680, 680, 'Tool 37', 'Keyboard'),
(682, 682, 'Tool 184', 'Keyboard'),
(685, 685, 'Tool 314', 'Keyboard'),
(687, 687, 'Tool 407', 'Keyboard'),
(698, 698, 'Tool 274', 'Keyboard'),
(705, 705, 'Tool 335', 'Keyboard'),
(707, 707, 'Tool 334', 'Keyboard'),
(717, 717, 'Tool 3', 'Keyboard'),
(720, 720, 'Tool 187', 'Keyboard'),
(733, 733, 'Tool 314 (C/D)', 'Keyboard'),
(736, 736, 'Tool 328', 'Keyboard'),
(738, 738, 'Tool 325', 'Keyboard'),
(740, 740, 'Tool 379', 'Keyboard'),
(752, 752, 'Tool 308', 'Keyboard'),
(757, 757, 'Tool 15', 'Keyboard'),
(763, 763, 'Tool 2', 'Keyboard'),
(765, 765, 'Tool 256', 'Keyboard'),
(769, 769, 'Tool 84', 'Keyboard'),
(776, 776, 'Tool 124', 'Keyboard'),
(779, 779, 'Tool 203', 'Keyboard'),
(788, 788, 'Tool 207', 'Keyboard'),
(790, 790, 'Tool 131', 'Keyboard'),
(797, 797, 'Tool 107', 'Keyboard'),
(801, 801, 'Tool 164', 'Keyboard'),
(803, 803, 'Tool 291', 'Keyboard'),
(811, 811, 'Tool 105', 'Keyboard'),
(859, 859, 'Tool 249', 'Keyboard'),
(870, 870, 'Tool 122', 'Keyboard'),
(879, 879, 'Tool 10', 'Keyboard'),
(887, 887, 'Tool 69', 'Keyboard'),
(900, 900, 'Tool 36', 'Keyboard'),
(906, 906, 'Tool 85', 'Keyboard'),
(910, 910, 'Tool 340', 'Keyboard'),
(912, 912, 'Tool 376', 'Keyboard'),
(918, 918, 'Tool 260', 'Keyboard'),
(920, 920, 'Tool 259', 'Keyboard'),
(928, 928, 'Tool 363', 'Keyboard'),
(933, 933, 'Tool 366', 'Keyboard'),
(935, 935, 'Tool 368', 'Keyboard'),
(937, 937, 'Tool 398', 'Keyboard'),
(942, 942, 'Tool 365', 'Keyboard'),
(944, 944, 'Tool 367', 'Keyboard'),
(947, 947, 'Tool 231', 'Keyboard'),
(949, 949, 'Tool 195', 'Keyboard'),
(952, 952, 'Tool 192', 'Keyboard'),
(956, 956, 'Tool 348', 'CARD'),
(958, 958, 'Tool 348c', 'CARD'),
(960, 960, 'Tool 348b', 'CARD'),
(962, 962, 'Tool 348a', 'CARD'),
(966, 966, 'Tool 355 (C/D)', 'Keyboard'),
(968, 968, 'Tool 396', 'Keyboard'),
(981, 981, 'Tool 375', 'Keyboard'),
(985, 985, 'Tool 278', 'Keyboard'),
(1013, 1013, 'Tool 234', 'Keyboard'),
(1015, 1015, 'Tool 275', 'Keyboard'),
(1040, 1040, 'Tool 378', 'Keyboard'),
(1087, 1087, 'Tool 381', 'Keyboard'),
(1089, 1089, 'Tool 349 C/D', 'Keyboard'),
(1091, 1091, 'Tool 349', 'Keyboard'),
(1093, 1093, 'Tool 120', 'Keyboard'),
(1097, 1097, 'Tool 343', 'Keyboard'),
(1099, 1099, 'Tool 384 C/D', 'Keyboard'),
(1111, 1111, 'Tool 276', 'Keyboard'),
(1116, 1116, 'Tool 383', 'Keyboard'),
(1118, 1118, 'Tool 336', 'Keyboard'),
(1121, 1121, 'Tool 220', 'Keyboard'),
(1125, 1125, 'Tool 288', 'Keyboard'),
(1127, 1127, 'Tool 318', 'Keyboard'),
(1142, 1142, 'Tool 32', 'Keyboard'),
(1154, 1154, 'Tool 31', 'Keyboard'),
(1158, 1158, 'Tool 121 (C/D)', 'Keyboard'),
(1160, 1160, 'Tool 20', 'Keyboard'),
(1163, 1163, 'Tool 248', 'Keyboard'),
(1166, 1166, 'Tool 121', 'Keyboard'),
(1170, 1170, 'Tool 152', 'Keyboard'),
(1174, 1174, 'Tool 18', 'Keyboard'),
(1186, 1186, 'Tool 217', 'Keyboard'),
(1192, 1192, 'Tool 338', 'Keyboard'),
(1211, 1211, 'Tool 129', 'Keyboard'),
(1214, 1214, 'Tool 174', 'Keyboard'),
(1217, 1217, 'Tool 103', 'Keyboard'),
(1220, 1220, 'Tool 272', 'Keyboard'),
(1224, 1224, 'Tool 128', 'Keyboard'),
(1227, 1227, 'Tool 182', 'Keyboard'),
(1235, 1235, 'Tool 208', 'Keyboard'),
(1238, 1238, 'Tool 273', 'Keyboard'),
(1248, 1248, 'Tool 206', 'Keyboard'),
(1258, 1258, 'Tool 393', 'Keyboard'),
(1261, 1261, 'Tool 1', 'Keyboard'),
(1278, 1278, 'Tool 324', 'Keyboard'),
(1286, 1286, 'Tool 350', 'Keyboard'),
(1299, 1299, 'Tool 95', 'Keyboard'),
(1301, 1301, 'Tool 106', 'Keyboard'),
(1311, 1311, 'Tool 33', 'Keyboard'),
(1317, 1317, 'Tool 45', 'Keyboard'),
(1319, 1319, 'Tool 92', 'Keyboard'),
(1329, 1329, 'Tool 34', 'Keyboard'),
(1337, 1337, 'Tool 228', 'Keyboard'),
(1339, 1339, 'Tool 252', 'Keyboard'),
(1344, 1344, 'Tool 257', 'Keyboard'),
(1363, 1363, 'Tool 229', 'Keyboard'),
(1368, 1368, 'Tool 197', 'Keyboard'),
(1376, 1376, 'Tool 408', 'Keyboard'),
(1378, 1378, 'Tool 227', 'Keyboard'),
(1385, 1385, 'Tool 235', 'Keyboard'),
(1387, 1387, 'Tool 186', 'Keyboard'),
(1394, 1394, 'Tool 263', 'Keyboard'),
(1405, 1405, 'Tool 226', 'Keyboard'),
(1415, 1415, 'Tool 301', 'Keyboard'),
(1429, 1429, 'Tool 27', 'Keyboard'),
(1431, 1431, 'Tool 285', 'Keyboard'),
(1434, 1434, 'Tool 282', 'Keyboard'),
(1436, 1436, 'Tool 305', 'Keyboard'),
(1442, 1442, 'Tool 362 C/D', 'Keyboard'),
(1455, 1455, 'Tool 147', 'Keyboard'),
(1463, 1463, 'Tool 389', 'Keyboard'),
(1465, 1465, 'Tool 388', 'Keyboard'),
(1495, 1495, 'Tool 369', 'Keyboard'),
(1497, 1497, 'Tool 401', 'Keyboard'),
(1522, 1522, 'Tool 4', 'Keyboard'),
(1525, 1525, 'Tool 135', 'Keyboard'),
(1527, 1527, 'Tool 24', 'Keyboard'),
(1556, 1556, 'Tool 265', 'Keyboard'),
(1576, 1576, 'Tool 206 C/D', 'Keyboard'),
(1586, 1586, 'Tool 364', 'Keyboard'),
(1588, 1588, 'Tool 377', 'Keyboard'),
(1590, 1590, 'Tool 397', 'Keyboard'),
(1594, 1594, 'Tool 406', 'Keyboard'),
(1597, 1597, 'Tool 392', 'Keyboard'),
(1615, 1615, 'Tool 404', 'Keyboard'),
(1619, 1619, 'Tool 331', 'Keyboard'),
(1682, 1682, 'Tool 317', 'Keyboard'),
(1684, 1684, 'Tool 277', 'Keyboard'),
(1697, 1697, 'Tool 243', 'Keyboard'),
(1699, 1699, 'Tool 90', 'Keyboard'),
(1701, 1701, 'Tool 171', 'Keyboard'),
(1704, 1704, 'Tool 77', 'Keyboard'),
(1708, 1708, 'Tool 79', 'Keyboard'),
(1712, 1712, 'Tool 204', 'Keyboard'),
(1714, 1714, 'Tool 170', 'Keyboard'),
(1719, 1719, 'Tool 292', 'Keyboard'),
(1726, 1726, 'Tool 94', 'Keyboard'),
(1729, 1729, 'Tool 242', 'Keyboard'),
(1740, 1740, 'Tool 111', 'Keyboard'),
(1747, 1747, 'Tool 371', 'Keyboard'),
(1759, 1759, 'Tool 244', 'Keyboard'),
(1763, 1763, 'Tool 72', 'Keyboard'),
(1770, 1770, 'Tool 55', 'Keyboard'),
(1773, 1773, 'Tool 89', 'Keyboard'),
(1776, 1776, 'Tool 126', 'Keyboard'),
(1778, 1778, 'Tool 130', 'Keyboard'),
(1805, 1805, 'Tool 215', 'Keyboard'),
(1817, 1817, 'Tool 385', 'Keyboard'),
(1819, 1819, 'Tool 347', 'Keyboard'),
(1821, 1821, 'Tool 293', 'Keyboard'),
(1828, 1828, 'Tool 310', 'Keyboard'),
(1830, 1830, 'Tool 117', 'Keyboard'),
(1832, 1832, 'Tool 21', 'Keyboard'),
(1834, 1834, 'Tool 59', 'Keyboard'),
(1837, 1837, 'Tool 6', 'Keyboard'),
(1839, 1839, 'Tool 7', 'Keyboard'),
(1841, 1841, 'Tool 8', 'Keyboard'),
(1848, 1848, 'Tool 201', 'Keyboard'),
(1863, 1863, 'Tool 63 C/D', 'Keyboard'),
(1869, 1869, 'Tool 100', 'Keyboard'),
(1877, 1877, 'Tool 44', 'Keyboard'),
(1881, 1881, 'Tool 74', 'Keyboard'),
(1883, 1883, 'Tool 73', 'Keyboard'),
(1904, 1904, 'Tool 16', 'Keyboard'),
(1918, 1918, 'Tool 297', 'Keyboard'),
(1921, 1921, 'Tool 210', 'Keyboard'),
(1925, 1925, 'Tool 211', 'Keyboard'),
(1927, 1927, 'Tool 173', 'Keyboard'),
(1930, 1930, 'Tool 281', 'Keyboard'),
(1936, 1936, 'Tool 322', 'Keyboard'),
(1939, 1939, 'Tool 410', 'Keyboard'),
(1941, 1941, 'Tool 409', 'Keyboard'),
(1943, 1943, 'Tool 225', 'Keyboard'),
(1947, 1947, 'Tool 313', 'Keyboard'),
(1950, 1950, 'Tool 311', 'Keyboard'),
(1957, 1957, 'Tool 209', 'Keyboard'),
(1960, 1960, 'Tool 222', 'Keyboard'),
(1965, 1965, 'Tool 179', 'Keyboard'),
(1967, 1967, 'Tool 296', 'Keyboard'),
(1969, 1969, 'Tool 177', 'Keyboard'),
(1978, 1978, 'Tool 270', 'Keyboard'),
(1985, 1985, 'Tool 258', 'Keyboard'),
(1988, 1988, 'Tool 351', 'Keyboard'),
(1991, 1991, 'Tool 355', 'Keyboard'),
(1994, 1994, 'Tool 386', 'Keyboard'),
(2002, 2002, 'Tool 395', 'Keyboard'),
(2009, 2009, 'Tool 304', 'Keyboard'),
(2012, 2012, 'Tool 346', 'Keyboard'),
(2026, 2026, 'Tool 311 (C/D)', 'Keyboard'),
(2046, 2046, 'Tool 279', 'Keyboard'),
(2197, 2197, 'Tool 261', 'Keyboard'),
(2200, 2200, 'Tool 212', 'Keyboard'),
(2202, 2202, 'Tool 283', 'Keyboard'),
(2205, 2205, 'Tool 96', 'Keyboard'),
(2207, 2207, 'Tool 78', 'Keyboard'),
(2209, 2209, 'Tool 153', 'Keyboard'),
(2211, 2211, 'Tool 151', 'Keyboard'),
(2213, 2213, 'Tool 22', 'Keyboard'),
(2227, 2227, 'Tool 299', 'Keyboard'),
(2229, 2229, 'Tool 387', 'Keyboard'),
(2231, 2231, 'Tool 17', 'Keyboard'),
(2234, 2234, 'Tool 26', 'Keyboard'),
(2238, 2238, 'Tool 12', 'Keyboard'),
(2241, 2241, 'Tool 11', 'Keyboard'),
(2243, 2243, 'Tool 43', 'Keyboard'),
(2247, 2247, 'Tool 119', 'Keyboard'),
(2249, 2249, 'Tool 168', 'Keyboard'),
(2252, 2252, 'Tool 47', 'Keyboard'),
(2254, 2254, 'Tool 60', 'Keyboard'),
(2256, 2256, 'Tool 316', 'Keyboard'),
(2259, 2259, 'Tool 42', 'Keyboard'),
(2261, 2261, 'Tool 262', 'Keyboard'),
(2263, 2263, 'Tool 267', 'Keyboard'),
(2265, 2265, 'Tool 136', 'Keyboard'),
(2267, 2267, 'Tool 19', 'Keyboard'),
(2270, 2270, 'Tool 99', 'Keyboard'),
(2274, 2274, 'Tool 246', 'Keyboard'),
(2276, 2276, 'Tool 216', 'Keyboard'),
(2281, 2281, 'Tool 112', 'Keyboard'),
(2283, 2283, 'Tool 113', 'Keyboard'),
(2285, 2285, 'Tool 233', 'Keyboard'),
(2292, 2292, 'Tool 321', 'Keyboard'),
(2298, 2298, 'Tool 236', 'Keyboard'),
(2305, 2305, 'Tool 9', 'Keyboard'),
(2307, 2307, 'Tool 65', 'Keyboard'),
(2309, 2309, 'Tool 23', 'Keyboard'),
(2311, 2311, 'Tool 240', 'Keyboard'),
(2313, 2313, 'Tool 71', 'Keyboard'),
(2318, 2318, 'Tool 172', 'Keyboard'),
(2320, 2320, 'Tool 185', 'Keyboard'),
(2322, 2322, 'Tool 254', 'Keyboard'),
(2325, 2325, 'Tool 53', 'Keyboard'),
(2328, 2328, 'Tool 262 C/D', 'Keyboard'),
(2331, 2331, 'Tool 48', 'Keyboard'),
(2336, 2336, 'Tool 237', 'Keyboard'),
(2349, 2349, 'Tool 359', 'Keyboard'),
(2352, 2352, 'Tool 333', 'Keyboard'),
(2413, 2413, 'Tool 314 C/D', 'Keyboard'),
(2450, 2450, 'Tool 269', 'Keyboard'),
(2477, 2477, 'Tool 167', 'Keyboard'),
(2479, 2479, 'Tool 54', 'Keyboard'),
(2498, 2498, 'Tool 188', 'Keyboard'),
(2519, 2519, 'Tool 353', 'Keyboard'),
(2522, 2522, 'Tool 384', 'Keyboard'),
(2525, 2525, 'Tool 405', 'Keyboard'),
(2527, 2527, 'Tool 380', 'Keyboard'),
(2532, 2532, 'Tool 402 C/D', 'Keyboard'),
(2534, 2534, 'Tool 312', 'Keyboard'),
(2536, 2536, 'Tool 309', 'Keyboard'),
(2544, 2544, 'Tool 330', 'Keyboard'),
(2546, 2546, 'Tool 342', 'Keyboard'),
(2555, 2555, 'Tool 303', 'Keyboard'),
(2591, 2591, 'Tool 360', 'Keyboard'),
(2643, 2643, 'Tool 332', 'Keyboard'),
(2652, 2652, 'Tool 238', 'Keyboard'),
(2654, 2654, 'Tool 344', 'Keyboard'),
(2657, 2657, 'Tool 400', 'Keyboard'),
(2660, 2660, 'Tool 290', 'Keyboard'),
(2663, 2663, 'Tool 339', 'Keyboard'),
(2666, 2666, 'Tool 268', 'CARD'),
(2750, 2750, 'Tool 393C/D', 'Keyboard'),
(2829, 2829, 'Tool 429', 'Keyboard'),
(3035, 3035, 'Tool 424', 'Keyboard'),
(3065, 3065, 'Tool 418', 'Keyboard'),
(3294, 3294, 'Tool 421', 'Keyboard'),
(3397, 3397, 'Tool 425', 'Keyboard'),
(3699, 3699, 'Tool 413', 'Keyboard'),
(3731, 3731, 'Tool 428', 'Keyboard'),
(3753, 3753, 'Tool 411', 'CARD'),
(3821, 3821, 'Tool 419', 'Keyboard'),
(3894, 3894, 'Tool 427', 'Keyboard'),
(3927, 3927, 'Tool 417', 'Keyboard'),
(3977, 3977, 'Tool 349C/D', 'Keyboard'),
(4166, 4166, 'Tool 414', 'CARD'),
(4427, 4427, 'Tool 413C/D', 'Keyboard'),
(4464, 4464, 'Tool 420', 'Keyboard'),
(4610, 4610, 'Tool 104 C/D', 'Keyboard'),
(4667, 4667, 'Tool 415', 'CARD'),
(4832, 4832, 'Tool 302', 'Keyboard'),
(4923, 4923, 'Tool 412', 'CARD'),
(4933, 4933, 'Tool 423', 'Keyboard'),
(4977, 4977, 'Tool 416', 'Keyboard'),
(5004, 5004, 'Tool 104C/D', 'Keyboard'),
(5026, 5026, 'Tool 311 C/D', 'Keyboard'),
(5038, 5038, 'Tool 430', 'Keyboard'),
(5056, 5056, 'Tool 431', 'Keyboard'),
(5059, 5059, 'Tool 432', 'Keyboard'),
(5073, 5073, 'Tool 403A', 'Keyboard'),
(5104, 5104, 'Tool 333a', 'Keyboard'),
(5105, 5105, 'Tool 433', 'CARD'),
(5115, 5115, 'Tool 435', 'Keyboard'),
(5117, 5117, 'Tool 331+435', 'Keyboard'),
(5118, 5118, 'Tool 404+435', 'Keyboard'),
(5125, 5125, 'Tool 434', 'Keyboard'),
(5308, 5308, 'Tool 436', 'CARD'),
(5325, 5325, 'Tool 437', 'Keyboard'),
(5336, 5336, 'Tool 439', 'Keyboard'),
(5338, 5338, 'Tool 437', 'Keyboard'),
(5339, 5339, 'Tool 438', 'Keyboard'),
(5349, 5349, 'Tool 440', 'Keyboard'),
(5365, 5365, 'Tool 443', 'Keyboard'),
(5371, 5371, 'TOOL 296 C/D', 'Keyboard'),
(5376, 5376, 'Tool 445', 'Keyboard'),
(5381, 5381, 'Tool 444', 'CARD'),
(5382, 5382, 'Tool 446', 'CARD'),
(5383, 5383, 'Tool 447', 'CARD'),
(5390, 5390, 'Tool 442', 'Keyboard'),
(5396, 5396, 'Tool 449', 'CARD'),
(5399, 5399, 'Tool 448', 'CARD');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aa_import_tmp`
--
ALTER TABLE `aa_import_tmp`
  ADD PRIMARY KEY (`merchandise_id`);
COMMIT;