diff options
Diffstat (limited to 'src/exchangedb/0002-age_withdraw.sql')
| -rw-r--r-- | src/exchangedb/0002-age_withdraw.sql | 9 |
1 files changed, 5 insertions, 4 deletions
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); + |