CREATE TABLE IF NOT EXISTS `dle_category` ( `id` smallint(5) NOT NULL AUTO_INCREMENT, `parentid` smallint(5) NOT NULL DEFAULT '0', `posi` smallint(5) NOT NULL DEFAULT '1', `name` varchar(50) NOT NULL DEFAULT '', `alt_name` varchar(50) NOT NULL DEFAULT '', `icon` varchar(200) NOT NULL DEFAULT '', `skin` varchar(50) NOT NULL DEFAULT '', `descr` varchar(200) NOT NULL DEFAULT '', `keywords` text NOT NULL, `news_sort` varchar(10) NOT NULL DEFAULT '', `news_msort` varchar(4) NOT NULL DEFAULT '', `news_number` smallint(5) NOT NULL DEFAULT '0', `short_tpl` varchar(40) NOT NULL DEFAULT '', `full_tpl` varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;