-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 13, 2025 at 06:14 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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

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

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `announcement_id` int(11) NOT NULL,
  `announcement_img` varchar(500) NOT NULL,
  `announcement_text` varchar(1000) NOT NULL,
  `announcement_venue` text NOT NULL,
  `announcement_date` varchar(20) NOT NULL,
  `to_date` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `date_announced` varchar(100) NOT NULL,
  `office/dept` varchar(255) NOT NULL,
  `profile_pic` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `campus` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` (`announcement_id`, `announcement_img`, `announcement_text`, `announcement_venue`, `announcement_date`, `to_date`, `description`, `date_announced`, `office/dept`, `profile_pic`, `full_name`, `campus`) VALUES
(28, 'vtine-day_759_td.jpg', 'Event: Valentine\'s Day', 'Venue: AVR', '2022-02-14', '2022-02-14', 'Valentine\'s Day, also called Saint Valentine\'s Day or the Feast of Saint Valentine, is celebrated annually on February 14.\r\nSignificance: In honor of one or two early Christian martyrs named Saint Valentine and, through later folk traditions, has become a significant cultural, religious, and commercial celebration of romance and love in many regions of the world.', '18-03-23 03:02:12 PM', 'Records Office', '1653875178img017.jpg', 'John Lloyd H Reyes', 'MBC'),
(32, 'General-Meeting.png', 'Event: Official General Meeting ', 'Venue: Virtual', '2023-05-07', '2023-05-08', 'To all officials Our company administration will be holding a virtual parent-teacher conference on March 30th, 2023. Please ensure that you have a stable internet connection and a device to participate. This is an excellent opportunity for you to discuss your students academic progress with their respective teachers.', '24-05-23 01:48:18 PM', 'Records Office', 'General-Meeting.png', 'John Lloyd H Reyes', 'MBC'),
(38, 'maxresdefault.jpg', 'Event: Health Protocol', 'Venue: N/A', '2023-01-01', '2023-01-31', 'Attention to all students: Due to the recent increase in COVID-19 cases, we urge everyone to strictly follow health protocols such as wearing face masks and face shields, practicing physical distancing, and avoiding unnecessary gatherings. Let us all do our part in preventing the spread of the virus and keeping our community safe.', '25-05-23 11:36:07 AM', '', '', '', ''),
(44, 'Chinese New Year.avif', 'Event: Chinese New Year', 'Venue: Pilar Covered Court', '2025-01-28', '2025-01-29', 'Etc.....', '26-01-25 02:52:11 PM', '', '', '', '');

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

--
-- Table structure for table `barangay_tb`
--

CREATE TABLE `barangay_tb` (
  `id` int(11) NOT NULL,
  `barangay_name` varchar(100) NOT NULL,
  `total_households` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `barangay_tb`
--

INSERT INTO `barangay_tb` (`id`, `barangay_name`, `total_households`) VALUES
(1, 'Abas', 271),
(2, 'Abucay', 604),
(3, 'Banuyo (Pob)', 782),
(4, 'Bayasong', 399),
(5, 'Binanuahan (Pob)', 409),
(6, 'Calongay', 403),
(7, 'Dao (Pob)', 535),
(8, 'Esperanza', 389),
(9, 'Guiron', 197),
(10, 'Mabanate', 404),
(11, 'Marifosque (Pob)', 537),
(12, 'Mercedes', 221),
(13, 'Putiao', 498),
(14, 'San Antonio (Sapa)', 634),
(15, 'San Jose', 271),
(16, 'Santa Fe', 504);

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

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

CREATE TABLE `complaints` (
  `ID` int(11) NOT NULL,
  `Last_Name` varchar(255) NOT NULL,
  `First_Name` varchar(255) NOT NULL,
  `Middle_Name` varchar(255) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Contact_Number` varchar(100) NOT NULL,
  `Category` varchar(255) NOT NULL,
  `Narration` text NOT NULL,
  `Status` varchar(255) NOT NULL,
  `Date_Submitted` varchar(255) NOT NULL,
  `TIme_Submitted` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `complaints` (`ID`, `Last_Name`, `First_Name`, `Middle_Name`, `Email`, `Contact_Number`, `Category`, `Narration`, `Status`, `Date_Submitted`, `TIme_Submitted`) VALUES
