Page MenuHomeWickedGov Phorge
Files F5986716

patch-pagelinks-pl_title-varbinary.sql
No OneTemporary
Actions

Size
651 B
Referenced Files
None
Subscribers
None

patch-pagelinks-pl_title-varbinary.sql
View Options

CREATE TABLE /*_*/pagelinks_tmp (
pl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
pl_namespace INTEGER DEFAULT 0 NOT NULL,
pl_title BLOB DEFAULT '' NOT NULL,
pl_from_namespace INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY(pl_from, pl_namespace, pl_title)
);
INSERT INTO /*_*/pagelinks_tmp
SELECT pl_from, pl_namespace, pl_title, pl_from_namespace
FROM /*_*/pagelinks;
DROP TABLE /*_*/pagelinks;
ALTER TABLE /*_*/pagelinks_tmp RENAME TO /*_*/pagelinks;
CREATE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
CREATE INDEX pl_backlinks_namespace ON /*_*/pagelinks (
pl_from_namespace, pl_namespace,
pl_title, pl_from
);

File Metadata

Mime Type
text/plain
Expires
Sun, Oct 4, 00:12 (2 w, 4 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
13/c2/8b20f4c33398834fbe2978a72634
Default Alt Text
patch-pagelinks-pl_title-varbinary.sql (651 B)

Event Timeline