references.txt

url paths

include($_SERVER["DOCUMENT_ROOT"] . "/");



'CREATE TABLE `hiring_admins` (
  `id` varchar(256) NOT NULL,
  `name` char(64) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `number` varchar(10) DEFAULT NULL,
  `password` varchar(256) DEFAULT NULL,
  `last_updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `company_name` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  UNIQUE KEY `number_UNIQUE` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci'



'CREATE TABLE `job_seekers` (
  `id` varchar(256) NOT NULL,
  `name` char(64) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `number` varchar(10) DEFAULT NULL,
  `password` varchar(256) DEFAULT NULL,
  `last_updated_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  UNIQUE KEY `number_UNIQUE` (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci'



'CREATE TABLE `jobs` (
  `job_id` varchar(256) NOT NULL,
  `position_name` text,
  `company_name` text,
  `place` text,
  `number_of_positions` int DEFAULT NULL,
  `job_level` varchar(45) DEFAULT NULL,
  `skills_required` text,
  `responsibilities` text,
  `eligibilities` text,
  `number_of_applicants` int DEFAULT ''0'',
  `benefits` text,
  `package` int DEFAULT NULL,
  `monthly_pay` int DEFAULT NULL,
  `admin_Id` varchar(256) DEFAULT NULL,
  `time_range` varchar(45) DEFAULT NULL,
  `posting_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `last_date_to_apply` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `is_active` int DEFAULT ''1'',
  PRIMARY KEY (`job_id`),
  UNIQUE KEY `job_id_UNIQUE` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci'


localhost "" "" 3307 job_engagement_platform_database