-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 25, 2024 at 11:08 AM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

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: `pwd_senior`
--

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

--
-- Table structure for table `access_level`
--

CREATE TABLE `access_level` (
  `access_level_id` bigint NOT NULL,
  `access_level_desc` varchar(50) NOT NULL,
  `access_level_stat` int NOT NULL DEFAULT '1',
  `access_level_code` varchar(4) NOT NULL,
  `access_def` smallint DEFAULT '0',
  `dt_ts` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `access_level`
--

INSERT INTO `access_level` (`access_level_id`, `access_level_desc`, `access_level_stat`, `access_level_code`, `access_def`, `dt_ts`) VALUES
(1, 'Admin', 1, '1001', 0, NULL),
(114, 'Administrator', 1, '1', 0, NULL),
(115, 'Users', 1, '143', 0, NULL);

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

--
-- Table structure for table `access_level_menu_navbar`
--

CREATE TABLE `access_level_menu_navbar` (
  `access_level_menu_id` bigint NOT NULL,
  `userid` bigint DEFAULT NULL,
  `nav_menu_id` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `access_level_menu_navbar`
--

INSERT INTO `access_level_menu_navbar` (`access_level_menu_id`, `userid`, `nav_menu_id`) VALUES
(12140, 114, 1),
(12142, 115, 1),
(12143, 115, 292),
(12292, 1, 1),
(12293, 1, 204),
(12294, 1, 205),
(12295, 1, 206),
(12296, 1, 207),
(12297, 1, 208),
(12298, 1, 209),
(12299, 1, 211),
(12300, 1, 232),
(12301, 1, 234),
(12302, 1, 295),
(12303, 1, 308),
(12304, 1, 309),
(12305, 1, 310),
(12306, 1, 311);

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `schedule` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text,
  `donor_type` enum('Individual','Organization','Company') DEFAULT NULL,
  `donation_type` enum('Material','Monetary') DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `total_beneficiary` int DEFAULT NULL,
  `amount_per_person` double DEFAULT NULL,
  `amount_claimed` double DEFAULT '0',
  `item` text,
  `item_desc` text,
  `item_quantity` int DEFAULT NULL,
  `item_per_person` int DEFAULT '1',
  `item_claimed` int DEFAULT '0',
  `beneficiary` enum('PWD','Senior Citizen','Both') DEFAULT NULL,
  `purpose` text,
  `location` varchar(255) DEFAULT NULL,
  `allow_multiple` enum('Yes','No') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` enum('Pending','Started','Done') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `schedule`, `name`, `email`, `phone`, `address`, `donor_type`, `donation_type`, `total_amount`, `total_beneficiary`, `amount_per_person`, `amount_claimed`, `item`, `item_desc`, `item_quantity`, `item_per_person`, `item_claimed`, `beneficiary`, `purpose`, `location`, `allow_multiple`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mayor Pantawid Mahirap', '2024-10-30 14:00:00', 'Vic Sotto', 'vic@gmail.com', '02154211111', 'Pasig City', 'Individual', 'Material', 0, 0, 0, 0, 'Wheelchair', 'For person with mobility problem', 500, 1, 0, 'Both', 'For people with mobility problem', 'Tayabas', 'Yes', 'Started', '2024-10-22 11:52:41', '2024-10-22 11:52:41'),
(2, 'Malasakit Foundation', '2024-10-25 13:00:00', 'KKP', 'kkp@gmail.com', '0154212222222', 'Tayabas', 'Organization', 'Monetary', 50000, 100, 500, 0, '', '', 0, 0, 0, 'PWD', 'Pantawid gutom', 'Tayabas', 'No', 'Started', '2024-10-22 12:50:58', '2024-10-22 12:50:58'),
(3, 'Kabayan Foundation', '2024-10-28 15:00:00', 'Armando Marcos', 'arman@gmail.com', '09302222221', 'Coliling, San Carlos City', 'Individual', 'Material', 0, 0, 0, 0, 'Hearing Aid', 'For hearing loss problem', 200, 1, 0, 'Senior Citizen', 'For the people of Coliling', 'San Carlos City', 'No', 'Started', '2024-10-22 17:32:41', '2024-10-22 17:32:41'),
(4, 'Senior Gantimpala', '2024-10-28 12:00:00', 'Frizer', 'frizer@gmail.com', '09303565452', 'Pasig City', 'Company', 'Material', 0, 0, 0, 0, 'Vitamins', 'For Health', 10000, 5, 0, 'Both', 'Para sa ikakaganda ng kalusugan', 'Tayabas', 'No', 'Started', '2024-10-23 03:47:25', '2024-10-23 03:47:25'),
(5, 'Pasig Citizen', '2024-10-27 15:00:00', 'Citizen Charter V', 'ctc@gmail.com', '01254211111', 'Pasig City', 'Organization', 'Monetary', 50000, 10, 5000, 0, '', '', 0, 0, 0, 'Senior Citizen', 'For citizen incentives', 'Tayabas', 'Yes', 'Started', '2024-10-23 03:55:03', '2024-10-23 03:55:03');

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int NOT NULL,
  `code` varchar(255) NOT NULL,
  `location_description` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `code`, `location_description`, `created_at`) VALUES
(1, '01', 'San Carlos City', '2024-10-06 08:53:29'),
(2, '02', 'Tayabas', '2024-10-06 09:48:40'),
(3, '03', 'Montalban', '2024-10-06 09:50:03');

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

--
-- Table structure for table `material_items`
--

CREATE TABLE `material_items` (
  `id` int NOT NULL,
  `code` varchar(255) NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `item_description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `material_items`
--

INSERT INTO `material_items` (`id`, `code`, `title`, `item_description`, `created_at`) VALUES
(1, '01', 'Wheelchairs', 'Wheelchairs', '2024-10-08 18:08:40'),
(2, '02', 'Hearing Aid', 'Hearing Aid', '2024-10-10 15:25:18'),
(3, '03', 'White Cane', 'White Cane', '2024-10-11 06:17:04'),
(4, '04', 'Hospital Bed', 'This for person with back injury', '2024-10-25 11:05:40');

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

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `id` int NOT NULL,
  `doc_number` varchar(64) NOT NULL,
  `fname` varchar(64) DEFAULT NULL,
  `mname` varchar(64) DEFAULT NULL,
  `lname` varchar(64) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `location_st` varchar(64) DEFAULT NULL,
  `location_brgy` varchar(64) DEFAULT NULL,
  `location_city` varchar(64) DEFAULT NULL,
  `location_prov` varchar(64) DEFAULT NULL,
  `location_region` varchar(64) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`id`, `doc_number`, `fname`, `mname`, `lname`, `birthday`, `email`, `phone`, `location_st`, `location_brgy`, `location_city`, `location_prov`, `location_region`, `image`, `status`, `created_at`, `updated_at`) VALUES
(2, '123456789', 'CORAZON', '', 'CRUZ', '2004-10-07', 'corazon@gmail.com', '0932654987', 'Bonifacio', 'Valencia', 'Tayabas', 'Quezon', 'Quezon', NULL, NULL, '2024-10-07 11:42:52', '2024-10-23 06:18:49');

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

--
-- Table structure for table `member_claimed`
--

CREATE TABLE `member_claimed` (
  `id` int NOT NULL,
  `reference` varchar(255) NOT NULL,
  `member_id` int DEFAULT NULL,
  `origin` enum('Event','Request') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'Event - event table,\r\nRequest - request table\r\n',
  `origin_id` int DEFAULT NULL,
  `donation_type` enum('Material','Monetary') DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `item_quantity` int DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `claimed_date` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `request`
--

CREATE TABLE `request` (
  `id` int NOT NULL,
  `member_id` int DEFAULT NULL,
  `donation_type` enum('Material','Monetary') DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `item_quantity` int DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `purpose` text,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` enum('Pending','Verified','Approved','Denied','Claimed') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `verified_date` datetime DEFAULT NULL,
  `verified_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `denied_date` datetime DEFAULT NULL,
  `denied_by` varchar(255) DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `approved_by` varchar(255) DEFAULT NULL,
  `claimed_date` datetime DEFAULT NULL,
  `claimed_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `released_date` datetime DEFAULT NULL,
  `released_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`id`, `member_id`, `donation_type`, `item_id`, `item_quantity`, `amount`, `purpose`, `location`, `status`, `verified_date`, `verified_by`, `denied_date`, `denied_by`, `approved_date`, `approved_by`, `claimed_date`, `claimed_by`, `released_date`, `released_by`, `created_at`, `updated_at`) VALUES
(1, 123456789, 'Material', 2, 1, NULL, 'This is a test', 'Tayabas', 'Approved', '2024-10-24 05:52:02', '28', NULL, NULL, '2024-10-24 06:24:41', '28', NULL, NULL, NULL, NULL, '2024-10-24 00:17:44', '2024-10-25 10:00:57'),
(2, 123456789, 'Material', 2, 1, NULL, 'Donation Details', 'Montalban', 'Verified', '2024-10-24 06:24:32', '28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-24 00:32:01', '2024-10-23 22:24:35'),
(3, 123456789, 'Monetary', 0, 0, 1000, 'Senior care', 'San Carlos', 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-24 00:59:56', '2024-10-23 18:34:15'),
(4, 123456789, 'Material', 3, 1, NULL, 'For personal', 'Tayabas', 'Approved', '2024-10-24 06:36:46', '28', NULL, NULL, '2024-10-24 15:38:50', '28', NULL, NULL, NULL, NULL, '2024-10-24 01:11:49', '2024-10-25 10:00:51'),
(5, 123456789, 'Material', 3, 1, NULL, 'For family', 'San Carlos City', 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-25 18:19:45', '2024-10-25 10:19:45');

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

--
-- Table structure for table `tbl_members`
--

CREATE TABLE `tbl_members` (
  `id` int NOT NULL,
  `fname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `lname` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `complete_address` varchar(1225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `house_no` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `street` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `brgy` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `city` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `province` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `zip_code` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `contact_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` longblob NOT NULL,
  `status` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_members`
--

INSERT INTO `tbl_members` (`id`, `fname`, `mname`, `lname`, `complete_address`, `house_no`, `street`, `brgy`, `city`, `province`, `zip_code`, `contact_no`, `image`, `status`) VALUES
(1, 'Rommel', 'Cayabyab', 'Santiago', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619',  , 0),
(2, 'Rommel', 'Cayabyab', 'Santiago', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0x696d6167652e6a7067, 0),
(3, 'Rommel', 'Cayabyab', 'Santiago', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0x696d6167652e6a7067, 0),
(4, 'asdasdas', 'asdas', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(5, 'dsa', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(6, 'dsa', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(7, 'Rommel', 'Cayabyab', 'Santiago', '436 Oplas, Bacnar, San Carlos City, Pangasinan', '436', 'Oplas', 'Bacnar', 'San Carlos City', 'Pangasinan', '2420', '09384547619', 0x696d6167652e6a7067, 0),
(8, 'sASasASa', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(9, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(10, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(11, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(12, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(13, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(14, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(15, '', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(16, 'ASasA', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0),
(17, '123asdadassa', '', '', ' , , , ', '', '', '', '', '', '', '', '', 0);

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

--
-- Table structure for table `tbl_menu_list`
--

CREATE TABLE `tbl_menu_list` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `parentid` int DEFAULT NULL,
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_menu_list`
--

INSERT INTO `tbl_menu_list` (`id`, `title`, `link`, `parentid`, `remarks`, `icon`) VALUES
(1, 'Dashboard', '/', 0, '', 'fe fe-home fe-16'),
(204, 'User', '#', 295, NULL, 'fe fe-user fe-16'),
(205, 'Add User', 'add-user.php', 204, NULL, 'fe fe-minus fe-16'),
(206, 'List User', 'list-user.php', 204, NULL, 'fe fe-minus fe-16'),
(207, 'Modify User Level', 'add-access-menu.php', 204, NULL, 'fe fe-minus fe-16'),
(208, 'Access Level', '#', 295, NULL, 'fe fe-trello fe-16'),
(209, 'Add User Access Level', 'add-user-level.php', 208, NULL, 'fe fe-minus fe-16'),
(211, 'View User Access Level', 'list-accesslvl.php', 208, NULL, 'fe fe-minus fe-16'),
(232, 'Dynamic Menu', '#', 295, 'Good', 'fe fe-menu fe-16'),
(234, 'List Dynamic Menu', 'list_of_dynamic_menu.php', 232, 'Good', 'fe fe-minus fe-16'),
(292, 'Members', 'philhealth_members_view.php', 0, 'Good', 'fe fe-check-square fe-16'),
(293, 'Reports', 'report_issue_voters.php', 0, 'Good', 'fe fe-file-text fe-16'),
(294, 'Logs', 'logs_voters_issued.php', 0, 'Good', 'fe fe-book-open fe-16'),
(295, 'User Management', '#', 0, 'Good', 'fe fe-settings fe-16'),
(305, 'List of Donation', '#', 0, 'Parent', NULL),
(306, 'Verify Request', 'list_verify_request.php', 305, 'Child', NULL),
(307, 'Request Donation', '#', 0, 'Parent', NULL),
(308, 'Donation', '#', 0, 'Parent', 'fe fe-git-pull-request fe-16'),
(309, 'Item List', 'items', 308, 'Child', 'fe fe-check fe-16'),
(310, 'Approve Request', 'list_for_approval_request.php', 308, 'Child', 'fe fe-check-circle fe-16'),
(311, 'List of Request Donation', 'list_request.php', 308, 'Child', 'fe fe-list fe-16');

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `idno` int NOT NULL,
  `uname` varchar(255) DEFAULT NULL,
  `userpass` varchar(255) DEFAULT NULL,
  `userempidno` varchar(15) DEFAULT NULL,
  `userfname` varchar(255) DEFAULT NULL,
  `userlname` varchar(255) DEFAULT NULL,
  `userposition` varchar(255) DEFAULT NULL,
  `userrole` varchar(255) DEFAULT NULL,
  `useroffice` varchar(255) DEFAULT NULL,
  `officeid` varchar(10) DEFAULT NULL,
  `userstatus` varchar(255) DEFAULT NULL,
  `userdatereg` varchar(255) DEFAULT NULL,
  `useremail` varchar(255) DEFAULT NULL,
  `access_level_cde` varchar(6) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `android_user` int DEFAULT NULL,
  `reset_pwd` smallint DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`idno`, `uname`, `userpass`, `userempidno`, `userfname`, `userlname`, `userposition`, `userrole`, `useroffice`, `officeid`, `userstatus`, `userdatereg`, `useremail`, `access_level_cde`, `location`, `android_user`, `reset_pwd`) VALUES
(28, 'Admin@Admin.com', '$2y$10$6hSlrq.DUmQU./T.VlCqsOi/abwZdM.Dr4gZebmVIgZy67GN0x6a6', '1001', 'Rommel', 'Santiago', 'Admin', '1', 'Admin', NULL, '1', '2024-02-23 19:07:30', 'Admin@Admin.com', '1', NULL, 0, 1),
(29, 'user@gmail.com', '$2y$10$rniUUvIO2p.TtZW4iQAGVu5ZUaaICz0kDXnU5vFWMimyCY9YQEPkK', '1002', 'Rommel', 'Santiago', 'Staff', '115', 'Staff', NULL, '1', '2024-03-07 21:30:04', 'user@gmail.com', '115', NULL, 0, 1),
(30, '', '$2y$10$UPS45hGYY00ZaQuK3dfk5OW45i9.jq91fbvmfBdkOpcY1YmX3nxsW', '', '', '', '', '', '', NULL, '1', '2024-03-05 19:41:07', '', '', NULL, 0, 1),
(31, 'Admin@Admin.admin', '$2y$10$xU6K.oloHNkiui5/zknYWuUhZPnajwfQqnbT.6b/xIBsGzESRepxW', '', '', '', '', '', '', NULL, '1', '2024-03-05 19:42:35', 'Admin@Admin.admin', '', NULL, 0, 1),
(32, 'user@gmail.com456', '$2y$10$115O26L/8rDml3hgMlIKn.DiYs7nXbCWzAZAmxHRGLYP.59wQMnWa', '3', 'Jet', 'Santiago', 'User', '', 'User', NULL, '1', '2024-03-06 21:47:58', 'user@gmail.com456', '', NULL, 0, 1),
(33, 'user@gmail.com123', '$2y$10$UfuG9DvUNXYvz91DcW/NGuBHpeRdQH2anthjlB.eOoGMhiTK4E.Hm', '1003', 'Rommel', 'Santiago', 'User', '', 'User', NULL, '1', '2024-03-06 21:48:11', 'user@gmail.com', '', NULL, 0, 1),
(34, 'Admin@Admin.com.ph', '$2y$10$KYwO7hg5OIxum28Plzk/WOkZ0YAD3fB.dfUSM2SzDsFptjnMoCL8u', '1004', 'Rommel', 'Santiago', 'Admin', '1', 'Admin', NULL, '1', '2024-03-05 20:13:44', 'Admin@Admin.com.ph', '1', NULL, 0, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `access_level`
--
ALTER TABLE `access_level`
  ADD PRIMARY KEY (`access_level_id`);

--
-- Indexes for table `access_level_menu_navbar`
--
ALTER TABLE `access_level_menu_navbar`
  ADD PRIMARY KEY (`access_level_menu_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`idno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `access_level`
--
ALTER TABLE `access_level`
  MODIFY `access_level_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--
-- AUTO_INCREMENT for table `access_level_menu_navbar`
--
ALTER TABLE `access_level_menu_navbar`
  MODIFY `access_level_menu_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12307;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `material_items`
--
ALTER TABLE `material_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `member`
--
ALTER TABLE `member`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `member_claimed`
--
ALTER TABLE `member_claimed`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `request`
--
ALTER TABLE `request`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_members`
--
ALTER TABLE `tbl_members`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_menu_list`
--
ALTER TABLE `tbl_menu_list`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=312;

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `idno` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
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 */;
