Manual:user_autocreate_serial table

↑ Manual:Contents

MediaWiki database layout

user_autocreate_serial table

MediaWiki version:

≥ 1.39 Gerrit change 767617

The user_autocreate_serial tables is for sequential name generation for auto-created temporary users.

Fields

uas_shard

MediaWiki version:

≥ 1.39

The segment of ID space, ID mod N, referred to by this row.

uas_value

MediaWiki version:

≥ 1.39

The maximum allocated ID value.

uas_year

MediaWiki version:

≥ 1.42

The year to which this row belongs, if the temporary account format includes the year. For IDs that are not combined with a year, this is 0.

Schema summary

MediaWiki version:

≥ 1.42

DESCRIBEuser_autocreate_serial;

+-----------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------------------+------+-----+---------+-------+ | uas_shard | int(10) unsigned | NO | PRI | NULL | | | uas_value | int(10) unsigned | NO | | NULL | | | uas_year | smallint(5) unsigned | NO | PRI | NULL | | +-----------+----------------------+------+-----+---------+-------+ 

MediaWiki versions:

1.39 – 1.41

DESCRIBEuser_autocreate_serial;

+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | uas_shard | int(10) unsigned | NO | PRI | NULL | | | uas_value | int(10) unsigned | NO | | NULL | | +-----------+------------------+------+-----+---------+-------+ 

Indexes

MediaWiki version:

≥ 1.42

SHOWINDEXINuser_autocreate_serial;

+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | user_autocreate_serial | 0 | PRIMARY | 1 | uas_shard | A | 0 | NULL | NULL | | BTREE | | | NO | | user_autocreate_serial | 0 | PRIMARY | 2 | uas_year | A | 0 | NULL | NULL | | BTREE | | | NO | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+