| 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 : |
-- 034: REST-API Tokens.
--
-- Externe Systeme (z.B. Anbindung der Reederei, Website, Mobile Counter App)
-- authentifizieren sich per Bearer-Token im Authorization-Header. Tokens werden
-- nur als SHA-256-Hash gespeichert; der Klartext ist nur einmalig beim Anlegen sichtbar.
CREATE TABLE IF NOT EXISTS `api_tokens` (
`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(191) NOT NULL,
`token_hash` CHAR(64) NOT NULL,
`scopes` VARCHAR(255) NOT NULL DEFAULT 'read',
`created_by` VARCHAR(191) DEFAULT NULL,
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_used_at` DATETIME DEFAULT NULL,
`revoked_at` DATETIME DEFAULT NULL,
UNIQUE KEY `ux_api_tokens_hash` (`token_hash`),
KEY `idx_api_tokens_active` (`revoked_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;