DROP TABLE IF EXISTS `offers`;

CREATE TABLE `offers` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(20) default NULL,
  `product_id` int(11) default NULL,
  `unit_price` double default NULL,
  `title` varchar(255) default NULL,
  `offertype` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `offers` */

insert into `offers` (`id`,`code`,`product_id`,`unit_price`,`title`,`offertype`) values (9999,'ntgardens',1,3,'National Trust','all');

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;