drop.sql (450B)
1 -- Drop script for OAuth2 Gateway 2 -- WARNING: This destroys all data in the oauth2gw schema 3 BEGIN; 4 5 -- Drop application schema (CASCADE removes all tables, indexes, functions) 6 DROP SCHEMA IF EXISTS oauth2gw CASCADE; 7 8 -- Unregister all oauth2gw patches from versioning system 9 -- This allows re-running migrations from scratch 10 SELECT _v.unregister_patch(patch_name) 11 FROM _v.patches 12 WHERE patch_name LIKE 'oauth2gw-%' 13 ORDER BY patch_name DESC; 14 15 COMMIT;