-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 23, 2021 at 05:38 PM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `sap_informationsystem`
--

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `user_id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`user_id`, `username`, `password`, `role`) VALUES
(1, 'admin', 'a1Bz20ydqelm8m1wqlxIseQ0zVd033e22ae348aeb5660fc2140aec35850c4da997', 'Administrator'),
(2, 'cel', 'a1Bz20ydqelm8m1wqlxIseQ0zVc77f8d4f860953c36855deda769009b29d188c3c', 'Administrator');

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

--
-- Table structure for table `tbl_audittrail`
--

CREATE TABLE `tbl_audittrail` (
  `audittrail_id` int(11) NOT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_ip` text DEFAULT NULL,
  `user_host` text DEFAULT NULL,
  `logdate` text DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_audittrail`
--

INSERT INTO `tbl_audittrail` (`audittrail_id`, `user_name`, `user_ip`, `user_host`, `logdate`, `action`) VALUES
(1, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 07:54 PM', '\'Admin\' will Add Account for \'Zone Leader\' name is. \'zone\''),
(2, 'zone', '::1', 'buhayko-PC', 'Oct-21-2021 07:59 PM', '\'Zone Leader\' will Add Beneficiaries Info. for \'Toledo, Junil A\''),
(3, 'Toledo, Junil A', '::1', 'buhayko-PC', 'Oct-21-2021 08:04 PM', 'The Beneficiarias member requested the SAP Form his/her name is \'Toledo, Junil A\''),
(4, 'zone', '::1', 'buhayko-PC', 'Oct-21-2021 08:07 PM', '\'Zone Leader\' does not Approve \'Toledo, Junil A\''),
(5, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:43 PM', '\'Admin\' will Add Official. \'CARLO JOHN A\''),
(6, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:43 PM', '\'Admin\' Deleted Official ID: \'16\''),
(7, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:51 PM', '\'Admin\' will Add Household No. \'22222\''),
(8, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:52 PM', '\'Admin\' will Add Household No. \'3333\''),
(9, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:53 PM', '\'Admin\' will Add Household No. \'44444\''),
(10, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 08:53 PM', '\'Admin\' Update Household No. \'44444\''),
(11, 'admin', '::1', 'buhayko-PC', 'Oct-21-2021 09:00 PM', '\'Admin\' will Add Beneficiaries Info. for \'Obal, Maria A\''),
(12, 'Obal, Maria A', '::1', 'buhayko-PC', 'Oct-21-2021 09:08 PM', 'The Beneficiarias member requested the SAP Form his/her name is \'Obal, Maria A\''),
(13, 'zone', '::1', 'buhayko-PC', 'Oct-21-2021 09:11 PM', '\'Zone Leader\' has already Approved \'Obal, Maria A\''),
(14, 'zone', '::1', 'buhayko-PC', 'Oct-21-2021 11:33 PM', '\'Zone Leader\' will Add Beneficiaries Info. for \'Toledo, Junil A\''),
(15, 'zone', '::1', 'buhayko-PC', 'Oct-21-2021 11:41 PM', '\'Zone Leader\' will Add Beneficiaries Info. for \'Obal, Maria T\''),
(16, 'Obal, Maria T', '::1', 'buhayko-PC', 'Oct-21-2021 11:43 PM', 'The Beneficiarias member requested the SAP Form his/her name is \'Obal, Maria T\''),
(17, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 08:28 PM', '\'Admin\' will Add Beneficiaries Info. for \'Orubia, Jen E\''),
(18, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 08:34 PM', '\'Admin\' will Add Beneficiaries Info. for \'Nario, Emil L\''),
(19, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 08:40 PM', '\'Admin\' will Add Beneficiaries Info. for \'Altarejos, Angelica C\''),
(20, 'Orubia, Jen E', '::1', 'buhayko-PC', 'Oct-23-2021 09:18 PM', 'The Beneficiarias member requested the SAP Form his/her name is \'Orubia, Jen E\''),
(21, 'zone', '::1', 'buhayko-PC', 'Oct-23-2021 09:19 PM', '\'Zone Leader\' has already Approved \'Obal, Maria T\''),
(22, 'zone', '::1', 'buhayko-PC', 'Oct-23-2021 09:20 PM', '\'Zone Leader\' does not Approve \'Orubia, Jen E\''),
(24, 'Orubia, Jen', '::1', 'buhayko-PC', 'Oct-23-2021 09:53 PM', '\'User\' added a comment to Contact Us whose name is Orubia, Jen'),
(25, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 11:20 PM', '\'Admin\' will Add Household No. \'77777\''),
(26, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 11:21 PM', '\'Admin\' Update Household No. \'77778\''),
(27, 'admin', '::1', 'buhayko-PC', 'Oct-23-2021 11:25 PM', '\'Admin\' will Add Household No. \'99999\'');

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

--
-- Table structure for table `tbl_beneficiaries`
--

CREATE TABLE `tbl_beneficiaries` (
  `beneficiaries_id` int(11) NOT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `middlename` varchar(255) DEFAULT NULL,
  `age` varchar(100) DEFAULT NULL,
  `birthdate` varchar(100) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `household_number` varchar(100) DEFAULT NULL,
  `birthplace` varchar(255) DEFAULT NULL,
  `differently_abledperson` varchar(255) DEFAULT NULL,
  `gcash_number` varchar(100) DEFAULT NULL,
  `blood_type` varchar(100) DEFAULT NULL,
  `purok_no` varchar(100) DEFAULT NULL,
  `civil_status` varchar(100) DEFAULT NULL,
  `total_householdmember` varchar(255) DEFAULT NULL,
  `religion` varchar(100) DEFAULT NULL,
  `occupation` varchar(100) DEFAULT NULL,
  `contact_number` varchar(50) DEFAULT NULL,
  `monthly_income` varchar(100) DEFAULT NULL,
  `educational_attainment` varchar(100) DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `philhealth_number` varchar(100) DEFAULT NULL,
  `skills` varchar(100) DEFAULT NULL,
  `water_usage` varchar(100) DEFAULT NULL,
  `land_ownershipstatus` varchar(100) DEFAULT NULL,
  `sektor` varchar(100) DEFAULT NULL,
  `benificiaries_of` varchar(100) DEFAULT NULL,
  `light_facilities` varchar(100) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `former_address` varchar(255) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `role` text DEFAULT NULL,
  `image_profile` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_beneficiaries`
