Manual:user_autocreate_serial table
From Linux Web Expert
| ↑ Manual:Contents | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>user_autocreate_serial</tvar> table</translate> |
<translate> ≥</translate> 1.39
Gerrit change 767617| <translate> MediaWiki version:</translate> |
The user_autocreate_serial tables is for sequential name generation for auto-created temporary users.
Fields
uas_shard
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.39
| <translate> MediaWiki version:</translate> |
The segment of ID space, ID mod N, referred to by this row.
uas_value
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.39
| <translate> MediaWiki version:</translate> |
The maximum allocated ID value.
uas_year
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.42
| <translate> MediaWiki version:</translate> |
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
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.42
| <translate> MediaWiki version:</translate> |
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 | | +-----------+----------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.41</tvar> is stable version</translate>">
1.39 – 1.41
| <translate> MediaWiki versions:</translate> |
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
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.42
| <translate> MediaWiki version:</translate> |
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 | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
