DROP TABLE IF EXISTS tng_albumlinks;
CREATE TABLE `tng_albumlinks` (
  `albumlinkID` int(11) NOT NULL AUTO_INCREMENT,
  `albumID` int(11) NOT NULL,
  `mediaID` int(11) NOT NULL,
  `ordernum` int(11) DEFAULT NULL,
  `defphoto` varchar(1) NOT NULL,
  PRIMARY KEY (`albumlinkID`),
  KEY `albumID` (`albumID`,`ordernum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
