Skip to content

Instantly share code, notes, and snippets.

@whoacowboy

whoacowboy/gist:5e8cfda13d333c9b8b1c9665c4a6ad1f

Created June 9, 2024 20:59
Show Gist options
  • Save whoacowboy/5e8cfda13d333c9b8b1c9665c4a6ad1f to your computer and use it in GitHub Desktop.
Save whoacowboy/5e8cfda13d333c9b8b1c9665c4a6ad1f to your computer and use it in GitHub Desktop.
Download ZIP
SO Database Optimization
Raw
gistfile1.txt
# ************************************************************
# Sequel Ace SQL dump
# Version 20062
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Host: 127.0.0.1 (MySQL 8.0.36)
# Database: stackoverflow
# Generation Time: 2024-06-09 20:58:56 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table categories
# ------------------------------------------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `categories_slug_index` (`slug`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` (`id`, `name`, `slug`)
VALUES
(1,'Category 1','category-1'),
(2,'Category 2','category-2'),
(3,'Category 3','category-3'),
(4,'Category 4','category-4'),
(5,'Category 5','category-5'),
(6,'Category 6','category-6'),
(7,'Category 7','category-7'),
(8,'Category 8','category-8'),
(9,'Category 9','category-9'),
(10,'Category 10','category-10'),
(11,'Category 11','category-11'),
(12,'Category 12','category-12'),
(13,'Category 13','category-13'),
(14,'Category 14','category-14'),
(15,'Category 15','category-15');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table customer_product
# ------------------------------------------------------------
DROP TABLE IF EXISTS `customer_product`;
CREATE TABLE `customer_product` (
`id` int NOT NULL AUTO_INCREMENT,
`customer_id` int unsigned NOT NULL,
`product_id` int unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `customer_id` (`customer_id`,`product_id`),
KEY `customer_id_2` (`customer_id`),
KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
LOCK TABLES `customer_product` WRITE;
/*!40000 ALTER TABLE `customer_product` DISABLE KEYS */;
INSERT INTO `customer_product` (`id`, `customer_id`, `product_id`)
VALUES
(1,1,1),
(11,1,11),
(21,1,21),
(31,1,31),
(41,1,41),
(51,1,51),
(61,1,61),
(71,1,71),
(81,1,81),
(91,1,91),
(101,1,101),
(111,1,111),
(121,1,121),
(131,1,131),
(141,1,141),
(151,1,151),
(161,1,161),
(171,1,171),
(181,1,181),
(191,1,191),
(201,1,201),
(211,1,211),
(221,1,221),
(231,1,231),
(241,1,241),
(251,1,251),
(261,1,261),
(271,1,271),
(281,1,281),
(291,1,291),
(2,2,2),
(12,2,12),
(22,2,22),
(32,2,32),
(42,2,42),
(52,2,52),
(62,2,62),
(72,2,72),
(82,2,82),
(92,2,92),
(102,2,102),
(112,2,112),
(122,2,122),
(132,2,132),
(142,2,142),
(152,2,152),
(162,2,162),
(172,2,172),
(182,2,182),
(192,2,192),
(202,2,202),
(212,2,212),
(222,2,222),
(232,2,232),
(242,2,242),
(252,2,252),
(262,2,262),
(272,2,272),
(282,2,282),
(292,2,292),
(3,3,3),
(13,3,13),
(23,3,23),
(33,3,33),
(43,3,43),
(53,3,53),
(63,3,63),
(73,3,73),
(83,3,83),
(93,3,93),
(103,3,103),
(113,3,113),
(123,3,123),
(133,3,133),
(143,3,143),
(153,3,153),
(163,3,163),
(173,3,173),
(183,3,183),
(193,3,193),
(203,3,203),
(213,3,213),
(223,3,223),
(233,3,233),
(243,3,243),
(253,3,253),
(263,3,263),
(273,3,273),
(283,3,283),
(293,3,293),
(4,4,4),
(14,4,14),
(24,4,24),
(34,4,34),
(44,4,44),
(54,4,54),
(64,4,64),
(74,4,74),
(84,4,84),
(94,4,94),
(104,4,104),
(114,4,114),
(124,4,124),
(134,4,134),
(144,4,144),
(154,4,154),
(164,4,164),
(174,4,174),
(184,4,184),
(194,4,194),
(204,4,204),
(214,4,214),
(224,4,224),
(234,4,234),
(244,4,244),
(254,4,254),
(264,4,264),
(274,4,274),
(284,4,284),
(294,4,294),
(5,5,5),
(15,5,15),
(25,5,25),
(35,5,35),
(45,5,45),
(55,5,55),
(65,5,65),
(75,5,75),
(85,5,85),
(95,5,95),
(105,5,105),
(115,5,115),
(125,5,125),
(135,5,135),
(145,5,145),
(155,5,155),
(165,5,165),
(175,5,175),
(185,5,185),
(195,5,195),
(205,5,205),
(215,5,215),
(225,5,225),
(235,5,235),
(245,5,245),
(255,5,255),
(265,5,265),
(275,5,275),
(285,5,285),
(295,5,295),
(6,6,6),
(16,6,16),
(26,6,26),
(36,6,36),
(46,6,46),
(56,6,56),
(66,6,66),
(76,6,76),
(86,6,86),
(96,6,96),
(106,6,106),
(116,6,116),
(126,6,126),
(136,6,136),
(146,6,146),
(156,6,156),
(166,6,166),
(176,6,176),
(186,6,186),
(196,6,196),
(206,6,206),
(216,6,216),
(226,6,226),
(236,6,236),
(246,6,246),
(256,6,256),
(266,6,266),
(276,6,276),
(286,6,286),
(296,6,296),
(7,7,7),
(17,7,17),
(27,7,27),
(37,7,37),
(47,7,47),
(57,7,57),
(67,7,67),
(77,7,77),
(87,7,87),
(97,7,97),
(107,7,107),
(117,7,117),
(127,7,127),
(137,7,137),
(147,7,147),
(157,7,157),
(167,7,167),
(177,7,177),
(187,7,187),
(197,7,197),
(207,7,207),
(217,7,217),
(227,7,227),
(237,7,237),
(247,7,247),
(257,7,257),
(267,7,267),
(277,7,277),
(287,7,287),
(297,7,297),
(8,8,8),
(18,8,18),
(28,8,28),
(38,8,38),
(48,8,48),
(58,8,58),
(68,8,68),
(78,8,78),
(88,8,88),
(98,8,98),
(108,8,108),
(118,8,118),
(128,8,128),
(138,8,138),
(148,8,148),
(158,8,158),
(168,8,168),
(178,8,178),
(188,8,188),
(198,8,198),
(208,8,208),
(218,8,218),
(228,8,228),
(238,8,238),
(248,8,248),
(258,8,258),
(268,8,268),
(278,8,278),
(288,8,288),
(298,8,298),
(9,9,9),
(19,9,19),
(29,9,29),
(39,9,39),
(49,9,49),
(59,9,59),
(69,9,69),
(79,9,79),
(89,9,89),
(99,9,99),
(109,9,109),
(119,9,119),
(129,9,129),
(139,9,139),
(149,9,149),
(159,9,159),
(169,9,169),
(179,9,179),
(189,9,189),
(199,9,199),
(209,9,209),
(219,9,219),
(229,9,229),
(239,9,239),
(249,9,249),
(259,9,259),
(269,9,269),
(279,9,279),
(289,9,289),
(299,9,299),
(10,10,10),
(20,10,20),
(30,10,30),
(40,10,40),
(50,10,50),
(60,10,60),
(70,10,70),
(80,10,80),
(90,10,90),
(100,10,100),
(110,10,110),
(120,10,120),
(130,10,130),
(140,10,140),
(150,10,150),
(160,10,160),
(170,10,170),
(180,10,180),
(190,10,190),
(200,10,200),
(210,10,210),
(220,10,220),
(230,10,230),
(240,10,240),
(250,10,250),
(260,10,260),
(270,10,270),
(280,10,280),
(290,10,290),
(300,10,300);
/*!40000 ALTER TABLE `customer_product` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table customers
# ------------------------------------------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`order` int DEFAULT '0',
`type_id` int DEFAULT '1',
`uuid` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` (`id`, `name`, `order`, `type_id`, `uuid`)
VALUES
(1,'Customer 1',1,1,'ca259f51-cff5-32d0-9bd9-358d9b153512'),
(2,'Customer 2',2,1,'5fe35d36-3a65-378d-87b1-5b6ea20a09f7'),
(3,'Customer 3',3,4,'27fbef24-79c4-3f6d-b490-bd6987d7a22f'),
(4,'Customer 4',4,3,'5186bcdc-96f6-31b8-8c32-d36fa6549e28'),
(5,'Customer 5',5,4,'13e8a920-46b5-391a-ac9f-2d8246763279'),
(6,'Customer 6',6,1,'10165612-e736-3128-bd10-24b9462f377d'),
(7,'Customer 7',7,1,'d66a9950-95a5-3c8c-9ca9-0248bcfb7f42'),
(8,'Customer 8',8,3,'ed321fa1-1947-37b8-baf4-f7375ab81bec'),
(9,'Customer 9',9,1,'4a191bbd-e809-3b5c-b045-31e0d2ab7bf0'),
(10,'Customer 10',10,2,'9a88c9e8-efb4-360c-9ce7-e1e78651973d');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table product_categories
# ------------------------------------------------------------
DROP TABLE IF EXISTS `product_categories`;
CREATE TABLE `product_categories` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`product_id` int unsigned NOT NULL,
`category_id` int unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `product_id_index` (`product_id`),
KEY `category_id_index` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
LOCK TABLES `product_categories` WRITE;
/*!40000 ALTER TABLE `product_categories` DISABLE KEYS */;
INSERT INTO `product_categories` (`id`, `product_id`, `category_id`)
VALUES
(1,1,1),
(2,1,3),
(3,1,4),
(4,1,5),
(5,1,7),
(6,1,11),
(7,2,0),
(8,2,1),
(9,2,3),
(10,2,4),
(11,2,8),
(12,2,11),
(13,3,0),
(14,3,1),
(15,3,3),
(16,3,7),
(17,3,8),
(18,3,10),
(19,4,0),
(20,4,1),
(21,4,5),
(22,4,6),
(23,4,8),
(24,4,11),
(25,5,1),
(26,5,3),
(27,5,4),
(28,5,5),
(29,5,7),
(30,5,11),
(31,6,0),
(32,6,1),
(33,6,6),
(34,6,7),
(35,6,8),
(36,6,11),
(37,7,0),
(38,7,2),
(39,7,3),
(40,7,4),
(41,7,5),
(42,7,10),
(43,8,0),
(44,8,1),
(45,8,2),
(46,8,4),
(47,8,7),
(48,8,10),
(49,9,0),
(50,9,4),
(51,9,5),
(52,9,7),
(53,9,8),
(54,9,10),
(55,10,0),
(56,10,2),
(57,10,3),
(58,10,4),
(59,10,8),
(60,10,11),
(61,11,0),
(62,11,3),
(63,11,4),
(64,11,6),
(65,11,8),
(66,11,11),
(67,12,0),
(68,12,5),
(69,12,6),
(70,12,7),
(71,12,8),
(72,12,11),
(73,13,1),
(74,13,2),
(75,13,3),
(76,13,4),
(77,13,7),
(78,13,11),
(79,14,1),
(80,14,2),
(81,14,3),
(82,14,5),
(83,14,8),
(84,14,11),
(85,15,2),
(86,15,3),
(87,15,4),
(88,15,5),
(89,15,6),
(90,15,10),
(91,16,0),
(92,16,2),
(93,16,3),
(94,16,5),
(95,16,6),
(96,16,10),
(97,17,0),
(98,17,3),
(99,17,5),
(100,17,7),
(101,17,8),
(102,17,10),
(103,18,0),
(104,18,2),
(105,18,3),
(106,18,4),
(107,18,8),
(108,18,10),
(109,19,2),
(110,19,4),
(111,19,5),
(112,19,6),
(113,19,8),
(114,19,11),
(115,20,0),
(116,20,1),
(117,20,4),
(118,20,6),
(119,20,8),
(120,20,11),
(121,21,0),
(122,21,3),
(123,21,5),
(124,21,6),
(125,21,8),
(126,21,11),
(127,22,0),
(128,22,1),
(129,22,3),
(130,22,4),
(131,22,8),
(132,22,11),
(133,23,1),
(134,23,2),
(135,23,5),
(136,23,6),
(137,23,7),
(138,23,10),
(139,24,0),
(140,24,2),
(141,24,3),
(142,24,5),
(143,24,8),
(144,24,11),
(145,25,0),
(146,25,1),
(147,25,4),
(148,25,5),
(149,25,8),
(150,25,11),
(151,26,0),
(152,26,2),
(153,26,4),
(154,26,7),
(155,26,8),
(156,26,10),
(157,27,0),
(158,27,2),
(159,27,5),
(160,27,6),
(161,27,8),
(162,27,11),
(163,28,0),
(164,28,2),
(165,28,4),
(166,28,5),
(167,28,7),
(168,28,10),
(169,29,0),
(170,29,1),
(171,29,3),
(172,29,6),
(173,29,7),
(174,29,11),
(175,30,0),
(176,30,3),
(177,30,4),
(178,30,5),
(179,30,6),
(180,30,11),
(181,31,0),
(182,31,1),
(183,31,4),
(184,31,6),
(185,31,7),
(186,31,10),
(187,32,1),
(188,32,2),
(189,32,4),
(190,32,5),
(191,32,8),
(192,32,11),
(193,33,0),
(194,33,1),
(195,33,3),
(196,33,4),
(197,33,6),
(198,33,10),
(199,34,1),
(200,34,2),
(201,34,5),
(202,34,6),
(203,34,8),
(204,34,11),
(205,35,0),
(206,35,1),
(207,35,2),
(208,35,6),
(209,35,8),
(210,35,11),
(211,36,0),
(212,36,2),
(213,36,5),
(214,36,6),
(215,36,8),
(216,36,11),
(217,37,0),
(218,37,1),
(219,37,3),
(220,37,4),
(221,37,8),
(222,37,10),
(223,38,0),
(224,38,1),
(225,38,4),
(226,38,6),
(227,38,7),
(228,38,11),
(229,39,1),
(230,39,2),
(231,39,3),
(232,39,4),
(233,39,7),
(234,39,10),
(235,40,1),
(236,40,2),
(237,40,3),
(238,40,5),
(239,40,8),
(240,40,11),
(241,41,0),
(242,41,1),
(243,41,2),
(244,41,3),
(245,41,6),
(246,41,10),
(247,42,1),
(248,42,4),
(249,42,6),
(250,42,7),
(251,42,8),
(252,42,10),
(253,43,0),
(254,43,1),
(255,43,3),
(256,43,4),
(257,43,7),
(258,43,11),
(259,44,0),
(260,44,1),
(261,44,5),
(262,44,6),
(263,44,8),
(264,44,11),
(265,45,1),
(266,45,5),
(267,45,6),
(268,45,7),
(269,45,8),
(270,45,11),
(271,46,0),
(272,46,3),
(273,46,4),
(274,46,6),
(275,46,7),
(276,46,11),
(277,47,0),
(278,47,2),
(279,47,4),
(280,47,7),
(281,47,8),
(282,47,11),
(283,48,0),
(284,48,3),
(285,48,5),
(286,48,6),
(287,48,7),
(288,48,10),
(289,49,0),
(290,49,3),
(291,49,4),
(292,49,6),
(293,49,7),
(294,49,10),
(295,50,1),
(296,50,2),
(297,50,5),
(298,50,6),
(299,50,7),
(300,50,10),
(301,51,1),
(302,51,3),
(303,51,4),
(304,51,5),
(305,51,6),
(306,51,10),
(307,52,1),
(308,52,4),
(309,52,6),
(310,52,7),
(311,52,8),
(312,52,10),
(313,53,1),
(314,53,3),
(315,53,4),
(316,53,6),
(317,53,8),
(318,53,10),
(319,54,0),
(320,54,2),
(321,54,4),
(322,54,6),
(323,54,7),
(324,54,10),
(325,55,0),
(326,55,2),
(327,55,5),
(328,55,6),
(329,55,8),
(330,55,11),
(331,56,1),
(332,56,2),
(333,56,3),
(334,56,4),
(335,56,5),
(336,56,10),
(337,57,1),
(338,57,3),
(339,57,4),
(340,57,5),
(341,57,8),
(342,57,10),
(343,58,1),
(344,58,2),
(345,58,3),
(346,58,4),
(347,58,7),
(348,58,11),
(349,59,0),
(350,59,1),
(351,59,2),
(352,59,6),
(353,59,7),
(354,59,10),
(355,60,0),
(356,60,4),
(357,60,6),
(358,60,7),
(359,60,8),
(360,60,11),
(361,61,0),
(362,61,2),
(363,61,3),
(364,61,4),
(365,61,7),
(366,61,11),
(367,62,4),
(368,62,5),
(369,62,6),
(370,62,7),
(371,62,8),
(372,62,10),
(373,63,1),
(374,63,2),
(375,63,4),
(376,63,5),
(377,63,7),
(378,63,11),
(379,64,1),
(380,64,2),
(381,64,6),
(382,64,7),
(383,64,8),
(384,64,11),
(385,65,1),
(386,65,2),
(387,65,4),
(388,65,7),
(389,65,8),
(390,65,10),
(391,66,0),
(392,66,2),
(393,66,3),
(394,66,7),
(395,66,8),
(396,66,10),
(397,67,0),
(398,67,2),
(399,67,5),
(400,67,6),
(401,67,8),
(402,67,10),
(403,68,1),
(404,68,2),
(405,68,4),
(406,68,6),
(407,68,7),
(408,68,10),
(409,69,2),
(410,69,3),
(411,69,4),
(412,69,6),
(413,69,8),
(414,69,10),
(415,70,0),
(416,70,3),
(417,70,4),
(418,70,6),
(419,70,7),
(420,70,11),
(421,71,0),
(422,71,1),
(423,71,2),
(424,71,5),
(425,71,6),
(426,71,11),
(427,72,2),
(428,72,4),
(429,72,5),
(430,72,6),
(431,72,8),
(432,72,10),
(433,73,2),
(434,73,4),
(435,73,6),
(436,73,7),
(437,73,8),
(438,73,11),
(439,74,0),
(440,74,1),
(441,74,3),
(442,74,5),
(443,74,8),
(444,74,10),
(445,75,0),
(446,75,2),
(447,75,3),
(448,75,5),
(449,75,8),
(450,75,10),
(451,76,0),
(452,76,2),
(453,76,4),
(454,76,5),
(455,76,6),
(456,76,11),
(457,77,2),
(458,77,3),
(459,77,4),
(460,77,6),
(461,77,7),
(462,77,11),
(463,78,0),
(464,78,1),
(465,78,3),
(466,78,5),
(467,78,6),
(468,78,11),
(469,79,0),
(470,79,1),
(471,79,2),
(472,79,5),
(473,79,7),
(474,79,11),
(475,80,0),
(476,80,2),
(477,80,6),
(478,80,7),
(479,80,8),
(480,80,10),
(481,81,0),
(482,81,2),
(483,81,3),
(484,81,4),
(485,81,7),
(486,81,10),
(487,82,0),
(488,82,1),
(489,82,3),
(490,82,6),
(491,82,7),
(492,82,11),
(493,83,0),
(494,83,2),
(495,83,3),
(496,83,4),
(497,83,5),
(498,83,10),
(499,84,0),
(500,84,2),
(501,84,3),
(502,84,6),
(503,84,8),
(504,84,10),
(505,85,1),
(506,85,3),
(507,85,4),
(508,85,6),
(509,85,8),
(510,85,10),
(511,86,0),
(512,86,1),
(513,86,2),
(514,86,4),
(515,86,8),
(516,86,10),
(517,87,0),
(518,87,3),
(519,87,4),
(520,87,7),
(521,87,8),
(522,87,11),
(523,88,0),
(524,88,4),
(525,88,5),
(526,88,6),
(527,88,8),
(528,88,11),
(529,89,0),
(530,89,2),
(531,89,5),
(532,89,6),
(533,89,8),
(534,89,11),
(535,90,0),
(536,90,1),
(537,90,2),
(538,90,6),
(539,90,8),
(540,90,11),
(541,91,1),
(542,91,3),
(543,91,5),
(544,91,6),
(545,91,7),
(546,91,11),
(547,92,0),
(548,92,1),
(549,92,4),
(550,92,5),
(551,92,6),
(552,92,11),
(553,93,0),
(554,93,4),
(555,93,6),
(556,93,7),
(557,93,8),
(558,93,10),
(559,94,0),
(560,94,1),
(561,94,5),
(562,94,6),
(563,94,8),
(564,94,10),
(565,95,2),
(566,95,3),
(567,95,6),
(568,95,7),
(569,95,8),
(570,95,10),
(571,96,0),
(572,96,2),
(573,96,3),
(574,96,4),
(575,96,8),
(576,96,10),
(577,97,2),
(578,97,4),
(579,97,6),
(580,97,7),
(581,97,8),
(582,97,11),
(583,98,2),
(584,98,3),
(585,98,5),
(586,98,7),
(587,98,8),
(588,98,11),
(589,99,0),
(590,99,1),
(591,99,2),
(592,99,5),
(593,99,7),
(594,99,10),
(595,100,0),
(596,100,2),
(597,100,4),
(598,100,6),
(599,100,7),
(600,100,11),
(601,101,1),
(602,101,3),
(603,101,5),
(604,101,6),
(605,101,7),
(606,101,10),
(607,102,0),
(608,102,1),
(609,102,2),
(610,102,4),
(611,102,8),
(612,102,10),
(613,103,2),
(614,103,4),
(615,103,5),
(616,103,6),
(617,103,7),
(618,103,10),
(619,104,0),
(620,104,1),
(621,104,5),
(622,104,6),
(623,104,8),
(624,104,10),
(625,105,0),
(626,105,2),
(627,105,3),
(628,105,5),
(629,105,6),
(630,105,11),
(631,106,0),
(632,106,1),
(633,106,3),
(634,106,4),
(635,106,7),
(636,106,11),
(637,107,0),
(638,107,1),
(639,107,5),
(640,107,7),
(641,107,8),
(642,107,11),
(643,108,0),
(644,108,2),
(645,108,4),
(646,108,5),
(647,108,6),
(648,108,10),
(649,109,1),
(650,109,2),
(651,109,4),
(652,109,5),
(653,109,8),
(654,109,11),
(655,110,1),
(656,110,3),
(657,110,5),
(658,110,7),
(659,110,8),
(660,110,11),
(661,111,2),
(662,111,3),
(663,111,4),
(664,111,7),
(665,111,8),
(666,111,10),
(667,112,0),
(668,112,3),
(669,112,4),
(670,112,6),
(671,112,8),
(672,112,10),
(673,113,1),
(674,113,3),
(675,113,4),
(676,113,5),
(677,113,8),
(678,113,10),
(679,114,0),
(680,114,1),
(681,114,2),
(682,114,6),
(683,114,8),
(684,114,10),
(685,115,0),
(686,115,3),
(687,115,4),
(688,115,5),
(689,115,8),
(690,115,11),
(691,116,2),
(692,116,5),
(693,116,6),
(694,116,7),
(695,116,8),
(696,116,10),
(697,117,2),
(698,117,3),
(699,117,4),
(700,117,7),
(701,117,8),
(702,117,11),
(703,118,1),
(704,118,3),
(705,118,4),
(706,118,6),
(707,118,8),
(708,118,11),
(709,119,1),
(710,119,3),
(711,119,4),
(712,119,6),
(713,119,8),
(714,119,11),
(715,120,1),
(716,120,2),
(717,120,5),
(718,120,7),
(719,120,8),
(720,120,11),
(721,121,1),
(722,121,3),
(723,121,5),
(724,121,6),
(725,121,8),
(726,121,11),
(727,122,1),
(728,122,3),
(729,122,5),
(730,122,6),
(731,122,7),
(732,122,11),
(733,123,1),
(734,123,3),
(735,123,4),
(736,123,5),
(737,123,6),
(738,123,10),
(739,124,1),
(740,124,2),
(741,124,4),
(742,124,6),
(743,124,8),
(744,124,10),
(745,125,0),
(746,125,4),
(747,125,5),
(748,125,6),
(749,125,8),
(750,125,11),
(751,126,1),
(752,126,4),
(753,126,6),
(754,126,7),
(755,126,8),
(756,126,10),
(757,127,0),
(758,127,1),
(759,127,3),
(760,127,7),
(761,127,8),
(762,127,11),
(763,128,1),
(764,128,2),
(765,128,4),
(766,128,6),
(767,128,8),
(768,128,11),
(769,129,3),
(770,129,4),
(771,129,5),
(772,129,6),
(773,129,8),
(774,129,11),
(775,130,1),
(776,130,3),
(777,130,4),
(778,130,5),
(779,130,6),
(780,130,10),
(781,131,0),
(782,131,1),
(783,131,4),
(784,131,5),
(785,131,6),
(786,131,11),
(787,132,0),
(788,132,2),
(789,132,3),
(790,132,5),
(791,132,8),
(792,132,11),
(793,133,0),
(794,133,1),
(795,133,2),
(796,133,3),
(797,133,6),
(798,133,10),
(799,134,1),
(800,134,2),
(801,134,3),
(802,134,4),
(803,134,8),
(804,134,11),
(805,135,0),
(806,135,2),
(807,135,3),
(808,135,4),
(809,135,7),
(810,135,11),
(811,136,1),
(812,136,2),
(813,136,3),
(814,136,5),
(815,136,6),
(816,136,10),
(817,137,0),
(818,137,1),
(819,137,2),
(820,137,5),
(821,137,7),
(822,137,10),
(823,138,0),
(824,138,3),
(825,138,5),
(826,138,6),
(827,138,7),
(828,138,11),
(829,139,0),
(830,139,4),
(831,139,6),
(832,139,7),
(833,139,8),
(834,139,11),
(835,140,2),
(836,140,4),
(837,140,6),
(838,140,7),
(839,140,8),
(840,140,10),
(841,141,2),
(842,141,3),
(843,141,4),
(844,141,7),
(845,141,8),
(846,141,10),
(847,142,2),
(848,142,3),
(849,142,4),
(850,142,7),
(851,142,8),
(852,142,11),
(853,143,0),
(854,143,1),
(855,143,3),
(856,143,7),
(857,143,8),
(858,143,11),
(859,144,1),
(860,144,5),
(861,144,6),
(862,144,7),
(863,144,8),
(864,144,10),
(865,145,1),
(866,145,2),
(867,145,3),
(868,145,4),
(869,145,6),
(870,145,10),
(871,146,0),
(872,146,2),
(873,146,3),
(874,146,4),
(875,146,8),
(876,146,11),
(877,147,0),
(878,147,1),
(879,147,4),
(880,147,6),
(881,147,8),
(882,147,10),
(883,148,0),
(884,148,1),
(885,148,4),
(886,148,5),
(887,148,7),
(888,148,11),
(889,149,2),
(890,149,3),
(891,149,4),
(892,149,7),
(893,149,8),
(894,149,10),
(895,150,1),
(896,150,4),
(897,150,5),
(898,150,6),
(899,150,8),
(900,150,10),
(901,151,0),
(902,151,1),
(903,151,3),
(904,151,7),
(905,151,8),
(906,151,10),
(907,152,0),
(908,152,1),
(909,152,2),
(910,152,7),
(911,152,8),
(912,152,11),
(913,153,0),
(914,153,2),
(915,153,5),
(916,153,6),
(917,153,7),
(918,153,11),
(919,154,1),
(920,154,3),
(921,154,5),
(922,154,6),
(923,154,8),
(924,154,10),
(925,155,0),
(926,155,2),
(927,155,4),
(928,155,5),
(929,155,6),
(930,155,10),
(931,156,1),
(932,156,2),
(933,156,3),
(934,156,4),
(935,156,7),
(936,156,10),
(937,157,0),
(938,157,4),
(939,157,6),
(940,157,7),
(941,157,8),
(942,157,10),
(943,158,0),
(944,158,2),
(945,158,3),
(946,158,6),
(947,158,7),
(948,158,11),
(949,159,0),
(950,159,1),
(951,159,5),
(952,159,6),
(953,159,8),
(954,159,11),
(955,160,0),
(956,160,1),
(957,160,2),
(958,160,5),
(959,160,8),
(960,160,11),
(961,161,2),
(962,161,3),
(963,161,4),
(964,161,5),
(965,161,6),
(966,161,11),
(967,162,0),
(968,162,3),
(969,162,5),
(970,162,7),
(971,162,8),
(972,162,10),
(973,163,1),
(974,163,2),
(975,163,3),
(976,163,4),
(977,163,5),
(978,163,11),
(979,164,3),
(980,164,4),
(981,164,5),
(982,164,7),
(983,164,8),
(984,164,11),
(985,165,0),
(986,165,2),
(987,165,3),
(988,165,4),
(989,165,5),
(990,165,11),
(991,166,2),
(992,166,3),
(993,166,4),
(994,166,5),
(995,166,8),
(996,166,11),
(997,167,1),
(998,167,3),
(999,167,4),
(1000,167,5),
(1001,167,6),
(1002,167,11),
(1003,168,0),
(1004,168,1),
(1005,168,2),
(1006,168,4),
(1007,168,6),
(1008,168,10),
(1009,169,0),
(1010,169,3),
(1011,169,4),
(1012,169,7),
(1013,169,8),
(1014,169,10),
(1015,170,0),
(1016,170,1),
(1017,170,2),
(1018,170,5),
(1019,170,7),
(1020,170,11),
(1021,171,0),
(1022,171,5),
(1023,171,6),
(1024,171,7),
(1025,171,8),
(1026,171,11),
(1027,172,0),
(1028,172,1),
(1029,172,3),
(1030,172,5),
(1031,172,6),
(1032,172,11),
(1033,173,0),
(1034,173,3),
(1035,173,4),
(1036,173,6),
(1037,173,8),
(1038,173,10),
(1039,174,1),
(1040,174,3),
(1041,174,6),
(1042,174,7),
(1043,174,8),
(1044,174,10),
(1045,175,1),
(1046,175,2),
(1047,175,5),
(1048,175,6),
(1049,175,7),
(1050,175,11),
(1051,176,0),
(1052,176,1),
(1053,176,2),
(1054,176,6),
(1055,176,7),
(1056,176,10),
(1057,177,0),
(1058,177,1),
(1059,177,4),
(1060,177,7),
(1061,177,8),
(1062,177,10),
(1063,178,0),
(1064,178,1),
(1065,178,2),
(1066,178,5),
(1067,178,8),
(1068,178,10),
(1069,179,0),
(1070,179,3),
(1071,179,4),
(1072,179,5),
(1073,179,8),
(1074,179,10),
(1075,180,1),
(1076,180,2),
(1077,180,3),
(1078,180,4),
(1079,180,6),
(1080,180,11),
(1081,181,0),
(1082,181,1),
(1083,181,2),
(1084,181,3),
(1085,181,8),
(1086,181,10),
(1087,182,4),
(1088,182,5),
(1089,182,6),
(1090,182,7),
(1091,182,8),
(1092,182,10),
(1093,183,1),
(1094,183,3),
(1095,183,5),
(1096,183,7),
(1097,183,8),
(1098,183,11),
(1099,184,1),
(1100,184,2),
(1101,184,3),
(1102,184,5),
(1103,184,6),
(1104,184,10),
(1105,185,0),
(1106,185,2),
(1107,185,4),
(1108,185,6),
(1109,185,8),
(1110,185,11),
(1111,186,1),
(1112,186,4),
(1113,186,5),
(1114,186,7),
(1115,186,8),
(1116,186,11),
(1117,187,0),
(1118,187,2),
(1119,187,6),
(1120,187,7),
(1121,187,8),
(1122,187,11),
(1123,188,0),
(1124,188,4),
(1125,188,5),
(1126,188,6),
(1127,188,7),
(1128,188,11),
(1129,189,0),
(1130,189,1),
(1131,189,2),
(1132,189,3),
(1133,189,6),
(1134,189,10),
(1135,190,1),
(1136,190,3),
(1137,190,4),
(1138,190,5),
(1139,190,6),
(1140,190,10),
(1141,191,0),
(1142,191,1),
(1143,191,4),
(1144,191,6),
(1145,191,7),
(1146,191,10),
(1147,192,0),
(1148,192,3),
(1149,192,4),
(1150,192,5),
(1151,192,6),
(1152,192,10),
(1153,193,1),
(1154,193,2),
(1155,193,5),
(1156,193,7),
(1157,193,8),
(1158,193,11),
(1159,194,2),
(1160,194,3),
(1161,194,5),
(1162,194,6),
(1163,194,7),
(1164,194,10),
(1165,195,0),
(1166,195,2),
(1167,195,3),
(1168,195,6),
(1169,195,8),
(1170,195,10),
(1171,196,1),
(1172,196,2),
(1173,196,4),
(1174,196,7),
(1175,196,8),
(1176,196,11),
(1177,197,0),
(1178,197,1),
(1179,197,2),
(1180,197,6),
(1181,197,8),
(1182,197,10),
(1183,198,0),
(1184,198,1),
(1185,198,2),
(1186,198,3),
(1187,198,7),
(1188,198,10),
(1189,199,1),
(1190,199,2),
(1191,199,3),
(1192,199,4),
(1193,199,8),
(1194,199,11),
(1195,200,0),
(1196,200,1),
(1197,200,2),
(1198,200,4),
(1199,200,7),
(1200,200,10),
(1201,201,1),
(1202,201,5),
(1203,201,6),
(1204,201,7),
(1205,201,8),
(1206,201,10),
(1207,202,1),
(1208,202,2),
(1209,202,5),
(1210,202,6),
(1211,202,8),
(1212,202,11),
(1213,203,3),
(1214,203,5),
(1215,203,6),
(1216,203,7),
(1217,203,8),
(1218,203,11),
(1219,204,0),
(1220,204,1),
(1221,204,2),
(1222,204,3),
(1223,204,5),
(1224,204,11),
(1225,205,0),
(1226,205,2),
(1227,205,3),
(1228,205,6),
(1229,205,8),
(1230,205,11),
(1231,206,2),
(1232,206,4),
(1233,206,5),
(1234,206,6),
(1235,206,7),
(1236,206,11),
(1237,207,0),
(1238,207,5),
(1239,207,6),
(1240,207,7),
(1241,207,8),
(1242,207,11),
(1243,208,0),
(1244,208,4),
(1245,208,5),
(1246,208,6),
(1247,208,8),
(1248,208,11),
(1249,209,0),
(1250,209,2),
(1251,209,5),
(1252,209,6),
(1253,209,7),
(1254,209,11),
(1255,210,0),
(1256,210,1),
(1257,210,3),
(1258,210,4),
(1259,210,5),
(1260,210,10),
(1261,211,0),
(1262,211,1),
(1263,211,5),
(1264,211,6),
(1265,211,8),
(1266,211,11),
(1267,212,1),
(1268,212,2),
(1269,212,4),
(1270,212,6),
(1271,212,7),
(1272,212,11),
(1273,213,1),
(1274,213,2),
(1275,213,3),
(1276,213,5),
(1277,213,6),
(1278,213,10),
(1279,214,0),
(1280,214,2),
(1281,214,4),
(1282,214,5),
(1283,214,8),
(1284,214,10),
(1285,215,0),
(1286,215,1),
(1287,215,2),
(1288,215,4),
(1289,215,6),
(1290,215,11),
(1291,216,1),
(1292,216,3),
(1293,216,4),
(1294,216,5),
(1295,216,7),
(1296,216,10),
(1297,217,0),
(1298,217,1),
(1299,217,2),
(1300,217,7),
(1301,217,8),
(1302,217,10),
(1303,218,0),
(1304,218,1),
(1305,218,4),
(1306,218,5),
(1307,218,7),
(1308,218,11),
(1309,219,3),
(1310,219,4),
(1311,219,5),
(1312,219,7),
(1313,219,8),
(1314,219,11),
(1315,220,0),
(1316,220,1),
(1317,220,3),
(1318,220,5),
(1319,220,8),
(1320,220,10),
(1321,221,1),
(1322,221,2),
(1323,221,4),
(1324,221,5),
(1325,221,8),
(1326,221,11),
(1327,222,1),
(1328,222,2),
(1329,222,5),
(1330,222,7),
(1331,222,8),
(1332,222,11),
(1333,223,0),
(1334,223,2),
(1335,223,3),
(1336,223,4),
(1337,223,8),
(1338,223,11),
(1339,224,1),
(1340,224,3),
(1341,224,4),
(1342,224,7),
(1343,224,8),
(1344,224,11),
(1345,225,1),
(1346,225,3),
(1347,225,4),
(1348,225,5),
(1349,225,6),
(1350,225,10),
(1351,226,2),
(1352,226,3),
(1353,226,5),
(1354,226,6),
(1355,226,8),
(1356,226,11),
(1357,227,0),
(1358,227,1),
(1359,227,4),
(1360,227,5),
(1361,227,7),
(1362,227,11),
(1363,228,0),
(1364,228,2),
(1365,228,3),
(1366,228,5),
(1367,228,8),
(1368,228,11),
(1369,229,3),
(1370,229,4),
(1371,229,5),
(1372,229,6),
(1373,229,7),
(1374,229,10),
(1375,230,2),
(1376,230,3),
(1377,230,5),
(1378,230,7),
(1379,230,8),
(1380,230,10),
(1381,231,0),
(1382,231,1),
(1383,231,2),
(1384,231,3),
(1385,231,8),
(1386,231,11),
(1387,232,0),
(1388,232,2),
(1389,232,4),
(1390,232,7),
(1391,232,8),
(1392,232,10),
(1393,233,3),
(1394,233,4),
(1395,233,5),
(1396,233,6),
(1397,233,8),
(1398,233,11),
(1399,234,0),
(1400,234,1),
(1401,234,3),
(1402,234,5),
(1403,234,7),
(1404,234,11),
(1405,235,0),
(1406,235,1),
(1407,235,5),
(1408,235,6),
(1409,235,8),
(1410,235,10),
(1411,236,1),
(1412,236,4),
(1413,236,5),
(1414,236,6),
(1415,236,7),
(1416,236,10),
(1417,237,0),
(1418,237,4),
(1419,237,5),
(1420,237,6),
(1421,237,8),
(1422,237,11),
(1423,238,0),
(1424,238,1),
(1425,238,3),
(1426,238,5),
(1427,238,7),
(1428,238,10),
(1429,239,4),
(1430,239,5),
(1431,239,6),
(1432,239,7),
(1433,239,8),
(1434,239,11),
(1435,240,0),
(1436,240,2),
(1437,240,3),
(1438,240,6),
(1439,240,8),
(1440,240,10),
(1441,241,3),
(1442,241,4),
(1443,241,5),
(1444,241,7),
(1445,241,8),
(1446,241,10),
(1447,242,0),
(1448,242,1),
(1449,242,2),
(1450,242,6),
(1451,242,8),
(1452,242,10),
(1453,243,0),
(1454,243,1),
(1455,243,3),
(1456,243,5),
(1457,243,6),
(1458,243,11),
(1459,244,0),
(1460,244,1),
(1461,244,4),
(1462,244,5),
(1463,244,7),
(1464,244,10),
(1465,245,0),
(1466,245,4),
(1467,245,5),
(1468,245,6),
(1469,245,7),
(1470,245,11),
(1471,246,0),
(1472,246,1),
(1473,246,3),
(1474,246,6),
(1475,246,7),
(1476,246,10),
(1477,247,0),
(1478,247,1),
(1479,247,3),
(1480,247,4),
(1481,247,5),
(1482,247,11),
(1483,248,1),
(1484,248,4),
(1485,248,6),
(1486,248,7),
(1487,248,8),
(1488,248,11),
(1489,249,2),
(1490,249,3),
(1491,249,6),
(1492,249,7),
(1493,249,8),
(1494,249,11),
(1495,250,1),
(1496,250,2),
(1497,250,3),
(1498,250,5),
(1499,250,7),
(1500,250,10),
(1501,251,0),
(1502,251,1),
(1503,251,2),
(1504,251,7),
(1505,251,8),
(1506,251,11),
(1507,252,0),
(1508,252,2),
(1509,252,3),
(1510,252,5),
(1511,252,8),
(1512,252,11),
(1513,253,0),
(1514,253,2),
(1515,253,3),
(1516,253,5),
(1517,253,7),
(1518,253,10),
(1519,254,1),
(1520,254,2),
(1521,254,4),
(1522,254,6),
(1523,254,8),
(1524,254,10),
(1525,255,0),
(1526,255,3),
(1527,255,4),
(1528,255,6),
(1529,255,8),
(1530,255,11),
(1531,256,0),
(1532,256,1),
(1533,256,4),
(1534,256,7),
(1535,256,8),
(1536,256,11),
(1537,257,0),
(1538,257,2),
(1539,257,4),
(1540,257,5),
(1541,257,6),
(1542,257,11),
(1543,258,0),
(1544,258,1),
(1545,258,2),
(1546,258,3),
(1547,258,5),
(1548,258,11),
(1549,259,1),
(1550,259,2),
(1551,259,3),
(1552,259,5),
(1553,259,8),
(1554,259,11),
(1555,260,1),
(1556,260,2),
(1557,260,3),
(1558,260,6),
(1559,260,7),
(1560,260,10),
(1561,261,2),
(1562,261,4),
(1563,261,5),
(1564,261,6),
(1565,261,8),
(1566,261,10),
(1567,262,0),
(1568,262,3),
(1569,262,5),
(1570,262,6),
(1571,262,8),
(1572,262,11),
(1573,263,0),
(1574,263,1),
(1575,263,2),
(1576,263,4),
(1577,263,8),
(1578,263,11),
(1579,264,1),
(1580,264,2),
(1581,264,3),
(1582,264,5),
(1583,264,7),
(1584,264,10),
(1585,265,3),
(1586,265,4),
(1587,265,6),
(1588,265,7),
(1589,265,8),
(1590,265,11),
(1591,266,1),
(1592,266,2),
(1593,266,4),
(1594,266,6),
(1595,266,8),
(1596,266,11),
(1597,267,0),
(1598,267,1),
(1599,267,3),
(1600,267,4),
(1601,267,6),
(1602,267,10),
(1603,268,0),
(1604,268,1),
(1605,268,3),
(1606,268,7),
(1607,268,8),
(1608,268,10),
(1609,269,2),
(1610,269,3),
(1611,269,4),
(1612,269,6),
(1613,269,7),
(1614,269,10),
(1615,270,0),
(1616,270,2),
(1617,270,6),
(1618,270,7),
(1619,270,8),
(1620,270,10),
(1621,271,4),
(1622,271,5),
(1623,271,6),
(1624,271,7),
(1625,271,8),
(1626,271,10),
(1627,272,1),
(1628,272,3),
(1629,272,4),
(1630,272,7),
(1631,272,8),
(1632,272,10),
(1633,273,0),
(1634,273,1),
(1635,273,4),
(1636,273,7),
(1637,273,8),
(1638,273,11),
(1639,274,1),
(1640,274,2),
(1641,274,5),
(1642,274,6),
(1643,274,7),
(1644,274,11),
(1645,275,0),
(1646,275,2),
(1647,275,4),
(1648,275,5),
(1649,275,8),
(1650,275,11),
(1651,276,0),
(1652,276,1),
(1653,276,2),
(1654,276,4),
(1655,276,8),
(1656,276,11),
(1657,277,0),
(1658,277,4),
(1659,277,5),
(1660,277,6),
(1661,277,8),
(1662,277,10),
(1663,278,0),
(1664,278,2),
(1665,278,4),
(1666,278,6),
(1667,278,8),
(1668,278,10),
(1669,279,0),
(1670,279,3),
(1671,279,4),
(1672,279,7),
(1673,279,8),
(1674,279,11),
(1675,280,1),
(1676,280,2),
(1677,280,4),
(1678,280,5),
(1679,280,7),
(1680,280,10),
(1681,281,0),
(1682,281,2),
(1683,281,3),
(1684,281,6),
(1685,281,8),
(1686,281,11),
(1687,282,1),
(1688,282,3),
(1689,282,4),
(1690,282,6),
(1691,282,8),
(1692,282,11),
(1693,283,1),
(1694,283,3),
(1695,283,5),
(1696,283,6),
(1697,283,7),
(1698,283,11),
(1699,284,1),
(1700,284,3),
(1701,284,4),
(1702,284,6),
(1703,284,8),
(1704,284,10),
(1705,285,2),
(1706,285,3),
(1707,285,4),
(1708,285,5),
(1709,285,7),
(1710,285,11),
(1711,286,2),
(1712,286,3),
(1713,286,5),
(1714,286,7),
(1715,286,8),
(1716,286,11),
(1717,287,0),
(1718,287,1),
(1719,287,2),
(1720,287,7),
(1721,287,8),
(1722,287,11),
(1723,288,0),
(1724,288,2),
(1725,288,3),
(1726,288,5),
(1727,288,7),
(1728,288,10),
(1729,289,1),
(1730,289,2),
(1731,289,4),
(1732,289,5),
(1733,289,6),
(1734,289,11),
(1735,290,0),
(1736,290,1),
(1737,290,3),
(1738,290,5),
(1739,290,8),
(1740,290,11),
(1741,291,0),
(1742,291,3),
(1743,291,4),
(1744,291,6),
(1745,291,7),
(1746,291,11),
(1747,292,0),
(1748,292,1),
(1749,292,3),
(1750,292,5),
(1751,292,7),
(1752,292,11),
(1753,293,1),
(1754,293,3),
(1755,293,6),
(1756,293,7),
(1757,293,8),
(1758,293,11),
(1759,294,1),
(1760,294,2),
(1761,294,6),
(1762,294,7),
(1763,294,8),
(1764,294,11),
(1765,295,0),
(1766,295,1),
(1767,295,2),
(1768,295,3),
(1769,295,8),
(1770,295,10),
(1771,296,1),
(1772,296,3),
(1773,296,4),
(1774,296,5),
(1775,296,7),
(1776,296,10),
(1777,297,0),
(1778,297,1),
(1779,297,2),
(1780,297,5),
(1781,297,8),
(1782,297,10),
(1783,298,0),
(1784,298,1),
(1785,298,3),
(1786,298,5),
(1787,298,7),
(1788,298,10),
(1789,299,1),
(1790,299,3),
(1791,299,5),
(1792,299,7),
(1793,299,8),
(1794,299,11),
(1795,300,0),
(1796,300,1),
(1797,300,2),
(1798,300,3),
(1799,300,4),
(1800,300,10);
/*!40000 ALTER TABLE `product_categories` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table product_set
# ------------------------------------------------------------
DROP TABLE IF EXISTS `product_set`;
CREATE TABLE `product_set` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`set_id` int unsigned NOT NULL,
`product_id` int unsigned NOT NULL,
`order` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `product_set_set_id_foreign` (`set_id`),
KEY `product_set_product_id_foreign` (`product_id`),
KEY `product_id` (`product_id`),
KEY `set_id` (`set_id`),
CONSTRAINT `product_set_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
CONSTRAINT `product_set_set_id_foreign` FOREIGN KEY (`set_id`) REFERENCES `sets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
LOCK TABLES `product_set` WRITE;
/*!40000 ALTER TABLE `product_set` DISABLE KEYS */;
INSERT INTO `product_set` (`id`, `set_id`, `product_id`, `order`)
VALUES
(1,1,1,13),
(2,2,2,2),
(3,3,3,8),
(4,4,4,12),
(5,5,5,16),
(6,6,6,13),
(7,7,7,10),
(8,8,8,16),
(9,9,9,11),
(10,10,10,12),
(11,11,11,2),
(12,12,12,4),
(13,13,13,7),
(14,14,14,19),
(15,15,15,8),
(16,16,16,13),
(17,17,17,20),
(18,18,18,14),
(19,19,19,11),
(20,20,20,8),
(21,1,21,18),
(22,2,22,15),
(23,3,23,14),
(24,4,24,6),
(25,5,25,6),
(26,6,26,15),
(27,7,27,5),
(28,8,28,4),
(29,9,29,12),
(30,10,30,13),
(31,11,31,12),
(32,12,32,13),
(33,13,33,18),
(34,14,34,17),
(35,15,35,4),
(36,16,36,6),
(37,17,37,19),
(38,18,38,20),
(39,19,39,19),
(40,20,40,5),
(41,1,41,16),
(42,2,42,17),
(43,3,43,16),
(44,4,44,2),
(45,5,45,4),
(46,6,46,20),
(47,7,47,1),
(48,8,48,5),
(49,9,49,18),
(50,10,50,16),
(51,11,51,14),
(52,12,52,1),
(53,13,53,17),
(54,14,54,20),
(55,15,55,19),
(56,16,56,3),
(57,17,57,9),
(58,18,58,18),
(59,19,59,7),
(60,20,60,10),
(61,1,61,6),
(62,2,62,1),
(63,3,63,10),
(64,4,64,1),
(65,5,65,20),
(66,6,66,14),
(67,7,67,9),
(68,8,68,16),
(69,9,69,14),
(70,10,70,12),
(71,11,71,9),
(72,12,72,8),
(73,13,73,7),
(74,14,74,19),
(75,15,75,7),
(76,16,76,6),
(77,17,77,1),
(78,18,78,1),
(79,19,79,6),
(80,20,80,19),
(81,1,81,12),
(82,2,82,14),
(83,3,83,14),
(84,4,84,19),
(85,5,85,13),
(86,6,86,11),
(87,7,87,11),
(88,8,88,2),
(89,9,89,10),
(90,10,90,9),
(91,11,91,18),
(92,12,92,3),
(93,13,93,12),
(94,14,94,5),
(95,15,95,9),
(96,16,96,10),
(97,17,97,4),
(98,18,98,9),
(99,19,99,8),
(100,20,100,19),
(101,1,101,17),
(102,2,102,2),
(103,3,103,1),
(104,4,104,11),
(105,5,105,20),
(106,6,106,7),
(107,7,107,12),
(108,8,108,10),
(109,9,109,7),
(110,10,110,3),
(111,11,111,7),
(112,12,112,9),
(113,13,113,14),
(114,14,114,16),
(115,15,115,12),
(116,16,116,15),
(117,17,117,14),
(118,18,118,10),
(119,19,119,4),
(120,20,120,3),
(121,1,121,9),
(122,2,122,12),
(123,3,123,15),
(124,4,124,5),
(125,5,125,3),
(126,6,126,4),
(127,7,127,16),
(128,8,128,6),
(129,9,129,12),
(130,10,130,13),
(131,11,131,17),
(132,12,132,9),
(133,13,133,3),
(134,14,134,9),
(135,15,135,16),
(136,16,136,18),
(137,17,137,2),
(138,18,138,3),
(139,19,139,10),
(140,20,140,9),
(141,1,141,4),
(142,2,142,14),
(143,3,143,17),
(144,4,144,17),
(145,5,145,7),
(146,6,146,5),
(147,7,147,12),
(148,8,148,10),
(149,9,149,1),
(150,10,150,12),
(151,11,151,8),
(152,12,152,19),
(153,13,153,15),
(154,14,154,17),
(155,15,155,16),
(156,16,156,14),
(157,17,157,11),
(158,18,158,6),
(159,19,159,3),
(160,20,160,17),
(161,1,161,1),
(162,2,162,12),
(163,3,163,12),
(164,4,164,14),
(165,5,165,16),
(166,6,166,9),
(167,7,167,4),
(168,8,168,20),
(169,9,169,10),
(170,10,170,15),
(171,11,171,8),
(172,12,172,20),
(173,13,173,7),
(174,14,174,10),
(175,15,175,6),
(176,16,176,7),
(177,17,177,17),
(178,18,178,2),
(179,19,179,5),
(180,20,180,8),
(181,1,181,8),
(182,2,182,9),
(183,3,183,4),
(184,4,184,5),
(185,5,185,15),
(186,6,186,8),
(187,7,187,1),
(188,8,188,17),
(189,9,189,16),
(190,10,190,13),
(191,11,191,5),
(192,12,192,9),
(193,13,193,10),
(194,14,194,6),
(195,15,195,5),
(196,16,196,18),
(197,17,197,11),
(198,18,198,14),
(199,19,199,4),
(200,20,200,8),
(201,1,201,13),
(202,2,202,19),
(203,3,203,13),
(204,4,204,5),
(205,5,205,4),
(206,6,206,6),
(207,7,207,17),
(208,8,208,9),
(209,9,209,20),
(210,10,210,3),
(211,11,211,18),
(212,12,212,1),
(213,13,213,14),
(214,14,214,12),
(215,15,215,20),
(216,16,216,16),
(217,17,217,7),
(218,18,218,1),
(219,19,219,18),
(220,20,220,14),
(221,1,221,10),
(222,2,222,17),
(223,3,223,2),
(224,4,224,12),
(225,5,225,18),
(226,6,226,2),
(227,7,227,6),
(228,8,228,2),
(229,9,229,17),
(230,10,230,7),
(231,11,231,12),
(232,12,232,13),
(233,13,233,12),
(234,14,234,8),
(235,15,235,9),
(236,16,236,9),
(237,17,237,12),
(238,18,238,15),
(239,19,239,10),
(240,20,240,12),
(241,1,241,11),
(242,2,242,17),
(243,3,243,19),
(244,4,244,15),
(245,5,245,18),
(246,6,246,20),
(247,7,247,6),
(248,8,248,1),
(249,9,249,20),
(250,10,250,11),
(251,11,251,15),
(252,12,252,18),
(253,13,253,5),
(254,14,254,10),
(255,15,255,3),
(256,16,256,3),
(257,17,257,20),
(258,18,258,11),
(259,19,259,16),
(260,20,260,10),
(261,1,261,11),
(262,2,262,6),
(263,3,263,11),
(264,4,264,9),
(265,5,265,10),
(266,6,266,6),
(267,7,267,18),
(268,8,268,12),
(269,9,269,12),
(270,10,270,18),
(271,11,271,19),
(272,12,272,12),
(273,13,273,18),
(274,14,274,3),
(275,15,275,8),
(276,16,276,18),
(277,17,277,13),
(278,18,278,18),
(279,19,279,5),
(280,20,280,9),
(281,1,281,19),
(282,2,282,2),
(283,3,283,20),
(284,4,284,1),
(285,5,285,16),
(286,6,286,5),
(287,7,287,20),
(288,8,288,8),
(289,9,289,8),
(290,10,290,9),
(291,11,291,4),
(292,12,292,5),
(293,13,293,3),
(294,14,294,4),
(295,15,295,11),
(296,16,296,6),
(297,17,297,20),
(298,18,298,1),
(299,19,299,6),
(300,20,300,4);
/*!40000 ALTER TABLE `product_set` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table product_state
# ------------------------------------------------------------
DROP TABLE IF EXISTS `product_state`;
CREATE TABLE `product_state` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`product_id` int unsigned NOT NULL,
`state_id` int unsigned NOT NULL,
`status_id` int unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `product_state_product_id_index` (`product_id`),
KEY `product_state_state_id_index` (`state_id`),
KEY `product_state_status_id_index` (`status_id`),
CONSTRAINT `product_state_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
CONSTRAINT `product_state_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
LOCK TABLES `product_state` WRITE;
/*!40000 ALTER TABLE `product_state` DISABLE KEYS */;
INSERT INTO `product_state` (`id`, `product_id`, `state_id`, `status_id`)
VALUES
(1,1,1,17),
(2,1,2,17),
(3,1,3,17),
(4,1,4,17),
(5,1,5,17),
(6,2,1,17),
(7,2,2,17),
(8,2,3,17),
(9,2,4,17),
(10,2,5,17),
(11,3,1,17),
(12,3,2,17),
(13,3,3,17),
(14,3,4,17),
(15,3,5,17),
(16,4,1,17),
(17,4,2,17),
(18,4,3,17),
(19,4,4,19),
(20,4,5,17),
(21,5,1,19),
(22,5,2,17),
(23,5,3,17),
(24,5,4,17),
(25,5,5,17),
(26,6,1,17),
(27,6,2,17),
(28,6,3,17),
(29,6,4,17),
(30,6,5,17),
(31,7,1,17),
(32,7,2,17),
(33,7,3,17),
(34,7,4,17),
(35,7,5,17),
(36,8,1,17),
(37,8,2,17),
(38,8,3,19),
(39,8,4,17),
(40,8,5,17),
(41,9,1,17),
(42,9,2,17),
(43,9,3,17),
(44,9,4,17),
(45,9,5,17),
(46,10,1,17),
(47,10,2,17),
(48,10,3,17),
(49,10,4,17),
(50,10,5,17),
(51,11,1,17),
(52,11,2,17),
(53,11,3,17),
(54,11,4,17),
(55,11,5,17),
(56,12,1,19),
(57,12,2,17),
(58,12,3,17),
(59,12,4,17),
(60,12,5,17),
(61,13,1,17),
(62,13,2,17),
(63,13,3,17),
(64,13,4,19),
(65,13,5,17),
(66,14,1,17),
(67,14,2,17),
(68,14,3,17),
(69,14,4,17),
(70,14,5,17),
(71,15,1,17),
(72,15,2,17),
(73,15,3,17),
(74,15,4,17),
(75,15,5,17),
(76,16,1,17),
(77,16,2,17),
(78,16,3,17),
(79,16,4,17),
(80,16,5,17),
(81,17,1,17),
(82,17,2,17),
(83,17,3,17),
(84,17,4,17),
(85,17,5,17),
(86,18,1,17),
(87,18,2,17),
(88,18,3,17),
(89,18,4,17),
(90,18,5,17),
(91,19,1,17),
(92,19,2,17),
(93,19,3,17),
(94,19,4,17),
(95,19,5,17),
(96,20,1,17),
(97,20,2,17),
(98,20,3,17),
(99,20,4,19),
(100,20,5,17),
(101,21,1,17),
(102,21,2,17),
(103,21,3,17),
(104,21,4,17),
(105,21,5,17),
(106,22,1,17),
(107,22,2,17),
(108,22,3,17),
(109,22,4,17),
(110,22,5,17),
(111,23,1,19),
(112,23,2,17),
(113,23,3,19),
(114,23,4,17),
(115,23,5,19),
(116,24,1,17),
(117,24,2,17),
(118,24,3,17),
(119,24,4,17),
(120,24,5,17),
(121,25,1,17),
(122,25,2,17),
(123,25,3,17),
(124,25,4,17),
(125,25,5,17),
(126,26,1,17),
(127,26,2,17),
(128,26,3,17),
(129,26,4,17),
(130,26,5,17),
(131,27,1,17),
(132,27,2,17),
(133,27,3,17),
(134,27,4,17),
(135,27,5,17),
(136,28,1,17),
(137,28,2,17),
(138,28,3,17),
(139,28,4,17),
(140,28,5,17),
(141,29,1,17),
(142,29,2,17),
(143,29,3,17),
(144,29,4,17),
(145,29,5,17),
(146,30,1,19),
(147,30,2,19),
(148,30,3,17),
(149,30,4,17),
(150,30,5,17),
(151,31,1,17),
(152,31,2,17),
(153,31,3,17),
(154,31,4,17),
(155,31,5,17),
(156,32,1,17),
(157,32,2,17),
(158,32,3,17),
(159,32,4,17),
(160,32,5,17),
(161,33,1,17),
(162,33,2,17),
(163,33,3,19),
(164,33,4,17),
(165,33,5,19),
(166,34,1,17),
(167,34,2,17),
(168,34,3,17),
(169,34,4,17),
(170,34,5,17),
(171,35,1,17),
(172,35,2,17),
(173,35,3,17),
(174,35,4,17),
(175,35,5,17),
(176,36,1,17),
(177,36,2,17),
(178,36,3,17),
(179,36,4,17),
(180,36,5,17),
(181,37,1,17),
(182,37,2,17),
(183,37,3,17),
(184,37,4,17),
(185,37,5,17),
(186,38,1,17),
(187,38,2,17),
(188,38,3,17),
(189,38,4,17),
(190,38,5,17),
(191,39,1,17),
(192,39,2,17),
(193,39,3,17),
(194,39,4,17),
(195,39,5,17),
(196,40,1,17),
(197,40,2,17),
(198,40,3,17),
(199,40,4,17),
(200,40,5,17),
(201,41,1,17),
(202,41,2,19),
(203,41,3,17),
(204,41,4,17),
(205,41,5,17),
(206,42,1,17),
(207,42,2,17),
(208,42,3,17),
(209,42,4,17),
(210,42,5,17),
(211,43,1,17),
(212,43,2,17),
(213,43,3,17),
(214,43,4,17),
(215,43,5,17),
(216,44,1,17),
(217,44,2,17),
(218,44,3,17),
(219,44,4,19),
(220,44,5,17),
(221,45,1,19),
(222,45,2,17),
(223,45,3,17),
(224,45,4,17),
(225,45,5,17),
(226,46,1,17),
(227,46,2,17),
(228,46,3,17),
(229,46,4,17),
(230,46,5,17),
(231,47,1,17),
(232,47,2,17),
(233,47,3,17),
(234,47,4,17),
(235,47,5,17),
(236,48,1,17),
(237,48,2,17),
(238,48,3,19),
(239,48,4,17),
(240,48,5,17),
(241,49,1,17),
(242,49,2,17),
(243,49,3,17),
(244,49,4,17),
(245,49,5,17),
(246,50,1,17),
(247,50,2,17),
(248,50,3,17),
(249,50,4,17),
(250,50,5,17),
(251,51,1,17),
(252,51,2,17),
(253,51,3,17),
(254,51,4,17),
(255,51,5,17),
(256,52,1,17),
(257,52,2,17),
(258,52,3,17),
(259,52,4,19),
(260,52,5,17),
(261,53,1,17),
(262,53,2,17),
(263,53,3,17),
(264,53,4,17),
(265,53,5,19),
(266,54,1,17),
(267,54,2,17),
(268,54,3,17),
(269,54,4,17),
(270,54,5,17),
(271,55,1,17),
(272,55,2,17),
(273,55,3,17),
(274,55,4,17),
(275,55,5,17),
(276,56,1,17),
(277,56,2,17),
(278,56,3,17),
(279,56,4,17),
(280,56,5,17),
(281,57,1,17),
(282,57,2,17),
(283,57,3,17),
(284,57,4,17),
(285,57,5,19),
(286,58,1,17),
(287,58,2,17),
(288,58,3,17),
(289,58,4,17),
(290,58,5,17),
(291,59,1,17),
(292,59,2,17),
(293,59,3,17),
(294,59,4,17),
(295,59,5,17),
(296,60,1,17),
(297,60,2,17),
(298,60,3,17),
(299,60,4,17),
(300,60,5,17),
(301,61,1,17),
(302,61,2,17),
(303,61,3,17),
(304,61,4,17),
(305,61,5,17),
(306,62,1,19),
(307,62,2,17),
(308,62,3,17),
(309,62,4,17),
(310,62,5,17),
(311,63,1,17),
(312,63,2,17),
(313,63,3,17),
(314,63,4,17),
(315,63,5,17),
(316,64,1,17),
(317,64,2,17),
(318,64,3,17),
(319,64,4,17),
(320,64,5,17),
(321,65,1,17),
(322,65,2,17),
(323,65,3,17),
(324,65,4,17),
(325,65,5,17),
(326,66,1,17),
(327,66,2,17),
(328,66,3,17),
(329,66,4,17),
(330,66,5,17),
(331,67,1,17),
(332,67,2,17),
(333,67,3,17),
(334,67,4,17),
(335,67,5,17),
(336,68,1,17),
(337,68,2,17),
(338,68,3,17),
(339,68,4,17),
(340,68,5,17),
(341,69,1,17),
(342,69,2,17),
(343,69,3,17),
(344,69,4,17),
(345,69,5,17),
(346,70,1,17),
(347,70,2,17),
(348,70,3,17),
(349,70,4,19),
(350,70,5,17),
(351,71,1,17),
(352,71,2,17),
(353,71,3,17),
(354,71,4,17),
(355,71,5,17),
(356,72,1,17),
(357,72,2,17),
(358,72,3,17),
(359,72,4,17),
(360,72,5,17),
(361,73,1,17),
(362,73,2,17),
(363,73,3,17),
(364,73,4,17),
(365,73,5,17),
(366,74,1,17),
(367,74,2,17),
(368,74,3,17),
(369,74,4,17),
(370,74,5,17),
(371,75,1,17),
(372,75,2,17),
(373,75,3,17),
(374,75,4,17),
(375,75,5,17),
(376,76,1,17),
(377,76,2,17),
(378,76,3,17),
(379,76,4,17),
(380,76,5,17),
(381,77,1,17),
(382,77,2,17),
(383,77,3,17),
(384,77,4,17),
(385,77,5,17),
(386,78,1,17),
(387,78,2,17),
(388,78,3,17),
(389,78,4,17),
(390,78,5,17),
(391,79,1,17),
(392,79,2,17),
(393,79,3,17),
(394,79,4,17),
(395,79,5,17),
(396,80,1,17),
(397,80,2,17),
(398,80,3,19),
(399,80,4,17),
(400,80,5,19),
(401,81,1,17),
(402,81,2,17),
(403,81,3,17),
(404,81,4,19),
(405,81,5,17),
(406,82,1,17),
(407,82,2,17),
(408,82,3,17),
(409,82,4,17),
(410,82,5,17),
(411,83,1,17),
(412,83,2,17),
(413,83,3,17),
(414,83,4,17),
(415,83,5,17),
(416,84,1,17),
(417,84,2,17),
(418,84,3,17),
(419,84,4,17),
(420,84,5,17),
(421,85,1,17),
(422,85,2,17),
(423,85,3,17),
(424,85,4,17),
(425,85,5,17),
(426,86,1,19),
(427,86,2,17),
(428,86,3,17),
(429,86,4,17),
(430,86,5,17),
(431,87,1,17),
(432,87,2,17),
(433,87,3,17),
(434,87,4,17),
(435,87,5,17),
(436,88,1,17),
(437,88,2,17),
(438,88,3,17),
(439,88,4,17),
(440,88,5,17),
(441,89,1,17),
(442,89,2,17),
(443,89,3,17),
(444,89,4,17),
(445,89,5,17),
(446,90,1,17),
(447,90,2,17),
(448,90,3,19),
(449,90,4,17),
(450,90,5,17),
(451,91,1,17),
(452,91,2,17),
(453,91,3,17),
(454,91,4,19),
(455,91,5,17),
(456,92,1,17),
(457,92,2,17),
(458,92,3,17),
(459,92,4,17),
(460,92,5,17),
(461,93,1,17),
(462,93,2,17),
(463,93,3,17),
(464,93,4,17),
(465,93,5,17),
(466,94,1,19),
(467,94,2,17),
(468,94,3,17),
(469,94,4,17),
(470,94,5,17),
(471,95,1,17),
(472,95,2,17),
(473,95,3,17),
(474,95,4,17),
(475,95,5,17),
(476,96,1,17),
(477,96,2,17),
(478,96,3,17),
(479,96,4,17),
(480,96,5,17),
(481,97,1,17),
(482,97,2,17),
(483,97,3,17),
(484,97,4,17),
(485,97,5,17),
(486,98,1,17),
(487,98,2,17),
(488,98,3,19),
(489,98,4,17),
(490,98,5,17),
(491,99,1,17),
(492,99,2,17),
(493,99,3,17),
(494,99,4,17),
(495,99,5,17),
(496,100,1,17),
(497,100,2,17),
(498,100,3,17),
(499,100,4,17),
(500,100,5,17),
(501,101,1,17),
(502,101,2,17),
(503,101,3,17),
(504,101,4,17),
(505,101,5,17),
(506,102,1,17),
(507,102,2,17),
(508,102,3,17),
(509,102,4,17),
(510,102,5,17),
(511,103,1,17),
(512,103,2,17),
(513,103,3,17),
(514,103,4,17),
(515,103,5,17),
(516,104,1,17),
(517,104,2,17),
(518,104,3,17),
(519,104,4,17),
(520,104,5,17),
(521,105,1,17),
(522,105,2,17),
(523,105,3,17),
(524,105,4,17),
(525,105,5,17),
(526,106,1,17),
(527,106,2,17),
(528,106,3,17),
(529,106,4,17),
(530,106,5,17),
(531,107,1,17),
(532,107,2,17),
(533,107,3,17),
(534,107,4,17),
(535,107,5,17),
(536,108,1,17),
(537,108,2,17),
(538,108,3,17),
(539,108,4,17),
(540,108,5,17),
(541,109,1,17),
(542,109,2,17),
(543,109,3,17),
(544,109,4,17),
(545,109,5,19),
(546,110,1,17),
(547,110,2,17),
(548,110,3,17),
(549,110,4,17),
(550,110,5,17),
(551,111,1,17),
(552,111,2,17),
(553,111,3,17),
(554,111,4,17),
(555,111,5,17),
(556,112,1,17),
(557,112,2,17),
(558,112,3,17),
(559,112,4,17),
(560,112,5,17),
(561,113,1,17),
(562,113,2,17),
(563,113,3,17),
(564,113,4,17),
(565,113,5,17),
(566,114,1,17),
(567,114,2,17),
(568,114,3,17),
(569,114,4,17),
(570,114,5,17),
(571,115,1,19),
(572,115,2,17),
(573,115,3,17),
(574,115,4,17),
(575,115,5,19),
(576,116,1,17),
(577,116,2,17),
(578,116,3,17),
(579,116,4,17),
(580,116,5,17),
(581,117,1,17),
(582,117,2,17),
(583,117,3,17),
(584,117,4,17),
(585,117,5,17),
(586,118,1,17),
(587,118,2,17),
(588,118,3,17),
(589,118,4,19),
(590,118,5,17),
(591,119,1,17),
(592,119,2,17),
(593,119,3,17),
(594,119,4,17),
(595,119,5,17),
(596,120,1,19),
(597,120,2,17),
(598,120,3,17),
(599,120,4,17),
(600,120,5,17),
(601,121,1,17),
(602,121,2,17),
(603,121,3,17),
(604,121,4,17),
(605,121,5,17),
(606,122,1,17),
(607,122,2,17),
(608,122,3,17),
(609,122,4,17),
(610,122,5,17),
(611,123,1,17),
(612,123,2,17),
(613,123,3,17),
(614,123,4,17),
(615,123,5,17),
(616,124,1,17),
(617,124,2,17),
(618,124,3,17),
(619,124,4,17),
(620,124,5,17),
(621,125,1,17),
(622,125,2,17),
(623,125,3,17),
(624,125,4,17),
(625,125,5,17),
(626,126,1,17),
(627,126,2,17),
(628,126,3,17),
(629,126,4,17),
(630,126,5,17),
(631,127,1,19),
(632,127,2,17),
(633,127,3,17),
(634,127,4,17),
(635,127,5,17),
(636,128,1,17),
(637,128,2,17),
(638,128,3,17),
(639,128,4,17),
(640,128,5,17),
(641,129,1,17),
(642,129,2,17),
(643,129,3,17),
(644,129,4,17),
(645,129,5,17),
(646,130,1,17),
(647,130,2,17),
(648,130,3,17),
(649,130,4,17),
(650,130,5,17),
(651,131,1,17),
(652,131,2,17),
(653,131,3,17),
(654,131,4,17),
(655,131,5,17),
(656,132,1,17),
(657,132,2,19),
(658,132,3,17),
(659,132,4,17),
(660,132,5,17),
(661,133,1,17),
(662,133,2,17),
(663,133,3,17),
(664,133,4,17),
(665,133,5,17),
(666,134,1,17),
(667,134,2,19),
(668,134,3,17),
(669,134,4,17),
(670,134,5,17),
(671,135,1,17),
(672,135,2,17),
(673,135,3,17),
(674,135,4,19),
(675,135,5,17),
(676,136,1,17),
(677,136,2,17),
(678,136,3,17),
(679,136,4,17),
(680,136,5,17),
(681,137,1,17),
(682,137,2,17),
(683,137,3,17),
(684,137,4,17),
(685,137,5,17),
(686,138,1,17),
(687,138,2,17),
(688,138,3,17),
(689,138,4,17),
(690,138,5,19),
(691,139,1,19),
(692,139,2,17),
(693,139,3,17),
(694,139,4,17),
(695,139,5,17),
(696,140,1,17),
(697,140,2,17),
(698,140,3,17),
(699,140,4,17),
(700,140,5,19),
(701,141,1,17),
(702,141,2,17),
(703,141,3,17),
(704,141,4,17),
(705,141,5,17),
(706,142,1,17),
(707,142,2,17),
(708,142,3,17),
(709,142,4,17),
(710,142,5,17),
(711,143,1,17),
(712,143,2,17),
(713,143,3,17),
(714,143,4,17),
(715,143,5,19),
(716,144,1,17),
(717,144,2,17),
(718,144,3,17),
(719,144,4,17),
(720,144,5,17),
(721,145,1,17),
(722,145,2,17),
(723,145,3,17),
(724,145,4,17),
(725,145,5,17),
(726,146,1,17),
(727,146,2,17),
(728,146,3,17),
(729,146,4,17),
(730,146,5,17),
(731,147,1,17),
(732,147,2,17),
(733,147,3,17),
(734,147,4,17),
(735,147,5,17),
(736,148,1,17),
(737,148,2,17),
(738,148,3,17),
(739,148,4,17),
(740,148,5,17),
(741,149,1,17),
(742,149,2,17),
(743,149,3,19),
(744,149,4,17),
(745,149,5,17),
(746,150,1,17),
(747,150,2,17),
(748,150,3,17),
(749,150,4,17),
(750,150,5,17),
(751,151,1,17),
(752,151,2,17),
(753,151,3,17),
(754,151,4,17),
(755,151,5,17),
(756,152,1,17),
(757,152,2,17),
(758,152,3,19),
(759,152,4,17),
(760,152,5,17),
(761,153,1,17),
(762,153,2,17),
(763,153,3,17),
(764,153,4,17),
(765,153,5,17),
(766,154,1,17),
(767,154,2,17),
(768,154,3,17),
(769,154,4,17),
(770,154,5,17),
(771,155,1,19),
(772,155,2,19),
(773,155,3,17),
(774,155,4,17),
(775,155,5,17),
(776,156,1,17),
(777,156,2,17),
(778,156,3,17),
(779,156,4,17),
(780,156,5,17),
(781,157,1,19),
(782,157,2,17),
(783,157,3,19),
(784,157,4,17),
(785,157,5,17),
(786,158,1,17),
(787,158,2,17),
(788,158,3,17),
(789,158,4,17),
(790,158,5,17),
(791,159,1,17),
(792,159,2,17),
(793,159,3,17),
(794,159,4,17),
(795,159,5,17),
(796,160,1,19),
(797,160,2,17),
(798,160,3,17),
(799,160,4,17),
(800,160,5,17),
(801,161,1,17),
(802,161,2,17),
(803,161,3,17),
(804,161,4,19),
(805,161,5,17),
(806,162,1,17),
(807,162,2,19),
(808,162,3,17),
(809,162,4,17),
(810,162,5,17),
(811,163,1,17),
(812,163,2,17),
(813,163,3,17),
(814,163,4,17),
(815,163,5,17),
(816,164,1,17),
(817,164,2,17),
(818,164,3,17),
(819,164,4,17),
(820,164,5,19),
(821,165,1,17),
(822,165,2,17),
(823,165,3,17),
(824,165,4,17),
(825,165,5,17),
(826,166,1,17),
(827,166,2,17),
(828,166,3,17),