Skip to content

History / Database Reporting and Operations Schema

Revisions

  • Make the upgrade and schema pages accurate for multi-release and manual upgrades - Updating the solution: add "Upgrading across several releases" (one installer run applies every pending migration; the admin actions of each skipped release, 1846-1857), the full manual-script chain 1846-1857 with each script's predecessor (checked against Migrations/*.manual.sql and the release assets), a "Verify the upgrade" pass/fail table, and "Backing up and restoring" (SQL, the AnalyticsState table, Key Vault, the saved installer configuration). Name the real Release & packages and Review & deploy options. Add release numbers, the 1833/1835 index builds and 1835's destructive table drop to the maintenance-window table. - SQL Upgrade Troubleshooting: fill in "Forcing schema updates" (File > Upgrade Database Schema, which also refreshes the SQL extensions after the .manual.sql scripts); current installer labels; AnalyticsEntitiesContext; a "database is behind this build" entry with the portal and Health texts. - Audit Events FK runbook: check the FK and index by column, not by name, so databases with the Create DB.sql names don't look failed; WebJob names. - URL shrink and Audit FK guides: say which builds they apply to; note that 1830's UniqueUrlsFullUrlIndex deletes duplicate URL rows. - Schema reference: add the copilot_cost_*, user_org_* and copilot_adoption_reclaim_exclusions tables and users.created_utc; the 25-day usage-report look-back; the dropped credit columns and Azure cost tag columns; release numbers; the other stores that hold tenant data. - Release Notes: complete 1857 PR list; GitHub keeps published stable releases from 1427; build 1604. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • Refresh wiki guides and screenshots for stable build 1854 Replace 49 product screenshots with current UI captures using fictional data. Split oversized guides into focused pages and refresh installation, upgrade, administration and report guidance with linked navigation. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: 75875569-ebac-4a0a-a963-7048d34147ad

    @sambetts sambetts committed Oct 22, 2026