1 files changed, 16 insertions, 16 deletions
diff --git a/src/auditordb/0002-deposit_confirmations.sql b/src/auditordb/0002-deposit_confirmations.sql
index 340799cd5..1d63bdb6e 100644
--- a/src/auditordb/0002-deposit_confirmations.sql
+++ b/src/auditordb/0002-deposit_confirmations.sql
@@ -15,21 +15,21 @@
 --
 
 CREATE TABLE IF NOT EXISTS deposit_confirmations
-    ,serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
-    ,h_contract_terms BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=64)
-    ,h_policy BYTEA NOT NULL CHECK (LENGTH(h_policy)=64)
-    ,h_wire BYTEA NOT NULL CHECK (LENGTH(h_wire)=64)
-    ,exchange_timestamp INT8 NOT NULL
-    ,refund_deadline INT8 NOT NULL
-    ,wire_deadline INT8 NOT NULL
-    ,amount_without_fee_val INT8 NOT NULL
-    ,amount_without_fee_frac INT4 NOT NULL
-    ,coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32)
-    ,merchant_pub BYTEA NOT NULL CHECK (LENGTH(merchant_pub)=32)
-    ,exchange_sig BYTEA NOT NULL CHECK (LENGTH(exchange_sig)=64)
-    ,exchange_pub BYTEA NOT NULL CHECK (LENGTH(exchange_pub)=32)
-    ,master_sig BYTEA NOT NULL CHECK (LENGTH(master_sig)=64)
-    ,PRIMARY KEY (h_contract_terms,h_wire,coin_pub,merchant_pub,exchange_sig,exchange_pub,master_sig)
-    );
+  (deposit_confirmation_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
+  ,h_contract_terms BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=64)
+  ,h_policy BYTEA NOT NULL CHECK (LENGTH(h_policy)=64)
+  ,h_wire BYTEA NOT NULL CHECK (LENGTH(h_wire)=64)
+  ,exchange_timestamp INT8 NOT NULL
+  ,refund_deadline INT8 NOT NULL
+  ,wire_deadline INT8 NOT NULL
+  ,total_without_fee taler_amount NOT NULL
+  ,coin_pubs BYTEA[] NOT NULL CHECK (CARDINALITY(coin_pubs)>0)
+  ,coin_sigs BYTEA[] NOT NULL CHECK (CARDINALITY(coin_sigs)=CARDINALITY(coin_pubs))
+  ,merchant_pub BYTEA NOT NULL CHECK (LENGTH(merchant_pub)=32)
+  ,exchange_sig BYTEA NOT NULL CHECK (LENGTH(exchange_sig)=64)
+  ,exchange_pub BYTEA NOT NULL CHECK (LENGTH(exchange_pub)=32)
+  ,master_sig BYTEA NOT NULL CHECK (LENGTH(master_sig)=64)
+  ,PRIMARY KEY (h_contract_terms,h_wire,coin_pub,merchant_pub,exchange_sig,exchange_pub,master_sig)
+  );
 COMMENT ON TABLE deposit_confirmations
   IS 'deposit confirmation sent to us by merchants; we must check that the exchange reported these properly.';