Compare text

Find the difference between two text files

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Tools

Untitled diff

Created 6 years agoDiff never expires

121 removals

188 lines

110 additions

185 lines

MariaDB [wikidatawiki]> describe wb_changes;

MariaDB [default]> describe wb_changes;

+--------------------+------------------+------+-----+---------+----------------+

+--------------------+------------------+------+-----+---------+----------------+

+--------------------+------------------+------+-----+---------+----------------+

7 rows in set (0.00 sec)

7 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_changes;

MariaDB [default]> show index from wb_changes;

+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

6 rows in set (0.00 sec)

6 rows in set (0.001 sec)

MariaDB [wikidatawiki]> describe wb_changes_dispatch;

MariaDB [default]> describe wb_changes_dispatch;

+--------------+---------------------+------+-----+----------------+-------+

+--------------+---------------------+------+-----+----------------+-------+

| chd_seen | int(11) | NO | MUL | 0 | |

| chd_touched | varbinary(14) | NO | MUL | 00000000000000 | |

| chd_disabled | tinyint(3) unsigned | NO | | 0 | |

+--------------+---------------------+------+-----+----------------+-------+

6 rows in set (0.00 sec)

6 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_changes_dispatch;

MariaDB [default]> show index from wb_changes_dispatch;

+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

3 rows in set (0.00 sec)

3 rows in set (0.000 sec)

MariaDB [wikidatawiki]> describe wb_changes_subscription;

MariaDB [default]> describe wb_changes_subscription;

+------------------+----------------+------+-----+---------+----------------+

+------------------+----------------+------+-----+---------+----------------+

+------------------+----------------+------+-----+---------+----------------+

3 rows in set (0.00 sec)

3 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_changes_subscription;

MariaDB [default]> show index from wb_changes_subscription;

+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.00 sec)

4 rows in set (0.000 sec)

MariaDB [wikidatawiki]> describe wb_id_counters;

MariaDB [default]> describe wb_id_counters;

+----------+------------------+------+-----+---------+-------+

+----------+------------------+------+-----+---------+-------+

+----------+------------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

2 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_id_counters;

MariaDB [default]> show index from wb_id_counters;

+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

1 row in set (0.00 sec)

1 row in set (0.000 sec)

MariaDB [wikidatawiki]> describe wb_items_per_site;

MariaDB [default]> describe wb_items_per_site;

+---------------+---------------------+------+-----+---------+----------------+

+---------------+---------------------+------+-----+---------+----------------+

+---------------+---------------------+------+-----+---------+----------------+

4 rows in set (0.00 sec)

4 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_items_per_site;

MariaDB [default]> show index from wb_items_per_site;

+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.00 sec)

4 rows in set (0.000 sec)

MariaDB [wikidatawiki]> describe wb_property_info;

MariaDB [default]> describe wb_property_info;

+----------------+------------------+------+-----+---------+-------+

+----------------+------------------+------+-----+---------+-------+

+----------------+------------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

3 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_property_info;

MariaDB [default]> show index from wb_property_info;

+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

2 rows in set (0.00 sec)

2 rows in set (0.000 sec)

MariaDB [wikidatawiki]> describe wb_terms;

MariaDB [default]> describe wb_terms;

+---------------------+---------------------+------+-----+---------+----------------+

+---------------------+---------------------+------+-----+---------+----------------+

| term_weight | float unsigned | NO | | 0 | |

+---------------------+---------------------+------+-----+---------+----------------+

9 rows in set (0.00 sec)

9 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wb_terms;

MariaDB [default]> show index from wb_terms;

+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | |

| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 85880978 | NULL | NULL | YES | BTREE | | |

| wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 1717619563 | NULL | NULL | YES | BTREE | | |

| wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | |

| wb_terms | 1 | term_search_full | 4 | term_search_key | A | 1717619563 | 16 | NULL | | BTREE | | |

| wb_terms | 1 | tmp1 | 1 | term_language | A | 6982193 | NULL | NULL | | BTREE | | |

