INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('amazonassociatetag', 'newznab-20', now());

INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('lookupbooks', '1', now());

alter table releases add `bookinfoID` INT NULL AFTER `consoleinfoID`;

alter table users add `bookview` int not null default 1 AFTER `consoleview`;

DROP TABLE IF EXISTS `bookinfo`;
CREATE TABLE `bookinfo`
(
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `asin` varchar(128) NULL,
  `url` varchar(1000) NULL,
  `author` varchar(255) NULL,
  `publisher` varchar(255) NULL,
  `publishdate` datetime NULL,
  `review` varchar(2000) NULL,
  `genreID` int(10) NULL,
  `dewey` varchar(10) NULL,
  `ean` varchar(20) NULL,
  `isbn` varchar(20) NULL,
  `pages` int(10) NULL,
  `cover` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `createddate` datetime NOT NULL,
  `updateddate` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1 ;

INSERT INTO menu (`href`, `title`, `tooltip`, `role`, `ordinal` )
VALUES ('books', 'Books', 'Browse for Books', 1, 66);