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[<a06db29b04022dfb709f8299f0d9e891><a06db29b04022dfb709f8299f0d9e891>]
>>
startxref
1812
%%EOF

<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>128</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>129</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>130</b><br />
<br />
<b>Warning</b>:  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 <b>/home/u697396820/domains/smartriegroup.com/public_html/assets/images/partners/logo_69cec45839613.php</b> on line <b>131</b><br />
-- Database Backup
-- Generated: 2025-04-26 13:51:49

SET FOREIGN_KEY_CHECKS=0;



-- Table structure for table `access_logs`

DROP TABLE IF EXISTS `access_logs`;

CREATE TABLE `access_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_ip_address` (`ip_address`),
  KEY `idx_path` (`path`),
  KEY `idx_session_id` (`session_id`),
  KEY `idx_status_code` (`status_code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `access_logs`
INSERT INTO `access_logs` VALUES ('1','192.168.1.1',NULL,'/home','GET','200','150','session123','2025-04-26 07:38:40');
INSERT INTO `access_logs` VALUES ('2','192.168.1.2',NULL,'/about','GET','200','120','session456','2025-04-26 07:38:40');
INSERT INTO `access_logs` VALUES ('3','192.168.1.1',NULL,'/packages','GET','200','180','session123','2025-04-26 07:38:40');
INSERT INTO `access_logs` VALUES ('4','192.168.1.3',NULL,'/admin/login','POST','401','200','session789','2025-04-26 07:38:40');
INSERT INTO `access_logs` VALUES ('5','192.168.1.4',NULL,'/api/packages','GET','500','300','session101','2025-04-26 07:38:40');



-- Table structure for table `backups`

DROP TABLE IF EXISTS `backups`;

CREATE TABLE `backups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `backups_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Dumping data for table `backups`
INSERT INTO `backups` VALUES ('1','backup_2025-04-26_02-18-42.sql','1','2025-04-26 07:18:42');
INSERT INTO `backups` VALUES ('2','backup_2025-04-26_05-26-45.sql','1','2025-04-26 10:26:45');



-- Table structure for table `bookings`

DROP TABLE IF EXISTS `bookings`;

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`),
  CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- Table structure for table `contact_messages`

DROP TABLE IF EXISTS `contact_messages`;

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



-- Table structure for table `error_logs`

DROP TABLE IF EXISTS `error_logs`;

CREATE TABLE `error_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_path` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `error_logs`
INSERT INTO `error_logs` VALUES ('1','/admin/login','Invalid credentials','AUTH001',NULL,'2025-04-26 07:32:38');
INSERT INTO `error_logs` VALUES ('2','/api/packages','Database connection failed','DB001',NULL,'2025-04-26 07:32:38');
INSERT INTO `error_logs` VALUES ('3','/admin/login','Invalid credentials','AUTH001',NULL,'2025-04-26 07:38:40');
INSERT INTO `error_logs` VALUES ('4','/api/packages','Database connection failed','DB001',NULL,'2025-04-26 07:38:40');



-- Table structure for table `features`

DROP TABLE IF EXISTS `features`;

CREATE TABLE `features` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

-- Dumping data for table `features`
INSERT INTO `features` 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 11:31:22','2025-04-26 11:38:26');
INSERT INTO `features` VALUES ('2','Akomodasi Premium','Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci','hotel feature-icon','why_choose','2','active','2025-04-26 11:31:22','2025-04-26 11:38:32');
INSERT INTO `features` VALUES ('3','Panduan Ahli','Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda','users feature-icon','why_choose','3','active','2025-04-26 11:31:22','2025-04-26 11:38:37');
INSERT INTO `features` VALUES ('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 11:31:22','2025-04-26 11:38:39');
INSERT INTO `features` VALUES ('5','Berpengalaman','Lebih dari 10 tahun pengalaman dalam melayani jamaah umrah dan haji','medal','feature','1','active','2025-04-26 11:31:22','2025-04-26 11:31:22');
INSERT INTO `features` VALUES ('6','Pelayanan Prima','Memberikan pelayanan terbaik dengan pendampingan penuh selama perjalanan','hands-helping','feature','2','active','2025-04-26 11:31:22','2025-04-26 11:31:22');
INSERT INTO `features` VALUES ('7','Kepuasan Jamaah','Mengutamakan kenyamanan dan kepuasan jamaah dalam setiap perjalanan','heart','feature','3','active','2025-04-26 11:31:22','2025-04-26 11:31:22');
INSERT INTO `features` VALUES ('8','10+','Tahun Pengalaman','calendar-alt fa-2x','counter','1','active','2025-04-26 11:56:36','2025-04-26 11:56:43');
INSERT INTO `features` VALUES ('9','1000+','Jamaah Bahagia','users fa-2x','counter','2','active','2025-04-26 11:58:21','2025-04-26 11:58:27');
INSERT INTO `features` VALUES ('10','100+','Muthawiff','user-tie fa-2x','counter','3','active','2025-04-26 11:58:21','2025-04-26 11:58:30');
INSERT INTO `features` VALUES ('11','4.9','Skor Rating','star fa-2x','counter','4','active','2025-04-26 11:58:21','2025-04-26 11:58:32');



-- Table structure for table `gallery`