| wb_terms | 1 | term_search_full | 4 | term_search_key | A | 4 | 16 | NULL | | BTREE | | |

| wb_terms | 1 | tmp1 | 2 | term_type | A | 6709451 | NULL | NULL | | BTREE | | |

+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| wb_terms | 1 | tmp1 | 3 | term_entity_type | A | 8718881 | NULL | NULL | | BTREE | | |

10 rows in set (0.001 sec)

| wb_terms | 1 | tmp1 | 4 | term_search_key | A | 429404890 | NULL | NULL | | BTREE | | |

+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

13 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wbc_entity_usage;

MariaDB [default]> describe wbc_entity_usage;

+--------------+----------------+------+-----+---------+----------------+

+--------------+----------------+------+-----+---------+----------------+

| eu_page_id | int(11) | NO | MUL | NULL | |

+--------------+----------------+------+-----+---------+----------------+

4 rows in set (0.00 sec)

4 rows in set (0.001 sec)

MariaDB [wikidatawiki]> show index from wbc_entity_usage;

MariaDB [default]> show index from wbc_entity_usage;

+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

6 rows in set (0.00 sec)

6 rows in set (0.000 sec)

Saved diffs

Original text

Open file

MariaDB [wikidatawiki]> describe wb_changes;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| change_id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| change_type        | varbinary(25)    | NO   | MUL | NULL    |                |
| change_time        | varbinary(14)    | NO   | MUL | NULL    |                |
| change_object_id   | varbinary(14)    | NO   | MUL | NULL    |                |
| change_revision_id | int(10) unsigned | NO   | MUL | NULL    |                |
| change_user_id     | int(10) unsigned | NO   | MUL | NULL    |                |
| change_info        | mediumblob       | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_changes;
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name                      | Seq_in_index | Column_name        | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes |          0 | PRIMARY                       |            1 | change_id          | A         |     1621042 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_type        |            1 | change_type        | A         |          13 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_time        |            1 | change_time        | A         |      540347 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_object_id   |            1 | change_object_id   | A         |     1621042 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_user_id     |            1 | change_user_id     | A         |        6839 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_revision_id |            1 | change_revision_id | A         |     1621042 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_changes_dispatch;
+--------------+---------------------+------+-----+----------------+-------+
| Field        | Type                | Null | Key | Default        | Extra |
+--------------+---------------------+------+-----+----------------+-------+
| chd_site     | varbinary(32)       | NO   | PRI | NULL           |       |
| chd_db       | varbinary(32)       | NO   |     | NULL           |       |
| chd_seen     | int(11)             | NO   | MUL | 0              |       |
| chd_touched  | varbinary(14)       | NO   | MUL | 00000000000000 |       |
| chd_lock     | varbinary(64)       | YES  |     | NULL           |       |
| chd_disabled | tinyint(3) unsigned | NO   |     | 0              |       |
+--------------+---------------------+------+-----+----------------+-------+
6 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_changes_dispatch;
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table               | Non_unique | Key_name                        | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_dispatch |          0 | PRIMARY                         |            1 | chd_site    | A         |         577 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_dispatch |          1 | wb_changes_dispatch_chd_seen    |            1 | chd_seen    | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_dispatch |          1 | wb_changes_dispatch_chd_touched |            1 | chd_touched | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_changes_subscription;
+------------------+----------------+------+-----+---------+----------------+
| Field            | Type           | Null | Key | Default | Extra          |
+------------------+----------------+------+-----+---------+----------------+
| cs_row_id        | bigint(20)     | NO   | PRI | NULL    | auto_increment |
| cs_entity_id     | varbinary(255) | NO   | MUL | NULL    |                |
| cs_subscriber_id | varbinary(255) | NO   | MUL | NULL    |                |
+------------------+----------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_changes_subscription;
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table                   | Non_unique | Key_name         | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_subscription |          0 | PRIMARY          |            1 | cs_row_id        | A         |    62616116 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          0 | cs_entity_id     |            1 | cs_entity_id     | A         |    62616116 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          0 | cs_entity_id     |            2 | cs_subscriber_id | A         |    62616116 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          1 | cs_subscriber_id |            1 | cs_subscriber_id | A         |       70993 |     NULL | NULL   |      | BTREE      |         |               |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_id_counters;
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| id_value | int(10) unsigned | NO   |     | NULL    |       |
| id_type  | varbinary(32)    | NO   | PRI | NULL    |       |
+----------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_id_counters;
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name            | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_id_counters |          0 | wb_id_counters_type |            1 | id_type     | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_items_per_site;
+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| ips_row_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ips_item_id   | int(10) unsigned    | NO   | MUL | NULL    |                |
| ips_site_id   | varbinary(32)       | NO   | MUL | NULL    |                |
| ips_site_page | varbinary(310)      | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_items_per_site;
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table             | Non_unique | Key_name              | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_items_per_site |          0 | PRIMARY               |            1 | ips_row_id    | A         |    60912657 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          0 | wb_ips_item_site_page |            1 | ips_site_id   | A         |       87267 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          0 | wb_ips_item_site_page |            2 | ips_site_page | A         |    60912657 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          1 | wb_ips_item_id        |            1 | ips_item_id   | A         |    60912657 |     NULL | NULL   |      | BTREE      |         |               |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_property_info;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pi_property_id | int(10) unsigned | NO   | PRI | NULL    |       |
| pi_type        | varbinary(32)    | NO   | MUL | NULL    |       |
| pi_info        | blob             | NO   |     | NULL    |       |
+----------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_property_info;
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_property_info |          0 | PRIMARY  |            1 | pi_property_id | A         |        5144 |     NULL | NULL   |      | BTREE      |         |               |
| wb_property_info |          1 | pi_type  |            1 | pi_type        | A         |          30 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wb_terms;
+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| term_row_id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| term_entity_id      | int(10) unsigned    | NO   | MUL | NULL    |                |
| term_full_entity_id | varbinary(32)       | YES  | MUL | NULL    |                |
| term_entity_type    | varbinary(32)       | NO   |     | NULL    |                |
| term_language       | varbinary(32)       | NO   | MUL | NULL    |                |
| term_type           | varbinary(32)       | NO   |     | NULL    |                |
| term_text           | varbinary(255)      | NO   | MUL | NULL    |                |
| term_search_key     | varbinary(255)      | NO   | MUL | NULL    |                |
| term_weight         | float unsigned      | NO   |     | 0       |                |
+---------------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wb_terms;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name            | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms |          0 | PRIMARY             |            1 | term_row_id         | A         |  1717619563 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_entity_id  |            1 | term_entity_id      | A         |   156147233 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_text       |            1 | term_text           | A         |   429404890 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_search_key |            1 | term_search_key     | A         |   156147233 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_full_entity    |            1 | term_full_entity_id | A         |    85880978 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            1 | term_language       | A         |     6580917 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            2 | term_full_entity_id | A         |  1717619563 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            3 | term_type           | A         |  1717619563 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            4 | term_search_key     | A         |  1717619563 |       16 | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            1 | term_language       | A         |     6982193 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            2 | term_type           | A         |     6709451 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            3 | term_entity_type    | A         |     8718881 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            4 | term_search_key     | A         |   429404890 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
13 rows in set (0.00 sec)

