summaryrefslogtreecommitdiff
path: root/database/schema.sql
diff options
context:
space:
mode:
authorGeorgios Andreadis <g.andreadis@student.tudelft.nl>2018-02-06 11:59:54 +0100
committerGeorgios Andreadis <g.andreadis@student.tudelft.nl>2018-02-06 11:59:54 +0100
commite7880192e47115abf648310f0f48883da18c1bb0 (patch)
treee65add15228d89e119284174a1e219d976f59daa /database/schema.sql
parent6b078c67594fac6bf5ee0204552d6330a5fff2d6 (diff)
Add GWF conversion script
Diffstat (limited to 'database/schema.sql')
-rw-r--r--database/schema.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/database/schema.sql b/database/schema.sql
index 89ba841e..c6f34f17 100644
--- a/database/schema.sql
+++ b/database/schema.sql
@@ -176,11 +176,11 @@ CREATE TABLE jobs (
-- A task that's defined in terms of how many flops (floating point operations) it takes to complete
DROP TABLE IF EXISTS tasks;
CREATE TABLE tasks (
- id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
- start_tick INTEGER NOT NULL CHECK (start_tick >= 0),
- total_flop_count INTEGER NOT NULL,
- job_id INTEGER NOT NULL,
- parallelizability VARCHAR(50) NOT NULL,
+ id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
+ start_tick INTEGER NOT NULL CHECK (start_tick >= 0),
+ total_flop_count BIGINT NOT NULL,
+ job_id INTEGER NOT NULL,
+ parallelizability VARCHAR(50) NOT NULL,
FOREIGN KEY (job_id) REFERENCES jobs (id)
ON DELETE CASCADE