dedecms如何初始化栏目和文章

dedecms的系统做多了，自己也有了一点小心得，今天分享一下如何如何初始化织梦的栏目和文章：

当我们要做一个新的网站时，往往要删除以前建立的栏目和文章，如果数据足够多的话就是一个相当大的工作量了。这时，我们只要连上数据库，执行下面的一段sql语句，就可以轻松搞定手工需要几个小时才能删除的数据。

以下是整理的sql语句：

delete from dede_addonarticle;

delete from dede_addonimages;

delete from dede_archives;

delete from dede_arctiny;

delete from dede_co_htmls;

delete from dede_co_urls;

delete from dede_co_mediaurls;

delete from dede_tagindex ;

delete from dede_taglist;

delete from dede_keywords;

delete from dede_arctype;

TRUNCATE TABLE dede_archives;

ALTER TABLE dede_archives AUTO_INCREMENT =1;

ALTER TABLE dede_arctiny AUTO_INCREMENT =1;

ALTER TABLE dede_addonarticle  AUTO_INCREMENT =1;

ALTER TABLE dede_arctype  AUTO_INCREMENT =1;