[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-exchange] branch master updated: Revert "updated table creation f
|
From: |
gnunet |
|
Subject: |
[taler-exchange] branch master updated: Revert "updated table creation files" |
|
Date: |
Wed, 28 Aug 2024 21:38:42 +0200 |
This is an automated email from the git hooks/post-receive script.
dold pushed a commit to branch master
in repository exchange.
The following commit(s) were added to refs/heads/master by this push:
new 96381a251 Revert "updated table creation files"
96381a251 is described below
commit 96381a2511293f07fbd8f226112530c43fe71d48
Author: Florian Dold <florian@dold.me>
AuthorDate: Wed Aug 28 21:38:18 2024 +0200
Revert "updated table creation files"
This reverts commit ca41d6a906e63658fafb10056da2630b41229717.
---
.../0002-auditor_amount_arithmetic_inconsistency.sql | 7 +++----
src/auditordb/0002-auditor_bad_sig_losses.sql | 5 ++---
src/auditordb/0002-auditor_balances.sql | 2 +-
src/auditordb/0002-auditor_closure_lags.sql | 9 ++++-----
src/auditordb/0002-auditor_coin_inconsistency.sql | 7 +++----
...tor_denomination_key_validity_withdraw_inconsistency.sql | 5 ++---
src/auditordb/0002-auditor_denominations_without_sigs.sql | 5 ++---
src/auditordb/0002-auditor_deposit_confirmations.sql | 1 -
src/auditordb/0002-auditor_emergency.sql | 9 ++++-----
src/auditordb/0002-auditor_emergency_by_count.sql | 13 ++++++-------
src/auditordb/0002-auditor_fee_time_inconsistency.sql | 7 +++----
.../0002-auditor_historic_denomination_revenue.sql | 1 -
src/auditordb/0002-auditor_historic_reserve_summary.sql | 4 ++--
.../0002-auditor_misattribution_in_inconsistency.sql | 7 +++----
src/auditordb/0002-auditor_pending_deposits.sql | 9 ++++-----
.../0002-auditor_purse_not_closed_inconsistencies.sql | 9 ++++-----
src/auditordb/0002-auditor_purses.sql | 5 ++---
src/auditordb/0002-auditor_refreshes_hanging.sql | 7 +++----
...2-auditor_reserve_balance_insufficient_inconsistency.sql | 5 ++---
...-auditor_reserve_balance_summary_wrong_inconsistency.sql | 7 +++----
.../0002-auditor_reserve_not_closed_inconsistency.sql | 5 ++---
src/auditordb/0002-auditor_reserves.sql | 1 -
src/auditordb/0002-auditor_row_inconsistency.sql | 1 -
src/auditordb/0002-auditor_wire_format_inconsistency.sql | 5 ++---
src/auditordb/0002-auditor_wire_out_inconsistency.sql | 1 -
25 files changed, 57 insertions(+), 80 deletions(-)
diff --git a/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql
b/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql
index 286f612bc..69b64bc41 100644
--- a/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql
+++ b/src/auditordb/0002-auditor_amount_arithmetic_inconsistency.sql
@@ -19,13 +19,12 @@
CREATE TABLE auditor_amount_arithmetic_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
-- TODO: correct constraintcheck, currently wrong
--operation BYTEA NOT NULL CHECK (LENGTH(operation)=16),
operation TEXT NOT NULL PRIMARY KEY,
- exchange_amount taler_amount NOT NULL,
- auditor_amount taler_amount NOT NULL,
- profitable BOOLEAN NOT NULL,
+ exchange_amount taler_amount,
+ auditor_amount taler_amount,
+ profitable BOOLEAN,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_amount_arithmetic_inconsistency
diff --git a/src/auditordb/0002-auditor_bad_sig_losses.sql
b/src/auditordb/0002-auditor_bad_sig_losses.sql
index 8be983670..c5a222251 100644
--- a/src/auditordb/0002-auditor_bad_sig_losses.sql
+++ b/src/auditordb/0002-auditor_bad_sig_losses.sql
@@ -18,9 +18,8 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_bad_sig_losses
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
- operation TEXT NOT NULL,
- loss taler_amount NOT NULL,
+ operation TEXT,
+ loss taler_amount,
operation_specific_pub BYTEA NOT NULL CHECK
(LENGTH(operation_specific_pub)=32),
suppressed BOOLEAN NOT NULL DEFAULT FALSE,
PRIMARY KEY (operation, operation_specific_pub)
diff --git a/src/auditordb/0002-auditor_balances.sql
b/src/auditordb/0002-auditor_balances.sql
index e25c3049c..78ff8a414 100644
--- a/src/auditordb/0002-auditor_balances.sql
+++ b/src/auditordb/0002-auditor_balances.sql
@@ -16,7 +16,7 @@
CREATE TABLE IF NOT EXISTS auditor_balances
(
- row_id BIGINT GENERATED BY DEFAULT AS IDENTITY,
+ row_id BIGINT GENERATED BY DEFAULT AS IDENTITY,
balance_key TEXT PRIMARY KEY NOT NULL,
balance_value taler_amount
diff --git a/src/auditordb/0002-auditor_closure_lags.sql
b/src/auditordb/0002-auditor_closure_lags.sql
index d41a55eae..93484f399 100644
--- a/src/auditordb/0002-auditor_closure_lags.sql
+++ b/src/auditordb/0002-auditor_closure_lags.sql
@@ -18,11 +18,10 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_closure_lags
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- amount taler_amount NOT NULL,
- deadline BIGINT NOT NULL,
- wtid BYTEA NOT NULL,
- account BYTEA NOT NULL,
+ amount taler_amount,
+ deadline BIGINT,
+ wtid BYTEA,
+ account BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_closure_lags
diff --git a/src/auditordb/0002-auditor_coin_inconsistency.sql
b/src/auditordb/0002-auditor_coin_inconsistency.sql
index c9c1b02fc..ea5210d68 100644
--- a/src/auditordb/0002-auditor_coin_inconsistency.sql
+++ b/src/auditordb/0002-auditor_coin_inconsistency.sql
@@ -18,12 +18,11 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_coin_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
operation TEXT NOT NULL,
- exchange_amount taler_amount NOT NULL,
- auditor_amount taler_amount NOT NULL,
+ exchange_amount taler_amount,
+ auditor_amount taler_amount,
coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32),
- profitable BOOLEAN NOT NULL,
+ profitable BOOLEAN,
suppressed BOOLEAN NOT NULL DEFAULT FALSE,
PRIMARY KEY (operation, coin_pub)
);
diff --git
a/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql
b/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql
index 4c91eded6..029bc90e0 100644
---
a/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql
+++
b/src/auditordb/0002-auditor_denomination_key_validity_withdraw_inconsistency.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS
auditor_denomination_key_validity_withdraw_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
execution_date BIGINT,
- reserve_pub BYTEA NOT NULL,
- denompub_h BYTEA NOT NULL,
+ reserve_pub BYTEA,
+ denompub_h BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_denomination_key_validity_withdraw_inconsistency
diff --git a/src/auditordb/0002-auditor_denominations_without_sigs.sql
b/src/auditordb/0002-auditor_denominations_without_sigs.sql
index 77dc3b153..94ea0a351 100644
--- a/src/auditordb/0002-auditor_denominations_without_sigs.sql
+++ b/src/auditordb/0002-auditor_denominations_without_sigs.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_denominations_without_sigs
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
denompub_h BYTEA PRIMARY KEY,
- value taler_amount NOT NULL,
- start_time BIGINT NOT NULL,
+ value taler_amount,
+ start_time BIGINT,
end_time BIGINT,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
diff --git a/src/auditordb/0002-auditor_deposit_confirmations.sql
b/src/auditordb/0002-auditor_deposit_confirmations.sql
index 2c9bbf951..7e47b4fd1 100644
--- a/src/auditordb/0002-auditor_deposit_confirmations.sql
+++ b/src/auditordb/0002-auditor_deposit_confirmations.sql
@@ -16,7 +16,6 @@
CREATE TABLE auditor_deposit_confirmations
(deposit_confirmation_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
- ,problem_row_id BIGINT NOT NULL
,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)
diff --git a/src/auditordb/0002-auditor_emergency.sql
b/src/auditordb/0002-auditor_emergency.sql
index a97befc0b..5fcd3cd06 100644
--- a/src/auditordb/0002-auditor_emergency.sql
+++ b/src/auditordb/0002-auditor_emergency.sql
@@ -20,13 +20,12 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_emergency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
denompub_h BYTEA CHECK (LENGTH(denompub_h)=64),
- denom_risk taler_amount NOT NULL,
- denom_loss taler_amount NOT NULL,
- deposit_start BIGINT NOT NULL,
+ denom_risk taler_amount,
+ denom_loss taler_amount,
+ deposit_start BIGINT,
deposit_end BIGINT,
- value taler_amount NOT NULL
+ value taler_amount
);
COMMENT ON TABLE auditor_emergency
IS 'Report an emergency denomination.';
diff --git a/src/auditordb/0002-auditor_emergency_by_count.sql
b/src/auditordb/0002-auditor_emergency_by_count.sql
index 41ff89cea..ff8ba405a 100644
--- a/src/auditordb/0002-auditor_emergency_by_count.sql
+++ b/src/auditordb/0002-auditor_emergency_by_count.sql
@@ -18,14 +18,13 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_emergency_by_count
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- denompub_h BYTEA NOT NULL,
- num_issued BIGINT NOT NULL,
- num_known BIGINT NOT NULL,
- risk taler_amount NOT NULL,
- start BIGINT NOT NULL,
+ denompub_h BYTEA,
+ num_issued BIGINT,
+ num_known BIGINT,
+ risk taler_amount,
+ start BIGINT,
deposit_end BIGINT,
- value taler_amount NOT NULL,
+ value taler_amount,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_emergency_by_count
diff --git a/src/auditordb/0002-auditor_fee_time_inconsistency.sql
b/src/auditordb/0002-auditor_fee_time_inconsistency.sql
index 128204bc4..1cea6caa6 100644
--- a/src/auditordb/0002-auditor_fee_time_inconsistency.sql
+++ b/src/auditordb/0002-auditor_fee_time_inconsistency.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_fee_time_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- fee_type BYTEA NOT NULL,
- fee_time BIGINT NOT NULL,
- diagnostic BYTEA NOT NULL,
+ type BYTEA,
+ time BIGINT,
+ diagnostic BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_fee_time_inconsistency
diff --git a/src/auditordb/0002-auditor_historic_denomination_revenue.sql
b/src/auditordb/0002-auditor_historic_denomination_revenue.sql
index 8576387a4..d711ac7fc 100644
--- a/src/auditordb/0002-auditor_historic_denomination_revenue.sql
+++ b/src/auditordb/0002-auditor_historic_denomination_revenue.sql
@@ -16,7 +16,6 @@
CREATE TABLE auditor_historic_denomination_revenue
(row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64)
,revenue_timestamp BIGINT NOT NULL
,revenue_balance taler_amount NOT NULL
diff --git a/src/auditordb/0002-auditor_historic_reserve_summary.sql
b/src/auditordb/0002-auditor_historic_reserve_summary.sql
index 0c97befb2..0dc68d594 100644
--- a/src/auditordb/0002-auditor_historic_reserve_summary.sql
+++ b/src/auditordb/0002-auditor_historic_reserve_summary.sql
@@ -18,12 +18,12 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_historic_reserve_summary
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
- start_date BIGINT NOT NULL,
+ start_date BIGINT,
end_date BIGINT NOT NULL,
reserve_profits taler_amount NOT NULL,
PRIMARY KEY (start_date, end_date)
+
);
COMMENT ON TABLE auditor_historic_reserve_summary
IS 'historic profits from reserves; we eventually GC
auditor_historic_reserve_revenue, and then store the totals in here (by time
intervals).';
diff --git a/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql
b/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql
index d212f5768..48050412d 100644
--- a/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql
+++ b/src/auditordb/0002-auditor_misattribution_in_inconsistency.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_misattribution_in_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- amount taler_amount NOT NULL,
- bank_row BIGINT NOT NULL,
- reserve_pub BYTEA NOT NULL,
+ amount taler_amount,
+ bank_row BIGINT,
+ reserve_pub BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_misattribution_in_inconsistency
diff --git a/src/auditordb/0002-auditor_pending_deposits.sql
b/src/auditordb/0002-auditor_pending_deposits.sql
index 847885e48..5cef7bf8c 100644
--- a/src/auditordb/0002-auditor_pending_deposits.sql
+++ b/src/auditordb/0002-auditor_pending_deposits.sql
@@ -17,10 +17,9 @@
CREATE TABLE IF NOT EXISTS auditor_pending_deposits
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- total_amount taler_amount NOT NULL,
- wire_target_payto TEXT NOT NULL,
- batch_deposit_serial_id BIGINT NOT NULL,
- deadline BIGINT NOT NULL,
+ total_amount taler_amount,
+ wire_target_h_payto BYTEA,
+ batch_deposit_serial_id BIGINT,
+ deadline BIGINT,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
diff --git a/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql
b/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql
index 470f759c6..e7f6078f0 100644
--- a/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql
+++ b/src/auditordb/0002-auditor_purse_not_closed_inconsistencies.sql
@@ -17,11 +17,10 @@
SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_purse_not_closed_inconsistencies
(
- row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
- purse_pub BYTEA PRIMARY KEY NOT NULL,
- amount taler_amount NOT NULL,
- expiration_date BIGINT NOT NULL,
+ row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE ,
+ purse_pub BYTEA PRIMARY KEY,
+ amount taler_amount,
+ expiration_date BIGINT,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_purse_not_closed_inconsistencies
diff --git a/src/auditordb/0002-auditor_purses.sql
b/src/auditordb/0002-auditor_purses.sql
index 6a100fd6e..9cfe2b095 100644
--- a/src/auditordb/0002-auditor_purses.sql
+++ b/src/auditordb/0002-auditor_purses.sql
@@ -15,9 +15,8 @@
--
CREATE TABLE auditor_purses
- (auditor_purses_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE NOT NULL
- ,problem_row_id BIGINT NOT NULL
- ,purse_pub BYTEA PRIMARY KEY CHECK(LENGTH(purse_pub)=32) NOT NULL
+ (auditor_purses_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
+ ,purse_pub BYTEA PRIMARY KEY CHECK(LENGTH(purse_pub)=32)
,balance taler_amount NOT NULL DEFAULT(0,0)
,target taler_amount NOT NULL
,expiration_date BIGINT NOT NULL
diff --git a/src/auditordb/0002-auditor_refreshes_hanging.sql
b/src/auditordb/0002-auditor_refreshes_hanging.sql
index f9ef5b743..c42d17c6c 100644
--- a/src/auditordb/0002-auditor_refreshes_hanging.sql
+++ b/src/auditordb/0002-auditor_refreshes_hanging.sql
@@ -17,10 +17,9 @@
SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_refreshes_hanging
(
- row_id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY UNIQUE,
- problem_row_id BIGINT NOT NULL,
- amount taler_amount NOT NULL,
- coin_pub BYTEA PRIMARY KEY NOT NULL,
+ row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
+ amount taler_amount,
+ coin_pub BYTEA PRIMARY KEY,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_refreshes_hanging
diff --git
a/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql
b/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql
index 00ec2fee2..533f35681 100644
--- a/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql
+++ b/src/auditordb/0002-auditor_reserve_balance_insufficient_inconsistency.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_reserve_balance_insufficient_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32),
- inconsistency_gain BOOLEAN NOT NULL,
- inconsistency_amount taler_amount NOT NULL,
+ inconsistency_gain BOOLEAN,
+ inconsistency_amount taler_amount,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_reserve_balance_insufficient_inconsistency
diff --git
a/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql
b/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql
index bd99e1dc8..12618d101 100644
--- a/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql
+++ b/src/auditordb/0002-auditor_reserve_balance_summary_wrong_inconsistency.sql
@@ -18,10 +18,9 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_reserve_balance_summary_wrong_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- reserve_pub BYTEA NOT NULL,
- exchange_amount taler_amount NOT NULL,
- auditor_amount taler_amount NOT NULL,
+ reserve_pub BYTEA,
+ exchange_amount taler_amount,
+ auditor_amount taler_amount,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE auditor_reserve_balance_summary_wrong_inconsistency
diff --git a/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql
b/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql
index 7c588a34c..ef0381bd1 100644
--- a/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql
+++ b/src/auditordb/0002-auditor_reserve_not_closed_inconsistency.sql
@@ -18,9 +18,8 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_reserve_not_closed_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE ,
- problem_row_id BIGINT NOT NULL,
- reserve_pub BYTEA PRIMARY KEY NOT NULL,
- balance taler_amount NOT NULL,
+ reserve_pub BYTEA PRIMARY KEY,
+ balance taler_amount,
expiration_time BIGINT,
diagnostic BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
diff --git a/src/auditordb/0002-auditor_reserves.sql
b/src/auditordb/0002-auditor_reserves.sql
index 9a7506b0f..f50653512 100644
--- a/src/auditordb/0002-auditor_reserves.sql
+++ b/src/auditordb/0002-auditor_reserves.sql
@@ -16,7 +16,6 @@
CREATE TABLE auditor_reserves
(auditor_reserves_rowid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
- ,problem_row_id BIGINT NOT NULL
,reserve_pub BYTEA PRIMARY KEY CHECK(LENGTH(reserve_pub)=32)
,reserve_balance taler_amount NOT NULL
,reserve_loss taler_amount NOT NULL
diff --git a/src/auditordb/0002-auditor_row_inconsistency.sql
b/src/auditordb/0002-auditor_row_inconsistency.sql
index 195d33030..6fae517bf 100644
--- a/src/auditordb/0002-auditor_row_inconsistency.sql
+++ b/src/auditordb/0002-auditor_row_inconsistency.sql
@@ -18,7 +18,6 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_row_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
row_table TEXT NOT NULL,
diagnostic TEXT NOT NULL,
problem_row_id INT8 NOT NULL,
diff --git a/src/auditordb/0002-auditor_wire_format_inconsistency.sql
b/src/auditordb/0002-auditor_wire_format_inconsistency.sql
index e77870a62..dc95f7956 100644
--- a/src/auditordb/0002-auditor_wire_format_inconsistency.sql
+++ b/src/auditordb/0002-auditor_wire_format_inconsistency.sql
@@ -18,9 +18,8 @@ SET search_path TO auditor;
CREATE TABLE IF NOT EXISTS auditor_wire_format_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
- amount taler_amount NOT NULL,
- wire_offset BIGINT NOT NULL,
+ amount taler_amount,
+ wire_offset BIGINT,
diagnostic BYTEA,
suppressed BOOLEAN NOT NULL DEFAULT FALSE
);
diff --git a/src/auditordb/0002-auditor_wire_out_inconsistency.sql
b/src/auditordb/0002-auditor_wire_out_inconsistency.sql
index 9e605d068..d46c2b283 100644
--- a/src/auditordb/0002-auditor_wire_out_inconsistency.sql
+++ b/src/auditordb/0002-auditor_wire_out_inconsistency.sql
@@ -17,7 +17,6 @@
CREATE TABLE IF NOT EXISTS auditor_wire_out_inconsistency
(
row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY,
- problem_row_id BIGINT NOT NULL,
destination_account TEXT NOT NULL,
diagnostic TEXT NOT NULL,
wire_out_serial_id INT8 NOT NULL,
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-exchange] branch master updated: Revert "updated table creation files",
gnunet <=