DROP TABLE IF EXISTS `gallery`;

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table `gallery`
INSERT INTO `gallery` VALUES ('1','assets/images/gallery/image1.jpg','Umrah Plus Turkye','','approved','2025-03-18 11:53:04','hajj');
INSERT INTO `gallery` VALUES ('2','assets/images/gallery/image2.jpg','Umrah Plus Turkye','','approved','2025-03-18 11:53:04','umrah');
INSERT INTO `gallery` VALUES ('3','assets/images/gallery/image3.jpg','Umrah Reguler','','approved','2025-03-18 11:53:04','halal-tour');



-- Table structure for table `hotels`

DROP TABLE IF EXISTS `hotels`;

CREATE TABLE `hotels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table `hotels`
INSERT INTO `hotels` 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 22:34:34','2025-03-17 22:34:34');
INSERT INTO `hotels` VALUES ('2','Le Meridien Madinah','Madinah, Saudi Arabia','5','Hotel bintang 5 dekat dengan Masjid Nabawi','assets/images/hotels/meridien-madinah.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `hotels` VALUES ('3','Movenpick Istanbul','Istanbul, Turki','5','Hotel mewah di pusat kota Istanbul','assets/images/hotels/movenpick-istanbul.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `hotels` VALUES ('4','Address Dubai Mall','Dubai, UAE','5','Hotel mewah terintegrasi dengan Dubai Mall','assets/images/hotels/address-dubai.jpg','2025-03-17 22:34:34','2025-03-17 22:34:34');



-- Table structure for table `itineraries`

DROP TABLE IF EXISTS `itineraries`;

CREATE TABLE `itineraries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `itineraries_ibfk_1` (`package_id`),
  CONSTRAINT `itineraries_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

-- Dumping data for table `itineraries`
INSERT INTO `itineraries` VALUES ('1','1','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Jeddah via Istanbul');
INSERT INTO `itineraries` VALUES ('2','1','2','Tiba di Istanbul','City tour Istanbul, mengunjungi Blue Mosque dan Hagia Sophia');
INSERT INTO `itineraries` VALUES ('3','1','3','Istanbul - Makkah','Penerbangan ke Jeddah, transfer ke Makkah, Umrah pertama');
INSERT INTO `itineraries` VALUES ('4','2','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah');
INSERT INTO `itineraries` VALUES ('5','2','2','Tiba di Makkah','Transfer ke hotel Makkah, Umrah pertama');
INSERT INTO `itineraries` VALUES ('6','3','1','Keberangkatan dari Jakarta','Berkumpul di Bandara Soekarno-Hatta, penerbangan ke Dubai');
INSERT INTO `itineraries` VALUES ('7','3','2','Dubai City Tour','Mengunjungi Burj Khalifa, Dubai Mall, dan Desert Safari');
INSERT INTO `itineraries` VALUES ('8','4','1','Keberangkatan Ramadhan','Berkumpul di Bandara Soekarno-Hatta, penerbangan langsung ke Jeddah');
INSERT INTO `itineraries` VALUES ('9','4','2','Ibadah di Masjidil Haram','Umrah pertama dan ibadah di Masjidil Haram');



-- Table structure for table `notifications`

DROP TABLE IF EXISTS `notifications`;

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

-- Dumping data for table `notifications`
INSERT INTO `notifications` VALUES ('1','1','system','System INFO','Error in package_functions.php:152 - New booking created: ID 2','0','2025-03-18 10:32:01');
INSERT INTO `notifications` VALUES ('2','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 2 for package ID 2','0','2025-03-18 10:32:01');
INSERT INTO `notifications` VALUES ('3','1','system','System INFO','Error in package_functions.php:187 - New booking created: ID 3','0','2025-03-18 10:32:25');
INSERT INTO `notifications` VALUES ('4','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 3 for package ID 2','0','2025-03-18 10:32:25');
INSERT INTO `notifications` VALUES ('5','1','system','System INFO','Error in package_functions.php:187 - New booking created: ID 5','0','2025-03-18 10:33:32');
INSERT INTO `notifications` VALUES ('6','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 5 for package ID 2','0','2025-03-18 10:33:32');
INSERT INTO `notifications` VALUES ('7','1','system','System INFO','Error in package-details.php:60 - New booking created: ID 7 for package ID 2','0','2025-03-18 10:35:36');
INSERT INTO `notifications` VALUES ('8','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:29:48');
INSERT INTO `notifications` VALUES ('9','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:29:48');
INSERT INTO `notifications` VALUES ('10','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:29:48');
INSERT INTO `notifications` VALUES ('11','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:02');
INSERT INTO `notifications` VALUES ('12','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:02');
INSERT INTO `notifications` VALUES ('13','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:31:02');
INSERT INTO `notifications` VALUES ('14','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:03');
INSERT INTO `notifications` VALUES ('15','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:31:03');
INSERT INTO `notifications` VALUES ('16','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:31:03');
INSERT INTO `notifications` VALUES ('17','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:32:43');
INSERT INTO `notifications` VALUES ('18','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:32:43');
INSERT INTO `notifications` VALUES ('19','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:32:43');
INSERT INTO `notifications` VALUES ('20','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:18');
INSERT INTO `notifications` VALUES ('21','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:18');
INSERT INTO `notifications` VALUES ('22','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:18');
INSERT INTO `notifications` VALUES ('23','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('24','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('25','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('26','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('27','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('28','1','system','System CRITICAL','Error in system_monitor.php:269 - System health issue: Disk usage is above 90%','0','2025-04-26 07:33:21');
INSERT INTO `notifications` VALUES ('29','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:17');
INSERT INTO `notifications` VALUES ('30','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:17');
INSERT INTO `notifications` VALUES ('31','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:17');
INSERT INTO `notifications` VALUES ('32','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('33','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('34','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('35','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('36','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('37','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('38','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('39','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('40','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:18');
INSERT INTO `notifications` VALUES ('41','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('42','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('43','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('44','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('45','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('46','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('47','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('48','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('49','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:35:19');
INSERT INTO `notifications` VALUES ('50','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:36:56');
INSERT INTO `notifications` VALUES ('51','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:36:56');
INSERT INTO `notifications` VALUES ('52','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:36:56');
INSERT INTO `notifications` VALUES ('53','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:38:45');
INSERT INTO `notifications` VALUES ('54','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:38:45');
INSERT INTO `notifications` VALUES ('55','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:38:45');
INSERT INTO `notifications` VALUES ('56','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:19');
INSERT INTO `notifications` VALUES ('57','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:19');
INSERT INTO `notifications` VALUES ('58','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:40:19');
INSERT INTO `notifications` VALUES ('59','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:42');
INSERT INTO `notifications` VALUES ('60','1','system','System INFO','Error in system_monitor.php:32 - System status check completed','0','2025-04-26 07:40:42');
INSERT INTO `notifications` VALUES ('61','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:40:42');
INSERT INTO `notifications` VALUES ('62','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:41:31');
INSERT INTO `notifications` VALUES ('63','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:43:49');
INSERT INTO `notifications` VALUES ('64','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:04');
INSERT INTO `notifications` VALUES ('65','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:06');
INSERT INTO `notifications` VALUES ('66','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 07:46:47');
INSERT INTO `notifications` VALUES ('67','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 08:10:05');
INSERT INTO `notifications` VALUES ('68','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 10:26:54');
INSERT INTO `notifications` VALUES ('69','1','system','System CRITICAL','Error in system_monitor.php:268 - System health issue: Disk usage is above 90%','0','2025-04-26 11:24:46');
INSERT INTO `notifications` VALUES ('70','1','system','Maintenance Mode Update','Website maintenance mode has been disabled by admin','0','2025-04-26 18:41:18');
INSERT INTO `notifications` VALUES ('71','1','system','Maintenance Mode Update','Website maintenance mode has been enabled by admin','0','2025-04-26 18:41:20');
INSERT INTO `notifications` VALUES ('72','1','system','Maintenance Mode Update','Website maintenance mode has been disabled by admin','0','2025-04-26 18:41:20');
INSERT INTO `notifications` VALUES ('73','1','system','Maintenance Mode Update','Website maintenance mode has been enabled by admin','0','2025-04-26 18:41:21');



-- Table structure for table `package_bookings`

DROP TABLE IF EXISTS `package_bookings`;

CREATE TABLE `package_bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`),
  CONSTRAINT `package_bookings_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;



