On Nov 20 2009, Platonides wrote:
Zeyi wrote:
I took the sub-current data from MediaWiki and import them to Oracle.
Which tool did you use for the import?
I used xml2sql tool, which is easy to use.
I found there are two same page_latest ID in the page table. Then when I tried to join Revision table and Page table together, this caused two same rev_id.
Which pages are those?
kinds of every pages, is that page_latest ID unique?
May I ask why I have two page_latest on page table, what it mean? If I want to put Revision table and Page table together, which should be the link point?
You shouldn't have that situation. And why are you merging page and revision, anyway?
I need use rev_user and page_namespace to do crossing-analysis. How i can put them in the one table? thanks again.
thanks, Zeyi
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l