Jump to content

Tool:PBbot

From Wikitech
Toolforge tools
PBbot Tools
Website https://pbbot.toolforge.org/
Description A collection of tools for plwiktionary and others.
Keywords bot, web tools, plwiktionary, eswiktionary, plwiki
Author(s) Peter Bowmantalk
Maintainer(s) Peter Bowman, Alkamid (View all)
Source code https://github.com/PeterBowman/wikibot
License GNU General Public License 3.0
Issues GitHub
Admin log Nova Resource:Tools.pbbot/SAL

Database layout (tools.db)

https://tool-db-usage.toolforge.org/owner/s52584

s52584__eswikt_anagrams (unused)

DESCRIBE normalized;

+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| title_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| from     | varchar(255)     | NO   |     | NULL    |                |
| to       | varchar(255)     | NO   |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+

s52584__plwikt_common

DESCRIBE execution_log;

+-----------+-------------+------+-----+-------------------+-------+
| Field     | Type        | Null | Key | Default           | Extra |
+-----------+-------------+------+-----+-------------------+-------+
| type      | varchar(45) | NO   | PRI | NULL              |       |
| timestamp | timestamp   | NO   |     | CURRENT_TIMESTAMP |       |
+-----------+-------------+------+-----+-------------------+-------+

DESCRIBE morfeo;

+----------+-----------------------+------+-----+---------+----------------+
| Field    | Type                  | Null | Key | Default | Extra          |
+----------+-----------------------+------+-----+---------+----------------+
| id       | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| title    | varchar(255)          | NO   | MUL | NULL    |                |
| morphem  | varchar(255)          | NO   | MUL | NULL    |                |
| position | tinyint(3) unsigned   | NO   |     | NULL    |                |
| type     | tinyint(3) unsigned   | NO   |     | NULL    |                |
+----------+-----------------------+------+-----+---------+----------------+

s52584__plwikt_verify_citations

DESCRIBE all_changes; (VIEW)

+-------------------+-----------------------+------+-----+---------------------+-------+
| Field             | Type                  | Null | Key | Default             | Extra |
+-------------------+-----------------------+------+-----+---------------------+-------+
| entry_id          | mediumint(8) unsigned | NO   |     | 0                   |       |
| page_id           | mediumint(8) unsigned | NO   |     | NULL                |       |
| page_title        | varchar(255)          | NO   |     | NULL                |       |
| language          | varchar(50)           | NO   |     | NULL                |       |
| field_id          | tinyint(3) unsigned   | NO   |     | 0                   |       |
| field_localized   | varchar(35)           | NO   |     | NULL                |       |
| source_text       | varchar(4095)         | NO   |     | NULL                |       |
| edited_text       | varchar(4095)         | NO   |     | NULL                |       |
| current_change_id | mediumint(8) unsigned | NO   |     | NULL                |       |
| change_log_id     | mediumint(8) unsigned | NO   |     | NULL                |       |
| editor            | varchar(255)          | NO   |     | @generated          |       |
| change_timestamp  | timestamp             | NO   |     | 0000-00-00 00:00:00 |       |
| is_pending        | int(1)                | NO   |     | 0                   |       |
| review_log_id     | mediumint(8) unsigned | YES  |     | 0                   |       |
| review_status     | bit(1)                | YES  |     | NULL                |       |
| reviewer          | varchar(255)          | YES  |     | NULL                |       |
| review_timestamp  | timestamp             | YES  |     | 0000-00-00 00:00:00 |       |
+-------------------+-----------------------+------+-----+---------------------+-------+

DESCRIBE all_entries; (VIEW)

+-------------------+-----------------------+------+-----+---------------------+-------+
| Field             | Type                  | Null | Key | Default             | Extra |
+-------------------+-----------------------+------+-----+---------------------+-------+
| entry_id          | mediumint(8) unsigned | NO   |     | 0                   |       |
| page_id           | mediumint(8) unsigned | NO   |     | NULL                |       |
| page_title        | varchar(255)          | NO   |     | NULL                |       |
| language          | varchar(50)           | NO   |     | NULL                |       |
| field_id          | tinyint(3) unsigned   | NO   |     | 0                   |       |
| field_localized   | varchar(35)           | NO   |     | NULL                |       |
| source_text       | varchar(4095)         | NO   |     | NULL                |       |
| edited_text       | varchar(4095)         | NO   |     | NULL                |       |
| current_change_id | mediumint(8) unsigned | NO   |     | NULL                |       |
| editor            | varchar(255)          | NO   |     | @generated          |       |
| change_timestamp  | timestamp             | NO   |     | 0000-00-00 00:00:00 |       |
| is_pending        | int(1)                | NO   |     | 0                   |       |
| review_log_id     | mediumint(8) unsigned | YES  |     | 0                   |       |
| review_status     | bit(1)                | YES  |     | NULL                |       |
| reviewer          | varchar(255)          | YES  |     | NULL                |       |
| review_timestamp  | timestamp             | YES  |     | 0000-00-00 00:00:00 |       |
+-------------------+-----------------------+------+-----+---------------------+-------+

DESCRIBE change_log;

