-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------



-- Dumping database structure for worker_management_app
CREATE DATABASE IF NOT EXISTS `worker_management_app` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;
USE `worker_management_app`;

-- Dumping structure for table worker_management_app.tasks
CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_name` varchar(255) NOT NULL,
  `assigned_to` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `priority` enum('Low','Medium','High') NOT NULL,
  `due_date` date NOT NULL,
  `status` enum('New','In Progress','Completed') DEFAULT 'New',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `assigned_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table worker_management_app.tasks: ~2 rows (approximately)
INSERT INTO `tasks` (`id`, `task_name`, `assigned_to`, `description`, `priority`, `due_date`, `status`, `created_at`, `assigned_by`) VALUES
	(3, 'Adding picturess', 'GariPoker', 'You have to skibidi rizz ohio on em fools', 'High', '2025-01-23', 'New', '2025-01-10 09:14:50', NULL),
	(4, 'Adding pictures', 'Joe', 'DO it', 'High', '2025-01-23', 'New', '2025-01-15 06:47:08', NULL);

