Hello,
I played a little bit with the (german) old_table (from 20040305) and have some questions about it.
1. As I understand the first entry of each row, this is an id, incremented for each new row. since there are missing some of the numbers, I assume that this are rows, which was deleted. Is this right?
2. There is a column timestamp and a column inverse timestamp. For what reason we need the inverse timestamp?
There also seems to be an inconsistency. The entry with the id 494209 (article about "Optik" in namespace 0 has timestamp "20031231041409" but inverse timestamp "80008783828360". May this is a new-year-bug? May this should be corrected manually?!
3. Which namespace is represented by which of the numbers 0 till 9?
4. The column for the "user-comment" in the begining contains often '*' but later nothing. Was it just the behaviour of the old software to represent no comment by '*'?
5. The column for the "user_id" in the beginning contains just 0, even for well-known users. later (after conversion_script appears) the correct id is printed. The column for the "user_name" has the same strange behaviour. It contains dns-names instead of IP-adresses. Was this the behaviour of the old software?
6. The coulumn "old_flags" seems to contain nothing. (its almost always empty, but contains one/sometimes '0'). Whats the application of this column? What flags does it contain?
--Ivo Köthnig
wikitech-l@lists.wikimedia.org