CREATE TABLE
category (
id int(11) NOT NULL auto_increment,
catpath varchar(255) default NULL,
name varchar(255) default NULL,PRIMARY KEY (
id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table category
INSERT INTO category VALUES (1,'0','网站首页');
INSERT INTO category VALUES (2,'0-1','Linux OS');
INSERT INTO category VALUES (3,'Apache服务器');
INSERT INTO category VALUES (4,'MySQL数据库');
INSERT INTO category VALUES (5,'PHP脚本语言');
INSERT INTO category VALUES (6,'0-1-2','Linux 系统教程');
INSERT INTO category VALUES (7,'Linux 网络技术');
INSERT INTO category VALUES (8,'Linux 安全基础');
INSERT INTO category VALUES (9,'0-1-2-7','Linux LAMP');
INSERT INTO category VALUES (10,'0-1-3-10','apache Server');
