drop.sql (539B)
1 -- counter part to initializing / schema 2 BEGIN; 3 4 DROP SCHEMA IF EXISTS c2ec CASCADE; 5 6 DELETE FROM _v.patches WHERE patch_name IN ( 7 '0001-c2ec-schema', 8 'proc-c2ec-payment-notification-listener', 9 'proc-c2ec-retry-listener', 10 'proc-c2ec-status-listener', 11 'proc-c2ec-transfer-listener', 12 '0001-c2ec-add-confirmed-id', 13 'access' 14 ); 15 16 DROP OWNED BY c2ec_operator; 17 DROP OWNED BY c2ec_api; 18 DROP OWNED BY c2ec_admin; 19 20 DROP ROLE IF EXISTS c2ec_operator; 21 DROP ROLE IF EXISTS c2ec_api; 22 DROP ROLE IF EXISTS c2ec_admin; 23 24 COMMIT;