# Migration Analysis - 20251123-124312
== Migration Files Found ==
-rw-r--r-- 1 administrator administrator   402 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/001_create_users_and_identities.down.sql
-rw-r--r-- 1 administrator administrator  2429 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/001_create_users_and_identities.up.sql
-rw-r--r-- 1 administrator administrator   508 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.down.sql
-rw-r--r-- 1 administrator administrator  3772 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.up.sql
-rw-r--r-- 1 administrator administrator   583 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/003_create_invoices_and_payments.down.sql
-rw-r--r-- 1 administrator administrator  5390 Nov 21 09:03 /home/administrator/projects/coppertone.tech/backend/migrations/003_create_invoices_and_payments.up.sql
-rw------- 1 administrator administrator  1557 Nov 23 04:38 /home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql
-rw------- 1 administrator administrator  8219 Nov 23 04:38 /home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.up.sql
-rw------- 1 administrator administrator   346 Nov 23 04:50 /home/administrator/projects/coppertone.tech/backend/migrations/005_schema_separation.down.sql
-rw------- 1 administrator administrator  4109 Nov 23 04:50 /home/administrator/projects/coppertone.tech/backend/migrations/005_schema_separation.up.sql
-rw------- 1 administrator administrator  1165 Nov 23 07:27 /home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.down.sql
-rw------- 1 administrator administrator  6276 Nov 23 07:27 /home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.up.sql
-rw------- 1 administrator administrator   242 Nov 23 10:08 /home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.down.sql
-rw------- 1 administrator administrator  1361 Nov 23 10:08 /home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.up.sql
-rw------- 1 administrator administrator   171 Nov 23 10:58 /home/administrator/projects/coppertone.tech/backend/migrations/008_csrf_tokens.down.sql
-rw------- 1 administrator administrator   815 Nov 23 10:58 /home/administrator/projects/coppertone.tech/backend/migrations/008_csrf_tokens.up.sql
-rw------- 1 administrator administrator  2237 Nov 23 12:01 /home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql
-rw------- 1 administrator administrator 12815 Nov 23 12:00 /home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.up.sql
-rw------- 1 administrator administrator  3012 Nov 23 12:09 /home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql
-rw------- 1 administrator administrator 23737 Nov 23 12:08 /home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.up.sql

== Migration Pairs Check (up/down) ==
[OK] 001_create_users_and_identities has both up and down migrations
[OK] 002_create_projects_and_tasks has both up and down migrations
[OK] 003_create_invoices_and_payments has both up and down migrations
[OK] 004_approval_workflow_and_audit has both up and down migrations
[OK] 005_schema_separation has both up and down migrations
[OK] 006_superuser_hierarchy has both up and down migrations
[OK] 007_refresh_tokens has both up and down migrations
[OK] 008_csrf_tokens has both up and down migrations
[OK] 009_messenger has both up and down migrations
[OK] 010_enhanced_payments has both up and down migrations

