[taler-donau] branch master updated: fix sql

[gnunet]

This is an automated email from the git hooks/post-receive script.

johannes-casaburi pushed a commit to branch master
in repository donau.

The following commit(s) were added to refs/heads/master by this push:
     new f1754f5  fix sql
f1754f5 is described below

commit f1754f583edfb043018dc79bd6f02e3548bfb05d
Author: Casaburi Johannes <johannes.casaburi@students.bfh.ch>
AuthorDate: Tue Jan 9 10:44:27 2024 +0100

    fix sql
---
 contrib/gana                         | 2 +-
 src/donaudb/0002-donation_units.sql  | 2 +-
 src/donaudb/0002-donau_charities.sql | 2 +-
 src/donaudb/0002-donau_history.sql   | 2 +-
 4 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/contrib/gana b/contrib/gana
index 6d3fb42..40f6cf1 160000
--- a/contrib/gana
+++ b/contrib/gana
@@ -1 +1 @@
-Subproject commit 6d3fb428f0a2dd5bc5f35516ea77c32c2cf0ecfa
+Subproject commit 40f6cf1015231663064eda98aa1e403cddd7b970
diff --git a/src/donaudb/0002-donation_units.sql 
b/src/donaudb/0002-donation_units.sql
index 06da924..94965f5 100644
--- a/src/donaudb/0002-donation_units.sql
+++ b/src/donaudb/0002-donation_units.sql
@@ -17,7 +17,7 @@
 CREATE TABLE donation_units
   (donation_unit_serial BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
   ,donation_unit_hash BYTEA PRIMARY KEY CHECK (LENGTH(donation_unit_hash)=64)
-  ,donation_unit_pub BYTEA NOT NULL
+  ,donation_unit_pub BYTEA UNIQUE NOT NULL
   ,validity_year INT4 NOT NULL
   ,donation_unit taler_amount NOT NULL
   );
diff --git a/src/donaudb/0002-donau_charities.sql 
b/src/donaudb/0002-donau_charities.sql
index fe11117..8f9525c 100644
--- a/src/donaudb/0002-donau_charities.sql
+++ b/src/donaudb/0002-donau_charities.sql
@@ -16,7 +16,7 @@
 
 CREATE TABLE charities
   (charity_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
-  ,charity_pub BYTEA PRIMARY KEY CHECK (LENGTH(donau_pub)=32)
+  ,charity_pub BYTEA PRIMARY KEY CHECK (LENGTH(charity_pub)=32)
   ,charity_name TEXT NOT NULL
   ,charity_url TEXT NOT NULL
   ,max_per_year taler_amount NOT NULL
diff --git a/src/donaudb/0002-donau_history.sql 
b/src/donaudb/0002-donau_history.sql
index f1e35e6..06f7c25 100644
--- a/src/donaudb/0002-donau_history.sql
+++ b/src/donaudb/0002-donau_history.sql
@@ -15,7 +15,7 @@
 --
 
 CREATE TABLE history
-  (charity_id BIGINT KEY REFERENCES charities (charity_id) ON DELETE CASCADE
+  (charity_id BIGINT PRIMARY KEY REFERENCES charities (charity_id) ON DELETE 
CASCADE
   ,final_amount taler_amount NOT NULL
   ,donation_year INT8 NOT NULL
   );

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.