Skip to content

History / Database Copilot Schema

Revisions

  • Repoint links to the renamed 1856 upgrade page Re-applies 8 of the 11 one-line repoints of 0e10a19 (docs/restructure-upgrade-pages), on pages the Copilot Adoption/WTI restructure didn't stub: Copilot Agent Evidence, Copilot Reports and Prompt History (Clean Old Data now links System performance, D2-25), Copilot, Database Activity and Web Schema, Database Copilot Schema, Database Schema, Installation - Manual Setup and Manual Install Deploy Binaries. Dropped, as both authors agreed: the hunks on Copilot Adoption People Guide, Copilot Adoption Time Saved Reference and WTI Evidence and Setup, which are now WR1 forwarding stubs (kept as WR1 wrote them). Follow-on repoints for the combination: - Copilot Adoption Metrics Reference, which took over the Time Saved Reference's Migration 003 note, now links Upgrade to Build 1856 instead of the old page name. - Upgrade to Build 1856's one-off-effects bullet links the time-saved section on the Metrics Reference, not the Time Saved Reference stub that WR1 left it on pending this rename. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • Turn dangling screenshot lead-ins into instructions on the install pages - Private Endpoint Manual Setup: tell installer users to clear the saved public-access setting rather than disable public access by hand, which the next installer run would undo; write out the App Service and SQL private endpoint steps that pointed at missing screenshots. - Certificate Authentication: write out the Key Vault policy and Entra certificate-upload steps, including the RBAC alternative. - Manual install stage 3: replace the screenshot-less reply-URL steps with the exact redirect URI and the two optional callbacks. - Private Endpoints: drop an "Example network:" lead-in with no diagram. - Database Copilot Schema: link the retention note to the page that documents Clean Old Data Data.sql. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • 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
  • Mark work shipped in Stable 1856 as released Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: 227226cc-9fa8-461c-9a39-17795ba0b247

    @sambetts sambetts committed Oct 30, 2026
  • Document unreleased importer reliability fixes and upgrade safeguards Describe PR #768's operator-visible changes on the reorganised wiki: Teams recovery and token handling, call retries and dead-letter replay, user-import safety, concealed-identity cleanup, usage and web tracking, portal recovery, and the three-migration upgrade chain. Include measured migration time/space and cleanup-sizing limitations, manual-script ordering and cancellation guidance, custom-reference collision safeguards, and the post-upgrade client-secret rotation. Mark the new behaviour unreleased and link it to the tracking PR. Preserve the current topic-page layout and existing screenshots. Examples and sample logs are synthetic. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: a52454d3-2b0c-4e3d-b9ca-9a9661cb9be3

    @sambetts sambetts committed Oct 22, 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