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

START TRANSACTION;



--
-- Database: `pdx-finger-printing`
--

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int(11) NOT NULL,
  `country` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','block','requires_email_activation','requires_password_modification') COLLATE utf8mb4_unicode_ci NOT NULL,
  `private_note` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `notary_commission_expiration` date DEFAULT NULL,
  `nna_background_check` date DEFAULT NULL,
  `eo_insurance_expiration` date DEFAULT NULL,
  `dual_printers` enum('no','yes','','') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_link` enum('no','yes','','') COLLATE utf8mb4_unicode_ci NOT NULL,
  `mis` enum('no','yes','','') COLLATE utf8mb4_unicode_ci NOT NULL,
  `fidelity` enum('no','yes','','') COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_american_title` enum('no','yes','','') COLLATE utf8mb4_unicode_ci NOT NULL,
  `check_payable_to` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SSN_EIN_no` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_counties` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_city` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_zipcode` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `email_verified_at`, `password`, `profile_pic`, `phone_no`, `address`, `company`, `role_id`, `country`, `city`, `state`, `zipcode`, `status`, `private_note`, `notary_commission_expiration`, `nna_background_check`, `eo_insurance_expiration`, `dual_printers`, `service_link`, `mis`, `fidelity`, `first_american_title`, `check_payable_to`, `SSN_EIN_no`, `additional_counties`, `additional_city`, `additional_zipcode`, `is_active`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `remember_token`) VALUES
(1, 'Super', 'Admin', '', 'admin@project.com', NULL, '$2y$10$0XZVYl.zAWuPBdklAob3x.ubKCa8CR1i0jg0u8IEok2KJ0w6tMx4i', 'dashboard/assets/images/no-user-image.webp', '0321256946', NULL, '', 1, 'London', 'karachi', '1', '', 'active', '', NULL, NULL, NULL, NULL, 'yes', 'yes', 'yes', 'yes', '', '', '', '', '', 1, 0, '2021-05-11 19:44:21', '2024-09-26 10:38:17', NULL, NULL),
(2, 'Agent', 'Agent', '', 'agent@project.com', NULL, '$2y$10$0XZVYl.zAWuPBdklAob3x.ubKCa8CR1i0jg0u8IEok2KJ0w6tMx4i', NULL, '0321256946', NULL, '', 2, 'London', 'karachi', '1', '', '', '', NULL, NULL, NULL, NULL, 'yes', 'yes', 'yes', 'yes', '', '', '', '', '', 1, 0, '2021-05-11 19:44:21', '2024-09-26 13:06:36', NULL, NULL),
(3, 'User', 'User', '', 'user@project.com', NULL, '$2y$10$0XZVYl.zAWuPBdklAob3x.ubKCa8CR1i0jg0u8IEok2KJ0w6tMx4i', NULL, '0321256946', NULL, '', 3, 'London', 'karachi', '1', '', '', '', NULL, NULL, NULL, NULL, 'yes', 'yes', 'yes', 'yes', '', '', '', '', '', 1, 0, '2021-05-11 19:44:21', '2024-09-26 13:06:05', NULL, NULL),
(8, 'test', 'test', 'admin@project.com', 'test@gmail.com', NULL, '$2y$10$ll7oc07QTnShI.9jPKEa1em.L7asM3kxQB7EQ/jIxvhLRvjx7uZgq', NULL, '321215154', 'test', NULL, 3, 'Pakistan', 'Karachi', 'Sindh', '2321511', 'block', 'ssssssd', NULL, NULL, NULL, NULL, 'no', 'no', 'no', 'no', NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-26 07:42:17', '2024-09-26 13:06:42', NULL, NULL),
(9, 'test', 'test', 'as@project.com', 'as@gmail.com', NULL, '$2y$10$UYOiKuHH/hBt1s6LoXeLBOPLOdMveH1c1kt0noF.WDyEBWmBpxicW', NULL, '321215154', 'test', NULL, 2, 'Pakistan', 'Karachi', 'Sindh', '2321511', 'requires_email_activation', 'sadasdsadsad', NULL, NULL, NULL, NULL, 'no', 'no', 'no', 'no', NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-26 07:47:18', '2024-09-26 07:47:18', NULL, NULL);

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

--
-- Table structure for table `user_docs`
--

CREATE TABLE `user_docs` (
  `id` int(11) NOT NULL,
  `user_id` mediumtext NOT NULL,
  `eo_insurance` mediumtext DEFAULT NULL,
  `nna_background_check` mediumtext DEFAULT NULL,
  `notary_commission` mediumtext DEFAULT NULL,
  `drivers_licence_Front` mediumtext DEFAULT NULL,
  `drivers_licence_back` mediumtext DEFAULT NULL,
  `file_w9` mediumtext DEFAULT NULL,
  `resume` mediumtext DEFAULT NULL,
  `lss_certification` mediumtext DEFAULT NULL,
  `other_documents` mediumtext DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `is_deleted` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `user_docs`
--
ALTER TABLE `user_docs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

