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

START TRANSACTION;



--
-- Database: `clientappdb`
--

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

--
-- Table structure for table `account_type`
--

CREATE TABLE `account_type` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_type` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

--
-- Table structure for table `admin_client_assoc`
--

CREATE TABLE `admin_client_assoc` (
  `id` int(10) UNSIGNED NOT NULL,
  `main_admin_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

--
-- Table structure for table `admin_logs`
--

CREATE TABLE `admin_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `done_by` int(11) NOT NULL,
  `action` varchar(100) NOT NULL,
  `note` text CHARACTER SET utf8,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `role_name` varchar(200) NOT NULL,
  `permissions` text NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

--
-- Table structure for table `admin_roles_assoc`
--

CREATE TABLE `admin_roles_assoc` (
  `id` int(10) UNSIGNED NOT NULL,
  `main_admin_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

--
-- Table structure for table `client_department`
--

CREATE TABLE `client_department` (
  `department_id` int(10) UNSIGNED NOT NULL,
  `client_id` int(11) NOT NULL,
  `department_name` varchar(50) NOT NULL,
  `department_code` varchar(10) NOT NULL,
  `department_order` int(11) NOT NULL,
  `department_status` varchar(1) NOT NULL DEFAULT 'A',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `client_department`
--

INSERT INTO `client_department` (`department_id`, `client_id`, `department_name`, `department_code`, `department_order`, `department_status`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, 0, 'm', 'n', 0, 'A', NULL, '2022-10-04 05:40:19', '2022-10-18 06:04:04', '2022-10-18 06:04:04'),
(5, 0, 'bgjhghj', 'hjkjhk', 0, 'A', NULL, '2022-10-07 02:20:20', '2022-11-03 09:48:27', NULL),
(6, 0, 'test new1', 'asdsa', 0, 'A', NULL, '2022-10-07 02:20:53', '2022-10-18 05:28:45', NULL),
(7, 0, 'sxada', 'adsasf', 0, 'A', NULL, '2022-10-07 02:21:20', '2022-11-03 09:48:31', NULL),
(8, 0, 'ddd', 'ff', 0, 'A', NULL, '2022-10-07 02:30:20', '2022-10-07 02:52:30', NULL),
(9, 0, 'Asadasdas', 'asdsadsad', 0, 'A', NULL, '2022-10-17 05:42:46', '2022-10-17 05:42:46', NULL),
(10, 0, 'Test', 'adsadsa', 0, 'A', NULL, '2022-10-17 05:50:13', '2022-10-17 05:50:13', NULL),
(11, 0, 'rtyuiopopopo', 'adsa343', 0, 'A', NULL, '2022-10-17 05:51:27', '2022-10-17 05:51:27', NULL),
(12, 0, 'asdasd', 'asdasd', 0, 'A', NULL, '2022-10-17 05:51:46', '2022-10-17 05:51:46', NULL),
(13, 0, 'adasd', 'asdsad', 0, 'A', NULL, '2022-10-17 05:52:36', '2022-10-17 05:52:36', NULL),
(14, 0, 'adsad', 'asdsa54', 0, 'A', NULL, '2022-10-17 05:53:27', '2022-10-20 08:56:28', '2022-10-20 08:56:28'),
(15, 0, 'sadasdsad', 'sadasdas', 0, 'A', NULL, '2022-10-17 05:54:17', '2022-10-20 08:56:37', '2022-10-20 08:56:37'),
(16, 0, 'asdsad', 'asdsad', 0, 'A', NULL, '2022-10-17 05:54:58', '2022-10-17 08:36:48', NULL),
(17, 0, 'nesto', 'NSTO', 0, 'A', NULL, '2022-10-17 05:55:21', '2022-10-17 08:47:17', NULL),
(18, 0, 'Uio', 'asd45', 0, 'A', NULL, '2022-10-17 05:59:28', '2022-10-17 08:36:53', NULL),
(19, 0, 'asddasd', 'sadasd', 0, 'A', NULL, '2022-10-17 06:01:04', '2022-10-17 06:01:04', NULL),
(20, 0, 'asdsad', 'sadsad', 0, 'A', NULL, '2022-10-17 06:59:10', '2022-10-17 06:59:10', NULL),
(21, 0, 'asdsadsad', 'asssssssss', 0, 'A', NULL, '2022-10-17 07:42:41', '2022-10-17 07:42:41', NULL),
(22, 0, 'adsdasd', 'asdsad', 0, 'A', NULL, '2022-10-17 08:46:46', '2022-10-17 08:46:46', NULL),
(23, 0, 'asdasd', 'asdasd', 0, 'A', NULL, '2022-10-18 06:42:51', '2022-10-18 06:42:51', NULL);

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

--
-- Table structure for table `client_designation`
--

CREATE TABLE `client_designation` (
  `designation_id` int(10) UNSIGNED NOT NULL,
  `department_id` int(11) NOT NULL,
  `designation_name` varchar(50) NOT NULL,
  `designation_key` varchar(50) NOT NULL,
  `designation_permissions` varchar(100) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `client_designation`
--

INSERT INTO `client_designation` (`designation_id`, `department_id`, `designation_name`, `designation_key`, `designation_permissions`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 8, 'ntest', '', '', NULL, '2022-10-07 04:56:09', '2022-11-03 09:46:34', NULL),
(3, 4, 'new edit', '', '', NULL, '2022-10-10 02:11:11', '2022-10-18 06:04:04', '2022-10-18 06:04:04'),
(4, 17, 'test new1', '', '', NULL, '2022-10-10 02:11:40', '2022-10-18 05:24:31', NULL),
(5, 7, 'test nwww', '', '', NULL, '2022-10-10 02:11:54', '2022-10-18 02:32:56', NULL),
(6, 6, 'dsadsad', '', '', NULL, '2022-10-18 02:47:11', '2022-10-18 05:24:24', '2022-10-18 05:24:24'),
(7, 6, 'asdasdsa', '', '', NULL, '2022-10-18 05:25:27', '2022-10-18 05:25:27', NULL),
(8, 6, 'fdasdsad', '', '', NULL, '2022-10-18 05:26:12', '2022-10-18 05:26:12', NULL),
(9, 18, 'aasdsad', '', '', NULL, '2022-10-18 06:20:17', '2022-10-18 06:30:52', NULL),
(10, 19, 'asdsad', '', '', NULL, '2022-10-18 06:43:00', '2022-10-18 06:43:00', NULL),
(11, 19, 'test new1', '', '', NULL, '2022-10-18 06:43:28', '2022-10-18 06:43:28', NULL),
(12, 20, 'adsdasd', '', '', NULL, '2022-10-18 06:54:03', '2022-10-18 06:54:03', NULL),
(13, 19, 'Test44', '', '', NULL, '2022-10-18 06:54:17', '2022-10-20 08:58:35', '2022-10-20 08:58:35'),
(14, 20, 'test new1', '', '', NULL, '2022-10-18 06:55:02', '2022-10-20 08:58:40', '2022-10-20 08:58:40'),
(15, 18, 'asdasd', '', '', NULL, '2022-10-18 06:55:26', '2022-10-18 06:55:26', NULL),
(16, 18, 'asdsad', '', '', NULL, '2022-10-18 06:56:37', '2022-10-18 06:56:37', NULL),
(17, 16, 'asdsad', '', '', NULL, '2022-10-18 06:57:15', '2022-10-18 06:57:15', NULL),
(18, 20, 'sdasd', '', '', NULL, '2022-10-18 06:57:45', '2022-10-18 06:57:45', NULL),
(19, 15, 'asdasd', '', '', NULL, '2022-10-18 06:57:56', '2022-10-20 08:56:37', '2022-10-20 08:56:37'),
(20, 20, 'asdsad', '', '', NULL, '2022-10-18 07:01:03', '2022-10-18 07:01:03', NULL),
(21, 5, 'test', '', '', NULL, '2022-11-01 10:32:24', '2022-11-01 10:32:24', NULL);

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

--
-- Table structure for table `client_logs`
--

CREATE TABLE `client_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `done_by` int(11) NOT NULL,
  `role` varchar(50) NOT NULL,
  `action` varchar(100) NOT NULL,
  `note` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `client_logs`
--

INSERT INTO `client_logs` (`id`, `done_by`, `role`, `action`, `note`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'SA', 'Disabled Successfully.', NULL, '2022-10-12 04:37:40', '2022-10-12 04:37:40', NULL),
(2, 1, 'SA', 'Client Enabled.', NULL, '2022-10-12 04:39:05', '2022-10-12 04:39:05', NULL),
(3, 1, 'SA', 'Client Enabled.', NULL, '2022-10-12 07:44:22', '2022-10-12 07:44:22', NULL),
(4, 1, 'SA', 'Client Disabled.', NULL, '2022-10-12 07:44:42', '2022-10-12 07:44:42', NULL),
(5, 1, 'SA', 'Client Enabled.', NULL, '2022-10-12 08:40:10', '2022-10-12 08:40:10', NULL),
(6, 1, 'SA', 'Client Disabled.', NULL, '2022-10-12 08:40:16', '2022-10-12 08:40:16', NULL),
(7, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:01:53', '2022-10-13 01:01:53', NULL),
(8, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:02:33', '2022-10-13 01:02:33', NULL),
(9, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:02:44', '2022-10-13 01:02:44', NULL),
(10, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:05:48', '2022-10-13 01:05:48', NULL),
(11, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:06:10', '2022-10-13 01:06:10', NULL),
(12, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:06:39', '2022-10-13 01:06:39', NULL),
(13, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:11:55', '2022-10-13 01:11:55', NULL),
(14, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:12:12', '2022-10-13 01:12:12', NULL),
(15, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:14:13', '2022-10-13 01:14:13', NULL),
(16, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 01:20:10', '2022-10-13 01:20:10', NULL),
(17, 1, 'SA', 'Client Enabled.', NULL, '2022-10-13 01:27:45', '2022-10-13 01:27:45', NULL),
(18, 1, 'SA', 'Client Disabled.', NULL, '2022-10-13 01:28:58', '2022-10-13 01:28:58', NULL),
(19, 1, 'SA', 'Client Enabled.', NULL, '2022-10-13 01:29:02', '2022-10-13 01:29:02', NULL),
(20, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 03:54:43', '2022-10-13 03:54:43', NULL),
(21, 1, 'SA', 'Client Created.', NULL, '2022-10-13 04:04:34', '2022-10-13 04:04:34', NULL),
(22, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 04:48:11', '2022-10-13 04:48:11', NULL),
(23, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 05:22:25', '2022-10-13 05:22:25', NULL),
(24, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 05:30:43', '2022-10-13 05:30:43', NULL),
(25, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 05:35:34', '2022-10-13 05:35:34', NULL),
(26, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 05:50:24', '2022-10-13 05:50:24', NULL),
(27, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-13 05:51:16', '2022-10-13 05:51:16', NULL),
(28, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-13 09:18:18', '2022-10-13 09:18:18', NULL),
(29, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-13 09:27:40', '2022-10-13 09:27:40', NULL),
(30, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:17:17', '2022-10-14 01:17:17', NULL),
(31, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:17:38', '2022-10-14 01:17:38', NULL),
(32, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:17:46', '2022-10-14 01:17:46', NULL),
(33, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:32:32', '2022-10-14 01:32:32', NULL),
(34, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:34:18', '2022-10-14 01:34:18', NULL),
(35, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:35:23', '2022-10-14 01:35:23', NULL),
(36, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:35:47', '2022-10-14 01:35:47', NULL),
(37, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:36:01', '2022-10-14 01:36:01', NULL),
(38, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:36:17', '2022-10-14 01:36:17', NULL),
(39, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:36:27', '2022-10-14 01:36:27', NULL),
(40, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:39:00', '2022-10-14 01:39:00', NULL),
(41, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:39:57', '2022-10-14 01:39:57', NULL),
(42, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:40:11', '2022-10-14 01:40:11', NULL),
(43, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 01:40:21', '2022-10-14 01:40:21', NULL),
(44, 1, 'SA', 'Client Disabled.', NULL, '2022-10-14 01:54:32', '2022-10-14 01:54:32', NULL),
(45, 1, 'SA', 'Client Enabled.', NULL, '2022-10-14 01:55:42', '2022-10-14 01:55:42', NULL),
(46, 1, 'SA', 'Client Disabled.', NULL, '2022-10-14 02:03:27', '2022-10-14 02:03:27', NULL),
(47, 1, 'SA', 'Client Disabled.', NULL, '2022-10-14 02:07:57', '2022-10-14 02:07:57', NULL),
(48, 1, 'SA', 'Client Disabled.', NULL, '2022-10-14 02:08:08', '2022-10-14 02:08:08', NULL),
(49, 1, 'SA', 'Client Enabled.', NULL, '2022-10-14 02:08:14', '2022-10-14 02:08:14', NULL),
(50, 1, 'SA', 'Client Enabled.', NULL, '2022-10-14 02:15:25', '2022-10-14 02:15:25', NULL),
(51, 1, 'SA', 'Client Enabled.', NULL, '2022-10-14 02:16:31', '2022-10-14 02:16:31', NULL),
(52, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 04:11:12', '2022-10-14 04:11:12', NULL),
(53, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 04:11:35', '2022-10-14 04:11:35', NULL),
(54, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 04:12:43', '2022-10-14 04:12:43', NULL),
(55, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 05:52:34', '2022-10-14 05:52:34', NULL),
(56, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 06:07:16', '2022-10-14 06:07:16', NULL),
(57, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 06:08:13', '2022-10-14 06:08:13', NULL),
(58, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-14 06:10:40', '2022-10-14 06:10:40', NULL),
(59, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:26:26', '2022-10-14 06:26:26', NULL),
(60, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:26:45', '2022-10-14 06:26:45', NULL),
(61, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:26:53', '2022-10-14 06:26:53', NULL),
(62, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:26:58', '2022-10-14 06:26:58', NULL),
(63, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:27:56', '2022-10-14 06:27:56', NULL),
(64, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:28:14', '2022-10-14 06:28:14', NULL),
(65, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-14 06:30:02', '2022-10-14 06:30:02', NULL),
(66, 1, 'SA', 'Client Created.', NULL, '2022-10-14 06:32:44', '2022-10-14 06:32:44', NULL),
(67, 1, 'SA', 'Client Enabled.', NULL, '2022-10-18 06:33:02', '2022-10-18 06:33:02', NULL),
(68, 1, 'SA', 'Client Disabled.', NULL, '2022-10-18 06:36:24', '2022-10-18 06:36:24', NULL),
(69, 1, 'SA', 'Client Enabled.', NULL, '2022-10-18 06:36:32', '2022-10-18 06:36:32', NULL),
(70, 1, 'SA', 'Client Disabled.', NULL, '2022-10-18 06:36:35', '2022-10-18 06:36:35', NULL),
(71, 1, 'SA', 'Client Enabled.', NULL, '2022-10-18 06:36:38', '2022-10-18 06:36:38', NULL),
(72, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:40:44', '2022-10-18 06:40:44', NULL),
(73, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:41:16', '2022-10-18 06:41:16', NULL),
(74, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:43:42', '2022-10-18 06:43:42', NULL),
(75, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:44:09', '2022-10-18 06:44:09', NULL),
(76, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:44:43', '2022-10-18 06:44:43', NULL),
(77, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:44:49', '2022-10-18 06:44:49', NULL),
(78, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:45:05', '2022-10-18 06:45:05', NULL),
(79, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-18 06:45:12', '2022-10-18 06:45:12', NULL),
(80, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-19 02:26:43', '2022-10-19 02:26:43', NULL),
(81, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-19 04:53:49', '2022-10-19 04:53:49', NULL),
(82, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-19 05:04:34', '2022-10-19 05:04:34', NULL),
(83, 1, 'SA', 'Client Created.', NULL, '2022-10-19 05:11:14', '2022-10-19 05:11:14', NULL),
(84, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:26:31', '2022-10-19 06:26:31', NULL),
(85, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:29:10', '2022-10-19 06:29:10', NULL),
(86, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:29:38', '2022-10-19 06:29:38', NULL),
(87, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:30:11', '2022-10-19 06:30:11', NULL),
(88, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:30:42', '2022-10-19 06:30:42', NULL),
(89, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:51:36', '2022-10-19 06:51:36', NULL),
(90, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:54:32', '2022-10-19 06:54:32', NULL),
(91, 1, 'SA', 'Client Created.', NULL, '2022-10-19 06:55:24', '2022-10-19 06:55:24', NULL),
(92, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 07:02:38', '2022-10-19 07:02:38', NULL),
(93, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 07:47:13', '2022-10-19 07:47:13', NULL),
(94, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-19 09:22:45', '2022-10-19 09:22:45', NULL),
(95, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:30:47', '2022-10-19 09:30:47', NULL),
(96, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:30:54', '2022-10-19 09:30:54', NULL),
(97, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:32:36', '2022-10-19 09:32:36', NULL),
(98, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:32:44', '2022-10-19 09:32:44', NULL),
(99, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:37:01', '2022-10-19 09:37:01', NULL),
(100, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-19 09:48:00', '2022-10-19 09:48:00', NULL),
(101, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:50:38', '2022-10-19 09:50:38', NULL),
(102, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:52:52', '2022-10-19 09:52:52', NULL),
(103, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-19 09:55:54', '2022-10-19 09:55:54', NULL),
(104, 1, 'SA', 'Client Created.', NULL, '2022-10-20 01:08:54', '2022-10-20 01:08:54', NULL),
(105, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-20 01:17:52', '2022-10-20 01:17:52', NULL),
(106, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 01:30:37', '2022-10-20 01:30:37', NULL),
(107, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 01:30:43', '2022-10-20 01:30:43', NULL),
(108, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 01:31:04', '2022-10-20 01:31:04', NULL),
(109, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 01:48:10', '2022-10-20 01:48:10', NULL),
(110, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 01:48:26', '2022-10-20 01:48:26', NULL),
(111, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 01:48:59', '2022-10-20 01:48:59', NULL),
(112, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 01:50:48', '2022-10-20 01:50:48', NULL),
(113, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 01:55:58', '2022-10-20 01:55:58', NULL),
(114, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 01:56:14', '2022-10-20 01:56:14', NULL),
(115, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 02:04:56', '2022-10-20 02:04:56', NULL),
(116, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 02:05:45', '2022-10-20 02:05:45', NULL),
(117, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 02:24:33', '2022-10-20 02:24:33', NULL),
(118, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 02:27:01', '2022-10-20 02:27:01', NULL),
(119, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 02:29:50', '2022-10-20 02:29:50', NULL),
(120, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 02:30:08', '2022-10-20 02:30:08', NULL),
(121, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 02:31:52', '2022-10-20 02:31:52', NULL),
(122, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 02:43:17', '2022-10-20 02:43:17', NULL),
(123, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-20 02:47:32', '2022-10-20 02:47:32', NULL),
(124, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-20 02:47:37', '2022-10-20 02:47:37', NULL),
(125, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-20 02:54:11', '2022-10-20 02:54:11', NULL),
(126, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 04:04:58', '2022-10-20 04:04:58', NULL),
(127, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 04:07:14', '2022-10-20 04:07:14', NULL),
(128, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 04:07:18', '2022-10-20 04:07:18', NULL),
(129, 1, 'SA', 'Client Details Updated.', NULL, '2022-10-20 04:11:37', '2022-10-20 04:11:37', NULL),
(130, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-20 04:33:38', '2022-10-20 04:33:38', NULL),
(131, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-20 04:33:44', '2022-10-20 04:33:44', NULL),
(132, 1, 'SA', 'Api Credential Updated.', NULL, '2022-10-20 04:34:05', '2022-10-20 04:34:05', NULL),
(133, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 04:41:10', '2022-10-20 04:41:10', NULL),
(134, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 04:45:21', '2022-10-20 04:45:21', NULL),
(135, 1, 'SA', 'Client Disabled.', NULL, '2022-10-20 06:45:57', '2022-10-20 06:45:57', NULL),
(136, 1, 'SA', 'Client Enabled.', NULL, '2022-10-20 06:46:14', '2022-10-20 06:46:14', NULL),
(137, 1, 'SA', 'Client Created.', NULL, '2022-11-01 03:57:20', '2022-11-01 03:57:20', NULL),
(138, 1, 'SA', 'Client Created.', NULL, '2022-11-01 07:05:06', '2022-11-01 07:05:06', NULL),
(139, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 07:43:14', '2022-11-01 07:43:14', NULL),
(140, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 07:43:20', '2022-11-01 07:43:20', NULL),
(141, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 07:43:24', '2022-11-01 07:43:24', NULL),
(142, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 07:44:34', '2022-11-01 07:44:34', NULL),
(143, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 07:51:38', '2022-11-01 07:51:38', NULL),
(144, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:10:35', '2022-11-01 08:10:35', NULL),
(145, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:10:37', '2022-11-01 08:10:37', NULL),
(146, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:13:33', '2022-11-01 08:13:33', NULL),
(147, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:13:52', '2022-11-01 08:13:52', NULL),
(148, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:13:56', '2022-11-01 08:13:56', NULL),
(149, 1, 'SA', 'Client Details Updated.', NULL, '2022-11-01 08:14:34', '2022-11-01 08:14:34', NULL),
(150, 1, 'SA', 'Api Credential Updated.', NULL, '2022-11-01 09:43:41', '2022-11-01 09:43:41', NULL),
(151, 1, 'SA', 'Api Credential Updated.', NULL, '2022-11-01 09:44:30', '2022-11-01 09:44:30', NULL),
(152, 1, 'SA', 'Api Credential Updated.', NULL, '2022-11-01 09:44:52', '2022-11-01 09:44:52', NULL),
(153, 1, 'SA', 'Api Credential Updated.', NULL, '2022-11-01 09:46:54', '2022-11-01 09:46:54', NULL),
(154, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 02:21:09', '2022-11-02 02:21:09', NULL),
(155, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 02:21:16', '2022-11-02 02:21:16', NULL),
(156, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 02:22:24', '2022-11-02 02:22:24', NULL),
(157, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 02:24:48', '2022-11-02 02:24:48', NULL),
(158, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 02:25:26', '2022-11-02 02:25:26', NULL),
(159, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 02:25:30', '2022-11-02 02:25:30', NULL),
(160, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 02:25:49', '2022-11-02 02:25:49', NULL),
(161, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 02:47:27', '2022-11-02 02:47:27', NULL),
(162, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 02:47:35', '2022-11-02 02:47:35', NULL),
(163, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 04:09:10', '2022-11-02 04:09:10', NULL),
(164, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 04:09:15', '2022-11-02 04:09:15', NULL),
(165, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 06:42:05', '2022-11-02 06:42:05', NULL),
(166, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 06:42:10', '2022-11-02 06:42:10', NULL),
(167, 1, 'SA', 'Client Disabled.', NULL, '2022-11-02 07:45:29', '2022-11-02 07:45:29', NULL),
(168, 1, 'SA', 'Client Enabled.', NULL, '2022-11-02 07:45:34', '2022-11-02 07:45:34', NULL),
(169, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-03 01:23:51', '2022-11-03 01:23:51', NULL),
(170, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-03 01:23:55', '2022-11-03 01:23:55', NULL),
(171, 1, 'super_admin', 'Client Admin Created.', NULL, '2022-11-03 05:54:42', '2022-11-03 05:54:42', NULL),
(172, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-03 09:13:33', '2022-11-03 09:13:33', NULL),
(173, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-03 09:13:39', '2022-11-03 09:13:39', NULL),
(174, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-03 09:34:02', '2022-11-03 09:34:02', NULL),
(175, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-03 09:34:15', '2022-11-03 09:34:15', NULL),
(176, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-03 09:34:39', '2022-11-03 09:34:39', NULL),
(177, 1, 'super_admin', 'Client Admin Created.', NULL, '2022-11-03 09:36:19', '2022-11-03 09:36:19', NULL),
(178, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-03 09:59:29', '2022-11-03 09:59:29', NULL),
(179, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-04 00:51:49', '2022-11-04 00:51:49', NULL),
(180, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-04 00:51:55', '2022-11-04 00:51:55', NULL),
(181, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-04 00:52:35', '2022-11-04 00:52:35', NULL),
(182, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-04 00:52:43', '2022-11-04 00:52:43', NULL),
(183, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-04 01:12:49', '2022-11-04 01:12:49', NULL),
(184, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-04 01:47:08', '2022-11-04 01:47:08', NULL),
(185, 1, 'super_admin', 'Api Credential Updated.', NULL, '2022-11-04 08:12:41', '2022-11-04 08:12:41', NULL),
(186, 1, 'super_admin', 'Api Credential Updated.', NULL, '2022-11-04 08:13:31', '2022-11-04 08:13:31', NULL),
(187, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-15 00:08:42', '2022-11-15 00:08:42', NULL),
(188, 1, 'super_admin', 'Client Admin Created.', NULL, '2022-11-15 01:00:35', '2022-11-15 01:00:35', NULL),
(189, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-15 04:38:08', '2022-11-15 04:38:08', NULL),
(190, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-15 04:38:18', '2022-11-15 04:38:18', NULL),
(191, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-15 04:38:29', '2022-11-15 04:38:29', NULL),
(192, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-15 04:44:51', '2022-11-15 04:44:51', NULL),
(193, 1, 'super_admin', 'Client Details Updated.', NULL, '2022-11-15 04:47:15', '2022-11-15 04:47:15', NULL),
(194, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-15 06:43:05', '2022-11-15 06:43:05', NULL),
(195, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-15 06:43:32', '2022-11-15 06:43:32', NULL),
(196, 1, 'super_admin', 'Client Disabled.', NULL, '2022-11-15 07:29:28', '2022-11-15 07:29:28', NULL),
(197, 1, 'super_admin', 'Client Enabled.', NULL, '2022-11-15 07:29:32', '2022-11-15 07:29:32', NULL);

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

--
-- Table structure for table `client_roles`
--

CREATE TABLE `client_roles` (
  `client_role_id` int(10) UNSIGNED NOT NULL,
  `client_role_name` varchar(200) NOT NULL,
  `client_permissions` json NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `client_roles`
--

INSERT INTO `client_roles` (`client_role_id`, `client_role_name`, `client_permissions`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'asdsa', '[\"1\", \"4\"]', '2022-10-26 02:39:10', '2022-10-26 03:57:27', NULL),
(2, 'asdasda', '[\"1\", \"4\"]', '2022-10-27 09:27:53', '2022-10-27 09:27:53', NULL),
(4, 'Test344', '[\"1\", \"4\", \"5\"]', '2022-10-28 01:55:07', '2022-10-28 01:55:07', NULL);

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

--
-- Table structure for table `client_roles_assoc`
--

CREATE TABLE `client_roles_assoc` (
  `assoc_id` int(10) UNSIGNED NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_role_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

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

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

CREATE TABLE `migrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(10) UNSIGNED NOT NULL
);

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

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(77, '2022-09-23-100215', 'App\\Database\\Migrations\\Admin', 'default', 'App', 1664356734, 1),
(78, '2022-09-23-115334', 'App\\Database\\Migrations\\AdminRoles', 'default', 'App', 1664356734, 1),
(79, '2022-09-23-115750', 'App\\Database\\Migrations\\AdminRolesAssoc', 'default', 'App', 1664356734, 1),
(80, '2022-09-23-120252', 'App\\Database\\Migrations\\AdminPermissions', 'default', 'App', 1664356735, 1),
(81, '2022-09-23-130307', 'App\\Database\\Migrations\\AdminClientAssoc', 'default', 'App', 1664356735, 1),
(82, '2022-09-23-130956', 'App\\Database\\Migrations\\ClientRoles', 'default', 'App', 1664356735, 1),
(83, '2022-09-23-131728', 'App\\Database\\Migrations\\Client', 'default', 'App', 1664356735, 1),
(84, '2022-09-23-132921', 'App\\Database\\Migrations\\ClientRolesAssoc', 'default', 'App', 1664356735, 1),
(85, '2022-09-23-133632', 'App\\Database\\Migrations\\ClientPermission', 'default', 'App', 1664356735, 1),
(86, '2022-09-28-065558', 'App\\Database\\Migrations\\ClientAdmin', 'default', 'App', 1664356735, 1),
(87, '2022-09-28-072027', 'App\\Database\\Migrations\\ClientDepartment', 'default', 'App', 1664356735, 1),
(88, '2022-09-28-073058', 'App\\Database\\Migrations\\ClientAdminDesignation', 'default', 'App', 1664356735, 1),
(89, '2022-09-28-075145', 'App\\Database\\Migrations\\Users', 'default', 'App', 1664356735, 1),
(90, '2022-09-28-092929', 'App\\Database\\Migrations\\UserTypes', 'default', 'App', 1664357632, 2),
(91, '2022-09-28-093303', 'App\\Database\\Migrations\\AccountType', 'default', 'App', 1664357632, 2),
(92, '2022-09-28-094520', 'App\\Database\\Migrations\\UserAddress', 'default', 'App', 1664359010, 3),
(93, '2022-09-28-094520', 'App\\Database\\Migrations\\ClientDesignation', 'default', 'App', 1664359010, 3),
(94, '2022-10-12-070255', 'App\\Database\\Migrations\\AdminLogs', 'default', 'App', 1665559714, 4),
(96, '2022-10-12-090655', 'App\\Database\\Migrations\\ClientLogs', 'default', 'App', 1665567370, 5);

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

--
-- Table structure for table `oauth_jwt`
--

CREATE TABLE `oauth_jwt` (
  `client_id` varchar(80) NOT NULL,
  `subject` varchar(80) DEFAULT NULL,
  `public_key` varchar(2000) NOT NULL
);

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

--
-- Table structure for table `oauth_scopes`
--

CREATE TABLE `oauth_scopes` (
  `scope` varchar(80) NOT NULL,
  `is_default` tinyint(1) DEFAULT NULL
);

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

--
-- Table structure for table `user_address`
--

CREATE TABLE `user_address` (
  `address_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `address_street` varchar(60) CHARACTER SET utf8 NOT NULL,
  `address_appartment` varchar(60) CHARACTER SET utf8 NOT NULL,
  `address_city` varchar(60) CHARACTER SET utf8 NOT NULL,
  `address_state` varchar(60) CHARACTER SET utf8 NOT NULL,
  `country_id` int(11) NOT NULL,
  `address_zipcode` varchar(10) NOT NULL,
  `address_type` char(1) CHARACTER SET utf8 NOT NULL,
  `address_status` varchar(1) NOT NULL DEFAULT 'A',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `user_address`
--

INSERT INTO `user_address` (`address_id`, `user_id`, `address_street`, `address_appartment`, `address_city`, `address_state`, `country_id`, `address_zipcode`, `address_type`, `address_status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'dfsdfsd', 'sdfsdfsd', 'sdfsdf', 'sdfsdf', 0, 'sfdfs', 's', 's', '2022-10-10 02:16:42', '2022-10-10 02:16:42', NULL),
(2, 8, 'dfsdfsd', 'sdfsdfsd', 'sdfsdf', 'sdfsdf', 0, 'sfdfs', 'C', 'A', '2022-10-12 02:18:00', '2022-10-12 02:18:00', NULL),
(3, 10, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 04:21:47', '2022-10-12 04:21:47', NULL),
(4, 11, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 04:28:18', '2022-10-12 04:28:18', NULL),
(5, 12, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 04:56:15', '2022-10-12 04:56:15', NULL),
(6, 13, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 04:59:44', '2022-10-12 04:59:44', NULL),
(7, 14, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 05:12:27', '2022-10-12 05:12:27', NULL),
(8, 15, 'dfgsdfg', 'fdgsdfg', 'dfgsdfg', 'dfgdsfg', 2, 'dfgsdgfgsd', 'C', 'A', '2022-10-12 05:53:03', '2022-10-12 05:53:03', NULL),
(9, 16, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 08:32:11', '2022-10-12 08:32:11', NULL),
(10, 17, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 09:20:32', '2022-10-12 09:20:32', NULL),
(11, 18, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-12 09:22:40', '2022-10-12 09:22:40', NULL),
(12, 19, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-14 06:00:49', '2022-10-14 06:00:49', NULL),
(13, 20, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-19 04:41:48', '2022-10-19 04:41:48', NULL),
(14, 21, ' xcvzxcv', ' xcvzxcv', ' cxvzxcv', ' xczvcvxc', 2, ' xczvzxcvx', 'C', 'A', '2022-10-21 02:53:28', '2022-10-21 02:53:28', NULL),
(15, 23, 'xcvzxcv', 'xcvzxcv', 'cxvzxcv', 'xczvcvxc', 2, 'xczvzxcvx', 'C', 'A', '2022-10-21 03:11:58', '2022-10-21 03:11:58', NULL),
(16, 25, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-26 09:13:59', '2022-10-26 09:13:59', NULL),
(17, 26, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:03:01', '2022-10-27 01:03:01', NULL),
(18, 27, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:09:10', '2022-10-27 01:09:10', NULL),
(19, 28, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:11:44', '2022-10-27 01:11:44', NULL),
(20, 29, 'dfgdfg', 'dfgdfg', 'dfgdsfg', 'fgsdfg', 2, 'dfgdsfg', 'C', 'A', '2022-10-27 01:25:09', '2022-10-27 01:25:09', NULL),
(21, 30, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:30:25', '2022-10-27 01:30:25', NULL),
(22, 31, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:31:53', '2022-10-27 01:31:53', NULL),
(23, 32, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:40:21', '2022-10-27 01:40:21', NULL),
(24, 33, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 01:42:25', '2022-10-27 01:42:25', NULL),
(25, 34, 'sdfasdf', 'sdafasdf', 'dsfsadf', 'sdafsadfsafd', 2, 'dsafasdf', 'C', 'A', '2022-10-27 02:40:08', '2022-10-27 02:40:08', NULL),
(26, 35, 'cvbxcvb', 'vcbxcvb', 'cvbxcvb', 'vcbxcvbxcvb', 2, 'cvbcxvb', 'C', 'A', '2022-10-27 02:43:52', '2022-10-27 02:43:52', NULL),
(27, 37, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 06:06:35', '2022-10-27 06:06:35', NULL),
(28, 38, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 06:09:37', '2022-10-27 06:09:37', NULL),
(29, 39, 'xcvxzcv', 'xcvzxcv', 'cxvzxvc', 'xcvxzcvx', 2, 'xcvvzxcv', 'C', 'A', '2022-10-27 06:48:08', '2022-10-27 06:48:08', NULL),
(30, 40, 'vcxvbxcvb', 'vcbxcvb', 'vcbxcvb', 'cvbxcbvxcb', 1, 'cvbxcvb', 'C', 'A', '2022-10-27 07:59:49', '2022-10-27 07:59:49', NULL),
(31, 41, 'Aasdsad', 'ad', 'asdsadsad', 'asdasdsad', 2, 'asdasdasd', 'C', 'A', '2022-10-28 04:49:57', '2022-10-31 08:06:46', NULL),
(32, 42, 'rrrrr', 'ggggggggg', 'asdsadsad', 'asdasdsad', 1, '4564654', 'C', 'A', '2022-10-28 04:53:13', '2022-10-31 06:50:12', NULL),
(33, 43, 'asdsadsad', 'asdasd', 'asdasd', 'LA', 1, '1312312', 'C', 'A', '2022-10-28 04:59:06', '2022-10-31 06:28:48', NULL),
(34, 44, 'adsdad', 'asdsadsad', 'asdasdsad', 'asdsadsad', 1, '1312312', 'C', 'A', '2022-10-28 07:05:49', '2022-10-28 07:56:06', NULL),
(35, 45, 'asdadad', 'Sdfsdfsdf', 'asdasd', 'Aadsdad', 1, '33433', 'C', 'A', '2022-10-31 04:15:57', '2022-10-31 05:26:27', NULL),
(36, 46, 'asdsad', 'asdasdasd', 'asdasd', 'asdasd', 1, '42342', 'C', 'A', '2022-10-31 06:51:29', '2022-10-31 06:51:58', NULL),
(37, 47, 'asdsad', 'asdsadsad', 'asdsadasd', 'asdsadas', 1, '23423432', 'C', 'A', '2022-10-31 08:16:51', '2022-10-31 08:16:51', NULL),
(38, 48, 'asdsadsad', 'asdasdsad', 'asdsad', 'asdsad', 2, '234444', 'C', 'A', '2022-11-01 01:57:54', '2022-11-01 01:57:54', NULL),
(39, 49, 'test', 'test', 'test', 'test', 1, 'testzip', 'C', 'A', '2022-11-01 08:24:59', '2022-11-01 08:24:59', NULL),
(40, 50, 'test', 'test', 'test', 'test', 1, 'test', 'C', 'A', '2022-11-01 08:26:30', '2022-11-01 08:26:30', NULL),
(41, 51, 'test', 'test', 'test', 'test', 1, 'test', 'C', 'A', '2022-11-01 08:27:37', '2022-11-01 08:27:37', NULL),
(42, 52, 'dfasdf', 'sdfasdf', 'dsfasdfsad', 'sdfsadf', 1, 'dfsadfsdfs', 'C', 'A', '2022-11-03 04:42:06', '2022-11-03 04:42:06', NULL),
(43, 53, 'SADAsd', 'asdaSD', 'asdASD', 'asdasd', 1, 'ASDASDASD', 'C', 'A', '2022-11-03 04:45:32', '2022-11-03 04:45:32', NULL),
(44, 54, 'ststts', 'estste', 'setse', 'stset', 1, 'stst', 'C', 'A', '2022-11-03 09:44:25', '2022-11-03 09:44:25', NULL),
(45, 55, 'sdfsadf', 'sdfsadf', 'dsfsadf', 'dsfsadfsdafsdaf', 2, 'dsfasdf', 'C', 'A', '2022-11-04 01:59:49', '2022-11-04 01:59:49', NULL),
(46, 56, 'kdfkds', 'fdgdfg', 'ghgfh', 'gfhf', 1, 'gfhfgh', 'C', 'A', '2022-11-04 08:14:28', '2022-11-04 08:14:28', NULL);

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
);

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `user_type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Borrower', '2022-11-02 06:05:42', NULL, NULL),
(2, 'Broker', '2022-11-02 06:05:42', NULL, NULL),
(3, 'Investor', '2022-11-02 06:05:42', NULL, NULL),
(4, 'Vendor', '2022-11-02 06:05:42', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
  ADD PRIMARY KEY (`role_id`);

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

--
-- Indexes for table `client_department`
--
ALTER TABLE `client_department`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `client_designation`
--
ALTER TABLE `client_designation`
  ADD PRIMARY KEY (`designation_id`);

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

--
-- Indexes for table `client_roles`
--
ALTER TABLE `client_roles`
  ADD PRIMARY KEY (`client_role_id`);

--
-- Indexes for table `client_roles_assoc`
--
ALTER TABLE `client_roles_assoc`
  ADD PRIMARY KEY (`assoc_id`);

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

--
-- Indexes for table `oauth_scopes`
--
ALTER TABLE `oauth_scopes`
  ADD PRIMARY KEY (`scope`);

--
-- Indexes for table `user_address`
--
ALTER TABLE `user_address`
  ADD PRIMARY KEY (`address_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
  MODIFY `role_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `client_department`
--
ALTER TABLE `client_department`
  MODIFY `department_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `client_designation`
--
ALTER TABLE `client_designation`
  MODIFY `designation_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

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

--
-- AUTO_INCREMENT for table `client_roles`
--
ALTER TABLE `client_roles`
  MODIFY `client_role_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `client_roles_assoc`
--
ALTER TABLE `client_roles_assoc`
  MODIFY `assoc_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `user_address`
--
ALTER TABLE `user_address`
  MODIFY `address_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

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

