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

START TRANSACTION;



--
-- Database: `alpha_home_inspection`
--

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

--
-- Truncate table before insert `cdns`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `cdns`;
--
-- Dumping data for table `cdns`
--

INSERT INTO `cdns` (`id`, `status`, `cdn_path`, `cdn_root`, `location_type`) VALUES
(1, 1, 'assets/', 'assets\\', 'public'),
(2, 0, 'assets/', 'assets\\', 's3');

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

--
-- Truncate table before insert `error_logs`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `error_logs`;
-- --------------------------------------------------------

--
-- Truncate table before insert `failed_jobs`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `failed_jobs`;
-- --------------------------------------------------------

--
-- Truncate table before insert `files`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `files`;
-- --------------------------------------------------------

--
-- Truncate table before insert `master_menus`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `master_menus`;
--
-- Dumping data for table `master_menus`
--

INSERT INTO `master_menus` (`id`, `parent_id`, `display_order`, `status`, `class`, `method`, `menu`, `url`, `icon`, `query_params`, `created_at`, `updated_at`) VALUES
(2, 0, 0, 1, NULL, NULL, 'Settings', '#', 'bx bx-cog', NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(3, 2, 0, 1, 'PermissionController', 'index', 'Permissions', 'permissions.index', 'nav-icon icon-star', NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(4, 2, 0, 1, 'RoleController', 'showRoles', 'Roles', 'roles.index', 'nav-icon icon-star', NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(5, 2, 0, 1, 'SiteSettingController', 'edit', 'Site Setting', 'settings.edit', 'nav-icon icon-star', '{\"setting\": \"general\"}', '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(6, 2, 0, 1, 'SiteTemplateController', 'index', 'Templates', 'templates.index', 'nav-icon icon-star', NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(8, 0, 0, 1, 'UserController', 'index', 'Users', 'users.index', 'mdi mdi-doctor', NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(9, 2, 5, 1, 'SiteContentController', 'index', 'Site Contents', 'contents.index', NULL, NULL, '2020-09-26 10:28:34', '2025-08-19 13:44:42'),
(10, 2, 25, 1, 'MenuController', 'index', 'Menus', 'menus.index', NULL, NULL, '2020-09-28 06:47:35', '2025-08-19 13:44:42');

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

--
-- Truncate table before insert `password_resets`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `password_resets`;
-- --------------------------------------------------------

--
-- Truncate table before insert `permissions`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `permissions`;
--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `menu_id`, `p_type`, `class`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 4, 'Role List', 'RoleController', 'showRoles', '2019-04-17 14:21:32', '2025-08-19 08:14:42', NULL),
(2, 4, 'Role Create', 'RoleController', 'create', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(3, 4, 'Role Edit', 'RoleController', 'edit', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(4, 4, 'Role Delete', 'RoleController', 'destroy', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(5, 3, 'Permission List', 'PermissionController', 'index', '2019-06-12 07:00:04', '2025-08-19 08:14:42', NULL),
(6, 3, 'Permission Create', 'PermissionController', 'create', '2019-06-12 07:00:04', '2025-08-19 08:14:42', NULL),
(7, 3, 'Permission Edit', 'PermissionController', 'edit', '2019-06-12 07:00:04', '2025-08-19 08:14:42', NULL),
(8, 3, 'Permission Delete', 'PermissionController', 'destroy', '2019-06-12 07:00:04', '2025-08-19 08:14:42', NULL),
(9, 4, 'Permission Manage Role', 'PermissionController', 'manageRole', '2019-06-12 07:00:04', '2025-08-19 08:14:42', NULL),
(10, 5, 'Site Setting Create', 'SiteSettingController', 'create', '2019-06-12 08:55:44', '2025-08-19 08:14:42', NULL),
(11, 5, 'Site Setting Edit', 'SiteSettingController', 'edit', '2019-06-12 08:55:44', '2025-08-19 08:14:42', NULL),
(12, 5, 'Site Setting Delete', 'SiteSettingController', 'destroy', '2019-06-12 08:55:44', '2025-08-19 08:14:42', NULL),
(13, 6, 'Template List', 'SiteTemplateController', 'index', '2019-06-12 08:58:09', '2025-08-19 08:14:42', NULL),
(14, 6, 'Template Create', 'SiteTemplateController', 'create', '2019-06-12 09:39:27', '2025-08-19 08:14:42', NULL),
(15, 6, 'Template Edit', 'SiteTemplateController', 'edit', '2019-06-12 09:44:20', '2025-08-19 08:14:42', NULL),
(16, 6, 'Template Delete', 'SiteTemplateController', 'destroy', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(17, 9, 'Site Content List', 'SiteContentController', 'index', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(18, 9, 'Site Content Create', 'SiteContentController', 'create', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(19, 9, 'Site Content Edit', 'SiteContentController', 'edit', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(20, 9, 'Site Content Delete', 'SiteContentController', 'destroy', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(21, 8, 'User List', 'UserController', 'index', '2019-04-17 14:21:32', '2025-08-19 08:14:42', NULL),
(22, 8, 'User Create', 'UserController', 'create', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(23, 8, 'User Edit', 'UserController', 'edit', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(24, 8, 'User Delete', 'UserController', 'destroy', '2019-06-12 09:47:50', '2025-08-19 08:14:42', NULL),
(25, 10, 'Menu List', 'MenuController', 'index', '2020-09-27 19:47:35', '2025-08-19 08:14:42', NULL),
(26, 10, 'Menu Add', 'MenuController', 'create', '2020-09-27 19:47:35', '2025-08-19 08:14:42', NULL),
(27, 10, 'Menu Edit', 'MenuController', 'edit', '2020-09-27 19:47:35', '2025-08-19 08:14:42', NULL),
(28, 10, 'Menu Delete', 'MenuController', 'destroy', '2020-09-27 19:47:35', '2025-08-19 08:14:42', NULL),
(29, 5, 'Import', 'SiteSettingController', 'settingsImport', '2020-10-03 04:06:37', '2025-08-19 08:14:42', NULL),
(30, 5, 'Export', 'SiteSettingController', 'settingsExport', '2020-10-03 04:06:55', '2025-08-19 08:14:42', NULL),
(31, 5, 'Icons List', 'SiteSettingController', 'uiIcons', '2020-10-03 04:07:25', '2025-08-19 08:14:42', NULL),
(32, 5, 'UI Elements', 'SiteSettingController', 'uiElements', '2020-10-03 04:08:56', '2025-08-19 08:14:42', NULL);

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

--
-- Truncate table before insert `permission_roles`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `permission_roles`;
--
-- Dumping data for table `permission_roles`
--

INSERT INTO `permission_roles` (`id`, `pid`, `rid`) VALUES
(1, 1, 1),
(3, 2, 1),
(5, 3, 1),
(7, 4, 1),
(8, 5, 1),
(9, 6, 1),
(10, 7, 1),
(11, 8, 1),
(12, 9, 1),
(14, 10, 1),
(15, 11, 1),
(17, 12, 1),
(18, 13, 1),
(20, 14, 1),
(21, 15, 1),
(23, 16, 1),
(24, 17, 1),
(25, 18, 1),
(26, 19, 1),
(27, 20, 1),
(28, 21, 1),
(31, 22, 1),
(34, 23, 1),
(37, 24, 1),
(39, 25, 1),
(40, 26, 1),
(41, 27, 1),
(42, 28, 1);

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

--
-- Truncate table before insert `roles`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `roles`;
--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `pid`, `user_id`, `tenant_id`, `user_type_id`, `title`, `slug`, `role_scope`, `role_level`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 0, NULL, NULL, 'Super Admin', 'super-admin', 'system', 0, 1, NULL, NULL),
(2, 0, 1, NULL, NULL, 'Tenant Admin', 'tenant-admin', 'tenant', 1, 1, '2025-08-20 08:33:52', '2025-08-20 08:33:52');

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

--
-- Truncate table before insert `site_contents`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `site_contents`;
-- --------------------------------------------------------

--
-- Dumping data for table `site_contents`
--

INSERT INTO `site_contents` (`id`, `slug`, `title`, `short_description`, `long_description`, `meta_title`, `meta_keyword`, `meta_description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'about-us', 'About Us', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', NULL, NULL, NULL, '2020-09-26 10:28:48', '2025-08-19 13:44:42', NULL),
(2, 'privacy-policy', 'Privacy Policy', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', NULL, NULL, NULL, '2020-09-26 10:28:48', '2025-08-19 13:44:42', NULL),
(3, 'terms-of-use', 'Terms of Use', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book', '<p class=\"thisclass\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', 'Terms of Use', 'Terms of Use', 'Terms of Use', '2020-09-26 10:28:48', '2025-08-19 13:44:42', NULL);

--
-- Truncate table before insert `site_templates`
--

-- -- TRUNCATE TABLE `cdns`; TABLE `cdns`; TABLE `site_templates`;
-- --------------------------------------------------------

--
-- Dumping data for table `site_templates`
--

INSERT INTO `site_templates` (`id`, `status`, `template_type`, `pdf_paper_size`, `pdf_paper_layout`, `template_name`, `subject`, `template_content`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 4, 0, 'register', 'Thank you for registering with us', ' <table class=\"es-content\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td style=\"padding:0;Margin:0;background-color:#0B5394;\" bgcolor=\"#0b5394\" align=\"center\"> \r\n <table class=\"es-content-body\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:transparent;\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"left\" style=\"padding:0;Margin:0;\"> \r\n <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td width=\"600\" valign=\"top\" align=\"center\" style=\"padding:0;Margin:0;\"> \r\n <table style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:separate;border-spacing:0px;background-color:#FFFFFF;border-radius:4px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\" role=\"presentation\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"center\" style=\"Margin:0;padding-bottom:5px;padding-left:30px;padding-right:30px;padding-top:35px;\"><h1 style=\"Margin:0;line-height:58px;mso-line-height-rule:exactly;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;font-size:48px;font-style:normal;font-weight:normal;color:#111111;\">Verify your email</h1></td> \r\n </tr> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td bgcolor=\"#ffffff\" align=\"center\" style=\"Margin:0;padding-top:5px;padding-bottom:5px;padding-left:20px;padding-right:20px;font-size:0;\"> \r\n <table width=\"100%\" height=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" role=\"presentation\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td style=\"padding:0;Margin:0px;border-bottom:1px solid #FFFFFF;background:#FFFFFFnone repeat scroll 0% 0%;height:1px;width:100%;margin:0px;\"></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table> \r\n <table class=\"es-content\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"center\" style=\"padding:0;Margin:0;\"> \r\n <table class=\"es-content-body\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:#FFFFFF;\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\" align=\"center\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"left\" style=\"padding:0;Margin:0;\"> \r\n <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td width=\"600\" valign=\"top\" align=\"center\" style=\"padding:0;Margin:0;\"> \r\n <table style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:#FFFFFF;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\" role=\"presentation\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td class=\"es-m-txt-l\" bgcolor=\"#ffffff\" align=\"left\" style=\"Margin:0;padding-bottom:15px;padding-top:20px;padding-left:30px;padding-right:30px;\"><p style=\"Margin:0;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-size:18px;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;line-height:27px;color:#666666;\">Hello {{name}}.<br>Your registration with LivDocs account has been complete, however you must verify your email for uninterrupted usage of the platform.<br><br>\r\n {{extra_text}}\r\n Happy Consultation!<br></p></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"left\" style=\"padding:0;Margin:0;padding-bottom:20px;padding-left:30px;padding-right:30px;\"> \r\n <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td width=\"540\" valign=\"top\" align=\"center\" style=\"padding:0;Margin:0;\"> \r\n <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" role=\"presentation\" style=\"mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;\"> \r\n <tr style=\"border-collapse:collapse;\"> \r\n <td align=\"center\" style=\"Margin:0;padding-left:10px;padding-right:10px;padding-top:40px;padding-bottom:40px;\"><span class=\"es-button-border\" style=\"border-style:solid;border-color:#9FC5E8;background:#0B5394;border-width:1px;display:inline-block;border-radius:2px;width:auto;\"><a href=\"{{activation_link}}\" class=\"es-button\" target=\"_blank\" style=\"mso-style-priority:100 !important;text-decoration:none;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-family:helvetica, \'helvetica neue\', arial, verdana, sans-serif;font-size:20px;color:#FFFFFF;border-style:solid;border-color:#0B5394;border-width:15px 25px;display:inline-block;background:#0B5394;border-radius:2px;font-weight:normal;font-style:normal;line-height:24px;width:auto;text-align:center;\">Verify Your Email</a></span></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table></td> \r\n </tr> \r\n </table> ', '2019-04-09 16:33:45', '2025-08-19 13:44:42', NULL),
(2, 1, 1, 4, 0, 'forgot_password', 'Forgot Pasword', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Table Card Open // -->\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color:#ffffff; border-style:solid; width:100%\">\r\n <tbody>\r\n <tr><!-- Header Top Border // -->\r\n <td style=\"background-color:#0d3349\">&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Hero Image // --><a href=\"{{site_url}}\" target=\"_blank\"><img alt=\"{{site_name}}\" src=\"{{site_url}}/images/user-account.png\" style=\"height:auto; width:100%\" /> </a></td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Main Title Text // -->\r\n <h2 style=\"font-style:normal\">&nbsp;Hi {{first_name}}</h2>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\">&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\">\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Description Text// -->\r\n <hr />&nbsp;You have requested for password recovery. Please <a href=\"{{activation_link}}\">Click here</a> to recover your password.</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:middle; text-align: center;\"><!-- Image and Link // --><a href=\"{{site_url}}\" target=\"_blank\"><img alt=\"{{site_name}}\" src=\"{{site_url}}/images/logo.png\" style=\"height:auto; width:auto\" /> </a></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n <!-- Table Card Close// --><!-- Space -->\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>', '2019-04-16 16:56:10', '2025-08-19 13:44:42', NULL),
(3, 1, 1, 4, 0, 'set_new_password', 'Set New Pasword', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Table Card Open // -->\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color:#ffffff; border-style:solid; width:100%\">\r\n <tbody>\r\n <tr><!-- Header Top Border // -->\r\n <td style=\"background-color:#0d3349\">&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Hero Image // --><a href=\"{{site_url}}\" target=\"_blank\"><img alt=\"{{site_name}}\" src=\"{{site_url}}/images/user-account.png\" style=\"height:auto; width:100%\" /> </a></td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Main Title Text // -->\r\n <h2 style=\"font-style:normal\">&nbsp;Hi {{first_name}}</h2>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\">&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:top\">\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td style=\"vertical-align:top\"><!-- Description Text// -->\r\n <hr />&nbsp;Welcome to LivDocs. Please <a href=\"{{activation_link}}\">Click here</a> to set your password.</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td style=\"vertical-align:middle; text-align: center;\"><!-- Image and Link // --><a href=\"{{site_url}}\" target=\"_blank\"><img alt=\"{{site_name}}\" src=\"{{site_url}}/images/logo.png\" style=\"height:auto; width:auto\" /> </a></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n <!-- Table Card Close// --><!-- Space -->\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>', '2019-04-16 16:56:10', '2025-08-19 13:44:42', NULL),
(4, 1, 1, 4, 0, 'resend_verify_email', 'Verify Your Email', '<table class=\"es-content\" style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px; table-layout: fixed !important; width: 100%;\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0; background-color: #0b5394;\" align=\"center\" bgcolor=\"#0b5394\">\r\n<table class=\"es-content-body\" style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px; background-color: transparent;\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"left\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"center\" valign=\"top\" width=\"600\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: separate; border-spacing: 0px; background-color: #ffffff; border-radius: 4px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"margin: 0; padding: 35px 30px 5px 30px;\" align=\"center\">\r\n<h1 style=\"margin: 0; line-height: 58px; mso-line-height-rule: exactly; font-family: lato, \'helvetica neue\', helvetica, arial, sans-serif; font-size: 48px; font-style: normal; font-weight: normal; color: #111111;\">Verify your email</h1>\r\n</td>\r\n</tr>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"margin: 0; font-size: 0; padding: 5px 20px 5px 20px;\" align=\"center\" bgcolor=\"#ffffff\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0px; border-bottom: 1px solid #FFFFFF; background: #FFFFFFnone repeat scroll 0% 0%; height: 1px; width: 100%;\">&nbsp;</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table class=\"es-content\" style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px; table-layout: fixed !important; width: 100%;\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"center\">\r\n<table class=\"es-content-body\" style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px; background-color: #ffffff;\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"left\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"center\" valign=\"top\" width=\"600\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px; background-color: #ffffff;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td class=\"es-m-txt-l\" style=\"margin: 0; padding: 20px 30px 15px 30px;\" align=\"left\" bgcolor=\"#ffffff\">\r\n<p style=\"margin: 0; -webkit-text-size-adjust: none; -ms-text-size-adjust: none; mso-line-height-rule: exactly; font-size: 18px; font-family: lato, \'helvetica neue\', helvetica, arial, sans-serif; line-height: 27px; color: #666666;\">Hello {{name}}.<br /> Your email verification is pending.<br /><br />Click below button to verify your account.</p>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0; padding-bottom: 20px; padding-left: 30px; padding-right: 30px;\" align=\"left\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"padding: 0; margin: 0;\" align=\"center\" valign=\"top\" width=\"540\">\r\n<table style=\"mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-collapse: collapse; border-spacing: 0px;\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr style=\"border-collapse: collapse;\">\r\n<td style=\"margin: 0; padding: 40px 10px 40px 10px;\" align=\"center\"><span class=\"es-button-border\" style=\"background: #0B5394; display: inline-block; border-radius: 2px; width: auto; border: 1px solid #9FC5E8;\"><a class=\"es-button\" style=\"mso-style-priority: 100 !important; text-decoration: none; -webkit-text-size-adjust: none; -ms-text-size-adjust: none; mso-line-height-rule: exactly; font-family: helvetica, \'helvetica neue\', arial, verdana, sans-serif; font-size: 20px; color: #ffffff; border-style: solid; border-color: #0B5394; border-width: 15px 25px; display: inline-block; background: #0B5394; border-radius: 2px; font-weight: normal; font-style: normal; line-height: 24px; width: auto; text-align: center;\" href=\"{{activation_link}}\" target=\"_blank\">Verify Your Email</a></span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>', '2019-04-16 16:56:10', '2025-08-19 13:44:42', NULL);

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

--
-- Truncate table before insert `user_roles`
--

-- TRUNCATE TABLE `cdns`; TABLE `user_roles`;
--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `user_id`, `role_id`) VALUES
(5, 1, 1);

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

--
-- Truncate table before insert `user_types`
--

-- TRUNCATE TABLE `cdns`; TABLE `user_types`;
--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Customer', NULL, NULL),
(2, 'Inspector', NULL, NULL),
(3, 'Agent', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `files_entity_id_index` (`entity_id`),
  ADD KEY `files_cdn_id_foreign` (`cdn_id`);

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

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

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

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

--
-- Indexes for table `permission_roles`
--
ALTER TABLE `permission_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_roles_pid_rid_index` (`pid`,`rid`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_role` (`tenant_id`,`user_type_id`,`title`),
  ADD KEY `roles_user_type_id_foreign` (`user_type_id`);

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

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

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

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_roles_user_id_foreign` (`user_id`),
  ADD KEY `user_roles_role_id_foreign` (`role_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_cdn_id_foreign` FOREIGN KEY (`cdn_id`) REFERENCES `cdns` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `roles_user_type_id_foreign` FOREIGN KEY (`user_type_id`) REFERENCES `user_types` (`id`) ON DELETE CASCADE;

--
-- 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;

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

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

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

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

