Hello,
I'm asking why not all tables are replicated? Of course I don't mean
user data - one of recent MediaWiki update introduced new table -
page_restrictions. It means that page_restrictions field from page
table is no more used. Lack of this table prevents me from writing a
tool which will list all protected pages in Wikipedia. It would be
helpful because special page Protectedpages
(
http://pl.wikipedia.org/wiki/Specjalna:Protectedpages) doesn't work.
Localhost:
mysql> select * from page_restrictions;
+---------+---------+----------+------------+---------+-----------+
| pr_page | pr_type | pr_level | pr_cascade | pr_user | pr_expiry |
+---------+---------+----------+------------+---------+-----------+
| 1 | edit | sysop | 1 | NULL | infinity |
| 1 | move | sysop | 1 | NULL | infinity |
+---------+---------+----------+------------+---------+-----------+
Hemlock:
mysql> select * from page_restrictions;
ERROR 1146 (42S02): Table 'plwiki_p.page_restrictions' doesn't exist
--
Dodek Dodecki
<dodekam[at]gmail.com>