Test: Unterschied zwischen den Versionen

Aus Bibelwissen
Wechseln zu: Navigation, Suche
Zeile 1: Zeile 1:
mysql> describe abuse_filter_action;
+
+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-----------------+---------------------+------+-----+---------+-------+
+
| Table              | Non_unique | Key_name        | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Field          | Type                | Null | Key | Default | Extra |
+
+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-----------------+---------------------+------+-----+---------+-------+
+
| abuse_filter_action |          0 | PRIMARY        |            1 | afa_filter      | A        |           0 |     NULL | NULL   |      | BTREE      |        |               |
| afa_filter      | bigint(20) unsigned | NO  | PRI | NULL   |       |
+
| abuse_filter_action |          0 | PRIMARY        |            2 | afa_consequence | A        |           0 |     NULL | NULL   |     | BTREE      |        |              |
| afa_consequence | varbinary(255)      | NO  | PRI | NULL   |       |
+
| abuse_filter_action |          1 | afa_consequence |            1 | afa_consequence | A        |          0 |    NULL | NULL   |      | BTREE      |        |               |
| afa_parameters  | tinyblob           | NO  |    | NULL   |       |
+
+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-----------------+---------------------+------+-----+---------+-------+
+

Version vom 2. April 2023, 00:17 Uhr

+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | abuse_filter_action | 0 | PRIMARY | 1 | afa_filter | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_action | 0 | PRIMARY | 2 | afa_consequence | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_action | 1 | afa_consequence | 1 | afa_consequence | A | 0 | NULL | NULL | | BTREE | | | +---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+