Dedecms(织梦内容管理系统)是一款广泛应用于网站内容管理的开源软件,其数据库结构是系统运行的基础,对于理解和优化DedeCMS的功能至关重要,以下是对核心数据库表格的详细解析:
一、dede_addonarticle(附加文章表)
字段名 | 说明描述 | 具体参数 |
aid | 文章编号 | mediumint(8) unsigned NOT NULL default ‘0’ |
typeid | 栏目ID | smallint(5) unsigned NOT NULL default ‘0’ |
body | 文章内容 | mediumtext |
二、dede_addonflash(附加Flash表)
字段名 | 说明描述 | 具体参数 |
aid | FLASH编号 | int(11) NOT NULL default ‘0’ |
typeid | 分类栏目编号 | int(11) NOT NULL default ‘0’ |
filesize | 文件大小 | varchar(10) NOT NULL default ” |
三、dede_admintype(管理员类别表)
字段名 | 说明描述 | 具体参数 |
typename | 管理组名称 | varchar(30) NOT NULL DEFAULT ” |
system | 是否为系统管理员 | smallint(6) NOT NULL DEFAULT ‘0’ |
rank | 权限值 | float NOT NULL DEFAULT ‘1’ |
purviews | 权限 | text |
四、dede_addonimages(附加图片表)
字段名 | 说明描述 | 具体参数 |
aid | 图片编号 | mediumint(8) unsigned NOT NULL default ‘0’ |
typeid | 栏目ID | smallint(5) unsigned NOT NULL default ‘0’ |
imagesMain | 主图片路径 | varchar(255) NOT NULL default ” |
width, height | 图片宽度和高度 | smallint(6) NOT NULL default ‘0’ |
五、dede_addoninfos(分类信息单表)
字段名 | 说明描述 | 具体参数 |
body | mediumtext | |
typeid | 类型ID | int(11) NOT NULL default ‘0’ |
infotype | 信息类型 | smallint(5) unsigned NOT NULL default ‘0’ |
channel | 频道信息 | set(‘c’,’h’,’p’,’f’,’s’,’j’,’a’,’b’) DEFAULT NULL |
click, title, litpic, senddate, flag, endtime | 点击数、标题、略缩图、发布时间、标记、结束时间 | various types, mostly varchar and datetime |
六、dede_addonsoft(软件附加表)
字段名 | 说明描述 | 具体参数 |
typeid | 栏目ID | smallint(5) unsigned NOT NULL DEFAULT ‘0’ |
officialDemo | 演示网址 | varchar(50) NOT NULL DEFAULT ” |
language | 语言 | varchar(10) NOT NULL DEFAULT ” |
softtype, templet, filetype, softlinks, daccess, officialUrl, needmoney, downurl, char, downid, mid, addtime, channel, ispart, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath, softMain, channel, nativeplace, infotype, filename, description, price, unit, downpath | various data types as per field requirements |
其他重要表格
dede_archives:文章主表,存储文章基本信息。
dede_addonshop:商品附加表,用于电商功能。
dede_member:会员表,管理用户信息。
FAQs
Q1: DedeCMS的数据库连接文件在哪里?
A1: Dedecms的数据库连接文件通常位于include/config_base.php
或data/common.inc.php
,根据不同的版本可能有所不同。
Q2: 如何在PHPMyAdmin中查找和管理DedeCMS的数据表?
A2: 在PHPMyAdmin中,连接到你的数据库服务器后,可以在左侧导航栏中找到对应的数据库,展开后即可查看和管理所有的数据表,找到名为“dede_addonarticle”的表,可以查看其结构和数据。
原创文章,作者:未希,如若转载,请注明出处:https://www.kdun.com/ask/1108729.html
本网站发布或转载的文章及图片均来自网络,其原创性以及文中表达的观点和判断不代表本网站。如有问题,请联系客服处理。
发表回复