packages.wenpai.net/migrations
elementary 6434bcc8f3
Some checks failed
ci / Go Modules Tidy (push) Waiting to run
ci / Go Test (push) Waiting to run
ci / Integration Test (push) Waiting to run
govulncheck / govulncheck (push) Waiting to run
ci / GolangCI-Lint (push) Has been cancelled
refactor(db+cli): drop versions_json and pipeline tables; disable legacy commands
Migration:
- Add 027_migrate_mirror_mode.sql
- Drop packages.versions_json (versions now fetched from upstream p2)
- Drop sync_runs, builds, metadata_changes, monthly_installs, status_checks, status_check_changes

Packages layer:
- Remove versions_json references from UpsertPackage, UpsertShellPackage, BatchUpsertPackages, BatchUpsertShellPackages, GetPackagesNeedingUpdate
- Make AllocateSyncRunID/FinishSyncRun no-ops (mirror mode has no sync_runs table)

CLI:
- Disable discover, update, build, deploy, pipeline, check-status commands
- All return "not available in mirror mode" to keep scripts from breaking
2026-04-12 01:31:36 +08:00
..
001_create_users.sql Initial commit 2026-03-14 13:36:07 -05:00
002_create_sessions.sql Initial commit 2026-03-14 13:36:07 -05:00
003_create_packages.sql Initial commit 2026-03-14 13:36:07 -05:00
004_create_install_events.sql Initial commit 2026-03-14 13:36:07 -05:00
005_create_sync_runs.sql Initial commit 2026-03-14 13:36:07 -05:00
006_create_builds.sql Initial commit 2026-03-14 13:36:07 -05:00
007_add_r2_synced_at_to_builds.sql Initial commit 2026-03-14 13:36:07 -05:00
008_add_og_image_tracking.sql Initial commit 2026-03-14 13:36:07 -05:00
009_add_error_message_to_builds.sql Track failed pipeline builds in admin dashboard (#2) 2026-03-14 18:48:23 -05:00
010_create_package_stats.sql DB query optimizations (#5) 2026-03-15 11:44:47 -05:00
011_add_packages_fts.sql DB query optimizations (#5) 2026-03-15 11:44:47 -05:00
012_create_site_meta.sql Fix SVN discovery never detecting package changes (#6) 2026-03-15 12:06:10 -05:00
013_add_pid_to_builds.sql Track build lifecycle for admin visibility (#10) 2026-03-15 13:49:37 -05:00
014_add_index_composer_installs.sql Perf improvements and build time tracking (#12) 2026-03-15 16:25:32 -04:00
015_add_step_durations_to_builds.sql Perf improvements and build time tracking (#12) 2026-03-15 16:25:32 -04:00
016_add_r2_upload_duration_to_builds.sql Track and display R2 upload duration in build timings 2026-03-15 16:31:46 -05:00
017_drop_provider_group_index.sql Drop Composer v1 support (#34) 2026-03-19 01:10:09 -04:00
018_rename_composer_to_packages.sql WP Packages rename (#42) 2026-03-19 11:50:12 -05:00
019_drop_provider_group_column.sql Remove stale provider_group references and drop column (#49) 2026-03-21 10:41:46 -05:00
020_create_metadata_changes.sql Add metadata changes feed (#51) 2026-03-21 15:45:31 -05:00
021_add_wporg_version.sql Add /untagged page and detail warnings for non-compliant plugins (#58) 2026-03-24 15:55:00 -05:00
022_create_monthly_installs.sql Add monthly install tracking for per-package install charts (#59) 2026-03-25 12:10:48 -05:00
023_add_trunk_revision.sql Pin dev-trunk to SVN revision and remove unpinnable dist (#69) 2026-03-26 12:10:49 -05:00
024_add_content_hash_columns.sql Add content_hash tracking and extract composer package (Phase 1) (#74) 2026-04-01 09:47:15 -05:00
025_create_status_checks.sql Add daily check-status sweep for closed/reopened packages (#84) 2026-04-01 20:39:46 -05:00
026_create_status_check_changes.sql Add public status page (#89) 2026-04-02 21:24:20 -05:00
027_migrate_mirror_mode.sql refactor(db+cli): drop versions_json and pipeline tables; disable legacy commands 2026-04-12 01:31:36 +08:00