-- http://www.phpmyadmin.net
--




--
-- Database: `monbela`
--

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

--
-- Table structure for table `tblaccomodation`
--

CREATE TABLE IF NOT EXISTS `tblaccomodation` (
  `ACCOMID` int(11) NOT NULL AUTO_INCREMENT,
  `ACCOMODATION` varchar(30) NOT NULL,
  `ACCOMDESC` varchar(90) NOT NULL,
  PRIMARY KEY (`ACCOMID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `tblaccomodation`
--

INSERT INTO `tblaccomodation` (`ACCOMID`, `ACCOMODATION`, `ACCOMDESC`) VALUES
(12, 'Standard Room', 'max 22hrs.'),
(13, 'Travelers Time', 'max of 12hrs.'),
(15, 'Bayanihan Room', 'max 22hrs.');

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

--
-- Table structure for table `tblamenities`
--

CREATE TABLE IF NOT EXISTS `tblamenities` (
  `AMENID` int(11) NOT NULL AUTO_INCREMENT,
  `AMENNAME` varchar(125) NOT NULL,
  `AMENDECS` varchar(125) NOT NULL,
  `AMENIMAGE` varchar(255) NOT NULL,
  PRIMARY KEY (`AMENID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tblroom`
--

CREATE TABLE IF NOT EXISTS `tblroom` (
  `ROOMID` int(11) NOT NULL AUTO_INCREMENT,
  `ROOMNUM` int(11) NOT NULL,
  `ACCOMID` int(11) NOT NULL,
  `ROOM` varchar(30) NOT NULL,
  `ROOMDESC` varchar(255) NOT NULL,
  `NUMPERSON` int(11) NOT NULL,
  `PRICE` double NOT NULL,
  `ROOMIMAGE` varchar(255) NOT NULL,
  PRIMARY KEY (`ROOMID`),
  KEY `ACCOMID` (`ACCOMID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `tblroom`
--

INSERT INTO `tblroom` (`ROOMID`, `ROOMNUM`, `ACCOMID`, `ROOM`, `ROOMDESC`, `NUMPERSON`, `PRICE`, `ROOMIMAGE`) VALUES
(11, 3, 12, 'Wing A', 'without TV', 1, 615, 'rooms/Clash-of-Clans-Town-Hall-10-farm-walls.jpg'),
(12, 3, 12, 'Wing A', 'Without TV', 2, 725, 'rooms/Chrysanthemum.jpg'),
(13, 3, 13, 'Wing A', 'Without TV', 1, 445, 'rooms/Desert.jpg'),
(14, 4, 13, 'Wing A', 'Without TV', 2, 495, 'rooms/Desert.jpg'),
(15, 1, 15, 'Wing A', 'Without TV | for groups - minimum of 5 pax | 250php per person', 5, 1250, 'rooms/Hydrangeas.jpg'),
(16, 3, 12, 'Wing B & Ground Floor', 'With TV', 1, 725, 'rooms/Jellyfish.jpg'),
(17, 3, 12, 'Wing B & Ground Floor', 'With TV', 2, 835, 'rooms/Hydrangeas.jpg'),
(18, 3, 13, 'Wing B & Ground Floor', 'With TV', 1, 555, 'rooms/Jellyfish.jpg'),
(19, 3, 13, 'Wing B & Ground Floor', 'Without TV', 2, 605, 'rooms/Jellyfish.jpg'),
(20, 3, 12, 'Wing B & Ground Floor', 'Twin Beds with TV', 2, 845, 'rooms/Koala.jpg'),
(21, 3, 13, 'Wing B & Ground Floor', 'Twin Beds with TV', 2, 675, 'rooms/Lighthouse.jpg'),
(22, 3, 12, 'RM 223', 'With TV & Hot and Cold Shower', 2, 995, 'rooms/Sunset.jpg'),
(23, 3, 13, 'RM 223', 'With TV & Hot and Cold Shower', 2, 895, 'rooms/Tulips.jpg'),
(24, 3, 12, 'RM 224', '2 Beds with TV & Hot and Cold Shower', 2, 1650, 'rooms/Water lilies.jpg'),
(25, 3, 13, 'RM 224', '2 Beds with TV & Hot and Cold Shower', 2, 1430, 'rooms/Winter.jpg'),
(26, 3, 12, 'RM 111', '1 double & single bed with Hot and Cold Shower', 2, 1350, 'rooms/Winter.jpg'),
(27, 3, 13, 'RM 111', '1 double & single bed with Hot and Cold Shower', 2, 1100, 'rooms/Koala.jpg');

--
-- Constraints for table `tblroom`
--
ALTER TABLE `tblroom`
  ADD CONSTRAINT `tblroom_ibfk_1` FOREIGN KEY (`ACCOMID`) REFERENCES `tblaccomodation` (`ACCOMID`);
