CREATE TABLE IF NOT EXISTS dle_category id smallint NOT NULL AUTO_INCR

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
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 ;