-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 29, 2026 at 08:05 AM
-- Server version: 11.8.9-MariaDB-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u427169110_lucky2sdb`
--

-- --------------------------------------------------------

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `slug`, `title`, `excerpt`, `body`, `image_path`, `author_name`, `published_at`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'blog-post-1', 'Seasonal lawn tips #1', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', 'blog/01KS2YZFCP93QBRY258SDJBEGN.jpeg', 'Lucky2s Team', '2026-05-19 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 15:10:00'),
(2, 'blog-post-2', 'Seasonal lawn tips #2', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', NULL, 'Lucky2s Team', '2026-05-18 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'blog-post-3', 'Seasonal lawn tips #3', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', NULL, 'Lucky2s Team', '2026-05-17 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(4, 'blog-post-4', 'Seasonal lawn tips #4', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', NULL, 'Lucky2s Team', '2026-05-16 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(5, 'blog-post-5', 'Seasonal lawn tips #5', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', NULL, 'Lucky2s Team', '2026-05-15 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(6, 'blog-post-6', 'Seasonal lawn tips #6', 'Simple maintenance ideas that keep turf healthy through changing weather.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>', NULL, 'Lucky2s Team', '2026-05-14 14:38:42', 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `bookings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference` varchar(64) NOT NULL,
  `service_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'awaiting_schedule',
  `scheduled_at` timestamp NULL DEFAULT NULL,
  `calendly_event_uri` varchar(255) DEFAULT NULL,
  `calendly_invitee_uri` varchar(255) DEFAULT NULL,
  `calendly_payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`calendly_payload`)),
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `confirmed_at` timestamp NULL DEFAULT NULL,
  `canceled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('356a192b7913b04c54574d18c28d46e6395428ab', 'i:1;', 1779289858),