-- Table structure for table `package_hotels`

DROP TABLE IF EXISTS `package_hotels`;

CREATE TABLE `package_hotels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `nights` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_id` (`hotel_id`),
  KEY `package_hotels_ibfk_1` (`package_id`),
  CONSTRAINT `package_hotels_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `package_hotels_ibfk_2` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

-- Dumping data for table `package_hotels`
INSERT INTO `package_hotels` VALUES ('4','2','1','5');
INSERT INTO `package_hotels` VALUES ('5','2','2','5');
INSERT INTO `package_hotels` VALUES ('6','3','1','5');
INSERT INTO `package_hotels` VALUES ('7','3','2','4');
INSERT INTO `package_hotels` VALUES ('8','3','4','4');
INSERT INTO `package_hotels` VALUES ('9','4','1','8');
INSERT INTO `package_hotels` VALUES ('10','4','2','7');
INSERT INTO `package_hotels` VALUES ('14','1','1','5');
INSERT INTO `package_hotels` VALUES ('15','1','2','4');
INSERT INTO `package_hotels` VALUES ('16','1','3','3');



-- Table structure for table `packages`

DROP TABLE IF EXISTS `packages`;

CREATE TABLE `packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table `packages`
INSERT INTO `packages` 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 22:34:34','2025-04-26 10:59:37','3','Hotel Bintang 4,Makan 3x Sehari,Guide Lokal,Tiket Wisata,Transport AC','4.1','83','1','Jakarta','40','13','Garuda Indonesia');
INSERT INTO `packages` VALUES ('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 22:34:34','2025-04-26 10:55:00','5','Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik','4.5','91','0','Jakarta','40','27','Garuda Indonesia');
INSERT INTO `packages` VALUES ('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 22:34:34','2025-04-26 10: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');
INSERT INTO `packages` VALUES ('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 22:34:34','2025-04-26 10:55:13','5','Perlengkapan Umroh,Handling,Pembimbing Berpengalaman,Manasik,Ziarah, Tiket Domestik, Ziarah','4.5','17','1','Jakarta','40','17','Emirates');



-- Table structure for table `partners_logos`

DROP TABLE IF EXISTS `partners_logos`;

CREATE TABLE `partners_logos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) NOT NULL,
  `alt_text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Dumping data for table `partners_logos`
