From 1c923855a31b35e28706ba2fafa2d2bccc7ee775 Mon Sep 17 00:00:00 2001 From: Özgür Kesim Date: Fri, 28 Jul 2023 14:29:25 +0200 Subject: finalize v3/v4 -> v2 exchange schema merger --- src/exchangedb/0002-age_withdraw.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'src/exchangedb/0002-age_withdraw.sql') diff --git a/src/exchangedb/0002-age_withdraw.sql b/src/exchangedb/0002-age_withdraw.sql index 05c0df27..e3bd71a6 100644 --- a/src/exchangedb/0002-age_withdraw.sql +++ b/src/exchangedb/0002-age_withdraw.sql @@ -138,7 +138,7 @@ BEGIN 'ALTER TABLE ' || table_name || ' ADD CONSTRAINT ' || table_name || '_foreign_reserve_pub' ' FOREIGN KEY (reserve_pub)' - ' REFERENCES reserves(reserve_pub);' -- ON DELETE CASCADE;' + ' REFERENCES reserves(reserve_pub) ON DELETE CASCADE;' ); END $$; @@ -151,6 +151,7 @@ INSERT INTO exchange_tables ,partitioned ,by_range) VALUES - ('age_withdraw', 'exchange-0003', 'create', TRUE ,FALSE), - ('age_withdraw', 'exchange-0003', 'constrain',TRUE ,FALSE), - ('age_withdraw', 'exchange-0003', 'foreign', TRUE ,FALSE); + ('age_withdraw', 'exchange-0002', 'create', TRUE ,FALSE), + ('age_withdraw', 'exchange-0002', 'constrain',TRUE ,FALSE), + ('age_withdraw', 'exchange-0002', 'foreign', TRUE ,FALSE); + -- cgit v1.2.3