Tabelle history_erp braucht noch einen Zeitstempel.

diff --git a/sql/Pg-upgrade2/history_erp.sql b/sql/Pg-upgrade2/history_erp.sql
index daa9c4b05e0d836d55842b97d44026dd78763264..165322c74a9eab2e293e45332d03949f0becad62 100644 (file)
--- a/sql/Pg-upgrade2/history_erp.sql
+++ b/sql/Pg-upgrade2/history_erp.sql
@@ -12,6 +12,7 @@ CREATE TABLE history_erp (
        employee_id integer,
        addition text,
        what_done text,
        employee_id integer,
        addition text,
        what_done text,

+       itime timestamp DEFAULT now(),

 
        PRIMARY KEY (id),
        FOREIGN KEY (employee_id) REFERENCES employee (id)
 
        PRIMARY KEY (id),
        FOREIGN KEY (employee_id) REFERENCES employee (id)