Manual:user_autocreate_serial table

↑ Manual:Contents

<translate> MediaWiki database layout</translate>

<translate> <tvar name=1>user_autocreate_serial</tvar> table</translate>

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></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      |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+