Last modified: 2014-03-09 03:26:07 UTC
There's currently no way to easily get the creator of a page. This makes it difficult to write reports about who wrote the most articles or make a list of the pages a person created. I think it'd be nice to have a page_creator column in the page table to track who has created a page. It'll have some edge cases like page moves, but I think this is acceptable. So this would have four pieces, I guess: * add a page_creator column to the page table (255 bytes, has to support anon page creations); * add an index to this column (so that you can sort by user); * write a maintenance script to populate this column; and * fix up Extension:RenameUser to make sure it accounts for this column in user renames.
Another solution is to log the creation of pages on Special:Log (bug 10331).
Or we could store the first revision.
(In reply to comment #2) > Or we could store the first revision. Store the first revision? You mean a separate table that just stores the data from revision, but limited to the first revision only?
Store the first revision's ID? Then you can go look up the ID. Actually maybe you could do something like this instead: select rev_user from revision where rev_parent_id=0 and rev_page=$pageid
(In reply to comment #2) > Or we could store the first revision. Okay, let's index the first revision. It should be simple enough to add a page_first column (or similar) to complement page_latest.
(In reply to MZMcBride from comment #0) > There's currently no way to easily get the creator of a page. This makes it > difficult to write reports about who wrote the most articles or make a list > of the pages a person created. FYI, the latter can be done with rev_parent_id=0 and the username in the where clause.