destoon分类数据资源-CSDN文库

共1个文件

sql：1个

5星 · 超过95%的资源需积分: 50 190 浏览量 2012-10-06 10:31:26 上传评论 7 收藏 536KB RAR 举报

Destoon是一款广受欢迎的开源企业建站系统，尤其在B2B（Business to Business）领域应用广泛。这个“destoon分类数据”压缩包文件显然包含了适用于Destoon 4.0版本的完整分类信息数据库，共计6121个条目。这样的数据集极大地简化了用户在搭建或管理Destoon网站时的分类设定工作，无需手动创建每一个分类，从而节省了大量的时间和精力。 Destoon的分类系统是其核心功能之一，它允许用户按照不同行业、产品类型或者服务类别来组织网站内容。分类数据通常包括分类ID、父分类ID、分类名称、描述、排序等字段，这些信息构成了网站信息架构的基础。导入"destoon_category.sql"文件，用户可以直接将这些预设的分类信息导入到自己的Destoon数据库中，快速构建一个结构清晰、层次分明的企业目录。在导入此分类数据之前，用户需要确保他们已经正确安装并配置了Destoon 4.0系统，并且具备一定的数据库操作知识，比如如何使用MySQL命令行或数据库管理工具（如phpMyAdmin）来执行SQL脚本。导入过程可能涉及以下步骤： 1. **备份现有数据**：在进行任何数据操作前，首先备份现有的数据库，以防意外情况发生。 2. **下载并解压文件**：将"destoon_category.sql"文件下载至本地，然后使用解压工具打开并读取其内容。 3. **连接数据库**：使用MySQL客户端工具连接到你的Destoon数据库。 4. **执行SQL脚本**：在客户端中运行SQL命令，通常是`source`命令加上SQL文件的路径，例如：`source /path/to/destoon_category.sql`，这会将文件中的所有SQL语句依次执行。 5. **检查导入结果**：导入完成后，通过后台管理系统检查新的分类是否成功添加，并确认分类层次和顺序是否符合预期。导入这些分类数据后，用户可以进一步自定义每个分类的属性，比如设置SEO关键词、调整排序、分配权限等。同时，Destoon系统还支持多级分类，这意味着6121个分类可以形成复杂的树状结构，适应各种规模和复杂性的企业信息分类需求。此外，了解如何有效利用和管理这些分类数据对提升用户体验至关重要。合理的分类可以帮助用户更快地找到所需信息，促进业务交流与合作。同时，分类数据也是搜索引擎优化（SEO）的重要元素，优化后的分类能提高网站在搜索结果中的排名，从而吸引更多的流量。 “destoon分类数据”压缩包提供了一套全面的行业分类模板，对于正在使用或计划使用Destoon 4.0构建B2B平台的用户来说，这是一个非常实用的资源，能够大大加快网站搭建进程，提升工作效率。正确导入和使用这些数据，有助于构建一个专业、高效且易于导航的企业网站。

资源推荐

资源详情

资源评论

收起资源包目录

destoon_category.rar （1个子文件）

destoon_category.sql 5.79MB

