From 223c94f52ebaa878f6951ebf7d08754e413bdca7 Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Thu, 5 Feb 2026 10:37:09 -1000 Subject: Document multi-agent workflow, ADRs, and Agent API - Add Development Workflow section to DESIGN.md documenting three-role system (Architect, Implementor, Reviewer) with handoff documents - Update CLAUDE.md with Key Documents section pointing to DESIGN.md, role definitions, and ADRs - Add ADR-first documentation policy across all role definitions - Update REVIEWER_ROLE.md with comprehensive test quality checklist - Document Agent API and completed tasks log in DESIGN.md - Update database schema table with 5 missing tables - Update endpoint reference with 10 missing routes - Create ADRs 002-005 capturing key architectural decisions: - 002: Timeline aggregation architecture - 003: HTMX write operations pattern - 004: Concurrent data fetching with graceful degradation - 005: Agent API notification-based authentication - Add migrations/README.md documenting schema history and 007 gap Co-Authored-By: Claude Opus 4.5 --- migrations/README.md | 36 ++++++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 migrations/README.md (limited to 'migrations/README.md') diff --git a/migrations/README.md b/migrations/README.md new file mode 100644 index 0000000..e849b9c --- /dev/null +++ b/migrations/README.md @@ -0,0 +1,36 @@ +# Database Migrations + +Sequential SQL migrations for task-dashboard schema evolution. + +## Migration History + +| # | File | Purpose | +|---|------|---------| +| 001 | `001_initial_schema.sql` | Initial schema (tasks, boards, cards, meals) | +| 002 | `002_add_cache_metadata.sql` | Cache metadata table for TTL tracking | +| 003 | `003_add_sync_tokens.sql` | Sync tokens for incremental sync | +| 004 | `004_add_auth.sql` | Authentication (users, sessions) | +| 005 | `005_add_bugs.sql` | Bug tracking table | +| 006 | `006_remove_resolved_bugs.sql` | Add resolved_at timestamp to bugs | +| 007 | — | **SKIPPED** (reserved, never used) | +| 008 | `008_user_shopping_items.sql` | User-added shopping items | +| 009 | `009_shopping_item_checks.sql` | External item check state | +| 010 | `010_agent_tables.sql` | Agent authentication (agents, agent_sessions) | +| 011 | `011_completed_tasks.sql` | Completed tasks log | +| 012 | `012_feature_toggles.sql` | Feature toggle system | +| 013 | `013_source_config.sql` | Source filtering configuration | + +## Migration 007 Gap + +Migration 007 was reserved during development but never implemented. The gap is intentional and preserved to maintain clean git history. Future migrations continue from 014. + +## Running Migrations + +Migrations are applied automatically on application startup via `store.RunMigrations()`. The `schema_migrations` table tracks which migrations have been applied. + +## Creating New Migrations + +1. Create file: `migrations/NNN_description.sql` (next number is 014) +2. Write idempotent SQL (use `IF NOT EXISTS` where possible) +3. Test locally: `go run cmd/dashboard/main.go` +4. Verify: Check `schema_migrations` table for new entry -- cgit v1.2.3