== Irreversible Operations (DROP, TRUNCATE) ==
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:13:DROP INDEX IF EXISTS idx_messenger_relay_active;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:14:DROP INDEX IF EXISTS idx_messenger_peer_registry_trusted;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:15:DROP INDEX IF EXISTS idx_messenger_peer_registry_type;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:16:DROP INDEX IF EXISTS idx_messenger_messages_ipfs;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:17:DROP INDEX IF EXISTS idx_messenger_messages_created;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:18:DROP INDEX IF EXISTS idx_messenger_messages_sender;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:19:DROP INDEX IF EXISTS idx_messenger_messages_conversation;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:20:DROP INDEX IF EXISTS idx_messenger_members_user;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:21:DROP INDEX IF EXISTS idx_messenger_members_conversation;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:22:DROP INDEX IF EXISTS idx_messenger_conversations_owner;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:23:DROP INDEX IF EXISTS idx_messenger_conversations_type;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:24:DROP INDEX IF EXISTS idx_messenger_blocklist_peer;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:25:DROP INDEX IF EXISTS idx_messenger_blocklist_blocked;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:26:DROP INDEX IF EXISTS idx_messenger_blocklist_owner;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:27:DROP INDEX IF EXISTS idx_messenger_contacts_messaging_id;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:28:DROP INDEX IF EXISTS idx_messenger_contacts_status;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:29:DROP INDEX IF EXISTS idx_messenger_contacts_owner;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:30:DROP INDEX IF EXISTS idx_messenger_keys_type;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:31:DROP INDEX IF EXISTS idx_messenger_keys_user_active;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:32:DROP INDEX IF EXISTS idx_messenger_profiles_status;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:33:DROP INDEX IF EXISTS idx_messenger_profiles_peer_id;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:34:DROP INDEX IF EXISTS idx_messenger_profiles_messaging_id;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:37:DROP TABLE IF EXISTS messenger_relay_nodes;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:38:DROP TABLE IF EXISTS messenger_peer_registry;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:39:DROP TABLE IF EXISTS messenger_read_receipts;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:40:DROP TABLE IF EXISTS messenger_messages;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:41:DROP TABLE IF EXISTS messenger_conversation_members;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:42:DROP TABLE IF EXISTS messenger_conversations;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:43:DROP TABLE IF EXISTS messenger_blocklist;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:44:DROP TABLE IF EXISTS messenger_contact_groups;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:45:DROP TABLE IF EXISTS messenger_contacts;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:46:DROP TABLE IF EXISTS messenger_keys;
/home/administrator/projects/coppertone.tech/backend/migrations/009_messenger.down.sql:47:DROP TABLE IF EXISTS messenger_profiles;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:17:DROP INDEX IF EXISTS idx_subscriptions_status;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:18:DROP INDEX IF EXISTS idx_subscriptions_user;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:19:DROP INDEX IF EXISTS idx_exchange_rates_history_pair;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:20:DROP INDEX IF EXISTS idx_exchange_rates_pair;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:21:DROP INDEX IF EXISTS idx_campaigns_public;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:22:DROP INDEX IF EXISTS idx_campaigns_active;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:23:DROP INDEX IF EXISTS idx_campaigns_slug;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:24:DROP INDEX IF EXISTS idx_donations_recurring;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:25:DROP INDEX IF EXISTS idx_donations_created;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:26:DROP INDEX IF EXISTS idx_donations_status;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:27:DROP INDEX IF EXISTS idx_donations_donor;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:28:DROP INDEX IF EXISTS idx_donations_campaign;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:29:DROP INDEX IF EXISTS idx_payment_audit_created;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:30:DROP INDEX IF EXISTS idx_payment_audit_action;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:31:DROP INDEX IF EXISTS idx_payment_audit_invoice;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:32:DROP INDEX IF EXISTS idx_payment_audit_payment;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:33:DROP INDEX IF EXISTS idx_payment_crypto_confirmed;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:34:DROP INDEX IF EXISTS idx_payment_crypto_network;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:35:DROP INDEX IF EXISTS idx_payment_crypto_tx;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:36:DROP INDEX IF EXISTS idx_payment_crypto_payment;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:37:DROP INDEX IF EXISTS idx_payment_gateways_enabled;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:38:DROP INDEX IF EXISTS idx_payment_gateways_code;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:39:DROP INDEX IF EXISTS idx_payment_wallets_primary;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:40:DROP INDEX IF EXISTS idx_payment_wallets_active;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:41:DROP INDEX IF EXISTS idx_payment_wallets_network;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:42:DROP INDEX IF EXISTS idx_payment_tokens_contract;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:43:DROP INDEX IF EXISTS idx_payment_tokens_enabled;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:44:DROP INDEX IF EXISTS idx_payment_tokens_verified;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:45:DROP INDEX IF EXISTS idx_payment_tokens_symbol;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:46:DROP INDEX IF EXISTS idx_payment_tokens_network;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:47:DROP INDEX IF EXISTS idx_payment_networks_enabled;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:48:DROP INDEX IF EXISTS idx_payment_networks_code;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:51:DROP TABLE IF EXISTS subscriptions;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:52:DROP TABLE IF EXISTS subscription_plans;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:53:DROP TABLE IF EXISTS exchange_rates_history;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:54:DROP TABLE IF EXISTS exchange_rates;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:55:DROP TABLE IF EXISTS donation_tiers;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:56:DROP TABLE IF EXISTS donations;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:57:DROP TABLE IF EXISTS donation_campaigns;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:58:DROP TABLE IF EXISTS payment_audit_log;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:59:DROP TABLE IF EXISTS payment_crypto_details;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:60:DROP TABLE IF EXISTS payment_gateway_currencies;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:61:DROP TABLE IF EXISTS payment_gateways;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:62:DROP TABLE IF EXISTS payment_wallets;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:63:DROP TABLE IF EXISTS payment_tokens;
/home/administrator/projects/coppertone.tech/backend/migrations/010_enhanced_payments.down.sql:64:DROP TABLE IF EXISTS payment_networks;
/home/administrator/projects/coppertone.tech/backend/migrations/003_create_invoices_and_payments.down.sql:11:DROP TABLE IF EXISTS invoice_items;
/home/administrator/projects/coppertone.tech/backend/migrations/003_create_invoices_and_payments.down.sql:12:DROP TABLE IF EXISTS payments;
/home/administrator/projects/coppertone.tech/backend/migrations/003_create_invoices_and_payments.down.sql:13:DROP TABLE IF EXISTS invoices;
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:20:DROP TABLE IF EXISTS project_approval_comments;
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:23:DROP TABLE IF EXISTS audit_log;
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:31:    DROP COLUMN IF EXISTS created_by,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:32:    DROP COLUMN IF EXISTS approved_by,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:33:    DROP COLUMN IF EXISTS approval_status,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:34:    DROP COLUMN IF EXISTS approval_date,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:35:    DROP COLUMN IF EXISTS rejection_reason;
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:39:    DROP COLUMN IF EXISTS requested_by,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:40:    DROP COLUMN IF EXISTS approved_by,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:41:    DROP COLUMN IF EXISTS approval_status,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:42:    DROP COLUMN IF EXISTS approval_date,
/home/administrator/projects/coppertone.tech/backend/migrations/004_approval_workflow_and_audit.down.sql:43:    DROP COLUMN IF EXISTS rejection_reason;
/home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.down.sql:17:DROP TABLE IF EXISTS superuser_transfers;
/home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.down.sql:20:DROP INDEX IF EXISTS idx_users_initial_superuser;
/home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.down.sql:23:ALTER TABLE users DROP COLUMN IF EXISTS is_protected;
/home/administrator/projects/coppertone.tech/backend/migrations/006_superuser_hierarchy.down.sql:24:ALTER TABLE users DROP COLUMN IF EXISTS is_initial_superuser;
/home/administrator/projects/coppertone.tech/backend/migrations/001_create_users_and_identities.down.sql:9:DROP TABLE IF EXISTS user_roles;
/home/administrator/projects/coppertone.tech/backend/migrations/001_create_users_and_identities.down.sql:10:DROP TABLE IF EXISTS identities;
/home/administrator/projects/coppertone.tech/backend/migrations/001_create_users_and_identities.down.sql:11:DROP TABLE IF EXISTS users;
/home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.down.sql:8:DROP TABLE IF EXISTS task_comments;
/home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.down.sql:9:DROP TABLE IF EXISTS work_orders;
/home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.down.sql:10:DROP TABLE IF EXISTS tasks;
/home/administrator/projects/coppertone.tech/backend/migrations/002_create_projects_and_tasks.down.sql:11:DROP TABLE IF EXISTS projects;
/home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.down.sql:3:DROP INDEX IF EXISTS idx_refresh_tokens_revoked_at;
/home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.down.sql:4:DROP INDEX IF EXISTS idx_refresh_tokens_expires_at;
/home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.down.sql:5:DROP INDEX IF EXISTS idx_refresh_tokens_user_id;
/home/administrator/projects/coppertone.tech/backend/migrations/007_refresh_tokens.down.sql:6:DROP TABLE IF EXISTS refresh_tokens;
/home/administrator/projects/coppertone.tech/backend/migrations/008_csrf_tokens.down.sql:2:DROP INDEX IF EXISTS idx_csrf_tokens_expires_at;
/home/administrator/projects/coppertone.tech/backend/migrations/008_csrf_tokens.down.sql:3:DROP INDEX IF EXISTS idx_csrf_tokens_user_id;
/home/administrator/projects/coppertone.tech/backend/migrations/008_csrf_tokens.down.sql:4:DROP TABLE IF EXISTS csrf_tokens;