-- Optional audit table for entity user / administrator changes.
CREATE TABLE IF NOT EXISTS `admin_audit_log` (
  `auditID` int NOT NULL AUTO_INCREMENT,
  `actorUserID` int NOT NULL,
  `action` varchar(64) NOT NULL,
  `adminID` int DEFAULT NULL,
  `entityID` int DEFAULT NULL,
  `payload` text,
  `createdAt` datetime NOT NULL,
  PRIMARY KEY (`auditID`),
  KEY `idx_actor` (`actorUserID`),
  KEY `idx_admin` (`adminID`),
  KEY `idx_entity` (`entityID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;