ALTER TABLE `book` CHANGE `publish_year` `copyright_date` INT( 11 ) NOT NULL DEFAULT '0' ;; ALTER TABLE `book` CHANGE `backinfo` `summary` TEXT NOT NULL ;; ALTER TABLE `book` CHANGE `type` `form` TINYINT( 4 ) NOT NULL DEFAULT '0' ;; ALTER TABLE `book` ADD `alt_titles` TEXT NOT NULL AFTER `title` ;; ALTER TABLE `book` ADD `summary_source` TINYINT( 2 ) NOT NULL AFTER `summary` ;; ALTER TABLE `book` ADD `copyright_approx` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `copyright_date`;; ALTER TABLE `book` ADD `copyright_note` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `copyright_approx`;; ALTER TABLE `book` ADD `notes` TEXT NOT NULL AFTER `summary` ;; ALTER TABLE `book` DROP `translator` ;; ALTER TABLE `book` DROP `original_language` ;; ALTER TABLE `book` DROP `last_update` ;; ALTER TABLE `book` DROP `series` ;; ALTER TABLE `book` DROP `part` ;; RENAME TABLE `book` TO `frbr_work`