-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 11, 2020 at 10:47 AM
-- Server version: 5.7.23-0ubuntu0.16.04.1
-- PHP Version: 7.0.32-0ubuntu0.16.04.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `ecommerce_prom_schoolwear`
--

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

--
-- Table structure for table `product_attribute_link`
--

-- CREATE TABLE `product_attribute_link` (
--   `prod_attrib_link_id` int(11) NOT NULL,
--   `product_id` int(11) NOT NULL DEFAULT '0',
--   `value` text,
--   `retailer_prod_attrib_id` int(11) NOT NULL DEFAULT '0'
-- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_attribute_link`
--

INSERT INTO `product_attribute_link` (`prod_attrib_link_id`, `product_id`, `value`, `retailer_prod_attrib_id`) VALUES
(803, 1, '0.36', 4),
(804, 2, '0.39', 4),
(805, 3, '0.20', 4),
(806, 4, '0.20', 4),
(807, 5, '0.62', 4),
(808, 6, '0.57', 4),
(809, 7, '0.90', 4),
(810, 8, '0.14', 4),
(811, 9, '0.14', 4),
(812, 10, '0.36', 4),
(813, 11, '0.39', 4),
(814, 12, '0.20', 4),
(815, 13, '0.20', 4),
(816, 14, '0.62', 4),
(817, 15, '0.57', 4),
(818, 16, '0.14', 4),
(819, 17, '0.36', 4),
(820, 18, '0.39', 4),
(821, 19, '0.14', 4),
(822, 20, '0.14', 4),
(823, 21, '0.14', 4),
(824, 22, '0.14', 4),
(825, 23, '0.90', 4),
(826, 24, '0.62', 4),
(827, 25, '0.57', 4),
(828, 26, '0.20', 4),
(829, 27, '0.20', 4),
(830, 28, '0.36', 4),
(831, 29, '0.39', 4),
(832, 30, '0.14', 4),
(833, 31, '0.14', 4),
(834, 32, '0.20', 4),
(835, 33, '0.36', 4),
(836, 34, '0.39', 4),
(837, 39, '0.14', 4),
(838, 40, '0.90', 4),
(839, 41, '0.62', 4),
(840, 42, '0.57', 4),
(841, 43, '0.20', 4),
(842, 44, '0.20', 4),
(843, 45, '0.20', 4),
(844, 46, '0.20', 4),
(845, 47, '0.20', 4),
(846, 48, '0.20', 4),
(847, 49, '0.20', 4),
(848, 50, '0.20', 4),
(849, 51, '0.20', 4),
(850, 52, '0.20', 4),
(851, 53, '0.36', 4),
(852, 54, '0.39', 4),
(853, 55, '0.20', 4),
(854, 56, '0.20', 4),
(855, 57, '0.20', 4),
(856, 58, '0.20', 4),
(857, 59, '0.36', 4),
(858, 60, '0.39', 4),
(859, 61, '0.20', 4),
(860, 62, '0.62', 4),
(861, 63, '0.57', 4),
(862, 65, '0.36', 4),
(863, 66, '0.39', 4),
(864, 67, '0.14', 4),
(865, 68, '0.14', 4),
(866, 69, '0.14', 4),
(867, 70, '0.14', 4),
(868, 71, '0.14', 4),
(869, 72, '0.08', 4),
(870, 73, '0.08', 4),
(871, 74, '0.08', 4),
(872, 75, '0.08', 4),
(873, 77, '0.25', 4),
(874, 78, '0.57', 4),
(875, 79, '0.90', 4),
(876, 80, '0.20', 4),
(877, 81, '0.36', 4),
(878, 82, '0.39', 4),
(879, 83, '0.20', 4),
(880, 84, '0.20', 4),
(881, 85, '0.90', 4),
(882, 86, '0.62', 4),
(883, 87, '0.57', 4),
(884, 88, '0.14', 4),
(885, 89, '0.36', 4),
(886, 90, '0.39', 4),
(887, 91, '0.20', 4),
(888, 92, '0.20', 4),
(889, 93, '0.62', 4),
(890, 94, '0.57', 4),
(891, 95, '0.90', 4),
(892, 96, '0.14', 4),
(893, 97, '0.14', 4),
(894, 98, '0.14', 4),
(895, 99, '0.14', 4),
(896, 100, '0.36', 4),
(897, 101, '0.39', 4),
(898, 102, '0.14', 4),
(899, 103, '0.14', 4),
(900, 104, '0.14', 4),
(901, 105, '0.14', 4),
(902, 108, '0.20', 4),
(903, 110, '0.36', 4),
(904, 111, '0.39', 4),
(905, 112, '0.14', 4),
(906, 113, '0.14', 4),
(907, 114, '0.14', 4),
(908, 115, '0.14', 4),
(909, 116, '0.90', 4),
(910, 117, '0.62', 4),
(911, 118, '0.57', 4),
(912, 119, '0.20', 4),
(913, 122, '0.36', 4),
(914, 123, '0.39', 4),
(915, 124, '0.20', 4),
(916, 125, '0.57', 4),
(917, 126, '0.62', 4),
(918, 127, '0.90', 4),
(919, 128, '0.39', 4),
(920, 129, '0.20', 4),
(921, 130, '0.36', 4),
(922, 131, '0.62', 4),
(923, 132, '0.90', 4),
(924, 133, '0.20', 4),
(925, 134, '0.20', 4),
(926, 135, '0.20', 4),
(927, 136, '0.20', 4),
(928, 137, '0.36', 4),
(929, 138, '0.39', 4),
(930, 139, '0.20', 4),
(931, 140, '0.20', 4),
(932, 141, '0.90', 4),
(933, 142, '0.90', 4),
(934, 143, '0.62', 4),
(935, 144, '0.62', 4),
(936, 145, '0.00', 4),
(937, 146, '0.00', 4),
(938, 147, '0.36', 4),
(939, 148, '0.39', 4),
(940, 149, '0.20', 4),
(941, 150, '0.20', 4),
(942, 151, '0.00', 4),
(943, 152, '0.20', 4),
(944, 153, '0.20', 4),
(945, 154, '0.20', 4),
(946, 155, '0.20', 4),
(947, 156, '0.20', 4),
(948, 157, '0.20', 4),
(949, 158, '0.20', 4),
(950, 159, '0.20', 4),
(951, 160, '0.20', 4),
(952, 161, '0.20', 4),
(953, 162, '0.20', 4),
(954, 163, '0.25', 4),
(955, 164, '0.36', 4),
(956, 165, '0.39', 4),
(957, 166, '0.20', 4),
(958, 167, '0.20', 4),
(959, 168, '0.00', 4),
(960, 169, '0.36', 4),
(961, 170, '0.39', 4),
(962, 171, '0.20', 4),
(963, 172, '0.20', 4),
(964, 173, '0.00', 4),
(965, 174, '0.36', 4),
(966, 175, '0.39', 4),
(967, 176, '0.20', 4),
(968, 177, '0.20', 4),
(969, 178, '0.00', 4),
(970, 179, '0.36', 4),
(971, 180, '0.39', 4),
(972, 181, '0.20', 4),
(973, 182, '0.20', 4),
(974, 183, '0.00', 4),
(975, 184, '0.36', 4),
(976, 185, '0.39', 4),
(977, 186, '0.20', 4),
(978, 187, '0.00', 4),
(979, 188, '0.36', 4),
(980, 189, '0.39', 4),
(981, 190, '0.00', 4),
(982, 191, '0.20', 4),
(983, 192, '0.20', 4),
(984, 193, '0.00', 4),
(985, 194, '0.00', 4),
(986, 195, '0.36', 4),
(987, 196, '0.39', 4),
(988, 197, '0.20', 4),
(989, 198, '0.36', 4),
(990, 199, '0.14', 4),
(991, 200, '0.14', 4),
(992, 201, '0.14', 4),
(993, 202, '0.14', 4),
(994, 203, '0.14', 4),
(995, 204, '0.14', 4),
(996, 205, '0.14', 4),
(997, 206, '0.14', 4),
(998, 208, '0.00', 4),
(999, 209, '0.00', 4),
(1000, 210, '0.00', 4),
(1001, 211, '0.00', 4),
(1002, 212, '0.00', 4),
(1003, 213, '0.00', 4),
(1004, 214, '0.00', 4),
(1005, 215, '0.00', 4),
(1006, 216, '0.00', 4),
(1007, 217, '0.00', 4),
(1008, 218, '0.00', 4),
(1009, 219, '0.00', 4),
(1010, 220, '0.36', 4),
(1011, 221, '0.20', 4),
(1012, 222, '0.14', 4),
(1013, 223, '0.14', 4),
(1014, 224, '0.14', 4),
(1015, 225, '0.14', 4),
(1016, 226, '0.20', 4),
(1017, 227, '0.39', 4),
(1018, 228, '0.36', 4),
(1019, 229, '0.20', 4),
(1020, 230, '0.20', 4),
(1021, 231, '0.36', 4),
(1022, 232, '0.39', 4),
(1023, 233, '0.20', 4),
(1024, 234, '0.20', 4),
(1025, 235, '0.39', 4),
(1026, 236, '0.36', 4),
(1027, 237, '0.20', 4),
(1028, 238, '0.20', 4),
(1029, 239, '0.39', 4),
(1030, 240, '0.36', 4),
(1031, 242, '0.76', 4),
(1032, 243, '0.76', 4),
(1033, 245, '0.75', 4),
(1034, 246, '0.20', 4),
(1035, 247, '0.14', 4),
(1036, 248, '0.14', 4),
(1037, 249, '0.14', 4),
(1038, 250, '0.14', 4),
(1039, 251, '0.14', 4),
(1040, 252, '0.14', 4),
(1041, 253, '0.14', 4),
(1042, 254, '0.14', 4),
(1043, 255, '0.14', 4),
(1044, 256, '0.08', 4),
(1045, 257, '0.08', 4),
(1046, 258, '0.08', 4),
(1047, 259, '0.08', 4),
(1048, 260, '0.08', 4),
(1049, 261, '0.08', 4),
(1050, 262, '0.08', 4),
(1051, 263, '0.08', 4),
(1052, 264, '0.39', 4),
(1053, 265, '0.76', 4),
(1054, 266, '0.00', 4),
(1055, 268, '0.35', 4),
(1056, 269, '0.08', 4),
(1057, 270, '0.76', 4),
(1058, 271, '0.14', 4),
(1059, 272, '0.90', 4),
(1060, 273, '0.25', 4),
(1061, 275, '0.20', 4),
(1062, 277, '0.37', 4),
(1063, 278, '0.37', 4),
(1064, 279, '0.23', 4),
(1065, 280, '0.23', 4),
(1066, 281, '0.18', 4),
(1067, 282, '0.18', 4),
(1068, 283, '0.18', 4),
(1069, 284, '0.18', 4),
(1070, 285, '0.37', 4),
(1071, 286, '0.37', 4),
(1072, 287, '0.37', 4),
(1073, 288, '0.37', 4),
(1074, 289, '0.37', 4),
(1075, 290, '0.21', 4),
(1076, 291, '0.21', 4),
(1077, 292, '0.65', 4),
(1078, 293, '0.37', 4),
(1079, 294, '0.10', 4),
(1080, 295, '0.10', 4),
(1081, 296, '0.10', 4),
(1082, 297, '0.10', 4),
(1083, 298, '0.76', 4),
(1084, 299, '0.76', 4),
(1085, 300, '0.49', 4),
(1086, 301, '0.48', 4),
(1087, 302, '0.35', 4),
(1088, 303, '0.49', 4),
(1089, 304, '0.14', 4),
(1090, 305, '0.35', 4),
(1091, 306, '0.35', 4),
(1092, 307, '0.20', 4),
(1093, 308, '0.20', 4),
(1094, 309, '0.36', 4),
(1095, 310, '0.39', 4),
(1096, 312, '0.49', 4),
(1097, 313, '0.25', 4),
(1098, 314, '0.25', 4),
(1099, 315, '0.25', 4),
(1100, 316, '0.25', 4),
(1101, 317, '0.25', 4),
(1102, 318, '0.76', 4),
(1103, 319, '0.76', 4),
(1104, 320, '0.76', 4),
(1105, 321, '0.76', 4),
(1106, 322, '0.76', 4),
(1107, 323, '0.76', 4),
(1108, 324, '0.49', 4),
(1109, 325, '0.75', 4),
(1110, 326, '0.48', 4),
(1111, 328, '0.48', 4),
(1112, 329, '0.48', 4),
(1113, 330, '0.23', 4),
(1114, 331, '0.23', 4),
(1115, 332, '0.45', 4),
(1116, 333, '0.45', 4),
(1117, 334, '0.24', 4),
(1118, 335, '0.24', 4),
(1119, 336, '0.18', 4),
(1120, 337, '0.18', 4),
(1121, 338, '0.18', 4),
(1122, 339, '0.14', 4),
(1123, 340, '0.25', 4),
(1124, 341, '0.14', 4),
(1125, 342, '0.14', 4);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `product_attribute_link`
--
-- ALTER TABLE `product_attribute_link`
--   ADD PRIMARY KEY (`prod_attrib_link_id`),
--   ADD KEY `product_id` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `product_attribute_link`
--
ALTER TABLE `product_attribute_link`
  MODIFY `prod_attrib_link_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1126;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
