
--
-- Table structure for table `review_images`
--

CREATE TABLE `review_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `review_id` bigint unsigned NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_review_id` (`review_id`),
  CONSTRAINT `review_images_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `reviews` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review_images`
--

INSERT INTO `review_images` VALUES (1,2,'reviews/f8ctlYyf3OUmMdQLDfx04ayhCkH95mo75GpIOzkG.png',0,'2026-01-23 11:28:04','2026-01-23 11:28:04');

--
-- Table structure for table `review_replies`
--

CREATE TABLE `review_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `review_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `reply` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_review_id` (`review_id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `review_replies_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `reviews` (`id`) ON DELETE CASCADE,
  CONSTRAINT `review_replies_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review_replies`
--


--
-- Table structure for table `review_votes`
--

CREATE TABLE `review_votes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `review_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `is_helpful` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_vote` (`review_id`,`user_id`),
  KEY `idx_review_id` (`review_id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `review_votes_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `reviews` (`id`) ON DELETE CASCADE,
  CONSTRAINT `review_votes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review_votes`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `order_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `rating` tinyint unsigned NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `reviewer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reviewer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_verified_purchase` tinyint(1) NOT NULL DEFAULT '1',
  `helpful_count` int NOT NULL DEFAULT '0',
  `not_helpful_count` int NOT NULL DEFAULT '0',
  `status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'approved',
  `admin_note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reviews_user_id_foreign` (`user_id`),
  CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (2,NULL,1,731,5,'mantap','Test User','test@example.com',1,0,0,'approved',NULL,'2026-01-23 11:28:04','2026-01-23 11:28:04'),(3,NULL,2,731,5,'Pelayanan cepat banget! Proses instan, diamond langsung masuk dalam 1 menit. Seller responsif dan terpercaya. Highly recommended untuk top up diamond ML!','Happy Customer','customer@test.com',1,0,0,'approved',NULL,'2026-01-27 00:42:22','2026-01-27 00:42:22');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_name_unique` (`key_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'digiflazz_username','dibeziDay6VD',NULL,NULL),(2,'digiflazz_api_key','dev-ca2c9af0-e929-11f0-a4f4-d175b4de8bca',NULL,NULL),(3,'digiflazz_balance','0',NULL,NULL),(4,'last_vipreseller_sync','2026-01-10 10:47:18',NULL,'2026-01-10 03:47:18');

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` VALUES (5,'images/banner/slider-1768132016-69638db0ccfb7.webp',0,'2026-01-11 04:46:56','2026-01-11 04:46:56'),(6,'images/banner/slider-1768132036-69638dc4bc50a.webp',0,'2026-01-11 04:47:16','2026-01-11 04:47:16'),(7,'images/banner/slider-1768132043-69638dcb4386e.webp',0,'2026-01-11 04:47:23','2026-01-11 04:47:23');

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_ref` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` bigint unsigned NOT NULL,
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_data` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `base_price` decimal(15,2) NOT NULL,
  `margin_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `product_price` decimal(15,2) NOT NULL,
  `payment_fee` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_amount` decimal(15,2) NOT NULL,
  `status` enum('pending','paid','processing','success','failed','refund','expired') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `processing_attempts` int NOT NULL DEFAULT '0',
  `last_processed_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `failed_at` timestamp NULL DEFAULT NULL,
  `payment_status` enum('UNPAID','PAID','EXPIRED','FAILED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UNPAID',
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_instructions` text COLLATE utf8mb4_unicode_ci,
  `paid_at` timestamp NULL DEFAULT NULL,
  `processing_at` timestamp NULL DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `trx_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_response` text COLLATE utf8mb4_unicode_ci,
  `provider_note` text COLLATE utf8mb4_unicode_ci,
  `provider_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_sn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `voucher_id` bigint unsigned DEFAULT NULL,
  `voucher_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_price` decimal(15,2) DEFAULT NULL,
  `discount_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `transactions_invoice_number_unique` (`invoice_number`),
  UNIQUE KEY `transactions_reference_unique` (`reference`),
  KEY `transactions_product_id_foreign` (`product_id`),
  KEY `transactions_status_index` (`status`),
  KEY `transactions_payment_status_index` (`payment_status`),
  KEY `transactions_invoice_number_index` (`invoice_number`),
  KEY `transactions_reference_index` (`reference`),
  KEY `transactions_merchant_ref_index` (`merchant_ref`),
  KEY `transactions_voucher_id_index` (`voucher_id`),
  KEY `transactions_voucher_code_index` (`voucher_code`),
  CONSTRAINT `transactions_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` VALUES (5,'INV-20260112-WGXK3FSH',NULL,'TRX-1768219763-GQKRVZ','admin@gmail.com',NULL,'Admin Ryll Store',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,0.00,5924.00,0.00,5924.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO',NULL,NULL,NULL,NULL,NULL,'2026-01-13 05:09:23',NULL,NULL,NULL,NULL,NULL,'2026-01-12 05:09:23','2026-01-12 05:09:23',NULL,NULL,NULL,0.00),(6,'INV-20260112-SF23SZCF','DEV-T47888329493ZCHCK','TRX-1768219998-IQQJYX','admin@gmail.com',NULL,'Admin Ryll Store',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,0.00,5924.00,0.00,5924.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888329493ZCHCK','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 05:13:18',NULL,NULL,NULL,NULL,NULL,'2026-01-12 05:13:18','2026-01-12 05:13:18',NULL,NULL,NULL,0.00),(7,'INV-20260112-WJ3OEF70','DEV-T47888329498HKKI1','TRX-1768220601-ZZKSV5','ryu@gmail.com',NULL,'ryu',298,'40 Diamonds','FF40-S13','619166319',5568.00,0.00,6125.00,0.00,6125.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888329498HKKI1','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 05:23:21',NULL,NULL,NULL,NULL,NULL,'2026-01-12 05:23:21','2026-01-12 05:23:21',NULL,NULL,NULL,0.00),(8,'INV-20260112-YZC3IGNI','DEV-T478883295006B3IM','TRX-1768221045-T4W0EP','ryll@gmail.com',NULL,'ryll',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,0.00,3715.00,0.00,3715.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T478883295006B3IM','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-12 06:29:46',NULL,NULL,NULL,NULL,NULL,'2026-01-12 05:30:45','2026-01-12 05:30:46',NULL,NULL,NULL,0.00),(10,'INV-20260112-EA9W1XL6','DEV-T47888329521HEGGN','TRX-1768227196-9X4DML','ryll@gmail.com',NULL,'ryll',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,338.00,3715.00,38.00,3753.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T47888329521HEGGN','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 07:12:16',NULL,NULL,NULL,NULL,NULL,'2026-01-12 07:13:16','2026-01-12 07:13:16',NULL,NULL,NULL,0.00),(13,'INV-20260112-B7BRSC2I','DEV-T47888329560DS4OZ','TRX-1768236065-TC8A5D','ryll@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888329560DS4OZ','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-12 10:40:06',NULL,NULL,NULL,NULL,NULL,'2026-01-12 09:41:05','2026-01-12 09:41:06',NULL,NULL,NULL,0.00),(14,'INV-20260112-ZBLUQMRA','DEV-T47888329562XJ6TQ','TRX-1768237995-UQNFAQ','ryll@gmail.com','111111111111111','ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888329562XJ6TQ','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-12 11:12:15',NULL,NULL,NULL,NULL,NULL,'2026-01-12 10:13:15','2026-01-12 10:13:15',NULL,NULL,NULL,0.00),(16,'INV-20260112-GEG2JYF9','DEV-T47888329564SO2LL','TRX-1768238437-2YUOUJ','ryll@gmail.com','1111111111111111','ryll',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,338.00,3715.00,38.00,3753.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T47888329564SO2LL','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 10:19:37',NULL,NULL,NULL,NULL,NULL,'2026-01-12 10:20:37','2026-01-12 10:20:37',NULL,NULL,NULL,0.00),(17,'INV-20260112-OAANZXHY','DEV-T47888329565HOKHP','TRX-1768238670-6XTTO5','r@gmail.com',NULL,'r',3,'250 + 20 Tokens','ACE250-S17','1',50745.00,5075.00,55820.00,559.00,56379.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T47888329565HOKHP','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 10:23:31',NULL,NULL,NULL,NULL,NULL,'2026-01-12 10:24:30','2026-01-12 10:24:31',NULL,NULL,NULL,0.00),(18,'INV-20260112-TTH6REBX','DEV-T47888329577UM8MK','TRX-1768245984-VTR96F','admin@gmail.com',NULL,'Admin Ryll Store',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,338.00,3715.00,75.00,3790.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888329577UM8MK','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-13 12:26:24',NULL,NULL,NULL,NULL,NULL,'2026-01-12 12:26:24','2026-01-12 12:26:24',NULL,NULL,NULL,0.00),(19,'INV-20260112-KHV2CRPN','DEV-T47888329578FW3UY','TRX-1768246212-THSEAZ','ryll@gmail.com',NULL,'ryll',736,'17 Diamonds (16 + 1 Bonus)','MLA17-S13','129310452|2652',4913.00,491.00,5404.00,38.00,5442.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888329578FW3UY','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-12 13:29:13',NULL,NULL,NULL,NULL,NULL,'2026-01-12 12:30:12','2026-01-12 12:30:13',NULL,NULL,NULL,0.00),(20,'INV-20260113-FCGM6RP2','DEV-T47888329789LWPKQ','TRX-1768304119-GKWCIB','admin@gmail.com',NULL,'Admin Ryll Store',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,539.00,5924.00,119.00,6043.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888329789LWPKQ','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-14 04:35:19',NULL,NULL,NULL,NULL,NULL,'2026-01-13 04:35:19','2026-01-13 04:35:19',NULL,NULL,NULL,0.00),(22,'INV-20260113-XVZR9GGM','DEV-T4788832981132FJZ','TRX-1768313516-9HXZQS','ryll@gmail.com',NULL,'ryll',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,539.00,5924.00,60.00,5984.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T4788832981132FJZ','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-14 07:10:57',NULL,NULL,NULL,NULL,NULL,'2026-01-13 07:11:56','2026-01-13 07:11:57',NULL,NULL,NULL,0.00),(23,'INV-20260113-WTKQUMSA','DEV-T478883298134LM0Z','TRX-1768313639-CCT5DP','ryll@gmail.com',NULL,'ryll',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,539.00,5924.00,60.00,5984.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T478883298134LM0Z','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-14 07:12:59',NULL,NULL,NULL,NULL,NULL,'2026-01-13 07:13:59','2026-01-13 07:13:59',NULL,NULL,NULL,0.00),(24,'INV-20260113-I2EM86YL','DEV-T47888329815Q4BYY','TRX-1768314116-8DW8SW','pseudobytes@gmail.com','083131013797','Koko Ail',737,'19 Diamonds (17 + 2 Bonus)','MLA19-S13','129310452|2652',5385.00,539.00,5924.00,60.00,5984.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T47888329815Q4BYY','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-14 07:20:56',NULL,NULL,NULL,NULL,NULL,'2026-01-13 07:21:56','2026-01-13 07:21:56',NULL,NULL,NULL,0.00),(25,'INV-20260113-5NZN16CN','DEV-T478883298201H5YP','TRX-1768316779-62H8AP','ryll@gmail.com',NULL,'ryll',808,'10 Diamonds ( 10 + 0 Bonus )','ML10_0-S1A','129310452|2652',2919.00,292.00,3211.00,33.00,3244.00,'success',0,NULL,NULL,NULL,'PAID','QRIS2','QRIS2','https://tripay.co.id/checkout/DEV-T478883298201H5YP','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]','2026-01-14 02:09:25',NULL,'2026-01-14 08:05:19',NULL,NULL,NULL,NULL,NULL,'2026-01-13 08:06:19','2026-01-13 08:06:20',NULL,NULL,NULL,0.00),(26,'INV-20260119-OJT3S8MY','DEV-T47888331560F5UHM','TRX-1768845485-0WOLUK','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331560F5UHM','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 11:57:06',NULL,NULL,NULL,NULL,NULL,'2026-01-19 10:58:05','2026-01-19 10:58:06',NULL,NULL,NULL,0.00),(27,'INV-20260119-CJNGYEKZ','DEV-T4788833156225YSN','TRX-1768846088-DCC5U4','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T4788833156225YSN','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:07:09',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:08:08','2026-01-19 11:08:09',NULL,NULL,NULL,0.00),(28,'INV-20260119-8IIBAHOG','DEV-T47888331565IX2UN','TRX-1768847069-FQ96FG','darryljuliansyah8@gmail.com',NULL,'ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331565IX2UN','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:23:29',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:24:29','2026-01-19 11:24:29',NULL,NULL,NULL,0.00),(29,'INV-20260119-VII1BUEB','DEV-T47888331566733YM','TRX-1768847169-3AZO9Q','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331566733YM','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:25:09',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:26:09','2026-01-19 11:26:09',NULL,NULL,NULL,0.00),(30,'INV-20260119-OS7LJ53A','DEV-T47888331567Y3SAI','TRX-1768847244-QRAH87','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331567Y3SAI','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:26:24',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:27:24','2026-01-19 11:27:24',NULL,NULL,NULL,0.00),(33,'INV-20260119-K4OGRHQW','DEV-T47888331569MXUSI','TRX-1768847829-6WNN5H','darryljuliansyah8@gmail.com',NULL,'ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331569MXUSI','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:36:09',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:37:09','2026-01-19 11:37:09',NULL,NULL,NULL,0.00),(36,'INV-20260119-T7KA64MA','DEV-T47888331570IUGPT','TRX-1768848098-D0CANX','darryljuliansyah8@gmail.com',NULL,'ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331570IUGPT','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:40:38',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:41:38','2026-01-19 11:41:38',NULL,NULL,NULL,0.00),(37,'INV-20260119-NUGVTKWY','DEV-T47888331571JBSXY','TRX-1768848714-BSTXJL','darryljuliansyah8@gmail.com',NULL,'ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331571JBSXY','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:50:54',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:51:54','2026-01-19 11:51:54',NULL,NULL,NULL,0.00),(38,'INV-20260119-1TJ1V3FG','DEV-T47888331572JP6CU','TRX-1768848873-NUHCZP','darryljuliansyah8@gmail.com',NULL,'ryll',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,338.00,3715.00,27.00,3742.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888331572JP6CU','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:53:34',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:54:33','2026-01-19 11:54:34',NULL,NULL,NULL,0.00),(39,'INV-20260119-MOK7QXBV','DEV-T478883315736FG6I','TRX-1768848966-E4JQWV','kaedeharakazuha1849@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T478883315736FG6I','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-19 12:55:06',NULL,NULL,NULL,NULL,NULL,'2026-01-19 11:56:06','2026-01-19 11:56:06',NULL,NULL,NULL,0.00),(40,'INV-20260121-DNLSALE9','DEV-T47888332090YZ5LT','TRX-1769037580-SI4ILZ','darryljuliansyah8@gmail.com',NULL,'ryll',731,'3 Diamonds (3 + 0 Bonus)','MLA3-S13','129310452|2652',1021.00,102.00,1123.00,8.00,1131.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888332090YZ5LT','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-21 17:18:40',NULL,NULL,NULL,NULL,NULL,'2026-01-21 16:19:40','2026-01-21 16:19:40',NULL,NULL,NULL,0.00),(41,'INV-20260122-01YPIUMX','DEV-T47888332343SECDO','TRX-1769100342-YSMHCF','ryllr34@gmail.com',NULL,'ryll',735,'15 Diamonds (15 + 0 Bonus)','MLA15-S13','129310452|2652',4428.00,443.00,4871.00,35.00,4906.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888332343SECDO','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-22 10:44:42',NULL,NULL,NULL,NULL,NULL,'2026-01-22 09:45:42','2026-01-22 09:45:42',NULL,NULL,NULL,0.00),(42,'INV-20260122-SRKIFSDQ','DEV-T478883323445XLPL','TRX-1769100444-B4WMAN','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.00,1597.00,32.00,1629.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T478883323445XLPL','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-23 09:47:24',NULL,NULL,NULL,NULL,NULL,'2026-01-22 09:47:24','2026-01-22 09:47:28',NULL,NULL,NULL,0.00),(43,'INV-20260123-ZXWM884M','DEV-T47888332661YP5VJ','TRX-1769191662-TY992J','darryljuliansyah8@gmail.com',NULL,'asu',734,'12 Diamonds (11 + 1 Bonus)','MLA12-S13','129310452|2652',3377.00,338.00,3715.00,27.00,3742.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS','https://tripay.co.id/checkout/DEV-T47888332661YP5VJ','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-23 12:06:45',NULL,NULL,NULL,NULL,NULL,'2026-01-23 11:07:42','2026-01-23 11:07:45',NULL,NULL,NULL,0.00),(47,'INV-20260127-K3DCVBLG','DEV-T47888333712GFIJN','TRX-1769513781-CTSVOB','darryljuliansyah8@gmail.com',NULL,'RYLL',744,'85 Diamonds (77 + 8 Bonus)','MLA85-S13','129310452|2652',22604.00,2260.40,24864.40,498.00,25362.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888333712GFIJN','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-28 04:36:21',NULL,NULL,NULL,NULL,NULL,'2026-01-27 04:36:21','2026-01-27 04:36:32',NULL,NULL,NULL,0.00),(48,'INV-20260127-3SCHVXCE',NULL,'TRX-1769513822-XMZSWL','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.20,1597.20,16.00,1613.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2',NULL,NULL,NULL,NULL,NULL,'2026-01-28 04:37:02',NULL,NULL,NULL,NULL,NULL,'2026-01-27 04:37:02','2026-01-27 04:37:02',NULL,NULL,NULL,0.00),(49,'INV-20260127-ZV1WCJQI','DEV-T47888333713ZCIVH','TRX-1769514055-NEOQP1','darryljuliansyah8@gmail.com',NULL,'ryll',736,'17 Diamonds (16 + 1 Bonus)','MLA17-S13','129310452|2652',4913.00,491.30,5404.30,55.00,5459.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS','https://tripay.co.id/checkout/DEV-T47888333713ZCIVH','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-28 04:39:55',NULL,NULL,NULL,NULL,NULL,'2026-01-27 04:40:55','2026-01-27 04:40:55',NULL,NULL,NULL,0.00),(50,'INV-20260127-XNXYRUQB','DEV-T47888333714YTBQU','TRX-1769514123-5C32PH','darryljuliansyah8@gmail.com',NULL,'ryll',736,'17 Diamonds (16 + 1 Bonus)','MLA17-S13','129310452|2652',4913.00,491.30,5404.30,55.00,5459.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS','https://tripay.co.id/checkout/DEV-T47888333714YTBQU','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-28 04:41:04',NULL,NULL,NULL,NULL,NULL,'2026-01-27 04:42:03','2026-01-27 04:42:04',NULL,NULL,NULL,0.00),(51,'INV-20260127-VQBS64RC','DEV-T47888333715W9RRN','TRX-1769514624-BC3W6K','darryljuliansyah8@gmail.com',NULL,'ryll',736,'17 Diamonds (16 + 1 Bonus)','MLA17-S13','129310452|2652',4913.00,491.30,5404.30,55.00,5459.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS2','QRIS','https://tripay.co.id/checkout/DEV-T47888333715W9RRN','[{\"title\":\"Pembayaran via QRIS\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-28 04:49:26',NULL,NULL,NULL,NULL,NULL,'2026-01-27 04:50:24','2026-01-27 04:50:27',NULL,NULL,NULL,0.00),(52,'INV-20260130-FUMWSAEB','DEV-T47888334350RCKMW','TRX-1769741420-OAGLEE','darryljuliansyah8@gmail.com',NULL,'DARRYL',745,'1x Weekly Diamond Pass (Event Topup 100)','MLAWDP1X-S13','129310452|2652',28168.00,2816.80,30984.80,558.00,28444.00,'pending',0,NULL,NULL,NULL,'UNPAID','OVO','OVO','https://tripay.co.id/checkout/DEV-T47888334350RCKMW','[{\"title\":\"Pembayaran via OVO\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Periksa <b>aplikasi OVO<\\/b> di Ponsel Anda\",\"Akan muncul prompt transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-30 19:50:20',NULL,NULL,NULL,NULL,NULL,'2026-01-29 19:50:20','2026-01-29 19:50:20',NULL,NULL,NULL,0.00),(53,'INV-20260130-ZOU6HX9Q','DEV-T478883343577OYAU','TRX-1769742432-BNVZJW','darryljuliansyah8@gmail.com',NULL,'ryll',293,'10 Diamonds','FF10-S13','619166319',1672.00,167.20,1839.20,13.00,1852.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS by ShopeePay','https://tripay.co.id/checkout/DEV-T478883343577OYAU','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-29 21:06:12',NULL,NULL,NULL,NULL,NULL,'2026-01-29 20:07:12','2026-01-29 20:07:12',NULL,NULL,NULL,0.00),(54,'INV-20260130-BRXUUWDH','DEV-T47888334359ZRLQ6','TRX-1769742556-SOBO0J','darryljuliansyah8@gmail.com',NULL,'RYLL',773,'1220 Diamonds (1083 + 138 Bonus)','MLA1220-S13','129310452|2652',306434.00,30643.40,337077.40,4551.00,307921.00,'pending',0,NULL,NULL,NULL,'UNPAID','SHOPEEPAY','ShopeePay','https://tripay.co.id/checkout/DEV-T47888334359ZRLQ6','[{\"title\":\"Pembayaran via ShopeePay\",\"steps\":[\"Klik tombol Lanjutkan Pembayaran\",\"Anda akan dialihkan ke aplikasi Shopee\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Klik tombol <b>Bayar<\\/b> dan masukkan <b>PIN<\\/b>\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-29 21:08:17',NULL,NULL,NULL,NULL,NULL,'2026-01-29 20:09:16','2026-01-29 20:09:17',NULL,NULL,NULL,0.00),(55,'INV-20260131-OAO5WL2C','DEV-T47888334635B3PZD','TRX-1769843354-O5XLHM','darryljuliansyah8@gmail.com',NULL,'ryll',732,'5 Diamonds (5 + 0 Bonus)','MLA5-S13','129310452|2652',1452.00,145.20,1597.20,12.00,1609.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS by ShopeePay','https://tripay.co.id/checkout/DEV-T47888334635B3PZD','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-31 01:08:14',NULL,NULL,NULL,NULL,NULL,'2026-01-31 00:09:14','2026-01-31 00:09:14',NULL,NULL,NULL,0.00),(56,'INV-20260201-14S82P5F','DEV-T47888334797EGZ7N','TRX-1769908498-4ROHC8','darryljuliansyah8@gmail.com',NULL,'ryll',2752,'10 Diamonds','FFMAX10-S44','619166319',1641.00,164.10,1805.10,13.00,1818.00,'pending',0,NULL,NULL,NULL,'UNPAID','QRIS','QRIS by ShopeePay','https://tripay.co.id/checkout/DEV-T47888334797EGZ7N','[{\"title\":\"Pembayaran via QRIS (ShopeePay)\",\"steps\":[\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Pindai\\/Scan QR Code yang tersedia\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]},{\"title\":\"Pembayaran via QRIS (Mobile)\",\"steps\":[\"Download QR Code pada invoice\",\"Masuk ke aplikasi dompet digital Anda yang telah mendukung QRIS\",\"Upload QR Code yang telah di download tadi\",\"Akan muncul detail transaksi. Pastikan data transaksi sudah sesuai\",\"Selesaikan proses pembayaran Anda\",\"Transaksi selesai. Simpan bukti pembayaran Anda\"]}]',NULL,NULL,'2026-01-31 19:13:58',NULL,NULL,NULL,NULL,NULL,'2026-01-31 18:14:58','2026-01-31 18:14:58',NULL,NULL,NULL,0.00),(57,'INV-20260201-MSJJV8RV','DEV-T47888334895XHNSG','TRX-1769925477-OK5JYL','darryljuliansyah8@gmail.com',NULL,'ryll',2789,'170 Diamonds (154 + 16 Bonus)','MLA170-S13','129310452|2652',44361.00,4436.10,48797.10,4000.00,52797.00,'pending',0,NULL,NULL,NULL,'UNPAID','MANDIRIVA','Mandiri Virtual Account','https://tripay.co.id/checkout/DEV-T47888334895XHNSG','[{\"title\":\"Internet Banking Livin Kuning\",\"steps\":[\"Login ke internet banking Anda\",\"Pilih menu <b>Bayar<\\/b> lalu klik menu <b>E-Commerce<\\/b>\",\"Masukkan Kode <b>Plink Pay (89039)<\\/b>\",\"Masukkan Nomor VA (<b>299325216622743<\\/b>)\",\"Masukkan Nominal (<b>57047<\\/b>)\",\"Detail transaksi akan ditampilkan, pastikan data sudah sesuai\",\"Klik tombol <b>Konfirmasi<\\/b>\",\"Periksa aplikasi Mandiri Online di ponsel Anda untuk menyelesaikan persetujuan transaksi\",\"Transaksi sukses, simpan bukti transaksi Anda\"]},{\"title\":\"ATM Mandiri\",\"steps\":[\"Masukkan kartu ATM & isi PIN ATM Anda\",\"Pilih menu <b>Bayar\\/Beli<\\/b> lalu pilih menu <b>Lainnya<\\/b>\",\"Pilih lagi menu <b>Lainnya<\\/b>\",\"Pilih menu <b>Multi Payment<\\/b>\",\"Masukkan kode <b>Plink Pay (89039)<\\/b> lalu tekan <b>Benar<\\/b>\",\"Masukkan Nomor VA (<b>299325216622743<\\/b>)\",\"Detail transaksi akan ditampilkan, pastikan data sudah sesuai\",\"Tekan <b>1<\\/b> lalu tekan <b>YA<\\/b>\",\"Transaksi sukses, simpan bukti transaksi Anda\"]},{\"title\":\"Mobile Banking\",\"steps\":[\"Masuk ke New Livin by Mandiri\",\"Pilih menu <b>Bayar\\/Beli<\\/b> \",\"Cari (89039) atau cari (Plink Pay) sebagai Penyedia Jasa\",\"Masukkan Nomor Virtual Account, (contoh: 146XXXXXXX)\",\"Masukkan jumlah transfer sesuai dengan tagihan kamu. Jumlah yang berbeda tidak dapat diproses\",\"Layar menampilkan Kode Bayar dan Data Pembayaran , pastikan data sudah sesuai\",\"Jika datanya benar, Klik <b>Lanjutkan<\\/b>\",\"Masukkan PIN New Livin, klik <b>OK<\\/b>\",\"Pembayaran selesai, simpan bukti transaksi Anda\"]}]',NULL,NULL,'2026-02-01 22:57:57',NULL,NULL,NULL,NULL,NULL,'2026-01-31 22:57:57','2026-01-31 22:57:57',NULL,NULL,NULL,0.00);

--
-- Table structure for table `voucher_usage`
--

CREATE TABLE `voucher_usage` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `voucher_id` bigint unsigned NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_amount` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `voucher_usage_voucher_id_foreign` (`voucher_id`),
  KEY `voucher_usage_transaction_id_index` (`transaction_id`),
  KEY `voucher_usage_customer_email_index` (`customer_email`),
  CONSTRAINT `voucher_usage_voucher_id_foreign` FOREIGN KEY (`voucher_id`) REFERENCES `vouchers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `voucher_usage`
--


--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('percentage','fixed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percentage',
  `value` decimal(10,2) NOT NULL,
  `min_purchase` int NOT NULL DEFAULT '0',
  `max_discount` int DEFAULT NULL,
  `max_usage` int NOT NULL DEFAULT '0',
  `used_count` int NOT NULL DEFAULT '0',
  `valid_from` datetime DEFAULT NULL,
  `valid_until` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vouchers_code_unique` (`code`),
  KEY `vouchers_code_index` (`code`),
  KEY `vouchers_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vouchers`
--

INSERT INTO `vouchers` VALUES (4,'RYLLXBERNADYA','percentage',10.00,20000,50000,10,0,'2026-01-30 02:49:00','2026-02-07 09:49:00',1,NULL,'2026-01-29 19:49:42','2026-01-31 22:58:17');


