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.
