Page MenuHomeWickedGov Phorge
Files F1431580

patch-imagelinks-il_to-varbinary.sql
No OneTemporary
Actions

Size
537 B
Referenced Files
None
Subscribers
None

patch-imagelinks-il_to-varbinary.sql
View Options

CREATE TABLE /*_*/imagelinks_tmp (
il_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
il_to BLOB DEFAULT '' NOT NULL,
il_from_namespace INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY(il_from, il_to)
);
INSERT INTO /*_*/imagelinks_tmp
SELECT il_from, il_to, il_from_namespace
FROM /*_*/imagelinks;
DROP TABLE /*_*/imagelinks;
ALTER TABLE /*_*/imagelinks_tmp RENAME TO /*_*/imagelinks;
CREATE INDEX il_to ON /*_*/imagelinks (il_to, il_from);
CREATE INDEX il_backlinks_namespace ON /*_*/imagelinks (
il_from_namespace, il_to, il_from
);

File Metadata

Mime Type
text/plain
Expires
Sat, May 16, 20:48 (1 d, 8 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
a4/ca/a364496d377c164230cc478ba46a
Default Alt Text
patch-imagelinks-il_to-varbinary.sql (537 B)

Event Timeline