INSERT INTO `partners_logos` VALUES ('1','assets/images/partners/iata.png','IATA');
INSERT INTO `partners_logos` VALUES ('2','assets/images/partners/amphuri.png','AMPHURI');
INSERT INTO `partners_logos` VALUES ('3','assets/images/partners/kan.png','KAN');
INSERT INTO `partners_logos` VALUES ('4','assets/images/partners/kemenag.png','Kemenag');
INSERT INTO `partners_logos` VALUES ('5','assets/images/partners/siskopatuh.png','SikoPatuh');



-- Table structure for table `partners_section`

DROP TABLE IF EXISTS `partners_section`;

CREATE TABLE `partners_section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table `partners_section`
INSERT INTO `partners_section` 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');



-- Table structure for table `performance_logs`

DROP TABLE IF EXISTS `performance_logs`;

CREATE TABLE `performance_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_path` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `performance_logs`
INSERT INTO `performance_logs` VALUES ('1','/home','150','1048576','2025-04-26 07:32:38');
INSERT INTO `performance_logs` VALUES ('2','/about','120','1048576','2025-04-26 07:32:38');
INSERT INTO `performance_logs` VALUES ('3','/packages','180','2097152','2025-04-26 07:32:38');
INSERT INTO `performance_logs` VALUES ('4','/contact','100','1048576','2025-04-26 07:32:38');
INSERT INTO `performance_logs` VALUES ('5','/home','150','1048576','2025-04-26 07:38:40');
INSERT INTO `performance_logs` VALUES ('6','/about','120','1048576','2025-04-26 07:38:40');
INSERT INTO `performance_logs` VALUES ('7','/packages','180','2097152','2025-04-26 07:38:40');
INSERT INTO `performance_logs` VALUES ('8','/contact','100','1048576','2025-04-26 07:38:40');



-- Table structure for table `resource_usage_logs`

DROP TABLE IF EXISTS `resource_usage_logs`;

CREATE TABLE `resource_usage_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `resource_usage_logs`
INSERT INTO `resource_usage_logs` VALUES ('1','65.50','70.20','45.30','2025-04-26 07:32:38');
INSERT INTO `resource_usage_logs` VALUES ('2','66.10','71.50','48.70','2025-04-26 07:32:38');
INSERT INTO `resource_usage_logs` VALUES ('3','65.50','70.20','45.30','2025-04-26 07:38:40');
INSERT INTO `resource_usage_logs` VALUES ('4','66.10','71.50','48.70','2025-04-26 07:38:40');



-- Table structure for table `scheduled_tasks`

DROP TABLE IF EXISTS `scheduled_tasks`;

CREATE TABLE `scheduled_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `scheduled_tasks`
INSERT INTO `scheduled_tasks` VALUES ('1','Database Backup','Create a backup of the database','daily',NULL,'2025-04-27 07:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56');
INSERT INTO `scheduled_tasks` VALUES ('2','Clean Old Logs','Remove logs older than 30 days','weekly',NULL,'2025-05-03 07:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56');
INSERT INTO `scheduled_tasks` VALUES ('3','Update Statistics','Update system statistics and analytics','hourly',NULL,'2025-04-26 08:22:56','1','2025-04-26 07:22:56','2025-04-26 07:22:56');



-- Table structure for table `settings`

DROP TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_setting` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=latin1;

