-- -- Структура таблицы `articles` -- CREATE TABLE `articles` ( `id_article` int(10) unsigned NOT NULL auto_increment, `name` tinytext NOT NULL, `description` text NOT NULL, `date` date NOT NULL, `pos` mediumint(9) NOT NULL default '0', `hide` enum('show','hide') NOT NULL default 'show', `id_page` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_article`), KEY `id_page` (`id_page`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=66 ; -- -- Структура таблицы `paragraphes` -- CREATE TABLE `paragraphes` ( `id_paragraph` int(10) unsigned NOT NULL auto_increment, `type` enum('paragraph','title','anchor','table') NOT NULL default 'paragraph', `name` text NOT NULL, `url` tinytext NOT NULL, `picture_big` tinytext NOT NULL, `picture_small` tinytext NOT NULL, `place` tinyint(4) NOT NULL default '0', `pos` int(11) NOT NULL default '0', `hide` enum('show','hide') NOT NULL default 'show', `id_article` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id_paragraph`), KEY `id_article` (`id_article`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=72 ;