diff options
Diffstat (limited to 'src/exchangedb/0002-purse_merges.sql')
-rw-r--r-- | src/exchangedb/0002-purse_merges.sql | 36 |
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); |