+------------------+-----------------------+------+-----+-------------------+-------+
| Field            | Type                  | Null | Key | Default           | Extra |
+------------------+-----------------------+------+-----+-------------------+-------+
| change_log_id    | mediumint(8) unsigned | NO   | PRI | NULL              |       |
| entry_id         | mediumint(8) unsigned | NO   | MUL | NULL              |       |
| user             | varchar(255)          | NO   | MUL | @generated        |       |
| change_timestamp | timestamp             | NO   |     | CURRENT_TIMESTAMP |       |
+------------------+-----------------------+------+-----+-------------------+-------+

DESCRIBE edit_log;

+----------------+-----------------------+------+-----+-------------------+----------------+
| Field          | Type                  | Null | Key | Default           | Extra          |
+----------------+-----------------------+------+-----+-------------------+----------------+
| edit_log_id    | mediumint(8) unsigned | NO   | PRI | NULL              | auto_increment |
| change_log_id  | mediumint(8) unsigned | NO   | MUL | NULL              |                |
| rev_id         | int(10) unsigned      | NO   | UNI | NULL              |                |
| edit_timestamp | timestamp             | NO   |     | CURRENT_TIMESTAMP |                |
+----------------+-----------------------+------+-----+-------------------+----------------+

DESCRIBE edited_line;

+----------------+-----------------------+------+-----+---------+----------------+
| Field          | Type                  | Null | Key | Default | Extra          |
+----------------+-----------------------+------+-----+---------+----------------+
| edited_line_id | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| edited_text    | varchar(4095)         | NO   |     | NULL    |                |
+----------------+-----------------------+------+-----+---------+----------------+

DESCRIBE entry;

+----------------+-----------------------+------+-----+---------+----------------+
| Field          | Type                  | Null | Key | Default | Extra          |
+----------------+-----------------------+------+-----+---------+----------------+
| entry_id       | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| page_id        | mediumint(8) unsigned | NO   | MUL | NULL    |                |
| language       | varchar(50)           | NO   |     | NULL    |                |
| field_id       | tinyint(3) unsigned   | NO   | MUL | NULL    |                |
| source_line_id | mediumint(8) unsigned | NO   | MUL | NULL    |                |
| edited_line_id | mediumint(8) unsigned | NO   | MUL | NULL    |                |
+----------------+-----------------------+------+-----+---------+----------------+

DESCRIBE field;

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| field_id   | tinyint(3) unsigned | NO   | PRI | NULL    | auto_increment |
| field_name | varchar(25)         | NO   | UNI | NULL    |                |
| localized  | varchar(35)         | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

DESCRIBE line;

+-----------+-----------------------+------+-----+---------+----------------+
| Field     | Type                  | Null | Key | Default | Extra          |
+-----------+-----------------------+------+-----+---------+----------------+
| line_id   | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| text      | varchar(4095)         | NO   |     | NULL    |                |
| user      | varchar(255)          | YES  |     | NULL    |                |
| timestamp | varchar(14)           | NO   |     | NULL    |                |
+-----------+-----------------------+------+-----+---------+----------------+

DESCRIBE page_title;

+------------+-----------------------+------+-----+---------+-------+
| Field      | Type                  | Null | Key | Default | Extra |
+------------+-----------------------+------+-----+---------+-------+
| page_id    | mediumint(8) unsigned | NO   | PRI | NULL    |       |
| page_title | varchar(255)          | NO   | MUL | NULL    |       |
+------------+-----------------------+------+-----+---------+-------+

DESCRIBE pending;

+----------+-----------------------+------+-----+---------+-------+
| Field    | Type                  | Null | Key | Default | Extra |
+----------+-----------------------+------+-----+---------+-------+
| entry_id | mediumint(8) unsigned | NO   | PRI | NULL    |       |
+----------+-----------------------+------+-----+---------+-------+

DESCRIBE review_log;

+------------------+-----------------------+------+-----+-------------------+----------------+
| Field            | Type                  | Null | Key | Default           | Extra          |
+------------------+-----------------------+------+-----+-------------------+----------------+
| review_log_id    | mediumint(8) unsigned | NO   | PRI | NULL              | auto_increment |
| edited_line_id   | mediumint(8) unsigned | NO   | MUL | NULL              |                |
| user             | varchar(255)          | NO   | MUL | NULL              |                |
| review_status    | bit(1)                | NO   |     | NULL              |                |
| review_timestamp | timestamp             | NO   |     | CURRENT_TIMESTAMP |                |
+------------------+-----------------------+------+-----+-------------------+----------------+

DESCRIBE reviewed;

+---------------+-----------------------+------+-----+---------+-------+
| Field         | Type                  | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------+-------+
| entry_id      | mediumint(8) unsigned | NO   | PRI | NULL    |       |
| review_log_id | mediumint(8) unsigned | NO   | MUL | NULL    |       |
+---------------+-----------------------+------+-----+---------+-------+

DESCRIBE source_line;

+----------------+-----------------------+------+-----+---------+----------------+
| Field          | Type                  | Null | Key | Default | Extra          |
+----------------+-----------------------+------+-----+---------+----------------+
| source_line_id | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| source_text    | varchar(4095)         | NO   |     | NULL    |                |
+----------------+-----------------------+------+-----+---------+----------------+

See also