--
-- Host: localhost    Database: bisnalmedical
-- ------------------------------------------------------


--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `state_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--


--
-- Table structure for table `client_authorizations`
--

CREATE TABLE `client_authorizations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `from` date DEFAULT NULL,
  `to` date DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1-Acitve ,2-Expired',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `authorization_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overlap` int(11) DEFAULT '0' COMMENT '0-No,1-Yes',
  `client_unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_unique_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_authorizations_client_id_foreign` (`client_id`),
  CONSTRAINT `client_authorizations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_authorizations`
--

INSERT INTO `client_authorizations` VALUES (1,3,'2023-03-21','2023-03-31',2,'2023-03-22 01:36:49','2023-04-07 05:41:02',NULL,'34534534545',0,'345345','34000-6772','ADE9EVXS0'),(2,2,'2023-03-15','2023-03-30',2,'2023-03-22 01:39:14','2023-04-07 05:41:02',NULL,'dfgd456456',1,'45645656','60208-2829','QRH567IU7'),(3,4,'2023-03-17','2023-04-23',1,'2023-03-28 07:06:17','2023-04-07 06:29:05',NULL,'ASDDD24565',1,'3453345','31605-9161','70N8RPQYG'),(4,12,'2023-03-14','2024-06-28',1,'2023-03-29 00:11:27','2023-04-10 11:08:35',NULL,'123456789',0,'9872345542','S5125 U1','IOOYNNH28'),(5,15,'2023-04-08','2023-04-28',1,'2023-04-07 06:06:15','2023-04-07 18:30:03',NULL,'wdjndsnj',1,'AD515','QA556','139ADF'),(6,16,'2023-04-01','2023-09-30',1,'2023-04-19 12:00:09','2023-04-20 04:42:06',NULL,'ED885478816',1,'63913010','T1019 U1','885478816'),(7,17,'2023-01-01','2023-06-30',1,'2023-04-21 10:55:59','2023-04-21 10:55:59',NULL,'ED741167808',0,'PA94918010','T1019 U1','741167808');

--
-- Table structure for table `client_codes`
--

CREATE TABLE `client_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_codes`
--

INSERT INTO `client_codes` VALUES (1,'NOW','2023-03-22 01:30:29',NULL,NULL),(2,'OASCCW','2023-03-22 01:30:29',NULL,NULL),(3,'LTPCS','2023-03-22 01:30:29',NULL,NULL),(4,'ROW','2023-03-22 01:30:29',NULL,NULL),(5,'ADHC','2023-03-22 01:30:29',NULL,NULL),(6,'RESPITE','2023-03-22 01:30:29',NULL,NULL),(7,'CC','2023-03-22 01:30:29',NULL,NULL),(8,'EPSDT','2023-03-22 01:30:29',NULL,NULL),(9,'VA','2023-03-22 01:30:29',NULL,NULL);

--
-- Table structure for table `clock_in_out_activities`
--

CREATE TABLE `clock_in_out_activities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `clock_in_time` time DEFAULT NULL,
  `clock_in_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clock_in_latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clock_in_longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `clock_in_message` longtext COLLATE utf8mb4_unicode_ci,
  `clock_out_time` time DEFAULT NULL,
  `clock_out_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clock_out_latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clock_out_longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clock_out_message` longtext COLLATE utf8mb4_unicode_ci,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `clock_out_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entry_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '2' COMMENT '1-Add,2-Update',
  `entry_reason` text COLLATE utf8mb4_unicode_ci,
  `overlap` int(11) DEFAULT '0' COMMENT '0-No,1-Yes',
  `is_auto_created` int(11) DEFAULT '0' COMMENT '0-No,1-Yes',
  `mid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorization_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clock_in_out_activities_employee_id_foreign` (`employee_id`),
  KEY `clock_in_out_activities_client_id_foreign` (`client_id`),
  KEY `clock_in_out_activities_parent_id_foreign` (`parent_id`),
  CONSTRAINT `clock_in_out_activities_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `clock_in_out_activities_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `clock_in_out_activities_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `clock_in_out_activities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clock_in_out_activities`
--

