CREATE TABLE IF NOT EXISTS `properties` (
`propid` int(11) NOT NULL auto_increment,
`propName` varchar(60) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `bookings` (
`bookid` int(11) NOT NULL auto_increment,
`startdate` date,
`enddate` date,
`propid` int(11) NOT NULL,
`booktype` int(11) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1; 