DROP TABLE IF EXISTS `destoon_category`; CREATE TABLE `destoon_category` ( `catid` int(10) unsigned NOT NULL AUTO_INCREMENT, `moduleid` smallint(6) unsigned NOT NULL DEFAULT '0', `catname` varchar(50) NOT NULL DEFAULT '', `style` varchar(50) NOT NULL DEFAULT '', `catdir` varchar(255) NOT NULL DEFAULT '', `linkurl` varchar(255) NOT NULL DEFAULT '', `letter` varchar(4) NOT NULL DEFAULT '', `level` tinyint(1) unsigned NOT NULL DEFAULT '1', `item` bigint(20) unsigned NOT NULL DEFAULT '0', `property` smallint(6) unsigned NOT NULL, `parentid` int(10) unsigned NOT NULL DEFAULT '0', `arrparentid` varchar(255) NOT NULL DEFAULT '', `child` tinyint(1) NOT NULL DEFAULT '0', `arrchildid` text NOT NULL, `listorder` smallint(4) unsigned NOT NULL DEFAULT '0', `template` varchar(30) NOT NULL DEFAULT '', `show_template` varchar(30) NOT NULL DEFAULT '', `seo_title` varchar(255) NOT NULL DEFAULT '', `seo_keywords` varchar(255) NOT NULL DEFAULT '', `seo_description` varchar(255) NOT NULL DEFAULT '', `group_list` varchar(255) NOT NULL DEFAULT '', `group_show` varchar(255) NOT NULL DEFAULT '', `group_add` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`catid`) ) ENGINE=MyISAM AUTO_INCREMENT=50551 DEFAULT CHARSET=utf8 COMMENT='栏目'; INSERT INTO `destoon_category` VALUES('2346','5','油过滤器滤芯','','youguolvqilvxin','list.php?catid=2346','y','1','1','0','309','0,1331,309','0','2346','2346','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('1262','5','PES工程料','','PESgongchengliao','list.php?catid=1262','p','1','0','0','1451','0,1329,1451','0','1262','1262','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('1263','5','PMMA工程料','','PMMAgongchengliao','list.php?catid=1263','p','1','10','0','1451','0,1329,1451','0','1263','1263','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2345','5','油气分离滤芯','','youqifenlilvxin','list.php?catid=2345','y','1','3','0','309','0,1331,309','0','2345','2345','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2236','5','聚氨酯发泡塑料','','juanfapaosuliao','list.php?catid=2236','j','1','0','0','1277','0,1329,1277','0','2236','2236','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2237','5','EPS泡沫塑料','','EPSpaomosuliao','list.php?catid=2237','e','1','0','0','1277','0,1329,1277','0','2237','2237','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2212','5','防腐酚醛树脂','','fangfufenquanshuzhi','list.php?catid=2212','f','1','0','0','1794','0,1329,1794','0','2212','2212','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2213','5','增强PP塑料','','zengqiangPPsuliao','list.php?catid=2213','z','1','0','0','1276','0,1329,1276','0','2213','2213','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2199','5','低压聚乙烯废塑料','','diyajuyixifeisuliao','list.php?catid=2199','d','1','0','0','1273','0,1329,1273','0','2199','2199','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2185','5','PET废塑料','','PETfeisuliao','list.php?catid=2185','p','1','0','0','1273','0,1329,1273','0','2185','2185','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2187','5','ABS废塑料','','ABSfeisuliao','list.php?catid=2187','a','1','0','0','1273','0,1329,1273','0','2187','2187','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2150','5','破碎设备','','posuishebei','list.php?catid=2150','p','1','0','0','1868','0,1330,1868','0','2150','2150','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2151','5','垃圾桶','','lajitong','list.php?catid=2151','l','1','0','0','1868','0,1330,1868','0','2151','2151','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2152','5','垃圾车','','lajiche','list.php?catid=2152','l','1','0','0','1868','0,1330,1868','0','2152','2152','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2153','5','鼓风机','','gufengji','list.php?catid=2153','g','1','6','0','1869','0,1330,1869','0','2153','2153','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2092','5','玻璃分割机','','bolifengeji','list.php?catid=2092','b','1','1','0','1865','0,1330,1865','0','2092','2092','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2093','5','织造机械','','zhizaojixie','list.php?catid=2093','z','1','0','0','1866','0,1330,1866','0','2093','2093','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2069','5','烫台','','tangtai','list.php?catid=2069','t','1','0','0','1863','0,1330,1863','0','2069','2069','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2070','5','电烫斗','','diantangdou','list.php?catid=2070','d','1','0','0','1863','0,1330,1863','0','2070','2070','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2044','5','切胶机','','qiejiaoji','list.php?catid=2044','q','1','0','0','1862','0,1330,1862','0','2044','2044','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2045','5','混炼机','','hunlianji','list.php?catid=2045','h','1','0','0','1862','0,1330,1862','0','2045','2045','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('309','5','液压过滤系统','#003366','yeyaguolvxitong','list.php?catid=309','y','2','18','0','1331','0,1331','1','309,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368','309','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2344','5','空气干燥机','','kongqiganzaoji','list.php?catid=2344','k','1','1','0','2263','0,1331,2263','0','2344','2344','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2011','5','验布机','','yanbuji','list.php?catid=2011','y','1','0','0','1860','0,1330,1860','0','2011','2011','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('2012','5','切带机','','qiedaiji','list.php?catid=2012','q','1','19','0','1860','0,1330,1860','0','2012','2012','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('1986','5','化工机械设备','','huagongjixieshebei','list.php?catid=1986','h','1','90','0','1858','0,1330,1858','0','1986','1986','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('1987','5','化工成套设备','','huagongchengtaoshebei','list.php?catid=1987','h','1','6','0','1858','0,1330,1858','0','1987','1987','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('34','8','国内塑料展会','#FF0000','guoneisuliaozhanhui','list/34/','g','1','5','0','0','0','0','34','34','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('35','8','国际塑料展会','#FF0000','guojisuliaozhanhui','list/35/','g','1','2','0','0','0','0','35','35','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('36','8','国内塑料机械展会','#FF0000','guoneisuliaojixiezhanhui','list/36/','g','1','4','0','0','0','0','36','36','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('37','8','国际塑料机械展会','#FF0000','guojisuliaojixiezhanhui','list/37/','g','1','3','0','0','0','0','37','37','','','','','','1,3,5,6,7','1,3,5,6,7','1,5,6,7'); INSERT INTO `destoon_category` VALUES('38','8','国

评论收藏

内容反馈