INSERT INTO `gssim_results`.`user` (`id`, `dn`) VALUES
(1, 'irondn'),
(2, 'irondn2');

INSERT INTO `gssim_results`.`configuration` (`id`) VALUES
(2),
(3);

INSERT INTO `gssim_results`.`blob_property` (`config_id`, `name`, `value`) VALUES
(2, 'Network topology', 0x31320a526f757465725f50534e430a526f757465725f4345534e45540a526f757465725f44464e0a526f757465725f474152520a526f757465725f4b54480a526f757465725f4845414e65740a526f757465725f5357495443480a526f757465725f48554e4741524e45540a526f757465725f526564495249530a526f757465725f49324341540a526f757465725f4643434e0a526f757465725f47524e45540a31380a526f757465725f4b54480909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f4b54480909526f757465725f50534e430909310933303009313530303030300a526f757465725f50534e430909526f757465725f44464e0909310933303009313530303030300a526f757465725f50534e430909526f757465725f474152520909310933303009313530303030300a526f757465725f50534e430909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f474152520909310933303009313530303030300a526f757465725f44464e0909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f5357495443480909310933303009313530303030300a526f757465725f474152520909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f474152520909526f757465725f526564495249530909310933303009313530303030300a526f757465725f4345534e45540909526f757465725f47524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f48554e4741524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f526564495249530909310933303009313530303030300a526f757465725f48554e4741524e45540909526f757465725f5357495443480909310933303009313530303030300a526f757465725f526564495249530909526f757465725f49324341540909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4643434e0909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f5357495443480909526f757465725f4845414e65740909310933303009313530303030300a32300a50534e432d766e536572766572310909526f757465725f50534e430909310933303009313530303030300a50534e432d766e536572766572320909526f757465725f50534e430909310933303009313530303030300a50534e432d726f757465720909526f757465725f50534e430909310933303009313530303030300a4345534e45542d766e536572766572310909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d766e536572766572320909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d726f757465720909526f757465725f4345534e45540909310933303009313530303030300a44464e2d766e536572766572310909526f757465725f44464e0909310933303009313530303030300a44464e2d766e536572766572320909526f757465725f44464e0909310933303009313530303030300a44464e2d726f757465720909526f757465725f44464e0909310933303009313530303030300a474152522d766e536572766572310909526f757465725f474152520909310933303009313530303030300a474152522d766e536572766572320909526f757465725f474152520909310933303009313530303030300a474152522d726f757465720909526f757465725f474152520909310933303009313530303030300a4b54482d766e5365727665720909526f757465725f4b54480909310933303009313530303030300a4845414e65742d766e5365727665720909526f757465725f4845414e65740909310933303009313530303030300a5357495443482d766e5365727665720909526f757465725f5357495443480909310933303009313530303030300a48554e4741524e45542d766e5365727665720909526f757465725f48554e4741524e45540909310933303009313530303030300a526564495249532d766e5365727665720909526f757465725f526564495249530909310933303009313530303030300a49324341542d766e5365727665720909526f757465725f49324341540909310933303009313530303030300a4643434e2d766e5365727665720909526f757465725f4643434e0909310933303009313530303030300a47524e45542d766e5365727665720909526f757465725f47524e45540909310933303009313530303030300a310a42726f6b6572496e74657266616365456e7469747920526f757465725f50534e432031202020202033303020202020313530303030300a),
(3, 'Network topology', 0x2320746f74616c206e756d626572206f6620726f75746572730a32350a23206561636820726f75746572206e616d650a506f7a6e616e0a4764616e736b0a576172737a6177610a57726f636c61770a4b72616b6f770a4b6f737a616c696e0a537a637a6563696e0a476f727a6f77576c6b700a427964676f737a637a0a546f72756e0a4f6c737a74796e0a4269616c7973746f6b0a5a69656c6f6e61476f72610a4c6f647a0a5261646f6d0a50756c6177790a4c75626c696e0a4f706f6c650a437a6573746f63686f77610a476c69776963650a4b69656c63650a527a65737a6f770a4269656c736b6f4269616c610a4b61746f776963650a5a616d6f73630a0a2320746f74616c206e756d626572206f6620636f6e6e656374696f6e73206265747765656e20726f75746572730a33300a2320636f6e6e656374696f6e73206265747765656e20726f75746572730a4764616e736b204b6f737a616c696e2032302033303020313530303030300a4764616e736b204f6c737a74796e2032302033303020313530303030300a4f706f6c6520476c69776963652032302033303020313530303030300a4b6f737a616c696e20537a637a6563696e2032302033303020313530303030300a537a637a6563696e20476f727a6f77576c6b702032302033303020313530303030300a427964676f737a637a20546f72756e2032302033303020313530303030300a5261646f6d204b69656c63652032302033303020313530303030300a4269656c736b6f4269616c61204b72616b6f772032302033303020313530303030300a506f7a6e616e20576172737a6177612032302033303020313530303030300a4f6c737a74796e204269616c7973746f6b20312036303020313530303030300a4b69656c6365204b72616b6f772032302033303020313530303030300a476c6977696365204b61746f776963652032302033303020313530303030300a57726f636c6177204f706f6c652032302033303020313530303030300a437a6573746f63686f7761204c6f647a2032302033303020313530303030300a527a65737a6f77204b72616b6f7720312036303020313530303030300a4c75626c696e205a616d6f73632032302033303020313530303030300a437a6573746f63686f7761204b61746f776963652032302033303020313530303030300a506f7a6e616e205a69656c6f6e61476f72612032302033303020313530303030300a576172737a617761204269616c7973746f6b2032302033303020313530303030300a546f72756e204764616e736b2032302033303020313530303030300a427964676f737a637a20506f7a6e616e2032302033303020313530303030300a506f7a6e616e20476f727a6f77576c6b702032302033303020313530303030300a4c6f647a20576172737a6177612032302033303020313530303030300a5261646f6d20576172737a6177612032302033303020313530303030300a50756c617779205261646f6d2032302033303020313530303030300a50756c617779204c75626c696e2032302033303020313530303030300a527a65737a6f77205a616d6f73632032302033303020313530303030300a4c6f647a20506f7a6e616e2032302033303020313530303030300a5a69656c6f6e61476f72612057726f636c61772032302033303020313530303030300a4269656c736b6f4269616c6120476c69776963652032302033303020313530303030300a0a2320746f74616c206e756d626572206f66207265736f75726365730a350a2320636f6e6e656374696f6e73206265747765656e207265736f7572636520616e6420726f757465720a5043535320506f7a6e616e2032302031303020313530303030300a574353532057726f636c61772032302031303020313530303030300a437966726f6e6574204b72616b6f772032302031303020313530303030300a43495441534b204764616e736b2032302031303020313530303030300a49434d20576172737a6177612032302031303020313530303030300a0a2320746f74616c206e756d626572206f662075736572730a310a2320636f6e6e656374696f6e206265747765656e207573657220616e6420726f757465720a42726f6b6572496e74657266616365456e74697479205a69656c6f6e61476f72612032302032303020313530303030300a);

