diff options
Diffstat (limited to 'database-versioning/libeufin-bank-0003.sql')
-rw-r--r-- | database-versioning/libeufin-bank-0003.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/database-versioning/libeufin-bank-0003.sql b/database-versioning/libeufin-bank-0003.sql new file mode 100644 index 00000000..14f1075f --- /dev/null +++ b/database-versioning/libeufin-bank-0003.sql @@ -0,0 +1,28 @@ +-- +-- This file is part of TALER +-- Copyright (C) 2024 Taler Systems SA +-- +-- TALER is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 3, or (at your option) any later version. +-- +-- TALER is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along with +-- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> + +BEGIN; + +SELECT _v.register_patch('libeufin-bank-0003', NULL, NULL); +SET search_path TO libeufin_bank; + +CREATE TABLE bank_transaction_operations + (request_uid BYTEA UNIQUE CHECK (LENGTH(request_uid)=32) + ,bank_transaction INT8 UNIQUE NOT NULL + REFERENCES bank_account_transactions(bank_transaction_id) + ON DELETE CASCADE + ); + +COMMIT; |