--
-- Host: europe-west2-001.proxy.kinsta.app    Database: inclusive-dashboard
-- ------------------------------------------------------


--
-- Table structure for table `audit`
--

CREATE TABLE `audit` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `issue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `audit_category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `audit_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quiz_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`quiz_info`)),
  `mark_complete` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_score` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `completion_rate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_engagement` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feedback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emoji_feedback` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_user_id_foreign` (`user_id`),
  KEY `audit_project_id_foreign` (`project_id`),
  CONSTRAINT `audit_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE CASCADE,
  CONSTRAINT `audit_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit`
--

INSERT INTO `audit` VALUES (95,'Misrepresenting an action or distorting an action','75',7,6,'2022-11-17 07:46:10','2024-02-13 12:31:02','Design-concept-audit','Internal Audit','[\"[{\\\"questionId\\\":\\\"36\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"37\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"38\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"39\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"40\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"41\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"42\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"47\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"56\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"0\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'88','35',NULL,NULL,NULL),(96,'Misrepresenting an action or distorting an action','25',1,1,'2022-11-17 11:04:19','2024-02-14 07:22:53','Audience-audit','Essential Of Internal Audit','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"100\\\"}]\"]',NULL,'58','20',NULL,NULL,NULL),(97,'Misrepresenting an action or distorting an action','75',1,7,'2022-11-17 11:14:04','2022-11-17 11:14:04','Complete-design-audit','Objectives Of Internal Audit','[\"[{\\\"questionId\\\":\\\"43\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"45\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'20','100',NULL,NULL,NULL),(99,'Misrepresenting an action or distorting an action','0',2,19,'2022-11-17 11:17:48','2024-02-14 07:45:16','Design-concept-audit','External Audit','[\"[{\\\"questionId\\\":\\\"44\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"0\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"50\\\"}]\"]',NULL,'62','20',NULL,NULL,NULL),(100,'Misrepresenting an action or distorting an action','50',7,2,'2022-11-18 07:48:23','2024-01-30 10:51:34','Audience-audit','Internal Audit','[\"[{\\\"questionId\\\":\\\"33\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"60\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"31\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"29\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"30\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'80','0',NULL,NULL,'likely'),(101,'Misrepresenting an action or distorting an action','25',7,2,'2022-11-18 07:49:55','2022-11-18 07:49:55','Test-Design-audit','External Audit','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"25\\\"}]\"]',NULL,'70','100',NULL,NULL,NULL),(102,'Misrepresenting an action or distorting an action','100',7,6,'2024-01-08 10:08:29','2024-01-31 07:43:06','Design-concept-audit','Mahboob Audit','[\"[{\\\"questionId\\\":\\\"36\\\",\\\"score\\\":\\\"0\\\"},{\\\"questionId\\\":\\\"34\\\",\\\"score\\\":\\\"0\\\"},{\\\"questionId\\\":\\\"35\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"59\\\",\\\"score\\\":\\\"100\\\"}]\"]',NULL,'10','0',NULL,NULL,NULL),(110,'Misrepresenting an action or distorting an action','75',7,29,'2024-02-06 11:55:24','2024-02-06 11:56:19','Audience-audit','Audit C','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,NULL,NULL,NULL,NULL,NULL),(113,'Misrepresenting an action or distorting an action','25',7,39,'2024-02-14 07:53:02','2024-02-14 11:53:26','Design-concept-audit','Developer','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"32\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"37\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"31\\\",\\\"score\\\":\\\"25\\\"}]\"]',NULL,'55','16',NULL,NULL,NULL),(114,'Misrepresenting an action or distorting an action','75',7,40,'2024-03-08 17:20:25','2024-03-08 17:21:46','Audience-audit','L2Beta','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'70','16',NULL,NULL,NULL),(115,'Misrepresenting an action or distorting an action','50',39,42,'2024-03-11 08:16:05','2024-03-11 08:16:09','Audience-audit','Talhas','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"50\\\"}]\"]',NULL,'50','3',NULL,NULL,NULL),(116,'Misrepresenting an action or distorting an action','100',12,43,'2024-03-11 08:18:09','2024-03-11 08:18:13','Audience-audit','zaryab','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"100\\\"}]\"]',NULL,'100','3',NULL,NULL,NULL),(117,'','',1,6,'2024-04-02 06:59:30','2024-04-02 06:59:30','Design-concept-audit','dd','[]',NULL,'0',NULL,NULL,NULL,NULL),(118,'','',1,44,'2024-04-15 16:38:11','2024-04-15 16:38:11','Design-concept-audit','d','[]',NULL,'0',NULL,NULL,NULL,NULL),(119,'Misrepresenting an action or distorting an action','25',41,2,'2024-08-16 12:47:20','2024-08-16 12:49:59','Audience-audit','test audit1','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"50\\\"}]\"]',NULL,'62','13',NULL,NULL,NULL),(120,'','',7,45,'2024-10-31 10:56:13','2024-10-31 10:56:13','Design-concept-audit','dd','[]',NULL,'0',NULL,NULL,NULL,NULL),(121,'Misrepresenting an action or distorting an action','0',1,46,'2024-12-02 12:54:01','2024-12-02 12:55:02','Audience-audit','`XXX','[\"[{\\\"questionId\\\":\\\"13\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"29\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"30\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"31\\\",\\\"score\\\":\\\"25\\\"},{\\\"questionId\\\":\\\"32\\\",\\\"score\\\":\\\"0\\\"},{\\\"questionId\\\":\\\"33\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'63','36',NULL,NULL,NULL),(122,'Misrepresenting an action or distorting an action','0',1,47,'2024-12-02 13:16:13','2024-12-02 13:16:33','Audience-audit','T1','[\"[{\\\"questionId\\\":\\\"17\\\",\\\"score\\\":\\\"50\\\"},{\\\"questionId\\\":\\\"18\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"19\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"20\\\",\\\"score\\\":\\\"75\\\"},{\\\"questionId\\\":\\\"21\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"29\\\",\\\"score\\\":\\\"100\\\"},{\\\"questionId\\\":\\\"30\\\",\\\"score\\\":\\\"75\\\"}]\"]',NULL,'78','23',NULL,NULL,NULL);

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comments` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `like` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dislike` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`comments_id`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES (40,'Randall Flag, Jack Torrance and John Coffey are all characters created by which author','2022-09-09 06:26:18','2023-09-27 06:35:21',7,2,'14','7','[{\"comment_id\":\"40\",\"comment_text\":\"test1\",\"date\":\"2022\",\"logo\":\"1661840323.jpg\",\"user_name\":\"veteranLogix\"},{\"comment_id\":\"40\",\"comment_text\":\"test2\",\"date\":\"2022\",\"logo\":\"1661840323.jpg\",\"user_name\":\"veteranLogix\"},{\"comment_id\":\"40\",\"comment_text\":\"test\",\"date\":\"2023-09-27\",\"logo\":\"1661840323.jpg\",\"user_name\":\"veteranLogix\"}]'),(41,'nnn','2022-09-13 01:36:34','2022-11-17 07:35:53',2,2,'11','9','[{\"comment_id\":\"40\",\"comment_text\":\"fff\",\"date\":\"2022\",\"logo\":\"1661840323.jpg\",\"user_name\":\"veteranLogix\"},{\"comment_id\":\"40\",\"comment_text\":\"test\",\"date\":\"2022\",\"logo\":\"1661840323.jpg\",\"user_name\":\"veteranLogix\"}]'),(42,'fff','2022-09-14 03:25:44','2024-01-31 07:43:55',2,2,'14','8','[{\"comment_id\":\"42\",\"comment_text\":\"mian\",\"date\":\"2022\",\"logo\":\"1657186670.jpg\",\"user_name\":\"Muhammad hamza\"},{\"comment_id\":\"42\",\"comment_text\":\"hamza\",\"date\":\"2022\",\"logo\":\"1657186670.jpg\",\"user_name\":\"Muhammad hamza\"},{\"comment_id\":\"42\",\"comment_text\":\"test last\",\"date\":\"2022-09-14\",\"logo\":\"1657186670.jpg\",\"user_name\":\"Muhammad hamza\"}]'),(43,'The Difference Between Internal Audit And External Audit','2022-11-17 11:17:03','2024-01-31 07:44:35',2,19,'5','3','[{\"comment_id\":\"43\",\"comment_text\":\"Internal Audit\",\"date\":\"2024-01-31\",\"logo\":\"1668071647.jpg\",\"user_name\":\"Manager\"}]'),(44,'test','2024-08-16 12:47:50','2024-08-16 12:47:50',41,2,'0','0',NULL),(45,'test','2024-08-16 12:47:59','2024-08-16 12:47:59',41,2,'0','0',NULL),(46,'testfr','2024-08-16 12:48:05','2024-08-16 12:48:05',41,2,'0','0',NULL),(47,'mm','2024-08-16 12:49:16','2024-08-16 12:49:37',41,2,'1','1',NULL),(48,'mmmm','2024-08-16 12:49:28','2024-08-16 12:49:43',41,2,'0','1','[{\"comment_id\":\"48\",\"comment_text\":\"m\",\"date\":\"2024-08-16\",\"logo\":null,\"user_name\":\"testuser\"}]');

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) 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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1,'Experience dynamic','software developer','1710227501.png','www.veteranlogix.com','2022-06-03 01:22:13','2024-03-12 07:11:41'),(3,'Inner circle','ux','1667889789.jpg','www.uxinnercircle.com','2022-06-03 01:22:13','2022-11-17 07:24:57'),(4,'Women Enabled','Women Enabled','1667889789.jpg','www.womenenabled.com','2022-06-03 01:22:13','2022-11-17 07:25:37'),(9,'miusa','abc','1714724282.png','https://lolwhoa.com','2024-05-03 08:18:02','2024-05-03 08:18:02');

