| 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 011: Anzahl der Gäste pro Buchung
USE `pacim_saas`;
SET @dbn = DATABASE();
SET @c := (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = @dbn AND TABLE_NAME = 'bookings' AND COLUMN_NAME = 'guest_count');
SET @sql := IF(@c = 0,
'ALTER TABLE bookings ADD COLUMN guest_count TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER license_plate',
'SELECT 1');
PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s;