From e7880192e47115abf648310f0f48883da18c1bb0 Mon Sep 17 00:00:00 2001 From: Georgios Andreadis Date: Tue, 6 Feb 2018 11:59:54 +0100 Subject: Add GWF conversion script --- database/schema.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'database/schema.sql') 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 -- cgit v1.2.3