50e25e3ee8
Rename subdirectories for a cleaner single-repo layout: - website-monitoring-backend/ → backend/ - website-monitoring-frontend/ → frontend/ - website-monitoring-devops/ → devops/ Update all references in package.json scripts, CI workflows, docker-compose, pre-commit hooks, and documentation. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
9 lines
394 B
SQL
9 lines
394 B
SQL
-- Add missing columns to crawl_sessions table that the API expects
|
|
-- Add total_urls and processed_urls columns that the API is trying to insert
|
|
ALTER TABLE crawl_sessions ADD COLUMN IF NOT EXISTS total_urls INTEGER DEFAULT 0;
|
|
ALTER TABLE crawl_sessions ADD COLUMN IF NOT EXISTS processed_urls INTEGER DEFAULT 0;
|
|
|
|
-- Refresh schema cache to pick up new columns
|
|
NOTIFY pgrst, 'reload schema';
|
|
|