INSERT INTO `gssim_results`.`text_property` (`config_id`, `name`, `value`) VALUES
(2, 'Grid scheduling', 'GridschedulingFCFSSR'),
(2, 'Local grid scheduling', 'FCFSAllocPolicy'),
(2, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'),
(3, 'Grid scheduling', 'GridschedulingARFCFS'),
(3, 'Local grid scheduling', 'LocalGridPluginAR'),
(3, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl');

INSERT INTO `gssim_results`.`experiment` (`PK`, `user_id`, `config_id`, `commission_date`, `name`, `description`, `status`, `metaexp_id`) VALUES
(2, 1, 2, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL),
(3, 2, 3, NULL, 'exp1', 'exp1 desc', 'RUNNING', NULL),
(4, 1, 2, NULL, 'exp1', 'exp1 desc', 'FAILED', NULL),
(5, 2, 3, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL);


INSERT INTO `gssim_results`.`experiment_stats` (`id`, `name`, `value`) VALUES
('2', 'Delayed tasks', '0'),
('2', 'Failed requests (tasks)', '0'),
('2', 'Makespan', '57600'),
('2', 'Resources queue length', '0.531'),
('2', 'Resources total load', '0.49'),
('2', 'Resources reservation load', '0.49'),
('2', 'Energy usage', '1.312'),
('2', 'Task completion time', '29630.769'),
('2', 'Task execution time', '13015.385'),
('2', 'Task start time', '6092.308'),
('2', 'Task flow time', '13015.385'),
('2', 'Task waiting time', '6092.308'),
('2', 'Task lateness', '0'),
('2', 'Task tardiness', '0'),
('3', 'Delayed tasks', '0'),
('3', 'Failed requests (tasks)', '0'),
('2', 'Makespan', '57600'),
('3', 'Resources queue length', '0.687'),
('3', 'Resources total load', '0.49'),
('3', 'Resources reservation load', '0.49'),
('3', 'Energy usage', '1.375'),
('3', 'Task completion time', '29630.769'),
('3', 'Task execution time', '13015.385'),
('3', 'Task start time', '6092.308'),
('3', 'Task flow time', '13015.385'),
('3', 'Task waiting time', '6092.308'),
('3', 'Task lateness', '0'),
('3', 'Task tardiness', '0'),
('4', 'Delayed tasks', '0'),
('4', 'Failed requests (tasks)', '0'),
('4', 'Makespan', '32400'),
('4', 'Resources queue length', '0.389'),
('4', 'Resources total load', '0.175'),
('4', 'Resources reservation load', '0.183'),
('4', 'Energy usage', '0.238'),
('4', 'Task completion time', '23398.8'),
('4', 'Task execution time', '7920'),
('4', 'Task start time', '15478.8'),
('4', 'Task flow time', '8278.8'),
('4', 'Task waiting time', '15477.6'),
('4', 'Task lateness', '-1.2'),
('4', 'Task tardiness', '0'),
('5', 'Delayed tasks', '0'),
('5', 'Failed requests (tasks)', '0'),
('2', 'Makespan', '61042'),
('5', 'Resources queue length', '0.393'),
('5', 'Resources total load', '0.286'),
('5', 'Resources reservation load', '0.345'),
('5', 'Energy usage', '0.756'),
('5', 'Task completion time', '40059.143'),
('5', 'Task execution time', '17485.714'),
('5', 'Task start time', '3030.571'),
('5', 'Task flow time', '20516.286'),
('5', 'Task waiting time', '3029.571'),
('5', 'Task lateness', '-569.429'),
('5', 'Task tardiness', '0');

INSERT INTO `gssim_results`.`task` (`PK`, `exp_id`, `job_id`,  `exec_start_date`, `exec_finish_date`, `exec_end_date`, `completion_time`, `execution_time`, `start_time`, `flow_time`, `waiting_time`, `gq_waiting_time`, `lateness`, `tardiness`, `makespan`) VALUES 
('20', '2', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'),
('21', '2', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'),
('210', '2', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'),
('211', '2', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'),
('212', '2', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'),
('213', '2', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'),
('214', '2', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'),
('215', '2', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'),
('216', '2', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'),
('22', '2', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'),
('23', '2', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'),
('24', '2', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'),
('25', '2', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'),
('30', '3', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'),
('31', '3', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'),
('310', '3', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'),
('311', '3', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'),
('312', '3', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'),
('313', '3', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'),
('314', '3', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'),
('315', '3', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'),
('316', '3', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'),
('32', '3', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'),
('33', '3', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'),
('34', '3', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'),
('35', '3', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'),
('41', '4', '1', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), '8994', '7200', '1794', '8994', '1793', '1', '0', '-6', '8994'),
('43', '4', '3', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14399', '1', '0', '0', '21600'),
('44', '4', '4', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '17999', '1', '0', '0', '25200'),
('45', '4', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21599', '1', '0', '0', '28800'),
('46', '4', '6', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21598', '2', '0', '0', '32400'),
('50', '5', '0', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), '17922', '14400', '3522', '17922', '3521', '1', '0', '-78', '17922'),
('51', '5', '1', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), '28802', '28800', '2', '28802', '1', '1', '0', '-3598', '28802'),
('52', '5', '2', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), '14386', '7200', '3586', '10786', '3585', '1', '0', '-14', '14386'),
('53', '5', '3', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), '46786', '21600', '3586', '25186', '3585', '1', '0', '-14', '46786'),
('54', '5', '4', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), '53970', '25200', '3570', '28770', '3569', '1', '0', '-30', '53970'),
('55', '5', '5', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), '57506', '14400', '3506', '17906', '3505', '1', '0', '-94', '57506'),
('56', '5', '6', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), '61042', '10800', '3442', '14242', '3441', '1', '0', '-158', '61042');

INSERT INTO `gssim_results`.`task` (`PK`, `exp_id`, `job_id`, `task_id`, `parent_id`, `exec_start_date`, `exec_finish_date`, `exec_end_date`, `gb_submit_date`, `lb_submit_date`, `completion_time`, `exec_start_time`, `execution_time`, `ready_time`, `start_time`, `flow_time`, `waiting_time`, `gq_waiting_time`, `lateness`, `tardiness`) VALUES
('2000', '2', '0', '0', '20', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '7200', '0', '7200', '0', '0', '7200', '0', '0', '0', '0'),
('2100', '2', '1', '0', '21', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '10800', '3600', '7200', '3600', '3600', '7200', '3600', '0', '0', '0'),
('21000', '2', '10', '0', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '14400', '0', '14400', '0', '0', '14400', '0', '0', '0', '0'),
('21100', '2', '11', '0', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '0', '28800', '0', '0', '28800', '0', '0', '0', '0'),
('21200', '2', '12', '0', '212', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670400), '10800', '3600', '7200', '3600', '0', '7200', '0', '0', '0', '0'),
('21300', '2', '13', '0', '213', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '43200', '21600', '21600', '21600', '0', '21600', '0', '0', '0', '0'),
('21400', '2', '14', '0', '214', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '50400', '25200', '25200', '25200', '0', '25200', '0', '0', '0', '0'),
('21500', '2', '15', '0', '215', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706400), '54000', '39600', '14400', '39600', '0', '14400', '0', '0', '0', '0'),
('21600', '2', '16', '0', '216', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713600), '57600', '46800', '10800', '46800', '0', '10800', '0', '0', '0', '0'),
('2200', '2', '2', '0', '22', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '21600', '14400', '7200', '14400', '14400', '7200', '14400', '0', '0', '0'),
('2300', '2', '3', '0', '23', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '25200', '18000', '7200', '18000', '18000', '7200', '18000', '0', '0', '0'),
('2400', '2', '4', '0', '24', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '21600', '7200', '21600', '21600', '7200', '21600', '0', '0', '0'),
('2500', '2', '5', '0', '25', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '32400', '21600', '10800', '21600', '21600', '10800', '21600', '0', '0', '0'),
('3000', '3', '0', '0', '30', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '7200', '0', '7200', '0', '0', '7200', '0', '0', '0', '0'),
('3100', '3', '1', '0', '31', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '10800', '3600', '7200', '3600', '3600', '7200', '3600', '0', '0', '0'),
('31000', '3', '10', '0', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '14400', '0', '14400', '0', '0', '14400', '0', '0', '0', '0'),
('31100', '3', '11', '0', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '0', '28800', '0', '0', '28800', '0', '0', '0', '0'),
('31200', '3', '12', '0', '312', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670400), '10800', '3600', '7200', '3600', '0', '7200', '0', '0', '0', '0'),
('31300', '3', '13', '0', '313', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '43200', '21600', '21600', '21600', '0', '21600', '0', '0', '0', '0'),
('31400', '3', '14', '0', '314', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '50400', '25200', '25200', '25200', '0', '25200', '0', '0', '0', '0'),
('31500', '3', '15', '0', '315', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706400), '54000', '39600', '14400', '39600', '0', '14400', '0', '0', '0', '0'),
('31600', '3', '16', '0', '316', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713600), '57600', '46800', '10800', '46800', '0', '10800', '0', '0', '0', '0'),
('3200', '3', '2', '0', '32', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '21600', '14400', '7200', '14400', '14400', '7200', '14400', '0', '0', '0'),
('3300', '3', '3', '0', '33', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '25200', '18000', '7200', '18000', '18000', '7200', '18000', '0', '0', '0'),
('3400', '3', '4', '0', '34', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '21600', '7200', '21600', '21600', '7200', '21600', '0', '0', '0'),
('3500', '3', '5', '0', '35', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '32400', '21600', '10800', '21600', '21600', '10800', '21600', '0', '0', '0'),
('4100', '4', '1', '0', '41', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '8994', '1794', '7200', '0', '1794', '8994', '1793', '1', '-6', '0'),
('4300', '4', '3', '0', '43', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '21600', '14400', '7200', '14400', '14400', '7200', '14399', '1', '0', '0'),
('4400', '4', '4', '0', '44', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '25200', '18000', '7200', '18000', '18000', '7200', '17999', '1', '0', '0'),
('4500', '4', '5', '0', '45', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '28800', '21600', '7200', '21600', '21600', '7200', '21599', '1', '0', '0'),
('4600', '4', '6', '0', '46', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666802), '32400', '21600', '10800', '21600', '21600', '10800', '21598', '2', '0', '0'),
('5000', '5', '0', '0', '50', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '17922', '3522', '14400', '0', '3522', '17922', '3521', '1', '-78', '0'),
('5100', '5', '1', '0', '51', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '28802', '2', '28800', '0', '2', '28802', '1', '1', '-3598', '0'),
('5200', '5', '2', '0', '52', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670401), '14386', '7186', '7200', '3600', '3586', '10786', '3585', '1', '-14', '0'),
('5300', '5', '3', '0', '53', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688401), '46786', '25186', '21600', '21600', '3586', '25186', '3585', '1', '-14', '0'),
('5400', '5', '4', '0', '54', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692001), '53970', '28770', '25200', '25200', '3570', '28770', '3569', '1', '-30', '0'),
('5500', '5', '5', '0', '55', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706401), '57506', '43106', '14400', '39600', '3506', '17906', '3505', '1', '-94', '0'),
('5600', '5', '6', '0', '56', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713601), '61042', '50242', '10800', '46800', '3442', '14242', '3441', '1', '-158', '0');

INSERT INTO `gssim_results`.`resource` (`PK`, `exp_id`, `name`, `type`, `allocation_load`, `reservation_load`) VALUES
('21', '2', 'compRes1', 'computing', '0.604', '0.604'),
('22', '2', 'compRes2', 'computing', '0.375', '0.375'),
('31', '3', 'compRes1', 'computing', '0.646', '0.646'),
('32', '3', 'compRes2', 'computing', '0.333', '0.333'),
('41', '4', 'compRes1', 'computing', '0.185', '0.185'),
('42', '4', 'compRes2', 'computing', '0.222', '0.241'),
('43', '4', 'dataRes1', 'data', '0', '0'),
('44', '4', 'networkRes1', 'network', '0.438', '0.438'),
('51', '5', 'compRes1', 'computing', '0.451', '0.549'),
('52', '5', 'compRes2', 'computing', '0.216', '0.255'),
('53', '5', 'dataRes1', 'data', '0', '0'),
('54', '5', 'networkRes1', 'network', '0.562', '0.562');

INSERT INTO `gssim_results`.`queues` (`fk_resource_id`, `name`, `avg_length`)
VALUES ('21', 'default', '0.437'),						
('22', 'default', '0.625'),						
('31', 'default', '1'),						
('32', 'default', '0.375'),						
('41', 'default', '0.667'),						
('42', 'default', '0.5'),						
('43', 'default', '0'),						
('51', 'default', '0.414'),						
('52', 'default', '0.765'),						
('53', 'default', '0');					


INSERT INTO `gssim_results`.`resource_allocation_timeline` (`fk_resource_id`, `timestamp`, `usage`)
VALUES ('21', FROM_UNIXTIME(1225666800), '2'),							
('21', FROM_UNIXTIME(1225674000), '1'),							
('21', FROM_UNIXTIME(1225681200), '0'),							
('21', FROM_UNIXTIME(1225688400), '2'),							
('21', FROM_UNIXTIME(1225692000), '3'),							
('21', FROM_UNIXTIME(1225699200), '2'),							
('21', FROM_UNIXTIME(1225706400), '3'),							
('21', FROM_UNIXTIME(1225710000), '2'),							
('21', FROM_UNIXTIME(1225713600), '3'),							
('21', FROM_UNIXTIME(1225717200), '2'),							
('21', FROM_UNIXTIME(1225720800), '1'),							
('21', FROM_UNIXTIME(1225724400), '0'),							
('22', FROM_UNIXTIME(1225666800), '1'),							
('22', FROM_UNIXTIME(1225670400), '3'),							
('22', FROM_UNIXTIME(1225677600), '1'),							
('22', FROM_UNIXTIME(1225681200), '2'),							
('22', FROM_UNIXTIME(1225684800), '3'),							
('22', FROM_UNIXTIME(1225688400), '3'),							
('22', FROM_UNIXTIME(1225692000), '2'),							
('22', FROM_UNIXTIME(1225695600), '0'),							
('31', FROM_UNIXTIME(1225666800), '3'),							
('31', FROM_UNIXTIME(1225674000), '2'),							
('31', FROM_UNIXTIME(1225681200), '2'),							
('31', FROM_UNIXTIME(1225684800), '3'),							
('31', FROM_UNIXTIME(1225688400), '3'),							
('31', FROM_UNIXTIME(1225692000), '3'),							
('31', FROM_UNIXTIME(1225695600), '2'),							
('31', FROM_UNIXTIME(1225699200), '1'),							
('31', FROM_UNIXTIME(1225713600), '2'),							
('31', FROM_UNIXTIME(1225717200), '1'),							
('31', FROM_UNIXTIME(1225724400), '0'),							
('32', FROM_UNIXTIME(1225666800), '0'),							
('32', FROM_UNIXTIME(1225670400), '2'),							
('32', FROM_UNIXTIME(1225677600), '0'),							
('32', FROM_UNIXTIME(1225688400), '2'),							
('32', FROM_UNIXTIME(1225695600), '1'),							
('32', FROM_UNIXTIME(1225706400), '2'),							
('32', FROM_UNIXTIME(1225710000), '1'),							
('32', FROM_UNIXTIME(1225720800), '0'),							
('41', FROM_UNIXTIME(1225666800), '0'),							
('41', FROM_UNIXTIME(1225688400), '2'),							
('41', FROM_UNIXTIME(1225695600), '1'),							
('41', FROM_UNIXTIME(1225699200), '0'),							
('42', FROM_UNIXTIME(1225666800), '0'),							
('42', FROM_UNIXTIME(1225668594), '1'),							
('42', FROM_UNIXTIME(1225675794), '0'),							
('42', FROM_UNIXTIME(1225681200), '1'),							
('42', FROM_UNIXTIME(1225684800), '2'),							
('42', FROM_UNIXTIME(1225688400), '1'),							
('42', FROM_UNIXTIME(1225692000), '0'),							
('43', FROM_UNIXTIME(1225666800), '0'),						
('51', FROM_UNIXTIME(1225666800), '0'),							
('51', FROM_UNIXTIME(1225670322), '1'),							
('51', FROM_UNIXTIME(1225673986), '2'),							
('51', FROM_UNIXTIME(1225681186), '1'),							
('51', FROM_UNIXTIME(1225684722), '0'),							
('51', FROM_UNIXTIME(1225691986), '1'),							
('51', FROM_UNIXTIME(1225695570), '2'),							
('51', FROM_UNIXTIME(1225709906), '3'),							
('51', FROM_UNIXTIME(1225713586), '2'),							
('51', FROM_UNIXTIME(1225720770), '1'),							
('51', FROM_UNIXTIME(1225724306), '0'),						
('52', FROM_UNIXTIME(1225666800), '0'),							
('52', FROM_UNIXTIME(1225666802), '1'),							
('52', FROM_UNIXTIME(1225695602), '0'),							
('52', FROM_UNIXTIME(1225717042), '1'),							
('52', FROM_UNIXTIME(1225727842), '0'),							
('53', FROM_UNIXTIME(1225666800), '0');

INSERT INTO `gssim_results`.`resource_energy_timeline` (`fk_resource_id`, `timestamp`, `usage`)
VALUES ('21', FROM_UNIXTIME(1225666800), '2'),							
('21', FROM_UNIXTIME(1225674000), '1'),							
('21', FROM_UNIXTIME(1225681200), '0'),							
('21', FROM_UNIXTIME(1225688400), '2'),							
('21', FROM_UNIXTIME(1225692000), '3'),							
('21', FROM_UNIXTIME(1225699200), '2'),							
('21', FROM_UNIXTIME(1225706400), '3'),							
('21', FROM_UNIXTIME(1225710000), '2'),							
('21', FROM_UNIXTIME(1225713600), '3'),							
('21', FROM_UNIXTIME(1225717200), '2'),							
('21', FROM_UNIXTIME(1225720800), '1'),							
('21', FROM_UNIXTIME(1225724400), '0'),													
('22', FROM_UNIXTIME(1225666800), '1'),							
('22', FROM_UNIXTIME(1225670400), '3'),							
('22', FROM_UNIXTIME(1225677600), '1'),							
('22', FROM_UNIXTIME(1225681200), '2'),							
('22', FROM_UNIXTIME(1225684800), '3'),							
('22', FROM_UNIXTIME(1225688400), '3'),							
('22', FROM_UNIXTIME(1225692000), '2'),							
('22', FROM_UNIXTIME(1225695600), '0'),												
('31', FROM_UNIXTIME(1225666800), '3'),							
('31', FROM_UNIXTIME(1225674000), '2'),							
('31', FROM_UNIXTIME(1225681200), '2'),							
('31', FROM_UNIXTIME(1225684800), '3'),							
('31', FROM_UNIXTIME(1225688400), '3'),							
('31', FROM_UNIXTIME(1225692000), '3'),							
('31', FROM_UNIXTIME(1225695600), '2'),							
('31', FROM_UNIXTIME(1225699200), '1'),							
('31', FROM_UNIXTIME(1225713600), '2'),							
('31', FROM_UNIXTIME(1225717200), '1'),							
('31', FROM_UNIXTIME(1225724400), '0'),													
('32', FROM_UNIXTIME(1225670400), '2'),							
('32', FROM_UNIXTIME(1225677600), '0'),							
('32', FROM_UNIXTIME(1225688400), '2'),							
('32', FROM_UNIXTIME(1225695600), '1'),							
('32', FROM_UNIXTIME(1225706400), '2'),							
('32', FROM_UNIXTIME(1225710000), '1'),							
('32', FROM_UNIXTIME(1225720800), '0'),							
('41', FROM_UNIXTIME(1225688400), '2'),							
('41', FROM_UNIXTIME(1225695600), '1'),							
('41', FROM_UNIXTIME(1225699200), '0'),											
('42', FROM_UNIXTIME(1225668594), '1'),							
('42', FROM_UNIXTIME(1225675794), '0'),							
('42', FROM_UNIXTIME(1225681200), '0'),							
('42', FROM_UNIXTIME(1225684800), '2'),							
('42', FROM_UNIXTIME(1225688400), '1'),							
('42', FROM_UNIXTIME(1225692000), '0'),							
('51', FROM_UNIXTIME(1225670322), '1'),							
('51', FROM_UNIXTIME(1225673986), '2'),							
('51', FROM_UNIXTIME(1225681186), '1'),							
('51', FROM_UNIXTIME(1225684722), '0'),							
('51', FROM_UNIXTIME(1225691986), '1'),							
('51', FROM_UNIXTIME(1225695570), '2'),							
('51', FROM_UNIXTIME(1225709906), '3'),							
('51', FROM_UNIXTIME(1225713586), '2'),							
('51', FROM_UNIXTIME(1225720770), '1'),							
('51', FROM_UNIXTIME(1225724306), '0'),							
('52', FROM_UNIXTIME(1225666802), '1'),							
('52', FROM_UNIXTIME(1225695602), '0'),							
('52', FROM_UNIXTIME(1225717042), '1'),							
('52', FROM_UNIXTIME(1225727842), '0');	


INSERT INTO `gssim_results`.`unit` (`PK`, `resource_id`, `type`, `name`, `amount`, `allocation_load`, `reservation_load`)
VALUES ('210', '21', 'computing', '0@compRes1', '1', '0.562', '0.562'),
('211', '21', 'computing', '1@compRes1', '1', '0.812', '0.812'),
('212', '21', 'computing', '2@compRes1', '1', '0.437', '0.437'), 
('220', '22', 'computing', '0@compRes2', '1', '0.5', '0.5'), 
('221', '22', 'computing', '1@compRes2', '1', '0.375', '0.375'), 
('222', '22', 'computing', '2@compRes2', '1', '0.25', '0.25'), 
('310', '31', 'computing', '0@compRes1', '1', '0.625', '0.625'), 
('311', '31', 'computing', '1@compRes1', '1', '0.812', '0.812'), 
('312', '31', 'computing', '2@compRes1', '1', '0.5', '0.5'), 
('320', '32', 'computing', '0@compRes2', '1', '0.5', '0.5'), 
('321', '32', 'computing', '1@compRes2', '1', '0.5', '0.5'), 
('322', '32', 'computing', '2@compRes2', '1', '0', '0'), 
('410', '41', 'computing', '0@compRes1', '1', '0.333', '0.333'), 
('411', '41', 'computing', '1@compRes1', '1', '0.222', '0.222'), 
('412', '41', 'computing', '2@compRes1', '1', '0', '0'), 
('420', '42', 'computing', '0@compRes2', '1', '0.444', '0.5'), 
('421', '42', 'computing', '1@compRes2', '1', '0.222', '0.222'), 
('422', '42', 'computing', '2@compRes2', '1', '0', '0'), 
('430', '43', 'data', '0@compRes3', '1', '0', '0'), 
('440', '44', 'link', 'R1_R2_link', '1', '0', '0'), 
('441', '44', 'link', 'R2_R5_link', '1', '0.003981', '0.003981'),
('442', '44', 'link', 'R1_R3_link', '1', '0', '0'), 
('443', '44', 'link', 'R3_R4_link', '1', '0', '0'), 
('444', '44', 'link', 'R4_R5_link', '1', '0.010617', '0.010617'), 
('445', '44', 'link', 'compRes1_link', '1', '0.003981', '0.003981'),
('446', '44', 'link', 'compRes2_link', '1', '0.010617', '0.010617'), 
('447', '44', 'link', 'dataRes1_link', '1', '0.014598', '0.014598'), 
('448', '44', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'),
('510', '51', 'computing', '0@compRes1', '1', '0.588', '0.706'), 
('511', '51', 'computing', '1@compRes1', '1', '0.529', '0.647'), 
('512', '51', 'computing', '2@compRes1', '1', '0.235', '0.294'), 
('520', '52', 'computing', '0@compRes2', '1', '0.647', '0.765'), 
('521', '52', 'computing', '1@compRes2', '1', '0', '0'), 
('522', '52', 'computing', '2@compRes2', '1', '0', '0'), 
('530', '53', 'data', '0@compRes3', '1', '0', '0'), 
('540', '54', 'link', 'R1_R2_link', '1', '0.000261', '0.000261'),
('541', '54', 'link', 'R2_R5_link', '1', '0.001438', '0.001438'), 
('542', '54', 'link', 'R1_R3_link', '1', '0.000261', '0.000261'), 
('543', '54', 'link', 'R3_R4_link', '1', '0.000261', '0.000261'), 
('544', '54', 'link', 'R4_R5_link', '1', '0', '0'),
('545', '54', 'link', 'compRes1_link', '1', '0.001438', '0.001438'),
('546', '54', 'link', 'compRes2_link', '1', '0.000261', '0.000261'), 
('547', '54', 'link', 'dataRes1_link', '1', '0.001699', '0.001699'), 
('548', '54', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0');

INSERT INTO `gssim_results`.`unit_details` (`fk_unit_id`, `name`, `value`)
VALUES ('210', 'details', '1'),
('211', 'details', '2'),
('212', 'details', '3'),
('220', 'details', '4'),
('221', 'details', '5'),
('222', 'details', '6'),
('310', 'details', '8'),
('311', 'details', '9'),
('312', 'details', '10'),
('320', 'details', '11'),
('321', 'details', '12'),
('322', 'details', '13'),
('410', 'details', '15'),
('411', 'details', '16'),
('412', 'details', '17'),
('420', 'details', '18'),
('421', 'details', '19'),
('422', 'details', '20'),
('430', 'details', '21'),
('440', 'Baud rate (bits/s)', '1000000'),
('440', 'delay(ms)', '300'),
('440', 'size of transmitted data(in bytes)', '2'),
('441', 'Baud rate (bits/s)', '1000000'),
('441', 'delay(ms)', '300'),
('441', 'size of transmitted data(in bytes)', '0'),
('442', 'Baud rate (bits/s)', '1000000'),
('442', 'delay(ms)', '300'),
('442', 'size of transmitted data(in bytes)', '3'),
('443', 'Baud rate (bits/s)', '1000000'),
('443', 'delay(ms)', '300'),
('443', 'size of transmitted data(in bytes)', '3'),
('444', 'Baud rate (bits/s)', '1000000'),
('444', 'delay(ms)', '300'),
('444', 'size of transmitted data(in bytes)', '0'),
('445', 'Baud rate (bits/s)', '1000000'),
('445', 'delay(ms)', '300'),
('445', 'size of transmitted data(in bytes)', '2'),
('446', 'Baud rate (bits/s)', '1000000'),
('446', 'delay(ms)', '300'),
('446', 'size of transmitted data(in bytes)', '3'),
('447', 'Baud rate (bits/s)', '1000000'),
('447', 'delay(ms)', '300'),
('447', 'size of transmitted data(in bytes)', '0'),
('448', 'Baud rate (bits/s)', '1000000'),
('448', 'delay(ms)', '300'),
('448', 'size of transmitted data(in bytes)', '5'),
('510', 'details', '23'),
('511', 'details', '24'),
('512', 'details', '25'),
('520', 'details', '26'),
('521', 'details', '27'),
('522', 'details', '28'),
('530', 'details', '29'),
('540', 'Baud rate (bits/s)', '10000000'),
('540', 'delay(ms)', '300'),
('540', 'size of transmitted data(in bytes)', '5'),
('541', 'Baud rate (bits/s)', '10000000'),
('541', 'delay(ms)', '300'),
('541', 'size of transmitted data(in bytes)', '5'),
('542', 'Baud rate (bits/s)', '10000000'),
('542', 'delay(ms)', '300'),
('542', 'size of transmitted data(in bytes)', '2'),
('543', 'Baud rate (bits/s)', '10000000'),
('543', 'delay(ms)', '300'),
('543', 'size of transmitted data(in bytes)', '2'),
('544', 'Baud rate (bits/s)', '10000000'),
('544', 'delay(ms)', '300'),
('544', 'size of transmitted data(in bytes)', '0'),
('545', 'Baud rate (bits/s)', '10000000'),
('545', 'delay(ms)', '300'),
('545', 'size of transmitted data(in bytes)', '5'),
('546', 'Baud rate (bits/s)', '10000000'),
('546', 'delay(ms)', '300'),
('546', 'size of transmitted data(in bytes)', '2'),
('547', 'Baud rate (bits/s)', '10000000'),
('547', 'delay(ms)', '300'),
('547', 'size of transmitted data(in bytes)', '0'),
('548', 'Baud rate (bits/s)', '10000000'),
('548', 'delay(ms)', '300'),
('548', 'size of transmitted data(in bytes)', '7');


INSERT INTO `gssim_results`.`unit_allocation_timeline` (`fk_unit_id`, `timestamp`, `usage`)
VALUES ('210', FROM_UNIXTIME(1225666800), '0.4'),							
('210', FROM_UNIXTIME(1225674000), '0.2'),							
('210', FROM_UNIXTIME(1225681200), '0'),							
('210', FROM_UNIXTIME(1225688400), '0.4'),							
('210', FROM_UNIXTIME(1225692000), '0.6'),							
('210', FROM_UNIXTIME(1225699200), '0.4'),							
('210', FROM_UNIXTIME(1225706400), '0.6'),							
('210', FROM_UNIXTIME(1225710000), '0.4'),							
('210', FROM_UNIXTIME(1225713600), '0.6'),							
('210', FROM_UNIXTIME(1225717200), '0.4'),							
('210', FROM_UNIXTIME(1225720800), '0.2'),							
('210', FROM_UNIXTIME(1225724400), '0'),							
('211', FROM_UNIXTIME(1225666800), '0.6'),							
('211', FROM_UNIXTIME(1225674000), '0.3'),							
('211', FROM_UNIXTIME(1225681200), '0'),							
('211', FROM_UNIXTIME(1225688400), '0.6'),							
('211', FROM_UNIXTIME(1225692000), '0.9'),							
('211', FROM_UNIXTIME(1225699200), '0.6'),							
('211', FROM_UNIXTIME(1225706400), '0.9'),							
('211', FROM_UNIXTIME(1225710000), '0.6'),							
('211', FROM_UNIXTIME(1225713600), '0.9'),							
('211', FROM_UNIXTIME(1225717200), '0.6'),							
('211', FROM_UNIXTIME(1225720800), '0.3'),							
('211', FROM_UNIXTIME(1225724400), '0'),							
('212', FROM_UNIXTIME(1225666800), '1'),							
('212', FROM_UNIXTIME(1225674000), '0.5'),							
('212', FROM_UNIXTIME(1225681200), '0'),							
('212', FROM_UNIXTIME(1225688400), '1'),							
('212', FROM_UNIXTIME(1225692000), '1.5'),							
('212', FROM_UNIXTIME(1225699200), '1'),							
('212', FROM_UNIXTIME(1225706400), '1.5'),							
('212', FROM_UNIXTIME(1225710000), '1'),							
('212', FROM_UNIXTIME(1225713600), '1.5'),							
('212', FROM_UNIXTIME(1225717200), '1'),							
('212', FROM_UNIXTIME(1225720800), '0.5'),							
('212', FROM_UNIXTIME(1225724400), '0'),							
('220', FROM_UNIXTIME(1225666800), '0.2'),							
('220', FROM_UNIXTIME(1225670400), '0.6'),							
('220', FROM_UNIXTIME(1225677600), '0.2'),							
('220', FROM_UNIXTIME(1225681200), '0.4'),							
('220', FROM_UNIXTIME(1225684800), '0.6'),							
('220', FROM_UNIXTIME(1225688400), '0.6'),							
('220', FROM_UNIXTIME(1225692000), '0.4'),							
('220', FROM_UNIXTIME(1225695600), '0'),							
('221', FROM_UNIXTIME(1225666800), '0.3'),							
('221', FROM_UNIXTIME(1225670400), '0.9'),							
('221', FROM_UNIXTIME(1225677600), '0.3'),							
('221', FROM_UNIXTIME(1225681200), '0.6'),							
('221', FROM_UNIXTIME(1225684800), '0.9'),							
('221', FROM_UNIXTIME(1225688400), '0.9'),							
('221', FROM_UNIXTIME(1225692000), '0.6'),							
('221', FROM_UNIXTIME(1225695600), '0'),							
('222', FROM_UNIXTIME(1225666800), '0.5'),							
('222', FROM_UNIXTIME(1225670400), '1.5'),							
('222', FROM_UNIXTIME(1225677600), '0.5'),							
('222', FROM_UNIXTIME(1225681200), '1'),							
('222', FROM_UNIXTIME(1225684800), '1.5'),							
('222', FROM_UNIXTIME(1225688400), '1.5'),							
('222', FROM_UNIXTIME(1225692000), '1'),							
('222', FROM_UNIXTIME(1225695600), '0'),							
('310', FROM_UNIXTIME(1225666800), '0.6'),							
('310', FROM_UNIXTIME(1225674000), '0.4'),							
('310', FROM_UNIXTIME(1225681200), '0.4'),							
('310', FROM_UNIXTIME(1225684800), '0.6'),							
('310', FROM_UNIXTIME(1225688400), '0.6'),							
('310', FROM_UNIXTIME(1225692000), '0.6'),							
('310', FROM_UNIXTIME(1225695600), '0.4'),							
('310', FROM_UNIXTIME(1225699200), '0.2'),							
('310', FROM_UNIXTIME(1225713600), '0.4'),							
('310', FROM_UNIXTIME(1225717200), '0.2'),							
('310', FROM_UNIXTIME(1225724400), '0'),							
('311', FROM_UNIXTIME(1225666800), '0.9'),							
('311', FROM_UNIXTIME(1225674000), '0.6'),							
('311', FROM_UNIXTIME(1225681200), '0.6'),							
('311', FROM_UNIXTIME(1225684800), '0.9'),							
('311', FROM_UNIXTIME(1225688400), '0.9'),							
('311', FROM_UNIXTIME(1225692000), '0.9'),							
('311', FROM_UNIXTIME(1225695600), '0.6'),							
('311', FROM_UNIXTIME(1225699200), '0.3'),							
('311', FROM_UNIXTIME(1225713600), '0.6'),							
('311', FROM_UNIXTIME(1225717200), '0.3'),							
('311', FROM_UNIXTIME(1225724400), '0'),							
('312', FROM_UNIXTIME(1225666800), '1.5'),							
('312', FROM_UNIXTIME(1225674000), '1'),							
('312', FROM_UNIXTIME(1225681200), '1'),							
('312', FROM_UNIXTIME(1225684800), '1.5'),							
('312', FROM_UNIXTIME(1225688400), '1.5'),							
('312', FROM_UNIXTIME(1225692000), '1.5'),							
('312', FROM_UNIXTIME(1225695600), '1'),							
('312', FROM_UNIXTIME(1225699200), '0.5'),							
('312', FROM_UNIXTIME(1225713600), '1'),							
('312', FROM_UNIXTIME(1225717200), '0.5'),							
('312', FROM_UNIXTIME(1225724400), '0'),							
('320', FROM_UNIXTIME(1225666800), '0'),							
('320', FROM_UNIXTIME(1225670400), '0.4'),							
('320', FROM_UNIXTIME(1225677600), '0'),							
('320', FROM_UNIXTIME(1225688400), '0.4'),							
('320', FROM_UNIXTIME(1225695600), '0.2'),							
('320', FROM_UNIXTIME(1225706400), '0.4'),							
('320', FROM_UNIXTIME(1225710000), '0.2'),							
('320', FROM_UNIXTIME(1225720800), '0'),							
('321', FROM_UNIXTIME(1225666800), '0'),							
('321', FROM_UNIXTIME(1225670400), '0.6'),							
('321', FROM_UNIXTIME(1225677600), '0'),							
('321', FROM_UNIXTIME(1225688400), '0.6'),							
('321', FROM_UNIXTIME(1225695600), '0.3'),							
('321', FROM_UNIXTIME(1225706400), '0.6'),							
('321', FROM_UNIXTIME(1225710000), '0.3'),							
('321', FROM_UNIXTIME(1225720800), '0'),							
('322', FROM_UNIXTIME(1225666800), '0'),							
('322', FROM_UNIXTIME(1225670400), '1'),							
('322', FROM_UNIXTIME(1225677600), '0'),							
('322', FROM_UNIXTIME(1225688400), '1'),							
('322', FROM_UNIXTIME(1225695600), '0.5'),							
('322', FROM_UNIXTIME(1225706400), '1'),							
('322', FROM_UNIXTIME(1225710000), '0.5'),							
('322', FROM_UNIXTIME(1225720800), '0'),							
('410', FROM_UNIXTIME(1225666800), '0'),							
('410', FROM_UNIXTIME(1225688400), '0.4'),							
('410', FROM_UNIXTIME(1225695600), '0.2'),							
('410', FROM_UNIXTIME(1225699200), '0'),							
('411', FROM_UNIXTIME(1225666800), '0'),							
('411', FROM_UNIXTIME(1225688400), '0.6'),							
('411', FROM_UNIXTIME(1225695600), '0.3'),							
('411', FROM_UNIXTIME(1225699200), '0'),							
('412', FROM_UNIXTIME(1225666800), '0'),							
('412', FROM_UNIXTIME(1225688400), '1'),							
('412', FROM_UNIXTIME(1225695600), '0.5'),							
('412', FROM_UNIXTIME(1225699200), '0'),							
('420', FROM_UNIXTIME(1225666800), '0'),							
('420', FROM_UNIXTIME(1225668594), '0.2'),							
('420', FROM_UNIXTIME(1225675794), '0'),							
('420', FROM_UNIXTIME(1225681200), '0.2'),							
('420', FROM_UNIXTIME(1225684800), '0.4'),							
('420', FROM_UNIXTIME(1225688400), '0.2'),							
('420', FROM_UNIXTIME(1225692000), '0'),							
('421', FROM_UNIXTIME(1225666800), '0'),							
('421', FROM_UNIXTIME(1225668594), '0.3'),							
('421', FROM_UNIXTIME(1225675794), '0'),							
('421', FROM_UNIXTIME(1225681200), '0.3'),							
('421', FROM_UNIXTIME(1225684800), '0.6'),							
('421', FROM_UNIXTIME(1225688400), '0.3'),							
('421', FROM_UNIXTIME(1225692000), '0'),							
('422', FROM_UNIXTIME(1225666800), '0'),							
('422', FROM_UNIXTIME(1225668594), '0.5'),							
('422', FROM_UNIXTIME(1225675794), '0'),							
('422', FROM_UNIXTIME(1225681200), '0.5'),							
('422', FROM_UNIXTIME(1225684800), '1'),							
('422', FROM_UNIXTIME(1225688400), '0.5'),							
('422', FROM_UNIXTIME(1225692000), '0'),							
('430', FROM_UNIXTIME(1225666800), '0'),							
('510', FROM_UNIXTIME(1225666800), '0'),							
('510', FROM_UNIXTIME(1225670322), '0.2'),							
('510', FROM_UNIXTIME(1225673986), '0.4'),							
('510', FROM_UNIXTIME(1225681186), '0.2'),							
('510', FROM_UNIXTIME(1225684722), '0'),							
('510', FROM_UNIXTIME(1225691986), '0.2'),							
('510', FROM_UNIXTIME(1225695570), '0.4'),							
('510', FROM_UNIXTIME(1225709906), '0.6'),							
('510', FROM_UNIXTIME(1225713586), '0.4'),							
('510', FROM_UNIXTIME(1225720770), '0.2'),							
('510', FROM_UNIXTIME(1225724306), '0'),							
('511', FROM_UNIXTIME(1225666800), '0'),							
('511', FROM_UNIXTIME(1225670322), '0.3'),							
('511', FROM_UNIXTIME(1225673986), '0.6'),							
('511', FROM_UNIXTIME(1225681186), '0.3'),							
('511', FROM_UNIXTIME(1225684722), '0'),							
('511', FROM_UNIXTIME(1225691986), '0.3'),							
('511', FROM_UNIXTIME(1225695570), '0.6'),							
('511', FROM_UNIXTIME(1225709906), '0.9'),							
('511', FROM_UNIXTIME(1225713586), '0.6'),							
('511', FROM_UNIXTIME(1225720770), '0.3'),							
('511', FROM_UNIXTIME(1225724306), '0'),							
('512', FROM_UNIXTIME(1225666800), '0'),							
('512', FROM_UNIXTIME(1225670322), '0.5'),							
('512', FROM_UNIXTIME(1225673986), '1'),							
('512', FROM_UNIXTIME(1225681186), '0.5'),							
('512', FROM_UNIXTIME(1225684722), '0'),							
('512', FROM_UNIXTIME(1225691986), '0.5'),							
('512', FROM_UNIXTIME(1225695570), '1'),							
('512', FROM_UNIXTIME(1225709906), '1.5'),							
('512', FROM_UNIXTIME(1225713586), '1'),							
('512', FROM_UNIXTIME(1225720770), '0.5'),							
('512', FROM_UNIXTIME(1225724306), '0'),							
('520', FROM_UNIXTIME(1225666800), '0'),							
('520', FROM_UNIXTIME(1225666802), '0.2'),							
('520', FROM_UNIXTIME(1225695602), '0'),							
('520', FROM_UNIXTIME(1225717042), '0.2'),							
('520', FROM_UNIXTIME(1225727842), '0'),							
('521', FROM_UNIXTIME(1225666800), '0'),							
('521', FROM_UNIXTIME(1225666802), '0.3'),							
('521', FROM_UNIXTIME(1225695602), '0'),							
('521', FROM_UNIXTIME(1225717042), '0.3'),							
('521', FROM_UNIXTIME(1225727842), '0'),							
('522', FROM_UNIXTIME(1225666800), '0'),							
('522', FROM_UNIXTIME(1225666802), '0.5'),							
('522', FROM_UNIXTIME(1225695602), '0'),							
('522', FROM_UNIXTIME(1225717042), '0.5'),							
('522', FROM_UNIXTIME(1225727842), '0'),							
('530', FROM_UNIXTIME(1225666800), '0');							


INSERT INTO `gssim_results`.`unit_energy_timeline` (`fk_unit_id`, `timestamp`, `usage`)
VALUES ('210', FROM_UNIXTIME(1225666800), '1.4'),							
('210', FROM_UNIXTIME(1225674000), '0.7'),							
('210', FROM_UNIXTIME(1225681200), '0'),							
('210', FROM_UNIXTIME(1225688400), '1.4'),							
('210', FROM_UNIXTIME(1225692000), '2.1'),							
('210', FROM_UNIXTIME(1225699200), '1.4'),							
('210', FROM_UNIXTIME(1225706400), '2.1'),							
('210', FROM_UNIXTIME(1225710000), '1.4'),							
('210', FROM_UNIXTIME(1225713600), '2.1'),							
('210', FROM_UNIXTIME(1225717200), '1.4'),							
('210', FROM_UNIXTIME(1225720800), '0.7'),							
('210', FROM_UNIXTIME(1225724400), '0'),							
('211', FROM_UNIXTIME(1225666800), '0.2'),							
('211', FROM_UNIXTIME(1225674000), '0.1'),							
('211', FROM_UNIXTIME(1225681200), '0'),							
('211', FROM_UNIXTIME(1225688400), '0.2'),							
('211', FROM_UNIXTIME(1225692000), '0.3'),							
('211', FROM_UNIXTIME(1225699200), '0.2'),							
('211', FROM_UNIXTIME(1225706400), '0.3'),							
('211', FROM_UNIXTIME(1225710000), '0.2'),							
('211', FROM_UNIXTIME(1225713600), '0.3'),							
('211', FROM_UNIXTIME(1225717200), '0.2'),							
('211', FROM_UNIXTIME(1225720800), '0.1'),							
('211', FROM_UNIXTIME(1225724400), '0'),							
('220', FROM_UNIXTIME(1225666800), '0.7'),							
('220', FROM_UNIXTIME(1225670400), '2.1'),							
('220', FROM_UNIXTIME(1225677600), '0.7'),							
('220', FROM_UNIXTIME(1225681200), '1.4'),							
('220', FROM_UNIXTIME(1225684800), '2.1'),							
('220', FROM_UNIXTIME(1225688400), '2.1'),							
('220', FROM_UNIXTIME(1225692000), '1.4'),							
('220', FROM_UNIXTIME(1225695600), '0'),							
('221', FROM_UNIXTIME(1225666800), '0.1'),							
('221', FROM_UNIXTIME(1225670400), '0.3'),							
('221', FROM_UNIXTIME(1225677600), '0.1'),							
('221', FROM_UNIXTIME(1225681200), '0.2'),							
('221', FROM_UNIXTIME(1225684800), '0.3'),							
('221', FROM_UNIXTIME(1225688400), '0.3'),							
('221', FROM_UNIXTIME(1225692000), '0.2'),							
('221', FROM_UNIXTIME(1225695600), '0'),							
('212', FROM_UNIXTIME(1225666800), '0.4'),							
('212', FROM_UNIXTIME(1225674000), '0.2'),							
('212', FROM_UNIXTIME(1225681200), '0'),							
('212', FROM_UNIXTIME(1225688400), '0.4'),							
('212', FROM_UNIXTIME(1225692000), '0.6'),							
('212', FROM_UNIXTIME(1225699200), '0.4'),							
('212', FROM_UNIXTIME(1225706400), '0.6'),							
('212', FROM_UNIXTIME(1225710000), '0.4'),							
('212', FROM_UNIXTIME(1225713600), '0.6'),							
('212', FROM_UNIXTIME(1225717200), '0.4'),							
('212', FROM_UNIXTIME(1225720800), '0.2'),							
('212', FROM_UNIXTIME(1225724400), '0'),							
('222', FROM_UNIXTIME(1225666800), '0.2'),							
('222', FROM_UNIXTIME(1225670400), '0.6'),							
('222', FROM_UNIXTIME(1225677600), '0.2'),							
('222', FROM_UNIXTIME(1225681200), '0.4'),							
('222', FROM_UNIXTIME(1225684800), '0.6'),							
('222', FROM_UNIXTIME(1225688400), '0.6'),							
('222', FROM_UNIXTIME(1225692000), '0.4'),							
('222', FROM_UNIXTIME(1225695600), '0'),							
('310', FROM_UNIXTIME(1225666800), '2.1'),							
('310', FROM_UNIXTIME(1225674000), '1.4'),							
('310', FROM_UNIXTIME(1225681200), '1.4'),							
('310', FROM_UNIXTIME(1225684800), '2.1'),							
('310', FROM_UNIXTIME(1225688400), '2.1'),							
('310', FROM_UNIXTIME(1225692000), '2.1'),							
('310', FROM_UNIXTIME(1225695600), '1.4'),							
('310', FROM_UNIXTIME(1225699200), '0.7'),							
('310', FROM_UNIXTIME(1225713600), '1.4'),							
('310', FROM_UNIXTIME(1225717200), '0.7'),							
('310', FROM_UNIXTIME(1225724400), '0'),							
('311', FROM_UNIXTIME(1225666800), '0.3'),							
('311', FROM_UNIXTIME(1225674000), '0.2'),							
('311', FROM_UNIXTIME(1225681200), '0.2'),							
('311', FROM_UNIXTIME(1225684800), '0.3'),							
('311', FROM_UNIXTIME(1225688400), '0.3'),							
('311', FROM_UNIXTIME(1225692000), '0.3'),							
('311', FROM_UNIXTIME(1225695600), '0.2'),							
('311', FROM_UNIXTIME(1225699200), '0.1'),							
('311', FROM_UNIXTIME(1225713600), '0.2'),							
('311', FROM_UNIXTIME(1225717200), '0.1'),							
('311', FROM_UNIXTIME(1225724400), '0'),							
('312', FROM_UNIXTIME(1225666800), '0.6'),							
('312', FROM_UNIXTIME(1225674000), '0.4'),							
('312', FROM_UNIXTIME(1225681200), '0.4'),							
('312', FROM_UNIXTIME(1225684800), '0.6'),							
('312', FROM_UNIXTIME(1225688400), '0.6'),							
('312', FROM_UNIXTIME(1225692000), '0.6'),							
('312', FROM_UNIXTIME(1225695600), '0.4'),							
('312', FROM_UNIXTIME(1225699200), '0.2'),							
('312', FROM_UNIXTIME(1225713600), '0.4'),							
('312', FROM_UNIXTIME(1225717200), '0.2'),							
('312', FROM_UNIXTIME(1225724400), '0'),							
('320', FROM_UNIXTIME(1225670400), '1.4'),							
('320', FROM_UNIXTIME(1225677600), '0'),							
('320', FROM_UNIXTIME(1225688400), '1.4'),							
('320', FROM_UNIXTIME(1225695600), '0.7'),							
('320', FROM_UNIXTIME(1225706400), '1.4'),							
('320', FROM_UNIXTIME(1225710000), '0.7'),							
('320', FROM_UNIXTIME(1225720800), '0'),							
('321', FROM_UNIXTIME(1225670400), '0.2'),							
('321', FROM_UNIXTIME(1225677600), '0'),							
('321', FROM_UNIXTIME(1225688400), '0.2'),							
('321', FROM_UNIXTIME(1225695600), '0.1'),							
('321', FROM_UNIXTIME(1225706400), '0.2'),							
('321', FROM_UNIXTIME(1225710000), '0.1'),							
('321', FROM_UNIXTIME(1225720800), '0'),							
('322', FROM_UNIXTIME(1225670400), '0.4'),							
('322', FROM_UNIXTIME(1225677600), '0'),							
('322', FROM_UNIXTIME(1225688400), '0.4'),							
('322', FROM_UNIXTIME(1225695600), '0.2'),							
('322', FROM_UNIXTIME(1225706400), '0.4'),							
('322', FROM_UNIXTIME(1225710000), '0.2'),							
('322', FROM_UNIXTIME(1225720800), '0'),							
('410', FROM_UNIXTIME(1225688400), '1.4'),							
('410', FROM_UNIXTIME(1225695600), '0.7'),							
('410', FROM_UNIXTIME(1225699200), '0'),							
('411', FROM_UNIXTIME(1225688400), '0.2'),							
('411', FROM_UNIXTIME(1225695600), '0.1'),							
('411', FROM_UNIXTIME(1225699200), '0'),							
('412', FROM_UNIXTIME(1225688400), '0.4'),							
('412', FROM_UNIXTIME(1225695600), '0.2'),							
('412', FROM_UNIXTIME(1225699200), '0'),								
('420', FROM_UNIXTIME(1225668594), '0.7'),							
('420', FROM_UNIXTIME(1225675794), '0'),							
('420', FROM_UNIXTIME(1225681200), '0'),							
('420', FROM_UNIXTIME(1225684800), '1.4'),							
('420', FROM_UNIXTIME(1225688400), '0.7'),							
('420', FROM_UNIXTIME(1225692000), '0'),							
('421', FROM_UNIXTIME(1225668594), '0.1'),							
('421', FROM_UNIXTIME(1225675794), '0'),							
('421', FROM_UNIXTIME(1225681200), '0'),							
('421', FROM_UNIXTIME(1225684800), '0.2'),							
('421', FROM_UNIXTIME(1225688400), '0.1'),							
('421', FROM_UNIXTIME(1225692000), '0'),							
('422', FROM_UNIXTIME(1225668594), '0.2'),							
('422', FROM_UNIXTIME(1225675794), '0'),							
('422', FROM_UNIXTIME(1225681200), '0'),							
('422', FROM_UNIXTIME(1225684800), '0.4'),							
('422', FROM_UNIXTIME(1225688400), '0.2'),							
('422', FROM_UNIXTIME(1225692000), '0'),							
('510', FROM_UNIXTIME(1225670322), '0.7'),							
('510', FROM_UNIXTIME(1225673986), '1.4'),							
('510', FROM_UNIXTIME(1225681186), '0.7'),							
('510', FROM_UNIXTIME(1225684722), '0'),							
('510', FROM_UNIXTIME(1225691986), '0.7'),							
('510', FROM_UNIXTIME(1225695570), '1.4'),							
('510', FROM_UNIXTIME(1225709906), '2.1'),							
('510', FROM_UNIXTIME(1225713586), '1.4'),							
('510', FROM_UNIXTIME(1225720770), '0.7'),							
('510', FROM_UNIXTIME(1225724306), '0'),							
('511', FROM_UNIXTIME(1225670322), '0.1'),							
('511', FROM_UNIXTIME(1225673986), '0.2'),							
('511', FROM_UNIXTIME(1225681186), '0.1'),							
('511', FROM_UNIXTIME(1225684722), '0'),							
('511', FROM_UNIXTIME(1225691986), '0.1'),							
('511', FROM_UNIXTIME(1225695570), '0.2'),							
('511', FROM_UNIXTIME(1225709906), '0.3'),							
('511', FROM_UNIXTIME(1225713586), '0.2'),							
('511', FROM_UNIXTIME(1225720770), '0.1'),							
('511', FROM_UNIXTIME(1225724306), '0'),							
('512', FROM_UNIXTIME(1225670322), '0.2'),							
('512', FROM_UNIXTIME(1225673986), '0.4'),							
('512', FROM_UNIXTIME(1225681186), '0.2'),							
('512', FROM_UNIXTIME(1225684722), '0'),							
('512', FROM_UNIXTIME(1225691986), '0.2'),							
('512', FROM_UNIXTIME(1225695570), '0.4'),							
('512', FROM_UNIXTIME(1225709906), '0.6'),							
('512', FROM_UNIXTIME(1225713586), '0.4'),							
('512', FROM_UNIXTIME(1225720770), '0.2'),							
('512', FROM_UNIXTIME(1225724306), '0'),							
('520', FROM_UNIXTIME(1225666802), '0.7'),							
('520', FROM_UNIXTIME(1225695602), '0'),							
('520', FROM_UNIXTIME(1225717042), '0.7'),							
('520', FROM_UNIXTIME(1225727842), '0'),							
('521', FROM_UNIXTIME(1225666802), '0.1'),							
('521', FROM_UNIXTIME(1225695602), '0'),							
('521', FROM_UNIXTIME(1225717042), '0.1'),							
('521', FROM_UNIXTIME(1225727842), '0'),							
('522', FROM_UNIXTIME(1225666802), '0.2'),							
('522', FROM_UNIXTIME(1225695602), '0'),							
('522', FROM_UNIXTIME(1225717042), '0.2'),							
('522', FROM_UNIXTIME(1225727842), '0');

INSERT INTO `gssim_results`.`allocation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) 
VALUES ('0', '2000', '210', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)),										
('1', '2100', '221', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),										
('2', '21000', '211', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)),										
('3', '21100', '220', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)),										
('4', '21200', '222', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),										
('5', '21300', '211', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)),										
('6', '21400', '212', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)),										
('7', '21500', '210', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)),										
('8', '21600', '211', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)),										
('9', '2200', '221', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),										
('10', '2300', '222', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),										
('11', '2400', '221', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),										
('12', '2500', '210', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),										
('13', '3000', '310', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)),										
('14', '3100', '320', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),										
('15', '31000', '311', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)),										
('16', '31100', '312', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)),										
('17', '31200', '321', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),										
('18', '31300', '321', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)),										
('19', '31400', '311', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)),										
('20', '31500', '320', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)),										
('21', '31600', '310', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)),										
('22', '3200', '310', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),										
('23', '3300', '311', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),										
('24', '3400', '320', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),										
('25', '3500', '310', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),										
('26', '4100', '420', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225674800)),										
('27', '4300', '420', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),										
('28', '4400', '421', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),										
('29', '4500', '411', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),										
('30', '4600', '410', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),										
('31', '5000', '510', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225683800)),										
('32', '5100', '520', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225698200)),										
('33', '5200', '511', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225680200)),										
('34', '5300', '510', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225712600)),										
('35', '5400', '511', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225719800)),										
('36', '5500', '512', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225723400)),										
('37', '5600', '520', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225727000));					


INSERT INTO `gssim_results`.`allocation_details` (`fk_allocation_id`, `name`, `value`) 
VALUES ('0', 'allocation_detail', '0'),	
('1', 'allocation_detail', '1'),	
('2', 'allocation_detail', '2'),	
('3', 'allocation_detail', '3'),	
('4', 'allocation_detail', '4'),	
('5', 'allocation_detail', '5'),	
('6', 'allocation_detail', '6'),	
('7', 'allocation_detail', '7'),	
('8', 'allocation_detail', '8'),	
('9', 'allocation_detail', '9'),	
('10', 'allocation_detail', '10'),	
('11', 'allocation_detail', '11'),	
('12', 'allocation_detail', '12'),	
('13', 'allocation_detail', '13'),	
('14', 'allocation_detail', '14'),	
('15', 'allocation_detail', '15'),	
('16', 'allocation_detail', '16'),	
('17', 'allocation_detail', '17'),	
('18', 'allocation_detail', '18'),	
('19', 'allocation_detail', '19'),	
('20', 'allocation_detail', '20'),	
('21', 'allocation_detail', '21'),	
('22', 'allocation_detail', '22'),	
('23', 'allocation_detail', '23'),	
('24', 'allocation_detail', '24'),	
('25', 'allocation_detail', '25'),	
('26', 'allocation_detail', '26'),	
('27', 'allocation_detail', '27'),	
('28', 'allocation_detail', '28'),	
('29', 'allocation_detail', '29'),	
('30', 'allocation_detail', '30'),	
('31', 'allocation_detail', '31'),	
('32', 'allocation_detail', '32'),	
('33', 'allocation_detail', '33'),	
('34', 'allocation_detail', '34'),	
('35', 'allocation_detail', '35'),	
('36', 'allocation_detail', '36'),	
('37', 'allocation_detail', '37');


INSERT INTO `gssim_results`.`reservation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) 
VALUES ('0', '2000', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)),										
('1', '2100', '221', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),										
('2', '21000', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)),										
('3', '21100', '220', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)),										
('4', '21200', '222', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),										
('5', '21300', '211', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)),										
('6', '21400', '212', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)),										
('7', '21500', '210', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)),										
('8', '21600', '211', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)),										
('9', '2200', '221', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),										
('10', '2300', '222', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),										
('11', '2400', '221', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),										
('12', '2500', '210', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),										
('13', '3000', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)),										
('14', '3100', '320', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),										
('15', '31000', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)),										
('16', '31100', '312', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)),										
('17', '31200', '321', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),										
('18', '31300', '321', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)),										
('19', '31400', '311', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)),										
('20', '31500', '320', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)),										
('21', '31600', '310', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)),										
('22', '3200', '310', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),										
('23', '3300', '311', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),										
('24', '3400', '320', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),										
('25', '3500', '310', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),										
('26', '4100', '420', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225675800)),										
('27', '4300', '420', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),										
('28', '4400', '421', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),										
('29', '4500', '411', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),										
('30', '4600', '410', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),										
('31', '5000', '510', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225684800)),										
('32', '5100', '520', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225699200)),										
('33', '5200', '511', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225681200)),										
('34', '5300', '510', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225713600)),										
('35', '5400', '511', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225720800)),										
('36', '5500', '512', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225724400)),										
('37', '5600', '520', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225728000));									


