diff options
Diffstat (limited to 'database/schema.sql')
| -rw-r--r-- | database/schema.sql | 9 |
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 |