From 1e555619094c310ad7ed060fa28bc0a26b565896 Mon Sep 17 00:00:00 2001 From: Matthijs Bijman 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