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/schema.sql | 9 ++-------
 1 file changed, 2 insertions(+), 7 deletions(-)

(limited to 'database/schema.sql')

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
-- 
cgit v1.2.3

