-- 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` (`id`, `name`, `content_type_id`, `codename`) 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` (`id`, `user_id`, `token_hash`, `jti`, `device_info`, `ip_address`, `expires_at`, `revoked_at`, `created_at`) 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` (`id`, `tenant_id`, `email`, `email_normalized`, `username`, `phone`, `phone_normalized`, `phone_verified`, `password_hash`, `user_type`, `status`, `email_verified`, `email_verified_at`, `full_name`, `avatar_url`, `language_pref`, `timezone`, `mfa_enabled`, `mfa_secret`, `google_id`, `facebook_id`, `linkedin_id`, `oauth_provider`, `oauth_provider_id`, `failed_login_count`, `locked_until`, `last_login_at`, `last_login_ip`, `password_changed_at`, `fraud_score`, `created_at`, `updated_at`, `deleted_at`) 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` (`id`, `app_label`, `model`) 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` (`id`, `app`, `name`, `applied`) 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` (`id`, `tenant_id`, `company_id`, `company_name`, `posted_by_user_id`, `title`, `title_normalized`, `slug`, `description`, `requirements`, `benefits`, `employment_type`, `experience_level`, `education_req`, `work_mode`, `hybrid_days_week`, `city`, `country_code`, `latitude`, `longitude`, `salary_min`, `salary_max`, `salary_currency`, `salary_frequency`, `salary_visible`, `vacancies`, `status`, `moderation_status`, `moderation_score`, `fraud_score`, `application_deadline`, `published_at`, `expires_at`, `is_featured`, `featured_until`, `view_count`, `apply_count`, `save_count`, `visa_sponsorship`, `external_apply_url`, `is_deleted`, `created_at`, `updated_at`, `job_category_id`) VALUES ('ba390454afa04ba0bd991aafb955f755','df44fcb1d3d049c6a0164736b6e63049','756420a10053441893619014f1648927','TechCorp Global Ltd','d9fa71a05aab47ac9d956a79bdc90f4d','Lead Python Django Developer',NULL,NULL,'We are seeking an experienced Lead Python Django Developer to join our core engineering team in Dhaka. You will design and scale robust backend services, optimize database architecture, and lead technical architecture decisions.',NULL,NULL,'FULL_TIME','MID_LEVEL',NULL,'REMOTE',NULL,'Dhaka','BD',NULL,NULL,140000.00,200000.00,'BDT','MONTHLY',1,1,'ACTIVE','APPROVED',NULL,0,NULL,NULL,NULL,0,NULL,0,0,0,0,NULL,0,'2026-10-15 07:10:28.001143','2026-10-15 07:10:28.001462',NULL),('e546eb412fb64e72b3f512f2696344c6','fe228ae351ee443dae173e49ecd4af77','756420a10053441893619014f1648927','TechCorp Global Ltd','d9fa71a05aab47ac9d956a79bdc90f4d','Senior Full Stack React & Node Engineer',NULL,NULL,'Looking for a talented Senior Full Stack Engineer proficient with React, Next.js, and Node.js to build high-performance, modern recruitment and career tools.',NULL,NULL,'FULL_TIME','MID_LEVEL',NULL,'HYBRID',NULL,'Dhaka','BD',NULL,NULL,100000.00,150000.00,'BDT','MONTHLY',1,1,'ACTIVE','APPROVED',NULL,0,NULL,NULL,NULL,0,NULL,0,0,0,0,NULL,0,'2026-10-15 07:10:28.008728','2026-10-15 07:10:28.008932',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` (`id`, `user_id`, `file_name`, `file_url`, `file_size`, `content_type`, `is_primary`, `parsed_text`, `created_at`) 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` (`id`, `tenant_id`, `name`, `slug`, `tagline`, `description`, `industry`, `company_size`, `website_url`, `logo_url`, `cover_image_url`, `hq_city`, `hq_country`, `is_verified`, `follower_count`, `active_jobs_count`, `created_at`, `updated_at`) VALUES ('756420a10053441893619014f1648927','dff2332f638f4c4da24807d856ac93b0','TechCorp Global Ltd','techcorp-global',NULL,'Leading global enterprise technology and cloud solutions provider specializing in recruitment and AI platforms.','Information Technology & Services','201-500','https://techcorp.example.com',NULL,NULL,'Dhaka','BD',0,0,0,'2026-10-12 15:59:35.403000','2026-10-15 07:09:50.624355'); /*!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 */; INSERT INTO `user_education` (`id`, `user_id`, `institution`, `degree`, `field_of_study`, `start_date`, `end_date`, `is_current`, `grade`, `created_at`) VALUES ('290b0d56fcef4665b8cb67778756efad','35c704c173a04457b1e62d6368a79569','University of Dhaka','B.Sc. in Computer Science & Engineering','Computer Science','2011-01-01','2015-05-30',0,'3.85 / 4.00','2026-10-15 07:09:50.586346'),('e8a28d708e9b4b94b967824fe0b33fc6','35c704c173a04457b1e62d6368a79569','Dhaka College','Higher Secondary Certificate (HSC)','Science','2009-06-01','2011-05-30',0,'GPA 5.00 / 5.00','2026-10-15 07:09:50.588751'); /*!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` (`id`, `user_id`, `company_id`, `designation`, `department`, `is_admin`, `created_at`, `updated_at`) 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` (`id`, `user_id`, `tenant_id`, `headline`, `summary`, `availability_status`, `availability_date`, `visibility`, `city`, `country_code`, `latitude`, `longitude`, `salary_expectation_min`, `salary_expectation_max`, `salary_currency`, `open_to_remote`, `open_to_relocation`, `years_experience`, `highest_degree`, `profile_completion_pct`, `cv_score`, `total_applications`, `total_interviews`, `profile_views`, `career_goal`, `notice_period_days`, `current_title`, `current_company`, `website_url`, `linkedin_url`, `github_url`, `portfolio_url`, `avatar_url`, `created_at`, `updated_at`, `alternate_email`, `area`, `blood_group`, `date_of_birth`, `disability_description`, `district`, `emergency_contact_name`, `emergency_contact_phone`, `father_name`, `gender`, `has_disability`, `height_meters`, `immediate_availability`, `marital_status`, `mother_name`, `national_id_number`, `nationality`, `passport_issue_date`, `passport_number`, `postal_code`, `religion`, `secondary_mobile`, `street_address`, `video_cv_url`, `weight_kg`) VALUES ('0d14fa51d702478c87b6fdf42db0464a','35c704c173a04457b1e62d6368a79569','c3821b1195e445bf861673990f4807a6','Lead Full Stack Architect & Tech Lead','High-performing Lead Software Engineer with 9+ years of experience designing scalable distributed web architectures, high-throughput microservices, and AI-enabled enterprise solutions. Expert in Python, Django, React, TypeScript, and MySQL.','ACTIVELY_LOOKING',NULL,'PUBLIC','Dhaka','BD',NULL,NULL,120000.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 07:09:50.562271',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` (`id`, `user_id`, `language_name`, `proficiency`, `created_at`) VALUES ('3b40f3fae0954377abc8864c9a986bc6','35c704c173a04457b1e62d6368a79569','English','FLUENT','2026-10-15 07:09:50.617822'),('c323ed10e7504058ac9efea167eed61f','35c704c173a04457b1e62d6368a79569','Bengali','NATIVE','2026-10-15 07:09:50.620442'); /*!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 */; INSERT INTO `user_user_skill` (`id`, `user_id`, `skill_name`, `proficiency_level`, `years_experience`, `is_top_skill`, `created_at`) VALUES ('3568bbffd8c2470390b5cb3463d95bf8','35c704c173a04457b1e62d6368a79569','Python','EXPERT',9,0,'2026-10-15 07:09:50.592915'),('3a44effede074ea7a4d19c50eab60bce','35c704c173a04457b1e62d6368a79569','MySQL','EXPERT',8,0,'2026-10-15 07:09:50.603627'),('48eb09d3aa0b46ebbc6233c340677f8c','35c704c173a04457b1e62d6368a79569','REST APIs','EXPERT',9,0,'2026-10-15 07:09:50.606172'),('8cf2eaaf18f04f35995bdf70129fba1c','35c704c173a04457b1e62d6368a79569','React','ADVANCED',6,0,'2026-10-15 07:09:50.598323'),('8dc02154b64f4b6e81e4b0494677e0a1','35c704c173a04457b1e62d6368a79569','Docker','ADVANCED',5,0,'2026-10-15 07:09:50.609291'),('b7a4365008584fa39f8760a2dc391855','35c704c173a04457b1e62d6368a79569','Django','EXPERT',8,0,'2026-10-15 07:09:50.595566'),('ca1e39f9a02f45e5b6d258bd01db0cce','35c704c173a04457b1e62d6368a79569','System Design','EXPERT',7,0,'2026-10-15 07:09:50.611890'),('d6a56ba0828c4711b77f6a934e210d5d','35c704c173a04457b1e62d6368a79569','TypeScript','ADVANCED',5,0,'2026-10-15 07:09:50.601427'); /*!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 */; INSERT INTO `user_work_experience` (`id`, `user_id`, `company_name`, `title`, `location`, `is_remote`, `start_date`, `end_date`, `is_current`, `description`, `created_at`) VALUES ('96fb06743a2544d7976a831492eaaf80','35c704c173a04457b1e62d6368a79569','CodeWave Software','Software Engineer','Dhaka, Bangladesh',0,'2015-06-01','2017-12-31',0,'Developed responsive frontend user interfaces in React and robust backend services in Django.','2026-10-15 07:09:50.580732'),('c9ce3d6ae53f401482ef799ff8ac0b2e','35c704c173a04457b1e62d6368a79569','NextGen Innovations','Senior Backend Engineer','Dhaka, Bangladesh',0,'2018-01-15','2021-02-28',0,'Designed and maintained core RESTful APIs using Python, Django, and MySQL. Mentored 6 junior engineers and implemented automated CI/CD pipelines.','2026-10-15 07:09:50.578149'),('fa0c91fc8677494180851ba63d476d99','35c704c173a04457b1e62d6368a79569','TechCorp Global Ltd','Lead Full Stack Architect','Dhaka, Bangladesh',0,'2021-03-01',NULL,1,'Architected and delivered distributed enterprise recruiting applications handling 100k+ monthly active users. Reduced database query latency by 45% using MySQL index optimization and Redis caching.','2026-10-15 07:09:50.575221'); /*!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 13:10:47