diff options
Diffstat (limited to 'src/exchangedb/0002-reserves_out.sql')
-rw-r--r-- | src/exchangedb/0002-reserves_out.sql | 20 |
1 files changed, 18 insertions, 2 deletions
diff --git a/src/exchangedb/0002-reserves_out.sql b/src/exchangedb/0002-reserves_out.sql index 77112f504..25d717a52 100644 --- a/src/exchangedb/0002-reserves_out.sql +++ b/src/exchangedb/0002-reserves_out.sql @@ -132,14 +132,25 @@ BEGIN ,table_name ,partition_suffix ); +END $$; + + +CREATE FUNCTION constrain_table_reserves_out_by_reserve( + IN partition_suffix VARCHAR DEFAULT NULL +) +RETURNS VOID +LANGUAGE plpgsql +AS $$ +DECLARE + table_name VARCHAR DEFAULT 'reserves_out_by_reserve'; +BEGIN table_name = concat_ws('_', table_name, partition_suffix); EXECUTE FORMAT ( 'CREATE INDEX ' || table_name || '_main_index ' 'ON ' || table_name || ' ' '(reserve_uuid);' ); -END -$$; +END $$; CREATE FUNCTION reserves_out_by_reserve_insert_trigger() @@ -217,6 +228,11 @@ INSERT INTO exchange_tables ,'create' ,TRUE ,FALSE), + ('reserves_out_by_reserve' + ,'exchange-0002' + ,'constrain' + ,TRUE + ,FALSE), ('reserves_out' ,'exchange-0002' ,'master' |