--
--  Drop all tables.
--
DROP TABLE IF EXISTS "pa_activation" CASCADE;
DROP TABLE IF EXISTS "pa_activation_history" CASCADE;
DROP TABLE IF EXISTS "pa_application" CASCADE;
DROP TABLE IF EXISTS "pa_application_version" CASCADE;
DROP TABLE IF EXISTS "pa_token" CASCADE;
DROP TABLE IF EXISTS "pa_master_keypair" CASCADE;
DROP TABLE IF EXISTS "pa_signature_audit" CASCADE;
DROP TABLE IF EXISTS "pa_integration" CASCADE;
DROP TABLE IF EXISTS "pa_application_callback" CASCADE;
DROP TABLE IF EXISTS "pa_recovery_config" CASCADE;
DROP TABLE IF EXISTS "pa_recovery_puk" CASCADE;
DROP TABLE IF EXISTS "pa_recovery_code" CASCADE;
DROP TABLE IF EXISTS "pa_operation" CASCADE;
DROP TABLE IF EXISTS "pa_operation_template" CASCADE;
DROP TABLE IF EXISTS "pa_unique_value" CASCADE;

-- Optionally drop the shedlock table
-- DROP TABLE IF EXISTS "shedlock" CASCADE;

--
--  Drop all sequences.
--
DROP SEQUENCE IF EXISTS "pa_application_seq";
DROP SEQUENCE IF EXISTS "pa_application_version_seq";
DROP SEQUENCE IF EXISTS "pa_master_keypair_seq";
DROP SEQUENCE IF EXISTS "pa_signature_audit_seq";
DROP SEQUENCE IF EXISTS "pa_activation_history_seq";
DROP SEQUENCE IF EXISTS "pa_recovery_code_seq";
DROP SEQUENCE IF EXISTS "pa_recovery_puk_seq";
DROP SEQUENCE IF EXISTS "pa_recovery_config_seq";
DROP SEQUENCE IF EXISTS "pa_operation_template_seq";
