CREATE TABLE `country_areas` (
  `id` int UNSIGNED NOT NULL,
  `merchant_id` int UNSIGNED NOT NULL,
  `country_id` int UNSIGNED NOT NULL,
  `is_geofence` tinyint NOT NULL DEFAULT '2' COMMENT '1 - Geofence Area, 2 - Service Area',
  `auto_upgradetion` int NOT NULL DEFAULT '2',
  `manual_downgradation` tinyint NOT NULL DEFAULT '2',
  `timezone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minimum_wallet_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'for driver',
  `pool_postion` int DEFAULT '1',
  `status` int DEFAULT '1',
  `is_premium` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Zone premium nécessitant premium_zones_access',
  `premium_bonus_multiplier` decimal(3,2) NOT NULL DEFAULT '1.00' COMMENT 'Multiplicateur bonus pour zones premium',
  `driver_earning_duration` int DEFAULT '1',
  `manual_toll_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bill_period_start` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AreaCoordinates` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `driver_cash_limit_amount` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
