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?