Files
geo/server/migrations_monitoring/20260410103000_create_monitoring_tables.down.sql
root 6066f43a7d Add monitoring service and database schema
- Implement monitoring service with heartbeat, lease tasks, resume tasks, and task result handling.
- Create monitoring time utilities for business date calculations.
- Add unit tests for date window resolution and business day handling.
- Define database schema for monitoring-related tables including quotas, daily reports, and task management.
- Establish migration scripts for creating and dropping monitoring tables.
2026-04-12 09:56:18 +08:00

11 lines
505 B
SQL

DROP TABLE IF EXISTS monitoring_brand_platform_daily;
DROP TABLE IF EXISTS monitoring_brand_daily;
DROP TABLE IF EXISTS monitoring_article_url_aliases;
DROP TABLE IF EXISTS site_domain_mappings;
DROP TABLE IF EXISTS monitoring_citation_facts;
DROP TABLE IF EXISTS question_monitor_parse_results;
DROP TABLE IF EXISTS question_monitor_runs;
DROP TABLE IF EXISTS monitoring_collect_tasks;
DROP TABLE IF EXISTS monitoring_platform_access_snapshots;
DROP TABLE IF EXISTS monitoring_question_config_snapshots;