-- 1. Membuat tabel 'transaksi' CREATE TABLE IF NOT EXISTS `transaksi` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `order_id` VARCHAR(100) NOT NULL, `customer_name` VARCHAR(100) DEFAULT NULL, `gross_amount` DECIMAL(15,2) DEFAULT NULL, `payment_type` VARCHAR(50) DEFAULT NULL, `transaction_status` VARCHAR(20) DEFAULT NULL, `transaction_time` DATETIME DEFAULT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `order_id` (`order_id`) -- Memastikan tidak ada order_id ganda ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2. Menambahkan index agar pencarian (filter hari ini) lebih cepat CREATE INDEX idx_tr_time ON transaksi(transaction_time);