--
-- Host: localhost    Database: flystarcourier_db
-- ------------------------------------------------------


--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `extra_title` varchar(255) DEFAULT NULL,
  `extra_content` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `button1_text` varchar(100) DEFAULT NULL,
  `button1_url` varchar(255) DEFAULT NULL,
  `button2_text` varchar(100) DEFAULT NULL,
  `button2_url` varchar(255) DEFAULT NULL,
  `json_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_name` (`page_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` VALUES (1,'our_profile','Our Profile','Welcome to FlyStar Services','FlyStar services are the leading International postage services operated in Hyderabad with a good domestic and international network. We are glad to mention that our services are best leading in position within the present market. We provide vast vary of services globally that features overnight delivery to decisive international destinations still as domestic destinations. We offer worldwide courier services with quick air freight in company with distinctive gift delivery services in selected areas. With the name we have a tendency to attained within the courier service retail, we have a tendency to are proud to announce ourselves as a one stop destination for international courier services business inside no time we have a tendency to recognized as worldwide express courier. FlyStar services head quartered at Hyderabad with its specific centres placed across Republic of India. We have a tendency to produce quickest connections to the remainder of the globe through a variety of cargo selections that suits the wants of the consumer. We\'ve robust moral principles with that we have a tendency to worth our customers and their satisfaction is our high priority after we are providing our quality services. We have a tendency to additionally partner with varied services to maximise our reach.',NULL,NULL,'2026-06-29 18:36:12','2026-06-30 11:36:06','our services','','contact us','','{\"stats\":[{\"number\":\"15+\",\"label\":\"Years Experience\"},{\"number\":\"220+\",\"label\":\"Countries\"},{\"number\":\"5M+\",\"label\":\"Parcels Delivered\"},{\"number\":\"50+\",\"label\":\"Global Partners\"}]}'),(2,'why_flystar','Why FlyStar','Why Choose FlyStar Services?','FlyStar Services has been a pioneer in global logistics, offering unmatched speed, security, and cost-effective shipping solutions. We leverage advanced tracking, custom clearance assistance, and a dedicated support team to ensure your parcel reaches its destination safely and on time. Whether you are shipping documents, commercial cargo, or personal items, we tailor our courier services to meet your specific requirements. We guarantee transparent pricing, secure packaging, and round-the-clock customer support for a hassle-free shipping experience.',NULL,NULL,'2026-06-29 18:36:12','2026-07-01 06:17:24','Learn More','#','Contact Us','#contact','{\"features\":[{\"icon\":\"fa-shield-halved\",\"title\":\"Secure Handling\",\"desc\":\"Your parcels are fully insured and handled with strict security protocols at every step.\"},{\"icon\":\"fa-bolt\",\"title\":\"Lightning Fast\",\"desc\":\"Optimized routing and dedicated fleets ensure the fastest possible delivery times.\"},{\"icon\":\"fa-headset\",\"title\":\"24\\/7 Support\",\"desc\":\"Our customer care team is always available to assist you with any queries or concerns.\"},{\"icon\":\"fa-map-location-dot\",\"title\":\"Live Tracking\",\"desc\":\"Real-time GPS tracking keeps you informed at every step of the delivery journey.\"}],\"timeline\":[{\"year\":\"2008\",\"title\":\"The Beginning\",\"desc\":\"Founded in Hyderabad with a vision to revolutionize local courier services.\"},{\"year\":\"2012\",\"title\":\"National Expansion\",\"desc\":\"Expanded our network to cover all major metro cities across India.\"},{\"year\":\"2015\",\"title\":\"Going Global\",\"desc\":\"Partnered with international giants FedEx, DHL, UPS & ARAMEX for worldwide reach.\"},{\"year\":\"2023\",\"title\":\"Tech Integration\",\"desc\":\"Launched our state-of-the-art tracking app and automated sorting hubs.\"}],\"stats\":[{\"number\":\"15+\",\"label\":\"Years Experience\"},{\"number\":\"10k+\",\"label\":\"Happy Clients\"},{\"number\":\"5M+\",\"label\":\"Parcels Delivered\"},{\"number\":\"50+\",\"label\":\"Global Partners\"}]}'),(3,'vision_mission','Vision & Mission','Our Vision','To be the most trusted and efficient global logistics and courier partner, connecting people and businesses worldwide with seamless, innovative, and sustainable shipping solutions.','Our Mission','To deliver excellence daily by providing fast, secure, and affordable courier services. We commit to customer satisfaction, continuous improvement, and the highest standards of reliability and safety in every delivery.','2026-06-29 18:36:12','2026-06-30 15:54:24','Our Services','#services','Contact Us','#contact','{\"vision_pillars\":[{\"icon\":\"fa-rocket\",\"title\":\"Speed & Precision\",\"desc\":\"Express delivery to any destination within 2\\u20135 business days.\"},{\"icon\":\"fa-shield-halved\",\"title\":\"Security First\",\"desc\":\"Every parcel handled with utmost care and real-time tracking.\"},{\"icon\":\"fa-microchip\",\"title\":\"Technology Driven\",\"desc\":\"Cutting-edge logistics systems for seamless global operations.\"},{\"icon\":\"fa-leaf\",\"title\":\"Sustainable Growth\",\"desc\":\"Committed to eco-conscious practices in all our operations.\"}],\"core_values\":[{\"icon\":\"fa-check-circle\",\"label\":\"Quality Service at Your Doorstep\"},{\"icon\":\"fa-check-circle\",\"label\":\"Low Cost & Transparent Pricing\"},{\"icon\":\"fa-check-circle\",\"label\":\"Authenticity in Every Delivery\"},{\"icon\":\"fa-check-circle\",\"label\":\"Consistent Growth for Partners\"},{\"icon\":\"fa-check-circle\",\"label\":\"Innovation & Creative Solutions\"},{\"icon\":\"fa-check-circle\",\"label\":\"Friendly Customer Communication\"}],\"mission_quote\":{\"text\":\"FlyStar is your one-stop destination for distinguished services \\u2014 backed by FEDEX, DHL, UPS & ARAMEX.\",\"author\":\"FlyStar International Couriers, Hyderabad\"},\"stats\":[{\"number\":\"220+\",\"label\":\"Countries\",\"color\":\"#0056b3\",\"bg\":\"#f8faff\",\"border\":\"#e2eaf8\"},{\"number\":\"2\\u20135\",\"label\":\"Day Delivery\",\"color\":\"#ef7e22\",\"bg\":\"#fff8f2\",\"border\":\"#f5e0cc\"},{\"number\":\"4\",\"label\":\"Elite Partners\",\"color\":\"#28a745\",\"bg\":\"#f0fff4\",\"border\":\"#c8ebd4\"},{\"number\":\"24\\/7\",\"label\":\"Support\",\"color\":\"#d4a800\",\"bg\":\"#fffdf0\",\"border\":\"#f0e8b0\"}]}');

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `image_path` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` VALUES (1,'assets/images/hero_banner.png','Global Logistics,<br>Delivered Locally.','Experience the next generation of courier services with real-time tracking, unmatched security, and lightning-fast deliveries worldwide.','active','2026-06-25 17:02:37','2026-06-25 17:02:37'),(3,'assets/images/flystar_van.png','FlyStar Delivery Fleet','Our modern delivery fleet ensures your packages arrive on time, every time.','active','2026-06-25 17:05:58','2026-06-25 17:05:58'),(4,'assets/images/flystar_warehouse.png','FlyStar Global Hub','State-of-the-art warehousing and organization for maximum efficiency and security.','active','2026-06-25 17:05:58','2026-06-25 17:05:58');

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tracking_number` varchar(50) NOT NULL,
  `sender_id` int(11) unsigned DEFAULT NULL,
  `sender_name` varchar(100) NOT NULL,
  `sender_phone` varchar(20) NOT NULL,
  `sender_address` text NOT NULL,
  `receiver_name` varchar(100) NOT NULL,
  `receiver_phone` varchar(20) NOT NULL,
  `receiver_address` text NOT NULL,
  `origin_branch_id` int(11) unsigned NOT NULL,
  `dest_branch_id` int(11) unsigned NOT NULL,
  `total_weight` decimal(10,2) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `payment_status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `status` enum('booked','dispatched','in_transit','arrived','out_for_delivery','delivered','returned') NOT NULL DEFAULT 'booked',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tracking_number` (`tracking_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookings`
--


--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `phone1` varchar(100) DEFAULT NULL,
  `phone2` varchar(100) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `map_url` text DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` VALUES (1,'Begumpet Branch','Plot No. 45, Sardar Patel Road, Begumpet, Hyderabad - 500016','+91 98765 43210','+91 40 2345 6789','begumpet@flystarcourier.com','https://maps.google.com/?q=Begumpet','active','2026-06-30 16:53:24','2026-06-30 16:53:24'),(2,'Chennai Branch','No. 12, Anna Salai, Guindy, Chennai - 600032','+91 99887 76655','','chennai@flystarcourier.com','https://maps.google.com/?q=Guindy','active','2026-06-30 16:53:24','2026-06-30 16:53:24');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `tagline` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `regional_text` varchar(255) DEFAULT NULL,
  `destinations` varchar(255) DEFAULT 'USA, UK, Germany, Australia, New Zealand',
  `content` text DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'Hyderabad','hyderabad','Best International Courier Services in Hyderabad','Relations are never far away from distances, we make them closer','<h5 class=\"fw-bold mb-2\">α░╣α▒êα░ªα░░α░╛α░¼α░╛α░ªα▒ì α░¿α▒üα░éα░íα░┐ α░àα░éα░ñα░░α▒ìα░£α░╛α░ñα▒Çα░» α░òα▒èα░░α░┐α░»α░░α▒ì α░╕α▒çα░╡α░▓α▒ü</h5><p class=\"mb-1\"><strong>α░╕α▒çα░╡α░▓α▒ü:</strong> α░╡α░╛α░»α▒ü α░░α░╡α░╛α░úα░╛, α░╕α░«α▒üα░ªα▒ìα░░ α░░α░╡α░╛α░úα░╛, α░¬α░ñα▒ìα░░α░╛α░▓α▒ü, α░¬α░╛α░░α▒ìα░╢α░┐α░▓α▒ì α░¬α░éα░¬α░┐α░úα▒Ç</p><p class=\"mb-0\"><strong>α░¬α▒ìα░░α░╕α░┐α░ªα▒ìα░º α░ùα░«α▒ìα░»α░╕α▒ìα░Ñα░╛α░¿α░╛α░▓α▒ü:</strong> USA, UK, α░£α░░α▒ìα░«α░¿α▒Ç, α░åα░╕α▒ìα░ƒα▒ìα░░α▒çα░▓α░┐α░»α░╛, α░òα▒åα░¿α░íα░╛','USA, UK, Germany, Australia, UAE, Singapore - Delivery 3-5 Days','FlyStar is the leading international courier service and freight forwarding company in Hyderabad. We offer fast, secure, and cost-effective courier solutions from Hyderabad to 220+ countries. Serving areas like Banjara Hills, Jubilee Hills, Hitech City, Gachibowli, Secunderabad, and all major localities. We provide Express and Economy international courier services with secure door-to-door delivery and port-to-port options.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43'),(2,'Mumbai','mumbai','Best International Courier Services in Mumbai','Your trusted global courier partner from the financial capital of India','<h5 class=\"fw-bold mb-2\">αñ«αÑüαñéαñ¼αñêαññαÑéαñ¿ αñåαñéαññαñ░αñ░αñ╛αñ╖αÑìαñƒαÑìαñ░αÑÇαñ» αñòαÑüαñ░αñ┐αñàαñ░ αñ╕αÑçαñ╡αñ╛</h5><p class=\"mb-1\"><strong>αñ╕αÑçαñ╡αñ╛:</strong> αñ╣αñ╡αñ╛αñê αñ«αñ╛αñ▓αñ╡αñ╛αñ╣αññαÑéαñò, αñ╕αñ╛αñùαñ░αÑÇ αñ«αñ╛αñ▓αñ╡αñ╛αñ╣αññαÑéαñò, αñªαñ╕αÑìαññαñÉαñ╡αñ£, αñ¬αñ╛αñ░αÑìαñ╕αñ▓ αñ╡αñ┐αññαñ░αñú</p><p class=\"mb-0\"><strong>αñ▓αÑïαñòαñ¬αÑìαñ░αñ┐αñ» αñùαñéαññαñ╡αÑìαñ»αñ╕αÑìαñÑαñ╛αñ¿αÑç:</strong> αñ»αÑéαñÅαñ╕αñÅ, αñ»αÑéαñòαÑç, αñ£αñ░αÑìαñ«αñ¿αÑÇ, αñæαñ╕αÑìαñƒαÑìαñ░αÑçαñ▓αñ┐αñ»αñ╛, αñòαÑàαñ¿αñí','USA, UK, Canada, Australia, UAE, Singapore - Delivery 3-5 Days','FlyStar offers premier international courier and freight forwarding services from Mumbai. Covering all major areas including Andheri, Bandra, Borivali, Thane, Navi Mumbai. As India\'s financial capital, Mumbai demands reliable, fast, and secure international shipping ΓÇö and that\'s exactly what we deliver with our elite courier network including FedEx, DHL, UPS, and ARAMEX.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43'),(3,'Delhi','delhi','Best International Courier Services in Delhi','Seamless international deliveries from India\'s capital city','<h5 class=\"fw-bold mb-2\">αñªαñ┐αñ▓αÑìαñ▓αÑÇ αñ╕αÑç αñàαñéαññαñ░αÑìαñ░αñ╛αñ╖αÑìαñƒαÑìαñ░αÑÇαñ» αñòαÑéαñ░αñ┐αñ»αñ░ αñ╕αÑçαñ╡αñ╛αñÅαñé</h5><p class=\"mb-1\"><strong>αñ╕αÑçαñ╡αñ╛αñÅαñé:</strong> αñ╣αñ╡αñ╛αñê αñ«αñ╛αñ▓ αñóαÑüαñ▓αñ╛αñê, αñ╕αñ«αÑüαñªαÑìαñ░αÑÇ αñ«αñ╛αñ▓ αñóαÑüαñ▓αñ╛αñê, αñªαñ╕αÑìαññαñ╛αñ╡αÑçαñ£αñ╝, αñ¬αñ╛αñ░αÑìαñ╕αñ▓ αñ╡αñ┐αññαñ░αñú</p><p class=\"mb-0\"><strong>αñ▓αÑïαñòαñ¬αÑìαñ░αñ┐αñ» αñùαñéαññαñ╡αÑìαñ»:</strong> αñ╕αñéαñ»αÑüαñòαÑìαññ αñ░αñ╛αñ£αÑìαñ» αñàαñ«αÑçαñ░αñ┐αñòαñ╛, αñ¼αÑìαñ░αñ┐αñƒαÑçαñ¿, αñ£αñ░','USA, UK, Europe, Australia, UAE - Delivery 3-5 Days','FlyStar provides world-class international courier and logistics services from Delhi and the NCR region. Covering Connaught Place, Karol Bagh, Dwarka, Gurugram, Noida, Faridabad, and Ghaziabad. Whether you\'re shipping business documents or commercial goods, our Express and Economy services ensure your parcel arrives safely and on time.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43'),(4,'Bangalore','bangalore','Best International Courier Services in Bangalore','Tech hub to the world ΓÇö fast courier solutions from Bangalore','<h5 class=\"fw-bold mb-2\">α▓¼α│åα▓éα▓ùα▓│α│éα▓░α▓┐α▓¿α▓┐α▓éα▓ª α▓àα▓éα▓ñα▓░α▓░α▓╛α▓╖α│ìα▓ƒα│ìα▓░α│Çα▓» α▓òα│èα▓░α▓┐α▓»α▓░α│ì α▓╕α│çα▓╡α│åα▓ùα▓│α│ü</h5><p class=\"mb-1\"><strong>α▓╕α│çα▓╡α│åα▓ùα▓│α│ü:</strong> α▓╡α▓╛α▓»α│ü α▓╕α▓░α▓òα│ü, α▓╕α▓«α│üα▓ªα│ìα▓░ α▓╕α▓░α▓òα│ü, α▓ªα▓╛α▓ûα▓▓α│å α▓╡α▓┐α▓ñα▓░α▓úα│å, α▓¬α▓╛α▓░α│ìα▓╕α│åα▓▓α│ì α▓╡α▓┐α▓ñα▓░α▓úα│å</p><p class=\"mb-0\"><strong>α▓£α▓¿α▓¬α│ìα▓░α▓┐α▓» α▓ùα▓«α│ìα▓»α▓╕α│ìα▓Ñα▓╛α▓¿α▓ùα▓│α│ü:</strong> α▓»α│üα▓Äα▓╕α│ìα▓Ä, α▓»α│üα▓òα│å, α▓£α▓░α│ìα▓«α▓¿α▓┐, α▓åα▓╕α│ìα▓ƒα│ìα▓░α│ç','USA, UK, Germany, Australia, New Zealand, Singapore - Delivery 5-7 Days','FlyStar is a leading international courier service and freight forwarding company offering global shipping solutions from Bangalore, Indiranagar, Koramangala, Whitefield, Electronic City, BTM Layout, HSR Layout, and Jayanagar. As the tech hub of India, Bangalore requires reliable shipping for IT products, documents, and e-commerce parcels.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43'),(5,'Chennai','chennai','Best International Courier Services in Chennai','Gateway to South Asia ΓÇö reliable courier services from Chennai','<h5 class=\"fw-bold mb-2\">α«Üα»åα«⌐α»ìα«⌐α»êα«»α«┐α«▓α«┐α«░α»üα«¿α»ìα«ñα»ü α«Üα«░α»ìα«╡α«ñα»çα«Ü α«òα»éα«░α«┐α«»α«░α»ì α«Üα»çα«╡α»êα«òα«│α»ì</h5><p class=\"mb-1\"><strong>α«Üα»çα«╡α»êα«òα«│α»ì:</strong> α«╡α«┐α««α«╛α«⌐ α«Üα«░α«òα»ìα«òα»ü, α«òα«ƒα«▓α»ì α«Üα«░α«òα»ìα«òα»ü, α«åα«╡α«úα«Öα»ìα«òα«│α»ì, α«¬α«╛α«░α»ìα«Üα«▓α»ì α«╡α«┐α«¿α«┐α«»α»ïα«òα««α»ì</p><p class=\"mb-0\"><strong>α«¬α«┐α«░α«¬α«▓α««α«╛α«⌐ α«çα«ƒα«Öα»ìα«òα«│α»ì:</strong> α«àα««α»åα«░α«┐α«òα»ìα«òα«╛, α«çα«Öα»ìα«òα«┐α«▓α«╛α«¿α»ìα«ñα»ü, α«£α»åα«░α»ìα««α«⌐α«┐, α«å','USA, UK, Malaysia, Singapore, UAE, Australia - Delivery 4-6 Days','FlyStar provides fast and reliable international courier services from Chennai to over 220 countries. We serve Anna Nagar, T. Nagar, Velachery, Tambaram, Adyar, Porur, and all Chennai localities. Our services include express delivery, document shipping, and commercial cargo forwarding with real-time tracking and dedicated customer support.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43'),(6,'Kolkata','kolkata','Best International Courier Services in Kolkata','Connecting the City of Joy to the world with fast courier services','<h5 class=\"fw-bold mb-2\">αªòαª▓αªòαª╛αªñαª╛ αªÑαºçαªòαºç αªåαª¿αºìαªñαª░αºìαª£αª╛αªñαª┐αªò αªòαºüαª░αª┐αª»αª╝αª╛αª░ αª¬αª░αª┐αª╖αºçαª¼αª╛</h5><p class=\"mb-1\"><strong>αª¬αª░αª┐αª╖αºçαª¼αª╛:</strong> αª¼αª┐αª«αª╛αª¿ αª¡αª╛αªíαª╝αª╛αª»αª╝ αª¬αª░αª┐αª¼αª╣αª¿, αª╕αª╛αª«αºüαªªαºìαª░αª┐αªò αª¡αª╛αªíαª╝αª╛αª»αª╝ αª¬αª░αª┐αª¼αª╣αª¿, αª¿αªÑαª┐, αª¬αª╛αª░αºìαª╕αºçαª▓ αª¼αª┐αªñαª░αªú</p><p class=\"mb-0\"><strong>αª£αª¿αª¬αºìαª░αª┐αª»αª╝ αªùαª¿αºìαªñαª¼αºìαª»:</strong> αª«αª╛αª░αºìαªòαª┐αª¿ αª»αºüαªòαºìαªñαª░αª╛αª╖αºìαªƒαºìαª░, ','USA, UK, Bangladesh, Australia, UAE, Singapore - Delivery 4-6 Days','FlyStar offers premier international courier and freight services from Kolkata. Covering Salt Lake, Park Street, New Town, Howrah, Dum Dum, and all parts of West Bengal. We provide Express and Economy international courier services for documents, parcels, and commercial shipments with full customs support and doorstep delivery.',NULL,'active','2026-06-29 09:23:43','2026-06-29 09:23:43');

--
-- Table structure for table `cms_pages`
--

CREATE TABLE `cms_pages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `status` enum('published','draft') NOT NULL DEFAULT 'draft',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cms_pages`
--


--
-- Table structure for table `courier_deals`
--

CREATE TABLE `courier_deals` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country_name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `condition_text` varchar(255) NOT NULL DEFAULT '*For Sending 50 Kg above',
  `image_path` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `courier_deals`
--

INSERT INTO `courier_deals` VALUES (1,'BELGIUM',758.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/be.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(2,'FRANCE',778.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/fr.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(3,'GERMANY',738.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/de.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(4,'IRELAND',788.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/ie.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(5,'ITALY',788.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/it.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(6,'CANADA',827.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/ca.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(7,'NETHERLANDS',768.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/nl.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05'),(8,'SWEDEN',798.00,'*For Sending 50 Kg above','https://flagcdn.com/w80/se.png','active','2026-06-25 17:30:05','2026-06-25 17:30:05');

--
-- Table structure for table `delivery_charges`
--

CREATE TABLE `delivery_charges` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `origin_city` varchar(50) NOT NULL,
  `destination_city` varchar(50) NOT NULL,
  `parcel_type` varchar(50) DEFAULT 'Document',
  `base_weight` decimal(10,2) NOT NULL COMMENT 'Weight up to which base charge applies',
  `base_charge` decimal(10,2) NOT NULL,
  `extra_charge` decimal(10,2) NOT NULL COMMENT 'Charge per extra kg',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `delivery_charges`
--

INSERT INTO `delivery_charges` VALUES (1,'Hyderabad','New York','Document',1.00,2500.00,1200.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(2,'Hyderabad','London','Document',1.00,2200.00,1000.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(3,'Hyderabad','Dubai','Document',1.00,1500.00,800.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(4,'Hyderabad','Sydney','Document',1.00,2800.00,1400.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(5,'Hyderabad','Toronto','Document',1.00,2600.00,1300.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(6,'Hyderabad','Singapore','Document',1.00,1200.00,600.00,'2026-06-25 23:07:58','2026-06-25 23:07:58'),(7,'Hyderabad','New York','Medicines',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(8,'Hyderabad','New York','Food Items',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(9,'Hyderabad','New York','Excess Baggage',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(10,'Hyderabad','New York','Commercial Cargo',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(11,'Hyderabad','New York','Household Items',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(12,'Hyderabad','New York','Gifts & Parcels',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(13,'Hyderabad','New York','E-Commerce Shipments',1.00,2500.00,1200.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(14,'Hyderabad','London','Medicines',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(15,'Hyderabad','London','Food Items',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(16,'Hyderabad','London','Excess Baggage',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(17,'Hyderabad','London','Commercial Cargo',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(18,'Hyderabad','London','Household Items',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(19,'Hyderabad','London','Gifts & Parcels',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(20,'Hyderabad','London','E-Commerce Shipments',1.00,2200.00,1000.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(21,'Hyderabad','Dubai','Medicines',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(22,'Hyderabad','Dubai','Food Items',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(23,'Hyderabad','Dubai','Excess Baggage',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(24,'Hyderabad','Dubai','Commercial Cargo',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(25,'Hyderabad','Dubai','Household Items',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(26,'Hyderabad','Dubai','Gifts & Parcels',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(27,'Hyderabad','Dubai','E-Commerce Shipments',1.00,1500.00,800.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(28,'Hyderabad','Sydney','Medicines',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(29,'Hyderabad','Sydney','Food Items',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(30,'Hyderabad','Sydney','Excess Baggage',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(31,'Hyderabad','Sydney','Commercial Cargo',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(32,'Hyderabad','Sydney','Household Items',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(33,'Hyderabad','Sydney','Gifts & Parcels',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(34,'Hyderabad','Sydney','E-Commerce Shipments',1.00,2800.00,1400.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(35,'Hyderabad','Toronto','Medicines',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(36,'Hyderabad','Toronto','Food Items',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(37,'Hyderabad','Toronto','Excess Baggage',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(38,'Hyderabad','Toronto','Commercial Cargo',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(39,'Hyderabad','Toronto','Household Items',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(40,'Hyderabad','Toronto','Gifts & Parcels',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(41,'Hyderabad','Toronto','E-Commerce Shipments',1.00,2600.00,1300.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(42,'Hyderabad','Singapore','Medicines',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(43,'Hyderabad','Singapore','Food Items',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(44,'Hyderabad','Singapore','Excess Baggage',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(45,'Hyderabad','Singapore','Commercial Cargo',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(46,'Hyderabad','Singapore','Household Items',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(47,'Hyderabad','Singapore','Gifts & Parcels',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08'),(48,'Hyderabad','Singapore','E-Commerce Shipments',1.00,1200.00,600.00,'2026-06-30 11:11:08','2026-06-30 11:11:08');

--
-- Table structure for table `how_it_works`
--

CREATE TABLE `how_it_works` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `step_number` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `how_it_works`
--

INSERT INTO `how_it_works` VALUES (1,1,'Enter Details','Select destination, weight, and package type in our rate calculator.','active','2026-06-25 21:05:02','2026-06-25 21:05:02'),(2,2,'Get Quote','Compare Express and Economy rates instantly with no hidden fees.','active','2026-06-25 21:05:02','2026-06-25 21:05:02'),(3,3,'Ship & Track','Schedule free pickup and track your shipment until delivery.','active','2026-06-25 21:05:02','2026-06-25 21:05:02');

--
-- Table structure for table `how_to_ship_pages`
--

CREATE TABLE `how_to_ship_pages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `button1_text` varchar(100) DEFAULT NULL,
  `button1_url` varchar(255) DEFAULT NULL,
  `button2_text` varchar(100) DEFAULT NULL,
  `button2_url` varchar(255) DEFAULT NULL,
  `json_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_name` (`page_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `how_to_ship_pages`
--

INSERT INTO `how_to_ship_pages` VALUES (1,'step_by_step_guide','Step-by-Step Guide',NULL,'Shipping with FlyStar Services is designed to be as seamless and hassle-free as possible. Follow this simple, foolproof 4-step guide to get your package from your hands to its final destination safely.\r\n\r\n### Step 1: Pack Your Items Securely\r\nBefore you ship, ensure your items are packed tightly using high-quality corrugated boxes. Use bubble wrap or packing peanuts for fragile items to prevent movement during transit. Seal all edges with heavy-duty packing tape.\r\n\r\n### Step 2: Measure and Weight\r\nAccurate measurements are crucial for a smooth shipping experience. Measure the length, width, and height of your packed box in centimeters, and weigh it accurately. You can use our Rate Calculator to get an instant estimate of your shipping costs based on these dimensions.\r\n\r\n### Step 3: Book Your Shipment\r\nYou can book your shipment entirely online through our customer portal, or drop it off at one of our many nationwide branches. If you book online, you can schedule a convenient doorstep pickup, and our executive will collect the parcel directly from you.\r\n\r\n### Step 4: Track Your Parcel\r\nOnce your parcel is handed over, you will receive a unique Tracking ID. Use this ID on our website to monitor your shipment\'s journey in real-time, right up until it reaches the receiver\'s doorstep.','2026-06-29 18:49:01','2026-07-01 09:58:50',NULL,NULL,NULL,NULL,NULL),(2,'packing_guidelines','Packing Guidelines','Ensure your cargo reaches its destination safely by following our expert packaging recommendations.','Proper packaging is the most critical factor in ensuring your shipment arrives at its destination in perfect condition. FlyStar Services handles thousands of packages daily, and adhering to these professional packing standards will safeguard your items against the rigors of transit.\r\n\r\n### 1. Choose the Right Box\r\nAlways use new, sturdy, double-walled corrugated cardboard boxes for heavy or fragile items. Reused boxes lose their structural integrity and are highly susceptible to crushing. Ensure the box is large enough to accommodate your item with at least 2 inches of cushioning on all sides.\r\n\r\n### 2. Internal Cushioning is Mandatory\r\nYour item should not touch the walls of the box. Use generous amounts of bubble wrap, foam inserts, or biodegradable packing peanuts to fill all void spaces. Shake the box gentlyΓÇöif you hear or feel movement inside, add more cushioning.\r\n\r\n### 3. Special Care for Liquids and Powders\r\nIf shipping liquids, they must be in leak-proof containers and sealed inside a waterproof plastic bag. Powders should be similarly sealed in sift-proof bags. Place these items upright inside the box.\r\n\r\n### 4. Sealing the Package\r\nDo not use masking tape, scotch tape, or string. Use strong, pressure-sensitive packing tape (at least 2 inches wide). Apply the \'H-tape\' method: seal the center seam securely, and then seal the two edge seams on both the top and bottom of the box.\r\n\r\n### 5. Clear Labeling\r\nRemove all old labels from the box. Print your FlyStar shipping label clearly and affix it to the largest, flat surface of the box. Do not place tape over the barcode, as this can interfere with our scanning equipment.','2026-06-29 18:49:01','2026-07-01 10:19:40',NULL,NULL,NULL,NULL,NULL),(3,'prohibited_items','Prohibited Items','Ensure compliance and safety. Review the list of items that are strictly prohibited or restricted for international shipping.','For the safety of our staff, the public, and compliance with national and international transport regulations, FlyStar Services strictly prohibits the shipment of certain hazardous, illegal, or dangerous goods. \r\n\r\nPlease review this list carefully. Attempting to ship prohibited items may result in confiscation, destruction of the package, or legal action.\r\n\r\n### 1. Explosives and Flammable Materials\r\n- Fireworks, flares, and ammunition.\r\n- Gasoline, lighter fluid, and matches.\r\n- Aerosol cans (including hairspray and deodorant) and compressed gas cylinders.\r\n\r\n### 2. Toxic, Infectious, and Radioactive Substances\r\n- Pesticides, agricultural chemicals, and poisons.\r\n- Medical waste, biological samples, and infectious substances.\r\n- Radioactive materials of any kind.\r\n\r\n### 3. Illegal and Restricted Items\r\n- Narcotics, illegal drugs, and unregistered pharmaceuticals.\r\n- Counterfeit currency, forged documents, and pirated goods.\r\n- Firearms, weaponry, and weapon parts.\r\n\r\n### 4. Perishables and Live Animals\r\n- Fresh fruits, vegetables, and meat products that require refrigeration.\r\n- Live animals, insects, or biological specimens.\r\n\r\n### 5. High-Value and Irreplaceable Items\r\nWhile not strictly prohibited, we strongly advise against (and may refuse liability for) shipping loose precious stones, gold bullion, cash/currency notes, and irreplaceable historical artifacts. Please contact our support team for specialized secure transport options for high-value goods.','2026-06-29 18:49:01','2026-07-01 10:23:54',NULL,NULL,NULL,NULL,'{\"notice_title\":\"Important Notice\",\"notice_text\":\"Shipping prohibited items can result in confiscation, severe delays, and legal penalties. Please review this list carefully before booking your shipment.\",\"clarification_title\":\"Need clarification on a specific item?\",\"clarification_text\":\"Customs regulations vary significantly by destination country. If you are unsure whether your item is prohibited or requires special permits, please contact our support team before booking.\",\"clarification_button\":\"Contact Support\"}'),(5,'rate_calculator','Shipping Rate Calculator','Get instant and accurate shipping estimates for your international and domestic courier needs.','Use our intelligent rate calculator below to get an instant, accurate estimate for your shipment. Simply enter your origin, destination, and package details. Note that final charges may vary slightly based on the actual volumetric weight determined at our facility.','2026-06-29 18:49:01','2026-07-01 10:18:55',NULL,NULL,NULL,NULL,'{\"calc_title\":\"Calculate Shipping Cost\",\"calc_subtitle\":\"Enter your shipment details below for an instant price quote\",\"terms_title\":\"Terms & Conditions\",\"terms_list\":[\"Packages volumetric ( L * W * H - in cms) \\/ 5000 ) or actual weight whichever is higher will be charged.\",\"Address correction charges will be charged as per destination.\",\"Remote area fee Rs.40\\/- per kg with minimum of Rs.2500\\/- will be charged extra for all Remote area locations.\",\"Photo ID compulsory for Shipment from Individual.\",\"Any other levies, taxes or duties implemented by the govt would be charged as applicable.\"],\"dim_title\":\"Dimensional Weight Calculator\",\"dim_formula_heading\":\"Formula : Length (X) Height (X) Width\\/5000\",\"dim_formula_desc\":\"For example, for U.S. or Canadian origin export shipments measured in inches, the divisor is 166. For EMEA, animal material and APAC origin export shipments measured in inches, the divisor is 139; if measured in centimetres, the divisor is 5,000.\"}'),(6,'international_regulatory','International Regulatory','Navigate global customs with ease. Understand the regulations, duties, and documentation required for seamless international shipping.','International Regulatory Compliance\r\n\r\nNavigating international borders requires strict adherence to customs regulations, import/export laws, and international trade compliance. FlyStar Services provides expert guidance to ensure your global shipments clear customs smoothly and without unnecessary delays.\r\n\r\nCommercial Invoices\r\n\r\nEvery international shipment containing goods (non-documents) must be accompanied by a commercial invoice. This document is the primary declaration used by customs authorities to assess duties and taxes. It must accurately detail the sender and receiver\'s information, a precise description of the goods, their country of origin, and their true commercial value.\r\n\r\nDuties, Taxes, and Tariffs\r\n\r\nCustoms duties and taxes are determined by the destination country based on the type of goods and their declared value. Unless otherwise specified (such as a DDP\r\nDelivered Duty Paid shipment), the receiver is typically responsible for paying these charges before the package is released by customs.\r\n\r\nRestricted Commodities & Licensing\r\n\r\nCertain goods may be legally exported from your country but heavily restricted or completely banned in the destination country. Common examples include agricultural products, pharmaceuticals, telecommunications equipment, and certain textiles. Some items may require specific import licenses or permits. It is the shipper\'s responsibility to verify that the item is permissible in the destination country.\r\n\r\nElectronic Export Information (EEI)\r\n\r\nFor high-value commercial shipments, an EEI filing may be legally required before export. Our regulatory team can assist you in filing the necessary declarations to ensure full compliance with international trade laws.','2026-06-30 06:12:26','2026-07-01 10:27:02',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned DEFAULT 0,
  `title` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `icon_color` varchar(50) DEFAULT NULL,
  `is_dynamic` enum('none','cities') DEFAULT 'none',
  `sort_order` int(11) DEFAULT 0,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,0,'Home','',NULL,NULL,'none',1,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(2,0,'About Us','#',NULL,NULL,'none',2,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(3,2,'Our Profile','about/profile','fa-solid fa-address-card','text-primary','none',1,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(4,2,'Why FlyStar','about/why-flystar','fa-solid fa-star','text-warning','none',2,'active','2026-06-29 18:27:42','2026-06-29 19:56:12'),(5,2,'Vision & Mission','about/vision-mission','fa-solid fa-eye','text-success','none',3,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(6,0,'Services','#',NULL,NULL,'none',3,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(7,6,'International','services/international','fa-solid fa-plane-departure','text-primary','none',1,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(8,6,'Domestic','services/domestic','fa-solid fa-truck','text-warning','none',2,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(9,6,'Logistics','services/logistics','fa-solid fa-boxes-stacked','text-success','none',3,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(10,0,'Cities','#',NULL,NULL,'cities',4,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(11,0,'How to Ship','#',NULL,NULL,'none',5,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(12,11,'Step-by-Step Guide','how-to-ship/step-by-step-guide','fa-solid fa-circle-play','text-primary','none',1,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(13,11,'Rate Calculator','how-to-ship/rate-calculator','fa-solid fa-calculator','text-success','none',2,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(14,11,'Packing Guidelines','how-to-ship/packing-guidelines','fa-solid fa-box','text-warning','none',3,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(15,11,'Prohibited Items','how-to-ship/prohibited-items','fa-solid fa-triangle-exclamation','text-danger','none',4,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(17,0,'Support','#',NULL,NULL,'none',6,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(18,17,'Customer Support','support/customer-support','fa-solid fa-headset','text-primary','none',1,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(19,17,'FAQ','support/faq','fa-solid fa-circle-question','text-warning','none',2,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(20,17,'International Regulatory','how-to-ship/international-regulatory','fa-solid fa-scale-balanced','text-info','none',3,'active','2026-06-29 18:27:42','2026-06-29 18:27:42'),(21,0,'Contact Us','contact-us',NULL,NULL,'none',7,'active','2026-06-29 18:27:42','2026-06-30 16:57:34'),(22,6,'Shopping','services/shopping','fa-solid fa-bag-shopping','text-info','none',4,'active','2026-06-30 17:42:52','2026-06-30 17:42:52'),(23,6,'Personalized Assistance','services/personalized-assistance','fa-solid fa-user-tie','text-danger','none',5,'active','2026-06-30 17:42:52','2026-06-30 17:42:52');

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

CREATE TABLE `migrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2026-06-25-110235','App\\Database\\Migrations\\Roles','default','App',1782385649,1),(2,'2026-06-25-110236','App\\Database\\Migrations\\Permissions','default','App',1782385649,1),(3,'2026-06-25-110237','App\\Database\\Migrations\\RolePermissions','default','App',1782385675,2),(4,'2026-06-25-110238','App\\Database\\Migrations\\Branches','default','App',1782385675,2),(5,'2026-06-25-110238','App\\Database\\Migrations\\Users','default','App',1782385675,2),(6,'2026-06-25-110322','App\\Database\\Migrations\\Settings','default','App',1782385675,2),(7,'2026-06-25-110323','App\\Database\\Migrations\\Bookings','default','App',1782385675,2),(8,'2026-06-25-110323','App\\Database\\Migrations\\DeliveryCharges','default','App',1782385675,2),(9,'2026-06-25-110323','App\\Database\\Migrations\\Shipments','default','App',1782385675,2),(10,'2026-06-25-110631','App\\Database\\Migrations\\CmsPages','default','App',1782385675,2),(11,'2026-06-25-113150','App\\Database\\Migrations\\Banners','default','App',1782387157,3),(12,'2026-06-25-134602','App\\Database\\Migrations\\Services','default','App',1782387962,4),(13,'2026-06-25-115121','App\\Database\\Migrations\\ShippableItems','default','App',1782388345,5),(14,'2026-06-25-115909','App\\Database\\Migrations\\CourierDeals','default','App',1782388805,6),(15,'2026-06-25-120416','App\\Database\\Migrations\\WhyChooseFeatures','default','App',1782389121,7),(16,'2026-06-25-153358','App\\Database\\Migrations\\HowItWorks','default','App',1782401702,8);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permissions`
--


--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `role_id` int(11) unsigned NOT NULL,
  `permission_id` int(11) unsigned NOT NULL,
  KEY `role_id_permission_id` (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permissions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--


--
-- Table structure for table `service_pages`
--

CREATE TABLE `service_pages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `button1_text` varchar(100) DEFAULT NULL,
  `button1_url` varchar(255) DEFAULT NULL,
  `button2_text` varchar(100) DEFAULT NULL,
  `button2_url` varchar(255) DEFAULT NULL,
  `stat1_number` varchar(100) DEFAULT NULL,
  `stat1_label` varchar(100) DEFAULT NULL,
  `stat2_number` varchar(100) DEFAULT NULL,
  `stat2_label` varchar(100) DEFAULT NULL,
  `stat3_number` varchar(100) DEFAULT NULL,
  `stat3_label` varchar(100) DEFAULT NULL,
  `stat4_number` varchar(100) DEFAULT NULL,
  `stat4_label` varchar(100) DEFAULT NULL,
  `json_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_name` (`page_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_pages`
--

INSERT INTO `service_pages` VALUES (1,'international','International Courier Services','Connecting Hyderabad to 220+ countries with speed, precision, and complete peace of mind. Your global courier partner.','At FlyStar Services, we bridge the gap between you and the world with our premium international shipping solutions. Whether you are sending critical business documents, commercial cargo, or a personal gift to a loved one overseas, our expansive global network covering over 220 countries and territories ensures your shipment arrives safely and on time.\r\n\r\nOur International Services Include:\r\n\r\n≡ƒîì Global Reach & Speed\r\nLeveraging strategic partnerships with major international carriers and airlines, we offer express air freight options that guarantee expedited delivery. Most major global destinations can be reached within 2 to 5 business days, ensuring your urgent shipments never face unnecessary delays.\r\n\r\n≡ƒ¢é Seamless Customs Clearance\r\nNavigating international customs can be complex, but our dedicated team of regulatory experts handles everything for you. From preparing the necessary commercial invoices and export documentation to managing duties and taxes, we ensure your parcel clears customs smoothly without unexpected hold-ups.\r\n\r\n≡ƒôª Comprehensive Tracking & Security\r\nFrom the moment your package leaves your hands until it reaches its final destination abroad, you are in complete control. Our advanced real-time tracking system provides step-by-step updates, while our robust packaging guidelines and insurance options guarantee maximum security for your valuable items.','2026-06-29 18:42:24','2026-06-30 11:38:27','get quote','#contact','Track Shipment','#tracking','221+','Countries Covered','2-5','Business Days','99.8%','On-Time Rate','24/7','Live Support',NULL),(2,'domestic','Domestic Courier Services','Express and standard delivery solutions covering every city and town across India ΓÇö fast, reliable, and affordable.','FlyStar Services offers a robust, nationwide domestic shipping network designed to meet the demands of both individual consumers and large enterprises. From the bustling streets of metropolitan hubs to the most remote towns across the country, we deliver your packages with unmatched speed and reliability.\r\n\r\nOur Domestic Services Include:\r\n\r\n≡ƒÜÇ Express & Standard Delivery\r\nWe understand that not all shipments have the same urgency. That\'s why we offer flexible options ranging from Same-Day and Next-Day Express Delivery for time-critical documents, to highly economical Standard Surface Transport for heavier, non-urgent parcels and freight.\r\n\r\n≡ƒôì Hyper-Local Last-Mile Fulfillment\r\nOur extensive fleet of delivery vehicles and widespread network of branch offices ensure that the final leg of the journeyΓÇöthe \"last mile\"ΓÇöis executed flawlessly. We pride ourselves on accurate doorstep delivery, supported by localized expertise that guarantees your package reaches the right hands.\r\n\r\n≡ƒÅó E-Commerce & B2B Solutions\r\nWe provide tailored solutions for e-commerce businesses and corporate clients. With features like automated bulk booking, API integrations, Cash on Delivery (COD) handling, and return logistics, we empower your business to operate smoothly and scale efficiently across the nation.','2026-06-29 18:42:24','2026-06-30 15:48:24','Book a Pickup','#contact','Track Shipment','#tracking','500+','Cities Served','Same Day','Express Option','99.5%','Delivery Rate','24/7','Pickup Available','{\"steps\":[{\"icon\":\"fa-mobile-screen\",\"number\":\"1\",\"title\":\"Book Online\",\"desc\":\"Use our app or website\"},{\"icon\":\"fa-truck-pickup\",\"number\":\"2\",\"title\":\"We Pickup\",\"desc\":\"From your doorstep\"},{\"icon\":\"fa-warehouse\",\"number\":\"3\",\"title\":\"Sort & Process\",\"desc\":\"At our hub center\"},{\"icon\":\"fa-location-dot\",\"number\":\"4\",\"title\":\"Live Tracking\",\"desc\":\"Monitor every step\"},{\"icon\":\"fa-handshake\",\"number\":\"5\",\"title\":\"Delivered\",\"desc\":\"At recipient doorstep\"}],\"services\":[{\"icon\":\"fa-bolt\",\"color\":\"#ef7e22\",\"title\":\"Same Day Express\",\"desc\":\"Delivery within the same city on the same day. Perfect for urgent documents and parcels.\",\"badge\":\"Book by 10 AM\"},{\"icon\":\"fa-sun\",\"color\":\"#0056b3\",\"title\":\"Next Day Delivery\",\"desc\":\"Guaranteed next business day delivery to all major cities across India.\",\"badge\":\"Book by 6 PM\"},{\"icon\":\"fa-calendar-days\",\"color\":\"#28a745\",\"title\":\"Economy (2-5 Days)\",\"desc\":\"Cost-effective delivery option for non-urgent parcels and packages.\",\"badge\":\"Most Affordable\"}],\"partners\":[{\"title\":\"Metro Cities\",\"desc\":\"Mumbai, Delhi, Bangalore, Chennai, Kolkata, Hyderabad\",\"icon\":\"fa-city\"},{\"title\":\"Tier-2 Cities\",\"desc\":\"Pune, Ahmedabad, Jaipur, Lucknow, Nagpur, Bhopal\",\"icon\":\"fa-buildings\"},{\"title\":\"Tier-3 & Towns\",\"desc\":\"2000+ towns across all states and union territories\",\"icon\":\"fa-location-dot\"},{\"title\":\"Special Zones\",\"desc\":\"J&K, Northeast India, Andaman & Lakshadweep\",\"icon\":\"fa-mountain\"}]}'),(3,'logistics','Comprehensive Logistics Solutions','End-to-end supply chain and logistics management for businesses of all sizes.','Beyond standard parcel delivery, FlyStar Services is a powerhouse in end-to-end supply chain management and heavy logistics. We offer customized, scalable solutions designed to streamline your operations, reduce overhead costs, and optimize the movement of your commercial goods.\r\n\r\nOur Logistics Capabilities Include:\r\n\r\n≡ƒÅ¡ Warehousing & Distribution\r\nWe provide state-of-the-art warehousing facilities equipped with modern inventory management systems. Our strategically located fulfillment centers allow you to store goods securely and dispatch them instantly, drastically reducing transit times and improving your customer satisfaction.\r\n\r\n≡ƒÜó Freight Forwarding & Heavy Cargo\r\nFor shipments that exceed standard courier limits, our freight forwarding division takes over. We handle Air Freight, Ocean Freight (FCL & LCL), and Overland Trucking. From heavy industrial machinery to bulk raw materials, we manage complex logistics with precision, ensuring compliance with all transport regulations.\r\n\r\n≡ƒöä Supply Chain Optimization\r\nOur logistics experts work closely with your business to analyze and optimize your supply chain. We identify bottlenecks, implement cost-saving routing strategies, and provide tailored solutions such as reverse logistics, vendor management, and just-in-time (JIT) inventory delivery to keep your business running at peak efficiency.','2026-06-29 18:42:24','2026-07-01 09:20:19','Talk to an Expert','#contact','Track Shipment','#tracking','50%','Cost Reduction','2x','Faster Processing','100%','Visibility','99%','Order Accuracy','{\"badge_text\":\"\\ud83d\\udce6 END-TO-END SUPPLY CHAIN\",\"steps\":[{\"icon\":\"fa-industry\",\"color\":\"#28a745\",\"title\":\"Supplier \\/ Origin\"},{\"icon\":\"fa-arrow-right\",\"color\":\"#adb5bd\",\"title\":\"\"},{\"icon\":\"fa-warehouse\",\"color\":\"#0056b3\",\"title\":\"Warehousing\"},{\"icon\":\"fa-arrow-right\",\"color\":\"#adb5bd\",\"title\":\"\"},{\"icon\":\"fa-ship\",\"color\":\"#17a2b8\",\"title\":\"Freight Forward\"},{\"icon\":\"fa-arrow-right\",\"color\":\"#adb5bd\",\"title\":\"\"},{\"icon\":\"fa-truck\",\"color\":\"#ef7e22\",\"title\":\"Last Mile\"},{\"icon\":\"fa-arrow-right\",\"color\":\"#adb5bd\",\"title\":\"\"},{\"icon\":\"fa-house-circle-check\",\"color\":\"#28a745\",\"title\":\"Customer\"}],\"services\":[{\"icon\":\"fa-boxes-stacked\",\"color\":\"#28a745\",\"title\":\"Warehousing & Distribution\",\"desc\":\"Secure, scalable storage solutions with real-time inventory tracking and efficient order fulfillment.\"},{\"icon\":\"fa-truck-fast\",\"color\":\"#0056b3\",\"title\":\"Freight Forwarding\",\"desc\":\"Optimized air, sea, and road freight solutions for domestic and international cargo movements.\"},{\"icon\":\"fa-clipboard-check\",\"color\":\"#ef7e22\",\"title\":\"Supply Chain Consulting\",\"desc\":\"Expert analysis and optimization of your logistics operations to reduce costs and improve efficiency.\"},{\"icon\":\"fa-handshake-angle\",\"color\":\"#17a2b8\",\"title\":\"Customs Brokerage\",\"desc\":\"Seamless customs clearance services to ensure compliance and avoid delays at borders.\"},{\"icon\":\"\",\"color\":\"\",\"title\":\"\",\"desc\":\"\"},{\"icon\":\"\",\"color\":\"\",\"title\":\"\",\"desc\":\"\"}],\"tech\":[{\"icon\":\"fa-qrcode\",\"title\":\"Barcode & QR Tracking\",\"desc\":\"Every shipment tagged and scanned at every touchpoint.\"},{\"icon\":\"fa-cloud\",\"title\":\"Cloud WMS\",\"desc\":\"Web-based warehouse management for real-time inventory.\"},{\"icon\":\"fa-robot\",\"title\":\"Automated Sorting\",\"desc\":\"AI-powered sorting for faster dispatch and fewer errors.\"},{\"icon\":\"fa-mobile-screen\",\"title\":\"Client Portal\",\"desc\":\"Track all orders and reports from a single dashboard.\"}],\"cta_title\":\"Streamline Your Supply Chain\",\"cta_desc\":\"Let our logistics experts design a custom solution for your business needs.\",\"cta_btn_text\":\"Talk to an Expert\",\"cta_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\",\"benefits_title\":\"Logistics Advantages\",\"benefits_list\":[\"End-to-end supply chain visibility\",\"Scalable for all business sizes\",\"Dedicated logistics manager\",\"Cloud-based WMS access\",\"Reverse logistics & returns\",\"ISO-certified warehouses\"],\"benefits_btn_text\":\"Get a Proposal\",\"benefits_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\",\"content_title\":\"Complete Logistics Management\"}'),(4,'why_flystar','Why Choose FlyStar','Your trusted partner in global logistics, delivering excellence with every parcel.','At FlyStar Courier, we go beyond simply moving packages from point A to point B. We build lasting partnerships based on trust, reliability, and unparalleled service quality.\n\nWith our extensive network, cutting-edge technology, and dedicated team of professionals, we ensure that your shipments are handled with the utmost care and delivered efficiently, regardless of the destination.','2026-06-30 15:48:24','2026-06-30 15:48:24','Learn More','#','Contact Us','#contact','15+','Years Experience','10k+','Happy Clients','5M+','Parcels Delivered','50+','Global Partners','{\"features\":[{\"icon\":\"fa-shield-halved\",\"title\":\"Secure Handling\",\"desc\":\"Your parcels are fully insured and handled with strict security protocols.\"},{\"icon\":\"fa-bolt\",\"title\":\"Lightning Fast\",\"desc\":\"Optimized routing and dedicated fleets ensure the fastest possible delivery.\"},{\"icon\":\"fa-headset\",\"title\":\"24\\/7 Support\",\"desc\":\"Our customer care team is always available to assist you with any queries.\"},{\"icon\":\"fa-map-location-dot\",\"title\":\"Live Tracking\",\"desc\":\"Real-time GPS tracking keeps you informed at every step of the journey.\"}],\"timeline\":[{\"year\":\"2008\",\"title\":\"The Beginning\",\"desc\":\"Founded in Hyderabad with a vision to revolutionize local courier services.\"},{\"year\":\"2012\",\"title\":\"National Expansion\",\"desc\":\"Expanded our network to cover all major metro cities across India.\"},{\"year\":\"2015\",\"title\":\"Going Global\",\"desc\":\"Partnered with international giants to offer worldwide delivery solutions.\"},{\"year\":\"2023\",\"title\":\"Tech Integration\",\"desc\":\"Launched our state-of-the-art tracking app and automated sorting hubs.\"}]}'),(5,'vision_mission','Vision & Mission','Our guiding principles that drive everything we do','We envision a connected world where distance is no longer a barrier to business or personal connections. Our mission is to provide seamless, reliable, and affordable logistics solutions that empower our clients to reach new horizons.\n\nBy continuously innovating and upholding the highest standards of service, we aim to be the preferred logistics partner for businesses and individuals worldwide.','2026-06-30 15:48:24','2026-06-30 15:48:24','Learn More','#','Contact Us','#contact',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"vision_pillars\":[{\"icon\":\"fa-rocket\",\"title\":\"Speed & Precision\",\"desc\":\"Express delivery to any destination within 2\\u20135 business days.\"},{\"icon\":\"fa-shield-halved\",\"title\":\"Security First\",\"desc\":\"Every parcel handled with utmost care and real-time tracking.\"},{\"icon\":\"fa-microchip\",\"title\":\"Technology Driven\",\"desc\":\"Cutting-edge logistics systems for seamless global operations.\"},{\"icon\":\"fa-leaf\",\"title\":\"Sustainable Growth\",\"desc\":\"Committed to eco-conscious practices in all our operations.\"}],\"core_values\":[{\"icon\":\"fa-check-circle\",\"label\":\"Quality Service at Your Doorstep\"},{\"icon\":\"fa-check-circle\",\"label\":\"Low Cost & Transparent Pricing\"},{\"icon\":\"fa-check-circle\",\"label\":\"Authenticity in Every Delivery\"},{\"icon\":\"fa-check-circle\",\"label\":\"Consistent Growth for Partners\"},{\"icon\":\"fa-check-circle\",\"label\":\"Innovation & Creative Solutions\"},{\"icon\":\"fa-check-circle\",\"label\":\"Friendly Customer Communication\"}],\"mission_quote\":{\"text\":\"FlyStar is your one-stop destination for distinguished services \\u2014 backed by FEDEX, DHL, UPS & ARAMEX.\",\"author\":\"FlyStar International Couriers, Hyderabad\"},\"stats\":[{\"number\":\"220+\",\"label\":\"Countries\",\"color\":\"#0056b3\",\"bg\":\"#f8faff\",\"border\":\"#e2eaf8\"},{\"number\":\"2\\u20135\",\"label\":\"Day Delivery\",\"color\":\"#ef7e22\",\"bg\":\"#fff8f2\",\"border\":\"#f5e0cc\"},{\"number\":\"4\",\"label\":\"Elite Partners\",\"color\":\"#28a745\",\"bg\":\"#f0fff4\",\"border\":\"#c8ebd4\"},{\"number\":\"24\\/7\",\"label\":\"Support\",\"color\":\"#d4a800\",\"bg\":\"#fffdf0\",\"border\":\"#f0e8b0\"}]}'),(6,'shopping','Shopping Services','Connecting Hyderabad to 220+ countries with speed, precision, and complete peace of mind. Your global courier partner.','Experience the ultimate freedom of global e-commerce with FlyStar\'s Shopping Services. If a store doesn\'t ship to your country or doesn\'t accept your credit card, we step in to make it happen. We purchase, consolidate, and ship your items directly to your doorstep with zero hassle.\r\n\r\nTake advantage of our secure warehouse storage and bundle your purchases to save significantly on international shipping rates. Shop without borders and let us handle the logistics!','2026-07-01 15:13:27','2026-07-01 09:45:27','Start Shopping','','Track Shipment','','','','','','','','','','{\"badge_text\":\"\\u2708 WORLDWIDE COVERAGE\",\"content_title\":\"About Our Shopping Service\",\"services\":[{\"title\":\"Personal Shopper\",\"icon\":\"fa-cart-shopping\",\"color\":\"#0056b3\",\"desc\":\"We shop on your behalf if your card is not accepted.\"},{\"title\":\"Package Consolidation\",\"icon\":\"fa-boxes-packing\",\"color\":\"#ef7e22\",\"desc\":\"Combine multiple orders into one box to save shipping costs.\"},{\"title\":\"Free Storage\",\"icon\":\"fa-warehouse\",\"color\":\"#28a745\",\"desc\":\"Store your items in our warehouse for up to 30 days.\"},{\"title\":\"Package Insurance\",\"icon\":\"fa-shield-halved\",\"color\":\"#17a2b8\",\"desc\":\"Full coverage for loss or damage during transit.\"},{\"title\":\"Express Delivery\",\"icon\":\"fa-truck-fast\",\"color\":\"#6f42c1\",\"desc\":\"Fast and reliable shipping with top courier partners.\"},{\"title\":\"Customs Clearance\",\"icon\":\"fa-file-shield\",\"color\":\"#d63384\",\"desc\":\"Expert customs declaration and clearance assistance.\"}],\"steps\":[{\"number\":\"1\",\"icon\":\"fa-cart-shopping\",\"title\":\"Shop Online\",\"desc\":\"Buy from your favorite stores worldwide\"},{\"number\":\"2\",\"icon\":\"fa-box-archive\",\"title\":\"Consolidate\",\"desc\":\"We receive and store your items securely\"},{\"number\":\"3\",\"icon\":\"fa-plane-departure\",\"title\":\"Ship\",\"desc\":\"We pack and ship to your doorstep\"},{\"number\":\"4\",\"icon\":\"fa-map-location-dot\",\"title\":\"Track Live\",\"desc\":\"Real-time updates at every checkpoint\"},{\"number\":\"5\",\"icon\":\"fa-house-circle-check\",\"title\":\"Delivered\",\"desc\":\"Safe doorstep delivery at destination\"}],\"cta_icon\":\"fa-cart-shopping\",\"cta_title\":\"Ready to Start Shopping?\",\"cta_desc\":\"Get an instant quote. No hidden fees. Just fast, reliable delivery.\",\"cta_btn_text\":\"Contact Us Today\",\"cta_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\",\"benefits_title\":\"Why Choose FlyStar?\",\"benefits_list\":[\"220+ countries covered\",\"Door-to-door delivery\",\"Real-time tracking\",\"Elite courier partners\",\"Competitive pricing\",\"24\\/7 customer support\"],\"benefits_btn_text\":\"Get a Quote\",\"benefits_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\"}'),(7,'personalized_assistance','Personalized Assistance','Connecting Hyderabad to 220+ countries with speed, precision, and complete peace of mind. Your global courier partner.','At FlyStar, we understand that standard logistics don\'t always cover unique or demanding shipments. Our Personalized Assistance service assigns you a dedicated logistics manager who will act as your single point of contact, ensuring every aspect of your shipment is handled with utmost care and precision.\r\n\r\nFrom custom routing and specialized packaging to regulatory navigation and 24/7 priority monitoring, we build a shipping plan that aligns perfectly with your goals. Experience VIP logistics designed exclusively for you.','2026-07-01 15:21:05','2026-07-01 09:55:05','Talk to an Expert','','Track Shipment','','','','','','','','','','{\"badge_text\":\"\\u2708 WORLDWIDE COVERAGE\",\"content_title\":\"About Personalized Assistance\",\"services\":[{\"title\":\"Dedicated Manager\",\"icon\":\"fa-user-tie\",\"color\":\"#0056b3\",\"desc\":\"A single point of contact for all your shipping needs.\"},{\"title\":\"Special Handling\",\"icon\":\"fa-dolly\",\"color\":\"#ef7e22\",\"desc\":\"Fragile, oversized, or high-value item care.\"},{\"title\":\"Route Optimization\",\"icon\":\"fa-map-location\",\"color\":\"#28a745\",\"desc\":\"Custom routing for faster or more secure transit.\"},{\"title\":\"Regulatory Help\",\"icon\":\"fa-scale-balanced\",\"color\":\"#17a2b8\",\"desc\":\"Assistance with complex international shipping laws.\"},{\"title\":\"24\\/7 Priority Support\",\"icon\":\"fa-headset\",\"color\":\"#6f42c1\",\"desc\":\"Round-the-clock assistance for urgent queries.\"},{\"title\":\"Custom Packaging\",\"icon\":\"fa-box-open\",\"color\":\"#d63384\",\"desc\":\"Bespoke packaging solutions for unique items.\"}],\"steps\":[{\"number\":\"1\",\"icon\":\"fa-comments\",\"title\":\"Consultation\",\"desc\":\"Discuss your specific requirements with us\"},{\"number\":\"2\",\"icon\":\"fa-clipboard-list\",\"title\":\"Custom Plan\",\"desc\":\"We create a tailored logistics plan for you\"},{\"number\":\"3\",\"icon\":\"fa-handshake\",\"title\":\"Agreement\",\"desc\":\"Confirm the details and pricing\"},{\"number\":\"4\",\"icon\":\"fa-truck-fast\",\"title\":\"Execution\",\"desc\":\"We handle the entire process smoothly\"},{\"number\":\"5\",\"icon\":\"fa-face-smile\",\"title\":\"Completion\",\"desc\":\"Successful delivery and satisfaction\"}],\"cta_icon\":\"fa-user-tie\",\"cta_title\":\"Need Custom Logistics Solutions?\",\"cta_desc\":\"Talk to our experts for a tailored approach to your unique needs.\",\"cta_btn_text\":\"Contact Us Today\",\"cta_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\",\"benefits_title\":\"Why Choose FlyStar?\",\"benefits_list\":[\"220+ countries covered\",\"Door-to-door delivery\",\"Real-time tracking\",\"Elite courier partners\",\"Competitive pricing\",\"24\\/7 customer support\"],\"benefits_btn_text\":\"Get a Quote\",\"benefits_btn_url\":\"http:\\/\\/localhost\\/flystarcourier\\/public\\/#contact\"}');

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `icon` varchar(50) NOT NULL DEFAULT 'fa-solid fa-box',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'Air Freight','Looking for an international courier service from Hyderabad to anywhere in the world? We offer worldwide courier services with enormous air freight capacity and a strong domestic and international network.',NULL,'assets/images/services/air_freight.png','fa-solid fa-plane','active','2026-06-25 22:58:52','2026-06-25 22:58:52'),(2,'Maritime Freight','Ship securely with our maritime freight service. We ensure your cargo reaches its destination in proper condition, making sea freight an ideal choice for heavy and bulk shipments.',NULL,'assets/images/services/maritime_freight.png','fa-solid fa-ship','active','2026-06-25 22:58:52','2026-06-25 22:58:52'),(3,'Ground Freight','Our ground freight offers cautious transportation for large items. If you need fast-moving and budget-friendly logistics, we are here to help you move cargo across India safely.',NULL,'assets/images/services/ground_freight.png','fa-solid fa-truck','active','2026-06-25 22:58:52','2026-06-25 22:58:52'),(4,'Home Delivery','Recognised for reliability and customer-friendly transportation, our home delivery service brings your couriers to your doorstep in perfect condition, every single time.',NULL,'assets/images/services/home_delivery.png','fa-solid fa-box','active','2026-06-25 22:58:52','2026-06-25 22:58:52'),(5,'E-Commerce','Our e-commerce service covers everything from collecting materials to delivering them in the same condition to your customer, powered by the latest shipping technology.',NULL,'assets/images/services/ecommerce.png','fa-solid fa-cart-shopping','active','2026-06-25 22:58:52','2026-06-25 22:58:52'),(6,'Warehousing','We offer enormous warehouse facilities with essential amenities, helping your firm manage and distribute goods to clients in good condition.',NULL,'assets/images/services/warehousing.png','fa-solid fa-warehouse','active','2026-06-25 22:58:52','2026-06-25 22:58:52');

--
-- Table structure for table `shipments`
--

CREATE TABLE `shipments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) unsigned NOT NULL,
  `delivery_staff_id` int(11) unsigned DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `location` varchar(100) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shipments`
--


--
-- Table structure for table `shippable_items`
--

CREATE TABLE `shippable_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(50) NOT NULL DEFAULT 'fa-solid fa-box',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shippable_items`
--

INSERT INTO `shippable_items` VALUES (1,'Documents','Passports, certificates, legal papers, and business documents.','fa-regular fa-file-lines','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(2,'Medicines','Temperature-safe medicine delivery with prescription support.','fa-solid fa-flask','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(3,'Food Items','Pickles, sweets, snacks, and homemade food for loved ones abroad.','fa-solid fa-cart-shopping','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(4,'Excess Baggage','Cost-effective baggage shipping for students and travelers.','fa-solid fa-briefcase','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(5,'Commercial Cargo','Samples, bulk cargo, and B2B shipments with customs clearance.','fa-solid fa-box','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(6,'Household Items','Furniture, kitchenware, and personal belongings by air or sea.','fa-solid fa-house','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(7,'Gifts & Parcels','Send gifts, personal parcels, and special occasions worldwide.','fa-solid fa-gift','active','2026-06-25 17:22:25','2026-06-25 17:22:25'),(8,'E-Commerce Shipments','Online seller deliveries with tracking and returns support.','fa-solid fa-truck-fast','active','2026-06-25 17:22:25','2026-06-25 17:22:25');

--
-- Table structure for table `support_pages`
--

CREATE TABLE `support_pages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `button1_text` varchar(100) DEFAULT NULL,
  `button1_url` varchar(255) DEFAULT NULL,
  `button2_text` varchar(100) DEFAULT NULL,
  `button2_url` varchar(255) DEFAULT NULL,
  `json_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_name` (`page_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support_pages`
--

INSERT INTO `support_pages` VALUES (1,'customer_support','Customer Support','We are here to help. Whether you have a question about our services or need to report an issue, our team is ready to assist you.','At FlyStar Services, our dedicated customer support team is always ready to assist you. Whether you need help tracking a parcel, scheduling a pickup, or resolving a shipping query, we are just a call or email away.\r\n\r\n### Contact Information\r\n- **Phone:** 1-800-123-4567 (Toll-Free)\r\n- **Email:** info@flystar.in\r\n- **Head Office:** 123 Shipping Lane, Logistics Park, NY 10001\r\n\r\n### Operating Hours\r\n- Monday - Friday: 8:00 AM - 8:00 PM (EST)\r\n- Saturday: 9:00 AM - 5:00 PM (EST)\r\n- Sunday: Closed (Emergency dispatch available)\r\n\r\n### Online Support Ticket\r\nIf your matter is not urgent, you can open a support ticket through your customer dashboard. One of our representatives will review your case and get back to you within 24 hours.','2026-06-29 19:01:37','2026-07-01 10:35:42',NULL,NULL,NULL,NULL,'{\"inquiry_options\":[\"Tracking Issue \\/ Delay\",\"Request a Quote\",\"Service Complaint\",\"Other Information\"],\"contact_infos\":[{\"title\":\"Call Us Directly\",\"value\":\"+91 40 4003 0159\",\"icon\":\"fa-phone\",\"icon_color\":\"text-primary\"},{\"title\":\"Email Us\",\"value\":\"info@flystar.in\",\"icon\":\"fa-envelope\",\"icon_color\":\"text-danger\"}]}'),(2,'faq','Frequently Asked Questions','Find quick answers to common questions about shipping, tracking, payments, and our services.',NULL,'2026-06-29 19:01:37','2026-07-01 10:49:45',NULL,NULL,NULL,NULL,'{\"cta_title\":\"Still have questions?\",\"cta_subtitle\":\"Our support team is just a click away.\",\"cta_button_text\":\"Contact Support\",\"cta_button_url\":\"support\\/customer_support\",\"faqs\":[{\"category\":\"Shipping & Delivery\",\"question\":\"How long does international delivery take?\",\"icon\":\"fa-clock\",\"icon_color\":\"text-primary\",\"answer\":\"Express shipments typically take 3 to 5 business days, depending on the destination city and customs processing speed. Economy options can take 7 to 10 business days.\"},{\"category\":\"Shipping & Delivery\",\"question\":\"How do I track my shipment?\",\"icon\":\"fa-magnifying-glass-location\",\"icon_color\":\"text-success\",\"answer\":\"Once your booking is processed, you will receive a tracking number (e.g. TRK-xxxx). Simply enter this number in the \\\"Track Your Shipment\\\" box on our home page for real-time updates.\"},{\"category\":\"Shipping & Delivery\",\"question\":\"Do you provide packing services?\",\"icon\":\"fa-box\",\"icon_color\":\"text-warning\",\"answer\":\"Yes, we offer professional packaging support at our Hyderabad hub to ensure your items are packed safely and securely in compliance with international airline standards.\"},{\"category\":\"Documents & Compliance\",\"question\":\"What documents are required for shipping?\",\"icon\":\"fa-file-invoice\",\"icon_color\":\"text-info\",\"answer\":\"For individual shipments, a government-approved ID (Passport, Aadhaar Card, or PAN Card) is required. For commercial consignments, GST, IEC, and commercial invoices are mandatory.\"},{\"category\":\"Documents & Compliance\",\"question\":\"Can I ship medicines internationally?\",\"icon\":\"fa-ban\",\"icon_color\":\"text-danger\",\"answer\":\"Yes, however it is strictly regulated. You must provide a valid doctor\'s prescription (in English), original purchase bills, and the consignee\'s details. Some countries strictly prohibit medicine imports, so please check with our team first.\"},{\"category\":\"Documents & Compliance\",\"question\":\"Who pays for customs duties?\",\"icon\":\"fa-money-bill-wave\",\"icon_color\":\"text-success\",\"answer\":\"Standard shipping is done under DDU (Delivered Duty Unpaid) terms, meaning the receiver is responsible for paying any import duties or taxes levied by the destination country\'s customs before delivery.\"}]}'),(3,'international_regulatory','International Regulatory Compliance',NULL,'Navigating international borders requires strict adherence to customs regulations, import/export laws, and international trade compliance. FlyStar Services provides expert guidance to ensure your global shipments clear customs smoothly and without unnecessary delays.\r\n\r\n### Commercial Invoices\r\nEvery international shipment containing goods (non-documents) must be accompanied by a commercial invoice. This document is the primary declaration used by customs authorities to assess duties and taxes. It must accurately detail the sender and receiver\'s information, a precise description of the goods, their country of origin, and their true commercial value.\r\n\r\n### Duties, Taxes, and Tariffs\r\nCustoms duties and taxes are determined by the destination country based on the type of goods and their declared value. Unless otherwise specified (such as a DDP - Delivered Duty Paid shipment), the receiver is typically responsible for paying these charges before the package is released by customs.\r\n\r\n### Restricted Commodities & Licensing\r\nCertain goods may be legally exported from your country but heavily restricted or completely banned in the destination country. Common examples include agricultural products, pharmaceuticals, telecommunications equipment, and certain textiles. Some items may require specific import licenses or permits. It is the shipper\'s responsibility to verify that the item is permissible in the destination country.\r\n\r\n### Electronic Export Information (EEI)\r\nFor high-value commercial shipments, an EEI filing may be legally required before export. Our regulatory team can assist you in filing the necessary declarations to ensure full compliance with international trade laws.','2026-06-29 19:01:37','2026-06-30 05:14:24',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `time_posted` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,'Devon Lane','3 months ago','We\'ve been working with FlyStar Courier for years, and they continue to deliver outstanding results. Their team is proactive and always goes the extra mile.','active','2026-06-30 18:10:24','2026-06-30 18:10:24'),(2,'Eleanor Pena','1 week ago','FlyStar provided the fastest shipping to London. My parcel arrived safely and on time! Highly recommended.','active','2026-06-30 18:11:35','2026-06-30 18:11:35'),(4,'lasya','2 months ago','received ','active','2026-06-30 12:50:51','2026-06-30 12:50:51');

--
-- Table structure for table `why_choose_features`
--

CREATE TABLE `why_choose_features` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(50) NOT NULL,
  `color` varchar(50) NOT NULL DEFAULT 'primary',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `why_choose_features`
--

INSERT INTO `why_choose_features` VALUES (1,'Fastest Delivery','Express 5-7 days to major countries.','fa-solid fa-box-open','warning','active','2026-06-25 17:35:21','2026-06-25 17:35:21'),(2,'24/7 Support','Call, WhatsApp, or email anytime.','fa-solid fa-headset','primary','active','2026-06-25 17:35:21','2026-06-25 17:35:21'),(3,'Safe & Insured','Secure packaging and shipment protection.','fa-solid fa-shield-halved','success','active','2026-06-25 17:35:21','2026-06-25 17:35:21'),(4,'Live Tracking','Track your parcel in real time.','fa-solid fa-clock-rotate-left','danger','active','2026-06-25 17:35:21','2026-06-25 17:35:21'),(5,'220+ Countries','Global coverage with local expertise.','fa-solid fa-truck-fast','warning','active','2026-06-25 17:35:21','2026-06-25 17:35:21'),(6,'Import Services','Import clearance and door delivery.','fa-solid fa-box','danger','active','2026-06-25 17:35:21','2026-06-25 17:35:21');