INSERT INTO `gssim_results`.`reservation_details` (`fk_reservation_id`, `name`, `value`) 
VALUES ('0', 'reservation_detail', '0'),	
('1', 'reservation_detail', '1'),	
('2', 'reservation_detail', '2'),	
('3', 'reservation_detail', '3'),	
('4', 'reservation_detail', '4'),	
('5', 'reservation_detail', '5'),	
('6', 'reservation_detail', '6'),	
('7', 'reservation_detail', '7'),	
('8', 'reservation_detail', '8'),	
('9', 'reservation_detail', '9'),	
('10', 'reservation_detail', '10'),	
('11', 'reservation_detail', '11'),	
('12', 'reservation_detail', '12'),	
('13', 'reservation_detail', '13'),	
('14', 'reservation_detail', '14'),	
('15', 'reservation_detail', '15'),	
('16', 'reservation_detail', '16'),	
('17', 'reservation_detail', '17'),	
('18', 'reservation_detail', '18'),	
('19', 'reservation_detail', '19'),	
('20', 'reservation_detail', '20'),	
('21', 'reservation_detail', '21'),	
('22', 'reservation_detail', '22'),	
('23', 'reservation_detail', '23'),	
('24', 'reservation_detail', '24'),	
('25', 'reservation_detail', '25'),	
('26', 'reservation_detail', '26'),	
('27', 'reservation_detail', '27'),	
('28', 'reservation_detail', '28'),	
('29', 'reservation_detail', '29'),	
('30', 'reservation_detail', '30'),	
('31', 'reservation_detail', '31'),	
('32', 'reservation_detail', '32'),	
('33', 'reservation_detail', '33'),	
('34', 'reservation_detail', '34'),	
('35', 'reservation_detail', '35'),	
('36', 'reservation_detail', '36'),	
('37', 'reservation_detail', '37');	


