@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 _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
