-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `devink_ink`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int UNSIGNED NOT NULL,
  `parent_id` int UNSIGNED DEFAULT NULL,
  `order` int NOT NULL DEFAULT '1',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `order`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, NULL, 1, 'Category 1', 'category-1', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(2, NULL, 1, 'Category 2', 'category-2', '2024-01-13 00:55:54', '2024-01-13 00:55:54');

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

--
-- Table structure for table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int UNSIGNED NOT NULL,
  `data_type_id` int UNSIGNED NOT NULL,
  `field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `browse` tinyint(1) NOT NULL DEFAULT '1',
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `add` tinyint(1) NOT NULL DEFAULT '1',
  `delete` tinyint(1) NOT NULL DEFAULT '1',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `data_rows`
--

INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, NULL, 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, NULL, 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, NULL, 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7),
(8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, NULL, 8),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}', 10),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11),
(11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, NULL, 12),
(12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5),
(21, 1, 'role_id', 'text', 'Role', 1, 1, 1, 1, 1, 1, NULL, 9),
(22, 4, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(23, 4, 'parent_id', 'select_dropdown', 'Parent', 0, 0, 1, 1, 1, 1, '{\"default\":\"\",\"null\":\"\",\"options\":{\"\":\"-- None --\"},\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}', 2),
(24, 4, 'order', 'text', 'Order', 1, 1, 1, 1, 1, 1, '{\"default\":1}', 3),
(25, 4, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 4),
(26, 4, 'slug', 'text', 'Slug', 1, 1, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"name\"}}', 5),
(27, 4, 'created_at', 'timestamp', 'Created At', 0, 0, 1, 0, 0, 0, NULL, 6),
(28, 4, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7),
(29, 5, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(30, 5, 'author_id', 'text', 'Author', 1, 0, 1, 1, 0, 1, NULL, 2),
(31, 5, 'category_id', 'text', 'Category', 1, 0, 1, 1, 1, 0, NULL, 3),
(32, 5, 'title', 'text', 'Title', 1, 1, 1, 1, 1, 1, NULL, 4),
(33, 5, 'excerpt', 'text_area', 'Excerpt', 1, 0, 1, 1, 1, 1, NULL, 5),
(34, 5, 'body', 'rich_text_box', 'Body', 1, 0, 1, 1, 1, 1, NULL, 6),
(35, 5, 'image', 'image', 'Post Image', 0, 1, 1, 1, 1, 1, '{\"resize\":{\"width\":\"1000\",\"height\":\"null\"},\"quality\":\"70%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"},{\"name\":\"small\",\"scale\":\"25%\"},{\"name\":\"cropped\",\"crop\":{\"width\":\"300\",\"height\":\"250\"}}]}', 7),
(36, 5, 'slug', 'text', 'Slug', 1, 0, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"title\",\"forceUpdate\":true},\"validation\":{\"rule\":\"unique:posts,slug\"}}', 8),
(37, 5, 'meta_description', 'text_area', 'Meta Description', 1, 0, 1, 1, 1, 1, NULL, 9),
(38, 5, 'meta_keywords', 'text_area', 'Meta Keywords', 1, 0, 1, 1, 1, 1, NULL, 10),
(39, 5, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"DRAFT\",\"options\":{\"PUBLISHED\":\"published\",\"DRAFT\":\"draft\",\"PENDING\":\"pending\"}}', 11),
(40, 5, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 12),
(41, 5, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 13),
(42, 5, 'seo_title', 'text', 'SEO Title', 0, 1, 1, 1, 1, 1, NULL, 14),
(43, 5, 'featured', 'checkbox', 'Featured', 1, 1, 1, 1, 1, 1, NULL, 15),
(44, 6, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(45, 6, 'author_id', 'text', 'Author', 1, 0, 0, 0, 0, 0, NULL, 2),
(46, 6, 'title', 'text', 'Title', 1, 1, 1, 1, 1, 1, NULL, 3),
(47, 6, 'excerpt', 'text_area', 'Excerpt', 1, 0, 1, 1, 1, 1, NULL, 4),
(48, 6, 'body', 'rich_text_box', 'Body', 1, 0, 1, 1, 1, 1, NULL, 5),
(49, 6, 'slug', 'text', 'Slug', 1, 0, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"title\"},\"validation\":{\"rule\":\"unique:pages,slug\"}}', 6),
(50, 6, 'meta_description', 'text', 'Meta Description', 1, 0, 1, 1, 1, 1, NULL, 7),
(51, 6, 'meta_keywords', 'text', 'Meta Keywords', 1, 0, 1, 1, 1, 1, NULL, 8),
(52, 6, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"INACTIVE\",\"options\":{\"INACTIVE\":\"INACTIVE\",\"ACTIVE\":\"ACTIVE\"}}', 9),
(53, 6, 'created_at', 'timestamp', 'Created At', 1, 1, 1, 0, 0, 0, NULL, 10),
(54, 6, 'updated_at', 'timestamp', 'Updated At', 1, 0, 0, 0, 0, 0, NULL, 11),
(55, 6, 'image', 'image', 'Page Image', 0, 1, 1, 1, 1, 1, NULL, 12),
(56, 7, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(57, 7, 'title', 'text', 'Title', 1, 1, 1, 1, 1, 1, '{}', 2),
(58, 7, 'short_desp', 'text', 'Short Desp', 1, 1, 1, 1, 1, 1, '{}', 3),
(59, 7, 'image', 'image', 'Image', 1, 1, 1, 1, 1, 1, '{}', 4),
(60, 7, 'detail', 'rich_text_box', 'Detail', 1, 1, 1, 1, 1, 1, '{}', 5),
(61, 7, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 8),
(62, 7, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 9),
(63, 7, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"DRAFT\",\"options\":{\"PUBLISHED\":\"Published\",\"DRAFT\":\"Draft\",\"PENDING\":\"Pending\"}}', 7),
(64, 7, 'order', 'text', 'Order', 1, 1, 1, 1, 1, 1, '{}', 6),
(65, 8, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(66, 8, 'quote', 'text_area', 'Quote', 1, 1, 1, 1, 1, 1, '{}', 2),
(67, 8, 'image', 'image', 'Image', 1, 1, 1, 1, 1, 1, '{}', 3),
(68, 8, 'star', 'text', 'Star', 1, 1, 1, 1, 1, 1, '{}', 4),
(69, 8, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, '{}', 5),
(70, 8, 'designation', 'text', 'Designation', 1, 1, 1, 1, 1, 1, '{}', 6),
(71, 8, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"DRAFT\",\"options\":{\"PUBLISHED\":\"Published\",\"DRAFT\":\"Draft\",\"PENDING\":\"Pending\"}}', 7),
(72, 8, 'order', 'text', 'Order', 1, 1, 1, 1, 1, 1, '{}', 8),
(73, 8, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 9),
(74, 8, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 10),
(75, 9, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(76, 9, 'name', 'text', 'Name', 0, 1, 1, 1, 1, 1, '{}', 2),
(77, 9, 'logo', 'image', 'Logo', 1, 1, 1, 1, 1, 1, '{}', 3),
(78, 9, 'status', 'select_dropdown', 'Status', 0, 1, 1, 1, 1, 1, '{\"default\":\"DRAFT\",\"options\":{\"PUBLISHED\":\"Published\",\"DRAFT\":\"Draft\",\"PENDING\":\"Pending\"}}', 4),
(79, 9, 'order', 'text', 'Order', 0, 1, 1, 1, 1, 1, '{}', 5),
(80, 9, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 6),
(81, 9, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7),
(82, 11, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(83, 11, 'title', 'text', 'Title', 0, 1, 1, 1, 1, 1, '{}', 2),
(84, 11, 'long_title', 'text', 'Long Title', 0, 1, 1, 1, 1, 1, '{}', 3),
(85, 11, 'description', 'rich_text_box', 'Description', 0, 1, 1, 1, 1, 1, '{}', 4),
(86, 11, 'icon', 'text', 'Icon', 0, 1, 1, 1, 1, 1, '{}', 5),
(87, 11, 'image', 'image', 'Image', 0, 1, 1, 1, 1, 1, '{}', 6),
(88, 11, 'order', 'text', 'Order', 0, 1, 1, 1, 1, 1, '{}', 7),
(89, 11, 'status', 'text', 'Status', 0, 1, 1, 1, 1, 1, '{}', 8),
(90, 11, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 9),
(91, 11, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 10);

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

--
-- Table structure for table `data_types`
--

CREATE TABLE `data_types` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint NOT NULL DEFAULT '0',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, 'TCG\\Voyager\\Http\\Controllers\\VoyagerRoleController', '', 1, 0, NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(4, 'categories', 'categories', 'Category', 'Categories', 'voyager-categories', 'TCG\\Voyager\\Models\\Category', NULL, '', '', 1, 0, NULL, '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(5, 'posts', 'posts', 'Post', 'Posts', 'voyager-news', 'TCG\\Voyager\\Models\\Post', 'TCG\\Voyager\\Policies\\PostPolicy', '', '', 1, 0, NULL, '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(6, 'pages', 'pages', 'Page', 'Pages', 'voyager-file-text', 'TCG\\Voyager\\Models\\Page', NULL, '', '', 1, 0, NULL, '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(7, 'loan_options', 'loan-options', 'Loan Option', 'Loan Options', 'voyager-dollar', 'App\\Models\\LoanOption', NULL, NULL, NULL, 1, 0, '{\"order_column\":\"id\",\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}', '2024-06-03 21:57:12', '2024-06-04 20:46:48'),
(8, 'testimonials', 'testimonials', 'Testimonial', 'Testimonials', 'voyager-leaf', 'App\\Models\\Testimonial', NULL, NULL, NULL, 1, 0, '{\"order_column\":\"id\",\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}', '2024-06-04 21:00:46', '2024-06-04 21:01:54'),
(9, 'partners', 'partners', 'Partner', 'Partners', 'voyager-check-circle', 'App\\Models\\Partner', NULL, NULL, NULL, 1, 0, '{\"order_column\":\"id\",\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}', '2024-06-04 21:53:51', '2024-06-04 22:39:31'),
(11, 'learnings', 'learnings', 'Learning', 'Learnings', 'voyager-window-list', 'App\\Models\\Learning', NULL, NULL, NULL, 1, 0, '{\"order_column\":\"id\",\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}', '2024-08-23 09:08:40', '2024-08-23 09:09:20');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `learnings`
--

CREATE TABLE `learnings` (
  `id` int UNSIGNED NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `long_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `icon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` int 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 `learnings`
