-- Generated from C:\wamp64\www\shaa_jewels\one_gram_gold_categories_full_seo.xlsx by database/scripts/xlsx_to_categories_sql.php
-- mysql dbname < database/categories.sql

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(500) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`),
  KEY `categories_slug_index` (`slug`),
  KEY `categories_parent_id_index` (`parent_id`),
  KEY `idx_categories_parent_active` (`parent_id`,`is_active`),
  KEY `idx_categories_active_sort` (`is_active`,`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `categories` (`id`, `parent_id`, `name`, `slug`, `description`, `meta_title`, `meta_description`, `image_path`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Neckwear', 'neckwear', NULL, 'Neckwear One Gram Gold Jewellery', 'Neckwear categories: Short Necklaces, Long Haram, Chokers, Pendant Sets, Layered Chains, Mangalsutra', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(2, NULL, 'Earrings', 'earrings', NULL, 'Earrings One Gram Gold Jewellery', 'Earrings categories: Studs, Jhumkas, Drops & Danglers, Chandbalis', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(3, NULL, 'Bangles & Bracelets', 'bangles-bracelets', NULL, 'Bangles & Bracelets One Gram Gold Jewellery', 'Bangles & Bracelets categories: Plain Bangles, Stone Bangles, Kadas, Bracelets', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(4, NULL, 'Rings', 'rings', NULL, 'Rings One Gram Gold Jewellery', 'Rings categories: Adjustable Rings, Stone Rings, Cocktail Rings', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(5, NULL, 'Bridal Collection', 'bridal-collection', NULL, 'Bridal Collection One Gram Gold Jewellery', 'Bridal Collection categories: Full Bridal Sets, Temple Jewellery Sets, Wedding Combo Packs', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(6, NULL, 'Temple Jewellery', 'temple-jewellery', NULL, 'Temple Jewellery One Gram Gold Jewellery', 'Temple Jewellery categories: Lakshmi Design Sets, Kasu Mala, Antique Haram', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(7, NULL, 'Men Collection', 'men-collection', NULL, 'Men Collection One Gram Gold Jewellery', 'Men Collection categories: Chains, Bracelets, Kadas, Rings, Pendants', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(8, NULL, 'Kids Jewellery', 'kids-jewellery', NULL, 'Kids Jewellery One Gram Gold Jewellery', 'Kids Jewellery categories: Necklace Sets, Bangles, Earrings', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(9, NULL, 'Hair Accessories', 'hair-accessories', NULL, 'Hair Accessories One Gram Gold Jewellery', 'Hair Accessories categories: Maang Tikka, Jadanagam, Hair Clips', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(10, NULL, 'Combo Sets', 'combo-sets', NULL, 'Combo Sets One Gram Gold Jewellery', 'Combo Sets categories: Necklace + Earrings, Full Combo Sets, Budget Combos', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(11, 1, 'Short Necklaces', 'neckwear-short-necklaces', 'Explore short necklaces in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Short Necklaces Online | One Gram Gold Jewellery', 'Shop latest short necklaces in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(12, 1, 'Long Haram', 'neckwear-long-haram', 'Explore long haram in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Long Haram Online | One Gram Gold Jewellery', 'Shop latest long haram in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(13, 1, 'Chokers', 'neckwear-chokers', 'Explore chokers in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Chokers Online | One Gram Gold Jewellery', 'Shop latest chokers in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(14, 1, 'Pendant Sets', 'neckwear-pendant-sets', 'Explore pendant sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Pendant Sets Online | One Gram Gold Jewellery', 'Shop latest pendant sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(15, 1, 'Layered Chains', 'neckwear-layered-chains', 'Explore layered chains in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Layered Chains Online | One Gram Gold Jewellery', 'Shop latest layered chains in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(16, 1, 'Mangalsutra', 'neckwear-mangalsutra', 'Explore mangalsutra in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Mangalsutra Online | One Gram Gold Jewellery', 'Shop latest mangalsutra in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(17, 2, 'Studs', 'earrings-studs', 'Explore studs in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Studs Online | One Gram Gold Jewellery', 'Shop latest studs in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(18, 2, 'Jhumkas', 'earrings-jhumkas', 'Explore jhumkas in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Jhumkas Online | One Gram Gold Jewellery', 'Shop latest jhumkas in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(19, 2, 'Drops & Danglers', 'earrings-drops-danglers', 'Explore drops & danglers in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Drops & Danglers Online | One Gram Gold Jewellery', 'Shop latest drops & danglers in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(20, 2, 'Chandbalis', 'earrings-chandbalis', 'Explore chandbalis in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Chandbalis Online | One Gram Gold Jewellery', 'Shop latest chandbalis in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(21, 3, 'Plain Bangles', 'bangles-bracelets-plain-bangles', 'Explore plain bangles in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Plain Bangles Online | One Gram Gold Jewellery', 'Shop latest plain bangles in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(22, 3, 'Stone Bangles', 'bangles-bracelets-stone-bangles', 'Explore stone bangles in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Stone Bangles Online | One Gram Gold Jewellery', 'Shop latest stone bangles in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(23, 3, 'Kadas', 'bangles-bracelets-kadas', 'Explore kadas in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Kadas Online | One Gram Gold Jewellery', 'Shop latest kadas in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(24, 3, 'Bracelets', 'bangles-bracelets-bracelets', 'Explore bracelets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Bracelets Online | One Gram Gold Jewellery', 'Shop latest bracelets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(25, 4, 'Adjustable Rings', 'rings-adjustable-rings', 'Explore adjustable rings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Adjustable Rings Online | One Gram Gold Jewellery', 'Shop latest adjustable rings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(26, 4, 'Stone Rings', 'rings-stone-rings', 'Explore stone rings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Stone Rings Online | One Gram Gold Jewellery', 'Shop latest stone rings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(27, 4, 'Cocktail Rings', 'rings-cocktail-rings', 'Explore cocktail rings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Cocktail Rings Online | One Gram Gold Jewellery', 'Shop latest cocktail rings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(28, 5, 'Full Bridal Sets', 'bridal-collection-full-bridal-sets', 'Explore full bridal sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Full Bridal Sets Online | One Gram Gold Jewellery', 'Shop latest full bridal sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(29, 5, 'Temple Jewellery Sets', 'bridal-collection-temple-jewellery-sets', 'Explore temple jewellery sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Temple Jewellery Sets Online | One Gram Gold Jewellery', 'Shop latest temple jewellery sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(30, 5, 'Wedding Combo Packs', 'bridal-collection-wedding-combo-packs', 'Explore wedding combo packs in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Wedding Combo Packs Online | One Gram Gold Jewellery', 'Shop latest wedding combo packs in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(31, 6, 'Lakshmi Design Sets', 'temple-jewellery-lakshmi-design-sets', 'Explore lakshmi design sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Lakshmi Design Sets Online | One Gram Gold Jewellery', 'Shop latest lakshmi design sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(32, 6, 'Kasu Mala', 'temple-jewellery-kasu-mala', 'Explore kasu mala in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Kasu Mala Online | One Gram Gold Jewellery', 'Shop latest kasu mala in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(33, 6, 'Antique Haram', 'temple-jewellery-antique-haram', 'Explore antique haram in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Antique Haram Online | One Gram Gold Jewellery', 'Shop latest antique haram in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(34, 7, 'Chains', 'men-collection-chains', 'Explore chains in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Chains Online | One Gram Gold Jewellery', 'Shop latest chains in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(35, 7, 'Bracelets', 'men-collection-bracelets', 'Explore bracelets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Bracelets Online | One Gram Gold Jewellery', 'Shop latest bracelets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(36, 7, 'Kadas', 'men-collection-kadas', 'Explore kadas in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Kadas Online | One Gram Gold Jewellery', 'Shop latest kadas in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(37, 7, 'Rings', 'men-collection-rings', 'Explore rings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Rings Online | One Gram Gold Jewellery', 'Shop latest rings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(38, 7, 'Pendants', 'men-collection-pendants', 'Explore pendants in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Pendants Online | One Gram Gold Jewellery', 'Shop latest pendants in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(39, 8, 'Necklace Sets', 'kids-jewellery-necklace-sets', 'Explore necklace sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Necklace Sets Online | One Gram Gold Jewellery', 'Shop latest necklace sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(40, 8, 'Bangles', 'kids-jewellery-bangles', 'Explore bangles in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Bangles Online | One Gram Gold Jewellery', 'Shop latest bangles in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(41, 8, 'Earrings', 'kids-jewellery-earrings', 'Explore earrings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Earrings Online | One Gram Gold Jewellery', 'Shop latest earrings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(42, 9, 'Maang Tikka', 'hair-accessories-maang-tikka', 'Explore maang tikka in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Maang Tikka Online | One Gram Gold Jewellery', 'Shop latest maang tikka in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(43, 9, 'Jadanagam', 'hair-accessories-jadanagam', 'Explore jadanagam in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Jadanagam Online | One Gram Gold Jewellery', 'Shop latest jadanagam in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(44, 9, 'Hair Clips', 'hair-accessories-hair-clips', 'Explore hair clips in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Hair Clips Online | One Gram Gold Jewellery', 'Shop latest hair clips in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(45, 10, 'Necklace + Earrings', 'combo-sets-necklace-earrings', 'Explore necklace + earrings in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Necklace + Earrings Online | One Gram Gold Jewellery', 'Shop latest necklace + earrings in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(46, 10, 'Full Combo Sets', 'combo-sets-full-combo-sets', 'Explore full combo sets in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Full Combo Sets Online | One Gram Gold Jewellery', 'Shop latest full combo sets in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55'),
(47, 10, 'Budget Combos', 'combo-sets-budget-combos', 'Explore budget combos in one gram gold and imitation jewellery. Stylish, affordable and perfect for all occasions.', 'Buy Budget Combos Online | One Gram Gold Jewellery', 'Shop latest budget combos in one gram gold jewellery. Best price, trendy designs, perfect for daily and bridal wear.', NULL, 1, 0, '2026-03-26 09:13:55', '2026-03-26 09:13:55');

SET FOREIGN_KEY_CHECKS = 1;
