-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 02, 2025 at 12:18 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.0.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_users` -- CREATE TABLE `tbl_users` ( `user_id` int(125) NOT NULL, `fullname` varchar(255) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(150) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `role` enum('Admin','Moderator','Member') NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `access_code` varchar(6) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tbl_users` -- INSERT INTO `tbl_users` (`user_id`, `fullname`, `phone`, `email`, `password`, `role`, `created_at`, `access_code`) VALUES (11, 'Dangana Tumba', '08131663532', 'danganatumba2019@gmail.com', '$2y$10$cKK3z/s1ulV0DgoHI0XWTumtiH/UgHFEZ9qs2WfYGlLJzTV/iaTCS', 'Admin', '2025-08-01 16:58:38', '813676'), (12, 'Alpha Bitrus', '08065773631', 'alphabitrus44@gmail.com', '$2y$10$bRHGsEm/GNYD3ahbzhviCe7Wv0OX8xzGEgHTAj1BEBt.V8iDqC2Ua', 'Member', '2025-08-01 22:16:42', '908784'); -- -- 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`); -- -- Indexes for table `tbl_users` -- ALTER TABLE `tbl_users` ADD PRIMARY KEY (`user_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; -- -- AUTO_INCREMENT for table `tbl_users` -- ALTER TABLE `tbl_users` MODIFY `user_id` int(125) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;