Page MenuHomeWickedGov Phorge
Files F4052024

patch-iwlinks-iwl_title-varbinary.sql
No OneTemporary
Actions

Size
550 B
Referenced Files
None
Subscribers
None

patch-iwlinks-iwl_title-varbinary.sql
View Options

CREATE TABLE /*_*/iwlinks_tmp (
iwl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
iwl_prefix BLOB DEFAULT '' NOT NULL,
iwl_title BLOB DEFAULT '' NOT NULL,
PRIMARY KEY(iwl_from, iwl_prefix, iwl_title)
);
INSERT INTO /*_*/iwlinks_tmp
SELECT iwl_from, iwl_prefix, iwl_title
FROM /*_*/iwlinks;
DROP TABLE /*_*/iwlinks;
ALTER TABLE /*_*/iwlinks_tmp RENAME TO /*_*/iwlinks;
CREATE INDEX iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from);
CREATE INDEX iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);

File Metadata

Mime Type
text/plain
Expires
Aug 15 2026, 18:49 (12 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
e5/ae/a24e86af4aead1bbc4172311801b
Default Alt Text
patch-iwlinks-iwl_title-varbinary.sql (550 B)

Event Timeline