
/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flag` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heroImg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tagline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `show_on_home` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'japan','Japan','🇯🇵','assets/images/dest_japan.webp','Negeri Matahari Terbit','Jelajahi keindahan Jepang — dari ketenangan Kyoto hingga keramaian Tokyo. Sakura, gunung Fuji, dan masakan autentik menunggu Anda.',1),(2,'korea','Korea','🇰🇷','assets/images/dest_korea.webp','Negeri Ginseng yang Memesona','Dari K-Drama hingga K-Pop, Korea menawarkan pengalaman budaya yang luar biasa. Temukan keindahan Seoul, Jeju, dan Busan.',1),(3,'china','China','🇨🇳','assets/images/dest_china.webp','Tembok Besar yang Menakjubkan','Rasakan keajaiban peradaban tertua di dunia. Beijing, Shanghai, dan Xi\'an menyimpan ribuan tahun sejarah dan budaya.',1),(4,'turkey','Turkey','🇹🇷','assets/images/dest_turkey.webp','Antara Timur dan Barat','Balon udara di Cappadocia, pesona Istanbul yang kosmopolitan, dan pantai Turquoise Coast. Turki adalah destinasi yang tak terlupakan.',1),(7,'france','France','🇫🇷','https://images.unsplash.com/photo-1549144511-f099e773c147?q=80&w=1974&auto=format&fit=crop','Negeri Menara Eiffel','Paris, kota yang tak pernah tidur — Menara Eiffel, Louvre, Champs-Élysées, dan masakan Prancis yang memukau selera.',0),(8,'australia','Australia','🇦🇺','https://images.unsplash.com/photo-1506973035872-a4ec16b8e8d9?q=80&w=2070&auto=format&fit=crop','Benua Terbesar yang Memesona','Sydney Opera House, Great Barrier Reef, Uluru, dan satwa liar yang unik. Australia menawarkan petualangan alam yang tak tertandingi.',0),(13,'indonesia','indonesia','id','assets/uploads/countries/img_6a828a1fbdb4a0.50494078.webp','alam','alam yang indah',1);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES ('address','Jl. Kujang 4, RT.002/RW.023, Jatirahayu, Kec. Pd. Melati, Kota Bks, Jawa Barat 17422\r\n(APPOINTMENT ONLY)'),('copyright','© 2024 Travelica Agency. All rights reserved.'),('email','info@travelica.id'),('footer_tagline','Agen perjalanan terpercaya untuk\r\nliburan impian Anda ke seluruh dunia.'),('hero_image','assets/images/hero_bg.webp'),('hero_subtitle','Kami siap melayani dengan sepenuh hati. Kami memberikan pelayanan terbaik untuk perjalanan impian Anda bersama Travelica.'),('hero_tagline','Travel More, Worry Lesss'),('hero_title','Explore The World\r\nWith Travelica'),('instagram','@travelica.id'),('maps_embed','<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3965.7259359003356!2d106.93783359999999!3d-6.2996982!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e6993627df8f069%3A0x6937c0d25a1e8706!2sTravelica%20Agency%20Indo%20Office!5e0!3m2!1sid!2sid!4v1787102310233!5m2!1sid!2sid\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"strict-origin-when-cross-origin\"></iframe>'),('reviews_eyebrow','REVIEWS'),('reviews_title','What our travelers say.'),('terms_conditions','1. PENDAFTARAN & PEMBAYARAN:\r\n• Pendaftaran wajib disertai pembayaran uang muka (DP) per peserta sesuai nominal yang ditentukan.\r\n• Pembayaran DP mengikat kuota kursi perjalanan Anda.\r\n• Pelunasan sisa biaya paket trip wajib diselesaikan selambat-lambatnya 14 (empat belas) hari kalender sebelum tanggal keberangkatan.\r\n• Segala bentuk pembayaran dan konfirmasi dilakukan secara resmi melalui WhatsApp Travelica Agency.\r\n\r\n2. KETENTUAN PEMBATALAN (CANCELATION):\r\n• Pembatalan lebih dari 30 hari sebelum jadwal keberangkatan: Pengembalian dana 50% dari total DP.\r\n• Pembatalan 15 - 30 hari sebelum keberangkatan: Uang muka (DP) hangus (non-refundable).\r\n• Pembatalan kurang dari 14 hari sebelum keberangkatan: Dikenakan biaya pembatalan 100% dari total paket trip.\r\n• Pengalihan peserta ke pihak lain dapat dilakukan paling lambat 7 hari sebelum keberangkatan (selama tiket dan reservasi memungkinkan).\r\n\r\n3. DOKUMEN & PASPOR:\r\n• Peserta wajib memiliki paspor yang masih berlaku minimal 6 (enam) bulan terhitung dari tanggal kepulangan.\r\n• Pengurusan visa & asuransi didampingi oleh tim Travelica sesuai paket yang dipilih. Keputusan penerbitan visa sepenuhnya merupakan hak prerogatif pihak Kedutaan Besar.\r\n\r\n4. FORCE MAJEURE & PERUBAHAN ITINERARY:\r\n• Jadwal itinerary dapat disesuaikan sewaktu-waktu demi kenyamanan dan keselamatan peserta apabila terjadi kondisi di luar kendali (Force Majeure, cuaca buruk, penundaan maskapai, dsb).\r\n• Pihak Travelica tidak bertanggung jawab atas kerugian materiil akibat kelalaian pribadi peserta selama tour berlangsung.\r\n\r\n5. TANGGUNG JAWAB & KETERTIBAN:\r\n• Peserta wajib mematuhi arahan Tour Leader / Guide serta mentaati peraturan hukum dan adat istiadat di negara tujuan.'),('tiktok','@travelica.id'),('tour_gallery','[{\"id\":1,\"img\":\"assets/uploads/gallery/tour_japan_spring.jpg\",\"title\":\"Dokumentasi Tour Jepang Sakura\",\"caption\":\"Momen tak terlupakan rombongan traveler Travelica menikmati musim semi sakura di Tokyo & Kyoto.\"},{\"id\":2,\"img\":\"assets/uploads/gallery/tour_cappadocia_balloons.jpg\",\"title\":\"Dokumentasi Tour Cappadocia Turkey\",\"caption\":\"Keseruan menikmati matahari terbit dan parade balon udara bersama rombongan di Cappadocia.\"},{\"id\":3,\"img\":\"assets/uploads/gallery/tour_switzerland_alps.jpg\",\"title\":\"Dokumentasi Tour Switzerland Alps\",\"caption\":\"Panorama spektakuler pegunungan Alpen Swiss dan momen kebersamaan rombongan traveler.\"},{\"id\":4,\"img\":\"assets/uploads/gallery/tour_korea_autumn.jpg\",\"title\":\"Dokumentasi Tour Korea Nami Island\",\"caption\":\"Keseruan menikmati keindahan daun keemasan musim gugur di pulau romantis Nami Island.\"}]'),('whatsapp','6282125423945'),('whatsapp_admin1_name','ADMIN 1 (DOROTHY)'),('whatsapp_admin1_number','6282125423945'),('whatsapp_admin2_name','ADMIN 2 (ANIS)'),('whatsapp_admin2_number','087809226402'),('youtube_desc','Saksikan momen-momen tak terlupakan dan keseruan para traveler saat menjelajahi destinasi impian bersama Travelica.'),('youtube_embed','https://youtu.be/rkdJHwwG5js?si=wTVE9LTDeaIVWH-C'),('youtube_tagline','VIDEO PERJALANAN'),('youtube_title','Lihat Keseruan Liburan Bersama Kami');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonials` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` tinyint NOT NULL DEFAULT '5',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `testimonials` WRITE;
/*!40000 ALTER TABLE `testimonials` DISABLE KEYS */;
INSERT INTO `testimonials` VALUES (1,'Leila','Japan Cherry Blossom Tour','assets/uploads/testimonials/traveler_leila.webp',5,'The trip is just as pictured and expected! The itinerary was very well organized, tour leader was super friendly, and the hotel was excellent! I highly recommend Travelica if you want a worry-free vacation!',1,1,'2026-08-18 01:06:00'),(2,'Dein','Korea Autumn & Nami Island','assets/uploads/testimonials/traveler_dein.webp',5,'OMG IM IN LOVEEE with the whole experience! The coordination was super duper fast and seamless, and we even got special documentation & free gifts! Best travel agency ever!',2,1,'2026-08-18 01:06:00'),(3,'Jayleen P.','Turkey Cappadocia Special','assets/uploads/testimonials/traveler_jayleen.webp',5,'Super fun and spacious tour pace! Naik balon udara di Cappadocia bareng teman-teman terwujud berkat Travelica. Fasilitas bintang lima dan pelayanannya sangat memuaskan dari awal hingga pulang.',3,1,'2026-08-18 01:06:00'),(4,'Rayleigh A.','China Great Wall & Shanghai','assets/uploads/testimonials/traveler_dein.webp',5,'Good quality service that comes with an insert and multiple ways to enjoy the tour. Very helpful tour leader and seamless visa assistance. Truly happy with Travelica!',4,1,'2026-08-18 01:06:00');
/*!40000 ALTER TABLE `testimonials` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `trips`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trips` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` int DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `durationShort` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateRange` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateStart` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateEnd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minPax` int DEFAULT NULL,
  `dp_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dp_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Pembayaran DP',
  `price` int DEFAULT NULL,
  `includes` json DEFAULT NULL,
  `excludes` json DEFAULT NULL,
  `itinerary` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `trips_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `trips` WRITE;
