maintenance/archives/patch-protected_titles.sql

   1 -- Protected titles - nonexistent pages that have been protected
   2 CREATE TABLE `/*$wgDBPrefix*/protected_titles` (
   3   `pt_namespace` int(11) NOT NULL,
   4   `pt_title` varchar(255) NOT NULL,
   5   `pt_by` int(10) unsigned NOT NULL,
   6   `pt_reason` tinyblob,
   7   `pt_timestamp` binary(14) NOT NULL,
   8   `pt_expiry` varbinary(14) NOT NULL default '',
   9   `pt_create_perm` varbinary(60) NOT NULL,
  10   PRIMARY KEY  (`pt_namespace`,`pt_title`),
  11   KEY `pt_by` (`pt_by`),
  12   KEY `pt_timestamp` (`pt_timestamp`)
  13 ) /*$wgDBTableOptions*/