gskMhS31

1CREATE TABLE IF NOT EXISTS `QuestsCompleted` (
2  QuestsCompletedID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  MarkersID int NOT NULL,
4  UsersID int NOT NULL,
5  date DATETIME(1) NOT NULL,
6  FOREIGN KEY (MarkersID) REFERENCES markers(`MarkersID`)
7    ON UPDATE CASCADE ON DELETE RESTRICT,
8  FOREIGN KEY (UsersID) REFERENCES users(`UsersID`)
9    ON UPDATE CASCADE ON DELETE RESTRICT
10)   DEFAULT CHARSET=utf8mb4;