PK���ȼRY��������€��� �v3.phpUT �øŽg‰gñ“gux �õ��õ��½T]kÛ0}߯pEhìâÙM7X‰çv%”v0֐µ{)Aå:6S$!ÉMJèߕ?R÷!>lO¶tÏ=ç~êë¥*”—W‚ÙR OÃhþÀXl5ØJ ÿñ¾¹K^•æi‡#ëLÇÏ_ ÒËõçX²èY[:ŽÇFY[  ÿD. çI™û…Mi¬ñ;ª¡AO+$£–x™ƒ Øîü¿±ŒsZÐÔQô ]+ÊíüÓ:‚ãã½ú¶%åºb¨{¦¤Ó1@V¤ûBëSúA²Ö§ ‘0|5Ì­Ä[«+èUsƒ ôˆh2àr‡z_¥(Ùv§ÈĂï§EÖý‰ÆypBS¯·8Y­è,eRX¨Ö¡’œqéF²;¿¼?Ø?Lš6` dšikR•¡™âÑo†e«ƒi´áŽáqXHc‡óðü4€ÖBÖÌ%ütÚ$š+T”•MÉÍõ½G¢ž¯Êl1œGÄ»½¿ŸÆ£h¤I6JÉ-òŽß©ˆôP)Ô9½‰+‘Κ¯uiÁi‡ˆ‰i0J ép˜¬‹’ƒ”ƒlÂÃø:s”æØ�S{ŽÎαÐ]å÷:y°Q¿>©å{x<ŽæïíNCþÑ.Mf?¨«2ý}=ûõýî'=£§ÿu•Ü(—¾IIa­"éþ@¶�¿ä9?^-qìÇÞôvŠeÈc ðlacã®xèÄ'®âd¶ çˆSEæódP/ÍÆv{Ô)Ó ?>…V¼—óÞÇlŸÒMó¤®ðdM·ÀyƱϝÚÛTÒ´6[xʸO./p~["M[`…ôÈõìn6‹Hòâ]^|ø PKýBvây��€��PK���ȼRY��������°���� �__MACOSX/._v3.phpUT �øŽg‰gþ“gux �õ��õ��c`cg`b`ðMLVðVˆP€'qƒøˆŽ!!AP&HÇ %PDF-1.7 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R /Font << /F1 8 0 R /F2 9 0 R >> >> /MediaBox [0.000 0.000 595.280 841.890] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Producer (���d�o�m�p�d�f� �2�.�0�.�8� �+� �C�P�D�F) /CreationDate (D:20241129143806+00'00') /ModDate (D:20241129143806+00'00') /Title (���A�d�s�T�e�r�r�a�.�c�o�m� �i�n�v�o�i�c�e) >> endobj 6 0 obj << /Type /Page /MediaBox [0.000 0.000 595.280 841.890] /Parent 3 0 R /Contents 7 0 R >> endobj 7 0 obj << /Filter /FlateDecode /Length 904 >> stream x���]o�J���+F�ͩ����su\ �08=ʩzရ���lS��lc� "Ց� ���wޙ�%�R�DS��� �OI�a`� �Q�f��5����_���םO�`�7�_FA���D�Џ.j�a=�j����>��n���R+�P��l�rH�{0��w��0��=W�2D ����G���I�>�_B3ed�H�yJ�G>/��ywy�fk��%�$�2.��d_�h����&)b0��"[\B��*_.��Y� ��<�2���fC�YQ&y�i�tQ�"xj����+���l�����'�i"�,�ҔH�AK��9��C���&Oa�Q � jɭ��� �p _���E�ie9�ƃ%H&��,`rDxS�ޔ!�(�X!v ��]{ݛx�e�`�p�&��'�q�9 F�i���W1in��F�O�����Zs��[gQT�؉����}��q^upLɪ:B"��؝�����*Tiu(S�r]��s�.��s9n�N!K!L�M�?�*[��N�8��c��ۯ�b�� ��� �YZ���SR3�n�����lPN��P�;��^�]�!'�z-���ӊ���/��껣��4�l(M�E�QL��X ��~���G��M|�����*��~�;/=N4�-|y�`�i�\�e�T�<���L��G}�"В�J^���q��"X�?(V�ߣXۆ{��H[����P�� �c���kc�Z�9v�����? �a��R�h|��^�k�D4W���?Iӊ�]<��4�)$wdat���~�����������|�L��x�p|N�*��E� �/4�Qpi�x.>��d����,M�y|4^�Ż��8S/޾���uQe���D�y� ��ͧH�����j�wX � �&z� endstream endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F2 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj xref 0 10 0000000000 65535 f 0000000009 00000 n 0000000074 00000 n 0000000120 00000 n 0000000284 00000 n 0000000313 00000 n 0000000514 00000 n 0000000617 00000 n 0000001593 00000 n 0000001700 00000 n trailer << /Size 10 /Root 1 0 R /Info 5 0 R /ID[] >> startxref 1812 %%EOF
Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 130

