On Sat, Dec 23, 2017 at 10:03 PM, Martin Domdey <animalia@gmx.net> wrote:
> Hi!
>
> Does anybody now, what a database table contains a column containing all the
> interwiki languages existing like 'dewiki', 'enwiki' , 'frwiki', ...
The meta_p `wiki` table may be what you are looking for:
$ sql meta
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 25438936
Server version: 10.1.29-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
(u3518@s7.labsdb) [meta_p]> describe wiki;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| dbname | varchar(32) | NO | PRI | NULL | |
| lang | varchar(12) | NO | | en | |
| name | text | YES | | NULL | |
| family | text | YES | | NULL | |
| url | text | YES | | NULL | |
| size | decimal(1,0) | NO | | 1 | |
| slice | text | NO | | NULL | |
| is_closed | decimal(1,0) | NO | | 0 | |
| has_echo | decimal(1,0) | NO | | 1 | |
| has_flaggedrevs | decimal(1,0) | NO | | 0 | |
| has_visualeditor | decimal(1,0) | NO | | 0 | |
| has_wikidata | decimal(1,0) | NO | | 0 | |
| is_sensitive | decimal(1,0) | NO | | 0 | |
+------------------+--------------+------+-----+---------+-------+
13 rows in set (0.00 sec)
(u3518@s7.labsdb) [meta_p]> select * from wiki where dbname='enwiki'\G
*************************** 1. row ***************************
dbname: enwiki
lang: en
name: Wikipedia
family: wikipedia
url:
https://en.wikipedia.org
size: 3
slice: s1.labsdb
is_closed: 0
has_echo: 1
has_flaggedrevs: 1
has_visualeditor: 1
has_wikidata: 1
is_sensitive: 0
1 row in set (0.00 sec)
Bryan
--
Bryan Davis Wikimedia Foundation <bd808@wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA
irc: bd808 v:415.839.6885 x6855
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud