INSERT INTO `employee_timestamp` (`timestampID`, `userID`, `checkIn`, `checkOut`, `status`, `createdAt`, `updatedAt`, `checkin_image`, `checkout_image`) VALUES
(135, 39, '2025-08-09 11:23:51', NULL, 'present', '2025-08-09 18:23:51', '2025-08-09 18:23:51', '[BLOB]', NULL);
INSERT INTO `employee_timestamp` (`timestampID`, `userID`, `checkIn`, `checkOut`, `status`, `createdAt`, `updatedAt`, `checkin_image`, `checkout_image`) VALUES
(136, 54, '2025-08-09 11:53:46', '2025-08-09 11:54:26', 'present', '2025-08-09 18:53:46', '2025-08-09 18:54:26', '[BLOB]', '[BLOB]');

-- --------------------------------------------------------

--
-- Table structure for table `fired_employees`
--

CREATE TABLE IF NOT EXISTS `fired_employees` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userID` varchar(50) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `firing_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `reason` text,
  `years_worked` float DEFAULT NULL,
  `status` enum('fired','active') DEFAULT 'fired',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fired_employees`
--

INSERT INTO `fired_employees` (`id`, `userID`, `department`, `firing_date`, `reason`, `years_worked`, `status`) VALUES
(1, '41', 'Human Resources', '2025-05-20 00:00:00', 'Misconducting to fellow employees ', 0, 'fired'),
(2, '27', 'Engineering', '2025-05-20 00:00:00', 'Always late', 0, 'fired'),
(3, '48', 'Engineering', '2025-06-12 00:00:00', 'Causing the app to unknown error', 0, 'fired');

-- --------------------------------------------------------

--
-- Table structure for table `hr_chat_messages`
--

CREATE TABLE IF NOT EXISTS `hr_chat_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(100) NOT NULL,
  `receiver_id` varchar(100) NOT NULL,
  `message` text,
  `file_path` varchar(255) DEFAULT NULL,
  `message_type` enum('text','image','file') DEFAULT 'text',
  `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  `deleted_for` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `hr_chat_messages`
--

INSERT INTO `hr_chat_messages` (`id`, `sender_id`, `receiver_id`, `message`, `file_path`, `message_type`, `timestamp`, `deleted_for`) VALUES
(1, '40', 'admin', 'Hello waa saacid', NULL, 'text', '2025-07-25 11:45:28', NULL),
(22, '39', 'admin', 'Hello boy', '', 'text', '2025-08-09 11:24:38', NULL),
(12, '40', 'admin', '📎 File', 'uploads/chat_files/6886353edd334_Screenshot_20250710_204255.jpg', 'file', '2025-07-27 07:18:38', NULL),
(6, '40', 'admin', '📎 File', 'uploads/chat_files/68847188ece01_Screenshot_20250720_111935.jpg', 'file', '2025-07-25 23:11:21', NULL),
(7, '40', 'admin', '📎 File', 'uploads/chat_files/688471991da63_Screenshot_20250720_112143.jpg', 'file', '2025-07-25 23:11:37', NULL),
(13, '40', 'admin', 'Dear HR', '', 'text', '2025-07-27 07:50:45', NULL),
(14, '39', 'admin', 'Hello dear HR, the last assigned task was quite frustrating. How do you want me to build a ship? Are you out of your mind? Haha', '', 'text', '2025-07-27 08:19:20', NULL),
(10, '40', 'admin', '📎 File', 'uploads/chat_files/68847362bd433_Screenshot_20250710_112831.jpg', 'file', '2025-07-25 23:19:14', NULL),
(11, '40', 'admin', 'There is no task today?', '', 'text', '2025-07-27 06:58:36', '40'),
(15, 'admin', '39', 'sguwba', NULL, 'text', '2025-07-27 15:37:54', 'admin'),
(16, 'admin', '40', '📎 File', 'uploads/chat_files/68864b2c83597_Screenshot_20250710_204255.jpg', 'file', '2025-07-27 08:52:12', NULL),
(17, 'admin', '40', 'There is nothing wrong about it', '', 'text', '2025-08-08 07:21:30', NULL),
(18, 'admin', '39', 'Hello', '', 'text', '2025-08-09 05:56:00', NULL),
(19, 'admin', '39', '📎 File', 'uploads/chat_files/689745695229c_salary_2025-06.pdf', 'file', '2025-08-09 05:56:09', NULL),
(20, 'admin', '39', '📎 File', 'uploads/chat_files/6897457278579_Screenshot_20250808_071755.jpg', 'file', '2025-08-09 05:56:18', NULL),
(21, '40', 'admin', 'Bishu waa 9, account-kuna waa $0', '', 'text', '2025-08-09 06:09:53', NULL),
(23, '40', 'admin', 'Gjr', '', 'text', '2025-08-09 12:41:28', NULL);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `jobs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `jobTitle` varchar(255) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `description` text,
  `requirements` text,
  `salary` varchar(100) DEFAULT NULL,
  `jobType` varchar(50) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL,
  `experienceLevel` varchar(50) DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `positions` int DEFAULT NULL,
  `skills` text,
  `benefits` text,
  `gender` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `jobs` (`id`, `jobTitle`, `department`, `description`, `requirements`, `salary`, `jobType`, `location`, `experienceLevel`, `deadline`, `positions`, `skills`, `benefits`, `gender`, `created_at`) VALUES
