otakuhub/setup/animelist.sql

DROP TABLE IF EXISTS `anime_list`;

CREATE TABLE `anime_list` (
  `uid` int(11) unsigned NOT NULL,
  `aid` int(11) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL,
  `episodes` int(11) NOT NULL,
  KEY `aiduid` (`aid`, `uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;