-- ------------------------------------------------------
-- Bilinggo MySQL Database Dump for cPanel / phpMyAdmin
-- Generated on: 2026-07-28 10:44:19
-- Compatible with MySQL 5.7+ / MariaDB 10.3+
-- ------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

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

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` VARCHAR(255) NOT NULL,
  `value` TEXT NOT NULL,
  `expiration` BIGINT NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` VARCHAR(255) NOT NULL,
  `owner` VARCHAR(255) NOT NULL,
  `expiration` BIGINT NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `customer_sessions`
--

DROP TABLE IF EXISTS `customer_sessions`;
CREATE TABLE `customer_sessions` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `customer_id` BIGINT NOT NULL,
  `token` VARCHAR(255) NOT NULL,
  `expires_at` TIMESTAMP NOT NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_sessions_token_unique` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `customer_sessions`
INSERT INTO `customer_sessions` (`id`, `customer_id`, `token`, `expires_at`, `created_at`, `updated_at`) VALUES ('2', '0', '2690285b48d30e34927c98c11bdac56f53f7b0f8515d4f3bcd3ab42d9a0a1a46', '2026-07-25 03:21:12', '2026-06-25 03:21:12', '2026-06-25 03:21:12');

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NULL,
  `password_hash` VARCHAR(255) NOT NULL,
  `is_active` INT NOT NULL DEFAULT 1,
  `last_login` TIMESTAMP NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customers_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `customers`
INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `password_hash`, `is_active`, `last_login`, `created_at`, `updated_at`) VALUES ('1', 'John Smith', 'john@example.com', '081234567890', '$2y$12$apkK18jzNFx3/X22aJkYleWhb2hckDqqr0AODDdz8Nirqnz1DfXLy', '1', NULL, '2026-06-25 03:20:09', '2026-06-25 03:22:19');

--
-- Table structure for table `event_sessions`
--

DROP TABLE IF EXISTS `event_sessions`;
CREATE TABLE `event_sessions` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `event_date` VARCHAR(255) NULL,
  `name` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  `bg_color` VARCHAR(255) NOT NULL DEFAULT 'bg-yellow',
  `is_tall` INT NOT NULL DEFAULT 0,
  `sort_order` INT NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `event_sessions`
INSERT INTO `event_sessions` (`id`, `event_date`, `name`, `description`, `bg_color`, `is_tall`, `sort_order`, `created_at`, `updated_at`) VALUES ('1', '06/06', 'TOEFL Mastery: Cetak Biru Menuju Skor Juara', 'Teknik Cerdas untuk Mencapai Target Skor Band Anda', 'bg-yellow', '0', '1', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `event_sessions` (`id`, `event_date`, `name`, `description`, `bg_color`, `is_tall`, `sort_order`, `created_at`, `updated_at`) VALUES ('2', '14/06', 'Kuasai Pengaruh Media Sosial', 'Membangun Branding Digital yang Menarik Peluang', 'bg-blue text-white', '0', '2', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `event_sessions` (`id`, `event_date`, `name`, `description`, `bg_color`, `is_tall`, `sort_order`, `created_at`, `updated_at`) VALUES ('3', '21/06', 'Keseimbangan Kesehatan Mental & Produktivitas', 'Mengelola Tekanan di Era Digital Modern', 'bg-pink text-white', '1', '3', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `event_sessions` (`id`, `event_date`, `name`, `description`, `bg_color`, `is_tall`, `sort_order`, `created_at`, `updated_at`) VALUES ('4', '27/06', 'Public Speaking untuk Pemimpin Masa Depan', 'Berbicara dengan Percaya Diri, Pengaruh & Otoritas', 'bg-red text-white', '0', '4', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `event_sessions` (`id`, `event_date`, `name`, `description`, `bg_color`, `is_tall`, `sort_order`, `created_at`, `updated_at`) VALUES ('5', '04/07', 'Revolusi Sumber Daya Manusia (HR)', 'Cara Perusahaan Teratas Mengidentifikasi Talenta Berkualitas Tinggi', 'bg-cyan', '0', '5', '2026-06-25 03:17:08', '2026-06-25 03:17:08');

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

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `uuid` VARCHAR(255) NOT NULL,
  `connection` VARCHAR(255) NOT NULL,
  `queue` VARCHAR(255) NOT NULL,
  `payload` TEXT NOT NULL,
  `exception` TEXT NOT NULL,
  `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `total_jobs` INT NOT NULL,
  `pending_jobs` INT NOT NULL,
  `failed_jobs` INT NOT NULL,
  `failed_job_ids` TEXT NOT NULL,
  `options` TEXT NULL,
  `cancelled_at` INT NULL,
  `created_at` INT NOT NULL,
  `finished_at` INT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `queue` VARCHAR(255) NOT NULL,
  `payload` TEXT NOT NULL,
  `attempts` SMALLINT NOT NULL,
  `reserved_at` INT NULL,
  `available_at` INT NOT NULL,
  `created_at` INT NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` INT AUTO_INCREMENT NOT NULL,
  `migration` VARCHAR(255) NOT NULL,
  `batch` INT NOT NULL,
  PRIMARY KEY (`id`)
) 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');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('2', '0001_01_01_000001_create_cache_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('3', '0001_01_01_000002_create_jobs_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('4', '2026_06_25_031537_create_orders_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('5', '2026_06_25_031537_create_products_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('6', '2026_06_25_031537_create_registrations_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('7', '2026_06_25_031538_create_news_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('8', '2026_06_25_031538_create_sessions_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('9', '2026_06_25_031538_create_slides_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('10', '2026_06_25_031538_create_topics_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('11', '2026_06_25_031539_create_customer_sessions_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('12', '2026_06_25_031539_create_customers_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('13', '2026_06_25_031539_create_settings_table', '1');

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  `news_date` VARCHAR(255) NULL,
  `image` VARCHAR(255) NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `news`
INSERT INTO `news` (`id`, `title`, `description`, `news_date`, `image`, `created_at`, `updated_at`) VALUES ('1', 'Webinar Nasional TOEFL Mastery Sukses Besar', 'Diikuti lebih dari 1000 peserta, webinar menghadirkan Liann Camille untuk membagikan formula sukses ujian.', '20 Juni 2026', 'assets/images/conference.png', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `news` (`id`, `title`, `description`, `news_date`, `image`, `created_at`, `updated_at`) VALUES ('2', 'Kelas Speak Up Angkatan 15 Resmi Dibuka', 'Program unggulan pelatihan presentasi dan kepercayaan diri berbicara bahasa Inggris untuk para profesional.', '15 Juni 2026', 'assets/images/laptop.png', '2026-06-25 03:17:08', '2026-06-25 03:17:08');

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

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `order_number` VARCHAR(255) NOT NULL,
  `customer_name` VARCHAR(255) NOT NULL,
  `customer_phone` VARCHAR(255) NOT NULL,
  `customer_email` VARCHAR(255) NULL,
  `items_json` TEXT NULL,
  `total_price` INT NOT NULL DEFAULT 0,
  `payment_method` VARCHAR(255) NOT NULL DEFAULT 'transfer',
  `status` VARCHAR(255) NOT NULL DEFAULT 'pending',
  `notes` TEXT NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_order_number_unique` (`order_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` VARCHAR(255) NOT NULL,
  `token` VARCHAR(255) NOT NULL,
  `created_at` TIMESTAMP NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `description` TEXT NULL,
  `price` VARCHAR(255) NULL,
  `promo_price` VARCHAR(255) NULL,
  `image` VARCHAR(255) NOT NULL DEFAULT 'assets/images/laptop.png',
  `category` VARCHAR(255) NOT NULL DEFAULT 'ebook',
  `shopee_url` TEXT NULL,
  `tokopedia_url` TEXT NULL,
  `va_details` TEXT NULL,
  `stock` INT NOT NULL DEFAULT '-1',
  `is_active` INT NOT NULL DEFAULT 1,
  `sort_order` INT NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `products`
INSERT INTO `products` (`id`, `name`, `description`, `price`, `promo_price`, `image`, `category`, `shopee_url`, `tokopedia_url`, `va_details`, `stock`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES ('1', 'E-Book Ultimate TOEFL Mastery Guide', 'Panduan lengkap belajar TOEFL mandiri berisi taktik, strategi menjawab soal, dan pola soal terpopuler.', 'Rp 150.000', 'Rp 99.000', 'assets/images/laptop.png', 'ebook', 'https://shopee.co.id', 'https://tokopedia.com', 'Bank BCA 1234567890 a/n Bilinggo Global Academy', '-1', '1', '0', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `products` (`id`, `name`, `description`, `price`, `promo_price`, `image`, `category`, `shopee_url`, `tokopedia_url`, `va_details`, `stock`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES ('2', 'IELTS Premium Prep 1-on-1', 'Kelas intensif privat bersama mentor tersertifikasi IELTS Band 8.5. Dilengkapi simulasi dan feedback instan.', 'Rp 1.999.000', 'Rp 1.499.000', 'assets/images/conference.png', 'course', 'https://shopee.co.id', 'https://tokopedia.com', 'Bank Mandiri 1310022233445 a/n Bilinggo Academy', '-1', '1', '0', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `products` (`id`, `name`, `description`, `price`, `promo_price`, `image`, `category`, `shopee_url`, `tokopedia_url`, `va_details`, `stock`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES ('3', 'Simulasi Ujian TOEFL ITP Resmi', 'Simulasi ujian TOEFL dengan format, tingkat kesulitan, dan sistem waktu pengerjaan yang mirip dengan ujian asli.', 'Rp 250.000', 'Rp 199.000', 'assets/images/laptop.png', 'test', 'https://shopee.co.id', 'https://tokopedia.com', 'Bank BCA 9876543210 a/n Bilinggo Global Academy', '-1', '1', '0', '2026-06-25 03:17:08', '2026-06-25 03:17:08');

--
-- Table structure for table `registrations`
--

DROP TABLE IF EXISTS `registrations`;
CREATE TABLE `registrations` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NULL,
  `email` VARCHAR(255) NULL,
  `topic` VARCHAR(255) NULL,
  `referral` VARCHAR(255) NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` VARCHAR(255) NOT NULL,
  `user_id` BIGINT NULL,
  `ip_address` VARCHAR(45) NULL,
  `user_agent` TEXT NULL,
  `payload` TEXT NOT NULL,
  `last_activity` INT NOT NULL,
  PRIMARY KEY (`id`)
) 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 ('EAR7VLYj0VjSZQe7qJyABwoE6IkC6NAEZfQMhLW7', NULL, '127.0.0.1', 'curl/8.18.0', 'eyJfdG9rZW4iOiJYS0tpeVRIOW1NTWNTVHlYZzd4SzlBVHQwOFZqZXBZSVVndjY0V2tkIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', '1782357609');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('tDRLsoTpyxCnmGBbWd0TwatvKg973HqkyJ6ngbZG', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiIzQTQ4SmM1Z3hYdkJmYTNsVnZxY0JlTVZ4MjVYNnZiUk1kTjJmaU1UIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1782369823');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('voBalrayVbwO1xLhRcHWyt06iVNNj3p4M0zZ8LLI', NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJWRjhvczdEY3NoeElEaHZQR1drN2FoMHp0NEFIS3cxUWdLUUQzT0RGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDgwXC9hcGlcL3Byb2R1Y3RzLnBocCIsInJvdXRlIjpudWxsfSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', '1782357754');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('7T1oMxEejYkNDgJxAKCqmb6hCkKv68DUYVTPqiks', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJYWE55WHkycndJREpzUnJTMEpOOGs1d1NTSWVSQ3FiYnA2WTRWVjJmIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1782359002');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('eZGGFdZeh3B7SjPiywrX4KXozVHIhl7CTB6lYIsj', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJZd1hldG8zWUt2emhHQ2p5UXpUbXZxWm43dFJyejh2NEZkdTM2SWU0IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1782367211');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('IiCHbBtSOk5Tv6sgfX9bliz7AZmsIYocGR0H2CaG', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJUbGE3bnkzc0R1Y3VpMFFuWEw4WDRkU0hEWVVUMkpRb3M3eHpnT2JkIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1785230234');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('l6RjG1uT0tP8T8Qj0B8srWTH6micyGDjevwwcyzo', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJsTTc2N2RqN1Q5SUJNWkh5RjVhdFN3bXJuZXhtUUVUYkpNU2JHOEhsIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1785233075');
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('rcA4aQs1DZG4BnYTOc0bUapxPt5UE9CDfmRO4hmN', NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJrNHpidlBIZTRDR3BTNERsanhBMnJiakdaQms4dXVURHNkYXNmaUxJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2xvY2FsaG9zdFwvYmlsaW5nZ28iLCJyb3V0ZSI6bnVsbH0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', '1785233491');

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `key_name` VARCHAR(255) NOT NULL,
  `value` TEXT NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_name_unique` (`key_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `settings`
INSERT INTO `settings` (`id`, `key_name`, `value`, `created_at`, `updated_at`) VALUES ('1', 'whatsapp_number', '6282118940782', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `settings` (`id`, `key_name`, `value`, `created_at`, `updated_at`) VALUES ('2', 'site_title', 'BilînGo Global Academy', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `settings` (`id`, `key_name`, `value`, `created_at`, `updated_at`) VALUES ('4', 'admin_password', 'admin123', '2026-06-25 03:17:08', '2026-07-28 09:41:16');
INSERT INTO `settings` (`id`, `key_name`, `value`, `created_at`, `updated_at`) VALUES ('3', 'admin_username', 'admin', '2026-06-25 03:17:08', '2026-07-28 09:41:16');

--
-- Table structure for table `slides`
--

DROP TABLE IF EXISTS `slides`;
CREATE TABLE `slides` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `type` VARCHAR(255) NOT NULL DEFAULT 'original',
  `tech_text` TEXT NULL,
  `title` TEXT NULL,
  `subtitle` TEXT NULL,
  `tagline` TEXT NULL,
  `outcomes` TEXT NULL,
  `event_date` VARCHAR(255) NULL,
  `old_price` VARCHAR(255) NULL,
  `new_price` VARCHAR(255) NULL,
  `bonus` VARCHAR(255) NULL,
  `btn_text` VARCHAR(255) NOT NULL DEFAULT 'DAFTAR SEKARANG',
  `image` VARCHAR(255) NULL,
  `speaker_name` VARCHAR(255) NULL,
  `speaker_title1` VARCHAR(255) NULL,
  `speaker_title2` VARCHAR(255) NULL,
  `speaker_image` VARCHAR(255) NULL,
  `is_active` INT NOT NULL DEFAULT 1,
  `sort_order` INT NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `slides`
INSERT INTO `slides` (`id`, `type`, `tech_text`, `title`, `subtitle`, `tagline`, `outcomes`, `event_date`, `old_price`, `new_price`, `bonus`, `btn_text`, `image`, `speaker_name`, `speaker_title1`, `speaker_title2`, `speaker_image`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES ('1', 'original', 'KETERAMPILAN MASA DEPAN DIMULAI DI SINI!', 'Memberdayakan<br>Talenta Masa Depan<br><span class="hero-title-underline">Indonesia di Era Digital</span>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GABUNG SEKARANG', 'assets/images/laptop.png', NULL, NULL, NULL, NULL, '1', '1', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `slides` (`id`, `type`, `tech_text`, `title`, `subtitle`, `tagline`, `outcomes`, `event_date`, `old_price`, `new_price`, `bonus`, `btn_text`, `image`, `speaker_name`, `speaker_title1`, `speaker_title2`, `speaker_image`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES ('2', 'toefl', NULL, 'TOEFL MASTERY', 'Cetak Biru Menuju Skor Juara', 'Taktik Terbukti dan Formula Sukses untuk Karier Global Anda', 'Presisi Taktis: Identifikasi jawaban "jebakan" dalam hitungan detik.|Formula Eksekutif: Dapatkan templat P.R.E.P. yang terbukti.|Peta Jalan Global: Manfaatkan skor untuk rekrutmen internasional.|Simulasi Langsung: Latihan waktu nyata dengan masukan ahli.', '06 JUNI 2026', 'Rp 150K', 'RP 75.000', 'SERTIFIKAT GRATIS', 'DAFTAR SEKARANG', NULL, 'Liann Camille Davalos Perez', 'Magister Bahasa Inggris', 'Mahasiswa Doktoral Ilmu Pendidikan Bahasa', 'assets/images/liann_perez.png', '1', '2', '2026-06-25 03:17:08', '2026-06-25 03:17:08');

--
-- Table structure for table `topics`
--

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  `label` VARCHAR(255) NOT NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `topics_value_unique` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `topics`
INSERT INTO `topics` (`id`, `value`, `label`, `sort_order`, `created_at`, `updated_at`) VALUES ('1', 'Digital Leadership', '1. Kepemimpinan Digital (Digital Leadership)', '1', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `topics` (`id`, `value`, `label`, `sort_order`, `created_at`, `updated_at`) VALUES ('2', 'Workplace Mental Health & HR Strategy', '2. Kesehatan Mental di Tempat Kerja & Strategi HR', '2', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `topics` (`id`, `value`, `label`, `sort_order`, `created_at`, `updated_at`) VALUES ('3', 'Digital HR & Talent Analytics', '3. HR Digital & Analitik Talenta (Digital HR & Talent Analytics)', '3', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `topics` (`id`, `value`, `label`, `sort_order`, `created_at`, `updated_at`) VALUES ('4', 'English for Global Leadership', '4. Bahasa Inggris untuk Kepemimpinan Global', '4', '2026-06-25 03:17:08', '2026-06-25 03:17:08');
INSERT INTO `topics` (`id`, `value`, `label`, `sort_order`, `created_at`, `updated_at`) VALUES ('5', 'Digital Wellbeing & Mental Health', '5. Kesejahteraan Digital & Kesehatan Mental (Digital Wellbeing & Mental Health)', '5', '2026-06-25 03:17:08', '2026-06-25 03:17:08');

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `email_verified_at` TIMESTAMP NULL,
  `password` VARCHAR(255) NOT NULL,
  `remember_token` VARCHAR(100) NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;