-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 10, 2026 at 06:54 PM
-- Server version: 8.4.3
-- PHP Version: 8.3.30

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

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint UNSIGNED DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint UNSIGNED NOT NULL,
  `invitation_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Regular',
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rsvp_status` enum('pending','hadir','tidak_hadir','ragu') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `comment` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `invitations`
--

CREATE TABLE `invitations` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_id` bigint UNSIGNED NOT NULL,
  `event_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pernikahan',
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','active','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `event_date` datetime NOT NULL,
  `content` json NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_01_01_035804_create_themes_table', 1),
(5, '2026_01_01_035805_create_invitations_table', 1),
(6, '2026_01_01_035806_create_guests_table', 1),
(7, '2026_02_21_000001_add_indexes_for_performance', 1),
(8, '2026_02_21_000002_create_activity_logs_table', 1),
(9, '2026_02_21_103050_add_price_to_themes_table', 1),
(10, '2026_02_22_025139_add_cancelled_to_status_enum_on_invitations_table', 1),
(11, '2026_02_22_030155_add_promo_price_to_themes_table', 1),
(12, '2026_03_04_020000_create_orders_table', 1),
(13, '2026_05_10_000001_add_event_type_to_themes_and_invitations', 1),
(14, '2026_05_11_000001_add_builder_config_to_themes', 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `unique_code` int NOT NULL,
  `total_amount` bigint NOT NULL,
  `status` enum('pending','paid','expired') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `expired_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `themes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `view_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pernikahan',
  `builder_config` json DEFAULT NULL,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` int UNSIGNED DEFAULT NULL COMMENT 'Harga per tema dalam Rupiah. NULL = pakai default dari APP_DEFAULT_PRICE di .env',
  `promo_price` int DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `themes` (`id`, `name`, `slug`, `view_path`, `event_type`, `builder_config`, `thumbnail`, `price`, `promo_price`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Rustic Green', 'rustic-green', 'themes.rustic-green.index', 'pernikahan', NULL, 'rustic-green.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(2, 'Floral Pastel', 'floral-pastel', 'themes.floral-pastel.index', 'pernikahan', NULL, 'floral-pastel.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(3, 'Royal Glass', 'royal-glass', 'themes.royal-glass.index', 'pernikahan', NULL, 'royal-glass.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(4, 'Barakah Love', 'barakah-love', 'themes.barakah-love.index', 'pernikahan', NULL, 'barakah-love.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(5, 'Boho Terracotta', 'boho-terracotta', 'themes.boho-terracotta.index', 'pernikahan', NULL, 'boho-terracotta.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(6, 'Emerald Garden', 'emerald-garden', 'themes.emerald-garden.index', 'pernikahan', NULL, 'emerald-garden.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(7, 'Ocean Breeze', 'ocean-breeze', 'themes.ocean-breeze.index', 'pernikahan', NULL, 'ocean-breeze.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(8, 'Watercolor Flow', 'watercolor-flow', 'themes.watercolor-flow.index', 'pernikahan', NULL, 'watercolor-flow.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(9, 'Golden Sunrise', 'golden-sunrise', 'themes.golden-sunrise.index', 'pernikahan', NULL, 'golden-sunrise.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(10, 'Jawa Keraton', 'jawa-keraton', 'themes.jawa-keraton.index', 'pernikahan', NULL, 'jawa-keraton.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(11, 'Midnight Garden', 'midnight-garden', 'themes.midnight-garden.index', 'pernikahan', NULL, 'midnight-garden.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(12, 'Sekar Jagad', 'sekar-jagad', 'themes.sekar-jagad.index', 'pernikahan', NULL, 'sekar-jagad.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(13, 'Sunda Asih', 'sunda-asih', 'themes.sunda-asih.index', 'pernikahan', NULL, 'sunda-asih.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(14, 'Barakah Khitanan', 'barakah-khitanan', 'themes.barakah-khitanan.index', 'khitanan', NULL, 'barakah-khitanan.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(15, 'Emerald Aqiqah', 'emerald-aqiqah', 'themes.emerald-aqiqah.index', 'aqiqah', NULL, 'emerald-aqiqah.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(16, 'Floral Ultah', 'floral-ultah', 'themes.floral-ultah.index', 'ulang_tahun', NULL, 'floral-ultah.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(17, 'Pengajian Akbar', 'pengajian-akbar', 'themes.pengajian-akbar.index', 'pengajian', NULL, 'pengajian-akbar.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(18, 'Royal Event', 'royal-event', 'themes.royal-event.index', 'event', NULL, 'royal-event.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(19, 'Motion Garden 3D', 'motion-garden', 'themes.motion-garden.index', 'pernikahan', NULL, 'motion-garden.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(20, 'Pristine White', 'pristine-white', 'themes.pristine-white.index', 'pernikahan', NULL, 'pristine-white.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(21, 'Cordova Moorish', 'cordova-moorish', 'themes.cordova-moorish.index', 'khitanan', NULL, 'cordova-moorish.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(22, 'Sakina Pastel', 'sakina-pastel', 'themes.sakina-pastel.index', 'aqiqah', NULL, 'sakina-pastel.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(23, 'Confetti Pop', 'confetti-pop', 'themes.confetti-pop.index', 'ulang_tahun', NULL, 'confetti-pop.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(24, 'Nur Calligraphy', 'nur-calligraphy', 'themes.nur-calligraphy.index', 'pengajian', NULL, 'nur-calligraphy.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(25, 'Onyx Formal', 'onyx-formal', 'themes.onyx-formal.index', 'event', NULL, 'onyx-formal.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(26, 'Ocean Pearl', 'ocean-pearl', 'themes.ocean-pearl.index', 'pernikahan', NULL, 'ocean-pearl.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(27, 'Mubarak Festive', 'mubarak-festive', 'themes.mubarak-festive.index', 'khitanan', NULL, 'mubarak-festive.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(28, 'Lullaby Cloud', 'lullaby-cloud', 'themes.lullaby-cloud.index', 'aqiqah', NULL, 'lullaby-cloud.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(29, 'Vintage Bloom', 'vintage-bloom', 'themes.vintage-bloom.index', 'ulang_tahun', NULL, 'vintage-bloom.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(30, 'Sufi Whirl', 'sufi-whirl', 'themes.sufi-whirl.index', 'pengajian', NULL, 'sufi-whirl.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(31, 'Midnight Lounge', 'midnight-lounge', 'themes.midnight-lounge.index', 'event', NULL, 'midnight-lounge.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(32, 'Javanese Classic', 'javanese-classic', 'themes.javanese-classic.index', 'pernikahan', NULL, 'javanese-classic.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(33, 'Tropical Paradise', 'tropical-paradise', 'themes.tropical-paradise.index', 'pernikahan', NULL, 'tropical-paradise.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(34, 'Korean Minimal', 'korean-minimal', 'themes.korean-minimal.index', 'pernikahan', NULL, 'korean-minimal.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(35, 'Garden Romance', 'garden-romance', 'themes.garden-romance.index', 'pernikahan', NULL, 'garden-romance.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(36, 'Mountain Mist', 'mountain-mist', 'themes.mountain-mist.index', 'pernikahan', NULL, 'mountain-mist.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(37, 'Bunga Sakura', 'bunga-sakura', 'themes.bunga-sakura.index', 'khitanan', NULL, 'bunga-sakura.png', NULL, NULL, 1, '2026-05-10 11:54:14', '2026-05-10 11:54:14'),
(38, 'Prince Blue', 'prince-blue', 'themes.prince-blue.index', 'khitanan', NULL, 'prince-blue.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(39, 'Mosque Night', 'mosque-night', 'themes.mosque-night.index', 'khitanan', NULL, 'mosque-night.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(40, 'Hijau Syari', 'hijau-syari', 'themes.hijau-syari.index', 'khitanan', NULL, 'hijau-syari.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(41, 'Bintang Cerah', 'bintang-cerah', 'themes.bintang-cerah.index', 'khitanan', NULL, 'bintang-cerah.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(42, 'Vanilla Mint', 'vanilla-mint', 'themes.vanilla-mint.index', 'aqiqah', NULL, 'vanilla-mint.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(43, 'Forest Fairy', 'forest-fairy', 'themes.forest-fairy.index', 'aqiqah', NULL, 'forest-fairy.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(44, 'Rainbow Baby', 'rainbow-baby', 'themes.rainbow-baby.index', 'aqiqah', NULL, 'rainbow-baby.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(45, 'Animal Friends', 'animal-friends', 'themes.animal-friends.index', 'aqiqah', NULL, 'animal-friends.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(46, 'Cuddly Bear', 'cuddly-bear', 'themes.cuddly-bear.index', 'aqiqah', NULL, 'cuddly-bear.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(47, 'Galaxy Party', 'galaxy-party', 'themes.galaxy-party.index', 'ulang_tahun', NULL, 'galaxy-party.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(48, 'Superhero Dynamic', 'superhero-dynamic', 'themes.superhero-dynamic.index', 'ulang_tahun', NULL, 'superhero-dynamic.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(49, 'Princess Castle', 'princess-castle', 'themes.princess-castle.index', 'ulang_tahun', NULL, 'princess-castle.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(50, 'Candy Land', 'candy-land', 'themes.candy-land.index', 'ulang_tahun', NULL, 'candy-land.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(51, 'Balloon Burst', 'balloon-burst', 'themes.balloon-burst.index', 'ulang_tahun', NULL, 'balloon-burst.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(52, 'Emerald Quran', 'emerald-quran', 'themes.emerald-quran.index', 'pengajian', NULL, 'emerald-quran.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(53, 'Arabic Tile', 'arabic-tile', 'themes.arabic-tile.index', 'pengajian', NULL, 'arabic-tile.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(54, 'Dome Ornament', 'dome-ornament', 'themes.dome-ornament.index', 'pengajian', NULL, 'dome-ornament.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(55, 'Kaligrafi Emas', 'kaligrafi-emas', 'themes.kaligrafi-emas.index', 'pengajian', NULL, 'kaligrafi-emas.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(56, 'Kabah Ornament', 'kabah-ornament', 'themes.kabah-ornament.index', 'pengajian', NULL, 'kabah-ornament.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(57, 'Gradient Sunset', 'gradient-sunset', 'themes.gradient-sunset.index', 'event', NULL, 'gradient-sunset.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(58, 'Corporate Gold', 'corporate-gold', 'themes.corporate-gold.index', 'event', NULL, 'corporate-gold.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(59, 'Art Deco', 'art-deco', 'themes.art-deco.index', 'event', NULL, 'art-deco.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(60, 'Festival Vibe', 'festival-vibe', 'themes.festival-vibe.index', 'event', NULL, 'festival-vibe.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15'),
(61, 'Vintage Cinema', 'vintage-cinema', 'themes.vintage-cinema.index', 'event', NULL, 'vintage-cinema.png', NULL, NULL, 1, '2026-05-10 11:54:15', '2026-05-10 11:54:15');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` enum('admin','client') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'client',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Test User', 'test@example.com', NULL, '$2y$12$3dgSu87dQkNXZOK7GNwfHuBzEHeJwGubxAuxANC/4bsY6Bo9HrMJq', 'admin', NULL, '2026-05-10 11:54:14', '2026-05-10 11:54:14');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_type_index` (`type`),
  ADD KEY `activity_logs_event_index` (`event`),
  ADD KEY `activity_logs_user_id_index` (`user_id`),
  ADD KEY `activity_logs_created_at_index` (`created_at`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `guests`
--
ALTER TABLE `guests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `guests_invitation_id_index` (`invitation_id`),
  ADD KEY `guests_rsvp_status_index` (`rsvp_status`);

--
-- Indexes for table `invitations`
--
ALTER TABLE `invitations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invitations_uuid_unique` (`uuid`),
  ADD UNIQUE KEY `invitations_slug_unique` (`slug`),
  ADD KEY `invitations_theme_id_foreign` (`theme_id`),
  ADD KEY `invitations_status_index` (`status`),
  ADD KEY `invitations_user_id_index` (`user_id`),
  ADD KEY `invitations_event_date_index` (`event_date`),
  ADD KEY `invitations_event_type_index` (`event_type`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_number_unique` (`order_number`),
  ADD KEY `orders_theme_id_foreign` (`theme_id`),
  ADD KEY `orders_user_id_foreign` (`user_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `themes_slug_unique` (`slug`),
  ADD KEY `themes_event_type_index` (`event_type`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `guests`
--
ALTER TABLE `guests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invitations`
--
ALTER TABLE `invitations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `guests`
--
ALTER TABLE `guests`
  ADD CONSTRAINT `guests_invitation_id_foreign` FOREIGN KEY (`invitation_id`) REFERENCES `invitations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invitations`
--
ALTER TABLE `invitations`
  ADD CONSTRAINT `invitations_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`),
  ADD CONSTRAINT `invitations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
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 */;