Last modified: 2007-01-10 23:42:43 UTC
I propose moving the page restrictions field to its own table, which would
behave in a relational fashion, e.g. fields for protectionid(int11, pri,
auto-inc), userid(int 11), protected(int 1) etc.
Wow, was I pissed when I wrote that schema? Anyway, still think this is
relevant. We'd want a field to correspond to the page_id, also, fields for edit
and move (corresponding to the names of groups required, obviously). Adding a
user field might be handy if we want to implement that suggestion to allow
preventing certain users from editing specific pages that's knocking around.
Indexing might be an idea, but indexes aren't my thing, so someone else can
suggest those. ;-)
This could also be used to dynamically update [[Wikipedia:Protected pages]] (or
even better, create a new Special page, [[Special:Protectedlist]], akin to
[[Special:Ipblocklist]]). and it would also solve the problem of lazy sysops not
updating manual logs.
Fixed in r19044, needs a branch merge and scap.
It's not fixed until it's in trunk. Plus, it's not even quite done in branch.
Fixed in r19095.