Manual:user_autocreate_serial table
Appearance
↑ 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
[edit]uas_shard
[edit]MediaWiki version: | ≥ 1.39 |
The segment of ID space, ID mod N, referred to by this row.
uas_value
[edit]MediaWiki version: | ≥ 1.39 |
The maximum allocated ID value.
uas_year
[edit]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
[edit]MediaWiki version: | ≥ 1.42 |
DESCRIBE user_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 |
DESCRIBE user_autocreate_serial;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | uas_shard | int(10) unsigned | NO | PRI | NULL | | | uas_value | int(10) unsigned | NO | | NULL | | +-----------+------------------+------+-----+---------+-------+
Indexes
[edit]MediaWiki version: | ≥ 1.42 |
SHOW INDEX IN user_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 | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+