Add state and last_simulated_tick to experiment, remove queued_experiments

1 files changed, 2 insertions, 7 deletions

diff --git a/database/schema.sql b/database/schema.sql
index ab9fd3a0..5604d419 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -74,6 +74,8 @@ CREATE TABLE IF NOT EXISTS experiments (
     trace_id                INTEGER                 NOT NULL,
     scheduler_name          TEXT                    NOT NULL,
     name                    TEXT                    NOT NULL,
+	state					TEXT					NOT NULL,
+	last_simulated_tick		INTEGER					NOT NULL DEFAULT 0 CHECK (last_simulated_tick >= 0),
 
     FOREIGN KEY (simulation_id) REFERENCES simulations (id) ON DELETE CASCADE ON UPDATE CASCADE
     FOREIGN KEY (path_id) REFERENCES paths (id) ON DELETE CASCADE ON UPDATE CASCADE
@@ -81,13 +83,6 @@ CREATE TABLE IF NOT EXISTS experiments (
     FOREIGN KEY (scheduler_name) REFERENCES schedulers (name) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
--- Queued experiments are ready to be run by the simulator
-CREATE TABLE IF NOT EXISTS queued_experiments (
-    experiment_id           INTEGER                 NOT NULL,
-
-    FOREIGN KEY (experiment_id) REFERENCES experiments (id) ON DELETE CASCADE ON UPDATE CASCADE
-);
-
 /*
 *   A Simulation has several Paths, which each contain Sections. A Section details which Datacenter topology to use
 *   starting at which point in time (known internally as a "tick"). So, combining the several Sections in a Path