INSERT INTO `clock_in_out_activities` VALUES (1,8,3,'07:08:17','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575025','76.727147','2023-03-22','Hello','07:08:52','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575045','76.7271491','Bye',NULL,'2023-03-22 01:38:04','2023-03-22 01:38:40',NULL,'2023-03-22','2',NULL,0,0,NULL,NULL),(2,8,2,'07:09:45','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575026','76.7271475','2023-03-22','Login','05:59:00','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575026','76.7271475',NULL,NULL,'2023-03-22 01:39:33','2023-03-22 23:30:01',NULL,'2023-03-22','2',NULL,1,0,NULL,NULL),(3,8,2,'06:00:00','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575026','76.7271475','2023-03-23','Login','05:59:00','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6575026','76.7271475',NULL,NULL,'2023-03-22 23:30:01','2023-03-23 23:30:02',NULL,'2023-03-23','2',NULL,1,1,NULL,NULL),(4,7,6,'18:15:00','dweasz',NULL,NULL,'2023-03-10','wefwefwef','18:16:00','effwed',NULL,NULL,'fdfesd',NULL,'2023-03-28 07:10:57','2023-03-28 07:10:57',NULL,'2023-03-16','1','Done',0,0,NULL,NULL),(5,7,2,'21:15:00','Test',NULL,NULL,'2023-03-10','Test','23:17:00','Tester',NULL,NULL,'Hey',NULL,'2023-03-28 07:13:05','2023-03-28 07:13:05',NULL,'2023-03-18','1','Hey',0,0,NULL,NULL),(6,14,12,'05:49:39','Lake Charles','30.184283094679','-93.202449521592','2023-03-29','Clock in','06:44:41','Lake Charles','30.184283094679','-93.202449521592','Clock out',NULL,'2023-03-29 00:19:41','2023-03-29 01:14:44',NULL,'2023-03-29','2',NULL,0,0,NULL,NULL),(7,14,13,'20:09:00','Mohali',NULL,NULL,'2023-04-06','Hey How you doin','21:10:00','Mexico',NULL,NULL,'Hey How you done',NULL,'2023-04-07 06:07:42','2023-04-07 06:07:42',NULL,'2023-04-07','1','m m',0,0,NULL,NULL),(8,8,4,'11:59:16','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6574972','76.727151','2023-04-07','Hell8','12:16:26','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6574988','76.7271283','Hszh',NULL,'2023-04-07 06:29:22','2023-04-07 06:46:32',NULL,'2023-04-07','2',NULL,1,0,'70N8RPQYG',NULL),(9,8,4,'12:16:47','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.657491','76.7271438','2023-04-07','Jhxhdh','12:26:00','JLPL Industrial Area Sahibzada Ajit Singh Nagar','30.6576512','76.727177','Gegsvs',NULL,'2023-04-07 06:46:48','2023-04-07 06:56:09',NULL,'2023-04-07','2',NULL,1,0,'70N8RPQYG','ASDDD24565'),(10,14,16,'17:32:35','Lake Charles','30.184251713308','-93.202253703253','2023-04-19','Had car trouble 30 min late','20:50:40','Lake Charles','30.18428061963','-93.202445196362','Done for day',NULL,'2023-04-19 12:02:37','2023-04-19 15:20:42',NULL,'2023-04-19','2',NULL,0,0,'885478816','ED885478816'),(11,19,17,'13:32:05','Lake Charles','30.184281646426','-93.202443424442','2023-04-26','Long Term Care','18:45:19','Lake Charles','30.184282145547','-93.202238929462','Clock out',NULL,'2023-04-26 08:02:06','2023-04-26 13:15:21',NULL,'2023-04-26','2',NULL,0,0,'741167808','ED741167808'),(12,19,16,'02:35:18','Lake Charles','30.184282866146','-93.202444129451','2023-04-26','Night Shift','06:12:28','Lake Charles','30.184282866146','-93.202444129451','Clock out',NULL,'2023-04-26 21:05:20','2023-04-27 00:42:29',NULL,'2023-04-27','2',NULL,1,0,'885478816','ED885478816');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `email_queues`
--

