| 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 017: Konfigurierbare Zahlungsarten.
-- Tabelle ersetzt die hardcoded Payment::METHODS Konstante.
-- "key" wird als Wert in payments.payment_method gespeichert (cash, card, ...).
USE `pacim_saas`;
CREATE TABLE IF NOT EXISTS payment_methods (
id INT AUTO_INCREMENT PRIMARY KEY,
method_key VARCHAR(50) NOT NULL UNIQUE,
label VARCHAR(100) NOT NULL,
sort_order INT NOT NULL DEFAULT 0,
is_active TINYINT(1) NOT NULL DEFAULT 1,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO payment_methods (method_key, label, sort_order, is_active) VALUES
('cash', 'Bar', 10, 1),
('card', 'Karte', 20, 1),
('bank_transfer', 'Überweisung', 30, 1),
('paypal', 'PayPal', 40, 1),
('other', 'Sonstige', 50, 1)
ON DUPLICATE KEY UPDATE method_key = VALUES(method_key);