Importing XML with restrictions tag - MediaWiki-l

18 Sep 2009


      @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