Page MenuHomeWickedGov Phorge
Files F4067735

patch-site_identifiers-rename-indexes.sql
No OneTemporary
Actions

Size
934 B
Referenced Files
None
Subscribers
None

patch-site_identifiers-rename-indexes.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-site_identifiers-rename-indexes.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX site_ids_site;
DROP INDEX site_ids_key;
CREATE TEMPORARY TABLE /*_*/__temp__site_identifiers AS
SELECT si_type, si_key, si_site
FROM /*_*/site_identifiers;
DROP TABLE /*_*/site_identifiers;
CREATE TABLE /*_*/site_identifiers ( si_type BLOB NOT NULL, si_key BLOB NOT NULL, si_site INTEGER UNSIGNED NOT NULL, PRIMARY KEY(si_type, si_key) );
INSERT INTO /*_*/site_identifiers (si_type, si_key, si_site)
SELECT si_type, si_key, si_site
FROM /*_*/__temp__site_identifiers;
DROP TABLE /*_*/__temp__site_identifiers;
CREATE INDEX si_site ON /*_*/site_identifiers (si_site);
CREATE INDEX si_key ON /*_*/site_identifiers (si_key);

File Metadata

Mime Type
text/plain
Expires
Aug 16 2026, 18:57 (11 w, 6 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
36/d8/52179ad57cc806900ed87b7685cf
Default Alt Text
patch-site_identifiers-rename-indexes.sql (934 B)

Event Timeline