-- 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', '<p>DISC 10K PW</p>', '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', '<p>DISC 50K SALON</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>DISC 10K PW</p>', '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', '<p>disc 50k salon</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>disc 10k PW</p>', '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', '<p>disc 50k salon</p>', '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', '<p>DISC 10K PW</p>', '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', '<p>DISC 50K SALON</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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', '<p>Disc 10% Coating</p>', '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', '<p>diskon 10k pw</p>', '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', '<p>disc 50k motodetailing</p>', '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', '<p>disc 10k pw</p>', '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', '<p>disc 50k salon</p>', '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 */;
