wngpnksy

1CREATE TABLE IF NOT EXISTS `dle_category` (
2  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
3  `parentid` mediumint(8) NOT NULL DEFAULT '0',
4  `posi` mediumint(8) NOT NULL DEFAULT '1',
5  `name` varchar(50) NOT NULL DEFAULT '',
6  `alt_name` varchar(50) NOT NULL DEFAULT '',
7  `icon` varchar(200) NOT NULL DEFAULT '',
8  `skin` varchar(50) NOT NULL DEFAULT '',
9  `descr` varchar(200) NOT NULL DEFAULT '',
10  `keywords` text NOT NULL,
11  `news_sort` varchar(10) NOT NULL DEFAULT '',
12  `news_msort` varchar(4) NOT NULL DEFAULT '',
13  `news_number` smallint(5) NOT NULL DEFAULT '0',
14  `short_tpl` varchar(40) NOT NULL DEFAULT '',
15  `full_tpl` varchar(40) NOT NULL DEFAULT '',
16  `metatitle` varchar(255) NOT NULL DEFAULT '',
17  `show_sub` tinyint(1) NOT NULL DEFAULT '0',
18  `allow_rss` tinyint(1) NOT NULL DEFAULT '1',
19  PRIMARY KEY (`id`)
20) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
21
22--
23-- Дамп данных таблицы `dle_category`
24--
25
26INSERT INTO `dle_category` (`id`, `parentid`, `posi`, `name`, `alt_name`, `icon`, `skin`, `descr`, `keywords`, `news_sort`, `news_msort`, `news_number`, `short_tpl`, `full_tpl`, `metatitle`, `show_sub`, `allow_rss`) VALUES
27(1, 0, 1, 'Информация', 'main', '', '', '', '', '', '', 0, '', '', '', 0, 1);