From 4ad9df0973a5efc160feda37e9dba3f1bcfb08fd Mon Sep 17 00:00:00 2001
From: Matthijs Bijman <matthijs@bijman.org>
Date: Mon, 27 Feb 2017 13:15:42 +0100
Subject: Add cores_used column to task_states table

---
 database/schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'database/schema.sql')

diff --git a/database/schema.sql b/database/schema.sql
index 5604d419..01172b99 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -148,8 +148,9 @@ CREATE TABLE IF NOT EXISTS task_states (
     id                      INTEGER PRIMARY KEY     NOT NULL,
     task_id                 INTEGER                 NOT NULL,
     experiment_id           INTEGER                 NOT NULL,
-    tick                    INTEGER                 NOT NULL,
-    flops_left              INTEGER                 NOT NULL,
+    tick                    INTEGER                 NOT NULL CHECK (tick >= 0),
+    flops_left              INTEGER                 NOT NULL CHECK (flops_left >= 0),
+	cores_used				INTEGER					NOT NULL CHECK (cores_used >= 0),
 
     FOREIGN KEY (task_id) REFERENCES tasks (id),
     FOREIGN KEY (experiment_id) REFERENCES experiments (id)
-- 
cgit v1.2.3


From b55ad82adcb624a2c844b75e768187b175242f7e Mon Sep 17 00:00:00 2001
From: Matthijs Bijman <matthijs@bijman.org>
Date: Mon, 27 Feb 2017 15:38:31 +0100
Subject: Add parallelizability and new schedulers to sql schema/test data

---
 database/schema.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'database/schema.sql')

diff --git a/database/schema.sql b/database/schema.sql
index 01172b99..ef67a8b0 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -115,6 +115,8 @@ CREATE TABLE IF NOT EXISTS schedulers (
     name                    TEXT PRIMARY KEY        NOT NULL
 );
 INSERT INTO schedulers (name) VALUES ("DEFAULT");
+INSERT INTO schedulers (name) VALUES ("SRTF");
+INSERT INTO schedulers (name) VALUES ("FIFO");
 
 /*
 *   Each simulation has a single trace. A trace contains tasks and their start times.
@@ -133,6 +135,7 @@ CREATE TABLE IF NOT EXISTS tasks (
     total_flop_count        INTEGER                 NOT NULL,
     trace_id                INTEGER                 NOT NULL,
     task_dependency_id      INTEGER                 NULL,
+	parallelizability		TEXT					NOT NULL,
 
     FOREIGN KEY (trace_id) REFERENCES traces (id) ON DELETE CASCADE ON UPDATE CASCADE,
     FOREIGN KEY (task_dependency_id) REFERENCES tasks (id) ON DELETE CASCADE ON UPDATE CASCADE
-- 
cgit v1.2.3

