X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fbank_transactions.sql;h=6e9f917668dea9ac7650bfc52ed20f66a56a7637;hb=a99fc9f6b84fbf0effae46eb41fe056c960a1602;hp=4b57741d8716983a5d825842e0052498ad1528c0;hpb=6a12a968761127af91e9da8db7579be2836bcaaa;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/bank_transactions.sql b/sql/Pg-upgrade2/bank_transactions.sql
index 4b57741d8..6e9f91766 100644
--- a/sql/Pg-upgrade2/bank_transactions.sql
+++ b/sql/Pg-upgrade2/bank_transactions.sql
@@ -1,6 +1,6 @@
 -- @tag: bank_transactions
 -- @description: Erstellen der Tabelle bank_transactions.
--- @depends: release_3_0_0 currencies
+-- @depends: release_3_2_0 currencies
 
 CREATE TABLE bank_transactions (
   id SERIAL PRIMARY KEY,
@@ -11,13 +11,12 @@ CREATE TABLE bank_transactions (
   valutadate DATE NOT NULL,
   amount numeric(15,5) NOT NULL,
   remote_name TEXT,
-  remote_name_1 TEXT,
   purpose TEXT,
   invoice_amount numeric(15,5) DEFAULT 0,
   local_bank_account_id INTEGER NOT NULL,
   currency_id INTEGER NOT NULL,
   cleared BOOLEAN NOT NULL DEFAULT FALSE,
-
+  itime TIMESTAMP DEFAULT now(),
   FOREIGN KEY (currency_id)            REFERENCES currencies (id),
   FOREIGN KEY (local_bank_account_id)  REFERENCES bank_accounts (id)
 );