(20, 'Alamo', 'Dave', 'V', 'alamodhandavish@gmail.com', '09954470242', 'Water Quality Issues', 'There\'s a problem. Fix it ASAP!', 'Closed', 'January 26 2025', '02:58 PM'),
(19, 'Vergara', 'David', 'A', 'dhandavishalamo@gmail.com', '09954470141', 'Water Quality Issues', 'There\'s a problem. Please fix ASAP!', 'Closed', 'January 25 2025', '11:37 PM'),
(18, 'Alamo', 'Dhan ', 'V', 'davealamo14@gmail.com', '09123456677', 'Water Quality Issues', 'Fix this', 'Closed', 'November 21 2024', '02:40 PM');

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

--
-- Table structure for table `consumption_data`
--

CREATE TABLE `consumption_data` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `barangay` varchar(255) NOT NULL,
  `month` varchar(50) NOT NULL,
  `ttl_consumption` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `consumption_data`
--

INSERT INTO `consumption_data` (`id`, `username`, `full_name`, `barangay`, `month`, `ttl_consumption`) VALUES
(276, 'kaishavalbuena@gmail.com', 'Kaisha', 'Calongay', 'March', '2.5'),
(275, 'kaishavalbuena@gmail.com', 'Kaisha', 'Calongay', 'February', '3.4'),
(274, 'kaishavalbuena@gmail.com', 'Kaisha', 'Calongay', 'January', '10');

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

--
-- Table structure for table `core_values`
--

CREATE TABLE `core_values` (
  `ID` int(11) NOT NULL,
  `Philosophy` text NOT NULL,
  `Ten_Pillars` text NOT NULL,
  `Mandate` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `core_values`
--

INSERT INTO `core_values` (`ID`, `Philosophy`, `Ten_Pillars`, `Mandate`) VALUES
(1, 'Ang BARANGAY POBLACION I, sa patnugot ng Kagawaran ng Interyor at Pamahalaang Lokal - Rehiyon ng CALABARZON at Lungsod ng Batangas, ay isa sa mga napiling barangay upang isakatuparan ang pang-rehiyong implementasyon ng BGPMS. Inilahad ang mga alituntunin at proseso sa pagsasagot sa data capture forms ng BGPMS, gayundin ang score card na naglalaman ng pangkalahatang antas ng paglilingkod (over-all performance) sa pamamagitan ng paggamit ng isang simpleng computerized system at pagpapaloob ng Community-Based Monitoring System (CBMS)-Millenium Development Goal (MDG) human development index bilang parte ng pangkalahatang impormasyon ng barangay.', 'Ang Barangay Governance Performance Management System ay isang pansariling pagtatasa para sa barangay na sumusukat sa maayos na pagbibigay ng mga pangunahing serbisyo sa mga mamamayan at pagsunod sa mga iniaatas ng 1991 Kodigo ng Pamahalaang Lokal at iba pang mga batas. Nakapaloob dito ang mga Ulat Kabatiran ng Pamamahala (Reports Findings), kung saan tinutukoy ang isang masusing pagsusuri sa natamong rating ng barangay sa apat na aspeto (4) Gawaing Saklaw (Performance Areas): Sistema at Paraang Pampangasiwaan (Administrative Systems & Procedures); Serbisyong Panlipunan (Social Services); Kaunlarang Pang-Ekonomiya (Economic Development); at Kaunlarang Pang-Kapaligiran (Environmental Development).', 'Ang Barangay 1, dating tinatawag na Poblacion, ay isang barangay sa bayan ng Cuenca, sa lalawigan ng Batangas. Ayon sa talaan ng 2020 Census, ang populasyon nito ay 1,999. Ito ay nagrerepresenta ng 5.52% ng kabuuang populasyon ng Cuenca. Ang kabuuang populasyon ng sambahayan sa Barangay 1 ay 1,883 ayon sa 2015 Census na nahahati sa 435 sambahayan o kaya naman ay may average na 4.33 miyembro bawat sambahayan. The population of Barangay 1 grew from 897 in 1990 to 1,999 in 2020, an increase of 1,102 people over the course of 30 years. The latest census figures in 2020 denote a positive growth rate of 1.27%, or an increase of 116 people, from the previous population of 1,883 in 2015.');

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `ID` int(11) NOT NULL,
  `Departments` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`ID`, `Departments`) VALUES
