Jonathan Walther wrote:
What if there were no "broken links", only
articles that had no text?
ie, the text field would be NULL?
No, "broken links" are links to articles that don't exist at all, not to
"blank" articles.
Hm. Maybe images could be collapsed into the
"cur" table too.
But they have special properties, which would have to be blank in every
"normal" article. Also, searches etc. would be slower.
I think we could reduce to the following tables:
current_articles, previous_articles, deleted_articles, links
Then we could drop deleted_articles as well, just set some "cur_deleted"
tag in "current_articles".
But, you'll be the one to change every line of source code for that, I
guess...
We just add a "type" field to the articles
tables to indicate "wiki
text" or "image"; this gives us flexibility to support other types of
object too.
"image" is already used for other files (e.g., ogg).
What is a "good article"? What uses that
table? What would happen if
it went away?
A "good article" contains at least a comma...
Ah. Oddly enough, I would recommend splitting that out
into two tables,
each containing just user ids; one called "developers", and the other
"sysops".
OK, but why bother? Seems to work, and saves some queries.
Magnus