@Peter: Please do not make fullquotes, thanks!
Why?
http://www.netmeister.org/news/learn2quote2.html#ss2.5
Do you have any idea
of how sensitive this might be to future upgrades and changes in the
database model?
Being not "in the team" (developement), I have absolutly no clue.
Does the page_restrictions table structure tend to
change very much?
IMHO they do not change often.
============================
Version 1.11.0:
CREATE TABLE mw_page_restrictions (
pr_page int(11) NOT NULL,
pr_type varbinary(60) NOT NULL,
pr_level varbinary(60) NOT NULL,
pr_cascade tinyint(4) NOT NULL,
pr_user int(11) default NULL,
pr_expiry varbinary(14) default NULL,
pr_id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (pr_page,pr_type),
UNIQUE KEY pr_id (pr_id),
KEY pr_typelevel (pr_type,pr_level),
KEY pr_level (pr_level),
KEY pr_cascade (pr_cascade)
) TYPE=MyISAM;
Version 1.13.3:
CREATE TABLE www_page_restrictions (
pr_page int(11) NOT NULL,
pr_type varbinary(60) NOT NULL,
pr_level varbinary(60) NOT NULL,
pr_cascade tinyint(4) NOT NULL,
pr_user int(11) default NULL,
pr_expiry varbinary(14) default NULL,
pr_id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (pr_page,pr_type),
UNIQUE KEY pr_id (pr_id),
KEY pr_typelevel (pr_type,pr_level),
KEY pr_level (pr_level),
KEY pr_cascade (pr_cascade)
) TYPE=MyISAM ;
Version 1.15.1:
CREATE TABLE lamp_page_restrictions (
pr_page int(11) NOT NULL,
pr_type varbinary(60) NOT NULL,
pr_level varbinary(60) NOT NULL,
pr_cascade tinyint(4) NOT NULL,
pr_user int(11) default NULL,
pr_expiry varbinary(14) default NULL,
pr_id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (pr_page,pr_type),
UNIQUE KEY pr_id (pr_id),
KEY pr_typelevel (pr_type,pr_level),
KEY pr_level (pr_level),
KEY pr_cascade (pr_cascade)
) TYPE=MyISAM;
============================
I do not see a difference over the last few month. I installed
- mediawiki-1.11.0.tar.gz: 2008-01-03
- mediawiki-1.15.1.tar.gz: 2009-07-16
and I think it was the same in "mediawiki-1.10.1.tar.gz". But you can
take a look yourself:
"maintenance/tables.sql" contains
===
-- Used for storing page restrictions (i.e. protection levels)
CREATE TABLE /*$wgDBprefix*/page_restrictions (
===
and as far as I can tell, they did not change at all since
"mediawiki-1.10.1.tar.gz".
Regards,
Claus