Detailed description of discuz table structure

Cdb_access user permission table
Cdb_adminactions management action table
Cdb_admingroups Management Group data table
Cdb_adminnotes administrator message
Cdb_adminsessions administrator online record
Cdb_advertisements advertisement table
Cdb_announcements Forum announcement table
Cdb_attachments attachment table
Cdb_attachtypes attachment type table
List of IP addresses prohibited by cdb_banned
Cdb_bbcodes BB code table
Cdb_blogcaches blog cache table
Cdb_buddys friend information table
Cdb_creditslog point transaction record table
Cdb_crons scheduler task table
Cdb_failedlogins error logon records
Cdb_favorites personal favorites information table
Cdb_forumfields data table
Cdb_forumlinks link data table
Cdb_forums Forum data table
Cdb_medals medal data table
Cdb_memberfields user extension table
Cdb_members user basic data table
Cdb_moderators moderator information data table
Cdb_modworks moderator WorkRecord table
Cdb_onlinelist online list Customization
Cdb_onlinetime user online time information table
Cdb_orders order data table
Cdb_paymentlog payment record
Cdb_pluginhooks plug-in hook table
Cdb_plugins plug-in table
Cdb_pluginvars plug-in configuration table
Cdb_pms text message table
Cdb_pmsearchindex Short Message search cache table
Cdb_polls voting post table
Cdb_posts post table
Cdb_profilefields user topic Customization
Cdb_promotions Forum promotion
Cdb_ranks title table
Cdb_ratelog post Score Table
Cdb_regips registration IP record table
Cdb_relatedthreads topics
Cdb_rsscaches RSS Cache
Cdb_searchindex search cache
Cdb_sessions online table
Cdb_settings forum settings table
Cdb_smilies
Cdb_stats statistical data table
Cdb_statvars statistical variable table
Cdb_styles Style
Cdb_stylevars style variable table
Cdb_subscr quota ptions subscription information table
Cdb_templates Template
Cdb_threads topic table
Cdb_threadsmod topic management record table
Cdb_threadtypes topic category table
Cdb_usergroups user group data table
Cdb_validating member records Awaiting manual review
Cdb_words word filtering table

========================== Partial table resolution ======

-- Table structure 'cdb _ access'
--

Drop table if exists cdb_access;
Create Table cdb_access (
UID mediumint (8) unsigned not null default '0 ',
FID smallint (6) unsigned not null default '0 ',
Allowview tinyint (1) not null default '0 ',
Allowpost tinyint (1) not null default '0 ',
Allowreply tinyint (1) not null default '0 ',
Allowgetattach tinyint (1) not null default '0 ',
Allowpostattach tinyint (1) not null default '0 ',
Primary Key (UID, FID)
) Type = MyISAM;

--
--

Data Table Description: when a user has specific permissions on certain sections, the table records the permissions of the user on these sections.
Attribute description:
UID -- mediumint (8) -- uid of the member

FID -- smallint (6) -- ID of the Forum

Allowview -- tinyint (1) -- whether to allow viewing posts

Allowpost -- tinyint (1) -- whether to allow posting

Allowreply -- tinyint (1) -- whether to allow reply

Allowgetattach -- tinyint (1) -- whether to allow attachment download

Allowpostattach tinyint (1) -- whether attachments can be uploaded

--
-- Table structure 'cdb _ adminactions'
--

Drop table if exists cdb_adminactions;
Create Table cdb_adminactions (
Admingid smallint (6) unsigned not null default '0 ',
Disabledactions text not null,
Primary Key (admingid)
) Type = MyISAM;

--

Data Table Function Introduction: Management table of the Management Group.
Admingid smallint (6) -- ID of the Management Group
Disabledactions text -- disable Behavior

Certificate -------------------------------------------------------------------------------------------------------------------------------------

-- Table structure 'cdb _ admingroup'
--

Drop table if exists cdb_admingroups;
Create Table cdb_admingroups (
Admingid smallint (6) unsigned not null default '0 ',
Alloweditpost tinyint (1) not null default '0 ',
Alloweditpoll tinyint (1) not null default '0 ',
Allowstickthread tinyint (1) not null default '0 ',
Allowmodpost tinyint (1) not null default '0 ',
Allowdelpost tinyint (1) not null default '0 ',
Allowmassprune tinyint (1) not null default '0 ',
Allowrefund tinyint (1) not null default '0 ',
Allowcensorword tinyint (1) not null default '0 ',
Allowviewip tinyint (1) not null default '0 ',
Allowbanip tinyint (1) not null default '0 ',
Allowedituser tinyint (1) not null default '0 ',
Allowmoduser tinyint (1) not null default '0 ',
Allowbanuser tinyint (1) not null default '0 ',
Allowpostannounce tinyint (1) not null default '0 ',
Allowviewlog tinyint (1) not null default '0 ',
Disablepostctrl tinyint (1) not null default '0 ',
Primary Key (admingid)
) Type = MyISAM;

--

