| Index: trunk/phase3/maintenance/archives/patch-page_restrictions.sql |
| — | — | @@ -0,0 +1,22 @@ |
| | 2 | +--- Used for storing page restrictions (i.e. protection levels) |
| | 3 | +CREATE TABLE /*$wgDBprefix*/page_restrictions ( |
| | 4 | + -- Page to apply restrictions to (Foreign Key to page). |
| | 5 | + pr_page int(8) NOT NULL, |
| | 6 | + -- The protection type (edit, move, etc) |
| | 7 | + pr_type varchar(255) NOT NULL, |
| | 8 | + -- The protection level (Sysop, autoconfirmed, etc) |
| | 9 | + pr_level varchar(255) NOT NULL, |
| | 10 | + -- Whether or not to cascade the protection down to pages transcluded. |
| | 11 | + pr_cascade tinyint(4) NOT NULL, |
| | 12 | + -- Field for future support of per-user restriction. |
| | 13 | + pr_user int(8) NULL, |
| | 14 | + -- Field for future support of time-limited protection. |
| | 15 | + pr_expiry char(14) binary NULL, |
| | 16 | + |
| | 17 | + PRIMARY KEY (pr_page,pr_type), |
| | 18 | + |
| | 19 | + KEY pr_page (pr_page), |
| | 20 | + KEY pr_typelevel (pr_type,pr_level), |
| | 21 | + KEY pr_level (pr_level), |
| | 22 | + KEY pr_cascade (pr_cascade) |
| | 23 | +) TYPE=InnoDB; |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/archives/patch-page_restrictions.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 24 | + native |