(1, '', 'ICT', 'You are going to swim 100M in 10 seconds, if you can\'t do that please don\'t apply. thanks', 'PhD level of swimmer 🏊‍♂️ ', '300', 'Part-Time', 'Xamar', 'Mid', '2025-06-20', 3, 'Somebody who can swim to save his life', 'You can get money', 'Any', '2025-06-17 14:53:14'),
(2, '', 'Networking', 'A good guy or girl', 'ma aqaan', '500', 'Full-Time', 'Guricel', 'Senior', '2025-06-28', 2, 'Van expert', 'Free money if you show up everyday lol', 'Any', '2025-06-17 15:27:14'),
(3, '', 'Marketing ', 'Develop and execute marketing campaigns\nAnalyze market trends and customer insights\nManage content creation and brand messaging\nCoordinate with sales and product teams\nTrack and re\nport on campaign performance\n', 'Bachelor’s degree in Marketing or related field\n3–5 years of marketing experience\nProficiency in digital marketing tools and analytics\nStrong communication and project management skills\nAbility to work cross-functionally and meet deadlines', '600', 'Contract', 'Suuqa Xoolaha', 'Mid', '2025-08-06', 5, 'Strategic thinking\nData analysis\nContent development\nCampaign management\n\n', 'Health insurance\nPaid time off\nProfessional development\nPerformance bonuses\n', 'Female', '2025-08-02 00:39:36'),
(5, '', 'Company efficiency ', 'Improve operational workflows and processes\nMonitor and analyze performance metrics\nCollaborate with departments to enhance productivity\nImplement efficiency-enhancing tools and systems\nEnsure compliance with company policies and standards\n', 'Bachelor’s degree in Business, Operations, or related field\n2–4 years of experience in process improvement or operations\nStrong analytical and problem-solving skills\nProficiency in workflow and project management tools\nExcellent communication and organizational abilities\n', '400', 'Part-Time', 'Banaadir', 'Senior', '2025-08-23', 3, 'Effective communication\nTime management\nTeam collaboration\nProblem-solving skills\n', 'Health insurance\nRetirement plans\nFlexible working hours\nEmployee training programs\n', 'Female', '2025-08-02 00:50:49'),
(6, '', 'ICT', 'whatever man', 'whatever you know is needed\n', '600', 'Part-Time', 'Xamar', 'Senior', '2025-08-30', 5, 'Urgent', 'Urgent', 'Male', '2025-08-09 16:21:26');

-- --------------------------------------------------------

--
-- Table structure for table `jobtitle`
--

