diff options
Diffstat (limited to 'src/auditordb/0002-auditor_balances.sql')
| -rw-r--r-- | src/auditordb/0002-auditor_balances.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_balances.sql b/src/auditordb/0002-auditor_balances.sql index 8014b9c41..78ff8a414 100644 --- a/src/auditordb/0002-auditor_balances.sql +++ b/src/auditordb/0002-auditor_balances.sql @@ -16,8 +16,10 @@ CREATE TABLE IF NOT EXISTS auditor_balances ( - balance_key TEXT PRIMARY KEY NOT NULL - ,balance_value taler_amount + row_id BIGINT GENERATED BY DEFAULT AS IDENTITY, + balance_key TEXT PRIMARY KEY NOT NULL, + balance_value taler_amount + ); COMMENT ON TABLE auditor_balances |