-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 25, 2026 at 11:45 AM -- Server version: 10.11.16-MariaDB -- PHP Version: 8.4.17 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `signature_sct_db` -- -- -- Dumping data for table `voucher_templates` -- INSERT INTO `voucher_templates` (`id`, `prefix`, `campaign_id`, `name`, `type`, `description`, `max_quantity`, `month_validity_period`, `min_transaction`, `disc_money`, `disc_pct`, `max_cashback`, `buy_sku`, `get_sku`, `get_quantity`, `creator_id`, `editor_id`, `created_at`, `updated_at`) VALUES (1, 'MSPW', 1, 'Member SCT Motodetailing - Premium Wash ', 'Discount Rupiah', '

DISC 10K PW

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-03-24 23:25:48'), (2, 'MSMD', 1, 'Member SCT Motodetailing - Motodetailing', 'Discount Rupiah', '

DISC 50K SALON

', '2', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-03-24 23:25:48'), (3, 'PMPW', 2, 'Premium Member Card - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '14', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-04-29 19:22:21'), (4, 'PMMD', 2, 'Premium Member Card - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '4', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-04-29 19:22:34'), (7, 'EXPR', 3, 'SCT Promo Wash', 'Discount Rupiah', '

disc 10k pw

', '15', '24', '90000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-03-24 23:25:48'), (8, 'EXPR', 3, 'SCT Promo Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '5', '24', '950000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-03-24 23:25:48', '2025-03-24 23:25:48'), (9, 'MCPW', 1, 'Member Coating Delight - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-02 03:23:02', '2025-05-02 03:23:02'), (10, 'MCPW', 7, 'Member Coating Delight - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-02 03:35:49', '2025-05-02 03:35:49'), (11, 'MCMD', 1, 'Member Coating Delight - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '4', '12', '200000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-02 03:47:00', '2025-05-02 03:47:00'), (12, 'MBOPW', 5, 'Member BO Premium Wash', 'Discount Rupiah', '

DISC 10K PW

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-08 21:32:25', '2025-05-08 21:34:30'), (13, 'MBODT', 5, 'Member BO Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '4', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-08 21:34:06', '2025-05-08 21:34:42'), (14, 'PBOPW', 5, 'Premium BO Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '14', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-08 21:36:28', '2025-05-08 21:36:28'), (15, 'PBODT', 5, 'Premium BO Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '8', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-05-08 21:37:42', '2025-05-08 21:37:42'), (16, 'UTPW', 8, 'Ultimate Member Card - Premium Wash', 'Discount Rupiah', '

disc 10k PW

', '20', '24', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-06-29 20:50:29', '2025-06-29 20:50:29'), (17, 'UTDT', 8, 'Ultimate Member Card - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '6', '24', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-06-29 20:53:06', '2025-06-29 20:53:06'), (18, 'UTBOPW', 9, 'Ultimate Member Card - Premium Wash BO', 'Discount Rupiah', '

DISC 10K PW

', '20', '24', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-07-09 00:37:50', '2025-07-09 00:37:50'), (19, 'UTBODT', 9, 'Ultimate Member Card - Motodetailing BO', 'Discount Rupiah', '

DISC 50K SALON

', '6', '24', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-07-09 00:40:05', '2025-07-09 00:40:05'), (20, 'DRP', 10, 'Bundling Anti Karat Delight Extra&Plus - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-08-10 19:31:37', '2025-08-10 19:31:37'), (21, 'DDRP', 10, 'Bundling Anti Karat Delight Extra&Plus - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '2', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-08-10 19:35:52', '2025-08-10 19:35:52'), (22, 'PRP', 10, 'Bundling Anti Karat Premium - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '14', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-08-10 19:36:54', '2025-08-10 19:36:54'), (23, 'PPRP', 10, 'Bundling Anti Karat Premium - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '4', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-08-10 19:38:17', '2025-08-10 19:38:17'), (24, 'SCPL', 11, 'Customer Loyal Coating', 'Discount Persentase', '

Disc 10% Coating

', '2', '12', '1000000', NULL, '10', '10000000', NULL, NULL, NULL, 1, NULL, '2025-10-23 00:06:53', '2025-10-23 00:06:53'), (25, 'CDEP', 12, 'Geber Maxi - Premium Wash', 'Discount Rupiah', '

diskon 10k pw

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-11-04 21:55:15', '2025-11-04 21:55:15'), (26, 'CTDEP', 12, 'Geber Maxi - Motodetailing', 'Discount Rupiah', '

disc 50k motodetailing

', '2', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-11-04 21:59:39', '2025-11-04 21:59:39'), (27, 'GMPW', 13, 'GM - Premium Wash', 'Discount Rupiah', '

disc 10k pw

', '8', '12', '30000', '10000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-11-04 23:56:24', '2025-11-04 23:56:24'), (28, 'GMDT', 13, 'GM - Motodetailing', 'Discount Rupiah', '

disc 50k salon

', '2', '12', '250000', '50000', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2025-11-04 23:58:31', '2025-11-04 23:58:31'); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;