Don't forget ipb_deleted. Eventually that should require Oversight access to view things flagged with that.

-Aaron Schulz

> Date: Mon, 5 Nov 2007 16:57:13 -0500
> From: gmaxwell@gmail.com
> To: toolserver-l@lists.wikimedia.org
> Subject: [Toolserver-l] ipblocks table available
>
> I have created a view for the ipblocks table. This view hides private
> data related to autoblocks.
>
> There were two possible ways that I could have created this view. I
> could have created so that it hides all autoblocks, or I could have
> created it so that it only hides the private data in autoblocks.
>
> The second choice is obviously more flexible, but it prevents the use
> of indexes on the ip address columns (ipb_address, ipb_range_start,
> ipb_range_end).
>
> Because the ipblocks tables are fairly small (even on large projects
> like enwiki) and because some tools already do things with autoblocks,
> I have decided to choose this slower option.
>
> If we have performance problems related to this view, I will change
> the it to the first type without any autoblocks, and potentially
> provide a second autoblocks only view for tools that need to see the
> autoblocks.
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l@lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l

---

Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now!