   PRIMARY KEY (`ID`),
   KEY `userid_idx` (`UserID`),
   CONSTRAINT `userid` FOREIGN KEY (`UserID`) REFERENCES `users` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
 CREATE TABLE IF NOT EXISTS `playlists` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,

  KEY `PlaylistID` (`PlaylistID`),
  CONSTRAINT `FKplaylistID` FOREIGN KEY (`PlaylistID`) REFERENCES `playlists` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FKvideoID` FOREIGN KEY (`VideoID`) REFERENCES `videos` (`videoID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `history` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,

  KEY `Video_idx` (`VideoID`),
  CONSTRAINT `DJ` FOREIGN KEY (`DJ`) REFERENCES `users` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Video` FOREIGN KEY (`VideoID`) REFERENCES `videos` (`videoID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
