Generated configuration is now fully stored to database

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

diff --git a/scripts/databaseinit.sql b/scripts/databaseinit.sql
index 1e34c75e5c14ef0986690049fc50a592c74be33c..d1ab3e2231e35a440f7c44b01437218139814c15 100644 (file)
--- a/scripts/databaseinit.sql
+++ b/scripts/databaseinit.sql
@@ -17,7 +17,7 @@ CREATE TABLE configurations (
        id BIGSERIAL PRIMARY KEY, -- Id
        hash char(32) NOT NULL, -- Hash of configuration
        generator TEXT NOT NULL, -- Text identificator of configure generation method
-       cfile TEXT NOT NULL, -- File path with configuration
+       config TEXT NOT NULL, -- Full configuration in text form
        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 
@@ -34,3 +34,10 @@ CREATE TABLE measure (
        linuxgit BIGINT REFERENCES linuxgit (id), -- Reference to git version of Linux
        toolgit BIGINT REFERENCES toolsgit (id) -- Reference to git version of tools 
 );
+
+-- In this table are sorted all used configuration options
+-- Order in this table is fundamental for configuration hash calculation
+CREATE TABLE configopt (
+       id BIGSERIAL PRIMARY KEY, -- Id
+       configopt TEXT NOT NULL -- Name of configuration option
+);