-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 01, 2024 at 09:34 PM
-- Server version: 10.6.16-MariaDB-cll-lve
-- PHP Version: 8.1.25

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: `webn5006_sebarundangan`
--

-- --------------------------------------------------------

--
-- Table structure for table `acara`
--

CREATE TABLE `acara` (
  `id_acara` int(11) NOT NULL,
  `nama_acara` varchar(50) NOT NULL,
  `tgl_acara` varchar(20) DEFAULT NULL,
  `waktu_mulai` varchar(10) NOT NULL,
  `waktu_akhir` varchar(10) NOT NULL,
  `tempat_acara` varchar(100) NOT NULL,
  `alamat_acara` text NOT NULL,
  `maps` text DEFAULT NULL,
  `set_countdown` enum('Y','N') DEFAULT 'N',
  `id_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `acara`
--

INSERT INTO `acara` (`id_acara`, `nama_acara`, `tgl_acara`, `waktu_mulai`, `waktu_akhir`, `tempat_acara`, `alamat_acara`, `maps`, `set_countdown`, `id_user`) VALUES
(185, 'Akad Nikah', '2022/12/14', '09:00', '10:00', 'Kediaman Mempelai Wanita', 'Jl. Medan Merdeka Utara No.3 RT.02/RW.03. Gambir, Jakarta Pusat.', '', 'N', 1),
(186, 'Resepsi', '2022/12/15', '10:00', '22:00', 'Kediaman Mempelai Wanita', 'Jl. Medan Merdeka Utara No.3 RT.02/RW.03. Gambir, Jakarta Pusat.', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3966.705836876672!2d106.82198811476884!3d-6.170129095532956!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e69f5d6aa94d477%3A0xebf3b9d252c86a26!2sMerdeka%20Palace!5e0!3m2!1sen!2sid!4v1595773648767!5m2!1sen!2sid\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 'Y', 1),
(187, 'Unduh Mantu', '2022/12/31', '10:00', '22:00', 'Kediaman Mempelai Pria', 'Dukun RT 002 RW 002', '', 'N', 1),
(201, 'Akad Nikah', '2022/04/01', '07:00', '08:00', 'Kediaman Mempelai Wanita', 'Kediaman Mempelai Wanita', '', 'N', 303),
(202, 'afasfas', '2022/05/21', '22:42', '22:43', 'afasfa', 'afasf', '', 'N', 304),
(203, 'Akad', '2023/08/01', '23:15', '23:15', 'Pinggir jalan', 'Hakna', '', 'N', 305),
(204, 'Resepsi', '2023/08/01', '23:15', '23:15', 'Hdjva', 'Hdgs', '', 'N', 305),
(205, 'Z. X', '2023/08/02', '15:30', '15:30', 'Nnnnn', 'Nnn', 'Nnnnnn', 'N', 306),
(206, 'Nnnnn', '2023/08/02', '15:30', '16:30', 'Nnnn', 'Nnnn', 'Nnn', 'N', 306),
(207, 'D', '2023/08/15', '16:22', '05:38', 'D', 'D', '', 'N', 307),
(208, 'D', '2023/08/17', '05:38', '04:38', 'D', 'D', '', 'N', 307),
(209, 'akad nikah', '2023/11/16', '12:16', '12:16', 'kediaman mempelai wanita ', 'kp dawagung', '', 'N', 309),
(210, 'akad nikah', '2023/11/15', '12:16', '12:16', 'kediaman mempelai wanita ', 'cibaok', '', 'N', 309),
(213, 'akad', '2023/11/23', '11:11', '11:22', 'j', 'idj', 'j', 'N', 310),
(214, 'nikah', '2023/11/24', '15:05', '17:06', 'pria', 'lampung', '', 'N', 311),
(215, 'resepsi', '2023/11/24', '15:06', '15:07', 'mempelai wanita', 'lampung', '', 'N', 311),
(216, 'Akad aja', '2023/12/07', '10:04', '22:04', 'Cewekku', 'Alamat aja', 'Alamat', 'N', 312),
(217, 'Resepsi', '2023/12/09', '10:05', '22:05', 'Ini aja', 'Hajajah', 'Alamat', 'N', 312),
(218, 'Hdhjdd', '2023/12/15', '17:48', '17:48', 'Ndnd', 'Jxnnxnd', '', 'N', 313),
(219, 'Jdjdj', '2023/12/15', '17:48', '17:48', 'Kfnnf', 'Ndnndn', '', 'N', 313);

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `nama_lengkap` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `email`, `nama_lengkap`, `created_at`) VALUES
(1, 'admin', '7ece99e593ff5dd200e2b9233d9ba654', 'koleksidigital2@gmail.com', 'Vincenzo', '2020-08-27 04:38:43');

-- --------------------------------------------------------

--
-- Table structure for table `album`
--

CREATE TABLE `album` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `album` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `album`
--

INSERT INTO `album` (`id`, `id_user`, `album`) VALUES
(383, 1, 'album1'),
(384, 1, 'album2'),
(385, 1, 'album3'),
(386, 1, 'album4'),
(387, 1, 'album5'),
(388, 1, 'album6'),
(389, 1, 'album7'),
(390, 1, 'album8'),
(391, 1, 'album9'),
(392, 1, 'album10'),
(459, 305, 'album1'),
(460, 305, 'album2'),
(461, 305, 'album3'),
(462, 305, 'album4'),
(463, 305, 'album5'),
(464, 305, 'album6'),
(465, 305, 'album7'),
(466, 305, 'album8'),
(467, 305, 'album9'),
(468, 305, 'album10');

-- --------------------------------------------------------

--
-- Table structure for table `cerita`
--

CREATE TABLE `cerita` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `tanggal_cerita` varchar(50) NOT NULL,
  `judul_cerita` text NOT NULL,
  `isi_cerita` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cerita`
--

INSERT INTO `cerita` (`id`, `id_user`, `tanggal_cerita`, `judul_cerita`, `isi_cerita`, `created_at`, `updated_at`) VALUES
(281, 1, '14 Januari 2021', 'Pertama bertemu', 'Waktu Pertama Kali\nKulihat Dirimu Hadir\nRasa hati ini inginkan dirimu ', '2022-03-30 03:55:22', '2022-03-30 12:06:49'),
(282, 1, '15 Maret 2021', 'Jatuh Cinta', 'Hati tenang mendengar \nsuara indah menyapa\nGeloranya hati ini\nTak ku sangka..', '2022-03-30 03:55:22', '2022-03-30 12:07:46'),
(283, 1, '1 Mei 2021', 'Ta\'aruf', 'Rasa ini.. tak tertahan..\nHati ini..slalu untukmu..', '2022-03-30 03:55:22', '2022-03-30 12:08:10'),
(284, 1, '16 Mei 2021', 'Khitbah', 'Terimalah lagu ini dari orang biasa\nTapi cintaku padamu luar biasa\nAku tak punya bunga\nAku tak punya harta\nYang ku punya hanyalah\nHati yang setia.. Tulus.. Padamu.. :)', '2022-03-30 03:55:22', '2022-03-30 12:08:47'),
(285, 1, '19 Desember', 'Pertemuan Antar Keluarga Besar', 'Membicarakan Tanggal dan Waktu Pernikahan', '2022-03-30 03:55:22', '2022-03-30 10:55:22'),
(286, 304, '14 Januari 2023', 'adfa', 'afs', '2022-05-21 15:41:22', '2022-05-21 22:41:22'),
(287, 305, 'Hej', 'He', 'He', '2023-08-01 16:16:58', '2023-08-01 23:16:58'),
(288, 305, 'Wudbe', 'Jekene', 'Ienebd', '2023-08-01 16:16:58', '2023-08-01 23:16:58'),
(289, 309, '13 januari 2020', 'pandangan pertama', 'ripuh', '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(290, 309, '13 januari 2020', 'pandangan pertama', 'goreng', '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(291, 310, 'ds', 'qwed', 'wqewq', '2023-11-21 00:25:03', '2023-11-21 07:25:03'),
(292, 311, '14 januari 2024', 'pertama', 'ya', '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(293, 311, '20 januari 2024', 'taaruf', 'ya', '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(294, 312, '14 januari 2020', 'Pertama anu', 'Anuam kiya', '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(295, 312, '20 januari 2020', 'Hahaa', 'Apa ya ini', '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(296, 313, 'Ndndn', 'Ndnndd', 'Nxnnxnx', '2023-12-15 10:49:33', '2023-12-15 17:49:33'),
(297, 313, 'Nxnnd', 'Ndnnd', 'Ndnnd', '2023-12-15 10:49:33', '2023-12-15 17:49:33'),
(298, 313, '', '', '', '2023-12-15 10:49:33', '2023-12-15 17:49:33');

-- --------------------------------------------------------

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `foto_pria` varchar(50) NOT NULL DEFAULT '0',
  `foto_wanita` varchar(50) NOT NULL DEFAULT '0',
  `maps` longtext DEFAULT NULL,
  `video` varchar(100) NOT NULL,
  `kunci` varchar(100) NOT NULL,
  `salam_pembuka` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token_wa` varchar(255) DEFAULT NULL,
  `salam_wa_atas` text NOT NULL,
  `salam_wa_bawah` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `data` (`id`, `id_user`, `foto_pria`, `foto_wanita`, `maps`, `video`, `kunci`, `salam_pembuka`, `token_wa`, `salam_wa_atas`, `salam_wa_bawah`, `created_at`, `updated_at`) VALUES
(1, 1, '1', '1', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3966.705836876672!2d106.82198811476884!3d-6.170129095532956!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e69f5d6aa94d477%3A0xebf3b9d252c86a26!2sMerdeka%20Palace!5e0!3m2!1sen!2sid!4v1595773648767!5m2!1sen!2sid\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 'https://youtu.be/PjHqsdT8pJQ', 'mIjh78y8ge13b89d99c1a29132e57d2ca', ' السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :	', '', 'Assalamualaikum Wr Wb\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih \n\nWassalamualaikum Wr Wb', '2020-07-26 14:16:43', '2022-04-01 17:57:06'),
(2, 303, '0', '0', '', '', '174cd83375fccca7c5c628537f974575', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2022-04-01 09:23:24', '2022-04-01 16:23:24'),
(3, 304, '1', '1', '', '', 'c5e3c1770e6ccad8326111fb0d58267e', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2022-05-21 15:41:22', '2022-05-21 22:41:22'),
(4, 305, '1', '1', '', '', 'a7acd85ba592ae0d1c7e8d168aa5d5fa', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-08-01 16:16:58', '2023-08-01 23:16:58'),
(5, 306, '1', '1', 'Nnn', '', '43afda33302537043ad14c2fd3f1bad1', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-08-02 07:31:19', '2023-08-02 14:31:19'),
(6, 307, '0', '0', '', '', 'd1f7d248f50182da12453e3a6987e7ac', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-08-15 07:38:55', '2023-08-15 14:38:55'),
(7, 309, '0', '0', '', '', '637f1884f84f3805639bb9899c1174c8', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(8, 310, '0', '0', 'j', '', '0080a4f78f432b5082f9e2698a1d29d8', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-11-21 00:25:03', '2023-11-21 07:25:03'),
(9, 311, '0', '0', '', '', '830dbcff8545d426cecd7d546c883be0', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(10, 312, '1', '1', 'Alamat', '', '7f4c99676ad3c109b48aa7f14d31749b', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(11, 313, '1', '1', '', '', '299e8a6ee28298850ec7c0b044cc8877', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', NULL, 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb', '2023-12-15 10:49:33', '2023-12-15 17:49:33');

-- --------------------------------------------------------

--
-- Table structure for table `komen`
--

CREATE TABLE `komen` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_komentar` varchar(50) NOT NULL,
  `isi_komentar` mediumtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `komen`
--

INSERT INTO `komen` (`id`, `id_user`, `nama_komentar`, `isi_komentar`, `created_at`, `updated_at`) VALUES
(1, 1, 'Aninda Safira', 'Alhamdulilah, selamat atas pernikahan kalian. Semoga pernikahan kalian dilimpahi oleh cinta, kebaikan dan kebahagiaan. Jazakallahu khairan khatira.. ', '2020-08-23 15:10:31', '2021-10-06 22:03:39'),
(2, 1, 'Raisa Andriana', 'Selamat menikah sahabatku, ‘Barakallahu lakum wa baraka alaikum’ ', '2020-08-22 15:12:45', '2020-08-22 01:17:42'),
(3, 1, 'Anisa Rahma', 'Alhamdulillah.. Selamat ya. Semoga Allah Swt selalu melimpahkan rahmatNya untuk pernikahan kalian.', '2020-08-20 15:14:44', '2020-08-22 01:18:37'),
(4, 1, 'Maudy Ayunda', 'MasyaAllah.. Selamat buat kalian berdua. Barakallah', '2020-08-22 15:32:50', '2021-10-06 22:03:39'),
(5, 1, 'Citra Kirana', 'Baarakallahu laka wa baaraka ‘alaika wa jama’a bainakumaa fii khaiir.\r\n\r\nSemoga Allah memberikan keberkahan untukmu dan atasmu, serta semoga Dia mengumpulkan di antara kalian berdua dalam kebaikan. ', '2020-07-26 16:00:41', '2021-10-06 22:03:39'),
(6, 1, 'Nissya Sabyan', 'Semoga pernikahan kalian langgeng dan selalu dinaungi petunjuk Allah dalam setiap langkah.. Aamiin', '2020-07-26 16:03:18', '2021-10-06 22:03:39'),
(7, 1, 'Tes', 'tesss', '2023-11-21 03:41:35', '2023-11-21 10:41:35');

-- --------------------------------------------------------

--
-- Table structure for table `mempelai`
--

CREATE TABLE `mempelai` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_pria` varchar(50) NOT NULL,
  `nama_panggilan_pria` varchar(50) NOT NULL,
  `nama_ibu_pria` varchar(50) NOT NULL,
  `nama_ayah_pria` varchar(50) NOT NULL,
  `nama_wanita` varchar(50) NOT NULL,
  `nama_panggilan_wanita` varchar(50) NOT NULL,
  `nama_ibu_wanita` varchar(50) NOT NULL,
  `nama_ayah_wanita` varchar(50) NOT NULL,
  `posisi_mempelai` enum('0','1') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mempelai`
--

INSERT INTO `mempelai` (`id`, `id_user`, `nama_pria`, `nama_panggilan_pria`, `nama_ibu_pria`, `nama_ayah_pria`, `nama_wanita`, `nama_panggilan_wanita`, `nama_ibu_wanita`, `nama_ayah_wanita`, `posisi_mempelai`, `created_at`, `updated_at`) VALUES
(1, 1, 'Andra Leksmana', 'Andra', 'Muslimah', 'Kusmanto', 'Siti Amelia', 'Amel', 'Siti Fatimah', 'Soekatmo', '0', '2020-07-26 14:16:43', '2022-03-08 21:47:25'),
(2, 303, 'Jack Sparrow', 'Jack', 'Kasniti', 'I Wayan Jarwa', 'Nadhifha Nukma Yasmine', 'Nadhifha', 'Sulastri', 'Miftahuddin', '0', '2022-04-01 09:23:24', '2022-04-01 16:23:24'),
(3, 304, 'Pirto Limbong', 'Pirto', 'Erika', 'Jamadin', 'Xontoh', 'Asdas', 'Asfafa', 'Afas', '0', '2022-05-21 15:41:22', '2022-05-21 22:41:22'),
(4, 305, 'Jack Down', 'Jack', 'Jack', 'Down', 'Fatme', 'Fat', 'Fat', 'Ma', '0', '2023-08-01 16:16:58', '2023-08-01 23:16:58'),
(5, 306, 'Jxnxnxn', 'Nznxn', 'Ndndn', 'Ndndn', 'E Dd', 'Nd', 'Jdd', 'Nd', '0', '2023-08-02 07:31:19', '2023-08-02 14:31:19'),
(6, 307, '1', 'Q', 'Q', 'Q', 'Y', 'S', 'D', 'D', '0', '2023-08-15 07:38:55', '2023-08-15 14:38:55'),
(7, 309, 'Aldi Albid', 'Aldi', 'Nana', 'Yuzonk', 'Icih', 'Icih', 'Hilda', 'Zilonk', '0', '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(8, 310, 'T', 'T', 'T', 'T', 'T', 'T', 'T', 'T', '0', '2023-11-21 00:25:03', '2023-11-21 07:25:03'),
(9, 311, 'Elvis', 'Elvis', 'Yur', 'Darson', 'Fitri', 'Fitri', 'Kasta', 'Pino', '0', '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(10, 312, 'Jack S', 'Javk', 'Juck', 'Javk', 'Zahya', 'Zahy', 'Zahy', 'Zahid', '0', '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(11, 313, '11', 'Asd', 'Qq', 'Aaa', 'Dd', 'Hh', 'Kk', 'Jj', '0', '2023-12-15 10:49:33', '2023-12-15 17:49:33');

-- --------------------------------------------------------

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `theme` varchar(50) NOT NULL,
  `id_paket` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id`, `id_user`, `domain`, `theme`, `id_paket`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'demo', '59', 3, 1, '2022-03-01 14:01:31', '2022-03-30 10:23:29'),
(2, 303, 'test', '5', 3, 1, '2022-04-01 09:23:24', '2022-04-01 16:23:24'),
(3, 304, 'tumorang', '52', 3, 1, '2022-05-21 15:41:22', '2022-05-21 22:41:22'),
(4, 305, 'Oke', '51', 3, 1, '2023-08-01 16:16:58', '2023-08-01 23:16:58'),
(5, 306, 'Lalal', '44', 1, 1, '2023-08-02 07:31:19', '2023-08-02 14:31:19'),
(6, 307, 'Putri-dodi', '49', 1, 1, '2023-08-15 07:38:55', '2023-08-15 14:38:55'),
(7, 309, 'aldialbod', '52', 2, 1, '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(8, 310, 'tes', '49', 1, 1, '2023-11-21 00:25:03', '2023-11-21 07:25:03'),
(9, 311, 'elvis&fitri', '52', 3, 1, '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(10, 312, 'hadehhhh', '1', 1, 1, '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(11, 313, '123', '63', 3, 1, '2023-12-15 10:49:33', '2023-12-15 17:55:21');

-- --------------------------------------------------------

--
-- Table structure for table `paket`
--

CREATE TABLE `paket` (
  `id_paket` int(11) NOT NULL,
  `nama_paket` varchar(100) NOT NULL,
  `harga_paket` varchar(100) NOT NULL,
  `masa_aktif` int(11) NOT NULL,
  `buku_tamu` int(11) NOT NULL,
  `kirim_whatsapp` int(11) NOT NULL,
  `tema_bebas` int(11) NOT NULL,
  `kirim_hadiah` int(11) NOT NULL,
  `import_datatamu` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paket`
--

INSERT INTO `paket` (`id_paket`, `nama_paket`, `harga_paket`, `masa_aktif`, `buku_tamu`, `kirim_whatsapp`, `tema_bebas`, `kirim_hadiah`, `import_datatamu`) VALUES
(1, 'Silver', '50000', 60, 0, 0, 0, 0, 0),
(2, 'Gold', '70000', 60, 0, 0, 1, 1, 0),
(3, 'Diamond', '100000', 60, 1, 1, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `pembayaran`
--

CREATE TABLE `pembayaran` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `nama_lengkap` varchar(200) DEFAULT NULL,
  `bukti` varchar(200) DEFAULT NULL,
  `nama_bank` varchar(100) NOT NULL,
  `va_number` varchar(200) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `harga` int(11) NOT NULL DEFAULT 0,
  `payment_type` varchar(200) NOT NULL,
  `transaction_status` varchar(100) NOT NULL,
  `transaction_time` datetime DEFAULT NULL,
  `transaction_expired` datetime DEFAULT NULL,
  `biller_code` varchar(100) DEFAULT NULL,
  `instruction` text NOT NULL,
  `status_order` enum('0','1') NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pembayaran`
--

INSERT INTO `pembayaran` (`id`, `id_user`, `invoice`, `nama_lengkap`, `bukti`, `nama_bank`, `va_number`, `status`, `created_at`, `harga`, `payment_type`, `transaction_status`, `transaction_time`, `transaction_expired`, `biller_code`, `instruction`, `status_order`) VALUES
(1, 1, '2203183', 'hhahhahahha', '2202159.png', 'permata', '8778009735519160', 2, '2023-08-21 14:28:19', 100000, 'bank_transfer', 'expire', '2022-03-30 07:22:57', '2022-03-30 08:22:57', '', '[{\"title\":\"Internet Banking\",\"steps\":[\"Masuk ke Internet Banking BSI Anda\",\"Pilih menu <b>Pembayaran<\\/b>\",\"Pilih nomor rekening Anda\",\"Pilih <b>Jenis Pembayaran > Institusi<\\/b>\",\"Pada opsi Nama Institusi, pilih <b>9042 Win Pay<\\/b>\",\"Masukkan kode bayar (<b>164856525400<\\/b>)\",\"Klik tombol <b>Verifikasi<\\/b>\",\"Akan ditampikan detail transaksi, pastikan sudah sesuai\",\"Masukkan TAN & PIN Anda\",\"Tekan tombol <b>Submit<\\/b>\",\"Transaksi selesai, simpan bukti pembayaran Anda\"]},{\"title\":\"BSI Mobile\",\"steps\":[\"Masuk ke aplikasi BSI Mobile Anda\",\"Pilih menu <b>Bayar<\\/b>\",\"Pilih menu <b>Institusi<\\/b>\",\"Pada opsi Nama Institusi, pilih <b>9042 Win Pay<\\/b>\",\"Masukkan kode bayar (<b>164856525400<\\/b>)\",\"Klik <b>Selanjutnya<\\/b>\",\"Masukkan PIN Anda\",\"Klik <b>Selanjutnya<\\/b>\",\"Akan ditampikan detail transaksi, pastikan sudah sesuai\",\"Klik <b>Selanjutnya<\\/b>\",\"Transaksi selesai, simpan bukti pembayaran Anda\"]},{\"title\":\"ATM BSI\",\"steps\":[\"Datang ke ATM BSI\",\"Masukkan kartu dan PIN kartu Anda\",\"Pilih menu <b>Pembayaran<\\/b>\",\"Pilih <b>Institusi<\\/b>\",\"Masukkan kode institusi 9042 + Nomor Virtual Account Anda. Contoh: <b>9042164856525400<\\/b>\",\"Tekan tombol <b>Benar<\\/b>\",\"Akan ditampikan detail transaksi, pastikan sudah sesuai\",\"Tekan tombol <b>BENAR\\/YA<\\/b>\",\"Transaksi selesai, simpan bukti pembayaran Anda\"]}]', '1'),
(2, 303, '220430325', NULL, NULL, '', '', 2, '2022-04-01 10:13:48', 100000, '', '', NULL, NULL, NULL, '', '1'),
(3, 304, '220530490', NULL, NULL, '', '', 2, '2022-05-21 15:48:28', 100000, '', '', NULL, NULL, NULL, '', '1'),
(4, 305, '230830586', NULL, NULL, '', '', 2, '2023-09-07 04:19:14', 100000, '', '', NULL, NULL, NULL, '', '1'),
(5, 306, '230830626', NULL, NULL, '', '', 0, '2023-08-02 07:31:19', 50000, '', '', NULL, NULL, NULL, '', '1'),
(6, 307, '230830757', NULL, NULL, '', '', 2, '2023-08-21 14:28:07', 50000, '', '', NULL, NULL, NULL, '', '1'),
(7, 309, '231130935', NULL, NULL, '', '', 2, '2023-11-23 18:13:56', 70000, '', '', NULL, NULL, NULL, '', '1'),
(8, 310, '231131051', NULL, NULL, '', '', 2, '2023-11-23 18:13:47', 50000, '', '', NULL, NULL, NULL, '', '1'),
(9, 311, '231131112', NULL, NULL, '', '', 0, '2023-11-24 09:35:54', 100000, '', '', NULL, NULL, NULL, '', '1'),
(10, 312, '231231250', NULL, NULL, '', '', 2, '2023-12-05 15:15:17', 50000, '', '', NULL, NULL, NULL, '', '1'),
(11, 313, '231231380', NULL, NULL, '', '', 2, '2023-12-15 10:50:02', 100000, '', '', NULL, NULL, NULL, '', '1');

-- --------------------------------------------------------

--
-- Table structure for table `pengunjung`
--

CREATE TABLE `pengunjung` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_pengunjung` varchar(100) NOT NULL,
  `addr` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pengunjung`
--

INSERT INTO `pengunjung` (`id`, `id_user`, `nama_pengunjung`, `addr`, `created_at`, `updated_at`) VALUES
(18, 304, 'Tamu Undangan', '2404:c0:5650::5e7:7b31', '2022-05-21 15:41:27', '2022-05-21 22:41:27'),
(19, 304, 'Tamu Undangan', '2404:c0:5650::5e7:7b31', '2022-05-21 15:48:59', '2022-05-21 22:48:59'),
(20, 305, 'Tamu Undangan', '112.215.210.105', '2023-08-01 16:17:12', '2023-08-01 23:17:12'),
(21, 306, 'Tamu Undangan', '180.253.123.169', '2023-08-02 07:31:34', '2023-08-02 14:31:34'),
(22, 307, 'Tamu Undangan', '114.125.60.236', '2023-08-15 07:39:12', '2023-08-15 14:39:12'),
(23, 307, 'Tamu Undangan', '103.211.160.144', '2023-08-15 07:47:55', '2023-08-15 14:47:55'),
(24, 307, 'Tamu Undangan', '36.68.221.196', '2023-08-18 00:42:31', '2023-08-18 07:42:31'),
(25, 305, 'Tamu Undangan', '36.68.221.196', '2023-08-18 00:42:37', '2023-08-18 07:42:37'),
(26, 307, 'Tamu Undangan', '125.166.182.114', '2023-08-21 14:29:20', '2023-08-21 21:29:20'),
(27, 307, 'Tamu Undangan', '125.166.182.114', '2023-08-21 14:32:06', '2023-08-21 21:32:06'),
(28, 1, 'Tamu Undangan', '125.166.182.114', '2023-08-21 14:38:05', '2023-08-21 21:38:05'),
(29, 1, 'Tamu Undangan', '112.215.238.25', '2023-09-01 14:35:19', '2023-09-01 21:35:19'),
(30, 304, 'Tamu Undangan', '112.215.235.197', '2023-09-01 14:40:13', '2023-09-01 21:40:13'),
(31, 303, 'Tamu Undangan', '103.126.87.20', '2023-09-04 11:43:32', '2023-09-04 18:43:32'),
(32, 303, 'Tamu Undangan', '103.126.87.20', '2023-09-04 11:43:44', '2023-09-04 18:43:44'),
(33, 307, 'Tamu Undangan', '103.126.87.20', '2023-09-04 11:44:50', '2023-09-04 18:44:50'),
(34, 1, 'Tamu Undangan', '103.126.87.20', '2023-09-04 12:20:28', '2023-09-04 19:20:28'),
(35, 1, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:11:52', '2023-09-07 11:11:52'),
(36, 1, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:13:48', '2023-09-07 11:13:48'),
(37, 307, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:15:52', '2023-09-07 11:15:52'),
(38, 305, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:20:33', '2023-09-07 11:20:33'),
(39, 1, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:23:54', '2023-09-07 11:23:54'),
(40, 305, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:38:04', '2023-09-07 11:38:04'),
(41, 305, 'Tamu Undangan', '182.253.105.226', '2023-09-07 04:38:12', '2023-09-07 11:38:12'),
(42, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 00:25:18', '2023-11-21 07:25:18'),
(43, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 00:25:28', '2023-11-21 07:25:28'),
(44, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 00:26:23', '2023-11-21 07:26:23'),
(45, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 00:28:46', '2023-11-21 07:28:46'),
(46, 1, 'Tamu Undangan', '205.178.183.170', '2023-11-21 03:34:51', '2023-11-21 10:34:51'),
(47, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 03:42:53', '2023-11-21 10:42:53'),
(48, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-21 03:46:58', '2023-11-21 10:46:58'),
(49, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:32:05', '2023-11-22 07:32:05'),
(50, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:32:46', '2023-11-22 07:32:46'),
(51, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:34:37', '2023-11-22 07:34:37'),
(52, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:34:47', '2023-11-22 07:34:47'),
(53, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:48:49', '2023-11-22 07:48:49'),
(54, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:49:55', '2023-11-22 07:49:55'),
(55, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:50:54', '2023-11-22 07:50:54'),
(56, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:51:55', '2023-11-22 07:51:55'),
(57, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:52:36', '2023-11-22 07:52:36'),
(58, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:56:44', '2023-11-22 07:56:44'),
(59, 309, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:56:54', '2023-11-22 07:56:54'),
(60, 1, 'Tamu Undangan', '205.178.183.170', '2023-11-22 00:58:20', '2023-11-22 07:58:20'),
(61, 310, 'Tamu Undangan', '182.2.69.63', '2023-11-22 02:11:39', '2023-11-22 09:11:39'),
(62, 310, 'Tamu Undangan', '182.2.69.63', '2023-11-22 02:17:48', '2023-11-22 09:17:48'),
(63, 310, 'Tes', '182.2.69.63', '2023-11-22 02:28:22', '2023-11-22 09:28:22'),
(64, 309, 'Tamu Undangan', '180.247.6.153', '2023-11-23 18:15:38', '2023-11-24 01:15:38'),
(65, 310, 'Tamu Undangan', '205.178.183.170', '2023-11-24 01:43:44', '2023-11-24 08:43:44'),
(66, 311, 'Tamu Undangan', '180.242.73.48', '2023-11-24 09:36:12', '2023-11-24 16:36:12'),
(67, 312, 'Tamu Undangan', '114.124.131.114', '2023-12-05 15:06:23', '2023-12-05 22:06:23'),
(68, 1, 'Tamu Undangan', '36.68.8.136', '2023-12-05 15:14:12', '2023-12-05 22:14:12'),
(69, 1, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:41:03', '2023-12-15 17:41:03'),
(70, 309, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:41:15', '2023-12-15 17:41:15'),
(71, 311, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:43:02', '2023-12-15 17:43:02'),
(72, 310, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:43:08', '2023-12-15 17:43:08'),
(73, 313, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:51:37', '2023-12-15 17:51:37'),
(74, 313, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:55:36', '2023-12-15 17:55:36'),
(75, 313, 'Tamu Undangan', '180.253.165.118', '2023-12-15 10:56:49', '2023-12-15 17:56:49'),
(76, 313, 'Tamu Undangan', '180.253.165.118', '2023-12-15 11:01:08', '2023-12-15 18:01:08'),
(77, 313, 'Tamu Undangan', '180.253.165.118', '2023-12-15 11:14:31', '2023-12-15 18:14:31');

-- --------------------------------------------------------

--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `id_quote` int(11) NOT NULL,
  `isi_quote` text DEFAULT NULL,
  `sumber_quote` varchar(100) DEFAULT NULL,
  `id_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `quote`
--

INSERT INTO `quote` (`id_quote`, `isi_quote`, `sumber_quote`, `id_user`) VALUES
(2, 'Tidak ada solusi yang lebih baik bagi dua insan yang saling mencintai di banding Pernikahan.', 'HR Ibnu Majah', 1);

-- --------------------------------------------------------

--
-- Table structure for table `rekening`
--

CREATE TABLE `rekening` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_bank` varchar(200) DEFAULT NULL,
  `no_rekening` varchar(200) DEFAULT NULL,
  `nama_pemilik` varchar(200) DEFAULT NULL,
  `qrcode_bank` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rekening`
--

INSERT INTO `rekening` (`id`, `id_user`, `nama_bank`, `no_rekening`, `nama_pemilik`, `qrcode_bank`) VALUES
(170, 1, 'OVO', '0812345678910', 'Demo', 'qrcode3.png');

-- --------------------------------------------------------

--
-- Table structure for table `rules`
--

CREATE TABLE `rules` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `sampul` int(11) NOT NULL,
  `mempelai` int(11) NOT NULL,
  `acara` int(11) NOT NULL,
  `komen` int(11) NOT NULL,
  `gallery` int(11) NOT NULL,
  `cerita` int(11) NOT NULL,
  `lokasi` int(11) NOT NULL,
  `prokes` int(11) NOT NULL,
  `qrcode` int(11) NOT NULL,
  `hadiah` int(11) NOT NULL,
  `quote` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rules`
--

INSERT INTO `rules` (`id`, `id_user`, `sampul`, `mempelai`, `acara`, `komen`, `gallery`, `cerita`, `lokasi`, `prokes`, `qrcode`, `hadiah`, `quote`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2020-07-26 14:16:43', '2022-03-27 22:05:54'),
(2, 303, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, '2022-04-01 09:23:24', '2022-04-01 16:23:24'),
(3, 304, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, '2022-05-21 15:41:22', '2022-05-21 22:41:22'),
(4, 305, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, '2023-08-01 16:16:58', '2023-09-07 11:20:14'),
(5, 306, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, '2023-08-02 07:31:19', '2023-08-02 14:31:19'),
(6, 307, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, '2023-08-15 07:38:55', '2023-08-15 14:38:55'),
(7, 309, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, '2023-11-06 05:17:27', '2023-11-06 12:17:27'),
(8, 310, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, '2023-11-21 00:25:03', '2023-11-21 07:25:03'),
(9, 311, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, '2023-11-24 09:35:54', '2023-11-24 16:35:54'),
(10, 312, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, '2023-12-05 15:06:18', '2023-12-05 22:06:18'),
(11, 313, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, '2023-12-15 10:49:33', '2023-12-15 17:49:33');

-- --------------------------------------------------------

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `harga` double NOT NULL,
  `img` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `trial` int(11) NOT NULL,
  `aktif` int(11) NOT NULL,
  `host_email` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `pass_email` varchar(255) DEFAULT NULL,
  `no_wa` varchar(15) DEFAULT NULL,
  `pesan_wa` text DEFAULT NULL,
  `salam_pembuka` longtext DEFAULT NULL,
  `wa_gateway` enum('nusagateway','starsender','onesender') NOT NULL DEFAULT 'nusagateway',
  `token_wa` varchar(255) DEFAULT NULL,
  `salam_wa_atas` text NOT NULL,
  `salam_wa_bawah` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `harga`, `img`, `created_at`, `trial`, `aktif`, `host_email`, `email`, `pass_email`, `no_wa`, `pesan_wa`, `salam_pembuka`, `wa_gateway`, `token_wa`, `salam_wa_atas`, `salam_wa_bawah`) VALUES
(1, 100000, 'bank.png', '2022-05-15 04:26:26', 2, 60, '', '', '', '6282311168586', 'Hello Admin NikahKuy, Saya Mau bertanya.', 'Assalamu\'alaikum Warahmatullahi Wabarakatuh.\n\nDengan memohon Rahmat dan Ridho Allah SWT, Kami akan menyelenggarakan resepsi pernikahan Putra-Putri kami :', 'starsender', '2f6a625e06edf217a6a6527150f70c532e604770', 'Assalamualaikum Wr Wb.\nDengan segala kerendahan hati dan syukur atas Karunia Allah SWT.\nKami bermaksud mengundang Bapak/Ibu/Saudara(i) pada acara pernikahan kami.', 'Merupakan suatu kebahagiaan bagi Kami apabila Bapak/Ibu/Saudara(i) berkenan hadir untuk memberikan doa restu kepada kami.\nAtas kehadiran dan doa restunya kami ucapkan terimakasih.\n\nWassalamualaikum Wr Wb');

-- --------------------------------------------------------

--
-- Table structure for table `setting_pembayaran`
--

CREATE TABLE `setting_pembayaran` (
  `id_setting` int(11) NOT NULL,
  `metode_bayar` enum('manual','midtrans','tripay') NOT NULL,
  `bank_manual` varchar(100) DEFAULT NULL,
  `norek_manual` varchar(100) DEFAULT NULL,
  `nama_manual` varchar(100) DEFAULT NULL,
  `url_midtrans` varchar(200) DEFAULT NULL,
  `serverkey_midtrans` varchar(200) DEFAULT NULL,
  `clientkey_midtrans` varchar(200) DEFAULT NULL,
  `midtrans_production` varchar(10) DEFAULT 'false',
  `url_tripay` varchar(100) DEFAULT NULL,
  `apikey_tripay` varchar(100) DEFAULT NULL,
  `privatekey_tripay` varchar(100) DEFAULT NULL,
  `merchantcode_tripay` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setting_pembayaran`
--

INSERT INTO `setting_pembayaran` (`id_setting`, `metode_bayar`, `bank_manual`, `norek_manual`, `nama_manual`, `url_midtrans`, `serverkey_midtrans`, `clientkey_midtrans`, `midtrans_production`, `url_tripay`, `apikey_tripay`, `privatekey_tripay`, `merchantcode_tripay`) VALUES
(1, 'midtrans', 'BNI', '12414', 'Vincenzo', 'https://app.midtrans.com/snap/snap.js', '', '', 'true', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `slider_bukutamu`
--

CREATE TABLE `slider_bukutamu` (
  `id_slider` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_slider` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `slider_bukutamu`
--

INSERT INTO `slider_bukutamu` (`id_slider`, `id_user`, `nama_slider`) VALUES
(1, 1, 'slider1'),
(2, 1, 'slider2'),
(3, 1, 'slider3'),
(36, 1, 'slider4'),
(37, 1, 'slider5');

-- --------------------------------------------------------

--
-- Table structure for table `tamu`
--

CREATE TABLE `tamu` (
  `id_tamu` int(11) NOT NULL,
  `nama_tamu` varchar(100) NOT NULL,
  `nama_slug` varchar(255) NOT NULL,
  `alamat_tamu` varchar(255) NOT NULL,
  `alamat_slug` varchar(255) NOT NULL,
  `no_wa` varchar(100) NOT NULL,
  `qrcode` varchar(255) NOT NULL,
  `id_user` int(11) NOT NULL,
  `tgl_kirim` date NOT NULL,
  `status_kirim` varchar(100) NOT NULL DEFAULT 'belum dikirim',
  `status` varchar(100) DEFAULT NULL,
  `waktu_hadir` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tamu`
--

INSERT INTO `tamu` (`id_tamu`, `nama_tamu`, `nama_slug`, `alamat_tamu`, `alamat_slug`, `no_wa`, `qrcode`, `id_user`, `tgl_kirim`, `status_kirim`, `status`, `waktu_hadir`) VALUES
(1, 'Bagus Jumawan', 'bagus+jumawan', 'Demak, Jawa Tengah', 'demak+jawa+tengah', '089659687659', '9756540c94be8be6dfe5ed007cfc79e1', 1, '2022-04-01', 'terkirim', 'hadir', '2022-03-10 10:32:50'),
(2, 'Kadek Sila', 'kadek+sila', 'Bali, Indonesia', 'bali+indonesia', '082237972112', 'dc879db724c3dabe409a6905988db685', 1, '2021-08-17', 'terkirim', 'hadir', '2022-03-11 09:49:44'),
(9, 'Bayu Sutrisno', 'bayu+sutrisno', 'Demak, Jawa Tengah', 'demak+jawa+tengah', '089659687659', 'd0d47b4f15aba1d2f895ea0114d91cce', 1, '2021-08-02', 'terkirim', NULL, '2022-01-27 21:29:21'),
(10, 'Maulana Arifin', 'maulana+arifin', 'Demak, Jawa Tengah', 'demak+jawa+tengah', '089659687659', '649d6a20cf7ef33e53ec124f7714d042', 1, '2021-08-02', 'terkirim', NULL, '2022-01-27 21:29:21'),
(11, 'PT. CIRCLE ART INDONESIA ', 'pt+circle+art+indonesia', 'Cianjur ', 'cianjur', '082121364741', 'bd213cadb6dec8ebbf345610c126577f', 305, '2023-08-02', 'belum dikirim', NULL, NULL),
(13, 'Agus', 'agus', 'Medan', 'medan', '081279721081', '982b2a731ea4320bdfeb8d41cb36e288', 311, '2023-11-24', 'belum dikirim', NULL, NULL),
(14, 'Sukamto', 'sukamto', 'Merdeka', 'merdeka', '082372316681', '077b3f50e1d73277daf7a1af3fe93527', 311, '2023-11-24', 'belum dikirim', NULL, NULL),
(15, '<script>alert(\'tes\')</script>', 'alerttes', '', '', '', '169a537c45ad3ccc051c70a9b8a98a93', 310, '0000-00-00', 'belum dikirim', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tema_categories`
--

CREATE TABLE `tema_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tema_categories`
--

INSERT INTO `tema_categories` (`id`, `name`, `slug`) VALUES
(1, 'Mobile', 'mobile'),
(2, 'Slide', 'slide'),
(3, 'Scroll', 'scroll');

-- --------------------------------------------------------

--
-- Table structure for table `testimoni`
--

CREATE TABLE `testimoni` (
  `id_testi` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_lengkap` varchar(100) DEFAULT NULL,
  `kota` varchar(100) DEFAULT NULL,
  `provinsi` varchar(100) DEFAULT NULL,
  `ulasan` text DEFAULT NULL,
  `status` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `testimoni`
--

INSERT INTO `testimoni` (`id_testi`, `id_user`, `nama_lengkap`, `kota`, `provinsi`, `ulasan`, `status`) VALUES
(3, 1, 'Andra Leksmana', 'Gambir', 'Jakarta', 'Sangat keren dan menarik, proses pembuatannya cepat dan bisa custom sendiri', 0),
(4, 303, NULL, NULL, NULL, NULL, 0),
(5, 304, NULL, NULL, NULL, NULL, 0),
(6, 305, NULL, NULL, NULL, NULL, 0),
(7, 306, NULL, NULL, NULL, NULL, 0),
(8, 307, NULL, NULL, NULL, NULL, 0),
(9, 309, NULL, NULL, NULL, NULL, 0),
(10, 310, NULL, NULL, NULL, NULL, 0),
(11, 311, NULL, NULL, NULL, NULL, 0),
(12, 312, NULL, NULL, NULL, NULL, 0),
(13, 313, NULL, NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) NOT NULL,
  `nama_theme` varchar(50) NOT NULL,
  `kode_theme` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `nama_theme`, `kode_theme`, `status`, `created_at`, `updated_at`, `category_id`) VALUES
(1, 'hwflower', 'A001', 1, '2020-07-26 13:23:40', '2022-02-18 15:58:22', 1),
(2, 'tealflower', 'A002', 1, '2020-07-26 13:23:40', '2022-02-18 15:58:22', 1),
(3, 'greenflower', 'A003', 1, '2020-08-17 01:03:22', '2022-02-18 15:58:22', 1),
(4, 'prettyflower', 'A004', 1, '2020-08-28 18:22:30', '2022-02-18 15:58:22', 1),
(5, 'blueroses', 'A005', 1, '2020-08-28 17:03:54', '2022-02-18 15:58:22', 1),
(6, 'redroses', 'A006', 1, '2020-08-28 17:04:08', '2022-02-18 15:58:22', 1),
(8, 'radiantyellow', 'A007', 1, '2020-08-28 19:56:29', '2022-02-18 15:58:22', 1),
(9, 'radiantdark', 'A009', 1, '2020-08-28 19:56:29', '2022-02-18 15:58:22', 1),
(44, 'purpleflower', 'A010', 1, '2021-07-04 02:03:44', '2022-02-18 15:58:22', 1),
(45, 'sketchflower', 'A011', 1, '2021-07-04 12:59:28', '2022-02-18 15:58:22', 1),
(49, 'beautiful-floral', 'A012', 1, '2021-09-17 23:52:39', '2022-02-18 16:00:23', 3),
(50, 'tapis', 'A013', 1, '2021-09-19 07:39:35', '2022-02-18 16:00:23', 2),
(51, 'rustic', 'A014', 1, '2021-09-20 04:46:10', '2022-02-18 16:00:23', 2),
(52, 'arabian', 'A015', 1, '2021-09-20 04:46:10', '2022-02-18 16:00:23', 3),
(53, 'jellyblack', 'A016', 1, '2021-09-20 04:46:28', '2022-02-18 16:00:23', 2),
(54, 'floral', 'A017', 1, '2021-09-20 04:46:55', '2022-02-18 16:00:23', 2),
(55, 'vintage-islamic', 'A018', 1, '2021-09-20 04:46:55', '2022-02-18 16:00:23', 2),
(59, 'islamic1', 'A019', 1, '2022-01-15 02:12:52', '2022-02-18 16:00:23', 3),
(60, 'watercolor1', 'A020', 1, '2022-01-15 02:12:52', '2022-02-18 16:00:23', 3),
(61, 'twelve', 'A021', 1, '2022-01-28 09:37:46', '2022-02-18 16:00:23', 3),
(63, 'mandala', 'A022', 1, '2022-02-17 04:21:17', '2022-03-24 09:30:55', 2),
(67, 'watercolor2', 'A026', 1, '2022-02-24 02:00:36', '2022-02-25 00:09:25', 3),
(68, 'watercolor3', 'A027', 1, '2022-02-24 02:02:36', '2022-02-25 00:14:54', 3),
(69, 'watercolor4', 'A028', 1, '2022-02-24 02:03:24', '2022-02-25 00:14:54', 3),
(70, 'watercolor5', 'A029', 1, '2022-02-24 02:04:10', '2022-02-25 00:14:54', 3);

-- --------------------------------------------------------

--
-- Table structure for table `themes_video`
--

CREATE TABLE `themes_video` (
  `id_theme` int(11) NOT NULL,
  `nama_tema` varchar(100) NOT NULL,
  `harga` int(11) NOT NULL,
  `preview` varchar(200) NOT NULL,
  `url_video` varchar(250) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `themes_video`
--

INSERT INTO `themes_video` (`id_theme`, `nama_tema`, `harga`, `preview`, `url_video`, `category_id`) VALUES
(1, 'Kode 01', 40000, 'kode_01.png', '<iframe src=\"https://drive.google.com/file/d/1OyLGmbmBooRg_dFHtNX_ZOg0VZUWkwxV/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(2, 'Kode 02', 40000, 'kode_02.png', '<iframe src=\"https://drive.google.com/file/d/1BvinpaAotK-xHXgE_OziR9D2HufFZ12p/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(3, 'Kode 03', 40000, 'kode_03.png', '<iframe src=\"https://drive.google.com/file/d/1gOP05_koMTKzsjy1PIfyWV-NlLCwRN6Q/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(4, 'Kode 04', 40000, 'kode_04.png', '<iframe src=\"https://drive.google.com/file/d/1psKTtjNJqiaCyuGqLQfAsUj6Ojtb4_qy/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(5, 'Kode 05', 40000, 'kode_05.png', '<iframe src=\"https://drive.google.com/file/d/1z65eVHOYKdMIp7X2zEmeWnEBg3AtpJ5y/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(6, 'Kode 06', 40000, 'kode_06.png', '<iframe src=\"https://drive.google.com/file/d/1G-N68I75X8aQ3PqQS-A13jJ1KYvATh64/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 1),
(7, 'Kode 07', 40000, 'kode_07.png', '<iframe src=\"https://drive.google.com/file/d/1niwHJOkM3M-NJDad7eTzz_M9bS3XXjX_/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(8, 'Kode 08', 40000, 'kode_08.png', '<iframe src=\"https://drive.google.com/file/d/1dlurlHQcI-qEdAfzqALIqeiifor4A1kz/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(9, 'Kode 09', 40000, 'kode_09.png', '<iframe src=\"https://drive.google.com/file/d/16_vSP99YkEPK0U4bdWn1-0mrqHMJhgEK/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(10, 'Kode 10', 40000, 'kode_10.png', '<iframe src=\"https://drive.google.com/file/d/1ek9-CEUrn4rjhoHvLXxUfW7mm0OD8YxN/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(11, 'Kode 11', 40000, 'kode_11.png', '<iframe src=\"https://drive.google.com/file/d/17dcyya0OeY848DjaT-Jn2keUGeqWBF2T/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(12, 'Kode 12', 40000, 'kode_12.png', '<iframe src=\"https://drive.google.com/file/d/1FOccAQ88gZIEh5QlzWvENXnTqzn2-igb/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(13, 'Kode 13', 40000, 'kode_13.png', '<iframe src=\"https://drive.google.com/file/d/1wAoLV_lZEFEWdqkpKiMSfE2CriiUY-Wo/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(14, 'Kode 14', 40000, 'kode_14.png', '<iframe src=\"https://drive.google.com/file/d/1hkU9Zo3LZ5itviqX8hHpUbSAE2NE0HQJ/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(15, 'Kode 15', 40000, 'kode_15.png', '<iframe src=\"https://drive.google.com/file/d/122Ua8UIewzb6cQS6fcbtTz3ax9pWHDz4/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(20, 'Kode 16', 40000, 'kode_16.png', '<iframe src=\"https://drive.google.com/file/d/1TyS6-wuCwkC_NI3PicZXsyrCGokYRYAy/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 2),
(25, 'Kode 17', 40000, 'kode_17.png', '<iframe src=\"https://drive.google.com/file/d/16-6NrD_BvVQFEXq5iRxaLyS7jLndqKjc/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(26, 'Kode 18', 40000, 'kode_18.png', '<iframe src=\"https://drive.google.com/file/d/13GVMcTO6qEEx_1aZAaE6xJdw62dY1Lcu/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(27, 'Kode 19', 40000, 'kode_19.png', '<iframe src=\"https://drive.google.com/file/d/1hf8dcyrb4nvOuqwslJuidz8aW0Xqss_a/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(28, 'Kode 20', 40000, 'kode_20.png', '<iframe src=\"https://drive.google.com/file/d/1v_aqcSpj_M5-mWrYdxLse5VVALxZQXvQ/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(29, 'Kode 21', 40000, 'kode_21.png', '<iframe src=\"https://drive.google.com/file/d/1ckXCj5aAS1Ki7G7lIQ4o3DordGAWteV-/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(30, 'Kode 22', 40000, 'kode_22.png', '<iframe src=\"https://drive.google.com/file/d/1koayXRVm_Ibh68odpXgIBoJ8uZ_DHrI1/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(31, 'Kode 23', 40000, 'kode_23.png', '<iframe src=\"https://drive.google.com/file/d/1IxdMkfl_OCO4yfRoeHec42lcZEw-vPTG/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(32, 'Kode 24', 40000, 'kode_24.png', '<iframe src=\"https://drive.google.com/file/d/1sXAGGM1WprmmmuIEa8Q2afZcpjE3dRDZ/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(33, 'Kode 25', 40000, 'kode_25.png', '<iframe src=\"https://drive.google.com/file/d/1PHga9AwwEFxAD7eNwLz55jCkw-HZ_cO5/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(34, 'Kode 26', 40000, 'kode_26.png', '<iframe src=\"https://drive.google.com/file/d/1BO1f_b-ycz30GPiE56emaUAu2m2RJ1zC/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 3),
(35, 'Kode 27', 40000, 'kode_27.png', '<iframe src=\"https://drive.google.com/file/d/1GX1vAXqzwvbkTH7AAQPficafmIJ1uG9N/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 4),
(36, 'Kode 28', 40000, 'kode_28.png', '<iframe src=\"https://drive.google.com/file/d/1vh3oq92-PQfg1LTltI3J5BjdLASzChAL/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 4),
(37, 'Kode 29', 40000, 'kode_29.png', '<iframe src=\"https://drive.google.com/file/d/1ziEnVA9LdabmO6nWT0boAjLFr3F6viYY/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 4),
(38, 'Kode 30', 40000, 'kode_30.png', '<iframe src=\"https://drive.google.com/file/d/1OrO1_g2vSiElDQPNfhkq4THqOxC-TjYW/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 4),
(39, 'Kode 31', 40000, 'kode_31.png', '<iframe src=\"https://drive.google.com/file/d/1p5NIEnRqP-dPao-CTho0KY0n3CoDUzJM/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(40, 'Kode 32', 40000, 'kode_32.png', '<iframe src=\"https://drive.google.com/file/d/14qHnyViXGjDAcDxDzdKjYEHj1vmTRoUw/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(41, 'Kode 33', 40000, 'kode_33.png', '<iframe src=\"https://drive.google.com/file/d/1xcKpK_9r18-3f4_QAM-QDa2ev0G_7ZIH/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(42, 'Kode 34', 40000, 'kode_34.png', '<iframe src=\"https://drive.google.com/file/d/1qswmddDVgzc3hXEsOpFo_QVW8SoVpyhl/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(43, 'Kode 35', 40000, 'kode_35.png', '<iframe src=\"https://drive.google.com/file/d/1GOUNAlptuhZ83O6ZHebdwf8KKbnlXeeU/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(44, 'Kode 36', 40000, 'kode_36.png', '<iframe src=\"https://drive.google.com/file/d/1LX3VEGhKdXSAjF4D6TAGV5ebyGoZMmFT/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(45, 'Kode 37', 40000, 'kode_37.png', '<iframe src=\"https://drive.google.com/file/d/11spFRdgPZPq1hZpzPW_NsSzTYKrk22iK/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(46, 'Kode 38', 40000, 'kode_38.png', '<iframe src=\"https://drive.google.com/file/d/1Rz2HLPo2BoCRPFIWXZYt38aBv0I4VWrt/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(47, 'Kode 39', 40000, 'kode_39.png', '<iframe src=\"https://drive.google.com/file/d/1L1DCdp09i56_R6fwCdEdPDHH7xz_pqeA/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(48, 'Kode 40', 40000, 'kode_40.png', '<iframe src=\"https://drive.google.com/file/d/1XfOfdlI83d_7RIQLeFob9HoOBGb55FOd/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(49, 'Kode 41', 40000, 'kode_41.png', '<iframe src=\"https://drive.google.com/file/d/1KGx7Ns4DcFibDpQiK3ravUBuUYFKYKTC/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(50, 'Kode 42', 40000, 'kode_42.png', '<iframe src=\"https://drive.google.com/file/d/1Mpw6VXNOvsdsPrxUCQ-MMJeySMos7cEh/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(51, 'Kode 43', 40000, 'kode_43.png', '<iframe src=\"https://drive.google.com/file/d/1EvXINx9hysFIlwa6HpWcdcTtlrjEC2F0/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(52, 'Kode 44', 40000, 'kode_44.png', '<iframe src=\"https://drive.google.com/file/d/1vv3A7KlOMLO3bi6npSUh8n7XjxNOMGVw/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(53, 'Kode 45', 40000, 'kode_45.png', '<iframe src=\"https://drive.google.com/file/d/14_Ka45Z1MWwlzXfJsmKFOw9Bxnv-O1y6/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(54, 'Kode 46', 40000, 'kode_46.png', '<iframe src=\"https://drive.google.com/file/d/13qYybj3gICbZ9ow_tpqmGKbiUE5WvcN4/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(55, 'Kode 47', 40000, 'kode_47.png', '<iframe src=\"https://drive.google.com/file/d/1wglyjVQNl8gZsnz_Z0PEKfiskNoDC9nG/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(56, 'Kode 48', 40000, 'kode_48.png', '<iframe src=\"https://drive.google.com/file/d/1B1GlR9dG8kbBmyauTlTctuFh2EPn8ULp/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(57, 'Kode 49', 40000, 'kode_49.png', '<iframe src=\"https://drive.google.com/file/d/1FC8Lp5b99Eo0upR71sTev1qD-5XU6N-4/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(58, 'Kode 50', 40000, 'kode_50.png', '<iframe src=\"https://drive.google.com/file/d/1McUMlXvCoB0grlrsHQjNxoqK_1ntGg33/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(59, 'Kode 51', 40000, 'kode_51.png', '<iframe src=\"https://drive.google.com/file/d/1W4DdLgcPWe3hIdN3UReTBtUVUagPi-lh/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(60, 'Kode 52', 40000, 'kode_52.png', '<iframe src=\"https://drive.google.com/file/d/1sVobKAEynfB_tm-1voTJJ8xXQNt_LKJs/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(61, 'Kode 53', 40000, 'kode_53.png', '<iframe src=\"https://drive.google.com/file/d/1vzdwgRTcYpDwmJDSZE9d4K9l7ck_2Ps9/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(62, 'Kode 54', 40000, 'kode_54.png', '<iframe src=\"https://drive.google.com/file/d/1Q03xoPiM8OeRny-KiWDAn7WAc-m918_5/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(63, 'Kode 55', 40000, 'kode_55.png', '<iframe src=\"https://drive.google.com/file/d/1rWzIoqfUWeIeFDBOT_6tZahkGombq3yH/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(64, 'Kode 56', 40000, 'kode_56.png', '<iframe src=\"https://drive.google.com/file/d/1-1GC8H51_-zsFEAmV7--9onZB9I4jvgT/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(65, 'Kode 57', 40000, 'kode_57.png', '<iframe src=\"https://drive.google.com/file/d/1Y8sHoNrBgWZBiml4PLiC6xstpW5jem6c/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5),
(66, 'Kode 58', 40000, 'kode_58.png', '<iframe src=\"https://drive.google.com/file/d/1E96VJFFxt6Q3PQxPFDYYTDBLzYOow3Hy/preview\" width=\"640\" height=\"480\" allow=\"autoplay\"></iframe>', 5);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `hp` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `id_unik` varchar(500) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `token` text DEFAULT NULL,
  `created_token` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `hp`, `email`, `username`, `password`, `id_unik`, `created_at`, `token`, `created_token`) VALUES
(1, '089659687659', 'demo@gmail.com', 'Demo', '2278a0f743d90e23b2fb4d009e6af10a', '2007155', '2020-07-26 14:16:42', '', '2022-01-09 03:35:18'),
(303, '089659687659', 'abgtua93@gmail.com', 'abgtua93@gmail.com', '446419aa4b2c2368f29d8298c1cf71a2', '220430325', '2022-04-01 09:23:23', NULL, NULL),
(304, '6282311168586', 'oppungcode@gmail.com', 'oppungcode@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '220530490', '2022-05-21 15:41:22', NULL, NULL),
(305, '081312736360', 'greatdesign97@gmail.com', 'greatdesign97@gmail.com', '88c304566935c980661ae5073352205d', '230830586', '2023-08-01 16:16:58', NULL, NULL),
(306, '085241878999', 'nourapayment@gmail.com', 'nourapayment@gmail.com', '8acfb25af261e1d3aec89b497fdb4cae', '230830626', '2023-08-02 07:31:19', NULL, NULL),
(307, '89525042195', 'redmikuali@gmail.com', 'redmikuali@gmail.com', 'c4ca4238a0b923820dcc509a6f75849b', '230830757', '2023-08-15 07:38:55', NULL, NULL),
(308, '0813455678', 'ahyo.sw@gmail.com', 'ahyo.sw@gmail.com', '202cb962ac59075b964b07152d234b70', '230930876', '2023-09-01 05:57:32', NULL, NULL),
(309, '085798209051', 'ahmadsanjaya29@gmail.com', 'ahmadsanjaya29@gmail.com', '49bd05b5363cc16dd772b8a85ba3dbf3', '231130935', '2023-11-06 05:17:27', NULL, NULL),
(310, '12345678', 'tes@ting.com', 'tes@ting.com', '25d55ad283aa400af464c76d713c07ad', '231131051', '2023-11-21 00:25:03', NULL, NULL),
(311, '082372316681', 'elvis@gmail.com', 'elvis@gmail.com', 'b3128063ef51bd7d61ceee104346526b', '231131112', '2023-11-24 09:35:54', NULL, NULL),
(312, '6287825869784', 'Novia7886@gmail.com', 'Novia7886@gmail.com', '18aa06576d9cb4e1520b4b09ca1ff6e8', '231231253', '2023-12-05 15:06:18', NULL, NULL),
(313, '11111111', '123@gmail.com', '123@gmail.com', '25d55ad283aa400af464c76d713c07ad', '231231380', '2023-12-15 10:49:33', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `video_categories`
--

CREATE TABLE `video_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `slug` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `video_categories`
--

INSERT INTO `video_categories` (`id`, `name`, `slug`) VALUES
(1, 'Elegant', 'elegant'),
(2, 'Islamic', 'islamic'),
(3, 'Minimalist', 'minimalist'),
(4, 'Overlay', 'overlay'),
(5, 'Watercolor', 'watercolor');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `acara`
--
ALTER TABLE `acara`
  ADD PRIMARY KEY (`id_acara`);

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `album`
--
ALTER TABLE `album`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cerita`
--
ALTER TABLE `cerita`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data`
--
ALTER TABLE `data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `komen`
--
ALTER TABLE `komen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mempelai`
--
ALTER TABLE `mempelai`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `paket`
--
ALTER TABLE `paket`
  ADD PRIMARY KEY (`id_paket`);

--
-- Indexes for table `pembayaran`
--
ALTER TABLE `pembayaran`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pengunjung`
--
ALTER TABLE `pengunjung`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quote`
--
ALTER TABLE `quote`
  ADD PRIMARY KEY (`id_quote`);

--
-- Indexes for table `rekening`
--
ALTER TABLE `rekening`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rules`
--
ALTER TABLE `rules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `setting_pembayaran`
--
ALTER TABLE `setting_pembayaran`
  ADD PRIMARY KEY (`id_setting`);

--
-- Indexes for table `slider_bukutamu`
--
ALTER TABLE `slider_bukutamu`
  ADD PRIMARY KEY (`id_slider`);

--
-- Indexes for table `tamu`
--
ALTER TABLE `tamu`
  ADD PRIMARY KEY (`id_tamu`);

--
-- Indexes for table `tema_categories`
--
ALTER TABLE `tema_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimoni`
--
ALTER TABLE `testimoni`
  ADD PRIMARY KEY (`id_testi`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `themes_video`
--
ALTER TABLE `themes_video`
  ADD PRIMARY KEY (`id_theme`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `video_categories`
--
ALTER TABLE `video_categories`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `acara`
--
ALTER TABLE `acara`
  MODIFY `id_acara` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=220;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `album`
--
ALTER TABLE `album`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=475;

--
-- AUTO_INCREMENT for table `cerita`
--
ALTER TABLE `cerita`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=299;

--
-- AUTO_INCREMENT for table `data`
--
ALTER TABLE `data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `komen`
--
ALTER TABLE `komen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `mempelai`
--
ALTER TABLE `mempelai`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `paket`
--
ALTER TABLE `paket`
  MODIFY `id_paket` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `pembayaran`
--
ALTER TABLE `pembayaran`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `pengunjung`
--
ALTER TABLE `pengunjung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `quote`
--
ALTER TABLE `quote`
  MODIFY `id_quote` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `rekening`
--
ALTER TABLE `rekening`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT for table `rules`
--
ALTER TABLE `rules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `setting_pembayaran`
--
ALTER TABLE `setting_pembayaran`
  MODIFY `id_setting` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `slider_bukutamu`
--
ALTER TABLE `slider_bukutamu`
  MODIFY `id_slider` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `tamu`
--
ALTER TABLE `tamu`
  MODIFY `id_tamu` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tema_categories`
--
ALTER TABLE `tema_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `testimoni`
--
ALTER TABLE `testimoni`
  MODIFY `id_testi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `themes_video`
--
ALTER TABLE `themes_video`
  MODIFY `id_theme` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=314;

--
-- AUTO_INCREMENT for table `video_categories`
--
ALTER TABLE `video_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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 */;