1 -- Protected titles - nonexistent pages that have been protected
2 CREATE TABLE /*$wgDBprefix*/protected_titles (
3 pt_namespace
int NOT NULL,
4 pt_title
varchar(255) binary NOT NULL,
5 pt_user
int unsigned
NOT NULL,
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_timestamp (pt_timestamp
)
12 ) /*$wgDBTableOptions*/;