1 -- field is deprecated and no longer updated as of 1.25
2 CREATE TABLE /*_*/page_tmp (
3 page_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
4 page_namespace
int NOT NULL,
5 page_title
varchar(255) binary NOT NULL,
6 page_restrictions tinyblob
NOT NULL,
7 page_is_redirect tinyint unsigned
NOT NULL default 0,
8 page_is_new tinyint unsigned
NOT NULL default 0,
9 page_random
real unsigned
NOT NULL,
10 page_touched
binary(14) NOT NULL default '',
11 page_links_updated
varbinary(14) NULL default NULL,
12 page_latest
int unsigned
NOT NULL,
13 page_len
int unsigned
NOT NULL,
14 page_content_model
varbinary(32) DEFAULT NULL,
15 page_lang
varbinary(35) DEFAULT NULL
16 ) /*$wgDBTableOptions*/;
18 INSERT INTO /*_*/page_tmp
19 SELECT page_id
, page_namespace
, page_title
, page_restrictions
, page_is_redirect
,
20 page_is_new
, page_random
, page_touched
, page_links_updated
, page_latest
, page_len
,
21 page_content_model
, page_lang
26 ALTER TABLE /*_*/page_tmp
RENAME TO /*_*/page
;
28 CREATE UNIQUE INDEX /*i*/name_title
ON /*_*/page (page_namespace
,page_title
);
29 CREATE INDEX /*i*/page_random
ON /*_*/page (page_random
);
30 CREATE INDEX /*i*/page_len
ON /*_*/page (page_len
);
31 CREATE INDEX /*i*/page_redirect_namespace_len
ON /*_*/page (page_is_redirect
, page_namespace
, page_len
);