diff options
author | Christian Grothoff <christian@grothoff.org> | 2024-02-08 00:05:39 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2024-02-08 00:05:39 +0100 |
commit | 659b1aaac82b57ff25cb26fcf34ba3c9b333b653 (patch) | |
tree | b12e81e79d1cd418a0bdffdc777ceae71350df23 /src/auditordb/0002-auditor_purses.sql | |
parent | 97f3e30c3d4081a6765c914c94b6cbf3a75110f3 (diff) | |
download | exchange-659b1aaac82b57ff25cb26fcf34ba3c9b333b653.tar.xz |
clean up SQL logic a bit more
Diffstat (limited to 'src/auditordb/0002-auditor_purses.sql')
-rw-r--r-- | src/auditordb/0002-auditor_purses.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/src/auditordb/0002-auditor_purses.sql b/src/auditordb/0002-auditor_purses.sql index 7cebd8894..86b6494d1 100644 --- a/src/auditordb/0002-auditor_purses.sql +++ b/src/auditordb/0002-auditor_purses.sql @@ -14,8 +14,7 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- -SET search_path TO auditor; -CREATE TABLE IF NOT EXISTS auditor_purses +CREATE TABLE auditor_purses (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) |