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*/;