/*!40000 ALTER TABLE `trips` DISABLE KEYS */;
INSERT INTO `trips` VALUES ('alam',13,'asdmas','asmdas','','42','aksd','22 mei','22 mei',1,'1 Pax','Minimum Peserta',900000,'[\"hotel *5\", \"sda\"]','[\"pesawat\", \"sad\"]','[{\"day\": 1, \"img\": \"assets/uploads/itinerary/img_6a828a7c53f2c4.55992450.webp\", \"desc\": \"\", \"title\": \"lmk\"}, {\"day\": 2, \"img\": \"\", \"desc\": \"asd\", \"title\": \"asd\"}]'),('australia-604n-sep',8,'AUS 604N','Sydney – Melbourne – Gold Coast','6 Days 5 Nights','6H 5M','20 – 25 Sep 2026','20 September 2026','25 September 2026',10,'10 Pax','Minimum Peserta',29500000,'[\"Hotel ★4\", \"Transportasi Bus & Penerbangan Domestik\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat Internasional\", \"Visa Australia\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1524293581917-878a6d017c71?w=120&q=80\", \"desc\": \"Arrival at Sydney Airport, transfer to hotel. Evening at Darling Harbour.\", \"title\": \"ARRIVAL SYDNEY\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1506973035872-a4ec16b8e8d9?w=120&q=80\", \"desc\": \"Sydney Opera House – Harbour Bridge – Bondi Beach – The Rocks.\", \"title\": \"SYDNEY CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1514395462725-fb4566210144?w=120&q=80\", \"desc\": \"Flight to Melbourne – Queen Victoria Market – Federation Square.\", \"title\": \"SYDNEY – MELBOURNE\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1545165375-277be8c1f5ab?w=120&q=80\", \"desc\": \"Twelve Apostles – Loch Ard Gorge – Otway National Park.\", \"title\": \"GREAT OCEAN ROAD\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=120&q=80\", \"desc\": \"Flight to Gold Coast – Surfers Paradise – Harbour Town Shopping.\", \"title\": \"MELBOURNE – GOLD COAST\"}, {\"day\": 6, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast, transfer to Gold Coast Airport. Departure.\", \"title\": \"DEPARTURE\"}]'),('china-502n-sep',3,'CHINA 502N','Beijing – Great Wall – Shanghai','5 Days 4 Nights','5H 4M','12 – 16 Sep 2026','12 September 2026','16 September 2026',15,'15 Pax','Minimum Peserta',11500000,'[\"Hotel ★3/★4\", \"Transportasi Bus & KA Cepat\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat\", \"Visa China\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1508804185872-d7badad00f7d?w=120&q=80\", \"desc\": \"Arrival at Beijing Capital Airport, transfer to hotel.\", \"title\": \"ARRIVAL BEIJING\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1532587575534-f5bcc0fc4578?w=120&q=80\", \"desc\": \"Tiananmen Square – Forbidden City – Temple of Heaven.\", \"title\": \"BEIJING TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1508804052814-cd3ba865a116?w=120&q=80\", \"desc\": \"Great Wall of China – Ming Tombs – Summer Palace.\", \"title\": \"GREAT WALL TOUR\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1545893835-abaa8575d9b4?w=120&q=80\", \"desc\": \"High-speed train to Shanghai – The Bund – Nanjing Road.\", \"title\": \"BEIJING – SHANGHAI\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel, transfer to Pudong Airport.\", \"title\": \"DEPARTURE\"}]'),('china-603n-nov',3,'CHINA 603N','Beijing – Shanghai – Xi\'an','6 Days 5 Nights','6H 5M','10 – 15 Nov 2026','10 November 2026','15 November 2026',15,'15 Pax','Minimum Peserta',16500000,'[\"Hotel ★4\", \"Transportasi Bus & KA Cepat\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\", \"1x Dinner Spesial\"]','[\"Tiket Pesawat\", \"Visa China\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1508804185872-d7badad00f7d?w=120&q=80\", \"desc\": \"Arrival at Beijing Capital Airport, transfer to hotel.\", \"title\": \"ARRIVAL BEIJING\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1532587575534-f5bcc0fc4578?w=120&q=80\", \"desc\": \"Tiananmen Square – Forbidden City – Temple of Heaven.\", \"title\": \"BEIJING TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1508804052814-cd3ba865a116?w=120&q=80\", \"desc\": \"Great Wall – Train to Xi\'an – Terracotta Army Museum.\", \"title\": \"GREAT WALL & XI\'AN\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1549887552-cb1071d3e5ca?w=120&q=80\", \"desc\": \"Xi\'an City Wall – Muslim Quarter – Big Wild Goose Pagoda.\", \"title\": \"XI\'AN CITY TOUR\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1545893835-abaa8575d9b4?w=120&q=80\", \"desc\": \"Flight to Shanghai – The Bund – Yu Garden – Xintiandi.\", \"title\": \"XI\'AN – SHANGHAI\"}, {\"day\": 6, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast, transfer to Pudong Airport. Departure.\", \"title\": \"DEPARTURE\"}]'),('france-604n-oct',7,'FRANCE 604N','Paris – Nice – Mont Saint-Michel','6 Days 5 Nights','6H 5M','12 – 17 Oct 2026','12 Oktober 2026','17 Oktober 2026',10,'10 Pax','Minimum Peserta',34000000,'[\"Hotel ★4\", \"Transportasi Bus & TGV\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat Internasional\", \"Schengen Visa\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1502602898657-3e91760cbb34?w=120&q=80\", \"desc\": \"Arrival at Charles de Gaulle Airport, transfer to hotel.\", \"title\": \"ARRIVAL PARIS\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1499856871958-5b9627545d1a?w=120&q=80\", \"desc\": \"Eiffel Tower – Louvre Museum – Champs-Élysées – Arc de Triomphe.\", \"title\": \"PARIS CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1568515387631-8b650bbcdb90?w=120&q=80\", \"desc\": \"Palace of Versailles – Drive to Normandy – Mont Saint-Michel.\", \"title\": \"VERSAILLES & MONT SAINT-MICHEL\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=120&q=80\", \"desc\": \"TGV to Nice – Promenade des Anglais – Old Town – Castle Hill.\", \"title\": \"PARIS – NICE\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1504870712357-65ea720d6078?w=120&q=80\", \"desc\": \"Day trip to Monaco – Prince\'s Palace – Casino Square – Exotic Garden.\", \"title\": \"NICE – MONACO\"}, {\"day\": 6, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast, transfer to Nice Airport. Departure.\", \"title\": \"DEPARTURE\"}]'),('japan-403n-aug',1,'JAPAN 403N','Tokyo – Osaka – Kyoto','4 Days 3 Nights','4H 3M','22 – 25 Aug 2026','22 Agustus 2026','25 Agustus 2026',15,'3,5Jt/Pax','Pembayaran DP',9900000,'[\"Hotel ★3/★4\", \"Transportasi Bus\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat\", \"Visa & Insurance\", \"Pengeluaran Pribadi\", \"Air Mineral\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=120&q=80\", \"desc\": \"Arrival at Narita Airport, meet & greet with guide. Transfer to hotel, free time.\", \"title\": \"ARRIVAL TOKYO\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1513407030348-c983a97b98d8?w=120&q=80\", \"desc\": \"Asakusa Temple – Tokyo Skytree – Shibuya – Shinjuku.\", \"title\": \"TOKYO CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1558618666-fcd25c85cd64?w=120&q=80\", \"desc\": \"Shinkansen to Osaka – Osaka Castle – Dotonbori – Free time.\", \"title\": \"TOKYO – OSAKA\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel, free time until transfer to airport.\", \"title\": \"DEPARTURE\"}]'),('japan-403n-nov',1,'JAPAN 403N','Tokyo – Osaka – Kyoto','5 Days 4 Nights','5H 4M','15 – 19 Nov 2026','15 November 2026','19 November 2026',15,'15 Pax','Minimum Peserta',12900000,'[\"Hotel ★3/★4\", \"Transportasi Bus\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat\", \"Visa & Insurance\", \"Pengeluaran Pribadi\", \"Air Mineral\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=120&q=80\", \"desc\": \"Arrival at Narita Airport, meet & greet with guide. Transfer to hotel.\", \"title\": \"ARRIVAL TOKYO\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1513407030348-c983a97b98d8?w=120&q=80\", \"desc\": \"Asakusa Temple – Tokyo Skytree – Shibuya – Shinjuku.\", \"title\": \"TOKYO CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1490806843957-31f4c9a91c65?w=120&q=80\", \"desc\": \"Mt. Fuji area – Hakone Open Air Museum – Lake Ashi – Ropeway.\", \"title\": \"HAKONE TOUR\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1478436127897-769e1b3f0f36?w=120&q=80\", \"desc\": \"Fushimi Inari – Kinkakuji – Arashiyama Bamboo Grove – Gion District.\", \"title\": \"KYOTO TOUR\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel, free time until transfer to airport.\", \"title\": \"DEPARTURE\"}]'),('japan-403n-oct',1,'JAPAN 403N','Tokyo – Osaka – Kyoto','6 Days 5 Nights','6H 5M','20 – 25 Oct 2026','20 Oktober 2026','25 Oktober 2026',15,'15 Pax','Minimum Peserta',15900000,'[\"Hotel ★3/★4\", \"Transportasi Bus\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\", \"Welcome Dinner\"]','[\"Tiket Pesawat\", \"Visa & Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=120&q=80\", \"desc\": \"Arrival at Narita Airport, meet & greet with guide. Transfer to hotel, free time.\", \"title\": \"ARRIVAL TOKYO\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1513407030348-c983a97b98d8?w=120&q=80\", \"desc\": \"Asakusa Temple – Tokyo Skytree – Shibuya – Shinjuku.\", \"title\": \"TOKYO CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1490806843957-31f4c9a91c65?w=120&q=80\", \"desc\": \"Mt. Fuji area – Hakone Open Air Museum – Lake Ashi – Ropeway.\", \"title\": \"HAKONE TOUR\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1478436127897-769e1b3f0f36?w=120&q=80\", \"desc\": \"Fushimi Inari – Kinkakuji (Golden Pavilion) – Arashiyama Bamboo Grove.\", \"title\": \"KYOTO TOUR\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1558618666-fcd25c85cd64?w=120&q=80\", \"desc\": \"Universal Studios Japan (Optional) – Dotonbori – Shopping.\", \"title\": \"OSAKA FREE DAY\"}, {\"day\": 6, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel, free time until transfer to airport.\", \"title\": \"DEPARTURE\"}]'),('japan-403n-sep',1,'JAPAN 403N','Tokyo – Osaka – Kyoto','5 Days 4 Nights','5H 4M','10 – 14 Sep 2026','10 September 2026','14 September 2026',15,'15 Pax','Minimum Peserta',12500000,'[\"Hotel ★3/★4\", \"Transportasi Bus\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat\", \"Visa & Insurance\", \"Pengeluaran Pribadi\", \"Air Mineral\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=120&q=80\", \"desc\": \"Arrival at Narita Airport, meet & greet with guide. Transfer to hotel, free time.\", \"title\": \"ARRIVAL TOKYO\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1513407030348-c983a97b98d8?w=120&q=80\", \"desc\": \"Asakusa Temple – Tokyo Skytree – Shibuya – Shinjuku.\", \"title\": \"TOKYO CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1490806843957-31f4c9a91c65?w=120&q=80\", \"desc\": \"Mt. Fuji area – Hakone Open Air Museum – Lake Ashi – Ropeway.\", \"title\": \"HAKONE TOUR\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1558618666-fcd25c85cd64?w=120&q=80\", \"desc\": \"Shinkansen to Osaka – Osaka Castle – Dotonbori – Free time.\", \"title\": \"TOKYO – OSAKA\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel, free time until transfer to airport.\", \"title\": \"DEPARTURE\"}]'),('korea-401n-aug',2,'KOREA 401N','Seoul – Nami Island – Petite France','4 Days 3 Nights','4H 3M','18 – 21 Aug 2026','18 Agustus 2026','21 Agustus 2026',15,'15 Pax','Minimum Peserta',10500000,'[\"Hotel ★3/★4\", \"Transportasi Bus\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat\", \"Visa & Insurance\", \"Pengeluaran Pribadi\", \"Air Mineral\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1517154421773-0529f29ea451?w=120&q=80\", \"desc\": \"Arrival at Incheon Airport, transfer to hotel. Evening free to explore Myeongdong.\", \"title\": \"ARRIVAL SEOUL\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1540474056-6d6e80e0a9e4?w=120&q=80\", \"desc\": \"Gyeongbokgung Palace – Bukchon Hanok Village – Insadong – Namsan Tower.\", \"title\": \"SEOUL CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1503152394-c571994fd383?w=120&q=80\", \"desc\": \"Nami Island – Petite France – Garden of Morning Calm.\", \"title\": \"NAMI ISLAND & PETITE FRANCE\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast at hotel. Transfer to Incheon Airport.\", \"title\": \"DEPARTURE\"}]'),('korea-502n-oct',2,'KOREA 502N','Seoul – Jeju Island Tour','5 Days 4 Nights','5H 4M','5 – 9 Oct 2026','5 Oktober 2026','9 Oktober 2026',12,'12 Pax','Minimum Peserta',14900000,'[\"Hotel ★4\", \"Transportasi Bus & Pesawat lokal\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat Internasional\", \"Visa & Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1517154421773-0529f29ea451?w=120&q=80\", \"desc\": \"Arrival at Incheon Airport, transfer to hotel. Evening Myeongdong Shopping.\", \"title\": \"ARRIVAL SEOUL\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1540474056-6d6e80e0a9e4?w=120&q=80\", \"desc\": \"Gyeongbokgung Palace – Bukchon Hanok Village – Namsan Tower.\", \"title\": \"SEOUL CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1562832135-14a35d25edef?w=120&q=80\", \"desc\": \"Flight to Jeju – Hallasan Mountain Trail – Jeju Folk Village.\", \"title\": \"SEOUL – JEJU\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1558618047-3c8c76ca7d13?w=120&q=80\", \"desc\": \"Seongsan Ilchulbong – Hyeopjae Beach – Cheonjeyeon Waterfall.\", \"title\": \"JEJU ISLAND TOUR\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Flight back to Seoul/Incheon – Departure to Jakarta.\", \"title\": \"DEPARTURE\"}]'),('turkey-503n-nov',4,'TURKEY 503N','Istanbul – Cappadocia','5 Days 4 Nights','5H 4M','20 – 24 Nov 2026','20 November 2026','24 November 2026',15,'15 Pax','Minimum Peserta',14500000,'[\"Hotel ★3/★4\", \"Transportasi Bus & Penerbangan Domestik\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat Internasional\", \"Balon Udara (optional)\", \"Visa\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1541432901042-2d8bd64b4a9b?w=120&q=80\", \"desc\": \"Arrival at Istanbul Airport, transfer to hotel.\", \"title\": \"ARRIVAL ISTANBUL\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1524231757912-21f4fe3a7200?w=120&q=80\", \"desc\": \"Hagia Sophia – Blue Mosque – Topkapi Palace – Grand Bazaar.\", \"title\": \"ISTANBUL CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1577551086574-0a5bb4bd8cf0?w=120&q=80\", \"desc\": \"Flight to Cappadocia – Göreme Open Air Museum.\", \"title\": \"ISTANBUL – CAPPADOCIA\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1519451241324-20b4ea2c4220?w=120&q=80\", \"desc\": \"Sunrise view – Pigeon Valley – Uçhisar Castle – Pottery Workshop.\", \"title\": \"CAPPADOCIA TOUR\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast, flight back to Istanbul. Departure.\", \"title\": \"DEPARTURE\"}]'),('turkey-703n-sep',4,'TURKEY 703N','Istanbul – Cappadocia – Pamukkale','7 Days 6 Nights','7H 6M','15 – 21 Sep 2026','15 September 2026','21 September 2026',12,'12 Pax','Minimum Peserta',18500000,'[\"Hotel ★4\", \"Transportasi Bus & Penerbangan Domestik\", \"Balon Udara Cappadocia\", \"Tiket sesuai itinerary\", \"Tour Leader\", \"Breakfast\"]','[\"Tiket Pesawat Internasional\", \"Visa\", \"Insurance\", \"Pengeluaran Pribadi\"]','[{\"day\": 1, \"img\": \"https://images.unsplash.com/photo-1541432901042-2d8bd64b4a9b?w=120&q=80\", \"desc\": \"Arrival at Istanbul Airport, transfer to hotel. Evening Bosphorus walk.\", \"title\": \"ARRIVAL ISTANBUL\"}, {\"day\": 2, \"img\": \"https://images.unsplash.com/photo-1524231757912-21f4fe3a7200?w=120&q=80\", \"desc\": \"Hagia Sophia – Blue Mosque – Topkapi Palace – Grand Bazaar.\", \"title\": \"ISTANBUL CITY TOUR\"}, {\"day\": 3, \"img\": \"https://images.unsplash.com/photo-1577551086574-0a5bb4bd8cf0?w=120&q=80\", \"desc\": \"Flight to Cappadocia – Göreme Open Air Museum – Pigeon Valley.\", \"title\": \"ISTANBUL – CAPPADOCIA\"}, {\"day\": 4, \"img\": \"https://images.unsplash.com/photo-1519451241324-20b4ea2c4220?w=120&q=80\", \"desc\": \"Sunrise Hot Air Balloon ride – Underground City – Uçhisar Castle.\", \"title\": \"HOT AIR BALLOON\"}, {\"day\": 5, \"img\": \"https://images.unsplash.com/photo-1569596082827-c5a7a00a1b40?w=120&q=80\", \"desc\": \"Drive to Pamukkale – Cotton Castle Thermal Pools – Hierapolis Ancient City.\", \"title\": \"CAPPADOCIA – PAMUKKALE\"}, {\"day\": 6, \"img\": \"https://images.unsplash.com/photo-1541432901042-2d8bd64b4a9b?w=120&q=80\", \"desc\": \"Morning exploration, flight back to Istanbul. Farewell dinner.\", \"title\": \"PAMUKKALE – ISTANBUL\"}, {\"day\": 7, \"img\": \"https://images.unsplash.com/photo-1436491865332-7a61a109cc05?w=120&q=80\", \"desc\": \"Breakfast, transfer to Istanbul Airport. Departure.\", \"title\": \"DEPARTURE\"}]');
/*!40000 ALTER TABLE `trips` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `videos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `video_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` bigint DEFAULT '0',
  `file_size_formatted` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `videos` WRITE;
/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
INSERT INTO `videos` VALUES (2,'Petualangan Balon Udara Cappadocia Turkey','Pengalaman spektakuler menyaksikan matahari terbit dari atas balon udara bersama para sahabat Travelica di Cappadocia.','assets/uploads/videos/vid_cappadocia_tour_demo.mp4','assets/images/dest_turkey.webp',1128375,'1.1 MB','02:10',3,1,'2026-09-02 10:28:47'),(3,'Batik Ratih – Pabrik Batik Custom & Seragam Batik Berkualitas and 4 more pages   Personal   Microsoft​ Edge 2026 07 25 13 37 10','sDsd','assets/uploads/videos/vid_6a97fd79b8c036.86347713.mp4','assets/uploads/videos/covers/thumb_6a97fd79bbe649.09606766.jpg',32289016,'30.8 MB','00:25',2,1,'2026-09-02 10:42:01');
/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