-- Dumping data for table `settings`
INSERT INTO `settings` VALUES ('1','company_name','Awwaliyah Travel','2025-03-17 22:34:34','2025-03-19 18:18:25');
INSERT INTO `settings` VALUES ('2','company_email','info@code80vity.com','2025-03-17 22:34:34','2025-04-26 12:30:52');
INSERT INTO `settings` VALUES ('3','company_phone','082279107372','2025-03-17 22:34:34','2025-03-19 14:50:35');
INSERT INTO `settings` VALUES ('4','company_address','Samping Carefour Cibinong, Jl. Raya Bogor, Ciriung, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16918','2025-03-17 22:34:34','2025-03-19 18:18:25');
INSERT INTO `settings` VALUES ('5','maintenance_mode','1','2025-03-17 22:34:34','2025-04-26 18:41:21');
INSERT INTO `settings` VALUES ('6','booking_reminder_days','7','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('7','payment_reminder_days','3','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('8','document_reminder_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('9','backup_retention_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('10','log_retention_days','30','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('11','smtp_host','mail.code80vity.com','2025-03-17 22:34:34','2025-04-26 12:36:49');
INSERT INTO `settings` VALUES ('12','smtp_port','587','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('13','smtp_user','admin@code80vity.com','2025-03-17 22:34:34','2025-04-26 12:37:08');
INSERT INTO `settings` VALUES ('14','smtp_pass','code80vity','2025-03-17 22:34:34','2025-04-26 12:37:10');
INSERT INTO `settings` VALUES ('15','mailchimp_list_id','your-list-id','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('16','stripe_webhook_secret','your-webhook-secret','2025-03-17 22:34:34','2025-03-17 22:34:34');
INSERT INTO `settings` VALUES ('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 19:44:03','2025-03-18 19:51:22');
INSERT INTO `settings` VALUES ('18','primary_color','#04b942','2025-03-18 19:44:36','2025-04-25 19:14:21');
INSERT INTO `settings` VALUES ('19','secondary_color','#ffffff','2025-03-18 19:44:36','2025-04-25 19:32:19');
INSERT INTO `settings` VALUES ('20','accent_color','#616161','2025-03-18 19:44:45','2025-04-25 19:37:40');
INSERT INTO `settings` VALUES ('21','site_logo','assets/images/logo.png','2025-03-18 19:46:34','2025-04-25 19:16:30');
INSERT INTO `settings` VALUES ('30','facebook_url','https://facebook.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22');
INSERT INTO `settings` VALUES ('31','twitter_url','https://x.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22');
INSERT INTO `settings` VALUES ('32','instagram_url','https://instagram.com/code80vity','2025-03-18 19:51:22','2025-03-18 19:51:22');
INSERT INTO `settings` VALUES ('33','whatsapp_number','082279107372','2025-03-18 19:51:22','2025-03-18 19:51:22');
INSERT INTO `settings` VALUES ('55','gradient_style','none','2025-03-19 11:29:27','2025-03-19 11:37:00');
INSERT INTO `settings` VALUES ('56','gradient_start_color','#bf953f','2025-03-19 11:29:27','2025-03-19 11:29:27');
INSERT INTO `settings` VALUES ('57','gradient_end_color','#fcf6ba','2025-03-19 11:29:27','2025-03-19 11:29:27');
INSERT INTO `settings` VALUES ('58','gradient_direction','to right','2025-03-19 11:29:27','2025-03-19 11:37:00');
INSERT INTO `settings` VALUES ('87','light_color','#f8f9fa','2025-03-19 11:36:20','2025-03-19 11:36:20');
INSERT INTO `settings` VALUES ('88','dark_color','#1a1f3c','2025-03-19 11:36:20','2025-03-19 11:36:20');
INSERT INTO `settings` VALUES ('311','maintenance_message','We are currently performing maintenance. Please check back later.','2025-04-26 18:41:18','2025-04-26 18:41:18');
INSERT INTO `settings` VALUES ('318','maintenance_allowed_ips','::1','2025-04-26 18:42:46','2025-04-26 18:43:40');



-- Table structure for table `system_health_logs`

DROP TABLE IF EXISTS `system_health_logs`;

CREATE TABLE `system_health_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_check_type` (`check_type`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `system_health_logs`
INSERT INTO `system_health_logs` VALUES ('1','disk','healthy','Disk usage is within normal limits',NULL,'2025-04-26 07:32:38');
INSERT INTO `system_health_logs` VALUES ('2','memory','warning','Memory usage is approaching limit',NULL,'2025-04-26 07:32:38');
INSERT INTO `system_health_logs` VALUES ('3','database','healthy','Database connection is stable',NULL,'2025-04-26 07:32:38');
INSERT INTO `system_health_logs` VALUES ('4','disk','healthy','Disk usage is within normal limits',NULL,'2025-04-26 07:38:40');
INSERT INTO `system_health_logs` VALUES ('5','memory','warning','Memory usage is approaching limit',NULL,'2025-04-26 07:38:40');
INSERT INTO `system_health_logs` VALUES ('6','database','healthy','Database connection is stable',NULL,'2025-04-26 07:38:40');



-- Table structure for table `system_logs`

DROP TABLE IF EXISTS `system_logs`;

CREATE TABLE `system_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `system_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=latin1;

-- Dumping data for table `system_logs`
INSERT INTO `system_logs` VALUES ('4','auth','User admin logged in successfully','info','1','2025-03-18 13:10:21');
INSERT INTO `system_logs` VALUES ('5','settings','Added new team member: Meyki Ardiansyah','info','1','2025-03-18 19:24:17');
INSERT INTO `system_logs` VALUES ('6','settings','Updated team member: Nanda Iskandar','info','1','2025-03-18 19:24:36');
INSERT INTO `system_logs` VALUES ('7','settings','Added new team member: Niko Adi Saputra','info','1','2025-03-18 19:25:02');
INSERT INTO `system_logs` VALUES ('8','settings','Added new team member: Besti Neliza Lubis','info','1','2025-03-18 19:25:36');
INSERT INTO `system_logs` VALUES ('9','settings','Added new team member: Esanda Audria','info','1','2025-03-18 19:25:55');
INSERT INTO `system_logs` VALUES ('10','settings','Updated general settings','info','1','2025-03-18 19:51:22');
INSERT INTO `system_logs` VALUES ('11','settings','Updated general settings','info','1','2025-03-18 20:20:24');
INSERT INTO `system_logs` VALUES ('12','packages','Package updated: Promo Khusus Umpast','info','1','2025-03-19 11:04:51');
INSERT INTO `system_logs` VALUES ('13','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:06:04');
INSERT INTO `system_logs` VALUES ('14','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:07:13');
INSERT INTO `system_logs` VALUES ('15','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:07:47');
INSERT INTO `system_logs` VALUES ('16','packages','Package updated: Promo Khusus Umpast','info','1','2025-03-19 11:12:42');
INSERT INTO `system_logs` VALUES ('17','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:14:08');
INSERT INTO `system_logs` VALUES ('18','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:16:04');
INSERT INTO `system_logs` VALUES ('19','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:16:46');
INSERT INTO `system_logs` VALUES ('20','packages','Package updated: Gebyar Umroh Spesial Milad','info','1','2025-03-19 11:17:26');
INSERT INTO `system_logs` VALUES ('21','packages','Package updated: Paket Umrah Mabrur','info','1','2025-03-19 11:17:32');
INSERT INTO `system_logs` VALUES ('22','packages','Package updated: Paket Umrah Samawa','info','1','2025-03-19 11:17:39');
INSERT INTO `system_logs` VALUES ('23','settings','Updated general settings','info','1','2025-03-19 11:29:27');
INSERT INTO `system_logs` VALUES ('24','settings','Updated general settings','info','1','2025-03-19 11:29:46');
INSERT INTO `system_logs` VALUES ('25','settings','Updated general settings','info','1','2025-03-19 11:36:20');
INSERT INTO `system_logs` VALUES ('26','settings','Updated general settings','info','1','2025-03-19 11:37:00');
INSERT INTO `system_logs` VALUES ('27','settings','Updated general settings','info','1','2025-03-19 11:43:57');
INSERT INTO `system_logs` VALUES ('28','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:21');
INSERT INTO `system_logs` VALUES ('29','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:33');
INSERT INTO `system_logs` VALUES ('30','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:42');
INSERT INTO `system_logs` VALUES ('31','settings','Updated team member: Fulan Bin Fulan','info','1','2025-03-19 11:55:55');
INSERT INTO `system_logs` VALUES ('32','settings','Updated general settings','info','1','2025-03-19 18:16:50');
INSERT INTO `system_logs` VALUES ('33','settings','Updated general settings','info','1','2025-03-19 18:17:07');
INSERT INTO `system_logs` VALUES ('34','settings','Updated general settings','info','1','2025-03-19 18:17:42');
INSERT INTO `system_logs` VALUES ('35','settings','Updated general settings','info','1','2025-03-19 18:18:25');
INSERT INTO `system_logs` VALUES ('36','packages','Package updated: Paket Umroh Syawal','info','1','2025-03-19 18:49:11');
INSERT INTO `system_logs` VALUES ('37','packages','Package updated: Paket Umroh Syawal','info','1','2025-03-19 18:49:17');
INSERT INTO `system_logs` VALUES ('38','packages','Package updated: Paket Umroh Ramadhan 1446H','info','1','2025-03-19 18:50:08');
INSERT INTO `system_logs` VALUES ('39','packages','Package updated: Promo Umroh Lancar Ibadah Khusus','info','1','2025-03-19 18:50:59');
INSERT INTO `system_logs` VALUES ('40','packages','Package updated: Promo Umroh Haji Ramdhan','info','1','2025-03-19 18:51:54');
INSERT INTO `system_logs` VALUES ('41','settings','Updated general settings','info','1','2025-03-19 19:04:20');
INSERT INTO `system_logs` VALUES ('47','auth','User admin logged in successfully','info','1','2025-04-25 19:10:03');
INSERT INTO `system_logs` VALUES ('48','settings','Updated general settings','info','1','2025-04-25 19:10:37');
INSERT INTO `system_logs` VALUES ('49','settings','Updated general settings','info','1','2025-04-25 19:12:45');
INSERT INTO `system_logs` VALUES ('50','settings','Updated general settings','info','1','2025-04-25 19:14:21');
INSERT INTO `system_logs` VALUES ('51','settings','Updated general settings','info','1','2025-04-25 19:32:19');
INSERT INTO `system_logs` VALUES ('52','settings','Updated general settings','info','1','2025-04-25 19:32:58');
INSERT INTO `system_logs` VALUES ('53','settings','Updated general settings','info','1','2025-04-25 19:37:40');
INSERT INTO `system_logs` VALUES ('54','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:24');
INSERT INTO `system_logs` VALUES ('55','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:57');
INSERT INTO `system_logs` VALUES ('56','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:49:58');
INSERT INTO `system_logs` VALUES ('57','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:00');
INSERT INTO `system_logs` VALUES ('58','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:07');
INSERT INTO `system_logs` VALUES ('59','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:32');
INSERT INTO `system_logs` VALUES ('60','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:33');
INSERT INTO `system_logs` VALUES ('61','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:33');
INSERT INTO `system_logs` VALUES ('62','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:34');
INSERT INTO `system_logs` VALUES ('63','bookings','Error fetching bookings: Table \\\'arbainsani_db.bookings\\\' doesn\\\'t exist','error',NULL,'2025-04-25 20:50:35');
INSERT INTO `system_logs` VALUES ('64','database','Bookings table created','info',NULL,'2025-04-25 20:59:15');
INSERT INTO `system_logs` VALUES ('65','bookings','Booking updated: ID 0','info',NULL,'2025-04-25 21:00:49');
INSERT INTO `system_logs` VALUES ('66','bookings','Booking updated: ID 0','info',NULL,'2025-04-25 21:00:55');
INSERT INTO `system_logs` VALUES ('67','backup','Created new database backup','info',NULL,'2025-04-26 07:18:42');
INSERT INTO `system_logs` VALUES ('68','backup','Created new database backup','info',NULL,'2025-04-26 10:26:45');
INSERT INTO `system_logs` VALUES ('69','packages','Package updated: Paket Umroh Syawal','info',NULL,'2025-04-26 10:59:30');
INSERT INTO `system_logs` VALUES ('70','packages','Package updated: Paket Umroh Syawals','info',NULL,'2025-04-26 10:59:37');
INSERT INTO `system_logs` VALUES ('71','why_choose_us','Item updated: Berizin Resmi & Profesional','info',NULL,'2025-04-26 11:21:53');
INSERT INTO `system_logs` VALUES ('72','users','New user created: staff','info',NULL,'2025-04-26 17:50:09');
INSERT INTO `system_logs` VALUES ('73','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:15');
INSERT INTO `system_logs` VALUES ('74','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:21');
INSERT INTO `system_logs` VALUES ('75','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:23');
INSERT INTO `system_logs` VALUES ('76','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:04:23');
INSERT INTO `system_logs` VALUES ('77','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:05:38');
INSERT INTO `system_logs` VALUES ('78','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:04');
INSERT INTO `system_logs` VALUES ('79','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07');
INSERT INTO `system_logs` VALUES ('80','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07');
INSERT INTO `system_logs` VALUES ('81','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07');
INSERT INTO `system_logs` VALUES ('82','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:07');
INSERT INTO `system_logs` VALUES ('83','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:18');
INSERT INTO `system_logs` VALUES ('84','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:44');
INSERT INTO `system_logs` VALUES ('85','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:48');
INSERT INTO `system_logs` VALUES ('86','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:06:50');
INSERT INTO `system_logs` VALUES ('87','bookings','Booking updated: ID 2','info',NULL,'2025-04-26 18:07:43');
INSERT INTO `system_logs` VALUES ('88','bookings','Booking updated: ID 11','info',NULL,'2025-04-26 18:07:47');
INSERT INTO `system_logs` VALUES ('89','bookings','Booking updated: ID 11','info',NULL,'2025-04-26 18:07:51');
INSERT INTO `system_logs` VALUES ('90','bookings','Booking deleted: ID 11','warning',NULL,'2025-04-26 18:07:56');
INSERT INTO `system_logs` VALUES ('91','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:19:35');
INSERT INTO `system_logs` VALUES ('92','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:19:39');
INSERT INTO `system_logs` VALUES ('93','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:21:46');
INSERT INTO `system_logs` VALUES ('94','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:01');
INSERT INTO `system_logs` VALUES ('95','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:11');
INSERT INTO `system_logs` VALUES ('96','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:11');
INSERT INTO `system_logs` VALUES ('97','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:21');
INSERT INTO `system_logs` VALUES ('98','testimonials','Testimonial updated: ID 1','info',NULL,'2025-04-26 18:22:26');
INSERT INTO `system_logs` VALUES ('99','features','New item added: 123','info',NULL,'2025-04-26 18:23:48');
INSERT INTO `system_logs` VALUES ('100','features','New item added: 324','info',NULL,'2025-04-26 18:24:12');
INSERT INTO `system_logs` VALUES ('101','features','New item added: 3453','info',NULL,'2025-04-26 18:24:21');
INSERT INTO `system_logs` VALUES ('102','features','Item updated: 324','info',NULL,'2025-04-26 18:24:50');
INSERT INTO `system_logs` VALUES ('103','features','Item deleted: ID 13','warning',NULL,'2025-04-26 18:25:40');
INSERT INTO `system_logs` VALUES ('104','features','Item deleted: ID 12','warning',NULL,'2025-04-26 18:25:44');
INSERT INTO `system_logs` VALUES ('105','features','Item deleted: ID 14','warning',NULL,'2025-04-26 18:25:47');
INSERT INTO `system_logs` VALUES ('106','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:31:55');
INSERT INTO `system_logs` VALUES ('107','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:32:24');
INSERT INTO `system_logs` VALUES ('108','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:32:59');
INSERT INTO `system_logs` VALUES ('109','users','User updated: ID 2','info',NULL,'2025-04-26 18:33:50');
INSERT INTO `system_logs` VALUES ('110','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:33:53');
INSERT INTO `system_logs` VALUES ('111','users','User details viewed: ID 1','info',NULL,'2025-04-26 18:34:02');
INSERT INTO `system_logs` VALUES ('112','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:13');
INSERT INTO `system_logs` VALUES ('113','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:34:14');
INSERT INTO `system_logs` VALUES ('114','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:16');
INSERT INTO `system_logs` VALUES ('115','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:34:18');
INSERT INTO `system_logs` VALUES ('116','users','User updated: ID 2','info',NULL,'2025-04-26 18:34:20');
INSERT INTO `system_logs` VALUES ('117','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:16');
INSERT INTO `system_logs` VALUES ('118','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:36');
INSERT INTO `system_logs` VALUES ('119','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:36:37');
INSERT INTO `system_logs` VALUES ('120','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:39');
INSERT INTO `system_logs` VALUES ('121','users','User details viewed: ID 2','info',NULL,'2025-04-26 18:36:41');
INSERT INTO `system_logs` VALUES ('122','users','User updated: ID 2','info',NULL,'2025-04-26 18:36:44');
INSERT INTO `system_logs` VALUES ('123','auth','Failed login attempt for username: admin','warning',NULL,'2025-04-26 18:48:09');
INSERT INTO `system_logs` VALUES ('124','auth','Failed login attempt for username: admin','warning',NULL,'2025-04-26 18:48:13');
INSERT INTO `system_logs` VALUES ('125','auth','User admin logged in successfully','info',NULL,'2025-04-26 18:48:19');



-- Table structure for table `task_history`

DROP TABLE IF EXISTS `task_history`;

CREATE TABLE `task_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  CONSTRAINT `task_history_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `scheduled_tasks` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



-- Table structure for table `team_members`

DROP TABLE IF EXISTS `team_members`;

CREATE TABLE `team_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table `team_members`
INSERT INTO `team_members` VALUES ('1','Fulan Bin Fulan','Komisaris Utama','assets/images/team/67da4e391c925.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:24:17','2025-03-19 11:55:21');
INSERT INTO `team_members` VALUES ('2','Fulan Bin Fulan','Direktur Utama','assets/images/team/67da4e45bdfba.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:02','2025-03-19 11:55:33');
INSERT INTO `team_members` VALUES ('3','Fulan Bin Fulan','Direktur Pemasaran','assets/images/team/67da4e4ee0459.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:36','2025-03-19 11:55:42');
INSERT INTO `team_members` VALUES ('4','Fulan Bin Fulan','Direktur Keuangan','assets/images/team/67da4e5b81ea2.jpg','https://facebook.com','https://facebook.com','https://facebook.com','2025-03-18 19:25:55','2025-03-19 11:55:55');



-- Table structure for table `testimonials`

DROP TABLE IF EXISTS `testimonials`;

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`),
  CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Dumping data for table `testimonials`
INSERT INTO `testimonials` VALUES ('1','1','Ahmad Syafiq','5','Alhamdulillah, perjalanan umrah yang sangat berkesan. Pelayanan sangat memuaskan dan pembimbing sangat membantu.',NULL,'approved','2025-03-17 23:15:33');
INSERT INTO `testimonials` VALUES ('2','1','Siti Aminah','4','Pengalaman spiritual yang luar biasa. Hotel dekat dengan Masjidil Haram, sangat memudahkan untuk beribadah.',NULL,'approved','2025-03-17 23:15:33');
INSERT INTO `testimonials` VALUES ('3','1','Muhammad Rizki','5','Terima kasih Arbain Sani Travel. Semua diurus dengan profesional, dari keberangkatan sampai kepulangan.',NULL,'approved','2025-03-17 23:15:33');



-- Table structure for table `users`

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Dumping data for table `users`
INSERT INTO `users` VALUES ('1','admin','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','admin','Administrator','admin@arbainsani.com','active','2025-03-18 13:06:10');
INSERT INTO `users` VALUES ('2','staff','$2y$10$EBBPPxIqbOJ3a7c4ix4FVupzcoonMjlP56sxcgg9G96lmKLc7J9NO','staff','','staff@example.com','active','2025-04-26 17:50:09');



-- Table structure for table `video_gallery`

DROP TABLE IF EXISTS `video_gallery`;

CREATE TABLE `video_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Dumping data for table `video_gallery`
INSERT INTO `video_gallery` 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 12:19:28','2025-04-26 12:19:28');
INSERT INTO `video_gallery` VALUES ('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 12:19:28','2025-04-26 12:19:28');
INSERT INTO `video_gallery` VALUES ('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 12:19:28','2025-04-26 12:19:28');



-- Table structure for table `visitor_logs`

DROP TABLE IF EXISTS `visitor_logs`;

CREATE TABLE `visitor_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_ip_address` (`ip_address`),
  KEY `idx_path` (`path`),
  KEY `idx_session_id` (`session_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `visitor_logs`
INSERT INTO `visitor_logs` VALUES ('1','192.168.1.1',NULL,'/home','session123','2025-04-26 07:32:38');
INSERT INTO `visitor_logs` VALUES ('2','192.168.1.2',NULL,'/about','session456','2025-04-26 07:32:38');
INSERT INTO `visitor_logs` VALUES ('3','192.168.1.1',NULL,'/packages','session123','2025-04-26 07:32:38');
INSERT INTO `visitor_logs` VALUES ('4','192.168.1.1',NULL,'/home','session123','2025-04-26 07:38:40');
INSERT INTO `visitor_logs` VALUES ('5','192.168.1.2',NULL,'/about','session456','2025-04-26 07:38:40');
INSERT INTO `visitor_logs` VALUES ('6','192.168.1.1',NULL,'/packages','session123','2025-04-26 07:38:40');



-- Table structure for table `why_choose_us`

DROP TABLE IF EXISTS `why_choose_us`;

CREATE TABLE `why_choose_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table `why_choose_us`
INSERT INTO `why_choose_us` 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 11:05:02','2025-04-26 11:36:37');
INSERT INTO `why_choose_us` VALUES ('2','Akomodasi Premium','Menginap di hotel nyaman yang berlokasi strategis dekat dengan tempat suci','hotel feature-icon','2','active','2025-04-26 11:05:02','2025-04-26 11:36:47');
INSERT INTO `why_choose_us` VALUES ('3','Panduan Ahli','Didampingi oleh ulama dan pembimbing berpengalaman selama perjalanan Anda','users feature-icon','3','active','2025-04-26 11:05:02','2025-04-26 11:36:56');
INSERT INTO `why_choose_us` VALUES ('4','Dukungan 24/7','Bantuan dan layanan pelanggan tersedia setiap saat untuk semua kebutuhan Anda','headset feature-icon','4','active','2025-04-26 11:05:02','2025-04-26 11:37:05');


SET FOREIGN_KEY_CHECKS=1;