See also https://phabricator.wikimedia.org/T54919

On Tue, Apr 7, 2015 at 1:54 PM, Daniel Barrett danb@cimpress.com wrote:

Will anything bad happen if entries in the MediaWiki "logging" table are not inserted in chronological order?

Due to a bug, our logging table has incomplete data. I'd like to insert the missing data using a script. However, the log_id column is auto-increment. This means that when the table is ordered by log_id, the data will not be in chronological order by log_timestamp.

Is that bad in any way? Or are all applications (like Special:Log) expected to "order by log_timestamp" rather than log_id?

Thanks, Dan

---

Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

On Apr 7, 2015 1:54 PM, "Daniel Barrett" danb@cimpress.com wrote:

Will anything bad happen if entries in the MediaWiki "logging" table are

not inserted in chronological order?

Due to a bug, our logging table has incomplete data. I'd like to insert

the missing data using a script.

However, the log_id column is auto-increment. This means that when the

table is ordered by log_id,

the data will not be in chronological order by log_timestamp.

Is that bad in any way? Or are all applications (like Special:Log) expected to "order by

log_timestamp" rather than log_id?

Thanks, Dan

---

Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

It should be fine.

--bawolff