Code: Select all

DROP TABLE IF EXISTS `item_details_book_pages`;

CREATE TABLE `item_details_book_pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(10) unsigned NOT NULL DEFAULT '0',
  `page` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `page_text` text COLLATE latin1_general_ci NOT NULL,
  `page_text_valign` tinyint(3) NOT NULL DEFAULT '0',
  `page_text_halign` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ItemBookIDX` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;