Page MenuHomeWickedGov Phorge
Files F4155310

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
Aug 19 2026, 21:39 (8 w, 2 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
ed/09/2fbf578dbc91e498d3dcf398b62b
Default Alt Text
patch-imagelinks-il_to-varbinary.sql (537 B)

Event Timeline