1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
--
-- Table structure for table `item`
--
CREATE TABLE IF NOT EXISTS `item` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_category` int(11) NOT NULL,
`title` text NOT NULL,
`summary` text NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
-- --------------------------------------------------------
--
-- Table structure for table `page`
--
CREATE TABLE IF NOT EXISTS `page` (
`id_item` int(11) NOT NULL,
`page_number` int(11) NOT NULL,
`title` text NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id_item`,`page_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager