BEGIN;

SET LOCAL lock_timeout = '10s';
SET LOCAL statement_timeout = '900000';
SET LOCAL idle_in_transaction_session_timeout = '900000';

DROP FUNCTION IF EXISTS ops.audit_domain_public_divergence();
DROP FUNCTION IF EXISTS ops.reconcile_public_to_canonical(text, text, text);

REVOKE CREATE ON SCHEMA public FROM PUBLIC;
REVOKE CREATE ON SCHEMA public_legacy FROM PUBLIC;

COMMENT ON SCHEMA public IS 'Technical schema only. Business DDL blocked by COMPACTACION_ESQUEMAS_POSTGRESQL.';
COMMENT ON SCHEMA public_legacy IS 'Legacy compatibility schema retired by COMPACTACION_ESQUEMAS_POSTGRESQL. No new business objects allowed.';

COMMIT;