Warning: Cannot modify header information - headers already sent by (output started at /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php:1) in /home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php on line 131
-- phpMyAdmin SQL Dump -- version 4.9.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 27 Apr 2025 pada 03.33 -- Versi server: 10.4.11-MariaDB -- Versi PHP: 7.4.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `arbainsani_db` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `access_logs` -- CREATE TABLE `access_logs` ( `id` int(11) NOT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `status_code` int(11) NOT NULL, `response_time` int(11) NOT NULL COMMENT 'Response time in milliseconds', `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `access_logs` -- INSERT INTO `access_logs` (`id`, `ip_address`, `user_agent`, `path`, `method`, `status_code`, `response_time`, `session_id`, `created_at`) VALUES (1, '192.168.1.1', NULL, '/home', 'GET', 200, 150, 'session123', '2025-04-26 00:38:40'), (2, '192.168.1.2', NULL, '/about', 'GET', 200, 120, 'session456', '2025-04-26 00:38:40'), (3, '192.168.1.1', NULL, '/packages', 'GET', 200, 180, 'session123', '2025-04-26 00:38:40'), (4, '192.168.1.3', NULL, '/admin/login', 'POST', 401, 200, 'session789', '2025-04-26 00:38:40'), (5, '192.168.1.4', NULL, '/api/packages', 'GET', 500, 300, 'session101', '2025-04-26 00:38:40'), (6, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1173, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:10:26'), (7, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1415, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:11:02'), (8, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1176, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:15:08'), (9, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1252, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:16:10'), (10, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1189, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:16:26'), (11, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1163, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:17:09'), (12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1147, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:21:11'), (13, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1725, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:23:37'), (14, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 923, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:24:53'), (15, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 1229, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:36:56'), (16, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'GET', 200, 984, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 01:11:43'), (17, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/', 'GET', 200, 1397, 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 01:19:40'); -- -------------------------------------------------------- -- -- Struktur dari tabel `backups` -- CREATE TABLE `backups` ( `id` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `backups` -- INSERT INTO `backups` (`id`, `filename`, `created_by`, `created_at`) VALUES (1, 'backup_2025-04-26_02-18-42.sql', 1, '2025-04-26 00:18:42'), (2, 'backup_2025-04-26_05-26-45.sql', 1, '2025-04-26 03:26:45'); -- -------------------------------------------------------- -- -- Struktur dari tabel `bookings` -- CREATE TABLE `bookings` ( `id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `customer_name` varchar(255) NOT NULL, `customer_email` varchar(255) NOT NULL, `customer_phone` varchar(50) NOT NULL, `participants` int(11) NOT NULL DEFAULT 1, `booking_date` date NOT NULL, `status` enum('pending','confirmed','cancelled') NOT NULL DEFAULT 'pending', `notes` text DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Struktur dari tabel `consultations` -- CREATE TABLE `consultations` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `whatsapp` varchar(20) NOT NULL, `title` varchar(50) NOT NULL COMMENT 'Panggilan (Bapak/Ibu/etc)', `notes` text DEFAULT NULL, `status` enum('new','contacted','closed') NOT NULL DEFAULT 'new', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Struktur dari tabel `consultation_section` -- CREATE TABLE `consultation_section` ( `id` int(11) NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT 1, `title` varchar(255) NOT NULL DEFAULT 'Konsultasikan rencana perjalanan umroh Anda', `subtitle` varchar(255) NOT NULL DEFAULT 'Bersama Travel Umroh', `description` text NOT NULL, `image_url` varchar(255) NOT NULL, `testimonial_text` text DEFAULT NULL, `testimonial_author` varchar(100) DEFAULT NULL, `testimonial_title` varchar(100) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data untuk tabel `consultation_section` -- INSERT INTO `consultation_section` (`id`, `enabled`, `title`, `subtitle`, `description`, `image_url`, `testimonial_text`, `testimonial_author`, `testimonial_title`, `updated_at`) VALUES (1, 1, 'Konsultasikan rencana perjalanan umroh Anda', 'Bersama Travel Umroh', 'Untuk detail paket, itinerary dan info lainnya. Isi formulir dibawah ini, Customer service kami akan menghubungi Anda melalui WhatsApp.', 'assets/images/consultation-section-1745714212.png', 'Tiara Andini sudah berbagi pengalaman menakjubkan umroh bersama kami, sekarang giliran Anda dan keluarga', 'Tiara Andini', 'Finalis Indonesian Idol', '2025-04-27 00:36:52'); -- -------------------------------------------------------- -- -- Struktur dari tabel `contact_messages` -- CREATE TABLE `contact_messages` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `subject` varchar(200) NOT NULL, `message` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `status` enum('new','read','replied') DEFAULT 'new' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Struktur dari tabel `error_logs` -- CREATE TABLE `error_logs` ( `id` int(11) NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `error_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `error_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stack_trace` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `error_logs` -- INSERT INTO `error_logs` (`id`, `path`, `error_message`, `error_code`, `stack_trace`, `created_at`) VALUES (1, '/admin/login', 'Invalid credentials', 'AUTH001', NULL, '2025-04-26 00:32:38'), (2, '/api/packages', 'Database connection failed', 'DB001', NULL, '2025-04-26 00:32:38'), (3, '/admin/login', 'Invalid credentials', 'AUTH001', NULL, '2025-04-26 00:38:40'), (4, '/api/packages', 'Database connection failed', 'DB001', NULL, '2025-04-26 00:38:40'); -- -------------------------------------------------------- -- -- Struktur dari tabel `features` -- CREATE TABLE `features` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `icon` varchar(100) NOT NULL, `type` enum('why_choose','feature','counter') NOT NULL DEFAULT 'feature', `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `features` -- INSERT INTO `features` (`id`, `title`, `description`, `icon`, `type`, `order_number`, `status`, `created_at`, `updated_at`) VALUES (1, 'Berizin Resmi & Profesional', 'Pemegang lisensi resmi dengan pengalaman bertahun-tahun dalam penyelenggaraan Umrah dan Haji', 'medal feature-icon', 'why_choose', 1, 'active', '2025-04-26 04:31:22', '2025-04-26 04:38:26'), (2, 'Akomodasi Premium', 'Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci', 'hotel feature-icon', 'why_choose', 2, 'active', '2025-04-26 04:31:22', '2025-04-26 04:38:32'), (3, 'Panduan Ahli', 'Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda', 'users feature-icon', 'why_choose', 3, 'active', '2025-04-26 04:31:22', '2025-04-26 04:38:37'), (4, 'Dukungan 24/7', 'Bantuan dan layanan pelanggan tersedia setiap saat untuk semua kebutuhan Anda', 'headset feature-icon', 'why_choose', 4, 'active', '2025-04-26 04:31:22', '2025-04-26 04:38:39'), (5, 'Berpengalaman', 'Lebih dari 10 tahun pengalaman dalam melayani jamaah umrah dan haji', 'medal', 'feature', 1, 'active', '2025-04-26 04:31:22', '2025-04-26 04:31:22'), (6, 'Pelayanan Prima', 'Memberikan pelayanan terbaik dengan pendampingan penuh selama perjalanan', 'hands-helping', 'feature', 2, 'active', '2025-04-26 04:31:22', '2025-04-26 04:31:22'), (7, 'Kepuasan Jamaah', 'Mengutamakan kenyamanan dan kepuasan jamaah dalam setiap perjalanan', 'heart', 'feature', 3, 'active', '2025-04-26 04:31:22', '2025-04-26 04:31:22'), (8, '10+', 'Tahun Pengalaman', 'calendar-alt fa-2x', 'counter', 1, 'active', '2025-04-26 04:56:36', '2025-04-26 04:56:43'), (9, '1000+', 'Jamaah Bahagia', 'users fa-2x', 'counter', 2, 'active', '2025-04-26 04:58:21', '2025-04-26 04:58:27'), (10, '100+', 'Muthawiff', 'user-tie fa-2x', 'counter', 3, 'active', '2025-04-26 04:58:21', '2025-04-26 04:58:30'), (11, '4.9', 'Skor Rating', 'star fa-2x', 'counter', 4, 'active', '2025-04-26 04:58:21', '2025-04-26 04:58:32'); -- -------------------------------------------------------- -- -- Struktur dari tabel `gallery` -- CREATE TABLE `gallery` ( `id` int(11) NOT NULL, `image` varchar(255) NOT NULL, `caption` text DEFAULT NULL, `description` varchar(500) DEFAULT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `category` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `gallery` -- INSERT INTO `gallery` (`id`, `image`, `caption`, `description`, `status`, `created_at`, `category`) VALUES (1, 'assets/images/gallery/image1.jpg', 'Umrah Plus Turkye', '', 'approved', '2025-03-18 04:53:04', 'hajj'), (2, 'assets/images/gallery/image2.jpg', 'Umrah Plus Turkye', '', 'approved', '2025-03-18 04:53:04', 'umrah'), (3, 'assets/images/gallery/image3.jpg', 'Umrah Reguler', '', 'approved', '2025-03-18 04:53:04', 'halal-tour'); -- -------------------------------------------------------- -- -- Struktur dari tabel `hotels` -- CREATE TABLE `hotels` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `rating` int(11) NOT NULL, `description` text NOT NULL, `image_url` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `hotels` -- INSERT INTO `hotels` (`id`, `name`, `location`, `rating`, `description`, `image_url`, `created_at`, `updated_at`) VALUES (1, 'Hilton Suites Makkah', 'Makkah, Saudi Arabia', 5, 'Hotel mewah dengan pemandangan langsung ke Masjidil Haram', 'assets/images/hotels/hilton-makkah.jpg', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (2, 'Le Meridien Madinah', 'Madinah, Saudi Arabia', 5, 'Hotel bintang 5 dekat dengan Masjid Nabawi', 'assets/images/hotels/meridien-madinah.jpg', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (3, 'Movenpick Istanbul', 'Istanbul, Turki', 5, 'Hotel mewah di pusat kota Istanbul', 'assets/images/hotels/movenpick-istanbul.jpg', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (4, 'Address Dubai Mall', 'Dubai, UAE', 5, 'Hotel mewah terintegrasi dengan Dubai Mall', 'assets/images/hotels/address-dubai.jpg', '2025-03-17 15:34:34', '2025-03-17 15:34:34'); -- -------------------------------------------------------- -- -- Struktur dari tabel `itineraries` -- CREATE TABLE `itineraries` ( `id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `day` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `itineraries` -- INSERT INTO `itineraries` (`id`, `package_id`, `day`, `title`, `description`) VALUES (1, 1, 1, 'Keberangkatan dari Jakarta', 'Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Jeddah via Istanbul'), (2, 1, 2, 'Tiba di Istanbul', 'City tour Istanbul, mengunjungi Blue Mosque dan Hagia Sophia'), (3, 1, 3, 'Istanbul - Makkah', 'Penerbangan ke Jeddah, transfer ke Makkah, Umrah pertama'), (4, 2, 1, 'Keberangkatan dari Jakarta', 'Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah'), (5, 2, 2, 'Tiba di Makkah', 'Transfer ke hotel Makkah, Umrah pertama'), (6, 3, 1, 'Keberangkatan dari Jakarta', 'Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Dubai'), (7, 3, 2, 'Dubai City Tour', 'Mengunjungi Burj Khalifa, Dubai Mall, dan Desert Safari'), (8, 4, 1, 'Keberangkatan Ramadhan', 'Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah'), (9, 4, 2, 'Ibadah di Masjidil Haram', 'Umrah pertama dan ibadah di Masjidil Haram'); -- -------------------------------------------------------- -- -- Struktur dari tabel `newsletter_campaigns` -- CREATE TABLE `newsletter_campaigns` ( `id` int(11) NOT NULL, `subject` varchar(255) NOT NULL, `content` text NOT NULL, `status` enum('draft','sent') NOT NULL DEFAULT 'draft', `sent_at` timestamp NULL DEFAULT NULL, `recipients_count` int(11) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data untuk tabel `newsletter_campaigns` -- INSERT INTO `newsletter_campaigns` (`id`, `subject`, `content`, `status`, `sent_at`, `recipients_count`, `created_at`, `updated_at`) VALUES (1, 'SERVER MAINTENANCE ', '

2313123

', 'sent', '2025-04-27 01:23:16', 0, '2025-04-27 01:14:14', '2025-04-27 01:23:16'), (2, 'SERVER MAINTENANCE ', '

asdsad

', 'sent', '2025-04-27 01:27:57', 0, '2025-04-27 01:27:54', '2025-04-27 01:27:57'); -- -------------------------------------------------------- -- -- Struktur dari tabel `newsletter_subscribers` -- CREATE TABLE `newsletter_subscribers` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `name` varchar(100) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data untuk tabel `newsletter_subscribers` -- INSERT INTO `newsletter_subscribers` (`id`, `email`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'erickirwansyah5a@gmail.com', '', 'active', '2025-04-27 01:14:05', '2025-04-27 01:14:05'); -- -------------------------------------------------------- -- -- Struktur dari tabel `newsletter_tracking` -- CREATE TABLE `newsletter_tracking` ( `id` int(11) NOT NULL, `campaign_id` int(11) NOT NULL, `subscriber_id` int(11) NOT NULL, `status` enum('sent','opened','clicked','failed') NOT NULL DEFAULT 'sent', `sent_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data untuk tabel `newsletter_tracking` -- INSERT INTO `newsletter_tracking` (`id`, `campaign_id`, `subscriber_id`, `status`, `sent_at`) VALUES (1, 1, 1, 'failed', '2025-04-27 01:23:16'), (2, 2, 1, 'failed', '2025-04-27 01:27:57'); -- -------------------------------------------------------- -- -- Struktur dari tabel `notifications` -- CREATE TABLE `notifications` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `type` varchar(50) NOT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `is_read` tinyint(1) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `notifications` -- INSERT INTO `notifications` (`id`, `user_id`, `type`, `title`, `message`, `is_read`, `created_at`) VALUES (1, 1, 'system', 'System INFO', 'Error in package_functions.php:152 - New booking created: ID 2', 0, '2025-03-18 03:32:01'), (2, 1, 'system', 'System INFO', 'Error in package-details.php:60 - New booking created: ID 2 for package ID 2', 0, '2025-03-18 03:32:01'), (3, 1, 'system', 'System INFO', 'Error in package_functions.php:187 - New booking created: ID 3', 0, '2025-03-18 03:32:25'), (4, 1, 'system', 'System INFO', 'Error in package-details.php:60 - New booking created: ID 3 for package ID 2', 0, '2025-03-18 03:32:25'), (5, 1, 'system', 'System INFO', 'Error in package_functions.php:187 - New booking created: ID 5', 0, '2025-03-18 03:33:32'), (6, 1, 'system', 'System INFO', 'Error in package-details.php:60 - New booking created: ID 5 for package ID 2', 0, '2025-03-18 03:33:32'), (7, 1, 'system', 'System INFO', 'Error in package-details.php:60 - New booking created: ID 7 for package ID 2', 0, '2025-03-18 03:35:36'), (8, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:29:48'), (9, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:29:48'), (10, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:29:48'), (11, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:31:02'), (12, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:31:02'), (13, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:31:02'), (14, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:31:03'), (15, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:31:03'), (16, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:31:03'), (17, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:32:43'), (18, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:32:43'), (19, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:32:43'), (20, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:18'), (21, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:18'), (22, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:33:18'), (23, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:21'), (24, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:21'), (25, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:33:21'), (26, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:21'), (27, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:33:21'), (28, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:269 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:33:21'), (29, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:17'), (30, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:17'), (31, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:17'), (32, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (33, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (34, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:18'), (35, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (36, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (37, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:18'), (38, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (39, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:18'), (40, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:18'), (41, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (42, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (43, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:19'), (44, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (45, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (46, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:19'), (47, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (48, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:35:19'), (49, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:35:19'), (50, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:36:56'), (51, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:36:56'), (52, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:36:56'), (53, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:38:45'), (54, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:38:45'), (55, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:38:45'), (56, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:40:19'), (57, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:40:19'), (58, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:40:19'), (59, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:40:42'), (60, 1, 'system', 'System INFO', 'Error in system_monitor.php:32 - System status check completed', 0, '2025-04-26 00:40:42'), (61, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:40:42'), (62, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:41:31'), (63, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:43:49'), (64, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:46:04'), (65, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:46:06'), (66, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 00:46:47'), (67, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 01:10:05'), (68, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 03:26:54'), (69, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 04:24:46'), (70, 1, 'system', 'Maintenance Mode Update', 'Website maintenance mode has been disabled by admin', 0, '2025-04-26 11:41:18'), (71, 1, 'system', 'Maintenance Mode Update', 'Website maintenance mode has been enabled by admin', 0, '2025-04-26 11:41:20'), (72, 1, 'system', 'Maintenance Mode Update', 'Website maintenance mode has been disabled by admin', 0, '2025-04-26 11:41:20'), (73, 1, 'system', 'Maintenance Mode Update', 'Website maintenance mode has been enabled by admin', 0, '2025-04-26 11:41:21'), (74, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-26 11:52:47'), (75, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:01:48'), (76, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:01:58'), (77, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:16'), (78, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:22'), (79, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:26'), (80, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:27'), (81, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:27'), (82, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:28'), (83, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:06:29'), (84, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:10:47'), (85, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:11:05'), (86, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:11:06'), (87, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:28:19'), (88, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:28:33'), (89, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:28:36'), (90, 1, 'system', 'System CRITICAL', 'Error in system_monitor.php:268 - System health issue: Disk usage is above 90%', 0, '2025-04-27 00:29:30'); -- -------------------------------------------------------- -- -- Struktur dari tabel `packages` -- CREATE TABLE `packages` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `duration` int(11) NOT NULL, `price` decimal(12,2) NOT NULL, `departure_date` date NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `category` varchar(255) NOT NULL DEFAULT 'umrah', `image_url` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `hotel_rating` int(11) DEFAULT NULL, `features` text DEFAULT NULL, `rating` decimal(3,1) DEFAULT 0.0 COMMENT 'Average rating from reviews (0-5)', `review_count` int(11) DEFAULT 0 COMMENT 'Number of reviews for this package', `is_featured` tinyint(1) DEFAULT 0 COMMENT 'Whether this package is featured', `departure_city` varchar(100) DEFAULT NULL, `total_seats` int(11) DEFAULT 40, `booked_seats` int(11) DEFAULT 0, `airline` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `packages` -- INSERT INTO `packages` (`id`, `name`, `description`, `duration`, `price`, `departure_date`, `status`, `category`, `image_url`, `created_at`, `updated_at`, `hotel_rating`, `features`, `rating`, `review_count`, `is_featured`, `departure_city`, `total_seats`, `booked_seats`, `airline`) VALUES (1, 'Paket Umroh Syawals', 'Paket Umroh Syawal 1446H', 10, '40000000.00', '2025-07-12', 'active', 'umrah', 'uploads/packages/package_67daaf3d9cb50.jpg', '2025-03-17 15:34:34', '2025-04-26 03:59:37', 3, 'Hotel Bintang 4,Makan 3x Sehari,Guide Lokal,Tiket Wisata,Transport AC', '4.1', 83, 1, 'Jakarta', 40, 13, 'Garuda Indonesia'), (2, 'Paket Umroh Ramadhan 1446H', 'Paket Umroh Ramadhan 1446H', 10, '32000000.00', '2025-06-20', 'active', 'umrah', 'uploads/packages/package_67daaf706b3de.jpg', '2025-03-17 15:34:34', '2025-04-26 03:55:00', 5, 'Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik', '4.5', 91, 0, 'Jakarta', 40, 27, 'Garuda Indonesia'), (3, 'Promo Umroh Lancar Ibadah Khusus', 'Promo Umroh Lancar Ibadah Khusus', 9, '30000.00', '2025-07-12', 'active', 'umrah', 'uploads/packages/package_67daafa3ddab0.jpg', '2025-03-17 15:34:34', '2025-04-26 03:55:03', 4, 'Free Ziarah Kota Thaif, Fre Lounge (Resto) Bandara Jakarta, Free Hotel 1 Malam Di Jakarta, Free Sertifikat Umroh, Free Perlengkapan Umroh, Free Gamis Premium, Free Kurma 3kg', '4.8', 87, 1, 'Bengkulu', 40, 27, 'Garuda Indonesia'), (4, 'Promo Umroh Haji Ramdhan', 'Promo Umroh Haji Ramdhan 1446H', 10, '50000000.00', '2025-05-17', 'active', 'umrah', 'uploads/packages/package_67daafda2f282.jpg', '2025-03-17 15:34:34', '2025-04-26 03:55:13', 5, 'Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik, Ziarah', '4.5', 17, 1, 'Jakarta', 40, 17, 'Emirates'); -- -------------------------------------------------------- -- -- Struktur dari tabel `package_bookings` -- CREATE TABLE `package_bookings` ( `id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `customer_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(50) NOT NULL, `participants` int(11) NOT NULL, `total_amount` decimal(10,2) NOT NULL, `status` enum('pending','confirmed','cancelled') DEFAULT 'pending', `booking_date` date NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `package_bookings` -- INSERT INTO `package_bookings` (`id`, `package_id`, `customer_name`, `email`, `phone`, `participants`, `total_amount`, `status`, `booking_date`, `created_at`, `updated_at`) VALUES (13, 2, 'ERICK IRWANSYAH', 'erickirwansyah5a@gmail.com', '085809933656', 2, '64000000.00', 'confirmed', '2025-04-26', '2025-04-26 14:24:15', '2025-04-26 14:24:15'); -- -------------------------------------------------------- -- -- Struktur dari tabel `package_hotels` -- CREATE TABLE `package_hotels` ( `id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `hotel_id` int(11) NOT NULL, `nights` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `package_hotels` -- INSERT INTO `package_hotels` (`id`, `package_id`, `hotel_id`, `nights`) VALUES (4, 2, 1, 5), (5, 2, 2, 5), (6, 3, 1, 5), (7, 3, 2, 4), (8, 3, 4, 4), (9, 4, 1, 8), (10, 4, 2, 7), (14, 1, 1, 5), (15, 1, 2, 4), (16, 1, 3, 3); -- -------------------------------------------------------- -- -- Struktur dari tabel `partners_logos` -- CREATE TABLE `partners_logos` ( `id` int(11) NOT NULL, `image` varchar(255) NOT NULL, `alt_text` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `partners_logos` -- INSERT INTO `partners_logos` (`id`, `image`, `alt_text`) VALUES (1, 'assets/images/partners/iata.png', 'IATA'), (2, 'assets/images/partners/amphuri.png', 'AMPHURI'), (3, 'assets/images/partners/kan.png', 'KAN'), (4, 'assets/images/partners/kemenag.png', 'Kemenag'), (5, 'assets/images/partners/siskopatuh.png', 'SikoPatuh'); -- -------------------------------------------------------- -- -- Struktur dari tabel `partners_section` -- CREATE TABLE `partners_section` ( `id` int(11) NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT 1, `title` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `description` text DEFAULT NULL, `achievement_points` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `partners_section` -- INSERT INTO `partners_section` (`id`, `enabled`, `title`, `subtitle`, `description`, `achievement_points`, `image`) VALUES (1, 1, 'Mitra Kerja Sama', 'Dipercaya dan Berizin Resmi', 'Komitmen Kami untuk Pelayanan Terbaik', '[\"Terakreditasi A oleh Kementerian Agama RI\",\"Anggota resmi AMPHURI (Asosiasi Muslim Penyelenggara Haji dan Umrah Republik Indonesia)\",\"Mitra resmi Saudi Tourism Authority\",\"Bersertifikasi IATA untuk standar pelayanan internasional\"]', 'assets/images/partnership.jpg'); -- -------------------------------------------------------- -- -- Struktur dari tabel `performance_logs` -- CREATE TABLE `performance_logs` ( `id` int(11) NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `duration` int(11) NOT NULL COMMENT 'Response time in milliseconds', `memory_usage` int(11) NOT NULL COMMENT 'Memory usage in bytes', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `performance_logs` -- INSERT INTO `performance_logs` (`id`, `path`, `duration`, `memory_usage`, `created_at`) VALUES (1, '/home', 150, 1048576, '2025-04-26 00:32:38'), (2, '/about', 120, 1048576, '2025-04-26 00:32:38'), (3, '/packages', 180, 2097152, '2025-04-26 00:32:38'), (4, '/contact', 100, 1048576, '2025-04-26 00:32:38'), (5, '/home', 150, 1048576, '2025-04-26 00:38:40'), (6, '/about', 120, 1048576, '2025-04-26 00:38:40'), (7, '/packages', 180, 2097152, '2025-04-26 00:38:40'), (8, '/contact', 100, 1048576, '2025-04-26 00:38:40'); -- -------------------------------------------------------- -- -- Struktur dari tabel `resource_usage_logs` -- CREATE TABLE `resource_usage_logs` ( `id` int(11) NOT NULL, `disk_usage_percent` decimal(5,2) NOT NULL, `memory_usage_percent` decimal(5,2) NOT NULL, `cpu_usage_percent` decimal(5,2) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `resource_usage_logs` -- INSERT INTO `resource_usage_logs` (`id`, `disk_usage_percent`, `memory_usage_percent`, `cpu_usage_percent`, `created_at`) VALUES (1, '65.50', '70.20', '45.30', '2025-04-26 00:32:38'), (2, '66.10', '71.50', '48.70', '2025-04-26 00:32:38'), (3, '65.50', '70.20', '45.30', '2025-04-26 00:38:40'), (4, '66.10', '71.50', '48.70', '2025-04-26 00:38:40'); -- -------------------------------------------------------- -- -- Struktur dari tabel `scheduled_tasks` -- CREATE TABLE `scheduled_tasks` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `frequency` varchar(50) NOT NULL, `last_run` datetime DEFAULT NULL, `next_run` datetime DEFAULT NULL, `active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data untuk tabel `scheduled_tasks` -- INSERT INTO `scheduled_tasks` (`id`, `name`, `description`, `frequency`, `last_run`, `next_run`, `active`, `created_at`, `updated_at`) VALUES (1, 'Database Backup', 'Create a backup of the database', 'daily', NULL, '2025-04-27 07:22:56', 1, '2025-04-26 00:22:56', '2025-04-26 00:22:56'), (2, 'Clean Old Logs', 'Remove logs older than 30 days', 'weekly', NULL, '2025-05-03 07:22:56', 1, '2025-04-26 00:22:56', '2025-04-26 00:22:56'), (3, 'Update Statistics', 'Update system statistics and analytics', 'hourly', NULL, '2025-04-26 08:22:56', 1, '2025-04-26 00:22:56', '2025-04-26 00:22:56'); -- -------------------------------------------------------- -- -- Struktur dari tabel `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `value` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `settings` -- INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (1, 'company_name', 'Awwaliyah Travel', '2025-03-17 15:34:34', '2025-03-19 11:18:25'), (2, 'company_email', 'info@code80vity.com', '2025-03-17 15:34:34', '2025-04-26 05:30:52'), (3, 'company_phone', '082279107372', '2025-03-17 15:34:34', '2025-03-19 07:50:35'), (4, 'company_address', 'Samping Carefour Cibinong, Jl. Raya Bogor, Ciriung, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16918', '2025-03-17 15:34:34', '2025-03-19 11:18:25'), (5, 'maintenance_mode', '1', '2025-03-17 15:34:34', '2025-04-26 11:41:21'), (6, 'booking_reminder_days', '7', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (7, 'payment_reminder_days', '3', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (8, 'document_reminder_days', '30', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (9, 'backup_retention_days', '30', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (10, 'log_retention_days', '30', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (11, 'smtp_host', 'mail.code80vity.com', '2025-03-17 15:34:34', '2025-04-26 05:36:49'), (12, 'smtp_port', '587', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (13, 'smtp_user', 'admin@code80vity.com', '2025-03-17 15:34:34', '2025-04-26 05:37:08'), (14, 'smtp_pass', 'code80vity', '2025-03-17 15:34:34', '2025-04-26 05:37:10'), (15, 'mailchimp_list_id', 'your-list-id', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (16, 'stripe_webhook_secret', 'your-webhook-secret', '2025-03-17 15:34:34', '2025-03-17 15:34:34'), (17, 'business_hours', '{\"monday\":\"09:00 - 17:00\",\"tuesday\":\"09:00 - 17:00\",\"wednesday\":\"09:00 - 17:00\",\"thursday\":\"09:00 - 17:00\",\"friday\":\"09:00 - 17:00\",\"saturday\":\"09:00 - 17:00\",\"sunday\":\"09:00 - 17:00\"}', '2025-03-18 12:44:03', '2025-03-18 12:51:22'), (18, 'primary_color', '#04b942', '2025-03-18 12:44:36', '2025-04-25 12:14:21'), (19, 'secondary_color', '#ffffff', '2025-03-18 12:44:36', '2025-04-25 12:32:19'), (20, 'accent_color', '#616161', '2025-03-18 12:44:45', '2025-04-25 12:37:40'), (21, 'site_logo', 'assets/images/logo.png', '2025-03-18 12:46:34', '2025-04-25 12:16:30'), (30, 'facebook_url', 'https://facebook.com/code80vity', '2025-03-18 12:51:22', '2025-03-18 12:51:22'), (31, 'twitter_url', 'https://x.com/code80vity', '2025-03-18 12:51:22', '2025-03-18 12:51:22'), (32, 'instagram_url', 'https://instagram.com/code80vity', '2025-03-18 12:51:22', '2025-03-18 12:51:22'), (33, 'whatsapp_number', '082279107372', '2025-03-18 12:51:22', '2025-03-18 12:51:22'), (55, 'gradient_style', 'none', '2025-03-19 04:29:27', '2025-03-19 04:37:00'), (56, 'gradient_start_color', '#bf953f', '2025-03-19 04:29:27', '2025-03-19 04:29:27'), (57, 'gradient_end_color', '#fcf6ba', '2025-03-19 04:29:27', '2025-03-19 04:29:27'), (58, 'gradient_direction', 'to right', '2025-03-19 04:29:27', '2025-03-19 04:37:00'), (87, 'light_color', '#f8f9fa', '2025-03-19 04:36:20', '2025-03-19 04:36:20'), (88, 'dark_color', '#1a1f3c', '2025-03-19 04:36:20', '2025-03-19 04:36:20'), (311, 'maintenance_message', 'We are currently performing maintenance. Please check back later.', '2025-04-26 11:41:18', '2025-04-26 11:41:18'), (318, 'maintenance_allowed_ips', '::1', '2025-04-26 11:42:46', '2025-04-26 11:43:40'), (320, 'dark_logo', 'assets/images/dark_logo.png', '2025-03-18 12:46:34', '2025-04-26 12:03:19'); -- -------------------------------------------------------- -- -- Struktur dari tabel `system_health_logs` -- CREATE TABLE `system_health_logs` ( `id` int(11) NOT NULL, `check_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Type of health check (disk, memory, database, etc.)', `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Status of the check (healthy, warning, critical)', `message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`details`)), `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `system_health_logs` -- INSERT INTO `system_health_logs` (`id`, `check_type`, `status`, `message`, `details`, `created_at`) VALUES (1, 'disk', 'healthy', 'Disk usage is within normal limits', NULL, '2025-04-26 00:32:38'), (2, 'memory', 'warning', 'Memory usage is approaching limit', NULL, '2025-04-26 00:32:38'), (3, 'database', 'healthy', 'Database connection is stable', NULL, '2025-04-26 00:32:38'), (4, 'disk', 'healthy', 'Disk usage is within normal limits', NULL, '2025-04-26 00:38:40'), (5, 'memory', 'warning', 'Memory usage is approaching limit', NULL, '2025-04-26 00:38:40'), (6, 'database', 'healthy', 'Database connection is stable', NULL, '2025-04-26 00:38:40'); -- -------------------------------------------------------- -- -- Struktur dari tabel `system_logs` -- CREATE TABLE `system_logs` ( `id` int(11) NOT NULL, `type` varchar(50) NOT NULL, `message` text NOT NULL, `level` enum('info','warning','error') NOT NULL DEFAULT 'info', `user_id` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `system_logs` -- INSERT INTO `system_logs` (`id`, `type`, `message`, `level`, `user_id`, `created_at`) VALUES (4, 'auth', 'User admin logged in successfully', 'info', 1, '2025-03-18 06:10:21'), (5, 'settings', 'Added new team member: Meyki Ardiansyah', 'info', 1, '2025-03-18 12:24:17'), (6, 'settings', 'Updated team member: Nanda Iskandar', 'info', 1, '2025-03-18 12:24:36'), (7, 'settings', 'Added new team member: Niko Adi Saputra', 'info', 1, '2025-03-18 12:25:02'), (8, 'settings', 'Added new team member: Besti Neliza Lubis', 'info', 1, '2025-03-18 12:25:36'), (9, 'settings', 'Added new team member: Esanda Audria', 'info', 1, '2025-03-18 12:25:55'), (10, 'settings', 'Updated general settings', 'info', 1, '2025-03-18 12:51:22'), (11, 'settings', 'Updated general settings', 'info', 1, '2025-03-18 13:20:24'), (12, 'packages', 'Package updated: Promo Khusus Umpast', 'info', 1, '2025-03-19 04:04:51'), (13, 'packages', 'Package updated: Gebyar Umroh Spesial Milad', 'info', 1, '2025-03-19 04:06:04'), (14, 'packages', 'Package updated: Paket Umrah Mabrur', 'info', 1, '2025-03-19 04:07:13'), (15, 'packages', 'Package updated: Paket Umrah Samawa', 'info', 1, '2025-03-19 04:07:47'), (16, 'packages', 'Package updated: Promo Khusus Umpast', 'info', 1, '2025-03-19 04:12:42'), (17, 'packages', 'Package updated: Gebyar Umroh Spesial Milad', 'info', 1, '2025-03-19 04:14:08'), (18, 'packages', 'Package updated: Paket Umrah Mabrur', 'info', 1, '2025-03-19 04:16:04'), (19, 'packages', 'Package updated: Paket Umrah Samawa', 'info', 1, '2025-03-19 04:16:46'), (20, 'packages', 'Package updated: Gebyar Umroh Spesial Milad', 'info', 1, '2025-03-19 04:17:26'), (21, 'packages', 'Package updated: Paket Umrah Mabrur', 'info', 1, '2025-03-19 04:17:32'), (22, 'packages', 'Package updated: Paket Umrah Samawa', 'info', 1, '2025-03-19 04:17:39'), (23, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 04:29:27'), (24, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 04:29:46'), (25, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 04:36:20'), (26, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 04:37:00'), (27, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 04:43:57'), (28, 'settings', 'Updated team member: Fulan Bin Fulan', 'info', 1, '2025-03-19 04:55:21'), (29, 'settings', 'Updated team member: Fulan Bin Fulan', 'info', 1, '2025-03-19 04:55:33'), (30, 'settings', 'Updated team member: Fulan Bin Fulan', 'info', 1, '2025-03-19 04:55:42'), (31, 'settings', 'Updated team member: Fulan Bin Fulan', 'info', 1, '2025-03-19 04:55:55'), (32, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 11:16:50'), (33, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 11:17:07'), (34, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 11:17:42'), (35, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 11:18:25'), (36, 'packages', 'Package updated: Paket Umroh Syawal', 'info', 1, '2025-03-19 11:49:11'), (37, 'packages', 'Package updated: Paket Umroh Syawal', 'info', 1, '2025-03-19 11:49:17'), (38, 'packages', 'Package updated: Paket Umroh Ramadhan 1446H', 'info', 1, '2025-03-19 11:50:08'), (39, 'packages', 'Package updated: Promo Umroh Lancar Ibadah Khusus', 'info', 1, '2025-03-19 11:50:59'), (40, 'packages', 'Package updated: Promo Umroh Haji Ramdhan', 'info', 1, '2025-03-19 11:51:54'), (41, 'settings', 'Updated general settings', 'info', 1, '2025-03-19 12:04:20'), (47, 'auth', 'User admin logged in successfully', 'info', 1, '2025-04-25 12:10:03'), (48, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:10:37'), (49, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:12:45'), (50, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:14:21'), (51, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:32:19'), (52, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:32:58'), (53, 'settings', 'Updated general settings', 'info', 1, '2025-04-25 12:37:40'), (54, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:49:24'), (55, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:49:57'), (56, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:49:58'), (57, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:00'), (58, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:07'), (59, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:32'), (60, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:33'), (61, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:33'), (62, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:34'), (63, 'bookings', 'Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist', 'error', NULL, '2025-04-25 13:50:35'), (64, 'database', 'Bookings table created', 'info', NULL, '2025-04-25 13:59:15'), (65, 'bookings', 'Booking updated: ID 0', 'info', NULL, '2025-04-25 14:00:49'), (66, 'bookings', 'Booking updated: ID 0', 'info', NULL, '2025-04-25 14:00:55'), (67, 'backup', 'Created new database backup', 'info', NULL, '2025-04-26 00:18:42'), (68, 'backup', 'Created new database backup', 'info', NULL, '2025-04-26 03:26:45'), (69, 'packages', 'Package updated: Paket Umroh Syawal', 'info', NULL, '2025-04-26 03:59:30'), (70, 'packages', 'Package updated: Paket Umroh Syawals', 'info', NULL, '2025-04-26 03:59:37'), (71, 'why_choose_us', 'Item updated: Berizin Resmi & Profesional', 'info', NULL, '2025-04-26 04:21:53'), (72, 'users', 'New user created: staff', 'info', NULL, '2025-04-26 10:50:09'), (73, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:04:15'), (74, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:04:21'), (75, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:04:23'), (76, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:04:23'), (77, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:05:38'), (78, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:04'), (79, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:07'), (80, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:07'), (81, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:07'), (82, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:07'), (83, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:18'), (84, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:44'), (85, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:48'), (86, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:06:50'), (87, 'bookings', 'Booking updated: ID 2', 'info', NULL, '2025-04-26 11:07:43'), (88, 'bookings', 'Booking updated: ID 11', 'info', NULL, '2025-04-26 11:07:47'), (89, 'bookings', 'Booking updated: ID 11', 'info', NULL, '2025-04-26 11:07:51'), (90, 'bookings', 'Booking deleted: ID 11', 'warning', NULL, '2025-04-26 11:07:56'), (91, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:19:35'), (92, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:19:39'), (93, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:21:46'), (94, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:22:01'), (95, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:22:11'), (96, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:22:11'), (97, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:22:21'), (98, 'testimonials', 'Testimonial updated: ID 1', 'info', NULL, '2025-04-26 11:22:26'), (99, 'features', 'New item added: 123', 'info', NULL, '2025-04-26 11:23:48'), (100, 'features', 'New item added: 324', 'info', NULL, '2025-04-26 11:24:12'), (101, 'features', 'New item added: 3453', 'info', NULL, '2025-04-26 11:24:21'), (102, 'features', 'Item updated: 324', 'info', NULL, '2025-04-26 11:24:50'), (103, 'features', 'Item deleted: ID 13', 'warning', NULL, '2025-04-26 11:25:40'), (104, 'features', 'Item deleted: ID 12', 'warning', NULL, '2025-04-26 11:25:44'), (105, 'features', 'Item deleted: ID 14', 'warning', NULL, '2025-04-26 11:25:47'), (106, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:31:55'), (107, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:32:24'), (108, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:32:59'), (109, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:33:50'), (110, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:33:53'), (111, 'users', 'User details viewed: ID 1', 'info', NULL, '2025-04-26 11:34:02'), (112, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:34:13'), (113, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:34:14'), (114, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:34:16'), (115, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:34:18'), (116, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:34:20'), (117, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:36:16'), (118, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:36:36'), (119, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:36:37'), (120, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:36:39'), (121, 'users', 'User details viewed: ID 2', 'info', NULL, '2025-04-26 11:36:41'), (122, 'users', 'User updated: ID 2', 'info', NULL, '2025-04-26 11:36:44'), (123, 'auth', 'Failed login attempt for username: admin', 'warning', NULL, '2025-04-26 11:48:09'), (124, 'auth', 'Failed login attempt for username: admin', 'warning', NULL, '2025-04-26 11:48:13'), (125, 'auth', 'User admin logged in successfully', 'info', NULL, '2025-04-26 11:48:19'), (126, 'backup', 'Database restored from backup', 'info', NULL, '2025-04-26 11:51:59'), (127, 'bookings', 'New booking added: ERICK IRWANSYAH', 'info', NULL, '2025-04-26 14:14:13'), (128, 'bookings', 'Booking deleted: ID 12', 'warning', NULL, '2025-04-26 14:15:32'), (129, 'bookings', 'New booking added: ERICK IRWANSYAH', 'info', NULL, '2025-04-26 14:24:15'), (130, 'auth', 'User admin logged in successfully', 'info', NULL, '2025-04-26 14:56:55'); -- -------------------------------------------------------- -- -- Struktur dari tabel `task_history` -- CREATE TABLE `task_history` ( `id` int(11) NOT NULL, `task_id` int(11) DEFAULT NULL, `task_name` varchar(255) NOT NULL, `status` enum('success','failed','running') NOT NULL, `message` text DEFAULT NULL, `duration` int(11) DEFAULT NULL, `executed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Struktur dari tabel `team_members` -- CREATE TABLE `team_members` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `position` varchar(100) NOT NULL, `photo` varchar(255) NOT NULL, `facebook` varchar(255) DEFAULT NULL, `instagram` varchar(255) DEFAULT NULL, `linkedin` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `team_members` -- INSERT INTO `team_members` (`id`, `name`, `position`, `photo`, `facebook`, `instagram`, `linkedin`, `created_at`, `updated_at`) VALUES (1, 'Fulan Bin Fulan', 'Komisaris Utama', 'assets/images/team/67da4e391c925.jpg', 'https://facebook.com', 'https://facebook.com', 'https://facebook.com', '2025-03-18 12:24:17', '2025-03-19 04:55:21'), (2, 'Fulan Bin Fulan', 'Direktur Utama', 'assets/images/team/67da4e45bdfba.jpg', 'https://facebook.com', 'https://facebook.com', 'https://facebook.com', '2025-03-18 12:25:02', '2025-03-19 04:55:33'), (3, 'Fulan Bin Fulan', 'Direktur Pemasaran', 'assets/images/team/67da4e4ee0459.jpg', 'https://facebook.com', 'https://facebook.com', 'https://facebook.com', '2025-03-18 12:25:36', '2025-03-19 04:55:42'), (4, 'Fulan Bin Fulan', 'Direktur Keuangan', 'assets/images/team/67da4e5b81ea2.jpg', 'https://facebook.com', 'https://facebook.com', 'https://facebook.com', '2025-03-18 12:25:55', '2025-03-19 04:55:55'); -- -------------------------------------------------------- -- -- Struktur dari tabel `testimonials` -- CREATE TABLE `testimonials` ( `id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `customer_name` varchar(100) NOT NULL, `rating` int(11) NOT NULL, `review` text NOT NULL, `image` varchar(255) DEFAULT NULL, `status` enum('pending','approved','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `testimonials` -- INSERT INTO `testimonials` (`id`, `package_id`, `customer_name`, `rating`, `review`, `image`, `status`, `created_at`) VALUES (1, 1, 'Ahmad Syafiq', 5, 'Alhamdulillah, perjalanan umrah yang sangat berkesan. Pelayanan sangat memuaskan dan pembimbing sangat membantu.', NULL, 'approved', '2025-03-17 16:15:33'), (2, 1, 'Siti Aminah', 4, 'Pengalaman spiritual yang luar biasa. Hotel dekat dengan Masjidil Haram, sangat memudahkan untuk beribadah.', NULL, 'approved', '2025-03-17 16:15:33'), (3, 1, 'Muhammad Rizki', 5, 'Terima kasih Arbain Sani Travel. Semua diurus dengan profesional, dari keberangkatan sampai kepulangan.', NULL, 'approved', '2025-03-17 16:15:33'); -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','staff') NOT NULL DEFAULT 'staff', `name` varchar(100) NOT NULL, `email` varchar(100) DEFAULT NULL, `status` enum('active','inactive') NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `users` -- INSERT INTO `users` (`id`, `username`, `password`, `role`, `name`, `email`, `status`, `created_at`) VALUES (1, 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', 'Administrator', 'admin@arbainsani.com', 'active', '2025-03-18 06:06:10'), (2, 'staff', '$2y$10$EBBPPxIqbOJ3a7c4ix4FVupzcoonMjlP56sxcgg9G96lmKLc7J9NO', 'staff', '', 'staff@example.com', 'active', '2025-04-26 10:50:09'); -- -------------------------------------------------------- -- -- Struktur dari tabel `video_gallery` -- CREATE TABLE `video_gallery` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `video_id` varchar(100) NOT NULL, `duration` varchar(10) DEFAULT NULL, `date_recorded` date DEFAULT NULL, `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `video_gallery` -- INSERT INTO `video_gallery` (`id`, `title`, `description`, `video_id`, `duration`, `date_recorded`, `order_number`, `status`, `created_at`, `updated_at`) VALUES (1, 'Umroh Plus Dubai', 'Saksikan perjalanan spiritual jamaah kami mengunjungi tempat-tempat bersejarah Islam sambil menikmati keindahan modern Dubai.', '3tprx4h_dZU', '12:30', '2024-03-01', 1, 'active', '2025-04-26 05:19:28', '2025-04-26 05:19:28'), (2, 'Umroh Plus Turki', 'Perjalanan umroh dengan tambahan mengunjungi situs-situs bersejarah Islam di Turki.', '3tprx4h_dZU', '15:45', '2024-02-01', 2, 'active', '2025-04-26 05:19:28', '2025-04-26 05:19:28'), (3, 'Umroh Plus Mesir', 'Dokumentasi perjalanan umroh dengan tambahan mengunjungi peninggalan Islam di Mesir.', '3tprx4h_dZU', '10:20', '2024-01-01', 3, 'active', '2025-04-26 05:19:28', '2025-04-26 05:19:28'); -- -------------------------------------------------------- -- -- Struktur dari tabel `visitor_logs` -- CREATE TABLE `visitor_logs` ( `id` int(11) NOT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `visitor_logs` -- INSERT INTO `visitor_logs` (`id`, `ip_address`, `user_agent`, `path`, `session_id`, `created_at`) VALUES (1, '192.168.1.1', NULL, '/home', 'session123', '2025-04-26 00:32:38'), (2, '192.168.1.2', NULL, '/about', 'session456', '2025-04-26 00:32:38'), (3, '192.168.1.1', NULL, '/packages', 'session123', '2025-04-26 00:32:38'), (4, '192.168.1.1', NULL, '/home', 'session123', '2025-04-26 00:38:40'), (5, '192.168.1.2', NULL, '/about', 'session456', '2025-04-26 00:38:40'), (6, '192.168.1.1', NULL, '/packages', 'session123', '2025-04-26 00:38:40'), (7, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:05:52'), (8, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:05:57'), (9, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:06:06'), (10, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', '/arbainsani/index.php', 'h6p828635p8vrqk00c7u920aq7', '2025-04-27 00:06:17'); -- -------------------------------------------------------- -- -- Struktur dari tabel `why_choose_us` -- CREATE TABLE `why_choose_us` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `icon` varchar(100) NOT NULL, `order_number` int(11) NOT NULL DEFAULT 0, `status` enum('active','inactive') DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `why_choose_us` -- INSERT INTO `why_choose_us` (`id`, `title`, `description`, `icon`, `order_number`, `status`, `created_at`, `updated_at`) VALUES (1, 'Berizin Resmi & Profesional', 'Pemegang lisensi resmi dengan pengalaman bertahun-tahun dalam penyelenggaraan Umrah dan Haji', 'medal feature-icon', 1, 'active', '2025-04-26 04:05:02', '2025-04-26 04:36:37'), (2, 'Akomodasi Premium', 'Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci', 'hotel feature-icon', 2, 'active', '2025-04-26 04:05:02', '2025-04-26 04:36:47'), (3, 'Panduan Ahli', 'Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda', 'users feature-icon', 3, 'active', '2025-04-26 04:05:02', '2025-04-26 04:36:56'), (4, 'Dukungan 24/7', 'Bantuan dan layanan pelanggan tersedia setiap saat untuk semua kebutuhan Anda', 'headset feature-icon', 4, 'active', '2025-04-26 04:05:02', '2025-04-26 04:37:05'); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `access_logs` -- ALTER TABLE `access_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`), ADD KEY `idx_ip_address` (`ip_address`), ADD KEY `idx_path` (`path`), ADD KEY `idx_session_id` (`session_id`), ADD KEY `idx_status_code` (`status_code`); -- -- Indeks untuk tabel `backups` -- ALTER TABLE `backups` ADD PRIMARY KEY (`id`), ADD KEY `created_by` (`created_by`); -- -- Indeks untuk tabel `bookings` -- ALTER TABLE `bookings` ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`); -- -- Indeks untuk tabel `consultations` -- ALTER TABLE `consultations` ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `created_at` (`created_at`); -- -- Indeks untuk tabel `consultation_section` -- ALTER TABLE `consultation_section` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `contact_messages` -- ALTER TABLE `contact_messages` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `error_logs` -- ALTER TABLE `error_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`), ADD KEY `idx_path` (`path`); -- -- Indeks untuk tabel `features` -- ALTER TABLE `features` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `hotels` -- ALTER TABLE `hotels` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `itineraries` -- ALTER TABLE `itineraries` ADD PRIMARY KEY (`id`), ADD KEY `itineraries_ibfk_1` (`package_id`); -- -- Indeks untuk tabel `newsletter_campaigns` -- ALTER TABLE `newsletter_campaigns` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indeks untuk tabel `newsletter_tracking` -- ALTER TABLE `newsletter_tracking` ADD PRIMARY KEY (`id`), ADD KEY `campaign_id` (`campaign_id`), ADD KEY `subscriber_id` (`subscriber_id`); -- -- Indeks untuk tabel `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `package_bookings` -- ALTER TABLE `package_bookings` ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`); -- -- Indeks untuk tabel `package_hotels` -- ALTER TABLE `package_hotels` ADD PRIMARY KEY (`id`), ADD KEY `hotel_id` (`hotel_id`), ADD KEY `package_hotels_ibfk_1` (`package_id`); -- -- Indeks untuk tabel `partners_logos` -- ALTER TABLE `partners_logos` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `partners_section` -- ALTER TABLE `partners_section` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `performance_logs` -- ALTER TABLE `performance_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`), ADD KEY `idx_path` (`path`); -- -- Indeks untuk tabel `resource_usage_logs` -- ALTER TABLE `resource_usage_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`); -- -- Indeks untuk tabel `scheduled_tasks` -- ALTER TABLE `scheduled_tasks` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_setting` (`name`); -- -- Indeks untuk tabel `system_health_logs` -- ALTER TABLE `system_health_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`), ADD KEY `idx_check_type` (`check_type`), ADD KEY `idx_status` (`status`); -- -- Indeks untuk tabel `system_logs` -- ALTER TABLE `system_logs` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indeks untuk tabel `task_history` -- ALTER TABLE `task_history` ADD PRIMARY KEY (`id`), ADD KEY `task_id` (`task_id`); -- -- Indeks untuk tabel `team_members` -- ALTER TABLE `team_members` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`); -- -- Indeks untuk tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indeks untuk tabel `video_gallery` -- ALTER TABLE `video_gallery` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `visitor_logs` -- ALTER TABLE `visitor_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_created_at` (`created_at`), ADD KEY `idx_ip_address` (`ip_address`), ADD KEY `idx_path` (`path`), ADD KEY `idx_session_id` (`session_id`); -- -- Indeks untuk tabel `why_choose_us` -- ALTER TABLE `why_choose_us` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `access_logs` -- ALTER TABLE `access_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT untuk tabel `backups` -- ALTER TABLE `backups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT untuk tabel `bookings` -- ALTER TABLE `bookings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `consultations` -- ALTER TABLE `consultations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `consultation_section` -- ALTER TABLE `consultation_section` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `contact_messages` -- ALTER TABLE `contact_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `error_logs` -- ALTER TABLE `error_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `features` -- ALTER TABLE `features` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT untuk tabel `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT untuk tabel `hotels` -- ALTER TABLE `hotels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `itineraries` -- ALTER TABLE `itineraries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT untuk tabel `newsletter_campaigns` -- ALTER TABLE `newsletter_campaigns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT untuk tabel `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `newsletter_tracking` -- ALTER TABLE `newsletter_tracking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT untuk tabel `notifications` -- ALTER TABLE `notifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91; -- -- AUTO_INCREMENT untuk tabel `packages` -- ALTER TABLE `packages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `package_bookings` -- ALTER TABLE `package_bookings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT untuk tabel `package_hotels` -- ALTER TABLE `package_hotels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT untuk tabel `partners_logos` -- ALTER TABLE `partners_logos` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT untuk tabel `partners_section` -- ALTER TABLE `partners_section` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `performance_logs` -- ALTER TABLE `performance_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT untuk tabel `resource_usage_logs` -- ALTER TABLE `resource_usage_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `scheduled_tasks` -- ALTER TABLE `scheduled_tasks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=338; -- -- AUTO_INCREMENT untuk tabel `system_health_logs` -- ALTER TABLE `system_health_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT untuk tabel `system_logs` -- ALTER TABLE `system_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131; -- -- AUTO_INCREMENT untuk tabel `task_history` -- ALTER TABLE `task_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `team_members` -- ALTER TABLE `team_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT untuk tabel `video_gallery` -- ALTER TABLE `video_gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `visitor_logs` -- ALTER TABLE `visitor_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT untuk tabel `why_choose_us` -- ALTER TABLE `why_choose_us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `backups` -- ALTER TABLE `backups` ADD CONSTRAINT `backups_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Ketidakleluasaan untuk tabel `bookings` -- ALTER TABLE `bookings` ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `itineraries` -- ALTER TABLE `itineraries` ADD CONSTRAINT `itineraries_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `newsletter_tracking` -- ALTER TABLE `newsletter_tracking` ADD CONSTRAINT `fk_campaign` FOREIGN KEY (`campaign_id`) REFERENCES `newsletter_campaigns` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_subscriber` FOREIGN KEY (`subscriber_id`) REFERENCES `newsletter_subscribers` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `package_bookings` -- ALTER TABLE `package_bookings` ADD CONSTRAINT `package_bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `package_hotels` -- ALTER TABLE `package_hotels` ADD CONSTRAINT `package_hotels_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `package_hotels_ibfk_2` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `system_logs` -- ALTER TABLE `system_logs` ADD CONSTRAINT `system_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Ketidakleluasaan untuk tabel `task_history` -- ALTER TABLE `task_history` ADD CONSTRAINT `task_history_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `scheduled_tasks` (`id`) ON DELETE SET NULL; -- -- Ketidakleluasaan untuk tabel `testimonials` -- ALTER TABLE `testimonials` ADD CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`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 */;