-- Generated from database/categories.csv by database/scripts/csv_to_categories_sql.php
-- Run this file to create/truncate categories and load data (e.g. 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,
  `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`, `image_path`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Accessories', 'accessories', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(2, NULL, 'Bangles', 'bangles', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(3, NULL, 'Beeds', 'beeds', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(4, NULL, 'Bridal Sets', 'bridal-sets', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(5, NULL, 'Earrings', 'earrings', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(6, NULL, 'Kumkum Barina', 'kumkum-barina', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(7, NULL, 'Mangalasutras', 'mangalasutras', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(8, NULL, 'Necklaces', 'necklaces', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(9, NULL, 'Victorian', 'victorian', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(10, 8, 'Bajubands', 'bajubands', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(11, 8, 'Bracelets', 'bracelets', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(12, 8, 'BUGADI', 'bugadi', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(13, 8, 'Chains', 'chains', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(14, 8, 'Chandbalis', 'chandbalis', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(15, 8, 'Chokers', 'chokers', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(16, 8, 'Chotis', 'chotis', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(17, 8, 'Combo Sets', 'combo-sets', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(18, 8, 'EAR CUFFS', 'ear-cuffs', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(19, 8, 'GJ Earrings', 'gj-earrings', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(20, 8, 'Guttapoosalu', 'guttapoosalu', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(21, 8, 'Hangings', 'hangings', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(22, 8, 'Jhumkas', 'jhumkas', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(23, 8, 'Kadas', 'kadas', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(24, 8, 'Kundhan', 'kundhan', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(25, 8, 'Layers', 'layers', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(26, 8, 'Long Ganga Jemuna', 'long-ganga-jemuna', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(27, 8, 'Long Gold Finish', 'long-gold-finish', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(28, 8, 'Long Haar', 'long-haar', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(29, 8, 'Long mangalasutras', 'long-mangalasutras', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(30, 8, 'Long Mehandi-Kundhan', 'long-mehandi-kundhan', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(31, 8, 'Long Nakshi', 'long-nakshi', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(32, 8, 'Long necklaces', 'long-necklaces', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(33, 8, 'Matils', 'matils', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(34, 8, 'MURUGULU', 'murugulu', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(35, 8, 'Nose pins', 'nose-pins', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(36, 8, 'Payals', 'payals', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(37, 8, 'Pendants', 'pendants', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(38, 8, 'Rings', 'rings', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(39, 8, 'Saree Pins', 'saree-pins', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(40, 8, 'Short Ganga Jemuna', 'short-ganga-jemuna', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(41, 8, 'Short Gold Finish', 'short-gold-finish', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(42, 8, 'Short mangalasutras', 'short-mangalasutras', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(43, 8, 'Short Mehandi-Kundhan', 'short-mehandi-kundhan', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(44, 8, 'Short Nakshi', 'short-nakshi', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(45, 8, 'Short necklaces', 'short-necklaces', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(46, 8, 'Single line  mangalasutras', 'single-line-mangalasutras', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(47, 8, 'Studs & tops', 'studs-tops', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(48, 8, 'Sutra', 'sutra', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(49, 8, 'Tally Chains', 'tally-chains', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(50, 8, 'Tikkas', 'tikkas', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(51, 8, 'Toe Rings', 'toe-rings', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(52, 8, 'Victorian Earrings', 'victorian-earrings', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(53, 8, 'Waist Belts', 'waist-belts', NULL, 1, 1, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(54, 8, 'Bottu Mala', 'bottu-mala', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(55, 8, 'Cz Stone', 'cz-stone', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(56, 8, 'Butterfly', 'butterfly', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(57, 8, 'Laxmi', 'laxmi', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(58, 8, 'Flower Design', 'flower-design', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(59, 8, 'Kotta Stone', 'kotta-stone', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(60, 8, 'Mango', 'mango', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(61, 8, 'Fancy', 'fancy', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(62, 8, 'Leaf Design', 'leaf-design', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(63, 8, 'Changable', 'changable', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(64, 8, 'Leaves', 'leaves', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(65, 8, 'Laxmilocket', 'laxmilocket', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(66, 8, 'Fancy Kante', 'fancy-kante', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(67, 8, 'Neck Round', 'neck-round', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(68, 8, 'White Pearls', 'white-pearls', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(69, 8, 'Gold Finish', 'gold-finish', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(70, 8, 'Peacock', 'peacock', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(71, 8, 'Cz Neck', 'cz-neck', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(72, 8, 'Ruby Neck', 'ruby-neck', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(73, 8, 'Gold Neck', 'gold-neck', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(74, 8, 'Coral Neck', 'coral-neck', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(75, 8, 'Kante Neck', 'kante-neck', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(76, 8, 'Fancy Cz Stone', 'fancy-cz-stone', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(77, 8, 'Guttapusalu', 'guttapusalu', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(78, 8, 'Traditional', 'traditional', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(79, 8, 'Kante Laxmi', 'kante-laxmi', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(80, 8, 'Kante', 'kante', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(81, 8, 'Kids Chowker', 'kids-chowker', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(82, 8, 'Nan Patti', 'nan-patti', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(83, 8, 'All Together', 'all-together', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(84, 8, 'Czstone', 'czstone', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(85, 8, 'Gj Polish', 'gj-polish', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(86, 8, 'Gjpolish', 'gjpolish', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(87, 8, 'Ruby', 'ruby', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(88, 8, 'Silver', 'silver', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(89, 8, 'Nanpatti', 'nanpatti', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(90, 8, 'Nakshi', 'nakshi', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(91, 8, 'Kota Stone', 'kota-stone', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(92, 8, 'Pulse', 'pulse', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(93, 8, 'Pulse 3 Lines', 'pulse-3-lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(94, 8, 'Beads', 'beads', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(95, 8, 'Chandraharam', 'chandraharam', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(96, 8, 'Monalisa Beads', 'monalisa-beads', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(97, 8, 'Elephant', 'elephant', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(98, 8, 'Laxmi Kasu', 'laxmi-kasu', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(99, 8, 'Silver Lines', 'silver-lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(100, 8, 'Jadav Kundhan', 'jadav-kundhan', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(101, 8, 'One Locket', 'one-locket', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(102, 8, 'Big Plane', 'big-plane', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(103, 8, 'Medium Plane', 'medium-plane', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(104, 8, 'Kasu', 'kasu', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(105, 8, 'Shanka Mala', 'shanka-mala', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(106, 8, 'Muvvala Haram', 'muvvala-haram', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(107, 8, 'Tiger Nail', 'tiger-nail', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(108, 8, 'Gold Model', 'gold-model', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(109, 8, 'String', 'string', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(110, 8, 'Gold Polish', 'gold-polish', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(111, 8, 'Matte Finish', 'matte-finish', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(112, 8, 'Lotus', 'lotus', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(113, 8, 'Chand Bali', 'chand-bali', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(114, 8, 'Gold', 'gold', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(115, 8, '2 Peacock', '2-peacock', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(116, 8, '2 Line Lotus', '2-line-lotus', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(117, 8, 'J Type', 'j-type', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(118, 8, 'Flower', 'flower', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(119, 8, '3 Star', '3-star', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(120, 8, '3 Lines', '3-lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(121, 8, '7 Star', '7-star', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(122, 8, '2 Lines', '2-lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(123, 8, '2Lines', '2lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(124, 8, '1Lines', '1lines', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27'),
(125, 8, '5 Stars', '5-stars', NULL, 1, 0, '2026-02-02 18:02:27', '2026-02-02 18:02:27');

SET FOREIGN_KEY_CHECKS = 1;
