From b2bf0e59c5ec17f0eb0441ab6d8260f8492f6a94 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 21 Feb 2007 08:20:25 +0000 Subject: [PATCH] Tabelle history_erp braucht noch einen Zeitstempel. --- sql/Pg-upgrade2/history_erp.sql | 1 + 1 file changed, 1 insertion(+) 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) -- 2.20.1