-- MySQL dump 10.13 Distrib 8.0.44, for Win64 (x86_64) -- -- Host: localhost Database: ejobs360 -- ------------------------------------------------------ -- Server version 8.0.44 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `admin_audit_log` -- DROP TABLE IF EXISTS `admin_audit_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `admin_audit_log` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `admin_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `action` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `target_entity` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `target_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `details` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin_audit_log` -- LOCK TABLES `admin_audit_log` WRITE; /*!40000 ALTER TABLE `admin_audit_log` DISABLE KEYS */; /*!40000 ALTER TABLE `admin_audit_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `analytics_event` -- DROP TABLE IF EXISTS `analytics_event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `analytics_event` ( `id` bigint NOT NULL AUTO_INCREMENT, `event_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `properties` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `analytics_event` -- LOCK TABLES `analytics_event` WRITE; /*!40000 ALTER TABLE `analytics_event` DISABLE KEYS */; /*!40000 ALTER TABLE `analytics_event` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `application_job_application` -- DROP TABLE IF EXISTS `application_job_application`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `application_job_application` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_post_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `applicant_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `resume_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_letter` longtext COLLATE utf8mb4_unicode_ci, `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `current_stage_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stage_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `ai_fit_score` smallint DEFAULT NULL, `employer_notes` json NOT NULL, `source` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `submitted_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `application_job_application` -- LOCK TABLES `application_job_application` WRITE; /*!40000 ALTER TABLE `application_job_application` DISABLE KEYS */; /*!40000 ALTER TABLE `application_job_application` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `application_talent_pool_candidate` -- DROP TABLE IF EXISTS `application_talent_pool_candidate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `application_talent_pool_candidate` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `candidate_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tags` json NOT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `application_talent_pool_candidate` -- LOCK TABLES `application_talent_pool_candidate` WRITE; /*!40000 ALTER TABLE `application_talent_pool_candidate` DISABLE KEYS */; /*!40000 ALTER TABLE `application_talent_pool_candidate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assessment_certification` -- DROP TABLE IF EXISTS `assessment_certification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assessment_certification` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `passing_score` int NOT NULL, `duration_minutes` int NOT NULL, `questions` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assessment_certification` -- LOCK TABLES `assessment_certification` WRITE; /*!40000 ALTER TABLE `assessment_certification` DISABLE KEYS */; /*!40000 ALTER TABLE `assessment_certification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assessment_daily_challenge` -- DROP TABLE IF EXISTS `assessment_daily_challenge`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assessment_daily_challenge` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `question` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` json NOT NULL, `correct_option` int NOT NULL, `points` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `date` (`date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assessment_daily_challenge` -- LOCK TABLES `assessment_daily_challenge` WRITE; /*!40000 ALTER TABLE `assessment_daily_challenge` DISABLE KEYS */; /*!40000 ALTER TABLE `assessment_daily_challenge` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assessment_skill` -- DROP TABLE IF EXISTS `assessment_skill`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assessment_skill` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `category` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assessment_skill` -- LOCK TABLES `assessment_skill` WRITE; /*!40000 ALTER TABLE `assessment_skill` DISABLE KEYS */; /*!40000 ALTER TABLE `assessment_skill` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_email_verification` -- DROP TABLE IF EXISTS `auth_email_verification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_email_verification` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expires_at` datetime(6) NOT NULL, `used_at` datetime(6) DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_email_verification` -- LOCK TABLES `auth_email_verification` WRITE; /*!40000 ALTER TABLE `auth_email_verification` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_email_verification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group` -- DROP TABLE IF EXISTS `auth_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group` -- LOCK TABLES `auth_group` WRITE; /*!40000 ALTER TABLE `auth_group` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group_permissions` -- DROP TABLE IF EXISTS `auth_group_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group_permissions` ( `id` bigint NOT NULL AUTO_INCREMENT, `group_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group_permissions` -- LOCK TABLES `auth_group_permissions` WRITE; /*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_login_history` -- DROP TABLE IF EXISTS `auth_login_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_login_history` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `ip_address` char(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `failure_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_login_history` -- LOCK TABLES `auth_login_history` WRITE; /*!40000 ALTER TABLE `auth_login_history` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_login_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_permission` -- DROP TABLE IF EXISTS `auth_permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_permission` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content_type_id` int NOT NULL, `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`), CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_permission` -- LOCK TABLES `auth_permission` WRITE; /*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */; INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',3,'add_permission'),(6,'Can change permission',3,'change_permission'),(7,'Can delete permission',3,'delete_permission'),(8,'Can view permission',3,'view_permission'),(9,'Can add group',2,'add_group'),(10,'Can change group',2,'change_group'),(11,'Can delete group',2,'delete_group'),(12,'Can view group',2,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add Email Verification Token',7,'add_emailverificationtoken'),(26,'Can change Email Verification Token',7,'change_emailverificationtoken'),(27,'Can delete Email Verification Token',7,'delete_emailverificationtoken'),(28,'Can view Email Verification Token',7,'view_emailverificationtoken'),(29,'Can add Login History',8,'add_loginhistory'),(30,'Can change Login History',8,'change_loginhistory'),(31,'Can delete Login History',8,'delete_loginhistory'),(32,'Can view Login History',8,'view_loginhistory'),(33,'Can add Refresh Token',9,'add_refreshtoken'),(34,'Can change Refresh Token',9,'change_refreshtoken'),(35,'Can delete Refresh Token',9,'delete_refreshtoken'),(36,'Can view Refresh Token',9,'view_refreshtoken'),(37,'Can add Tenant',10,'add_tenant'),(38,'Can change Tenant',10,'change_tenant'),(39,'Can delete Tenant',10,'delete_tenant'),(40,'Can view Tenant',10,'view_tenant'),(41,'Can add User Account',11,'add_useraccount'),(42,'Can change User Account',11,'change_useraccount'),(43,'Can delete User Account',11,'delete_useraccount'),(44,'Can view User Account',11,'view_useraccount'),(45,'Can add Activity Log',12,'add_activitylog'),(46,'Can change Activity Log',12,'change_activitylog'),(47,'Can delete Activity Log',12,'delete_activitylog'),(48,'Can view Activity Log',12,'view_activitylog'),(49,'Can add Career Board',13,'add_careerboard'),(50,'Can change Career Board',13,'change_careerboard'),(51,'Can delete Career Board',13,'delete_careerboard'),(52,'Can view Career Board',13,'view_careerboard'),(53,'Can add Career Board Item',14,'add_careerboarditem'),(54,'Can change Career Board Item',14,'change_careerboarditem'),(55,'Can delete Career Board Item',14,'delete_careerboarditem'),(56,'Can view Career Board Item',14,'view_careerboarditem'),(57,'Can add Company',15,'add_company'),(58,'Can change Company',15,'change_company'),(59,'Can delete Company',15,'delete_company'),(60,'Can view Company',15,'view_company'),(61,'Can add Education',16,'add_education'),(62,'Can change Education',16,'change_education'),(63,'Can delete Education',16,'delete_education'),(64,'Can view Education',16,'view_education'),(65,'Can add Employer Profile',17,'add_employerprofile'),(66,'Can change Employer Profile',17,'change_employerprofile'),(67,'Can delete Employer Profile',17,'delete_employerprofile'),(68,'Can view Employer Profile',17,'view_employerprofile'),(69,'Can add Job Seeker Profile',18,'add_jobseekerprofile'),(70,'Can change Job Seeker Profile',18,'change_jobseekerprofile'),(71,'Can delete Job Seeker Profile',18,'delete_jobseekerprofile'),(72,'Can view Job Seeker Profile',18,'view_jobseekerprofile'),(73,'Can add Personalization Settings',19,'add_personalizationsettings'),(74,'Can change Personalization Settings',19,'change_personalizationsettings'),(75,'Can delete Personalization Settings',19,'delete_personalizationsettings'),(76,'Can view Personalization Settings',19,'view_personalizationsettings'),(77,'Can add User Skill',21,'add_userskill'),(78,'Can change User Skill',21,'change_userskill'),(79,'Can delete User Skill',21,'delete_userskill'),(80,'Can view User Skill',21,'view_userskill'),(81,'Can add Work Experience',22,'add_workexperience'),(82,'Can change Work Experience',22,'change_workexperience'),(83,'Can delete Work Experience',22,'delete_workexperience'),(84,'Can view Work Experience',22,'view_workexperience'),(85,'Can add Profile Language',20,'add_profilelanguage'),(86,'Can change Profile Language',20,'change_profilelanguage'),(87,'Can delete Profile Language',20,'delete_profilelanguage'),(88,'Can view Profile Language',20,'view_profilelanguage'),(89,'Can add Job Alert',23,'add_jobalert'),(90,'Can change Job Alert',23,'change_jobalert'),(91,'Can delete Job Alert',23,'delete_jobalert'),(92,'Can view Job Alert',23,'view_jobalert'),(93,'Can add Job Category',24,'add_jobcategory'),(94,'Can change Job Category',24,'change_jobcategory'),(95,'Can delete Job Category',24,'delete_jobcategory'),(96,'Can view Job Category',24,'view_jobcategory'),(97,'Can add Job Invitation',25,'add_jobinvitation'),(98,'Can change Job Invitation',25,'change_jobinvitation'),(99,'Can delete Job Invitation',25,'delete_jobinvitation'),(100,'Can view Job Invitation',25,'view_jobinvitation'),(101,'Can add Saved Filter',28,'add_savedfilter'),(102,'Can change Saved Filter',28,'change_savedfilter'),(103,'Can delete Saved Filter',28,'delete_savedfilter'),(104,'Can view Saved Filter',28,'view_savedfilter'),(105,'Can add Job Post',26,'add_jobpost'),(106,'Can change Job Post',26,'change_jobpost'),(107,'Can delete Job Post',26,'delete_jobpost'),(108,'Can view Job Post',26,'view_jobpost'),(109,'Can add Job Saved',27,'add_jobsaved'),(110,'Can change Job Saved',27,'change_jobsaved'),(111,'Can delete Job Saved',27,'delete_jobsaved'),(112,'Can view Job Saved',27,'view_jobsaved'),(113,'Can add Job Application',29,'add_jobapplication'),(114,'Can change Job Application',29,'change_jobapplication'),(115,'Can delete Job Application',29,'delete_jobapplication'),(116,'Can view Job Application',29,'view_jobapplication'),(117,'Can add Talent Pool Candidate',30,'add_talentpoolcandidate'),(118,'Can change Talent Pool Candidate',30,'change_talentpoolcandidate'),(119,'Can delete Talent Pool Candidate',30,'delete_talentpoolcandidate'),(120,'Can view Talent Pool Candidate',30,'view_talentpoolcandidate'),(121,'Can add Job Boost',31,'add_jobboost'),(122,'Can change Job Boost',31,'change_jobboost'),(123,'Can delete Job Boost',31,'delete_jobboost'),(124,'Can view Job Boost',31,'view_jobboost'),(125,'Can add Payment Transaction',32,'add_paymenttransaction'),(126,'Can change Payment Transaction',32,'change_paymenttransaction'),(127,'Can delete Payment Transaction',32,'delete_paymenttransaction'),(128,'Can view Payment Transaction',32,'view_paymenttransaction'),(129,'Can add Subscription Plan',33,'add_subscriptionplan'),(130,'Can change Subscription Plan',33,'change_subscriptionplan'),(131,'Can delete Subscription Plan',33,'delete_subscriptionplan'),(132,'Can view Subscription Plan',33,'view_subscriptionplan'),(133,'Can add User Subscription',34,'add_usersubscription'),(134,'Can change User Subscription',34,'change_usersubscription'),(135,'Can delete User Subscription',34,'delete_usersubscription'),(136,'Can view User Subscription',34,'view_usersubscription'),(137,'Can add search log',35,'add_searchlog'),(138,'Can change search log',35,'change_searchlog'),(139,'Can delete search log',35,'delete_searchlog'),(140,'Can view search log',35,'view_searchlog'),(141,'Can add CV Rating',36,'add_cvrating'),(142,'Can change CV Rating',36,'change_cvrating'),(143,'Can delete CV Rating',36,'delete_cvrating'),(144,'Can view CV Rating',36,'view_cvrating'),(145,'Can add Resume Record',37,'add_resumerecord'),(146,'Can change Resume Record',37,'change_resumerecord'),(147,'Can delete Resume Record',37,'delete_resumerecord'),(148,'Can view Resume Record',37,'view_resumerecord'),(149,'Can add Notification',38,'add_notification'),(150,'Can change Notification',38,'change_notification'),(151,'Can delete Notification',38,'delete_notification'),(152,'Can view Notification',38,'view_notification'),(153,'Can add Push Subscription',39,'add_pushsubscription'),(154,'Can change Push Subscription',39,'change_pushsubscription'),(155,'Can delete Push Subscription',39,'delete_pushsubscription'),(156,'Can view Push Subscription',39,'view_pushsubscription'),(157,'Can add Conversation',41,'add_conversation'),(158,'Can change Conversation',41,'change_conversation'),(159,'Can delete Conversation',41,'delete_conversation'),(160,'Can view Conversation',41,'view_conversation'),(161,'Can add Chat Message',40,'add_chatmessage'),(162,'Can change Chat Message',40,'change_chatmessage'),(163,'Can delete Chat Message',40,'delete_chatmessage'),(164,'Can view Chat Message',40,'view_chatmessage'),(165,'Can add Video Item',42,'add_videoitem'),(166,'Can change Video Item',42,'change_videoitem'),(167,'Can delete Video Item',42,'delete_videoitem'),(168,'Can view Video Item',42,'view_videoitem'),(169,'Can add Certification Test',43,'add_certificationtest'),(170,'Can change Certification Test',43,'change_certificationtest'),(171,'Can delete Certification Test',43,'delete_certificationtest'),(172,'Can view Certification Test',43,'view_certificationtest'),(173,'Can add Daily Challenge',44,'add_dailychallenge'),(174,'Can change Daily Challenge',44,'change_dailychallenge'),(175,'Can delete Daily Challenge',44,'delete_dailychallenge'),(176,'Can view Daily Challenge',44,'view_dailychallenge'),(177,'Can add Skill Taxonomy',45,'add_skilltaxonomy'),(178,'Can change Skill Taxonomy',45,'change_skilltaxonomy'),(179,'Can delete Skill Taxonomy',45,'delete_skilltaxonomy'),(180,'Can view Skill Taxonomy',45,'view_skilltaxonomy'),(181,'Can add analytics event',46,'add_analyticsevent'),(182,'Can change analytics event',46,'change_analyticsevent'),(183,'Can delete analytics event',46,'delete_analyticsevent'),(184,'Can view analytics event',46,'view_analyticsevent'),(185,'Can add audit log',47,'add_auditlog'),(186,'Can change audit log',47,'change_auditlog'),(187,'Can delete audit log',47,'delete_auditlog'),(188,'Can view audit log',47,'view_auditlog'),(189,'Can add media asset',48,'add_mediaasset'),(190,'Can change media asset',48,'change_mediaasset'),(191,'Can delete media asset',48,'delete_mediaasset'),(192,'Can view media asset',48,'view_mediaasset'),(193,'Can add KYC Verification',49,'add_kycverification'),(194,'Can change KYC Verification',49,'change_kycverification'),(195,'Can delete KYC Verification',49,'delete_kycverification'),(196,'Can view KYC Verification',49,'view_kycverification'),(197,'Can add Community Post',51,'add_communitypost'),(198,'Can change Community Post',51,'change_communitypost'),(199,'Can delete Community Post',51,'delete_communitypost'),(200,'Can view Community Post',51,'view_communitypost'),(201,'Can add Company Review',52,'add_companyreview'),(202,'Can change Company Review',52,'change_companyreview'),(203,'Can delete Company Review',52,'delete_companyreview'),(204,'Can view Company Review',52,'view_companyreview'),(205,'Can add Community Comment',50,'add_communitycomment'),(206,'Can change Community Comment',50,'change_communitycomment'),(207,'Can delete Community Comment',50,'delete_communitycomment'),(208,'Can view Community Comment',50,'view_communitycomment'); /*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_refresh_token` -- DROP TABLE IF EXISTS `auth_refresh_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_refresh_token` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `token_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jti` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `device_info` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` char(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expires_at` datetime(6) NOT NULL, `revoked_at` datetime(6) DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `token_hash` (`token_hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_refresh_token` -- LOCK TABLES `auth_refresh_token` WRITE; /*!40000 ALTER TABLE `auth_refresh_token` DISABLE KEYS */; INSERT INTO `auth_refresh_token` VALUES ('03007c761fae466db7d31b6ce0b4f48e','d9fa71a05aab47ac9d956a79bdc90f4d','39aaaf8f-7680-4481-96e3-b0ce3683eb97-77c623cc-11a1-4370-b5ee-107e6e945da6','03e5d3229fea43b3a372ba926cb5260f','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:52.065000',NULL,'2026-10-13 12:53:52.065000'),('035f77490a7048d688a019b001bfd55d','d9fa71a05aab47ac9d956a79bdc90f4d','a9931d6a-be2c-49bd-94ef-4bd615860912-c058259f-7c1c-4528-993b-3f1851a2ff84','f8c51375a44d474b87b292026d0f2fe8','Python-urllib/3.14','127.0.0.1','2026-11-14 06:27:24.520410',NULL,'2026-10-15 06:27:24.520481'),('056d2b457d6544979605625e7c9f5627','35c704c173a04457b1e62d6368a79569','3c3e4e2c-595b-49a1-97d4-b3b93589c235-6b5e0c1d-939c-4b63-b058-f251a267b093','58755ea958cd4bbe963bb50b85166aa1','Python-urllib/3.14','127.0.0.1','2026-11-14 03:49:23.584947',NULL,'2026-10-15 03:49:23.585015'),('06157b796ec843048eefb36ee43595a7','d9fa71a05aab47ac9d956a79bdc90f4d','e5b257a7-67ce-4adf-af01-ec412fbfa3f0-ef37d8f2-0138-48f0-81fe-c147f70f9807','403ac74b9bbd4cda998822e0b29d5897','Python-urllib/3.14','127.0.0.1','2026-11-13 11:26:12.925000',NULL,'2026-10-14 11:26:12.925000'),('0783ed7879a9439e877d9841796bef43','d9fa71a05aab47ac9d956a79bdc90f4d','a36bcc07-5423-4e6a-9d75-7acbbc730050-fa097aad-00ea-4696-acc5-c4ba872f0c53','fa66a04f2d094237a1b7af19cd055b4a','Python-urllib/3.14','127.0.0.1','2026-11-13 11:49:09.914000',NULL,'2026-10-14 11:49:09.914000'),('097d79495f994682a28f4c33f7527c91','d9fa71a05aab47ac9d956a79bdc90f4d','74300b58-7fcd-40e8-a132-a6ae617dd294-fea8b243-104f-4eda-85fd-6c54baeed1a6','a1159ca321af47f08c3de184f15ad1f5','Python-urllib/3.14','127.0.0.1','2026-11-13 11:52:30.663000',NULL,'2026-10-14 11:52:30.663000'),('098a0327aa674ab1a534a47c3ac4c764','35c704c173a04457b1e62d6368a79569','0ef47fd2-4758-485f-a720-a10feaf2e6bd-ff146fbe-bd11-4e93-8024-be0791a143f5','1d10ac70bfd64fdfb1a64ea2deaade24','Python-urllib/3.14','127.0.0.1','2026-11-13 11:20:40.437000',NULL,'2026-10-14 11:20:40.438000'),('0be881764c3340aeb07bd4bab961dcf9','35c704c173a04457b1e62d6368a79569','98aa526b-20a0-4519-9f5f-fd5348708489-6b853f7e-1db9-45c3-993b-3d17f57c7f89','137e84f23a0e4ec3848178b30e1566c6','Python-urllib/3.14','127.0.0.1','2026-11-13 12:40:18.377000',NULL,'2026-10-14 12:40:18.377000'),('123495f881c84cff80ae685b66c640b3','d9fa71a05aab47ac9d956a79bdc90f4d','fe0bdcfc-9d14-40c3-a077-7fab70b1f4b0-2b031313-8efa-42e4-b419-6410f6320747','6c238f3f79c0442c9cfbbfa586173257','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:09.156000',NULL,'2026-10-14 10:06:09.156000'),('14c6f498556e45849161d4fccfbc9afb','dbc5a67d9af544438150e9d730482ae0','50df2a68-bebd-4966-add4-41dc07853cc6-c4c4c090-dff0-422f-bb9a-08172c1420d7','5979229938b04326947d7eefbb9a3cbe','Python-urllib/3.14','127.0.0.1','2026-11-14 06:25:24.604516',NULL,'2026-10-15 06:25:24.604587'),('17a60c7949cd424fb8c1f63da9f75edd','dbc5a67d9af544438150e9d730482ae0','d1e2a748-1b1f-4e01-873a-7b3b60b1f480-aea61175-8e4b-4ee0-a551-e5d5c8f4947f','dfa4281a1d8445eb8b89b0fb15027cd7','Python-urllib/3.14','127.0.0.1','2026-11-14 06:10:36.263423',NULL,'2026-10-15 06:10:36.263499'),('1a7df040c3e8466aab8a331ddcd70225','d9fa71a05aab47ac9d956a79bdc90f4d','4ffcd9e4-000d-4ca1-b993-96ea70de1195-f80f5f78-ccbb-498a-b1dc-b94b70fee120','08c5c1c42bab463ca9a4abfa9ecea7ef','Python-urllib/3.14','127.0.0.1','2026-11-14 06:07:51.762024',NULL,'2026-10-15 06:07:51.762095'),('1ef1239eb2364de0a8eb6cebabbea0ac','35c704c173a04457b1e62d6368a79569','9b7d03b0-7e85-459a-8650-e24e654e659a-c83fecb8-451f-45e4-b16b-f3db20466076','14278af553c0471eb72e5c461094f6f6','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36','127.0.0.1','2026-11-11 16:22:35.757000',NULL,'2026-10-12 16:22:35.757000'),('1f7a9466711f4154aaa4e29b2f84cc99','2960573f1b77468da693689cb777dcb3','8aff689c-e7a7-42c2-bfa5-2a3cfe9e5c89-cb9239a5-f43b-4963-be8b-c742c7e13125','0097c41512ab457d8e1ed07d4b86db16','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:56.812000',NULL,'2026-10-13 12:53:56.812000'),('1fbc8d9abb6c418a84fcea402192e80b','35c704c173a04457b1e62d6368a79569','b10db55f-b2c2-4063-b5a4-2e153e862ffb-6d24b101-5a31-4278-8c63-a3c09bf372da','0459a120074747e5a263960c9f94be66','Python-urllib/3.14','127.0.0.1','2026-11-14 06:27:05.136510',NULL,'2026-10-15 06:27:05.136583'),('28b86d2e005e44748820b0d4c8983900','d9fa71a05aab47ac9d956a79bdc90f4d','7cc70c1a-43a1-4db6-a26a-843b0993cdd2-a795f3d7-f88f-4d2c-8bce-16adf782ac54','68629c580ad94638ac45bfabf668b6a2','Python-urllib/3.14','127.0.0.1','2026-11-13 12:59:37.230000',NULL,'2026-10-14 12:59:37.230000'),('2ad8fc4cf5414372bc9f92ad5565f0e6','d9fa71a05aab47ac9d956a79bdc90f4d','cf792197-4fe6-41da-9b88-e5df9de92b96-39efb837-8e8e-4bfa-a52f-b964aa02abab','b0fa5b7b150d4612981a8d0ce2a8aaef','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:53.614000',NULL,'2026-10-13 12:53:53.614000'),('2ef7ba291cb14a14adcb635f8d8da71c','35c704c173a04457b1e62d6368a79569','3eb72565-78a4-4816-b296-13d18cd724f7-ec732e16-9f5b-458b-a201-cdbd424dee73','4378df79edd7430d8cc374fcebe91e6a','Python-urllib/3.14','127.0.0.1','2026-11-13 11:51:33.780000',NULL,'2026-10-14 11:51:33.780000'),('321ca175767a406ab95e8319f832d741','35c704c173a04457b1e62d6368a79569','d2a6bc1b-e9c9-4019-b4d0-0e801d3276b2-671ee0c5-b601-4aab-8e15-148cf9028547','31e74b13a4ff4841981db152c78f541f','Python-urllib/3.14','127.0.0.1','2026-11-14 03:49:01.488774',NULL,'2026-10-15 03:49:01.488909'),('321e4b4c5a394c0a96fe8b72c87d9124','d9fa71a05aab47ac9d956a79bdc90f4d','7e8ec42e-2bcc-4c7a-9ea9-9fed5026ae68-4be2204d-d3bf-4b62-877b-6ec9498f85ca','71312094097c46bba9ad26f1b11d9054','Python-urllib/3.14','127.0.0.1','2026-11-14 06:28:43.809341',NULL,'2026-10-15 06:28:43.809407'),('369e03abea274d609c5a2c8b327719a9','35c704c173a04457b1e62d6368a79569','a30eacd6-d3da-4641-82ed-33afc98505ad-ba9fb9f0-56fa-424f-a5c0-8ca983d4d2ab','897e12f6153a4de693d1bc3fbfb38273','Python-urllib/3.14','127.0.0.1','2026-11-13 12:55:21.497000',NULL,'2026-10-14 12:55:21.498000'),('3a171fae6b674be5b6df713550530bd1','35c704c173a04457b1e62d6368a79569','a627f345-3257-43c9-b171-ef44614279d9-ec555b83-60fd-4277-b5c8-cbea07d510d1','4aeef741aefc49c299172a3e9abbb20e','Python-urllib/3.14','127.0.0.1','2026-11-13 10:07:00.774000',NULL,'2026-10-14 10:07:00.774000'),('3bb3bf2063e749918611066cd2d61b42','dbc5a67d9af544438150e9d730482ae0','ae46dec4-a0fc-4b87-8389-7746b7077249-3d48e258-0639-4ccc-b053-1beb71024f13','1679fde7fef54956ad95683603f437dd','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:55.960000',NULL,'2026-10-13 12:53:55.960000'),('3c2d6bdc2e824df2a46c87c264eae067','35c704c173a04457b1e62d6368a79569','b399581b-35ed-4a07-b1ab-4dae3686261b-c0d89962-d654-4e86-a7b6-c4836552c142','35297496e7f143b79c3a491930e8f9ad','Python-urllib/3.14','127.0.0.1','2026-11-14 06:20:58.270029',NULL,'2026-10-15 06:20:58.270106'),('3d6bb3fa54e1480d9257e30d96d914bd','dbc5a67d9af544438150e9d730482ae0','42c0db5e-9669-4bae-b790-9a4a6472fd61-c1e106b0-b0d2-4648-9835-6b8814bf856c','e6b59cecdf3b4eb088458b006e3d659e','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:54.398000',NULL,'2026-10-13 12:53:54.399000'),('4148ad8fc10e48e5af34298c44e29b78','35c704c173a04457b1e62d6368a79569','b4475e48-e33d-49de-a9b4-568d8ed2ee9b-5912b890-4a98-4f08-84c1-a5e3ec1031f6','01192b56ada54f79927eec42a9fc3002','Python-urllib/3.14','127.0.0.1','2026-11-14 03:58:59.316890',NULL,'2026-10-15 03:58:59.317017'),('41734e3aabab4174be86519cb41de972','35c704c173a04457b1e62d6368a79569','eb8618b5-2e8f-4b7c-b627-81bf95b0891b-162ab493-6d42-4ed9-bf90-fc42d7f16206','7e9f850b1ce74e1a821e52d3c5e6f477','Python-urllib/3.14','127.0.0.1','2026-11-13 11:27:33.506000',NULL,'2026-10-14 11:27:33.507000'),('4c5c2c755e354980a12858d4c57dcbe1','dbc5a67d9af544438150e9d730482ae0','f505cd30-3eae-4939-b8a2-96fb70112363-a40a1963-4969-4490-8cac-fe17d0ab3736','f66de9a2ccf242cc926209d564cb0484','Python-urllib/3.14','127.0.0.1','2026-11-13 12:59:52.547000',NULL,'2026-10-14 12:59:52.547000'),('4f1a85c673b0407ab66ed8c9bfd38ede','35c704c173a04457b1e62d6368a79569','6834b1a8-9817-48ee-8c2a-457dffce8970-1d1be78c-2612-4b6e-b71f-cf06aaa24919','b1abe2d24914423a99ff89825579444d','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:49.715000',NULL,'2026-10-13 12:53:49.716000'),('4f491b3487914a48ac1f6c08ae7a9658','2960573f1b77468da693689cb777dcb3','4dc211c8-9e57-4c2e-a159-fcb2884256bf-5e72a1d4-f12e-47e2-82b9-a8b7eefdde09','b30e3c959f01419eb817a4104762c4e4','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.0.0 Safari/537.36','127.0.0.1','2026-11-12 12:56:06.873000',NULL,'2026-10-13 12:56:06.873000'),('50d1e4acac5d430e8eb388cdce1f9321','35c704c173a04457b1e62d6368a79569','609a4f9c-8ea4-4339-a366-75dc3f52bb43-bed61742-feea-4cfd-80b3-e21ab613595d','e13c016dfd4947a1b24d92fd7f02282a','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.9549','127.0.0.1','2026-11-11 16:15:14.141000',NULL,'2026-10-12 16:15:14.141000'),('51af24aa16c2459399c6cc68d3235cad','dbc5a67d9af544438150e9d730482ae0','558a8504-a497-4a9e-9c87-1b72c906b8b0-fe6a8a07-30db-43af-8634-d7419369f677','6dd52565a7ce4cc2a4b650faa49577de','Python-urllib/3.14','127.0.0.1','2026-11-14 06:27:39.624318',NULL,'2026-10-15 06:27:39.624429'),('52f2c8d1db3548aa8bcb93a714c7a7ec','dbc5a67d9af544438150e9d730482ae0','39d71c4f-b799-4017-b6b4-c347da1ed879-38189a54-a5a5-44ec-975e-5a74de342b6c','2e3793d1a4794a899359a8cfdc8570e3','Python-urllib/3.14','127.0.0.1','2026-11-14 06:08:06.788141',NULL,'2026-10-15 06:08:06.788207'),('5351debca0784feeab78190060fa5b16','35c704c173a04457b1e62d6368a79569','8b347f9f-6ec5-4955-8092-fe56da402288-8d39f439-ecde-4e12-bc1a-cda2401db0ef','58b9f9ab4dbc48258309c83e3084287a','Python-urllib/3.14','127.0.0.1','2026-11-13 11:52:11.333000',NULL,'2026-10-14 11:52:11.333000'),('55717e0ddf684fe186a9ed9b965d2a9c','dbc5a67d9af544438150e9d730482ae0','2611d6c8-27d8-4baa-beed-e6d73641b588-f26892b1-4786-43c8-b6c0-271ecf9d7d33','5f91970bc9324a3db255719559245cdc','Python-urllib/3.14','127.0.0.1','2026-11-13 10:07:06.467000',NULL,'2026-10-14 10:07:06.467000'),('57e7f61e8d534c9794a7d297baa75f51','dbc5a67d9af544438150e9d730482ae0','7bc4d415-03bb-481c-87a3-2bc42056b8f5-46cb4d1b-5266-4a32-8688-062f9bac95c2','a66ee2d847cb4c1c825b58dfaed570ac','Python-urllib/3.14','127.0.0.1','2026-11-14 06:29:00.961754',NULL,'2026-10-15 06:29:00.961834'),('5abc06d1d09c4f92b4d2aa6cfe83d031','35c704c173a04457b1e62d6368a79569','4f5d9457-6f63-4b15-8eab-2f99df11a5c3-508517d3-ddc5-4408-b31a-a52d05fa19c3','88e68e5c60284aaabc271697053b1eab','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:06.267000',NULL,'2026-10-14 10:06:06.267000'),('5bbdc614c0bc47c48ab4d7afa2b953b7','35c704c173a04457b1e62d6368a79569','814b4cc8-577f-4dcf-bd05-8fa1359e7b34-ff85a2c8-d9cb-4c23-86c9-809a5eb0f8ed','9988d086f28e4fc083cdeadad2a5b79f','Python-urllib/3.14','127.0.0.1','2026-11-13 10:18:49.363000',NULL,'2026-10-14 10:18:49.363000'),('5ca9bef21c874348b43662676d2c66bc','dbc5a67d9af544438150e9d730482ae0','99f3ac6a-5f74-4da9-bff2-721c8a2f500f-501cde95-3939-4710-a221-2e8b5f10dd68','64f1536f27c844bd915563f9265ce58b','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:41.680000',NULL,'2026-10-14 10:06:41.680000'),('611c32df80ae45f7b05855917fec6d56','d9fa71a05aab47ac9d956a79bdc90f4d','0550be33-44ed-42a3-a89c-a846451ce7fd-2b66c5ac-118c-45af-8520-a5c551fc74a6','7ff0531dfebd4ea79bc93b9b64aaa7b2','Python-urllib/3.14','127.0.0.1','2026-11-14 06:10:35.750690',NULL,'2026-10-15 06:10:35.750755'),('616f8cd946724dc494cccc769834e30b','35c704c173a04457b1e62d6368a79569','e1a2ea3f-13ce-4705-859a-90bda79d616a-b9067417-bb2a-41e4-b2d5-3ddea3368701','6f362c90dc2744dc8dc61dc747846fd6','Python-urllib/3.14','127.0.0.1','2026-11-14 06:07:32.375137',NULL,'2026-10-15 06:07:32.375242'),('651a5c6aeae24464a72f92c26caf839a','35c704c173a04457b1e62d6368a79569','ec1856fd-ef21-4dbd-ade5-55de85876269-5c8c1179-f432-4250-8154-fa957d8f0e98','cbf253f016904132b37db8ce6c1023bc','Python-urllib/3.14','127.0.0.1','2026-11-13 08:45:02.230000',NULL,'2026-10-14 08:45:02.230000'),('689d9b97f0c540df8aba7741481af3b8','dbc5a67d9af544438150e9d730482ae0','4d6b7cb3-86f0-4b19-94a8-dc6843150737-49e0caf1-3304-41fd-b27d-22266138afc5','af6f2501e4194aab8a37e439bdc7d670','Python-urllib/3.14','127.0.0.1','2026-11-13 11:49:25.139000',NULL,'2026-10-14 11:49:25.139000'),('6f76a0aa438d40839b21df2f8c114c5a','dbc5a67d9af544438150e9d730482ae0','efad1a66-3e8f-4910-9e18-333529077e86-ebbd8ebd-ff4f-4195-9bb9-7f0bee52bc78','28cdc3249ff44a8a809acc0612663afc','Python-urllib/3.14','127.0.0.1','2026-11-13 16:47:12.149531',NULL,'2026-10-14 16:47:12.149782'),('731bac65b24a4d6a9492cb39a4792bed','dbc5a67d9af544438150e9d730482ae0','7287c12e-0e18-41c6-a7ca-9c8f65ff6736-65ad61e2-e99f-4ca8-a86f-e3b07d4cecfd','6111c12b10a541eab3655ea71cb0bccb','Python-urllib/3.14','127.0.0.1','2026-11-13 11:26:27.791000',NULL,'2026-10-14 11:26:27.791000'),('77861a5405854aa5b75a79a5fa003d39','35c704c173a04457b1e62d6368a79569','5dec8bce-e601-4b14-801b-558841de5900-f64b1ad8-ff2b-4495-aa23-7fa3b7b6a786','fa782685b95848a0be351bb6103cb1fb','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','127.0.0.1','2026-11-13 16:52:30.733385',NULL,'2026-10-14 16:52:30.733566'),('79d86fbc65da410d9854cd12dc941dd5','35c704c173a04457b1e62d6368a79569','5d92e408-791c-4551-ab34-5c1c4538a1b1-f6ba29a2-2042-48ce-9197-70536008dd03','cc6697ef4b0e48dbafc42c98a8821d50','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:36.083000',NULL,'2026-10-14 10:06:36.083000'),('817b099ae5014d8fb1e93600e6546e97','35c704c173a04457b1e62d6368a79569','a65b3902-203b-4348-baa2-fe93cabbe1f3-eb7b9232-2e91-4afa-a4b6-0720a0932af2','ec1ea0c0df9d40aead93204ddc1fb8b9','Python-urllib/3.14','127.0.0.1','2026-11-13 12:59:17.795000',NULL,'2026-10-14 12:59:17.795000'),('874b7f18d7bd4ffd90f6c157fd57b36d','dbc5a67d9af544438150e9d730482ae0','120cb6b1-cd27-497c-94fb-01cfef1fa297-58ef0664-27ec-4ec0-a5b7-5b30ab131384','7f79f74ddacd4ae4b69fa2c0de9ba54b','Python-urllib/3.14','127.0.0.1','2026-11-13 11:52:45.857000',NULL,'2026-10-14 11:52:45.857000'),('8b604dc47455473fa8e3a4f090f3aaef','35c704c173a04457b1e62d6368a79569','f5c52d3e-37b0-4fe0-98be-e62c1be7cf68-d5a97a91-bf4d-4b21-955c-38f208f2df97','cf1f8de42fba4094b79020dc72e7814d','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.9549','127.0.0.1','2026-11-11 16:14:16.686000',NULL,'2026-10-12 16:14:16.686000'),('9205464e77b4495aa2fd5f001f429405','35c704c173a04457b1e62d6368a79569','bc37287c-eecb-495b-9143-d00e8422f454-dccc09a2-5ec8-4426-a433-5b27cdc416d8','2e6b9d1124764613ba6aa3fd9d61e1e8','Python-urllib/3.14','127.0.0.1','2026-11-13 10:01:01.337000',NULL,'2026-10-14 10:01:01.337000'),('9630410952e541179aa9a162c77162c6','d9fa71a05aab47ac9d956a79bdc90f4d','4faff33c-8582-43b7-af24-c0d024ca0b91-2dbc9529-a5e1-4ac7-a7e8-136080a906fd','de8e80aa7a044e5da36b165e3bcfd8dd','Python-urllib/3.14','127.0.0.1','2026-11-13 09:35:30.768000',NULL,'2026-10-14 09:35:30.769000'),('9645acd496464fc3a2367101c6e2d537','dbc5a67d9af544438150e9d730482ae0','dad8cc07-06a3-413f-92f7-614f94e2f86b-2ea17349-6e1f-4716-ac39-1129e9da8d20','1640502681e445e5a4dce9d27a598ab8','Python-urllib/3.14','127.0.0.1','2026-11-13 08:45:03.733000',NULL,'2026-10-14 08:45:03.733000'),('9c9613820bef447da0ef3ed0cfa6da23','d9fa71a05aab47ac9d956a79bdc90f4d','1e4d49d6-63a6-4f9d-a765-655b36fe4fb7-fbb04cf4-d1a4-4a85-bd7b-d8f91e377551','aa0ee75b79574afeaf8cb37ae0d1a83c','Python-urllib/3.14','127.0.0.1','2026-11-14 06:25:07.511551',NULL,'2026-10-15 06:25:07.511626'),('9df5695b3feb4b8382a9a0d0188b7a80','35c704c173a04457b1e62d6368a79569','fb3ee17f-f6b9-487d-9113-5bda578cccb4-d6427ec0-443e-43b7-bc7e-95cb1ebdd2d0','49e1d26bc91d4d49a4246b94211ab12b','Python-urllib/3.14','127.0.0.1','2026-11-13 12:44:56.131000',NULL,'2026-10-14 12:44:56.131000'),('9f240bfa446f408a930f4950b2395457','dbc5a67d9af544438150e9d730482ae0','3f455b37-0348-453f-a561-1615ba2369ce-1ab462f1-608c-4e87-8195-2ed1c43070c2','8f2d714bb3df4a88998cbece636a28ef','Python-urllib/3.14','127.0.0.1','2026-11-13 10:01:35.957000',NULL,'2026-10-14 10:01:35.957000'),('a4f26d43ffba4b5f922a516d63817478','d9fa71a05aab47ac9d956a79bdc90f4d','c16022df-5d0e-476d-9a0e-6dbae9157687-737fb919-06de-47a1-90b6-c9bfb6f2dc14','c3fcf7755d7446f7a64078ed9bae952a','Python-urllib/3.14','127.0.0.1','2026-11-14 03:49:55.337219',NULL,'2026-10-15 03:49:55.337294'),('ae73799cd4ac42f2b0b79dfe7e0e7753','35c704c173a04457b1e62d6368a79569','200cb646-d386-447e-9217-b5c145e39cc7-4cc5ece0-ec0e-47c9-b5ca-db62bd0e3172','ecf677fa8a1443ceba5270157f7fd1c3','Python-urllib/3.14','127.0.0.1','2026-11-14 06:17:58.021330',NULL,'2026-10-15 06:17:58.021414'),('ae81aaf5984f4ac0b3f4fb7035723bef','35c704c173a04457b1e62d6368a79569','33be308c-47ef-460b-a257-aa2b061418e9-e07de597-2033-45cf-8068-cb6ed9604dd9','767a9d7d760645dd8221cbc03771c384','Python-urllib/3.14','127.0.0.1','2026-11-13 09:01:01.534000',NULL,'2026-10-14 09:01:01.534000'),('b0a83116bf43499aa1f188785a0f5e20','dbc5a67d9af544438150e9d730482ae0','81e869cb-c162-4462-bbee-f942d9c25361-5ee27ace-707a-46fd-afa5-927b4d81818d','e007d4d582b245b8b0d94aea00e21680','Python-urllib/3.14','127.0.0.1','2026-11-14 06:21:30.744436',NULL,'2026-10-15 06:21:30.744511'),('b7467c40c73843d094ce38befa789905','35c704c173a04457b1e62d6368a79569','8561407e-4ae5-4683-a7cf-80979b1ce51d-87283b8e-605c-45ba-9796-5beb2a0549e7','f8959593d174491bb4082157c5bd0e04','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:51.222000',NULL,'2026-10-13 12:53:51.222000'),('b7af1dc52fe04603af50ee93b5500983','35c704c173a04457b1e62d6368a79569','0b880396-013f-4072-8e26-e21681cb5664-79015608-3d4a-4b97-9f06-a95c99f0f3b5','eaf3aca3c26446deb70d56233613e1af','Python-urllib/3.14','127.0.0.1','2026-11-14 06:28:11.581916',NULL,'2026-10-15 06:28:11.581981'),('b86c4ba773cd4ae6ae530a1facb631bc','35c704c173a04457b1e62d6368a79569','177ce181-4022-4696-a857-0cb6246c59e8-32f8b258-a7ad-4845-beef-14c96d7c4043','681bf20d4adb476a84a82634e6ed886d','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','127.0.0.1','2026-11-13 10:09:44.946000',NULL,'2026-10-14 10:09:44.947000'),('bb2ee081a8724f5684d05a821439f0cd','35c704c173a04457b1e62d6368a79569','f749d92b-8eb9-4e93-b0a4-92762aab73e5-875d4719-c059-4147-9a73-20403465d836','d94554ee6c6c448c9a4958ee96f04ef5','Python-urllib/3.14','127.0.0.1','2026-11-13 16:46:35.639418',NULL,'2026-10-14 16:46:35.639622'),('c1030fe30e524c4d8b8be3902e75d641','d9fa71a05aab47ac9d956a79bdc90f4d','c593094e-4432-434a-8b5b-c4e75c85498d-fea6ae64-3669-40d5-87ad-bd8a11d895ff','673c28a77ae64796836a9e31d6f2e1c4','Python-urllib/3.14','127.0.0.1','2026-11-13 10:07:03.644000',NULL,'2026-10-14 10:07:03.644000'),('c15f700b238e4f72a536207f67f214c7','35c704c173a04457b1e62d6368a79569','343d63e8-9945-4f7c-af96-55c65206f34a-28eb3053-4900-4f0f-ab2c-1d92a43f33d0','3211022e21334a4187da01cb27933ae5','Python-urllib/3.14','127.0.0.1','2026-11-13 11:48:50.702000',NULL,'2026-10-14 11:48:50.703000'),('c4ff444f4d1340058c66dcfb7f44868f','dbc5a67d9af544438150e9d730482ae0','ced06838-aa58-424c-ac92-fc54a6df7c7a-71436ad3-3b07-4dba-bde3-90a0c9d92df5','3d27506483f8482e97eaf39db9dcf390','Python-urllib/3.14','127.0.0.1','2026-11-14 03:50:10.382783',NULL,'2026-10-15 03:50:10.382847'),('c7d7bcc578934617abbd5ebcbc3b7e27','d9fa71a05aab47ac9d956a79bdc90f4d','a91b3805-2098-4a38-8078-98802a66cc88-1d8f347b-0fd4-486f-9e7e-76531a61a840','fd241ca39c95499b806ed3bddb6ed155','Python-urllib/3.14','127.0.0.1','2026-11-14 06:21:13.648825',NULL,'2026-10-15 06:21:13.648893'),('cf7cce45a485463199057d7d09f020d7','d9fa71a05aab47ac9d956a79bdc90f4d','71211322-144f-4e25-bb0c-8fe6f249f49b-47a3e1ad-6c40-477c-81de-5f22f3f0aee2','1b54b885614e47a5aa95f1817a239110','Python-urllib/3.14','127.0.0.1','2026-11-13 10:01:20.718000',NULL,'2026-10-14 10:01:20.719000'),('d3524a5f969842858f0ec1529abd8798','35c704c173a04457b1e62d6368a79569','13117177-84fe-4448-bbf1-b713ce3669d7-0d1473ba-18e1-4029-a7de-bd9869cd891e','f5732e980713418a88493edcfa747944','Python-urllib/3.14','127.0.0.1','2026-11-14 05:16:22.141475',NULL,'2026-10-15 05:16:22.141633'),('d56a63724ec34ad9be9b8612973b384f','35c704c173a04457b1e62d6368a79569','613feb8d-a89f-40f2-987d-670bb0b0100e-735327cf-2641-4f05-809d-41a304748916','2169880cc41f476c88cf2892440eb374','Python-urllib/3.14','127.0.0.1','2026-11-14 06:24:35.259881',NULL,'2026-10-15 06:24:35.260002'),('d7db3bf06dac4fa1bc05893056f5bbf2','35c704c173a04457b1e62d6368a79569','e75b226e-3a38-4d6a-a3e4-6f6cb1358b66-6e14ca6a-f17d-413b-952a-226f1706756e','020d6ac062ce4f9b9a656c1bb95b8849','Python-urllib/3.14','127.0.0.1','2026-11-13 09:35:11.261000',NULL,'2026-10-14 09:35:11.261000'),('d812cf73b0464cec8bebd7f0e045d4fd','35c704c173a04457b1e62d6368a79569','04d4cc90-1f0c-416e-95bc-37ba7ba51b04-8f3ff4a9-b79e-4b39-a794-eb07de360383','283efd37be8f44ac8f708e1c07ea0621','Python-urllib/3.14','127.0.0.1','2026-11-14 06:19:59.849769',NULL,'2026-10-15 06:19:59.849924'),('d9fffcb4b0524baba185fba38662118d','35c704c173a04457b1e62d6368a79569','e2422bbe-8a18-4ca3-a9bb-e90a16123091-cdf4ec8d-6777-4889-aac8-8f733c085aa2','8cb01a02bcfd4478a419e22afdde5fed','Python-urllib/3.14','127.0.0.1','2026-11-14 04:29:16.439344',NULL,'2026-10-15 04:29:16.439456'),('dc3829331bba4e70ba1e3d7df044e70a','35c704c173a04457b1e62d6368a79569','2fd3327c-66c1-4d7f-aed1-2b03a7ba6fd8-b77802d4-1836-42bf-b3e3-8fcf8eb0a905','60b24d3e54004738afd4c6b47ae1499f','Python-urllib/3.14','127.0.0.1','2026-11-14 06:10:35.229162',NULL,'2026-10-15 06:10:35.229235'),('e3a49a136f884de58047ddd103556ff6','2960573f1b77468da693689cb777dcb3','365bd08f-35be-495e-8c91-ca8ffa56e3ad-3e84d20f-4d84-4cbd-84d0-b77739c5b7ee','16060d1c6f4343deae4b2ff28df618ad','Python-urllib/3.14','127.0.0.1','2026-11-12 12:53:58.348000',NULL,'2026-10-13 12:53:58.348000'),('e583941ef6594af8ad58e5a65c92f1ac','35c704c173a04457b1e62d6368a79569','20d4f2a3-c77a-48e3-b578-ad4cd4e61a79-ab7e1100-86a7-4af5-9c85-7faef9901387','b36aa3e0b3ac4f9e90faca8ac96edee2','Python-urllib/3.14','127.0.0.1','2026-11-13 11:25:53.947000',NULL,'2026-10-14 11:25:53.947000'),('e9925e3ecb7d427c89fd112467a66cd3','d9fa71a05aab47ac9d956a79bdc90f4d','5f1d759c-4dd1-4b5f-986a-24319b9bcaac-eaedda29-d313-4d5a-9df7-054566e054c7','71b316d0cc9c42a1a087438e18fcf3f5','Python-urllib/3.14','127.0.0.1','2026-11-13 16:46:56.054271',NULL,'2026-10-14 16:46:56.054367'),('edb9a34cd2e1490db932ba65cf9feca8','35c704c173a04457b1e62d6368a79569','4d31a5f5-4b68-4761-ad1a-4b4315724e9f-34018863-5dc5-4af8-9287-825eb5f37e55','9f6ec5e368534c0eb76438c8d64af3fb','Python-urllib/3.14','127.0.0.1','2026-11-14 05:16:53.631160',NULL,'2026-10-15 05:16:53.631261'),('ee227848646648ec826e239baf602359','2960573f1b77468da693689cb777dcb3','7cce6f5a-e508-47d9-a814-27668ba82b11-4c616bcb-db98-4c2c-99c3-e1546fb92497','5bcc5f3a07d24b2c815b67b811edef60','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:44.542000',NULL,'2026-10-14 10:06:44.542000'),('ef059cca9eeb4a6b975aa10af8df96db','35c704c173a04457b1e62d6368a79569','6d08ad60-56d5-4e1a-8d97-acb6dcd54e0d-38e2a881-383b-43d2-ae23-b061ddce4ba6','871d127817094c908a556ae84d3de975','Python-urllib/3.14','127.0.0.1','2026-11-14 03:49:35.905105',NULL,'2026-10-15 03:49:35.905176'),('f025c47b2216426d9bacccb6ddc2361f','dbc5a67d9af544438150e9d730482ae0','81d6504c-53ed-4941-ac1d-27c7731ef7a0-814b3c4e-2e33-4673-8e4d-9ea38d3125e5','e7bf6260d35043258998270be5ad2be9','Python-urllib/3.14','127.0.0.1','2026-11-13 09:35:46.026000',NULL,'2026-10-14 09:35:46.026000'),('f33f83aa4124490e96be48c26bd1ad14','dbc5a67d9af544438150e9d730482ae0','53955818-9774-460b-8fab-cce5ba2eb57b-91f8ecf4-8b67-4b1e-9bd0-d61fa482f4b0','3b499beb23754359a921044f5ce6da9d','Python-urllib/3.14','127.0.0.1','2026-11-12 12:49:26.904000',NULL,'2026-10-13 12:49:26.904000'),('f577b51c6cb24c1988328cf9b2eb9876','2960573f1b77468da693689cb777dcb3','a7355316-ae53-4fb8-b864-85ac30519803-c713095f-9f7e-4b61-bc8b-050813924fda','214ab63c7e7b4558b925e5987c21ee12','Python-urllib/3.14','127.0.0.1','2026-11-13 10:07:09.327000',NULL,'2026-10-14 10:07:09.328000'),('f7405ddc4fbc40ea8bf9a767bdd5247d','d9fa71a05aab47ac9d956a79bdc90f4d','dcce0d63-050d-4143-b812-f00cf190b62b-6fd6ca2d-bf34-4708-a21b-3bebdb2c0660','eee8ad3cc7ae4a6dbbb0e0bddb56c4a2','Python-urllib/3.14','127.0.0.1','2026-11-13 10:06:38.867000',NULL,'2026-10-14 10:06:38.867000'),('fa54f768af914120ba1853bddd730d51','35c704c173a04457b1e62d6368a79569','45a8266b-b635-409b-98c5-745f063da544-08cddc40-a0fd-4903-a5ea-2892dde508e9','b784b6da2cd0454ca9d041f528c364b9','Python-urllib/3.14','127.0.0.1','2026-11-13 12:56:06.165000',NULL,'2026-10-14 12:56:06.165000'),('fc652ddd7ceb4cb29999951544fc881d','d9fa71a05aab47ac9d956a79bdc90f4d','8a76f816-98a9-4185-8431-9f2f007ac118-d781813e-17c8-4cae-b0ac-81ee6e00c631','70d680aef86c44de8fea71095a334716','Python-urllib/3.14','127.0.0.1','2026-11-13 08:45:03.044000',NULL,'2026-10-14 08:45:03.045000'); /*!40000 ALTER TABLE `auth_refresh_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_tenant` -- DROP TABLE IF EXISTS `auth_tenant`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_tenant` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_tenant` -- LOCK TABLES `auth_tenant` WRITE; /*!40000 ALTER TABLE `auth_tenant` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_tenant` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user` -- DROP TABLE IF EXISTS `auth_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user` ( `id` int NOT NULL AUTO_INCREMENT, `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user` -- LOCK TABLES `auth_user` WRITE; /*!40000 ALTER TABLE `auth_user` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_account` -- DROP TABLE IF EXISTS `auth_user_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_account` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_normalized` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_normalized` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_verified` tinyint(1) NOT NULL, `password_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified` tinyint(1) NOT NULL, `email_verified_at` datetime(6) DEFAULT NULL, `full_name` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `language_pref` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `timezone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `mfa_enabled` tinyint(1) NOT NULL, `mfa_secret` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `linkedin_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oauth_provider` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oauth_provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `failed_login_count` int NOT NULL, `locked_until` datetime(6) DEFAULT NULL, `last_login_at` datetime(6) DEFAULT NULL, `last_login_ip` char(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password_changed_at` datetime(6) DEFAULT NULL, `fraud_score` int NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `deleted_at` datetime(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_account` -- LOCK TABLES `auth_user_account` WRITE; /*!40000 ALTER TABLE `auth_user_account` DISABLE KEYS */; INSERT INTO `auth_user_account` VALUES ('2960573f1b77468da693689cb777dcb3','00000000000000000000000000000001','owner.admin@ejobs360.com','owner.admin@ejobs360.com','owner.admin',NULL,NULL,0,'pbkdf2_sha256$1500000$HThPABvRToLK58GNCJOu4U$bkpdXsQTnubT1T6G8ymLKLj5rzuxG5scUlC2KtPIts0=','ADMIN','ACTIVE',1,NULL,'Owner Admin',NULL,'en','UTC',0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'2026-10-13 12:49:50.129000','2026-10-13 12:49:50.129000',NULL),('35c704c173a04457b1e62d6368a79569','745d3ae6499440c68d5ee06ef8f6f5ea','seeker@ejobs360.com','seeker@ejobs360.com','seeker',NULL,NULL,0,'pbkdf2_sha256$1500000$kP3OMMJhXQbn5mYLJpUWHN$caHItgVmJmcnr9W8Bp74WuYw2CPsFmTBh1YyAnOzqtk=','JOB_SEEKER','ACTIVE',1,NULL,'Rahim Ahmed',NULL,'en','UTC',0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'2026-10-12 15:59:14.943000','2026-10-12 15:59:14.943000',NULL),('d9fa71a05aab47ac9d956a79bdc90f4d','441cf683b5f846819c8e4f84c3914300','employer@techcorp.com','employer@techcorp.com','employer',NULL,NULL,0,'pbkdf2_sha256$1500000$qCwuJJm5bTXsxNMSxEkU7M$RFymWE73s6Ewg4/Ko03CLrY2EuokZ+pGmyCo0hg0oF8=','EMPLOYER','ACTIVE',1,NULL,'Sarah Jenkins',NULL,'en','UTC',0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'2026-10-12 15:59:35.393000','2026-10-12 15:59:35.394000',NULL),('dbc5a67d9af544438150e9d730482ae0','092681f259c14685be68a826a76915fc','admin@ejobs360.com','admin@ejobs360.com','admin',NULL,NULL,0,'pbkdf2_sha256$1500000$E9rn85NuJQyWgBUf4lnqpA$EzPR3caYpIZME2ERPA/xLH2j3wv92NTt70HmRDasDbo=','ADMIN','ACTIVE',1,NULL,'System Administrator',NULL,'en','UTC',0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,0,'2026-10-12 15:59:54.450000','2026-10-12 15:59:54.451000',NULL); /*!40000 ALTER TABLE `auth_user_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_groups` -- DROP TABLE IF EXISTS `auth_user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_groups` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `group_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`), KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`), CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_groups` -- LOCK TABLES `auth_user_groups` WRITE; /*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_user_permissions` -- DROP TABLE IF EXISTS `auth_user_user_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_user_permissions` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`), KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_user_permissions` -- LOCK TABLES `auth_user_user_permissions` WRITE; /*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_conversation` -- DROP TABLE IF EXISTS `chat_conversation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_conversation` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `participant_one` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `participant_two` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `last_message` longtext COLLATE utf8mb4_unicode_ci, `last_message_at` datetime(6) NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_conversation` -- LOCK TABLES `chat_conversation` WRITE; /*!40000 ALTER TABLE `chat_conversation` DISABLE KEYS */; /*!40000 ALTER TABLE `chat_conversation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_message` -- DROP TABLE IF EXISTS `chat_message`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_message` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `sender_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_read` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `conversation_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `chat_message_conversation_id_a1207bf4_fk_chat_conversation_id` (`conversation_id`), CONSTRAINT `chat_message_conversation_id_a1207bf4_fk_chat_conversation_id` FOREIGN KEY (`conversation_id`) REFERENCES `chat_conversation` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_message` -- LOCK TABLES `chat_message` WRITE; /*!40000 ALTER TABLE `chat_message` DISABLE KEYS */; /*!40000 ALTER TABLE `chat_message` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `community_comment` -- DROP TABLE IF EXISTS `community_comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `community_comment` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `author_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `author_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, `post_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `community_comment_post_id_12b521a8_fk_community_post_id` (`post_id`), CONSTRAINT `community_comment_post_id_12b521a8_fk_community_post_id` FOREIGN KEY (`post_id`) REFERENCES `community_post` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `community_comment` -- LOCK TABLES `community_comment` WRITE; /*!40000 ALTER TABLE `community_comment` DISABLE KEYS */; /*!40000 ALTER TABLE `community_comment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `community_company_review` -- DROP TABLE IF EXISTS `community_company_review`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `community_company_review` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `author_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `rating` decimal(2,1) NOT NULL, `review_title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `review_text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `pros` longtext COLLATE utf8mb4_unicode_ci, `cons` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `community_company_review` -- LOCK TABLES `community_company_review` WRITE; /*!40000 ALTER TABLE `community_company_review` DISABLE KEYS */; /*!40000 ALTER TABLE `community_company_review` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `community_post` -- DROP TABLE IF EXISTS `community_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `community_post` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `author_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `author_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `channel` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `likes_count` int NOT NULL, `comments_count` int NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `community_post` -- LOCK TABLES `community_post` WRITE; /*!40000 ALTER TABLE `community_post` DISABLE KEYS */; /*!40000 ALTER TABLE `community_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_admin_log` -- DROP TABLE IF EXISTS `django_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_admin_log` ( `id` int NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext COLLATE utf8mb4_unicode_ci, `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `action_flag` smallint unsigned NOT NULL, `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `content_type_id` int DEFAULT NULL, `user_id` int NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`), KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`), CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_admin_log` -- LOCK TABLES `django_admin_log` WRITE; /*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */; /*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_content_type` -- DROP TABLE IF EXISTS `django_content_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_content_type` ( `id` int NOT NULL AUTO_INCREMENT, `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_content_type` -- LOCK TABLES `django_content_type` WRITE; /*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */; INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(47,'admin_app','auditlog'),(46,'analytics_app','analyticsevent'),(29,'application_app','jobapplication'),(30,'application_app','talentpoolcandidate'),(43,'assessment_app','certificationtest'),(44,'assessment_app','dailychallenge'),(45,'assessment_app','skilltaxonomy'),(2,'auth','group'),(3,'auth','permission'),(4,'auth','user'),(7,'auth_app','emailverificationtoken'),(8,'auth_app','loginhistory'),(9,'auth_app','refreshtoken'),(10,'auth_app','tenant'),(11,'auth_app','useraccount'),(40,'chat_app','chatmessage'),(41,'chat_app','conversation'),(50,'community_app','communitycomment'),(51,'community_app','communitypost'),(52,'community_app','companyreview'),(5,'contenttypes','contenttype'),(23,'job_app','jobalert'),(24,'job_app','jobcategory'),(25,'job_app','jobinvitation'),(26,'job_app','jobpost'),(27,'job_app','jobsaved'),(28,'job_app','savedfilter'),(49,'kyc_app','kycverification'),(48,'media_app','mediaasset'),(38,'notification_app','notification'),(39,'notification_app','pushsubscription'),(31,'payment_app','jobboost'),(32,'payment_app','paymenttransaction'),(33,'payment_app','subscriptionplan'),(34,'payment_app','usersubscription'),(36,'resume_app','cvrating'),(37,'resume_app','resumerecord'),(35,'search_app','searchlog'),(6,'sessions','session'),(12,'user_app','activitylog'),(13,'user_app','careerboard'),(14,'user_app','careerboarditem'),(15,'user_app','company'),(16,'user_app','education'),(17,'user_app','employerprofile'),(18,'user_app','jobseekerprofile'),(19,'user_app','personalizationsettings'),(20,'user_app','profilelanguage'),(21,'user_app','userskill'),(22,'user_app','workexperience'),(42,'video_app','videoitem'); /*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_migrations` -- DROP TABLE IF EXISTS `django_migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_migrations` ( `id` bigint NOT NULL AUTO_INCREMENT, `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_migrations` -- LOCK TABLES `django_migrations` WRITE; /*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */; INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2026-10-14 16:44:15.790404'),(2,'auth','0001_initial','2026-10-14 16:44:16.799190'),(3,'admin','0001_initial','2026-10-14 16:44:16.989213'),(4,'admin','0002_logentry_remove_auto_add','2026-10-14 16:44:17.001789'),(5,'admin','0003_logentry_add_action_flag_choices','2026-10-14 16:44:17.011686'),(6,'admin_app','0001_initial','2026-10-14 16:44:17.038100'),(7,'analytics_app','0001_initial','2026-10-14 16:44:17.064001'),(8,'application_app','0001_initial','2026-10-14 16:44:17.113454'),(9,'assessment_app','0001_initial','2026-10-14 16:44:17.226540'),(10,'contenttypes','0002_remove_content_type_name','2026-10-14 16:44:17.392085'),(11,'auth','0002_alter_permission_name_max_length','2026-10-14 16:44:17.491432'),(12,'auth','0003_alter_user_email_max_length','2026-10-14 16:44:17.518483'),(13,'auth','0004_alter_user_username_opts','2026-10-14 16:44:17.528811'),(14,'auth','0005_alter_user_last_login_null','2026-10-14 16:44:17.607482'),(15,'auth','0006_require_contenttypes_0002','2026-10-14 16:44:17.610967'),(16,'auth','0007_alter_validators_add_error_messages','2026-10-14 16:44:17.621277'),(17,'auth','0008_alter_user_username_max_length','2026-10-14 16:44:17.746137'),(18,'auth','0009_alter_user_last_name_max_length','2026-10-14 16:44:17.840137'),(19,'auth','0010_alter_group_name_max_length','2026-10-14 16:44:17.862110'),(20,'auth','0011_update_proxy_permissions','2026-10-14 16:44:17.874299'),(21,'auth','0012_alter_user_first_name_max_length','2026-10-14 16:44:17.974543'),(22,'auth_app','0001_initial','2026-10-14 16:44:18.148318'),(23,'chat_app','0001_initial','2026-10-14 16:44:18.296013'),(24,'community_app','0001_initial','2026-10-14 16:44:18.449310'),(25,'job_app','0001_initial','2026-10-14 16:44:18.687300'),(26,'job_app','0002_jobsaved','2026-10-14 16:44:18.745072'),(27,'kyc_app','0001_initial','2026-10-14 16:44:18.789182'),(28,'media_app','0001_initial','2026-10-14 16:44:18.815278'),(29,'notification_app','0001_initial','2026-10-14 16:44:18.863978'),(30,'payment_app','0001_initial','2026-10-14 16:44:19.071898'),(31,'resume_app','0001_initial','2026-10-14 16:44:19.123859'),(32,'search_app','0001_initial','2026-10-14 16:44:19.149637'),(33,'sessions','0001_initial','2026-10-14 16:44:19.196302'),(34,'user_app','0001_initial','2026-10-14 16:44:19.586484'),(35,'user_app','0002_profilelanguage_jobseekerprofile_alternate_email_and_more','2026-10-14 16:44:21.797030'),(36,'video_app','0001_initial','2026-10-14 16:44:21.839986'); /*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_session` -- DROP TABLE IF EXISTS `django_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_session` ( `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_session` -- LOCK TABLES `django_session` WRITE; /*!40000 ALTER TABLE `django_session` DISABLE KEYS */; /*!40000 ALTER TABLE `django_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_job_alert` -- DROP TABLE IF EXISTS `job_job_alert`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_job_alert` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `frequency` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_job_alert` -- LOCK TABLES `job_job_alert` WRITE; /*!40000 ALTER TABLE `job_job_alert` DISABLE KEYS */; /*!40000 ALTER TABLE `job_job_alert` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_job_category` -- DROP TABLE IF EXISTS `job_job_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_job_category` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `job_count` int NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `slug` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_job_category` -- LOCK TABLES `job_job_category` WRITE; /*!40000 ALTER TABLE `job_job_category` DISABLE KEYS */; /*!40000 ALTER TABLE `job_job_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_job_invitation` -- DROP TABLE IF EXISTS `job_job_invitation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_job_invitation` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `candidate_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `invited_by_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_job_invitation` -- LOCK TABLES `job_job_invitation` WRITE; /*!40000 ALTER TABLE `job_job_invitation` DISABLE KEYS */; /*!40000 ALTER TABLE `job_job_invitation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_job_post` -- DROP TABLE IF EXISTS `job_job_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_job_post` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_name` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `posted_by_user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL, `title_normalized` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `requirements` longtext COLLATE utf8mb4_unicode_ci, `benefits` longtext COLLATE utf8mb4_unicode_ci, `employment_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `experience_level` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `education_req` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `work_mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `hybrid_days_week` smallint DEFAULT NULL, `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(9,6) DEFAULT NULL, `longitude` decimal(9,6) DEFAULT NULL, `salary_min` decimal(15,2) DEFAULT NULL, `salary_max` decimal(15,2) DEFAULT NULL, `salary_currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `salary_frequency` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `salary_visible` tinyint(1) NOT NULL, `vacancies` smallint NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `moderation_status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `moderation_score` decimal(4,3) DEFAULT NULL, `fraud_score` smallint NOT NULL, `application_deadline` datetime(6) DEFAULT NULL, `published_at` datetime(6) DEFAULT NULL, `expires_at` datetime(6) DEFAULT NULL, `is_featured` tinyint(1) NOT NULL, `featured_until` datetime(6) DEFAULT NULL, `view_count` int NOT NULL, `apply_count` int NOT NULL, `save_count` int NOT NULL, `visa_sponsorship` tinyint(1) NOT NULL, `external_apply_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_deleted` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `job_category_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `job_job_post_job_category_id_79427695_fk_job_job_category_id` (`job_category_id`), CONSTRAINT `job_job_post_job_category_id_79427695_fk_job_job_category_id` FOREIGN KEY (`job_category_id`) REFERENCES `job_job_category` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_job_post` -- LOCK TABLES `job_job_post` WRITE; /*!40000 ALTER TABLE `job_job_post` DISABLE KEYS */; INSERT INTO `job_job_post` VALUES ('a9c5f76f9b144cdab158d332f3864f42','25151e26bcbd4e089d757af3396207f9','756420a10053441893619014f1648927',NULL,'d9fa71a05aab47ac9d956a79bdc90f4d','Lead Python Django Developer',NULL,NULL,'Looking for an expert Python/Django developer to build scalable monolith services.',NULL,NULL,'FULL_TIME','MID_LEVEL',NULL,'HYBRID',NULL,'Dhaka',NULL,NULL,NULL,150000.00,250000.00,'USD','MONTHLY',1,1,'PUBLISHED','PENDING',NULL,0,NULL,NULL,NULL,0,NULL,0,0,0,0,NULL,0,'2026-10-12 15:59:53.504000','2026-10-12 15:59:53.505000',NULL); /*!40000 ALTER TABLE `job_job_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_job_saved` -- DROP TABLE IF EXISTS `job_job_saved`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_job_saved` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_post_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `job_job_saved_user_id_job_post_id_dde181bd_uniq` (`user_id`,`job_post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_job_saved` -- LOCK TABLES `job_job_saved` WRITE; /*!40000 ALTER TABLE `job_job_saved` DISABLE KEYS */; /*!40000 ALTER TABLE `job_job_saved` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_saved_filter` -- DROP TABLE IF EXISTS `job_saved_filter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_saved_filter` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `criteria` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_saved_filter` -- LOCK TABLES `job_saved_filter` WRITE; /*!40000 ALTER TABLE `job_saved_filter` DISABLE KEYS */; /*!40000 ALTER TABLE `job_saved_filter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kyc_verification` -- DROP TABLE IF EXISTS `kyc_verification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `kyc_verification` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `document_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `document_number` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `document_url` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `reviewed_at` datetime(6) DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kyc_verification` -- LOCK TABLES `kyc_verification` WRITE; /*!40000 ALTER TABLE `kyc_verification` DISABLE KEYS */; /*!40000 ALTER TABLE `kyc_verification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media_asset` -- DROP TABLE IF EXISTS `media_asset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `media_asset` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_url` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media_asset` -- LOCK TABLES `media_asset` WRITE; /*!40000 ALTER TABLE `media_asset` DISABLE KEYS */; /*!40000 ALTER TABLE `media_asset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification_notification` -- DROP TABLE IF EXISTS `notification_notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notification_notification` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `data` json NOT NULL, `is_read` tinyint(1) NOT NULL, `read_at` datetime(6) DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification_notification` -- LOCK TABLES `notification_notification` WRITE; /*!40000 ALTER TABLE `notification_notification` DISABLE KEYS */; /*!40000 ALTER TABLE `notification_notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification_push_subscription` -- DROP TABLE IF EXISTS `notification_push_subscription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notification_push_subscription` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `endpoint` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `p256dh` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `auth` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification_push_subscription` -- LOCK TABLES `notification_push_subscription` WRITE; /*!40000 ALTER TABLE `notification_push_subscription` DISABLE KEYS */; /*!40000 ALTER TABLE `notification_push_subscription` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_job_boost` -- DROP TABLE IF EXISTS `payment_job_boost`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_job_boost` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `boost_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `start_time` datetime(6) NOT NULL, `end_time` datetime(6) NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_job_boost` -- LOCK TABLES `payment_job_boost` WRITE; /*!40000 ALTER TABLE `payment_job_boost` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_job_boost` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_subscription_plan` -- DROP TABLE IF EXISTS `payment_subscription_plan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_subscription_plan` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `price` decimal(12,2) NOT NULL, `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `billing_cycle` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `features` json NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_subscription_plan` -- LOCK TABLES `payment_subscription_plan` WRITE; /*!40000 ALTER TABLE `payment_subscription_plan` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_subscription_plan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_transaction` -- DROP TABLE IF EXISTS `payment_transaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_transaction` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(12,2) NOT NULL, `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `gateway` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `gateway_transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_transaction` -- LOCK TABLES `payment_transaction` WRITE; /*!40000 ALTER TABLE `payment_transaction` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_transaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_user_subscription` -- DROP TABLE IF EXISTS `payment_user_subscription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_user_subscription` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `current_period_start` datetime(6) NOT NULL, `current_period_end` datetime(6) NOT NULL, `cancel_at_period_end` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `plan_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `payment_user_subscri_plan_id_b7816311_fk_payment_s` (`plan_id`), CONSTRAINT `payment_user_subscri_plan_id_b7816311_fk_payment_s` FOREIGN KEY (`plan_id`) REFERENCES `payment_subscription_plan` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_user_subscription` -- LOCK TABLES `payment_user_subscription` WRITE; /*!40000 ALTER TABLE `payment_user_subscription` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_user_subscription` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `resume_cv_rating` -- DROP TABLE IF EXISTS `resume_cv_rating`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `resume_cv_rating` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `resume_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_score` int NOT NULL, `strengths` json NOT NULL, `improvements` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `resume_cv_rating` -- LOCK TABLES `resume_cv_rating` WRITE; /*!40000 ALTER TABLE `resume_cv_rating` DISABLE KEYS */; /*!40000 ALTER TABLE `resume_cv_rating` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `resume_record` -- DROP TABLE IF EXISTS `resume_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `resume_record` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_url` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `file_size` bigint NOT NULL, `content_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `is_primary` tinyint(1) NOT NULL, `parsed_text` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `resume_record` -- LOCK TABLES `resume_record` WRITE; /*!40000 ALTER TABLE `resume_record` DISABLE KEYS */; INSERT INTO `resume_record` VALUES ('1da357e83c454cff854420c07c78b619','35c704c173a04457b1e62d6368a79569','SOP-INF-042_Tahoma_Font_Installation.pdf','http://localhost:9001/jp-media/resumes/35c704c1-73a0-4457-b1e6-2d6368a79569/0d06820b-2087-44e0-b981-0970241165c7_SOP-INF-042_Tahoma_Font_Installation.pdf',4694,'application/pdf',0,NULL,'2026-10-14 12:06:43.045000'),('31e5293e172447c4a8305a24cea8f405','35c704c173a04457b1e62d6368a79569','trade_rpt_dfd.pdf','http://localhost:9001/jp-media/resumes/35c704c1-73a0-4457-b1e6-2d6368a79569/5d71742d-165d-4f30-84b6-0f667df3898e_trade_rpt_dfd.pdf',985208,'application/pdf',1,NULL,'2026-10-14 16:54:12.430136'),('b133436d09f8420f8bbd0a31f4a27a29','35c704c173a04457b1e62d6368a79569','Generated-Profile-CV-Classic.pdf','http://localhost:9001/jp-media/resumes/35c704c1-73a0-4457-b1e6-2d6368a79569/generated_313cd508_cv-classic.pdf',2261,'application/pdf',0,NULL,'2026-10-14 12:56:12.420000'); /*!40000 ALTER TABLE `resume_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `search_log` -- DROP TABLE IF EXISTS `search_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `search_log` ( `id` bigint NOT NULL AUTO_INCREMENT, `query` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `search_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `results_count` int NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `search_log` -- LOCK TABLES `search_log` WRITE; /*!40000 ALTER TABLE `search_log` DISABLE KEYS */; /*!40000 ALTER TABLE `search_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_activity_log` -- DROP TABLE IF EXISTS `user_activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_activity_log` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `action` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `details` json NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_activity_log` -- LOCK TABLES `user_activity_log` WRITE; /*!40000 ALTER TABLE `user_activity_log` DISABLE KEYS */; /*!40000 ALTER TABLE `user_activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_career_board` -- DROP TABLE IF EXISTS `user_career_board`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_career_board` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_career_board` -- LOCK TABLES `user_career_board` WRITE; /*!40000 ALTER TABLE `user_career_board` DISABLE KEYS */; /*!40000 ALTER TABLE `user_career_board` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_career_board_item` -- DROP TABLE IF EXISTS `user_career_board_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_career_board_item` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `board_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_career_board_item` -- LOCK TABLES `user_career_board_item` WRITE; /*!40000 ALTER TABLE `user_career_board_item` DISABLE KEYS */; /*!40000 ALTER TABLE `user_career_board_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_company` -- DROP TABLE IF EXISTS `user_company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_company` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tagline` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `industry` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_size` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `website_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `logo_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_image_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hq_city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hq_country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_verified` tinyint(1) NOT NULL, `follower_count` int NOT NULL, `active_jobs_count` int NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), KEY `user_company_slug_e68d22e2` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_company` -- LOCK TABLES `user_company` WRITE; /*!40000 ALTER TABLE `user_company` DISABLE KEYS */; INSERT INTO `user_company` VALUES ('756420a10053441893619014f1648927','dff2332f638f4c4da24807d856ac93b0','TechCorp Global Ltd',NULL,NULL,'Leading technology consulting and product development firm.','Information Technology',NULL,'https://techcorp.example.com',NULL,NULL,'Dhaka','Bangladesh',0,0,0,'2026-10-12 15:59:35.403000','2026-10-12 15:59:35.403000'); /*!40000 ALTER TABLE `user_company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_education` -- DROP TABLE IF EXISTS `user_education`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_education` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `institution` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `degree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `field_of_study` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `is_current` tinyint(1) NOT NULL, `grade` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_education` -- LOCK TABLES `user_education` WRITE; /*!40000 ALTER TABLE `user_education` DISABLE KEYS */; /*!40000 ALTER TABLE `user_education` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_employer_profile` -- DROP TABLE IF EXISTS `user_employer_profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_employer_profile` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_id` char(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `designation` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `department` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_admin` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_employer_profile` -- LOCK TABLES `user_employer_profile` WRITE; /*!40000 ALTER TABLE `user_employer_profile` DISABLE KEYS */; INSERT INTO `user_employer_profile` VALUES ('015c4620b6854f2eb7e563c045eabe22','d9fa71a05aab47ac9d956a79bdc90f4d','756420a10053441893619014f1648927','Head of Talent Acquisition',NULL,0,'2026-10-12 15:59:35.410000','2026-10-12 15:59:35.410000'); /*!40000 ALTER TABLE `user_employer_profile` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_job_seeker_profile` -- DROP TABLE IF EXISTS `user_job_seeker_profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_job_seeker_profile` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `tenant_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `headline` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `summary` longtext COLLATE utf8mb4_unicode_ci, `availability_status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `availability_date` date DEFAULT NULL, `visibility` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(9,6) DEFAULT NULL, `longitude` decimal(9,6) DEFAULT NULL, `salary_expectation_min` decimal(15,2) DEFAULT NULL, `salary_expectation_max` decimal(15,2) DEFAULT NULL, `salary_currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `open_to_remote` tinyint(1) NOT NULL, `open_to_relocation` tinyint(1) NOT NULL, `years_experience` smallint NOT NULL, `highest_degree` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profile_completion_pct` smallint NOT NULL, `cv_score` smallint DEFAULT NULL, `total_applications` int NOT NULL, `total_interviews` int NOT NULL, `profile_views` int NOT NULL, `career_goal` longtext COLLATE utf8mb4_unicode_ci, `notice_period_days` smallint DEFAULT NULL, `current_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `current_company` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `website_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `linkedin_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `github_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `portfolio_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `alternate_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `blood_group` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `disability_description` longtext COLLATE utf8mb4_unicode_ci, `district` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emergency_contact_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emergency_contact_phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `father_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `has_disability` tinyint(1) NOT NULL, `height_meters` decimal(5,2) DEFAULT NULL, `immediate_availability` tinyint(1) NOT NULL, `marital_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `national_id_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationality` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `passport_issue_date` date DEFAULT NULL, `passport_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secondary_mobile` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `street_address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_cv_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `weight_kg` decimal(5,2) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_job_seeker_profile` -- LOCK TABLES `user_job_seeker_profile` WRITE; /*!40000 ALTER TABLE `user_job_seeker_profile` DISABLE KEYS */; INSERT INTO `user_job_seeker_profile` VALUES ('0d14fa51d702478c87b6fdf42db0464a','35c704c173a04457b1e62d6368a79569','c3821b1195e445bf861673990f4807a6','Lead Full Stack Architect & Tech Lead','Senior Engineer with 8+ years experience architecting scalable distributed systems.','ACTIVELY_LOOKING',NULL,'PUBLIC','Dhaka','BD',NULL,NULL,150000.00,180000.00,'BDT',1,0,9,NULL,60,NULL,0,0,0,NULL,30,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-10-12 15:59:34.410000','2026-10-15 06:28:15.869904',NULL,'Mirpur','O+','1994-06-12',NULL,'Dhaka',NULL,NULL,'Mustafa Mojid','Male',0,1.70,0,'Married','Razia Sultana','9876543210123','Bangladeshi',NULL,NULL,'1216','Islam',NULL,'Road 11, Banani',NULL,64.00); /*!40000 ALTER TABLE `user_job_seeker_profile` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_personalization_settings` -- DROP TABLE IF EXISTS `user_personalization_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_personalization_settings` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `job_alerts_enabled` tinyint(1) NOT NULL, `preferred_locations` json NOT NULL, `preferred_roles` json NOT NULL, `min_salary` decimal(15,2) DEFAULT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_personalization_settings` -- LOCK TABLES `user_personalization_settings` WRITE; /*!40000 ALTER TABLE `user_personalization_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `user_personalization_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_profile_language` -- DROP TABLE IF EXISTS `user_profile_language`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_profile_language` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `language_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `proficiency` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_profile_language` -- LOCK TABLES `user_profile_language` WRITE; /*!40000 ALTER TABLE `user_profile_language` DISABLE KEYS */; INSERT INTO `user_profile_language` VALUES ('cbb1e5fa108144f48ce9036ec922ee78','35c704c173a04457b1e62d6368a79569','English','FLUENT','2026-10-14 11:20:46.629000'); /*!40000 ALTER TABLE `user_profile_language` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_user_skill` -- DROP TABLE IF EXISTS `user_user_skill`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_user_skill` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `skill_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `proficiency_level` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `years_experience` smallint NOT NULL, `is_top_skill` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_user_skill` -- LOCK TABLES `user_user_skill` WRITE; /*!40000 ALTER TABLE `user_user_skill` DISABLE KEYS */; /*!40000 ALTER TABLE `user_user_skill` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_work_experience` -- DROP TABLE IF EXISTS `user_work_experience`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_work_experience` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_remote` tinyint(1) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `is_current` tinyint(1) NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_work_experience` -- LOCK TABLES `user_work_experience` WRITE; /*!40000 ALTER TABLE `user_work_experience` DISABLE KEYS */; /*!40000 ALTER TABLE `user_work_experience` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `video_item` -- DROP TABLE IF EXISTS `video_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video_item` ( `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `video_url` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `thumbnail_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `duration_seconds` int NOT NULL, `transcript` longtext COLLATE utf8mb4_unicode_ci, `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `views_count` int NOT NULL, `created_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video_item` -- LOCK TABLES `video_item` WRITE; /*!40000 ALTER TABLE `video_item` DISABLE KEYS */; /*!40000 ALTER TABLE `video_item` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-10-15 12:55:44