Manual talk:User newtalk table

Interwiki newtalk

I'm thinking that it might not be hard to write an extension to implement interwiki newtalk, if another table were added to store other data (e.g. which wiki the new messages are at) and the user_newtalk table were shared. Leucosticte (talk) 10:26, 26 September 2012 (UTC)

user_newtalk.user_id

It seems like this column should be changed as follows, for consistency (and speedy join-ability) with user.user_id:

alter table user_newtalk change column user_id user_id int(10) unsigned NOT NULL;

Another more minor note about this table, if it's being modified any time soon: prefixing the column names with something like unt_* seems like it would match the rest of the schema better.

Rs561 (talk) 00:40, 8 December 2014 (UTC)

I've created task T77005 for the data type. I don't think the fields would be renamed, since it would require changing some queries and it may break installations with shared tables, but feel free to create a new task for this if you like. --Ciencia Al Poder (talk) 11:52, 8 December 2014 (UTC)

In current versions the field is now int(10) unsigned.

What is still missing is the renaming. It would in fact be better for consistency. --87.123.60.3 13:54, 18 February 2016 (UTC)