Add database table linuxgit and fix prepare sql command

[linux-conf-perf.git] / scripts / databaseinit.sql

diff --git a/scripts/databaseinit.sql b/scripts/databaseinit.sql
index eee51fa86e7e10b4f93e225e31b0fc5ff67c7356..fb765caa4f26bc9c4dfd89d90a7e870e756fe9ff 100644 (file)
--- a/scripts/databaseinit.sql
+++ b/scripts/databaseinit.sql
@@ -1,16 +1,24 @@
 -- In this table are tracked versions of tools in git
 CREATE TABLE toolsgit (
        id BIGSERIAL PRIMARY KEY, -- Id
-       git_describe text NOT NULL, -- Git describe string (--always --tags --dirty)
-       git_commit text NOT NULL -- Commit hash of version of tool used for generating
+       git_describe TEXT NOT NULL, -- Git describe string (--always --tags --dirty)
+       git_commit TEXT NOT NULL -- Commit hash of version of tool used for generating
+);
+
+-- In this table are tracked versions of measured Linux in git
+CREATE TABLE linuxgit (
+       id BIGSERIAL PRIMARY KEY, -- Id
+       git_describe TEXT NOT NULL, -- Git describe scring (--always --tags --dirty)
+       git_commit TEXT NOT NULL -- Commit hash of version of tool used for generating
 );
 
 -- In this table are stored all generated configurations
 CREATE TABLE configurations (
        id BIGSERIAL PRIMARY KEY, -- Id
-       hash char(34) NOT NULL, -- Hash of configuration
-       cfile text NOT NULL, -- File path with configuration
+       hash char(32) NOT NULL, -- Hash of configuration
+       cfile TEXT NOT NULL, -- File path with configuration
        gtime timestamp NOT NULL, -- Time and date of generation
+       linuxgit BIGINT REFERENCES linuxgit (id), -- Reference to git version of Linux
        toolgit BIGINT REFERENCES toolsgit (id) -- Reference to git version of tools 
 );
 
@@ -18,8 +26,10 @@ CREATE TABLE configurations (
 CREATE TABLE measure (
        id BIGSERIAL PRIMARY KEY, -- Id
        conf BIGINT REFERENCES configurations (id), -- Reference to configuration
-       mfile text NOT NULL, -- File with measuring output
-       value BIGINT DEFAULT null, -- Measured data value
+       measurement TEXT NOT NULL, -- Text identifivator of measuring tool
+       mfile TEXT NOT NULL, -- File with measuring output
+       value DOUBLE PRECISION DEFAULT null, -- Measured data value
        mtime timestamp NOT NULL, -- Time and date of measurement
+       linuxgit BIGINT REFERENCES linuxgit (id), -- Reference to git version of Linux
        toolgit BIGINT REFERENCES toolsgit (id) -- Reference to git version of tools 
 );