('356a192b7913b04c54574d18c28d46e6395428ab:timer', 'i:1779289858;', 1779289858),
('e9fcfe799d7c9d0a235084696184cad9b063ad40', 'i:1;', 1779289758),
('e9fcfe799d7c9d0a235084696184cad9b063ad40:timer', 'i:1779289758;', 1779289758),
('livewire-rate-limiter:1a11d40847fafcabe11d3622ae3f177904337e8c', 'i:1;', 1780427569),
('livewire-rate-limiter:1a11d40847fafcabe11d3622ae3f177904337e8c:timer', 'i:1780427569;', 1780427569),
('livewire-rate-limiter:9e518d57063a44af08ef196b547558c98411adcf', 'i:1;', 1779288777),
('livewire-rate-limiter:9e518d57063a44af08ef196b547558c98411adcf:timer', 'i:1779288777;', 1779288777),
('spatie.permission.cache', 'a:3:{s:5:\"alias\";a:5:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:10:\"guard_name\";s:1:\"r\";s:5:\"roles\";s:1:\"j\";s:12:\"display_name\";}s:11:\"permissions\";a:161:{i:0;a:4:{s:1:\"a\";i:1;s:1:\"b\";s:15:\"view_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:1;a:4:{s:1:\"a\";i:2;s:1:\"b\";s:19:\"view_any_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:2;a:4:{s:1:\"a\";i:3;s:1:\"b\";s:17:\"create_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:3;a:4:{s:1:\"a\";i:4;s:1:\"b\";s:17:\"update_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:4;a:4:{s:1:\"a\";i:5;s:1:\"b\";s:18:\"restore_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:5;a:4:{s:1:\"a\";i:6;s:1:\"b\";s:22:\"restore_any_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:6;a:4:{s:1:\"a\";i:7;s:1:\"b\";s:20:\"replicate_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:7;a:4:{s:1:\"a\";i:8;s:1:\"b\";s:18:\"reorder_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:8;a:4:{s:1:\"a\";i:9;s:1:\"b\";s:17:\"delete_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:9;a:4:{s:1:\"a\";i:10;s:1:\"b\";s:21:\"delete_any_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:10;a:4:{s:1:\"a\";i:11;s:1:\"b\";s:23:\"force_delete_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:11;a:4:{s:1:\"a\";i:12;s:1:\"b\";s:27:\"force_delete_any_blog::post\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:12;a:4:{s:1:\"a\";i:13;s:1:\"b\";s:12:\"view_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:13;a:4:{s:1:\"a\";i:14;s:1:\"b\";s:16:\"view_any_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:14;a:4:{s:1:\"a\";i:15;s:1:\"b\";s:14:\"create_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:15;a:4:{s:1:\"a\";i:16;s:1:\"b\";s:14:\"update_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:16;a:4:{s:1:\"a\";i:17;s:1:\"b\";s:15:\"restore_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:17;a:4:{s:1:\"a\";i:18;s:1:\"b\";s:19:\"restore_any_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:18;a:4:{s:1:\"a\";i:19;s:1:\"b\";s:17:\"replicate_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:19;a:4:{s:1:\"a\";i:20;s:1:\"b\";s:15:\"reorder_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:20;a:4:{s:1:\"a\";i:21;s:1:\"b\";s:14:\"delete_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:21;a:4:{s:1:\"a\";i:22;s:1:\"b\";s:18:\"delete_any_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:22;a:4:{s:1:\"a\";i:23;s:1:\"b\";s:20:\"force_delete_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:23;a:4:{s:1:\"a\";i:24;s:1:\"b\";s:24:\"force_delete_any_booking\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:24;a:4:{s:1:\"a\";i:25;s:1:\"b\";s:24:\"view_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:25;a:4:{s:1:\"a\";i:26;s:1:\"b\";s:28:\"view_any_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:26;a:4:{s:1:\"a\";i:27;s:1:\"b\";s:26:\"create_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:27;a:4:{s:1:\"a\";i:28;s:1:\"b\";s:26:\"update_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:28;a:4:{s:1:\"a\";i:29;s:1:\"b\";s:27:\"restore_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:29;a:4:{s:1:\"a\";i:30;s:1:\"b\";s:31:\"restore_any_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:30;a:4:{s:1:\"a\";i:31;s:1:\"b\";s:29:\"replicate_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:31;a:4:{s:1:\"a\";i:32;s:1:\"b\";s:27:\"reorder_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:32;a:4:{s:1:\"a\";i:33;s:1:\"b\";s:26:\"delete_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:33;a:4:{s:1:\"a\";i:34;s:1:\"b\";s:30:\"delete_any_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:34;a:4:{s:1:\"a\";i:35;s:1:\"b\";s:32:\"force_delete_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:35;a:4:{s:1:\"a\";i:36;s:1:\"b\";s:36:\"force_delete_any_career::application\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:36;a:4:{s:1:\"a\";i:37;s:1:\"b\";s:18:\"view_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:37;a:4:{s:1:\"a\";i:38;s:1:\"b\";s:22:\"view_any_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:38;a:4:{s:1:\"a\";i:39;s:1:\"b\";s:20:\"create_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:39;a:4:{s:1:\"a\";i:40;s:1:\"b\";s:20:\"update_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:40;a:4:{s:1:\"a\";i:41;s:1:\"b\";s:21:\"restore_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:41;a:4:{s:1:\"a\";i:42;s:1:\"b\";s:25:\"restore_any_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:42;a:4:{s:1:\"a\";i:43;s:1:\"b\";s:23:\"replicate_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:43;a:4:{s:1:\"a\";i:44;s:1:\"b\";s:21:\"reorder_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:44;a:4:{s:1:\"a\";i:45;s:1:\"b\";s:20:\"delete_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:45;a:4:{s:1:\"a\";i:46;s:1:\"b\";s:24:\"delete_any_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:46;a:4:{s:1:\"a\";i:47;s:1:\"b\";s:26:\"force_delete_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:47;a:4:{s:1:\"a\";i:48;s:1:\"b\";s:30:\"force_delete_any_dynamic::page\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:48;a:4:{s:1:\"a\";i:49;s:1:\"b\";s:12:\"view_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:49;a:4:{s:1:\"a\";i:50;s:1:\"b\";s:16:\"view_any_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:50;a:4:{s:1:\"a\";i:51;s:1:\"b\";s:14:\"create_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:51;a:4:{s:1:\"a\";i:52;s:1:\"b\";s:14:\"update_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:52;a:4:{s:1:\"a\";i:53;s:1:\"b\";s:15:\"restore_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:53;a:4:{s:1:\"a\";i:54;s:1:\"b\";s:19:\"restore_any_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:54;a:4:{s:1:\"a\";i:55;s:1:\"b\";s:17:\"replicate_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:55;a:4:{s:1:\"a\";i:56;s:1:\"b\";s:15:\"reorder_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:56;a:4:{s:1:\"a\";i:57;s:1:\"b\";s:14:\"delete_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:57;a:4:{s:1:\"a\";i:58;s:1:\"b\";s:18:\"delete_any_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:58;a:4:{s:1:\"a\";i:59;s:1:\"b\";s:20:\"force_delete_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:59;a:4:{s:1:\"a\";i:60;s:1:\"b\";s:24:\"force_delete_any_enquiry\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:60;a:4:{s:1:\"a\";i:61;s:1:\"b\";s:16:\"view_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:61;a:4:{s:1:\"a\";i:62;s:1:\"b\";s:20:\"view_any_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:62;a:4:{s:1:\"a\";i:63;s:1:\"b\";s:18:\"create_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:63;a:4:{s:1:\"a\";i:64;s:1:\"b\";s:18:\"update_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:64;a:4:{s:1:\"a\";i:65;s:1:\"b\";s:19:\"restore_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:65;a:4:{s:1:\"a\";i:66;s:1:\"b\";s:23:\"restore_any_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:66;a:4:{s:1:\"a\";i:67;s:1:\"b\";s:21:\"replicate_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:67;a:4:{s:1:\"a\";i:68;s:1:\"b\";s:19:\"reorder_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:68;a:4:{s:1:\"a\";i:69;s:1:\"b\";s:18:\"delete_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:69;a:4:{s:1:\"a\";i:70;s:1:\"b\";s:22:\"delete_any_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:70;a:4:{s:1:\"a\";i:71;s:1:\"b\";s:24:\"force_delete_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:71;a:4:{s:1:\"a\";i:72;s:1:\"b\";s:28:\"force_delete_any_hero::slide\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:72;a:4:{s:1:\"a\";i:73;s:1:\"b\";s:17:\"view_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:73;a:4:{s:1:\"a\";i:74;s:1:\"b\";s:21:\"view_any_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:74;a:4:{s:1:\"a\";i:75;s:1:\"b\";s:19:\"create_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:75;a:4:{s:1:\"a\";i:76;s:1:\"b\";s:19:\"update_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:76;a:4:{s:1:\"a\";i:77;s:1:\"b\";s:20:\"restore_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:77;a:4:{s:1:\"a\";i:78;s:1:\"b\";s:24:\"restore_any_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:78;a:4:{s:1:\"a\";i:79;s:1:\"b\";s:22:\"replicate_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:79;a:4:{s:1:\"a\";i:80;s:1:\"b\";s:20:\"reorder_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:80;a:4:{s:1:\"a\";i:81;s:1:\"b\";s:19:\"delete_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:81;a:4:{s:1:\"a\";i:82;s:1:\"b\";s:23:\"delete_any_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:82;a:4:{s:1:\"a\";i:83;s:1:\"b\";s:25:\"force_delete_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:83;a:4:{s:1:\"a\";i:84;s:1:\"b\";s:29:\"force_delete_any_job::opening\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:84;a:4:{s:1:\"a\";i:85;s:1:\"b\";s:15:\"view_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:85;a:4:{s:1:\"a\";i:86;s:1:\"b\";s:19:\"view_any_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:86;a:4:{s:1:\"a\";i:87;s:1:\"b\";s:17:\"create_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:87;a:4:{s:1:\"a\";i:88;s:1:\"b\";s:17:\"update_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:88;a:4:{s:1:\"a\";i:89;s:1:\"b\";s:18:\"restore_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:89;a:4:{s:1:\"a\";i:90;s:1:\"b\";s:22:\"restore_any_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:90;a:4:{s:1:\"a\";i:91;s:1:\"b\";s:20:\"replicate_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:91;a:4:{s:1:\"a\";i:92;s:1:\"b\";s:18:\"reorder_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:92;a:4:{s:1:\"a\";i:93;s:1:\"b\";s:17:\"delete_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:93;a:4:{s:1:\"a\";i:94;s:1:\"b\";s:21:\"delete_any_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:94;a:4:{s:1:\"a\";i:95;s:1:\"b\";s:23:\"force_delete_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:95;a:4:{s:1:\"a\";i:96;s:1:\"b\";s:27:\"force_delete_any_menu::item\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:96;a:4:{s:1:\"a\";i:97;s:1:\"b\";s:12:\"view_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:97;a:4:{s:1:\"a\";i:98;s:1:\"b\";s:16:\"view_any_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:98;a:4:{s:1:\"a\";i:99;s:1:\"b\";s:14:\"create_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:99;a:4:{s:1:\"a\";i:100;s:1:\"b\";s:14:\"update_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:100;a:4:{s:1:\"a\";i:101;s:1:\"b\";s:15:\"restore_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:101;a:4:{s:1:\"a\";i:102;s:1:\"b\";s:19:\"restore_any_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:102;a:4:{s:1:\"a\";i:103;s:1:\"b\";s:17:\"replicate_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:103;a:4:{s:1:\"a\";i:104;s:1:\"b\";s:15:\"reorder_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:104;a:4:{s:1:\"a\";i:105;s:1:\"b\";s:14:\"delete_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:105;a:4:{s:1:\"a\";i:106;s:1:\"b\";s:18:\"delete_any_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:106;a:4:{s:1:\"a\";i:107;s:1:\"b\";s:20:\"force_delete_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:107;a:4:{s:1:\"a\";i:108;s:1:\"b\";s:24:\"force_delete_any_project\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:108;a:4:{s:1:\"a\";i:109;s:1:\"b\";s:9:\"view_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:109;a:4:{s:1:\"a\";i:110;s:1:\"b\";s:13:\"view_any_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:110;a:4:{s:1:\"a\";i:111;s:1:\"b\";s:11:\"create_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:111;a:4:{s:1:\"a\";i:112;s:1:\"b\";s:11:\"update_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:112;a:4:{s:1:\"a\";i:113;s:1:\"b\";s:11:\"delete_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:113;a:4:{s:1:\"a\";i:114;s:1:\"b\";s:15:\"delete_any_role\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:114;a:4:{s:1:\"a\";i:115;s:1:\"b\";s:12:\"view_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:115;a:4:{s:1:\"a\";i:116;s:1:\"b\";s:16:\"view_any_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:116;a:4:{s:1:\"a\";i:117;s:1:\"b\";s:14:\"create_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:117;a:4:{s:1:\"a\";i:118;s:1:\"b\";s:14:\"update_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:118;a:4:{s:1:\"a\";i:119;s:1:\"b\";s:15:\"restore_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:119;a:4:{s:1:\"a\";i:120;s:1:\"b\";s:19:\"restore_any_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:120;a:4:{s:1:\"a\";i:121;s:1:\"b\";s:17:\"replicate_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:121;a:4:{s:1:\"a\";i:122;s:1:\"b\";s:15:\"reorder_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:122;a:4:{s:1:\"a\";i:123;s:1:\"b\";s:14:\"delete_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:123;a:4:{s:1:\"a\";i:124;s:1:\"b\";s:18:\"delete_any_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:124;a:4:{s:1:\"a\";i:125;s:1:\"b\";s:20:\"force_delete_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:125;a:4:{s:1:\"a\";i:126;s:1:\"b\";s:24:\"force_delete_any_service\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:126;a:4:{s:1:\"a\";i:127;s:1:\"b\";s:16:\"view_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:127;a:4:{s:1:\"a\";i:128;s:1:\"b\";s:20:\"view_any_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:128;a:4:{s:1:\"a\";i:129;s:1:\"b\";s:18:\"create_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:129;a:4:{s:1:\"a\";i:130;s:1:\"b\";s:18:\"update_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:130;a:4:{s:1:\"a\";i:131;s:1:\"b\";s:19:\"restore_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:131;a:4:{s:1:\"a\";i:132;s:1:\"b\";s:23:\"restore_any_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:132;a:4:{s:1:\"a\";i:133;s:1:\"b\";s:21:\"replicate_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:133;a:4:{s:1:\"a\";i:134;s:1:\"b\";s:19:\"reorder_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:134;a:4:{s:1:\"a\";i:135;s:1:\"b\";s:18:\"delete_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:135;a:4:{s:1:\"a\";i:136;s:1:\"b\";s:22:\"delete_any_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:136;a:4:{s:1:\"a\";i:137;s:1:\"b\";s:24:\"force_delete_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:137;a:4:{s:1:\"a\";i:138;s:1:\"b\";s:28:\"force_delete_any_testimonial\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:138;a:4:{s:1:\"a\";i:139;s:1:\"b\";s:9:\"view_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:139;a:4:{s:1:\"a\";i:140;s:1:\"b\";s:13:\"view_any_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:140;a:4:{s:1:\"a\";i:141;s:1:\"b\";s:11:\"create_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:141;a:4:{s:1:\"a\";i:142;s:1:\"b\";s:11:\"update_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:142;a:4:{s:1:\"a\";i:143;s:1:\"b\";s:12:\"restore_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:143;a:4:{s:1:\"a\";i:144;s:1:\"b\";s:16:\"restore_any_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:144;a:4:{s:1:\"a\";i:145;s:1:\"b\";s:14:\"replicate_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:145;a:4:{s:1:\"a\";i:146;s:1:\"b\";s:12:\"reorder_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:146;a:4:{s:1:\"a\";i:147;s:1:\"b\";s:11:\"delete_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:147;a:4:{s:1:\"a\";i:148;s:1:\"b\";s:15:\"delete_any_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:148;a:4:{s:1:\"a\";i:149;s:1:\"b\";s:17:\"force_delete_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:149;a:4:{s:1:\"a\";i:150;s:1:\"b\";s:21:\"force_delete_any_user\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:150;a:4:{s:1:\"a\";i:151;s:1:\"b\";s:20:\"page_ManageAboutPage\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:151;a:4:{s:1:\"a\";i:152;s:1:\"b\";s:22:\"page_ManageCareersPage\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:152;a:4:{s:1:\"a\";i:153;s:1:\"b\";s:22:\"page_ManageContactPage\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:153;a:4:{s:1:\"a\";i:154;s:1:\"b\";s:19:\"page_ManageHomePage\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:154;a:4:{s:1:\"a\";i:155;s:1:\"b\";s:23:\"page_ManageServicesPage\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:155;a:4:{s:1:\"a\";i:156;s:1:\"b\";s:23:\"page_ManageSiteSettings\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:156;a:4:{s:1:\"a\";i:157;s:1:\"b\";s:26:\"widget_OverviewStatsWidget\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:157;a:4:{s:1:\"a\";i:158;s:1:\"b\";s:29:\"widget_EnquiriesOverviewChart\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:158;a:4:{s:1:\"a\";i:159;s:1:\"b\";s:28:\"widget_RecentEnquiriesWidget\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:159;a:4:{s:1:\"a\";i:160;s:1:\"b\";s:31:\"widget_RecentApplicationsWidget\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:160;a:4:{s:1:\"a\";i:161;s:1:\"b\";s:27:\"widget_RecentBookingsWidget\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}}s:5:\"roles\";a:1:{i:0;a:4:{s:1:\"a\";i:1;s:1:\"b\";s:11:\"super_admin\";s:1:\"j\";s:11:\"Super Admin\";s:1:\"c\";s:3:\"web\";}}}', 1779375412);