(1, 'BSIT'),
(2, 'BSED');

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

--
-- Table structure for table `file_comment`
--

CREATE TABLE `file_comment` (
  `ID` int(11) NOT NULL,
  `Code` int(11) NOT NULL,
  `Profile_Picture` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Private_Comments` text NOT NULL,
  `Time` varchar(100) NOT NULL,
  `Date` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `file_request`
--

CREATE TABLE `file_request` (
  `ID` int(11) NOT NULL,
  `Last_Name` varchar(255) NOT NULL,
  `First_Name` varchar(255) NOT NULL,
  `Middle_Name` varchar(255) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Contact_Number` varchar(100) NOT NULL,
  `Document_Type` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Status` varchar(255) NOT NULL,
  `Date_Submitted` varchar(255) NOT NULL,
  `TIme_Submitted` varchar(255) NOT NULL,
  `File_Upload` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `uploaded_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `image_upload`
--

CREATE TABLE `image_upload` (
  `id` int(11) NOT NULL,
  `image` varchar(100) NOT NULL,
  `image_text` text NOT NULL,
  `date_posted` varchar(50) NOT NULL,
  `office/dept` varchar(100) NOT NULL,
  `campus` varchar(100) NOT NULL,
  `profile_pic` varchar(100) NOT NULL,
  `full_name` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `image_upload`
--

INSERT INTO `image_upload` (`id`, `image`, `image_text`, `date_posted`, `office/dept`, `campus`, `profile_pic`, `full_name`) VALUES
(63, '287711715_10167271488365713_8951643276123886044_n.png', 'Sa araw na ito ay ipinagdiriwang natin ang ika-isaandaan at dalawampu\'t apat na anibersaryo ng Araw ng Kalayaan. Mabuhay ang Pilipinas! ðŸ‡µðŸ‡­', '14-06-22 03:43:44 PM', 'Records Office', 'MBC', '281898304_1067111900852487_5805817302146542894_n.jpg', 'Mark Lester F Rabi');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `ID` int(11) NOT NULL,
  `Last_Name` varchar(100) NOT NULL,
  `First_Name` varchar(100) NOT NULL,
  `Middle_Initial` varchar(100) NOT NULL,
  `Contact_Number` varchar(100) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Profile_Picture` varchar(255) NOT NULL,
  `Usertype` varchar(100) NOT NULL,
  `Role` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `Account_Code` varchar(255) DEFAULT NULL,
  `Verified` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`ID`, `Last_Name`, `First_Name`, `Middle_Initial`, `Contact_Number`, `Email`, `Password`, `Profile_Picture`, `Usertype`, `Role`, `code`, `Account_Code`, `Verified`) VALUES
(33, 'ADMINISTRATOR', 'Admin', 'M', '09875362145', 'admin@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'admin.jpg', 'admin', '', '0', '', 1),
(75, 'Valbuena', 'Kaisha', 'M', '09101700746', 'kaishavalbuena@gmail.com', '25d55ad283aa400af464c76d713c07ad', '1749211192images (1).jpg', 'user', '', '', NULL, 0);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `date_created` datetime NOT NULL,
  `status` enum('read','unread') DEFAULT 'unread'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `email`, `title`, `message`, `date_created`, `status`) VALUES
(45, 'kaishavalbuena@gmail.com', 'test', 'tes1', '2025-06-06 14:10:28', 'read');

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

--
-- Table structure for table `notified_emails`
--

CREATE TABLE `notified_emails` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `month` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `notification_type` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notified_emails`
--

INSERT INTO `notified_emails` (`id`, `username`, `month`, `message`, `notification_type`, `created_at`) VALUES
(4, 'li.m.sevidal@gmail.com', 'January', 'Dear lithium, your water consumption for January is 10 cubic meters, which exceeds our recommended threshold. Please consider conserving water.', 'high_consumption', '2025-06-05 17:18:15'),
(6, 'kaishavalbuena@gmail.com', 'January', 'Dear Kaisha, your water consumption for January is 10 cubic meters, which exceeds our recommended threshold. Please consider conserving water.', 'high_consumption', '2025-06-06 12:10:57');

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

--
-- Table structure for table `private_comment`
--

CREATE TABLE `private_comment` (
  `ID` int(11) NOT NULL,
  `Code` int(11) NOT NULL,
  `Profile_Picture` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Private_Comments` text NOT NULL,
  `Time` varchar(100) NOT NULL,
  `Date` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `private_comment`
--

INSERT INTO `private_comment` (`ID`, `Code`, `Profile_Picture`, `Username`, `Private_Comments`, `Time`, `Date`) VALUES
(88, 14, 'admin.jpg', 'Administrator', 'Hello Mark!', '03:30 PM', 'Oct 07 2024'),
(89, 17, '1730574391Healthcare and Real Estate.png', 'Dhan  V Alamo', 'Any update?', '02:13 PM', 'Nov 21 2024'),
(90, 17, 'admin.jpg', 'Administrator', 'On-going', '02:13 PM', 'Nov 21 2024'),
(91, 18, '1730574391Healthcare and Real Estate.png', 'Dhan  V Alamo', 'Amy update?', '02:41 PM', 'Nov 21 2024'),
(92, 18, 'admin.jpg', 'Administrator', 'On-going', '02:43 PM', 'Nov 21 2024'),
(93, 19, 'admin.jpg', 'Administrator', 'Working on it', '11:39 PM', 'Jan 25 2025'),
(94, 19, '1737819378ALAMO, Dhan Davish V.png', 'David A Vergara', 'Thank you', '11:39 PM', 'Jan 25 2025'),
(95, 20, 'admin.jpg', 'Administrator', 'On it. ', '02:59 PM', 'Jan 26 2025');

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

--
-- Table structure for table `pump_forecast_data`
--

CREATE TABLE `pump_forecast_data` (
  `id` int(11) NOT NULL,
  `pump` int(11) NOT NULL,
  `barangays` varchar(255) NOT NULL,
  `total_supply` decimal(10,2) NOT NULL,
  `monthly_demand` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pump_forecast_data`
--

INSERT INTO `pump_forecast_data` (`id`, `pump`, `barangays`, `total_supply`, `monthly_demand`, `created_at`) VALUES
(1, 1, 'Brgy. 1', 50000.00, 3500.00, '2025-06-06 12:11:08'),
(2, 2, 'Brgy. 2', 50001.00, 3501.00, '2025-06-06 12:11:08'),
(3, 3, 'Brgy. 3', 50002.00, 3502.00, '2025-06-06 12:11:08'),
(4, 4, 'Brgy. 4', 50003.00, 3503.00, '2025-06-06 12:11:08'),
(5, 5, 'Brgy. 5', 50004.00, 3504.00, '2025-06-06 12:11:08'),
(6, 6, 'Brgy. 6', 50005.00, 3505.00, '2025-06-06 12:11:08');

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

--
-- Table structure for table `requirements`
--

CREATE TABLE `requirements` (
  `ID` int(11) NOT NULL,
  `Title` varchar(100) NOT NULL,
  `Instructions` text NOT NULL,
  `Due_Date` varchar(255) NOT NULL,
  `Due_Time` varchar(255) NOT NULL,
  `Attached_File` varchar(255) NOT NULL,
  `Date_Posted` varchar(100) NOT NULL,
  `Time_Posted` varchar(100) NOT NULL,
  `Department` varchar(255) NOT NULL,
  `Year` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `requirements`
--

INSERT INTO `requirements` (`ID`, `Title`, `Instructions`, `Due_Date`, `Due_Time`, `Attached_File`, `Date_Posted`, `Time_Posted`, `Department`, `Year`) VALUES
(70, 'Area 1 - Monthly Report', 'Please Pass your MR before deadline\r\nThank You!', '12-10-2022', '06:59 PM', 'Sample Docs.docx', '12-03-2022', '06:57 PM', 'BSIT', '2022');

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

--
-- Table structure for table `submitted_evaluation`
--

CREATE TABLE `submitted_evaluation` (
  `ID` int(11) NOT NULL,
  `Eval_ID` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Eval_Stat` varchar(255) NOT NULL,
  `Date_Submitted` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `submitted_evaluation`
--

INSERT INTO `submitted_evaluation` (`ID`, `Eval_ID`, `Email`, `Eval_Stat`, `Date_Submitted`) VALUES
(15, '10', 'marklesterrabi@gmail.com', '2', '05/26/2022'),
(16, '16', 'marklesterrabi123@gmail.com', '1', '06/07/2022');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `ID` int(11) NOT NULL,
  `Code` varchar(100) NOT NULL,
  `Assignment_Code` varchar(255) NOT NULL,
  `Profile_Picture` varchar(255) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `File_Link` varchar(255) NOT NULL,
  `File_Status` varchar(100) NOT NULL,
  `Date_Submitted` varchar(100) NOT NULL,
  `Time` varchar(100) NOT NULL,
  `Notif_Status` varchar(11) NOT NULL DEFAULT 'unread',
  `Department` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`ID`, `Code`, `Assignment_Code`, `Profile_Picture`, `Username`, `Email`, `File_Link`, `File_Status`, `Date_Submitted`, `Time`, `Notif_Status`, `Department`) VALUES
(60, '1', '70', 'j_profile.jpg', 'John Lloyd P. Cruz', 'johnlloydcruz@gmail.com', 'Monthy Report.docx', 'pending', '12/03/2022', '07:16 PM', 'read', 'BSIT');

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

--
-- Table structure for table `vm`
--

CREATE TABLE `vm` (
  `ID` int(11) NOT NULL,
  `Departments/Offices` varchar(255) NOT NULL,
  `Vision` text NOT NULL,
  `Mission` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vm`
--

INSERT INTO `vm` (`ID`, `Departments/Offices`, `Vision`, `Mission`) VALUES
(16, 'Poblacion 1', 'Pilar Water District envision to be an outstanding water district that provides excellent service to the community that serves through proper, adequate, and safe water supply and maintain to be financially stable and viable.', 'To provide safe, potable, adequate and affordable water to the most number of Pilareños and continuously improving the skills and well – being of our employees, to maintain a district responsive to the needs of our concessionaires and firmly focused on productivity.');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`announcement_id`);

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

--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `core_values`
--
ALTER TABLE `core_values`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `file_comment`
--
ALTER TABLE `file_comment`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `file_request`
--
ALTER TABLE `file_request`
  ADD PRIMARY KEY (`ID`);

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

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

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `notified_emails`
--
ALTER TABLE `notified_emails`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`,`month`,`notification_type`);

--
-- Indexes for table `private_comment`
--
ALTER TABLE `private_comment`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `requirements`
--
ALTER TABLE `requirements`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `submitted_evaluation`
--
ALTER TABLE `submitted_evaluation`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `vm`
--
ALTER TABLE `vm`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `announcement_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `file_comment`
--
ALTER TABLE `file_comment`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `file_request`
--
ALTER TABLE `file_request`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

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

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

--
-- AUTO_INCREMENT for table `private_comment`
--
ALTER TABLE `private_comment`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

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

--
-- AUTO_INCREMENT for table `requirements`
--
ALTER TABLE `requirements`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

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

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

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