--

INSERT INTO `tbl_beneficiaries` (`beneficiaries_id`, `lastname`, `firstname`, `middlename`, `age`, `birthdate`, `gender`, `household_number`, `birthplace`, `differently_abledperson`, `gcash_number`, `blood_type`, `purok_no`, `civil_status`, `total_householdmember`, `religion`, `occupation`, `contact_number`, `monthly_income`, `educational_attainment`, `nationality`, `philhealth_number`, `skills`, `water_usage`, `land_ownershipstatus`, `sektor`, `benificiaries_of`, `light_facilities`, `remark`, `former_address`, `username`, `password`, `role`, `image_profile`) VALUES
(1, 'toledo', 'junil', 'a', '32', '2021-10-05', 'Male', '1122', 'masbate', 'none', '09987978998', 'a', '2', 'Married', '3', 'catholic', 'freelance', '09797897897', '23000', 'Bachelors degree', 'filipino', '', 'programmer', 'Faucet', 'Landless', 'Prefer not to stay', 'UCT', 'Electric', 'Not Granted', 'Purok  maligaya 2 Mambugan Antipolo City', 'nel', 'a1Bz20ydqelm8m1wqlxIseQ0zV5fd00371820533da4391a56b59d8c94f921f945d', 'Member', 'uploads/anduin.png'),
(2, 'obal', 'maria', 't', '32', '2021-10-05', 'Female', '2233', 'camarines norte', 'none', '09646777770', 'a', '2', 'Married', '3', 'catholic', 'accounting', '09767657557', '260000', 'Bachelors degree', 'filipino', '', 'excel,bir', 'Faucet', 'Landless', 'Walang Tirahan', '4PS', 'Electric', 'Granted', 'Purok  maligaya 2 Mambugan Antipolo City', 'maria', 'a1Bz20ydqelm8m1wqlxIseQ0zVe21fc56c1a272b630e0d1439079d0598cf8b8329', 'Member', 'uploads/mercycute.jpg'),
(3, 'orubia', 'jen', 'e', '26', '2021-10-25', 'Female', '2555', 'laguna', 'none', '09868686778', 'b', '1', 'Legally Separated', '3', 'catholic', 'none', '09645646465', '0', 'Bachelors degree', 'filipino', '', 'excel', 'Faucet', 'Landless', 'Prefer not to stay', '4PS', 'Electric', 'Not Granted', 'francia antipolo city', 'jen', 'a1Bz20ydqelm8m1wqlxIseQ0zV261019afe158769f164bd424584a7ecf88a4a877', 'Member', 'uploads/tracer.png'),
(4, 'nario', 'emil', 'l', '59', '2021-10-12', 'Male', '1110', 'laguna', 'none', '0964444444', 'b', '3', 'Single', '4', 'catholic', 'encoder', '09897979790', '20000', 'College, graduate', 'filipino', '', 'encode', 'Faucet', 'Landless', 'Prefer not to stay', 'Prefer not to stay', 'Electric', 'Not Granted', 'francia antipolo city', 'nario', 'a1Bz20ydqelm8m1wqlxIseQ0zVbb320075a47d40ab258fa91041c5b87fd09c3562', 'Member', 'uploads/download.png'),
(5, 'altarejos', 'angelica', 'c', '35', '2022-10-23', 'Female', '6663', 'bulacan', 'none', '09536465477', 'o', '4', 'Legally Separated', '4', 'catholic', 'housewife', '09798797890', '0', 'College, undergrad', 'filipino', '', 'excel', 'Deep Well', 'Landless', 'None', 'Prefer not to stay', 'Electric', 'Not Granted', 'bukawe bulacan', 'angel', 'a1Bz20ydqelm8m1wqlxIseQ0zVedf360b3f9f25e1b43f3777db55c002035dcfe5c', 'Member', 'uploads/cutest-puppy-ever - Copy.jpg');

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

