-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 05, 2016 at 03:18 AM
-- Server version: 5.6.26
-- PHP Version: 5.5.28

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

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

--
-- Table structure for table `tblcustomer`
--

CREATE TABLE IF NOT EXISTS `tblcustomer` (
  `CUSTOMERID` int(11) NOT NULL,
  `FNAME` varchar(90) NOT NULL,
  `LNAME` varchar(90) NOT NULL,
  `ADDRESS` varchar(90) NOT NULL,
  `CONTACT` varchar(30) NOT NULL,
  `EMAIL` varchar(90) NOT NULL,
  `USER_NAME` varchar(90) NOT NULL,
  `PASS` varchar(90) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblcustomer`
--

INSERT INTO `tblcustomer` (`CUSTOMERID`, `FNAME`, `LNAME`, `ADDRESS`, `CONTACT`, `EMAIL`, `USER_NAME`, `PASS`) VALUES
(61, 'Christian', 'Palomo', 'Tampalon', '09784639621', 'christianjpalomo@yahoo.com', 'cj', 'qwerty'),
(62, 'Eva', 'Delima', 'Camansi', '0949678324', 'eva@yahoo.com', 'eva', 'eva');

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

--
-- Table structure for table `tblgallery`
--

CREATE TABLE IF NOT EXISTS `tblgallery` (
  `ID` int(11) NOT NULL,
  `CATEGORY` varchar(30) NOT NULL,
  `CAPTION` varchar(30) NOT NULL,
  `LOCATION` varchar(125) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblgallery`
--

INSERT INTO `tblgallery` (`ID`, `CATEGORY`, `CAPTION`, `LOCATION`) VALUES
(1, 'Single', 'For Couple Room', 'img/couple.jpg'),
(7, 'Double', 'For lover room', 'img/double.jpg'),
(8, 'Suite', 'For single who want at peace', 'img/suite2.jpg'),
(9, 'Single', 'For Couple Room', 'img/couple1.jpg'),
(13, 'Single', 'For Couple Room', 'img/couple2.jpg'),
(14, 'Double', 'For lovers who want to enjoy t', 'img/duoble2.jpg'),
(15, 'Suite', 'For single who want at peace', 'img/suite1.jpg'),
(16, 'Double', 'For lovers who want to enjoy t', 'img/duoble1.jpg'),
(17, 'Suite', 'For single who want at peace', 'img/suite.jpg');

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

--
-- Table structure for table `tblpackage`
--

CREATE TABLE IF NOT EXISTS `tblpackage` (
  `PACKAGEID` int(11) NOT NULL,
  `PACKAGE` varchar(90) NOT NULL,
  `CATEGORY` varchar(90) NOT NULL,
  `PHOTOGRAPHER` varchar(90) NOT NULL,
  `PHOTOBOOK` varchar(90) NOT NULL,
  `MAXPHOTO` varchar(90) NOT NULL,
  `COVERAGE` varchar(90) NOT NULL,
  `ADDONS` varchar(90) NOT NULL,
  `PIC` varchar(255) NOT NULL,
  `PRICE` double NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblpackage`
--

INSERT INTO `tblpackage` (`PACKAGEID`, `PACKAGE`, `CATEGORY`, `PHOTOGRAPHER`, `PHOTOBOOK`, `MAXPHOTO`, `COVERAGE`, `ADDONS`, `PIC`, `PRICE`) VALUES
(18, 'Aircon and Fresh', 'Single', 'For couple', 'Adult: 2', 'Children: 2', 'Max Member: 6', '', 'img/couple.jpg', 5000),
(19, 'Fresh and Love', 'Single', 'For couple', 'Adult: 3', 'Childre: 3', 'Max Member: 8', '', 'img/couple1.jpg', 6000),
(20, 'Amaze and Glaze', 'Single', 'For couple', 'Adult: 5', 'Children: 5', 'Max Member: 12', '', 'img/couple2.jpg', 7800),
(21, 'Freely Love and Deepest Love', 'Double', 'For lovers ', 'Adult: 2', 'Children: 2', 'Max Member: 6', '', 'img/duoble2.jpg', 8000),
(22, 'Relationship and Harder Lover', 'Double', 'For lovers ', 'Adult: 3', 'Children: 3', 'Max Member: 8', '', 'img/duoble1.jpg', 9000),
(23, 'Tell me how deepest your love', 'Double', 'For lovers ', 'Adult: 4', 'Children: 4', 'Max Member: 10', '', 'img/double.jpg', 10000),
(24, 'Consume by asking no where ', 'Suite', 'For people want to lie their for a while', 'Adult: 2', 'Children: 2', 'Max Member: 6', '', 'img/suite.jpg', 12000),
(25, 'Even walk away they need', 'Suite', 'For set them free for broking pain', 'Adult: 4', 'Children: 4', 'Max Member: 10', '', 'img/suite1.jpg', 23000),
(26, 'We teke you home', 'Suite', 'for forever take you alone', 'Adult: 5', 'Children:5', 'Max Member: 15', '', 'img/suite2.jpg', 15500);

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

--
-- Table structure for table `tblreservation`
--

CREATE TABLE IF NOT EXISTS `tblreservation` (
  `RESERVEID` int(11) NOT NULL,
  `PACKAGEID` int(11) NOT NULL,
  `CUSTOMERID` int(11) NOT NULL,
  `ARRIVAL` date NOT NULL,
  `DEPARTURE` date NOT NULL,
  `STATUS` varchar(30) NOT NULL,
  `Child` int(25) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblreservation`
--

INSERT INTO `tblreservation` (`RESERVEID`, `PACKAGEID`, `CUSTOMERID`, `ARRIVAL`, `DEPARTURE`, `STATUS`, `Child`) VALUES
(119, 18, 61, '2016-02-03', '2016-02-03', 'Check Out', 0),
(120, 19, 61, '2016-02-03', '2016-02-03', 'Check Out', 0),
(121, 23, 62, '2016-02-03', '2016-02-04', 'Check Out', 0);

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

--
-- Table structure for table `tbluseraccount`
--

CREATE TABLE IF NOT EXISTS `tbluseraccount` (
  `USERID` int(11) NOT NULL,
  `UPIC` varchar(255) NOT NULL,
  `U_NAME` varchar(90) NOT NULL,
  `U_USERNAME` varchar(90) NOT NULL,
  `UPASS` varchar(90) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbluseraccount`
--

INSERT INTO `tbluseraccount` (`USERID`, `UPIC`, `U_NAME`, `U_USERNAME`, `UPASS`) VALUES
(13, 'img/df.jpg', 'CJP.', 'Palomo', 'x'),
(15, 'img/fhev.jpg', 'fhev', 'fhev', 'fhev'),
(16, 'img/11822575_1465763083748606_8576267109826965835_n.jpg', 'Victor', 'Palomo', 'palomo');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tblcustomer`
--
ALTER TABLE `tblcustomer`
  ADD PRIMARY KEY (`CUSTOMERID`);

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

--
-- Indexes for table `tblpackage`
--
ALTER TABLE `tblpackage`
  ADD PRIMARY KEY (`PACKAGEID`);

--
-- Indexes for table `tblreservation`
--
ALTER TABLE `tblreservation`
  ADD PRIMARY KEY (`RESERVEID`);

--
-- Indexes for table `tbluseraccount`
--
ALTER TABLE `tbluseraccount`
  ADD PRIMARY KEY (`USERID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tblcustomer`
--
ALTER TABLE `tblcustomer`
  MODIFY `CUSTOMERID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63;
--
-- AUTO_INCREMENT for table `tblgallery`
--
ALTER TABLE `tblgallery`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `tblpackage`
--
ALTER TABLE `tblpackage`
  MODIFY `PACKAGEID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `tblreservation`
--
ALTER TABLE `tblreservation`
  MODIFY `RESERVEID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=122;
--
-- AUTO_INCREMENT for table `tbluseraccount`
--
ALTER TABLE `tbluseraccount`
  MODIFY `USERID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
/*!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 */;
