-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `taskmanagement`
--

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

--
-- Table structure for table `addprojects`
--

CREATE TABLE `addprojects` (
  `id` int(11) NOT NULL,
  `protitle` varchar(255) NOT NULL,
  `taskdes` text NOT NULL,
  `startdate` varchar(255) NOT NULL,
  `enddate` varchar(255) NOT NULL,
  `projectManager` varchar(255) NOT NULL,
  `taskmem` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp(),
  `project_status` enum('pending','completed') NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `addprojects`
--

INSERT INTO `addprojects` (`id`, `protitle`, `taskdes`, `startdate`, `enddate`, `projectManager`, `taskmem`, `file`, `datetime`, `project_status`) VALUES
(18, 'Ecommerce Stored for shopify', 'need to connect with shopify and customized theme according to template', '03/24/2023', '03/31/2023', 'asimakouser@gmail.com', '1,10,12,13,14,15', 'Admission Trend Analysi1.docx', '2023-03-19 11:23:57', 'completed'),
(19, 'design a webpage for captive portal', 'framework use only front end html,css javascript ', '03/22/2023', '03/24/2023', 'husnain123@gmail.com', '1,10,12', 'Lecture 4.pdf', '2023-03-19 11:24:58', 'pending'),
(20, 'find solutions  for this file ', 'everyone can research on that and find solutions ', '03/30/2023', '03/31/2023', 'pazkeeza786@gmail.com', '13,14,15', 'LEC 15.pdf', '2023-03-19 11:26:16', 'pending'),
(21, 'woocommerce plugin', 'installed plugin and apply payment gayways each person done each payment gatway ', '03/22/2023', '03/25/2023', 'asimakouser@gmail.com', '1,12,14,15', 'D_M LEC 8.pdf', '2023-03-19 11:27:23', 'completed'),
(22, 'create a portfollio website ', 'using php mysql and every one designed one page and given and end date task needed to be done ', '03/17/2023', '03/19/2023', 'husnain123@gmail.com', '10,13,15', 'Lecture 1.pdf', '2023-03-19 11:28:24', 'pending'),
(23, 'data mining solutions', 'find solutions for data mining anaysis and gather data for project ', '03/24/2023', '03/27/2023', 'Samimushtaq222@gmail.com', '1,10,12,15', 'BCS-3605-Lecture-06.pdf', '2023-03-19 11:29:10', 'pending'),
(24, 'projects management system ', 'design portal which contains all data from users and that is used for work.', '03/29/2023', '03/31/2023', 'shabaz@gmail.com', '1,10,12,13,14,15', '132836134180280855.pdf', '2023-03-19 11:30:15', 'completed'),
(25, 'nodogsplash captive portal ', 'design a captive portal for website name is shoptobyme with authentication technique ', '04/04/2023', '03/09/2023', 'pazkeeza786@gmail.com', '1,10,12,15', 'Requirements Traceability Matrix.docx', '2023-03-19 11:31:36', 'pending'),
(26, 'Requirement task abilities matrix', 'design a work flow for the given matrix in attached file ', '03/30/2023', '03/31/2023', 'saniaarrvi786@gmail.com', '10', 'PENDING.pdf', '2023-03-19 11:32:30', 'pending');

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

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `chat_id` int(11) NOT NULL,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `opened` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `conversation_id` int(11) NOT NULL,
  `user_1` int(11) NOT NULL,
  `user_2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `project_members`
--

CREATE TABLE `project_members` (
  `project_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `project_members`
--

INSERT INTO `project_members` (`project_id`, `member_id`, `datetime`) VALUES
(16, 1, '2023-03-19 09:44:52'),
(16, 7, '2023-03-19 09:44:52'),
(16, 10, '2023-03-19 09:44:52'),
(16, 12, '2023-03-19 09:44:52'),
(17, 1, '2023-03-19 09:46:54'),
(17, 7, '2023-03-19 09:46:54'),
(17, 10, '2023-03-19 09:46:54'),
(17, 12, '2023-03-19 09:46:54'),
(18, 1, '2023-03-19 11:23:57'),
(18, 10, '2023-03-19 11:23:57'),
(18, 12, '2023-03-19 11:23:57'),
(18, 13, '2023-03-19 11:23:57'),
(18, 14, '2023-03-19 11:23:57'),
(18, 15, '2023-03-19 11:23:57'),
(19, 1, '2023-03-19 11:24:58'),
(19, 10, '2023-03-19 11:24:58'),
(19, 12, '2023-03-19 11:24:58'),
(20, 13, '2023-03-19 11:26:16'),
(20, 14, '2023-03-19 11:26:16'),
(20, 15, '2023-03-19 11:26:16'),
(21, 1, '2023-03-19 11:27:23'),
(21, 12, '2023-03-19 11:27:23'),
(21, 14, '2023-03-19 11:27:23'),
(21, 15, '2023-03-19 11:27:23'),
(22, 10, '2023-03-19 11:28:24'),
(22, 13, '2023-03-19 11:28:24'),
(22, 15, '2023-03-19 11:28:24'),
(23, 1, '2023-03-19 11:29:10'),
(23, 10, '2023-03-19 11:29:10'),
(23, 12, '2023-03-19 11:29:10'),
(23, 15, '2023-03-19 11:29:10'),
(24, 1, '2023-03-19 11:30:15'),
(24, 10, '2023-03-19 11:30:15'),
(24, 12, '2023-03-19 11:30:15'),
(24, 13, '2023-03-19 11:30:15'),
(24, 14, '2023-03-19 11:30:15'),
(24, 15, '2023-03-19 11:30:15'),
(25, 1, '2023-03-19 11:31:36'),
(25, 10, '2023-03-19 11:31:36'),
(25, 12, '2023-03-19 11:31:36'),
(25, 15, '2023-03-19 11:31:36'),
(26, 10, '2023-03-19 11:32:30');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` varchar(255) NOT NULL,
  `end_date` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `Project` varchar(255) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp(),
  `task_status` enum('pending','completed') NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `title`, `description`, `start_date`, `end_date`, `file`, `Project`, `datetime`, `task_status`) VALUES
(21, 'modify these website ', 'you need to change their color into attached files requirements and need to completed in within time duaration ', '03/22/2023', '03/31/2023', 'FA18-BIT-050 [ASSIGNMENT 1] IT PROJECT MANAGEMENT.pdf', 'create a portfollio website ', '2023-03-19 11:33:53', 'completed'),
(22, 'missing files for this payments section ', 'when users pay bills not stored in database please modify this ', '03/16/2023', '03/22/2023', 'Strategic Management_ The Case of Nike, Inc. - 3907 Words _ Essay Example.pdf', 'projects management system ', '2023-03-19 11:35:45', 'pending'),
(23, 'captive portal deniy authentication is missing ', 'deny auhenciation for this captive portal is missing fix the bug right now ', '03/22/2023', '03/23/2023', 'IRJET-V7I3722-with-cover-page-v2.pdf', 'nodogsplash captive portal ', '2023-03-19 11:37:22', 'pending'),
(24, 'highlighs errors', 'plugin do not work properly you need to fix it ', '03/27/2023', '03/30/2023', 'Kanika_Indicon_2011.pdf', 'woocommerce plugin', '2023-03-19 11:38:05', 'pending');

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

--
-- Table structure for table `task_members`
--

CREATE TABLE `task_members` (
  `task_id` int(11) NOT NULL,
  `member_id` varchar(255) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `task_members`
--

INSERT INTO `task_members` (`task_id`, `member_id`, `datetime`) VALUES
(19, '1', '2023-03-19 09:47:53'),
(19, '7', '2023-03-19 09:47:53'),
(19, '12', '2023-03-19 09:47:53'),
(20, '1', '2023-03-19 09:48:36'),
(20, '7', '2023-03-19 09:48:36'),
(20, '10', '2023-03-19 09:48:36'),
(20, '12', '2023-03-19 09:48:36'),
(21, '1', '2023-03-19 11:33:53'),
(21, '10', '2023-03-19 11:33:53'),
(21, '12', '2023-03-19 11:33:53'),
(21, '13', '2023-03-19 11:33:53'),
(21, '14', '2023-03-19 11:33:53'),
(21, '15', '2023-03-19 11:33:53'),
(0, '1', '2023-03-19 11:34:38'),
(0, '10', '2023-03-19 11:34:38'),
(0, '12', '2023-03-19 11:34:38'),
(22, '10', '2023-03-19 11:35:45'),
(22, '14', '2023-03-19 11:35:45'),
(22, '15', '2023-03-19 11:35:45'),
(23, '1', '2023-03-19 11:37:22'),
(23, '12', '2023-03-19 11:37:22'),
(23, '13', '2023-03-19 11:37:22'),
(23, '15', '2023-03-19 11:37:22'),
(24, '10', '2023-03-19 11:38:05'),
(24, '12', '2023-03-19 11:38:05'),
(24, '13', '2023-03-19 11:38:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addprojects`
--
ALTER TABLE `addprojects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
  ADD PRIMARY KEY (`chat_id`);

--
-- Indexes for table `conversations`
--
ALTER TABLE `conversations`
  ADD PRIMARY KEY (`conversation_id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addprojects`
--
ALTER TABLE `addprojects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
  MODIFY `chat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
  MODIFY `conversation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
COMMIT;