--

INSERT INTO `learnings` (`id`, `title`, `long_title`, `description`, `icon`, `image`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 'How to Get a Loan', 'Here\'s a quick look at the mortgage process', '<p>Once you select us to obtain your home loan, you\'ll be amazed at how quickly and simply the loan process moves. Before you know it, you\'ll have a mortgage that suits your lifestyle and saves you money.</p>\r\n<p>Call (863) 688-8443 or toll free (855) 915-4663, or&nbsp;<a href=\"https://www.midflorida.com/resources/mortgage-lending-center/choose-start/\">apply for a mortgage</a>&nbsp;online.&nbsp;</p>\r\n<h4>Step One - Apply Now! Getting started is&nbsp;easy</h4>\r\n<p>When you\'ve selected a property and have a contract with the seller, the next step is to complete your loan application, which can be done easily through our website.&nbsp;<a href=\"https://www.midflorida.com/resources/mortgage-lending-center/choose-start/\">Apply for a mortgage</a>.</p>\r\n<h4>Step Two - Processing your application</h4>\r\n<p>Your loan processor will order the title work and appraisal and begin verifying all loan documentation. Once all necessary documentation is received and processed, your loan application will be submitted to underwriting for final approval.</p>\r\n<h4>Step Three - Your Loan is approved and funded</h4>\r\n<p>Your real estate agent or the seller will designate an escrow/title company to handle the funding of your loan, along with many other factors which make your purchase go smoothly.</p>\r\n<p>We will coordinate with the escrow team and you\'ll sign the final papers at their office.</p>\r\n<p>Let us help you get on the path to homeownership.&nbsp;<a href=\"https://www.midflorida.com/resources/mortgage-lending-center/mortgage-specialists/\">Find a mortgage specialist</a>&nbsp;or&nbsp;<a href=\"https://midfloridacreditunion.mymortgage-online.com/?loanapp&amp;siteid=7019353305&amp;workFlowId=68314\">request a free consultation</a>.</p>', 'fa-money-bill-wheat', NULL, '1', 1, '2024-08-23 09:11:00', '2024-10-21 18:39:47'),
(2, 'Planning for Homeownership', 'Prepare for your purchase', '<p>If you&rsquo;re thinking about purchasing your first home, you probably have a number of questions running through your mind: What if my credit score is too low? Can I afford a down payment? What else should I be worrying about? The good news is that, by creating&mdash;and following!&mdash;a plan, you can confidently prepare for the home buying process.</p>\r\n<h3>Work on building and improving your credit now</h3>\r\n<p>The sooner you start working toward a better credit score the better. Here are some simple tips for getting your score higher:</p>\r\n<ul>\r\n<li><strong>Pay every bill on time, every time.</strong>&nbsp;Schedule payments ahead of time with Bill Pay and say bye-bye to late payments once and for all.</li>\r\n<li><strong>Check your credit report.</strong>&nbsp;The three major reporting agencies (Equifax, Experian, and TransUnion) each offer a free credit report once every 12 months. Make it a habit of rotating through the reporting agencies to intermittently pull your credit. That way, you can identify and resolve errors as quickly as possible!</li>\r\n<li><strong>Consider opening a Secured Visa credit card.&nbsp;</strong>This type of credit card uses a secured savings account as collateral (for instance, to have a $1,000 credit limit, you&rsquo;ll need to maintain $1,000 in savings). By continually borrowing against your own savings&mdash;and paying your Secured Visa bill on time!&mdash;you can establish positive credit history to help improve your score.</li>\r\n</ul>\r\n<h3>Discover your down payment options</h3>\r\n<p>Depending on the type of mortgage you receive, your down payment might be a lot less than you think. With an FHA mortgage, it&rsquo;s possible to purchase a home with as little as 3.5% down! In some cases, you might even qualify for a conventional mortgage with only a 3% down payment.</p>\r\n<h3>Talk with a Mortgage Specialist</h3>\r\n<p>One of our expert Mortgage Specialists will gladly answer all of your questions about purchasing a home. We can help you decide which type of mortgage best fits your needs and give you an idea of what you can afford and how much you&rsquo;ll need for a down payment.&nbsp;<a href=\"https://midfloridacreditunion.mymortgage-online.com/?loanapp&amp;siteid=7019353305&amp;workFlowId=68314\">Request a free consultation</a>&nbsp;with a Mortgage Specialist near you and get started today!</p>', 'fa-house', NULL, '2', 1, '2024-08-23 09:12:00', '2024-10-21 18:39:59'),
(3, 'Mortgage Checklist', 'Mortgage Checklist', '<p>The following information is usually required during the loan process:</p>\r\n<ul>\r\n<li>Your Social Security Card and Driver&rsquo;s License</li>\r\n<li>Income Documentation:\r\n<ul>\r\n<li>Salary &ndash; Most recent paystub and W-2 or 1099</li>\r\n<li>Self-Employed, Rental or Interest income &ndash; 2 years most recent Personal AND Business tax returns, must include all schedules and K-1&rsquo;s (if applicable)</li>\r\n<li>Pension and Social Security Income &ndash; Award Letter or 1099 AND 2 months most recent bank statements documenting receipt of funds</li>\r\n<li>Recipient of Alimony or Child Support &ndash; Full documentation of court order and proof of receipt for the past 12 months (bank deposits or cancelled checks)</li>\r\n</ul>\r\n</li>\r\n<li>Bank statements for the past two months, must include all pages and be most recent statements available at time of application</li>\r\n<li>Investment or Retirement account statements for the past two months, must include all pages and be most recent statement available at time of application</li>\r\n<li>Real Estate contract (if purchasing)</li>\r\n<li>If obligated to pay Child Support or Alimony&nbsp;&ndash; provide full court ordered documentation</li>\r\n<li>Bankruptcy &ndash; provide full copy of filing and discharge documentation</li>\r\n</ul>\r\n<p><strong>If you currently own real estate:</strong></p>\r\n<ul>\r\n<li>Mortgage account information</li>\r\n<li>Home insurance policy information</li>\r\n<li>Home equity account information (if applicable)</li>\r\n<li>Property Tax Information</li>\r\n</ul>\r\n<p><strong>FHA/USDA/VA Financing</strong></p>\r\n<p>All of the above documentation plus:</p>\r\n<ul>\r\n<li>Previous year&rsquo;s W-2 or 1099</li>\r\n<li>1 full month of paystubs</li>\r\n<li>DD214 &amp; Certificate of Eligibility (VA only)</li>\r\n</ul>', 'fa-landmark', NULL, '3', 1, '2024-08-23 19:28:20', '2024-08-23 19:28:20'),
(4, 'Home Purchase Basics', 'Home Purchase Basics', '<p>A home purchase may be your largest financial transaction to date, so it&rsquo;s important to make the right decisions and to keep an eye on the details. With the assistance of your real estate agent and loan officer, it should be an efficient, pleasant, and ultimately rewarding experience.<br>&nbsp;</p>\r\n<p><strong>Count On Your Real Estate Agent To:</strong></p>\r\n<ul>\r\n<li>Preview available homes to weed out those that are overpriced, or undesirable in some other way.</li>\r\n<li>Present the homes that suit your needs as you&rsquo;ve defined them.</li>\r\n<li>Help you determine the difference between a &ldquo;good buy&rdquo; and a property which, because of its nature (neighborhood, market appeal, etc.), might have to be discounted if you decide to sell in the future.</li>\r\n<li>Negotiate the best deal for you. With a prequalification letter from us in hand, your real estate agent will be able to demonstrate that you are a qualified and capable borrower. This will strongly influence the seller, and may make the difference between the seller accepting your offer or someone else&rsquo;s &mdash; even if your offer is lower!</li>\r\n</ul>\r\n<p><strong>Count On Your Mortgage Loan Officer To:</strong></p>\r\n<ul>\r\n<li>Assist you in selecting the best loan to meet your personal situation and goals. (This single decision can save you thousands of dollars throughout the years!)</li>\r\n<li>Keep you informed of your loan status throughout the entire process.</li>\r\n<li>Keep your real estate agent informed of our loan progress (Note: your personal information is always kept confidential between you and us; only deal points and progress are shared).</li>\r\n<li>Get the appropriate loan for you at the best rates and fees. This will save you significant money &ldquo;up front&rdquo; and throughout the years to come.</li>\r\n</ul>\r\n<p><strong>Count On Yourself To:</strong></p>\r\n<ul>\r\n<li>Keep your real estate agent informed of any questions or concerns as they develop.</li>\r\n<li>Keep the process moving by providing documentation and decisions as soon as reasonably possible. By doing so, many of the details are taken care of early in the process so you can comfortably concentrate on any last-minute details or events that require your attention.</li>\r\n<li>Enjoy purchasing your home, but do remain objective throughout &mdash; to make the business decisions that are best for you.</li>\r\n<li>Make sure you are pre-approved as early as possible. This will put the power of financing behind you so you can concentrate on selecting your home.</li>\r\n</ul>', 'fa-vihara', NULL, '4', 1, '2024-08-23 19:30:06', '2024-08-23 19:30:06'),
(5, 'Mortgage Glossary', 'Mortgage Glossary', '<h3>Acceleration Clause</h3>\r\n<p>Provision in a mortgage that allows the lender to demand payment of the entire principal balance if a monthly payment is missed or some other default occurs.</p>\r\n<h3>Additional Principal Payment</h3>\r\n<p>A way to reduce the remaining balance on the loan by paying more than the scheduled principal amount due.</p>\r\n<h3>Adjustable-Rate Mortgage (ARM)</h3>\r\n<p>A mortgage with an interest rate that changes during the life of the loan according to movements in an index rate. Sometimes called AMLs (adjustable mortgage loans) or VRMs (variable-rate mortgages).</p>\r\n<h3>Adjusted Basis</h3>\r\n<p>The cost of a property plus the value of any capital expenditures for improvements to the property minus any depreciation taken.</p>\r\n<h3>Adjustment Date</h3>\r\n<p>The date that the interest rate changes on an adjustable-rate mortgage (ARM).</p>\r\n<h3>Adjustment Period</h3>\r\n<p>The period elapsing between adjustment dates for an adjustable-rate mortgage (ARM).</p>\r\n<h3>Affordability Analysis</h3>\r\n<p>An analysis of a buyer&rsquo;s ability to afford the purchase of a home. Reviews income, liabilities, and available funds, and considers the type of mortgage you plan to use, the area where you want to purchase a home, and the closing costs that are likely.</p>\r\n<h3>Amortization</h3>\r\n<p>The gradual repayment of a mortgage loan, both principal and interest, by installments.</p>\r\n<h3>Amortization Term</h3>\r\n<p>The length of time required to amortize the mortgage loan expressed as a number of months. For example, 360 months is the amortization term for a 30-year fixed-rate mortgage.</p>\r\n<h3>Annual Percentage Rate (APR)</h3>\r\n<p>The cost of credit, expressed as a yearly rate including interest, mortgage insurance, and loan origination fees. This allows the buyer to compare loans, however APR should not be confused with the actual note rate.</p>\r\n<h3>Appraisal</h3>\r\n<p>A written analysis prepared by a qualified appraiser and estimating the value of a property.</p>\r\n<h3>Appraised Value</h3>\r\n<p>An opinion of a property&rsquo;s fair market value, based on an appraiser&rsquo;s knowledge, experience, and analysis of the property.</p>\r\n<h3>Asset</h3>\r\n<p>Anything owned of monetary value including real property, personal property, and enforceable claims against others (including bank accounts, stocks, mutual funds, etc.).</p>\r\n<h3>Assignment</h3>\r\n<p>The transfer of a mortgage from one person to another.</p>\r\n<h3>Assumability</h3>\r\n<p>An assumable mortgage can be transferred from the seller to the new buyer. Generally requires a credit review of the new borrower and lenders may charge a fee for the assumption. If a mortgage contains a due-on-sale clause, it may not be assumed by a new buyer.</p>\r\n<h3>Assumption Fee</h3>\r\n<p>The fee paid to a lender (usually by the purchaser of real property) when an assumption takes place.</p>\r\n<h3>Balance Sheet</h3>\r\n<p>A financial statement that shows assets, liabilities, and net worth as of a specific date.</p>\r\n<h3>Balloon Mortgage</h3>\r\n<p>A mortgage with level monthly payments that amortizes over a stated term but also requires that a lump sum payment be paid at the end of an earlier specified term.</p>\r\n<h3>Balloon Payment</h3>\r\n<p>The final lump sum paid at the maturity date of a balloon mortgage.</p>\r\n<h3>Before-tax Income</h3>\r\n<p>Income before taxes are deducted.</p>\r\n<h3>Biweekly Payment Mortgage</h3>\r\n<p>A plan to reduce the debt every two weeks (instead of the standard monthly payment schedule). The 26 (or possibly 27) biweekly payments are each equal to one-half of the monthly payment required if the loan were a standard 30-year fixed-rate mortgage. The result for the borrower is a substantial savings in interest.</p>\r\n<h3>Bridge Loan</h3>\r\n<p>A second trust that is collateralized by the borrower&rsquo;s present home allowing the proceeds to be used to close on a new house before the present home is sold. Also known as &ldquo;swing loan.&rdquo;</p>\r\n<h3>Broker</h3>\r\n<p>An individual or company that brings borrowers and lenders together for the purpose of loan origination.</p>\r\n<h3>Buydown</h3>\r\n<p>When the seller, builder or buyer pays an amount of money up front to the lender to reduce monthly payments during the first few years of a mortgage. Buydowns can occur in both fixed and adjustable rate mortgages.</p>\r\n<h3>Cap</h3>\r\n<p>Limits how much the interest rate or the monthly payment can increase, either at each adjustment or during the life of the mortgage. Payment caps don&rsquo;t limit the amount of interest the lender is earning and may cause negative amortization.</p>\r\n<h3>Certificate of Eligibility</h3>\r\n<p>A document issued by the federal government certifying a veteran&rsquo;s eligibility for a Department of Veterans Affairs (VA) mortgage.</p>\r\n<h3>Certificate of Reasonable Value (CRV)</h3>\r\n<p>A document issued by the Department of Veterans Affairs (VA) that establishes the maximum value and loan amount for a VA mortgage.</p>\r\n<h3>Change Frequency</h3>\r\n<p>The frequency (in months) of payment and/or interest rate changes in an adjustable-rate mortgage (ARM).</p>\r\n<h3>Closing</h3>\r\n<p>A meeting held to finalize the sale of a property. The buyer signs the mortgage documents and pays closing costs. Also called &ldquo;settlement.&rdquo;</p>\r\n<h3>Closing Costs</h3>\r\n<p>These are expenses &ndash; over and above the price of the property &ndash; that are incurred by buyers and sellers when transferring ownership of a property. Closing costs normally include an origination fee, property taxes, charges for title insurance and escrow costs, appraisal fees, etc. Closing costs will vary according to the area, country and the lenders used.</p>\r\n<h3>Compound Interest</h3>\r\n<p>Interest paid on the original principal balance and on the accrued and unpaid interest.</p>\r\n<h3>Consumer Reporting Agency (or Bureau)</h3>\r\n<p>An organization that handles the preparation of reports used by lenders to determine a potential borrower&rsquo;s credit history. The agency gets data for these reports from a credit repository and from other sources.</p>\r\n<h3>Conversion Clause</h3>\r\n<p>A provision in an ARM allowing the loan to be converted to a fixed-rate at some point during the term. Usually conversion is allowed at the end of the first adjustment period. The conversion feature may cost extra.</p>\r\n<h3>Credit Report</h3>\r\n<p>A report detailing an individual&rsquo;s credit history that is prepared by a credit bureau and used by a lender to determine a loan applicant&rsquo;s creditworthiness.</p>\r\n<h3>Credit Risk Score</h3>\r\n<p>A credit score measures a consumer&rsquo;s credit risk relative to the rest of the U.S. population, based on the individual&rsquo;s credit usage history. The credit score most widely used by lenders is the FICO&reg; score, developed by Fair, Issac and Company. This 3-digit number, ranging from 300 to 850, is calculated by a mathematical equation that evaluates many types of information that are on your credit report. Higher FICO&reg; scores represents lower credit risks, which typically equate to better loan terms. In general, credit scores are critical in the mortgage loan underwriting process.</p>\r\n<h3>Deed of Trust</h3>\r\n<p>The document used in some states instead of a mortgage. Title is conveyed to a trustee.</p>\r\n<h3>Default</h3>\r\n<p>Failure to make mortgage payments on a timely basis or to comply with other requirements of a mortgage.</p>\r\n<h3>Delinquency</h3>\r\n<p>Failure to make mortgage payments on time.</p>\r\n<h3>Deposit</h3>\r\n<p>This is a sum of money given to bind the sale of real estate, or a sum of money given to ensure payment or an advance of funds in the processing of a loan.</p>\r\n<h3>Discount</h3>\r\n<p>In an ARM with an initial rate discount, the lender gives up a number of percentage points in interest to reduce the rate and lower the payments for part of the mortgage term (usually for one year or less). After the discount period, the ARM rate usually increases according to its index rate.</p>\r\n<h3>Down Payment</h3>\r\n<p>Part of the purchase price of a property that is paid in cash and not financed with a mortgage.</p>\r\n<h3>Effective Gross Income</h3>\r\n<p>A borrower&rsquo;s normal annual income, including overtime that is regular or guaranteed. Salary is usually the principal source, but other income may qualify if it is significant and stable.</p>\r\n<h3>Equity</h3>\r\n<p>The amount of financial interest in a property. Equity is the difference between the fair market value of the property and the amount still owed on the mortgage.</p>\r\n<h3>Escrow</h3>\r\n<p>An item of value, money, or documents deposited with a third party to be delivered upon the fulfillment of a condition. For example, the deposit of funds or documents into an escrow account to be disbursed upon the closing of a sale of real estate.</p>\r\n<h3>Escrow Disbursements</h3>\r\n<p>The use of escrow funds to pay real estate taxes, hazard insurance, mortgage insurance, and other property expenses as they become due.</p>\r\n<h3>Escrow Payment</h3>\r\n<p>The part of a mortgagor&rsquo;s monthly payment that is held by the servicer to pay for taxes, hazard insurance, mortgage insurance, lease payments, and other items as they become due.</p>\r\n<h3>Fannie Mae</h3>\r\n<p>A congressionally chartered, shareholder-owned company that is the nation&rsquo;s largest supplier of home mortgage funds.</p>\r\n<h3>FHA Mortgage</h3>\r\n<p>A mortgage that is insured by the Federal Housing Administration (FHA). Also known as a government mortgage.</p>\r\n<h3>FICO Score</h3>\r\n<p>FICO&reg; scores are the most widely used credit score in U.S. mortgage loan underwriting. This 3-digit number, ranging from 300 to 850, is calculated by a mathematical equation that evaluates many types of information that are on your credit report. Higher FICO&reg; scores represent lower credit risks, which typically equate to better loan terms.</p>\r\n<h3>First Mortgage</h3>\r\n<p>The primary lien against a property.</p>\r\n<h3>Fixed Installment</h3>\r\n<p>The monthly payment due on a mortgage loan including payment of both principal and interest.</p>\r\n<h3>Fixed-Rate Mortgage (FRM)</h3>\r\n<p>A mortgage with an interest rate that is fixed throughout the entire term of the loan.</p>\r\n<h3>Fully Amortized ARM</h3>\r\n<p>An adjustable-rate mortgage (ARM) with a monthly payment that is sufficient to amortize the remaining balance, at the interest accrual rate, over the amortization term.</p>\r\n<h3>GNMA</h3>\r\n<p>A government-owned corporation that assumed responsibility for the special assistance loan program formerly administered by Fannie Mae. Popularly known as Ginnie Mae.</p>\r\n<h3>Growing-Equity Mortgage (GEM)</h3>\r\n<p>A fixed-rate mortgage that provides scheduled payment increases over an established period of time. The increased amount of the monthly payment is applied directly toward reducing the remaining balance of the mortgage.</p>\r\n<h3>Guarantee Mortgage</h3>\r\n<p>A mortgage that is guaranteed by a third party.</p>\r\n<h3>Housing Expense Ratio</h3>\r\n<p>The percentage of gross monthly income budgeted to pay housing expenses.</p>\r\n<h3>HUD-1 statement</h3>\r\n<p>A document that provides an itemized listing of the funds that are payable at closing. Items that appear on the statement include real estate commissions, loan fees, points, and initial escrow amounts. Each item on the statement is represented by a separate number within a standardized numbering system. The totals at the bottom of the HUD-1 statement define the seller&rsquo;s net proceeds and the buyer&rsquo;s net payment at closing.</p>\r\n<h3>Hybrid ARM (3/1 ARM, 5/1 ARM, 7/1 ARM)</h3>\r\n<p>A combination fixed rate and adjustable rate loan &ndash; also called 3/1,5/1,7/1 &ndash; can offer the best of both worlds: lower interest rates (like ARMs) and a fixed payment for a longer period of time than most adjustable rate loans. For example, a &ldquo;5/1 loan&rdquo; has a fixed monthly payment and interest for the first five years and then turns into a traditional adjustable rate loan, based on then-current rates for the remaining 25 years. It&rsquo;s a good choice for people who expect to move or refinance, before or shortly after, the adjustment occurs.</p>\r\n<h3>Index</h3>\r\n<p>The index is the measure of interest rate changes a lender uses to decide the amount an interest rate on an ARM will change over time.The index is generally a published number or percentage, such as the average interest rate or yield on Treasury bills. Some index rates tend to be higher than others and some more volatile.</p>\r\n<h3>Initial Interest Rate</h3>\r\n<p>This refers to the original interest rate of the mortgage at the time of closing. This rate changes for an adjustable-rate mortgage (ARM). It&rsquo;s also known as &ldquo;start rate&rdquo; or &ldquo;teaser.&rdquo;</p>\r\n<h3>Installment</h3>\r\n<p>The regular periodic payment that a borrower agrees to make to a lender.</p>\r\n<h3>Insured Mortgage</h3>\r\n<p>A mortgage that is protected by the Federal Housing Administration (FHA) or by private mortgage insurance (PMI).</p>\r\n<h3>Interest</h3>\r\n<p>The fee charged for borrowing money.</p>\r\n<h3>Interest Accrual Rate</h3>\r\n<p>The percentage rate at which interest accrues on the mortgage. In most cases, it is also the rate used to calculate the monthly payments.</p>\r\n<h3>Interest Rate Buydown Plan</h3>\r\n<p>An arrangement that allows the property seller to deposit money to an account. That money is then released each month to reduce the mortgagor&rsquo;s monthly payments during the early years of a mortgage.</p>\r\n<h3>Interest Rate Ceiling</h3>\r\n<p>For an adjustable-rate mortgage (ARM), the maximum interest rate, as specified in the mortgage note.</p>\r\n<h3>Interest Rate Floor</h3>\r\n<p>For an adjustable-rate mortgage (ARM), the minimum interest rate, as specified in the mortgage note.</p>\r\n<h3>Late Charge</h3>\r\n<p>The penalty a borrower must pay when a payment is made a stated number of days (usually 15) after the due date.</p>\r\n<h3>Lease-Purchase Mortgage Loan</h3>\r\n<p>An alternative financing option that allows low- and moderate-income home buyers to lease a home with an option to buy. Each month&rsquo;s rent payment consists of principal, interest, taxes and insurance (PITI) payments on the first mortgage plus an extra amount that accumulates in a savings account for a downpayment.</p>\r\n<h3>Liabilities</h3>\r\n<p>A person&rsquo;s financial obligations. Liabilities include long-term and short-term debt.</p>\r\n<h3>Lifetime Payment Cap</h3>\r\n<p>For an adjustable-rate mortgage (ARM), a limit on the amount that payments can increase or decrease over the life of the mortgage.</p>\r\n<h3>Lifetime Rate Cap</h3>\r\n<p>For an adjustable-rate mortgage (ARM), a limit on the amount that the interest rate can increase or decrease over the life of the loan. See cap.</p>\r\n<h3>Line of Credit</h3>\r\n<p>An agreement by a commercial bank or other financial institution to extend credit up to a certain amount for a certain time.</p>\r\n<h3>Liquid Asset</h3>\r\n<p>A cash asset or an asset that is easily converted into cash.</p>\r\n<h3>Loan</h3>\r\n<p>A sum of borrowed money (principal) that is generally repaid with interest.</p>\r\n<h3>Loan-to-Value (LTV) Percentage</h3>\r\n<p>The relationship between the principal balance of the mortgage and the appraised value (or sales price if it is lower) of the property. For example, a $100,000 home with an $80,000 mortgage has an LTV of 80 percent.</p>\r\n<h3>Lock-In Period</h3>\r\n<p>The guarantee of an interest rate for a specified period of time by a lender, including loan term and points, if any, to be paid at closing. Short term locks (under 21 days), are usually available after lender loan approval only. However, many lenders may permit a borrower to lock a loan for 30 days or more prior to submission of the loan application.</p>\r\n<h3>Margin</h3>\r\n<p>The number of percentage points the lender adds to the index rate to calculate the ARM interest rate at each adjustment.</p>\r\n<h3>Maturity</h3>\r\n<p>The date on which the principal balance of a loan becomes due and payable.</p>\r\n<h3>Monthly Fixed Installment</h3>\r\n<p>That portion of the total monthly payment that is applied toward principal and interest. When a mortgage negatively amortizes, the monthly fixed installment does not include any amount for principal reduction and doesn&rsquo;t cover all of the interest. The loan balance therefore increases instead of decreasing.</p>\r\n<h3>Mortgage</h3>\r\n<p>A legal document that pledges a property to the lender as security for payment of a debt.</p>\r\n<h3>Mortgage Banker</h3>\r\n<p>A company that originates mortgages exclusively for resale in the secondary mortgage market.</p>\r\n<h3>Mortgage Broker</h3>\r\n<p>An individual or company that brings borrowers and lenders together for the purpose of loan origination.</p>\r\n<h3>Mortgage Insurance</h3>\r\n<p>A contract that insures the lender against loss caused by a mortgagor&rsquo;s default on a government mortgage or conventional mortgage. Mortgage insurance can be issued by a private company or by a government agency.</p>\r\n<h3>Mortgage Insurance Premium (MIP)</h3>\r\n<p>The amount paid by a mortgagor for mortgage insurance.</p>\r\n<h3>Mortgage Life Insurance</h3>\r\n<p>A type of term life insurance In the event that the borrower dies while the policy is in force, the debt is automatically paid by insurance proceeds.</p>\r\n<h3>Mortgagor</h3>\r\n<p>The borrower in a mortgage agreement.</p>\r\n<h3>Negative Amortization</h3>\r\n<p>Amortization means that monthly payments are large enough to pay the interest and reduce the principal on your mortgage. Negative amortization occurs when the monthly payments do not cover all of the interest cost. The interest cost that isn&rsquo;t covered is added to the unpaid principal balance. This means that even after making many payments, you could owe more than you did at the beginning of the loan. Negative amortization can occur when an ARM has a payment cap that results in monthly payments not high enough to cover the interest due.</p>\r\n<h3>Net Worth</h3>\r\n<p>The value of all of a person&rsquo;s assets, including cash.</p>\r\n<h3>Non Liquid Asset</h3>\r\n<p>An asset that cannot easily be converted into cash.</p>\r\n<h3>Note</h3>\r\n<p>A legal document that obligates a borrower to repay a mortgage loan at a stated interest rate during a specified period of time.</p>\r\n<h3>Origination Fee</h3>\r\n<p>A fee paid to a lender for processing a loan application. The origination fee is stated in the form of points. One point is 1 percent of the mortgage amount.</p>\r\n<h3>Owner Financing</h3>\r\n<p>A property purchase transaction in which the party selling the property provides all or part of the financing.</p>\r\n<h3>Payment Change Date</h3>\r\n<p>The date when a new monthly payment amount takes effect on an adjustable-rate mortgage (ARM) or a graduated-payment mortgage (GPM). Generally, the payment change date occurs in the month immediately after the adjustment date.</p>\r\n<h3>Periodic Payment Cap</h3>\r\n<p>A limit on the amount that payments can increase or decrease during any one adjustment period.</p>\r\n<h3>Periodic Rate Cap</h3>\r\n<p>A limit on the amount that the interest rate can increase or decrease during any one adjustment period, regardless of how high or low the index might be.</p>\r\n<h3>PITI Reserves</h3>\r\n<p>A cash amount that a borrower must have on hand after making a down payment and paying all closing costs for the purchase of a home. The principal, interest, taxes, and insurance (PITI) reserves must equal the amount that the borrower would have to pay for PITI for a predefined number of months (usually three).</p>\r\n<h3>Points</h3>\r\n<p>A point is equal to one percent of the principal amount of your mortgage. For example, if you get a mortgage for $165,000 one point means $1,650 to the lender.Points usually are collected at closing and may be paid by the borrower or the home seller, or may be split between them.</p>\r\n<h3>Prepayment Penalty</h3>\r\n<p>A fee that may be charged to a borrower who pays off a loan before it is due.</p>\r\n<h3>Pre-Approval</h3>\r\n<p>The process of determining how much money you will be eligible to borrow before you apply for a loan.</p>\r\n<h3>Prime Rate</h3>\r\n<p>The interest rate that banks charge to their preferred customers. Changes in the prime rate influence changes in other rates, including mortgage interest rates.</p>\r\n<h3>Principal</h3>\r\n<p>The amount borrowed or remaining unpaid. The part of the monthly payment that reduces the remaining balance of a mortgage.</p>\r\n<h3>Principal Balance</h3>\r\n<p>The outstanding balance of principal on a mortgage not including interest or any other charges.</p>\r\n<h3>Principal, Interest, Taxes, and Insurance (PITI)</h3>\r\n<p>The four components of a monthly mortgage payment. Principal refers to the part of the monthly payment that reduces the remaining balance of the mortgage. Interest is the fee charged for borrowing money. Taxes and insurance refer to the monthly cost of property taxes and homeowners insurance, whether these amounts are paid into an escrow account each month or not.</p>\r\n<h3>Private Mortgage Insurance (PMI)</h3>\r\n<p>Mortgage insurance provided by a private mortgage insurance company to protect lenders against loss if a borrower defaults. Most lenders generally require MI for a loan with a loan-to-value (LTV) percentage in excess of 80 percent.</p>\r\n<h3>Qualifying Ratios</h3>\r\n<p>Calculations used to determine if a borrower can qualify for a mortgage. They consist of two separate calculations: a housing expense as a percent of income ratio and total debt obligations as a percent of income ratio.</p>\r\n<h3>Rate Lock</h3>\r\n<p>A commitment issued by a lender to a borrower or other mortgage originator guaranteeing a specified interest rate and lender costs for a specified period of time.</p>\r\n<h3>Real Estate Agent</h3>\r\n<p>A person licensed to negotiate and transact the sale of real estate on behalf of the property owner.</p>\r\n<h3>Real Estate Settlement Procedures Act (RESPA)</h3>\r\n<p>A consumer protection law that requires lenders to give borrowers advance notice of closing costs.</p>\r\n<h3>Real Estate Agent&reg;</h3>\r\n<p>A real estate broker or an associate who is an active member in a local real estate board that is affiliated with the National Association of Real Estate Agents.</p>\r\n<h3>Recording</h3>\r\n<p>The noting in the registrar&rsquo;s office of the details of a properly executed legal document, such as a deed, a mortgage note, a satisfaction of mortgage, or an extension of mortgage, thereby making it a part of the public record.</p>\r\n<h3>Refinance</h3>\r\n<p>Paying off one loan with the proceeds from a new loan using the same property as security.</p>\r\n<h3>Revolving Liability</h3>\r\n<p>A credit arrangement, such as a credit card, that allows a customer to borrow against a pre-approved line of credit when purchasing goods and services.</p>\r\n<h3>Secondary Mortgage Market</h3>\r\n<p>Where existing mortgages are bought and sold.</p>\r\n<h3>Security</h3>\r\n<p>The property that will be pledged as collateral for a loan.</p>\r\n<h3>Seller Carry-back</h3>\r\n<p>An agreement in which the owner of a property provides financing, often in combination with an assumable mortgage. See Owner Financing.</p>\r\n<h3>Servicer</h3>\r\n<p>An organization that collects principal and interest payments from borrowers and manages borrowers&rsquo; escrow accounts. The servicer often services mortgages that have been purchased by an investor in the secondary mortgage market.</p>\r\n<h3>Standard Payment Calculation</h3>\r\n<p>The method used to determine the monthly payment required to repay the remaining balance of a mortgage in substantially equal installments over the remaining term of the mortgage at the current interest rate.</p>\r\n<h3>Step-Rate Mortgage</h3>\r\n<p>A mortgage that allows for the interest rate to increase according to a specified schedule (i.e., seven years), resulting in increased payments as well. At the end of the specified period, the rate and payments will remain constant for the remainder of the loan.</p>\r\n<h3>Third-party Origination</h3>\r\n<p>When a lender uses another party to completely or partially originate, process, underwrite, close, fund, or package the mortgages it plans to deliver to the secondary mortgage market.</p>\r\n<h3>Total Expense Ratio</h3>\r\n<p>Total obligations as a percentage of gross monthly income including monthly housing expenses plus other monthly debts.</p>\r\n<h3>Treasury Index</h3>\r\n<p>An index used to determine interest rate changes for certain adjustable-rate mortgage (ARM) plans. Based on the results of auctions that the U.S. Treasury holds for its Treasury bills and securities or derived from the U.S. Treasury&rsquo;s daily yield curve, which is based on the closing market bid yields on actively traded Treasury securities in the over-the-counter market.</p>\r\n<h3>Truth-in-Lending</h3>\r\n<p>A federal law that requires lenders to fully disclose, in writing, the terms and conditions of a mortgage, including the annual percentage rate (APR) and other charges.</p>\r\n<h3>Two-step Mortgage</h3>\r\n<p>An adjustable-rate mortgage (ARM) with one interest rate for the first five or seven years of its mortgage term and a different interest rate for the remainder of the amortization term.</p>\r\n<h3>Underwriting</h3>\r\n<p>The process of evaluating a loan application to determine the risk involved for the lender. Underwriting involves an analysis of the borrower&rsquo;s creditworthiness and the quality of the property itself.</p>', 'fa-file-invoice', NULL, '5', 1, '2024-08-23 19:31:50', '2024-08-23 19:31:50'),
(6, 'Mortgage Types', NULL, '<h3>Thirty-Year Fixed Rate Mortgage</h3>\r\n<p>The traditional 30-year fixed-rate mortgage has a constant interest rate and monthly payments that never change. This may be a good choice if you plan to stay in your home for seven years or longer. If you plan to move within seven years, then adjustable-rate loans are usually cheaper. As a rule of thumb, it may be harder to qualify for fixed-rate loans than for adjustable-rate loans. When interest rates are low, fixed-rate loans are generally not that much more expensive than adjustable-rate mortgages and may be a better deal in the long run&nbsp;because you can lock in the rate for the life of your loan.</p>\r\n<h3>Twenty-Year Fixed Rate Mortgage</h3>\r\n<p>The 20-year loan option provides distinct advantages over other products. You get the advantage of the fixed rate and payment for 20 years, the rate is slightly lower than that of the 30 year mortgage and you will own your home 10 years sooner. This is a good option when you do not want to finance for 30 years, but cannot quite afford the option of the 15-year mortgage payment.</p>\r\n<h3>Fifteen-Year Fixed Rate Mortgage</h3>\r\n<p>This loan is fully amortized over a 15-year period and features constant monthly payments. It offers all the advantages of the 30-year loan, plus a lower interest rate&mdash;and you&rsquo;ll own your home twice as fast. The disadvantage is that, with a 15-year loan, you commit to a higher monthly payment. Many borrowers opt for a 30-year fixed-rate loan and voluntarily make larger payments that will pay off their loan in 15 years. This approach is often safer than committing to a higher monthly payment, since the difference in interest rates isn&rsquo;t that great.</p>\r\n<h3>Ten-Year Fixed Rate Mortgage</h3>\r\n<p>The 10-year fixed rate mortgage is a great option for owning your home in no time and taking advantage of a low interest rate. This is usually a good option when refinancing to avoid extending your loan terms and still pay off your home in a short time period. Your rate is fixed for the full 10 years and you will pay significantly less interest over the life of the loan.</p>\r\n<h3>Adjustable-Rate Mortgages (ARM)</h3>\r\n<p>An Adjustable Rate Mortgage is a loan that has an interest rate that changes annually, usually in relation to an index, and payments may go up or down. Hybrid ARMs--such as 5/1, 7/1 or 5/5--can offer the best of: lower interest rates (like ARMs) and a fixed payment for a longer period of time. The first number indicates the initial fixed-rate period, and the second number indicates how often the rate can adjust after that. For example, a &ldquo;5/1 loan&rdquo; has a fixed monthly payment and interest rate for the first five years and then adjusts annually based on then-current rates for the remaining 25 years. It&rsquo;s a good choice for people who expect to move (or refinance) before or shortly after the adjustment occurs.</p>\r\n<h3>Construction-Perm</h3>\r\n<p>The Construction to Permanent loan is designed to finance the construction of your dream home. You have the option of a 10, 15, 20 or 30-year amortization with a fixed rate. The rate is locked in up front at time of application. During construction you make interest-only payments at a discounted interest rate. Once construction is completed, your loan terms are finalized and you begin making principal and interest payments.</p>\r\n<h3>FHA Mortgage</h3>\r\n<p>A FHA (Federal Housing Administration) mortgage is a government-backed mortgage product, offering 15, 20 and 30-year financing options. This is a great option for first-time home buyers with limited funds for down payment. Not only can the seller assist with closing costs, but the source of funds for down payment can be 100% gift funds from a relative. The other benefit is the credit score requirements are lower than the conventional mortgage products. The disadvantage of FHA financing is the costly PMI which remains for the life of the loan.</p>', 'fa-gg-circle', NULL, '6', 1, '2024-08-23 19:33:44', '2024-08-23 19:33:44');

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

