DROP TABLE IF EXISTS `_forecast_sales`;
CREATE TABLE `_forecast_sales` (
  `_oid` int(11) NOT NULL auto_increment,
  `_typed_by` int(11) default NULL,
  `_product_oid` int(11) default NULL,
  `_year` date default NULL,
  `_validation_state` int(11) default NULL,
  PRIMARY KEY  (`_oid`),
  KEY `_product_oid` (`_product_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

INSERT INTO `_forecast_sales` (`_oid`,`_typed_by`,`_product_oid`,`_year`,`_validation_state`) VALUES 
 (26,3,2,'2010-01-01',1),
 (27,3,2,'2009-01-01',1),
 (28,3,2,'2008-01-01',2),
 (29,3,2,'2007-01-01',2),
 (30,3,2,'2006-01-01',0),
 (31,3,3,'2010-01-01',1),
 (32,3,3,'2009-01-01',1),
 (33,3,3,'2008-01-01',2),
 (34,3,3,'2007-01-01',2),
 (35,3,3,'2006-01-01',0),
 (36,3,11,'2010-01-01',1),
 (37,3,11,'2009-01-01',1),
 (38,3,11,'2008-01-01',2),
 (39,3,11,'2007-01-01',2),
 (40,3,11,'2006-01-01',0),
 (41,3,13,'2010-01-01',1),
 (42,3,13,'2009-01-01',1),
 (43,3,13,'2008-01-01',2),
 (44,3,13,'2007-01-01',2),
 (45,3,13,'2006-01-01',0),
 (46,3,18,'2010-01-01',1),
 (47,3,18,'2009-01-01',1),
 (48,3,18,'2008-01-01',2),
 (49,3,18,'2007-01-01',2),
 (50,3,18,'2006-01-01',0);


DROP TABLE IF EXISTS `_forecast_sales_per_month`;
CREATE TABLE `_forecast_sales_per_month` (
  `_oid` int(11) NOT NULL auto_increment,
  `_sheet_oid` int(11) default NULL,
  `_month` date default NULL,
  `_quantity` int(11) default NULL,
  PRIMARY KEY  (`_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `_forecast_sales_per_month` (`_oid`,`_sheet_oid`,`_month`,`_quantity`) VALUES 
 (1,26,'2010-02-01',326589),
 (2,26,'2010-04-01',326598),
 (3,26,'2010-07-01',326589),
 (4,36,'2010-08-01',236589),
 (5,36,'2010-01-01',326589),
 (6,36,'2010-06-01',215487);

DROP TABLE IF EXISTS `_numbers`;
CREATE TABLE `_numbers` (
  `_oid` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

INSERT INTO `_numbers` (`_oid`) VALUES 
 (1),
 (2),
 (3),
 (4),
 (5),
 (6),
 (7),
 (8),
 (9),
 (10),
 (11),
 (12);
