Page MenuHomeWickedGov Phorge
Files F5987407

patch-ipblocks_restrictions-ir_value.sql
No OneTemporary
Actions

Size
943 B
Referenced Files
None
Subscribers
None

patch-ipblocks_restrictions-ir_value.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_value.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP INDEX ir_type_value;
CREATE TEMPORARY TABLE /*_*/__temp__ipblocks_restrictions AS
SELECT ir_ipb_id, ir_type, ir_value
FROM /*_*/ipblocks_restrictions;
DROP TABLE /*_*/ipblocks_restrictions;
CREATE TABLE /*_*/ipblocks_restrictions ( ir_ipb_id INTEGER NOT NULL, ir_type SMALLINT NOT NULL, ir_value INTEGER UNSIGNED NOT NULL, PRIMARY KEY(ir_ipb_id, ir_type, ir_value) );
INSERT INTO /*_*/ipblocks_restrictions (ir_ipb_id, ir_type, ir_value)
SELECT ir_ipb_id, ir_type, ir_value
FROM /*_*/__temp__ipblocks_restrictions;
DROP TABLE /*_*/__temp__ipblocks_restrictions;
CREATE INDEX ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value);

File Metadata

Mime Type
text/plain
Expires
Sun, Oct 4, 00:26 (2 w, 6 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
0c/3d/60dbf756cda97af092d725d09ce6
Default Alt Text
patch-ipblocks_restrictions-ir_value.sql (943 B)

Event Timeline