Which database table records the dedecms administrator username and password?

dedecms administrator username and password are recorded in the common.inc.php file under the data directory, which records the database account and database name. ,password.

Recommended: Where to change dedecms background password

Main data structure table:

dede_addonarticle: Additional article Table
aid int(11) Article number
typeid int(11) Category column number
body mediumtext Article content
dede_addonflash Additional Flash table
aid int(11) FLASH number
typeid int(11) Category column number
filesize varchar(10) File size
playtime varchar(10) Play time
flashtype varchar(10) Work type
flashrank smallint(6) Work level
width smallint(6) Video width
height smallint(6) Video height
flashurl varchar(80) FLASH address

dede_addonimages： Additional atlas table
aid int(11) Album number
typeid int(11) Category column number
pagestyle smallint(6) Expression method (1 single page display 2 multi-page display 3 multi-row and multi-column display)
maxwidth smallint(6) large Picture limit width
imgurls text Picture collection content (label storage)
row smallint(6) Multi-column parameter (row)
col smallint(6) Multi-column parameter (column)
isrm smallint (6) Whether to download remote pictures
ddmaxwidth smallint(6) Small picture width limit

dede_addonsoft Additional software table
aid int(11) Software number
typeid int(11) Classification column number
filetype varchar(10) File type
language varchar(10) Interface language
softtype varchar(10) Software type
accredit varchar(10) Authorization method
os varchar(30 ) Operating environment
softrank int(11) Software level
officialUrl varchar(30) Official website
officialDemo varchar(50) Program demonstration address
softsize varchar(10) Software size
softlinks text software Download link list
introduce text Software introduction

dede_addonspec: Additional topic table
aid int(11) Topic number
typeid int(11) Classification column number
note text Topic content (only stores tag codes)

dede_admin: Administrator information table
ID int(10) Automatic number
usertype int(10) User type
userid varchar(30) ) User login ID
pwd varchar(50) User password
uname varchar(20) User pen name
tname varchar(30) Real name
email varchar(30) Email
typeid int( 11) Responsible for the channel (0 means all)
logintime datetime Login time
loginip varchar(20) Login IP

dede_admintype: System user group management table
rank smallint(6) Group level number
typename varchar(30) Group name
system smallint(6) Whether it is the system default group
purviews text Permission list

dede_arcatt: Document custom attribute table
att smallint(6) number
attname varchar(30) attribute name
dede_archives article table
ID int(11) automatic number
typeid int(11) main column number
typeid2 int(11) Sub-column number
sortrank int(11) Article sorting (top method)
iscommend smallint(6) Whether to recommend
ismake smallint(6) Whether to generate static
channel int(11 ) Article model
arcrank smallint(6) Reading permission
click int(11) Number of clicks
money smallint(6) Consumption points
title varchar(80) Title
shorttitle varchar(36) ) Abbreviated title
color varchar(10) Title color
writer varchar(30) Author
source varchar(50) Source
litpic varchar(100) Thumbnail
pubdate int(11) Input Time
senddate int(11) Release time
arcatt smallint(6) Custom attribute (att)
adminID int(11) Release administrator ID
memberID int(11) Release member ID
description varchar(250) Summary
keywords varchar(60) Keywords
templet varchar(60) Document template
lastpost int(11) Last comment time
postnum int(11) Number of comments
redirecturl varchar(150) Jump URL
mtype int(11) User-defined classification
userip varchar(20) User IP
locklikeid smallint(6) Whether to lock related articles
likeid varchar(240 ) Related article ID

dede_arcrank: Reading permission table
ID int(10) Automatic number
rank smallint(10) Permission level
membername varchar(20) Level name
adminrank smallint(10) Management level
money int(11) Consumption points

dede_arctype: Column management table
ID int(10) Column number (automatic number)
reID int(10) Parent column number
topID int(10)
sortrank smallint( 6) Sorting number
typename varchar(30) Column name
typedir varchar(100) Column directory
isdefault smallint(6) Column list option (1 links to the default page 0 links to the first page of the list -1 Use dynamic pages)
defaultname varchar(20) The name of the default page
issend smallint(6) Whether to support submission
channeltype smallint(6) Channel type
maxpage int(11) Reserved
ispart smallint(6) Column attribute
corank smallint(6) Browsing permission
tempindex varchar(60) Cover template
templist varchar(60) List template
temparticle varchar(60) Article template
tempone varchar(60) Single page template
namerule varchar(50) Article naming rule
namerule2 varchar(50) List naming rule
modname varchar(30) Template name
description varchar(200) Column introduction
keywords varchar(100) Keywords
moresite smallint(6) Multi-site support
siterefer smallint(6) Multi-site site root directory attribute
sitepath varchar(60) Multi-site site root directory
siteurl varchar(60) Multi-site binding domain name
ishidden smallint(6) Whether to hide the column

dede_area: Area table
eid int(11) Area number
name varchar( 20) Region name
rid int(11) Number attribute

For more DedeCMS related technical articles, please visit the DedeCMS Tutorial column to learn!

The above is the detailed content of Which database table records the dedecms administrator username and password?. For more information, please follow other related articles on the PHP Chinese website!