| 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 : |
-- Arbeitszeiterfassung (vom Terminal-Modul „Arbeitszeiterfassung" befüllt, Kunden-Zuordnung). CREATE TABLE IF NOT EXISTS `crm_time_entries` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `customer_id` INT UNSIGNED NOT NULL, `terminal_hash` CHAR(32) NULL, -- erfassendes Terminal `terminal_label` VARCHAR(190) NULL, `work_date` DATE NOT NULL, `full_day` TINYINT(1) NOT NULL DEFAULT 0, `start_time` TIME NULL, `end_time` TIME NULL, `minutes` INT UNSIGNED NOT NULL DEFAULT 0, `note` VARCHAR(255) NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `idx_te_customer` (`customer_id`), KEY `idx_te_terminal` (`terminal_hash`), KEY `idx_te_date` (`work_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;