-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 04, 2026 at 02:16 AM -- Server version: 8.4.3 -- PHP Version: 8.3.16 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; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel-cache-unsplash_dummy_36df34102c96a289e545a97591cff27b', 's:185:\"https://images.unsplash.com/photo-1634507554990-2043ccc61e61?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwMzh8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353933), ('laravel-cache-unsplash_dummy_5891f00d223899bbb091ddf35025a6f6', 's:185:\"https://images.unsplash.com/photo-1680564950629-cc8c4391b92d?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwMzd8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353931), ('laravel-cache-unsplash_dummy_85db4b347c1dcfceab64a0d79f86be3d', 's:185:\"https://images.unsplash.com/photo-1772404245951-771b903f2248?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwMzh8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353932), ('laravel-cache-unsplash_dummy_abf05846cd360e7a35b0c4670c1fa65f', 's:185:\"https://images.unsplash.com/photo-1737402655755-c72aa4086639?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwMzl8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353934), ('laravel-cache-unsplash_dummy_ba865986b8984875b15f3b4abc9929f9', 's:185:\"https://images.unsplash.com/photo-1508214564935-9f2adc2ec3c2?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwNDB8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353934), ('laravel-cache-unsplash_dummy_bdca4a93078101f790075dafab4cb834', 's:182:\"https://images.unsplash.com/photo-1558535299-1fc041f8a331?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwNDJ8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353937), ('laravel-cache-unsplash_dummy_c3aad6f52893819a29d0562dcb0215ff', 's:185:\"https://images.unsplash.com/photo-1766041675267-01431f165ff0?crop=entropy&cs=tinysrgb&fit=max&fm=jpg&ixid=M3w4ODA4MjV8MHwxfHJhbmRvbXx8fHx8fHx8fDE3NzUyNjYwNDF8&ixlib=rb-4.1.0&q=80&w=1080\";', 1775353935); -- -------------------------------------------------------- -- -- 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, `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); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('dFcVjkxfOQ2kJpHoI1XZLysndwmW7D4sAVjUNe3C', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaXBMMXJGN3dvNlpmeVpCRWZOeFc2Zm5kSkZBb1o5bjJ1MGQ5S2FPMSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9idWF0LXVuZGFuZ2FuIjtzOjU6InJvdXRlIjtzOjEyOiJvcmRlci5jcmVhdGUiO319', 1775268054); -- -------------------------------------------------------- -- -- 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, `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`, `thumbnail`, `price`, `promo_price`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Rustic Green', 'rustic-green', 'themes.rustic-green.index', 'rustic-green.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (2, 'Floral Pastel', 'floral-pastel', 'themes.floral-pastel.index', 'floral-pastel.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (3, 'Royal Glass', 'royal-glass', 'themes.royal-glass.index', 'royal-glass.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (4, 'Barakah Love', 'barakah-love', 'themes.barakah-love.index', 'barakah-love.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (5, 'Boho Terracotta', 'boho-terracotta', 'themes.boho-terracotta.index', 'boho-terracotta.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (6, 'Emerald Garden', 'emerald-garden', 'themes.emerald-garden.index', 'emerald-garden.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (7, 'Ocean Breeze', 'ocean-breeze', 'themes.ocean-breeze.index', 'ocean-breeze.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (8, 'Watercolor Flow', 'watercolor-flow', 'themes.watercolor-flow.index', 'watercolor-flow.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (9, 'Golden Sunrise', 'golden-sunrise', 'themes.golden-sunrise.index', 'golden-sunrise.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (10, 'Jawa Keraton', 'jawa-keraton', 'themes.jawa-keraton.index', 'jawa-keraton.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (11, 'Midnight Garden', 'midnight-garden', 'themes.midnight-garden.index', 'midnight-garden.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (12, 'Sekar Jagad', 'sekar-jagad', 'themes.sekar-jagad.index', 'sekar-jagad.png', NULL, NULL, 1, '2026-04-03 18:51:25', '2026-04-03 18:51:25'), (13, 'Sunda Asih', 'sunda-asih', 'themes.sunda-asih.index', 'sunda-asih.png', NULL, NULL, 1, '2026-04-03 18:51:26', '2026-04-03 18:51:26'); -- -------------------------------------------------------- -- -- 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$ROWvdMKr7JfJxyyGySigMuPTe/1NL/xrmUJjJbdAotVzDS3ZxGKGS', 'admin', NULL, '2026-04-03 18:51:25', '2026-04-03 18:51:25'); -- -- 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`); -- -- 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`); -- -- 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=13; -- -- 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=14; -- -- 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 */;