DROP TABLE IF EXISTS tng_albumlinks;
CREATE TABLE `tng_albumlinks` (
  `albumlinkID` int NOT NULL AUTO_INCREMENT,
  `albumID` int NOT NULL,
  `mediaID` int NOT NULL,
  `ordernum` int DEFAULT NULL,
  `defphoto` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`albumlinkID`),
  KEY `albumID` (`albumID`,`ordernum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;