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

START TRANSACTION;



--
-- Database: `membership_db`
--

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

--
-- Table structure for table `tbl_membership_dues`
--

CREATE TABLE `tbl_membership_dues` (
  `id` int(11) NOT NULL,
  `member_info_id` int(125) NOT NULL,
  `year` year(4) NOT NULL,
  `status` enum('Paid','Not-Paid') DEFAULT 'Not-Paid',
  `payment_date` datetime DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_membership_dues`
--

INSERT INTO `tbl_membership_dues` (`id`, `member_info_id`, `year`, `status`, `payment_date`, `amount`) VALUES
(24, 5, '2023', 'Paid', '2025-08-01 18:37:35', NULL),
(25, 5, '2025', 'Paid', '2025-08-01 18:37:44', NULL);

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

--
-- Table structure for table `tbl_members_info`
--

CREATE TABLE `tbl_members_info` (
  `member_info_id` int(125) NOT NULL,
  `user_id` int(125) NOT NULL,
  `dob` date DEFAULT NULL,
  `gender` enum('Male','Female') NOT NULL,
  `marital_status` enum('Single','Married') DEFAULT NULL,
  `state_of_origin` varchar(100) DEFAULT NULL,
  `lga` varchar(100) DEFAULT NULL,
  `eyn_lcc` text DEFAULT NULL,
  `eyn_dcc` text NOT NULL,
  `permanent_address` text DEFAULT NULL,
  `occupation` varchar(100) DEFAULT NULL,
  `education` varchar(100) DEFAULT NULL,
  `skill` varchar(100) DEFAULT NULL,
  `other_skill` varchar(100) DEFAULT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `status` enum('Pending','Approved','Canceled') DEFAULT 'Pending',
  `rank` varchar(125) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_members_info`
--

INSERT INTO `tbl_members_info` (`member_info_id`, `user_id`, `dob`, `gender`, `marital_status`, `state_of_origin`, `lga`, `eyn_lcc`, `eyn_dcc`, `permanent_address`, `occupation`, `education`, `skill`, `other_skill`, `profile_picture`, `status`, `rank`, `created_at`) VALUES
(5, 11, '1986-02-07', 'Male', 'Married', 'Adamawa', 'Mubi', 'Nasarawo', 'Mubi', 'Kolere word, Ahmadu Bello Way Mubi', 'Civil Servant', 'B.Sc', 'Other', '', 'images/profile_pics/688cf42fe63c1_DANGANA-TUMBA.jpg', 'Approved', 'National Secretary', '2025-08-01 17:04:33');

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

--
-- Table structure for table `tbl_publications`
--

CREATE TABLE `tbl_publications` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `pdf_path` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_publications`
--

INSERT INTO `tbl_publications` (`id`, `name`, `description`, `pdf_path`, `created_at`) VALUES
(1, 'BOOK INNER ENY BIBLE STUDYS', 'LITTAFI BINCIKE MAI TSARKI (TA 6) KAFAFFE DA KUMA GINANU A CIKIN KRISTI', 'publications/1753569375_BOOK INNER ENY BIBLE STUDYS.pdf', '2025-07-26 23:36:15'),
(2, 'BOOK INNER EYN BIBLE STUDIES ENGLISH', 'BIBLE STUDY OUTLINE (6 EDITION) THEME: ROOTED & BUILT UP IN CHRIST', 'publications/1753639549_BOOK INNER EYN BIBLE STUDIES ENGLISH.pdf', '2025-07-27 19:05:49');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `tbl_members_info`
--
ALTER TABLE `tbl_members_info`
  ADD PRIMARY KEY (`member_info_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `tbl_members_info`
--
ALTER TABLE `tbl_members_info`
  MODIFY `member_info_id` int(125) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `tbl_membership_dues`
--
ALTER TABLE `tbl_membership_dues`
  ADD CONSTRAINT `tbl_membership_dues_ibfk_1` FOREIGN KEY (`member_info_id`) REFERENCES `tbl_members_info` (`member_info_id`);
COMMIT;

