-- ============================================================
-- Migration: old_versions -> new_versions
-- Generated: 2026-07-14 11:54:26
-- Safe migration: No DROP, TRUNCATE, or DELETE statements
-- ============================================================

SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';

-- ============================================================
-- SECTION 1: Create New Tables (IF NOT EXISTS)
-- ============================================================

-- Table: clic23_cache
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_cache_locks
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_cash_categories
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cash_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_fr` varchar(255) NOT NULL,
  `name_ar` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'both',
  `is_system` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_cash_movements
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cash_movements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cash_register_id` bigint(20) unsigned NOT NULL,
  `cash_session_id` bigint(20) unsigned DEFAULT NULL,
  `cash_box_code` varchar(255) DEFAULT NULL,
  `target_cash_box_code` varchar(255) DEFAULT NULL,
  `exchange_rate_used` decimal(15,6) DEFAULT NULL,
  `converted_amount` decimal(15,2) DEFAULT NULL,
  `cash_category_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `movement_date` date NOT NULL,
  `type` varchar(255) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `observation` text DEFAULT NULL,
  `source_type` varchar(255) DEFAULT NULL,
  `source_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_cash_movements_cash_register_id_foreign` (`cash_register_id`),
  KEY `clic23_cash_movements_user_id_index` (`user_id`),
  KEY `clic23_cash_movements_source_type_source_id_index` (`source_type`,`source_id`),
  CONSTRAINT `clic23_cash_movements_cash_register_id_foreign` FOREIGN KEY (`cash_register_id`) REFERENCES `clic23_cash_registers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_cash_registers
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cash_registers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'DZD',
  `balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_cash_sessions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_cash_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cash_register_id` bigint(20) unsigned NOT NULL,
  `opened_by` bigint(20) unsigned NOT NULL,
  `closed_by` bigint(20) unsigned DEFAULT NULL,
  `opened_at` datetime NOT NULL,
  `closed_at` datetime DEFAULT NULL,
  `opening_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `expected_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `actual_balance` decimal(15,2) DEFAULT NULL,
  `variance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `notes_opening` text DEFAULT NULL,
  `notes_closing` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_cash_sessions_cash_register_id_foreign` (`cash_register_id`),
  KEY `clic23_cash_sessions_opened_by_index` (`opened_by`),
  KEY `clic23_cash_sessions_closed_by_index` (`closed_by`),
  CONSTRAINT `clic23_cash_sessions_cash_register_id_foreign` FOREIGN KEY (`cash_register_id`) REFERENCES `clic23_cash_registers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_client_commissions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_client_commissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `pricing_line_type` varchar(255) NOT NULL DEFAULT 'visa',
  `commission_type` varchar(255) NOT NULL DEFAULT 'percentage',
  `commission_value` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_client_commissions_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_failed_jobs
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_job_batches
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_jobs
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_notifications
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` text NOT NULL,
  `message` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_notifications_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_permissions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_permissions_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_purchase_items
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_purchase_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_order_id` bigint(20) unsigned NOT NULL,
  `description` varchar(255) NOT NULL,
  `item_type` varchar(255) DEFAULT NULL,
  `period_start_date` date DEFAULT NULL,
  `period_end_date` date DEFAULT NULL,
  `nights` int(10) unsigned NOT NULL DEFAULT 0,
  `quantity` int(10) unsigned NOT NULL DEFAULT 1,
  `unit_price` decimal(15,2) NOT NULL DEFAULT 0.00,
  `line_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `clic23_purchase_items_purchase_order_id_foreign` (`purchase_order_id`),
  CONSTRAINT `clic23_purchase_items_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `clic23_purchase_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_purchase_orders
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_purchase_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(255) NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `purchase_date` date NOT NULL,
  `type` varchar(255) NOT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `reservation_start_date` date DEFAULT NULL,
  `reservation_end_date` date DEFAULT NULL,
  `reservation_room_count` int(10) unsigned NOT NULL DEFAULT 0,
  `reservation_nights` int(10) unsigned NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `subtotal` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `notes` text DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_purchase_orders_number_unique` (`number`),
  KEY `clic23_purchase_orders_supplier_id_foreign` (`supplier_id`),
  KEY `clic23_purchase_orders_user_id_index` (`user_id`),
  CONSTRAINT `clic23_purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `clic23_suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_role_permissions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_role_permissions` (
  `role_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_roles
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_sessions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_sessions_user_id_index` (`user_id`),
  KEY `clic23_sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_settings
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_supplier_payments
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_supplier_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(255) NOT NULL,
  `payment_date` date NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `purchase_order_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `cash_box_code` varchar(255) DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL,
  `payment_currency` varchar(10) NOT NULL DEFAULT 'DZD',
  `exchange_rate` decimal(12,6) DEFAULT NULL,
  `exchange_amount` decimal(14,2) DEFAULT NULL,
  `payment_method` varchar(255) NOT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_supplier_payments_number_unique` (`number`),
  KEY `clic23_supplier_payments_supplier_id_foreign` (`supplier_id`),
  KEY `clic23_supplier_payments_user_id_index` (`user_id`),
  CONSTRAINT `clic23_supplier_payments_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `clic23_suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_suppliers
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `initial_balance` decimal(15,2) NOT NULL DEFAULT 0.00,
  `cash_box_code` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_ticket_priorities
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_ticket_priorities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `color` varchar(10) NOT NULL DEFAULT '#64748b',
  `icon` varchar(100) DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_guides
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_guides` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_hotels
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_hotels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT 'Algérie',
  `stars` tinyint(3) unsigned DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_package_hotels
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_package_hotels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `hotel_id` bigint(20) unsigned NOT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_package_hotels_package_id_foreign` (`package_id`),
  KEY `clic23_travel_package_hotels_hotel_id_foreign` (`hotel_id`),
  CONSTRAINT `clic23_travel_package_hotels_hotel_id_foreign` FOREIGN KEY (`hotel_id`) REFERENCES `clic23_travel_hotels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `clic23_travel_package_hotels_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `clic23_travel_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_packages
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `program_template_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `departure_date` date NOT NULL,
  `return_date` date NOT NULL,
  `nights` smallint(5) unsigned NOT NULL DEFAULT 0,
  `places_total` smallint(5) unsigned NOT NULL DEFAULT 0,
  `places_remaining` smallint(5) unsigned NOT NULL DEFAULT 0,
  `guide_id` bigint(20) unsigned DEFAULT NULL,
  `status` enum('draft','open','full','closed','cancelled') NOT NULL DEFAULT 'draft',
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_packages_program_template_id_foreign` (`program_template_id`),
  KEY `clic23_travel_packages_guide_id_foreign` (`guide_id`),
  CONSTRAINT `clic23_travel_packages_guide_id_foreign` FOREIGN KEY (`guide_id`) REFERENCES `clic23_travel_guides` (`id`) ON DELETE SET NULL,
  CONSTRAINT `clic23_travel_packages_program_template_id_foreign` FOREIGN KEY (`program_template_id`) REFERENCES `clic23_travel_program_templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_passenger_pricing_lines
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_passenger_pricing_lines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `passenger_id` bigint(20) unsigned NOT NULL,
  `pricing_line_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_passenger_pricing_lines_passenger_id_foreign` (`passenger_id`),
  KEY `clic23_travel_passenger_pricing_lines_pricing_line_id_foreign` (`pricing_line_id`),
  CONSTRAINT `clic23_travel_passenger_pricing_lines_passenger_id_foreign` FOREIGN KEY (`passenger_id`) REFERENCES `clic23_travel_passengers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `clic23_travel_passenger_pricing_lines_pricing_line_id_foreign` FOREIGN KEY (`pricing_line_id`) REFERENCES `clic23_travel_pricing_lines` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_passengers
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_passengers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `passport_number` varchar(255) DEFAULT NULL,
  `passport_document` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_passengers_reservation_id_foreign` (`reservation_id`),
  CONSTRAINT `clic23_travel_passengers_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `clic23_travel_reservations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_payments
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint(20) unsigned NOT NULL,
  `passenger_id` bigint(20) unsigned DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_date` date NOT NULL,
  `method` enum('cash','ccp','baridimob','bank_transfer','cib') NOT NULL DEFAULT 'cash',
  `reference` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `justificatif` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_payments_reservation_id_foreign` (`reservation_id`),
  KEY `clic23_travel_payments_passenger_id_foreign` (`passenger_id`),
  CONSTRAINT `clic23_travel_payments_passenger_id_foreign` FOREIGN KEY (`passenger_id`) REFERENCES `clic23_travel_passengers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `clic23_travel_payments_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `clic23_travel_reservations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_pricing_lines
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_pricing_lines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_hotel_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` enum('hebergement','visa','food','transport','insurance','other') NOT NULL DEFAULT 'hebergement',
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `commission` decimal(10,2) NOT NULL DEFAULT 0.00,
  `is_mandatory` tinyint(1) NOT NULL DEFAULT 0,
  `passengers_count` smallint(5) unsigned NOT NULL DEFAULT 1,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_pricing_lines_package_hotel_id_foreign` (`package_hotel_id`),
  CONSTRAINT `clic23_travel_pricing_lines_package_hotel_id_foreign` FOREIGN KEY (`package_hotel_id`) REFERENCES `clic23_travel_package_hotels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_program_templates
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_program_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `type` enum('omra','tour') NOT NULL DEFAULT 'tour',
  `description` text DEFAULT NULL,
  `conditions` text DEFAULT NULL,
  `included_services` text DEFAULT NULL,
  `excluded_services` text DEFAULT NULL,
  `excursions` text DEFAULT NULL,
  `program_days` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`program_days`)),
  `photos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`photos`)),
  `status` enum('active','draft') NOT NULL DEFAULT 'active',
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_travel_reservations
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_travel_reservations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `package_hotel_id` bigint(20) unsigned NOT NULL,
  `client_user_id` bigint(20) unsigned DEFAULT NULL,
  `status` enum('pending','confirmed','cancelled','in_progress') NOT NULL DEFAULT 'pending',
  `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_travel_reservations_package_id_foreign` (`package_id`),
  KEY `clic23_travel_reservations_package_hotel_id_foreign` (`package_hotel_id`),
  CONSTRAINT `clic23_travel_reservations_package_hotel_id_foreign` FOREIGN KEY (`package_hotel_id`) REFERENCES `clic23_travel_package_hotels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `clic23_travel_reservations_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `clic23_travel_packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_users
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_users` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL DEFAULT '',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(100) NOT NULL DEFAULT '',
  `remember_token` varchar(100) DEFAULT NULL,
  `token` varchar(255) NOT NULL DEFAULT '',
  `IP` varchar(500) NOT NULL DEFAULT '',
  `username` varchar(255) NOT NULL DEFAULT '',
  `first_name` varchar(255) NOT NULL DEFAULT '',
  `last_name` varchar(25) NOT NULL DEFAULT '',
  `avatar` varchar(1000) NOT NULL DEFAULT 'default.png',
  `joined` int(11) NOT NULL DEFAULT 0,
  `joined_date` varchar(10) NOT NULL DEFAULT '',
  `online_timestamp` int(11) NOT NULL DEFAULT 0,
  `oauth_provider` varchar(40) NOT NULL DEFAULT '',
  `oauth_id` varchar(1000) NOT NULL DEFAULT '',
  `oauth_token` varchar(1500) NOT NULL DEFAULT '',
  `oauth_secret` varchar(500) NOT NULL DEFAULT '',
  `email_notification` int(11) NOT NULL DEFAULT 1,
  `aboutme` varchar(1000) NOT NULL DEFAULT '',
  `points` decimal(10,2) NOT NULL DEFAULT 0.00,
  `premium_time` int(11) NOT NULL DEFAULT 0,
  `user_role` int(11) NOT NULL DEFAULT 0,
  `role_id` int(11) DEFAULT NULL,
  `client_type` enum('B2B','B2C') DEFAULT NULL,
  `premium_planid` int(11) NOT NULL DEFAULT 0,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `activate_code` varchar(255) NOT NULL DEFAULT '',
  `noti_count` int(11) NOT NULL DEFAULT 0,
  `custom_view` int(11) NOT NULL DEFAULT 0,
  `active_project` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`ID`),
  KEY `users_email_index` (`email`),
  KEY `users_role_id_index` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Table: clic23_visa_bookings
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_visa_bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_reference` varchar(30) NOT NULL,
  `visa_offer_id` bigint(20) unsigned NOT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `travel_date` date NOT NULL,
  `num_persons` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `travel_document` enum('passport','identity_card') NOT NULL DEFAULT 'passport',
  `nationality` varchar(100) DEFAULT NULL,
  `total_price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` enum('pending','processing','approved','rejected','cancelled') NOT NULL DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_visa_bookings_booking_reference_unique` (`booking_reference`),
  KEY `clic23_visa_bookings_visa_offer_id_foreign` (`visa_offer_id`),
  KEY `clic23_visa_bookings_country_id_foreign` (`country_id`),
  KEY `clic23_visa_bookings_user_id_index` (`user_id`),
  CONSTRAINT `clic23_visa_bookings_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `clic23_visa_countries` (`id`),
  CONSTRAINT `clic23_visa_bookings_visa_offer_id_foreign` FOREIGN KEY (`visa_offer_id`) REFERENCES `clic23_visa_offers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_visa_conditions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_visa_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_fr` varchar(200) NOT NULL,
  `name_ar` varchar(200) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_visa_countries
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_visa_countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_fr` varchar(100) NOT NULL,
  `name_ar` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `iso_code` varchar(4) DEFAULT NULL,
  `image` varchar(150) DEFAULT NULL COMMENT 'filename in public/assets/logo/',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clic23_visa_countries_slug_unique` (`slug`),
  UNIQUE KEY `clic23_visa_countries_iso_code_unique` (`iso_code`),
  KEY `clic23_visa_countries_iso_code_index` (`iso_code`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_visa_passengers
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_visa_passengers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `birth_place` varchar(150) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `passport_number` varchar(50) DEFAULT NULL,
  `passport_issue_date` date DEFAULT NULL,
  `passport_expiry_date` date DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `passport_file` varchar(300) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_visa_passengers_booking_id_foreign` (`booking_id`),
  CONSTRAINT `clic23_visa_passengers_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `clic23_visa_bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: clic23_visa_payments
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `clic23_visa_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` bigint(20) unsigned NOT NULL,
  `passenger_id` bigint(20) unsigned DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_date` date NOT NULL,
  `method` enum('cash','ccp','baridimob','bank_transfer','cib') NOT NULL DEFAULT 'cash',
  `reference` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `justificatif` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clic23_visa_payments_booking_id_foreign` (`booking_id`),
  CONSTRAINT `clic23_visa_payments_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `clic23_visa_bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table: client_commissions
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `client_commissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `pricing_line_type` varchar(50) NOT NULL,
  `commission_type` enum('percentage','fixed') DEFAULT 'percentage',
  `commission_value` decimal(10,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_type` (`user_id`,`pricing_line_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Table: visa_payments
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `visa_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `payment_date` date NOT NULL,
  `method` enum('cash','ccp','baridimob','bank_transfer','cib') DEFAULT 'cash',
  `reference` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ============================================================
-- SECTION 2: Add Missing Columns to Existing Tables (IF NOT EXISTS)
-- ============================================================

-- Table: clic23_announcements
ALTER TABLE `clic23_announcements` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_announcements` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_backupdb
ALTER TABLE `clic23_backupdb` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_canned_responses
ALTER TABLE `clic23_canned_responses` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_canned_responses` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_contacts
ALTER TABLE `clic23_contacts` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_contacts` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_contact_lists
ALTER TABLE `clic23_contact_lists` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_contact_lists` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_content_frontend
ALTER TABLE `clic23_content_frontend` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_content_frontend` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_countries
ALTER TABLE `clic23_countries` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_countries` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_custom_fields
ALTER TABLE `clic23_custom_fields` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_custom_fields` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_custom_statuses
ALTER TABLE `clic23_custom_statuses` ADD COLUMN IF NOT EXISTS `is_closable` tinyint(1) NOT NULL DEFAULT 0;
ALTER TABLE `clic23_custom_statuses` ADD COLUMN IF NOT EXISTS `order` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `clic23_custom_statuses` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_custom_statuses` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_custom_views
ALTER TABLE `clic23_custom_views` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_custom_views` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_documentation_projects
ALTER TABLE `clic23_documentation_projects` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_documentation_projects` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_documents
ALTER TABLE `clic23_documents` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_documents` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_document_files
ALTER TABLE `clic23_document_files` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_document_files` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_email_templates
ALTER TABLE `clic23_email_templates` ADD COLUMN IF NOT EXISTS `channel_local` tinyint(4) NOT NULL DEFAULT 1;
ALTER TABLE `clic23_email_templates` ADD COLUMN IF NOT EXISTS `channel_email` tinyint(4) NOT NULL DEFAULT 1;
ALTER TABLE `clic23_email_templates` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_email_templates` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_faq
ALTER TABLE `clic23_faq` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_faq` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_faq_categories
ALTER TABLE `clic23_faq_categories` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_faq_categories` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_home_stats
ALTER TABLE `clic23_home_stats` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_home_stats` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ipn_log
ALTER TABLE `clic23_ipn_log` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ipn_log` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ip_block
ALTER TABLE `clic23_ip_block` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ip_block` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_knowledge_articles
ALTER TABLE `clic23_knowledge_articles` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_knowledge_articles` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_knowledge_categories
ALTER TABLE `clic23_knowledge_categories` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_knowledge_categories` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_knowledge_groups
ALTER TABLE `clic23_knowledge_groups` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_knowledge_groups` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_knowledge_votes
ALTER TABLE `clic23_knowledge_votes` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_knowledge_votes` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_livechats
ALTER TABLE `clic23_livechats` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_livechats` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_livechat_notifications
ALTER TABLE `clic23_livechat_notifications` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_livechat_notifications` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_login_attempts
ALTER TABLE `clic23_login_attempts` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_login_attempts` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_password_reset
ALTER TABLE `clic23_password_reset` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_password_reset` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_payment_logs
ALTER TABLE `clic23_payment_logs` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_payment_logs` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_payment_plans
ALTER TABLE `clic23_payment_plans` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_payment_plans` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_reservationsvisa
ALTER TABLE `clic23_reservationsvisa` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_reservationsvisa` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_reset_log
ALTER TABLE `clic23_reset_log` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_reset_log` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_site_layouts
ALTER TABLE `clic23_site_layouts` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_site_layouts` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_site_settings
ALTER TABLE `clic23_site_settings` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_site_settings` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_slider_images
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `enabled` tinyint(1) NOT NULL DEFAULT 1;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `order` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `title` varchar(500) DEFAULT NULL;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `description` text DEFAULT NULL;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `show_title` tinyint(1) NOT NULL DEFAULT 1;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `show_description` tinyint(1) NOT NULL DEFAULT 1;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `show_button` tinyint(1) NOT NULL DEFAULT 0;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `button_text` varchar(100) DEFAULT NULL;
ALTER TABLE `clic23_slider_images` ADD COLUMN IF NOT EXISTS `button_url` varchar(500) DEFAULT NULL;

-- Table: clic23_tickets
ALTER TABLE `clic23_tickets` ADD COLUMN IF NOT EXISTS `priority_id` int(10) unsigned DEFAULT NULL;
ALTER TABLE `clic23_tickets` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_tickets` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_categories
ALTER TABLE `clic23_ticket_categories` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_categories` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_category_groups
ALTER TABLE `clic23_ticket_category_groups` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_category_groups` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_client_users
ALTER TABLE `clic23_ticket_client_users` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_client_users` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_custom_fields
ALTER TABLE `clic23_ticket_custom_fields` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_custom_fields` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_custom_field_cats
ALTER TABLE `clic23_ticket_custom_field_cats` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_custom_field_cats` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_files
ALTER TABLE `clic23_ticket_files` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_files` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_history
ALTER TABLE `clic23_ticket_history` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_history` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_multi_files
ALTER TABLE `clic23_ticket_multi_files` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_multi_files` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_replies
ALTER TABLE `clic23_ticket_replies` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_replies` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_ticket_user_custom_fields
ALTER TABLE `clic23_ticket_user_custom_fields` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_ticket_user_custom_fields` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_custom_fields
ALTER TABLE `clic23_user_custom_fields` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_custom_fields` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_events
ALTER TABLE `clic23_user_events` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_events` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_groups
ALTER TABLE `clic23_user_groups` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_groups` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_group_users
ALTER TABLE `clic23_user_group_users` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_group_users` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_notifications
ALTER TABLE `clic23_user_notifications` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_notifications` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_roles
ALTER TABLE `clic23_user_roles` ADD COLUMN IF NOT EXISTS `slug` varchar(100) DEFAULT NULL;
ALTER TABLE `clic23_user_roles` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_roles` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_user_role_permissions
ALTER TABLE `clic23_user_role_permissions` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_user_role_permissions` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp();

-- Table: clic23_visa_offers
ALTER TABLE `clic23_visa_offers` ADD COLUMN IF NOT EXISTS `commission` decimal(10,2) NOT NULL DEFAULT 0.00;
ALTER TABLE `clic23_visa_offers` ADD COLUMN IF NOT EXISTS `conditions` text DEFAULT NULL;
ALTER TABLE `clic23_visa_offers` ADD COLUMN IF NOT EXISTS `status` enum('active','inactive') NOT NULL DEFAULT 'active';
ALTER TABLE `clic23_visa_offers` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL;
ALTER TABLE `clic23_visa_offers` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL;

-- Table: clic23_users (missing columns: email_verified_at, name, remember_token, role_id, client_type, is_active, created_at, updated_at)
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `email_verified_at` timestamp NULL DEFAULT NULL AFTER `email`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `name` varchar(255) DEFAULT NULL AFTER `email_verified_at`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `remember_token` varchar(100) DEFAULT NULL AFTER `password`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `role_id` int(11) DEFAULT NULL AFTER `user_role`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `client_type` enum('B2B','B2C') DEFAULT NULL AFTER `role_id`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `is_active` int(11) NOT NULL DEFAULT 1 AFTER `active`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `created_at` timestamp NULL DEFAULT NULL AFTER `active_project`;
ALTER TABLE `clic23_users` ADD COLUMN IF NOT EXISTS `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() AFTER `created_at`;

-- ============================================================
-- SECTION 3: Insert New Settings Data (INSERT IGNORE)
-- ============================================================

INSERT IGNORE INTO `clic23_settings` VALUES (1,'site_name','Support Palmabooking',NULL,NULL),(2,'site_desc','<p>null</p>',NULL,'2026-06-21 02:33:34'),(3,'upload_path','uploads',NULL,NULL),(4,'upload_path_relative','uploads',NULL,NULL),(5,'google_drive_folder_id','1WoSdSM_RGHY-PSdcAqKbvqishPsygte4',NULL,NULL),(6,'site_email','admin@support.palmabooking.pro',NULL,NULL),(7,'site_logo','1782012814_site_logo.png',NULL,'2026-06-21 02:33:34'),(8,'site_frontend_logo','1782012814_site_frontend_logo.png',NULL,'2026-06-21 02:33:34'),(9,'site_footer_frontend_logo','1782012814_site_footer_frontend_logo.png',NULL,'2026-06-21 02:33:34'),(10,'register','0',NULL,NULL),(11,'disable_captcha','1',NULL,NULL),(12,'date_format','d/m/Y H:i',NULL,NULL),(13,'avatar_upload','0',NULL,NULL),(14,'file_types','pdf|docx|xlsx|pptx|rtf|doc|xls|ppt|txt|wps|sxw|jpeg|jpg|png|gif|bmp|tiff|zip|rar',NULL,NULL),(15,'twitter_consumer_key','',NULL,NULL),(16,'twitter_consumer_secret','',NULL,NULL),(17,'disable_social_login','0',NULL,NULL),(18,'facebook_app_id','',NULL,NULL),(19,'facebook_app_secret','',NULL,NULL),(20,'google_client_id','',NULL,NULL),(21,'google_client_secret','',NULL,NULL),(22,'file_size','5000',NULL,NULL),(23,'paypal_email','',NULL,NULL),(24,'paypal_currency','USD',NULL,NULL),(25,'payment_enabled','1',NULL,NULL),(26,'payment_symbol','$',NULL,NULL),(27,'global_premium','0',NULL,NULL),(28,'install','0',NULL,NULL),(29,'login_protect','1',NULL,NULL),(30,'activate_account','0',NULL,NULL),(31,'default_user_role','10',NULL,NULL),(32,'secure_login','0',NULL,NULL),(33,'stripe_secret_key','',NULL,NULL),(34,'stripe_publish_key','',NULL,NULL),(35,'enable_ticket_uploads','1',NULL,NULL),(36,'enable_ticket_guests','0',NULL,NULL),(37,'enable_ticket_edit','0',NULL,NULL),(38,'require_login','1',NULL,NULL),(39,'login_logo',NULL,NULL,NULL),(40,'protocol','1',NULL,NULL),(41,'protocol_path','support.palmabooking.pro:143',NULL,NULL),(42,'protocol_email','akouas_v@yahoo.fr',NULL,NULL),(43,'protocol_password','20JUILLET2018',NULL,NULL),(44,'ticket_title','Support Ticket PalmaBooking',NULL,NULL),(45,'title_fields_categories_data','[\n    {\n        \"field_tkt_texte\": \"Demande MDF-TKT- PNR\",\n        \"field_tkt_id\": \"5\",\n        \"field_tkt_category_ids\": [\n            \"16\"\n        ]\n    }\n]',NULL,NULL),(46,'protocol_ssl','1',NULL,NULL),(47,'ticket_rating','1',NULL,NULL),(48,'notes','<p>null</p>',NULL,'2026-06-21 02:33:34'),(49,'google_recaptcha','0',NULL,NULL),(50,'google_recaptcha_secret','null',NULL,'2026-06-21 02:32:46'),(51,'google_recaptcha_key','null',NULL,'2026-06-21 02:32:46'),(52,'logo_option','1',NULL,NULL),(53,'avatar_height','100',NULL,NULL),(54,'avatar_width','100',NULL,NULL),(55,'default_category','14',NULL,NULL),(56,'checkout2_accountno','0',NULL,NULL),(57,'checkout2_secret','',NULL,NULL),(58,'layout','layout/themes/clicngo_layout.php',NULL,NULL),(59,'imap_ticket_string','## Ticket ID:',NULL,NULL),(60,'imap_reply_string','## - REPLY ABOVE THIS LINE - ##',NULL,NULL),(61,'captcha_ticket','0',NULL,NULL),(62,'envato_personal_token','',NULL,NULL),(63,'cache_time','360',NULL,NULL),(64,'ticket_note_close','1',NULL,NULL),(65,'default_status','1',NULL,NULL),(66,'close_ticket_reply','0',NULL,NULL),(67,'disable_cert','0',NULL,NULL),(68,'staff_status','2',NULL,NULL),(69,'client_status','6',NULL,NULL),(70,'public_tickets','0',NULL,NULL),(71,'enable_knowledge','1',NULL,NULL),(72,'enable_faq','1',NULL,NULL),(73,'logo_height','50',NULL,NULL),(74,'logo_width','150',NULL,NULL),(75,'enable_documentation','1',NULL,NULL),(76,'resize_avatar','1',NULL,NULL),(77,'alert_users','null',NULL,'2026-06-21 02:32:46'),(78,'send_mail_by_category','[\n    {\n        \"send_mail_by_category\": \"akouas_v@yahoo.fr\",\n        \"emails_category_ids\": [\n            \"14\",\n            \"16\",\n            \"17\",\n            \"20\",\n            \"22\",\n            \"23\",\n            \"27\",\n            \"28\",\n            \"39\"\n        ]\n    },\n    {\n        \"send_mail_by_category\": \"hamzachaffai125@gmail.com\",\n        \"emails_category_ids\": []\n    },\n    {\n        \"send_mail_by_category\": \"houssamdibi1@gmail.com\",\n        \"emails_category_ids\": [\n            \"28\",\n            \"39\"\n        ]\n    },\n    {\n        \"send_mail_by_category\": \"palmabookingb2b@gmail.com\",\n        \"emails_category_ids\": []\n    },\n    {\n        \"send_mail_by_category\": \"houssamdibi1@gmail.com\",\n        \"emails_category_ids\": [\n            \"14\"\n        ]\n    }\n]',NULL,NULL),(79,'price_per_ticket','0.00',NULL,NULL),(80,'google_drive_client','384258166417-cjb2afqj7kuv752mck8cvsnb1j23qsld.apps.googleusercontent.com',NULL,NULL),(81,'google_drive_secret','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',NULL,NULL),(82,'google_drive_access_token','{\"access_token\":\"ya29.a0AT3oNZ9jmJqMhlUjo-THBmv8DnzjbtFYMYzO_2Hegugu9UJ1viBoUFmPIic6NV2X8uXsoPmN_kAxDQmqrIvE9OndxpghCvczTqN5ha7YYYsOmlkMUHB-OgWvd-4CZqINWYgN8PK7zgj4xnshpY6C2IzoZHOYLBvENb5UyltzOE442V6aTQb1b2Ff9WuyJkrlTe7b4BFZkAaCgYKAQISARcSFQHGX2Mi3PwbQABcyYsBENvkK4XdVA0209\",\"expires_in\":3599,\"scope\":\"https:\\/\\/www.googleapis.com\\/auth\\/drive\",\"token_type\":\"Bearer\",\"created\":1781945088,\"refresh_token\":\"1\\/\\/03Vq9Q9lEx89pCgYIARAAGAMSNwF-L9IrSHc0kX586FWOOIqi_OjjsMaBhNSGYFn1PT6kWlwxREL0oaLh_RVRbRT1FbyOmj1VClI\"}',NULL,NULL),(83,'order_tickets','ASC',NULL,'2026-06-21 02:32:46'),(84,'panneau_administration','http://www.palmabooking.pro',NULL,NULL),(85,'status_ticket_first_agent_response','2',NULL,NULL),(86,'status_opened_ticket_firset_time','2',NULL,NULL),(87,'sho_default_fealds_of_cat_id','20',NULL,NULL),(88,'primary_color','#dd1671',NULL,NULL),(89,'second_color','#48565f',NULL,NULL),(90,'secondary_color','#48565f',NULL,NULL),(91,'user_to_chats_roles_ids','7,8,9,11',NULL,NULL),(92,'is_chat_enable','1',NULL,NULL),(93,'fast_links','[{\"title\":\"amadeus\",\"url\":\"https:\\/\\/www.sellingplatformconnect.amadeus.com\\/login\\/\",\"icon\":\"public\",\"client_visible\":\"yes\"},{\"title\":\"amadeus\",\"url\":\"https:\\/\\/www.sellingplatformconnect.amadeus.com\\/login\\/\",\"icon\":\"flight\",\"client_visible\":\"no\"}]',NULL,'2026-07-14 09:11:42'),(94,'auto_close_tickets','{\"enable_1\":0,\"enable_2\":0,\"enable_3\":0,\"enable_4\":0,\"enable_5\":0,\"enable_6\":0}',NULL,'2026-06-21 03:16:27'),(95,'dark_mode','0',NULL,'2026-07-13 20:05:52'),(96,'enable_google_authenticator','0',NULL,NULL),(97,'ticket_upload_driver','local',NULL,'2026-06-21 04:59:38'),(98,'ticket_upload_local_base','uploads',NULL,'2026-06-21 05:02:12'),(99,'bunny_enable','0',NULL,NULL),(100,'bunny_storage_zone','null',NULL,'2026-06-21 02:32:46'),(101,'bunny_api_key','null',NULL,'2026-06-21 02:32:46'),(102,'bunny_region_host','storage.bunnycdn.com',NULL,NULL),(103,'bunny_cdn_domain','null',NULL,'2026-06-21 02:32:46'),(104,'bunny_default_folder','uploads',NULL,NULL),(105,'google_drive_refresh_token','null',NULL,'2026-06-21 02:32:46'),(106,'google_drive_make_public','0',NULL,NULL),(107,'order_tickets_by_status','6,4,2,5,1,3',NULL,'2026-07-13 22:30:40'),(108,'status_show_new_tickets_by_status','',NULL,NULL),(109,'status_show_close_tickets_by_status','',NULL,NULL),(110,'status_release_ticket_by_status','',NULL,NULL),(111,'nbr_days_to_close_ticket_by_status','{\"1\":null,\"2\":null,\"3\":null,\"4\":null,\"5\":null,\"6\":null}',NULL,'2026-06-21 02:32:46'),(112,'status_enable_disable','{\"1\":\"0\",\"2\":\"0\",\"3\":\"0\",\"4\":\"0\",\"5\":\"0\",\"6\":\"0\"}',NULL,'2026-06-21 03:16:27'),(113,'field_tkt_texte','[\"Demande MDF-TKT- PNR\"]',NULL,NULL),(114,'field_tkt_id','[5]',NULL,'2026-06-21 02:32:46'),(115,'field_tkt_category_ids','[[16]]',NULL,'2026-06-21 02:32:46'),(116,'emails_category','[\"akouas_v@yahoo.fr\",\"hamzachaffai125@gmail.com\",\"houssamdibi1@gmail.com\",\"palmabookingb2b@gmail.com\"]',NULL,NULL),(117,'emails_category_ids','[[28,27,16,17,14,20,23,22,39],[22],[28,39],[]]',NULL,'2026-07-14 08:50:39'),(118,'legacy_role_permission_overrides','{}',NULL,NULL),(119,'site_favicon','1782012814_site_favicon.png',NULL,'2026-06-21 02:33:34'),(120,'active_frontend_template','showcase_modern','2026-06-21 03:12:00','2026-06-21 03:12:00'),(122,'notif_local_enabled','1',NULL,NULL),(123,'notif_email_enabled','1',NULL,NULL),(124,'notif_on_reservation_create','1',NULL,NULL),(125,'notif_on_visa_booking','1',NULL,NULL),(126,'notif_on_ticket_create','1',NULL,NULL),(127,'notif_on_ticket_reply','1',NULL,NULL),(128,'notif_on_status_change','1',NULL,NULL),(129,'emails_category_enabled','1','2026-07-14 09:11:42','2026-07-14 09:11:42');

-- Additional data for clic23_site_settings:
INSERT IGNORE INTO `clic23_site_settings` VALUES (1,'Support Palmabooking','','uploads','uploads','1WoSdSM_RGHY-PSdcAqKbvqishPsygte4','admin@support.palmabooking.pro','6776c8cf1a9f1.png',NULL,NULL,0,1,'d/m/Y H:i',0,'pdf|docx|xlsx|pptx|rtf|doc|xls|ppt|txt|wps|sxw|jpeg|jpg|png|gif|bmp|tiff|zip|rar','','',0,'','','','',5000,'','USD',1,'$',0,0,1,0,10,0,'','',1,0,0,1,NULL,1,'support.palmabooking.pro:143','akouas_v@yahoo.fr','20JUILLET2018','Support Ticket PalmaBooking','[\n    {\n        \"field_tkt_texte\": \"Demande MDF-TKT- PNR\",\n        \"field_tkt_id\": \"5\",\n        \"field_tkt_category_ids\": [\n            \"16\"\n        ]\n    }\n]',1,1,'',0,'','',1,100,100,14,0,'','layout/themes/clicngo_layout.php','## Ticket ID:','## - REPLY ABOVE THIS LINE - ##',0,'',360,1,1,0,0,2,6,0,1,1,50,150,1,1,'','[\n    {\n        \"send_mail_by_category\": \"akouas_v@yahoo.fr\",\n        \"emails_category_ids\": [\n            \"14\",\n            \"16\",\n            \"17\",\n            \"20\",\n            \"22\",\n            \"23\",\n            \"27\",\n            \"28\",\n            \"39\"\n        ]\n    },\n    {\n        \"send_mail_by_category\": \"hamzachaffai125@gmail.com\",\n        \"emails_category_ids\": []\n    },\n    {\n        \"send_mail_by_category\": \"houssamdibi1@gmail.com\",\n        \"emails_category_ids\": [\n            \"28\",\n            \"39\"\n        ]\n    },\n    {\n        \"send_mail_by_category\": \"palmabookingb2b@gmail.com\",\n        \"emails_category_ids\": []\n    },\n    {\n        \"send_mail_by_category\": \"houssamdibi1@gmail.com\",\n        \"emails_category_ids\": [\n            \"14\"\n        ]\n    }\n]',0.00,'384258166417-cjb2afqj7kuv752mck8cvsnb1j23qsld.apps.googleusercontent.com','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','{\"access_token\":\"ya29.a0AT3oNZ9jmJqMhlUjo-THBmv8DnzjbtFYMYzO_2Hegugu9UJ1viBoUFmPIic6NV2X8uXsoPmN_kAxDQmqrIvE9OndxpghCvczTqN5ha7YYYsOmlkMUHB-OgWvd-4CZqINWYgN8PK7zgj4xnshpY6C2IzoZHOYLBvENb5UyltzOE442V6aTQb1b2Ff9WuyJkrlTe7b4BFZkAaCgYKAQISARcSFQHGX2Mi3PwbQABcyYsBENvkK4XdVA0209\",\"expires_in\":3599,\"scope\":\"https:\\/\\/www.googleapis.com\\/auth\\/drive\",\"token_type\":\"Bearer\",\"created\":1781945088,\"refresh_token\":\"1\\/\\/03Vq9Q9lEx89pCgYIARAAGAMSNwF-L9IrSHc0kX586FWOOIqi_OjjsMaBhNSGYFn1PT6kWlwxREL0oaLh_RVRbRT1FbyOmj1VClI\"}','1,6,2,4,7,5,3','http://www.palmabooking.pro',2,2,20,'#dd1671','#48565f','7,8,9,11',1,'[{\"title\":\"amadeus \",\"url\":\"https:\\/\\/www.sellingplatformconnect.amadeus.com\\/login\\/\",\"icon\":\"glyphicon-globe\",\"client_visible\":\"yes\"}]',0,NULL,NULL);

SET FOREIGN_KEY_CHECKS = 1;
-- End of migration
