-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 02, 2025 at 05:55 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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: `cartzilla_shop`
--

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

--
-- Table structure for table `abandoned_cart_emails`
--

CREATE TABLE `abandoned_cart_emails` (
  `id` int(11) NOT NULL,
  `cart_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `sent_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `cui` varchar(20) DEFAULT NULL,
  `reg_com` varchar(50) DEFAULT NULL,
  `country` varchar(100) NOT NULL DEFAULT 'România',
  `county` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `postcode` varchar(20) NOT NULL,
  `address_line1` varchar(255) NOT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--

INSERT INTO `addresses` (`id`, `user_id`, `first_name`, `last_name`, `email`, `phone`, `company_name`, `cui`, `reg_com`, `country`, `county`, `city`, `postcode`, `address_line1`, `address_line2`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 1, 'Ion', 'Popescu', 'ion.popescu@example.com', '0721234567', NULL, NULL, NULL, 'România', 'București', 'București', '010101', 'Str. Exemplu, Nr. 1, Bl. A, Sc. 1, Ap. 1', NULL, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(2, 2, 'Maria', 'Ionescu', 'maria.ionescu@example.com', '0722345678', NULL, NULL, NULL, 'România', 'Cluj', 'Cluj-Napoca', '400001', 'Str. Test, Nr. 2', NULL, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(3, 3, 'Gheorghe', 'Georgescu', 'gheorghe.georgescu@example.com', '0723456789', 'TechBusiness SRL', 'RO12345678', 'J40/1234/2020', 'România', 'Timiș', 'Timișoara', '300001', 'Str. Demo, Nr. 3', NULL, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(4, 4, 'Ana', 'Marinescu', 'ana.marinescu@example.com', '0724567890', NULL, NULL, NULL, 'România', 'Iași', 'Iași', '700001', 'Bd. Independenței, Nr. 10', NULL, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(5, 5, 'Petru', 'Constantinescu', 'petru.constantinescu@example.com', '0725678901', 'ElectroDist SRL', 'RO23456789', 'J12/5678/2021', 'România', 'Constanța', 'Constanța', '900001', 'Str. Portului, Nr. 5', NULL, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13');

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('super_admin','admin') DEFAULT 'admin',
  `created_at` datetime DEFAULT current_timestamp(),
  `last_login` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `email`, `password`, `role`, `created_at`, `last_login`) VALUES
(1, 'admin', 'admin@cartzilla-shop.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'super_admin', '2025-11-30 01:59:12', NULL),
(2, 'manager', 'manager@cartzilla-shop.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', '2025-11-30 01:59:12', NULL);

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

--
-- Table structure for table `b2b_groups`
--

CREATE TABLE `b2b_groups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `discount_percent` decimal(5,2) DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `b2b_groups`
--

INSERT INTO `b2b_groups` (`id`, `name`, `discount_percent`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Clienți Business', 10.00, 'Grup pentru clienți business cu discount de 10%', 1, '2025-11-30 01:59:12', '2025-11-30 01:59:12'),
(2, 'Distribuitori', 20.00, 'Grup pentru distribuitori cu discount de 20%', 1, '2025-11-30 01:59:12', '2025-11-30 01:59:12'),
(3, 'Parteneri Premium', 15.00, 'Grup pentru parteneri premium cu discount de 15%', 1, '2025-11-30 01:59:12', '2025-11-30 01:59:12'),
(4, 'Revânzători', 25.00, 'Grup pentru revânzători cu discount de 25%', 1, '2025-11-30 01:59:12', '2025-11-30 01:59:12');

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

--
-- Table structure for table `b2b_group_users`
--

CREATE TABLE `b2b_group_users` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `b2b_group_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `b2b_group_users`
--

INSERT INTO `b2b_group_users` (`id`, `user_id`, `b2b_group_id`, `created_at`) VALUES
(1, 2, 1, '2025-11-30 01:59:13'),
(2, 3, 2, '2025-11-30 01:59:13'),
(3, 5, 3, '2025-11-30 01:59:13');

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

--
-- Table structure for table `b2b_product_prices`
--

CREATE TABLE `b2b_product_prices` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `discount_percent` decimal(5,2) DEFAULT NULL,
  `custom_price` decimal(10,2) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_email_sent` datetime DEFAULT NULL,
  `email_count` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`id`, `user_id`, `session_id`, `created_at`, `updated_at`, `last_email_sent`, `email_count`) VALUES
(1, 1, NULL, '2025-11-28 01:59:13', '2025-11-30 12:44:30', NULL, 0),
(2, NULL, 'test_session_123', '2025-11-29 01:59:13', '2025-11-29 01:59:13', NULL, 0),
(3, 4, NULL, '2025-11-29 22:59:13', '2025-11-29 22:59:13', NULL, 0),
(4, NULL, 'h6ao529s44o3ms20v0580mkpic', '2025-11-30 03:11:47', '2025-11-30 03:11:52', NULL, 0),
(5, NULL, 'nk69l1ibs0d71o712m43ebok3d', '2025-11-30 23:49:52', '2025-11-30 23:49:52', NULL, 0);

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

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int(11) NOT NULL,
  `cart_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price_at_add` decimal(10,2) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_items`
--

INSERT INTO `cart_items` (`id`, `cart_id`, `product_id`, `quantity`, `price_at_add`, `created_at`) VALUES
(3, 2, 2, 1, 6499.00, '2025-11-30 01:59:13'),
(4, 3, 14, 1, 1999.00, '2025-11-30 01:59:13'),
(16, 4, 1, 4, 100.00, '2025-11-30 03:11:52'),
(37, 1, 4, 1, 4499.00, '2025-11-30 12:44:30');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL COMMENT 'ID-ul categoriei parinte (NULL pentru categorii root)',
  `name` varchar(255) NOT NULL COMMENT 'Numele categoriei',
  `slug` varchar(255) NOT NULL COMMENT 'URL-friendly identifier unic',
  `description` text DEFAULT NULL COMMENT 'Descriere detaliata a categoriei',
  `icon` varchar(100) DEFAULT NULL COMMENT 'Clasa CSS pentru iconita (ex: ci-computer)',
  `image_url` varchar(500) DEFAULT NULL COMMENT 'URL imagine reprezentativa',
  `url` varchar(500) DEFAULT NULL COMMENT 'Link catre pagina de categorie',
  `position` int(11) DEFAULT 0 COMMENT 'Ordinea de afisare (mai mic = mai sus)',
  `is_active` tinyint(1) DEFAULT 1 COMMENT 'Categorie activa (1) sau dezactivata (0)',
  `show_in_menu` tinyint(1) DEFAULT 1 COMMENT 'Arata in mega-menu (1=da, 0=nu)',
  `has_megamenu` tinyint(1) DEFAULT 0 COMMENT 'Are submeniu extins - mega-menu (1=da, 0=nu)',
  `megamenu_layout` varchar(50) DEFAULT 'auto' COMMENT 'Layout mega-menu: auto, 2-col, 3-col, 4-col',
  `seo_title` varchar(255) DEFAULT NULL COMMENT 'Titlu SEO pentru pagina categoriei',
  `seo_description` text DEFAULT NULL COMMENT 'Meta description pentru SEO',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Categorii de produse cu ierarhie';

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `name`, `slug`, `description`, `icon`, `image_url`, `url`, `position`, `is_active`, `show_in_menu`, `has_megamenu`, `megamenu_layout`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Computers & Accessories', 'computers-accessories', NULL, 'ci-computer', NULL, '/shop-catalog-electronics.php', 1, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(2, 1, 'Computers', 'computers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(3, 1, 'Accessories', 'accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(4, 1, 'Laptops & Tablets', 'laptops-tablets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(5, 1, 'Desktop Computers', 'desktop-computers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(6, 1, 'External Components', 'external-components', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(7, 1, 'Internal Components', 'internal-components', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(8, 1, 'Networking Products (NAS)', 'networking-products', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(9, 1, 'Single Board Computers', 'single-board-computers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(10, 1, 'Desktop Barebones', 'desktop-barebones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(11, 2, 'Monitors', 'monitors', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(12, 2, 'Bags, Cases & Sleeves', 'bags-cases-sleeves', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(13, 2, 'Batteries', 'batteries', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(14, 2, 'Chargers & Adapters', 'chargers-adapters', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(15, 2, 'Cooling Pads', 'cooling-pads', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(16, 2, 'Mounts', 'mounts', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(17, 2, 'Replacement Screens', 'replacement-screens', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(18, 2, 'Security Locks', 'security-locks', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(19, 2, 'Stands', 'stands', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(20, NULL, 'Smartphones & Tablets', 'smartphones-tablets', NULL, 'ci-smartphone-2', NULL, '/shop-catalog-electronics.php', 2, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(21, 20, 'Smartphones', 'smartphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(22, 20, 'Tablets', 'tablets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(23, 20, 'Accessories', 'smartphone-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(24, 19, 'Apple iPhone', 'apple-iphone', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(25, 19, 'Google Pixel', 'google-pixel', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(26, 19, 'Android Smartphones', 'android-smartphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(27, 19, 'Phablets', 'phablets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(28, 20, 'Apple iPad', 'apple-ipad', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(29, 20, 'Android Tablets', 'android-tablets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(30, 20, 'Tablets with Keyboard', 'tablets-keyboard', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(31, 21, 'Accessory Kits', 'accessory-kits', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(32, 21, 'Batteries & Battery Packs', 'batteries-battery-packs', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(33, 21, 'Bags & Cases', 'phone-bags-cases', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(34, 21, 'Cables', 'phone-cables', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(35, 21, 'Car Accessories', 'car-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(36, 21, 'Chargers & Power Adapters', 'phone-chargers-adapters', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(37, NULL, 'Headphones', 'headphones', NULL, 'ci-headphones-2', NULL, '/shop-catalog-electronics.php', 3, 1, 1, 1, '2-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(38, 37, 'Headphones', 'headphones-items', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(39, 37, 'Accessories', 'headphone-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(40, 37, 'Earbud Headphones', 'earbud-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(41, 37, 'Over-Ear Headphones', 'over-ear-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(42, 37, 'On-Ear Headphones', 'on-ear-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(43, 37, 'Bluetooth Headphones', 'bluetooth-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(44, 37, 'Sports & Fitness', 'sports-fitness-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(45, 37, 'Noise-Cancelling', 'noise-cancelling-headphones', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(46, 38, 'Cases & Sleeves', 'headphone-cases', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(47, 38, 'Cables & Cords', 'headphone-cables', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(48, 38, 'Ear Pads', 'ear-pads', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(49, NULL, 'TV, Video & Audio', 'tv-video-audio', NULL, 'ci-monitor-2', NULL, '/shop-catalog-electronics.php', 4, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(50, 49, 'TV, Video & Audio', 'tv-video-audio-items', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(51, 50, 'TV Sets', 'tv-sets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(52, 50, 'Home Theater Systems', 'home-theater-systems', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(53, 50, 'DVD Players & Recorders', 'dvd-players-recorders', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(54, 50, 'Blue-ray Players & Recorders', 'blue-ray-players-recorders', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(55, 50, 'HD DVD Players & Recorders', 'hd-dvd-players-recorders', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(56, 50, 'DVD-VCR Combos', 'dvd-vcr-combos', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(57, 50, 'DTV Converters', 'dtv-converters', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(58, 50, 'AV Receivers', 'av-receivers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(59, 50, 'AV Amplifiers', 'av-amplifiers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(60, 50, 'Projectors', 'projectors', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(61, 50, 'Projection Screens', 'projection-screens', NULL, NULL, NULL, '/shop-catalog-electronics.php', 11, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(62, 50, 'Satelite Television', 'satelite-television', NULL, NULL, NULL, '/shop-catalog-electronics.php', 12, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(63, 50, 'TV-DTD Combos', 'tv-dtd-combos', NULL, NULL, NULL, '/shop-catalog-electronics.php', 13, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(64, 50, 'Sound Systems', 'sound-systems', NULL, NULL, NULL, '/shop-catalog-electronics.php', 14, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(65, 50, 'Home Cinema Systems', 'home-cinema-systems', NULL, NULL, NULL, '/shop-catalog-electronics.php', 15, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(66, 50, 'Streaming Media Players', 'streaming-media-players', NULL, NULL, NULL, '/shop-catalog-electronics.php', 16, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(67, 50, 'VCRs', 'vcrs', NULL, NULL, NULL, '/shop-catalog-electronics.php', 17, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(68, 50, 'Video Glasses', 'video-glasses', NULL, NULL, NULL, '/shop-catalog-electronics.php', 18, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(69, 50, 'Lens Attachments', 'tv-lens-attachments', NULL, NULL, NULL, '/shop-catalog-electronics.php', 19, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(70, 50, 'Subwoofers', 'tv-subwoofers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 20, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(71, 50, 'Sound Boosters', 'sound-boosters', NULL, NULL, NULL, '/shop-catalog-electronics.php', 21, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(72, NULL, 'Speakers & Home Music', 'speakers-home-music', NULL, 'ci-speaker-2', NULL, '/shop-catalog-electronics.php', 5, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(73, 72, 'Speakers', 'speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(74, 72, 'Home Audio', 'home-audio', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(75, 72, 'Smart Speakers', 'smart-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(76, 72, 'Bluetooth Speakers', 'bluetooth-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(77, 72, 'Bookshelf Speakers', 'bookshelf-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(78, 72, 'Ceiling & In-Wall Speakers', 'ceiling-in-wall-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(79, 72, 'Center-Channel Speakers', 'center-channel-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(80, 72, 'Floorstanding Speakers', 'floorstanding-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(81, 72, 'Outdoor Speakers', 'outdoor-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(82, 72, 'Satellite Speakers', 'satellite-speakers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(83, 72, 'Sound Bars', 'sound-bars', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(84, 72, 'Surround Sound Systems', 'surround-sound-systems', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(85, 73, 'Home Theater', 'home-theater', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(86, 73, 'Wireless & Streaming Audio', 'wireless-streaming-audio', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(87, 73, 'Stereo System Components', 'stereo-system-components', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(88, 73, 'Compact Radios & Stereos', 'compact-radios-stereos', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(89, 73, 'Home Audio Accessories', 'home-audio-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(90, 73, 'Subwoofers', 'audio-subwoofers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(91, NULL, 'Cameras, Photo & Video', 'cameras-photo-video', NULL, 'ci-camera-2', NULL, '/shop-catalog-electronics.php', 6, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(92, 91, 'Cameras & Lenses', 'cameras-lenses', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(93, 91, 'Accessories', 'camera-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(94, 91, 'Point & Shoot Cameras', 'point-shoot-cameras', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(95, 91, 'DSLR Cameras', 'dslr-cameras', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(96, 91, 'Mirrorless Cameras', 'mirrorless-cameras', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(97, 91, 'Body Mounted Cameras', 'body-mounted-cameras', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(98, 91, 'Camcorders', 'camcorders', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(99, 91, 'Camcorder Lenses', 'camcorder-lenses', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(100, 91, 'Camera Lenses', 'camera-lenses', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(101, 91, 'Macro & Ringlight Flashes', 'macro-ringlight-flashes', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(102, 91, 'Shoe Mount Flashes', 'shoe-mount-flashes', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(103, 91, 'Tripods & Monopods', 'tripods-monopods', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(104, 91, 'Video Studio', 'video-studio', NULL, NULL, NULL, '/shop-catalog-electronics.php', 11, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(105, 92, 'Bags & Cases', 'camera-bags-cases', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(106, 92, 'Binoculars & Scopes', 'binoculars-scopes', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(107, 92, 'Batteries & Chargers', 'camera-batteries-chargers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(108, 92, 'Cables & Cords', 'camera-cables-cords', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(109, 92, 'Camcorder Accessories', 'camcorder-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(110, 92, 'Cleaning Equipment', 'camera-cleaning-equipment', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(111, 92, 'Protector Foils', 'protector-foils', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(112, 92, 'Filters & Accessories', 'filters-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(113, 92, 'Remote Controls', 'camera-remote-controls', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(114, 92, 'Rain Covers', 'rain-covers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(115, 92, 'Viewfinders', 'viewfinders', NULL, NULL, NULL, '/shop-catalog-electronics.php', 11, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(116, NULL, 'Printers & Ink', 'printers-ink', NULL, 'ci-printer-2', NULL, '/shop-catalog-electronics.php', 7, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(117, 116, 'By type', 'printers-by-type', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(118, 116, 'Scanners', 'scanners', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(119, 116, 'Printers', 'printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(120, 115, 'All-in-One', 'all-in-one', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(121, 115, 'Copying', 'copying', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(122, 115, 'Faxing', 'faxing', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(123, 115, 'Photo Printing', 'photo-printing', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(124, 115, 'Printing Only', 'printing-only', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(125, 115, 'Scanning', 'scanning', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(126, 116, 'Business Card Scanners', 'business-card-scanners', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(127, 116, 'Document Scanners', 'document-scanners', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(128, 116, 'Flatbed & Photo Scanners', 'flatbed-photo-scanners', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(129, 116, 'Slide & Negative Scanners', 'slide-negative-scanners', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(130, 117, 'Dot Matrix Printers', 'dot-matrix-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(131, 117, 'Inkjet Printers', 'inkjet-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(132, 117, 'Label Printers', 'label-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(133, 117, 'Laser Printers', 'laser-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(134, 117, 'Photo Printers', 'photo-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(135, 117, 'Wide Format Printers', 'wide-format-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(136, 117, 'Plotter Printers', 'plotter-printers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(137, NULL, 'Charging Stations', 'charging-stations', NULL, 'ci-battery-2', NULL, '/shop-catalog-electronics.php', 8, 1, 1, 1, '2-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(138, 137, 'Charging Stations', 'charging-stations-items', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(139, 138, 'Portable Power Stations', 'portable-power-stations', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(140, 138, 'Inverter Power Stations', 'inverter-power-stations', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(141, 138, 'Outdoor Generators', 'outdoor-generators', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(142, 138, 'Gasoline Generators', 'gasoline-generators', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(143, 138, 'Cell Phone Chargers', 'cell-phone-chargers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(144, 138, 'Power Strips', 'power-strips', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(145, 138, 'Wall Chargers', 'wall-chargers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(146, NULL, 'Wearable Electronics', 'wearable-electronics', NULL, 'ci-watch-2', NULL, '/shop-catalog-electronics.php', 9, 1, 1, 1, '2-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(147, 146, 'Wearable Gadgets', 'wearable-gadgets', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(148, 147, 'Smartwatches', 'smartwatches', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(149, 147, 'Fitness Trackers', 'fitness-trackers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(150, 147, 'Smart Glasses', 'smart-glasses', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(151, 147, 'Rings', 'rings', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(152, 147, 'Virtual Reality', 'virtual-reality', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(153, 147, 'Clips, Arm & Wristbands', 'clips-arm-wristbands', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(154, 147, 'Accessories', 'wearable-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(155, NULL, 'Powerbanks', 'powerbanks', NULL, 'ci-powerbank', NULL, '/shop-catalog-electronics.php', 10, 1, 1, 1, '2-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(156, 155, 'Powerbanks', 'powerbanks-items', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(157, 156, 'Fast Charging', 'fast-charging', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(158, 156, 'Built In Cable', 'built-in-cable', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(159, 156, 'Built In Wall Plug', 'built-in-wall-plug', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(160, 156, 'LED Indicator Lights', 'led-indicator-lights', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(161, 156, 'Pocket Size', 'pocket-size', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(162, 156, 'Wireless Charging', 'wireless-charging', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(163, 156, 'Short Circuit Protection', 'short-circuit-protection', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(164, 156, 'Scratch Resistant', 'scratch-resistant', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(165, 156, 'Flashlight', 'flashlight', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(166, 156, 'Lightweight', 'lightweight', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(167, NULL, 'HDD/SSD Data Storage', 'hdd-ssd-data-storage', NULL, 'ci-hard-drive-2', NULL, '/shop-catalog-electronics.php', 11, 1, 1, 1, '2-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(168, 167, 'Data Storage', 'data-storage', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(169, 168, 'External Hard Drives', 'external-hard-drives', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(170, 168, 'External SSD', 'external-ssd', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(171, 168, 'External Zip Drives', 'external-zip-drives', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(172, 168, 'Floppy & Tape Drives', 'floppy-tape-drives', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(173, 168, 'Internal Hard Drives', 'internal-hard-drives', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(174, 168, 'Internal SSD', 'internal-ssd', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(175, 168, 'Network Attached Storage', 'network-attached-storage', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(176, 168, 'USB Flash Drives', 'usb-flash-drives', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(177, NULL, 'Video Games', 'video-games', NULL, 'ci-game', NULL, '/shop-catalog-electronics.php', 12, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(178, 177, 'Games & Hardware', 'games-hardware', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(179, 178, 'Video Games', 'video-games-items', NULL, NULL, NULL, '/shop-catalog-electronics.php', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(180, 178, 'PlayStation 5', 'playstation-5', NULL, NULL, NULL, '/shop-catalog-electronics.php', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(181, 178, 'PlayStation 4', 'playstation-4', NULL, NULL, NULL, '/shop-catalog-electronics.php', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(182, 178, 'Xbox Series X', 'xbox-series-x', NULL, NULL, NULL, '/shop-catalog-electronics.php', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(183, 178, 'Xbox Series S', 'xbox-series-s', NULL, NULL, NULL, '/shop-catalog-electronics.php', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(184, 178, 'Nintendo Switch', 'nintendo-switch', NULL, NULL, NULL, '/shop-catalog-electronics.php', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(185, 178, 'Gaming PC', 'gaming-pc', NULL, NULL, NULL, '/shop-catalog-electronics.php', 7, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(186, 178, 'Gaming Laptops', 'gaming-laptops', NULL, NULL, NULL, '/shop-catalog-electronics.php', 8, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(187, 178, 'Wii U', 'wii-u', NULL, NULL, NULL, '/shop-catalog-electronics.php', 9, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(188, 178, 'Wii', 'wii', NULL, NULL, NULL, '/shop-catalog-electronics.php', 10, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(189, 178, 'Nintendo 3DS', 'nintendo-3ds', NULL, NULL, NULL, '/shop-catalog-electronics.php', 11, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(190, 178, 'Nintendo 2DS', 'nintendo-2ds', NULL, NULL, NULL, '/shop-catalog-electronics.php', 12, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(191, 178, 'Nintendo DS', 'nintendo-ds', NULL, NULL, NULL, '/shop-catalog-electronics.php', 13, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(192, 178, 'Mac', 'mac-gaming', NULL, NULL, NULL, '/shop-catalog-electronics.php', 14, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(193, 178, 'PlayStation Vita', 'playstation-vita', NULL, NULL, NULL, '/shop-catalog-electronics.php', 15, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(194, 178, 'Sony PSP', 'sony-psp', NULL, NULL, NULL, '/shop-catalog-electronics.php', 16, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(195, 178, 'Retro Gaming', 'retro-gaming', NULL, NULL, NULL, '/shop-catalog-electronics.php', 17, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(196, 178, 'Microconsoles', 'microconsoles', NULL, NULL, NULL, '/shop-catalog-electronics.php', 18, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(197, 178, 'Controllers', 'controllers', NULL, NULL, NULL, '/shop-catalog-electronics.php', 19, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(198, 178, 'Accessories', 'gaming-accessories', NULL, NULL, NULL, '/shop-catalog-electronics.php', 20, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(199, 178, 'Digital Games Screens', 'digital-games-screens', NULL, NULL, NULL, '/shop-catalog-electronics.php', 21, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(200, 178, 'Game Pass', 'game-pass', NULL, NULL, NULL, '/shop-catalog-electronics.php', 22, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(201, 178, 'PlayStation Plus', 'playstation-plus', NULL, NULL, NULL, '/shop-catalog-electronics.php', 23, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(202, NULL, 'Supraveghere video', 'supraveghere-video', NULL, 'ci-camera', NULL, '/shop-catalog-electronics.php?category=supraveghere-video', 13, 1, 1, 1, '3-col', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(203, 202, 'Sisteme complete', 'sisteme-complete', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=sisteme-complete', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(204, 202, 'Camere de supraveghere', 'camere-supraveghere', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-supraveghere', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(205, 202, 'DVR / NVR', 'dvr-nvr', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=dvr-nvr', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(206, 202, 'Accesorii & Cabluri', 'accesorii-cabluri', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=accesorii-cabluri', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(207, 202, 'Surse alimentare & UPS', 'surse-ups', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=surse-ups', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(208, 199, 'Kit complet 4 camere', 'kit-4-camere', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=kit-4-camere', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(209, 199, 'Kit complet 8 camere', 'kit-8-camere', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=kit-8-camere', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(210, 199, 'Kit complet 16 camere', 'kit-16-camere', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=kit-16-camere', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(211, 199, 'Kit IP PoE', 'kit-ip-poe', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=kit-ip-poe', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(212, 199, 'Kit wireless Wi-Fi', 'kit-wireless', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=kit-wireless', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(213, 200, 'Camere analogice HD', 'camere-analogice-hd', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-analogice-hd', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(214, 200, 'Camere IP', 'camere-ip', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-ip', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(215, 200, 'Camere dome', 'camere-dome', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-dome', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(216, 200, 'Camere bullet', 'camere-bullet', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-bullet', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(217, 200, 'Camere PTZ', 'camere-ptz', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-ptz', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(218, 200, 'Camere termice', 'camere-termice', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=camere-termice', 6, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(219, 201, 'DVR analogic', 'dvr-analogic', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=dvr-analogic', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(220, 201, 'NVR IP', 'nvr-ip', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=nvr-ip', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(221, 201, 'HVR hibrid', 'hvr-hibrid', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=hvr-hibrid', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 22:56:47'),
(222, 206, 'Mufe BNC / RCA', 'mufe-bnc-rca', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=mufe-bnc-rca', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:16:41'),
(223, 206, 'Cablu coaxial', 'cablu-coaxial', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=cablu-coaxial', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:18:01'),
(224, 206, 'Cablu UTP', 'cablu-utp', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=cablu-utp', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:17:22'),
(225, 206, 'Splittere video', 'splittere-video', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=splittere-video', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:17:39'),
(226, 206, 'Convertoare video', 'convertoare-video', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=convertoare-video', 5, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:17:53'),
(227, 207, 'Surse 12V pentru camere', 'surse-12v', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=surse-12v', 1, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:18:29'),
(228, 207, 'Alimentatoare în carcasă', 'alimentatoare-carcase', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=alimentatoare-carcase', 2, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:18:35'),
(229, 207, 'UPS-uri pentru DVR/NVR', 'ups-dvr', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=ups-dvr', 3, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:18:39'),
(230, 207, 'Baterii reîncărcabile', 'baterii-reincarcabile', NULL, NULL, NULL, '/shop-catalog-electronics.php?category=baterii-reincarcabile', 4, 1, 1, 0, 'auto', NULL, NULL, '2025-11-30 22:56:47', '2025-11-30 23:19:12');

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

--
-- Table structure for table `category_promo_cards`
--

CREATE TABLE `category_promo_cards` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL COMMENT 'ID categoria parinte pentru care apare cardul',
  `title` varchar(255) NOT NULL COMMENT 'Titlul produsului/ofertei',
  `subtitle` text DEFAULT NULL COMMENT 'Subtitlu (ex: Deal of the week, Best deal)',
  `badge_text` varchar(100) DEFAULT NULL COMMENT 'Text badge (ex: Save up to $400)',
  `badge_bg_color` varchar(50) DEFAULT 'danger' COMMENT 'Culoare badge: danger, success, warning, info, etc',
  `description` text DEFAULT NULL COMMENT 'Descriere suplimentara',
  `price_original` decimal(10,2) DEFAULT NULL COMMENT 'Pret original (taiat)',
  `price_sale` decimal(10,2) DEFAULT NULL COMMENT 'Pret promotional',
  `price_label` varchar(100) DEFAULT NULL COMMENT 'Label pret (ex: Starts from)',
  `image_url` varchar(500) NOT NULL COMMENT 'URL imagine produs',
  `image_alt` varchar(255) DEFAULT NULL COMMENT 'Text alternativ pentru imagine (SEO)',
  `icon` varchar(100) DEFAULT NULL COMMENT 'Icon brand optional (ex: ci-apple, ci-google)',
  `button_text` varchar(100) DEFAULT 'Shop now' COMMENT 'Text buton CTA',
  `button_url` varchar(500) NOT NULL COMMENT 'Link buton CTA',
  `bg_color` varchar(50) DEFAULT 'bg-body-secondary' COMMENT 'Clasa CSS pentru culoare fundal',
  `position` int(11) DEFAULT 0 COMMENT 'Ordinea de afisare',
  `is_active` tinyint(1) DEFAULT 1 COMMENT 'Card activ (1) sau inactiv (0)',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Carduri promotionale pentru mega-menu';

--
-- Dumping data for table `category_promo_cards`
--

INSERT INTO `category_promo_cards` (`id`, `category_id`, `title`, `subtitle`, `badge_text`, `badge_bg_color`, `description`, `price_original`, `price_sale`, `price_label`, `image_url`, `image_alt`, `icon`, `button_text`, `button_url`, `bg_color`, `position`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 'Surface Laptop Studio', 'Starts from', 'Save up to $900', 'warning', NULL, 1599.00, 1399.00, 'Starts from', '/assets/img/mega-menu/electronics/01.png', 'Surface Laptop Studio', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:48:54'),
(2, 20, 'iPad Pro M1', 'Deal of the week', NULL, 'danger', NULL, NULL, NULL, NULL, '/assets/img/mega-menu/electronics/02.png', 'iPad Pro', 'ci-apple', 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(3, 37, 'Wireless Headphones', NULL, 'Save up to $200', 'danger', NULL, NULL, 119.99, 'Starts from', '/assets/img/mega-menu/electronics/08.png', 'Wireless Headphones', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(4, 49, 'LG OLED 4K Smart TV', NULL, NULL, 'danger', 'Best deal! Save up to $500', NULL, NULL, NULL, '/assets/img/mega-menu/electronics/03.png', 'Smart TV', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(5, 72, 'Nest Audio', 'Deal of the week', NULL, 'danger', NULL, NULL, NULL, NULL, '/assets/img/mega-menu/electronics/04.png', 'Nest Audio', 'ci-google', 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(6, 91, 'Canon Digital Cameras', NULL, 'Save up to $300', 'danger', NULL, 1100.00, 899.00, 'Starts from', '/assets/img/mega-menu/electronics/05.png', 'Canon Camera', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(7, 116, 'Epson Color Printers', NULL, NULL, 'danger', 'Best deal! Save up to $200', NULL, NULL, NULL, '/assets/img/mega-menu/electronics/06.png', 'Epson Printer', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(8, 137, 'Portable Power Stations', NULL, 'Huge sale!', 'danger', 'Save up to $350', NULL, NULL, NULL, '/assets/img/mega-menu/electronics/07.png', 'Portable Power Station', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(9, 146, 'Pixel Watch', 'Deal of the week', NULL, 'danger', NULL, NULL, NULL, NULL, '/assets/img/mega-menu/electronics/09.png', 'Pixel Watch', 'ci-google', 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(10, 155, 'Powerbanks Deals', NULL, NULL, 'danger', 'Save up to $50 on our', NULL, NULL, NULL, '/assets/img/mega-menu/electronics/10.png', 'Powerbank', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(11, 167, 'Samsung SSD Deals', NULL, 'Save up to $100', 'danger', NULL, NULL, 89.99, 'Starts from', '/assets/img/mega-menu/electronics/11.png', 'SSD', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(12, 177, 'Xbox Series X', NULL, 'Save $100', 'danger', NULL, 599.00, 499.00, 'Starts from', '/assets/img/mega-menu/electronics/12.png', 'Xbox', NULL, 'Shop now', '/shop-catalog-electronics.php', 'bg-body-secondary', 1, 1, '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(13, 202, 'Echipamente CCTV', NULL, NULL, 'danger', 'Reduceri până la -30% - Echipamente profesionale pentru orice tip de locație', NULL, NULL, NULL, '/assets/img/mega-menu/electronics/cctv-promo.png', 'Sisteme supraveghere video', NULL, 'Shop now', '/shop-catalog-electronics.php?category=supraveghere-video', 'bg-body-secondary', 1, 1, '2025-11-30 22:56:47', '2025-11-30 22:56:47');

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

--
-- Table structure for table `category_settings`
--

CREATE TABLE `category_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL COMMENT 'Cheie unica pentru setare',
  `setting_value` text DEFAULT NULL COMMENT 'Valoarea setarii',
  `description` varchar(255) DEFAULT NULL COMMENT 'Descriere setare',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Setari globale pentru mega-menu';

--
-- Dumping data for table `category_settings`
--

INSERT INTO `category_settings` (`id`, `setting_key`, `setting_value`, `description`, `created_at`, `updated_at`) VALUES
(1, 'homepage_static_menu', '1', 'Mega-menu static pe homepage (1=da, 0=nu)', '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(2, 'hover_trigger', 'hover', 'Trigger pentru deschidere: hover sau click', '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(3, 'hover_delay', '200', 'Delay hover in milisecunde', '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(4, 'max_megamenu_columns', '3', 'Numar maxim de coloane in mega-menu (fara promo card)', '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(5, 'show_mobile_all_categories', '1', 'Arata butonul All Categories pe mobile (1=da, 0=nu)', '2025-11-30 22:42:51', '2025-11-30 22:42:51'),
(6, 'min_menu_height', '561.33', 'Inaltime minima mega-menu in px (pentru min 12 categorii)', '2025-11-30 22:42:51', '2025-11-30 23:30:16');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `discount_type` enum('percentage','fixed','free_shipping') NOT NULL,
  `discount_value` decimal(10,2) NOT NULL,
  `min_order_value` decimal(10,2) DEFAULT 0.00,
  `max_discount` decimal(10,2) DEFAULT NULL,
  `usage_limit` int(11) DEFAULT NULL,
  `used_count` int(11) DEFAULT 0,
  `valid_from` datetime DEFAULT NULL,
  `valid_until` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `code`, `discount_type`, `discount_value`, `min_order_value`, `max_discount`, `usage_limit`, `used_count`, `valid_from`, `valid_until`, `is_active`, `created_at`) VALUES
(1, 'WELCOME10', 'percentage', 10.00, 100.00, NULL, 100, 0, '2025-11-30 01:59:13', '2026-11-30 01:59:13', 1, '2025-11-30 01:59:13'),
(2, 'SAVE50', 'fixed', 50.00, 200.00, NULL, 50, 0, '2025-11-30 01:59:13', '2026-05-30 01:59:13', 1, '2025-11-30 01:59:13'),
(3, 'FREESHIP', 'free_shipping', 0.00, 300.00, NULL, 200, 0, '2025-11-30 01:59:13', '2026-11-30 01:59:13', 1, '2025-11-30 01:59:13'),
(4, 'BLACKFRIDAY25', 'percentage', 25.00, 500.00, 500.00, 1000, 0, '2025-11-30 01:59:13', '2026-11-30 01:59:13', 1, '2025-11-30 01:59:13'),
(5, 'SUMMER15', 'percentage', 15.00, 150.00, NULL, 500, 0, '2025-11-30 01:59:13', '2026-05-30 01:59:13', 1, '2025-11-30 01:59:13');

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

--
-- Table structure for table `gift_products`
--

CREATE TABLE `gift_products` (
  `id` int(11) NOT NULL,
  `buy_product_id` int(11) DEFAULT NULL,
  `buy_quantity` int(11) DEFAULT 1,
  `gift_product_id` int(11) NOT NULL,
  `gift_quantity` int(11) DEFAULT 1,
  `min_order_value` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gift_products`
--

INSERT INTO `gift_products` (`id`, `buy_product_id`, `buy_quantity`, `gift_product_id`, `gift_quantity`, `min_order_value`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 10, 1, 5000.00, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(2, 5, 1, 10, 1, 9000.00, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13');

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

--
-- Table structure for table `import_export_logs`
--

CREATE TABLE `import_export_logs` (
  `id` int(11) NOT NULL,
  `type` enum('import','export') NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `records_count` int(11) DEFAULT 0,
  `success_count` int(11) DEFAULT 0,
  `error_count` int(11) DEFAULT 0,
  `errors` text DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `loyalty_points`
--

CREATE TABLE `loyalty_points` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `type` enum('earned','used','expired') NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `loyalty_points`
--

INSERT INTO `loyalty_points` (`id`, `user_id`, `points`, `type`, `order_id`, `description`, `created_at`) VALUES
(1, 1, 1299, 'earned', 1, 'Puncte câștigate din comandă ORD-2024-001', '2025-11-30 01:59:13'),
(2, 2, 5999, 'earned', 2, 'Puncte câștigate din comandă ORD-2024-002', '2025-11-30 01:59:13'),
(3, 3, 9999, 'earned', 3, 'Puncte câștigate din comandă ORD-2024-003', '2025-11-30 01:59:13'),
(4, 1, 2299, 'earned', 4, 'Puncte câștigate din comandă ORD-2024-004', '2025-11-30 01:59:13');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_type` enum('physical','legal') NOT NULL,
  `billing_address_id` int(11) DEFAULT NULL,
  `shipping_address_id` int(11) DEFAULT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) DEFAULT 0.00,
  `shipping_cost` decimal(10,2) DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL,
  `payment_method` varchar(50) DEFAULT 'cash_on_delivery',
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `order_status` enum('pending','processing','shipped','delivered','cancelled') DEFAULT 'pending',
  `coupon_code` varchar(50) DEFAULT NULL,
  `loyalty_points_used` int(11) DEFAULT 0,
  `notes` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_number`, `user_id`, `order_type`, `billing_address_id`, `shipping_address_id`, `subtotal`, `discount`, `shipping_cost`, `total`, `payment_method`, `payment_status`, `order_status`, `coupon_code`, `loyalty_points_used`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'ORD-2024-001', 1, 'physical', 1, 1, 1299.00, 0.00, 0.00, 1299.00, 'cash_on_delivery', 'paid', 'delivered', NULL, 0, NULL, '2025-11-20 01:59:13', '2025-11-30 01:59:13'),
(2, 'ORD-2024-002', 2, 'physical', 2, 2, 5999.00, 0.00, 0.00, 5999.00, 'card', 'paid', 'shipped', NULL, 0, NULL, '2025-11-25 01:59:13', '2025-11-30 01:59:13'),
(3, 'ORD-2024-003', 3, 'legal', 3, 3, 9999.00, 999.90, 0.00, 8999.10, 'bank_transfer', 'paid', 'processing', 'WELCOME10', 0, NULL, '2025-11-28 01:59:13', '2025-11-30 01:59:13'),
(4, 'ORD-2024-004', 1, 'physical', 1, 1, 2299.00, 0.00, 0.00, 2299.00, 'card', 'pending', 'pending', NULL, 0, NULL, '2025-11-29 01:59:13', '2025-11-30 01:59:13');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `is_gift` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `product_name`, `quantity`, `price`, `subtotal`, `is_gift`) VALUES
(1, 1, 10, 'AirPods Pro 2 - Alb', 1, 1299.00, 1299.00, 0),
(2, 2, 8, 'iPad Pro 12.9\" M2 256GB', 1, 5999.00, 5999.00, 0),
(3, 3, 5, 'MacBook Pro 14\" M3 512GB', 1, 9999.00, 9999.00, 0),
(4, 4, 14, 'Apple Watch Series 9 45mm', 1, 2299.00, 2299.00, 0);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `stock_quantity` int(11) DEFAULT 0,
  `category_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `gallery` text DEFAULT NULL,
  `is_gift` tinyint(1) DEFAULT 0,
  `is_featured` tinyint(1) DEFAULT 0,
  `featured_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `slug`, `description`, `short_description`, `sku`, `price`, `sale_price`, `stock_quantity`, `category_id`, `supplier_id`, `image`, `gallery`, `is_gift`, `is_featured`, `featured_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'iPhone 15 Pro 256GB', 'iphone-15-pro-256gb', 'iPhone 15 Pro cu ecran Super Retina XDR de 6.1 inci, procesor A17 Pro, sistem de cameră Pro cu 3 camere de 48MP, rezistență la apă IP68.', 'iPhone 15 Pro 256GB - Titanium Natural', 'IPH15P256', 5999.00, 100.00, 15, 6, 1, '/assets/img/shop/electronics/thumbs/01.png', NULL, 0, 1, 1, 1, '2025-11-30 01:59:13', '2025-11-30 03:03:29'),
(2, 'Samsung Galaxy S24 Ultra', 'samsung-galaxy-s24-ultra', 'Samsung Galaxy S24 Ultra cu ecran Dynamic AMOLED 2X de 6.8 inci, procesor Snapdragon 8 Gen 3, cameră de 200MP, S Pen inclus.', 'Samsung Galaxy S24 Ultra 256GB', 'SGS24U256', 6499.00, NULL, 12, 6, 1, '/assets/img/shop/electronics/thumbs/02.png', NULL, 0, 1, 2, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(3, 'Xiaomi Redmi Note 13 Pro', 'xiaomi-redmi-note-13-pro', 'Xiaomi Redmi Note 13 Pro cu ecran AMOLED 6.67 inch, procesor MediaTek Dimensity 7200 Ultra, cameră 200MP, baterie 5100mAh.', 'Redmi Note 13 Pro 256GB', 'XMRN13P', 1499.00, 1299.00, 25, 6, 1, '/assets/img/shop/electronics/thumbs/12.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(4, 'Google Pixel 8 Pro', 'google-pixel-8-pro', 'Google Pixel 8 Pro cu ecran LTPO OLED de 6.7 inci, procesor Google Tensor G3, cameră 50MP, Android 14.', 'Google Pixel 8 Pro 128GB', 'GPX8P', 4999.00, 4499.00, 10, 6, 1, '/assets/img/shop/electronics/thumbs/13.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(5, 'MacBook Pro 14\" M3', 'macbook-pro-14-m3', 'MacBook Pro 14 inch cu procesor Apple M3, 18GB RAM, 512GB SSD, ecran Liquid Retina XDR, autonomie până la 18 ore.', 'MacBook Pro 14\" M3 512GB', 'MBP14M3', 9999.00, 9499.00, 8, 7, 2, '/assets/img/shop/electronics/thumbs/03.png', NULL, 0, 1, 3, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(6, 'Dell XPS 15', 'dell-xps-15', 'Dell XPS 15 cu procesor Intel Core i7-13700H, 16GB RAM, 512GB SSD, ecran OLED 15.6 inch 3.5K, NVIDIA RTX 4050.', 'Dell XPS 15 i7 16GB 512GB', 'DLLXPS15', 7999.00, 7499.00, 6, 7, 2, '/assets/img/shop/electronics/thumbs/05.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(7, 'ASUS ROG Strix G16', 'asus-rog-strix-g16', 'ASUS ROG Strix G16 cu procesor Intel Core i7-13650HX, 16GB RAM, 1TB SSD, ecran 16 inch FHD 165Hz, NVIDIA RTX 4060.', 'ASUS ROG Strix G16 i7 RTX 4060', 'ASUSROGG16', 6999.00, NULL, 5, 7, 2, '/assets/img/shop/electronics/thumbs/14.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(8, 'iPad Pro 12.9\" M2', 'ipad-pro-12-9-m2', 'iPad Pro 12.9 inch cu procesor Apple M2, 256GB, ecran Liquid Retina XDR, suport pentru Apple Pencil 2, autonomie până la 10 ore.', 'iPad Pro 12.9\" M2 256GB', 'IPADP129M2', 6999.00, NULL, 12, 8, 2, '/assets/img/shop/electronics/thumbs/04.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(9, 'Samsung Galaxy Tab S9 Ultra', 'samsung-galaxy-tab-s9-ultra', 'Samsung Galaxy Tab S9 Ultra cu ecran Dynamic AMOLED 2X de 14.6 inci, procesor Snapdragon 8 Gen 2, S Pen inclus, rezistență la apă IP68.', 'Galaxy Tab S9 Ultra 256GB', 'SGTABS9U', 5999.00, 5499.00, 8, 8, 1, '/assets/img/shop/electronics/thumbs/15.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(10, 'AirPods Pro 2', 'airpods-pro-2', 'AirPods Pro 2 cu cancelare activă a zgomotului, audio spațial, rezistență la apă IPX4, autonomie până la 6 ore, cazul cu încărcare wireless.', 'AirPods Pro 2 - Alb', 'APDPRO2', 1499.00, 1299.00, 30, 9, 3, '/assets/img/shop/electronics/thumbs/06.png', NULL, 1, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(11, 'Sony WH-1000XM5', 'sony-wh-1000xm5', 'Căști Sony WH-1000XM5 cu cancelare activă a zgomotului, audio Hi-Res, autonomie 30h, încărcare rapidă 3 minute = 3 ore.', 'Sony WH-1000XM5 - Negru', 'SNYWH1000XM5', 2299.00, 1999.00, 18, 9, 3, '/assets/img/shop/electronics/thumbs/09.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(12, 'Logitech MX Master 3S', 'logitech-mx-master-3s', 'Mouse wireless Logitech MX Master 3S cu tracking precis Darkfield 8K DPI, 7 butoane programabile, autonomie 70 zile, încărcare USB-C.', 'Logitech MX Master 3S', 'LGTMXM3S', 699.00, NULL, 35, 9, 3, '/assets/img/shop/electronics/thumbs/10.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(13, 'Apple Magic Keyboard', 'apple-magic-keyboard', 'Tastatură wireless Apple Magic Keyboard cu layout QWERTY, baterie recarregabilă, conectare Bluetooth, design minimalist.', 'Apple Magic Keyboard - Alb', 'APLMK', 899.00, NULL, 20, 9, 3, '/assets/img/shop/electronics/thumbs/16.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(14, 'Apple Watch Series 9', 'apple-watch-series-9', 'Apple Watch Series 9 cu ecran Always-On Retina de 45mm, monitorizare sănătate avansată, GPS, rezistență la apă 50m, autonomie 18h.', 'Apple Watch Series 9 45mm', 'AW9', 2299.00, 1999.00, 22, 11, 3, '/assets/img/shop/electronics/thumbs/08.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(15, 'Samsung Galaxy Watch 6', 'samsung-galaxy-watch-6', 'Samsung Galaxy Watch 6 cu ecran AMOLED de 44mm, monitorizare sănătate, GPS, rezistență la apă 5ATM, autonomie 40h.', 'Galaxy Watch 6 44mm', 'SGW6', 1799.00, NULL, 20, 11, 3, '/assets/img/shop/electronics/thumbs/07.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(16, 'Samsung 4K Smart TV 55\"', 'samsung-4k-smart-tv-55', 'Televizor Samsung 4K Smart TV 55 inch, HDR10+, Smart Hub, compatibil cu Alexa și Google Assistant, procesor Crystal 4K.', 'Samsung 4K Smart TV 55\" QLED', 'SMTV55', 3999.00, 3499.00, 8, 10, 1, '/assets/img/shop/electronics/thumbs/11.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13'),
(17, 'LG OLED 65\" C3', 'lg-oled-65-c3', 'Televizor LG OLED 65 inch C3, 4K HDR, procesor α9 Gen6 AI, webOS 23, Dolby Vision IQ, compatibil cu Google Assistant.', 'LG OLED 65\" C3', 'LGOLED65C3', 6999.00, 6499.00, 5, 10, 1, '/assets/img/shop/electronics/thumbs/17.png', NULL, 0, 0, 0, 1, '2025-11-30 01:59:13', '2025-11-30 01:59:13');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `rating` int(1) NOT NULL CHECK (`rating` >= 1 and `rating` <= 5),
  `title` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `is_approved` tinyint(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `user_id`, `product_id`, `order_id`, `rating`, `title`, `comment`, `is_approved`, `created_at`) VALUES
(1, 1, 1, NULL, 5, 'Excelent telefon!', 'Telefonul este foarte bun, camerele sunt excelente și performanța este impecabilă. Recomand cu căldură!', 1, '2025-11-30 01:59:13'),
(2, 2, 5, 2, 5, 'MacBook perfect', 'Laptopul este rapid, ecranul este minunat și bateria ține mult. Foarte mulțumită de achiziție!', 1, '2025-11-30 01:59:13'),
(3, 1, 10, 1, 4, 'Bune căști', 'Căștile sunt bune, cancelarea zgomotului funcționează bine. Singurul minus este prețul puțin ridicat.', 1, '2025-11-30 01:59:13'),
(4, 2, 14, NULL, 5, 'Apple Watch excelent', 'Ceasul este perfect pentru monitorizarea sănătății și notificările. Recomand cu căldură!', 1, '2025-11-30 01:59:13'),
(5, 3, 5, 3, 5, 'Excelent pentru business', 'Laptopul este perfect pentru lucru, performanță excelentă și design profesional.', 1, '2025-11-30 01:59:13');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `contact_person`, `email`, `phone`, `address`, `created_at`) VALUES
(1, 'TechSupplier SRL', 'Ion Popescu', 'contact@techsupplier.ro', '0721234567', 'București, Str. Exemplu, Nr. 1', '2025-11-30 01:59:12'),
(2, 'ElectroDist SRL', 'Maria Ionescu', 'contact@electrodist.ro', '0722345678', 'Cluj-Napoca, Str. Test, Nr. 2', '2025-11-30 01:59:12'),
(3, 'GadgetPro SRL', 'Gheorghe Georgescu', 'contact@gadgetpro.ro', '0723456789', 'Timișoara, Str. Demo, Nr. 3', '2025-11-30 01:59:12'),
(4, 'FashionLine SRL', 'Ana Dumitrescu', 'contact@fashionline.ro', '0724567890', 'Iași, Str. Moda, Nr. 4', '2025-11-30 01:59:12');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `cnp` varchar(13) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `cui` varchar(20) DEFAULT NULL,
  `reg_com` varchar(50) DEFAULT NULL,
  `bank_account` varchar(50) DEFAULT NULL,
  `default_order_type` enum('physical','legal') DEFAULT 'physical',
  `loyalty_points` int(11) DEFAULT 0,
  `b2b_group_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_login` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `password`, `phone`, `cnp`, `company_name`, `cui`, `reg_com`, `bank_account`, `default_order_type`, `loyalty_points`, `b2b_group_id`, `created_at`, `updated_at`, `last_login`) VALUES
(1, 'Ion', 'Popescu', 'ion.popescu@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '0721234567', NULL, NULL, NULL, NULL, NULL, 'physical', 500, NULL, '2025-11-30 01:59:13', '2025-11-30 01:59:13', NULL),
(2, 'Maria', 'Ionescu', 'maria.ionescu@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '0722345678', NULL, NULL, NULL, NULL, NULL, 'physical', 1200, NULL, '2025-11-30 01:59:13', '2025-11-30 01:59:13', NULL),
(3, 'Gheorghe', 'Georgescu', 'gheorghe.georgescu@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '0723456789', '1234567890123', 'TechBusiness SRL', 'RO12345678', 'J40/1234/2020', 'RO12BANK123456789', 'legal', 2500, NULL, '2025-11-30 01:59:13', '2025-11-30 01:59:13', NULL),
(4, 'Ana', 'Marinescu', 'ana.marinescu@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '0724567890', NULL, NULL, NULL, NULL, NULL, 'physical', 800, NULL, '2025-11-30 01:59:13', '2025-11-30 01:59:13', NULL),
(5, 'Petru', 'Constantinescu', 'petru.constantinescu@example.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '0725678901', '2345678901234', 'ElectroDist SRL', 'RO23456789', 'J12/5678/2021', 'RO34BANK234567890', 'legal', 3500, NULL, '2025-11-30 01:59:13', '2025-11-30 01:59:13', NULL);

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wishlist`
--

INSERT INTO `wishlist` (`id`, `user_id`, `product_id`, `created_at`) VALUES
(1, 1, 2, '2025-11-30 01:59:13'),
(2, 1, 8, '2025-11-30 01:59:13'),
(3, 2, 1, '2025-11-30 01:59:13'),
(4, 2, 5, '2025-11-30 01:59:13'),
(5, 3, 16, '2025-11-30 01:59:13'),
(6, 4, 14, '2025-11-30 01:59:13'),
(7, 1, 1, '2025-11-30 02:32:02'),
(8, 1, 4, '2025-11-30 12:44:34');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abandoned_cart_emails`
--
ALTER TABLE `abandoned_cart_emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cart` (`cart_id`);

--
-- Indexes for table `addresses`
--
ALTER TABLE `addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_username` (`username`);

--
-- Indexes for table `b2b_groups`
--
ALTER TABLE `b2b_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_active` (`is_active`);

--
-- Indexes for table `b2b_group_users`
--
ALTER TABLE `b2b_group_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_group` (`user_id`,`b2b_group_id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_group` (`b2b_group_id`);

--
-- Indexes for table `b2b_product_prices`
--
ALTER TABLE `b2b_product_prices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_product` (`user_id`,`product_id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_product` (`product_id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_session` (`session_id`);

--
-- Indexes for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_cart_product` (`cart_id`,`product_id`),
  ADD KEY `idx_cart` (`cart_id`),
  ADD KEY `idx_product` (`product_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `idx_parent` (`parent_id`),
  ADD KEY `idx_position` (`position`),
  ADD KEY `idx_active` (`is_active`),
  ADD KEY `idx_show_in_menu` (`show_in_menu`);

--
-- Indexes for table `category_promo_cards`
--
ALTER TABLE `category_promo_cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_category` (`category_id`),
  ADD KEY `idx_active` (`is_active`),
  ADD KEY `idx_position` (`position`);

--
-- Indexes for table `category_settings`
--
ALTER TABLE `category_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `idx_code` (`code`),
  ADD KEY `idx_active` (`is_active`);

--
-- Indexes for table `gift_products`
--
ALTER TABLE `gift_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_buy_product` (`buy_product_id`),
  ADD KEY `idx_gift_product` (`gift_product_id`),
  ADD KEY `idx_active` (`is_active`);

--
-- Indexes for table `import_export_logs`
--
ALTER TABLE `import_export_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_admin` (`admin_id`),
  ADD KEY `idx_type` (`type`);

--
-- Indexes for table `loyalty_points`
--
ALTER TABLE `loyalty_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_order` (`order_id`),
  ADD KEY `idx_type` (`type`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_number` (`order_number`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_order_number` (`order_number`),
  ADD KEY `idx_status` (`order_status`),
  ADD KEY `idx_payment_status` (`payment_status`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `billing_address_id` (`billing_address_id`),
  ADD KEY `shipping_address_id` (`shipping_address_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order` (`order_id`),
  ADD KEY `idx_product` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD UNIQUE KEY `sku` (`sku`),
  ADD KEY `idx_category` (`category_id`),
  ADD KEY `idx_supplier` (`supplier_id`),
  ADD KEY `idx_slug` (`slug`),
  ADD KEY `idx_active` (`is_active`),
  ADD KEY `idx_featured` (`is_featured`,`featured_order`),
  ADD KEY `idx_sku` (`sku`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_product` (`product_id`),
  ADD KEY `idx_order` (`order_id`),
  ADD KEY `idx_approved` (`is_approved`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_b2b_group` (`b2b_group_id`);

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_product` (`user_id`,`product_id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_product` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abandoned_cart_emails`
--
ALTER TABLE `abandoned_cart_emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `addresses`
--
ALTER TABLE `addresses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `b2b_groups`
--
ALTER TABLE `b2b_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `b2b_group_users`
--
ALTER TABLE `b2b_group_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `b2b_product_prices`
--
ALTER TABLE `b2b_product_prices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `cart_items`
--
ALTER TABLE `cart_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=231;

--
-- AUTO_INCREMENT for table `category_promo_cards`
--
ALTER TABLE `category_promo_cards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `category_settings`
--
ALTER TABLE `category_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `gift_products`
--
ALTER TABLE `gift_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `import_export_logs`
--
ALTER TABLE `import_export_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loyalty_points`
--
ALTER TABLE `loyalty_points`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `abandoned_cart_emails`
--
ALTER TABLE `abandoned_cart_emails`
  ADD CONSTRAINT `abandoned_cart_emails_ibfk_1` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `addresses`
--
ALTER TABLE `addresses`
  ADD CONSTRAINT `addresses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `b2b_group_users`
--
ALTER TABLE `b2b_group_users`
  ADD CONSTRAINT `b2b_group_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `b2b_group_users_ibfk_2` FOREIGN KEY (`b2b_group_id`) REFERENCES `b2b_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `b2b_product_prices`
--
ALTER TABLE `b2b_product_prices`
  ADD CONSTRAINT `b2b_product_prices_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `b2b_product_prices_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cart`
--
ALTER TABLE `cart`
  ADD CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD CONSTRAINT `cart_items_ibfk_1` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `fk_categories_parent` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `category_promo_cards`
--
ALTER TABLE `category_promo_cards`
  ADD CONSTRAINT `fk_promo_cards_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `gift_products`
--
ALTER TABLE `gift_products`
  ADD CONSTRAINT `gift_products_ibfk_1` FOREIGN KEY (`buy_product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `gift_products_ibfk_2` FOREIGN KEY (`gift_product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `import_export_logs`
--
ALTER TABLE `import_export_logs`
  ADD CONSTRAINT `import_export_logs_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `loyalty_points`
--
ALTER TABLE `loyalty_points`
  ADD CONSTRAINT `loyalty_points_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `loyalty_points_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`billing_address_id`) REFERENCES `addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_ibfk_3` FOREIGN KEY (`shipping_address_id`) REFERENCES `addresses` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_ibfk_3` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD CONSTRAINT `wishlist_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlist_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
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 */;
