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

START TRANSACTION;



--
-- Database: `nisa_db`
--

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `category` varchar(100) DEFAULT 'General',
  `status` enum('pending','resolved') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `complaints`
--

INSERT INTO `complaints` (`id`, `user_id`, `title`, `description`, `category`, `status`, `created_at`) VALUES
(1, NULL, 'Hello', 'Hello', 'Medical', 'pending', '2026-01-08 09:51:47'),
(2, NULL, 'Leg Problem', 'Leg ProblemLeg ProblemLeg ProblemLeg Problem', 'Medical', 'pending', '2026-01-08 09:59:07'),
(3, NULL, 'dhjgj', 'jkk', 'Service', 'pending', '2026-01-08 11:25:03'),
(4, NULL, 'hello', 'hello', 'Service', 'pending', '2026-01-08 11:51:02'),
(5, NULL, 'Bukola babe', 'Bukola babeBukola babeBukola babeBukola babe', 'Service', 'pending', '2026-01-08 20:19:47'),
(6, NULL, 'Hello @ 10pm', 'Hello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmHello @ 10pmv', 'Medical', 'pending', '2026-01-08 21:45:17'),
(7, NULL, 'zzzzzzzzzzzzzzzzzzzzzzzzzz', 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz', 'Medical', 'pending', '2026-01-09 00:04:28'),
(8, NULL, 'aaaaaaaaaaaaaaaaaaaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'General', 'pending', '2026-01-09 00:04:46'),
(9, NULL, 'qqqqq', 'Enable shell integration to improve command detection\n\nPerfect! No errors. Now Enable shell integration to improve command detection\n\nPerfect! No errors. Now Enable shell integration to improve command detection\n\nPerfect! No errors. Now', 'Medical', 'pending', '2026-01-09 01:12:35');

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

--
-- Table structure for table `fertility_resources`
--

CREATE TABLE `fertility_resources` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `resource_type` enum('Article','Video','Document','Link') DEFAULT 'Article',
  `url` varchar(500) NOT NULL,
  `is_published` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fertility_resources`
--

INSERT INTO `fertility_resources` (`id`, `title`, `description`, `resource_type`, `url`, `is_published`, `created_at`) VALUES
(1, 'ssgwed', 'dsgdfdfgdd', 'Video', 'dffdcd.com', 1, '2026-01-08 11:54:07'),
(3, 'University Students', 'While numerous studies suggest a correlation between social media use and academic outcomes, there is limited understanding of:\n1.	Which specific usage patterns (e.g., time of day, duration, platform type, activity type) most significantly impact academic performance\n2.	How students\' self-regulation strategies mediate this relationship\n3.	The contextual factors that differentiate detrimental from beneficial social media use in academic contexts', 'Link', 'https://chat.deepseek.com/a/chat/s/377d0a0e-5825-4428-8956-3df5e03c8a10', 1, '2026-01-08 12:02:08'),
(4, 'Quantitative Study', '•	Design: Correlational survey research with longitudinal elements\n•	Participants: Stratified random sample of 500 university students across disciplines and year levels', 'Document', 'https://web.whatsapp.com/', 1, '2026-01-08 12:20:45'),
(7, 'aaa', 'aaa', 'Video', 'aaa', 1, '2026-01-09 02:17:18');

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

--
-- Table structure for table `ivf_tips`
--

CREATE TABLE `ivf_tips` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `category` varchar(100) DEFAULT 'General',
  `is_published` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ivf_tips`
--

INSERT INTO `ivf_tips` (`id`, `title`, `content`, `category`, `is_published`, `created_at`) VALUES
(1, 'HELLO', 'SFSSSDS', 'HRTRTR', 1, '2026-01-08 11:53:46'),
(2, 'reswd', 'dgwadwrgfwafsfsdfsfs', 'ddrefw', 1, '2026-01-08 11:55:20'),
(3, 'ewew', 'dsc', 'dsdsx', 1, '2026-01-08 11:55:43'),
(4, 'University Students:', 'While numerous studies suggest a correlation between social media use and academic outcomes, there is limited understanding of:\n1.	Which specific usage patterns (e.g., time of day, duration, platform type, activity type) most significantly impact academic performance\n2.	How students\' self-regulation strategies mediate this relationship\n3.	The contextual factors that differentiate detrimental from beneficial social media use in academic contexts', 'University Students: A Mixed-Methods Investigation', 1, '2026-01-08 12:01:20'),
(5, 'ffff', 'ffff', 'fff', 1, '2026-01-09 00:31:56'),
(6, 'zzz', 'zzzz', 'zzzz', 1, '2026-01-09 01:01:52'),
(7, 'yyyy', 'yyyy', 'yyyy', 1, '2026-01-09 01:03:04'),
(8, 'aaa', 'aaaa', 'aaa', 1, '2026-01-09 01:10:29'),
(9, 'ppp', 'ppp', 'ppp', 1, '2026-01-09 01:10:37'),
(10, 'ss', 'ssss', 'sss', 1, '2026-01-09 01:21:23'),
(11, 'yy', 'yy', 'yyy', 1, '2026-01-09 01:21:44'),
(12, 'kk', 'kk', 'kk', 1, '2026-01-09 01:22:03'),
(13, 'rrr', 'rrr', 'rrr', 1, '2026-01-09 02:16:30'),
(14, 'qqq', 'qqq', 'qqq', 1, '2026-01-09 03:10:28'),
(15, 'www', 'www', 'www', 1, '2026-01-09 03:10:41'),
(16, 'qqq', 'qqq', 'qqq', 1, '2026-01-09 03:10:55'),
(17, 'www', 'www', 'www', 1, '2026-01-09 03:11:01'),
(18, 'eee', 'eee', 'eee', 1, '2026-01-09 03:11:07'),
(19, 'qqq', 'qqq', 'qqq', 1, '2026-01-09 03:11:14'),
(20, 'rrr', 'rrr', 'rrr', 1, '2026-01-09 03:11:20'),
(21, 'www', 'www', 'www', 1, '2026-01-09 03:11:28'),
(22, 'qqq', 'qqq', 'qqq', 1, '2026-01-09 03:11:34'),
(23, '333', '333', '333', 1, '2026-01-09 03:11:53'),
(24, '111', '111', '111', 1, '2026-01-09 03:11:59'),
(25, '333', '333', '33', 1, '2026-01-09 03:12:09'),
(26, 'ttt', 'ttt', 'ttt', 1, '2026-01-09 03:12:16'),
(27, 'University Students:', 'While numerous studies suggest a correlation between social media use and academic outcomes, there is limited understanding of:\n1.	Which specific usage patterns (e.g., time of day, duration, platform type, activity type) most significantly impact academic performance\n2.	How students\' self-regulation strategies mediate this relationship\n3.	The contextual factors that differentiate detrimental from beneficial social media use in academic contextsssss', 'University Students: A Mixed-Methods Investigation', 1, '2026-01-09 04:06:03');

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

--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `id` int(11) NOT NULL,
  `content_type` varchar(50) NOT NULL COMMENT 'story, tip, or resource',
  `content_id` int(11) NOT NULL COMMENT 'ID of the story/tip/resource',
  `user_identifier` varchar(255) NOT NULL COMMENT 'User ID or guest identifier',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`id`, `content_type`, `content_id`, `user_identifier`, `created_at`) VALUES
(8, 'tip', 7, 'guest_user', '2026-01-09 03:16:31'),
(9, 'tip', 8, 'guest_user', '2026-01-09 03:16:32'),
(10, 'tip', 10, 'guest_user', '2026-01-09 03:16:34'),
(11, 'tip', 15, 'guest_user', '2026-01-09 03:16:36'),
(20, 'story', 5, 'guest_user', '2026-01-09 03:22:07'),
(27, 'tip', 11, 'guest_user', '2026-01-09 03:25:00'),
(28, 'tip', 12, 'guest_user', '2026-01-09 03:25:01'),
(29, 'tip', 14, 'guest_user', '2026-01-09 03:25:03'),
(30, 'story', 2, 'guest_user', '2026-01-09 03:27:42'),
(31, 'story', 1, 'guest_user', '2026-01-09 03:27:57'),
(32, 'resource', 7, 'guest_user', '2026-01-09 03:28:04'),
(33, 'resource', 4, 'guest_user', '2026-01-09 03:28:07'),
(34, 'resource', 3, 'guest_user', '2026-01-09 03:28:09'),
(35, 'resource', 1, 'guest_user', '2026-01-09 03:28:12'),
(36, 'story', 6, 'guest_user', '2026-01-09 03:30:27'),
(38, 'story', 3, 'guest_user', '2026-01-09 03:37:55'),
(39, 'tip', 26, 'guest_user', '2026-01-09 03:41:26'),
(40, 'tip', 25, 'guest_user', '2026-01-09 03:41:27');

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

--
-- Table structure for table `patients`
--

CREATE TABLE `patients` (
  `id` int(11) NOT NULL,
  `full_name` varchar(200) DEFAULT NULL COMMENT 'This is now wife''s name',
  `wife_name` varchar(200) DEFAULT NULL,
  `wife_dob` date DEFAULT NULL,
  `wife_occupation` varchar(100) DEFAULT NULL,
  `husband_name` varchar(200) DEFAULT NULL,
  `husband_dob` date DEFAULT NULL,
  `husband_occupation` varchar(100) DEFAULT NULL,
  `husband_email` varchar(100) DEFAULT NULL,
  `husband_phone` varchar(20) DEFAULT NULL,
  `religion` varchar(50) DEFAULT NULL,
  `denomination` varchar(100) DEFAULT NULL,
  `referred_by` varchar(200) DEFAULT NULL,
  `referrer_phone` varchar(20) DEFAULT NULL,
  `wife_email` varchar(100) DEFAULT NULL,
  `wife_phone1` varchar(20) DEFAULT NULL,
  `phone2` varchar(20) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `gender` enum('Male','Female','Other') DEFAULT 'Other',
  `marital_status` enum('Single','Married','Divorced','Widowed') DEFAULT 'Married',
  `address` text DEFAULT NULL,
  `medical_history` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `patients`
--

INSERT INTO `patients` (`id`, `full_name`, `wife_name`, `wife_dob`, `wife_occupation`, `husband_name`, `husband_dob`, `husband_occupation`, `husband_email`, `husband_phone`, `religion`, `denomination`, `referred_by`, `referrer_phone`, `wife_email`, `wife_phone1`, `phone2`, `age`, `gender`, `marital_status`, `address`, `medical_history`, `created_at`, `updated_at`) VALUES
(3, 'ddd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dd@gma.com', '577654324567754', NULL, 33, 'Male', 'Married', '23566432', 'efheasdf', '2026-01-08 15:20:24', '2026-01-08 22:01:37'),
(4, 'Bukola babe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Bukola@gmail.com', '11111111111', NULL, 60, 'Female', 'Married', 'Bukola babeBukola babeBukola babeBukola babeBukola babeBukola babe', 'Bukola babeBukola babeBukola babeBukola babe', '2026-01-08 20:20:31', '2026-01-08 22:01:37'),
(5, 'Adaora Nwankwo', NULL, '1988-05-15', 'Doctor', 'Chinedu Nwankwo', '1985-08-22', 'Banker', 'chinedu@example.com', '08051234567', 'Christian', 'Catholic', 'Dr. Okoro', '08071234567', 'adaora@example.com', '08031234567', '08123456789', 35, 'Female', 'Married', '15 Medical Road, Enugu', 'PCOS treatment', '2026-01-08 22:01:37', '2026-01-08 22:01:37'),
(6, 'AAAAA', NULL, '2000-01-20', 'STUDENT', 'asd', '1991-01-09', 'student', 'Asa@gmail.com', '1234567890', 'cgdd', 'ddssd', 'ddfsf', '2332', 'olareally@gmail.com', '1234567890', '1234567890', 25, 'Female', 'Married', 'asas', 'adasasda', '2026-01-08 23:14:38', '2026-01-08 23:14:38'),
(7, 'aaa', NULL, '2000-01-20', 'aaa', 'aaa', '1985-01-09', 'student', 'olaw@gmail.com', '1234567890', 'cdfd', '', 'asa', '1234567890', 'aaa@gmail.com', '1234567890', '1234567890', 25, 'Female', 'Single', '1234567890', 'fghfdhgfddfvbnfd', '2026-01-08 23:22:52', '2026-01-08 23:22:52'),
(8, 'aaa', NULL, '2000-01-20', 'aaa', 'aaa', '1985-01-09', 'student', 'olaw@gmail.com', '1234567890', 'cdfd', '', 'asa', '1234567890', 'aaa@gmail.com', '1234567890', '1234567890', 25, 'Female', 'Single', '1234567890', 'fghfdhgfddfvbnfd', '2026-01-08 23:23:07', '2026-01-08 23:23:07');

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

--
-- Table structure for table `success_stories`
--

CREATE TABLE `success_stories` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `story` text NOT NULL,
  `author_name` varchar(100) DEFAULT 'Anonymous',
  `date` date DEFAULT NULL,
  `is_published` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `success_stories`
--

INSERT INTO `success_stories` (`id`, `title`, `story`, `author_name`, `date`, `is_published`, `created_at`) VALUES
(2, 'xxxx', 'xxxxx', 'Anonymous', '2026-01-09', 1, '2026-01-09 00:26:29'),
(3, 'cccc', 'cccc', 'Anonymous', '2026-01-09', 1, '2026-01-09 00:27:29'),
(5, 'zzzz', 'zzzzz', 'Anonymous', '2026-01-09', 1, '2026-01-09 01:11:30'),
(6, 'aaaa', 'aaaa', 'Anonymous', '2026-01-09', 1, '2026-01-09 02:16:48');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `likes`
--
ALTER TABLE `likes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_like` (`content_type`,`content_id`,`user_identifier`),
  ADD KEY `idx_content` (`content_type`,`content_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `complaints`
--
ALTER TABLE `complaints`
  ADD CONSTRAINT `complaints_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

