DROP TABLE IF EXISTS tng_albums;
CREATE TABLE `tng_albums` (
  `albumID` int NOT NULL AUTO_INCREMENT,
  `albumname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `alwayson` tinyint DEFAULT NULL,
  `keywords` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint NOT NULL,
  PRIMARY KEY (`albumID`),
  KEY `albumname` (`albumname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;