149 lines
19 KiB
Plaintext
149 lines
19 KiB
Plaintext
# 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;
|