CREATE TABLE IF NOT EXISTS `simul_usersmargins` (
  `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 ;

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 ;

CREATE TABLE IF NOT EXISTS `simul_users` (
  `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=28 ;

INSERT INTO `simul_usersmargins` (`id`,`hour`,`margin`)
VALUES
	(1,1,1),
	(2,2,1.1),
	(3,3,1.25),
	(4,4,1.25),
	(5,5,1.25),
	(6,6,1.25),
	(7,7,2.5),
	(8,8,2.5),
	(9,9,2.2),
	(10,10,2.2),
	(11,11,2.2),
	(12,12,2.2),
	(13,13,2.1),
	(14,14,2),
	(15,15,2.1),
	(16,16,2.1),
	(17,17,2.1),
	(29,23,0.2),
	(28,22,1),
	(27,21,1.5),
	(26,20,1.7),
	(25,19,1.8),
	(24,18,1.9),
	(30,24,0.1),
	(31,0,0.1);

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

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

SELECT * FROM 'simul_settings';