diff options
Diffstat (limited to 'src/auditordb/0002-auditor_historic_reserve_summary.sql')
| -rw-r--r-- | src/auditordb/0002-auditor_historic_reserve_summary.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/auditordb/0002-auditor_historic_reserve_summary.sql b/src/auditordb/0002-auditor_historic_reserve_summary.sql index 819c4e160..a81abb832 100644 --- a/src/auditordb/0002-auditor_historic_reserve_summary.sql +++ b/src/auditordb/0002-auditor_historic_reserve_summary.sql @@ -18,7 +18,8 @@ SET search_path TO auditor; CREATE TABLE IF NOT EXISTS auditor_historic_reserve_summary (start_date INT8 PRIMARY KEY ,end_date INT8 NOT NULL - ,reserve_profits taler_amount NOT NULL + ,reserve_profits taler_amount NOT NULL, + suppressed BOOLEAN NOT NULL DEFAULT FALSE ); 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).'; |