[Wikidata-bugs] [Maniphest] [Commented On] T162252: Create SQL database and Tables for Cognate extension to be used on Wiktionaries

[Addshore]

Addshore added a comment.

All looks good

> addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="SHOW TABLES;"
stdClass Object
(
    [Tables_in_cognate_wiktionary] => cognate_pages
)
stdClass Object
(
    [Tables_in_cognate_wiktionary] => cognate_sites
)
stdClass Object
(
    [Tables_in_cognate_wiktionary] => cognate_titles
)
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="DESCRIBE cognate_pages;"
stdClass Object
(
    [Field] => cgpa_site
    [Type] => bigint(20)
    [Null] => NO
    [Key] => PRI
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgpa_namespace
    [Type] => int(11)
    [Null] => NO
    [Key] => PRI
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgpa_title
    [Type] => bigint(20)
    [Null] => NO
    [Key] => PRI
    [Default] =>
    [Extra] =>
)
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="DESCRIBE cognate_sites;"
stdClass Object
(
    [Field] => cgsi_key
    [Type] => bigint(20)
    [Null] => NO
    [Key] => PRI
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgsi_dbname
    [Type] => varbinary(32)
    [Null] => NO
    [Key] =>
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgsi_interwiki
    [Type] => varbinary(32)
    [Null] => NO
    [Key] =>
    [Default] =>
    [Extra] =>
)
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="DESCRIBE cognate_titles;"
stdClass Object
(
    [Field] => cgti_raw
    [Type] => varbinary(255)
    [Null] => NO
    [Key] =>
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgti_raw_key
    [Type] => bigint(20)
    [Null] => NO
    [Key] => PRI
    [Default] =>
    [Extra] =>
)
stdClass Object
(
    [Field] => cgti_normalized_key
    [Type] => bigint(20)
    [Null] => NO
    [Key] => MUL
    [Default] =>
    [Extra] =>
)
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="SELECT * FROM cognate_titles;"
Query OK, 0 row(s) affected
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="SELECT * FROM cognate_pages;"
Query OK, 0 row(s) affected
addshore@tin:~$ mwscript sql.php --wiki=enwiktionary --cluster=extension1 --replicadb=any --wikidb=cognate_wiktionary --query="SELECT * FROM cognate_sites;"
Query OK, 0 row(s) affected

TASK DETAIL

https://phabricator.wikimedia.org/T162252

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui, Addshore
Cc: Liuxinyu970226, jcrespo, Marostegui, Lydia_Pintscher, Aklapper, Lea_Lacroix_WMDE, Addshore, QZanden, Salgo60, Minhnv-2809, Urbanecm, Izno, Luke081515, Wikidata-bugs, aude, GPHemsley, Darkdadaah, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs