module.exports = '\
    PRAGMA FOREIGN_KEYS = ON;\
    CREATE TABLE tblUser (id INTEGER PRIMARY KEY, account TEXT Not Null UNIQUE, password TEXT Not Null, fname TEXT Not Null, lname TEXT Not Null, pcode TEXT Not Null UNIQUE, workunit TEXT Not Null, sysadmin BOOLEAN Not Null, github TEXT, telegram TEXT, attribute TEXT);\
    CREATE TABLE tblReportClass (id INTEGER PRIMARY KEY, caption TEXT Not Null UNIQUE, duration TEXT, user_owner INTEGER REFERENCES tblUser (id), caption_pitypes TEXT, weight_pitypes TEXT, attribute TEXT);\
    CREATE TABLE tblVariableCat_1 (id INTEGER PRIMARY KEY, caption TEXT Not Null UNIQUE, code TEXT Not Null, attribute TEXT);\
    CREATE TABLE tblVariableCat_2 (id INTEGER PRIMARY KEY, caption TEXT Not Null UNIQUE, code TEXT Not Null, variablecat_1_id REFERENCES tblVariableCat_1 (id), attribute TEXT);\
    CREATE TABLE tblVariableCat_3 (id INTEGER PRIMARY KEY, caption TEXT Not Null UNIQUE, code TEXT Not Null, variablecat_2_id REFERENCES tblVariableCat_2 (id), attribute TEXT);\
    CREATE TABLE tblVariableDef (id INTEGER PRIMARY KEY, unit TEXT Not Null, caption TEXT Not Null UNIQUE, code TEXT Not Null UNIQUE, user_provider INTEGER REFERENCES tblUser (id), user_owner INTEGER REFERENCES tblUser (id), user_reviewer INTEGER REFERENCES tblUser (id), attribute TEXT);\
    CREATE TABLE tblJunctionClass (id INTEGER PRIMARY KEY, reportclass_id INTEGER Not Null REFERENCES tblReportClass (id), variabledef_id INTEGER Not Null REFERENCES tblVariableDef (id), VariableCat_3_id INTEGER REFERENCES tblVariableCat_3 (id), weight DOUBLE);\
    CREATE TABLE tblReport (id INTEGER PRIMARY KEY, caption TEXT Not Null, time_limit INTEGER Not Null, user_owner INTEGER Not Null REFERENCES tblUser (id), user_creator INTEGER Not Null REFERENCES tblUser (id), ip_user TEXT Not Null, time_create INTEGER Not Null, pathfile TEXT, time_latestissue INTEGER, attribute TEXT);\
    CREATE TABLE tblVariable (id INTEGER PRIMARY KEY, unit TEXT Not Null, caption TEXT Not Null, code TEXT Not Null, user_provider INTEGER Not Null REFERENCES tblUser (id), user_owner INTEGER Not Null REFERENCES tblUser (id), user_reviewer INTEGER Not Null REFERENCES tblUser (id), attribute TEXT);\
    CREATE TABLE tblJunction (id INTEGER PRIMARY KEY, report_id INTEGER Not Null REFERENCES tblReport (id), variable_id INTEGER Not Null REFERENCES tblVariable (id), weight TEXT);\
    CREATE TABLE tblAttachment (id INTEGER PRIMARY KEY, report_id INTEGER Not Null REFERENCES tblReport (id), pathfile TEXT Not Null, user_attach INTEGER Not Null REFERENCES tblUser (id), ip_user TEXT Not Null, time_attach INTEGER Not Null, attribute TEXT);\
    CREATE TABLE tblValue (id INTEGER PRIMARY KEY, variable_id INTEGER REFERENCES tblVariable (id), value DOUBLE Not Null, time_update INTEGER Not Null, user_update INTEGER Not Null REFERENCES tblUser (id), ip_user TEXT Not Null, attribute TEXT);\
    CREATE TABLE tblTarget (id INTEGER PRIMARY KEY, variable_id INTEGER REFERENCES tblVariable (id), value DOUBLE Not Null, time_target INTEGER Not Null, time_update INTEGER Not Null, user_update INTEGER Not Null REFERENCES tblUser (id), ip_user TEXT Not Null, attribute TEXT);\
    CREATE TABLE tblMessage (id INTEGER PRIMARY KEY, textmessage TEXT Not Null, time_message INTEGER Not Null, ip_sender TEXT Not Null, user_sender INTEGER REFERENCES tblUser (id), user_reciever INTEGER Not Null REFERENCES tblUser (id), variable_id INTEGER REFERENCES tblVariable (id), teme_read INTEGER, attribute TEXT);';

@@ -2736,32 +2736,45 @@
 DOUBLE Not Null,
+ base DOUBLE,
  time_update INT

add base in tblValue