From 1e555619094c310ad7ed060fa28bc0a26b565896 Mon Sep 17 00:00:00 2001
From: Matthijs Bijman <matthijs@bijman.org>
Date: Thu, 16 Feb 2017 22:04:47 +0100
Subject: Add state and last_simulated_tick to experiment, remove
 queued_experiments

---
 database/test.sql | 13 ++++---------
 1 file changed, 4 insertions(+), 9 deletions(-)

(limited to 'database/test.sql')

diff --git a/database/test.sql b/database/test.sql
index 775ff584..69304767 100644
--- a/database/test.sql
+++ b/database/test.sql
@@ -46,10 +46,10 @@ INSERT INTO tasks (start_tick, total_flop_count, trace_id) VALUES (26, 10000, 1)
 INSERT INTO tasks (start_tick, total_flop_count, trace_id, task_dependency_id) VALUES (80, 200000, 1, 1);
 
 -- Experiments
-INSERT INTO experiments (simulation_id, path_id, trace_id, scheduler_name, name)
-    VALUES (1, 1, 1, 'DEFAULT', 'Experiment 1');
-INSERT INTO experiments (simulation_id, path_id, trace_id, scheduler_name, name)
-    VALUES (1, 2, 1, 'DEFAULT', 'Experiment 2');
+INSERT INTO experiments (simulation_id, path_id, trace_id, scheduler_name, name, state, last_simulated_tick)
+    VALUES (1, 1, 1, 'DEFAULT', 'Experiment 1', 'QUEUED', 0);
+INSERT INTO experiments (simulation_id, path_id, trace_id, scheduler_name, name, state, last_simulated_tick)
+    VALUES (1, 2, 1, 'DEFAULT', 'Experiment 2', 'QUEUED', 0);
 
 -- Rooms
 INSERT INTO rooms (name, datacenter_id, type) VALUES ('room 1', 1, 'SERVER');
@@ -224,8 +224,3 @@ INSERT INTO memories (manufacturer, family, generation, model, speed_mb_per_s, s
 
 INSERT INTO storages (manufacturer, family, generation, model, speed_mb_per_s, size_mb, energy_consumption_w, 
 	failure_model_id) VALUES ('samsung', 'EVO', '2016', 'SATA III', 6000, 250000, 10, 1);
-
--- Simulation queue
-INSERT INTO queued_experiments (experiment_id) VALUES (1);
-INSERT INTO queued_experiments (experiment_id) VALUES (2);
-
-- 
cgit v1.2.3

