>>! In T299800#7668611, @Umherirrender wrote:
>>>! In T299800#7648691, @Urbanecm wrote:
>> For posterity, there is how the table looks at one of the enwiki production DB replicas:
>>
>> ```
>> wikiadmin@10.64.32.13(enwiki)> show create table wikilove_log\G
>> *************************** 1. row ***************************
>> Table: wikilove_log
>> Create Table: CREATE TABLE `wikilove_log` (
>> `wll_id` int(11) NOT NULL AUTO_INCREMENT,
>> `wll_timestamp` binary(14) NOT NULL,
>> `wll_sender` int(11) NOT NULL,
>> `wll_sender_registration` binary(14) DEFAULT NULL,
>> `wll_sender_editcount` int(11) DEFAULT NULL,
>> `wll_receiver` int(11) NOT NULL,
>> `wll_receiver_registration` binary(14) DEFAULT NULL,
>> `wll_receiver_editcount` int(11) DEFAULT NULL,
>> `wll_type` varbinary(64) NOT NULL,
>> `wll_subject` varbinary(255) NOT NULL,
>> `wll_message` blob NOT NULL,
>> `wll_email` tinyint(1) NOT NULL DEFAULT 0,
>> PRIMARY KEY (`wll_id`),
>> KEY `wll_timestamp` (`wll_timestamp`),
>> KEY `wll_type_time` (`wll_type`,`wll_timestamp`),
>> KEY `wll_sender_time` (`wll_sender`,`wll_timestamp`),
>> KEY `wll_receiver_time` (`wll_receiver`,`wll_timestamp`)
>> ) ENGINE=InnoDB AUTO_INCREMENT=153645 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED
>> 1 row in set (0.000 sec)
>> ```
>>
>> It indeeds appears to be different from what's in the repo now.
>
> Thanks for the definition, it missed the unsigned on two columns as done back in 2016 at https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/WikiLove/+/7d61821685181b8c97a4df9d988495ab25a3b04f%5E%21/patches/WikiLoveLog.sql
```lang=sql
ALTER TABLE /*_*/wikilove_log
CHANGE wll_sender wll_sender INT UNSIGNED NOT NULL,
CHANGE wll_receiver wll_receiver INT UNSIGNED NOT NULL;
```
# **ALTERs to run:** there is no commited alter, but see above
# **Where to run those changes:** wikis with wikilove - https://gerrit.wikimedia.org/g/operations/mediawiki-config/+/c73f08d501443801d839703ccb92b9cf7405523b/wmf-config/InitialiseSettings.php#17595
[] s1
[x] s2
[x] s3
[x] s4
[x] s5
[x] s6
[x] s7
# **When to run those changes:** any time
# **If the schema change is backwards compatible:** Yes
# **If the schema change has been tested already on some of the test/beta wikis:** Tested in beta cluster.
# **if the data should be made available on the labs replicas and/or dumps:** no change of the existing rules