3 -- RESET DATA FOR LIVE TESTING LP#1198465:
4 -- Support for Conditional Negative Balances
6 -- After running this, reload neg_bal_custom_transactions.sql.
7 -- Once both files are run, the tests should succeed again.
9 -- clear bills and payments for our test circs
10 DELETE FROM money.billing WHERE xact <= 16;
11 DELETE FROM money.payment WHERE xact <= 16;
13 -- clear any non-stock settings
14 -- XXX This will need adjusting if new stock settings are added, so
15 -- TODO: Pad out org_unit_settings with a SETVAL like we do for other
17 DELETE FROM actor.org_unit_setting WHERE id >= 14;
19 -- clear out the test workstation (just in case)
20 DELETE FROM actor.workstation WHERE name = 'BR1-test-09-lp1198465_neg_balances.t';