-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 10, 2025 at 03:04 AM
-- Server version: 10.11.10-MariaDB-log
-- PHP Version: 7.2.34

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u427573777_LC2JS`
--

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

--
-- Table structure for table `j6w7_category`
--

CREATE TABLE `j6w7_category` (
  `id_category` int(10) UNSIGNED NOT NULL,
  `id_parent` int(10) UNSIGNED NOT NULL,
  `id_shop_default` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `level_depth` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `nleft` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `nright` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `position` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_root_category` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `j6w7_category`
--

INSERT INTO `j6w7_category` (`id_category`, `id_parent`, `id_shop_default`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES
(1, 0, 1, 0, 1, 112, 1, '2021-03-12 14:15:31', '2021-03-12 14:15:31', 0, 0),
(2, 1, 1, 1, 2, 111, 1, '2021-03-12 14:15:31', '2021-03-12 14:15:31', 0, 1),
(10, 2, 1, 2, 3, 64, 1, '2020-06-09 22:39:28', '2020-11-26 16:31:18', 0, 0),
(11, 10, 1, 3, 4, 5, 1, '2020-06-09 22:50:15', '2022-07-01 16:04:43', 0, 0),
(147, 10, 1, 3, 6, 7, 1, '2020-11-26 17:19:28', '2022-07-01 16:04:50', 1, 0),
(148, 10, 1, 3, 8, 9, 1, '2020-11-26 17:25:18', '2022-07-01 16:04:55', 2, 0),
(149, 2, 1, 2, 65, 70, 1, '2020-12-27 17:39:31', '2020-12-27 17:39:31', 1, 0),
(150, 149, 1, 3, 66, 67, 1, '2020-12-27 17:39:49', '2020-12-27 17:39:49', 0, 0),
(151, 10, 1, 3, 10, 11, 1, '2021-02-02 16:33:01', '2021-02-02 16:33:01', 3, 0),
(152, 10, 1, 3, 12, 13, 1, '2021-02-09 18:19:14', '2021-02-09 18:19:14', 4, 0),
(153, 2, 1, 2, 71, 92, 1, '2021-05-12 16:58:23', '2021-05-12 16:58:23', 2, 0),
(154, 153, 1, 3, 72, 73, 1, '2021-05-12 16:58:42', '2021-07-26 16:16:55', 0, 0),
(155, 153, 1, 3, 74, 75, 1, '2021-06-29 13:44:38', '2021-07-26 16:16:55', 1, 0),
(156, 153, 1, 3, 76, 77, 1, '2021-06-29 13:50:50', '2021-07-26 16:16:55', 2, 0),
(157, 153, 1, 3, 78, 79, 1, '2021-06-29 13:56:04', '2021-07-26 16:16:55', 3, 0),
(158, 153, 1, 3, 80, 81, 1, '2021-06-29 13:57:21', '2021-07-26 16:16:55', 4, 0),
(159, 153, 1, 3, 82, 83, 1, '2021-06-29 14:01:37', '2021-07-26 16:16:55', 5, 0),
(160, 153, 1, 3, 84, 85, 1, '2021-06-29 14:04:00', '2021-07-26 16:16:55', 6, 0),
(161, 153, 1, 3, 86, 87, 1, '2021-06-29 14:11:20', '2021-07-26 16:16:55', 7, 0),
(162, 153, 1, 3, 88, 89, 1, '2021-06-29 14:20:09', '2021-07-26 16:16:55', 8, 0),
(163, 153, 1, 3, 90, 91, 1, '2021-06-29 14:40:30', '2021-07-26 16:16:55', 9, 0),
(164, 10, 1, 3, 14, 15, 1, '2021-07-22 21:18:34', '2021-07-22 21:18:34', 5, 0),
(165, 2, 1, 2, 93, 98, 1, '2021-07-23 14:58:39', '2021-07-23 14:58:39', 3, 0),
(166, 165, 1, 3, 94, 95, 1, '2021-07-23 14:59:16', '2021-07-23 14:59:16', 0, 0),
(167, 2, 1, 2, 99, 100, 1, '2021-07-23 15:55:24', '2021-07-23 15:55:24', 4, 0),
(168, 165, 1, 3, 96, 97, 1, '2021-07-23 16:04:03', '2021-07-23 16:04:03', 1, 0),
(169, 10, 1, 3, 16, 17, 1, '2021-07-30 15:03:12', '2021-07-30 15:03:12', 6, 0),
(170, 10, 1, 3, 18, 19, 1, '2021-07-30 17:11:04', '2021-07-30 17:11:04', 7, 0),
(171, 10, 1, 3, 20, 21, 1, '2021-08-03 13:27:36', '2021-08-03 13:27:36', 8, 0),
(172, 10, 1, 3, 22, 23, 1, '2021-08-11 14:12:22', '2021-08-11 14:12:22', 9, 0),
(173, 10, 1, 3, 24, 25, 1, '2021-09-13 16:02:20', '2021-09-13 16:02:20', 10, 0),
(174, 10, 1, 3, 26, 27, 1, '2021-09-13 16:25:28', '2021-09-13 16:25:28', 11, 0),
(175, 2, 1, 2, 101, 102, 1, '2021-09-27 16:59:19', '2021-09-27 16:59:19', 5, 0),
(176, 10, 1, 3, 28, 29, 1, '2021-09-27 16:59:31', '2021-09-27 16:59:31', 12, 0),
(177, 10, 1, 3, 30, 31, 1, '2021-10-12 15:32:24', '2021-10-12 15:32:24', 13, 0),
(178, 10, 1, 3, 32, 33, 1, '2021-10-18 21:59:38', '2021-10-18 21:59:38', 14, 0),
(179, 2, 1, 2, 103, 106, 1, '2022-01-04 11:30:00', '2022-01-04 11:30:00', 6, 0),
(180, 179, 1, 3, 104, 105, 1, '2022-01-04 11:30:07', '2022-01-04 11:30:07', 0, 0),
(181, 10, 1, 3, 34, 35, 1, '2022-02-01 12:01:15', '2022-02-01 12:01:15', 15, 0),
(182, 10, 1, 3, 36, 37, 1, '2022-03-25 18:11:23', '2022-03-25 18:11:23', 16, 0),
(183, 10, 1, 3, 38, 39, 1, '2022-05-23 17:21:53', '2022-05-23 17:21:53', 17, 0),
(184, 10, 1, 3, 40, 41, 1, '2022-05-23 17:46:23', '2022-05-23 17:46:23', 18, 0),
(185, 10, 1, 3, 42, 43, 1, '2022-05-23 17:47:37', '2022-05-23 17:47:37', 19, 0),
(186, 10, 1, 3, 44, 45, 1, '2022-07-19 19:40:15', '2025-07-31 23:58:03', 20, 0),
(187, 10, 1, 3, 46, 47, 1, '2022-11-02 18:42:26', '2022-11-02 18:42:26', 21, 0),
(188, 10, 1, 3, 48, 49, 1, '2023-03-01 15:00:13', '2023-03-01 15:00:13', 22, 0),
(189, 2, 1, 2, 107, 110, 1, '2023-05-29 15:53:39', '2023-05-29 15:53:39', 7, 0),
(190, 189, 1, 3, 108, 109, 1, '2023-05-29 15:53:56', '2023-05-29 15:53:56', 0, 0),
(191, 10, 1, 3, 50, 51, 1, '2023-07-20 18:21:46', '2023-07-20 18:21:46', 23, 0),
(192, 149, 1, 3, 68, 69, 1, '2023-12-12 12:31:54', '2023-12-12 12:31:54', 1, 0),
(193, 10, 1, 3, 52, 53, 1, '2023-12-27 20:15:36', '2023-12-27 20:15:36', 24, 0),
(194, 10, 1, 3, 54, 55, 1, '2023-12-27 20:36:37', '2023-12-27 20:36:37', 25, 0),
(195, 10, 1, 3, 56, 57, 1, '2024-04-18 14:41:20', '2024-04-18 14:41:20', 26, 0),
(196, 10, 1, 3, 58, 59, 1, '2024-09-12 19:21:35', '2024-09-12 19:21:35', 27, 0),
(197, 10, 1, 3, 60, 61, 1, '2025-07-31 22:57:39', '2025-07-31 22:57:39', 28, 0),
(198, 10, 1, 3, 62, 63, 1, '2025-08-29 20:20:45', '2025-08-29 20:20:45', 29, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `j6w7_category`
--
ALTER TABLE `j6w7_category`
  ADD PRIMARY KEY (`id_category`),
  ADD KEY `category_parent` (`id_parent`),
  ADD KEY `nleftrightactive` (`nleft`,`nright`,`active`),
  ADD KEY `level_depth` (`level_depth`),
  ADD KEY `nright` (`nright`),
  ADD KEY `activenleft` (`active`,`nleft`),
  ADD KEY `activenright` (`active`,`nright`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `j6w7_category`
--
ALTER TABLE `j6w7_category`
  MODIFY `id_category` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=199;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
