CREATE TABLE IF NOT EXISTS `business_item` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Summary` text NOT NULL,
  `Featured` tinyint(1) NOT NULL default '0',
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `Content` text NOT NULL,
  `Subtitle` varchar(255) NOT NULL,
  `Button_Text` varchar(255) default NULL,
  `Button_URL` varchar(255) default NULL,
  `Published` tinyint(1) NOT NULL default '1', 
  `Gallery_ID` int(11) NOT NULL,
  `Banner_ID` int(11) NOT NULL,
  `Side_Banner_ID` int(11) NOT NULL,
  `Video_URL` varchar(255) NOT NULL,
  `New_Window` tinyint(1) NOT NULL default '0',
  `SEO_Title` varchar(255) NOT NULL,
  `SEO_Keywords` varchar(255) NOT NULL,
  `SEO_Description` varchar(255) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `business_item_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `business_item_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Business_Item_ID` int(11) default NULL,
  `Category_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;