CREATE TABLE `email_queues` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `subject` text COLLATE utf8mb4_unicode_ci,
  `date_published` timestamp NULL DEFAULT NULL,
  `last_attempt` timestamp NULL DEFAULT NULL,
  `date_sent` timestamp NULL DEFAULT NULL,
  `attempts` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '0=>Not sent',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '1',
  `model_id` int(11) DEFAULT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_queues`
--


--
-- Table structure for table `employee_assigned_clients`
--

CREATE TABLE `employee_assigned_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_assigned_clients_employee_id_foreign` (`employee_id`),
  KEY `employee_assigned_clients_client_id_foreign` (`client_id`),
  CONSTRAINT `employee_assigned_clients_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `employee_assigned_clients_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_assigned_clients`
--

INSERT INTO `employee_assigned_clients` VALUES (1,7,2,1,'2023-03-22 01:35:02','2023-03-22 01:35:02',NULL),(2,7,3,1,'2023-03-22 01:35:02','2023-03-22 01:35:02',NULL),(3,7,6,1,'2023-03-22 01:35:02','2023-03-22 01:35:02',NULL),(4,8,2,1,'2023-03-22 01:36:00','2023-03-22 01:36:00',NULL),(5,8,3,1,'2023-03-22 01:36:00','2023-03-22 01:36:00',NULL),(6,8,4,1,'2023-03-22 01:36:00','2023-03-22 01:36:00',NULL),(7,8,5,1,'2023-03-22 01:36:00','2023-03-22 01:36:00',NULL),(8,8,6,1,'2023-03-22 01:36:00','2023-03-22 01:36:00',NULL),(9,7,11,1,'2023-03-28 06:48:16','2023-03-28 06:48:16',NULL),(10,8,11,1,'2023-03-28 06:48:16','2023-03-28 06:48:16',NULL),(13,14,16,1,'2023-04-19 12:01:26','2023-04-19 12:01:26',NULL),(16,19,17,1,'2023-04-21 11:10:54','2023-04-21 11:10:54',NULL),(17,19,18,1,'2023-04-21 11:10:54','2023-04-21 11:10:54',NULL),(18,19,16,1,'2023-04-26 21:04:46','2023-04-26 21:04:46',NULL);

--
-- Table structure for table `error_logs`
--

CREATE TABLE `error_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `file` longtext COLLATE utf8mb4_unicode_ci,
  `message` text COLLATE utf8mb4_unicode_ci,
  `trace` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `error_logs`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0 => image, 1 => video,2=>pdf,3=>other',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `files_created_by_foreign` (`created_by`),
  CONSTRAINT `files_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--


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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2020_06_21_170206_create_countries_table',1),(6,'2020_06_21_170206_create_states_table',1),(7,'2020_06_21_180249_create_cities_table',1),(8,'2022_01_19_101141_create_pages_table',1),(9,'2022_01_20_060542_create_files_table',1),(10,'2022_03_22_060720_create_logs_table',1),(11,'2022_03_23_234242_create_email_queues_table',1),(12,'2022_04_08_060156_create_roles_table',1),(13,'2022_04_08_060456_create_permissions_table',1),(14,'2022_04_14_011243_create_role_permissions_table',1),(15,'2022_11_14_040513_create_staff_assigned_clients',1),(16,'2022_11_15_015313_create_clock_in_out_activities',1),(17,'2022_11_15_023851_create_notifications',1),(18,'2022_12_20_063127_add_column_old_password_to_users',1),(19,'2022_12_20_063420_add_check_out_date_to_clock_in_out_activities',1),(20,'2022_12_28_003410_create_client_authorizations',1),(21,'2023_01_23_030401_add_columns_to_clock_in_out_activities',1),(22,'2023_01_23_045121_add_column_authorization_number_to_client_authorizations',1),(23,'2023_03_17_053110_add_target_and_code_columns_to_users_table',1),(24,'2023_03_22_054930_create_client_codes',1),(25,'2023_03_22_061313_add_client_id_column_to_client_authorizations',1),(26,'2023_03_24_053421_add_columns_to_users',2),(27,'2023_04_07_055113_add_mid_columns_to_users',3),(28,'2023_04_07_061818_add_mid_columns_to_client_authorizations',3),(29,'2023_04_07_074145_add_mid_columns_to_clock_in_out_activities',3);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sender_id` bigint(20) unsigned DEFAULT NULL,
  `receiver_id` bigint(20) unsigned DEFAULT NULL,
  `model_id` bigint(20) unsigned DEFAULT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_sender_id_foreign` (`sender_id`),
  KEY `notifications_receiver_id_foreign` (`receiver_id`),
  CONSTRAINT `notifications_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


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

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_type` int(11) NOT NULL COMMENT '1 => About Us, 2 => Terms Condition, 3 => Privecy Policy, 4=>Cookie Policy',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pages_created_by_foreign` (`created_by`),
  CONSTRAINT `pages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` VALUES (1,'Terms And Conditions','<p>Where does it come from</p>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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</p>\r\n\r\n<p>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>\r\n\r\n<p>The standard Lorem Ipsum</p>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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.</p>\r\n\r\n<ul>\r\n	<li>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley.</li>\r\n	<li>Scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap.</li>\r\n</ul>\r\n\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the.</p>',3,NULL,'2023-01-02 22:11:54','2023-01-02 22:11:54',NULL),(2,'Privacy Policy','<p>Must explain to you how all this mistaken</p>\r\n\r\n<p>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</p>\r\n\r\n<p>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>\r\n\r\n<p>Finibus Bonorum et Malorum</p>\r\n\r\n<p>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.</p>\r\n\r\n<ul>\r\n	<li>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley.</li>\r\n	<li>Scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap.</li>\r\n</ul>\r\n\r\n<p>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.</p>',2,NULL,'2023-01-02 22:11:54','2023-01-02 22:11:54',NULL),(3,'Cookie Policy','<p>Why do we use it</p>\r\n\r\n<p>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</p>\r\n\r\n<p>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>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum.</p>\r\n\r\n<p>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.</p>\r\n\r\n<ul>\r\n	<li>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley.</li>\r\n	<li>Scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap.</li>\r\n</ul>\r\n\r\n<p>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</p>',5,NULL,'2023-01-02 22:11:54','2023-01-12 13:43:24',NULL);

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

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

