summaryrefslogtreecommitdiff
path: root/database/schema.sql
diff options
context:
space:
mode:
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