From 1c690e4e6cc078d72af8465d120a3a8ff88978e5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Franti=C5=A1ek=20Dvo=C5=99=C3=A1k?= Date: Wed, 4 Mar 2015 15:41:48 +0100 Subject: [PATCH] Database schema. --- create.sql | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 create.sql diff --git a/create.sql b/create.sql new file mode 100644 index 0000000..92d4d25 --- /dev/null +++ b/create.sql @@ -0,0 +1,42 @@ +CREATE TABLE job ( + id CHAR(80) PRIMARY KEY, + user CHAR(20), + status CHAR(20), + submit BIGINT, + start BIGINT, + finish BIGINT, + + memory_seconds INTEGER, + cpu_seconds INTEGER, + map INTEGER, + reduce INTEGER, + + changed TIMESTAMP, + + INDEX (user) +); + + +CREATE TABLE node ( + jobid CHAR(80) NOT NULL, + host VARCHAR(256), + elapsed INTEGER, + map INTEGER, + reduce INTEGER, + + INDEX (jobid) +); + +DELIMITER // + +CREATE TRIGGER bi_measure BEFORE INSERT ON job +FOR EACH ROW BEGIN + SET NEW.changed = NOW(); +END; // + +CREATE TRIGGER bu_measure BEFORE UPDATE ON job +FOR EACH ROW BEGIN + SET NEW.changed = NOW(); +END; // + +DELIMITER ; -- 1.8.2.3