| Server IP : 202.61.199.114 / Your IP : 216.73.217.139 Web Server : nginx/1.22.1 System : Linux de.arni-solutions.de 6.1.0-49-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64 User : web20 ( 1018) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/seaside2.pacim.de/web/database/migrations/ |
Upload File : |
-- Migration 016: Kundenquelle (z.B. "AIDA", "Eigene", "Booking", ...).
-- Wird im Anreisen-Export zum Gruppieren genutzt (eigenes Tabellenblatt pro Quelle).
USE `pacim_saas`;
SET @dbn = DATABASE();
SET @c := (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = @dbn AND TABLE_NAME = 'customers' AND COLUMN_NAME = 'source');
SET @sql := IF(@c = 0,
"ALTER TABLE customers ADD COLUMN source VARCHAR(50) NULL AFTER status",
'SELECT 1');
PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;