X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fhistory_erp.sql;h=165322c74a9eab2e293e45332d03949f0becad62;hb=b0be688fa50e3f92526fdc281a663b19e52f6753;hp=daa9c4b05e0d836d55842b97d44026dd78763264;hpb=ca5de5712845a874f8abe976d92aef945d513ca7;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/history_erp.sql b/sql/Pg-upgrade2/history_erp.sql index daa9c4b05..165322c74 100644 --- 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, + itime timestamp DEFAULT now(), PRIMARY KEY (id), FOREIGN KEY (employee_id) REFERENCES employee (id)