MariaDB [wikidatawiki]> describe wbc_entity_usage;
+--------------+----------------+------+-----+---------+----------------+
| Field        | Type           | Null | Key | Default | Extra          |
+--------------+----------------+------+-----+---------+----------------+
| eu_row_id    | bigint(20)     | NO   | PRI | NULL    | auto_increment |
| eu_entity_id | varbinary(255) | NO   | MUL | NULL    |                |
| eu_aspect    | varbinary(37)  | NO   |     | NULL    |                |
| eu_page_id   | int(11)        | NO   | MUL | NULL    |                |
+--------------+----------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

MariaDB [wikidatawiki]> show index from wbc_entity_usage;
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name     | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wbc_entity_usage |          0 | PRIMARY      |            1 | eu_row_id    | A         |     6485691 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            1 | eu_entity_id | A         |     3242845 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            2 | eu_aspect    | A         |     6485691 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            3 | eu_page_id   | A         |     6485691 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          1 | eu_page_id   |            1 | eu_page_id   | A         |      180158 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          1 | eu_page_id   |            2 | eu_entity_id | A         |     6485691 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.00 sec)

Changed text

Open file

MariaDB [default]> describe wb_changes;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| change_id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| change_type        | varbinary(25)    | NO   | MUL | NULL    |                |
| change_time        | varbinary(14)    | NO   | MUL | NULL    |                |
| change_object_id   | varbinary(14)    | NO   | MUL | NULL    |                |
| change_revision_id | int(10) unsigned | NO   | MUL | NULL    |                |
| change_user_id     | int(10) unsigned | NO   | MUL | NULL    |                |
| change_info        | mediumblob       | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.001 sec)