--
-- 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 `follow_ups`
--

CREATE TABLE `follow_ups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `question_id` bigint(20) unsigned NOT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `audit_id` bigint(20) unsigned NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `follow_ups_project_id_foreign` (`project_id`),
  KEY `follow_ups_user_id_foreign` (`user_id`),
  KEY `follow_ups_question_id_foreign` (`question_id`),
  CONSTRAINT `follow_ups_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE CASCADE,
  CONSTRAINT `follow_ups_question_id_foreign` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `follow_ups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `follow_ups`
--

INSERT INTO `follow_ups` VALUES (1,1,'2022-06-08 02:20:34','2022-06-08 02:20:34',2,13,'It is a long established fact that a reader will be distracted by t',0,NULL),(5,1,'2022-06-09 03:04:04','2022-06-09 03:04:04',2,17,'always free from repetition',0,NULL),(9,19,'2022-11-17 11:16:27','2022-11-17 11:16:27',2,17,'external ausit',0,NULL),(10,19,'2022-11-17 11:16:47','2022-11-17 11:16:47',2,44,'control system',0,NULL),(11,6,'2024-02-12 11:16:43','2024-02-12 13:04:29',7,36,'always free from repetition',95,'Redo'),(12,6,'2024-02-12 11:22:35','2024-02-12 11:22:35',7,37,'Explain external audit',95,'Passed'),(13,6,'2024-02-12 13:04:09','2024-02-12 13:04:27',7,39,'It is a long established fact that a reader will be distracted by t',95,'Passed'),(14,19,'2024-02-13 08:01:51','2024-02-13 08:01:51',2,46,'',99,'Passed'),(15,19,'2024-02-13 08:04:48','2024-02-13 08:04:48',2,44,'',99,'Redo'),(16,39,'2024-02-14 07:54:19','2024-02-14 07:54:19',7,21,'',113,'Passed'),(17,39,'2024-02-14 07:54:23','2024-02-14 07:54:23',7,32,'',113,'Redo'),(18,2,'2024-08-16 12:49:02','2024-08-16 12:49:02',41,13,'test',119,NULL),(19,19,'2024-10-31 10:53:21','2024-10-31 10:53:21',2,13,'',99,'Passed'),(20,46,'2024-12-02 12:54:24','2024-12-02 12:54:24',1,13,'TESTXXX',121,NULL);

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_description` varchar(255) 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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES (4,'developer','web developer','2022-08-16 08:24:51','2022-08-16 08:24:51'),(8,'blog writer','blog writer','2022-11-16 06:05:50','2022-11-16 06:05:50'),(9,'QA Tester','QA Tester','2022-11-16 06:06:09','2022-11-16 06:06:09');

