From 1300d23d5661ec860e2ed99d08f656c9aab83690 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Franti=C5=A1ek=20Dvo=C5=99=C3=A1k?= Date: Fri, 6 Mar 2015 23:03:50 +0100 Subject: [PATCH] Index also time cilumns in subjobs. --- create.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/create.sql b/create.sql index be25f40..af9aef2 100644 --- a/create.sql +++ b/create.sql @@ -29,7 +29,9 @@ CREATE TABLE subjobs ( finish BIGINT, INDEX(id), - INDEX(jobid) + INDEX(jobid), + INDEX(start), + INDEX(finish) ); @@ -45,7 +47,7 @@ CREATE TABLE jobnodes ( CREATE TABLE nodes ( id INTEGER PRIMARY KEY AUTO_INCREMENT, - host VARCHAR(256) UNIQUE, + host VARCHAR(256), INDEX(host) ); -- 1.8.2.3