-- MySQL / MariaDB equivalent of the bulk payment recoveries migration.
CREATE TABLE IF NOT EXISTS `bulk_payment_recoveries` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `batch_id` CHAR(36) NOT NULL,
  `performed_by` BIGINT UNSIGNED NULL,
  `invoice_count` INT UNSIGNED NOT NULL,
  `total_amount` DECIMAL(12, 2) NOT NULL,
  `payment_mode` VARCHAR(30) NOT NULL,
  `payment_date` DATE NOT NULL,
  `invoice_ids` JSON NOT NULL,
  `created_at` TIMESTAMP NULL DEFAULT NULL,
  `updated_at` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bulk_payment_recoveries_batch_id_unique` (`batch_id`),
  KEY `bulk_payment_recoveries_performed_by_foreign` (`performed_by`),
  CONSTRAINT `bulk_payment_recoveries_performed_by_foreign`
    FOREIGN KEY (`performed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;