INSERT INTO `plugin` (`id`, `name`, `is_global`, `description`, `input`) VALUES
(1, 'ARGraham', 1, 'This Plugin schedules jobs using the earliest due date (EDD) policy to sort them in a queue and then applies the greedy list scheduling Graham algorithm. Jobs $J_i$ from the queue are assigned to one of clusters  $\\mathcal{M}$ using a greedy list-scheduling algorithm based on ~\\cite{graham1969bmt,mounie07}. To this end, the Grid scheduler queries each organization $O_k$ about a list of free slots $\\psi_{ki} \\in \\Psi_k, \\psi_{ki}=(t'',t'''',m_{ki}) , i=1..|\\Psi|$. Parameters $t''$ and $t''''$ denote start and time of a slot, respectively. $m_{ki}$ is a number of processors available within the slot $i$ at organization $O_k$. Slots are time periods within which a number of available processors is constant. The Grid scheduler sorts collected slots by increasing start time. The schedule is constructed by assigning jobs in the Grid scheduler''s queue to processors in given slots in a greedy manner. For each slot $\\psi_{kI}$ (starting from the earliest one) the scheduler chooses from its queue the first job $J_j$ requiring no more than $m_{ki}$ processors in all subsequent slots $i \\geq I$ such as $t''''_{ki} \\geq t''_{kI} + p_j$. If such a job was find the scheduler schedules it to be started at $t''_{kI}$, and removes it from the queue. If there is no such a job, the scheduler apply the same procedure to the next free slot whose number of available processors is larger than the current one.', NULL),
(2, 'GridARAllSlots', 1, NULL, NULL),
(3, 'GridARFirstFit', 1, NULL, NULL),
(4, 'GridARNRDijkstra', 1, NULL, NULL),
(5, 'GridARNRSpecificPath', 1, NULL, NULL),
(6, 'GridRoundRobinPlugin', 1, NULL, NULL),
(7, 'ARAllSlots', 0, 'This implementation of getOffers() method returns detail state of the resource in requested time. Imagine the result as a gantt diagram of resource usage between start and end time. Grid scheduling plugin must analyze this result, decide if there are enough resource units and create reservation of this units.', NULL),
(8, 'ARFirstFit', 0, NULL, NULL),
(9, 'FCFSLocalPlugin', 0, NULL, NULL);


INSERT INTO `plugin_compatibility` (`parent_id`, `child_id`) VALUES
(2, 7),
(3, 8),
(4, 8),
(5, 8),
(6, 9);
