CREATE TABLE IF NOT EXISTS `ai_classification_settings` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ai_assistant_id` bigint(20) UNSIGNED NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `categories` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ai_classification_settings_ai_assistant_id_index` (`ai_assistant_id`),
  CONSTRAINT `ai_classification_settings_ai_assistant_id_foreign` FOREIGN KEY (`ai_assistant_id`) REFERENCES `ai_assistants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
