CREATE TABLE IF NOT EXISTS `Publisher` (
  `ID` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `Name` VARCHAR(65) NOT NULL
);

CREATE TABLE IF NOT EXISTS `Book` (
  `ISBN` VARCHAR(65) NOT NULL PRIMARY KEY,
  `Title` VARCHAR(65) NOT NULL,
  `Author` VARCHAR(65) NOT NULL,
  `Language` VARCHAR(65) NOT NULL,
  `Pages` INTEGER NOT NULL,
  `PublisherID` VARCHAR(65) NOT NULL REFERENCES `Publisher`(`ID`)
);