MariaDB [default]> show index from wb_changes;
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name                      | Seq_in_index | Column_name        | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes |          0 | PRIMARY                       |            1 | change_id          | A         |          17 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_type        |            1 | change_type        | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_time        |            1 | change_time        | A         |          17 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_object_id   |            1 | change_object_id   | A         |          17 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_user_id     |            1 | change_user_id     | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes |          1 | wb_changes_change_revision_id |            1 | change_revision_id | A         |          17 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.001 sec)

MariaDB [default]> describe wb_changes_dispatch;
+--------------+---------------------+------+-----+----------------+-------+
| Field        | Type                | Null | Key | Default        | Extra |
+--------------+---------------------+------+-----+----------------+-------+
| chd_site     | varbinary(32)       | NO   | PRI | NULL           |       |
| chd_db       | varbinary(32)       | NO   |     | NULL           |       |
| chd_seen     | int(11)             | NO   | MUL | 0              |       |
| chd_touched  | varbinary(14)       | NO   | MUL | 00000000000000 |       |
| chd_lock     | varbinary(64)       | YES  |     | NULL           |       |
| chd_disabled | tinyint(3) unsigned | NO   |     | 0              |       |
+--------------+---------------------+------+-----+----------------+-------+
6 rows in set (0.001 sec)

MariaDB [default]> show index from wb_changes_dispatch;
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table               | Non_unique | Key_name                        | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_dispatch |          0 | PRIMARY                         |            1 | chd_site    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_dispatch |          1 | wb_changes_dispatch_chd_seen    |            1 | chd_seen    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_dispatch |          1 | wb_changes_dispatch_chd_touched |            1 | chd_touched | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.000 sec)

MariaDB [default]> describe wb_changes_subscription;
+------------------+----------------+------+-----+---------+----------------+
| Field            | Type           | Null | Key | Default | Extra          |
+------------------+----------------+------+-----+---------+----------------+
| cs_row_id        | bigint(20)     | NO   | PRI | NULL    | auto_increment |
| cs_entity_id     | varbinary(255) | NO   | MUL | NULL    |                |
| cs_subscriber_id | varbinary(255) | NO   | MUL | NULL    |                |
+------------------+----------------+------+-----+---------+----------------+
3 rows in set (0.001 sec)

MariaDB [default]> show index from wb_changes_subscription;
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table                   | Non_unique | Key_name         | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_subscription |          0 | PRIMARY          |            1 | cs_row_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          0 | cs_entity_id     |            1 | cs_entity_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          0 | cs_entity_id     |            2 | cs_subscriber_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_changes_subscription |          1 | cs_subscriber_id |            1 | cs_subscriber_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.000 sec)

