database-versioning/libeufin-nexus-drop.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

BEGIN;

DO
$do$
DECLARE
    patch text;
BEGIN
    IF EXISTS(SELECT 1 FROM information_schema.schemata WHERE schema_name='_v') THEN
        FOR patch IN SELECT patch_name FROM _v.patches WHERE patch_name LIKE 'libeufin_nexus_%' LOOP 
            PERFORM _v.unregister_patch(patch);
        END LOOP;
    END IF;
END
$do$;

DROP SCHEMA IF EXISTS libeufin_nexus CASCADE;

COMMIT;