gitfor/platform

-- 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;