summaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_deposit_confirmations.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/auditordb/0002-auditor_deposit_confirmations.sql')
-rw-r--r--src/auditordb/0002-auditor_deposit_confirmations.sql6
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();