CREATE TABLE IF NOT EXISTS `jobtitle` (
  `jobID` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `departmentID` int DEFAULT NULL,
  PRIMARY KEY (`jobID`),
  KEY `departmentID` (`departmentID`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `jobtitle`
--

INSERT INTO `jobtitle` (`jobID`, `title`, `departmentID`) VALUES
(17, 'HR Manager', 1),
(18, 'Software Engineer', 2),
(19, 'Project Manager', 1),
(21, 'test', 2),
(22, 'Deputy Manager', 9),
(23, 'President', 14),
(24, 'Vice-president', 14),
(25, 'Director of finance', 14),
(27, 'IT Technican', 13),
(36, 'Social Media manager ', 11),
(37, 'Employee', 11),
(38, 'Senior Advisor', 14),
(39, 'Employee', 16),
(40, 'Employee', 17),
(41, 'Employee', 18);

-- --------------------------------------------------------

--
-- Table structure for table `leavetable`
--

CREATE TABLE IF NOT EXISTS `leavetable` (
  `leaveID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `leaveType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `startDate` date NOT NULL,
  `endDate` date DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`leaveID`),
  KEY `userID` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leavetable`
--

INSERT INTO `leavetable` (`leaveID`, `userID`, `leaveType`, `reason`, `startDate`, `endDate`, `status`) VALUES
(58, 40, 'CL', 'I need to reset my mind', '2025-05-22', '2025-05-31', 'Approved'),
(59, 40, 'ML', 'cagsh', '2025-05-27', '2025-08-22', 'Rejected'),
(62, 40, 'SL', 'Got diarrhea ', '2025-08-09', '2025-08-10', 'Pending');

-- --------------------------------------------------------

--
-- Table structure for table `notices`
--

CREATE TABLE IF NOT EXISTS `notices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `department` varchar(100) NOT NULL DEFAULT 'All Employees',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `message`, `created_at`, `department`) VALUES
(13, 'Maanta fasax ayaad tihiin', '2025-08-08 14:35:39', 'All Employees'),
(2, 'Mudanayaal iyo Marwooyin, Shaqaalaha sharafta leh, maadama xalay roobab mahiigaan ah ka da&#039;een magaalada; waxaa la idin ku wargelinayaa in imaatinka shaqadu maanta fasax tahay.\n\nWixii faahfaahin ah waxaad kala xiriiri kartaan agaasimaha waaxda shaqada iyo shaqaalaha, Eng. Hanad. \n\nSalamulah, Nabad ahaada.', '2025-05-15 02:45:40', 'All Employees'),
(3, 'Hello, This is test.', '2025-05-15 03:11:06', 'All Employees'),
(4, 'Happy HR day to you all', '2025-05-15 03:22:50', 'All Employees'),
(12, 'Hello zaki', '2025-06-25 15:29:59', 'Telecommunications '),
(6, 'Hello HR team, enjoy your weekend. we have a lot of work to do on Saturdays, we gonna fire them all ,🤣', '2025-05-15 04:16:18', 'Human Resources'),
(7, 'Hooyo machan, Engineered Dahabo', '2025-05-15 04:23:28', 'Engineering'),
(10, 'Maalin wanaagsan dhamaantiin', '2025-05-21 18:52:43', 'All Employees'),
(11, 'hellooo', '2025-05-24 03:55:54', 'Human Resources');

-- --------------------------------------------------------

--
-- Table structure for table `points`
--

CREATE TABLE IF NOT EXISTS `points` (
  `pointID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `performancePoints` int NOT NULL,
  `seminarPoints` int NOT NULL,
  `attendancePoints` int NOT NULL,
  `totalPoints` int GENERATED ALWAYS AS (((`performancePoints` + `seminarPoints`) + `attendancePoints`)) STORED,
  `deductPoints` int DEFAULT NULL,
  `cashout` int DEFAULT '0',
  PRIMARY KEY (`pointID`),
  KEY `userID` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `points`
--

INSERT INTO `points` (`pointID`, `userID`, `performancePoints`, `seminarPoints`, `attendancePoints`, `deductPoints`, `cashout`) VALUES
(16, 38, 0, 0, 0, 0, 0),
(17, 39, 820, 205, 430, 0, 143),
(18, 40, 100, 120, 140, 0, 33),
(19, 41, 0, 0, 0, 0, 0),
(20, 42, 0, 0, 0, 0, 0),
(21, 43, 80, 70, 60, 0, 0),
(22, 44, 0, 0, 0, 0, 0),
(23, 45, 0, 0, 0, 0, 0),
(24, 46, 0, 0, 0, 0, 0),
(25, 47, 0, 0, 0, 0, 0),
(26, 48, 0, 0, 0, 0, 0),
(27, 49, 0, 0, 0, 0, 0),
(28, 50, 0, 0, 0, 0, 0),
(29, 51, 0, 0, 0, 0, 0),
(30, 52, 0, 0, 0, 0, 0),
(31, 53, 0, 0, 0, 0, 0),
(32, 54, 0, 0, 0, 0, 0),
(33, 55, 0, 0, 0, 0, 0),
(34, 56, 60, 10, 60, 0, 0),
(35, 57, 0, 0, 0, 0, 0),
(36, 58, 0, 0, 0, 0, 0),
(37, 59, 0, 0, 0, 0, 0),
(38, 60, 0, 0, 0, 0, 0),
(39, 61, 0, 0, 0, 0, 0),
(40, 62, 60, 30, 60, 0, 15),
(41, 63, 0, 0, 0, 0, 0),
(42, 64, 20, 20, 60, 0, 0),
(43, 65, 0, 0, 0, 0, 0),
(44, 66, 0, 0, 0, 0, 0),
(45, 67, 0, 0, 0, 0, 0),
(46, 68, 0, 0, 0, 0, 0),
(47, 69, 0, 0, 0, 0, 0),
(48, 70, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `project` (
  `projectID` int NOT NULL AUTO_INCREMENT,
  `projectTitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `teamLeader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `teamMembers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `projectDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `technologies` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`projectID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `project` (`projectID`, `projectTitle`, `teamLeader`, `teamMembers`, `projectDescription`, `startDate`, `endDate`, `createdAt`, `technologies`) VALUES
(15, 'Project Alpha', 'Alice', 'Alice', 'Description of Project Alpha', '2025-01-01', '2025-06-30', '2025-01-27 15:42:56', 'JAVA'),
(16, 'Project Beta', 'Bob', 'Neel', 'Description of Project Beta', '2025-02-01', '2025-07-31', '2025-01-27 15:42:56', 'RUST'),
(17, 'Project Gamma', 'Carol', 'Rudra', 'Description of Project Gamma', '2025-03-01', '2025-08-31', '2025-01-27 15:42:56', 'Flutter'),
(28, 'Smart HR', 'Dan', 'Dan - Bhavya', 'HR Management System ', '2025-03-07', '2025-03-31', '2025-03-07 16:58:17', 'Flutter And PHP'),
(29, 'Baashaal', 'Bhavya', 'Bhavya - Bob - John', 'this is for trining porposes', '2025-04-16', '2025-04-29', '2025-04-13 05:38:52', 'IT'),
(30, 'Environment work', 'Saacid', 'Saacid - John - Rudra - Dk', 'Environmental degradation ', '2025-05-24', '2025-05-30', '2025-05-07 05:35:49', 'Laptop and acced to network'),
(31, 'Welcoming Hanad', 'Hanad', 'saacid - Hanad', 'Finish on time', '2025-05-29', '2025-06-02', '2025-05-15 17:25:20', 'none'),
(32, 'Testing', 'Hanad', 'Abdulahi', 'This project is quite larger than you think', '2025-05-31', '2025-06-10', '2025-05-28 21:04:01', 'None'),
(33, 'hardest security ', 'Abdi', 'Abdi', 'quick', '2025-05-31', '2025-06-19', '2025-05-31 09:12:50', 'none');

-- --------------------------------------------------------

--
-- Table structure for table `salary_record`
--

CREATE TABLE IF NOT EXISTS `salary_record` (
  `recordID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `basic_salary` decimal(10,2) DEFAULT NULL,
  `bonus` decimal(10,2) DEFAULT NULL,
  `deduction` decimal(10,2) DEFAULT NULL,
  `cashout_points` decimal(10,2) DEFAULT NULL,
  `total_salary` decimal(10,2) DEFAULT NULL,
  `record_date` date DEFAULT NULL,
  PRIMARY KEY (`recordID`),
  KEY `fk_userID` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `salary_record`
--

INSERT INTO `salary_record` (`recordID`, `userID`, `basic_salary`, `bonus`, `deduction`, `cashout_points`, `total_salary`, `record_date`) VALUES
(17, 40, 6000.00, 90.00, 0.00, 0.00, 0.00, '2025-05-30'),
(18, 40, 6000.00, 0.00, 0.00, 0.00, 6000.00, '2025-05-30'),
(19, 40, 6000.00, 600.00, 0.00, 0.00, 6600.00, '2025-05-30'),
(20, 40, 6000.00, 630.00, 0.00, 0.00, 6630.00, '2025-05-30'),
(21, 40, 6000.00, 630.00, 50.00, 0.00, 6580.00, '2025-05-30'),
(22, 40, 6000.00, 630.00, 50.00, 0.00, 6580.00, '2025-05-30'),
(23, 40, 6000.00, 0.00, 0.00, 0.00, 6000.00, '2025-04-18'),
(24, 40, 6000.00, 0.00, 50.00, 0.00, 5950.00, '2025-05-30'),
(25, 40, 6000.00, 30.00, 50.00, 0.00, 5980.00, '2025-02-12'),
(26, 40, 6000.00, 50.00, 60.00, 0.00, 5990.00, '2025-01-20'),
(27, 40, 6000.00, 50.00, 60.00, 0.00, 5990.00, '2016-05-30'),
(28, 62, 600.00, 10.00, 0.00, 15.00, 625.00, '2025-05-31'),
(29, 64, 600.00, 50.00, 0.00, 0.00, 650.00, '2025-05-31'),
(31, 40, 6000.00, 80.00, 0.00, 30.00, 6110.00, '2025-06-03'),
(32, 42, 5000.00, 0.00, 0.00, 0.00, 5000.00, '2025-07-13'),
(33, 47, 500.00, 60.00, 0.00, 0.00, 560.00, '2025-08-08');

-- --------------------------------------------------------

--
-- Table structure for table `seminar`
--

CREATE TABLE IF NOT EXISTS `seminar` (
  `seminarID` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`seminarID`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `seminar`
--

INSERT INTO `seminar` (`seminarID`, `title`, `place`, `date`) VALUES
(30, 'Barsho', 'Soobe', '2025-08-15'),
(31, 'Barsho', 'Soobe', '2025-08-15'),
(32, 'Barsho', 'Soobe', '2025-08-15'),
(34, 'Managing time effectively ', 'Baraawo', '2025-08-09'),
(35, 'Managing time effectively ', 'Baraawo', '2025-08-09');

-- --------------------------------------------------------

--
-- Table structure for table `seminar_attendance`
--

CREATE TABLE IF NOT EXISTS `seminar_attendance` (
  `attendanceID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `seminarID` int DEFAULT NULL,
  `attendanceDate` date NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`attendanceID`),
  KEY `userID` (`userID`),
  KEY `seminarID` (`seminarID`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `seminar_attendance`
--

INSERT INTO `seminar_attendance` (`attendanceID`, `userID`, `seminarID`, `attendanceDate`, `status`) VALUES
(80, 2, 10, '2025-02-25', 'attended'),
(81, 17, 12, '2025-03-07', 'attended'),
(82, 17, 13, '2025-03-07', 'attended'),
(83, 3, 14, '2025-03-10', 'attended'),
(84, 2, 15, '2025-03-21', 'attended'),
(85, 3, 15, '2025-03-21', 'attended'),
(86, 40, 33, '2025-08-09', 'attended');

-- --------------------------------------------------------

--
-- Table structure for table `skills`
--

CREATE TABLE IF NOT EXISTS `skills` (
  `skillID` int NOT NULL AUTO_INCREMENT,
  `userID` int DEFAULT NULL,
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `skill` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `startDate` date NOT NULL,
  `endDate` date DEFAULT NULL,
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`skillID`),
  KEY `userID` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` (`skillID`, `userID`, `language`, `skill`, `reference`, `startDate`, `endDate`, `certificate`) VALUES
(1, 2, 'flutter', 'Designing', 'Ref123', '2022-01-01', '2025-01-01', 'Certificate1'),
(2, 3, 'Spanish', 'Management', 'Ref456', '2021-05-15', '2024-05-15', 'Certificate2'),
(3, 4, 'French', 'Design', 'Ref789', '2020-08-30', '2023-08-30', 'Certificate3'),
(18, 2, 'php', 'Programming', 'Ref123', '2022-01-01', '2025-01-01', 'Certificate123'),
(19, 3, 'Spanish', 'Management', 'Ref456', '2021-05-15', '2024-05-15', 'Certificate456'),
(20, 4, 'French', 'Design', 'Ref789', '2020-08-30', '2023-08-30', 'Certificate789'),
(21, 2, 'English, French', 'PHP Development', 'Some reference', '2024-01-01', '2024-12-31', 'Yes'),
(22, 3, 'HTML-CSS', 'Web Design', 'Github', '2025-01-30', '2025-01-31', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxMTEhUTExMVFRUXFxUXFhcXFxUVGBYXFRUWFxUXFRUYHSggGBolHRUVITEhJSkrLi4uFx8zODMtNygtLisBCgoKDg0OGxAQGy0lHyUtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLf/AABEIAuMBnwMBIgACEQEDEQH/xAAcAAACAwEBAQEAAAAAAAA'),
(23, 14, 'Python ', 'AI', 'AI assistance', '2025-02-15', '2025-02-22', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAYGBgYHBgcICAcKCwoLCg8ODAwODxYQERAREBYiFRkVFRkVIh4kHhweJB42KiYmKjY+NDI0PkxERExfWl98fKcBBgYGBgcGBwgIBwoLCgsKDw4MDA4PFhAREBEQFiIVGRUVGRUiHiQeHB4kHjYqJiYqNj40MjQ+TERETF9aX3x8p//CABEIBNkFAAMBIgACEQEDEQH/xAAuAAEBAQEBAQEAAAAAAAA'),
(24, 2, 'english,gujrati, hindi,malyalam,marathi,adivasi,abudi', 'more dansing singing,reading,hapyli stay,paly khokho,enkoring', 'Github', '2025-01-14', '2025-02-20', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAYGBgYHBgcICAcKCwoLCg8ODAwODxYQERAREBYiFRkVFRkVIh4kHhweJB42KiYmKjY+NDI0PkxERExfWl98fKcBBgYGBgcGBwgIBwoLCgsKDw4MDA4PFhAREBEQFiIVGRUVGRUiHiQeHB4kHjYqJiYqNj40MjQ+TERETF9aX3x8p//CABEIA4QGQAMBIgACEQEDEQH/xAAxAAEBAQEBAQEAAAAAAAA'),
(25, 2, 'hdhd', 'jfud', 'AI assistance', '2025-02-24', '2025-02-25', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAYGBgYHBgcICAcKCwoLCg8ODAwODxYQERAREBYiFRkVFRkVIh4kHhweJB42KiYmKjY+NDI0PkxERExfWl98fKcBBgYGBgcGBwgIBwoLCgsKDw4MDA4PFhAREBEQFiIVGRUVGRUiHiQeHB4kHjYqJiYqNj40MjQ+TERETF9aX3x8p//CABEIBQADkgMBIgACEQEDEQH/xAAwAAEAAwEBAQEAAAAAAAA'),
(26, 17, 'Flutter o2', 'new', 'Youtube', '2025-02-28', '2025-02-28', '/9j/4AAQSkZJRgABAQAAAQABAAD/2wDEAAkICBALEBAPDxAXERIRFxgYFBQYGBoWGBcYFhobHBsdHRscGxwaHyAfGhwdHyIiHx0gJiYmICYjIyYqJiolJR4RAAgABwAHAA4ACgAOAAwADQANAAwAEwANAA8ADQATABEAEQAOAA4AEQARABQADwAQAA8AEAAPABQAFgATABIAEwATABIAEwAWABQAEgARAA8AEQASABQAFQATABYAFgATABUAFgA'),
(27, 17, 'HTML-CSS', 'UI design ', 'Youtube', '2025-03-07', '2025-03-31', '/9j/4AAQSkZJRgABAQAAAQABAAD/4gIoSUNDX1BST0ZJTEUAAQEAAAIYAAAAAAIQAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAAHRyWFlaAAABZAA'),
(28, 39, 'somali', 'Hooyonimo', 'Online-template', '2025-05-29', '2025-05-11', 'AAAAIGZ0eXBpc29tAAACAGlzb21pc28yYXZjMW1wNDEAAkJsbW9vdgAAAGxtdmhkAAAAAAAAAAAAAAAAAAAD6AACEBIAAQAAAQAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwABQdx0cmFrAAAAXHRraGQAAAADAAAAAAAAAAAAAAABAAAAAAACEBIAAAA'),
(29, 39, 'Farah', 'Saacid', 'AI assistance', '2025-05-15', '2025-05-23', 'AAAAIGZ0eXBpc29tAAACAGlzb21pc28yYXZjMW1wNDEAAIVQbW9vdgAAAGxtdmhkAAAAAAAAAAAAAAAAAAAD6AAAdUYAAQAAAQAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwAASPx0cmFrAAAAXHRraGQAAAADAAAAAAAAAAAAAAABAAAAAAAAdUYAAAA'),
(30, 40, 'Spanish', 'Multilingual ', 'AI assistance', '2025-05-21', '2025-05-30', '/9j/4QEZRXhpZgAATU0AKgAAAAgABQEAAAMAAAABBDgAAAEBAAMAAAABCIoAAAExAAIAAAAmAAAASodpAAQAAAABAAAAcAESAAMAAAABAAAAAAAAAABBbmRyb2lkIFRQMUEuMjIwNjI0LjAxNC5BNTE1RlhYVThIV0kxAAAEkAMAAgAAABQAAACmkpEAAgAAAAQwODUAkBEAAgAAAAcAAAC6kggABAAAAAEAAAAAAAAAADIwMjU6MDU6MjEgMDc');

-- --------------------------------------------------------

--
-- Table structure for table `task`
--

CREATE TABLE IF NOT EXISTS `task` (
  `taskID` int NOT NULL AUTO_INCREMENT,
  `projectID` int DEFAULT NULL,
  `userID` int DEFAULT NULL,
  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `task` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `deadline` date DEFAULT NULL,
  `date` date NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `completeTime` datetime DEFAULT NULL,
  `startDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `distance` double DEFAULT NULL,
  `submissionFile` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileType` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `completionDocument` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`taskID`),
  KEY `fk_project` (`projectID`),
  KEY `fk_user` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `task`
--

INSERT INTO `task` (`taskID`, `projectID`, `userID`, `module`, `task`, `deadline`, `date`, `status`, `address`, `completeTime`, `startDate`, `distance`, `submissionFile`, `fileType`, `completionDocument`) VALUES
(63, 30, 38, 'Building smart agriculture tools', 'You need to build this project ASAP', '2023-09-24', '2023-09-24', 'pending', '', NULL, '2025-05-07 12:38:28', 0, NULL, NULL, NULL),
(65, 15, 40, 'Completing lettters', 'Preparation of annual letters', '2025-05-30', '2025-05-21', 'completed', '', '2025-08-08 07:41:13', '2025-08-08 07:39:28', 0, '1754663968_salary_2025-06.pdf', 'application/pdf', ''),
(66, 32, 40, 'Tasking', 'The big project', '2025-05-31', '2025-05-28', 'completed', '', '2025-05-30 09:06:38', '2025-05-30 09:05:42', 0, '1748621142_scaled_1000004645.jpg', 'image/jpeg', ''),
(67, 32, 40, 'Coding AI', 'Building an interesting AI, show the completion of the task by uploading a file document', '2025-07-14', '2025-05-30', 'completed', '', '2025-05-30 09:31:28', '2025-05-30 09:30:31', 0, '1748622631_tone.xml', 'application/octet-stream', ''),
(68, 32, 43, 'Asking docs', 'Send a detailed document about your assigned module', '2025-06-18', '2025-05-31', 'pending', '', NULL, '2025-05-31 14:58:52', 0, NULL, NULL, NULL),
(69, 33, 63, 'Harder algorithms', 'Upload the hardest possible algorithms', '2025-06-27', '2025-05-31', 'pending', '', NULL, '2025-05-31 16:13:57', 0, NULL, NULL, NULL),
(70, 33, 62, 'Harder Algorithms', 'upload the hardest possible algorithms', '2025-06-27', '2025-05-31', 'completed', '', '2025-05-31 09:20:03', '2025-05-31 09:19:05', 0, '1748708345_salary_2025-04.pdf', 'application/pdf', ''),
(71, 31, 64, 'Soodhawen', 'sodhawow', '2025-06-19', '2025-05-31', 'pending', '', NULL, '2025-05-31 18:36:49', 0, NULL, NULL, NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `employee`
--
ALTER TABLE `employee`
  ADD CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`),
  ADD CONSTRAINT `employee_ibfk_2` FOREIGN KEY (`deptID`) REFERENCES `dept` (`deptID`);

--
-- Constraints for table `employee_timestamp`
--
ALTER TABLE `employee_timestamp`
  ADD CONSTRAINT `employee_timestamp_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`);

--
-- Constraints for table `jobtitle`
--
ALTER TABLE `jobtitle`
  ADD CONSTRAINT `jobtitle_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `dept` (`deptID`);

--
-- Constraints for table `leavetable`
--
ALTER TABLE `leavetable`
  ADD CONSTRAINT `leavetable_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`);

--
-- Constraints for table `points`
--
ALTER TABLE `points`
  ADD CONSTRAINT `points_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`);

--
-- Constraints for table `salary_record`
--
ALTER TABLE `salary_record`
  ADD CONSTRAINT `fk_userID` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`);

--
-- Constraints for table `task`
--
ALTER TABLE `task`
  ADD CONSTRAINT `fk_project` FOREIGN KEY (`projectID`) REFERENCES `project` (`projectID`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_user` FOREIGN KEY (`userID`) REFERENCES `users_table` (`userID`) ON DELETE CASCADE;
COMMIT;

