Doctrine Migrations
0
Executed
0
Unavailable
58
Available
58
New
Migrations 58
| Version | Description | Status | Executed at | Execution time |
|---|---|---|---|---|
| DoctrineMigrations\Version20220112003055CreateTables | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220118012735AddCompanyId | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220127005044AddIsActiveProperty | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220224230816ModifyReservation | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220228194110ModifyReservationItems | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220303222536SetDefaultValueTask | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220303224159AddAssigneeIdPropertyTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220307185730AddRelatedTaskIdTaskTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220307200036AddAmenitiesTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220314235314ChangePhoneTypeForAccountTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220318002854AddListingsChannelRelation | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220318224737AddTeamTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220318231635ModifiedReservation | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220322212426AddTeamIdField | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220330175510ModifiedPropertyTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220404235111AddRelatedItems | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220406202906ModifiedTaskItemRelated | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220419212102AddExternalPropertyIdReservation | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220419212525ChangeCompanyPhoneType | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220505232006AddTimezoneAccessTokenTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220506153033Version20220506153033AddTimeZoneAccountTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220602205302CreateNotificationTokenTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20220916234405CreateVendorAccessTokenTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20231220220611AddIsDeletedTaskTable | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20240111003216 | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20240205190528 | NOT EXECUTED | n/a | n/a | |
| DoctrineMigrations\Version20251208000000_create_phone_verification_table | Create phone_verification table for SMS verification codes | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20251210000000_add_verification_token | Add verification_token and token_expires_at columns to phone_verification table | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000001_account_role_table | Create account_role table and migrate legacy roles/team_id data | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000002_task_table | Add workflow, STI, and lifecycle columns to task; clean up legacy columns | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000003_issue_table | Create issue table; add task.source_issue_id; migrate data from task_damage_item | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000004_task_audit_log_table | Create task_audit_log table for tracking task state changes | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000005_task_note_table | Create task_note table; migrate task.notes to GENERAL task_note rows | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000006_property_checklist_template_table | Create property_checklist_template table for reusable task checklist templates | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000007_task_checklist_item_table | Create task_checklist_item table for per-task checklist tracking | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000008_photo_table | Rename file→photo; add STI discriminator, metadata, subtype FK columns; backfill data | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000009_account_updates | Add current_company_id and current_team_id context columns to account | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000010_property_updates | Add latitude and longitude to property table | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260301000011_drop_dead_tables | Drop deprecated tables, sequences, and legacy account/task columns | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260304000001_deduplicate_tasks | Deduplicate tasks with the same (order_id, type) and add unique index | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260306011951 | Add hasLivingRoom, hasKitchen, hasGarbageBin flags to property (all default true) | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260306011952 | Fix schema drift: photo.directory nullable, task_note.created_by_id nullable | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260313000001_add_task_due_time | Add due_at column to task table | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260316000001_backfill_task_due_at | Backfill due_at from todo_date + property timezone (pure SQL) | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260513000001_deduplicate_reservations | Deduplicate reservation rows by (channel_id, channel_code), repoint tasks/line_items, add unique indexes | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260515000001_reservation_last_event_at | Add reservation.last_event_at high-water mark for Guesty webhook event ordering | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260525000001_property_cleaning_fee_and_task_unit_price | Add property.new_cleaning_fee, property.cleaning_fee_effective_date, task.unit_price | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260526000001_issue_audit_log | Create issue_audit_log table for tracking issue operation history | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260528000001_photo_passed_field | Add passed (boolean, nullable) field to photo table for inspection review | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260601000001_billing_system | Create billing, billing_line_item, and payment tables for CZL-4121 | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260602000001_billing_audit_log | Create billing_audit_log table for tracking billing lifecycle events | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260602000002_checklist_item_passed | Add passed field to task_checklist_item for per-spot inspection review | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260608000001_reservation_confirmation_code_property_city | Add confirmation_code to reservation and city to property | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260610000001_performance_indexes | Add performance indexes on task, property, reservation, and related tables | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260625000001_price_non_negative_constraints | Add non-negative CHECK constraints on task.unit_price, property.cleaning_fee, and billing_line_item.unit_price | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260702000001_task_status_check_constraint | Clean up invalid task statuses and add CHECK constraint to task.status | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260706000001_backfill_property_city | Backfill property city from address field (2nd comma-separated segment), normalized to Title Case | NOT EXECUTED | n/a | n/a |
| DoctrineMigrations\Version20260709000001_replace_request_redo_audit_action | Replace REQUEST_REDO audit action with INSPECTION_FAILED before removing the enum value | NOT EXECUTED | n/a | n/a |
Configuration
| Storage | |
|---|---|
| Type | Doctrine\Migrations\Metadata\Storage\TableMetadataStorage |
| Table Name | doctrine_migration_versions |
| Column Name | version |
| Database | |
|---|---|
| Driver | Symfony\Bridge\Doctrine\Middleware\Debug\Driver |
| Name | postgres |
| Migration Namespaces | |
|---|---|
| DoctrineMigrations | /var/www/symfony/migrations |