Context Navigation

← Previous Revision
Latest Revision
Next Revision →
Annotate
Revision Log

data.sql @ 104

Revision 104, 69.6 KB checked in by wojtekp, 13 years ago (diff)

Line
1	INSERT INTO `gssim_results`.`user` (`id`, `dn`) VALUES
2	(1, 'irondn'),
3	(2, 'irondn2');
4
5	INSERT INTO `gssim_results`.`configuration` (`id`) VALUES
6	(2),
7	(3);
8
9	INSERT INTO `gssim_results`.`blob_property` (`config_id`, `name`, `value`) VALUES
10	(2, 'Network topology', 0x31320a526f757465725f50534e430a526f757465725f4345534e45540a526f757465725f44464e0a526f757465725f474152520a526f757465725f4b54480a526f757465725f4845414e65740a526f757465725f5357495443480a526f757465725f48554e4741524e45540a526f757465725f526564495249530a526f757465725f49324341540a526f757465725f4643434e0a526f757465725f47524e45540a31380a526f757465725f4b54480909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f4b54480909526f757465725f50534e430909310933303009313530303030300a526f757465725f50534e430909526f757465725f44464e0909310933303009313530303030300a526f757465725f50534e430909526f757465725f474152520909310933303009313530303030300a526f757465725f50534e430909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f474152520909310933303009313530303030300a526f757465725f44464e0909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f5357495443480909310933303009313530303030300a526f757465725f474152520909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f474152520909526f757465725f526564495249530909310933303009313530303030300a526f757465725f4345534e45540909526f757465725f47524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f48554e4741524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f526564495249530909310933303009313530303030300a526f757465725f48554e4741524e45540909526f757465725f5357495443480909310933303009313530303030300a526f757465725f526564495249530909526f757465725f49324341540909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4643434e0909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f5357495443480909526f757465725f4845414e65740909310933303009313530303030300a32300a50534e432d766e536572766572310909526f757465725f50534e430909310933303009313530303030300a50534e432d766e536572766572320909526f757465725f50534e430909310933303009313530303030300a50534e432d726f757465720909526f757465725f50534e430909310933303009313530303030300a4345534e45542d766e536572766572310909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d766e536572766572320909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d726f757465720909526f757465725f4345534e45540909310933303009313530303030300a44464e2d766e536572766572310909526f757465725f44464e0909310933303009313530303030300a44464e2d766e536572766572320909526f757465725f44464e0909310933303009313530303030300a44464e2d726f757465720909526f757465725f44464e0909310933303009313530303030300a474152522d766e536572766572310909526f757465725f474152520909310933303009313530303030300a474152522d766e536572766572320909526f757465725f474152520909310933303009313530303030300a474152522d726f757465720909526f757465725f474152520909310933303009313530303030300a4b54482d766e5365727665720909526f757465725f4b54480909310933303009313530303030300a4845414e65742d766e5365727665720909526f757465725f4845414e65740909310933303009313530303030300a5357495443482d766e5365727665720909526f757465725f5357495443480909310933303009313530303030300a48554e4741524e45542d766e5365727665720909526f757465725f48554e4741524e45540909310933303009313530303030300a526564495249532d766e5365727665720909526f757465725f526564495249530909310933303009313530303030300a49324341542d766e5365727665720909526f757465725f49324341540909310933303009313530303030300a4643434e2d766e5365727665720909526f757465725f4643434e0909310933303009313530303030300a47524e45542d766e5365727665720909526f757465725f47524e45540909310933303009313530303030300a310a42726f6b6572496e74657266616365456e7469747920526f757465725f50534e432031202020202033303020202020313530303030300a),
11	(3, 'Network topology', 0x2320746f74616c206e756d626572206f6620726f75746572730a32350a23206561636820726f75746572206e616d650a506f7a6e616e0a4764616e736b0a576172737a6177610a57726f636c61770a4b72616b6f770a4b6f737a616c696e0a537a637a6563696e0a476f727a6f77576c6b700a427964676f737a637a0a546f72756e0a4f6c737a74796e0a4269616c7973746f6b0a5a69656c6f6e61476f72610a4c6f647a0a5261646f6d0a50756c6177790a4c75626c696e0a4f706f6c650a437a6573746f63686f77610a476c69776963650a4b69656c63650a527a65737a6f770a4269656c736b6f4269616c610a4b61746f776963650a5a616d6f73630a0a2320746f74616c206e756d626572206f6620636f6e6e656374696f6e73206265747765656e20726f75746572730a33300a2320636f6e6e656374696f6e73206265747765656e20726f75746572730a4764616e736b204b6f737a616c696e2032302033303020313530303030300a4764616e736b204f6c737a74796e2032302033303020313530303030300a4f706f6c6520476c69776963652032302033303020313530303030300a4b6f737a616c696e20537a637a6563696e2032302033303020313530303030300a537a637a6563696e20476f727a6f77576c6b702032302033303020313530303030300a427964676f737a637a20546f72756e2032302033303020313530303030300a5261646f6d204b69656c63652032302033303020313530303030300a4269656c736b6f4269616c61204b72616b6f772032302033303020313530303030300a506f7a6e616e20576172737a6177612032302033303020313530303030300a4f6c737a74796e204269616c7973746f6b20312036303020313530303030300a4b69656c6365204b72616b6f772032302033303020313530303030300a476c6977696365204b61746f776963652032302033303020313530303030300a57726f636c6177204f706f6c652032302033303020313530303030300a437a6573746f63686f7761204c6f647a2032302033303020313530303030300a527a65737a6f77204b72616b6f7720312036303020313530303030300a4c75626c696e205a616d6f73632032302033303020313530303030300a437a6573746f63686f7761204b61746f776963652032302033303020313530303030300a506f7a6e616e205a69656c6f6e61476f72612032302033303020313530303030300a576172737a617761204269616c7973746f6b2032302033303020313530303030300a546f72756e204764616e736b2032302033303020313530303030300a427964676f737a637a20506f7a6e616e2032302033303020313530303030300a506f7a6e616e20476f727a6f77576c6b702032302033303020313530303030300a4c6f647a20576172737a6177612032302033303020313530303030300a5261646f6d20576172737a6177612032302033303020313530303030300a50756c617779205261646f6d2032302033303020313530303030300a50756c617779204c75626c696e2032302033303020313530303030300a527a65737a6f77205a616d6f73632032302033303020313530303030300a4c6f647a20506f7a6e616e2032302033303020313530303030300a5a69656c6f6e61476f72612057726f636c61772032302033303020313530303030300a4269656c736b6f4269616c6120476c69776963652032302033303020313530303030300a0a2320746f74616c206e756d626572206f66207265736f75726365730a350a2320636f6e6e656374696f6e73206265747765656e207265736f7572636520616e6420726f757465720a5043535320506f7a6e616e2032302031303020313530303030300a574353532057726f636c61772032302031303020313530303030300a437966726f6e6574204b72616b6f772032302031303020313530303030300a43495441534b204764616e736b2032302031303020313530303030300a49434d20576172737a6177612032302031303020313530303030300a0a2320746f74616c206e756d626572206f662075736572730a310a2320636f6e6e656374696f6e206265747765656e207573657220616e6420726f757465720a42726f6b6572496e74657266616365456e74697479205a69656c6f6e61476f72612032302032303020313530303030300a);
12
13	INSERT INTO `gssim_results`.`text_property` (`config_id`, `name`, `value`) VALUES
14	(2, 'Grid scheduling', 'GridschedulingFCFSSR'),
15	(2, 'Local grid scheduling', 'FCFSAllocPolicy'),
16	(2, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'),
17	(3, 'Grid scheduling', 'GridschedulingARFCFS'),
18	(3, 'Local grid scheduling', 'LocalGridPluginAR'),
19	(3, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl');
20
21	INSERT INTO `gssim_results`.`experiment` (`PK`, `user_id`, `config_id`, `commission_date`, `name`, `description`, `status`, `metaexp_id`) VALUES
22	(2, 1, 2, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL),
23	(3, 2, 3, NULL, 'exp1', 'exp1 desc', 'RUNNING', NULL),
24	(4, 1, 2, NULL, 'exp1', 'exp1 desc', 'FAILED', NULL),
25	(5, 2, 3, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL);
26
27
28	INSERT INTO `gssim_results`.`experiment_stats` (`id`, `name`, `value`) VALUES
29	('2', 'Delayed tasks', '0'),
30	('2', 'Failed requests (tasks)', '0'),
31	('2', 'Makespan', '57600'),
32	('2', 'Resources queue length', '0.531'),
33	('2', 'Resources total load', '0.49'),
34	('2', 'Resources reservation load', '0.49'),
35	('2', 'Energy usage', '1.312'),
36	('2', 'Task completion time', '29630.769'),
37	('2', 'Task execution time', '13015.385'),
38	('2', 'Task start time', '6092.308'),
39	('2', 'Task flow time', '13015.385'),
40	('2', 'Task waiting time', '6092.308'),
41	('2', 'Task lateness', '0'),
42	('2', 'Task tardiness', '0'),
43	('3', 'Delayed tasks', '0'),
44	('3', 'Failed requests (tasks)', '0'),
45	('2', 'Makespan', '57600'),
46	('3', 'Resources queue length', '0.687'),
47	('3', 'Resources total load', '0.49'),
48	('3', 'Resources reservation load', '0.49'),
49	('3', 'Energy usage', '1.375'),
50	('3', 'Task completion time', '29630.769'),
51	('3', 'Task execution time', '13015.385'),
52	('3', 'Task start time', '6092.308'),
53	('3', 'Task flow time', '13015.385'),
54	('3', 'Task waiting time', '6092.308'),
55	('3', 'Task lateness', '0'),
56	('3', 'Task tardiness', '0'),
57	('4', 'Delayed tasks', '0'),
58	('4', 'Failed requests (tasks)', '0'),
59	('4', 'Makespan', '32400'),
60	('4', 'Resources queue length', '0.389'),
61	('4', 'Resources total load', '0.175'),
62	('4', 'Resources reservation load', '0.183'),
63	('4', 'Energy usage', '0.238'),
64	('4', 'Task completion time', '23398.8'),
65	('4', 'Task execution time', '7920'),
66	('4', 'Task start time', '15478.8'),
67	('4', 'Task flow time', '8278.8'),
68	('4', 'Task waiting time', '15477.6'),
69	('4', 'Task lateness', '-1.2'),
70	('4', 'Task tardiness', '0'),
71	('5', 'Delayed tasks', '0'),
72	('5', 'Failed requests (tasks)', '0'),
73	('2', 'Makespan', '61042'),
74	('5', 'Resources queue length', '0.393'),
75	('5', 'Resources total load', '0.286'),
76	('5', 'Resources reservation load', '0.345'),
77	('5', 'Energy usage', '0.756'),
78	('5', 'Task completion time', '40059.143'),
79	('5', 'Task execution time', '17485.714'),
80	('5', 'Task start time', '3030.571'),
81	('5', 'Task flow time', '20516.286'),
82	('5', 'Task waiting time', '3029.571'),
83	('5', 'Task lateness', '-569.429'),
84	('5', 'Task tardiness', '0');
85
86	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
87	('20', '2', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'),
88	('21', '2', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'),
89	('210', '2', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'),
90	('211', '2', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'),
91	('212', '2', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'),
92	('213', '2', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'),
93	('214', '2', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'),
94	('215', '2', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'),
95	('216', '2', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'),
96	('22', '2', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'),
97	('23', '2', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'),
98	('24', '2', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'),
99	('25', '2', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'),
100	('30', '3', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'),
101	('31', '3', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'),
102	('310', '3', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'),
103	('311', '3', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'),
104	('312', '3', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'),
105	('313', '3', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'),
106	('314', '3', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'),
107	('315', '3', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'),
108	('316', '3', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'),
109	('32', '3', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'),
110	('33', '3', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'),
111	('34', '3', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'),
112	('35', '3', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'),
113	('41', '4', '1', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), '8994', '7200', '1794', '8994', '1793', '1', '0', '-6', '8994'),
114	('43', '4', '3', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14399', '1', '0', '0', '21600'),
115	('44', '4', '4', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '17999', '1', '0', '0', '25200'),
116	('45', '4', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21599', '1', '0', '0', '28800'),
117	('46', '4', '6', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21598', '2', '0', '0', '32400'),
118	('50', '5', '0', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), '17922', '14400', '3522', '17922', '3521', '1', '0', '-78', '17922'),
119	('51', '5', '1', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), '28802', '28800', '2', '28802', '1', '1', '0', '-3598', '28802'),
120	('52', '5', '2', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), '14386', '7200', '3586', '10786', '3585', '1', '0', '-14', '14386'),
121	('53', '5', '3', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), '46786', '21600', '3586', '25186', '3585', '1', '0', '-14', '46786'),
122	('54', '5', '4', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), '53970', '25200', '3570', '28770', '3569', '1', '0', '-30', '53970'),
123	('55', '5', '5', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), '57506', '14400', '3506', '17906', '3505', '1', '0', '-94', '57506'),
124	('56', '5', '6', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), '61042', '10800', '3442', '14242', '3441', '1', '0', '-158', '61042');
125
126	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
127	('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'),
128	('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'),
129	('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'),
130	('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'),
131	('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'),
132	('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'),
133	('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'),
134	('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'),
135	('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'),
136	('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'),
137	('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'),
138	('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'),
139	('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'),
140	('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'),
141	('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'),
142	('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'),
143	('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'),
144	('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'),
145	('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'),
146	('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'),
147	('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'),
148	('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'),
149	('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'),
150	('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'),
151	('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'),
152	('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'),
153	('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'),
154	('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'),
155	('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'),
156	('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'),
157	('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'),
158	('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'),
159	('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'),
160	('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'),
161	('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'),
162	('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'),
163	('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'),
164	('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');
165
166	INSERT INTO `gssim_results`.`resource` (`PK`, `exp_id`, `name`, `type`, `allocation_load`, `reservation_load`) VALUES
167	('21', '2', 'compRes1', 'computing', '0.604', '0.604'),
168	('22', '2', 'compRes2', 'computing', '0.375', '0.375'),
169	('31', '3', 'compRes1', 'computing', '0.646', '0.646'),
170	('32', '3', 'compRes2', 'computing', '0.333', '0.333'),
171	('41', '4', 'compRes1', 'computing', '0.185', '0.185'),
172	('42', '4', 'compRes2', 'computing', '0.222', '0.241'),
173	('43', '4', 'dataRes1', 'data', '0', '0'),
174	('44', '4', 'networkRes1', 'network', '0.438', '0.438'),
175	('51', '5', 'compRes1', 'computing', '0.451', '0.549'),
176	('52', '5', 'compRes2', 'computing', '0.216', '0.255'),
177	('53', '5', 'dataRes1', 'data', '0', '0'),
178	('54', '5', 'networkRes1', 'network', '0.562', '0.562');
179
180	INSERT INTO `gssim_results`.`queues` (`fk_resource_id`, `name`, `avg_length`)
181	VALUES ('21', 'default', '0.437'),
182	('22', 'default', '0.625'),
183	('31', 'default', '1'),
184	('32', 'default', '0.375'),
185	('41', 'default', '0.667'),
186	('42', 'default', '0.5'),
187	('43', 'default', '0'),
188	('51', 'default', '0.414'),
189	('52', 'default', '0.765'),
190	('53', 'default', '0');
191
192
193	INSERT INTO `gssim_results`.`resource_allocation_timeline` (`fk_resource_id`, `timestamp`, `usage`)
194	VALUES ('21', FROM_UNIXTIME(1225666800), '2'),
195	('21', FROM_UNIXTIME(1225674000), '1'),
196	('21', FROM_UNIXTIME(1225681200), '0'),
197	('21', FROM_UNIXTIME(1225688400), '2'),
198	('21', FROM_UNIXTIME(1225692000), '3'),
199	('21', FROM_UNIXTIME(1225699200), '2'),
200	('21', FROM_UNIXTIME(1225706400), '3'),
201	('21', FROM_UNIXTIME(1225710000), '2'),
202	('21', FROM_UNIXTIME(1225713600), '3'),
203	('21', FROM_UNIXTIME(1225717200), '2'),
204	('21', FROM_UNIXTIME(1225720800), '1'),
205	('21', FROM_UNIXTIME(1225724400), '0'),
206	('22', FROM_UNIXTIME(1225666800), '1'),
207	('22', FROM_UNIXTIME(1225670400), '3'),
208	('22', FROM_UNIXTIME(1225677600), '1'),
209	('22', FROM_UNIXTIME(1225681200), '2'),
210	('22', FROM_UNIXTIME(1225684800), '3'),
211	('22', FROM_UNIXTIME(1225688400), '3'),
212	('22', FROM_UNIXTIME(1225692000), '2'),
213	('22', FROM_UNIXTIME(1225695600), '0'),
214	('31', FROM_UNIXTIME(1225666800), '3'),
215	('31', FROM_UNIXTIME(1225674000), '2'),
216	('31', FROM_UNIXTIME(1225681200), '2'),
217	('31', FROM_UNIXTIME(1225684800), '3'),
218	('31', FROM_UNIXTIME(1225688400), '3'),
219	('31', FROM_UNIXTIME(1225692000), '3'),
220	('31', FROM_UNIXTIME(1225695600), '2'),
221	('31', FROM_UNIXTIME(1225699200), '1'),
222	('31', FROM_UNIXTIME(1225713600), '2'),
223	('31', FROM_UNIXTIME(1225717200), '1'),
224	('31', FROM_UNIXTIME(1225724400), '0'),
225	('32', FROM_UNIXTIME(1225666800), '0'),
226	('32', FROM_UNIXTIME(1225670400), '2'),
227	('32', FROM_UNIXTIME(1225677600), '0'),
228	('32', FROM_UNIXTIME(1225688400), '2'),
229	('32', FROM_UNIXTIME(1225695600), '1'),
230	('32', FROM_UNIXTIME(1225706400), '2'),
231	('32', FROM_UNIXTIME(1225710000), '1'),
232	('32', FROM_UNIXTIME(1225720800), '0'),
233	('41', FROM_UNIXTIME(1225666800), '0'),
234	('41', FROM_UNIXTIME(1225688400), '2'),
235	('41', FROM_UNIXTIME(1225695600), '1'),
236	('41', FROM_UNIXTIME(1225699200), '0'),
237	('42', FROM_UNIXTIME(1225666800), '0'),
238	('42', FROM_UNIXTIME(1225668594), '1'),
239	('42', FROM_UNIXTIME(1225675794), '0'),
240	('42', FROM_UNIXTIME(1225681200), '1'),
241	('42', FROM_UNIXTIME(1225684800), '2'),
242	('42', FROM_UNIXTIME(1225688400), '1'),
243	('42', FROM_UNIXTIME(1225692000), '0'),
244	('43', FROM_UNIXTIME(1225666800), '0'),
245	('51', FROM_UNIXTIME(1225666800), '0'),
246	('51', FROM_UNIXTIME(1225670322), '1'),
247	('51', FROM_UNIXTIME(1225673986), '2'),
248	('51', FROM_UNIXTIME(1225681186), '1'),
249	('51', FROM_UNIXTIME(1225684722), '0'),
250	('51', FROM_UNIXTIME(1225691986), '1'),
251	('51', FROM_UNIXTIME(1225695570), '2'),
252	('51', FROM_UNIXTIME(1225709906), '3'),
253	('51', FROM_UNIXTIME(1225713586), '2'),
254	('51', FROM_UNIXTIME(1225720770), '1'),
255	('51', FROM_UNIXTIME(1225724306), '0'),
256	('52', FROM_UNIXTIME(1225666800), '0'),
257	('52', FROM_UNIXTIME(1225666802), '1'),
258	('52', FROM_UNIXTIME(1225695602), '0'),
259	('52', FROM_UNIXTIME(1225717042), '1'),
260	('52', FROM_UNIXTIME(1225727842), '0'),
261	('53', FROM_UNIXTIME(1225666800), '0');
262
263	INSERT INTO `gssim_results`.`resource_energy_timeline` (`fk_resource_id`, `timestamp`, `usage`)
264	VALUES ('21', FROM_UNIXTIME(1225666800), '2'),
265	('21', FROM_UNIXTIME(1225674000), '1'),
266	('21', FROM_UNIXTIME(1225681200), '0'),
267	('21', FROM_UNIXTIME(1225688400), '2'),
268	('21', FROM_UNIXTIME(1225692000), '3'),
269	('21', FROM_UNIXTIME(1225699200), '2'),
270	('21', FROM_UNIXTIME(1225706400), '3'),
271	('21', FROM_UNIXTIME(1225710000), '2'),
272	('21', FROM_UNIXTIME(1225713600), '3'),
273	('21', FROM_UNIXTIME(1225717200), '2'),
274	('21', FROM_UNIXTIME(1225720800), '1'),
275	('21', FROM_UNIXTIME(1225724400), '0'),
276	('22', FROM_UNIXTIME(1225666800), '1'),
277	('22', FROM_UNIXTIME(1225670400), '3'),
278	('22', FROM_UNIXTIME(1225677600), '1'),
279	('22', FROM_UNIXTIME(1225681200), '2'),
280	('22', FROM_UNIXTIME(1225684800), '3'),
281	('22', FROM_UNIXTIME(1225688400), '3'),
282	('22', FROM_UNIXTIME(1225692000), '2'),
283	('22', FROM_UNIXTIME(1225695600), '0'),
284	('31', FROM_UNIXTIME(1225666800), '3'),
285	('31', FROM_UNIXTIME(1225674000), '2'),
286	('31', FROM_UNIXTIME(1225681200), '2'),
287	('31', FROM_UNIXTIME(1225684800), '3'),
288	('31', FROM_UNIXTIME(1225688400), '3'),
289	('31', FROM_UNIXTIME(1225692000), '3'),
290	('31', FROM_UNIXTIME(1225695600), '2'),
291	('31', FROM_UNIXTIME(1225699200), '1'),
292	('31', FROM_UNIXTIME(1225713600), '2'),
293	('31', FROM_UNIXTIME(1225717200), '1'),
294	('31', FROM_UNIXTIME(1225724400), '0'),
295	('32', FROM_UNIXTIME(1225670400), '2'),
296	('32', FROM_UNIXTIME(1225677600), '0'),
297	('32', FROM_UNIXTIME(1225688400), '2'),
298	('32', FROM_UNIXTIME(1225695600), '1'),
299	('32', FROM_UNIXTIME(1225706400), '2'),
300	('32', FROM_UNIXTIME(1225710000), '1'),
301	('32', FROM_UNIXTIME(1225720800), '0'),
302	('41', FROM_UNIXTIME(1225688400), '2'),
303	('41', FROM_UNIXTIME(1225695600), '1'),
304	('41', FROM_UNIXTIME(1225699200), '0'),
305	('42', FROM_UNIXTIME(1225668594), '1'),
306	('42', FROM_UNIXTIME(1225675794), '0'),
307	('42', FROM_UNIXTIME(1225681200), '0'),
308	('42', FROM_UNIXTIME(1225684800), '2'),
309	('42', FROM_UNIXTIME(1225688400), '1'),
310	('42', FROM_UNIXTIME(1225692000), '0'),
311	('51', FROM_UNIXTIME(1225670322), '1'),
312	('51', FROM_UNIXTIME(1225673986), '2'),
313	('51', FROM_UNIXTIME(1225681186), '1'),
314	('51', FROM_UNIXTIME(1225684722), '0'),
315	('51', FROM_UNIXTIME(1225691986), '1'),
316	('51', FROM_UNIXTIME(1225695570), '2'),
317	('51', FROM_UNIXTIME(1225709906), '3'),
318	('51', FROM_UNIXTIME(1225713586), '2'),
319	('51', FROM_UNIXTIME(1225720770), '1'),
320	('51', FROM_UNIXTIME(1225724306), '0'),
321	('52', FROM_UNIXTIME(1225666802), '1'),
322	('52', FROM_UNIXTIME(1225695602), '0'),
323	('52', FROM_UNIXTIME(1225717042), '1'),
324	('52', FROM_UNIXTIME(1225727842), '0');
325
326
327	INSERT INTO `gssim_results`.`unit` (`PK`, `resource_id`, `type`, `name`, `amount`, `allocation_load`, `reservation_load`)
328	VALUES ('210', '21', 'computing', '0@compRes1', '1', '0.562', '0.562'),
329	('211', '21', 'computing', '1@compRes1', '1', '0.812', '0.812'),
330	('212', '21', 'computing', '2@compRes1', '1', '0.437', '0.437'),
331	('220', '22', 'computing', '0@compRes2', '1', '0.5', '0.5'),
332	('221', '22', 'computing', '1@compRes2', '1', '0.375', '0.375'),
333	('222', '22', 'computing', '2@compRes2', '1', '0.25', '0.25'),
334	('310', '31', 'computing', '0@compRes1', '1', '0.625', '0.625'),
335	('311', '31', 'computing', '1@compRes1', '1', '0.812', '0.812'),
336	('312', '31', 'computing', '2@compRes1', '1', '0.5', '0.5'),
337	('320', '32', 'computing', '0@compRes2', '1', '0.5', '0.5'),
338	('321', '32', 'computing', '1@compRes2', '1', '0.5', '0.5'),
339	('322', '32', 'computing', '2@compRes2', '1', '0', '0'),
340	('410', '41', 'computing', '0@compRes1', '1', '0.333', '0.333'),
341	('411', '41', 'computing', '1@compRes1', '1', '0.222', '0.222'),
342	('412', '41', 'computing', '2@compRes1', '1', '0', '0'),
343	('420', '42', 'computing', '0@compRes2', '1', '0.444', '0.5'),
344	('421', '42', 'computing', '1@compRes2', '1', '0.222', '0.222'),
345	('422', '42', 'computing', '2@compRes2', '1', '0', '0'),
346	('430', '43', 'data', '0@compRes3', '1', '0', '0'),
347	('440', '44', 'link', 'R1_R2_link', '1', '0', '0'),
348	('441', '44', 'link', 'R2_R5_link', '1', '0.003981', '0.003981'),
349	('442', '44', 'link', 'R1_R3_link', '1', '0', '0'),
350	('443', '44', 'link', 'R3_R4_link', '1', '0', '0'),
351	('444', '44', 'link', 'R4_R5_link', '1', '0.010617', '0.010617'),
352	('445', '44', 'link', 'compRes1_link', '1', '0.003981', '0.003981'),
353	('446', '44', 'link', 'compRes2_link', '1', '0.010617', '0.010617'),
354	('447', '44', 'link', 'dataRes1_link', '1', '0.014598', '0.014598'),
355	('448', '44', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'),
356	('510', '51', 'computing', '0@compRes1', '1', '0.588', '0.706'),
357	('511', '51', 'computing', '1@compRes1', '1', '0.529', '0.647'),
358	('512', '51', 'computing', '2@compRes1', '1', '0.235', '0.294'),
359	('520', '52', 'computing', '0@compRes2', '1', '0.647', '0.765'),
360	('521', '52', 'computing', '1@compRes2', '1', '0', '0'),
361	('522', '52', 'computing', '2@compRes2', '1', '0', '0'),
362	('530', '53', 'data', '0@compRes3', '1', '0', '0'),
363	('540', '54', 'link', 'R1_R2_link', '1', '0.000261', '0.000261'),
364	('541', '54', 'link', 'R2_R5_link', '1', '0.001438', '0.001438'),
365	('542', '54', 'link', 'R1_R3_link', '1', '0.000261', '0.000261'),
366	('543', '54', 'link', 'R3_R4_link', '1', '0.000261', '0.000261'),
367	('544', '54', 'link', 'R4_R5_link', '1', '0', '0'),
368	('545', '54', 'link', 'compRes1_link', '1', '0.001438', '0.001438'),
369	('546', '54', 'link', 'compRes2_link', '1', '0.000261', '0.000261'),
370	('547', '54', 'link', 'dataRes1_link', '1', '0.001699', '0.001699'),
371	('548', '54', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0');
372
373	INSERT INTO `gssim_results`.`unit_details` (`fk_unit_id`, `name`, `value`)
374	VALUES ('210', 'details', '1'),
375	('211', 'details', '2'),
376	('212', 'details', '3'),
377	('220', 'details', '4'),
378	('221', 'details', '5'),
379	('222', 'details', '6'),
380	('310', 'details', '8'),
381	('311', 'details', '9'),
382	('312', 'details', '10'),
383	('320', 'details', '11'),
384	('321', 'details', '12'),
385	('322', 'details', '13'),
386	('410', 'details', '15'),
387	('411', 'details', '16'),
388	('412', 'details', '17'),
389	('420', 'details', '18'),
390	('421', 'details', '19'),
391	('422', 'details', '20'),
392	('430', 'details', '21'),
393	('440', 'Baud rate (bits/s)', '1000000'),
394	('440', 'delay(ms)', '300'),
395	('440', 'size of transmitted data(in bytes)', '2'),
396	('441', 'Baud rate (bits/s)', '1000000'),
397	('441', 'delay(ms)', '300'),
398	('441', 'size of transmitted data(in bytes)', '0'),
399	('442', 'Baud rate (bits/s)', '1000000'),
400	('442', 'delay(ms)', '300'),
401	('442', 'size of transmitted data(in bytes)', '3'),
402	('443', 'Baud rate (bits/s)', '1000000'),
403	('443', 'delay(ms)', '300'),
404	('443', 'size of transmitted data(in bytes)', '3'),
405	('444', 'Baud rate (bits/s)', '1000000'),
406	('444', 'delay(ms)', '300'),
407	('444', 'size of transmitted data(in bytes)', '0'),
408	('445', 'Baud rate (bits/s)', '1000000'),
409	('445', 'delay(ms)', '300'),
410	('445', 'size of transmitted data(in bytes)', '2'),
411	('446', 'Baud rate (bits/s)', '1000000'),
412	('446', 'delay(ms)', '300'),
413	('446', 'size of transmitted data(in bytes)', '3'),
414	('447', 'Baud rate (bits/s)', '1000000'),
415	('447', 'delay(ms)', '300'),
416	('447', 'size of transmitted data(in bytes)', '0'),
417	('448', 'Baud rate (bits/s)', '1000000'),
418	('448', 'delay(ms)', '300'),
419	('448', 'size of transmitted data(in bytes)', '5'),
420	('510', 'details', '23'),
421	('511', 'details', '24'),
422	('512', 'details', '25'),
423	('520', 'details', '26'),
424	('521', 'details', '27'),
425	('522', 'details', '28'),
426	('530', 'details', '29'),
427	('540', 'Baud rate (bits/s)', '10000000'),
428	('540', 'delay(ms)', '300'),
429	('540', 'size of transmitted data(in bytes)', '5'),
430	('541', 'Baud rate (bits/s)', '10000000'),
431	('541', 'delay(ms)', '300'),
432	('541', 'size of transmitted data(in bytes)', '5'),
433	('542', 'Baud rate (bits/s)', '10000000'),
434	('542', 'delay(ms)', '300'),
435	('542', 'size of transmitted data(in bytes)', '2'),
436	('543', 'Baud rate (bits/s)', '10000000'),
437	('543', 'delay(ms)', '300'),
438	('543', 'size of transmitted data(in bytes)', '2'),
439	('544', 'Baud rate (bits/s)', '10000000'),
440	('544', 'delay(ms)', '300'),
441	('544', 'size of transmitted data(in bytes)', '0'),
442	('545', 'Baud rate (bits/s)', '10000000'),
443	('545', 'delay(ms)', '300'),
444	('545', 'size of transmitted data(in bytes)', '5'),
445	('546', 'Baud rate (bits/s)', '10000000'),
446	('546', 'delay(ms)', '300'),
447	('546', 'size of transmitted data(in bytes)', '2'),
448	('547', 'Baud rate (bits/s)', '10000000'),
449	('547', 'delay(ms)', '300'),
450	('547', 'size of transmitted data(in bytes)', '0'),
451	('548', 'Baud rate (bits/s)', '10000000'),
452	('548', 'delay(ms)', '300'),
453	('548', 'size of transmitted data(in bytes)', '7');
454
455
456	INSERT INTO `gssim_results`.`unit_allocation_timeline` (`fk_unit_id`, `timestamp`, `usage`)
457	VALUES ('210', FROM_UNIXTIME(1225666800), '0.4'),
458	('210', FROM_UNIXTIME(1225674000), '0.2'),
459	('210', FROM_UNIXTIME(1225681200), '0'),
460	('210', FROM_UNIXTIME(1225688400), '0.4'),
461	('210', FROM_UNIXTIME(1225692000), '0.6'),
462	('210', FROM_UNIXTIME(1225699200), '0.4'),
463	('210', FROM_UNIXTIME(1225706400), '0.6'),
464	('210', FROM_UNIXTIME(1225710000), '0.4'),
465	('210', FROM_UNIXTIME(1225713600), '0.6'),
466	('210', FROM_UNIXTIME(1225717200), '0.4'),
467	('210', FROM_UNIXTIME(1225720800), '0.2'),
468	('210', FROM_UNIXTIME(1225724400), '0'),
469	('211', FROM_UNIXTIME(1225666800), '0.6'),
470	('211', FROM_UNIXTIME(1225674000), '0.3'),
471	('211', FROM_UNIXTIME(1225681200), '0'),
472	('211', FROM_UNIXTIME(1225688400), '0.6'),
473	('211', FROM_UNIXTIME(1225692000), '0.9'),
474	('211', FROM_UNIXTIME(1225699200), '0.6'),
475	('211', FROM_UNIXTIME(1225706400), '0.9'),
476	('211', FROM_UNIXTIME(1225710000), '0.6'),
477	('211', FROM_UNIXTIME(1225713600), '0.9'),
478	('211', FROM_UNIXTIME(1225717200), '0.6'),
479	('211', FROM_UNIXTIME(1225720800), '0.3'),
480	('211', FROM_UNIXTIME(1225724400), '0'),
481	('212', FROM_UNIXTIME(1225666800), '1'),
482	('212', FROM_UNIXTIME(1225674000), '0.5'),
483	('212', FROM_UNIXTIME(1225681200), '0'),
484	('212', FROM_UNIXTIME(1225688400), '1'),
485	('212', FROM_UNIXTIME(1225692000), '1.5'),
486	('212', FROM_UNIXTIME(1225699200), '1'),
487	('212', FROM_UNIXTIME(1225706400), '1.5'),
488	('212', FROM_UNIXTIME(1225710000), '1'),
489	('212', FROM_UNIXTIME(1225713600), '1.5'),
490	('212', FROM_UNIXTIME(1225717200), '1'),
491	('212', FROM_UNIXTIME(1225720800), '0.5'),
492	('212', FROM_UNIXTIME(1225724400), '0'),
493	('220', FROM_UNIXTIME(1225666800), '0.2'),
494	('220', FROM_UNIXTIME(1225670400), '0.6'),
495	('220', FROM_UNIXTIME(1225677600), '0.2'),
496	('220', FROM_UNIXTIME(1225681200), '0.4'),
497	('220', FROM_UNIXTIME(1225684800), '0.6'),
498	('220', FROM_UNIXTIME(1225688400), '0.6'),
499	('220', FROM_UNIXTIME(1225692000), '0.4'),
500	('220', FROM_UNIXTIME(1225695600), '0'),
501	('221', FROM_UNIXTIME(1225666800), '0.3'),
502	('221', FROM_UNIXTIME(1225670400), '0.9'),
503	('221', FROM_UNIXTIME(1225677600), '0.3'),
504	('221', FROM_UNIXTIME(1225681200), '0.6'),
505	('221', FROM_UNIXTIME(1225684800), '0.9'),
506	('221', FROM_UNIXTIME(1225688400), '0.9'),
507	('221', FROM_UNIXTIME(1225692000), '0.6'),
508	('221', FROM_UNIXTIME(1225695600), '0'),
509	('222', FROM_UNIXTIME(1225666800), '0.5'),
510	('222', FROM_UNIXTIME(1225670400), '1.5'),
511	('222', FROM_UNIXTIME(1225677600), '0.5'),
512	('222', FROM_UNIXTIME(1225681200), '1'),
513	('222', FROM_UNIXTIME(1225684800), '1.5'),
514	('222', FROM_UNIXTIME(1225688400), '1.5'),
515	('222', FROM_UNIXTIME(1225692000), '1'),
516	('222', FROM_UNIXTIME(1225695600), '0'),
517	('310', FROM_UNIXTIME(1225666800), '0.6'),
518	('310', FROM_UNIXTIME(1225674000), '0.4'),
519	('310', FROM_UNIXTIME(1225681200), '0.4'),
520	('310', FROM_UNIXTIME(1225684800), '0.6'),
521	('310', FROM_UNIXTIME(1225688400), '0.6'),
522	('310', FROM_UNIXTIME(1225692000), '0.6'),
523	('310', FROM_UNIXTIME(1225695600), '0.4'),
524	('310', FROM_UNIXTIME(1225699200), '0.2'),
525	('310', FROM_UNIXTIME(1225713600), '0.4'),
526	('310', FROM_UNIXTIME(1225717200), '0.2'),
527	('310', FROM_UNIXTIME(1225724400), '0'),
528	('311', FROM_UNIXTIME(1225666800), '0.9'),
529	('311', FROM_UNIXTIME(1225674000), '0.6'),
530	('311', FROM_UNIXTIME(1225681200), '0.6'),
531	('311', FROM_UNIXTIME(1225684800), '0.9'),
532	('311', FROM_UNIXTIME(1225688400), '0.9'),
533	('311', FROM_UNIXTIME(1225692000), '0.9'),
534	('311', FROM_UNIXTIME(1225695600), '0.6'),
535	('311', FROM_UNIXTIME(1225699200), '0.3'),
536	('311', FROM_UNIXTIME(1225713600), '0.6'),
537	('311', FROM_UNIXTIME(1225717200), '0.3'),
538	('311', FROM_UNIXTIME(1225724400), '0'),
539	('312', FROM_UNIXTIME(1225666800), '1.5'),
540	('312', FROM_UNIXTIME(1225674000), '1'),
541	('312', FROM_UNIXTIME(1225681200), '1'),
542	('312', FROM_UNIXTIME(1225684800), '1.5'),
543	('312', FROM_UNIXTIME(1225688400), '1.5'),
544	('312', FROM_UNIXTIME(1225692000), '1.5'),
545	('312', FROM_UNIXTIME(1225695600), '1'),
546	('312', FROM_UNIXTIME(1225699200), '0.5'),
547	('312', FROM_UNIXTIME(1225713600), '1'),
548	('312', FROM_UNIXTIME(1225717200), '0.5'),
549	('312', FROM_UNIXTIME(1225724400), '0'),
550	('320', FROM_UNIXTIME(1225666800), '0'),
551	('320', FROM_UNIXTIME(1225670400), '0.4'),
552	('320', FROM_UNIXTIME(1225677600), '0'),
553	('320', FROM_UNIXTIME(1225688400), '0.4'),
554	('320', FROM_UNIXTIME(1225695600), '0.2'),
555	('320', FROM_UNIXTIME(1225706400), '0.4'),
556	('320', FROM_UNIXTIME(1225710000), '0.2'),
557	('320', FROM_UNIXTIME(1225720800), '0'),
558	('321', FROM_UNIXTIME(1225666800), '0'),
559	('321', FROM_UNIXTIME(1225670400), '0.6'),
560	('321', FROM_UNIXTIME(1225677600), '0'),
561	('321', FROM_UNIXTIME(1225688400), '0.6'),
562	('321', FROM_UNIXTIME(1225695600), '0.3'),
563	('321', FROM_UNIXTIME(1225706400), '0.6'),
564	('321', FROM_UNIXTIME(1225710000), '0.3'),
565	('321', FROM_UNIXTIME(1225720800), '0'),
566	('322', FROM_UNIXTIME(1225666800), '0'),
567	('322', FROM_UNIXTIME(1225670400), '1'),
568	('322', FROM_UNIXTIME(1225677600), '0'),
569	('322', FROM_UNIXTIME(1225688400), '1'),
570	('322', FROM_UNIXTIME(1225695600), '0.5'),
571	('322', FROM_UNIXTIME(1225706400), '1'),
572	('322', FROM_UNIXTIME(1225710000), '0.5'),
573	('322', FROM_UNIXTIME(1225720800), '0'),
574	('410', FROM_UNIXTIME(1225666800), '0'),
575	('410', FROM_UNIXTIME(1225688400), '0.4'),
576	('410', FROM_UNIXTIME(1225695600), '0.2'),
577	('410', FROM_UNIXTIME(1225699200), '0'),
578	('411', FROM_UNIXTIME(1225666800), '0'),
579	('411', FROM_UNIXTIME(1225688400), '0.6'),
580	('411', FROM_UNIXTIME(1225695600), '0.3'),
581	('411', FROM_UNIXTIME(1225699200), '0'),
582	('412', FROM_UNIXTIME(1225666800), '0'),
583	('412', FROM_UNIXTIME(1225688400), '1'),
584	('412', FROM_UNIXTIME(1225695600), '0.5'),
585	('412', FROM_UNIXTIME(1225699200), '0'),
586	('420', FROM_UNIXTIME(1225666800), '0'),
587	('420', FROM_UNIXTIME(1225668594), '0.2'),
588	('420', FROM_UNIXTIME(1225675794), '0'),
589	('420', FROM_UNIXTIME(1225681200), '0.2'),
590	('420', FROM_UNIXTIME(1225684800), '0.4'),
591	('420', FROM_UNIXTIME(1225688400), '0.2'),
592	('420', FROM_UNIXTIME(1225692000), '0'),
593	('421', FROM_UNIXTIME(1225666800), '0'),
594	('421', FROM_UNIXTIME(1225668594), '0.3'),
595	('421', FROM_UNIXTIME(1225675794), '0'),
596	('421', FROM_UNIXTIME(1225681200), '0.3'),
597	('421', FROM_UNIXTIME(1225684800), '0.6'),
598	('421', FROM_UNIXTIME(1225688400), '0.3'),
599	('421', FROM_UNIXTIME(1225692000), '0'),
600	('422', FROM_UNIXTIME(1225666800), '0'),
601	('422', FROM_UNIXTIME(1225668594), '0.5'),
602	('422', FROM_UNIXTIME(1225675794), '0'),
603	('422', FROM_UNIXTIME(1225681200), '0.5'),
604	('422', FROM_UNIXTIME(1225684800), '1'),
605	('422', FROM_UNIXTIME(1225688400), '0.5'),
606	('422', FROM_UNIXTIME(1225692000), '0'),
607	('430', FROM_UNIXTIME(1225666800), '0'),
608	('510', FROM_UNIXTIME(1225666800), '0'),
609	('510', FROM_UNIXTIME(1225670322), '0.2'),
610	('510', FROM_UNIXTIME(1225673986), '0.4'),
611	('510', FROM_UNIXTIME(1225681186), '0.2'),
612	('510', FROM_UNIXTIME(1225684722), '0'),
613	('510', FROM_UNIXTIME(1225691986), '0.2'),
614	('510', FROM_UNIXTIME(1225695570), '0.4'),
615	('510', FROM_UNIXTIME(1225709906), '0.6'),
616	('510', FROM_UNIXTIME(1225713586), '0.4'),
617	('510', FROM_UNIXTIME(1225720770), '0.2'),
618	('510', FROM_UNIXTIME(1225724306), '0'),
619	('511', FROM_UNIXTIME(1225666800), '0'),
620	('511', FROM_UNIXTIME(1225670322), '0.3'),
621	('511', FROM_UNIXTIME(1225673986), '0.6'),
622	('511', FROM_UNIXTIME(1225681186), '0.3'),
623	('511', FROM_UNIXTIME(1225684722), '0'),
624	('511', FROM_UNIXTIME(1225691986), '0.3'),
625	('511', FROM_UNIXTIME(1225695570), '0.6'),
626	('511', FROM_UNIXTIME(1225709906), '0.9'),
627	('511', FROM_UNIXTIME(1225713586), '0.6'),
628	('511', FROM_UNIXTIME(1225720770), '0.3'),
629	('511', FROM_UNIXTIME(1225724306), '0'),
630	('512', FROM_UNIXTIME(1225666800), '0'),
631	('512', FROM_UNIXTIME(1225670322), '0.5'),
632	('512', FROM_UNIXTIME(1225673986), '1'),
633	('512', FROM_UNIXTIME(1225681186), '0.5'),
634	('512', FROM_UNIXTIME(1225684722), '0'),
635	('512', FROM_UNIXTIME(1225691986), '0.5'),
636	('512', FROM_UNIXTIME(1225695570), '1'),
637	('512', FROM_UNIXTIME(1225709906), '1.5'),
638	('512', FROM_UNIXTIME(1225713586), '1'),
639	('512', FROM_UNIXTIME(1225720770), '0.5'),
640	('512', FROM_UNIXTIME(1225724306), '0'),
641	('520', FROM_UNIXTIME(1225666800), '0'),
642	('520', FROM_UNIXTIME(1225666802), '0.2'),
643	('520', FROM_UNIXTIME(1225695602), '0'),
644	('520', FROM_UNIXTIME(1225717042), '0.2'),
645	('520', FROM_UNIXTIME(1225727842), '0'),
646	('521', FROM_UNIXTIME(1225666800), '0'),
647	('521', FROM_UNIXTIME(1225666802), '0.3'),
648	('521', FROM_UNIXTIME(1225695602), '0'),
649	('521', FROM_UNIXTIME(1225717042), '0.3'),
650	('521', FROM_UNIXTIME(1225727842), '0'),
651	('522', FROM_UNIXTIME(1225666800), '0'),
652	('522', FROM_UNIXTIME(1225666802), '0.5'),
653	('522', FROM_UNIXTIME(1225695602), '0'),
654	('522', FROM_UNIXTIME(1225717042), '0.5'),
655	('522', FROM_UNIXTIME(1225727842), '0'),
656	('530', FROM_UNIXTIME(1225666800), '0');
657
658
659	INSERT INTO `gssim_results`.`unit_energy_timeline` (`fk_unit_id`, `timestamp`, `usage`)
660	VALUES ('210', FROM_UNIXTIME(1225666800), '1.4'),
661	('210', FROM_UNIXTIME(1225674000), '0.7'),
662	('210', FROM_UNIXTIME(1225681200), '0'),
663	('210', FROM_UNIXTIME(1225688400), '1.4'),
664	('210', FROM_UNIXTIME(1225692000), '2.1'),
665	('210', FROM_UNIXTIME(1225699200), '1.4'),
666	('210', FROM_UNIXTIME(1225706400), '2.1'),
667	('210', FROM_UNIXTIME(1225710000), '1.4'),
668	('210', FROM_UNIXTIME(1225713600), '2.1'),
669	('210', FROM_UNIXTIME(1225717200), '1.4'),
670	('210', FROM_UNIXTIME(1225720800), '0.7'),
671	('210', FROM_UNIXTIME(1225724400), '0'),
672	('211', FROM_UNIXTIME(1225666800), '0.2'),
673	('211', FROM_UNIXTIME(1225674000), '0.1'),
674	('211', FROM_UNIXTIME(1225681200), '0'),
675	('211', FROM_UNIXTIME(1225688400), '0.2'),
676	('211', FROM_UNIXTIME(1225692000), '0.3'),
677	('211', FROM_UNIXTIME(1225699200), '0.2'),
678	('211', FROM_UNIXTIME(1225706400), '0.3'),
679	('211', FROM_UNIXTIME(1225710000), '0.2'),
680	('211', FROM_UNIXTIME(1225713600), '0.3'),
681	('211', FROM_UNIXTIME(1225717200), '0.2'),
682	('211', FROM_UNIXTIME(1225720800), '0.1'),
683	('211', FROM_UNIXTIME(1225724400), '0'),
684	('220', FROM_UNIXTIME(1225666800), '0.7'),
685	('220', FROM_UNIXTIME(1225670400), '2.1'),
686	('220', FROM_UNIXTIME(1225677600), '0.7'),
687	('220', FROM_UNIXTIME(1225681200), '1.4'),
688	('220', FROM_UNIXTIME(1225684800), '2.1'),
689	('220', FROM_UNIXTIME(1225688400), '2.1'),
690	('220', FROM_UNIXTIME(1225692000), '1.4'),
691	('220', FROM_UNIXTIME(1225695600), '0'),
692	('221', FROM_UNIXTIME(1225666800), '0.1'),
693	('221', FROM_UNIXTIME(1225670400), '0.3'),
694	('221', FROM_UNIXTIME(1225677600), '0.1'),
695	('221', FROM_UNIXTIME(1225681200), '0.2'),
696	('221', FROM_UNIXTIME(1225684800), '0.3'),
697	('221', FROM_UNIXTIME(1225688400), '0.3'),
698	('221', FROM_UNIXTIME(1225692000), '0.2'),
699	('221', FROM_UNIXTIME(1225695600), '0'),
700	('212', FROM_UNIXTIME(1225666800), '0.4'),
701	('212', FROM_UNIXTIME(1225674000), '0.2'),
702	('212', FROM_UNIXTIME(1225681200), '0'),
703	('212', FROM_UNIXTIME(1225688400), '0.4'),
704	('212', FROM_UNIXTIME(1225692000), '0.6'),
705	('212', FROM_UNIXTIME(1225699200), '0.4'),
706	('212', FROM_UNIXTIME(1225706400), '0.6'),
707	('212', FROM_UNIXTIME(1225710000), '0.4'),
708	('212', FROM_UNIXTIME(1225713600), '0.6'),
709	('212', FROM_UNIXTIME(1225717200), '0.4'),
710	('212', FROM_UNIXTIME(1225720800), '0.2'),
711	('212', FROM_UNIXTIME(1225724400), '0'),
712	('222', FROM_UNIXTIME(1225666800), '0.2'),
713	('222', FROM_UNIXTIME(1225670400), '0.6'),
714	('222', FROM_UNIXTIME(1225677600), '0.2'),
715	('222', FROM_UNIXTIME(1225681200), '0.4'),
716	('222', FROM_UNIXTIME(1225684800), '0.6'),
717	('222', FROM_UNIXTIME(1225688400), '0.6'),
718	('222', FROM_UNIXTIME(1225692000), '0.4'),
719	('222', FROM_UNIXTIME(1225695600), '0'),
720	('310', FROM_UNIXTIME(1225666800), '2.1'),
721	('310', FROM_UNIXTIME(1225674000), '1.4'),
722	('310', FROM_UNIXTIME(1225681200), '1.4'),
723	('310', FROM_UNIXTIME(1225684800), '2.1'),
724	('310', FROM_UNIXTIME(1225688400), '2.1'),
725	('310', FROM_UNIXTIME(1225692000), '2.1'),
726	('310', FROM_UNIXTIME(1225695600), '1.4'),
727	('310', FROM_UNIXTIME(1225699200), '0.7'),
728	('310', FROM_UNIXTIME(1225713600), '1.4'),
729	('310', FROM_UNIXTIME(1225717200), '0.7'),
730	('310', FROM_UNIXTIME(1225724400), '0'),
731	('311', FROM_UNIXTIME(1225666800), '0.3'),
732	('311', FROM_UNIXTIME(1225674000), '0.2'),
733	('311', FROM_UNIXTIME(1225681200), '0.2'),
734	('311', FROM_UNIXTIME(1225684800), '0.3'),
735	('311', FROM_UNIXTIME(1225688400), '0.3'),
736	('311', FROM_UNIXTIME(1225692000), '0.3'),
737	('311', FROM_UNIXTIME(1225695600), '0.2'),
738	('311', FROM_UNIXTIME(1225699200), '0.1'),
739	('311', FROM_UNIXTIME(1225713600), '0.2'),
740	('311', FROM_UNIXTIME(1225717200), '0.1'),
741	('311', FROM_UNIXTIME(1225724400), '0'),
742	('312', FROM_UNIXTIME(1225666800), '0.6'),
743	('312', FROM_UNIXTIME(1225674000), '0.4'),
744	('312', FROM_UNIXTIME(1225681200), '0.4'),
745	('312', FROM_UNIXTIME(1225684800), '0.6'),
746	('312', FROM_UNIXTIME(1225688400), '0.6'),
747	('312', FROM_UNIXTIME(1225692000), '0.6'),
748	('312', FROM_UNIXTIME(1225695600), '0.4'),
749	('312', FROM_UNIXTIME(1225699200), '0.2'),
750	('312', FROM_UNIXTIME(1225713600), '0.4'),
751	('312', FROM_UNIXTIME(1225717200), '0.2'),
752	('312', FROM_UNIXTIME(1225724400), '0'),
753	('320', FROM_UNIXTIME(1225670400), '1.4'),
754	('320', FROM_UNIXTIME(1225677600), '0'),
755	('320', FROM_UNIXTIME(1225688400), '1.4'),
756	('320', FROM_UNIXTIME(1225695600), '0.7'),
757	('320', FROM_UNIXTIME(1225706400), '1.4'),
758	('320', FROM_UNIXTIME(1225710000), '0.7'),
759	('320', FROM_UNIXTIME(1225720800), '0'),
760	('321', FROM_UNIXTIME(1225670400), '0.2'),
761	('321', FROM_UNIXTIME(1225677600), '0'),
762	('321', FROM_UNIXTIME(1225688400), '0.2'),
763	('321', FROM_UNIXTIME(1225695600), '0.1'),
764	('321', FROM_UNIXTIME(1225706400), '0.2'),
765	('321', FROM_UNIXTIME(1225710000), '0.1'),
766	('321', FROM_UNIXTIME(1225720800), '0'),
767	('322', FROM_UNIXTIME(1225670400), '0.4'),
768	('322', FROM_UNIXTIME(1225677600), '0'),
769	('322', FROM_UNIXTIME(1225688400), '0.4'),
770	('322', FROM_UNIXTIME(1225695600), '0.2'),
771	('322', FROM_UNIXTIME(1225706400), '0.4'),
772	('322', FROM_UNIXTIME(1225710000), '0.2'),
773	('322', FROM_UNIXTIME(1225720800), '0'),
774	('410', FROM_UNIXTIME(1225688400), '1.4'),
775	('410', FROM_UNIXTIME(1225695600), '0.7'),
776	('410', FROM_UNIXTIME(1225699200), '0'),
777	('411', FROM_UNIXTIME(1225688400), '0.2'),
778	('411', FROM_UNIXTIME(1225695600), '0.1'),
779	('411', FROM_UNIXTIME(1225699200), '0'),
780	('412', FROM_UNIXTIME(1225688400), '0.4'),
781	('412', FROM_UNIXTIME(1225695600), '0.2'),
782	('412', FROM_UNIXTIME(1225699200), '0'),
783	('420', FROM_UNIXTIME(1225668594), '0.7'),
784	('420', FROM_UNIXTIME(1225675794), '0'),
785	('420', FROM_UNIXTIME(1225681200), '0'),
786	('420', FROM_UNIXTIME(1225684800), '1.4'),
787	('420', FROM_UNIXTIME(1225688400), '0.7'),
788	('420', FROM_UNIXTIME(1225692000), '0'),
789	('421', FROM_UNIXTIME(1225668594), '0.1'),
790	('421', FROM_UNIXTIME(1225675794), '0'),
791	('421', FROM_UNIXTIME(1225681200), '0'),
792	('421', FROM_UNIXTIME(1225684800), '0.2'),
793	('421', FROM_UNIXTIME(1225688400), '0.1'),
794	('421', FROM_UNIXTIME(1225692000), '0'),
795	('422', FROM_UNIXTIME(1225668594), '0.2'),
796	('422', FROM_UNIXTIME(1225675794), '0'),
797	('422', FROM_UNIXTIME(1225681200), '0'),
798	('422', FROM_UNIXTIME(1225684800), '0.4'),
799	('422', FROM_UNIXTIME(1225688400), '0.2'),
800	('422', FROM_UNIXTIME(1225692000), '0'),
801	('510', FROM_UNIXTIME(1225670322), '0.7'),
802	('510', FROM_UNIXTIME(1225673986), '1.4'),
803	('510', FROM_UNIXTIME(1225681186), '0.7'),
804	('510', FROM_UNIXTIME(1225684722), '0'),
805	('510', FROM_UNIXTIME(1225691986), '0.7'),
806	('510', FROM_UNIXTIME(1225695570), '1.4'),
807	('510', FROM_UNIXTIME(1225709906), '2.1'),
808	('510', FROM_UNIXTIME(1225713586), '1.4'),
809	('510', FROM_UNIXTIME(1225720770), '0.7'),
810	('510', FROM_UNIXTIME(1225724306), '0'),
811	('511', FROM_UNIXTIME(1225670322), '0.1'),
812	('511', FROM_UNIXTIME(1225673986), '0.2'),
813	('511', FROM_UNIXTIME(1225681186), '0.1'),
814	('511', FROM_UNIXTIME(1225684722), '0'),
815	('511', FROM_UNIXTIME(1225691986), '0.1'),
816	('511', FROM_UNIXTIME(1225695570), '0.2'),
817	('511', FROM_UNIXTIME(1225709906), '0.3'),
818	('511', FROM_UNIXTIME(1225713586), '0.2'),
819	('511', FROM_UNIXTIME(1225720770), '0.1'),
820	('511', FROM_UNIXTIME(1225724306), '0'),
821	('512', FROM_UNIXTIME(1225670322), '0.2'),
822	('512', FROM_UNIXTIME(1225673986), '0.4'),
823	('512', FROM_UNIXTIME(1225681186), '0.2'),
824	('512', FROM_UNIXTIME(1225684722), '0'),
825	('512', FROM_UNIXTIME(1225691986), '0.2'),
826	('512', FROM_UNIXTIME(1225695570), '0.4'),
827	('512', FROM_UNIXTIME(1225709906), '0.6'),
828	('512', FROM_UNIXTIME(1225713586), '0.4'),
829	('512', FROM_UNIXTIME(1225720770), '0.2'),
830	('512', FROM_UNIXTIME(1225724306), '0'),
831	('520', FROM_UNIXTIME(1225666802), '0.7'),
832	('520', FROM_UNIXTIME(1225695602), '0'),
833	('520', FROM_UNIXTIME(1225717042), '0.7'),
834	('520', FROM_UNIXTIME(1225727842), '0'),
835	('521', FROM_UNIXTIME(1225666802), '0.1'),
836	('521', FROM_UNIXTIME(1225695602), '0'),
837	('521', FROM_UNIXTIME(1225717042), '0.1'),
838	('521', FROM_UNIXTIME(1225727842), '0'),
839	('522', FROM_UNIXTIME(1225666802), '0.2'),
840	('522', FROM_UNIXTIME(1225695602), '0'),
841	('522', FROM_UNIXTIME(1225717042), '0.2'),
842	('522', FROM_UNIXTIME(1225727842), '0');
843
844	INSERT INTO `gssim_results`.`allocation` (`PK`, `task_id`, `unit_id`, `begin`, `end`)
845	VALUES ('0', '2000', '210', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)),
846	('1', '2100', '221', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),
847	('2', '21000', '211', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)),
848	('3', '21100', '220', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)),
849	('4', '21200', '222', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),
850	('5', '21300', '211', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)),
851	('6', '21400', '212', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)),
852	('7', '21500', '210', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)),
853	('8', '21600', '211', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)),
854	('9', '2200', '221', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),
855	('10', '2300', '222', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),
856	('11', '2400', '221', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),
857	('12', '2500', '210', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),
858	('13', '3000', '310', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)),
859	('14', '3100', '320', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),
860	('15', '31000', '311', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)),
861	('16', '31100', '312', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)),
862	('17', '31200', '321', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)),
863	('18', '31300', '321', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)),
864	('19', '31400', '311', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)),
865	('20', '31500', '320', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)),
866	('21', '31600', '310', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)),
867	('22', '3200', '310', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),
868	('23', '3300', '311', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),
869	('24', '3400', '320', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),
870	('25', '3500', '310', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),
871	('26', '4100', '420', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225674800)),
872	('27', '4300', '420', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)),
873	('28', '4400', '421', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)),
874	('29', '4500', '411', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)),
875	('30', '4600', '410', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)),
876	('31', '5000', '510', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225683800)),
877	('32', '5100', '520', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225698200)),
878	('33', '5200', '511', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225680200)),
879	('34', '5300', '510', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225712600)),
880	('35', '5400', '511', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225719800)),
881	('36', '5500', '512', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225723400)),
882	('37', '5600', '520', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225727000));
883
884
885	INSERT INTO `gssim_results`.`allocation_details` (`fk_allocation_id`, `name`, `value`)
886	VALUES ('0', 'allocation_detail', '0'),
887	('1', 'allocation_detail', '1'),
888	('2', 'allocation_detail', '2'),
889	('3', 'allocation_detail', '3'),
890	('4', 'allocation_detail', '4'),
891	('5', 'allocation_detail', '5'),
892	('6', 'allocation_detail', '6'),
893	('7', 'allocation_detail', '7'),
894	('8', 'allocation_detail', '8'),
895	('9', 'allocation_detail', '9'),
896	('10', 'allocation_detail', '10'),
897	('11', 'allocation_detail', '11'),
898	('12', 'allocation_detail', '12'),
899	('13', 'allocation_detail', '13'),
900	('14', 'allocation_detail', '14'),
901	('15', 'allocation_detail', '15'),
902	('16', 'allocation_detail', '16'),
903	('17', 'allocation_detail', '17'),
904	('18', 'allocation_detail', '18'),
905	('19', 'allocation_detail', '19'),
906	('20', 'allocation_detail', '20'),
907	('21', 'allocation_detail', '21'),
908	('22', 'allocation_detail', '22'),
909	('23', 'allocation_detail', '23'),
910	('24', 'allocation_detail', '24'),
911	('25', 'allocation_detail', '25'),
912	('26', 'allocation_detail', '26'),
913	('27', 'allocation_detail', '27'),
914	('28', 'allocation_detail', '28'),
915	('29', 'allocation_detail', '29'),
916	('30', 'allocation_detail', '30'),
917	('31', 'allocation_detail', '31'),
918	('32', 'allocation_detail', '32'),
919	('33', 'allocation_detail', '33'),
920	('34', 'allocation_detail', '34'),
921	('35', 'allocation_detail', '35'),
922	('36', 'allocation_detail', '36'),
923	('37', 'allocation_detail', '37');
924
925
926	INSERT INTO `gssim_results`.`reservation` (`PK`, `task_id`, `unit_id`, `begin`, `end`)
927	VALUES ('0', '2000', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)),
928	('1', '2100', '221', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),
929	('2', '21000', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)),
930	('3', '21100', '220', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)),
931	('4', '21200', '222', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),
932	('5', '21300', '211', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)),
933	('6', '21400', '212', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)),
934	('7', '21500', '210', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)),
935	('8', '21600', '211', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)),
936	('9', '2200', '221', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),
937	('10', '2300', '222', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),
938	('11', '2400', '221', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),
939	('12', '2500', '210', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),
940	('13', '3000', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)),
941	('14', '3100', '320', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),
942	('15', '31000', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)),
943	('16', '31100', '312', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)),
944	('17', '31200', '321', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)),
945	('18', '31300', '321', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)),
946	('19', '31400', '311', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)),
947	('20', '31500', '320', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)),
948	('21', '31600', '310', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)),
949	('22', '3200', '310', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),
950	('23', '3300', '311', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),
951	('24', '3400', '320', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),
952	('25', '3500', '310', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),
953	('26', '4100', '420', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225675800)),
954	('27', '4300', '420', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)),
955	('28', '4400', '421', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)),
956	('29', '4500', '411', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)),
957	('30', '4600', '410', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)),
958	('31', '5000', '510', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225684800)),
959	('32', '5100', '520', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225699200)),
960	('33', '5200', '511', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225681200)),
961	('34', '5300', '510', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225713600)),
962	('35', '5400', '511', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225720800)),
963	('36', '5500', '512', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225724400)),
964	('37', '5600', '520', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225728000));
965
966
967	INSERT INTO `gssim_results`.`reservation_details` (`fk_reservation_id`, `name`, `value`)
968	VALUES ('0', 'reservation_detail', '0'),
969	('1', 'reservation_detail', '1'),
970	('2', 'reservation_detail', '2'),
971	('3', 'reservation_detail', '3'),
972	('4', 'reservation_detail', '4'),
973	('5', 'reservation_detail', '5'),
974	('6', 'reservation_detail', '6'),
975	('7', 'reservation_detail', '7'),
976	('8', 'reservation_detail', '8'),
977	('9', 'reservation_detail', '9'),
978	('10', 'reservation_detail', '10'),
979	('11', 'reservation_detail', '11'),
980	('12', 'reservation_detail', '12'),
981	('13', 'reservation_detail', '13'),
982	('14', 'reservation_detail', '14'),
983	('15', 'reservation_detail', '15'),
984	('16', 'reservation_detail', '16'),
985	('17', 'reservation_detail', '17'),
986	('18', 'reservation_detail', '18'),
987	('19', 'reservation_detail', '19'),
988	('20', 'reservation_detail', '20'),
989	('21', 'reservation_detail', '21'),
990	('22', 'reservation_detail', '22'),
991	('23', 'reservation_detail', '23'),
992	('24', 'reservation_detail', '24'),
993	('25', 'reservation_detail', '25'),
994	('26', 'reservation_detail', '26'),
995	('27', 'reservation_detail', '27'),
996	('28', 'reservation_detail', '28'),
997	('29', 'reservation_detail', '29'),
998	('30', 'reservation_detail', '30'),
999	('31', 'reservation_detail', '31'),
1000	('32', 'reservation_detail', '32'),
1001	('33', 'reservation_detail', '33'),
1002	('34', 'reservation_detail', '34'),
1003	('35', 'reservation_detail', '35'),
1004	('36', 'reservation_detail', '36'),
1005	('37', 'reservation_detail', '37');
1006
1007
1008	INSERT INTO `plugin` (`id`, `name`, `is_global`, `description`, `input`) VALUES
1009	(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),
1010	(2, 'GridARAllSlots', 1, NULL, NULL),
1011	(3, 'GridARFirstFit', 1, NULL, NULL),
1012	(4, 'GridARNRDijkstra', 1, NULL, NULL),
1013	(5, 'GridARNRSpecificPath', 1, NULL, NULL),
1014	(6, 'GridRoundRobinPlugin', 1, NULL, NULL),
1015	(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),
1016	(8, 'ARFirstFit', 0, NULL, NULL),
1017	(9, 'FCFSLocalPlugin', 0, NULL, NULL);
1018
1019
1020	INSERT INTO `plugin_compatibility` (`parent_id`, `child_id`) VALUES
1021	(2, 7),
1022	(3, 8),
1023	(4, 8),
1024	(5, 8),
1025	(6, 9);

Note: See TracBrowser for help on using the repository browser.

Context Navigation

source: xssim/trunk/db/example/data.sql @ 104

Download in other formats: