Ucenter table structure

Last Update:2018-12-07 Source: Internet

Author: User

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

Ucenter database table structure description

Uc_admins administrator table
Data Table Description: Administrator Information
Attribute description:
UID mediumint (8) -- User ID
Username char (15) -- User Name
Allowadminsetting tinyint (1 )--
Allowadminapp tinyint (1 )--
Allowadminuser tinyint (1 )--
Allowadminbadword tinyint (1 )--
Allowadmintag tinyint (1 )--
Allowadminpm tinyint (1 )--
Allowadmincredits tinyint (1 )--
Allowadmindomain tinyint (1 )--
Allowadmindb tinyint (1 )--
Allowadminnote tinyint (1 )--
Allowadmincache tinyint (1 )--
Allowadminlog tinyint (1 )--

Uc_applications discuz application table
Data Table Description: records all applications (discuz Forum, uchome)
Attribute description:
Appid smallint (6) -- Application ID
Type char (16) -- Application Type
Name char (20) -- Application name
URL char (255) -- URL address
Authkey char (255 )--
IP char (15 )--
Viewprourl char (30 )--
Apifilename char (30) -- API file name
Charset char (8) -- Character Set
Dbcharset char (8) -- database Character Set
Synlogin tinyint (1 )--
Recvnote tinyint (1 )--
Extra mediumtext
Extra mediumtext

Uc_badwords filter words
Data Table Description: Key Word Filtering
Attribute description:
Id smallint (6 )--
Admin varchar (15 )--
Find varchar (255 )--
Replacement varchar (255 )--
Findpattern varchar (255 )--

Uc_domains domain name resolution
Data Table Description: domain name resolution information
Attribute description:
Id int (10) -- ID
Domain char (40) -- Domain Name
IP char (15) -- IP Address

Uc_failedlogins logon records
Data Table Description: logon information
Attribute description:
IP char (15) -- logon IP Address
Count tinyint (1) -- number of logins
Lastupdate int (10) -- Last Logon Time

Uc_feeds Feedback Form
Data Table Description: feedback (see the uchome_feed table)
Attribute description:
Feedid mediumint (8) -- feedback ID
Appid varchar (30) -- Application ID
Icon varchar (30) -- icon
UID mediumint (8) -- User ID
Username varchar (15) -- User Name
Dateline int (10) -- Creation Time
Hash_template varchar (32 )--
Hash_data varchar (32 )--
Title_template text -- title Template
Title_data text -- title content
Body_template text -- Subject Template
Body_data text -- subject content
Body_general text -- general subject information
Image_1 varchar (255) -- image 1 position
Image_1_link varchar (255) -- image 1 Link (the same as below)
Image_2 varchar (255 )--
Image_2_link varchar (255 )--
Image_3 varchar (255 )--
Image_3_link varchar (255 )--
Image_4 varchar (255 )--
Image_4_link varchar (255 )--
Target_ids varchar (255 )--

Uc_friends friends table
Data Table Description: Friend information
Attribute description:
UID mediumint (8) -- User ID
Friendid mediumint (8) -- friend ID
Direction tinyint (1 )--
Version int (10 )--
Delstatus tinyint (1) -- delete status
Comment char (255) -- leave a message

Uc_mailqueue Message Queue
Data table description:
Attribute description:
Mailid int (10) -- email id
Touid mediumint (8) -- receiver ID
Toumail varchar (32 )--
Frommail varchar (100 )--
Subject varchar (255) -- Topic
Message Text -- Information
Charset varchar (15) -- Character Set
Htmlon tinyint (1 )--
Level tinyint (1 )--
Dateline int (10) -- Creation Time
Failures tinyint (3 )--
Appid smallint (6 )--

Uc_memberfields
Data table description:
Attribute description:
UID mediumint (8) -- User ID
Blacklist text -- blacklist

Uc_members User table
Data Table Description: User personal information
Attribute description:
UID mediumint (8) -- User ID
Username char (15) -- User Name
Password char (32) -- Password
Email char (32) -- email address
Myid char (30 )--
Myidkey char (16 )--
Regip char (15) -- register an IP address
Regdate int (10) -- Registration Date
Lastloginip int (10) -- Last Logon IP
Lastlogintime int (10) -- Last Logon Time
Salt char (6 )--
Secques char (8 )--

Uc_mergemembers
Data Table Description: users with duplicate names are saved to this table.
Attribute description:
Appid smallint (6) -- Application ID
Username char (15) -- User Name

Uc_newpm
Data table description:
Attribute description:
UID mediumint (8 )--

Uc_notelist
Data table description:
Attribute description:
Noteid int (10 )--
Operation char (32 )--
Closed tinyint (4 )--
Totalnum smallint (6 )--
Succeednum smallint (6 )--
Getdata mediumtext --
Postdata mediumtext --
Dateline int (10 )--
PRI tinyint (3 )--
App1 tinyint (4 )--
App2 tinyint (4 )--

Uc_pms Short Message table
Data Table Description: stores the content of short messages on the site.
Attribute description:
Pmid int (10) -- Short Message ID
Msgfrom varchar (15) -- sender name
Msgfromid mediumint (8) -- sender ID
Msgtoid mediumint (8) -- receiver ID
Folder Enum ('inbox', 'Outbox') -- storage location
New tinyint (1) -- whether it is a new message
Subject varchar (75) -- Topic
Dateline int (10) -- Creation Time
Message Text -- Information Content
Delstatus tinyint (1) -- delete status
Related int (10) -- whether to Associate Information
Fromappid smallint (6) -- Application ID

Uc_protectedmembers
Description of data tables: protected users
Attribute description:
UID mediumint (8) -- User ID
Username char (15) -- User Name
Appid tinyint (1) -- Application ID
Dateline int (10) -- Creation Time
Admin char (15) -- Administrator

Uc_settings settings table
Data Table Description: Basic settings
Attribute description:
K varchar (32) -- set the name
V text -- set content

Uc_sqlcache
Data table description:
Attribute description:
Sqlid char (6 )--
Data char (100 )--
Expiry int (10 )--

Uc_tags
Data table description:
Attribute description:
Tagname char (20 )--
Appid smallint (6 )--
Data mediumtext --
Expiration int (10 )--

Uc_vars
Data table description:
Attribute description:
Name char (32 )--
Value char (255 )--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Still not found. For reference only! The content comes from the network.