--
-- Dumping data for table `password_resets`
--


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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` VALUES (4,'App\\Models\\User',19,'authToken','1a5c90be08f45260fc594110da2b3f04ab409f29213b096f2a5d5e2ab65fe7dc','[\"*\"]','2023-04-27 00:42:30','2023-04-21 11:11:19','2023-04-27 00:42:30'),(5,'App\\Models\\User',8,'authToken','fe508400f94ee0237a1fe657d41385c6749269ac6573f703dc6366e46d9d748c','[\"*\"]','2023-04-24 06:47:14','2023-04-24 06:44:01','2023-04-24 06:47:14');

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `is_readable` int(11) NOT NULL DEFAULT '0',
  `is_writable` int(11) NOT NULL DEFAULT '0',
  `is_creatable` int(11) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `role_permissions_role_id_foreign` (`role_id`),
  KEY `role_permissions_permission_id_foreign` (`permission_id`),
  KEY `role_permissions_created_by_foreign` (`created_by`),
  CONSTRAINT `role_permissions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  CONSTRAINT `role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permissions`
--


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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_deleteable` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>No',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roles_created_by_foreign` (`created_by`),
  CONSTRAINT `roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--


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

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weekly_service_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` int(11) DEFAULT NULL COMMENT '1 =>Male, 0=>Female',
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>off, 1=>on',
  `role` int(11) NOT NULL DEFAULT '2' COMMENT '0 =>Admin,1=>Employee Or Staff,2=>Client,3=>User',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>inactive, 1=>active',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `email_verification_otp` int(11) DEFAULT NULL,
  `device_type` int(11) NOT NULL DEFAULT '1' COMMENT '0 =>IOS, 1=>Android',
  `fcm_token` text COLLATE utf8mb4_unicode_ci,
  `member_since` date DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `old_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_created_by_foreign` (`created_by`),
  CONSTRAINT `users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,'Admin',NULL,NULL,'admin@yopmail.com','$2y$10$lubhPV4jKWLO2EoESVQPfeKshEQ6rQv8i4y7.dbRiH0TTx7neil4i',NULL,NULL,'123456789',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,NULL,NULL,1,NULL,NULL,'so5s7AIAEGSMo0MTybhOOR6CZHYyz8TyPvD2rlH2llRRT1XakzqEhSBhxihg',NULL,'2023-03-22 01:30:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HILKPY0I8'),(2,'Carlotta Luettgen','Carlotta','Luettgen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'45645656','66',NULL,'2022-09-09',NULL,NULL,NULL,'15495 Block Forge',NULL,'Walterborough','South Dakota',1,2,1,NULL,NULL,1,NULL,'2022-09-10',NULL,NULL,'2023-03-22 01:31:16','2023-03-28 01:47:22',1,NULL,'ADHC','60208-2829','45645645','19810-5700','QRH567IU7'),(3,'Mathias Rippin','Mathias','Rippin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'345345','45',NULL,'2023-03-18',NULL,NULL,NULL,'9548 Veum Walk',NULL,'Lake Halshire','South Carolina',1,2,1,NULL,NULL,1,NULL,'2022-06-24',NULL,NULL,'2023-03-22 01:31:44','2023-03-28 01:46:59',1,NULL,'ADHC','34000-6772','324545','99734','ADE9EVXS0'),(4,'King Crooks','King','Crooks',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3453345','345',NULL,'2022-09-05',NULL,NULL,NULL,'845 Price Spurs',NULL,'Port Vidalhaven','Delaware',1,2,1,NULL,NULL,1,NULL,'2023-03-15',NULL,NULL,'2023-03-22 01:32:15','2023-03-28 01:46:19',1,NULL,'EPSDT','31605-9161','345443','63861','70N8RPQYG'),(5,'Elyssa Gleason','Elyssa','Gleason',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'234234234234','43',NULL,'2022-10-16',NULL,NULL,NULL,'64062 Champlin Stream',NULL,'Hettingerboro','New Jersey',1,2,1,NULL,NULL,1,NULL,'2022-09-20',NULL,NULL,'2023-03-22 01:32:44','2023-03-28 01:46:30',1,NULL,'RESPITE','63185-9282','345345','68106','3Z1FNQSVF'),(6,'Dillon Russel','Dillon','Russel',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'345345345','65',NULL,'2022-11-24',NULL,NULL,NULL,'83 Conn Trail',NULL,'Demondfort','Connecticut',1,2,1,NULL,NULL,1,NULL,'2022-09-09',NULL,NULL,'2023-03-22 01:33:16','2023-03-28 01:45:33',1,NULL,'VA','92334-5311','34534545','13662','Y9CT7HE2U'),(7,'Arvel Hane','Arvel','Hane','Arvel@gmail.com','$2y$10$Zbw4VT5caVwI395dLj18t.5o80oxKN0hF/NDlQ96jA7aNwxGBP5.O','1','us','8938066898',NULL,'9374','453456456456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,'2023-03-22 01:35:02',NULL,1,NULL,'2023-03-01',NULL,NULL,'2023-03-22 01:35:02','2023-03-22 01:35:02',1,'aDMIN@123',NULL,NULL,NULL,NULL,'HLAAFPEK6'),(8,'Vijay Rajput','Vijay','Rajput','vijaykrajput6@gmail.com','$2y$10$1UH7CrdpVmMR92BKOQHjkO.lpQAqB.D.TXjJ8soZDyFswRotV7z1m','91','in','8628878878',NULL,'2279','589304345',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,'2023-03-22 01:36:00',NULL,1,'123','2023-03-17',NULL,NULL,'2023-03-22 01:36:00','2023-03-22 01:37:25',1,'Admin@123',NULL,NULL,NULL,NULL,'KMGDRZH5A'),(9,'Josh Mathew','Josh','Mathew',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2623323','656',NULL,'2023-03-23',NULL,NULL,NULL,'Animal County',NULL,'dddd','ssss',1,2,1,NULL,NULL,1,NULL,'2023-03-24',NULL,NULL,'2023-03-28 04:21:29','2023-03-28 04:21:29',1,NULL,'NOW','5611515','ddd','26222','EWBOGKABE'),(10,'Devon Port','Devon','Port',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'s3s322','2325',NULL,'2023-03-25',NULL,NULL,NULL,'Arizona',NULL,'Mohali','Alan',1,2,1,NULL,NULL,1,NULL,'2023-03-23',NULL,NULL,'2023-03-28 04:24:40','2023-03-28 04:24:40',1,NULL,'ADHC','2662626','Status','1523223','CM990OVKC'),(11,'Derry Brown','Derry','Brown',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3GFTLLLL','80',NULL,'2023-03-17',NULL,NULL,NULL,'Amazon Street',NULL,'Moscow','Belarus',1,2,1,NULL,NULL,1,NULL,'2023-03-17',NULL,NULL,'2023-03-28 04:26:05','2023-03-28 06:55:15',1,NULL,'ADHC','345TDET','Google','ASD123','IEB7RLEAR'),(12,'Don Johnson','Don','Johnson',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9872345542','60',NULL,'1998-12-29',NULL,NULL,NULL,'12334 Texas Street',NULL,'Lake Charles','LA',1,2,1,NULL,NULL,1,NULL,'2023-03-29',NULL,NULL,'2023-03-29 00:01:51','2023-04-10 11:08:35',1,NULL,'NOW','S5125 U1','675','70607','IOOYNNH28'),(13,'Don Johnson','Don','Johnson',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9872345541','60',NULL,'1998-12-29',NULL,NULL,NULL,'12334 Texas Street',NULL,'Lake Charles','LA',1,2,1,NULL,NULL,1,NULL,'2022-12-29',NULL,NULL,'2023-03-29 00:10:18','2023-04-10 11:08:10',1,NULL,'RESPITE','S5150 U1','675','70607','2SFSV8AOG'),(14,'JOHN DOE','JOHN','DOE','latrell34232@gmail.com','$2y$10$1exKxI9nc5YimRJRU9kC.OKETVfXG2AYoBDqqzV66NwvAHKIqkfqC','1','us','3374771234',NULL,'868','112212312',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,'2023-03-29 00:15:20',NULL,2,NULL,'2021-02-01',NULL,NULL,'2023-03-29 00:15:20','2023-04-21 11:07:27',1,'jOHNdOE01@1',NULL,NULL,NULL,NULL,'SSAUR6FYA'),(15,'Ely Willy','Ely','Willy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AD515','92',NULL,'2023-04-07',NULL,NULL,NULL,'Mohali',NULL,'Mohali','Mohali',1,2,1,NULL,NULL,1,NULL,'2023-04-07',NULL,NULL,'2023-04-07 06:04:56','2023-04-07 06:04:56',1,NULL,'CC','QA556','AA852656','133265A','139ADF'),(16,'SARAH ANTHONY','SARAH','ANTHONY',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'63913010','70',NULL,'1936-01-03',NULL,NULL,NULL,'2526 BOYD RD',NULL,'UTICA','MS',1,2,1,NULL,NULL,1,NULL,'2022-06-28',NULL,NULL,'2023-04-19 11:57:51','2023-04-20 04:42:06',1,NULL,'NOW','T1019 U1',NULL,'39175','885478816'),(17,'PATRICIA ASH','PATRICIA','ASH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA94918010','42',NULL,'1949-01-08',NULL,NULL,NULL,'3216 JOHN HANCOCK DR',NULL,'COLUMBUS','MS',1,2,1,NULL,NULL,1,NULL,'2021-07-21',NULL,NULL,'2023-04-21 10:52:28','2023-04-21 10:54:21',1,NULL,'NOW','T1019 U1',NULL,'39705','741167808'),(18,'PATRICIA ASH','PATRICIA','ASH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PA94918010','24',NULL,'1949-01-08',NULL,NULL,NULL,'3216 JOHN HANCOCK DR',NULL,'COLUMBUS','MS',1,2,1,NULL,NULL,1,NULL,'2022-05-27',NULL,NULL,'2023-04-21 11:06:14','2023-04-21 11:06:14',1,NULL,'RESPITE','S5125 U1',NULL,'39705','741671808'),(19,'Brady Alfred','Brady','Alfred','bralfred@yahoo.com','$2y$10$840jUQn13Yaq3X5Su688uOspJBwaIc3J/YBgxd2P.8ZKsTB6ilEVq','1','us','3374787727',NULL,'184','123098',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,'2023-04-21 11:10:54',NULL,2,'123','2023-01-01',NULL,NULL,'2023-04-21 11:10:54','2023-04-21 11:11:19',1,'Nikyia01@1',NULL,NULL,NULL,NULL,NULL);