--
-- Table structure for table `learning_engagement`
--

CREATE TABLE `learning_engagement` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `learning_engagement`
--

INSERT INTO `learning_engagement` VALUES (1,'98','2022-06-22 04:53:45','2024-01-22 11:22:04',1,NULL),(8,'4','2022-06-24 02:57:38','2024-01-08 13:01:09',2,NULL),(9,'3','2022-09-14 01:06:59','2024-01-08 10:09:11',6,NULL),(10,'2','2022-11-17 11:15:52','2022-11-17 11:16:03',19,NULL),(11,'1','2024-01-08 13:24:27','2024-01-08 13:24:27',7,NULL);

--
-- Table structure for table `learning_zone`
--

CREATE TABLE `learning_zone` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `learning_zone`
--

INSERT INTO `learning_zone` VALUES (3,'frank spiller','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','1667907104.jpg','2022-11-08 06:31:44','2022-11-08 06:31:44','[\"1\"]'),(4,'Experience Dynamics','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock','1667995571.jpg','2022-11-09 07:06:11','2022-11-09 07:06:11',NULL),(17,'Experience Dynamic','Experience Dynamic helps you build loyalty and generate more revenue by giving your customers the interactions they crave.','1667907104.jpg','2024-01-09 06:31:40','2024-01-09 06:31:40',NULL),(18,'Blog','Learning Zone Blog','1667907104.jpg','2024-01-24 13:20:43','2024-01-24 13:20:43','[\"3\",\"4\",\"7\"]');

