-- ── shop_categories ──────────────────────────────────────────
CREATE TABLE IF NOT EXISTS `shop_categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL UNIQUE,
  `emoji` varchar(10) NOT NULL DEFAULT '📦',
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO `shop_categories` (`name`,`emoji`,`is_active`,`sort_order`,`created_at`,`updated_at`) VALUES
('Networking',  '📡', 1, 1, NOW(), NOW()),
('Cables',      '🔌', 1, 2, NOW(), NOW()),
('Accessories', '🎧', 1, 3, NOW(), NOW()),
('Security',    '📷', 1, 4, NOW(), NOW());
