/*
SQLyog Enterprise - MySQL GUI v7.02 
MySQL - 5.0.51b-community-nt : Database - tcems
*********************************************************************
*/





CREATE DATABASE /*!32312 IF NOT EXISTS*/`tcems` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `tcems`;

/*Table structure for table `tbl_addrec` */


CREATE TABLE `tbl_addrec` (
  `Year` varchar(30) NOT NULL,
  `Month` varchar(30) NOT NULL,
  `Day` varchar(30) NOT NULL,
  `Prov` varchar(30) NOT NULL,
  `Mun` varchar(30) NOT NULL,
  `AccomId` varchar(30) NOT NULL,
  `AccomName` varchar(30) NOT NULL,
  `NumRooms` varchar(30) NOT NULL,
  `NumGuests` varchar(30) NOT NULL,
  `Nationality` varchar(500) NOT NULL,
  `RoomNum` varchar(30) NOT NULL,
  `DailyRate` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tbl_addrec` */

insert  into `tbl_addrec`(`Year`,`Month`,`Day`,`Prov`,`Mun`,`AccomId`,`AccomName`,`NumRooms`,`NumGuests`,`Nationality`,`RoomNum`,`DailyRate`) values ('2012','March','08','La Union','Agoo','AGRES-0001','VIlla-Remy-Xia-Resort','12','4','bru,','1','1500'),('2012','March','08','','','','','','','','','');

/*Data for the table `tblcurrentuser` */

/*Table structure for table `tblnationality` */


CREATE TABLE `tblnationality` (
  `Accom` varchar(20) default NULL,
  `Month` varchar(10) default NULL,
  `Year` varchar(10) default NULL,
  `Brunei` varchar(10) default NULL,
  `Cambodia` varchar(10) default NULL,
  `Indonesia` varchar(10) default NULL,
  `Laos` varchar(10) default NULL,
  `Malaysia` varchar(10) default NULL,
  `Myanmar` varchar(10) default NULL,
  `Singapore` varchar(10) default NULL,
  `Thailand` varchar(10) default NULL,
  `Vietnam` varchar(10) default NULL,
  `China` varchar(10) default NULL,
  `Hongkong` varchar(10) default NULL,
  `Japan` varchar(10) default NULL,
  `Korea` varchar(10) default NULL,
  `Taiwan` varchar(10) default NULL,
  `Bangladesh` varchar(10) default NULL,
  `India` varchar(10) default NULL,
  `Iran` varchar(10) default NULL,
  `Nepal` varchar(10) default NULL,
  `Pakistan` varchar(10) default NULL,
  `SriLanka` varchar(10) default NULL,
  `Bahrain` varchar(10) default NULL,
  `Egypt` varchar(10) default NULL,
  `Israel` varchar(10) default NULL,
  `Jordan` varchar(10) default NULL,
  `Kuwait` varchar(10) default NULL,
  `SaudiArabia` varchar(10) default NULL,
  `UAE` varchar(10) default NULL,
  `Canada` varchar(10) default NULL,
  `Mexico` varchar(10) default NULL,
  `USA` varchar(10) default NULL,
  `Argentina` varchar(10) default NULL,
  `Brazil` varchar(10) default NULL,
  `Colombia` varchar(10) default NULL,
  `Peru` varchar(10) default NULL,
  `Venezuela` varchar(10) default NULL,
  `Austria` varchar(10) default NULL,
  `Belgium` varchar(10) default NULL,
  `France` varchar(10) default NULL,
  `Germany` varchar(10) default NULL,
  `Luxembourg` varchar(10) default NULL,
  `Netherlands` varchar(10) default NULL,
  `Switzerland` varchar(10) default NULL,
  `Denmark` varchar(10) default NULL,
  `Finland` varchar(10) default NULL,
  `Ireland` varchar(10) default NULL,
  `Norway` varchar(10) default NULL,
  `Sweden` varchar(10) default NULL,
  `UK` varchar(10) default NULL,
  `Greece` varchar(10) default NULL,
  `Italy` varchar(10) default NULL,
  `Portugal` varchar(10) default NULL,
  `Spain` varchar(10) default NULL,
  `USAM` varchar(10) default NULL,
  `CIS` varchar(10) default NULL,
  `Poland` varchar(10) default NULL,
  `Russia` varchar(10) default NULL,
  `Australia` varchar(10) default NULL,
  `GUam` varchar(10) default NULL,
  `Nauru` varchar(10) default NULL,
  `NewZealand` varchar(10) default NULL,
  `Papua` varchar(10) default NULL,
  `Nigeria` varchar(10) default NULL,
  `SouthAfrica` varchar(10) default NULL,
  `Philippines` varchar(10) default NULL,
  `Philippines1` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tblnationality` */

insert  into `tblnationality`(`Accom`,`Month`,`Year`,`Brunei`,`Cambodia`,`Indonesia`,`Laos`,`Malaysia`,`Myanmar`,`Singapore`,`Thailand`,`Vietnam`,`China`,`Hongkong`,`Japan`,`Korea`,`Taiwan`,`Bangladesh`,`India`,`Iran`,`Nepal`,`Pakistan`,`SriLanka`,`Bahrain`,`Egypt`,`Israel`,`Jordan`,`Kuwait`,`SaudiArabia`,`UAE`,`Canada`,`Mexico`,`USA`,`Argentina`,`Brazil`,`Colombia`,`Peru`,`Venezuela`,`Austria`,`Belgium`,`France`,`Germany`,`Luxembourg`,`Netherlands`,`Switzerland`,`Denmark`,`Finland`,`Ireland`,`Norway`,`Sweden`,`UK`,`Greece`,`Italy`,`Portugal`,`Spain`,`USAM`,`CIS`,`Poland`,`Russia`,`Australia`,`GUam`,`Nauru`,`NewZealand`,`Papua`,`Nigeria`,`SouthAfrica`,`Philippines`,`Philippines1`) values ('AGRES-0001','March','2012','4','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');

/*Table structure for table `tblrooms` */


CREATE TABLE `tblrooms` (
  `Accom` varchar(30) default NULL,
  `roomnumber` varchar(30) default NULL,
  `Available` varchar(30) default NULL,
  `Month` varchar(20) default NULL,
  `Year` varchar(20) default NULL,
  `Day` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tblrooms` */

insert  into `tblrooms`(`Accom`,`roomnumber`,`Available`,`Month`,`Year`,`Day`) values ('AGRES-0001','1','not','March','2012','08'),('AGRES-0001','2','available','March','2012','08'),('AGRES-0001','4','available','March','2012','08');

