DROP FUNCTION IF EXISTS collection_broadcasts.update_broadcast_status(BIGINT, VARCHAR, TEXT, JSONB);
DROP FUNCTION IF EXISTS collection_broadcasts.get_template_variables(INT);

DROP VIEW IF EXISTS collection_broadcasts.v_delivery_rate_24h;
DROP VIEW IF EXISTS collection_broadcasts.v_failed_records_24h;
DROP VIEW IF EXISTS collection_broadcasts.v_collar_summary;
DROP VIEW IF EXISTS collection_broadcasts.v_template_variables_ordered;

DROP TABLE IF EXISTS collection_broadcasts.sopiga_sync_job;
DROP TABLE IF EXISTS collection_broadcasts.broadcast_error_log;
DROP TABLE IF EXISTS collection_broadcasts.broadcast_audit_log;
DROP TABLE IF EXISTS collection_broadcasts.broadcast_staging;
DROP TABLE IF EXISTS collection_broadcasts.sopiga_collar_config;
DROP TABLE IF EXISTS collection_broadcasts.template_variable_mapping;
DROP TABLE IF EXISTS collection_broadcasts.sopiga_template_config;

DROP SCHEMA IF EXISTS collection_broadcasts;