-- --------------------------------------------------------

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

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `career_applications`
--

CREATE TABLE `career_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `cv_path` varchar(255) NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `enquiries`
--

CREATE TABLE `enquiries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `service_id` bigint(20) UNSIGNED DEFAULT NULL,
  `message` text NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hero_slides`
--

CREATE TABLE `hero_slides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `alt_text` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hero_slides`
--

INSERT INTO `hero_slides` (`id`, `image_path`, `alt_text`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'hero/01KS2YN416Y9KJR5RCZPSS4JE8.jpeg', 'Hero slide 1', 0, 1, '2026-05-20 14:38:42', '2026-05-20 15:04:20'),
(2, 'hero/01KS2YS69GYQAQ1JSZGT5VBT93.jpeg', 'Hero slide 2', 1, 1, '2026-05-20 14:38:42', '2026-05-20 15:06:34'),
(3, NULL, 'Hero slide 3', 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_openings`
--

CREATE TABLE `job_openings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `employment_type` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_openings`
--

INSERT INTO `job_openings` (`id`, `title`, `employment_type`, `location`, `description`, `sort_order`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'Landscape Technician', 'Full Time', 'Austin, TX', 'Handle mowing, trimming, and seasonal maintenance on client properties.', 0, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(2, 'Yard Maintenance Helper', 'Seasonal', 'Austin, TX', 'Support the crew with cleanup, materials, and property care throughout the season.', 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `location` varchar(32) NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `label` varchar(255) NOT NULL,
  `link_type` varchar(16) NOT NULL DEFAULT 'route',
  `route_name` varchar(255) DEFAULT NULL,
  `route_params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`route_params`)),
  `url` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_visible` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `location`, `parent_id`, `label`, `link_type`, `route_name`, `route_params`, `url`, `sort_order`, `is_visible`, `created_at`, `updated_at`) VALUES
(1, 'header', NULL, 'Home', 'route', 'home', NULL, NULL, 0, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(2, 'header', NULL, 'About Us', 'route', 'about', NULL, NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'header', NULL, 'Services', 'route', 'services', NULL, NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(4, 'header', NULL, 'Careers', 'route', 'careers', NULL, NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(5, 'header', NULL, 'Contact', 'route', 'contact', NULL, NULL, 4, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(6, 'footer_quick', NULL, 'Home', 'route', 'home', NULL, NULL, 0, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(7, 'footer_quick', NULL, 'About Us', 'route', 'about', NULL, NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(8, 'footer_quick', NULL, 'Services', 'route', 'services', NULL, NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(9, 'footer_quick', NULL, 'Careers', 'route', 'careers', NULL, NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(10, 'footer_quick', NULL, 'Contact', 'route', 'contact', NULL, NULL, 4, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(11, 'footer_services', NULL, 'Lawn Care', 'route', 'services.show', '{\"service\":\"lawn-care\"}', NULL, 0, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(12, 'footer_services', NULL, 'Branch Trimming', 'route', 'services.show', '{\"service\":\"branch-trimming\"}', NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(13, 'footer_services', NULL, 'Leaf Removing', 'route', 'services.show', '{\"service\":\"leaf-removing\"}', NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(14, 'footer_services', NULL, 'Mowing', 'route', 'services.show', '{\"service\":\"mowing\"}', NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(15, 'footer_services', NULL, 'Snow Services', 'route', 'services.show', '{\"service\":\"snow-services\"}', NULL, 4, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_05_20_071543_create_permission_tables', 1),
(5, '2026_05_20_080000_create_cms_tables', 1),
(6, '2026_05_20_120000_add_detail_fields_to_projects_table', 1),
(7, '2026_05_20_120000_add_display_name_to_roles_table', 1),
(8, '2026_05_20_120000_create_bookings_table', 1),
(9, '2026_05_20_130000_add_admin_logo_path_to_site_settings_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `template` varchar(32) NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sections` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sections`)),
  `body` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `slug`, `title`, `template`, `meta_title`, `meta_description`, `is_published`, `parent_id`, `sections`, `body`, `created_at`, `updated_at`) VALUES
(1, 'home', 'Home', 'home', NULL, NULL, 1, NULL, '{\"hero\":{\"label\":null,\"title\":null,\"intro\":null,\"image\":null},\"about\":{\"label\":\"About Lucky2s Landscaping\",\"title\":\"We keep outdoor spaces sharp, healthy, and ready to enjoy.\",\"badge_text\":\"About\\nLucky2s\\nLandscaping\",\"left_image\":\"pages\\/home\\/01KS2YXMTQ54JSFWTQR6XHYYAF.jpeg\",\"right_image\":\"pages\\/home\\/01KS2YXMTRAS4VT4GJPW99PXBF.jpeg\",\"features\":[{\"icon\":\"bi-droplet-half\",\"title\":\"Healthy lawns\",\"body\":\"Programs built around your turf, soil, and seasonal needs.\"},{\"icon\":\"bi-globe2\",\"title\":\"Reliable scheduling\",\"body\":\"Clear communication and consistent visits you can count on.\"}]},\"services_intro\":{\"label\":\"Our Services\",\"title\":\"Best Provide Services\"},\"projects_intro\":{\"label\":\"Our Projects\",\"title\":\"Finished the Latest Projects\\nWorks\"},\"testimonials_intro\":{\"label\":\"Our Testimonials\",\"title\":\"Client Testimonials\"},\"contact_intro\":{\"label\":\"Contact Us\",\"title\":\"Contact Us\"},\"blog_intro\":{\"label\":\"Latest Blog\",\"title\":\"Building a Greener Future\\nTogether Forever\"}}', NULL, '2026-05-20 14:38:42', '2026-05-20 15:09:00'),
(2, 'about', 'About Us', 'about', NULL, NULL, 1, NULL, '{\"hero\":{\"label\":\"About Us\",\"title\":\"A trusted landscaping team built around care, precision, and reliability.\",\"intro\":\"We design and maintain outdoor spaces that feel polished, healthy, and welcoming. Our approach blends craftsmanship with friendly service, so every yard gets the attention it deserves.\"},\"story\":{\"label\":\"Our Story\",\"title\":\"We keep outdoor spaces sharp, healthy, and ready to enjoy.\",\"body\":\"From lawn care and trimming to seasonal maintenance, we focus on the details that make a property feel well cared for. Every visit is handled with consistency, good communication, and professional pride.\",\"badge_text\":\"About\\nLucky2s\\nLandscaping\",\"highlights\":[{\"icon\":\"bi-check2-circle\",\"title\":\"Skilled crew\",\"text\":\"Experienced landscapers who know how to work efficiently and cleanly.\"},{\"icon\":\"bi-leaf\",\"title\":\"Healthy results\",\"text\":\"Maintenance choices that support long-term lawn health and curb appeal.\"},{\"icon\":\"bi-star\",\"title\":\"Reliable service\",\"text\":\"We show up on time, follow through, and keep projects moving smoothly.\"}]},\"values\":{\"label\":\"What We Stand For\",\"title\":\"The values behind every property we touch.\",\"items\":[{\"icon\":\"bi-gear-wide-connected\",\"title\":\"Precision\",\"text\":\"Careful work and tidy finishes help every space look intentional and well maintained.\"},{\"icon\":\"bi-shield-check\",\"title\":\"Dependability\",\"text\":\"Our clients count on us for punctual visits, clear updates, and dependable results.\"},{\"icon\":\"bi-tree\",\"title\":\"Sustainability\",\"text\":\"We prefer methods that support healthier landscapes and responsible outdoor care.\"},{\"icon\":\"bi-people\",\"title\":\"Service\",\"text\":\"We treat each property like it is our own and each client like a long-term partner.\"}]},\"stats\":{\"label\":\"At A Glance\",\"title\":\"A small team with a strong reputation for outdoor care.\",\"items\":[{\"value\":\"250+\",\"label\":\"Projects completed\"},{\"value\":\"98%\",\"label\":\"Client satisfaction\"},{\"value\":\"12+\",\"label\":\"Years of experience\"}]}}', NULL, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'services', 'Services', 'services', NULL, NULL, 1, NULL, '{\"hero\":{\"label\":\"Services\",\"title\":\"Complete outdoor care for lawns, trees, and seasonal maintenance.\",\"intro\":\"We handle the routine work that keeps yards looking polished, healthy, and ready for every season.\"},\"grid\":{\"label\":\"What We Offer\",\"title\":\"Reliable services tailored to your property.\"},\"special\":{\"text\":\"Precision care, dependable scheduling, and a strong finish on every visit.\",\"badge_text\":\"Lucky2s\\nLandscaping\"},\"process\":{\"label\":\"Our Process\",\"title\":\"Simple steps, dependable results.\",\"steps\":[{\"title\":\"Consultation\",\"text\":\"We assess your property, listen to priorities, and outline the right service plan.\"},{\"title\":\"Scheduled Care\",\"text\":\"We arrive on time and complete the work efficiently with a clean, careful finish.\"},{\"title\":\"Ongoing Support\",\"text\":\"We can maintain your landscape throughout the year so it stays healthy and polished.\"}]},\"cta\":{\"label\":\"Need Something Specific?\",\"title\":\"Tell us what your property needs and we\\u2019ll shape the service around it.\",\"body\":\"From a one-time cleanup to regular maintenance, we can build a plan that fits your space and schedule.\",\"button_text\":\"Request a Quote\"}}', NULL, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(4, 'contact', 'Contact', 'contact', NULL, NULL, 1, NULL, '{\"hero\":{\"label\":\"Contact\",\"title\":\"Let\\u2019s talk about your next lawn care or landscaping project.\",\"intro\":\"We\\u2019re happy to answer questions, provide estimates, and help you find the right service plan.\"},\"form\":{\"label\":\"Send an Inquiry\",\"title\":\"Get in touch with our team.\"},\"faq\":{\"label\":\"FAQ\",\"title\":\"A few quick answers before you reach out.\",\"items\":[{\"question\":\"Do you offer one-time or recurring service?\",\"answer\":\"Yes, we can help with both single visits and scheduled maintenance plans.\"},{\"question\":\"Can I request a quote online?\",\"answer\":\"Absolutely. Fill out the form and we\\u2019ll get back to you with the next steps.\"},{\"question\":\"What areas do you serve?\",\"answer\":\"We currently serve Austin and the surrounding neighborhoods.\"}]}}', NULL, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(5, 'careers', 'Careers', 'careers', NULL, NULL, 1, NULL, '{\"hero\":{\"label\":\"Careers\",\"title\":\"Build a career outdoors with a team that values reliability and craftsmanship.\",\"intro\":\"We\\u2019re looking for dependable people who care about quality work, customer service, and doing the job right.\"},\"benefits\":{\"label\":\"Why Work With Us\",\"title\":\"A small company with room to grow.\",\"items\":[{\"icon\":\"bi-cash-coin\",\"title\":\"Fair pay\",\"text\":\"Competitive compensation with room to grow as you build experience.\"},{\"icon\":\"bi-clock-history\",\"title\":\"Reliable schedule\",\"text\":\"Clear workdays and predictable planning so the team can stay organized.\"},{\"icon\":\"bi-award\",\"title\":\"Skill growth\",\"text\":\"Learn practical landscaping techniques and build a career with real value.\"},{\"icon\":\"bi-people\",\"title\":\"Supportive team\",\"text\":\"Work with people who care about good work, safety, and respect on the job.\"}]},\"openings\":{\"label\":\"Open Positions\",\"title\":\"Find the role that fits your strengths.\"},\"cta\":{\"label\":\"Want To Join Us?\",\"title\":\"Send us your CV and we\\u2019ll get back to you quickly.\",\"body\":\"Tell us about your experience, the type of work you enjoy, and why you\\u2019d like to join the team.\",\"button_text\":\"Upload CV\"},\"apply\":{\"label\":\"Upload CV\",\"title\":\"Apply online\"}}', NULL, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(6, 'privacy-policy', 'Privacy Policy', 'flex', NULL, NULL, 1, NULL, NULL, '<p>This is placeholder privacy policy content. Replace it in the admin panel.</p>', '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(7, 'terms-of-service', 'Terms of Service', 'flex', NULL, NULL, 1, NULL, NULL, '<p>This is placeholder terms content. Replace it in the admin panel.</p>', '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'view_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(2, 'view_any_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(3, 'create_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(4, 'update_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(5, 'restore_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(6, 'restore_any_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(7, 'replicate_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(8, 'reorder_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(9, 'delete_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(10, 'delete_any_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(11, 'force_delete_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(12, 'force_delete_any_blog::post', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(13, 'view_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(14, 'view_any_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(15, 'create_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(16, 'update_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(17, 'restore_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(18, 'restore_any_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(19, 'replicate_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(20, 'reorder_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(21, 'delete_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(22, 'delete_any_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(23, 'force_delete_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(24, 'force_delete_any_booking', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(25, 'view_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(26, 'view_any_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(27, 'create_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(28, 'update_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(29, 'restore_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(30, 'restore_any_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(31, 'replicate_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(32, 'reorder_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(33, 'delete_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(34, 'delete_any_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(35, 'force_delete_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(36, 'force_delete_any_career::application', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(37, 'view_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(38, 'view_any_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(39, 'create_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(40, 'update_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(41, 'restore_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(42, 'restore_any_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(43, 'replicate_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(44, 'reorder_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(45, 'delete_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(46, 'delete_any_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(47, 'force_delete_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(48, 'force_delete_any_dynamic::page', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(49, 'view_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(50, 'view_any_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(51, 'create_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(52, 'update_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(53, 'restore_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(54, 'restore_any_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(55, 'replicate_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(56, 'reorder_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(57, 'delete_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(58, 'delete_any_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(59, 'force_delete_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(60, 'force_delete_any_enquiry', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(61, 'view_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(62, 'view_any_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(63, 'create_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(64, 'update_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(65, 'restore_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(66, 'restore_any_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(67, 'replicate_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(68, 'reorder_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(69, 'delete_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(70, 'delete_any_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(71, 'force_delete_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(72, 'force_delete_any_hero::slide', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(73, 'view_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(74, 'view_any_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(75, 'create_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(76, 'update_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(77, 'restore_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(78, 'restore_any_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(79, 'replicate_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(80, 'reorder_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(81, 'delete_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(82, 'delete_any_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(83, 'force_delete_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(84, 'force_delete_any_job::opening', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(85, 'view_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(86, 'view_any_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(87, 'create_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(88, 'update_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(89, 'restore_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(90, 'restore_any_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(91, 'replicate_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(92, 'reorder_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(93, 'delete_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(94, 'delete_any_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(95, 'force_delete_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(96, 'force_delete_any_menu::item', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(97, 'view_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(98, 'view_any_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(99, 'create_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(100, 'update_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(101, 'restore_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(102, 'restore_any_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(103, 'replicate_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(104, 'reorder_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(105, 'delete_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(106, 'delete_any_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(107, 'force_delete_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(108, 'force_delete_any_project', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(109, 'view_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(110, 'view_any_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(111, 'create_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(112, 'update_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(113, 'delete_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(114, 'delete_any_role', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(115, 'view_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(116, 'view_any_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(117, 'create_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(118, 'update_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(119, 'restore_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(120, 'restore_any_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(121, 'replicate_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(122, 'reorder_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(123, 'delete_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(124, 'delete_any_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(125, 'force_delete_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(126, 'force_delete_any_service', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(127, 'view_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(128, 'view_any_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(129, 'create_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(130, 'update_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(131, 'restore_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(132, 'restore_any_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(133, 'replicate_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(134, 'reorder_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(135, 'delete_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(136, 'delete_any_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(137, 'force_delete_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(138, 'force_delete_any_testimonial', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(139, 'view_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(140, 'view_any_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(141, 'create_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(142, 'update_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(143, 'restore_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(144, 'restore_any_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(145, 'replicate_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(146, 'reorder_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(147, 'delete_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(148, 'delete_any_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(149, 'force_delete_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(150, 'force_delete_any_user', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(151, 'page_ManageAboutPage', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(152, 'page_ManageCareersPage', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(153, 'page_ManageContactPage', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(154, 'page_ManageHomePage', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(155, 'page_ManageServicesPage', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(156, 'page_ManageSiteSettings', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(157, 'widget_OverviewStatsWidget', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(158, 'widget_EnquiriesOverviewChart', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(159, 'widget_RecentEnquiriesWidget', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(160, 'widget_RecentApplicationsWidget', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15'),
(161, 'widget_RecentBookingsWidget', 'web', '2026-05-20 14:55:15', '2026-05-20 14:55:15');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `excerpt` text DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `title`, `slug`, `excerpt`, `body`, `location`, `image_path`, `link_url`, `sort_order`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'Mowing', 'mowing', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', 'projects/01KS2YSV0MCE8HN0T17TAXYS3F.jpeg', NULL, 0, 1, '2026-05-20 14:38:42', '2026-05-20 15:06:55'),
(2, 'Branch Trimming', 'branch-trimming', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', NULL, NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'Leaf Removing', 'leaf-removing', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', NULL, NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(4, 'Garden Beds', 'garden-beds', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', NULL, NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(5, 'Irrigation Tune-Up', 'irrigation-tune-up', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', NULL, NULL, 4, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(6, 'Seasonal Cleanup', 'seasonal-cleanup', 'A recent property transformation completed by the Lucky2s crew.', '<p>Scope included prep, execution, and final cleanup with attention to edges, beds, and seasonal needs.</p>', 'Austin, TX', NULL, NULL, 5, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `display_name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super_admin', 'Super Admin', 'web', '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(2, 'content_manager', 'Content Manager', 'web', '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'hr', 'HR', 'web', '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(87, 1),
(88, 1),
(89, 1),
(90, 1),
(91, 1),
(92, 1),
(93, 1),
(94, 1),
(95, 1),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 1),
(101, 1),
(102, 1),
(103, 1),
(104, 1),
(105, 1),
(106, 1),
(107, 1),
(108, 1),
(109, 1),
(110, 1),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(140, 1),
(141, 1),
(142, 1),
(143, 1),
(144, 1),
(145, 1),
(146, 1),
(147, 1),
(148, 1),
(149, 1),
(150, 1),
(151, 1),
(152, 1),
(153, 1),
(154, 1),
(155, 1),
(156, 1),
(157, 1),
(158, 1),
(159, 1),
(160, 1),
(161, 1);

-- --------------------------------------------------------

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `services` (`id`, `slug`, `title`, `excerpt`, `body`, `image_path`, `sort_order`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'lawn-care', 'Lawn Care', 'Professional, reliable service tailored to your property.', '<p>Contact us for a tailored plan and a crisp, healthy outdoor space.</p>', 'services/01KS2YYXXN2G272BBTN9S5HZBY.jpeg', 0, 1, '2026-05-20 14:38:42', '2026-05-20 15:09:42'),
(2, 'branch-trimming', 'Branch Trimming', 'Professional, reliable service tailored to your property.', '<p>Contact us for a tailored plan and a crisp, healthy outdoor space.</p>', NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'leaf-removing', 'Leaf Removing', 'Professional, reliable service tailored to your property.', '<p>Contact us for a tailored plan and a crisp, healthy outdoor space.</p>', NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(4, 'mowing', 'Mowing', 'Professional, reliable service tailored to your property.', '<p>Contact us for a tailored plan and a crisp, healthy outdoor space.</p>', NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(5, 'snow-services', 'Snow Services', 'Professional, reliable service tailored to your property.', '<p>Contact us for a tailored plan and a crisp, healthy outdoor space.</p>', NULL, 4, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('fP5FG3WCGdJ9Gf3W796WlR7kyTM4mKfGABtZPQfl', NULL, '106.219.133.124', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2tzdzRLaXNuNVEyS0xKQ0tza0NuU3Zsc2lpTEhrNW9WRks0M1dhNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHBzOi8vZXhjZWxsaXMuY28uaW4vbHVja3kycy1sYW5kc2NhcGluZy9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1789031943),
('s1zp0QcQor9FDMZIQY8O8ZtHRg22pT5z9lBrelsc', NULL, '103.121.157.203', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidThmRUdsZ2ZPVldYZlR1cWNxY2kwRzhLU01WNGRiZXlOdUpBUDlVUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHBzOi8vZXhjZWxsaXMuY28uaW4vbHVja3kycy1sYW5kc2NhcGluZy9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1785490925),
('SOXaghao7WVoPz4HyqV74WMT8MbIG7f24iCL2XDx', NULL, '106.215.96.183', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieUpEYmxNNmtsZ29od0xNYWFONHFuVnFBTWt4dXBkVnF1WUVJUG5vcCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjE6Imh0dHBzOi8vZXhjZWxsaXMuY28uaW4vbHVja3kycy1sYW5kc2NhcGluZy9wdWJsaWMvYWRtaW4vbG9naW4iO319', 1780427516);

-- --------------------------------------------------------

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_name` varchar(255) NOT NULL DEFAULT 'Lucky2s Landscaping',
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `topbar_email` varchar(255) DEFAULT NULL,
  `topbar_phone` varchar(255) DEFAULT NULL,
  `footer_text` text DEFAULT NULL,
  `copyright_text` varchar(255) DEFAULT NULL,
  `logo_path` varchar(255) DEFAULT NULL,
  `favicon_path` varchar(255) DEFAULT NULL,
  `admin_logo_path` varchar(255) DEFAULT NULL,
  `social_facebook` varchar(255) DEFAULT NULL,
  `social_instagram` varchar(255) DEFAULT NULL,
  `social_twitter` varchar(255) DEFAULT NULL,
  `social_linkedin` varchar(255) DEFAULT NULL,
  `calendly_url` varchar(255) DEFAULT NULL,
  `map_embed_html` text DEFAULT NULL,
  `office_address` text DEFAULT NULL,
  `brand_nav_text` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `site_name`, `meta_title`, `meta_description`, `topbar_email`, `topbar_phone`, `footer_text`, `copyright_text`, `logo_path`, `favicon_path`, `admin_logo_path`, `social_facebook`, `social_instagram`, `social_twitter`, `social_linkedin`, `calendly_url`, `map_embed_html`, `office_address`, `brand_nav_text`, `created_at`, `updated_at`) VALUES
(1, 'Lucky2s Landscaping', 'Lucky2s Landscaping', 'Professional lawn care and landscaping services.', 'hello@lucky2slandscaping.test', '(555) 000-0000', 'Dedicated to providing the highest quality landscaping and lawn care services with a focus on precision and customer satisfaction.', 'Lucky2s Landscaping. All Rights Reserved.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://calendly.com/masum-excellisit', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d4319.5143977242!2d-97.72610640548217!3d30.29843483309044!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x8644b58912a37db5%3A0x354a20db01a178f!2sGreenway%20St%2C%20Austin%2C%20TX%2078705%2C%20USA!5e1!3m2!1sen!2sin!4v1779289692731!5m2!1sen!2sin\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '123 Greenway Drive\nAustin, TX', 'Lucky2s\nLandscaping', '2026-05-20 14:38:42', '2026-05-20 15:08:33');

-- --------------------------------------------------------

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

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quote` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `stars` tinyint(3) UNSIGNED NOT NULL DEFAULT 5,
  `photo_path` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `testimonials` (`id`, `quote`, `name`, `email`, `stars`, `photo_path`, `sort_order`, `is_published`, `created_at`, `updated_at`) VALUES
(1, 'Great communication, tidy crew, and our yard has never looked better.', 'Happy Client 1', 'client1@example.com', 4, NULL, 1, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(2, 'Great communication, tidy crew, and our yard has never looked better.', 'Happy Client 2', 'client2@example.com', 4, NULL, 2, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42'),
(3, 'Great communication, tidy crew, and our yard has never looked better.', 'Happy Client 3', 'client3@example.com', 4, NULL, 3, 1, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'admin@lucky2slandscaping.test', NULL, '$2y$12$jbziDsd6ihl3kJQpKHOftO6NBBxLpYnuXZIRlrokahnGf4NTKpuRS', NULL, '2026-05-20 14:38:42', '2026-05-20 14:38:42');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_posts_slug_unique` (`slug`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bookings_reference_unique` (`reference`),
  ADD KEY `bookings_service_id_foreign` (`service_id`),
  ADD KEY `bookings_status_index` (`status`),
  ADD KEY `bookings_email_index` (`email`),
  ADD KEY `bookings_created_at_index` (`created_at`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `career_applications`
--
ALTER TABLE `career_applications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `enquiries`
--
ALTER TABLE `enquiries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `enquiries_service_id_foreign` (`service_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `hero_slides`
--
ALTER TABLE `hero_slides`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `job_openings`
--
ALTER TABLE `job_openings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`),
  ADD KEY `pages_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `projects_slug_unique` (`slug`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `services_slug_unique` (`slug`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `career_applications`
--
ALTER TABLE `career_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `enquiries`
--
ALTER TABLE `enquiries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hero_slides`
--
ALTER TABLE `hero_slides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_openings`
--
ALTER TABLE `job_openings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `enquiries`
--
ALTER TABLE `enquiries`
  ADD CONSTRAINT `enquiries_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `pages_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
