Doctrine Migrations
109
Executed
0
Unavailable
109
Available
0
New
Migrations 109
| Version | Description | Status | Executed at | Execution time |
|---|---|---|---|---|
| Agency\Migrations\Version20260422100000 | Address book: enforce required and unique email, remove duplicate/empty records. | EXECUTED | Apr 24, 2026 08:40 | 56 ms |
| Agency\Migrations\Version20260413133300 | Add board default notification users (many-to-many). | EXECUTED | Apr 24, 2026 08:40 | 15 ms |
| Agency\Migrations\Version20260411170000 | Add MCP token fields to agency_user_settings for employee-only ticket MCP access. | EXECUTED | Apr 24, 2026 08:40 | 8 ms |
| Agency\Migrations\Version20260409105710 | Add context fields for customer offer/order visibility date and customer hint text. | EXECUTED | Apr 24, 2026 08:40 | 8 ms |
| Agency\Migrations\Version20260406174200 | Add invoice team split table for team revenue statistics. | EXECUTED | Apr 24, 2026 08:40 | 44 ms |
| Agency\Migrations\Version20260403141500 | Increase Office 365 contact id length for address book sync. | EXECUTED | Apr 24, 2026 08:40 | 44 ms |
| Agency\Migrations\Version20260403135500 | Add agency address book contacts with Office 365 sync metadata. | EXECUTED | Apr 24, 2026 08:40 | 13 ms |
| Agency\Migrations\Version20260324105712 | Add global focus flag for ToDo tickets. | EXECUTED | Apr 24, 2026 08:40 | 19 ms |
| Agency\Migrations\Version20260320144100 | Normalize agency_ticket.internal_progress: with_concept -> in_progress; unassigned in_progress -> new. | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| Agency\Migrations\Version20260320100000 | Add BPMN process documentation tables agency_process and agency_process_version. | EXECUTED | Apr 24, 2026 08:40 | 19 ms |
| Agency\Migrations\Version20260319173000 | Add invoice_vat_free flag to agency_context for automatic billing invoices. | EXECUTED | Apr 24, 2026 08:40 | 9 ms |
| Ciosix\Core\User\Migrations\Version20260318105159 | Create default MailGPT user and automatically resolve its team_id. | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| DoctrineMigrations\Version20260313100800 | Increase agency_session.sess_data capacity from BLOB to LONGBLOB to prevent SQLSTATE[22001] session truncation. | EXECUTED | Apr 24, 2026 08:40 | 12 ms |
| Ciosix\Core\User\Migrations\Version20260310095530 | Create integration table and migrate legacy user.auth_token values | EXECUTED | Apr 24, 2026 08:40 | 22 ms |
| Ciosix\Core\User\Migrations\Version20260309092127 | EXECUTED | Apr 24, 2026 08:40 | 9 ms | |
| Ciosix\Core\Notes\Migrations\Version20260302101334 | EXECUTED | Apr 24, 2026 08:40 | 10 ms | |
| Agency\Migrations\Version20260213182307 | Add invoice_text to agency_invoice. | EXECUTED | Apr 24, 2026 08:40 | 9 ms |
| Agency\Migrations\Version20260212123901 | Context: Add billing_reference_required + billing_reference_default for Abrechnungsreferenz defaults/requirement. | EXECUTED | Apr 24, 2026 08:40 | 21 ms |
| Agency\Migrations\Version20260212090000 | Invoice: Add customer_reference (Abrechnungsreferenz) to agency_invoice for billing merge/grouping. | EXECUTED | Apr 24, 2026 08:40 | 21 ms |
| Agency\Migrations\Version20260205221200 | Billing: Backfill ticket number prefix into invoice item text (invoices >= 2026-02-01) when offer/order is linked to a ticket. | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| Agency\Migrations\Version20260204165100 | Add follow-up monitoring flags to Context and Ticket (opt-in) + snooze until timestamp. | EXECUTED | Apr 24, 2026 08:40 | 47 ms |
| Agency\Migrations\Version20260126202555 | Create agency_user_settings table (weekly work hours per user). | EXECUTED | Apr 24, 2026 08:40 | 22 ms |
| Agency\Migrations\Version20260125181553 | Add OpenAI token→user mapping table and persist user_id on OpenAI proxy logs. | EXECUTED | Apr 24, 2026 08:40 | 66 ms |
| Agency\Migrations\Version20260124185012 | Store OpenAI proxy request/response bodies as LONGBLOB to support gzipped payloads. | EXECUTED | Apr 24, 2026 08:40 | 18 ms |
| Agency\Migrations\Version20260123125128 | Add conversation_key to agency_openai_proxy_log for grouping implicit multi-request conversations. | EXECUTED | Apr 24, 2026 08:40 | 20 ms |
| Agency\Migrations\Version20260120124610 | Add user_prompt column to agency_openai_proxy_log (persisted extracted user prompt). | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20260119134600 | Backfill agency_ticket.estimated_hours_updated_at from latest ticket_estimated_remaining_hours note. | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| Agency\Migrations\Version20260119134213 | Add estimated_hours_updated_at to agency_ticket to track last Restaufwand update. | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20260118140058 | Add api_key_suffix + token usage columns to agency_openai_proxy_log. | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20260118130900 | Create agency_openai_proxy_log table for OpenAI gateway request/response auditing. | EXECUTED | Apr 24, 2026 08:40 | 47 ms |
| DoctrineMigrations\Version20260116100000 | Create DB-backed Symfony sessions table (agency_session). | EXECUTED | Apr 24, 2026 08:40 | 18 ms |
| Agency\Migrations\Version20260111165300 | Add last_log to agency_package to persist the last SATIS build error per repository. | EXECUTED | Apr 24, 2026 08:40 | 10 ms |
| Agency\Migrations\Version20260110145500 | Seed CIOSIX setting for pinned time-tracking tickets (agency.time_tracking.pinned_tickets). | EXECUTED | Apr 24, 2026 08:40 | 0 ms |
| Agency\Migrations\Version20260109202925 | Add manual sort field to agency_board (higher numbers first). | EXECUTED | Apr 24, 2026 08:40 | 23 ms |
| Ciosix\Core\Mailtemplates\Migrations\Version20260109135939 | EXECUTED | Apr 24, 2026 08:40 | 12 ms | |
| Ciosix\Core\Translations\Migrations\Version20260108145116 | EXECUTED | Apr 24, 2026 08:40 | 10 ms | |
| Agency\Migrations\Version20260107194500 | Add indexable ticket_number to agency_gitlab_commit_ticket and add supporting indexes for activity wall (avoid CONCAT join + speed up created_at sorting). | EXECUTED | Apr 24, 2026 08:40 | 34 ms |
| Ciosix\Core\Notes\Migrations\Version20260107190500 | Add performance indexes for activity wall sorting/filtering on note (created_at/id + is_private/created_at/id). | EXECUTED | Apr 24, 2026 08:40 | 20 ms |
| Ciosix\Core\Cron\Migrations\Version20260107150000 | Create cron_schedule table | EXECUTED | Apr 24, 2026 08:40 | 56 ms |
| Agency\Migrations\Version20260107150000 | Add Context.superadmin_only lock flag and seed ROLE_SUPERADMIN authorization role. | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20260107130500 | Add technical audit log table agency_audit_log for entity history (snapshot+diff+collections). | EXECUTED | Apr 24, 2026 08:40 | 10 ms |
| Agency\Migrations\Version20260107080230 | Add agency_context_user join table for direct context access grants (union with team access). | EXECUTED | Apr 24, 2026 08:40 | 36 ms |
| Agency\Migrations\Version20260106093704 | Add metabase_redirect_url to agency_context for Metabase redirect feature. | EXECUTED | Apr 24, 2026 08:40 | 7 ms |
| Agency\Migrations\Version20260106093236 | Add offer/order visibility whitelist (customer users) to contexts. | EXECUTED | Apr 24, 2026 08:40 | 35 ms |
| Agency\Migrations\Version20260105150000 | Add default notification users for contexts (agency_context_default_notification_user). | EXECUTED | Apr 24, 2026 08:40 | 39 ms |
| Agency\Migrations\Version20260104134000 | Add agency_ticket_search table (public/internal fulltext) for fast ticket + note search. | EXECUTED | Apr 24, 2026 08:40 | 61 ms |
| Agency\Migrations\Version20260103155500 | Create credential_note join table for CIOSIX Notes on credentials (fix missing table error on credential edit). | EXECUTED | Apr 24, 2026 08:40 | 41 ms |
| Agency\Migrations\Version20260103073630 | Drop agency_ticket.due_at column (and related indexes) after removing dueAt from Ticket entity. | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20251231095102 | Add archived flag to agency_context. | EXECUTED | Apr 24, 2026 08:40 | 9 ms |
| Ciosix\Core\Notes\Migrations\Version20251230144130 | Add is_private flag to note table | EXECUTED | Apr 24, 2026 08:40 | 8 ms |
| Agency\Migrations\Version20251230080550 | Drop Ticket.priority (prio removed from system) | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
| Agency\Migrations\Version20251229111500 | Drop legacy agency_gitlab_commit.ticket_numbers JSON column and add agency_gitlab_commit.author_email. | EXECUTED | Apr 24, 2026 08:40 | 18 ms |
| Agency\Migrations\Version20251229104500 | Add agency_gitlab_commit_ticket table (indexable ticket_number_label) and backfill from agency_gitlab_commit.ticket_numbers JSON. | EXECUTED | Apr 24, 2026 08:40 | 26 ms |
| Agency\Migrations\Version20251229103002 | Add OfferOrder "protected" flag (hide offer price in ticket edit view). | EXECUTED | Apr 24, 2026 08:40 | 9 ms |
| Agency\Migrations\Version20251229100500 | Add agency_gitlab_commit table to store GitLab push commits (unique by repository_url + commit_id). | EXECUTED | Apr 24, 2026 08:40 | 9 ms |
| Agency\Migrations\Version20251228162201 | Make agency_invoice.context_id nullable (allow draft invoices without context). | EXECUTED | Apr 24, 2026 08:40 | 20 ms |
| Agency\Migrations\Version20251228092700 | Add agency_rest_day table for holiday/sick/national holiday calendar (incl. GitLab sync). | EXECUTED | Apr 24, 2026 08:40 | 29 ms |
| Agency\Migrations\Version20251227163215 | Remove package_name from agency_package; repository_url is the only managed field. | EXECUTED | Apr 24, 2026 08:40 | 27 ms |
| Agency\Migrations\Version20251227153424 | EXECUTED | Apr 24, 2026 08:40 | 26 ms | |
| Agency\Migrations\Version20251227145821 | Add optional board relation to agency_offerorder for board-based billing. | EXECUTED | Apr 24, 2026 08:40 | 43 ms |
| Agency\Migrations\Version20251227091656 | Billing: InvoiceItem links to OfferOrder (offer_order_id) instead of Ticket; remove OfferOrder.invoice_item_id dedup. | EXECUTED | Apr 24, 2026 08:40 | 93 ms |
| Agency\Migrations\Version20251224081119 | EXECUTED | Apr 24, 2026 08:40 | 117 ms | |
| Agency\Migrations\Version20251223220000 | Add agency_board_group.calender_week (nullable int) + index and backfill from name patterns (KW xx / Title (KW XX)). | EXECUTED | Apr 24, 2026 08:40 | 21 ms |
| Agency\Migrations\Version20251223143000 | Create invoice_note join table for CIOSIX Notes on invoices. | EXECUTED | Apr 24, 2026 08:40 | 37 ms |
| Agency\Migrations\Version20251223140000 | Migrate invoice_number to global 6-digit sequence without year prefix and initialize agency_invoice_number_sequence year=0. | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| Agency\Migrations\Version20251223122524 | Create invoice tables: agency_invoice, agency_invoice_item, agency_invoice_number_sequence. | EXECUTED | Apr 24, 2026 08:40 | 54 ms |
| Agency\Migrations\Version20251223122326 | EXECUTED | Apr 24, 2026 08:40 | 39 ms | |
| Agency\Migrations\Version20251223120405 | EXECUTED | Apr 24, 2026 08:40 | 155 ms | |
| Agency\Migrations\Version20251223095230 | Add time tracking tables agency_time_entry and agency_ticket_touched. | EXECUTED | Apr 24, 2026 08:40 | 142 ms |
| Agency\Migrations\Version20251223093100 | Remove agency_board.priority column (boards do not have priorities). | EXECUTED | Apr 24, 2026 08:40 | 18 ms |
| Agency\Migrations\Version20251222182530 | Make agency_ticket.board_group_id nullable for Ticket ToDo list ("without board group") and update FK to SET NULL. | EXECUTED | Apr 24, 2026 08:40 | 54 ms |
| Agency\Migrations\Version20251222160348 | EXECUTED | Apr 24, 2026 08:40 | 54 ms | |
| Agency\Migrations\Version20251222122230 | Refactor agency_team_context to a pure join table for Context <-> Team access (ManyToMany). | EXECUTED | Apr 24, 2026 08:40 | 44 ms |
| Agency\Migrations\Version20251222090019 | Drop agency_context_user mapping table (Context no longer has direct user assignments). | EXECUTED | Apr 24, 2026 08:40 | 19 ms |
| Agency\Migrations\Version20251222085731 | Create agency_team_context mapping table for Team -> Context access control. | EXECUTED | Apr 24, 2026 08:40 | 39 ms |
| Agency\Migrations\Version20251221170946 | EXECUTED | Apr 24, 2026 08:40 | 255 ms | |
| Agency\Migrations\Version20251221160000 | Remove key_account_user_id from agency_ticket | EXECUTED | Apr 24, 2026 08:40 | 18 ms |
| Agency\Migrations\Version20251220180000 | Add ticket_number to agency_ticket and create agency_ticket_number_sequence for legacy-like ticket numbers (T{ticketNumber} starting at 10001). | EXECUTED | Apr 24, 2026 08:40 | 44 ms |
| Agency\Migrations\Version20251220173634 | EXECUTED | Apr 24, 2026 08:40 | 81 ms | |
| Ciosix\Core\Mailtemplates\Migrations\Version20251218135340 | EXECUTED | Apr 24, 2026 08:40 | 8 ms | |
| Ciosix\Core\Translations\Migrations\Version20251127153947 | EXECUTED | Apr 24, 2026 08:40 | 10 ms | |
| Ciosix\Core\Flows\Migrations\Version20251121140344 | EXECUTED | Apr 24, 2026 08:40 | 8 ms | |
| Ciosix\Core\Flows\Migrations\Version20251121125454 | EXECUTED | Apr 24, 2026 08:40 | 5 ms | |
| Ciosix\Core\Translations\Migrations\Version20251120101111 | EXECUTED | Apr 24, 2026 08:40 | 5 ms | |
| Agency\Migrations\Version20251022173139 | EXECUTED | Apr 24, 2026 08:40 | 73 ms | |
| Ciosix\Core\User\Migrations\Version20251010120505 | EXECUTED | Apr 24, 2026 08:40 | 87 ms | |
| Ciosix\Core\Tasks\Migrations\Version20251008111356 | EXECUTED | Apr 24, 2026 08:40 | 35 ms | |
| Ciosix\Core\Settings\Migrations\Version20251006115741 | EXECUTED | Apr 24, 2026 08:40 | 13 ms | |
| Agency\Migrations\Version20250813135301 | EXECUTED | Apr 24, 2026 08:40 | 36 ms | |
| Agency\Migrations\Version20250813131305 | EXECUTED | Apr 24, 2026 08:40 | 8 ms | |
| Agency\Migrations\Version20250813123519 | EXECUTED | Apr 24, 2026 08:40 | 5 ms | |
| Ciosix\Core\User\Migrations\Version20250716132303 | EXECUTED | Apr 24, 2026 08:40 | 8 ms | |
| Ciosix\Core\Migrations\Version20250613114214 | EXECUTED | Apr 24, 2026 08:40 | 3 ms | |
| Ciosix\Core\User\Migrations\Version20250203131719 | EXECUTED | Apr 24, 2026 08:40 | 8 ms | |
| Ciosix\Core\Settings\Migrations\Version20241125143652 | EXECUTED | Apr 24, 2026 08:40 | 7 ms | |
| Ciosix\Core\Migrations\Version20241107193257 | EXECUTED | Apr 24, 2026 08:40 | 19 ms | |
| Ciosix\Core\Flows\Migrations\Version20240926065545 | EXECUTED | Apr 24, 2026 08:40 | 42 ms | |
| Ciosix\Core\Tasks\Migrations\Version20240916083554 | EXECUTED | Apr 24, 2026 08:40 | 19 ms | |
| Ciosix\Core\Notes\Migrations\Version20231228081101 | EXECUTED | Apr 24, 2026 08:40 | 18 ms | |
| Ciosix\Core\Notes\Migrations\Version20230828125827 | EXECUTED | Apr 24, 2026 08:40 | 4 ms | |
| Ciosix\Core\Notes\Migrations\Version20230607090034 | EXECUTED | Apr 24, 2026 08:40 | 5 ms | |
| Ciosix\Core\User\Migrations\Version20230606132413 | EXECUTED | Apr 24, 2026 08:40 | 35 ms | |
| Ciosix\Core\Notes\Migrations\Version20230606131700 | EXECUTED | Apr 24, 2026 08:40 | 69 ms | |
| Ciosix\Core\Mailtemplates\Migrations\Version20230606075325 | EXECUTED | Apr 24, 2026 08:40 | 27 ms | |
| Ciosix\Core\User\Migrations\Version20221116085805 | Ciosix\User migrations (admin user) | EXECUTED | Apr 24, 2026 08:40 | 1 ms |
| Ciosix\Core\Migrations\Version20221116075855 | Ciosix\Core migrations (countries data) | EXECUTED | Apr 24, 2026 08:40 | 43 ms |
| Ciosix\Core\Migrations\Version20220829063441 | EXECUTED | Apr 24, 2026 08:40 | 5 ms | |
| Ciosix\Core\User\Migrations\Version20220819085805 | Ciosix\User migrations | EXECUTED | Apr 24, 2026 08:40 | 97 ms |
| Ciosix\Core\Migrations\Version20220819075855 | Ciosix\Core migrations | EXECUTED | Apr 24, 2026 08:40 | 11 ms |
Configuration
| Storage | |
|---|---|
| Type | Doctrine\Migrations\Metadata\Storage\TableMetadataStorage |
| Table Name | doctrine_migration_versions |
| Column Name | version |
| Database | |
|---|---|
| Driver | Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver |
| Name | db |
| Migration Namespaces | |
|---|---|
| Ciosix\Core\Migrations | /var/www/html/vendor/ciosix/core/core/migrations |
| Ciosix\Core\User\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/User/migrations |
| Ciosix\Core\Dashboard\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Dashboard/migrations |
| Ciosix\Core\Notes\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Notes/migrations |
| Ciosix\Core\Tasks\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Tasks/migrations |
| Ciosix\Core\Cron\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Cron/migrations |
| Ciosix\Core\Flows\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Flows/migrations |
| Ciosix\Core\Mailtemplates\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Mailtemplates/migrations |
| Ciosix\Core\Settings\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Settings/migrations |
| Ciosix\Core\Translations\Migrations | /var/www/html/vendor/ciosix/core/core/bundles/Translations/migrations |
| DoctrineMigrations | /var/www/html/migrations |
| Agency\Migrations | /var/www/html/custom/Agency/migrations |