--
-- 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=58 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,'2022_05_24_074658_create_roles_table',1),(6,'2022_05_24_074836_create_project_table',1),(7,'2022_05_24_075003_create_questions_table',1),(8,'2022_05_24_075131_create_audit_table',1),(9,'2022_05_24_075308_create_follow_ups_table',1),(10,'2022_05_24_095744_add_user_id_to_questions',1),(11,'2022_05_24_095817_add_user_id_to_follow_ups',1),(12,'2022_06_02_143600_create_company_table',1),(13,'2022_06_03_094307_add_columns_to_questions_table',2),(14,'2022_06_03_102444_add_slider_to_questions_table',3),(15,'2022_06_07_060406_add_category_to_audit_table',4),(16,'2022_06_07_063446_add_audit_name_to_audit_table',5),(17,'2022_06_07_130655_create_comments_table',6),(18,'2022_06_08_070300_remove_column_from_follow_ups',7),(19,'2022_06_08_071140_add_questions_follow_up',8),(20,'2022_06_08_072246_add_range_to_follow_up',9),(21,'2022_06_08_073345_remove_range_to_follow_up',10),(22,'2022_06_09_113458_add_notes_to_follow_up',11),(23,'2022_06_10_111241_create_tags_table',12),(24,'2022_06_10_111556_rename_tags_column',13),(25,'2022_06_10_112001_add_name_to_tags',14),(26,'2022_06_14_053352_add_quiz_info_to_audit',15),(27,'2022_06_17_073040_add_logo_to_users',16),(28,'2022_06_17_073356_remove_logo_from_users',17),(29,'2022_06_17_073610_add_logo_to_users',18),(30,'2022_06_17_092945_alter_comments_table',19),(31,'2022_06_22_093816_create_learning_engagement_table',20),(32,'2022_06_23_075730_add_mark_complete_to_audit',21),(33,'2022_06_30_055149_add_total_score_to_audit',22),(34,'2022_07_01_063348_add_completion_rate_to_audit',23),(35,'2022_07_01_094013_add_learning_engagement_to_audit',24),(36,'2022_08_10_062342_add_feedback_to_audit',25),(37,'2022_08_11_071256_add_emoji_to_audit',26),(38,'2022_08_16_124846_create_jobs_table',27),(39,'2022_08_30_085353_add_like_dislike_to_comments',28),(40,'2022_08_31_065752_add_comments_id_to_comments',29),(41,'2022_08_31_070545_drop_column_from_comments',30),(42,'2022_08_31_070726_add_comment_id_to_comments',31),(43,'2022_09_13_093452_drop_columns_from_questions',32),(44,'2022_11_08_104643_create_learning_zone_table',33),(45,'2022_11_09_115313_add_tags_to_learning_zone',34),(46,'2024_01_24_121738_add_tags_to_learning_engagement_table',35),(47,'2024_01_24_131355_add_tags_to_learning_zone_table',36),(48,'2024_01_25_122939_remove_image_column_from_questions_table',37),(49,'2024_01_25_123335_add_explanation_to_questions_table',38),(50,'2024_01_29_073136_remove_image_from_questions_table',39),(51,'2024_02_07_122604_add_description_to_tags_table',40),(52,'2024_02_12_080453_add_status_to_audit_table',41),(53,'2024_02_12_105924_add_status_to_follow_ups_table',42),(54,'2024_02_12_110221_drop_status_from_audit_table',43),(55,'2024_03_06_125734_create_themes_table',44),(56,'2024_03_07_065336_add_theme_column_to_tags_table',45),(57,'2024_03_19_065017_drop_learning_engagement_table',46);

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_user_id_foreign` (`user_id`),
  CONSTRAINT `project_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project`
--

INSERT INTO `project` VALUES (1,'Project A',2,'2022-06-03 01:45:17','2024-02-06 10:03:00'),(2,'Project B',2,'2022-06-10 02:05:25','2022-06-10 02:05:25'),(6,'Project C',2,'2022-09-12 06:45:00','2022-11-15 10:11:50'),(7,'Project D',2,'2022-09-23 08:32:48','2022-11-15 10:12:00'),(19,'Project E',2,'2022-11-11 08:03:39','2022-11-15 10:12:09'),(29,'new project',1,'2024-01-25 13:17:49','2024-01-25 13:17:49'),(32,'hamza Project',7,'2024-01-31 08:10:55','2024-01-31 08:10:55'),(33,'veteranLogix',7,'2024-01-31 08:35:24','2024-01-31 08:35:24'),(34,'Ameer Hamza project',7,'2024-01-31 08:51:09','2024-01-31 08:51:09'),(35,'project_name',7,'2024-02-01 06:32:44','2024-02-01 06:32:44'),(38,'Inclusive Audit',1,'2024-02-13 13:42:01','2024-02-13 13:42:01'),(39,'Developer',1,'2024-02-14 07:53:02','2024-02-14 07:53:02'),(40,'Kakao',7,'2024-03-08 17:20:25','2024-03-08 17:20:25'),(41,'Talha\'s Project',12,'2024-03-11 08:07:53','2024-03-11 08:07:53'),(42,'Talha\'s',39,'2024-03-11 08:16:05','2024-03-11 08:16:05'),(43,'Zaigham',12,'2024-03-11 08:18:09','2024-03-11 08:18:09'),(44,'d',1,'2024-04-15 16:38:11','2024-04-15 16:38:11'),(45,'test project',7,'2024-10-31 10:56:13','2024-10-31 10:56:13'),(46,'TESTXXX',1,'2024-12-02 12:54:01','2024-12-02 12:54:01'),(47,'Project CXAS',1,'2024-12-02 13:16:13','2024-12-02 13:16:13');

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `questions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`tags`)),
  `company_id` bigint(20) unsigned NOT NULL,
  `explanation` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `questions_user_id_foreign` (`user_id`),
  CONSTRAINT `questions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` VALUES (13,'What is the name of the main antagonist in the Shakespeare play.?','2022-07-13 01:51:07','2024-02-06 10:26:03',1,'[]',1,'<p>Quisque ut aliquet orci, a ullamcorper justo. Integer pharetra vitae metus at fermentum. Nunc eget velit vel mauris fermentum sodales. Vivamus sed ipsum at lacus semper imperdiet. Aliquam erat volutpat. Phasellus ullamcorper justo vitae lacus ultrices, id ultricies dolor tristique. Curabitur sit amet neque quis orci euismod tincidunt. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin vitae ipsum vel nisi euismod congue. Suspendisse eu arcu aliquet, accumsan felis a, efficitur dui<img class=\"upload-image\" src=\"images/1667995571.jpg\" alt=\"\" /></p>\r\n<p>Quisque ut aliquet orci, a ullamcorper justo. Integer pharetra vitae metus at fermentum. Nunc eget velit vel mauris fermentum sodales. Vivamus sed ipsum at lacus semper imperdiet. Aliquam erat volutpat. Phasellus ullamcorper justo vitae lacus ultrices, id ultricies dolor tristique. Curabitur sit amet neque quis orci euismod tincidunt. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin vitae ipsum vel nisi euismod congue. Suspendisse eu arcu aliquet, accumsan felis a, efficitur dui</p>'),(17,'Which English city is known as the Steel City?','2022-07-07 05:09:56','2024-02-06 10:59:07',1,'[]',1,'<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.<img class=\"upload-image\" src=\"images/1706785801.jpg\" alt=\"\" />Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</p>'),(18,'Which former British colony was given back to China in 1997?','2022-07-07 05:28:16','2022-07-07 05:28:16',12,'[\"3\",\"5\",\"3\",\"1\"]',1,NULL),(19,'The logo for luxury car maker Porsche features which animal?','2022-09-08 08:14:47','2022-09-08 08:14:47',12,'[\"3\",\"5\",\"1\"]',1,NULL),(20,'Which element is said to keep bones strong?','2022-07-08 08:20:38','2022-07-08 08:20:38',7,'[\"3\",\"1\"]',1,NULL),(21,'Haematology is the study of what??','2022-07-08 08:23:01','2022-11-14 11:23:22',7,'[\"3\",\"1\"]',1,NULL),(29,'Why You Want To Be A Auditor?','2022-11-17 06:53:40','2022-11-17 06:53:40',2,'[\"3\",\"5\"]',3,NULL),(30,'What Are Intangible Assets?','2022-11-17 06:54:04','2022-11-17 06:54:04',2,'[\"3\",\"5\"]',3,NULL),(31,'What Are Tangible Assets?','2022-11-17 06:54:29','2022-11-17 06:54:29',2,'[\"3\",\"5\"]',3,NULL),(32,'Who Will Audit An Auditing Firm?','2022-11-17 06:55:17','2022-11-17 06:55:17',2,'[\"3\",\"1\",\"5\"]',3,NULL),(33,'What Is The Mean Of Decommission Liability?','2022-11-17 06:55:48','2022-11-17 06:55:48',2,'[\"3\"]',3,NULL),(34,'What Should The Internal Auditor?','2022-11-17 06:56:16','2022-11-17 06:56:16',2,'[\"3\",\"1\"]',3,NULL),(35,'How did you get into auditing ?','2022-11-17 06:56:40','2022-11-17 06:56:40',2,'[\"3\",\"1\"]',3,NULL),(36,'What Is Internal Audit?','2022-11-17 07:20:59','2022-11-17 07:20:59',2,'[\"7\",\"8\",\"1\",\"3\"]',3,NULL),(37,'What Is External Audit?','2022-11-17 07:22:56','2022-11-17 07:22:56',2,'[\"3\",\"8\"]',3,NULL),(38,'What Is Non Statutory Audit?','2022-11-17 07:26:37','2022-11-17 07:26:37',1,'[\"5\",\"8\"]',4,NULL),(39,'Do You Know The Different Types Of Audits?','2022-11-17 07:28:08','2022-11-17 07:28:08',1,'[\"3\",\"1\",\"7\"]',3,NULL),(40,'Do You Know What Are The Reasons For Getting Audited?','2022-11-17 07:28:29','2022-11-17 07:28:29',1,'[\"3\",\"8\"]',3,NULL),(41,'What Is The Mean Of Statutory Audit?','2022-11-17 07:28:49','2022-11-17 07:28:49',1,'[\"3\",\"8\"]',3,NULL),(42,'What Is The Purpose Of Meeting In Audit?','2022-11-17 07:29:06','2022-11-17 07:29:06',1,'[\"5\",\"8\"]',3,NULL),(43,'What Is The Mean Of Internal Audit?','2022-11-17 07:29:26','2022-11-17 07:29:26',1,'[\"3\",\"1\",\"8\"]',3,NULL),(44,'What Are The Basic Principles Of An Internal Audit Control System?','2022-11-17 07:29:52','2022-11-17 07:29:52',1,'[\"3\",\"7\",\"5\"]',3,NULL),(45,'Whats Are The Importance Of Evaluating An Internal Audit Department?','2022-11-17 07:30:14','2022-11-17 07:30:14',1,'[\"3\",\"1\",\"5\",\"7\"]',3,NULL),(46,'What Are The Importance Of Internal Audit To The Organization?','2022-11-17 07:30:35','2022-11-17 07:30:35',1,'[\"7\"]',3,NULL),(47,'Explain The Difference Between Internal Audit And Statutory Audit?','2022-11-17 07:31:02','2022-11-17 07:31:02',1,'[\"3\",\"1\",\"7\",\"8\"]',4,NULL),(48,'Tell Me That How I Can Evaluate The Internal Control Audit?','2022-11-17 07:31:25','2022-11-17 07:31:25',1,'[\"1\",\"3\",\"7\"]',4,NULL),(49,'Explain How To Do An Internal Audit Effectively?','2022-11-17 07:31:49','2022-11-17 07:31:49',1,'[\"8\",\"7\",\"5\"]',4,NULL),(56,'What are the principles of auditing?','2024-01-29 07:37:43','2024-01-29 07:37:43',1,'[]',3,'<p>This is Explanation</p>'),(59,'How long does an audit take?','2024-01-30 10:49:11','2024-01-30 10:49:11',1,'[\"3\"]',1,'Lorem ipsum&nbsp;is placeholder text commonly used in the graphic, print, and publishing industries for previewing layouts and visual mockups.'),(62,'What are business risks?','2024-02-01 10:27:02','2024-02-01 10:27:02',1,'[\"3\"]',1,'<p>Quisque ut aliquet orci, a ullamcorper justo. Integer pharetra vitae metus at fermentum. Nunc eget velit vel mauris fermentum sodales. Vivamus sed ipsum at lacus semper imperdiet. Aliquam erat volutpat. Phasellus ullamcorper justo vitae lacus ultrices, id ultricies dolor tristique. Curabitur sit amet neque quis orci euismod tincidunt. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin vitae ipsum vel nisi euismod congue. Suspendisse eu arcu aliquet, accumsan felis a, efficitur dui<img class=\"upload-image\" src=\"images/1667995571.jpg\" alt=\"\" /></p>\r\n<p>Quisque ut aliquet orci, a ullamcorper justo. Integer pharetra vitae metus at fermentum. Nunc eget velit vel mauris fermentum sodales. Vivamus sed ipsum at lacus semper imperdiet. Aliquam erat volutpat. Phasellus ullamcorper justo vitae lacus ultrices, id ultricies dolor tristique. Curabitur sit amet neque quis orci euismod tincidunt. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin vitae ipsum vel nisi euismod congue. Suspendisse eu arcu aliquet, accumsan felis a, efficitur dui</p>');

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `roles` varchar(255) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Employee',NULL,NULL),(2,'Admin',NULL,NULL),(3,'Super Admin',NULL,NULL);

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `themes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`themes`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'2022-06-10 06:37:31','2022-06-10 06:37:31','General','general means belonging to, or prevailing throughout, a whole class or body collectively, irrespective of individuals','[\"3\"]'),(3,'2022-06-10 06:58:50','2022-06-10 06:58:50','Heterosexism','Heterosexism is a system of attitudes, bias, and discrimination in favor of heterosexuality and heterosexual relationships. According to Elizabeth Cramer, it can include the belief that all people are or should be heterosexual and that heterosexual relationships are the only norm and therefore superior.','[\"2\"]'),(5,'2022-06-10 06:59:54','2022-06-10 06:59:54','Sexism','Sexism is prejudice or discrimination based on one\'s sex or gender. Sexism can affect anyone, but primarily affects women and girls. It has been linked to gender roles and stereotypes, and may include the belief that one sex or gender is intrinsically superior to another.','[\"3\"]'),(7,'2022-11-17 07:13:22','2022-11-17 07:13:22','Classism','Class discrimination, also known as classism, is prejudice or discrimination on the basis of social class. It includes individual attitudes, behaviors, systems of policies and practices that are set up to benefit the upper class at the expense of the lower class.',NULL),(8,'2022-11-17 07:16:41','2022-11-17 07:16:41','Ethnocentrism','Ethnocentrism in social science and anthropology—as well as in colloquial English discourse—means to apply one\'s own culture or ethnicity as a frame of reference to judge other cultures, practices, behaviors, beliefs, and people, instead of using the standards of the particular culture involved. ',NULL),(9,'2023-09-28 06:42:10','2023-09-28 06:42:10','Ageism','Ageism is bias against, discrimination towards, or bullying of individuals and groups on the basis of their age. The term was coined in 1969 by Robert Neil Butler to describe discrimination against the elderly, patterned on the terminology of sexism and racism.',NULL),(10,'2023-09-28 06:42:18','2023-09-28 06:42:18','Ableism','Ableism is discrimination and social prejudice against people with physical or mental disabilities. Ableism characterizes people as they are defined by their disabilities and it also classifies disabled people as people who are inferior to non-disabled people.',NULL),(11,'2023-09-28 06:42:26','2023-09-28 06:42:26','Racism','Racism is the process by which systems and policies, actions and attitudes create inequitable opportunities and outcomes for people based on race.\n',NULL),(12,'2023-09-28 06:42:33','2023-09-28 06:42:33','Educated','Educated is a memoir by the American author Tara Westover. Westover recounts overcoming her survivalist Mormon family in order to go to college, and emphasizes the importance of education in enlarging her world.',NULL),(13,'2023-09-28 06:42:42','2023-09-28 06:42:42','Colorism','Discrimination based on skin tone, also known as colorism or shadeism, is a form of prejudice and discrimination in which people of certain ethnic groups, or people who are perceived as belonging to a darker-skinned race, are treated differently based on their darker skin tone.',NULL),(17,'2024-02-07 12:50:07','2024-02-07 12:50:07','Disability','The social model centers disability as a societally-created limitation on individuals who do not have the same ability as the majority of the population.',NULL),(19,'2024-03-07 07:19:26','2024-03-07 07:19:26','Dynamic','Dynamic','[]'),(20,'2024-03-07 07:41:07','2024-03-07 07:41:07','creative','creative','[\"2\",\"3\"]');

--
-- Table structure for table `themes`
--

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

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` VALUES (1,'My Theme','My First Theme','2024-03-06 13:43:39','2024-03-19 06:00:22'),(2,'Harm','Harm','2024-03-07 07:18:20','2024-03-07 07:18:20'),(3,'Experience Dynamic','Theme','2024-03-07 07:18:31','2024-03-07 07:18:31');


