Movatterモバイル変換


[0]ホーム

URL:


Jump to content
MediaWiki
Search

Extension:CheckUser/cu log event table

From mediawiki.org
<Extension:CheckUser
Translate this page
Languages:
MediaWiki version:
1.40

A table for theCheckUser extension used to store log entries with log ID from therecentchanges table and other selected events with the IP and UA string used to make the action.See alsocu_changes andcu_private_event.

In 1.40, this table is unused but is added to the database.Since 1.41, this table is used.

Fields

[edit]

cule_id

[edit]

Primary key, used to uniquely identify a cu_log_event row.

cule_log_id

[edit]

Thelogging.log_id associated with this cu_log_event row.

cule_actor

[edit]

Stores theactor_id for the user who performed the action that created this row.Similar torc_user.

cule_timestamp

[edit]

Timestamp for the event that is stored in the cu_log_event table, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss.

cule_ip

[edit]

The IP address used to make the edit.

cule_ip_hex

[edit]

The IP address incuc_ip as hexadecimal.

cule_xff

[edit]

The entire XFF header.If not provided or if all XFF IPs arevarnish servers, this will be the empty string.

cule_xff_hex

[edit]

If all XFF IPs are notvarnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.

cule_agent

[edit]

The User agent header provided in the request that made the action being stored in this row.

cule_agent_id

[edit]
MediaWiki version:
1.42

References a row in thecu_useragent table by thecuua_id column.The row in the table stores the user agent header provided in the request.

Schema

[edit]
MediaWiki version:
1.42

DESCRIBEcu_log_event;

+----------------+---------------------+------+-----+---------+----------------+| Field          | Type                | Null | Key | Default | Extra          |+----------------+---------------------+------+-----+---------+----------------+| cule_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment || cule_log_id    | int(10) unsigned    | NO   |     | 0       |                || cule_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                || cule_timestamp | binary(14)          | NO   | MUL | NULL    |                || cule_ip        | varbinary(255)      | YES  |     |         |                || cule_ip_hex    | varbinary(255)      | YES  | MUL | NULL    |                || cule_xff       | varbinary(255)      | YES  |     |         |                || cule_xff_hex   | varbinary(255)      | YES  | MUL | NULL    |                || cule_agent     | varbinary(255)      | YES  |     | NULL    |                || cule_agent_id  | bigint(20) unsigned | NO   |     | 0       |                |+----------------+---------------------+------+-----+---------+----------------+
MediaWiki versions:
1.40 – 1.41

DESCRIBEcu_log_event;

+----------------+---------------------+------+-----+---------+----------------+| Field          | Type                | Null | Key | Default | Extra          |+----------------+---------------------+------+-----+---------+----------------+| cule_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment || cule_log_id    | int(10) unsigned    | NO   |     | 0       |                || cule_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                || cule_timestamp | binary(14)          | NO   | MUL | NULL    |                || cule_ip        | varbinary(255)      | YES  |     |         |                || cule_ip_hex    | varbinary(255)      | YES  | MUL | NULL    |                || cule_xff       | varbinary(255)      | YES  |     |         |                || cule_xff_hex   | varbinary(255)      | YES  | MUL | NULL    |                || cule_agent     | varbinary(255)      | YES  |     | NULL    |                |+----------------+---------------------+------+-----+---------+----------------+
Engines
Current
Former
Technical documentation
Configuration
Development
Core tables
Current
Former
Wikimedia extension database tables
AbuseFilter
AntiSpoof
Babel
BetaFeatures
BounceHandler
CampaignEvents
CentralAuth
CentralNotice
CheckUser
Cognate
CommunityRequests
ContentTranslation
CreditsSource
DiscussionTools
Echo
EntitySchema
FlaggedRevs
GeoData
GlobalBlocking
GlobalPreferences
GlobalUsage
GrowthExperiments
Linter
LiquidThreads
LoginNotify
MediaModeration
Math
Newsletter
OATHAuth
OAuth
ORES
PageAssessments
PageTriage
Proofread Page
PropertySuggester
ReadingLists
SecurePoll
ShortUrl
TimedMediaHandler
Translate
UploadWizard
UrlShortener
WikibaseQualityConstraints
Wikibase Client
Wikibase Repository
WikiLambda
WikiLove
WikimediaCampaignEvents
WikimediaEditorTasks
Retrieved from "https://www.mediawiki.org/w/index.php?title=Extension:CheckUser/cu_log_event_table&oldid=6455745"
Category:

[8]ページ先頭

©2009-2025 Movatter.jp