bmc_hub/migrations
Christian 152670b4b2 Fix: Tilføj manglende is_travel og hourly_rate kolonner til tmodule_times
CRITICAL BUG FIX:
- Approval endpoint fejlede fordi is_travel kolonne ikke eksisterede i DB
- Koden referenced is_travel men migration var aldrig kørt
- Tilføjet is_travel (BOOLEAN DEFAULT false)
- Tilføjet hourly_rate (DECIMAL(10,2)) til times tabel
- Testet: Approval virker nu korrekt (entry 1225 godkendt)

RODSAG:
- User kunne ikke godkende timer fordi SQL fejlede med 'column does not exist'
- Dette forklarer hvorfor 0 entries nogensinde er blevet approved i systemet
2025-12-23 00:16:32 +01:00
..
002_auth_system.sql feat(ticket-module): Implement ticket system with comprehensive database schema, permissions, and testing suite 2025-12-15 23:40:23 +01:00
003_extend_customers.sql Add Material Blue design templates for dashboard and customer overview pages 2025-12-06 02:22:01 +01:00
004_contacts_relationships.sql Add Material Blue design templates for dashboard and customer overview pages 2025-12-06 02:22:01 +01:00
005_vendors.sql feat: Implement supplier invoices management with e-conomic integration 2025-12-07 03:29:54 +01:00
006_settings.sql feat: Implement Vendors API and Frontend 2025-12-06 11:04:19 +01:00
007_dev_portal.sql feat: Implement DEV Portal with Kanban board, idea management, and workflow editor 2025-12-06 21:27:47 +01:00
008_credit_notes.sql feat: Enhance billing frontend with Jinja2 templates and improve invoice handling 2025-12-08 09:15:52 +01:00
008_supplier_invoices.sql feat: Implement supplier invoices management with e-conomic integration 2025-12-07 03:29:54 +01:00
009_document_extraction.sql feat: Implement supplier invoices management with e-conomic integration 2025-12-07 03:29:54 +01:00
010_supplier_invoice_templates.sql feat: Implement supplier invoices management with e-conomic integration 2025-12-07 03:29:54 +01:00
011_extraction_lines_context.sql feat: Implement quick analysis on PDF upload for CVR, document type, and number extraction 2025-12-09 14:54:33 +01:00
011_quick_analysis.sql feat: Implement quick analysis on PDF upload for CVR, document type, and number extraction 2025-12-09 14:54:33 +01:00
012_own_invoice_filter.sql feat: Implement quick analysis on PDF upload for CVR, document type, and number extraction 2025-12-09 14:54:33 +01:00
012_template_default_category.sql feat: Implement quick analysis on PDF upload for CVR, document type, and number extraction 2025-12-09 14:54:33 +01:00
013_email_system.sql feat: Implement email processing system with scheduler, fetching, classification, and rule matching 2025-12-11 02:31:29 +01:00
013_timetracking_module.sql feat: Add customer time pricing management page with dynamic features 2025-12-10 18:29:13 +01:00
014_add_contact_user_company.sql feat: Add customer time pricing management page with dynamic features 2025-12-10 18:29:13 +01:00
014_economic_customer_number.sql feat: Add customer time pricing management page with dynamic features 2025-12-10 18:29:13 +01:00
014_email_workflows.sql feat: Implement Email Workflow System with comprehensive documentation and migration scripts 2025-12-15 12:28:12 +01:00
015_bmc_office_subscriptions.sql feat: Implement vTiger integration for subscriptions and sales orders 2025-12-11 23:14:20 +01:00
023_subscriptions_lock.sql feat: Add subscriptions lock feature to customers 2025-12-13 12:06:28 +01:00
024_backup_system.sql feat: Implement Email Workflow System with comprehensive documentation and migration scripts 2025-12-15 12:28:12 +01:00
025_ticket_module.sql feat(ticket-module): Implement ticket system with comprehensive database schema, permissions, and testing suite 2025-12-15 23:40:23 +01:00
026_ticket_enhancements.sql feat: Add Simply-CRM integration setup documentation and configuration details 2025-12-16 15:36:11 +01:00
026_ticket_permissions.sql feat(ticket-module): Implement ticket system with comprehensive database schema, permissions, and testing suite 2025-12-15 23:40:23 +01:00
027_customer_notes.sql feat: Implement internal comments for customer subscriptions with database support 2025-12-16 22:07:20 +01:00
027_tag_system.sql feat: Implement central tagging system with CRUD operations, entity tagging, and workflow management 2025-12-17 07:56:33 +01:00
028_auto_link_tmodule_customers.sql feat: Implement central tagging system with CRUD operations, entity tagging, and workflow management 2025-12-17 07:56:33 +01:00
029_ticket_contacts.sql feat: Implement ticket contacts management with flexible roles and CRUD operations 2025-12-17 16:38:08 +01:00
030_ticket_contacts_flexible_roles.sql feat: Implement ticket contacts management with flexible roles and CRUD operations 2025-12-17 16:38:08 +01:00
031_add_is_travel_column.sql Fix: Tilføj manglende is_travel og hourly_rate kolonner til tmodule_times 2025-12-23 00:16:32 +01:00
050_email_activity_log.sql feat: Implement Email Workflow System with comprehensive documentation and migration scripts 2025-12-15 12:28:12 +01:00
999_fix_cvr_unique_constraint.sql Fix: CVR unique constraint - tillad multiple kunder uden CVR nummer 2025-12-22 11:35:16 +01:00
init.sql Initial BMC Hub setup 2025-12-05 14:22:39 +01:00