--
-- Host: localhost    Database: icomply
-- ------------------------------------------------------


--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint unsigned DEFAULT NULL,
  `causer_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` bigint unsigned DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `batch_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_log`
--


--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seeder_status` int NOT NULL DEFAULT '0',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_id` int DEFAULT NULL,
  `subscription_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `mobile_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `domains_domain_unique` (`domain`),
  UNIQUE KEY `domains_email_unique` (`email`),
  UNIQUE KEY `domains_mobile_no_unique` (`mobile_no`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `domains`
--

INSERT INTO `domains` VALUES (4,'mytenantdev.dev-icomply.dreamstechnologies.com','mytenantdev','Shenbagam','Developer','My Tenant Dev','mytenantdev@yopmail.com',0,NULL,NULL,NULL,NULL,'788945560','2024-06-03 12:42:59','2024-06-18 11:55:28',NULL,1,NULL,NULL),(10,'sg.dev-icomply.dreamstechnologies.com','sg','Sathish','G','SG','sathish@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-19 10:44:54','2024-06-19 10:44:54',NULL,1,NULL,NULL),(11,'dgt.dev-icomply.dreamstechnologies.com','DGT','Gokila','Varatharaj','Testing','tenanttest1@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-19 12:18:43','2024-06-19 12:18:43',NULL,1,NULL,NULL),(12,'domjack.dev-icomply.dreamstechnologies.com','domjack','jack','333','comp jack','jack333@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-19 15:36:32','2024-06-19 15:36:32',NULL,1,NULL,NULL),(13,'domrob.dev-icomply.dreamstechnologies.com','domrob','rob','333','comp rob','rob333@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-19 15:43:48','2024-06-19 15:43:48',NULL,1,NULL,NULL),(14,'zee.dev-icomply.dreamstechnologies.com','zee','Gokila1','Varatharaj1','Demo testing','gokila.v@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-20 09:19:29','2024-06-20 09:19:29',NULL,1,NULL,NULL),(17,'grcdevtenant.dev-icomply.dreamstechnologies.com','grcdevtenant','grcdevtenant','grcdevtenant','grcdevtenant','grcdevtenant@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-21 23:42:18','2024-07-01 10:20:29','2024-07-01 10:20:29',1,NULL,NULL),(18,'sathishdev.dev-icomply.dreamstechnologies.com','sathishdev','sathishdev','sathishdev','sathishdev','sathishdev@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-22 12:21:59','2024-06-22 12:21:59',NULL,1,NULL,NULL),(19,'test6.dev-icomply.dreamstechnologies.com','test6','test','6','test6 comp','test6@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-22 16:13:13','2024-06-22 16:13:13',NULL,1,NULL,NULL),(20,'test7.dev-icomply.dreamstechnologies.com','test7','tenant','7','comp 7','test7@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-06-22 16:14:24','2024-06-22 16:14:24',NULL,1,NULL,NULL),(23,'amirdhevn.dev-icomply.dreamstechnologies.com','amirdhevn','amirdhevn','amirdhev','amirdhevn','amirdhevn@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-01 12:28:51','2024-07-01 12:28:51',NULL,1,NULL,NULL),(24,'dineshabc.dev-icomply.dreamstechnologies.com','dineshabc','Dinesh','Kumar','ABC','dinesh@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-01 12:37:21','2024-07-01 12:37:21',NULL,1,NULL,NULL),(25,'dineshcom.dev-icomply.dreamstechnologies.com','dineshcom','Dinesh','Kumar','mycom','dinesh1@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-01 12:41:46','2024-07-01 12:41:46',NULL,1,NULL,NULL),(29,'grcdev.dev-icomply.dreamstechnologies.com','grcdev','grcdev','grcdev','grcdev','grcdev@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-01 14:54:55','2024-07-01 14:54:55',NULL,1,NULL,NULL),(30,'xyz.dev-icomply.dreamstechnologies.com','xyz','Dinesh','kumar','xyz','dinesh2@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-01 15:08:43','2024-07-01 15:08:43',NULL,1,NULL,NULL),(31,'demo.icomply.dreamstechnologies.com','demo','Admin','Admin','demo','demo@yopmail.com',1,'Address',1,'2024-09-02','2025-10-02','9898989898','2024-07-01 15:35:20','2024-10-14 18:43:33',NULL,1,NULL,NULL),(32,'cwgdts.dev-icomply.dreamstechnologies.com','cwgdts','Naina','Pande','CWG-DTS','cwg-dts@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-02 23:54:53','2024-09-22 17:56:22',NULL,1,NULL,NULL),(33,'dgt-test.dev-icomply.dreamstechnologies.com','dgt-test','Sam','S','DGT','dgt@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-23 14:42:47','2024-07-24 12:06:54','2024-07-24 12:06:54',1,NULL,NULL),(34,'testcompany1.dev-icomply.dreamstechnologies.com','testcompany1','test','name','company','testcompany1@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 11:33:28','2024-07-24 12:06:50','2024-07-24 12:06:50',1,NULL,NULL),(35,'companydomaintest.dev-icomply.dreamstechnologies.com','companydomaintest','test','name','testcompany','testcompanyemail@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 11:58:04','2024-07-24 12:06:46','2024-07-24 12:06:46',1,NULL,NULL),(36,'testing-compant.dev-icomply.dreamstechnologies.com','testing-compant','test','name','test-company','test-company@yopmail.cpm',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 11:59:35','2024-07-24 12:06:42','2024-07-24 12:06:42',1,NULL,NULL),(37,'grc-domain.dev-icomply.dreamstechnologies.com','grc-domain','test','name','test','testmaill@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 12:06:00','2024-07-24 12:06:39','2024-07-24 12:06:39',1,NULL,NULL),(38,'grc-domains.dev-icomply.dreamstechnologies.com','grc-domains','first','.r','dreams','kavipriya.rajendran@dreamstechnologies.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 12:07:05','2024-07-24 12:07:05',NULL,1,NULL,NULL),(39,'testcompany2333.dev-icomply.dreamstechnologies.com','testcompany2333','test','name','test','testmail@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-24 12:32:27','2024-07-24 12:32:27',NULL,1,NULL,NULL),(40,'sgc-tech.dev-icomply.dreamstechnologies.com','sgc-tech','Raj','s','sgc','raj@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-29 10:32:05','2024-07-29 10:32:05',NULL,1,NULL,NULL),(41,'julydemo.dev-icomply.dreamstechnologies.com','julydemo','test','name','test','testmail30@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-30 12:17:07','2024-07-30 12:17:07',NULL,1,NULL,NULL),(42,'anu333domain.dev-icomply.dreamstechnologies.com','anu333domain','anu','333','anucomp','anu333@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-07-30 12:20:23','2024-07-30 12:20:23',NULL,1,NULL,NULL),(43,'dreamstech.dev-icomply.dreamstechnologies.com','dreamstech','Dreams','Technologies','Dreams','nithya.t@dreamstechnologoies.com',0,NULL,NULL,NULL,NULL,NULL,'2024-08-07 17:10:43','2024-08-07 17:10:43',NULL,1,NULL,NULL),(44,'amirlaks.dreams-pms.dreamstechnologies.com','amirlaks','amirlaks','amirlaks','amirlaks','amirlaks@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-08-14 10:56:49','2024-08-14 10:56:49',NULL,1,NULL,NULL),(45,'samsung.dreams-pms.dreamstechnologies.com','samsung','samsung','samsung','samsung','samsung@yopmail.com',0,NULL,NULL,NULL,NULL,NULL,'2024-08-14 11:06:20','2024-08-14 11:06:20',NULL,1,NULL,NULL),(46,'airtel.dreams-pms.dreamstechnologies.com','airtel','airtel','airtel','airtel','airtel@yopmail.com',1,NULL,NULL,NULL,NULL,NULL,'2024-08-14 11:10:28','2024-09-02 17:14:46',NULL,1,NULL,NULL),(47,'sepdomain.dreams-pms.dreamstechnologies.com','sepdomain','Sep TesT','Company','TesT CompanY','testcompany_sep@yopmail.com',0,'Address',1,'2024-09-02','2024-10-02','7896541230','2024-09-02 12:15:05','2024-09-02 12:15:05',NULL,1,NULL,NULL),(48,'domain1.dev-icomply.dreamstechnologies.com','domain1','doamin1','D','domain1','domain1@gmail.com',0,'domain1',1,'2024-09-03','2024-10-03','1234567890','2024-09-03 11:58:22','2024-09-03 11:58:22',NULL,1,NULL,NULL),(49,'testcompanysep03.dev-icomply.dreamstechnologies.com','testcompanysep03','test','company','testcompany_sep03','testcompany_sep03@yopmail.com',0,'Address',1,'2024-09-03','2024-09-03','1232564578','2024-09-03 12:02:25','2024-09-03 12:02:25',NULL,1,NULL,NULL),(50,'testingsite1.dev-icomply.dreamstechnologies.com','testingsite1','testingsite1','p','dreams technologies','testingsite1@gmail.com',0,'cheran managar',1,'2024-09-03','2024-10-03','0063746374','2024-09-03 13:18:00','2024-09-04 14:49:26',NULL,1,NULL,NULL),(51,'c-uat.dev-icomply.dreamstechnologies.com','c-uat','Sandeep','Honawar','Crown Worldwide Pvt Ltd','sandeeph@eprama.com',1,'C-3, MIDC, Taloja, Navi Mumbai',3,'2024-09-22','2025-09-22','9867369119','2024-09-22 17:57:16','2024-09-22 19:37:48',NULL,1,NULL,NULL),(52,'s-uat.dev-icomply.dreamstechnologies.com','s-uat','Sep 23','Tenant','Sep23Tenant','sep23tenant@yopmail.com',1,'sdbj j nnkfgnhkfn hkdk',3,'2024-09-23','2025-09-23','5645752312','2024-09-23 13:49:31','2024-09-23 13:51:45',NULL,1,NULL,NULL),(53,'bbb.dev-icomply.dreamstechnologies.com','bbb','bbb','b','bbb','bbb@gmail.com',0,'coimbatore',3,'2024-09-23','2025-09-23','8998898909','2024-09-23 13:58:56','2024-09-23 13:58:56',NULL,1,NULL,NULL),(54,'sepmon.dev-icomply.dreamstechnologies.com','sepmon','SepMonth','Domain','SepMonDomain','sepmondomain@yopmail.com',0,'skdjgn djhkfjk',1,'2024-09-23','2024-10-23','5645122356','2024-09-23 14:02:30','2024-09-23 14:02:30',NULL,1,NULL,NULL),(55,'test-bbb.dev-icomply.dreamstechnologies.com','test-bbb','kavi','R','Dgt','kavipriya@gmail.com',0,'cheran managar',2,'2024-09-23','2024-12-22','06374990099','2024-09-23 14:02:53','2024-09-23 14:02:53',NULL,1,NULL,NULL),(56,'login.dev-icomply.dreamstechnologies.com','login','loginuser','R','dreams technologies','abctest@gmail.com',0,'cheran managar',2,'2024-09-23','2024-12-22','04567005555','2024-09-23 14:20:30','2024-09-23 14:20:30',NULL,1,NULL,NULL),(57,'bnm.dev-icomply.dreamstechnologies.com','bnm','bnm','k','dreams technologies','bnm11@gmail.com',0,'cheran managar',3,'2024-09-23','2025-09-23','06374008802','2024-09-23 18:04:48','2024-09-23 18:04:48',NULL,1,NULL,NULL),(58,'fghjk.dev-icomply.dreamstechnologies.com','fghjk','fghjk','fghjk','fghjk','fghjjk@gmail.com',0,'dfghh',2,'2024-09-23','2024-12-22','1234567895','2024-09-23 18:05:50','2024-09-23 18:05:50',NULL,1,NULL,NULL),(59,'lab-tech.dev-icomply.dreamstechnologies.com','lab-tech','Tech','s','Lab','tech@yopmail.com',0,'Chennai',1,'2024-09-30','2024-10-30','8788686788','2024-09-30 18:25:32','2024-09-30 18:25:32',NULL,1,NULL,NULL),(61,'lab-eng.dev-icomply.dreamstechnologies.com','lab-eng','Lab','s','Lab','lab@yopmail.com',1,'Chennai',1,'2024-09-30','2024-10-30','8788686782','2024-09-30 18:35:59','2024-10-17 15:49:03',NULL,1,NULL,NULL),(63,'mob-test.dev-icomply.dreamstechnologies.com','mob-test','mob','s','RR mob','mob@yopmail.com',1,'Chennai',1,'2024-09-30','2024-10-30','5654764564','2024-09-30 18:46:56','2024-10-01 13:02:33',NULL,1,NULL,NULL),(64,'elevate.icomply.dreamstechnologies.com','elevate','Alice','Johnson','Elevate Software','alice1@elevatesoft.com',1,'8115, Maple Bvld, Montana, MT 11504',2,'2024-10-15','2025-01-13','9786453891','2024-10-15 00:24:48','2024-10-17 15:19:35',NULL,1,NULL,NULL),(65,'oct17tenant.dev-icomply.dreamstechnologies.com','oct17tenant','Oct 17','Tenant','October Tenant','oct17_tenant@yopmail.com',1,'Address',3,'2024-10-17','2025-10-17','7456310290','2024-10-17 16:02:59','2024-10-17 16:04:08',NULL,1,NULL,NULL),(66,'nithiyop.dev-icomply.dreamstechnologies.com','nithiyop','dreams','nithi','dgt','nithi11eee29@yopmail.com',0,'47/1,9th street,ganapathy pudur,ganapathy,near kannan departental stores',1,'2024-10-17','2024-11-16','9988776655','2024-10-17 16:27:41','2024-10-17 16:27:41',NULL,1,NULL,NULL),(67,'dreamslive.dev-icomply.dreamstechnologies.com','dreamslive','Super','Admin','dreamslive','superadmin@live.com',1,'test test',1,'2024-10-18','2024-11-17','9093459090','2024-10-18 15:23:37','2024-10-18 15:48:44',NULL,1,NULL,NULL),(68,'vaskum.com.icomply.dreamstechnologies.com','vaskum.com','vas','kumar','vaskumar','vasanthakumar.duraisamy@dreamstechnologies.com',0,'coimbatore',1,'2024-12-22','2025-01-21','09894097764','2024-12-22 15:11:40','2024-12-22 15:13:16','2024-12-22 15:13:16',1,NULL,NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 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_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_09_15_000010_create_tenants_table',1),(5,'2019_09_15_000020_create_domains_table',1),(6,'2019_10_16_000001_create_admin_table',1),(7,'2019_12_14_000001_create_personal_access_tokens_table',1),(8,'2020_05_15_000010_create_tenant_user_impersonation_tokens_table',1),(9,'2024_05_22_201629_create_permission_tables',1),(10,'2024_05_28_211455_add_tenant_id_to_users_table',1),(11,'2024_06_10_095849_create_activity_log_table',2),(12,'2024_06_10_095850_add_event_column_to_activity_log_table',2),(13,'2024_06_10_095851_add_batch_uuid_column_to_activity_log_table',2);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` int DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'Policy Management','admin',0,'policy_management','2024-05-31 08:05:11','2024-07-23 11:39:45'),(2,'Project Management','admin',0,'project_management','2024-05-31 08:05:11','2024-07-23 11:39:45'),(3,'Project Support','admin',0,'project_support','2024-05-31 08:05:11','2024-07-23 11:39:45'),(4,'Risk Management','admin',0,'risk_management','2024-05-31 08:05:12','2024-07-23 11:39:45'),(5,'Vendors & Contract','admin',0,'vendor_contracts','2024-05-31 08:05:12','2024-07-23 11:39:45'),(6,'Audit & Assurance','admin',0,'audit_assurance','2024-05-31 08:05:12','2024-07-23 11:39:45'),(7,'Dashboard','admin',2,'projects_dashboard','2024-05-31 08:05:12','2024-07-23 11:39:45'),(8,'Projects','admin',2,'projects','2024-05-31 08:05:12','2024-07-23 11:39:45'),(9,'Estimations','admin',2,'estimations','2024-05-31 08:05:12','2024-07-23 11:39:45'),(10,'Milestones','admin',2,'milestones','2024-05-31 08:05:12','2024-07-23 11:39:45'),(11,'Tasks','admin',2,'tasks','2024-05-31 08:05:12','2024-07-23 11:39:45'),(12,'Issues','admin',2,'issues','2024-05-31 08:05:12','2024-07-23 11:39:45'),(13,'Dependencies','admin',2,'dependencies','2024-06-27 11:11:13','2024-07-23 11:39:45'),(14,'Calendar','admin',2,'calendar','2024-06-27 11:11:13','2024-07-23 11:39:45'),(15,'Project Risks','admin',2,'project_risks','2024-06-27 11:14:19','2024-07-23 11:39:45'),(16,'Stakeholders','admin',3,'stakeholder','2024-06-27 11:14:19','2024-07-23 11:39:45'),(17,'PIP','admin',3,'pip','2024-06-27 11:14:19','2024-07-23 11:39:45'),(18,'Skill Building','admin',3,'skill_building','2024-06-27 11:14:19','2024-07-23 11:39:45'),(19,'Configurable Items','admin',3,'configurable_items','2024-06-27 11:14:19','2024-07-23 11:39:45'),(20,'Change Request','admin',3,'change_request','2024-06-27 11:14:19','2024-07-23 11:39:45'),(21,'Defects','admin',3,'defects','2024-06-27 11:14:19','2024-07-23 11:39:45'),(22,'Incidents','admin',3,'incidents','2024-06-27 11:14:19','2024-07-23 11:39:45'),(23,'Reviews','admin',3,'reviews','2024-06-27 11:14:19','2024-07-23 11:39:45'),(24,'Meeting Minutes','admin',3,'meeting_minutes','2024-06-28 11:49:31','2024-07-23 11:39:45'),(25,'Decision Matrix','admin',3,'decision_matrix','2024-06-28 11:49:31','2024-07-23 11:39:45'),(26,'Training & Skill Matrix','admin',3,'training_matrix','2024-06-28 11:49:31','2024-07-23 11:39:45'),(27,'Roles & Permissions','admin',0,'roles','2024-07-23 11:39:45','2024-07-23 11:39:45'),(28,'Dashboard','admin',5,'vendor_dashboard','2024-07-23 11:40:37','2024-07-23 11:40:37'),(29,'Vendors','admin',5,'vendors','2024-07-23 11:40:37','2024-07-23 11:40:37'),(30,'Contracts','admin',5,'contract','2024-07-23 11:40:37','2024-07-23 11:40:37'),(31,'Vendor Evaluation','admin',5,'vendor_evaluation','2024-07-23 11:40:37','2024-07-23 11:40:37'),(32,'Vendor Performance','admin',5,'vendor_performance','2024-07-23 11:40:37','2024-07-23 11:40:37'),(33,'Dashboard','admin',1,'policy_dashboard','2024-07-23 11:40:37','2024-07-23 11:40:37'),(34,'Policies','admin',1,'policies','2024-07-23 11:40:37','2024-07-23 11:40:37'),(35,'Standards','admin',1,'standards','2024-07-23 11:40:37','2024-07-23 11:40:37'),(36,'Procedures','admin',1,'procedures','2024-07-23 11:40:37','2024-07-23 11:40:37'),(37,'Attestation','admin',1,'attestation','2024-07-23 11:40:37','2024-07-23 11:40:37'),(38,'Exceptions','admin',1,'exception','2024-07-23 11:40:37','2024-07-23 11:40:37'),(39,'Reports','admin',1,'reports','2024-07-23 11:40:37','2024-07-23 11:40:37'),(40,'Dashboard','admin',4,'risk_dashboard','2024-07-23 11:40:37','2024-07-23 17:05:48'),(41,'Assets','admin',4,'asset','2024-07-23 11:40:37','2024-08-05 11:37:32'),(42,'Threats','admin',4,'risk-threats','2024-07-23 11:40:37','2024-08-05 11:37:32'),(43,'Vulnerabilities','admin',4,'risk-vulnerability','2024-07-23 11:40:37','2024-07-23 17:05:48'),(44,'Risk Register','admin',4,'risk_register','2024-07-23 11:40:37','2024-08-05 11:37:32'),(45,'IT Incidents','admin',4,'it_incidents','2024-07-23 11:40:37','2024-07-23 17:05:48'),(46,'Business Impact Analysis','admin',4,'business-impact','2024-07-23 11:40:37','2024-07-23 17:05:48'),(47,'Dashboard','admin',6,'audit_dashboard','2024-07-23 11:40:37','2024-07-23 17:05:48'),(48,'Audit Plan','admin',6,'audit_plan','2024-07-23 11:40:37','2024-07-23 17:05:48'),(49,'Non Conformance','admin',6,'nc_analysis_report','2024-07-23 11:40:37','2024-07-23 17:05:48'),(50,'% Compliance','admin',6,'compliance_report','2024-07-23 11:40:37','2024-07-23 17:05:48'),(51,'SOA Report','admin',6,'soa_report','2024-07-23 17:05:48','2024-07-23 17:05:48'),(52,'Company Setup','admin',0,'company_setup','2024-08-29 16:34:50','2024-08-29 16:34:50'),(53,'Locations','admin',52,'company_location','2024-08-29 16:34:50','2024-08-29 16:34:50'),(54,'Department','admin',52,'company_department','2024-08-29 16:34:50','2024-08-29 16:34:50'),(55,'Designation','admin',52,'company_designation','2024-08-29 16:34:50','2024-08-29 16:34:50'),(56,'Clients','admin',52,'company_clients','2024-08-29 16:34:50','2024-08-29 16:34:50'),(57,'Employee','admin',52,'company_employee','2024-08-29 16:34:50','2024-08-29 16:34:50'),(58,'Employee Type','admin',52,'company_employee_type','2024-08-29 16:34:50','2024-08-29 16:34:50'),(59,'Employee Level','admin',52,'company_employee_level','2024-08-29 16:34:50','2024-08-29 16:34:50'),(60,'Weekdays','admin',52,'company_weekdays','2024-08-29 16:34:50','2024-08-29 16:34:50'),(61,'Holidays','admin',52,'company_holidays','2024-08-29 16:34:50','2024-08-29 16:34:50');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  `parent_id` int DEFAULT NULL,
  `tenant_id` int NOT NULL,
  `add_permission` tinyint NOT NULL,
  `edit_permission` tinyint NOT NULL,
  `view_permission` tinyint NOT NULL,
  `delete_permission` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  KEY `role_has_permissions_tenant_id_index` (`tenant_id`),
  KEY `role_has_permissions_add_permission_index` (`add_permission`),
  KEY `role_has_permissions_edit_permission_index` (`edit_permission`),
  KEY `role_has_permissions_view_permission_index` (`view_permission`),
  KEY `role_has_permissions_delete_permission_index` (`delete_permission`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--


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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'admin','web','2024-05-31 14:12:42','2024-05-31 14:12:42');

--
-- Table structure for table `subscription_details`
--

CREATE TABLE `subscription_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription_id` bigint unsigned NOT NULL,
  `subscription_plan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_price` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_days` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscription_details_tenant_id_index` (`tenant_id`),
  KEY `subscription_details_subscription_id_index` (`subscription_id`),
  KEY `subscription_details_subscription_plan_index` (`subscription_plan`),
  KEY `subscription_details_subscription_price_index` (`subscription_price`),
  KEY `subscription_details_subscription_days_index` (`subscription_days`),
  KEY `subscription_details_subscription_date_index` (`subscription_date`),
  KEY `subscription_details_expiry_date_index` (`expiry_date`),
  CONSTRAINT `subscription_details_subscription_id_foreign` FOREIGN KEY (`subscription_id`) REFERENCES `subscriptions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_details`
--

INSERT INTO `subscription_details` VALUES (1,'sepdomain',1,'Basic','299.00','30','2024-09-02','2024-10-02',1,NULL,'2024-09-02 12:15:05','2024-09-02 12:15:05',NULL),(2,'domain1',1,'Basic','299.00','30','2024-09-03','2024-10-03',1,NULL,'2024-09-03 11:58:22','2024-09-03 11:58:22',NULL),(3,'testcompanysep03',1,'Basic','299.00','30','2024-09-03','2024-09-03',1,NULL,'2024-09-03 12:02:25','2024-09-03 12:02:25',NULL),(4,'testingsite1',1,'Basic','299.00','30','2024-09-03','2024-10-03',1,NULL,'2024-09-03 13:18:00','2024-09-03 13:18:00',NULL),(5,'C-UAT',3,'Personal','1099.00','365','2024-09-22','2025-09-22',1,NULL,'2024-09-22 17:57:16','2024-09-22 17:57:16',NULL),(6,'s-uat',3,'Personal','1099.00','365','2024-09-23','2025-09-23',1,NULL,'2024-09-23 13:49:31','2024-09-23 13:49:31',NULL),(7,'bbb',3,'Personal','1099.00','365','2024-09-23','2025-09-23',1,NULL,'2024-09-23 13:58:56','2024-09-23 13:58:56',NULL),(8,'sepmon',1,'Basic','299.00','30','2024-09-23','2024-10-23',1,NULL,'2024-09-23 14:02:30','2024-09-23 14:02:30',NULL),(9,'test-bbb',2,'Intermediate','499.00','90','2024-09-23','2024-12-22',1,NULL,'2024-09-23 14:02:53','2024-09-23 14:02:53',NULL),(10,'login',2,'Intermediate','499.00','90','2024-09-23','2024-12-22',1,NULL,'2024-09-23 14:20:30','2024-09-23 14:20:30',NULL),(11,'bnm',3,'Personal','1099.00','365','2024-09-23','2025-09-23',1,NULL,'2024-09-23 18:04:49','2024-09-23 18:04:49',NULL),(12,'fghjk',2,'Intermediate','499.00','90','2024-09-23','2024-12-22',1,NULL,'2024-09-23 18:05:50','2024-09-23 18:05:50',NULL),(13,'lab-tech',1,'Basic','299.00','30','2024-09-30','2024-10-30',1,NULL,'2024-09-30 18:25:32','2024-09-30 18:25:32',NULL),(14,'lab-eng',1,'Basic','299.00','30','2024-09-30','2024-10-30',1,NULL,'2024-09-30 18:35:59','2024-09-30 18:35:59',NULL),(15,'mob-test',1,'Basic','299.00','30','2024-09-30','2024-10-30',1,NULL,'2024-09-30 18:46:56','2024-09-30 18:46:56',NULL),(16,'elevate',2,'Intermediate','499.00','90','2024-10-15','2025-01-13',1,NULL,'2024-10-15 00:24:49','2024-10-15 00:24:49',NULL),(17,'oct17tenant',3,'Personal','1099.00','365','2024-10-17','2025-10-17',1,NULL,'2024-10-17 16:02:59','2024-10-17 16:02:59',NULL),(18,'nithiyop',1,'Basic','299.00','30','2024-10-17','2024-11-16',1,NULL,'2024-10-17 16:27:41','2024-10-17 16:27:41',NULL),(19,'dreamslive',1,'Basic','299.00','30','2024-10-18','2024-11-17',1,NULL,'2024-10-18 15:23:37','2024-10-18 15:23:37',NULL),(20,'vaskum.com',1,'Basic','299.00','30','2024-12-22','2025-01-21',1,NULL,'2024-12-22 15:11:40','2024-12-22 15:11:40',NULL);

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscription_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration_in` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1 = Active and 0 = Inactive',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriptions_subscription_name_index` (`subscription_name`),
  KEY `subscriptions_duration_in_index` (`duration_in`),
  KEY `subscriptions_price_index` (`price`),
  KEY `subscriptions_status_index` (`status`),
  KEY `subscriptions_created_by_index` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` VALUES (1,'Basic','30',299.00,1,'Basic Plan Description',1,1,'2024-08-30 10:07:51','2024-08-30 12:23:54',NULL),(2,'Intermediate','90',499.00,1,'Intermediate Plan Description',1,NULL,'2024-08-30 10:07:51','2024-08-30 10:08:18',NULL),(3,'Personal','365',1099.00,1,'Personal Plan Description',1,NULL,'2024-08-30 10:07:51','2024-08-30 10:08:18',NULL);

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tenant_id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` json DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` VALUES ('mytenantdev',4,NULL,'{\"created_at\": \"2024-06-03 12:42:50\", \"updated_at\": \"2024-06-03 12:42:50\", \"tenancy_db_name\": \"tenant_mytenantdev\"}',0,'2024-06-03 12:42:50','2024-06-03 12:42:50',NULL),('sg',21,NULL,'{\"created_at\": \"2024-06-19 10:44:38\", \"updated_at\": \"2024-06-19 10:44:38\", \"tenancy_db_name\": \"tenant_sg\"}',0,'2024-06-19 10:44:38','2024-06-19 10:44:38',NULL),('dgt',22,NULL,'{\"created_at\": \"2024-06-20 09:16:04\", \"updated_at\": \"2024-06-20 09:16:04\", \"tenancy_db_name\": \"tenant_dgt\"}',0,'2024-06-19 12:18:27','2024-06-20 09:16:04',NULL),('domjack',23,NULL,'{\"created_at\": \"2024-06-19 15:36:21\", \"updated_at\": \"2024-06-19 15:36:21\", \"tenancy_db_name\": \"tenant_domjack\"}',0,'2024-06-19 15:36:15','2024-06-19 15:36:21',NULL),('domjack',24,NULL,'{\"created_at\": \"2024-06-19 15:36:21\", \"updated_at\": \"2024-06-19 15:36:21\", \"tenancy_db_name\": \"tenant_domjack\"}',0,'2024-06-19 15:36:21','2024-06-19 15:36:21',NULL),('domrob',25,NULL,'{\"created_at\": \"2024-06-19 15:43:32\", \"updated_at\": \"2024-06-19 15:43:32\", \"tenancy_db_name\": \"tenant_domrob\"}',0,'2024-06-19 15:43:32','2024-06-19 15:43:32',NULL),('dgt',26,NULL,'{\"created_at\": \"2024-06-20 09:16:04\", \"updated_at\": \"2024-06-20 09:16:04\", \"tenancy_db_name\": \"tenant_dgt\"}',0,'2024-06-20 09:14:52','2024-06-20 09:16:04',NULL),('dgt',27,NULL,'{\"created_at\": \"2024-06-20 09:16:04\", \"updated_at\": \"2024-06-20 09:16:04\", \"tenancy_db_name\": \"tenant_dgt\"}',0,'2024-06-20 09:16:04','2024-06-20 09:16:04',NULL),('zee',28,NULL,'{\"created_at\": \"2024-06-20 09:19:16\", \"updated_at\": \"2024-06-20 09:19:16\", \"tenancy_db_name\": \"tenant_zee\"}',0,'2024-06-20 09:19:13','2024-06-20 09:19:16',NULL),('zee',29,NULL,'{\"created_at\": \"2024-06-20 09:19:16\", \"updated_at\": \"2024-06-20 09:19:16\", \"tenancy_db_name\": \"tenant_zee\"}',0,'2024-06-20 09:19:16','2024-06-20 09:19:16',NULL),('fds',30,NULL,'{\"created_at\": \"2024-06-20 09:20:48\", \"updated_at\": \"2024-06-20 09:20:48\", \"tenancy_db_name\": \"tenant_fds\"}',0,'2024-06-20 09:20:43','2024-06-20 09:20:48',NULL),('fds',31,NULL,'{\"created_at\": \"2024-06-20 09:20:48\", \"updated_at\": \"2024-06-20 09:20:48\", \"tenancy_db_name\": \"tenant_fds\"}',0,'2024-06-20 09:20:48','2024-06-20 09:20:48',NULL),('123qaz',32,NULL,'{\"created_at\": \"2024-06-20 09:28:40\", \"updated_at\": \"2024-06-20 09:28:40\", \"tenancy_db_name\": \"tenant_123qaz\"}',0,'2024-06-20 09:28:38','2024-06-20 09:28:40',NULL),('123qaz',33,NULL,'{\"created_at\": \"2024-06-20 09:28:40\", \"updated_at\": \"2024-06-20 09:28:40\", \"tenancy_db_name\": \"tenant_123qaz\"}',0,'2024-06-20 09:28:40','2024-06-20 09:28:40',NULL),('123park',34,NULL,'{\"created_at\": \"2024-06-20 09:35:04\", \"updated_at\": \"2024-06-20 09:35:04\", \"tenancy_db_name\": \"tenant_123park\"}',0,'2024-06-20 09:34:59','2024-06-20 09:35:04',NULL),('123park',35,NULL,'{\"created_at\": \"2024-06-20 09:35:04\", \"updated_at\": \"2024-06-20 09:35:04\", \"tenancy_db_name\": \"tenant_123park\"}',0,'2024-06-20 09:35:04','2024-06-20 09:35:04',NULL),('grc',36,NULL,'{\"created_at\": \"2024-06-21 23:41:58\", \"updated_at\": \"2024-06-21 23:41:58\", \"tenancy_db_name\": \"tenant_grc\"}',0,'2024-06-21 23:41:58','2024-07-01 10:20:29','2024-07-01 10:20:29'),('sathishdev',37,NULL,'{\"created_at\": \"2024-06-22 12:21:37\", \"updated_at\": \"2024-06-22 12:21:37\", \"tenancy_db_name\": \"tenant_sathishdev\"}',0,'2024-06-22 12:21:37','2024-06-22 12:21:37',NULL),('test6',38,NULL,'{\"created_at\": \"2024-06-22 16:12:52\", \"updated_at\": \"2024-06-22 16:12:52\", \"tenancy_db_name\": \"tenant_test6\"}',0,'2024-06-22 16:12:52','2024-06-22 16:12:52',NULL),('test7',39,NULL,'{\"created_at\": \"2024-06-22 16:14:03\", \"updated_at\": \"2024-06-22 16:14:03\", \"tenancy_db_name\": \"tenant_test7\"}',0,'2024-06-22 16:14:03','2024-06-22 16:14:03',NULL),('grcdevtenant',43,NULL,'{\"created_at\": \"2024-07-01 10:22:08\", \"updated_at\": \"2024-07-01 10:22:08\", \"tenancy_db_name\": \"tenant_grcdevtenant\"}',0,'2024-07-01 10:22:08','2024-07-01 10:22:08',NULL),('GRC-Test',45,NULL,'{\"created_at\": \"2024-07-01 11:57:42\", \"updated_at\": \"2024-07-01 11:57:42\", \"tenancy_db_name\": \"tenant_GRC-Test\"}',0,'2024-07-01 11:57:42','2024-07-01 11:57:42',NULL),('amirdhev',46,NULL,'{\"created_at\": \"2024-07-01 12:27:44\", \"updated_at\": \"2024-07-01 12:27:44\", \"tenancy_db_name\": \"tenant_amirdhev\"}',0,'2024-07-01 12:27:44','2024-07-01 12:27:44',NULL),('amirdhevn',47,NULL,'{\"created_at\": \"2024-07-01 12:28:20\", \"updated_at\": \"2024-07-01 12:28:20\", \"tenancy_db_name\": \"tenant_amirdhevn\"}',0,'2024-07-01 12:28:20','2024-07-01 12:28:20',NULL),('dineshabc',48,NULL,'{\"created_at\": \"2024-07-01 12:36:52\", \"updated_at\": \"2024-07-01 12:36:52\", \"tenancy_db_name\": \"tenant_dineshabc\"}',0,'2024-07-01 12:36:52','2024-07-01 12:36:52',NULL),('dineshcom',49,NULL,'{\"created_at\": \"2024-07-01 12:41:11\", \"updated_at\": \"2024-07-01 12:41:11\", \"tenancy_db_name\": \"tenant_dineshcom\"}',0,'2024-07-01 12:41:11','2024-07-01 12:41:11',NULL),('grctest',50,NULL,'{\"created_at\": \"2024-07-01 13:49:38\", \"updated_at\": \"2024-07-01 13:49:38\", \"tenancy_db_name\": \"tenant_grctest\"}',0,'2024-07-01 13:49:38','2024-07-01 13:49:38',NULL),('grctestyop',51,NULL,'{\"created_at\": \"2024-07-01 13:50:49\", \"updated_at\": \"2024-07-01 13:50:49\", \"tenancy_db_name\": \"tenant_grctestyop\"}',0,'2024-07-01 13:50:49','2024-07-01 14:38:34','2024-07-01 14:38:34'),('grcdev',53,NULL,'{\"created_at\": \"2024-07-01 14:54:28\", \"updated_at\": \"2024-07-01 14:54:28\", \"tenancy_db_name\": \"tenant_grcdev\"}',0,'2024-07-01 14:54:28','2024-07-01 14:54:28',NULL),('xyz',54,NULL,'{\"created_at\": \"2024-07-01 15:08:15\", \"updated_at\": \"2024-07-01 15:08:15\", \"tenancy_db_name\": \"tenant_xyz\"}',0,'2024-07-01 15:08:15','2024-07-01 15:08:15',NULL),('demo',55,NULL,'{\"created_at\": \"2024-07-01 15:34:49\", \"updated_at\": \"2024-07-01 15:34:49\", \"tenancy_db_name\": \"tenant_demo\"}',0,'2024-07-01 15:34:49','2024-07-01 15:34:49',NULL),('cwgdts',56,NULL,'{\"created_at\": \"2024-07-02 23:54:24\", \"updated_at\": \"2024-07-02 23:54:24\", \"tenancy_db_name\": \"tenant_cwgdts\"}',0,'2024-07-02 23:54:24','2024-07-02 23:54:24',NULL),('dgt-test',57,NULL,'{\"created_at\": \"2024-07-23 14:44:33\", \"updated_at\": \"2024-07-23 14:44:33\", \"tenancy_db_name\": \"tenant_dgt-test\"}',0,'2024-07-23 14:39:15','2024-07-24 12:06:54','2024-07-24 12:06:54'),('dgt-test',58,NULL,'{\"created_at\": \"2024-07-23 14:44:33\", \"updated_at\": \"2024-07-23 14:44:33\", \"tenancy_db_name\": \"tenant_dgt-test\"}',0,'2024-07-23 14:44:33','2024-07-24 12:06:54','2024-07-24 12:06:54'),('testcompany',59,NULL,'{\"created_at\": \"2024-07-24 12:28:53\", \"updated_at\": \"2024-07-24 12:28:53\", \"tenancy_db_name\": \"tenant_testcompany\"}',0,'2024-07-24 11:02:04','2024-07-24 12:28:53',NULL),('testcompany',60,NULL,'{\"created_at\": \"2024-07-24 12:28:53\", \"updated_at\": \"2024-07-24 12:28:53\", \"tenancy_db_name\": \"tenant_testcompany\"}',0,'2024-07-24 11:26:56','2024-07-24 12:28:53',NULL),('testcompany',61,NULL,'{\"created_at\": \"2024-07-24 12:28:53\", \"updated_at\": \"2024-07-24 12:28:53\", \"tenancy_db_name\": \"tenant_testcompany\"}',0,'2024-07-24 11:29:33','2024-07-24 12:28:53',NULL),('testcompany1',62,NULL,'{\"created_at\": \"2024-07-24 11:31:57\", \"updated_at\": \"2024-07-24 11:31:57\", \"tenancy_db_name\": \"tenant_testcompany1\"}',0,'2024-07-24 11:30:06','2024-07-24 12:06:50','2024-07-24 12:06:50'),('testcompany1',63,NULL,'{\"created_at\": \"2024-07-24 11:31:57\", \"updated_at\": \"2024-07-24 11:31:57\", \"tenancy_db_name\": \"tenant_testcompany1\"}',0,'2024-07-24 11:31:57','2024-07-24 12:06:50','2024-07-24 12:06:50'),('companydomaintest',64,NULL,'{\"created_at\": \"2024-07-24 11:54:36\", \"updated_at\": \"2024-07-24 11:54:36\", \"tenancy_db_name\": \"tenant_companydomaintest\"}',0,'2024-07-24 11:54:35','2024-07-24 12:06:46','2024-07-24 12:06:46'),('companydomaintest',65,NULL,'{\"created_at\": \"2024-07-24 11:54:36\", \"updated_at\": \"2024-07-24 11:54:36\", \"tenancy_db_name\": \"tenant_companydomaintest\"}',0,'2024-07-24 11:54:36','2024-07-24 12:06:46','2024-07-24 12:06:46'),('testing-compant',66,NULL,'{\"created_at\": \"2024-07-24 11:56:01\", \"updated_at\": \"2024-07-24 11:56:01\", \"tenancy_db_name\": \"tenant_testing-compant\"}',0,'2024-07-24 11:56:01','2024-07-24 12:06:42','2024-07-24 12:06:42'),('grc-domain',67,NULL,'{\"created_at\": \"2024-07-24 12:02:26\", \"updated_at\": \"2024-07-24 12:02:26\", \"tenancy_db_name\": \"tenant_grc-domain\"}',0,'2024-07-24 12:02:26','2024-07-24 12:06:39','2024-07-24 12:06:39'),('grc-domains',68,NULL,'{\"created_at\": \"2024-07-24 12:06:12\", \"updated_at\": \"2024-07-24 12:06:12\", \"tenancy_db_name\": \"tenant_grc-domains\"}',0,'2024-07-24 12:03:31','2024-07-24 12:06:12',NULL),('grc-domains',69,NULL,'{\"created_at\": \"2024-07-24 12:06:12\", \"updated_at\": \"2024-07-24 12:06:12\", \"tenancy_db_name\": \"tenant_grc-domains\"}',0,'2024-07-24 12:06:12','2024-07-24 12:06:12',NULL),('testcompany',70,NULL,'{\"created_at\": \"2024-07-24 12:28:53\", \"updated_at\": \"2024-07-24 12:28:53\", \"tenancy_db_name\": \"tenant_testcompany\"}',0,'2024-07-24 12:28:53','2024-07-24 12:28:53',NULL),('testcompany2333',71,NULL,'{\"created_at\": \"2024-07-24 12:29:03\", \"updated_at\": \"2024-07-24 12:29:03\", \"tenancy_db_name\": \"tenant_testcompany2333\"}',0,'2024-07-24 12:29:03','2024-07-24 12:29:03',NULL),('sgc-tech',72,NULL,'{\"created_at\": \"2024-07-29 10:28:47\", \"updated_at\": \"2024-07-29 10:28:47\", \"tenancy_db_name\": \"tenant_sgc-tech\"}',0,'2024-07-29 10:28:47','2024-07-29 10:28:47',NULL),('julydemo',73,NULL,'{\"created_at\": \"2024-07-30 12:13:46\", \"updated_at\": \"2024-07-30 12:13:46\", \"tenancy_db_name\": \"tenant_julydemo\"}',0,'2024-07-30 12:13:46','2024-07-30 12:13:46',NULL),('anu333domain',74,NULL,'{\"created_at\": \"2024-07-30 12:17:14\", \"updated_at\": \"2024-07-30 12:17:14\", \"tenancy_db_name\": \"tenant_anu333domain\"}',0,'2024-07-30 12:17:02','2024-07-30 12:17:14',NULL),('anu333domain',75,NULL,'{\"created_at\": \"2024-07-30 12:17:14\", \"updated_at\": \"2024-07-30 12:17:14\", \"tenancy_db_name\": \"tenant_anu333domain\"}',0,'2024-07-30 12:17:14','2024-07-30 12:17:14',NULL),('dreamstech',76,NULL,'{\"created_at\": \"2024-08-07 17:07:06\", \"updated_at\": \"2024-08-07 17:07:06\", \"tenancy_db_name\": \"tenant_dreamstech\"}',0,'2024-08-07 17:07:06','2024-08-07 17:07:06',NULL),('amirlaks',77,NULL,'{\"created_at\": \"2024-08-14 10:53:11\", \"updated_at\": \"2024-08-14 10:53:11\", \"tenancy_db_name\": \"tenant_amirlaks\"}',0,'2024-08-14 10:53:11','2024-08-14 10:53:11',NULL),('samsung',78,NULL,'{\"created_at\": \"2024-08-14 11:02:41\", \"updated_at\": \"2024-08-14 11:02:41\", \"tenancy_db_name\": \"tenant_samsung\"}',0,'2024-08-14 11:02:41','2024-08-14 11:02:41',NULL),('airtel',79,NULL,'{\"created_at\": \"2024-08-14 11:06:50\", \"updated_at\": \"2024-08-14 11:06:50\", \"tenancy_db_name\": \"tenant_airtel\"}',0,'2024-08-14 11:06:50','2024-08-14 11:06:50',NULL),('sepdomain',80,NULL,'{\"created_at\": \"2024-09-02 12:14:17\", \"updated_at\": \"2024-09-02 12:14:17\", \"tenancy_db_name\": \"tenant_sepdomain\"}',0,'2024-09-02 12:11:20','2024-09-02 12:14:17',NULL),('sepdomain',81,NULL,'{\"created_at\": \"2024-09-02 12:14:17\", \"updated_at\": \"2024-09-02 12:14:17\", \"tenancy_db_name\": \"tenant_sepdomain\"}',0,'2024-09-02 12:14:17','2024-09-02 12:14:17',NULL),('domain1',82,NULL,'{\"created_at\": \"2024-09-03 11:55:38\", \"updated_at\": \"2024-09-03 11:55:38\", \"tenancy_db_name\": \"tenant_domain1\"}',0,'2024-09-03 11:54:31','2024-09-03 11:55:38',NULL),('domain1',83,NULL,'{\"created_at\": \"2024-09-03 11:55:38\", \"updated_at\": \"2024-09-03 11:55:38\", \"tenancy_db_name\": \"tenant_domain1\"}',0,'2024-09-03 11:55:38','2024-09-03 11:55:38',NULL),('testcompanysep03',84,NULL,'{\"created_at\": \"2024-09-03 11:58:32\", \"updated_at\": \"2024-09-03 11:58:32\", \"tenancy_db_name\": \"tenant_testcompanysep03\"}',0,'2024-09-03 11:58:32','2024-09-03 11:58:32',NULL),('testingsite1',85,NULL,'{\"created_at\": \"2024-09-03 13:16:10\", \"updated_at\": \"2024-09-03 13:16:10\", \"tenancy_db_name\": \"tenant_testingsite1\"}',0,'2024-09-03 13:14:00','2024-09-03 13:16:10',NULL),('testingsite1',86,NULL,'{\"created_at\": \"2024-09-03 13:16:10\", \"updated_at\": \"2024-09-03 13:16:10\", \"tenancy_db_name\": \"tenant_testingsite1\"}',0,'2024-09-03 13:16:10','2024-09-03 13:16:10',NULL),('dts',87,NULL,'{\"created_at\": \"2024-09-10 21:54:06\", \"updated_at\": \"2024-09-10 21:54:06\", \"tenancy_db_name\": \"tenant_dts\"}',0,'2024-09-10 21:52:13','2024-09-10 21:54:06',NULL),('dts',88,NULL,'{\"created_at\": \"2024-09-10 21:54:06\", \"updated_at\": \"2024-09-10 21:54:06\", \"tenancy_db_name\": \"tenant_dts\"}',0,'2024-09-10 21:54:06','2024-09-10 21:54:06',NULL),('C-UAT',89,NULL,'{\"created_at\": \"2024-09-22 17:54:39\", \"updated_at\": \"2024-09-22 17:54:39\", \"tenancy_db_name\": \"tenant_C-UAT\"}',0,'2024-09-22 17:53:20','2024-09-22 17:54:39',NULL),('C-UAT',90,NULL,'{\"created_at\": \"2024-09-22 17:54:39\", \"updated_at\": \"2024-09-22 17:54:39\", \"tenancy_db_name\": \"tenant_C-UAT\"}',0,'2024-09-22 17:54:39','2024-09-22 17:54:39',NULL),('s-uat',91,NULL,'{\"created_at\": \"2024-09-23 13:45:02\", \"updated_at\": \"2024-09-23 13:45:02\", \"tenancy_db_name\": \"tenant_s-uat\"}',0,'2024-09-23 13:45:02','2024-09-23 13:45:02',NULL),('bbb',92,NULL,'{\"created_at\": \"2024-09-23 13:55:41\", \"updated_at\": \"2024-09-23 13:55:41\", \"tenancy_db_name\": \"tenant_bbb\"}',0,'2024-09-23 13:54:25','2024-09-23 13:55:41',NULL),('bbb',93,NULL,'{\"created_at\": \"2024-09-23 13:55:41\", \"updated_at\": \"2024-09-23 13:55:41\", \"tenancy_db_name\": \"tenant_bbb\"}',0,'2024-09-23 13:55:41','2024-09-23 13:55:41',NULL),('sepmon',94,NULL,'{\"created_at\": \"2024-09-23 13:57:36\", \"updated_at\": \"2024-09-23 13:57:36\", \"tenancy_db_name\": \"tenant_sepmon\"}',0,'2024-09-23 13:57:36','2024-09-23 13:57:36',NULL),('test-bbb',95,NULL,'{\"created_at\": \"2024-09-23 14:01:27\", \"updated_at\": \"2024-09-23 14:01:27\", \"tenancy_db_name\": \"tenant_test-bbb\"}',0,'2024-09-23 13:58:00','2024-09-23 14:01:27',NULL),('test-bbb',96,NULL,'{\"created_at\": \"2024-09-23 14:01:27\", \"updated_at\": \"2024-09-23 14:01:27\", \"tenancy_db_name\": \"tenant_test-bbb\"}',0,'2024-09-23 14:01:27','2024-09-23 14:01:27',NULL),('login',97,NULL,'{\"created_at\": \"2024-09-23 14:16:12\", \"updated_at\": \"2024-09-23 14:16:12\", \"tenancy_db_name\": \"tenant_login\"}',0,'2024-09-23 14:16:12','2024-09-23 14:16:12',NULL),('bnm',98,NULL,'{\"created_at\": \"2024-09-23 18:00:22\", \"updated_at\": \"2024-09-23 18:00:22\", \"tenancy_db_name\": \"tenant_bnm\"}',0,'2024-09-23 18:00:17','2024-09-23 18:00:22',NULL),('bnm',99,NULL,'{\"created_at\": \"2024-09-23 18:00:22\", \"updated_at\": \"2024-09-23 18:00:22\", \"tenancy_db_name\": \"tenant_bnm\"}',0,'2024-09-23 18:00:22','2024-09-23 18:00:22',NULL),('fghjk',100,NULL,'{\"created_at\": \"2024-09-23 18:01:42\", \"updated_at\": \"2024-09-23 18:01:42\", \"tenancy_db_name\": \"tenant_fghjk\"}',0,'2024-09-23 18:01:19','2024-09-23 18:01:42',NULL),('fghjk',101,NULL,'{\"created_at\": \"2024-09-23 18:01:42\", \"updated_at\": \"2024-09-23 18:01:42\", \"tenancy_db_name\": \"tenant_fghjk\"}',0,'2024-09-23 18:01:42','2024-09-23 18:01:42',NULL),('tech-eng',102,NULL,'{\"created_at\": \"2024-09-30 18:20:25\", \"updated_at\": \"2024-09-30 18:20:25\", \"tenancy_db_name\": \"tenant_tech-eng\"}',0,'2024-09-30 18:20:25','2024-09-30 18:20:25',NULL),('lab-tech',103,NULL,'{\"created_at\": \"2024-09-30 18:21:34\", \"updated_at\": \"2024-09-30 18:21:34\", \"tenancy_db_name\": \"tenant_lab-tech\"}',0,'2024-09-30 18:21:34','2024-09-30 18:21:34',NULL),('lab-ser',104,NULL,'{\"created_at\": \"2024-09-30 18:24:05\", \"updated_at\": \"2024-09-30 18:24:05\", \"tenancy_db_name\": \"tenant_lab-ser\"}',0,'2024-09-30 18:24:05','2024-09-30 18:24:05',NULL),('lab-eng',105,NULL,'{\"created_at\": \"2024-09-30 18:31:58\", \"updated_at\": \"2024-09-30 18:31:58\", \"tenancy_db_name\": \"tenant_lab-eng\"}',0,'2024-09-30 18:31:40','2024-09-30 18:31:58',NULL),('lab-eng',106,NULL,'{\"created_at\": \"2024-09-30 18:31:58\", \"updated_at\": \"2024-09-30 18:31:58\", \"tenancy_db_name\": \"tenant_lab-eng\"}',0,'2024-09-30 18:31:58','2024-09-30 18:31:58',NULL),('mac',107,NULL,'{\"created_at\": \"2024-09-30 18:40:33\", \"updated_at\": \"2024-09-30 18:40:33\", \"tenancy_db_name\": \"tenant_mac\"}',0,'2024-09-30 18:33:19','2024-09-30 18:40:33',NULL),('mac',108,NULL,'{\"created_at\": \"2024-09-30 18:40:33\", \"updated_at\": \"2024-09-30 18:40:33\", \"tenancy_db_name\": \"tenant_mac\"}',0,'2024-09-30 18:40:33','2024-09-30 18:40:33',NULL),('mob-test',109,NULL,'{\"created_at\": \"2024-09-30 18:42:56\", \"updated_at\": \"2024-09-30 18:42:56\", \"tenancy_db_name\": \"tenant_mob-test\"}',0,'2024-09-30 18:42:56','2024-09-30 18:42:56',NULL),('elevate',110,NULL,'{\"created_at\": \"2024-10-15 00:23:18\", \"updated_at\": \"2024-10-15 00:23:18\", \"tenancy_db_name\": \"tenant_elevate\"}',0,'2024-10-15 00:21:18','2024-10-15 00:23:18',NULL),('oct17tenant',112,NULL,'{\"created_at\": \"2024-10-17 15:58:52\", \"updated_at\": \"2024-10-17 15:58:52\", \"tenancy_db_name\": \"tenant_oct17tenant\"}',0,'2024-10-17 15:58:52','2024-10-17 15:58:52',NULL),('nithiyop',113,NULL,'{\"created_at\": \"2024-10-17 16:23:42\", \"updated_at\": \"2024-10-17 16:23:42\", \"tenancy_db_name\": \"tenant_nithiyop\"}',0,'2024-10-17 16:23:42','2024-10-17 16:23:42',NULL),('dreamslive',114,NULL,'{\"created_at\": \"2024-10-18 15:19:58\", \"updated_at\": \"2024-10-18 15:19:58\", \"tenancy_db_name\": \"tenant_dreamslive\"}',0,'2024-10-18 15:19:58','2024-10-18 15:19:58',NULL),('vaskum.com',115,NULL,'{\"created_at\": \"2024-12-22 15:10:10\", \"updated_at\": \"2024-12-22 15:10:10\", \"tenancy_db_name\": \"tenant_vaskum.com\"}',0,'2024-12-22 15:10:10','2024-12-22 15:10:10',NULL);


