-- ============================================================
-- Migration 58: Create partner_checks table
-- ============================================================

CREATE TABLE `partner_checks` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) UNSIGNED NOT NULL,
  `check_number` varchar(50) NOT NULL,
  `bank_name` varchar(50) NOT NULL,
  `amount` bigint(20) UNSIGNED NOT NULL,
  `due_date` date NOT NULL,
  `status` enum('pending','endorsed','bounced','cleared','returned') NOT NULL DEFAULT 'pending',
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `status_notes` text DEFAULT NULL,
  `processed_by` int(10) UNSIGNED DEFAULT NULL,
  `processed_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_customer` (`customer_id`),
  KEY `idx_status` (`status`),
  KEY `idx_due_date` (`due_date`),
  KEY `idx_check_bank` (`check_number`, `bank_name`),
  CONSTRAINT `fk_partner_checks_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
