| MediaWiki version: | ≥ 1.39 Gerrit change 767617 |
Theuser_autocreate_serial tables is for sequential name generation for auto-createdtemporary users.
| MediaWiki version: | ≥ 1.39 |
The segment of ID space, ID mod N, referred to by this row.
| MediaWiki version: | ≥ 1.39 |
The maximum allocated ID value.
| 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 is0.
| 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 | |+-----------+------------------+------+-----+---------+-------+
| 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 |+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+