Manual:user_autocreate_serial テーブル
Appearance
↑ Manual:コンテンツ | MediaWiki のデータベース レイアウト | user_autocreate_serial テーブル |
MediaWiki バージョン: | ≧ 1.39 Gerrit change 767617 |
The user_autocreate_serial tables is for sequential name generation for auto-created temporary users.
フィールド
uas_shard
MediaWiki バージョン: | ≧ 1.39 |
The segment of ID space, ID mod N, referred to by this row.
uas_value
MediaWiki バージョン: | ≧ 1.39 |
割り当てられた ID 値の最大値。
uas_year
MediaWiki バージョン: | ≧ 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
.
スキーマの要約
MediaWiki バージョン: | ≧ 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 バージョン: | 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 | | +-----------+------------------+------+-----+---------+-------+
インデックス
MediaWiki バージョン: | ≧ 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 | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+