   `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+
+/*Data for the table `ca_roomtype` */
+
+insert  into `ca_roomtype`(`id`,`typedesc`,`dptype`,`dpvalue`,`datecreated`,`createdbyid`,`datemodified`,`modifiedbyid`) values (1,'Cottages','',0,'2017-02-09 00:06:03',0,'2017-02-09 00:06:03',0),(2,'Rooms','',0,'2017-02-09 00:06:03',0,'2017-02-09 00:06:03',0),(3,'Villa','',0,'2017-02-09 00:06:03',0,'2017-02-09 00:06:03',0),(4,'Function Hall','',0,'2017-02-09 00:06:03',0,'2017-02-09 00:06:03',0);
 
 /*Table structure for table `ca_user_roles` */
 

  `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `ca_roomtype` */


  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ca_reservation` */

/*Table structure for table `ca_reservesetting` */

DROP TABLE IF EXISTS `ca_reservesetting`;
