CREATE TABLE IF NOT EXISTS `simul_orders` (
  `id` int(11) NOT NULL auto_increment,
  `hour` int(11) default NULL,
  `value` float default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

INSERT INTO `simul_orders` (`id`,`hour`,`value`)
VALUES
	(1,0,37),
	(2,1,28),
	(3,2,12),
	(4,3,8),
	(5,4,2),
	(6,5,1),
	(7,6,1),
	(8,7,4),
	(9,8,8),
	(10,9,14),
	(11,10,15),
	(12,11,16),
	(13,12,17),
	(14,13,19),
	(15,14,22),
	(16,15,24),
	(17,16,25),
	(18,17,26),
	(19,18,27),
	(20,19,29),
	(21,20,33),
	(22,21,34),
	(23,22,35),
	(24,23,36),
	(25,24,37);

CREATE TABLE IF NOT EXISTS `simul_ordersmargins` (
  `id` int(11) NOT NULL auto_increment,
  `hour` int(11) default NULL,
  `margin` float default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

INSERT INTO `simul_ordersmargins` (`id`,`hour`,`margin`)
VALUES
	(1,1,0),
	(2,2,0),
	(3,3,0),
	(4,4,0),
	(5,5,0),
	(6,6,0),
	(7,7,0),
	(8,8,0.5),
	(9,9,0.7),
	(10,10,0.8),
	(11,11,1),
	(12,12,1.4),
	(13,13,1.5),
	(14,14,2),
	(15,15,2.4),
	(16,16,2.8),
	(17,17,3.1),
	(29,23,3.8),
	(28,22,3.8),
	(27,21,3.6),
	(26,20,3.4),
	(25,19,3.4),
	(24,18,3.3),
	(30,24,3.9),
	(31,0,4);

CREATE TABLE IF NOT EXISTS `simul_settings` (
  `id` int(11) NOT NULL auto_increment,
  `settingskey` varchar(255) default NULL,
  `settingsvalue` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=285 ;

INSERT INTO `simul_settings` (`id`, `settingskey`, `settingsvalue`) VALUES
(281, 'currenthourorders', '24'),
(282, 'currentcountorders', '3'),
(283, 'currenthourusers', '24'),
(284, 'currentcountusers', '2');

SELECT * FROM 'simul_settings';