diff options
Diffstat (limited to 'src/auditordb/0002-auditor_deposit_confirmations.sql')
-rw-r--r-- | src/auditordb/0002-auditor_deposit_confirmations.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/src/auditordb/0002-auditor_deposit_confirmations.sql b/src/auditordb/0002-auditor_deposit_confirmations.sql index e26009efc..1b7fec185 100644 --- a/src/auditordb/0002-auditor_deposit_confirmations.sql +++ b/src/auditordb/0002-auditor_deposit_confirmations.sql @@ -14,9 +14,7 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- -SET search_path TO auditor; -DROP TABLE IF EXISTS deposit_confirmations; -CREATE TABLE IF NOT EXISTS auditor_deposit_confirmations +CREATE TABLE auditor_deposit_confirmations (deposit_confirmation_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE ,h_contract_terms BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=64) ,h_policy BYTEA NOT NULL CHECK (LENGTH(h_policy)=64) @@ -57,4 +55,4 @@ COMMENT ON FUNCTION auditor_new_transactions_trigger() CREATE TRIGGER auditor_notify_helper_deposits AFTER INSERT ON auditor.auditor_deposit_confirmations -EXECUTE PROCEDURE auditor_new_transactions_trigger();
\ No newline at end of file +EXECUTE PROCEDURE auditor_new_transactions_trigger(); |