*Rename pt_by to pt_user to be a bit more consistent
[lhc/web/wiklou.git] / 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_user 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
12 KEY pt_timestamp (pt_timestamp)
13 ) /*$wgDBTableOptions*/;