Page MenuHomeWickedGov Phorge
Files F4103996

patch-ipblocks_restrictions-ir_ipb_id.sql
No OneTemporary
Actions

Size
953 B
Referenced Files
None
Subscribers
None

patch-ipblocks_restrictions-ir_ipb_id.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-ipblocks_restrictions-ir_ipb_id.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 UNSIGNED 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
Tue, Aug 18, 18:15 (3 w, 2 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
dd/91/59f5b31c1e49372e97ad3777db70
Default Alt Text
patch-ipblocks_restrictions-ir_ipb_id.sql (953 B)

Event Timeline