X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/ca5de5712845a874f8abe976d92aef945d513ca7..e43c500e32c61ef667d4e6a57e7315232fd705c2:/sql/Pg-upgrade2/history_erp.sql 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)