From a6123ba18955b213e834a83ae9856958fba28c9b Mon Sep 17 00:00:00 2001 From: Andrew Garrett Date: Wed, 10 Jan 2007 23:47:10 +0000 Subject: [PATCH] I must not forget SVN ADD I must not forget SVN ADD I must not forget SVN ADD I must not forget SVN ADD I must not forget SVN ADD --- .../archives/patch-page_restrictions.sql | 22 +++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 maintenance/archives/patch-page_restrictions.sql diff --git a/maintenance/archives/patch-page_restrictions.sql b/maintenance/archives/patch-page_restrictions.sql new file mode 100644 index 0000000000..8805c2f866 --- /dev/null +++ b/maintenance/archives/patch-page_restrictions.sql @@ -0,0 +1,22 @@ +--- Used for storing page restrictions (i.e. protection levels) +CREATE TABLE /*$wgDBprefix*/page_restrictions ( + -- Page to apply restrictions to (Foreign Key to page). + pr_page int(8) NOT NULL, + -- The protection type (edit, move, etc) + pr_type varchar(255) NOT NULL, + -- The protection level (Sysop, autoconfirmed, etc) + pr_level varchar(255) NOT NULL, + -- Whether or not to cascade the protection down to pages transcluded. + pr_cascade tinyint(4) NOT NULL, + -- Field for future support of per-user restriction. + pr_user int(8) NULL, + -- Field for future support of time-limited protection. + pr_expiry char(14) binary NULL, + + PRIMARY KEY (pr_page,pr_type), + + KEY pr_page (pr_page), + KEY pr_typelevel (pr_type,pr_level), + KEY pr_level (pr_level), + KEY pr_cascade (pr_cascade) +) TYPE=InnoDB; \ No newline at end of file -- 2.20.1