| 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/arni-solutions.de/web/crm/database/ |
Upload File : |
-- ArNi CRM – Server-Verwaltung (ISPConfig/DB) Audit-Log + Import-Protokoll. CREATE TABLE IF NOT EXISTS `crm_server_admin_audit` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT UNSIGNED DEFAULT NULL, `user_name` VARCHAR(120) DEFAULT NULL, `area` VARCHAR(32) NOT NULL, -- website | database | ssl `resource` VARCHAR(190) DEFAULT NULL, -- Domain / DB-Name `action` VARCHAR(64) NOT NULL, `old_value` TEXT DEFAULT NULL, `new_value` TEXT DEFAULT NULL, `result` VARCHAR(16) DEFAULT NULL, -- ok | error `ip` VARCHAR(45) DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `idx_created` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;