51 lines
6.1 KiB
Plaintext
51 lines
6.1 KiB
Plaintext
# Migration Analysis - 20251123-092506
|
|
== 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
|
|
|
|
== 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
|
|
|
|
== Irreversible Operations (DROP, TRUNCATE) ==
|
|
/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;
|