diff options
| author | Özgür Kesim <oec-taler@kesim.org> | 2023-07-28 14:29:25 +0200 |
|---|---|---|
| committer | Özgür Kesim <oec-taler@kesim.org> | 2023-07-28 14:29:25 +0200 |
| commit | 1c923855a31b35e28706ba2fafa2d2bccc7ee775 (patch) | |
| tree | 5df5f6ed6225d3d2990e5054a5bb12de05a8d62f /src/exchangedb/0002-age_withdraw.sql | |
| parent | 0d0494ee9117c89faeda64baf7413dee1cee46ca (diff) | |
finalize v3/v4 -> v2 exchange schema merger
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); + |