:User talk:Kku#Overlinking/bot-like editing

Hi, I've started a drive to get users to multi-license all of their contributions that they've made to either (1) all U.S. state, county, and city articles or (2) all articles, using the Creative Commons Attribution-Share Alike (CC-by-sa) v1.0 and v2.0 Licenses or into the public domain if they prefer. The CC-by-sa license is a true free documentation license that is similar to Wikipedia's license, the GFDL, but it allows other projects, such as WikiTravel, to use our articles. Since you are among the top 2000 Wikipedians by edits, I was wondering if you would be willing to multi-license all of your contributions or at minimum those on the geographic articles. Over 90% of people asked have agreed. For More Information:

• 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 Template messages/User namespace. The following examples could also copied and pasted into your user page:

:Option 1

:I agree to multi-license all my contributions, with the exception of my user pages, as described below:

:{{DualLicenseWithCC-BySA-Dual}}

OR

:Option 2

:I agree to 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 GFDL, I would like to know that too. Please let me know what you think at my talk page. It's important to know either way so no one keeps asking. -- Ram-Man ([http://en.wikipedia.org/w/wiki.phtml?title=User_talk:Ram-Man&action=edit§ion=new comment]| talk)

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.

{{bots|deny=DPL bot}}

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)

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)

: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)

::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)

:::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)

::::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)

:::::This appears quite unambiguous: Using SQL from [https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column 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)