MariaDB [default]> describe wb_id_counters;
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| id_value | int(10) unsigned | NO   |     | NULL    |       |
| id_type  | varbinary(32)    | NO   | PRI | NULL    |       |
+----------+------------------+------+-----+---------+-------+
2 rows in set (0.001 sec)

MariaDB [default]> show index from wb_id_counters;
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name            | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_id_counters |          0 | wb_id_counters_type |            1 | id_type     | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.000 sec)

MariaDB [default]> describe wb_items_per_site;
+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| ips_row_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ips_item_id   | int(10) unsigned    | NO   | MUL | NULL    |                |
| ips_site_id   | varbinary(32)       | NO   | MUL | NULL    |                |
| ips_site_page | varbinary(310)      | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.001 sec)

MariaDB [default]> show index from wb_items_per_site;
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table             | Non_unique | Key_name              | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_items_per_site |          0 | PRIMARY               |            1 | ips_row_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          0 | wb_ips_item_site_page |            1 | ips_site_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          0 | wb_ips_item_site_page |            2 | ips_site_page | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wb_items_per_site |          1 | wb_ips_item_id        |            1 | ips_item_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.000 sec)

MariaDB [default]> describe wb_property_info;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pi_property_id | int(10) unsigned | NO   | PRI | NULL    |       |
| pi_type        | varbinary(32)    | NO   | MUL | NULL    |       |
| pi_info        | blob             | NO   |     | NULL    |       |
+----------------+------------------+------+-----+---------+-------+
3 rows in set (0.001 sec)

MariaDB [default]> show index from wb_property_info;
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_property_info |          0 | PRIMARY  |            1 | pi_property_id | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
| wb_property_info |          1 | pi_type  |            1 | pi_type        | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.000 sec)

MariaDB [default]> describe wb_terms;
+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| term_row_id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| term_entity_id      | int(10) unsigned    | NO   |     | NULL    |                |
| term_full_entity_id | varbinary(32)       | YES  | MUL | NULL    |                |
| term_entity_type    | varbinary(32)       | NO   |     | NULL    |                |
| term_language       | varbinary(32)       | NO   | MUL | NULL    |                |
| term_type           | varbinary(32)       | NO   |     | NULL    |                |
| term_text           | varbinary(255)      | NO   | MUL | NULL    |                |
| term_search_key     | varbinary(255)      | NO   | MUL | NULL    |                |
| term_weight         | float unsigned      | NO   |     | 0       |                |
+---------------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.001 sec)

MariaDB [default]> show index from wb_terms;
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms |          0 | PRIMARY          |            1 | term_row_id         | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_full_entity |            1 | term_full_entity_id | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_text        |            1 | term_text           | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_text        |            2 | term_language       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_key  |            1 | term_search_key     | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_key  |            2 | term_language       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full |            1 | term_language       | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full |            2 | term_full_entity_id | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_search_full |            3 | term_type           | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full |            4 | term_search_key     | A         |           4 |       16 | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
10 rows in set (0.001 sec)

MariaDB [default]> describe wbc_entity_usage;
+--------------+----------------+------+-----+---------+----------------+
| Field        | Type           | Null | Key | Default | Extra          |
+--------------+----------------+------+-----+---------+----------------+
| eu_row_id    | bigint(20)     | NO   | PRI | NULL    | auto_increment |
| eu_entity_id | varbinary(255) | NO   | MUL | NULL    |                |
| eu_aspect    | varbinary(37)  | NO   |     | NULL    |                |
| eu_page_id   | int(11)        | NO   | MUL | NULL    |                |
+--------------+----------------+------+-----+---------+----------------+
4 rows in set (0.001 sec)

MariaDB [default]> show index from wbc_entity_usage;
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name     | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wbc_entity_usage |          0 | PRIMARY      |            1 | eu_row_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            1 | eu_entity_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            2 | eu_aspect    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          0 | eu_entity_id |            3 | eu_page_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          1 | eu_page_id   |            1 | eu_page_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wbc_entity_usage |          1 | eu_page_id   |            2 | eu_entity_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.000 sec)