Topic on Project:Village Pump

done. Thanks.

Hi all, I am trying solving now the RED LINKS links in Extension box of => https://www.mediawiki.org/wiki/Extension:CentralNotice related to missing table pages. I try to match the both table lists I have. Here they are with correspondance of indexes.

As described in => Extension:CentralNotice/Database_schema

    1 cn_notices                  = [table1] => ok
    2 cn_assignments              = [table2] => ok
    3 cn_templates                = [table3] => ok
    4 cn_notice_languages         = [table4] => ok
    5 cn_notice_projects          = [table5] => ok
    6 cn_notice_countries         = [table6] => ok
    7 cn_known_mixins       => ??
    8 cn_template_mixins          = [table7] => ok
    9 cn_template_messages  => ??
    10 cn_known_mobile_carriers   = [table12] => ok
    11 cn_notice_mobile_carriers  = [table13] => ok
    12 cn_notice_log              = [table14] => ok
    13 cn_template_log            = [table15] => ok

As described in Extension box => Extension:CentralNotice

|table1  = cn_notices                = [1] => ok 
|table2  = cn_assignments            = [2] => ok 
|table3  = cn_templates              = [3] => ok
|table4  = cn_notice_languages       = [4] => ok 
|table5  = cn_notice_projects        = [5] => ok 
|table6  = cn_notice_countries       = [6] => ok 
|table7  = cn_template_mixins        = [8] => ok
|table8  = cn_notice_mixins       => ??
|table9  = cn_notice_mixin_params => ??
|table10 = cn_known_devices       => ??
|table11 = cn_template_devices    => ??
|table12 = cn_known_mobile_carriers  = [10] => ok
|table13 = cn_notice_mobile_carriers = [11] => ok
|table14 = cn_notice_log             = [12] => ok 
|table15 = cn_template_log           = [13] => ok

So Database_schema describes 13 items, and the Extension box describes 15 tables.
Mismatches:
Two tables of the Database_schema are not in the box :

 
    7 cn_known_mixins        => ?? 
    9 cn_template_messages   => ?? 

Question 1: are these tables still used ? and should they be added in the box as items table16 table 17 ?
Then four tables in the box are not in the Database_schema :

|table8  = cn_notice_mixins       => ??
|table9  = cn_notice_mixin_params => ??
|table10 = cn_known_devices       => ??
|table11 = cn_template_devices    => ?? 

Question 2: are these tables really used ? and if yes how can I get their layout ?
Thanks.

Christian FR (talk) 21:16, 30 November 2019 (UTC)

The current table definitions should be in the CentralNotice.sql file.

Thank you very much; from this I extract 15 actual tables and their informations inside :

CREATE TABLE IF NOT EXISTS /*_*/cn_notices (
CREATE TABLE IF NOT EXISTS /*_*/cn_assignments (
CREATE TABLE IF NOT EXISTS /*_*/cn_templates (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_languages (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_projects (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_countries (
CREATE TABLE IF NOT EXISTS /*_*/cn_template_mixins (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_mixins (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_mixin_params (
CREATE TABLE IF NOT EXISTS /*_*/cn_known_devices (
CREATE TABLE IF NOT EXISTS /*_*/cn_template_devices (
CREATE TABLE IF NOT EXISTS /*_*/cn_known_mobile_carriers (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_mobile_carriers (
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_log (
CREATE TABLE IF NOT EXISTS /*_*/cn_template_log (

Shirayuki can you please provide the "mysql> describe cn_notice_mixin_params;" instead of "mysql> describe cn_notice_mixins;" in => https://www.mediawiki.org/wiki/Extension:CentralNotice/cn_notice_mixin_params_table

Thank you for replying when the request is done such as I could close the topic.