INSERT INTO `eav_attribute_option_value` (`value_id`, `option_id`, `store_id`, `value`) VALUES
(4235, 4235, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Bases & Plates'),
(4236, 4236, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Batting Gloves'),
(4237, 4237, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Gloves & Mitts'),
(4238, 4238, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Pitching Mats'),
(4239, 4239, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Pitching Mounds'),
(4240, 4240, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear'),
(4241, 4241, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear > Baseball & Softball Batting Helmets'),
(4242, 4242, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear > Baseball & Softball Chest Protectors'),
(4243, 4243, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear > Baseball & Softball Leg Guards'),
(4244, 4244, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear > Catchers Equipment Sets'),
(4245, 4245, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball & Softball Protective Gear > Catchers Helmets & Masks'),
(4246, 4246, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseball Bats'),
(4247, 4247, 0, 'Sporting Goods > Athletics > Baseball & Softball > Baseballs'),
(4248, 4248, 0, 'Sporting Goods > Athletics > Baseball & Softball > Pitching Machines'),
(4249, 4249, 0, 'Sporting Goods > Athletics > Baseball & Softball > Softball Bats'),
(4250, 4250, 0, 'Sporting Goods > Athletics > Baseball & Softball > Softballs'),
(4251, 4251, 0, 'Sporting Goods > Athletics > Basketball'),
(4252, 4252, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories'),
(4253, 4253, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories > Basketball Backboards'),
(4254, 4254, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories > Basketball Hoop Padding'),
(4255, 4255, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories > Basketball Hoop Posts'),
(4256, 4256, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories > Basketball Nets'),
(4257, 4257, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoop Parts & Accessories > Basketball Rims'),
(4258, 4258, 0, 'Sporting Goods > Athletics > Basketball > Basketball Hoops'),
(4259, 4259, 0, 'Sporting Goods > Athletics > Basketball > Basketball Training Aids'),
(4260, 4260, 0, 'Sporting Goods > Athletics > Basketball > Basketballs'),
(4261, 4261, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts'),
(4262, 4262, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear'),
(4263, 4263, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > Boxing & MMA Hand Wraps'),
(4264, 4264, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > Boxing & Martial Arts Arm Guards'),
(4265, 4265, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > Boxing & Martial Arts Body Protectors'),
(4266, 4266, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > Boxing & Martial Arts Headgear'),
(4267, 4267, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > Boxing Gloves & Mitts'),
(4268, 4268, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Protective Gear > MMA Shin Guards'),
(4269, 4269, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment'),
(4270, 4270, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment > Boxing & MMA Punch Mitts'),
(4271, 4271, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment > Grappling Dummies'),
(4272, 4272, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment > Punching & Training Bag Accessories'),
(4273, 4273, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment > Punching & Training Bags'),
(4274, 4274, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing & Martial Arts Training Equipment > Strike Shields'),
(4275, 4275, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing Ring Parts'),
(4276, 4276, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Boxing Rings'),
(4277, 4277, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Martial Arts Belts'),
(4278, 4278, 0, 'Sporting Goods > Athletics > Boxing & Martial Arts > Martial Arts Weapons'),
(4279, 4279, 0, 'Sporting Goods > Athletics > Broomball Equipment'),
(4280, 4280, 0, 'Sporting Goods > Athletics > Cheerleading'),
(4281, 4281, 0, 'Sporting Goods > Athletics > Cheerleading > Cheerleading Pom Poms'),
(4282, 4282, 0, 'Sporting Goods > Athletics > Coaching & Officiating'),
(4283, 4283, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Captains Armbands'),
(4284, 4284, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Field & Court Boundary Markers'),
(4285, 4285, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Flip Coins & Discs'),
(4286, 4286, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Linesman Flags'),
(4287, 4287, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Penalty Cards & Flags'),
(4288, 4288, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Pitch Counters'),
(4289, 4289, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Referee Stands & Chairs'),
(4290, 4290, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Referee Wallets'),
(4291, 4291, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Scoreboards'),
(4292, 4292, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Sport & Safety Whistles'),
(4293, 4293, 0, 'Sporting Goods > Athletics > Coaching & Officiating > Umpire Indicators'),
(4294, 4294, 0, 'Sporting Goods > Athletics > Cricket'),
(4295, 4295, 0, 'Sporting Goods > Athletics > Cricket > Cricket Balls'),
(4296, 4296, 0, 'Sporting Goods > Athletics > Cricket > Cricket Bat Accessories'),
(4297, 4297, 0, 'Sporting Goods > Athletics > Cricket > Cricket Bat Accessories > Cricket Bat Grips'),
(4298, 4298, 0, 'Sporting Goods > Athletics > Cricket > Cricket Bats'),
(4299, 4299, 0, 'Sporting Goods > Athletics > Cricket > Cricket Equipment Sets'),
(4300, 4300, 0, 'Sporting Goods > Athletics > Cricket > Cricket Protective Gear'),
(4301, 4301, 0, 'Sporting Goods > Athletics > Cricket > Cricket Protective Gear > Cricket Gloves'),
(4302, 4302, 0, 'Sporting Goods > Athletics > Cricket > Cricket Protective Gear > Cricket Helmets'),
(4303, 4303, 0, 'Sporting Goods > Athletics > Cricket > Cricket Protective Gear > Cricket Leg Guards'),
(4304, 4304, 0, 'Sporting Goods > Athletics > Cricket > Cricket Stumps'),
(4305, 4305, 0, 'Sporting Goods > Athletics > Dancing'),
(4306, 4306, 0, 'Sporting Goods > Athletics > Dancing > Ballet Barres'),
(4307, 4307, 0, 'Sporting Goods > Athletics > Fencing'),
(4308, 4308, 0, 'Sporting Goods > Athletics > Fencing > Fencing Protective Gear'),
(4309, 4309, 0, 'Sporting Goods > Athletics > Fencing > Fencing Protective Gear > Fencing Gloves & Cuffs'),
(4310, 4310, 0, 'Sporting Goods > Athletics > Fencing > Fencing Protective Gear > Fencing Jackets & Lamés'),
(4311, 4311, 0, 'Sporting Goods > Athletics > Fencing > Fencing Protective Gear > Fencing Masks'),
(4312, 4312, 0, 'Sporting Goods > Athletics > Fencing > Fencing Weapons'),
(4313, 4313, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse'),
(4314, 4314, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey & Lacrosse Protective Gear'),
(4315, 4315, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey & Lacrosse Protective Gear > Field Hockey & Lacrosse Gloves'),
(4316, 4316, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey & Lacrosse Protective Gear > Field Hockey & Lacrosse Helmets'),
(4317, 4317, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey & Lacrosse Protective Gear > Field Hockey & Lacrosse Masks & Goggles'),
(4318, 4318, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey & Lacrosse Protective Gear > Field Hockey & Lacrosse Pads'),
(4319, 4319, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey Balls'),
(4320, 4320, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey Goals'),
(4321, 4321, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Field Hockey Sticks'),
(4322, 4322, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Balls'),
(4323, 4323, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Equipment Sets'),
(4324, 4324, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Goals'),
(4325, 4325, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Stick Parts'),
(4326, 4326, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Stick Parts > Lacrosse Mesh & String'),
(4327, 4327, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Stick Parts > Lacrosse Stick Heads'),
(4328, 4328, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Stick Parts > Lacrosse Stick Shafts'),
(4329, 4329, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Sticks'),
(4330, 4330, 0, 'Sporting Goods > Athletics > Field Hockey & Lacrosse > Lacrosse Training Aids'),
(4331, 4331, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey'),
(4332, 4332, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Balls & Pucks'),
(4333, 4333, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Goals'),
(4334, 4334, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear'),
(4335, 4335, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Elbow Pads'),
(4336, 4336, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Gloves'),
(4337, 4337, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Goalie Equipment Sets'),
(4338, 4338, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Helmets'),
(4339, 4339, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Pants'),
(4340, 4340, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Shin Guards & Leg Pads'),
(4341, 4341, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Shoulder Pads & Chest Protectors'),
(4342, 4342, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Protective Gear > Hockey Suspenders & Belts'),
(4343, 4343, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Sledges'),
(4344, 4344, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Stick Care'),
(4345, 4345, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Stick Parts'),
(4346, 4346, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Stick Parts > Hockey Stick Blades'),
(4347, 4347, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Stick Parts > Hockey Stick Shafts'),
(4348, 4348, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Hockey Sticks'),
(4349, 4349, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories'),
(4350, 4350, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories > Figure Skate Boots'),
(4351, 4351, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories > Ice Skate Blades'),
(4352, 4352, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories > Ice Skate Sharpeners'),
(4353, 4353, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories > Skate Blade Guards'),
(4354, 4354, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skate Parts & Accessories > Skate Lace Tighteners'),
(4355, 4355, 0, 'Sporting Goods > Athletics > Figure Skating & Hockey > Ice Skates'),
(4356, 4356, 0, 'Sporting Goods > Athletics > Football'),
(4357, 4357, 0, 'Sporting Goods > Athletics > Football > Football Gloves'),
(4358, 4358, 0, 'Sporting Goods > Athletics > Football > Football Goal Posts'),
(4359, 4359, 0, 'Sporting Goods > Athletics > Football > Football Kicking Tees & Holders'),
(4360, 4360, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear'),
(4361, 4361, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Girdles'),
(4362, 4362, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmet Accessories'),
(4363, 4363, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmet Accessories > Football Chin Straps'),
(4364, 4364, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmet Accessories > Football Face Masks'),
(4365, 4365, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmet Accessories > Football Helmet Padding'),
(4366, 4366, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmet Accessories > Football Helmet Visors'),
(4367, 4367, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Helmets'),
(4368, 4368, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Neck Rolls'),
(4369, 4369, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Rib Protection Shirts & Vests'),
(4370, 4370, 0, 'Sporting Goods > Athletics > Football > Football Protective Gear > Football Shoulder Pads'),
(4371, 4371, 0, 'Sporting Goods > Athletics > Football > Football Training Equipment'),
(4372, 4372, 0, 'Sporting Goods > Athletics > Football > Football Training Equipment > Football Dummies & Sleds'),
(4373, 4373, 0, 'Sporting Goods > Athletics > Football > Footballs'),
(4374, 4374, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment'),
(4375, 4375, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Altitude Training Masks'),
(4376, 4376, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Athletic Cups'),
(4377, 4377, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Ball Carrying Bags & Carts'),
(4378, 4378, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Ball Pump Accessories'),
(4379, 4379, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Ball Pump Accessories > Ball Pump Needles'),
(4380, 4380, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Ball Pumps'),
(4381, 4381, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Exercise & Gym Mat Storage Racks & Carts'),
(4382, 4382, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Grip Spray & Chalk'),
(4383, 4383, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Gym Mats'),
(4384, 4384, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Practice Nets & Screens'),
(4385, 4385, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Speed & Agility Ladders & Hurdles'),
(4386, 4386, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Sports & Agility Cones'),
(4387, 4387, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Sports Megaphones'),
(4388, 4388, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Sports Mouthguards'),
(4389, 4389, 0, 'Sporting Goods > Athletics > General Purpose Athletic Equipment > Stadium Seats & Cushions'),
(4390, 4390, 0, 'Sporting Goods > Athletics > Gymnastics'),
(4391, 4391, 0, 'Sporting Goods > Athletics > Gymnastics > Gymnastics Bars & Balance Beams'),
(4392, 4392, 0, 'Sporting Goods > Athletics > Gymnastics > Gymnastics Protective Gear'),
(4393, 4393, 0, 'Sporting Goods > Athletics > Gymnastics > Gymnastics Protective Gear > Gymnastics Grips'),
(4394, 4394, 0, 'Sporting Goods > Athletics > Gymnastics > Gymnastics Rings'),
(4395, 4395, 0, 'Sporting Goods > Athletics > Gymnastics > Gymnastics Springboards'),
(4396, 4396, 0, 'Sporting Goods > Athletics > Gymnastics > Pommel Horses'),
(4397, 4397, 0, 'Sporting Goods > Athletics > Gymnastics > Vaulting Horses'),
(4398, 4398, 0, 'Sporting Goods > Athletics > Racquetball & Squash'),
(4399, 4399, 0, 'Sporting Goods > Athletics > Racquetball & Squash > Racquetball & Squash Balls'),
(4400, 4400, 0, 'Sporting Goods > Athletics > Racquetball & Squash > Racquetball & Squash Eyewear'),
(4401, 4401, 0, 'Sporting Goods > Athletics > Racquetball & Squash > Racquetball & Squash Gloves'),
(4402, 4402, 0, 'Sporting Goods > Athletics > Racquetball & Squash > Racquetball Racquets'),
(4403, 4403, 0, 'Sporting Goods > Athletics > Racquetball & Squash > Squash Racquets'),
(4404, 4404, 0, 'Sporting Goods > Athletics > Rounders'),
(4405, 4405, 0, 'Sporting Goods > Athletics > Rounders > Rounders Bats'),
(4406, 4406, 0, 'Sporting Goods > Athletics > Rounders > Rounders Gloves'),
(4407, 4407, 0, 'Sporting Goods > Athletics > Rugby'),
(4408, 4408, 0, 'Sporting Goods > Athletics > Rugby > Rugby Balls'),
(4409, 4409, 0, 'Sporting Goods > Athletics > Rugby > Rugby Gloves'),
(4410, 4410, 0, 'Sporting Goods > Athletics > Rugby > Rugby Posts'),
(4411, 4411, 0, 'Sporting Goods > Athletics > Rugby > Rugby Protective Gear'),
(4412, 4412, 0, 'Sporting Goods > Athletics > Rugby > Rugby Protective Gear > Rugby Headgear'),
(4413, 4413, 0, 'Sporting Goods > Athletics > Rugby > Rugby Training Aids'),
(4414, 4414, 0, 'Sporting Goods > Athletics > Soccer'),
(4415, 4415, 0, 'Sporting Goods > Athletics > Soccer > Soccer Balls'),
(4416, 4416, 0, 'Sporting Goods > Athletics > Soccer > Soccer Corner Flags'),
(4417, 4417, 0, 'Sporting Goods > Athletics > Soccer > Soccer Gloves'),
(4418, 4418, 0, 'Sporting Goods > Athletics > Soccer > Soccer Goal Accessories'),
(4419, 4419, 0, 'Sporting Goods > Athletics > Soccer > Soccer Goals'),
(4420, 4420, 0, 'Sporting Goods > Athletics > Soccer > Soccer Protective Gear'),
(4421, 4421, 0, 'Sporting Goods > Athletics > Soccer > Soccer Protective Gear > Soccer Shin Guards'),
(4422, 4422, 0, 'Sporting Goods > Athletics > Team Handball'),
(4423, 4423, 0, 'Sporting Goods > Athletics > Team Handball > Handballs'),
(4424, 4424, 0, 'Sporting Goods > Athletics > Tennis'),
(4425, 4425, 0, 'Sporting Goods > Athletics > Tennis > Tennis Ball Hoppers & Carts'),
(4426, 4426, 0, 'Sporting Goods > Athletics > Tennis > Tennis Ball Machines'),
(4427, 4427, 0, 'Sporting Goods > Athletics > Tennis > Tennis Ball Savers'),
(4428, 4428, 0, 'Sporting Goods > Athletics > Tennis > Tennis Balls'),
(4429, 4429, 0, 'Sporting Goods > Athletics > Tennis > Tennis Nets'),
(4430, 4430, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories'),
(4431, 4431, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories > Racquet Vibration Dampeners'),
(4432, 4432, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories > Tennis Racquet Bags'),
(4433, 4433, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories > Tennis Racquet Grips & Tape'),
(4434, 4434, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories > Tennis Racquet Grommets'),
(4435, 4435, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquet Accessories > Tennis Racquet String'),
(4436, 4436, 0, 'Sporting Goods > Athletics > Tennis > Tennis Racquets'),
(4437, 4437, 0, 'Sporting Goods > Athletics > Track & Field'),
(4438, 4438, 0, 'Sporting Goods > Athletics > Track & Field > Discus'),
(4439, 4439, 0, 'Sporting Goods > Athletics > Track & Field > High Jump Crossbars'),
(4440, 4440, 0, 'Sporting Goods > Athletics > Track & Field > High Jump Pits'),
(4441, 4441, 0, 'Sporting Goods > Athletics > Track & Field > Javelins'),
(4442, 4442, 0, 'Sporting Goods > Athletics > Track & Field > Pole Vault Pits'),
(4443, 4443, 0, 'Sporting Goods > Athletics > Track & Field > Relay Batons'),
(4444, 4444, 0, 'Sporting Goods > Athletics > Track & Field > Shot Puts'),
(4445, 4445, 0, 'Sporting Goods > Athletics > Track & Field > Starter Pistols'),
(4446, 4446, 0, 'Sporting Goods > Athletics > Track & Field > Throwing Hammers'),
(4447, 4447, 0, 'Sporting Goods > Athletics > Track & Field > Track Hurdles'),
(4448, 4448, 0, 'Sporting Goods > Athletics > Track & Field > Track Starting Blocks'),
(4449, 4449, 0, 'Sporting Goods > Athletics > Track & Field > Vaulting Poles'),
(4450, 4450, 0, 'Sporting Goods > Athletics > Volleyball'),
(4451, 4451, 0, 'Sporting Goods > Athletics > Volleyball > Volleyball Nets'),
(4452, 4452, 0, 'Sporting Goods > Athletics > Volleyball > Volleyball Protective Gear'),
(4453, 4453, 0, 'Sporting Goods > Athletics > Volleyball > Volleyball Protective Gear > Volleyball Knee Pads'),
(4454, 4454, 0, 'Sporting Goods > Athletics > Volleyball > Volleyball Training Aids'),
(4455, 4455, 0, 'Sporting Goods > Athletics > Volleyball > Volleyballs'),
(4456, 4456, 0, 'Sporting Goods > Athletics > Wallyball Equipment'),
(4457, 4457, 0, 'Sporting Goods > Athletics > Water Polo'),
(4458, 4458, 0, 'Sporting Goods > Athletics > Water Polo > Water Polo Balls'),
(4459, 4459, 0, 'Sporting Goods > Athletics > Water Polo > Water Polo Caps'),
(4460, 4460, 0, 'Sporting Goods > Athletics > Water Polo > Water Polo Goals'),
(4461, 4461, 0, 'Sporting Goods > Athletics > Wrestling'),
(4462, 4462, 0, 'Sporting Goods > Athletics > Wrestling > Wrestling Protective Gear'),
(4463, 4463, 0, 'Sporting Goods > Athletics > Wrestling > Wrestling Protective Gear > Wrestling Headgear'),
(4464, 4464, 0, 'Sporting Goods > Athletics > Wrestling > Wrestling Protective Gear > Wrestling Knee Pads'),
(4465, 4465, 0, 'Sporting Goods > Exercise & Fitness'),
(4466, 4466, 0, 'Sporting Goods > Exercise & Fitness > Ab Wheels & Rollers'),
(4467, 4467, 0, 'Sporting Goods > Exercise & Fitness > Aerobic Steps'),
(4468, 4468, 0, 'Sporting Goods > Exercise & Fitness > Balance Trainers'),
(4469, 4469, 0, 'Sporting Goods > Exercise & Fitness > Cardio'),
(4470, 4470, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories'),
(4471, 4471, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories > Elliptical Trainer Accessories'),
(4472, 4472, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories > Exercise Bike Accessories'),
(4473, 4473, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories > Rowing Machine Accessories'),
(4474, 4474, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories > Stair Climber & Stepper Accessories'),
(4475, 4475, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machine Accessories > Treadmill Accessories'),
(4476, 4476, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines'),
(4477, 4477, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines > Elliptical Trainers'),
(4478, 4478, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines > Exercise Bikes'),
(4479, 4479, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines > Rowing Machines'),
(4480, 4480, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines > Stair Climbers & Steppers'),
(4481, 4481, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Cardio Machines > Treadmills'),
(4482, 4482, 0, 'Sporting Goods > Exercise & Fitness > Cardio > Jump Ropes'),
(4483, 4483, 0, 'Sporting Goods > Exercise & Fitness > Exercise Balls'),
(4484, 4484, 0, 'Sporting Goods > Exercise & Fitness > Exercise Bands'),
(4485, 4485, 0, 'Sporting Goods > Exercise & Fitness > Exercise Benches'),
(4486, 4486, 0, 'Sporting Goods > Exercise & Fitness > Exercise Equipment Mats'),
(4487, 4487, 0, 'Sporting Goods > Exercise & Fitness > Exercise Machine & Equipment Sets'),
(4488, 4488, 0, 'Sporting Goods > Exercise & Fitness > Exercise Wedges'),
(4489, 4489, 0, 'Sporting Goods > Exercise & Fitness > Foam Roller Accessories'),
(4490, 4490, 0, 'Sporting Goods > Exercise & Fitness > Foam Roller Accessories > Foam Roller Storage Bags'),
(4491, 4491, 0, 'Sporting Goods > Exercise & Fitness > Foam Rollers'),
(4492, 4492, 0, 'Sporting Goods > Exercise & Fitness > Hand Exercisers'),
(4493, 4493, 0, 'Sporting Goods > Exercise & Fitness > Inversion Tables & Systems'),
(4494, 4494, 0, 'Sporting Goods > Exercise & Fitness > Medicine Balls'),
(4495, 4495, 0, 'Sporting Goods > Exercise & Fitness > Power Towers'),
(4496, 4496, 0, 'Sporting Goods > Exercise & Fitness > Push Up & Pull Up Bars'),
(4497, 4497, 0, 'Sporting Goods > Exercise & Fitness > Reaction Balls'),
(4498, 4498, 0, 'Sporting Goods > Exercise & Fitness > Speed & Resistance Parachutes'),
(4499, 4499, 0, 'Sporting Goods > Exercise & Fitness > Sport Safety Lights & Reflectors'),
(4500, 4500, 0, 'Sporting Goods > Exercise & Fitness > Stopwatches'),
(4501, 4501, 0, 'Sporting Goods > Exercise & Fitness > Suspension Trainers'),
(4502, 4502, 0, 'Sporting Goods > Exercise & Fitness > Vibration Exercise Machines'),
(4503, 4503, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting'),
(4504, 4504, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Free Weight Accessories'),
(4505, 4505, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Free Weight Accessories > Free Weight Storage Racks'),
(4506, 4506, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Free Weight Accessories > Weight Bar Collars'),
(4507, 4507, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Free Weight Accessories > Weight Bars'),
(4508, 4508, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Free Weights'),
(4509, 4509, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Weight Lifting Belts'),
(4510, 4510, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Weight Lifting Gloves & Hand Supports'),
(4511, 4511, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Weight Lifting Machine & Exercise Bench Accessories'),
(4512, 4512, 0, 'Sporting Goods > Exercise & Fitness > Weight Lifting > Weight Lifting Machines & Racks'),
(4513, 4513, 0, 'Sporting Goods > Exercise & Fitness > Weighted Clothing'),
(4514, 4514, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates'),
(4515, 4515, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates > Pilates Machines'),
(4516, 4516, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates > Yoga & Pilates Blocks'),
(4517, 4517, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates > Yoga & Pilates Mats'),
(4518, 4518, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates > Yoga & Pilates Towels'),
(4519, 4519, 0, 'Sporting Goods > Exercise & Fitness > Yoga & Pilates > Yoga Mat Bags & Straps'),
(4520, 4520, 0, 'Sporting Goods > Indoor Games'),
(4521, 4521, 0, 'Sporting Goods > Indoor Games > Air Hockey'),
(4522, 4522, 0, 'Sporting Goods > Indoor Games > Air Hockey > Air Hockey Equipment'),
(4523, 4523, 0, 'Sporting Goods > Indoor Games > Air Hockey > Air Hockey Table Parts'),
(4524, 4524, 0, 'Sporting Goods > Indoor Games > Air Hockey > Air Hockey Tables'),
(4525, 4525, 0, 'Sporting Goods > Indoor Games > Billiards'),
(4526, 4526, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Ball Racks'),
(4527, 4527, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Balls'),
(4528, 4528, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Cue Accessories'),
(4529, 4529, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Cue Accessories > Billiard Cue Cases'),
(4530, 4530, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Cue Accessories > Billiard Cue Chalk'),
(4531, 4531, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Cue Accessories > Billiard Cue Racks'),
(4532, 4532, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Cues & Bridges'),
(4533, 4533, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Gloves'),
(4534, 4534, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Lights'),
(4535, 4535, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Parts & Accessories'),
(4536, 4536, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Parts & Accessories > Billiard Pockets'),
(4537, 4537, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Parts & Accessories > Billiard Table Brushes'),
(4538, 4538, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Parts & Accessories > Billiard Table Cloth'),
(4539, 4539, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Table Parts & Accessories > Billiard Table Covers'),
(4540, 4540, 0, 'Sporting Goods > Indoor Games > Billiards > Billiard Tables'),
(4541, 4541, 0, 'Sporting Goods > Indoor Games > Bowling'),
(4542, 4542, 0, 'Sporting Goods > Indoor Games > Bowling > Bowling Ball Bags'),
(4543, 4543, 0, 'Sporting Goods > Indoor Games > Bowling > Bowling Balls'),
(4544, 4544, 0, 'Sporting Goods > Indoor Games > Bowling > Bowling Gloves'),
(4545, 4545, 0, 'Sporting Goods > Indoor Games > Bowling > Bowling Pins'),
(4546, 4546, 0, 'Sporting Goods > Indoor Games > Bowling > Bowling Wrist Supports'),
(4547, 4547, 0, 'Sporting Goods > Indoor Games > Foosball'),
(4548, 4548, 0, 'Sporting Goods > Indoor Games > Foosball > Foosball Balls'),
(4549, 4549, 0, 'Sporting Goods > Indoor Games > Foosball > Foosball Table Parts & Accessories'),
(4550, 4550, 0, 'Sporting Goods > Indoor Games > Foosball > Foosball Tables'),
(4551, 4551, 0, 'Sporting Goods > Indoor Games > Multi-Game Tables'),
(4552, 4552, 0, 'Sporting Goods > Indoor Games > Ping Pong'),
(4553, 4553, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Balls'),
(4554, 4554, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Nets & Posts'),
(4555, 4555, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Paddle Accessories'),
(4556, 4556, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Paddles & Sets'),
(4557, 4557, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Robot Accessories'),
(4558, 4558, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Robots'),
(4559, 4559, 0, 'Sporting Goods > Indoor Games > Ping Pong > Ping Pong Tables'),
(4560, 4560, 0, 'Sporting Goods > Indoor Games > Table Shuffleboard'),
(4561, 4561, 0, 'Sporting Goods > Indoor Games > Table Shuffleboard > Shuffleboard Tables'),
(4562, 4562, 0, 'Sporting Goods > Indoor Games > Table Shuffleboard > Table Shuffleboard Powder'),
(4563, 4563, 0, 'Sporting Goods > Indoor Games > Table Shuffleboard > Table Shuffleboard Pucks'),
(4564, 4564, 0, 'Sporting Goods > Indoor Games > Throwing Darts'),
(4565, 4565, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dart Backboards'),
(4566, 4566, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dart Parts'),
(4567, 4567, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dart Parts > Dart Flights'),
(4568, 4568, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dart Parts > Dart Shafts'),
(4569, 4569, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dart Parts > Dart Tips'),
(4570, 4570, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Dartboards'),
(4571, 4571, 0, 'Sporting Goods > Indoor Games > Throwing Darts > Darts'),
(4572, 4572, 0, 'Sporting Goods > Outdoor Recreation'),
(4573, 4573, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports'),
(4574, 4574, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting'),
(4575, 4575, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Boating Gloves'),
(4576, 4576, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Canoe Accessories'),
(4577, 4577, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Canoes'),
(4578, 4578, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Kayak Accessories'),
(4579, 4579, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Kayaks'),
(4580, 4580, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Paddle Leashes'),
(4581, 4581, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Paddles & Oars'),
(4582, 4582, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Pedal Boats'),
(4583, 4583, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Row Boats'),
(4584, 4584, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Rafting > Whitewater Rafts'),
(4585, 4585, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel'),
(4586, 4586, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Drysuits'),
(4587, 4587, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Life Jacket Accessories'),
(4588, 4588, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Life Jackets'),
(4589, 4589, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Rash Guards & Swim Shirts'),
(4590, 4590, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Water Sport Helmets'),
(4591, 4591, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Wetsuit Pieces'),
(4592, 4592, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Wetsuit Pieces > Wetsuit Bottoms'),
(4593, 4593, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Wetsuit Pieces > Wetsuit Hoods, Gloves & Boots'),
(4594, 4594, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Wetsuit Pieces > Wetsuit Tops'),
(4595, 4595, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Boating & Water Sport Apparel > Wetsuits'),
(4596, 4596, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling'),
(4597, 4597, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Buoyancy Compensators'),
(4598, 4598, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Dive Computers'),
(4599, 4599, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving & Snorkeling Equipment Sets'),
(4600, 4600, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving & Snorkeling Fins'),
(4601, 4601, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving & Snorkeling Masks'),
(4602, 4602, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving Belts'),
(4603, 4603, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving Knives & Shears'),
(4604, 4604, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Diving Regulators'),
(4605, 4605, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Diving & Snorkeling > Snorkels'),
(4606, 4606, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing'),
(4607, 4607, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing > Kiteboard Cases'),
(4608, 4608, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing > Kiteboard Parts'),
(4609, 4609, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing > Kiteboards'),
(4610, 4610, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing > Kitesurfing & Windsurfing Harnesses'),
(4611, 4611, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Kitesurfing > Kitesurfing Kites'),
(4612, 4612, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing'),
(4613, 4613, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Bodyboards'),
(4614, 4614, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Paddleboards'),
(4615, 4615, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Skimboards'),
(4616, 4616, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surf Leashes'),
(4617, 4617, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfboard Cases & Bags'),
(4618, 4618, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfboard Fins'),
(4619, 4619, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfboard Wax'),
(4620, 4620, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfboards'),
(4621, 4621, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfing Gloves'),
(4622, 4622, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Surfing > Surfing Tail Pads'),
(4623, 4623, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming'),
(4624, 4624, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Child Swimming Aids'),
(4625, 4625, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Hand Paddles'),
(4626, 4626, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Kickboards'),
(4627, 4627, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Pull Buoys'),
(4628, 4628, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Belts'),
(4629, 4629, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Caps'),
(4630, 4630, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Gloves'),
(4631, 4631, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Goggle & Mask Accessories'),
(4632, 4632, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Goggles & Masks'),
(4633, 4633, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swim Weights'),
(4634, 4634, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swimming Fins'),
(4635, 4635, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swimming Fins > Monofins'),
(4636, 4636, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swimming Fins > Training Fins'),
(4637, 4637, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swimming Machines'),
(4638, 4638, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Swimming > Swimming Nose Clips'),
(4639, 4639, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports'),
(4640, 4640, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Kneeboarding'),
(4641, 4641, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Kneeboarding > Kneeboards'),
(4642, 4642, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Towable Rafts & Tubes'),
(4643, 4643, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Towed Water Sport Gloves'),
(4644, 4644, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Wakeboarding'),
(4645, 4645, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Wakeboarding > Kiteboard & Wakeboard Bindings'),
(4646, 4646, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Wakeboarding > Wakeboard Parts'),
(4647, 4647, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Wakeboarding > Wakeboards'),
(4648, 4648, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Skiing'),
(4649, 4649, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Skiing > Sit-Down Hydrofoils'),
(4650, 4650, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Skiing > Water Ski Bindings'),
(4651, 4651, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Skiing > Water Ski Cases & Bags'),
(4652, 4652, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Skiing > Water Skis'),
(4653, 4653, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Towed Water Sports > Water Sport Tow Cables'),
(4654, 4654, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Watercraft Storage Racks'),
(4655, 4655, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Watercraft Storage Racks > Boat Storage Racks'),
(4656, 4656, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Watercraft Storage Racks > Water Sport Board Storage Racks'),
(4657, 4657, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing'),
(4658, 4658, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing > Windsurfing Board Parts'),
(4659, 4659, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing > Windsurfing Board Parts > Windsurfing Board Fins'),
(4660, 4660, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing > Windsurfing Board Parts > Windsurfing Board Masts'),
(4661, 4661, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing > Windsurfing Boards'),
(4662, 4662, 0, 'Sporting Goods > Outdoor Recreation > Boating & Water Sports > Windsurfing > Windsurfing Sails'),
(4663, 4663, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking'),
(4664, 4664, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camp Furniture'),
(4665, 4665, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camp Furniture > Air Mattress & Sleeping Pad Accessories'),
(4666, 4666, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camp Furniture > Air Mattresses'),
(4667, 4667, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camp Furniture > Cots'),
(4668, 4668, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Cookware & Dinnerware'),
(4669, 4669, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Lights & Lanterns'),
(4670, 4670, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Tools'),
(4671, 4671, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Tools > Hunting & Survival Knives'),
(4672, 4672, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Camping Tools > Multifunction Tools & Knives'),
(4673, 4673, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Chemical Hand Warmers'),
(4674, 4674, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Compression Sacks'),
(4675, 4675, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Hiking Pole Accessories'),
(4676, 4676, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Hiking Poles'),
(4677, 4677, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Mosquito Nets & Insect Screens'),
(4678, 4678, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Navigational Compasses'),
(4679, 4679, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Portable Toilets & Showers'),
(4680, 4680, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Portable Toilets & Showers > Portable Showers & Privacy Enclosures'),
(4681, 4681, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Portable Toilets & Showers > Portable Toilets & Urination Devices'),
(4682, 4682, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Portable Water Filters & Purifiers'),
(4683, 4683, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Sleeping Bag Liners'),
(4684, 4684, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Sleeping Bags'),
(4685, 4685, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Sleeping Pads'),
(4686, 4686, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tent Accessories'),
(4687, 4687, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tent Accessories > Inner Tents'),
(4688, 4688, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tent Accessories > Tent Footprints'),
(4689, 4689, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tent Accessories > Tent Poles & Stakes'),
(4690, 4690, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tent Accessories > Tent Vestibules'),
(4691, 4691, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Tents'),
(4692, 4692, 0, 'Sporting Goods > Outdoor Recreation > Camping & Hiking > Windbreaks'),
(4693, 4693, 0, 'Sporting Goods > Outdoor Recreation > Climbing'),
(4694, 4694, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Belay Devices'),
(4695, 4695, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Carabiners'),
(4696, 4696, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Apparel & Accessories'),
(4697, 4697, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Apparel & Accessories > Climbing Gloves'),
(4698, 4698, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Apparel & Accessories > Climbing Helmets'),
(4699, 4699, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Apparel & Accessories > Crampons'),
(4700, 4700, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Ascenders & Descenders'),
(4701, 4701, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Chalk Bags'),
(4702, 4702, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Crash Pads'),
(4703, 4703, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Harnesses'),
(4704, 4704, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Protection Devices'),
(4705, 4705, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Rope'),
(4706, 4706, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Rope Bags'),
(4707, 4707, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Climbing Webbing'),
(4708, 4708, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Ice Climbing Tools'),
(4709, 4709, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Ice Screws'),
(4710, 4710, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Indoor Climbing Holds'),
(4711, 4711, 0, 'Sporting Goods > Outdoor Recreation > Climbing > Quickdraws'),
(4712, 4712, 0, 'Sporting Goods > Outdoor Recreation > Cycling'),
(4713, 4713, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories'),
(4714, 4714, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Bags & Panniers'),
(4715, 4715, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Baskets'),
(4716, 4716, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Bells & Horns'),
(4717, 4717, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Cages'),
(4718, 4718, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Child Seat Accessories'),
(4719, 4719, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Child Seats'),
(4720, 4720, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Computer Accessories'),
(4721, 4721, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Computers'),
(4722, 4722, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Covers'),
(4723, 4723, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Fenders'),
(4724, 4724, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Front & Rear Racks'),
(4725, 4725, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Handlebar Grips & Decor'),
(4726, 4726, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Locks'),
(4727, 4727, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Mirrors'),
(4728, 4728, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Pumps'),
(4729, 4729, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Saddle Pads & Seat Covers'),
(4730, 4730, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Shock Pumps'),
(4731, 4731, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Spoke Beads'),
(4732, 4732, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Stands & Storage'),
(4733, 4733, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Tire Repair Supplies & Kits'),
(4734, 4734, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Toe Straps & Clips'),
(4735, 4735, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Tools'),
(4736, 4736, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Trailers'),
(4737, 4737, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Trainers'),
(4738, 4738, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Training Wheels'),
(4739, 4739, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Transport Bags & Cases'),
(4740, 4740, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Bicycle Water Sport Board Racks'),
(4741, 4741, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Accessories > Electric Bicycle Conversion Kits'),
(4742, 4742, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts');
INSERT INTO `eav_attribute_option_value` (`value_id`, `option_id`, `store_id`, `value`) VALUES
(4743, 4743, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Brake Parts'),
(4744, 4744, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Brake Parts > Bicycle Brake Calipers'),
(4745, 4745, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Brake Parts > Bicycle Brake Levers'),
(4746, 4746, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Brake Parts > Bicycle Brake Rotors'),
(4747, 4747, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Brake Parts > Bicycle Brake Sets'),
(4748, 4748, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Cable Housings'),
(4749, 4749, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Cables'),
(4750, 4750, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts'),
(4751, 4751, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Bottom Brackets'),
(4752, 4752, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Cassettes & Freewheels'),
(4753, 4753, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Chainrings'),
(4754, 4754, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Chains'),
(4755, 4755, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Cranks'),
(4756, 4756, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Derailleurs'),
(4757, 4757, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Pedals'),
(4758, 4758, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Drivetrain Parts > Bicycle Shifters'),
(4759, 4759, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Forks'),
(4760, 4760, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Frames'),
(4761, 4761, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Groupsets'),
(4762, 4762, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Handlebar Extensions'),
(4763, 4763, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Handlebars'),
(4764, 4764, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Headset Parts'),
(4765, 4765, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Headset Parts > Bicycle Headset Bearings'),
(4766, 4766, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Headset Parts > Bicycle Headset Spacers'),
(4767, 4767, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Headsets'),
(4768, 4768, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Kickstands'),
(4769, 4769, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Saddles'),
(4770, 4770, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Seatpost Clamps'),
(4771, 4771, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Seatposts'),
(4772, 4772, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Small Parts'),
(4773, 4773, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Stems'),
(4774, 4774, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Tire Valve Adapters'),
(4775, 4775, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Tire Valve Caps'),
(4776, 4776, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Tire Valves'),
(4777, 4777, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Tires'),
(4778, 4778, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Tubes'),
(4779, 4779, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts'),
(4780, 4780, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Foot Pegs'),
(4781, 4781, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Hub Parts'),
(4782, 4782, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Hubs'),
(4783, 4783, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Rim Strips'),
(4784, 4784, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Spokes'),
(4785, 4785, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Wheel Axles & Skewers'),
(4786, 4786, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Wheel Nipples'),
(4787, 4787, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheel Parts > Bicycle Wheel Rims'),
(4788, 4788, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycle Parts > Bicycle Wheels'),
(4789, 4789, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Bicycles'),
(4790, 4790, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories'),
(4791, 4791, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Cleat Accessories'),
(4792, 4792, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Cleat Accessories > Bicycle Cleat Bolts'),
(4793, 4793, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Cleat Accessories > Bicycle Cleat Covers'),
(4794, 4794, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Cleat Accessories > Bicycle Cleat Shims & Wedges'),
(4795, 4795, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Cleats'),
(4796, 4796, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Gloves'),
(4797, 4797, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Helmet Parts & Accessories'),
(4798, 4798, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Helmets'),
(4799, 4799, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Protective Pads'),
(4800, 4800, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Cycling Apparel & Accessories > Bicycle Shoe Covers'),
(4801, 4801, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Tricycle Accessories'),
(4802, 4802, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Tricycles'),
(4803, 4803, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Unicycle Accessories'),
(4804, 4804, 0, 'Sporting Goods > Outdoor Recreation > Cycling > Unicycles'),
(4805, 4805, 0, 'Sporting Goods > Outdoor Recreation > Equestrian'),
(4806, 4806, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care'),
(4807, 4807, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Blankets & Sheets'),
(4808, 4808, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Boots & Leg Wraps'),
(4809, 4809, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Feed'),
(4810, 4810, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Fly Masks'),
(4811, 4811, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Grooming'),
(4812, 4812, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Grooming > Horse Clippers & Trimmers'),
(4813, 4813, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Grooming > Horse Grooming Combs, Brushes & Mitts'),
(4814, 4814, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Treats'),
(4815, 4815, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Vitamins & Supplements'),
(4816, 4816, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Care > Horse Wormers'),
(4817, 4817, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack'),
(4818, 4818, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Bridle Bits'),
(4819, 4819, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Bridles'),
(4820, 4820, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Cinches'),
(4821, 4821, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Horse Halters'),
(4822, 4822, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Horse Harnesses'),
(4823, 4823, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Horse Leads'),
(4824, 4824, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Reins'),
(4825, 4825, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Saddles'),
(4826, 4826, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack > Stirrups'),
(4827, 4827, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories'),
(4828, 4828, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Horse Tack Boxes'),
(4829, 4829, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Saddle Accessories'),
(4830, 4830, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Saddle Accessories > Saddle Bags & Panniers'),
(4831, 4831, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Saddle Accessories > Saddle Covers & Cases'),
(4832, 4832, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Saddle Accessories > Saddle Pads & Blankets'),
(4833, 4833, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Horse Tack Accessories > Saddle Accessories > Saddle Racks'),
(4834, 4834, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Riding Apparel & Accessories'),
(4835, 4835, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Riding Apparel & Accessories > Equestrian Gloves'),
(4836, 4836, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Riding Apparel & Accessories > Equestrian Helmets'),
(4837, 4837, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Riding Apparel & Accessories > Riding Crops & Whips'),
(4838, 4838, 0, 'Sporting Goods > Outdoor Recreation > Equestrian > Riding Apparel & Accessories > Riding Pants'),
(4839, 4839, 0, 'Sporting Goods > Outdoor Recreation > Fishing'),
(4840, 4840, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Bite Alarms'),
(4841, 4841, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing & Hunting Waders'),
(4842, 4842, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Bait & Chum Containers'),
(4843, 4843, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Gaffs'),
(4844, 4844, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Hook Removal Tools'),
(4845, 4845, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Lines & Leaders'),
(4846, 4846, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Nets'),
(4847, 4847, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Reel Accessories'),
(4848, 4848, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Reel Accessories > Fishing Reel Bags & Cases'),
(4849, 4849, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Reel Accessories > Fishing Reel Lubricants'),
(4850, 4850, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Reel Accessories > Fishing Reel Replacement Spools'),
(4851, 4851, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Reels'),
(4852, 4852, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Rod Accessories'),
(4853, 4853, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Rod Accessories > Fishing Rod Bags & Cases'),
(4854, 4854, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Rod Accessories > Fishing Rod Holders & Storage Racks'),
(4855, 4855, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Rods'),
(4856, 4856, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Spears'),
(4857, 4857, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle'),
(4858, 4858, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle > Fishing Baits & Lures'),
(4859, 4859, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle > Fishing Floats'),
(4860, 4860, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle > Fishing Hooks'),
(4861, 4861, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle > Fishing Sinkers'),
(4862, 4862, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Tackle > Fishing Snaps & Swivels'),
(4863, 4863, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fishing Traps'),
(4864, 4864, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fly Tying Materials'),
(4865, 4865, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fly Tying Materials > Fishing Beads'),
(4866, 4866, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Fly Tying Materials > Fishing Yarn'),
(4867, 4867, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Live Bait'),
(4868, 4868, 0, 'Sporting Goods > Outdoor Recreation > Fishing > Tackle Bags & Boxes'),
(4869, 4869, 0, 'Sporting Goods > Outdoor Recreation > Golf'),
(4870, 4870, 0, 'Sporting Goods > Outdoor Recreation > Golf > Divot Tools'),
(4871, 4871, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Accessory Sets'),
(4872, 4872, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Bag Accessories'),
(4873, 4873, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Bag Accessories > Golf Bag Carts'),
(4874, 4874, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Bag Accessories > Golf Bag Covers & Cases'),
(4875, 4875, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Bags'),
(4876, 4876, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Ball Markers'),
(4877, 4877, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Balls'),
(4878, 4878, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Club Parts & Accessories'),
(4879, 4879, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Club Parts & Accessories > Golf Club Grips'),
(4880, 4880, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Club Parts & Accessories > Golf Club Headcovers'),
(4881, 4881, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Club Parts & Accessories > Golf Club Shafts'),
(4882, 4882, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Clubs'),
(4883, 4883, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Flags'),
(4884, 4884, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Gloves'),
(4885, 4885, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Tees'),
(4886, 4886, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Towels'),
(4887, 4887, 0, 'Sporting Goods > Outdoor Recreation > Golf > Golf Training Aids'),
(4888, 4888, 0, 'Sporting Goods > Outdoor Recreation > Hang Gliding & Skydiving'),
(4889, 4889, 0, 'Sporting Goods > Outdoor Recreation > Hang Gliding & Skydiving > Air Suits'),
(4890, 4890, 0, 'Sporting Goods > Outdoor Recreation > Hang Gliding & Skydiving > Hang Gliders'),
(4891, 4891, 0, 'Sporting Goods > Outdoor Recreation > Hang Gliding & Skydiving > Parachutes'),
(4892, 4892, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting'),
(4893, 4893, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery'),
(4894, 4894, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Archery Armguards'),
(4895, 4895, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Archery Gloves & Releases'),
(4896, 4896, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Archery Targets'),
(4897, 4897, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Arrow Parts & Accessories'),
(4898, 4898, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Arrow Parts & Accessories > Arrow Fletchings'),
(4899, 4899, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Arrow Parts & Accessories > Arrow Nocks'),
(4900, 4900, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Arrow Parts & Accessories > Broadheads & Field Points'),
(4901, 4901, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Arrows & Bolts'),
(4902, 4902, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Bow & Crossbow Accessories'),
(4903, 4903, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Bows & Crossbows'),
(4904, 4904, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Bows & Crossbows > Compound Bows'),
(4905, 4905, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Bows & Crossbows > Crossbows'),
(4906, 4906, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Bows & Crossbows > Recurve & Longbows'),
(4907, 4907, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Archery > Quivers'),
(4908, 4908, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Clay Pigeon Shooting'),
(4909, 4909, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Clay Pigeon Shooting > Clay Pigeon Throwers'),
(4910, 4910, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Clay Pigeon Shooting > Clay Pigeons'),
(4911, 4911, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting'),
(4912, 4912, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting & Shooting Protective Gear'),
(4913, 4913, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting & Shooting Protective Gear > Hunting & Shooting Gloves'),
(4914, 4914, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting & Shooting Protective Gear > Hunting & Shooting Jackets'),
(4915, 4915, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Animal Traps'),
(4916, 4916, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Hearing Enhancers'),
(4917, 4917, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Hunting Blinds & Screens'),
(4918, 4918, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Hunting Dog Equipment'),
(4919, 4919, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Tree Stands'),
(4920, 4920, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wild Game Feeders'),
(4921, 4921, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wildlife Attractants'),
(4922, 4922, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wildlife Attractants > Cover Scents & Scent Attractants'),
(4923, 4923, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wildlife Attractants > Hunting & Wildlife Calls'),
(4924, 4924, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wildlife Attractants > Hunting & Wildlife Decoys'),
(4925, 4925, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Hunting > Wildlife Attractants > Wildlife Bait, Feed & Minerals'),
(4926, 4926, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft'),
(4927, 4927, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Airsoft'),
(4928, 4928, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Airsoft > Airsoft Gun Parts & Accessories'),
(4929, 4929, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Airsoft > Airsoft Gun Parts & Accessories > Airsoft Gun Batteries'),
(4930, 4930, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Airsoft > Airsoft Guns'),
(4931, 4931, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Airsoft > Airsoft Pellets'),
(4932, 4932, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball'),
(4933, 4933, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball & Airsoft Protective Gear'),
(4934, 4934, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball & Airsoft Protective Gear > Paintball & Airsoft Gloves'),
(4935, 4935, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball & Airsoft Protective Gear > Paintball & Airsoft Goggles & Masks'),
(4936, 4936, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball & Airsoft Protective Gear > Paintball & Airsoft Pads'),
(4937, 4937, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball & Airsoft Protective Gear > Paintball & Airsoft Vests'),
(4938, 4938, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Grenade Launchers'),
(4939, 4939, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Grenades'),
(4940, 4940, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Gun Parts & Accessories'),
(4941, 4941, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Gun Parts & Accessories > Paintball Air Tanks'),
(4942, 4942, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Gun Parts & Accessories > Paintball Gun Barrels'),
(4943, 4943, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Gun Parts & Accessories > Paintball Gun Drop Forwards'),
(4944, 4944, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Gun Parts & Accessories > Paintball Hoppers'),
(4945, 4945, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Guns'),
(4946, 4946, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintball Harnesses & Packs'),
(4947, 4947, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Paintball & Airsoft > Paintball > Paintballs'),
(4948, 4948, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Shooting & Range Accessories'),
(4949, 4949, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Shooting & Range Accessories > Shooting Rests'),
(4950, 4950, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Shooting & Range Accessories > Shooting Sticks & Bipods'),
(4951, 4951, 0, 'Sporting Goods > Outdoor Recreation > Hunting & Shooting > Shooting & Range Accessories > Shooting Targets'),
(4952, 4952, 0, 'Sporting Goods > Outdoor Recreation > Hydration System Accessories'),
(4953, 4953, 0, 'Sporting Goods > Outdoor Recreation > Hydration Systems'),
(4954, 4954, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating'),
(4955, 4955, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Inline & Roller Skating Protective Gear'),
(4956, 4956, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Inline & Roller Skating Protective Gear > Roller Skating Pads'),
(4957, 4957, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Inline Skate Parts'),
(4958, 4958, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Inline Skates'),
(4959, 4959, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Roller Skate Parts'),
(4960, 4960, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Roller Skates'),
(4961, 4961, 0, 'Sporting Goods > Outdoor Recreation > Inline & Roller Skating > Roller Skis'),
(4962, 4962, 0, 'Sporting Goods > Outdoor Recreation > Kite Buggying'),
(4963, 4963, 0, 'Sporting Goods > Outdoor Recreation > Kite Buggying > Kite Buggies'),
(4964, 4964, 0, 'Sporting Goods > Outdoor Recreation > Kite Buggying > Kite Buggy Accessories'),
(4965, 4965, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games'),
(4966, 4966, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Badminton'),
(4967, 4967, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Badminton > Badminton Nets'),
(4968, 4968, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Badminton > Badminton Racquets & Sets'),
(4969, 4969, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Badminton > Shuttlecocks'),
(4970, 4970, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Deck Shuffleboard'),
(4971, 4971, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Deck Shuffleboard > Deck Shuffleboard Cues'),
(4972, 4972, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Deck Shuffleboard > Deck Shuffleboard Pucks'),
(4973, 4973, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Disc Golf'),
(4974, 4974, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Disc Golf > Disc Golf Bags'),
(4975, 4975, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Disc Golf > Disc Golf Baskets'),
(4976, 4976, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Lawn Games'),
(4977, 4977, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Paddle Ball Sets'),
(4978, 4978, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Pickleball'),
(4979, 4979, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Pickleball > Pickleball Paddles'),
(4980, 4980, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Pickleball > Pickleballs'),
(4981, 4981, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Platform & Paddle Tennis'),
(4982, 4982, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Platform & Paddle Tennis > Platform & Paddle Tennis Paddles'),
(4983, 4983, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Platform & Paddle Tennis > Platform Tennis Balls'),
(4984, 4984, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Tetherball'),
(4985, 4985, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Tetherball > Tetherball Poles'),
(4986, 4986, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Tetherball > Tetherball Sets'),
(4987, 4987, 0, 'Sporting Goods > Outdoor Recreation > Outdoor Games > Tetherball > Tetherballs'),
(4988, 4988, 0, 'Sporting Goods > Outdoor Recreation > Riding Scooters'),
(4989, 4989, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding'),
(4990, 4990, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skate Rails'),
(4991, 4991, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skate Ramps'),
(4992, 4992, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboard Parts'),
(4993, 4993, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboard Parts > Skateboard Decks'),
(4994, 4994, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboard Parts > Skateboard Small Parts'),
(4995, 4995, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboard Parts > Skateboard Trucks'),
(4996, 4996, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboard Parts > Skateboard Wheels'),
(4997, 4997, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboarding Protective Gear'),
(4998, 4998, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboarding Protective Gear > Skate Helmets'),
(4999, 4999, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboarding Protective Gear > Skateboarding Gloves'),
(5000, 5000, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboarding Protective Gear > Skateboarding Pads'),
(5001, 5001, 0, 'Sporting Goods > Outdoor Recreation > Skateboarding > Skateboards'),
(5002, 5002, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities'),
(5003, 5003, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Avalanche Safety'),
(5004, 5004, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Avalanche Safety > Avalanche Probes'),
(5005, 5005, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Avalanche Safety > Avalanche Safety Airbags'),
(5006, 5006, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding'),
(5007, 5007, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Bags'),
(5008, 5008, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Goggle Accessories'),
(5009, 5009, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Goggle Accessories > Ski & Snowboard Goggle Lenses'),
(5010, 5010, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Goggles'),
(5011, 5011, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Helmets'),
(5012, 5012, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Leashes'),
(5013, 5013, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Storage Racks'),
(5014, 5014, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Tuning Tools'),
(5015, 5015, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski & Snowboard Wax'),
(5016, 5016, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski Binding Parts'),
(5017, 5017, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski Bindings'),
(5018, 5018, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski Boots'),
(5019, 5019, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Ski Poles'),
(5020, 5020, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Skis'),
(5021, 5021, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Skis > Cross-Country Skis'),
(5022, 5022, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Skis > Downhill Skis'),
(5023, 5023, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Snowboard Binding Parts'),
(5024, 5024, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Snowboard Bindings'),
(5025, 5025, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Snowboard Boots'),
(5026, 5026, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Skiing & Snowboarding > Snowboards'),
(5027, 5027, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Sleds'),
(5028, 5028, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Snowshoeing'),
(5029, 5029, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Snowshoeing > Snowshoe Bindings'),
(5030, 5030, 0, 'Sporting Goods > Outdoor Recreation > Winter Sports & Activities > Snowshoeing > Snowshoes'),
(5031, 5031, 0, 'Toys & Games'),
(5032, 5032, 0, 'Toys & Games > Game Timers'),
(5033, 5033, 0, 'Toys & Games > Games'),
(5034, 5034, 0, 'Toys & Games > Games > Battle Top Accessories'),
(5035, 5035, 0, 'Toys & Games > Games > Battle Tops'),
(5036, 5036, 0, 'Toys & Games > Games > Bingo Sets'),
(5037, 5037, 0, 'Toys & Games > Games > Blackjack & Craps Sets'),
(5038, 5038, 0, 'Toys & Games > Games > Board Games'),
(5039, 5039, 0, 'Toys & Games > Games > Card Game Accessories'),
(5040, 5040, 0, 'Toys & Games > Games > Card Games'),
(5041, 5041, 0, 'Toys & Games > Games > Dexterity Games'),
(5042, 5042, 0, 'Toys & Games > Games > Dice Sets & Games'),
(5043, 5043, 0, 'Toys & Games > Games > Poker Chip Accessories'),
(5044, 5044, 0, 'Toys & Games > Games > Poker Chip Accessories > Poker Chip Carriers & Trays'),
(5045, 5045, 0, 'Toys & Games > Games > Poker Chips & Sets'),
(5046, 5046, 0, 'Toys & Games > Games > Portable Electronic Games'),
(5047, 5047, 0, 'Toys & Games > Games > Roulette Wheels & Sets'),
(5048, 5048, 0, 'Toys & Games > Games > Slot Machines'),
(5049, 5049, 0, 'Toys & Games > Games > Tile Games'),
(5050, 5050, 0, 'Toys & Games > Outdoor Play Equipment'),
(5051, 5051, 0, 'Toys & Games > Outdoor Play Equipment > Inflatable Bouncer Accessories'),
(5052, 5052, 0, 'Toys & Games > Outdoor Play Equipment > Inflatable Bouncers'),
(5053, 5053, 0, 'Toys & Games > Outdoor Play Equipment > Play Swings'),
(5054, 5054, 0, 'Toys & Games > Outdoor Play Equipment > Play Tents & Tunnels'),
(5055, 5055, 0, 'Toys & Games > Outdoor Play Equipment > Playhouses'),
(5056, 5056, 0, 'Toys & Games > Outdoor Play Equipment > Pogo Sticks'),
(5057, 5057, 0, 'Toys & Games > Outdoor Play Equipment > Sandboxes'),
(5058, 5058, 0, 'Toys & Games > Outdoor Play Equipment > See Saws'),
(5059, 5059, 0, 'Toys & Games > Outdoor Play Equipment > Slides'),
(5060, 5060, 0, 'Toys & Games > Outdoor Play Equipment > Stilts'),
(5061, 5061, 0, 'Toys & Games > Outdoor Play Equipment > Swing Set & Playset Accessories'),
(5062, 5062, 0, 'Toys & Games > Outdoor Play Equipment > Swing Sets & Playsets'),
(5063, 5063, 0, 'Toys & Games > Outdoor Play Equipment > Trampoline Accessories'),
(5064, 5064, 0, 'Toys & Games > Outdoor Play Equipment > Trampolines'),
(5065, 5065, 0, 'Toys & Games > Outdoor Play Equipment > Water Play Equipment'),
(5066, 5066, 0, 'Toys & Games > Outdoor Play Equipment > Water Play Equipment > Play Sprinkers'),
(5067, 5067, 0, 'Toys & Games > Outdoor Play Equipment > Water Play Equipment > Water Parks & Slides'),
(5068, 5068, 0, 'Toys & Games > Outdoor Play Equipment > Water Play Equipment > Water Tables'),
(5069, 5069, 0, 'Toys & Games > Puzzles'),
(5070, 5070, 0, 'Toys & Games > Puzzles > Jigsaw Puzzle Accessories'),
(5071, 5071, 0, 'Toys & Games > Puzzles > Jigsaw Puzzles'),
(5072, 5072, 0, 'Toys & Games > Puzzles > Mechanical Puzzles'),
(5073, 5073, 0, 'Toys & Games > Puzzles > Wooden & Pegged Puzzles'),
(5074, 5074, 0, 'Toys & Games > Toys'),
(5075, 5075, 0, 'Toys & Games > Toys > Activity Toys'),
(5076, 5076, 0, 'Toys & Games > Toys > Activity Toys > Ball & Cup Games'),
(5077, 5077, 0, 'Toys & Games > Toys > Activity Toys > Bouncy Balls'),
(5078, 5078, 0, 'Toys & Games > Toys > Activity Toys > Bubble Blowing Solution'),
(5079, 5079, 0, 'Toys & Games > Toys > Activity Toys > Bubble Blowing Toys'),
(5080, 5080, 0, 'Toys & Games > Toys > Activity Toys > Coiled Spring Toys'),
(5081, 5081, 0, 'Toys & Games > Toys > Activity Toys > Marbles'),
(5082, 5082, 0, 'Toys & Games > Toys > Activity Toys > Paddle Ball Toys'),
(5083, 5083, 0, 'Toys & Games > Toys > Activity Toys > Ribbon & Streamer Toys'),
(5084, 5084, 0, 'Toys & Games > Toys > Activity Toys > Spinning Tops'),
(5085, 5085, 0, 'Toys & Games > Toys > Activity Toys > Toy Jacks'),
(5086, 5086, 0, 'Toys & Games > Toys > Activity Toys > Yo-Yo Parts & Accessories'),
(5087, 5087, 0, 'Toys & Games > Toys > Activity Toys > Yo-Yos'),
(5088, 5088, 0, 'Toys & Games > Toys > Art & Drawing Toys'),
(5089, 5089, 0, 'Toys & Games > Toys > Art & Drawing Toys > Play Dough & Putty'),
(5090, 5090, 0, 'Toys & Games > Toys > Art & Drawing Toys > Toy Drawing Tablets'),
(5091, 5091, 0, 'Toys & Games > Toys > Ball Pit Accessories'),
(5092, 5092, 0, 'Toys & Games > Toys > Ball Pit Accessories > Ball Pit Balls'),
(5093, 5093, 0, 'Toys & Games > Toys > Ball Pits'),
(5094, 5094, 0, 'Toys & Games > Toys > Bath Toys'),
(5095, 5095, 0, 'Toys & Games > Toys > Beach & Sand Toys'),
(5096, 5096, 0, 'Toys & Games > Toys > Building Toys'),
(5097, 5097, 0, 'Toys & Games > Toys > Building Toys > Construction Set Toys'),
(5098, 5098, 0, 'Toys & Games > Toys > Building Toys > Foam Blocks'),
(5099, 5099, 0, 'Toys & Games > Toys > Building Toys > Interlocking Blocks'),
(5100, 5100, 0, 'Toys & Games > Toys > Building Toys > Marble Track Sets'),
(5101, 5101, 0, 'Toys & Games > Toys > Building Toys > Wooden Blocks'),
(5102, 5102, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures'),
(5103, 5103, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action & Toy Figures'),
(5104, 5104, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Bobblehead Figures'),
(5105, 5105, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Doll & Action Figure Accessories'),
(5106, 5106, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Dollhouse Accessories'),
(5107, 5107, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Dollhouses'),
(5108, 5108, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Dolls'),
(5109, 5109, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Paper & Magnetic Dolls'),
(5110, 5110, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Puppet & Puppet Theater Accessories'),
(5111, 5111, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Puppet Theaters'),
(5112, 5112, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Puppets & Marionettes'),
(5113, 5113, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Stuffed Animals'),
(5114, 5114, 0, 'Toys & Games > Toys > Dolls, Playsets & Toy Figures > Toy Playsets'),
(5115, 5115, 0, 'Toys & Games > Toys > Educational Toys'),
(5116, 5116, 0, 'Toys & Games > Toys > Educational Toys > Ant Farms'),
(5117, 5117, 0, 'Toys & Games > Toys > Educational Toys > Astronomy Toys & Models'),
(5118, 5118, 0, 'Toys & Games > Toys > Educational Toys > Bug Collecting Kits'),
(5119, 5119, 0, 'Toys & Games > Toys > Educational Toys > Educational Flash Cards'),
(5120, 5120, 0, 'Toys & Games > Toys > Educational Toys > Reading Toys'),
(5121, 5121, 0, 'Toys & Games > Toys > Educational Toys > Science & Exploration Sets'),
(5122, 5122, 0, 'Toys & Games > Toys > Educational Toys > Toy Abacuses'),
(5123, 5123, 0, 'Toys & Games > Toys > Executive Toys'),
(5124, 5124, 0, 'Toys & Games > Toys > Executive Toys > Magnet Toys'),
(5125, 5125, 0, 'Toys & Games > Toys > Flying Toy Accessories'),
(5126, 5126, 0, 'Toys & Games > Toys > Flying Toy Accessories > Kite Accessories'),
(5127, 5127, 0, 'Toys & Games > Toys > Flying Toy Accessories > Kite Accessories > Kite Line Reels & Winders'),
(5128, 5128, 0, 'Toys & Games > Toys > Flying Toys'),
(5129, 5129, 0, 'Toys & Games > Toys > Flying Toys > Air & Water Rockets'),
(5130, 5130, 0, 'Toys & Games > Toys > Flying Toys > Kites'),
(5131, 5131, 0, 'Toys & Games > Toys > Flying Toys > Toy Gliders'),
(5132, 5132, 0, 'Toys & Games > Toys > Flying Toys > Toy Parachutes'),
(5133, 5133, 0, 'Toys & Games > Toys > Musical Toys'),
(5134, 5134, 0, 'Toys & Games > Toys > Musical Toys > Toy Instruments'),
(5135, 5135, 0, 'Toys & Games > Toys > Play Vehicle Accessories'),
(5136, 5136, 0, 'Toys & Games > Toys > Play Vehicle Accessories > Toy Race Car & Track Accessories'),
(5137, 5137, 0, 'Toys & Games > Toys > Play Vehicle Accessories > Toy Train Accessories'),
(5138, 5138, 0, 'Toys & Games > Toys > Play Vehicles'),
(5139, 5139, 0, 'Toys & Games > Toys > Play Vehicles > Toy Airplanes'),
(5140, 5140, 0, 'Toys & Games > Toys > Play Vehicles > Toy Boats'),
(5141, 5141, 0, 'Toys & Games > Toys > Play Vehicles > Toy Cars'),
(5142, 5142, 0, 'Toys & Games > Toys > Play Vehicles > Toy Helicopters'),
(5143, 5143, 0, 'Toys & Games > Toys > Play Vehicles > Toy Motorcycles'),
(5144, 5144, 0, 'Toys & Games > Toys > Play Vehicles > Toy Race Car & Track Sets'),
(5145, 5145, 0, 'Toys & Games > Toys > Play Vehicles > Toy Spaceships'),
(5146, 5146, 0, 'Toys & Games > Toys > Play Vehicles > Toy Trains & Train Sets'),
(5147, 5147, 0, 'Toys & Games > Toys > Play Vehicles > Toy Trucks & Construction Vehicles'),
(5148, 5148, 0, 'Toys & Games > Toys > Pretend Play'),
(5149, 5149, 0, 'Toys & Games > Toys > Pretend Play > Play Money & Banking'),
(5150, 5150, 0, 'Toys & Games > Toys > Pretend Play > Pretend Electronics'),
(5151, 5151, 0, 'Toys & Games > Toys > Pretend Play > Pretend Housekeeping'),
(5152, 5152, 0, 'Toys & Games > Toys > Pretend Play > Pretend Lawn & Garden'),
(5153, 5153, 0, 'Toys & Games > Toys > Pretend Play > Pretend Professions & Role Playing'),
(5154, 5154, 0, 'Toys & Games > Toys > Pretend Play > Pretend Shopping & Grocery'),
(5155, 5155, 0, 'Toys & Games > Toys > Pretend Play > Toy Kitchens & Play Food'),
(5156, 5156, 0, 'Toys & Games > Toys > Pretend Play > Toy Tools'),
(5157, 5157, 0, 'Toys & Games > Toys > Remote Control Toy Accessories'),
(5158, 5158, 0, 'Toys & Games > Toys > Remote Control Toys'),
(5159, 5159, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Airships & Blimps'),
(5160, 5160, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Boats & Watercraft'),
(5161, 5161, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Cars & Trucks'),
(5162, 5162, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Helicopters'),
(5163, 5163, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Motorcycles'),
(5164, 5164, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Planes'),
(5165, 5165, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Robots'),
(5166, 5166, 0, 'Toys & Games > Toys > Remote Control Toys > Remote Control Tanks'),
(5167, 5167, 0, 'Toys & Games > Toys > Riding Toy Accessories'),
(5168, 5168, 0, 'Toys & Games > Toys > Riding Toys'),
(5169, 5169, 0, 'Toys & Games > Toys > Riding Toys > Electric Riding Vehicles'),
(5170, 5170, 0, 'Toys & Games > Toys > Riding Toys > Hobby Horses'),
(5171, 5171, 0, 'Toys & Games > Toys > Riding Toys > Push & Pedal Riding Vehicles'),
(5172, 5172, 0, 'Toys & Games > Toys > Riding Toys > Rocking & Spring Riding Toys'),
(5173, 5173, 0, 'Toys & Games > Toys > Riding Toys > Wagons'),
(5174, 5174, 0, 'Toys & Games > Toys > Robotic Toys'),
(5175, 5175, 0, 'Toys & Games > Toys > Sports Toy Accessories'),
(5176, 5176, 0, 'Toys & Games > Toys > Sports Toy Accessories > Fitness Toy Accessories'),
(5177, 5177, 0, 'Toys & Games > Toys > Sports Toy Accessories > Fitness Toy Accessories > Hula Hoop Accessories'),
(5178, 5178, 0, 'Toys & Games > Toys > Sports Toys'),
(5179, 5179, 0, 'Toys & Games > Toys > Sports Toys > Baseball Toys'),
(5180, 5180, 0, 'Toys & Games > Toys > Sports Toys > Basketball Toys'),
(5181, 5181, 0, 'Toys & Games > Toys > Sports Toys > Boomerangs'),
(5182, 5182, 0, 'Toys & Games > Toys > Sports Toys > Bowling Toys'),
(5183, 5183, 0, 'Toys & Games > Toys > Sports Toys > Fingerboards & Fingerboard Sets'),
(5184, 5184, 0, 'Toys & Games > Toys > Sports Toys > Fishing Toys'),
(5185, 5185, 0, 'Toys & Games > Toys > Sports Toys > Fitness Toys'),
(5186, 5186, 0, 'Toys & Games > Toys > Sports Toys > Fitness Toys > Hula Hoops'),
(5187, 5187, 0, 'Toys & Games > Toys > Sports Toys > Flying Discs'),
(5188, 5188, 0, 'Toys & Games > Toys > Sports Toys > Footbags'),
(5189, 5189, 0, 'Toys & Games > Toys > Sports Toys > Golf Toys'),
(5190, 5190, 0, 'Toys & Games > Toys > Sports Toys > Hockey Toys'),
(5191, 5191, 0, 'Toys & Games > Toys > Sports Toys > Playground Balls'),
(5192, 5192, 0, 'Toys & Games > Toys > Sports Toys > Racquet Sport Toys'),
(5193, 5193, 0, 'Toys & Games > Toys > Sports Toys > Toy Footballs'),
(5194, 5194, 0, 'Toys & Games > Toys > Toy Gift Baskets'),
(5195, 5195, 0, 'Toys & Games > Toys > Toy Weapon & Gadget Accessories'),
(5196, 5196, 0, 'Toys & Games > Toys > Toy Weapons & Gadgets'),
(5197, 5197, 0, 'Toys & Games > Toys > Visual Toys'),
(5198, 5198, 0, 'Toys & Games > Toys > Visual Toys > Kaleidoscopes'),
(5199, 5199, 0, 'Toys & Games > Toys > Visual Toys > Prisms'),
(5200, 5200, 0, 'Toys & Games > Toys > Wind-Up Toys'),
(5201, 5201, 0, 'Vehicles & Parts'),
(5202, 5202, 0, 'Vehicles & Parts > Vehicle Parts & Accessories'),
(5203, 5203, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Aircraft Parts & Accessories'),
(5204, 5204, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics'),
(5205, 5205, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle A/V Players & In-Dash Systems'),
(5206, 5206, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Amplifiers'),
(5207, 5207, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Cassette Adapters'),
(5208, 5208, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Cassette Players'),
(5209, 5209, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Equalizers & Crossovers'),
(5210, 5210, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Parking Cameras'),
(5211, 5211, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Speakerphones'),
(5212, 5212, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Speakers'),
(5213, 5213, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Subwoofers'),
(5214, 5214, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Electronics > Motor Vehicle Video Monitor Mounts'),
(5215, 5215, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts'),
(5216, 5216, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Braking'),
(5217, 5217, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Carpet & Upholstery'),
(5218, 5218, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Climate Control'),
(5219, 5219, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Controls'),
(5220, 5220, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Engine Oil Circulation'),
(5221, 5221, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Engine Parts'),
(5222, 5222, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Engines'),
(5223, 5223, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Exhaust'),
(5224, 5224, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Frame & Body Parts'),
(5225, 5225, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Fuel Systems'),
(5226, 5226, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Interior Fittings'),
(5227, 5227, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Lighting'),
(5228, 5228, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Mirrors'),
(5229, 5229, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Power & Electrical Systems'),
(5230, 5230, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Seating'),
(5231, 5231, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Sensors & Gauges'),
(5232, 5232, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Suspension Parts'),
(5233, 5233, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Towing'),
(5234, 5234, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Transmission & Drivetrain Parts'),
(5235, 5235, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems'),
(5236, 5236, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Rims & Wheels'),
(5237, 5237, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Rims & Wheels > Automotive Rims & Wheels'),
(5238, 5238, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Rims & Wheels > Motorcycle Rims & Wheels'),
(5239, 5239, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Rims & Wheels > Off-Road and All-Terrain Vehicle Rims & Wheels'),
(5240, 5240, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Tire Accessories'),
(5241, 5241, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Tires'),
(5242, 5242, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Tires > Automotive Tires'),
(5243, 5243, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Tires > Motorcycle Tires'),
(5244, 5244, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Tires > Off-Road and All-Terrain Vehicle Tires'),
(5245, 5245, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Wheel Systems > Motor Vehicle Wheel Parts'),
(5246, 5246, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Motor Vehicle Parts > Motor Vehicle Window Parts & Accessories'),
(5247, 5247, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor'),
(5248, 5248, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Portable Fuel Cans'),
(5249, 5249, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning'),
(5250, 5250, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Car Wash Brushes'),
(5251, 5251, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Car Wash Solutions');
INSERT INTO `eav_attribute_option_value` (`value_id`, `option_id`, `store_id`, `value`) VALUES
(5252, 5252, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Vehicle Carpet & Upholstery Cleaners'),
(5253, 5253, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Vehicle Fuel Injection Cleaning Kits'),
(5254, 5254, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Vehicle Glass Cleaners'),
(5255, 5255, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Cleaning > Vehicle Waxes, Polishes & Protectants'),
(5256, 5256, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers'),
(5257, 5257, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Golf Cart Enclosures'),
(5258, 5258, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Motor Vehicle Windshield Covers'),
(5259, 5259, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Tonneau Covers'),
(5260, 5260, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Hardtops'),
(5261, 5261, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Soft Tops'),
(5262, 5262, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers'),
(5263, 5263, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers > Automotive Storage Covers'),
(5264, 5264, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers > Golf Cart Storage Covers'),
(5265, 5265, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers > Motorcycle Storage Covers'),
(5266, 5266, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers > Recreational Vehicle Storage Covers'),
(5267, 5267, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Covers > Vehicle Storage Covers > Watercraft Storage Covers'),
(5268, 5268, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor'),
(5269, 5269, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Bumper Stickers'),
(5270, 5270, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Air Fresheners'),
(5271, 5271, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Antenna Balls'),
(5272, 5272, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Dashboard Accessories'),
(5273, 5273, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Decals'),
(5274, 5274, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Decor Accessory Sets'),
(5275, 5275, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Display Flags'),
(5276, 5276, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Emblems & Hood Ornaments'),
(5277, 5277, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Hitch Covers'),
(5278, 5278, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle License Plate Covers'),
(5279, 5279, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle License Plate Frames'),
(5280, 5280, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle License Plate Mounts & Holders'),
(5281, 5281, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle License Plates'),
(5282, 5282, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Magnets'),
(5283, 5283, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Rear View Mirror Ornaments'),
(5284, 5284, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Shift Boots'),
(5285, 5285, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Shift Knobs'),
(5286, 5286, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Steering Wheel Covers'),
(5287, 5287, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Decor > Vehicle Wraps'),
(5288, 5288, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids'),
(5289, 5289, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Antifreeze'),
(5290, 5290, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Brake Fluid'),
(5291, 5291, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Cooling System Additives'),
(5292, 5292, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Engine Degreasers'),
(5293, 5293, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Fuel System Cleaners'),
(5294, 5294, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Greases'),
(5295, 5295, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Hydraulic Clutch Fluid'),
(5296, 5296, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Motor Oil'),
(5297, 5297, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Performance Additives'),
(5298, 5298, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Power Steering Fluid'),
(5299, 5299, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Transmission Fluid'),
(5300, 5300, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Fluids > Vehicle Windshield Fluid'),
(5301, 5301, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Paint'),
(5302, 5302, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Paint > Motor Vehicle Body Paint'),
(5303, 5303, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Paint > Motor Vehicle Brake Caliper Paint'),
(5304, 5304, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools'),
(5305, 5305, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Motor Vehicle Brake Service Kits'),
(5306, 5306, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Motor Vehicle Clutch Alignment & Removal Tools'),
(5307, 5307, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Battery Chargers'),
(5308, 5308, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Battery Testers'),
(5309, 5309, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Body Filler'),
(5310, 5310, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Diagnostic Scanners'),
(5311, 5311, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Jump Starters'),
(5312, 5312, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Jumper Cables'),
(5313, 5313, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Vehicle Tire Repair & Tire Changing Tools'),
(5314, 5314, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Maintenance, Care & Decor > Vehicle Repair & Specialty Tools > Windshield Repair Kits'),
(5315, 5315, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security'),
(5316, 5316, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear'),
(5317, 5317, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Chest & Back Protectors'),
(5318, 5318, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Elbow & Wrist Guards'),
(5319, 5319, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Gloves'),
(5320, 5320, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Goggles'),
(5321, 5321, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Hand Guards'),
(5322, 5322, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Helmet Parts & Accessories'),
(5323, 5323, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Helmets'),
(5324, 5324, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Kidney Belts'),
(5325, 5325, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Knee & Shin Guards'),
(5326, 5326, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Motorcycle Protective Gear > Motorcycle Neck Braces'),
(5327, 5327, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Off-Road & All-Terrain Vehicle Protective Gear'),
(5328, 5328, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Off-Road & All-Terrain Vehicle Protective Gear > ATV & UTV Bar Pads'),
(5329, 5329, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks'),
(5330, 5330, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Automotive Alarm Accessories'),
(5331, 5331, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Automotive Alarm Systems'),
(5332, 5332, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Motorcycle Alarms & Locks'),
(5333, 5333, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Door Locks & Parts'),
(5334, 5334, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Door Locks & Parts > Vehicle Door Lock Actuators'),
(5335, 5335, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Door Locks & Parts > Vehicle Door Lock Knobs'),
(5336, 5336, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Door Locks & Parts > Vehicle Door Locks & Locking Systems'),
(5337, 5337, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Hitch Locks'),
(5338, 5338, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Immobilizers'),
(5339, 5339, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Remote Keyless Systems'),
(5340, 5340, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Steering Wheel Locks'),
(5341, 5341, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Alarms & Locks > Vehicle Wheel Clamps'),
(5342, 5342, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment'),
(5343, 5343, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Car Window Nets'),
(5344, 5344, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Emergency Road Flares'),
(5345, 5345, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Motor Vehicle Airbag Parts'),
(5346, 5346, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Motor Vehicle Roll Cages & Bars'),
(5347, 5347, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Seat Belt Buckles'),
(5348, 5348, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Seat Belt Covers'),
(5349, 5349, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Seat Belt Straps'),
(5350, 5350, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Seat Belts'),
(5351, 5351, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Warning Whips'),
(5352, 5352, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Safety & Security > Vehicle Safety Equipment > Vehicle Wheel Chocks'),
(5353, 5353, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo'),
(5354, 5354, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Cargo Nets'),
(5355, 5355, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Rack Accessories'),
(5356, 5356, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Rack Accessories > Vehicle Bicycle Rack Accessories'),
(5357, 5357, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Rack Accessories > Vehicle Ski & Snowboard Rack Accessories'),
(5358, 5358, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks'),
(5359, 5359, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Base Rack Systems'),
(5360, 5360, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Bicycle Racks'),
(5361, 5361, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Boat Racks'),
(5362, 5362, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Cargo Racks'),
(5363, 5363, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Fishing Rod Racks'),
(5364, 5364, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Gun Racks'),
(5365, 5365, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Motorcycle & Scooter Racks'),
(5366, 5366, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Ski & Snowboard Racks'),
(5367, 5367, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Carrying Racks > Vehicle Water Sport Board Racks'),
(5368, 5368, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Loading Ramps'),
(5369, 5369, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Trailers'),
(5370, 5370, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Trailers > Boat Trailers'),
(5371, 5371, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Trailers > Horse & Livestock Trailers'),
(5372, 5372, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Trailers > Travel Trailers'),
(5373, 5373, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motor Vehicle Trailers > Utility & Cargo Trailers'),
(5374, 5374, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Motorcycle Bags & Panniers'),
(5375, 5375, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Truck Bed Storage Boxes & Organizers'),
(5376, 5376, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Vehicle Headrest Hangers & Hooks'),
(5377, 5377, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Vehicle Storage & Cargo > Vehicle Organizers'),
(5378, 5378, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories'),
(5379, 5379, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring'),
(5380, 5380, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Anchor Chains'),
(5381, 5381, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Anchor Lines & Ropes'),
(5382, 5382, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Anchor Windlasses'),
(5383, 5383, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Anchors'),
(5384, 5384, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Boat Hooks'),
(5385, 5385, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Boat Ladders'),
(5386, 5386, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Dock Cleats'),
(5387, 5387, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Docking & Anchoring > Dock Steps'),
(5388, 5388, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Sailboat Parts'),
(5389, 5389, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Care'),
(5390, 5390, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Care > Watercraft Cleaners'),
(5391, 5391, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Care > Watercraft Polishes'),
(5392, 5392, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts'),
(5393, 5393, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Alternators'),
(5394, 5394, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Carburetors & Parts'),
(5395, 5395, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Engine Controls'),
(5396, 5396, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Ignition Parts'),
(5397, 5397, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Impellers'),
(5398, 5398, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Motor Locks'),
(5399, 5399, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Motor Mounts'),
(5400, 5400, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Pistons & Parts'),
(5401, 5401, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engine Parts > Watercraft Propellers'),
(5402, 5402, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Engines & Motors'),
(5403, 5403, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Exhaust Parts'),
(5404, 5404, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Exhaust Parts > Watercraft Manifolds'),
(5405, 5405, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Exhaust Parts > Watercraft Mufflers & Parts'),
(5406, 5406, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Fuel Systems'),
(5407, 5407, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Fuel Systems > Watercraft Fuel Lines & Parts'),
(5408, 5408, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Fuel Systems > Watercraft Fuel Meters'),
(5409, 5409, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Fuel Systems > Watercraft Fuel Pumps & Parts'),
(5410, 5410, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Fuel Systems > Watercraft Fuel Tanks & Parts'),
(5411, 5411, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Lighting'),
(5412, 5412, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Steering Parts'),
(5413, 5413, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Steering Parts > Watercraft Steering Cables'),
(5414, 5414, 0, 'Vehicles & Parts > Vehicle Parts & Accessories > Watercraft Parts & Accessories > Watercraft Steering Parts > Watercraft Steering Wheels'),
(5415, 5415, 0, 'Vehicles & Parts > Vehicles'),
(5416, 5416, 0, 'Vehicles & Parts > Vehicles > Aircraft'),
(5417, 5417, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles'),
(5418, 5418, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Cars, Trucks & Vans'),
(5419, 5419, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Golf Carts'),
(5420, 5420, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Motorcycles & Scooters'),
(5421, 5421, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Off-Road and All-Terrain Vehicles'),
(5422, 5422, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Off-Road and All-Terrain Vehicles > ATVs & UTVs'),
(5423, 5423, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Off-Road and All-Terrain Vehicles > Go Karts & Dune Buggies'),
(5424, 5424, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Recreational Vehicles'),
(5425, 5425, 0, 'Vehicles & Parts > Vehicles > Motor Vehicles > Snowmobiles'),
(5426, 5426, 0, 'Vehicles & Parts > Vehicles > Watercraft'),
(5427, 5427, 0, 'Vehicles & Parts > Vehicles > Watercraft > Motor Boats'),
(5428, 5428, 0, 'Vehicles & Parts > Vehicles > Watercraft > Personal Watercraft'),
(5429, 5429, 0, 'Vehicles & Parts > Vehicles > Watercraft > Sailboats'),
(5430, 5430, 0, 'Vehicles & Parts > Vehicles > Watercraft > Yachts');

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

--
-- Table structure for table `eav_attribute_set`
--

CREATE TABLE `eav_attribute_set` (
  `attribute_set_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Attribute Set ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
  `sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `eav_attribute_set`
--

INSERT INTO `eav_attribute_set` (`attribute_set_id`, `entity_type_id`, `attribute_set_name`, `sort_order`) VALUES
(1, 1, 'Default', 2),
(2, 2, 'Default', 2),
(3, 3, 'Default', 1),
(4, 4, 'Default', 1),
(5, 5, 'Default', 1),
(6, 6, 'Default', 1),
(7, 7, 'Default', 1),
(8, 8, 'Default', 1);

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

--
-- Table structure for table `eav_entity`
--

CREATE TABLE `eav_entity` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Parent ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `is_active` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Defines Is Entity Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

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

--
-- Table structure for table `eav_entity_attribute`
--

CREATE TABLE `eav_entity_attribute` (
  `entity_attribute_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity Attribute ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute Set ID',
  `attribute_group_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute Group ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `eav_entity_attribute`
--

INSERT INTO `eav_entity_attribute` (`entity_attribute_id`, `entity_type_id`, `attribute_set_id`, `attribute_group_id`, `attribute_id`, `sort_order`) VALUES
(1, 1, 1, 1, 1, 10),
(2, 1, 1, 1, 2, 20),
(3, 1, 1, 1, 3, 20),
(4, 1, 1, 1, 4, 30),
(5, 1, 1, 1, 5, 40),
(6, 1, 1, 1, 6, 50),
(7, 1, 1, 1, 7, 60),
(8, 1, 1, 1, 8, 70),
(9, 1, 1, 1, 9, 80),
(10, 1, 1, 1, 10, 25),
(11, 1, 1, 1, 11, 90),
(12, 1, 1, 1, 12, 81),
(13, 1, 1, 1, 13, 115),
(14, 1, 1, 1, 14, 120),
(15, 1, 1, 1, 15, 82),
(16, 1, 1, 1, 16, 83),
(17, 1, 1, 1, 17, 100),
(18, 1, 1, 1, 18, 0),
(19, 1, 1, 1, 19, 0),
(20, 1, 1, 1, 20, 110),
(21, 1, 1, 1, 21, 28),
(22, 2, 2, 2, 22, 10),
(23, 2, 2, 2, 23, 20),
(24, 2, 2, 2, 24, 30),
(25, 2, 2, 2, 25, 40),
(26, 2, 2, 2, 26, 50),
(27, 2, 2, 2, 27, 60),
(28, 2, 2, 2, 28, 70),
(29, 2, 2, 2, 29, 80),
(30, 2, 2, 2, 30, 90),
(31, 2, 2, 2, 31, 100),
(32, 2, 2, 2, 32, 100),
(33, 2, 2, 2, 33, 110),
(34, 2, 2, 2, 34, 120),
(35, 2, 2, 2, 35, 130),
(36, 2, 2, 2, 36, 140),
(37, 2, 2, 2, 37, 132),
(38, 2, 2, 2, 38, 133),
(39, 2, 2, 2, 39, 134),
(40, 2, 2, 2, 40, 135),
(41, 1, 1, 1, 41, 87),
(42, 1, 1, 1, 42, 100),
(43, 1, 1, 1, 43, 110),
(44, 1, 1, 1, 44, 120),
(45, 3, 3, 4, 45, 1),
(46, 3, 3, 4, 46, 2),
(47, 3, 3, 4, 47, 4),
(48, 3, 3, 4, 48, 5),
(49, 3, 3, 4, 49, 6),
(50, 3, 3, 4, 50, 7),
(51, 3, 3, 4, 51, 8),
(52, 3, 3, 5, 52, 10),
(53, 3, 3, 5, 53, 20),
(54, 3, 3, 5, 54, 30),
(55, 3, 3, 4, 55, 12),
(56, 3, 3, 4, 56, 13),
(57, 3, 3, 4, 57, 14),
(58, 3, 3, 4, 58, 15),
(59, 3, 3, 4, 59, 16),
(60, 3, 3, 6, 60, 10),
(61, 3, 3, 6, 61, 30),
(62, 3, 3, 6, 62, 40),
(63, 3, 3, 6, 63, 50),
(64, 3, 3, 6, 64, 60),
(65, 3, 3, 4, 65, 24),
(66, 3, 3, 4, 66, 25),
(67, 3, 3, 5, 67, 40),
(68, 3, 3, 5, 68, 50),
(69, 3, 3, 4, 69, 10),
(70, 3, 3, 6, 70, 5),
(71, 3, 3, 6, 71, 6),
(72, 3, 3, 5, 72, 51),
(73, 4, 4, 7, 73, 10),
(74, 4, 4, 7, 74, 20),
(75, 4, 4, 13, 75, 90),
(76, 4, 4, 13, 76, 100),
(77, 4, 4, 7, 77, 30),
(78, 4, 4, 8, 78, 3),
(79, 4, 4, 8, 79, 4),
(80, 4, 4, 8, 80, 5),
(81, 4, 4, 8, 81, 6),
(82, 4, 4, 7, 82, 70),
(83, 4, 4, 9, 84, 20),
(84, 4, 4, 9, 85, 30),
(85, 4, 4, 9, 86, 40),
(86, 4, 4, 10, 87, 1),
(87, 4, 4, 10, 88, 2),
(88, 4, 4, 10, 89, 3),
(89, 4, 4, 10, 90, 4),
(90, 4, 4, 7, 91, 6),
(91, 4, 4, 8, 92, 7),
(92, 4, 4, 7, 94, 90),
(93, 4, 4, 7, 95, 100),
(94, 4, 4, 10, 96, 5),
(95, 4, 4, 7, 97, 5),
(96, 4, 4, 8, 98, 8),
(97, 4, 4, 7, 99, 80),
(98, 4, 4, 14, 100, 40),
(99, 4, 4, 14, 101, 20),
(100, 4, 4, 14, 102, 30),
(101, 4, 4, 11, 103, 10),
(102, 4, 4, 11, 104, 5),
(103, 4, 4, 7, 105, 80),
(104, 4, 4, 11, 106, 6),
(105, 4, 4, 7, 107, 14),
(106, 4, 4, 7, 108, 15),
(107, 4, 4, 7, 109, 16),
(108, 4, 4, 7, 110, 17),
(109, 4, 4, 7, 111, 18),
(110, 4, 4, 7, 112, 19),
(111, 4, 4, 7, 113, 20),
(112, 4, 4, 7, 114, 110),
(113, 4, 4, 7, 115, 60),
(114, 4, 4, 14, 116, 50),
(115, 4, 4, 11, 117, 51),
(116, 3, 3, 6, 118, 51),
(117, 4, 4, 8, 119, 9),
(118, 4, 4, 8, 120, 10),
(119, 3, 3, 4, 121, 3),
(120, 3, 3, 4, 122, 17),
(121, 4, 4, 9, 123, 10),
(122, 4, 4, 7, 124, 11),
(123, 4, 4, 7, 125, 111),
(124, 4, 4, 7, 126, 112),
(125, 4, 4, 7, 127, 113),
(126, 4, 4, 7, 128, 114),
(127, 4, 4, 19, 129, 10),
(128, 4, 4, 7, 130, 115),
(129, 4, 4, 7, 131, 31),
(130, 4, 4, 7, 132, 21),
(131, 4, 4, 7, 133, 71),
(132, 4, 4, 8, 134, 11),
(133, 4, 4, 20, 135, 1),
(134, 4, 4, 10, 136, 3),
(135, 4, 4, 7, 137, 40);

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

--
-- Table structure for table `eav_entity_datetime`
--

CREATE TABLE `eav_entity_datetime` (
  `value_id` int(11) NOT NULL COMMENT 'Value ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `entity_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Attribute Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

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

--
-- Table structure for table `eav_entity_decimal`
--

CREATE TABLE `eav_entity_decimal` (
  `value_id` int(11) NOT NULL COMMENT 'Value ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `entity_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `value` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Attribute Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

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

--
-- Table structure for table `eav_entity_int`
--

CREATE TABLE `eav_entity_int` (
  `value_id` int(11) NOT NULL COMMENT 'Value ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `entity_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `value` int(11) NOT NULL DEFAULT 0 COMMENT 'Attribute Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

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

--
-- Table structure for table `eav_entity_store`
--

CREATE TABLE `eav_entity_store` (
  `entity_store_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity Store ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `increment_prefix` varchar(20) DEFAULT NULL COMMENT 'Increment Prefix',
  `increment_last_id` varchar(50) DEFAULT NULL COMMENT 'Last Incremented ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Store';

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

--
-- Table structure for table `eav_entity_text`
--

CREATE TABLE `eav_entity_text` (
  `value_id` int(11) NOT NULL COMMENT 'Value ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `entity_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `value` text NOT NULL COMMENT 'Attribute Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

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

--
-- Table structure for table `eav_entity_type`
--

CREATE TABLE `eav_entity_type` (
  `entity_type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Entity Type ID',
  `entity_type_code` varchar(50) NOT NULL COMMENT 'Entity Type Code',
  `entity_model` varchar(255) NOT NULL COMMENT 'Entity Model',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `entity_table` varchar(255) DEFAULT NULL COMMENT 'Entity Table',
  `value_table_prefix` varchar(255) DEFAULT NULL COMMENT 'Value Table Prefix',
  `entity_id_field` varchar(255) DEFAULT NULL COMMENT 'Entity ID Field',
  `is_data_sharing` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Defines Is Data Sharing',
  `data_sharing_key` varchar(100) DEFAULT 'default' COMMENT 'Data Sharing Key',
  `default_attribute_set_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Default Attribute Set ID',
  `increment_model` varchar(255) DEFAULT NULL COMMENT 'Increment Model',
  `increment_per_store` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Increment Per Store',
  `increment_pad_length` smallint(5) UNSIGNED NOT NULL DEFAULT 8 COMMENT 'Increment Pad Length',
  `increment_pad_char` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Increment Pad Char',
  `additional_attribute_table` varchar(255) DEFAULT NULL COMMENT 'Additional Attribute Table',
  `entity_attribute_collection` varchar(255) DEFAULT NULL COMMENT 'Entity Attribute Collection'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Type';

--
-- Dumping data for table `eav_entity_type`
--

INSERT INTO `eav_entity_type` (`entity_type_id`, `entity_type_code`, `entity_model`, `attribute_model`, `entity_table`, `value_table_prefix`, `entity_id_field`, `is_data_sharing`, `data_sharing_key`, `default_attribute_set_id`, `increment_model`, `increment_per_store`, `increment_pad_length`, `increment_pad_char`, `additional_attribute_table`, `entity_attribute_collection`) VALUES
(1, 'customer', 'Magento\\Customer\\Model\\ResourceModel\\Customer', 'Magento\\Customer\\Model\\Attribute', 'customer_entity', NULL, NULL, 1, 'default', 1, 'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue', 0, 8, '0', 'customer_eav_attribute', 'Magento\\Customer\\Model\\ResourceModel\\Attribute\\Collection'),
(2, 'customer_address', 'Magento\\Customer\\Model\\ResourceModel\\Address', 'Magento\\Customer\\Model\\Attribute', 'customer_address_entity', NULL, NULL, 1, 'default', 2, NULL, 0, 8, '0', 'customer_eav_attribute', 'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Collection'),
(3, 'catalog_category', 'Magento\\Catalog\\Model\\ResourceModel\\Category', 'Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute', 'catalog_category_entity', NULL, NULL, 1, 'default', 3, NULL, 0, 8, '0', 'catalog_eav_attribute', 'Magento\\Catalog\\Model\\ResourceModel\\Category\\Attribute\\Collection'),
(4, 'catalog_product', 'Magento\\Catalog\\Model\\ResourceModel\\Product', 'Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute', 'catalog_product_entity', NULL, NULL, 1, 'default', 4, NULL, 0, 8, '0', 'catalog_eav_attribute', 'Magento\\Catalog\\Model\\ResourceModel\\Product\\Attribute\\Collection'),
(5, 'order', 'Magento\\Sales\\Model\\ResourceModel\\Order', NULL, 'sales_order', NULL, NULL, 1, 'default', 5, 'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue', 1, 8, '0', NULL, NULL),
(6, 'invoice', 'Magento\\Sales\\Model\\ResourceModel\\Order\\Invoice', NULL, 'sales_invoice', NULL, NULL, 1, 'default', 6, 'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue', 1, 8, '0', NULL, NULL),
(7, 'creditmemo', 'Magento\\Sales\\Model\\ResourceModel\\Order\\Creditmemo', NULL, 'sales_creditmemo', NULL, NULL, 1, 'default', 7, 'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue', 1, 8, '0', NULL, NULL),
(8, 'shipment', 'Magento\\Sales\\Model\\ResourceModel\\Order\\Shipment', NULL, 'sales_shipment', NULL, NULL, 1, 'default', 8, 'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue', 1, 8, '0', NULL, NULL);

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

--
-- Table structure for table `eav_entity_varchar`
--

CREATE TABLE `eav_entity_varchar` (
  `value_id` int(11) NOT NULL COMMENT 'Value ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `entity_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Attribute Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

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

--
-- Table structure for table `eav_form_element`
--

CREATE TABLE `eav_form_element` (
  `element_id` int(10) UNSIGNED NOT NULL COMMENT 'Element ID',
  `type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Type ID',
  `fieldset_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Fieldset ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Attribute ID',
  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT 'Sort Order'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Element';

--
-- Dumping data for table `eav_form_element`
--

INSERT INTO `eav_form_element` (`element_id`, `type_id`, `fieldset_id`, `attribute_id`, `sort_order`) VALUES
(1, 1, NULL, 23, 0),
(2, 1, NULL, 25, 1),
(3, 1, NULL, 27, 2),
(4, 1, NULL, 9, 3),
(5, 1, NULL, 28, 4),
(6, 1, NULL, 29, 5),
(7, 1, NULL, 31, 6),
(8, 1, NULL, 33, 7),
(9, 1, NULL, 30, 8),
(10, 1, NULL, 34, 9),
(11, 1, NULL, 35, 10),
(12, 2, NULL, 23, 0),
(13, 2, NULL, 25, 1),
(14, 2, NULL, 27, 2),
(15, 2, NULL, 9, 3),
(16, 2, NULL, 28, 4),
(17, 2, NULL, 29, 5),
(18, 2, NULL, 31, 6),
(19, 2, NULL, 33, 7),
(20, 2, NULL, 30, 8),
(21, 2, NULL, 34, 9),
(22, 2, NULL, 35, 10),
(23, 3, NULL, 23, 0),
(24, 3, NULL, 25, 1),
(25, 3, NULL, 27, 2),
(26, 3, NULL, 28, 3),
(27, 3, NULL, 29, 4),
(28, 3, NULL, 31, 5),
(29, 3, NULL, 33, 6),
(30, 3, NULL, 30, 7),
(31, 3, NULL, 34, 8),
(32, 3, NULL, 35, 9),
(33, 4, NULL, 23, 0),
(34, 4, NULL, 25, 1),
(35, 4, NULL, 27, 2),
(36, 4, NULL, 28, 3),
(37, 4, NULL, 29, 4),
(38, 4, NULL, 31, 5),
(39, 4, NULL, 33, 6),
(40, 4, NULL, 30, 7),
(41, 4, NULL, 34, 8),
(42, 4, NULL, 35, 9);

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

--
-- Table structure for table `eav_form_fieldset`
--

CREATE TABLE `eav_form_fieldset` (
  `fieldset_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Fieldset ID',
  `type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Type ID',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT 'Sort Order'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset';

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

--
-- Table structure for table `eav_form_fieldset_label`
--

CREATE TABLE `eav_form_fieldset_label` (
  `fieldset_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Fieldset ID',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID',
  `label` varchar(255) NOT NULL COMMENT 'Label'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset Label';

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

--
-- Table structure for table `eav_form_type`
--

CREATE TABLE `eav_form_type` (
  `type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Type ID',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `label` varchar(255) NOT NULL COMMENT 'Label',
  `is_system` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is System',
  `theme` varchar(64) DEFAULT NULL COMMENT 'Theme',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Type';

--
-- Dumping data for table `eav_form_type`
--

INSERT INTO `eav_form_type` (`type_id`, `code`, `label`, `is_system`, `theme`, `store_id`) VALUES
(1, 'checkout_onepage_register', 'checkout_onepage_register', 1, '', 0),
(2, 'checkout_onepage_register_guest', 'checkout_onepage_register_guest', 1, '', 0),
(3, 'checkout_onepage_billing_address', 'checkout_onepage_billing_address', 1, '', 0),
(4, 'checkout_onepage_shipping_address', 'checkout_onepage_shipping_address', 1, '', 0);

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

--
-- Table structure for table `eav_form_type_entity`
--

CREATE TABLE `eav_form_type_entity` (
  `type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Type ID',
  `entity_type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Entity Type ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Type Entity';

--
-- Dumping data for table `eav_form_type_entity`
--

INSERT INTO `eav_form_type_entity` (`type_id`, `entity_type_id`) VALUES
(1, 1),
(1, 2),
(2, 1),
(2, 2),
(3, 2),
(4, 2);

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

--
-- Table structure for table `email_abandoned_cart`
--

CREATE TABLE `email_abandoned_cart` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `quote_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Quote Id',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store Id',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email',
  `status` varchar(255) NOT NULL DEFAULT '' COMMENT 'Contact Status',
  `is_active` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Quote Active',
  `quote_updated_at` timestamp NULL DEFAULT NULL COMMENT 'Quote updated at',
  `abandoned_cart_number` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Abandoned Cart number',
  `items_count` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Quote items count',
  `items_ids` varchar(255) DEFAULT NULL COMMENT 'Quote item ids',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated at'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Abandoned Carts Table';

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

--
-- Table structure for table `email_automation`
--

CREATE TABLE `email_automation` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `automation_type` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `enrolment_status` varchar(255) NOT NULL COMMENT 'Enrolment Status',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `type_id` varchar(255) DEFAULT NULL COMMENT 'Type ID',
  `program_id` varchar(255) DEFAULT NULL COMMENT 'Program ID',
  `website_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Website Id',
  `message` varchar(255) NOT NULL COMMENT 'Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Automation Status';

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

--
-- Table structure for table `email_campaign`
--

CREATE TABLE `email_campaign` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `campaign_id` int(10) UNSIGNED NOT NULL COMMENT 'Campaign ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Contact Email',
  `customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer ID',
  `sent_at` timestamp NULL DEFAULT NULL COMMENT 'Send Date',
  `order_increment_id` varchar(50) NOT NULL COMMENT 'Order Increment ID',
  `quote_id` int(10) UNSIGNED NOT NULL COMMENT 'Sales Quote ID',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `checkout_method` varchar(255) NOT NULL DEFAULT '' COMMENT 'Checkout Method Used',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `event_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Name',
  `send_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Send Id',
  `send_status` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Campaign send status',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Campaigns';

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

--
-- Table structure for table `email_catalog`
--

CREATE TABLE `email_catalog` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `product_id` int(10) UNSIGNED NOT NULL COMMENT 'Product Id',
  `imported` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Product imported [deprecated]',
  `modified` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Product modified [deprecated]',
  `processed` smallint(5) UNSIGNED NOT NULL COMMENT 'Product processed',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `last_imported_at` timestamp NULL DEFAULT NULL COMMENT 'Last imported date'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Catalog';

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

--
-- Table structure for table `email_contact`
--

CREATE TABLE `email_contact` (
  `email_contact_id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `is_guest` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Guest',
  `contact_id` varchar(15) DEFAULT NULL COMMENT 'Connector Contact ID',
  `customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Website ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Customer Email',
  `is_subscriber` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Subscriber',
  `subscriber_status` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Subscriber status',
  `email_imported` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is Imported',
  `subscriber_imported` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is Subscriber Imported',
  `suppressed` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Suppressed',
  `last_subscribed_at` timestamp NULL DEFAULT NULL COMMENT 'Last time user subscribed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Contacts';

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

--
-- Table structure for table `email_contact_consent`
--

CREATE TABLE `email_contact_consent` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `email_contact_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Email Contact Id',
  `consent_url` varchar(255) DEFAULT NULL COMMENT 'Contact consent url',
  `consent_datetime` datetime DEFAULT NULL COMMENT 'Contact consent datetime',
  `consent_ip` varchar(255) DEFAULT NULL COMMENT 'Contact consent ip',
  `consent_user_agent` varchar(255) DEFAULT NULL COMMENT 'Contact consent user agent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email contact consent table.';

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

--
-- Table structure for table `email_coupon_attribute`
--

CREATE TABLE `email_coupon_attribute` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `salesrule_coupon_id` int(10) UNSIGNED NOT NULL COMMENT 'Coupon ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon expiration date'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Dotdigital coupon attributes table';

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

--
-- Table structure for table `email_failed_auth`
--

CREATE TABLE `email_failed_auth` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `failures_num` int(10) UNSIGNED DEFAULT NULL COMMENT 'Number of fails',
  `first_attempt_date` datetime DEFAULT NULL COMMENT 'First attempt date',
  `last_attempt_date` datetime DEFAULT NULL COMMENT 'Last attempt date',
  `url` varchar(255) DEFAULT NULL COMMENT 'URL',
  `store_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Store Id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Failed Auth Table.';

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

--
-- Table structure for table `email_importer`
--

CREATE TABLE `email_importer` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `import_type` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Type',
  `website_id` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Website Id',
  `import_status` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Import Status',
  `import_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Id',
  `import_data` mediumblob NOT NULL DEFAULT '' COMMENT 'Import Data',
  `import_mode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Mode',
  `import_file` text NOT NULL DEFAULT '' COMMENT 'Import File',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `import_started` timestamp NULL DEFAULT NULL COMMENT 'Import Started',
  `import_finished` timestamp NULL DEFAULT NULL COMMENT 'Import Finished'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Importer';

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

--
-- Table structure for table `email_order`
--

CREATE TABLE `email_order` (
  `email_order_id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `order_id` int(10) UNSIGNED NOT NULL COMMENT 'Order ID',
  `order_status` varchar(255) NOT NULL COMMENT 'Order Status',
  `quote_id` int(10) UNSIGNED NOT NULL COMMENT 'Sales Quote ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `email_imported` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is Order Imported',
  `modified` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Order Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Transactional Order Data';

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

--
-- Table structure for table `email_review`
--

CREATE TABLE `email_review` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `review_id` int(10) UNSIGNED NOT NULL COMMENT 'Review Id',
  `customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store Id',
  `review_imported` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Review Imported',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Reviews';

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

--
-- Table structure for table `email_rules`
--

CREATE TABLE `email_rules` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Rule Name',
  `website_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `type` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Rule Type',
  `status` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Status',
  `combination` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Rule Condition',
  `conditions` blob NOT NULL COMMENT 'Rule Conditions',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Rules';

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

--
-- Table structure for table `email_template`
--

CREATE TABLE `email_template` (
  `template_id` int(10) UNSIGNED NOT NULL COMMENT 'Template ID',
  `template_code` varchar(150) NOT NULL COMMENT 'Template Name',
  `template_text` text NOT NULL COMMENT 'Template Content',
  `template_styles` text DEFAULT NULL COMMENT 'Templste Styles',
  `template_type` int(10) UNSIGNED DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) NOT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `added_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of Template Creation',
  `modified_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date of Template Modification',
  `orig_template_code` varchar(200) DEFAULT NULL COMMENT 'Original Template Code',
  `orig_template_variables` text DEFAULT NULL COMMENT 'Original Template Variables',
  `is_legacy` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should the template render in legacy mode'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Templates';

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

--
-- Table structure for table `email_wishlist`
--

CREATE TABLE `email_wishlist` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
  `wishlist_id` int(10) UNSIGNED NOT NULL COMMENT 'Wishlist Id',
  `item_count` int(10) UNSIGNED NOT NULL COMMENT 'Item Count',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store Id',
  `wishlist_imported` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Wishlist Imported',
  `wishlist_modified` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Wishlist Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Wishlist';

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

--
-- Table structure for table `flag`
--

CREATE TABLE `flag` (
  `flag_id` int(10) UNSIGNED NOT NULL COMMENT 'Flag Id',
  `flag_code` varchar(255) NOT NULL COMMENT 'Flag Code',
  `state` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Flag State',
  `flag_data` mediumtext DEFAULT NULL COMMENT 'Flag Data',
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date of Last Flag Update'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Flag';

--
-- Dumping data for table `flag`
--

INSERT INTO `flag` (`flag_id`, `flag_code`, `state`, `flag_data`, `last_update`) VALUES
(1, 'analytics_link_attempts_reverse_counter', 0, '24', '2020-09-16 04:50:14');

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

--
-- Table structure for table `gift_message`
--

CREATE TABLE `gift_message` (
  `gift_message_id` int(10) UNSIGNED NOT NULL COMMENT 'GiftMessage ID',
  `customer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `sender` varchar(255) DEFAULT NULL COMMENT 'Sender',
  `recipient` varchar(255) DEFAULT NULL COMMENT 'Registrant',
  `message` text DEFAULT NULL COMMENT 'Message'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Gift Message';

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

--
-- Table structure for table `googleoptimizer_code`
--

CREATE TABLE `googleoptimizer_code` (
  `code_id` int(10) UNSIGNED NOT NULL COMMENT 'Google experiment code ID',
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Optimized entity ID product ID or catalog ID',
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'Optimized entity type',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID',
  `experiment_script` text DEFAULT NULL COMMENT 'Google experiment script'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Google Experiment code';

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

--
-- Table structure for table `importexport_importdata`
--

CREATE TABLE `importexport_importdata` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `entity` varchar(50) NOT NULL COMMENT 'Entity',
  `behavior` varchar(10) NOT NULL DEFAULT 'append' COMMENT 'Behavior',
  `data` longtext DEFAULT NULL COMMENT 'Data'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Import Data Table';

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

--
-- Table structure for table `import_history`
--

CREATE TABLE `import_history` (
  `history_id` int(10) UNSIGNED NOT NULL COMMENT 'History record ID',
  `started_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Started at',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'User ID',
  `imported_file` varchar(255) DEFAULT NULL COMMENT 'Imported file',
  `execution_time` varchar(255) DEFAULT NULL COMMENT 'Execution time',
  `summary` varchar(255) DEFAULT NULL COMMENT 'Summary',
  `error_file` varchar(255) NOT NULL COMMENT 'Imported file with errors'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Import history table';

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

--
-- Table structure for table `indexer_state`
--

CREATE TABLE `indexer_state` (
  `state_id` int(10) UNSIGNED NOT NULL COMMENT 'Indexer State ID',
  `indexer_id` varchar(255) DEFAULT NULL COMMENT 'Indexer ID',
  `status` varchar(16) DEFAULT 'invalid' COMMENT 'Indexer Status',
  `updated` datetime DEFAULT NULL COMMENT 'Indexer Status',
  `hash_config` varchar(32) NOT NULL COMMENT 'Hash of indexer config'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Indexer State';

--
-- Dumping data for table `indexer_state`
--

INSERT INTO `indexer_state` (`state_id`, `indexer_id`, `status`, `updated`, `hash_config`) VALUES
(1, 'design_config_grid', 'valid', '2020-09-16 04:50:37', 'e965d5cea8bf3590547010dea7d93ced'),
(2, 'customer_grid', 'valid', '2020-09-16 04:50:39', '4306a2fdfb7e5e573fea06e14ca82f34'),
(3, 'catalog_category_product', 'invalid', '2020-09-16 04:39:47', '1bc48cb339e06824963035e6f659f399'),
(4, 'catalog_product_category', 'invalid', '2020-09-16 04:39:47', '9f30db45b1884800c3acc95f95c59027'),
(5, 'catalogrule_rule', 'invalid', '2020-09-16 04:39:47', '3b2f79e28d9a2523522c43f7f4a61808'),
(6, 'catalog_product_attribute', 'invalid', '2020-09-16 04:39:47', '31541333320d2c11e65f9236a97ebe34'),
(7, 'cataloginventory_stock', 'invalid', '2020-09-16 04:39:47', '1d39398e36709595df0c069f693b25ae'),
(8, 'inventory', 'invalid', '2020-09-16 04:39:47', '13ba3b9638f2226e874c96d3b94922f6'),
(9, 'catalogrule_product', 'invalid', '2020-09-16 04:39:47', 'f20f99e366e9e90809c969e976d09333'),
(10, 'catalog_product_price', 'invalid', '2020-09-16 04:39:47', '4be230c3ddc3a6a187ad68754f13a745'),
(11, 'scconnector_google_remove', 'invalid', '2020-09-16 04:39:47', '2715f6993f5e53e0b74b8ca31d581f49'),
(12, 'scconnector_google_feed', 'invalid', '2020-09-16 04:39:47', '7a66f614e9697270fbfd0ff5c05230f5'),
(13, 'catalogsearch_fulltext', 'invalid', '2020-09-16 04:39:47', '20454c607a71ef56c48d88b673a5f60d');

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

--
-- Table structure for table `integration`
--

CREATE TABLE `integration` (
  `integration_id` int(10) UNSIGNED NOT NULL COMMENT 'Integration ID',
  `name` varchar(255) NOT NULL COMMENT 'Integration name is displayed in the admin interface',
  `email` varchar(255) NOT NULL COMMENT 'Email address of the contact person',
  `endpoint` varchar(255) DEFAULT NULL COMMENT 'Endpoint for posting consumer credentials',
  `status` smallint(5) UNSIGNED NOT NULL COMMENT 'Integration status',
  `consumer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Oauth consumer',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Update Time',
  `setup_type` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Integration type - manual or config file',
  `identity_link_url` varchar(255) DEFAULT NULL COMMENT 'Identity linking Url'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='integration';

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

--
-- Table structure for table `inventory_geoname`
--

CREATE TABLE `inventory_geoname` (
  `country_code` varchar(64) NOT NULL,
  `postcode` varchar(64) NOT NULL,
  `city` varchar(180) NOT NULL,
  `region` varchar(100) NOT NULL,
  `province` varchar(64) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_low_stock_notification_configuration`
--

CREATE TABLE `inventory_low_stock_notification_configuration` (
  `source_code` varchar(255) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `notify_stock_qty` decimal(12,4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_reservation`
--

CREATE TABLE `inventory_reservation` (
  `reservation_id` int(10) UNSIGNED NOT NULL,
  `stock_id` int(10) UNSIGNED NOT NULL,
  `sku` varchar(64) NOT NULL,
  `quantity` decimal(10,4) NOT NULL DEFAULT 0.0000,
  `metadata` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_shipment_source`
--

CREATE TABLE `inventory_shipment_source` (
  `shipment_id` int(10) UNSIGNED NOT NULL,
  `source_code` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_source`
--

CREATE TABLE `inventory_source` (
  `source_code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `enabled` smallint(5) UNSIGNED NOT NULL DEFAULT 1,
  `description` text DEFAULT NULL,
  `latitude` decimal(8,6) DEFAULT NULL,
  `longitude` decimal(9,6) DEFAULT NULL,
  `country_id` varchar(2) NOT NULL,
  `region_id` int(10) UNSIGNED DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `use_default_carrier_config` smallint(5) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_source`
--

INSERT INTO `inventory_source` (`source_code`, `name`, `enabled`, `description`, `latitude`, `longitude`, `country_id`, `region_id`, `region`, `city`, `street`, `postcode`, `contact_name`, `email`, `phone`, `fax`, `use_default_carrier_config`) VALUES
('default', 'Default Source', 1, 'Default Source', 0.000000, 0.000000, 'US', NULL, NULL, NULL, NULL, '00000', NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `inventory_source_carrier_link`
--

CREATE TABLE `inventory_source_carrier_link` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `source_code` varchar(255) NOT NULL,
  `carrier_code` varchar(255) NOT NULL,
  `position` smallint(5) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_source_item`
--

CREATE TABLE `inventory_source_item` (
  `source_item_id` int(10) UNSIGNED NOT NULL,
  `source_code` varchar(255) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `quantity` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `status` smallint(5) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory_source_stock_link`
--

CREATE TABLE `inventory_source_stock_link` (
  `link_id` int(10) UNSIGNED NOT NULL,
  `stock_id` int(10) UNSIGNED NOT NULL,
  `source_code` varchar(255) NOT NULL,
  `priority` smallint(5) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_source_stock_link`
--

INSERT INTO `inventory_source_stock_link` (`link_id`, `stock_id`, `source_code`, `priority`) VALUES
(1, 1, 'default', 1);

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

--
-- Table structure for table `inventory_stock`
--

CREATE TABLE `inventory_stock` (
  `stock_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_stock`
--

INSERT INTO `inventory_stock` (`stock_id`, `name`) VALUES
(1, 'Default Stock');

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

--
-- Stand-in structure for view `inventory_stock_1`
-- (See below for the actual view)
--
CREATE TABLE `inventory_stock_1` (
`product_id` int(10) unsigned
,`website_id` smallint(5) unsigned
,`stock_id` smallint(5) unsigned
,`quantity` decimal(12,4)
,`is_salable` smallint(5) unsigned
,`sku` varchar(64)
);

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

--
-- Table structure for table `inventory_stock_sales_channel`
--

CREATE TABLE `inventory_stock_sales_channel` (
  `type` varchar(64) NOT NULL,
  `code` varchar(64) NOT NULL,
  `stock_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_stock_sales_channel`
--

INSERT INTO `inventory_stock_sales_channel` (`type`, `code`, `stock_id`) VALUES
('website', 'base', 1);

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

--
-- Table structure for table `klarna_core_order`
--

CREATE TABLE `klarna_core_order` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Entity Id',
  `klarna_order_id` varchar(255) DEFAULT NULL COMMENT 'Klarna Order Id',
  `session_id` varchar(255) DEFAULT NULL COMMENT 'Session Id',
  `reservation_id` varchar(255) DEFAULT NULL COMMENT 'Reservation Id',
  `order_id` int(10) UNSIGNED NOT NULL COMMENT 'Order Id',
  `is_acknowledged` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Acknowledged'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Klarna Order';

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

--
-- Table structure for table `klarna_payments_quote`
--

CREATE TABLE `klarna_payments_quote` (
  `payments_quote_id` int(10) UNSIGNED NOT NULL COMMENT 'Payments Id',
  `session_id` varchar(255) DEFAULT NULL COMMENT 'Klarna Session Id',
  `client_token` text DEFAULT NULL COMMENT 'Klarna Client Token',
  `authorization_token` varchar(255) DEFAULT NULL COMMENT 'Authorization Token',
  `is_active` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Active',
  `quote_id` int(10) UNSIGNED NOT NULL COMMENT 'Quote Id',
  `payment_methods` varchar(255) DEFAULT NULL COMMENT 'Payment Method Categories',
  `payment_method_info` text DEFAULT NULL COMMENT 'Payment Method Category Info'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Klarna Payments Quote';

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

--
-- Table structure for table `layout_link`
--

CREATE TABLE `layout_link` (
  `layout_link_id` int(10) UNSIGNED NOT NULL COMMENT 'Link ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `theme_id` int(10) UNSIGNED NOT NULL COMMENT 'Theme ID',
  `layout_update_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Layout Update ID',
  `is_temporary` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Defines whether Layout Update is Temporary'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Layout Link';

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

--
-- Table structure for table `layout_update`
--

CREATE TABLE `layout_update` (
  `layout_update_id` int(10) UNSIGNED NOT NULL COMMENT 'Layout Update ID',
  `handle` varchar(255) DEFAULT NULL COMMENT 'Handle',
  `xml` text DEFAULT NULL COMMENT 'Xml',
  `sort_order` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Sort Order',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() COMMENT 'Last Update Timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Layout Updates';

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

--
-- Table structure for table `magento_acknowledged_bulk`
--

CREATE TABLE `magento_acknowledged_bulk` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Internal ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bulk that was viewed by user from notification area';

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

--
-- Table structure for table `magento_bulk`
--

CREATE TABLE `magento_bulk` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Bulk Internal ID (must not be exposed)',
  `uuid` varbinary(39) DEFAULT NULL COMMENT 'Bulk UUID (can be exposed to reference bulk entity)',
  `user_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'ID of the WebAPI user that performed an action',
  `user_type` int(11) DEFAULT NULL COMMENT 'Which type of user',
  `description` varchar(255) DEFAULT NULL COMMENT 'Bulk Description',
  `operation_count` int(10) UNSIGNED NOT NULL COMMENT 'Total number of operations scheduled within this bulk',
  `start_time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Bulk start time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bulk entity that represents set of related asynchronous operations';

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

--
-- Table structure for table `magento_operation`
--

CREATE TABLE `magento_operation` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Operation ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Name of the related message queue topic',
  `serialized_data` blob DEFAULT NULL COMMENT 'Data (serialized) required to perform an operation',
  `result_serialized_data` blob DEFAULT NULL COMMENT 'Result data (serialized) after perform an operation',
  `status` smallint(6) DEFAULT 0 COMMENT 'Operation status (OPEN | COMPLETE | RETRIABLY_FAILED | NOT_RETRIABLY_FAILED)',
  `error_code` smallint(6) DEFAULT NULL COMMENT 'Code of the error that appeared during operation execution (used to aggregate related failed operations)',
  `result_message` varchar(255) DEFAULT NULL COMMENT 'Operation result message'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Operation entity';

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

--
-- Table structure for table `media_gallery_asset`
--

CREATE TABLE `media_gallery_asset` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `path` varchar(255) DEFAULT NULL COMMENT 'Path',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `source` varchar(255) DEFAULT NULL COMMENT 'Source',
  `content_type` varchar(255) DEFAULT NULL COMMENT 'Content Type',
  `width` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Width',
  `height` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Height',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Asset';

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

--
-- Table structure for table `media_gallery_asset_keyword`
--

CREATE TABLE `media_gallery_asset_keyword` (
  `keyword_id` int(10) UNSIGNED NOT NULL COMMENT 'Keyword Id',
  `asset_id` int(10) UNSIGNED NOT NULL COMMENT 'Asset ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Asset Keyword';

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

--
-- Table structure for table `media_gallery_keyword`
--

CREATE TABLE `media_gallery_keyword` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Keyword ID',
  `keyword` varchar(255) NOT NULL COMMENT 'Keyword'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Media Gallery Keyword';

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

--
-- Table structure for table `msp_tfa_country_codes`
--

CREATE TABLE `msp_tfa_country_codes` (
  `msp_tfa_country_codes_id` int(10) UNSIGNED NOT NULL COMMENT 'TFA admin user ID',
  `code` text NOT NULL COMMENT 'Country code',
  `name` text NOT NULL COMMENT 'Country name',
  `dial_code` text NOT NULL COMMENT 'Prefix'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_country_codes';

--
-- Dumping data for table `msp_tfa_country_codes`
--

INSERT INTO `msp_tfa_country_codes` (`msp_tfa_country_codes_id`, `code`, `name`, `dial_code`) VALUES
(1, 'IL', 'Israel', '+972'),
(2, 'AF', 'Afghanistan', '+93'),
(3, 'AL', 'Albania', '+355'),
(4, 'DZ', 'Algeria', '+213'),
(5, 'AS', 'AmericanSamoa', '+1 684'),
(6, 'AD', 'Andorra', '+376'),
(7, 'AO', 'Angola', '+244'),
(8, 'AI', 'Anguilla', '+1 264'),
(9, 'AG', 'Antigua and Barbuda', '+1268'),
(10, 'AR', 'Argentina', '+54'),
(11, 'AM', 'Armenia', '+374'),
(12, 'AW', 'Aruba', '+297'),
(13, 'AU', 'Australia', '+61'),
(14, 'AT', 'Austria', '+43'),
(15, 'AZ', 'Azerbaijan', '+994'),
(16, 'BS', 'Bahamas', '+1 242'),
(17, 'BH', 'Bahrain', '+973'),
(18, 'BD', 'Bangladesh', '+880'),
(19, 'BB', 'Barbados', '+1 246'),
(20, 'BY', 'Belarus', '+375'),
(21, 'BE', 'Belgium', '+32'),
(22, 'BZ', 'Belize', '+501'),
(23, 'BJ', 'Benin', '+229'),
(24, 'BM', 'Bermuda', '+1 441'),
(25, 'BT', 'Bhutan', '+975'),
(26, 'BA', 'Bosnia and Herzegovina', '+387'),
(27, 'BW', 'Botswana', '+267'),
(28, 'BR', 'Brazil', '+55'),
(29, 'IO', 'British Indian Ocean Territory', '+246'),
(30, 'BG', 'Bulgaria', '+359'),
(31, 'BF', 'Burkina Faso', '+226'),
(32, 'BI', 'Burundi', '+257'),
(33, 'KH', 'Cambodia', '+855'),
(34, 'CM', 'Cameroon', '+237'),
(35, 'CA', 'Canada', '+1'),
(36, 'CV', 'Cape Verde', '+238'),
(37, 'KY', 'Cayman Islands', '+ 345'),
(38, 'CF', 'Central African Republic', '+236'),
(39, 'TD', 'Chad', '+235'),
(40, 'CL', 'Chile', '+56'),
(41, 'CN', 'China', '+86'),
(42, 'CX', 'Christmas Island', '+61'),
(43, 'CO', 'Colombia', '+57'),
(44, 'KM', 'Comoros', '+269'),
(45, 'CG', 'Congo', '+242'),
(46, 'CK', 'Cook Islands', '+682'),
(47, 'CR', 'Costa Rica', '+506'),
(48, 'HR', 'Croatia', '+385'),
(49, 'CU', 'Cuba', '+53'),
(50, 'CY', 'Cyprus', '+537'),
(51, 'CZ', 'Czech Republic', '+420'),
(52, 'DK', 'Denmark', '+45'),
(53, 'DJ', 'Djibouti', '+253'),
(54, 'DM', 'Dominica', '+1 767'),
(55, 'DO', 'Dominican Republic', '+1 849'),
(56, 'EC', 'Ecuador', '+593'),
(57, 'EG', 'Egypt', '+20'),
(58, 'SV', 'El Salvador', '+503'),
(59, 'GQ', 'Equatorial Guinea', '+240'),
(60, 'ER', 'Eritrea', '+291'),
(61, 'EE', 'Estonia', '+372'),
(62, 'ET', 'Ethiopia', '+251'),
(63, 'FO', 'Faroe Islands', '+298'),
(64, 'FJ', 'Fiji', '+679'),
(65, 'FI', 'Finland', '+358'),
(66, 'FR', 'France', '+33'),
(67, 'GF', 'French Guiana', '+594'),
(68, 'PF', 'French Polynesia', '+689'),
(69, 'GA', 'Gabon', '+241'),
(70, 'GM', 'Gambia', '+220'),
(71, 'GE', 'Georgia', '+995'),
(72, 'DE', 'Germany', '+49'),
(73, 'GH', 'Ghana', '+233'),
(74, 'GI', 'Gibraltar', '+350'),
(75, 'GR', 'Greece', '+30'),
(76, 'GL', 'Greenland', '+299'),
(77, 'GD', 'Grenada', '+1 473'),
(78, 'GP', 'Guadeloupe', '+590'),
(79, 'GU', 'Guam', '+1 671'),
(80, 'GT', 'Guatemala', '+502'),
(81, 'GN', 'Guinea', '+224'),
(82, 'GW', 'Guinea-Bissau', '+245'),
(83, 'GY', 'Guyana', '+595'),
(84, 'HT', 'Haiti', '+509'),
(85, 'HN', 'Honduras', '+504'),
(86, 'HU', 'Hungary', '+36'),
(87, 'IS', 'Iceland', '+354'),
(88, 'IN', 'India', '+91'),
(89, 'ID', 'Indonesia', '+62'),
(90, 'IQ', 'Iraq', '+964'),
(91, 'IE', 'Ireland', '+353'),
(92, 'IL', 'Israel', '+972'),
(93, 'IT', 'Italy', '+39'),
(94, 'JM', 'Jamaica', '+1 876'),
(95, 'JP', 'Japan', '+81'),
(96, 'JO', 'Jordan', '+962'),
(97, 'KZ', 'Kazakhstan', '+7 7'),
(98, 'KE', 'Kenya', '+254'),
(99, 'KI', 'Kiribati', '+686'),
(100, 'KW', 'Kuwait', '+965'),
(101, 'KG', 'Kyrgyzstan', '+996'),
(102, 'LV', 'Latvia', '+371'),
(103, 'LB', 'Lebanon', '+961'),
(104, 'LS', 'Lesotho', '+266'),
(105, 'LR', 'Liberia', '+231'),
(106, 'LI', 'Liechtenstein', '+423'),
(107, 'LT', 'Lithuania', '+370'),
(108, 'LU', 'Luxembourg', '+352'),
(109, 'MG', 'Madagascar', '+261'),
(110, 'MW', 'Malawi', '+265'),
(111, 'MY', 'Malaysia', '+60'),
(112, 'MV', 'Maldives', '+960'),
(113, 'ML', 'Mali', '+223'),
(114, 'MT', 'Malta', '+356'),
(115, 'MH', 'Marshall Islands', '+692'),
(116, 'MQ', 'Martinique', '+596'),
(117, 'MR', 'Mauritania', '+222'),
(118, 'MU', 'Mauritius', '+230'),
(119, 'YT', 'Mayotte', '+262'),
(120, 'MX', 'Mexico', '+52'),
(121, 'MC', 'Monaco', '+377'),
(122, 'MN', 'Mongolia', '+976'),
(123, 'ME', 'Montenegro', '+382'),
(124, 'MS', 'Montserrat', '+1664'),
(125, 'MA', 'Morocco', '+212'),
(126, 'MM', 'Myanmar', '+95'),
(127, 'NA', 'Namibia', '+264'),
(128, 'NR', 'Nauru', '+674'),
(129, 'NP', 'Nepal', '+977'),
(130, 'NL', 'Netherlands', '+31'),
(131, 'AN', 'Netherlands Antilles', '+599'),
(132, 'NC', 'New Caledonia', '+687'),
(133, 'NZ', 'New Zealand', '+64'),
(134, 'NI', 'Nicaragua', '+505'),
(135, 'NE', 'Niger', '+227'),
(136, 'NG', 'Nigeria', '+234'),
(137, 'NU', 'Niue', '+683'),
(138, 'NF', 'Norfolk Island', '+672'),
(139, 'MP', 'Northern Mariana Islands', '+1 670'),
(140, 'NO', 'Norway', '+47'),
(141, 'OM', 'Oman', '+968'),
(142, 'PK', 'Pakistan', '+92'),
(143, 'PW', 'Palau', '+680'),
(144, 'PA', 'Panama', '+507'),
(145, 'PG', 'Papua New Guinea', '+675'),
(146, 'PY', 'Paraguay', '+595'),
(147, 'PE', 'Peru', '+51'),
(148, 'PH', 'Philippines', '+63'),
(149, 'PL', 'Poland', '+48'),
(150, 'PT', 'Portugal', '+351'),
(151, 'PR', 'Puerto Rico', '+1 939'),
(152, 'QA', 'Qatar', '+974'),
(153, 'RO', 'Romania', '+40'),
(154, 'RW', 'Rwanda', '+250'),
(155, 'WS', 'Samoa', '+685'),
(156, 'SM', 'San Marino', '+378'),
(157, 'SA', 'Saudi Arabia', '+966'),
(158, 'SN', 'Senegal', '+221'),
(159, 'RS', 'Serbia', '+381'),
(160, 'SC', 'Seychelles', '+248'),
(161, 'SL', 'Sierra Leone', '+232'),
(162, 'SG', 'Singapore', '+65'),
(163, 'SK', 'Slovakia', '+421'),
(164, 'SI', 'Slovenia', '+386'),
(165, 'SB', 'Solomon Islands', '+677'),
(166, 'ZA', 'South Africa', '+27'),
(167, 'GS', 'South Georgia and the South Sandwich Islands', '+500'),
(168, 'ES', 'Spain', '+34'),
(169, 'LK', 'Sri Lanka', '+94'),
(170, 'SD', 'Sudan', '+249'),
(171, 'SR', 'Suriname', '+597'),
(172, 'SZ', 'Swaziland', '+268'),
(173, 'SE', 'Sweden', '+46'),
(174, 'CH', 'Switzerland', '+41'),
(175, 'TJ', 'Tajikistan', '+992'),
(176, 'TH', 'Thailand', '+66'),
(177, 'TG', 'Togo', '+228'),
(178, 'TK', 'Tokelau', '+690'),
(179, 'TO', 'Tonga', '+676'),
(180, 'TT', 'Trinidad and Tobago', '+1 868'),
(181, 'TN', 'Tunisia', '+216'),
(182, 'TR', 'Turkey', '+90'),
(183, 'TM', 'Turkmenistan', '+993'),
(184, 'TC', 'Turks and Caicos Islands', '+1 649'),
(185, 'TV', 'Tuvalu', '+688'),
(186, 'UG', 'Uganda', '+256'),
(187, 'UA', 'Ukraine', '+380'),
(188, 'AE', 'United Arab Emirates', '+971'),
(189, 'GB', 'United Kingdom', '+44'),
(190, 'US', 'United States', '+1'),
(191, 'UY', 'Uruguay', '+598'),
(192, 'UZ', 'Uzbekistan', '+998'),
(193, 'VU', 'Vanuatu', '+678'),
(194, 'WF', 'Wallis and Futuna', '+681'),
(195, 'YE', 'Yemen', '+967'),
(196, 'ZM', 'Zambia', '+260'),
(197, 'ZW', 'Zimbabwe', '+263'),
(198, 'AX', 'land Islands', ''),
(199, 'BO', 'Bolivia, Plurinational State of', '+591'),
(200, 'BN', 'Brunei Darussalam', '+673'),
(201, 'CC', 'Cocos (Keeling) Islands', '+61'),
(202, 'CD', 'Congo, The Democratic Republic of the', '+243'),
(203, 'CI', 'Cote d\'Ivoire', '+225'),
(204, 'FK', 'Falkland Islands (Malvinas)', '+500'),
(205, 'GG', 'Guernsey', '+44'),
(206, 'VA', 'Holy See (Vatican City State)', '+379'),
(207, 'HK', 'Hong Kong', '+852'),
(208, 'IR', 'Iran, Islamic Republic of', '+98'),
(209, 'IM', 'Isle of Man', '+44'),
(210, 'JE', 'Jersey', '+44'),
(211, 'KP', 'Korea, Democratic People\'s Republic of', '+850'),
(212, 'KR', 'Korea, Republic of', '+82'),
(213, 'LA', 'Lao People\'s Democratic Republic', '+856'),
(214, 'LY', 'Libyan Arab Jamahiriya', '+218'),
(215, 'MO', 'Macao', '+853'),
(216, 'MK', 'Macedonia, The Former Yugoslav Republic of', '+389'),
(217, 'FM', 'Micronesia, Federated States of', '+691'),
(218, 'MD', 'Moldova, Republic of', '+373'),
(219, 'MZ', 'Mozambique', '+258'),
(220, 'PS', 'Palestinian Territory, Occupied', '+970'),
(221, 'PN', 'Pitcairn', '+872'),
(222, 'RE', 'Réunion', '+262'),
(223, 'RU', 'Russia', '+7'),
(224, 'BL', 'Saint Barthélemy', '+590'),
(225, 'SH', 'Saint Helena, Ascension and Tristan Da Cunha', '+290'),
(226, 'KN', 'Saint Kitts and Nevis', '+1 869'),
(227, 'LC', 'Saint Lucia', '+1 758'),
(228, 'MF', 'Saint Martin', '+590'),
(229, 'PM', 'Saint Pierre and Miquelon', '+508'),
(230, 'VC', 'Saint Vincent and the Grenadines', '+1 784'),
(231, 'ST', 'Sao Tome and Principe', '+239'),
(232, 'SO', 'Somalia', '+252'),
(233, 'SJ', 'Svalbard and Jan Mayen', '+47'),
(234, 'SY', 'Syrian Arab Republic', '+963'),
(235, 'TW', 'Taiwan, Province of China', '+886'),
(236, 'TZ', 'Tanzania, United Republic of', '+255'),
(237, 'TL', 'Timor-Leste', '+670'),
(238, 'VE', 'Venezuela, Bolivarian Republic of', '+58'),
(239, 'VN', 'Viet Nam', '+84'),
(240, 'VG', 'Virgin Islands, British', '+1 284'),
(241, 'VI', 'Virgin Islands, U.S.', '+1 340');

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

--
-- Table structure for table `msp_tfa_trusted`
--

CREATE TABLE `msp_tfa_trusted` (
  `msp_tfa_trusted_id` int(10) UNSIGNED NOT NULL COMMENT 'Trusted device ID',
  `date_time` datetime NOT NULL COMMENT 'Date and time',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT 'User ID',
  `device_name` text NOT NULL COMMENT 'Device name',
  `token` text NOT NULL COMMENT 'Token',
  `last_ip` text NOT NULL COMMENT 'Last IP'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_trusted';

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

--
-- Table structure for table `msp_tfa_user_config`
--

CREATE TABLE `msp_tfa_user_config` (
  `msp_tfa_user_config_id` int(10) UNSIGNED NOT NULL COMMENT 'TFA admin user ID',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT 'User ID',
  `encoded_providers` text DEFAULT NULL COMMENT 'Encoded providers list',
  `encoded_config` text DEFAULT NULL COMMENT 'Encoded providers configuration',
  `default_provider` text DEFAULT NULL COMMENT 'Default provider'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_user_config';

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

--
-- Table structure for table `mview_state`
--

CREATE TABLE `mview_state` (
  `state_id` int(10) UNSIGNED NOT NULL COMMENT 'View State ID',
  `view_id` varchar(255) DEFAULT NULL COMMENT 'View ID',
  `mode` varchar(16) DEFAULT 'disabled' COMMENT 'View Mode',
  `status` varchar(16) DEFAULT 'idle' COMMENT 'View Status',
  `updated` datetime DEFAULT NULL COMMENT 'View updated time',
  `version_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'View Version ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='View State';

--
-- Dumping data for table `mview_state`
--

INSERT INTO `mview_state` (`state_id`, `view_id`, `mode`, `status`, `updated`, `version_id`) VALUES
(1, 'scconnector_google_remove', 'enabled', 'idle', '2020-09-16 04:50:09', NULL),
(2, 'scconnector_google_feed', 'enabled', 'idle', '2020-09-16 04:50:13', NULL);

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

--
-- Table structure for table `newsletter_problem`
--

CREATE TABLE `newsletter_problem` (
  `problem_id` int(10) UNSIGNED NOT NULL COMMENT 'Problem ID',
  `subscriber_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Subscriber ID',
  `queue_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Queue ID',
  `problem_error_code` int(10) UNSIGNED DEFAULT 0 COMMENT 'Problem Error Code',
  `problem_error_text` varchar(200) DEFAULT NULL COMMENT 'Problem Error Text'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Problems';

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

--
-- Table structure for table `newsletter_queue`
--

CREATE TABLE `newsletter_queue` (
  `queue_id` int(10) UNSIGNED NOT NULL COMMENT 'Queue ID',
  `template_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Template ID',
  `newsletter_type` int(11) DEFAULT NULL COMMENT 'Newsletter Type',
  `newsletter_text` text DEFAULT NULL COMMENT 'Newsletter Text',
  `newsletter_styles` text DEFAULT NULL COMMENT 'Newsletter Styles',
  `newsletter_subject` varchar(200) DEFAULT NULL COMMENT 'Newsletter Subject',
  `newsletter_sender_name` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Name',
  `newsletter_sender_email` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Email',
  `queue_status` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Queue Status',
  `queue_start_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Start At',
  `queue_finish_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Finish At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue';

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

--
-- Table structure for table `newsletter_queue_link`
--

CREATE TABLE `newsletter_queue_link` (
  `queue_link_id` int(10) UNSIGNED NOT NULL COMMENT 'Queue Link ID',
  `queue_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Queue ID',
  `subscriber_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Subscriber ID',
  `letter_sent_at` timestamp NULL DEFAULT NULL COMMENT 'Letter Sent At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Link';

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

--
-- Table structure for table `newsletter_queue_store_link`
--

CREATE TABLE `newsletter_queue_store_link` (
  `queue_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Queue ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Store Link';

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

--
-- Table structure for table `newsletter_subscriber`
--

CREATE TABLE `newsletter_subscriber` (
  `subscriber_id` int(10) UNSIGNED NOT NULL COMMENT 'Subscriber ID',
  `store_id` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Store ID',
  `change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
  `customer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `subscriber_email` varchar(150) DEFAULT NULL COMMENT 'Subscriber Email',
  `subscriber_status` int(11) NOT NULL DEFAULT 0 COMMENT 'Subscriber Status',
  `subscriber_confirm_code` varchar(32) DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Subscriber';

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

--
-- Table structure for table `newsletter_template`
--

CREATE TABLE `newsletter_template` (
  `template_id` int(10) UNSIGNED NOT NULL COMMENT 'Template ID',
  `template_code` varchar(150) DEFAULT NULL COMMENT 'Template Code',
  `template_text` text DEFAULT NULL COMMENT 'Template Text',
  `template_styles` text DEFAULT NULL COMMENT 'Template Styles',
  `template_type` int(10) UNSIGNED DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint(5) UNSIGNED DEFAULT 1 COMMENT 'Template Actual',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Added At',
  `modified_at` timestamp NULL DEFAULT NULL COMMENT 'Modified At',
  `is_legacy` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should the template render in legacy mode'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Template';

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

--
-- Table structure for table `oauth_consumer`
--

CREATE TABLE `oauth_consumer` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() COMMENT 'Updated At',
  `name` varchar(255) NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) NOT NULL COMMENT 'Key code',
  `secret` varchar(32) NOT NULL COMMENT 'Secret code',
  `callback_url` text DEFAULT NULL COMMENT 'Callback URL',
  `rejected_callback_url` text NOT NULL COMMENT 'Rejected callback URL'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';

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

--
-- Table structure for table `oauth_nonce`
--

CREATE TABLE `oauth_nonce` (
  `nonce` varchar(32) NOT NULL COMMENT 'Nonce String',
  `timestamp` int(10) UNSIGNED NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int(10) UNSIGNED NOT NULL COMMENT 'Consumer ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Nonce';

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

--
-- Table structure for table `oauth_token`
--

CREATE TABLE `oauth_token` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `consumer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Oauth Consumer ID',
  `admin_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Admin user ID',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer user ID',
  `type` varchar(16) NOT NULL COMMENT 'Token Type',
  `token` varchar(32) NOT NULL COMMENT 'Token',
  `secret` varchar(32) NOT NULL COMMENT 'Token Secret',
  `verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
  `callback_url` text NOT NULL COMMENT 'Token Callback URL',
  `revoked` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is Token revoked',
  `authorized` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is Token authorized',
  `user_type` int(11) DEFAULT NULL COMMENT 'User type',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Token creation timestamp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Tokens';

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

--
-- Table structure for table `oauth_token_request_log`
--

CREATE TABLE `oauth_token_request_log` (
  `log_id` int(10) UNSIGNED NOT NULL COMMENT 'Log ID',
  `user_name` varchar(255) NOT NULL COMMENT 'Customer email or admin login',
  `user_type` smallint(5) UNSIGNED NOT NULL COMMENT 'User type (admin or customer)',
  `failures_count` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Number of failed authentication attempts in a row',
  `lock_expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Lock expiration time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of token request authentication failures.';

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

--
-- Table structure for table `password_reset_request_event`
--

CREATE TABLE `password_reset_request_event` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `request_type` smallint(5) UNSIGNED NOT NULL COMMENT 'Type of the event under a security control',
  `account_reference` varchar(255) DEFAULT NULL COMMENT 'An identifier for existing account or another target',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp when the event occurs',
  `ip` varchar(15) NOT NULL COMMENT 'Remote user IP'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Password Reset Request Event under a security control';

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

--
-- Table structure for table `patch_list`
--

CREATE TABLE `patch_list` (
  `patch_id` int(11) NOT NULL COMMENT 'Patch Auto Increment',
  `patch_name` varchar(1024) NOT NULL COMMENT 'Patch Class Name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of data/schema patches';

--
-- Dumping data for table `patch_list`
--

INSERT INTO `patch_list` (`patch_id`, `patch_name`) VALUES
(1, 'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),
(2, 'Magento\\Catalog\\Setup\\Patch\\Schema\\EnableSegmentation'),
(3, 'Magento\\Bundle\\Setup\\Patch\\Schema\\UpdateBundleRelatedSchema'),
(4, 'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\CreateLegacyStockStatusView'),
(5, 'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\InitializeDefaultStock'),
(6, 'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\UpdateInventorySourceItem'),
(7, 'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\ReindexDefaultSource'),
(8, 'Magento\\InventorySales\\Setup\\Patch\\Schema\\InitializeWebsiteDefaultSock'),
(9, 'Temando\\ShippingRemover\\Setup\\Patch\\Schema\\EmptyTablesRemoval'),
(10, 'Magento\\Store\\Setup\\Patch\\Data\\DisableSid'),
(11, 'Magento\\Store\\Setup\\Patch\\Data\\UpdateStoreGroupCodes'),
(12, 'Magento\\Directory\\Setup\\Patch\\Data\\InitializeDirectoryData'),
(13, 'Magento\\Directory\\Setup\\Patch\\Data\\AddCountriesCaribbeanCuracaoKosovoSintMaarten'),
(14, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCroatia'),
(15, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIndia'),
(16, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAustralia'),
(17, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForBelgium'),
(18, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForChina'),
(19, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForColombia'),
(20, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForMexico'),
(21, 'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForPoland'),
(22, 'Magento\\Config\\Setup\\Patch\\Data\\UpdateClassAliases'),
(23, 'Magento\\Theme\\Setup\\Patch\\Data\\RegisterThemes'),
(24, 'Magento\\Theme\\Setup\\Patch\\Data\\ConvertSerializedData'),
(25, 'Magento\\Eav\\Setup\\Patch\\Data\\InitializeAttributeModels'),
(26, 'Magento\\Customer\\Setup\\Patch\\Data\\DefaultCustomerGroupsAndAttributes'),
(27, 'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributesMetadata'),
(28, 'Magento\\Customer\\Setup\\Patch\\Data\\AddNonSpecifiedGenderAttributeOption'),
(29, 'Magento\\Customer\\Setup\\Patch\\Data\\UpdateIdentifierCustomerAttributesVisibility'),
(30, 'Magento\\Customer\\Setup\\Patch\\Data\\AddCustomerUpdatedAtAttribute'),
(31, 'Magento\\Customer\\Setup\\Patch\\Data\\UpgradePasswordHashAndAddress'),
(32, 'Magento\\Customer\\Setup\\Patch\\Data\\RemoveCheckoutRegisterAndUpdateAttributes'),
(33, 'Magento\\Customer\\Setup\\Patch\\Data\\AddSecurityTrackingAttributes'),
(34, 'Magento\\Customer\\Setup\\Patch\\Data\\UpdateAutocompleteOnStorefrontConfigPath'),
(35, 'Magento\\Customer\\Setup\\Patch\\Data\\MigrateStoresAllowedCountriesToWebsite'),
(36, 'Magento\\Customer\\Setup\\Patch\\Data\\ConvertValidationRulesFromSerializedToJson'),
(37, 'Magento\\Customer\\Setup\\Patch\\Data\\UpdateVATNumber'),
(38, 'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributeInputFilters'),
(39, 'Magento\\Indexer\\Setup\\Patch\\Data\\InitializeIndexerState'),
(40, 'Magento\\Authorization\\Setup\\Patch\\Data\\InitializeAuthRoles'),
(41, 'Magento\\Cms\\Setup\\Patch\\Data\\CreateDefaultPages'),
(42, 'Magento\\Cms\\Setup\\Patch\\Data\\UpdatePrivacyPolicyPage'),
(43, 'Magento\\Cms\\Setup\\Patch\\Data\\ConvertWidgetConditionsToJson'),
(44, 'Magento\\Catalog\\Setup\\Patch\\Data\\InstallDefaultCategories'),
(45, 'Magento\\Catalog\\Setup\\Patch\\Data\\SetNewResourceModelsPaths'),
(46, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateDefaultAttributeValue'),
(47, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateMediaAttributesBackendTypes'),
(48, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductAttributes'),
(49, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductMetaDescription'),
(50, 'Magento\\Catalog\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),
(51, 'Magento\\Catalog\\Setup\\Patch\\Data\\DisallowUsingHtmlForProductName'),
(52, 'Magento\\Catalog\\Setup\\Patch\\Data\\EnableDirectiveParsing'),
(53, 'Magento\\Catalog\\Setup\\Patch\\Data\\EnableSegmentation'),
(54, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateCustomLayoutAttributes'),
(55, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWidgetData'),
(56, 'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWebsiteAttributes'),
(57, 'Magento\\Quote\\Setup\\Patch\\Data\\InstallEntityTypes'),
(58, 'Magento\\Quote\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(59, 'Magento\\CatalogInventory\\Setup\\Patch\\Data\\CreateDefaultStock'),
(60, 'Magento\\CatalogInventory\\Setup\\Patch\\Data\\UpdateStockItemsWebsite'),
(61, 'Magento\\CatalogInventory\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(62, 'Magento\\CatalogRule\\Setup\\Patch\\Data\\UpdateClassAliasesForCatalogRules'),
(63, 'Magento\\CatalogRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(64, 'Magento\\Msrp\\Setup\\Patch\\Data\\InitializeMsrpAttributes'),
(65, 'Magento\\Msrp\\Setup\\Patch\\Data\\ChangeMsrpAttributeLabel'),
(66, 'Magento\\Msrp\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),
(67, 'Magento\\CatalogSearch\\Setup\\Patch\\Data\\MySQLSearchDeprecationNotification'),
(68, 'Magento\\CatalogSearch\\Setup\\Patch\\Data\\SetInitialSearchWeightForAttributes'),
(69, 'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\CreateUrlAttributes'),
(70, 'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\UpdateUrlKeySearchable'),
(71, 'Magento\\Widget\\Setup\\Patch\\Data\\UpgradeModelInstanceClassAliases'),
(72, 'Magento\\Widget\\Setup\\Patch\\Data\\ConvertSerializedData'),
(73, 'Magento\\Sales\\Setup\\Patch\\Data\\InstallOrderStatusesAndInitialSalesConfig'),
(74, 'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypes'),
(75, 'Magento\\Sales\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(76, 'Magento\\Sales\\Setup\\Patch\\Data\\FillQuoteAddressIdInSalesOrderAddress'),
(77, 'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypeModelForInvoice'),
(78, 'Magento\\User\\Setup\\Patch\\Data\\UpgradePasswordHashes'),
(79, 'Magento\\User\\Setup\\Patch\\Data\\UpgradeSerializedFields'),
(80, 'Magento\\Checkout\\Setup\\Patch\\Data\\PrepareInitialCheckoutConfiguration'),
(81, 'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\InstallInitialConfigurableAttributes'),
(82, 'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateManufacturerAttribute'),
(83, 'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateTierPriceAttribute'),
(84, 'Magento\\CurrencySymbol\\Setup\\Patch\\Data\\ConvertSerializedCustomCurrencySymbolToJson'),
(85, 'Magento\\Integration\\Setup\\Patch\\Data\\RemoveInactiveTokens'),
(86, 'Magento\\Downloadable\\Setup\\Patch\\Data\\AddDownloadableHostsConfig'),
(87, 'Magento\\Downloadable\\Setup\\Patch\\Data\\InstallDownloadableAttributes'),
(88, 'Magento\\Downloadable\\Setup\\Patch\\Data\\UpdateLinksExistDefaultAttributeValue'),
(89, 'Magento\\Dhl\\Setup\\Patch\\Data\\PrepareShipmentDays'),
(90, 'Magento\\Email\\Setup\\Patch\\Data\\FlagLegacyTemplates'),
(91, 'Magento\\EncryptionKey\\Setup\\Patch\\Data\\SodiumChachaPatch'),
(92, 'Magento\\Fedex\\Setup\\Patch\\Data\\ConfigureFedexDefaults'),
(93, 'Magento\\GiftMessage\\Setup\\Patch\\Data\\AddGiftMessageAttributes'),
(94, 'Magento\\GiftMessage\\Setup\\Patch\\Data\\MoveGiftMessageToGiftOptionsGroup'),
(95, 'Magento\\GiftMessage\\Setup\\Patch\\Data\\UpdateGiftMessageAttribute'),
(96, 'Magento\\GroupedProduct\\Setup\\Patch\\Data\\InitializeGroupedProductLinks'),
(97, 'Magento\\GroupedProduct\\Setup\\Patch\\Data\\UpdateProductRelations'),
(98, 'Magento\\Bundle\\Setup\\Patch\\Data\\ApplyAttributesUpdate'),
(99, 'Magento\\Bundle\\Setup\\Patch\\Data\\UpdateBundleRelatedEntityTypes'),
(100, 'Magento\\Analytics\\Setup\\Patch\\Data\\PrepareInitialConfig'),
(101, 'Magento\\Analytics\\Setup\\Patch\\Data\\ActivateDataCollection'),
(102, 'Magento\\InventoryLowQuantityNotification\\Setup\\Patch\\Data\\MigrateCatalogInventoryNotifyStockQuantityData'),
(103, 'Magento\\Reports\\Setup\\Patch\\Data\\InitializeReportEntityTypesAndPages'),
(104, 'Magento\\Reports\\Setup\\Patch\\Data\\ReportDisableNotification'),
(105, 'Magento\\Newsletter\\Setup\\Patch\\Data\\FlagLegacyTemplates'),
(106, 'Magento\\SalesRule\\Setup\\Patch\\Data\\PrepareRuleModelSerializedData'),
(107, 'Magento\\SalesRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(108, 'Magento\\SalesRule\\Setup\\Patch\\Data\\FillSalesRuleProductAttributeTable'),
(109, 'Magento\\Vault\\Setup\\Patch\\Data\\SetCreditCardAsDefaultTokenType'),
(110, 'Magento\\Paypal\\Setup\\Patch\\Data\\AddPaypalOrderStatuses'),
(111, 'Magento\\Paypal\\Setup\\Patch\\Data\\UpdatePaypalCreditOption'),
(112, 'Magento\\AuthorizenetAcceptjs\\Setup\\Patch\\Data\\CopyCurrentConfig'),
(113, 'Magento\\Review\\Setup\\Patch\\Data\\InitReviewStatusesAndData'),
(114, 'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateQuoteShippingAddresses'),
(115, 'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateShippingTablerate'),
(116, 'Magento\\Braintree\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(117, 'Magento\\UrlRewrite\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),
(118, 'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageAttribute'),
(119, 'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageToDefaultAttribtueSet'),
(120, 'Magento\\Swatches\\Setup\\Patch\\Data\\UpdateAdminTextSwatchValues'),
(121, 'Magento\\Swatches\\Setup\\Patch\\Data\\ConvertAdditionalDataToJson'),
(122, 'Magento\\Tax\\Setup\\Patch\\Data\\AddTaxAttributeAndTaxClasses'),
(123, 'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxClassAttributeVisibility'),
(124, 'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxRegionId'),
(125, 'Magento\\SampleData\\Setup\\Patch\\Data\\ClearSampleDataState'),
(126, 'Magento\\Usps\\Setup\\Patch\\Data\\UpdateAllowedMethods'),
(127, 'Magento\\Weee\\Setup\\Patch\\Data\\InitQuoteAndOrderAttributes'),
(128, 'Magento\\Wishlist\\Setup\\Patch\\Data\\ConvertSerializedData'),
(129, 'Klarna\\Core\\Setup\\Patch\\Data\\UpdateKcoApiPathsInCoreConfig'),
(130, 'Klarna\\Core\\Setup\\Patch\\Data\\UpdateKlarnaApiVersionInCoreConfig'),
(131, 'Klarna\\Kp\\Setup\\Patch\\Data\\RemoveHtmlTag'),
(132, 'Klarna\\Kp\\Setup\\Patch\\Data\\ResetIsActive'),
(133, 'Temando\\ShippingRemover\\Setup\\Patch\\Data\\AttributesRemoval'),
(134, 'Temando\\ShippingRemover\\Setup\\Patch\\Data\\BookmarkCleaner'),
(135, 'Temando\\ShippingRemover\\Setup\\Patch\\Data\\ConfigRemoval');

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

--
-- Table structure for table `paypal_billing_agreement`
--

CREATE TABLE `paypal_billing_agreement` (
  `agreement_id` int(10) UNSIGNED NOT NULL COMMENT 'Agreement ID',
  `customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer ID',
  `method_code` varchar(32) NOT NULL COMMENT 'Method Code',
  `reference_id` varchar(32) NOT NULL COMMENT 'Reference ID',
  `status` varchar(20) NOT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `agreement_label` varchar(255) DEFAULT NULL COMMENT 'Agreement Label'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement';

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

--
-- Table structure for table `paypal_billing_agreement_order`
--

CREATE TABLE `paypal_billing_agreement_order` (
  `agreement_id` int(10) UNSIGNED NOT NULL COMMENT 'Agreement ID',
  `order_id` int(10) UNSIGNED NOT NULL COMMENT 'Order ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement Order';

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

--
-- Table structure for table `paypal_cert`
--

CREATE TABLE `paypal_cert` (
  `cert_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Cert ID',
  `website_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Website ID',
  `content` text DEFAULT NULL COMMENT 'Content',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Certificate Table';

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

--
-- Table structure for table `paypal_payment_transaction`
--

CREATE TABLE `paypal_payment_transaction` (
  `transaction_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn ID',
  `additional_information` blob DEFAULT NULL COMMENT 'Additional Information',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='PayPal Payflow Link Payment Transaction';

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

--
-- Table structure for table `paypal_settlement_report`
--

CREATE TABLE `paypal_settlement_report` (
  `report_id` int(10) UNSIGNED NOT NULL COMMENT 'Report ID',
  `report_date` date DEFAULT NULL COMMENT 'Report Date',
  `account_id` varchar(64) DEFAULT NULL COMMENT 'Account ID',
  `filename` varchar(24) DEFAULT NULL COMMENT 'Filename',
  `last_modified` timestamp NULL DEFAULT NULL COMMENT 'Last Modified'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Table';

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

--
-- Table structure for table `paypal_settlement_report_row`
--

CREATE TABLE `paypal_settlement_report_row` (
  `row_id` int(10) UNSIGNED NOT NULL COMMENT 'Row ID',
  `report_id` int(10) UNSIGNED NOT NULL COMMENT 'Report ID',
  `transaction_id` varchar(19) DEFAULT NULL COMMENT 'Transaction ID',
  `invoice_id` varchar(127) DEFAULT NULL COMMENT 'Invoice ID',
  `paypal_reference_id` varchar(19) DEFAULT NULL COMMENT 'Paypal Reference ID',
  `paypal_reference_id_type` varchar(3) DEFAULT NULL COMMENT 'Paypal Reference ID Type',
  `transaction_event_code` varchar(5) DEFAULT NULL COMMENT 'Transaction Event Code',
  `transaction_initiation_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Initiation Date',
  `transaction_completion_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Completion Date',
  `transaction_debit_or_credit` varchar(2) NOT NULL DEFAULT 'CR' COMMENT 'Transaction Debit Or Credit',
  `gross_transaction_amount` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Gross Transaction Amount',
  `gross_transaction_currency` varchar(3) DEFAULT NULL COMMENT 'Gross Transaction Currency',
  `fee_debit_or_credit` varchar(2) DEFAULT NULL COMMENT 'Fee Debit Or Credit',
  `fee_amount` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Fee Amount',
  `fee_currency` varchar(3) DEFAULT NULL COMMENT 'Fee Currency',
  `custom_field` varchar(255) DEFAULT NULL COMMENT 'Custom Field',
  `consumer_id` varchar(127) DEFAULT NULL COMMENT 'Consumer ID',
  `payment_tracking_id` varchar(255) DEFAULT NULL COMMENT 'Payment Tracking ID',
  `store_id` varchar(50) DEFAULT NULL COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Row Table';

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

--
-- Table structure for table `persistent_session`
--

CREATE TABLE `persistent_session` (
  `persistent_id` int(10) UNSIGNED NOT NULL COMMENT 'Session ID',
  `key` varchar(50) NOT NULL COMMENT 'Unique cookie key',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Website ID',
  `info` text DEFAULT NULL COMMENT 'Session Data',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Persistent Session';

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

--
-- Table structure for table `product_alert_price`
--

CREATE TABLE `product_alert_price` (
  `alert_price_id` int(10) UNSIGNED NOT NULL COMMENT 'Product alert price ID',
  `customer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Price amount',
  `website_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Website ID',
  `store_id` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Store ID',
  `add_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Product alert add date',
  `last_send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert last send date',
  `send_count` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product alert send count',
  `status` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product alert status'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Price';

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

--
-- Table structure for table `product_alert_stock`
--

CREATE TABLE `product_alert_stock` (
  `alert_stock_id` int(10) UNSIGNED NOT NULL COMMENT 'Product alert stock ID',
  `customer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `website_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Website ID',
  `store_id` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Store ID',
  `add_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Product alert add date',
  `send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert send date',
  `send_count` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Send Count',
  `status` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product alert status'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Stock';

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

--
-- Table structure for table `queue`
--

CREATE TABLE `queue` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Queue ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Queue name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table storing unique queues';

--
-- Dumping data for table `queue`
--

INSERT INTO `queue` (`id`, `name`) VALUES
(9, 'async.operations.all'),
(8, 'codegenerator'),
(3, 'export'),
(5, 'inventory.mass.update'),
(6, 'inventory.reservations.cleanup'),
(7, 'inventory.reservations.update'),
(4, 'inventory.source.items.cleanup'),
(1, 'product_action_attribute.update'),
(2, 'product_action_attribute.website.update');

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

--
-- Table structure for table `queue_lock`
--

CREATE TABLE `queue_lock` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Message ID',
  `message_code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Message Code',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Created At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Messages that were processed are inserted here to be locked.';

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

--
-- Table structure for table `queue_message`
--

CREATE TABLE `queue_message` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT 'Message ID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Message topic',
  `body` longtext DEFAULT NULL COMMENT 'Message body'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Queue messages';

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

--
-- Table structure for table `queue_message_status`
--

CREATE TABLE `queue_message_status` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT 'Relation ID',
  `queue_id` int(10) UNSIGNED NOT NULL COMMENT 'Queue ID',
  `message_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Message ID',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `status` smallint(5) UNSIGNED NOT NULL COMMENT 'Message status in particular queue',
  `number_of_trials` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Number of trials to processed failed message processing'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relation table to keep associations between queues and messages';

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

--
-- Table structure for table `queue_poison_pill`
--

CREATE TABLE `queue_poison_pill` (
  `version` varchar(255) NOT NULL COMMENT 'Poison Pill version.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sequence table for poison pill versions';

--
-- Dumping data for table `queue_poison_pill`
--

INSERT INTO `queue_poison_pill` (`version`) VALUES
('version-5f61bddcd4e64');

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

--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `converted_at` timestamp NULL DEFAULT NULL COMMENT 'Converted At',
  `is_active` smallint(5) UNSIGNED DEFAULT 1 COMMENT 'Is Active',
  `is_virtual` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Is Virtual',
  `is_multi_shipping` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Is Multi Shipping',
  `items_count` int(10) UNSIGNED DEFAULT 0 COMMENT 'Items Count',
  `items_qty` decimal(12,4) DEFAULT 0.0000 COMMENT 'Items Qty',
  `orig_order_id` int(10) UNSIGNED DEFAULT 0 COMMENT 'Orig Order ID',
  `store_to_base_rate` decimal(12,4) DEFAULT 0.0000 COMMENT 'Store To Base Rate',
  `store_to_quote_rate` decimal(12,4) DEFAULT 0.0000 COMMENT 'Store To Quote Rate',
  `base_currency_code` varchar(255) DEFAULT NULL COMMENT 'Base Currency Code',
  `store_currency_code` varchar(255) DEFAULT NULL COMMENT 'Store Currency Code',
  `quote_currency_code` varchar(255) DEFAULT NULL COMMENT 'Quote Currency Code',
  `grand_total` decimal(20,4) DEFAULT 0.0000 COMMENT 'Grand Total',
  `base_grand_total` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Grand Total',
  `checkout_method` varchar(255) DEFAULT NULL COMMENT 'Checkout Method',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `customer_tax_class_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer Tax Class ID',
  `customer_group_id` int(10) UNSIGNED DEFAULT 0 COMMENT 'Customer Group ID',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_prefix` varchar(40) DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_firstname` varchar(255) DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_middlename` varchar(40) DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_lastname` varchar(255) DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_suffix` varchar(40) DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `customer_note` varchar(255) DEFAULT NULL COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) UNSIGNED DEFAULT 1 COMMENT 'Customer Note Notify',
  `customer_is_guest` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Customer Is Guest',
  `remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
  `applied_rule_ids` varchar(255) DEFAULT NULL COMMENT 'Applied Rule Ids',
  `reserved_order_id` varchar(64) DEFAULT NULL COMMENT 'Reserved Order ID',
  `password_hash` varchar(255) DEFAULT NULL COMMENT 'Password Hash',
  `coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
  `global_currency_code` varchar(255) DEFAULT NULL COMMENT 'Global Currency Code',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_to_quote_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Quote Rate',
  `customer_taxvat` varchar(255) DEFAULT NULL COMMENT 'Customer Taxvat',
  `customer_gender` varchar(255) DEFAULT NULL COMMENT 'Customer Gender',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `subtotal_with_discount` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal With Discount',
  `base_subtotal_with_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal With Discount',
  `is_changed` int(10) UNSIGNED DEFAULT NULL COMMENT 'Is Changed',
  `trigger_recollect` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Trigger Recollect',
  `ext_shipping_info` text DEFAULT NULL COMMENT 'Ext Shipping Info',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `is_persistent` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Is Quote Persistent'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote';

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

--
-- Table structure for table `quote_address`
--

CREATE TABLE `quote_address` (
  `address_id` int(10) UNSIGNED NOT NULL COMMENT 'Address ID',
  `quote_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quote ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `save_in_address_book` smallint(6) DEFAULT 0 COMMENT 'Save In Address Book',
  `customer_address_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer Address ID',
  `address_type` varchar(10) DEFAULT NULL COMMENT 'Address Type',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Prefix',
  `firstname` varchar(255) DEFAULT NULL,
  `middlename` varchar(40) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `street` varchar(255) DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `region_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Region ID',
  `postcode` varchar(20) DEFAULT NULL COMMENT 'Postcode',
  `country_id` varchar(30) DEFAULT NULL COMMENT 'Country ID',
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `same_as_billing` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Same As Billing',
  `collect_shipping_rates` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Collect Shipping Rates',
  `shipping_method` varchar(120) DEFAULT NULL,
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `weight` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Weight',
  `subtotal` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal',
  `base_subtotal` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Subtotal',
  `subtotal_with_discount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal With Discount',
  `base_subtotal_with_discount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Subtotal With Discount',
  `tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Tax Amount',
  `shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Shipping Amount',
  `base_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Shipping Amount',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `base_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Discount Amount',
  `grand_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Grand Total',
  `base_grand_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Grand Total',
  `customer_notes` text DEFAULT NULL COMMENT 'Customer Notes',
  `applied_taxes` text DEFAULT NULL COMMENT 'Applied Taxes',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
  `base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `base_subtotal_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `vat_id` text DEFAULT NULL COMMENT 'Vat ID',
  `vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text DEFAULT NULL COMMENT 'Vat Request ID',
  `vat_request_date` text DEFAULT NULL COMMENT 'Vat Request Date',
  `vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
  `validated_country_code` text DEFAULT NULL COMMENT 'Validated Country Code',
  `validated_vat_number` text DEFAULT NULL COMMENT 'Validated Vat Number',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Free Shipping'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address';

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

--
-- Table structure for table `quote_address_item`
--

CREATE TABLE `quote_address_item` (
  `address_item_id` int(10) UNSIGNED NOT NULL COMMENT 'Address Item ID',
  `parent_item_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_address_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quote Address ID',
  `quote_item_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quote Item ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `applied_rule_ids` text DEFAULT NULL COMMENT 'Applied Rule Ids',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty',
  `discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Amount',
  `tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Amount',
  `row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Total',
  `base_row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Total',
  `row_total_with_discount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Row Total With Discount',
  `base_discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Amount',
  `base_tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Amount',
  `row_weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Row Weight',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `super_product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Super Product ID',
  `parent_product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Parent Product ID',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text DEFAULT NULL COMMENT 'Description',
  `is_qty_decimal` int(10) UNSIGNED DEFAULT NULL COMMENT 'Is Qty Decimal',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `discount_percent` decimal(12,4) DEFAULT NULL COMMENT 'Discount Percent',
  `no_discount` int(10) UNSIGNED DEFAULT NULL COMMENT 'No Discount',
  `tax_percent` decimal(12,4) DEFAULT NULL COMMENT 'Tax Percent',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` int(10) UNSIGNED DEFAULT NULL COMMENT 'Free Shipping'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address Item';

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

--
-- Table structure for table `quote_id_mask`
--

CREATE TABLE `quote_id_mask` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `quote_id` int(10) UNSIGNED NOT NULL COMMENT 'Quote ID',
  `masked_id` varchar(32) DEFAULT NULL COMMENT 'Masked ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Quote ID and masked ID mapping';

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

--
-- Table structure for table `quote_item`
--

CREATE TABLE `quote_item` (
  `item_id` int(10) UNSIGNED NOT NULL COMMENT 'Item ID',
  `quote_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quote ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `parent_item_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Parent Item ID',
  `is_virtual` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Virtual',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text DEFAULT NULL COMMENT 'Description',
  `applied_rule_ids` text DEFAULT NULL COMMENT 'Applied Rule Ids',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `is_qty_decimal` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'No Discount',
  `weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty',
  `price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Price',
  `custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Custom Price',
  `discount_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Discount Percent',
  `discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Amount',
  `base_discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Amount',
  `tax_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Tax Percent',
  `tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Amount',
  `row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Total',
  `base_row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Total',
  `row_total_with_discount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Row Total With Discount',
  `row_weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Row Weight',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
  `tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
  `original_custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Custom Price',
  `redirect_url` varchar(255) DEFAULT NULL COMMENT 'Redirect Url',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `free_shipping` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Free Shipping',
  `weee_tax_applied` text DEFAULT NULL COMMENT 'Weee Tax Applied',
  `weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
  `weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
  `weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
  `weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
  `base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
  `base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
  `base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
  `base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item';

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

--
-- Table structure for table `quote_item_option`
--

CREATE TABLE `quote_item_option` (
  `option_id` int(10) UNSIGNED NOT NULL COMMENT 'Option ID',
  `item_id` int(10) UNSIGNED NOT NULL COMMENT 'Item ID',
  `product_id` int(10) UNSIGNED NOT NULL COMMENT 'Product ID',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text DEFAULT NULL COMMENT 'Value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item Option';

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

--
-- Table structure for table `quote_payment`
--

CREATE TABLE `quote_payment` (
  `payment_id` int(10) UNSIGNED NOT NULL COMMENT 'Payment ID',
  `quote_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Quote ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `method` varchar(255) DEFAULT NULL COMMENT 'Method',
  `cc_type` varchar(255) DEFAULT NULL COMMENT 'Cc Type',
  `cc_number_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Number Enc',
  `cc_last_4` varchar(255) DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_cid_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Cid Enc',
  `cc_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Owner',
  `cc_exp_month` varchar(255) DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_exp_year` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Cc Exp Year',
  `cc_ss_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Owner',
  `cc_ss_start_month` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Cc Ss Start Month',
  `cc_ss_start_year` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Cc Ss Start Year',
  `po_number` varchar(255) DEFAULT NULL COMMENT 'Po Number',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `cc_ss_issue` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `additional_information` text DEFAULT NULL COMMENT 'Additional Information',
  `paypal_payer_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer ID',
  `paypal_payer_status` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer Status',
  `paypal_correlation_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Correlation ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Payment';

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

--
-- Table structure for table `quote_shipping_rate`
--

CREATE TABLE `quote_shipping_rate` (
  `rate_id` int(10) UNSIGNED NOT NULL COMMENT 'Rate ID',
  `address_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Address ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `carrier` varchar(255) DEFAULT NULL COMMENT 'Carrier',
  `carrier_title` varchar(255) DEFAULT NULL COMMENT 'Carrier Title',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `method` varchar(255) DEFAULT NULL COMMENT 'Method',
  `method_description` text DEFAULT NULL COMMENT 'Method Description',
  `price` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
  `error_message` text DEFAULT NULL COMMENT 'Error Message',
  `method_title` text DEFAULT NULL COMMENT 'Method Title'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Shipping Rate';

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

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `rating_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Rating ID',
  `entity_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `rating_code` varchar(64) NOT NULL COMMENT 'Rating Code',
  `position` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Position On Storefront',
  `is_active` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Rating is active.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ratings';

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` (`rating_id`, `entity_id`, `rating_code`, `position`, `is_active`) VALUES
(1, 1, 'Quality', 0, 1),
(2, 1, 'Value', 0, 1),
(3, 1, 'Price', 0, 1);

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

--
-- Table structure for table `rating_entity`
--

CREATE TABLE `rating_entity` (
  `entity_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `entity_code` varchar(64) NOT NULL COMMENT 'Entity Code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating entities';

--
-- Dumping data for table `rating_entity`
--

INSERT INTO `rating_entity` (`entity_id`, `entity_code`) VALUES
(1, 'product'),
(2, 'product_review'),
(3, 'review');

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

--
-- Table structure for table `rating_option`
--

CREATE TABLE `rating_option` (
  `option_id` int(10) UNSIGNED NOT NULL COMMENT 'Rating Option ID',
  `rating_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating ID',
  `code` varchar(32) NOT NULL COMMENT 'Rating Option Code',
  `value` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Option Value',
  `position` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ration option position on Storefront'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating options';

--
-- Dumping data for table `rating_option`
--

INSERT INTO `rating_option` (`option_id`, `rating_id`, `code`, `value`, `position`) VALUES
(1, 1, '1', 1, 1),
(2, 1, '2', 2, 2),
(3, 1, '3', 3, 3),
(4, 1, '4', 4, 4),
(5, 1, '5', 5, 5),
(6, 2, '1', 1, 1),
(7, 2, '2', 2, 2),
(8, 2, '3', 3, 3),
(9, 2, '4', 4, 4),
(10, 2, '5', 5, 5),
(11, 3, '1', 1, 1),
(12, 3, '2', 2, 2),
(13, 3, '3', 3, 3),
(14, 3, '4', 4, 4),
(15, 3, '5', 5, 5);

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

--
-- Table structure for table `rating_option_vote`
--

CREATE TABLE `rating_option_vote` (
  `vote_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Vote ID',
  `option_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Vote option ID',
  `remote_ip` varchar(16) NOT NULL COMMENT 'Customer IP',
  `remote_ip_long` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Customer IP converted to long integer format',
  `customer_id` int(10) UNSIGNED DEFAULT 0 COMMENT 'Customer ID',
  `entity_pk_value` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `rating_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating ID',
  `review_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Review ID',
  `percent` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Percent amount',
  `value` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Vote option value'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating option values';

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

--
-- Table structure for table `rating_option_vote_aggregated`
--

CREATE TABLE `rating_option_vote_aggregated` (
  `primary_id` int(11) NOT NULL COMMENT 'Vote aggregation ID',
  `rating_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating ID',
  `entity_pk_value` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `vote_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Vote dty',
  `vote_value_sum` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'General vote sum',
  `percent` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Vote percent',
  `percent_approved` smallint(6) DEFAULT 0 COMMENT 'Vote percent approved by admin',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating vote aggregated';

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

--
-- Table structure for table `rating_store`
--

CREATE TABLE `rating_store` (
  `rating_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Store';

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

--
-- Table structure for table `rating_title`
--

CREATE TABLE `rating_title` (
  `rating_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating ID',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `value` varchar(255) NOT NULL COMMENT 'Rating Label'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Title';

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

--
-- Table structure for table `release_notification_viewer_log`
--

CREATE TABLE `release_notification_viewer_log` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Log ID',
  `viewer_id` int(10) UNSIGNED NOT NULL COMMENT 'Viewer admin user ID',
  `last_view_version` varchar(16) NOT NULL COMMENT 'Viewer last view on product version'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Release Notification Viewer Log Table';

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

--
-- Table structure for table `reporting_counts`
--

CREATE TABLE `reporting_counts` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'Item Reported',
  `count` int(10) UNSIGNED DEFAULT NULL COMMENT 'Count Value',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for all count related events generated via the cron job';

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

--
-- Table structure for table `reporting_module_status`
--

CREATE TABLE `reporting_module_status` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Module ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Module Name',
  `active` varchar(255) DEFAULT NULL COMMENT 'Module Active Status',
  `setup_version` varchar(255) DEFAULT NULL COMMENT 'Module Version',
  `state` varchar(255) DEFAULT NULL COMMENT 'Module State',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module Status Table';

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

--
-- Table structure for table `reporting_orders`
--

CREATE TABLE `reporting_orders` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `total` decimal(20,4) UNSIGNED DEFAULT NULL,
  `total_base` decimal(20,4) UNSIGNED DEFAULT NULL,
  `item_count` int(10) UNSIGNED NOT NULL COMMENT 'Line Item Count',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for all orders';

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

--
-- Table structure for table `reporting_system_updates`
--

CREATE TABLE `reporting_system_updates` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'Update Type',
  `action` varchar(255) DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for system updates';

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

--
-- Table structure for table `reporting_users`
--

CREATE TABLE `reporting_users` (
  `entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'User Type',
  `action` varchar(255) DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Updated At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for user actions';

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

--
-- Table structure for table `report_compared_product_index`
--

CREATE TABLE `report_compared_product_index` (
  `index_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Index ID',
  `visitor_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) UNSIGNED NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Added At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Compared Product Index Table';

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

--
-- Table structure for table `report_event`
--

CREATE TABLE `report_event` (
  `event_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Event ID',
  `logged_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Logged At',
  `event_type_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Event Type ID',
  `object_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Object ID',
  `subject_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Subject ID',
  `subtype` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Subtype',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Event Table';

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

--
-- Table structure for table `report_event_types`
--

CREATE TABLE `report_event_types` (
  `event_type_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Event Type ID',
  `event_name` varchar(64) NOT NULL COMMENT 'Event Name',
  `customer_login` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer Login'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Event Type Table';

--
-- Dumping data for table `report_event_types`
--

INSERT INTO `report_event_types` (`event_type_id`, `event_name`, `customer_login`) VALUES
(1, 'catalog_product_view', 0),
(2, 'sendfriend_product', 0),
(3, 'catalog_product_compare_add_product', 0),
(4, 'checkout_cart_add_product', 0),
(5, 'wishlist_add_product', 0),
(6, 'wishlist_share', 0);

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

--
-- Table structure for table `report_viewed_product_aggregated_daily`
--

CREATE TABLE `report_viewed_product_aggregated_daily` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT 0 COMMENT 'Number of Views',
  `rating_pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Pos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Daily';

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

--
-- Table structure for table `report_viewed_product_aggregated_monthly`
--

CREATE TABLE `report_viewed_product_aggregated_monthly` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT 0 COMMENT 'Number of Views',
  `rating_pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Pos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Monthly';

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

--
-- Table structure for table `report_viewed_product_aggregated_yearly`
--

CREATE TABLE `report_viewed_product_aggregated_yearly` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT 0 COMMENT 'Number of Views',
  `rating_pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Pos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Yearly';

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

--
-- Table structure for table `report_viewed_product_index`
--

CREATE TABLE `report_viewed_product_index` (
  `index_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Index ID',
  `visitor_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) UNSIGNED NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Added At'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Viewed Product Index Table';

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

--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `review_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Review ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Review create date',
  `entity_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Entity ID',
  `entity_pk_value` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `status_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review base information';

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

--
-- Table structure for table `review_detail`
--

CREATE TABLE `review_detail` (
  `detail_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Review detail ID',
  `review_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Review ID',
  `store_id` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Store ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `detail` text NOT NULL COMMENT 'Detail description',
  `nickname` varchar(128) NOT NULL COMMENT 'User nickname',
  `customer_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Customer ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review detail information';

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

--
-- Table structure for table `review_entity`
--

CREATE TABLE `review_entity` (
  `entity_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Review entity ID',
  `entity_code` varchar(32) NOT NULL COMMENT 'Review entity code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review entities';

--
-- Dumping data for table `review_entity`
--

INSERT INTO `review_entity` (`entity_id`, `entity_code`) VALUES
(1, 'product'),
(2, 'customer'),
(3, 'category');

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

--
-- Table structure for table `review_entity_summary`
--

CREATE TABLE `review_entity_summary` (
  `primary_id` bigint(20) NOT NULL COMMENT 'Summary review entity ID',
  `entity_pk_value` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `entity_type` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Entity type ID',
  `reviews_count` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Qty of reviews',
  `rating_summary` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Summarized rating',
  `store_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review aggregates';

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

--
-- Table structure for table `review_status`
--

CREATE TABLE `review_status` (
  `status_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Status ID',
  `status_code` varchar(32) NOT NULL COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review statuses';

--
-- Dumping data for table `review_status`
--

INSERT INTO `review_status` (`status_id`, `status_code`) VALUES
(1, 'Approved'),
(2, 'Pending'),
(3, 'Not Approved');

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

--
-- Table structure for table `review_store`
--

CREATE TABLE `review_store` (
  `review_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Review ID',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';

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

--
-- Table structure for table `salesrule`
--

CREATE TABLE `salesrule` (
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text DEFAULT NULL COMMENT 'Description',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `uses_per_customer` int(11) NOT NULL DEFAULT 0 COMMENT 'Uses Per Customer',
  `is_active` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Active',
  `conditions_serialized` mediumtext DEFAULT NULL COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext DEFAULT NULL COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Stop Rules Processing',
  `is_advanced` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Is Advanced',
  `product_ids` text DEFAULT NULL COMMENT 'Product Ids',
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Sort Order',
  `simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
  `discount_step` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Discount Step',
  `apply_to_shipping` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Apply To Shipping',
  `times_used` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Times Used',
  `is_rss` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Rss',
  `coupon_type` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Coupon Type',
  `use_auto_generation` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Use Auto Generation',
  `uses_per_coupon` int(11) NOT NULL DEFAULT 0 COMMENT 'User Per Coupon',
  `simple_free_shipping` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Simple Free Shipping'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule';

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

--
-- Table structure for table `salesrule_coupon`
--

CREATE TABLE `salesrule_coupon` (
  `coupon_id` int(10) UNSIGNED NOT NULL COMMENT 'Coupon ID',
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `usage_limit` int(10) UNSIGNED DEFAULT NULL COMMENT 'Usage Limit',
  `usage_per_customer` int(10) UNSIGNED DEFAULT NULL COMMENT 'Usage Per Customer',
  `times_used` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Times Used',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Expiration Date',
  `is_primary` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Is Primary',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon Code Creation Date',
  `type` smallint(6) DEFAULT 0 COMMENT 'Coupon Code Type',
  `generated_by_dotmailer` smallint(6) DEFAULT NULL COMMENT '1 = Generated by dotmailer'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon';

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

--
-- Table structure for table `salesrule_coupon_aggregated`
--

CREATE TABLE `salesrule_coupon_aggregated` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated';

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

--
-- Table structure for table `salesrule_coupon_aggregated_order`
--

CREATE TABLE `salesrule_coupon_aggregated_order` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated Order';

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

--
-- Table structure for table `salesrule_coupon_aggregated_updated`
--

CREATE TABLE `salesrule_coupon_aggregated_updated` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Aggregated Updated';

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

--
-- Table structure for table `salesrule_coupon_usage`
--

CREATE TABLE `salesrule_coupon_usage` (
  `coupon_id` int(10) UNSIGNED NOT NULL COMMENT 'Coupon ID',
  `customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer ID',
  `times_used` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Times Used'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Usage';

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

--
-- Table structure for table `salesrule_customer`
--

CREATE TABLE `salesrule_customer` (
  `rule_customer_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule Customer ID',
  `rule_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rule ID',
  `customer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `times_used` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Times Used'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Customer';

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

--
-- Table structure for table `salesrule_customer_group`
--

CREATE TABLE `salesrule_customer_group` (
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule ID',
  `customer_group_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer Group ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Customer Groups Relations';

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

--
-- Table structure for table `salesrule_label`
--

CREATE TABLE `salesrule_label` (
  `label_id` int(10) UNSIGNED NOT NULL COMMENT 'Label ID',
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule ID',
  `store_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Store ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Label';

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

--
-- Table structure for table `salesrule_product_attribute`
--

CREATE TABLE `salesrule_product_attribute` (
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Website ID',
  `customer_group_id` int(10) UNSIGNED NOT NULL COMMENT 'Customer Group ID',
  `attribute_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Attribute ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Product Attribute';

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

--
-- Table structure for table `salesrule_website`
--

CREATE TABLE `salesrule_website` (
  `rule_id` int(10) UNSIGNED NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) UNSIGNED NOT NULL COMMENT 'Website ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Websites Relations';

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

--
-- Table structure for table `sales_bestsellers_aggregated_daily`
--

CREATE TABLE `sales_bestsellers_aggregated_daily` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `rating_pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Pos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Daily';

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

--
-- Table structure for table `sales_bestsellers_aggregated_monthly`
--

CREATE TABLE `sales_bestsellers_aggregated_monthly` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Store ID',
  `product_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Product ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Product Price',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `rating_pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Rating Pos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Monthly';

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

--
