Extension:AntiSpoof/spoofuser table

From mediawiki.org

Schema[edit]

mysql> describe spoofuser;
+---------------+----------------+------+-----+---------+-------+
| Field         | Type           | Null | Key | Default | Extra |
+---------------+----------------+------+-----+---------+-------+
| su_name       | varbinary(255) | NO   | PRI | NULL    |       |
| su_normalized | varbinary(255) | YES  | MUL | NULL    |       |
| su_legal      | tinyint(1)     | YES  |     | NULL    |       |
| su_error      | blob           | YES  |     | NULL    |       |
+---------------+----------------+------+-----+---------+-------+

Indexes[edit]

+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table     | Non_unique | Key_name      | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| spoofuser |          0 | PRIMARY       |            1 | su_name       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| spoofuser |          1 | su_normalized |            1 | su_normalized | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| spoofuser |          1 | su_normalized |            2 | su_name       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+