User talk:Kku

Hi, I've

• Multi-Licensing FAQ - Lots of questions answered
• Multi-Licensing Guide
• Free the Rambot Articles Project

To allow us to track those users who muli-license their contributions, many users copy and paste the "{{DualLicenseWithCC-BySA-Dual}}" template into their user page, but there are other options at

Option 1

I agree to [[Wikipedia:Multi-licensing|multi-license]] all my contributions, with the exception of my user pages, as described below:

{{DualLicenseWithCC-BySA-Dual}}

OR

Option 2

I agree to [[Wikipedia:Multi-licensing|multi-license]] all my contributions to any [[U.S. state]], county, or city article as described below:

{{DualLicenseWithCC-BySA-Dual}}

Or if you wanted to place your work into the public domain, you could replace "{{DualLicenseWithCC-BySA-Dual}}" with "{{MultiLicensePD}}". If you only prefer using the

Hi. Thank you for your recent edits. Wikipedia appreciates your help. We noticed though that when you edited Spring Web Flow, you added a link pointing to the disambiguation page MVC (check to confirm | fix with Dab solver). Such links are almost always unintended, since a disambiguation page is merely a list of "Did you mean..." article titles. Read the FAQ • Join us at the DPL WikiProject.

Maybe you edit on forestry was small but as it was fairly recent and I am struggling to get comments from that wikiproject perhaps you would like to comment on https://en.wikipedia.org/wiki/Talk:Ecoforestry#Merge_proposal

Hello, User Kku,

Since you know about MySQL and Wikipedia, I hope you will help me to determine whether or not schema Enwiki has foreign keys.

The DDL code of schema Enwiki from the available sources (examples below) does not include any declarations of foreign keys. Does it mean no foreign keys are formally defined in the schema structure?

https://phabricator.wikimedia.org/source/mediawiki/browse/master/sql/mysql/tables-generated.sql

https://gerrit.wikimedia.org/g/mediawiki/core/%2B/HEAD/sql/mysql/tables-generated.sql

On the other hand, the documentation of the tables in schema enwiki specifies in many places (examples below) that certain columns are foreign keys referencing other tables. Does it mean those foreign keys are formally declared in the schema structure (DDL)?

page "https://www.mediawiki.org/wiki/Manual:Revision_table#Fields", column "rev_comment_id".

page "https://www.mediawiki.org/wiki/Manual:Categorylinks_table#Fields", column "cl_collation_id".

So, are there formal foreign keys in the schema that underlies Wikipedia?

Thank you in advance for your thoughts.

Ion Soggo (talk) 16:02, 10 June 2025 (UTC)[reply]

P.S. I put my question, by mistake, in Wikiversity. I intended to write it here. Ion Soggo (talk) 16:02, 10 June 2025 (UTC)[reply]

Hummm... Your question is rather wide-scoped. I can check my local mediawiki installation at home in order to have a look. A purely theoretical approach does not appear promising. Give me a few days, pls. -- Kku (talk) 12:42, 11 June 2025 (UTC)[reply]

Thank you. I look forward to your response. I thought my question was rather simple: Are there foreign keys, yes or no. Ion Soggo (talk) 15:23, 11 June 2025 (UTC)[reply]

When you put it like this, it's almost too trivial. But it really depends on whether foreign key constraints are only declared or rather: enforced, and to which degree, you know. -- Kku (talk) 16:39, 11 June 2025 (UTC)[reply]

Are the foreign keys in Enwiki declared? If so, I would expect to see statements similar to:

ALTER TABLE actor

ADD CONSTRAINT actor_user_FK1

FOREIGN KEY(actor_user)

REFERENCES user(user_id);

Ion Soggo (talk) 20:35, 11 June 2025 (UTC)[reply]

This appears quite unambiguous: Using SQL from this stackoverflow question on my mediawiki installation (select database() will yield 'mediawiki' which is the correct one):

        SELECT 
          TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
        FROM
          INFORMATION_SCHEMA.KEY_COLUMN_USAGE
        WHERE
           REFERENCED_TABLE_SCHEMA = (SELECT DATABASE())
         Empty set (0.008 sec)

Fascinating. -- Kku (talk) 11:58, 20 June 2025 (UTC)[reply]

Hi Kku,

I’m reaching out as I saw you recently edited the Investcorp page. I was wondering given your recent update whether you would be interested in reviewing the further detail I have added to the Investcorp talk page? For context, I work at Kekst CNC a global communications agency that works with Investcorp to manage its communications. The agency has signed the Wikipedia:Statement on Wikipedia from participating communications firms, which means I understand rules around COI on the platform.

I would really appreciate your review of our suggested edits, and would be grateful if you consider adding some of the edits I’ve suggested to the page.

Any questions or feedback you have would be much appreciated too! AmeliaP KCNC (talk) 14:49, 1 July 2025 (UTC)[reply]