--
-- Table structure for table `loan_options`
--

CREATE TABLE `loan_options` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_desp` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` enum('PUBLISHED','DRAFT','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `loan_options`
--

INSERT INTO `loan_options` (`id`, `title`, `short_desp`, `image`, `detail`, `created_at`, `updated_at`, `status`, `order`) VALUES
(1, 'USDA Loans', 'Buy with $0 down using the USDA rural development mortgage. USDA home loans are offered at great rates.', 'loan-options\\June2024\\zLWJ9D9CHx5xvyosL9T0.jpg', '<p>Buy with $0 down using the USDA rural development mortgage. USDA home loans are offered at great rates. This a great loan program for first time home buyers, geographic and income limitations do apply.</p>\r\n<ul>\r\n<li>Down Payment: Zero. 100% financing! No down payment required.</li>\r\n<li>Credit Scores: Ideal for borrows with credit scores greater than 640.</li>\r\n<li>Income Caps: Total household income will determine a borrower&rsquo;s eligibility when it comes to USDA loans. Generally, a 1&ndash;4-member household income cannot exceed $93,000</li>\r\n<li>Occupancy: Owner occupied residence only.</li>\r\n</ul>', '2024-06-03 22:00:48', '2024-06-03 22:00:48', 'PUBLISHED', 1),
(2, 'FHA Loans', 'Loans that are incurred by Federal Housing Administration (FHA) and issued by an FHA approved lender.', 'loan-options\\June2024\\gF2HArjDZhle20U7D3eC.jpg', '<p>Loans that are incurred by Federal Housing Administration (FHA) and issued by an FHA approved lender. The FHA loans have low down payment, and interest rates. FHA loan requires an upfront mortgage insurance, which is usually added on top of the loan amount and a monthly mortgage insurance to be added to your monthly payment. You can use this product for purchases and refinances.</p>\r\n<p>Buy with as little as 3.5% down and with a score as low as 580. Additionally, the seller can pay all your closing costs. Great for first time buyers who pay be less income or some issues with their credit.</p>\r\n<ul>\r\n<li>Down Payment: 3.5% or more down payment is typically required. Family gift money is allowed for down payment.</li>\r\n<li>Credit Scores: Ideal for borrows with credit scores greater than 580 (Lower credit scores in a range of 550 to 579 can be accepted with pricing adjustments and tighter underwriting criteria and a 10% down.)</li>\r\n<li>Loan Limits: Please check FHA county limits for your county</li>\r\n<li>Occupancy: Most commonly used for owner occupied residences.</li>\r\n</ul>', '2024-06-04 20:10:26', '2024-06-04 20:10:26', 'PUBLISHED', 2),
(3, 'Investor Loan', 'Investment properties require a minimum of 20% down. However, your rate is improved with 25% down.', 'loan-options\\June2024\\mVjJT6nPCZhM1fkgheqD.jpg', '<p>Investment properties require a minimum of 20% down. However, your rate is improved with 25% down. Your interest rate will typically be higher in any case compared to a primary or secondary home loan as the risk is higher for the lender. Keep in mind that an appraisal for an investment property will cost a little more than typical because a valuation of potential rent is required as well. The condition of the property must still be considered functional.</p>\r\n<ul>\r\n<li>Down Payment: 20% or more down payment is typically required. (25% down payment saves at least a quarter on the rate)</li>\r\n<li>Credit Scores: Ideal for borrows with credit scores greater than 740 (Lower credit scores are accepted with pricing adjustments.)</li>\r\n<li>Loan Limits: Up to $548,000 (Higher limits available for high-cost areas)</li>\r\n<li>Reserves: Six months</li>\r\n</ul>', '2024-06-04 22:41:44', '2024-06-04 22:41:44', 'PUBLISHED', 3),
(4, 'Jumbo Loans', 'Jumbo Elite is a mortgage loan intended for well qualified buyers that are looking for a mortgage higher than the conventional limit (currently $548,000 in most areas).', 'loan-options\\June2024\\FQrQnBqR5jL8j6OlIh7W.jpg', '<p>Jumbo Elite is a mortgage loan intended for well qualified buyers that are looking for a mortgage higher than the conventional limit (currently $548,000 in most areas). Borrowers can choose from 30-year fixed product or three different ARM programs. Usually, a 20% down program is required, however, there are programs that require only 5% down payment.</p>\r\n<ul>\r\n<li>Down Payment: Usually 20% or more down, but less down payment options are available</li>\r\n<li>Credit Scores: Ideal for borrows with credit scores greater than 760 (Lower credit scores in a range of 720 to 759 are accepted with pricing adjustments.) Middle score of highest income earner will be used.</li>\r\n<li>Loan Limits: Up to $5,000,000</li>\r\n<li>Occupancy: Owner occupied or second residence</li>\r\n</ul>', '2024-06-04 22:43:16', '2024-06-04 22:43:16', 'PUBLISHED', 4),
(5, 'Conventional Loans', 'You can buy a home with conventional financing from as little as 3% down on your primary residence.', 'loan-options\\June2024\\d2dSYpypeyay5GvsQevu.jpg', '<p>You can buy a home with conventional financing from as little as 3% down on your primary residence. Both Fannie Me and Freddie Mac have low down payment programs that allow borrowers to qualify for a conventional mortgage with lower down payments, lower Mortgage insurance, and easier qualification guidelines.</p>\r\n<ul>\r\n<li>Down Payment: 3% or more down payment is typically required. Down payment for primary residence can be in the form of a family gift.10% down for a second home, and 15% or higher down payment for an investment property.</li>\r\n<li>Credit Scores: Minimum credit score required is 620. Ideal for borrows with less blemishes on their credit file.</li>\r\n<li>Occupancy: Owner occupied, second home, or investment properties are allowed</li>\r\n<li>Proof of income (W2&rsquo;s, tax returns, etc.)</li>\r\n</ul>', '2024-06-04 22:44:29', '2024-06-04 22:44:29', 'PUBLISHED', 5),
(6, 'VA Loans', 'A VA loan is a mortgage that is guaranteed by the Department of Veteran Affairs Department (VA).', 'loan-options/August2024/0V4cS86LpzJwwofLIHn6.jpg', '<p>A VA loan is a mortgage that is guaranteed by the Department of Veteran Affairs Department (VA). If you are a current service member or a veteran, there are mortgages specifically designed to help you buy a home, known as VA loans. With a VA loan you can buy with $0 down anywhere. A great perk of this loan is that it allows for the seller to pay most closing costs for the buyer.It&rsquo;s an amazing option for those who qualify.</p>\r\n<ul>\r\n<li>Down Payment: Zero. 100% financing! No down payment required.</li>\r\n<li>Credit Scores: Scores above a little as 580. However, for better terms a higher credit score is desirable</li>\r\n<li>Loan Limits: Currently no limit with adequate qualifying income</li>\r\n<li>Monthly Mortgage Insurance: None!</li>\r\n</ul>', '2024-06-04 22:45:00', '2024-08-26 19:46:43', 'PUBLISHED', 6);

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

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

CREATE TABLE `menus` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2024-01-13 00:55:53', '2024-01-13 00:55:53');

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

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

CREATE TABLE `menu_items` (
  `id` int UNSIGNED NOT NULL,
  `menu_id` int UNSIGNED DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Dashboard', '', '_self', 'voyager-boat', NULL, NULL, 1, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.dashboard', NULL),
(2, 1, 'Media', '', '_self', 'voyager-images', NULL, NULL, 5, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.media.index', NULL),
(3, 1, 'Users', '', '_self', 'voyager-person', NULL, NULL, 3, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.users.index', NULL),
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 2, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.roles.index', NULL),
(5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 9, '2024-01-13 00:55:53', '2024-01-13 00:55:53', NULL, NULL),
(6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 10, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.menus.index', NULL),
(7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 11, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.database.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 12, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 13, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.bread.index', NULL),
(10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 14, '2024-01-13 00:55:53', '2024-01-13 00:55:53', 'voyager.settings.index', NULL),
(11, 1, 'Categories', '', '_self', 'voyager-categories', NULL, NULL, 8, '2024-01-13 00:55:54', '2024-01-13 00:55:54', 'voyager.categories.index', NULL),
(12, 1, 'Posts', '', '_self', 'voyager-news', NULL, NULL, 6, '2024-01-13 00:55:54', '2024-01-13 00:55:54', 'voyager.posts.index', NULL),
(13, 1, 'Pages', '', '_self', 'voyager-file-text', NULL, NULL, 7, '2024-01-13 00:55:54', '2024-01-13 00:55:54', 'voyager.pages.index', NULL),
(14, 1, 'Loan Options', '', '_self', 'voyager-dollar', '#000000', NULL, 15, '2024-06-03 21:57:12', '2024-06-04 20:47:08', 'voyager.loan-options.index', 'null'),
(15, 1, 'Testimonials', '', '_self', 'voyager-leaf', '#000000', NULL, 16, '2024-06-04 21:00:46', '2024-06-04 21:02:10', 'voyager.testimonials.index', 'null'),
(16, 1, 'Partners', '', '_self', 'voyager-check-circle', '#000000', NULL, 17, '2024-06-04 21:53:51', '2024-06-04 22:40:12', 'voyager.partners.index', 'null'),
(17, 1, 'Learnings', '', '_self', 'voyager-window-list', '#000000', NULL, 18, '2024-08-23 09:08:40', '2024-08-23 09:09:41', 'voyager.learnings.index', 'null');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2019_08_19_000000_create_failed_jobs_table', 1),
(24, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(25, '2016_01_01_000000_create_pages_table', 2),
(26, '2016_01_01_000000_create_posts_table', 2),
(27, '2016_02_15_204651_create_categories_table', 2),
(28, '2017_04_11_000000_alter_post_nullable_fields_table', 2);

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

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

CREATE TABLE `pages` (
  `id` int UNSIGNED NOT NULL,
  `author_id` int NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INACTIVE',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `pages` (`id`, `author_id`, `title`, `excerpt`, `body`, `image`, `slug`, `meta_description`, `meta_keywords`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 'Hello World', 'Hang the jib grog grog blossom grapple dance the hempen jig gangway pressgang bilge rat to go on account lugger. Nelsons folly gabion line draught scallywag fire ship gaff fluke fathom case shot. Sea Legs bilge rat sloop matey gabion long clothes run a shot across the bow Gold Road cog league.', '<p>Hello World. Scallywag grog swab Cat o\'nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.</p>\n<p>Ballast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.</p>', 'pages/page1.jpg', 'hello-world', 'Yar Meta Description', 'Keyword1, Keyword2', 'ACTIVE', '2024-01-13 00:55:54', '2024-01-13 00:55:54');

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('PUBLISHED','DRAFT','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'DRAFT',
  `order` int 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 `partners`
--

INSERT INTO `partners` (`id`, `name`, `logo`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, NULL, 'partners\\June2024\\kLoDN2ROXN6YLfqrgdbQ.png', 'PUBLISHED', 1, '2024-06-04 22:16:10', '2024-06-04 22:16:10'),
(2, NULL, 'partners\\June2024\\ZTzIs8HwXDJlVz8nSO0n.png', 'PUBLISHED', 2, '2024-06-04 22:16:19', '2024-06-04 22:16:19'),
(3, NULL, 'partners\\June2024\\X4Eck3bRh0GsKVW7ck7b.png', 'PUBLISHED', 3, '2024-06-04 22:16:30', '2024-06-04 22:16:30'),
(4, NULL, 'partners\\June2024\\20OtgxJjvmA9JQ8QqeRo.png', 'PUBLISHED', 4, '2024-06-04 22:16:40', '2024-06-04 22:16:40'),
(5, NULL, 'partners\\June2024\\0mDBdhwekhi35CRuR7T4.png', 'PUBLISHED', 1, '2024-06-04 22:16:51', '2024-06-04 22:16:51'),
(6, NULL, 'partners\\June2024\\KPoiZ3PMkG600aqlRKDA.png', 'PUBLISHED', 5, '2024-06-04 22:17:01', '2024-06-04 22:17:01'),
(7, NULL, 'partners\\June2024\\9uz1X5jNZio03GkdIXID.png', 'PUBLISHED', 6, '2024-06-04 22:17:14', '2024-06-04 22:17:14');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(2, 'browse_bread', NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(3, 'browse_database', NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(4, 'browse_media', NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(5, 'browse_compass', NULL, '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(6, 'browse_menus', 'menus', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(7, 'read_menus', 'menus', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(8, 'edit_menus', 'menus', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(9, 'add_menus', 'menus', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(10, 'delete_menus', 'menus', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(11, 'browse_roles', 'roles', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(12, 'read_roles', 'roles', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(13, 'edit_roles', 'roles', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(14, 'add_roles', 'roles', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(15, 'delete_roles', 'roles', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(16, 'browse_users', 'users', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(17, 'read_users', 'users', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(18, 'edit_users', 'users', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(19, 'add_users', 'users', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(20, 'delete_users', 'users', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(21, 'browse_settings', 'settings', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(22, 'read_settings', 'settings', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(23, 'edit_settings', 'settings', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(24, 'add_settings', 'settings', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(25, 'delete_settings', 'settings', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(26, 'browse_categories', 'categories', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(27, 'read_categories', 'categories', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(28, 'edit_categories', 'categories', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(29, 'add_categories', 'categories', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(30, 'delete_categories', 'categories', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(31, 'browse_posts', 'posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(32, 'read_posts', 'posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(33, 'edit_posts', 'posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(34, 'add_posts', 'posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(35, 'delete_posts', 'posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(36, 'browse_pages', 'pages', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(37, 'read_pages', 'pages', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(38, 'edit_pages', 'pages', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(39, 'add_pages', 'pages', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(40, 'delete_pages', 'pages', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(41, 'browse_loan_options', 'loan_options', '2024-06-03 21:57:12', '2024-06-03 21:57:12'),
(42, 'read_loan_options', 'loan_options', '2024-06-03 21:57:12', '2024-06-03 21:57:12'),
(43, 'edit_loan_options', 'loan_options', '2024-06-03 21:57:12', '2024-06-03 21:57:12'),
(44, 'add_loan_options', 'loan_options', '2024-06-03 21:57:12', '2024-06-03 21:57:12'),
(45, 'delete_loan_options', 'loan_options', '2024-06-03 21:57:12', '2024-06-03 21:57:12'),
(46, 'browse_testimonials', 'testimonials', '2024-06-04 21:00:46', '2024-06-04 21:00:46'),
(47, 'read_testimonials', 'testimonials', '2024-06-04 21:00:46', '2024-06-04 21:00:46'),
(48, 'edit_testimonials', 'testimonials', '2024-06-04 21:00:46', '2024-06-04 21:00:46'),
(49, 'add_testimonials', 'testimonials', '2024-06-04 21:00:46', '2024-06-04 21:00:46'),
(50, 'delete_testimonials', 'testimonials', '2024-06-04 21:00:46', '2024-06-04 21:00:46'),
(51, 'browse_partners', 'partners', '2024-06-04 21:53:51', '2024-06-04 21:53:51'),
(52, 'read_partners', 'partners', '2024-06-04 21:53:51', '2024-06-04 21:53:51'),
(53, 'edit_partners', 'partners', '2024-06-04 21:53:51', '2024-06-04 21:53:51'),
(54, 'add_partners', 'partners', '2024-06-04 21:53:51', '2024-06-04 21:53:51'),
(55, 'delete_partners', 'partners', '2024-06-04 21:53:51', '2024-06-04 21:53:51'),
(56, 'browse_learnings', 'learnings', '2024-08-23 09:08:40', '2024-08-23 09:08:40'),
(57, 'read_learnings', 'learnings', '2024-08-23 09:08:40', '2024-08-23 09:08:40'),
(58, 'edit_learnings', 'learnings', '2024-08-23 09:08:40', '2024-08-23 09:08:40'),
(59, 'add_learnings', 'learnings', '2024-08-23 09:08:40', '2024-08-23 09:08:40'),
(60, 'delete_learnings', 'learnings', '2024-08-23 09:08:40', '2024-08-23 09:08:40');

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

--
-- Table structure for table `permission_role`
--

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

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 3),
(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),
(31, 3),
(32, 1),
(32, 3),
(33, 1),
(33, 3),
(34, 1),
(34, 3),
(35, 1),
(35, 3),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(41, 3),
(42, 1),
(42, 3),
(43, 1),
(43, 3),
(44, 1),
(44, 3),
(45, 1),
(45, 3),
(46, 1),
(46, 3),
(47, 1),
(47, 3),
(48, 1),
(48, 3),
(49, 1),
(49, 3),
(50, 1),
(50, 3),
(51, 1),
(51, 3),
(52, 1),
(52, 3),
(53, 1),
(53, 3),
(54, 1),
(54, 3),
(55, 1),
(55, 3),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int UNSIGNED NOT NULL,
  `author_id` int NOT NULL,
  `category_id` int DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('PUBLISHED','DRAFT','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `author_id`, `category_id`, `title`, `seo_title`, `excerpt`, `body`, `image`, `slug`, `meta_description`, `meta_keywords`, `status`, `featured`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'Test text', NULL, 'This is the excerpt for the Lorem Ipsum Post', '<p>This is the body of the lorem ipsum post</p>', 'posts/post1.jpg', 'test-text', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2024-01-13 00:55:54', '2024-09-26 19:43:53'),
(2, 0, NULL, 'My Sample Post', NULL, 'This is the excerpt for the sample Post', '<p>This is the body for the sample post, which includes the body.</p>\n                <h2>We can use all kinds of format!</h2>\n                <p>And include a bunch of other stuff.</p>', 'posts/post2.jpg', 'my-sample-post', 'Meta Description for sample post', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(3, 0, NULL, 'Latest Post', NULL, 'This is the excerpt for the latest post', '<p>This is the body for the latest post</p>', 'posts/post3.jpg', 'latest-post', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(4, 1, 1, 'Yarr Post', NULL, 'Reef sails nipperkin bring a spring upon her cable coffer jury mast spike marooned Pieces of Eight poop deck pillage.', '<p>Swab deadlights Buccaneer fire ship square-rigged dance the hempen jig weigh anchor cackle fruit grog furl. Crack Jennys tea cup chase guns pressgang hearties spirits hogshead Gold Road six pounders fathom measured fer yer chains. Main sheet provost come about trysail barkadeer crimp scuttle mizzenmast brig plunder.</p>\r\n<p>Mizzen league keelhaul galleon tender cog chase Barbary Coast doubloon crack Jennys tea cup. Blow the man down lugsail fire ship pinnace cackle fruit line warp Admiral of the Black strike colors doubloon. Tackle Jack Ketch come about crimp rum draft scuppers run a shot across the bow haul wind maroon.</p>\r\n<ul>\r\n<li>Interloper heave down list driver pressgang holystone scuppers tackle scallywag bilged</li>\r\n<li>on her anchor. Jack Tar interloper draught grapple mizzenmast hulk knave</li>\r\n<li>cable transom hogshead. Gaff pillage to go on account grog aft chase guns piracy yardarm knave clap of thunder.</li>\r\n</ul>', 'posts/post4.jpg', 'yarr-post', 'this be a meta descript', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2024-01-13 00:55:54', '2024-06-07 20:14:54');

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

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

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(2, 'user', 'Normal User', '2024-01-13 00:55:53', '2024-01-13 00:55:53'),
(3, 'manager', 'manager', '2024-06-07 19:14:33', '2024-06-07 19:14:33');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '1',
  `group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'INK MORTGAGE', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', 'settings\\June2024\\HxwhfNg18rPEYC2g9be4.png', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', NULL, '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', '', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'INK MORTGAGE', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Welcome to Admin Panel of Inkmortgage', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', '', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', 'settings/June2024/TuwRjfuZvFIBDEyuRo3U.png', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', NULL, '', 'text', 1, 'Admin');

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

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

CREATE TABLE `testimonials` (
  `id` int UNSIGNED NOT NULL,
  `quote` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `star` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('PUBLISHED','DRAFT','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `order` int 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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `quote`, `image`, `star`, `name`, `designation`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, 'I would like to thank all the team of ink mortgage and specially to Ishrat Khurshid this is my 3rd time working with him and I would recommend Ishrat to any one who is looking for a good broker he is really honest and always looking for the best interest of the client.', 'testimonials\\June2024\\7c2KWyne8xINJDCi3krR.png', 5, 'Montoya', 'Port Saint Lucie, FL', 'PUBLISHED', 1, '2024-06-04 21:06:00', '2024-06-04 22:30:07'),
(2, 'Ishrat did a great job helping me with a home acquisition and loan. Even with the market being busy, we were able to close on time. Great job! Well done!', 'testimonials\\June2024\\fRSJ8ioCB5ScO0QTjFm0.png', 5, 'jplaw55', 'Hollywood, FL', 'PUBLISHED', 2, '2024-06-04 22:27:23', '2024-06-04 22:27:23'),
(3, 'Very professional very efficient lender did everything on time lender kept me informed of all details of the loan I would highly recommend the lender for a new purchase or refinance', 'testimonials\\June2024\\kuEiDR6eFhcs4soyWYSR.png', 5, 'carlosarnoldo', 'Port Saint Lucie, FL', 'PUBLISHED', 3, '2024-06-04 22:29:03', '2024-06-04 22:29:03'),
(4, 'Over the years Ishrat has become a very good friend of mine. He has helped me buy homes and obtain multiple mortgages. I have been able to completely rely on his sound judgement.', 'testimonials\\June2024\\l2UZR7Fj8olKkRbLLVlm.png', 5, 'khrmsaeed', 'Pompano Beach, FL', 'PUBLISHED', 4, '2024-06-04 22:29:59', '2024-06-04 22:29:59');

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

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` int UNSIGNED NOT NULL,
  `table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int UNSIGNED NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `translations`
--

INSERT INTO `translations` (`id`, `table_name`, `column_name`, `foreign_key`, `locale`, `value`, `created_at`, `updated_at`) VALUES
(1, 'data_types', 'display_name_singular', 5, 'pt', 'Post', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(2, 'data_types', 'display_name_singular', 6, 'pt', 'Página', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(3, 'data_types', 'display_name_singular', 1, 'pt', 'Utilizador', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(4, 'data_types', 'display_name_singular', 4, 'pt', 'Categoria', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(5, 'data_types', 'display_name_singular', 2, 'pt', 'Menu', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(6, 'data_types', 'display_name_singular', 3, 'pt', 'Função', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(7, 'data_types', 'display_name_plural', 5, 'pt', 'Posts', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(8, 'data_types', 'display_name_plural', 6, 'pt', 'Páginas', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(9, 'data_types', 'display_name_plural', 1, 'pt', 'Utilizadores', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(10, 'data_types', 'display_name_plural', 4, 'pt', 'Categorias', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(11, 'data_types', 'display_name_plural', 2, 'pt', 'Menus', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(12, 'data_types', 'display_name_plural', 3, 'pt', 'Funções', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(13, 'categories', 'slug', 1, 'pt', 'categoria-1', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(14, 'categories', 'name', 1, 'pt', 'Categoria 1', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(15, 'categories', 'slug', 2, 'pt', 'categoria-2', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(16, 'categories', 'name', 2, 'pt', 'Categoria 2', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(17, 'pages', 'title', 1, 'pt', 'Olá Mundo', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(18, 'pages', 'slug', 1, 'pt', 'ola-mundo', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(19, 'pages', 'body', 1, 'pt', '<p>Olá Mundo. Scallywag grog swab Cat o\'nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.</p>\r\n<p>Ballast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.</p>', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(20, 'menu_items', 'title', 1, 'pt', 'Painel de Controle', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(21, 'menu_items', 'title', 2, 'pt', 'Media', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(22, 'menu_items', 'title', 12, 'pt', 'Publicações', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(23, 'menu_items', 'title', 3, 'pt', 'Utilizadores', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(24, 'menu_items', 'title', 11, 'pt', 'Categorias', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(25, 'menu_items', 'title', 13, 'pt', 'Páginas', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(26, 'menu_items', 'title', 4, 'pt', 'Funções', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(27, 'menu_items', 'title', 5, 'pt', 'Ferramentas', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(28, 'menu_items', 'title', 6, 'pt', 'Menus', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(29, 'menu_items', 'title', 7, 'pt', 'Base de dados', '2024-01-13 00:55:54', '2024-01-13 00:55:54'),
(30, 'menu_items', 'title', 10, 'pt', 'Configurações', '2024-01-13 00:55:54', '2024-01-13 00:55:54');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`) VALUES
(1, 1, 'Admin', 'admin@admin.com', 'users\\January2024\\ocFVvrStYoNa0Qd7EYGE.png', NULL, '$2y$10$el98BHHyBHyh8OJTg49u1Od9ZNoKNfDMqSP7HAJuo3wpwoAnI/Xv2', 'WDlxxJVQ0YKIB3AxVtwLWikJKGDnHwWkvq3dJm14LflMEEhOJDBusiZWj8Ia', '{\"locale\":\"en\"}', '2024-01-13 00:55:54', '2024-01-13 01:07:18'),
(2, 2, 'asdf', 'a@gmail.com', 'users/default.png', NULL, '$2y$10$FpJwYUugelYBwOnyFvslVezGzepP5rxq3/d5Ifjh/yjYMRSMCusO2', NULL, '{\"locale\":\"en\"}', '2024-01-13 00:58:38', '2024-01-13 00:58:38'),
(3, 3, 'hussain', 'hussain@eservmd.com', 'users/default.png', NULL, '$2y$10$VNbpYnSRgBNQc1LDeYj5COOAiSBdCexo/pynmHxs0tEx3QFKeVgHS', 'ZQ6Yt6pSVQsJDRZBdtMbWgPj7JCvunIoDJheUB6RioJEolRidpVYuXVdF5nE', '{\"locale\":\"en\"}', '2024-06-07 19:15:14', '2024-06-07 19:15:14');

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Indexes for table `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

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

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

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

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

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

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

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

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

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

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

--
-- Indexes for table `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

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

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- AUTO_INCREMENT for table `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

--
-- AUTO_INCREMENT for table `learnings`
--
ALTER TABLE `learnings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `loan_options`
--
ALTER TABLE `loan_options`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

