-- Final cutover step: every moved table has been imported into its RepoState / AccountState object
-- (importAllScopesOnce has set its KV flag). Dropping them here makes D1 the directory only.
-- Move this file into migrations/ for the deploy AFTER the one that introduced the objects.

-- Triggers on directory tables that still reference moved tables.
DROP TRIGGER IF EXISTS credit_balances_account_deleted;
DROP TRIGGER IF EXISTS ai_endpoints_account_deleted;
DROP TRIGGER IF EXISTS collaborators_revoke_deploy_on_delete;
DROP TRIGGER IF EXISTS collaborators_revoke_deploy_on_downgrade;
DROP TRIGGER IF EXISTS org_members_revoke_deploy_on_delete;
DROP TRIGGER IF EXISTS org_members_revoke_deploy_on_demote;
DROP TRIGGER IF EXISTS repos_owner_lfs;
DROP TRIGGER IF EXISTS ai_endpoints_repo_deleted;

-- Moved tables, children before the tables they reference (SQLite checks a child's parent when it is dropped).
DROP TABLE IF EXISTS issues_fts;
DROP TABLE IF EXISTS comments;
DROP TABLE IF EXISTS issue_events;
DROP TABLE IF EXISTS issue_labels;
DROP TABLE IF EXISTS issue_assignees;
DROP TABLE IF EXISTS pinned_issues;
DROP TABLE IF EXISTS reactions;
DROP TABLE IF EXISTS pull_requests;
DROP TABLE IF EXISTS review_comments;
DROP TABLE IF EXISTS review_requests;
DROP TABLE IF EXISTS pull_issue_links;
DROP TABLE IF EXISTS pull_auto_merges;
DROP TABLE IF EXISTS issue_redirects;
DROP TABLE IF EXISTS thread_subscriptions;
DROP TABLE IF EXISTS branch_protections;
DROP TABLE IF EXISTS webhook_deliveries;
DROP TABLE IF EXISTS secrets;
DROP TABLE IF EXISTS repo_variables;
DROP TABLE IF EXISTS environment_secrets;
DROP TABLE IF EXISTS environment_variables;
DROP TABLE IF EXISTS deploy_tokens;
DROP TABLE IF EXISTS deployments;
DROP TABLE IF EXISTS repo_security_settings;
DROP TABLE IF EXISTS repo_mergefix_settings;
DROP TABLE IF EXISTS runner_policies;
DROP TABLE IF EXISTS job_steps;
DROP TABLE IF EXISTS job_artifacts;
DROP TABLE IF EXISTS commit_statuses;
DROP TABLE IF EXISTS workflow_triggers;
DROP TABLE IF EXISTS workflow_schedules;
DROP TABLE IF EXISTS action_caches;
DROP TABLE IF EXISTS job_tokens;
DROP TABLE IF EXISTS job_token_pushes;
DROP TABLE IF EXISTS ci_notify_state;
DROP TABLE IF EXISTS merge_queue_entries;
DROP TABLE IF EXISTS mergefix_runs;
DROP TABLE IF EXISTS hidden_ref_cleanups;
DROP TABLE IF EXISTS release_assets;
DROP TABLE IF EXISTS lfs_objects;
DROP TABLE IF EXISTS lfs_locks;
DROP TABLE IF EXISTS code_scanning_alerts;
DROP TABLE IF EXISTS sarif_uploads;
DROP TABLE IF EXISTS secret_alerts;
DROP TABLE IF EXISTS secret_push_blocks;
DROP TABLE IF EXISTS advisory_collaborators;
DROP TABLE IF EXISTS advisory_comments;
DROP TABLE IF EXISTS dependencies;
DROP TABLE IF EXISTS dependency_manifests;
DROP TABLE IF EXISTS security_counters;
DROP TABLE IF EXISTS discussion_comments;
DROP TABLE IF EXISTS discussion_votes;
DROP TABLE IF EXISTS push_events;
DROP TABLE IF EXISTS activity;
DROP TABLE IF EXISTS attachments;
DROP TABLE IF EXISTS repo_storage_estimates;
DROP TABLE IF EXISTS site_deployments;
DROP TABLE IF EXISTS site_env;
DROP TABLE IF EXISTS site_usage;
DROP TABLE IF EXISTS site_preview_comments;
DROP TABLE IF EXISTS site_pr_aliases;
DROP TABLE IF EXISTS sessions;
DROP TABLE IF EXISTS passkeys;
DROP TABLE IF EXISTS recovery_codes;
DROP TABLE IF EXISTS access_token_repos;
DROP TABLE IF EXISTS auth_tokens;
DROP TABLE IF EXISTS oauth_codes;
DROP TABLE IF EXISTS oauth_refresh_tokens;
DROP TABLE IF EXISTS mcp_token_agents;
DROP TABLE IF EXISTS agents;
DROP TABLE IF EXISTS signing_keys;
DROP TABLE IF EXISTS notification_settings;
DROP TABLE IF EXISTS notification_category_prefs;
DROP TABLE IF EXISTS notification_email_counters;
DROP TABLE IF EXISTS notification_unsubscribe_tokens;
DROP TABLE IF EXISTS notification_digest_items;
DROP TABLE IF EXISTS notification_deliveries;
DROP TABLE IF EXISTS notifications;
DROP TABLE IF EXISTS org_invitations;
DROP TABLE IF EXISTS owner_secrets;
DROP TABLE IF EXISTS owner_variables;
DROP TABLE IF EXISTS security_managers;
DROP TABLE IF EXISTS project_item_values;
DROP TABLE IF EXISTS account_billing;
DROP TABLE IF EXISTS billing_customers;
DROP TABLE IF EXISTS billing_addons;
DROP TABLE IF EXISTS credit_balances;
DROP TABLE IF EXISTS credit_ledger;
DROP TABLE IF EXISTS credit_draws;
DROP TABLE IF EXISTS usage_events;
DROP TABLE IF EXISTS usage_repo_periods;
DROP TABLE IF EXISTS usage_days;
DROP TABLE IF EXISTS usage_gauges;
DROP TABLE IF EXISTS usage_periods;
DROP TABLE IF EXISTS usage_reservations;
DROP TABLE IF EXISTS usage_claims;
DROP TABLE IF EXISTS usage_alerts;
DROP TABLE IF EXISTS quota_notices;
DROP TABLE IF EXISTS mcp_usage_daily;
DROP TABLE IF EXISTS mcp_audit;
DROP TABLE IF EXISTS lfs_usage;
DROP TABLE IF EXISTS lfs_account_objects;
DROP TABLE IF EXISTS integration_usage_daily;
DROP TABLE IF EXISTS runners;
DROP TABLE IF EXISTS runner_registration_tokens;
DROP TABLE IF EXISTS runner_usage_events;
DROP TABLE IF EXISTS editor_container_sessions;
DROP TABLE IF EXISTS ai_endpoints;
DROP TABLE IF EXISTS labels;
DROP TABLE IF EXISTS reviews;
DROP TABLE IF EXISTS webhooks;
DROP TABLE IF EXISTS environments;
DROP TABLE IF EXISTS workflow_jobs;
DROP TABLE IF EXISTS releases;
DROP TABLE IF EXISTS security_advisories;
DROP TABLE IF EXISTS discussions;
DROP TABLE IF EXISTS discussion_categories;
DROP TABLE IF EXISTS sites;
DROP TABLE IF EXISTS access_tokens;
DROP TABLE IF EXISTS project_fields;
DROP TABLE IF EXISTS project_items;
DROP TABLE IF EXISTS issues;
DROP TABLE IF EXISTS milestones;
DROP TABLE IF EXISTS issue_types;
DROP TABLE IF EXISTS workflow_runs;
DROP TABLE IF EXISTS projects;