aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-purse_merges.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/0002-purse_merges.sql')
-rw-r--r--src/exchangedb/0002-purse_merges.sql36
1 files changed, 0 insertions, 36 deletions
diff --git a/src/exchangedb/0002-purse_merges.sql b/src/exchangedb/0002-purse_merges.sql
index 60a2067a7..178a36ccf 100644
--- a/src/exchangedb/0002-purse_merges.sql
+++ b/src/exchangedb/0002-purse_merges.sql
@@ -125,37 +125,6 @@ END
$$;
-CREATE OR REPLACE FUNCTION purse_merges_insert_trigger()
- RETURNS trigger
- LANGUAGE plpgsql
- AS $$
-BEGIN
- INSERT INTO reserve_history
- (reserve_pub
- ,table_name
- ,serial_id)
- VALUES
- (NEW.reserve_pub
- ,'purse_merges'
- ,NEW.purse_merge_request_serial_id);
- RETURN NEW;
-END $$;
-COMMENT ON FUNCTION purse_merges_insert_trigger()
- IS 'Automatically generate reserve history entry.';
-
-
-CREATE FUNCTION master_table_purse_merges()
-RETURNS VOID
-LANGUAGE plpgsql
-AS $$
-BEGIN
- CREATE TRIGGER purse_merges_on_insert
- AFTER INSERT
- ON purse_merges
- FOR EACH ROW EXECUTE FUNCTION purse_merges_insert_trigger();
-END $$;
-
-
INSERT INTO exchange_tables
(name
,version
@@ -177,9 +146,4 @@ INSERT INTO exchange_tables
,'exchange-0002'
,'foreign'
,TRUE
- ,FALSE),
- ('purse_merges'
- ,'exchange-0002'
- ,'master'
- ,TRUE
,FALSE);