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;