--
-- Table structure for table `tbl_contact`
--

CREATE TABLE `tbl_contact` (
  `contact_id` int(11) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact_number` varchar(50) DEFAULT NULL,
  `message` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contact`
--

INSERT INTO `tbl_contact` (`contact_id`, `first_name`, `last_name`, `email`, `contact_number`, `message`) VALUES
(1, 'junil', 'toledo', 'nel@gmail.com', '09978979878', 'sana po ma approve na ako'),
(2, 'Junil', 'Toledo', 'nel@gmail.com', '09897777777', 'sample message'),
(3, 'Junil', 'Toledo', 'nel@gmail.com', '09888888888', 'messsage'),
(4, 'Junil', 'Toledo', 'nel@gmail.com', '09666666666', 'message 2'),
(5, 'Jen', 'Orubia', 'jen@gmail.com', '09789879797', 'follow up ko lang po ang SAP'),
(6, 'Jen', 'Orubia', 'jen@gmail.com', '09789789999', 'follow up ko lang sa SAP');

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

--
-- Table structure for table `tbl_household`
--

CREATE TABLE `tbl_household` (
  `household_id` int(11) NOT NULL,
  `household_no` varchar(100) DEFAULT NULL,
  `purok_no` varchar(100) DEFAULT NULL,
  `total_membersofthefamily` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_household`
--

INSERT INTO `tbl_household` (`household_id`, `household_no`, `purok_no`, `total_membersofthefamily`) VALUES
(1, '22222', '1', '5'),
(2, '3333', '1', '7'),
(3, '44444', '3', '7'),
(4, '77778', '4', '4'),
(5, '99999', '3', '8');

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

--
-- Table structure for table `tbl_official`
--

CREATE TABLE `tbl_official` (
  `official_id` int(11) NOT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_official`
--

INSERT INTO `tbl_official` (`official_id`, `full_name`, `position`) VALUES
(1, 'ROMMEL E. CORDANO', 'Punong Barangay'),
(2, 'NELGEN G. DELA CRUZ', 'Chairman, Committee on Education and Agriculture'),
(3, 'BEINVENIDO R. MANALO.Sr.', 'Chairman, Committee on infrastructure'),
(4, 'MELINDA E. SIKAT', 'Chairman, Committee on Appropriation, Woman and Family, VAWC'),
(5, 'ANGELITO O. CALIXIHAN', 'Chairman, Committee on Peace & Order'),
(6, 'ROMEO M. QUINTO', 'Chairman, Committee on Social Services & Human Right'),
(7, 'NOEL B. EMRALINO', 'Chairman, Committee on Solid Waste, Vice-Chairman of Peace & Order '),
(8, 'LORELYN A. EMRALINO', 'Chairman, Committee on Health & Sanitation'),
(9, 'JAYVEE Y. ARBILO', 'SK Chairperson'),
(10, 'SHERMA M. MENDOZA', 'Barangay Secretary'),
(11, 'NANCYLITA Y. ARBILO', 'Barangay Treasurer'),
(12, 'GERENCIO A. COMENDADOR', 'Barangay Administrative Assistant'),
(13, 'MARY JOY E. CORDANO', 'Barangay Clerk');

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

--
-- Table structure for table `tbl_sapform`
--

CREATE TABLE `tbl_sapform` (
  `sapform_id` int(11) NOT NULL,
  `sapform_no` varchar(255) DEFAULT NULL,
  `beneficiaries_id` varchar(255) DEFAULT NULL,
  `purpose` varchar(255) DEFAULT NULL,
  `financial_serviceprovider` varchar(255) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `dateRecorded` datetime NOT NULL DEFAULT current_timestamp(),
  `recordedBy` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_sapform`
--

INSERT INTO `tbl_sapform` (`sapform_id`, `sapform_no`, `beneficiaries_id`, `purpose`, `financial_serviceprovider`, `status`, `dateRecorded`, `recordedBy`) VALUES
(1, '1111', '2', 'SAP', 'GCASH', 'Approve', '2021-10-21 23:43:56', 'zone'),
(2, NULL, '3', 'not accepted sorry', NULL, 'Disapprove', '2021-10-23 21:18:43', NULL);

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

--
-- Table structure for table `tbl_zoneleader`
--

CREATE TABLE `tbl_zoneleader` (
  `user_id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_zoneleader`
--

INSERT INTO `tbl_zoneleader` (`user_id`, `username`, `password`, `role`) VALUES
(1, 'zoneleader', 'a1Bz20ydqelm8m1wqlxIseQ0zV7d5db0b13c6a6b51a93afe22fb6d15f3cc597578', 'Zone Leader'),
(2, 'leader', 'a1Bz20ydqelm8m1wqlxIseQ0zV2745806ac18e2e95c0e5f359387f07eb16dce59a', 'Zone Leader'),
(3, 'zone', 'a1Bz20ydqelm8m1wqlxIseQ0zVb6931b00fd5c406edb24c0ed02274408e63555a0', 'Zone Leader');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `tbl_audittrail`
--
ALTER TABLE `tbl_audittrail`
  ADD PRIMARY KEY (`audittrail_id`);

--
-- Indexes for table `tbl_beneficiaries`
--
ALTER TABLE `tbl_beneficiaries`
  ADD PRIMARY KEY (`beneficiaries_id`);

--
-- Indexes for table `tbl_contact`
--
ALTER TABLE `tbl_contact`
  ADD PRIMARY KEY (`contact_id`);

--
-- Indexes for table `tbl_household`
--
ALTER TABLE `tbl_household`
  ADD PRIMARY KEY (`household_id`);

--
-- Indexes for table `tbl_official`
--
ALTER TABLE `tbl_official`
  ADD PRIMARY KEY (`official_id`);

--
-- Indexes for table `tbl_sapform`
--
ALTER TABLE `tbl_sapform`
  ADD PRIMARY KEY (`sapform_id`);

--
-- Indexes for table `tbl_zoneleader`
--
ALTER TABLE `tbl_zoneleader`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `tbl_audittrail`
--
ALTER TABLE `tbl_audittrail`
  MODIFY `audittrail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `tbl_beneficiaries`
--
ALTER TABLE `tbl_beneficiaries`
  MODIFY `beneficiaries_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `tbl_household`
--
ALTER TABLE `tbl_household`
  MODIFY `household_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_official`
--
ALTER TABLE `tbl_official`
  MODIFY `official_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `tbl_zoneleader`
--
ALTER TABLE `tbl_zoneleader`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
