donau

commit cb7b395c5458c53fb9282d66f618adda9b2ea431
parent b49f8d7066b47bdf55b193bbd57ef05a2fa44abb
Author: Casaburi Johannes <johannes.casaburi@students.bfh.ch>
Date:   Tue, 10 Oct 2023 21:32:11 +0200

[db] Some edits and added comments

Diffstat:
D
src/donaudb/0002-donation_unit_revocations.sql
 | 
24
------------------------
M
src/donaudb/0002-donation_units.sql
 | 
6
++++--
M
src/donaudb/0002-donau_receipts_issued.sql
 | 
2
+-

3 files changed, 5 insertions(+), 27 deletions(-)
diff --git a/src/donaudb/0002-donation_unit_revocations.sql b/src/donaudb/0002-donation_unit_revocations.sql
@@ -1,24 +0,0 @@
---
--- This file is part of TALER
--- Copyright (C) 2023 Taler Systems SA
---
--- TALER is free software; you can redistribute it and/or modify it under the
--- terms of the GNU General Public License as published by the Free Software
--- Foundation; either version 3, or (at your option) any later version.
---
--- TALER is distributed in the hope that it will be useful, but WITHOUT ANY
--- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
--- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
---
--- You should have received a copy of the GNU General Public License along with
--- TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
---
-
-CREATE TABLE IF NOT EXISTS donation_unit_revocations
-  (donation_unit_revocations_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
-  ,donation_unit_serial INT8 PRIMARY KEY REFERENCES donation_units (donation_unit_serial) ON DELETE CASCADE
-  );
-COMMENT ON TABLE donation_unit_revocations
-  IS 'remembering which donation_unit keys have been revoked';
-
--- FIXME: probably leave out revocation for now.
diff --git a/src/donaudb/0002-donation_units.sql b/src/donaudb/0002-donation_units.sql
@@ -22,8 +22,10 @@ CREATE TABLE donation_units
   ,donation_unit taler_amount NOT NULL
   );
 COMMENT ON TABLE donation_units
-  IS 'Main donation_unit table. All the valid donation_unit the exchange knows about.';
+  IS 'Main donation_unit table. All the valid donation units the Donau knows about.';
+COMMENT ON COLUMN donation_units.donation_unit
+  IS 'Value the donation unit has in Taler amount';
 
-CREATE INDEX donation_units_by_expire
+CREATE INDEX donation_units_by_validity_year
   ON donation_units
   (validity_year);
diff --git a/src/donaudb/0002-donau_receipts_issued.sql b/src/donaudb/0002-donau_receipts_issued.sql
@@ -26,4 +26,4 @@ COMMENT ON TABLE receipts_issued
 COMMENT ON COLUMN receipts_issued.charity_sig
   IS 'Signature from the charity.';
 COMMENT ON COLUMN receipts_issued.receipt_hash
-  IS 'Hash value of the receipt received.';
+  IS 'Hash value over all the blinded donation receipt received plus the hash of the donation units public key.';