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

CREATE TABLE IF NOT EXISTS `banner_image` (
  `ID` int(11) NOT NULL auto_increment,
  `Banner_ID` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Alt` varchar(255) default NULL,
  `Description` text,
  `Link` varchar(255) default NULL,
  `Show_Button` tinyint(1) NOT NULL default '0',
  `Button_Text` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Banner_ID` (`Banner_ID`),
  KEY `Order_By` (`Order_By`),
  KEY `Select` (`Banner_ID`,`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;