Last modified: 2006-09-19 14:02:05 UTC
There are a number of cases when one wants to produce a list of articles in a category ordered by the time articles entered the category (for example, this has been recently done on en: for articles that are "deleted-protected"). This is done using the cl_timestamp field of the categorylinks table. However, this field is also updated every time the article is moved. In my view, this should be only the time the article entered the category, as the other data (the last time the page was moved) can be retrieved separately from the logging table.
The field is updated whenever the table is.
So, I presume the behaviour is this way because the software needs so. In other words, if ordering categories that way is really needed, a new field to the table should be added. Is this correct?
