releases

releases.mysql.sql

CREATE TABLE `releases` (
`id` int(11) NOT NULL,
  `source` varchar(45) DEFAULT NULL,
  `packagename` varchar(255) DEFAULT NULL,
  `package_id` varchar(45) DEFAULT NULL,
  `isbn` char(13) DEFAULT NULL,
  `book_title` varchar(255) DEFAULT NULL,
  `year` char(4) DEFAULT NULL,
  `issn` varchar(45) DEFAULT NULL,
  `series_title` varchar(127) DEFAULT NULL,
  `volume` int(11) DEFAULT NULL,
  `imprint` varchar(127) DEFAULT NULL,
  `available_online` date DEFAULT NULL,
  `shortcut_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;