Function Introduction: Manage the module information table.
Admingid -- smallint (3) -- ID of the Management Group
Alloweditpost tinyint (1) -- edit post permission
Alloweditpoll tinyint (1) -- edit the voting permission
Allowstickthread tinyint (1) -- set the post permission
Allowmodpost tinyint (1) -- manage (edit) Post Permissions
Allowdelpost tinyint (1) -- permission to delete a post
Allowmassprune tinyint (1) -- Read Permission
Allowrefund tinyint (1 )--
Allowcensorword tinyint (1) -- filter words to set permissions
Allowviewip tinyint (1) -- View IP permission
Allowbanip tinyint (1) -- Disable IP permission
Allowedituser tinyint (1) -- edit User Permissions
Allowmoduser tinyint (1) -- manage User Permissions
Allowbanuser tinyint (1) -- Disable User Permissions
Allowpostannounce tinyint (1) -- publish announcement permission
Allowviewlog tinyint (1) -- browser managementLogsPermission
Disablepostctrl tinyint (1) -- Batch Management Permissions
Bytes ------------------------------------------------------------------------------------------

-- Table structure 'cdb _ adminnote'
--

Drop table if exists cdb_adminnotes;
Create Table cdb_adminnotes (
Id mediumint (8) unsigned not null auto_increment,
Admin varchar (15) not null default '',
Access tinyint (3) not null default '0 ',
Adminid tinyint (3) not null default '0 ',
Dateline int (10) unsigned not null default '0 ',
Expiration int (10) unsigned not null default '0 ',
Message Text not null,
Primary Key (ID)
) Type = MyISAM;

--

Data Table Function Introduction: Background message.
Id mediumint (8) -- event ID
Admin varchar (15) -- operator
Access tinyint (3 )--
Adminid tinyint (3) -- Management Group ID
Dateline int (10) -- Date
Expiration int (10) -- Validity Period
Message Text -- message content

-------------------------------------------------------------------------

-- Table structure 'cdb _ adminsession'
--

Drop table if exists cdb_adminsessions;
Create Table cdb_adminsessions (
UID mediumint (8) unsigned not null default '0 ',
IP char (15) not null default '',
Dateline int (10) unsigned not null default '0 ',
Errorcount tinyint (1) not null default '0'
) Type = MyISAM;

--

Data Table Function Introduction: Background logon records
UID mediumint (8) -- User Logon ID
IP char (15) -- logon IP
Dateline int (10) -- logon date
Errorcount tinyint (1) -- number of password errors

--------------------------------------------------------------------------

-- Table structure 'cdb _ Advertisements'
--

Drop table if exists cdb_advertisements;
Create Table cdb_advertisements (
Advid mediumint (8) unsigned not null auto_increment,
Available tinyint (1) not null default '0 ',
'Type' varchar (50) not null default '0 ',
Displayorder tinyint (3) not null default '0 ',
Title varchar (50) not null default '',
Targets text not null,
Parameters text not null,
'Code' text not null,
Starttime int (10) unsigned not null default '0 ',
Endtime int (10) unsigned not null default '0 ',
Primary Key (advid)
) Type = MyISAM;

--

Function Introduction: AD Information Storage
Advid mediumint (8) -- Ad ID
Available tinyint (1) -- whether to display (available)
'Type' varchar (50) -- type
Displayorder tinyint (3) -- display order
Title varchar (50) -- title
Targets text -- style
Parameters text -- display position #
'Code' text -- code
Starttime int (10) -- Start Time
Endtime int (10) -- End Time

-------------------------------------------------------------- ==============

-- Table structure 'cdb _ announcements'
--

Drop table if exists cdb_announcements;
Create Table cdb_announcements (
Id smallint (6) unsigned not null auto_increment,
Author varchar (15) not null default '',
'Subobject' varchar (250) not null default '',
Displayorder tinyint (3) not null default '0 ',
Starttime int (10) unsigned not null default '0 ',
Endtime int (10) unsigned not null default '0 ',
Message Text not null,
Primary Key (ID ),
Key timespan (starttime, endtime)
) Type = MyISAM;

--

Data Table Function Introduction: storage of announcement Information
Id smallint (6) -- announcement ID
Author varchar (15) -- publisher
'Subobject' varchar (250) -- title
Displayorder tinyint (3) -- display order
Starttime int (10) -- Start Time
Endtime int (10) -- End Time
Message Text -- Content

Bytes --------------------------------------------------------------------------------------

-- Table structure 'cdb _ attachances'
--

Drop table if exists cdb_attachments;
Create Table cdb_attachments (
Aid mediumint (8) unsigned not null auto_increment,
TID mediumint (8) unsigned not null default '0 ',
PID int (10) unsigned not null default '0 ',
Dateline int (10) unsigned not null default '0 ',
Readperm tinyint (3) unsigned not null default '0 ',
Filename char (100) not null default '',
Descr resume ption char (100) not null default '',
Filetype char (50) not null default '',
Filesize int (10) unsigned not null default '0 ',
Attachment char (100) not null default '',
Downloads mediumint (8) Not null default '0 ',
Primary Key (AID ),
Key TID (TID ),
Key PID (PID, aid)
) Type = MyISAM;

--

Data Table Function Introduction: attachment information storage table
Aid mediumint (8) -- attachment ID
TID mediumint (8) -- ID of the topic
PID int (10) -- ID of the post
Dateline int (10) -- date and time when the attachment is uploaded/last updated
Readperm tinyint (3) -- Read Permission
Filename char (100) -- File Name of the attachment during upload
Descr limit ption char (100) -- attachment description
Filetype char (50) -- attachment type
Filesize int (10) -- attachment size
Attachment char (100) -- File Name of the uploaded attachment
Downloads mediumint (8) -- downloads