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

START TRANSACTION;



--
-- Database: `trs_db`
--

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

--
-- Table structure for table `reminder_list`
--

CREATE TABLE `reminder_list` (
  `id` bigint(30) NOT NULL,
  `user_id` bigint(30) NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `remind_from` date NOT NULL,
  `remind_to` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reminder_list`
--

INSERT INTO `reminder_list` (`id`, `user_id`, `title`, `description`, `remind_from`, `remind_to`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Sample Task 101', 'abc\r\nxyz', '2024-04-01', '2023-05-01', 2, '2023-04-17 16:44:27', '2024-05-24 11:40:59'),
(2, 14, 'Monthly Achievements', 'this is my mpr for the month of April 2024.', '2024-04-01', '2023-04-22', 2, '2023-04-17 16:44:57', '2024-05-24 11:41:27'),
(3, 13, 'Monthly Achievement', 'abc efghi jklmno p', '2024-04-01', '2023-04-20', 0, '2023-04-17 16:45:25', '2024-05-24 11:41:56'),
(4, 13, 'Sample Task 103', 'my mpr for the month', '2024-06-01', '2024-06-01', 1, '2023-04-17 16:45:56', '2024-07-24 12:36:37'),
(5, 13, 'ssss', 'ssss', '2024-01-04', '2024-01-16', 1, '2024-01-15 17:24:53', NULL),
(6, 13, '', 'Designed different reports.\r\nWorked with UNICEF officials on IM-SESP dashboard.\r\nCoordinate with Implementation Partners on flood response dashboard.\r\nDesigned different reports.\r\nDesigned different reports.\r\nCoordinate with Implementation Partners on flood response dashboard.\r\nDesigned different reports.\r\nCoordinate with Implementation Partners on flood response dashboard.\r\nDesigned different reports.\r\nDesigned different reports.\r\nDesigned different reports.\r\nCoordinate with Implementation Partners on flood response dashboard.\r\nDesigned different reports.\r\nDesigned different reports.\r\nDesigned different reports.\r\nDesigned different reports.\r\nCoordinate with Implementation Partners on flood response dashboard.\r\nDesigned different reports.\r\n\r\n', '0000-00-00', '2024-07-01', 2, '2024-07-24 11:58:39', '2024-07-24 12:38:42');

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

--
-- Table structure for table `system_info`
--

CREATE TABLE `system_info` (
  `id` int(30) NOT NULL,
  `meta_field` text NOT NULL,
  `meta_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `system_info`
--

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES
(1, 'name', 'Staff MPR System'),
(6, 'short_name', 'MPR - RWP'),
(11, 'logo', 'uploads/logo.png?v=1681720857'),
(13, 'user_avatar', 'uploads/user_avatar.jpg'),
(14, 'cover', 'uploads/cover.png?v=1681694880'),
(17, 'phone', '+92-21-34320241-5'),
(18, 'mobile', '0333-7105917'),
(19, 'email', 'imran.memon@rsu-sindh.gov.pk'),
(20, 'address', '#47-E/1 - 48th Street, Block-6, PECHS, Nursery, Shahrah-e-Faisal, Karachi.');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `reminder_list`
--
ALTER TABLE `reminder_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_fk` (`user_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `reminder_list`
--
ALTER TABLE `reminder_list`
  MODIFY `id` bigint(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `system_info`
--
ALTER TABLE `system_info`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `reminder_list`
--
ALTER TABLE `reminder_list`
  ADD CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
COMMIT;

