patch-global_block_whitelist-default-gbw_address.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-global_block_whitelist-default-gbw_address.sql
View Options

	-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
	-- Source: extensions/GlobalBlocking/sql/abstractSchemaChanges/patch-global_block_whitelist-default-gbw_address.json
	-- Do not modify this file directly.
	-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
	CREATE TEMPORARY TABLE /_/__temp__global_block_whitelist AS
	SELECT
	gbw_id,
	gbw_address,
	gbw_target_central_id,
	gbw_by,
	gbw_by_text,
	gbw_reason,
	gbw_expiry
	FROM /_/global_block_whitelist;
	DROP TABLE /_/global_block_whitelist;


	CREATE TABLE /_/global_block_whitelist (
	gbw_id INTEGER NOT NULL,
	gbw_address BLOB DEFAULT '' NOT NULL,
	gbw_target_central_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,
	gbw_by INTEGER NOT NULL,
	gbw_by_text BLOB NOT NULL,
	gbw_reason BLOB NOT NULL,
	gbw_expiry BLOB NOT NULL,
	PRIMARY KEY(gbw_id)
	);
	INSERT INTO /_/global_block_whitelist (
	gbw_id, gbw_address, gbw_target_central_id,
	gbw_by, gbw_by_text, gbw_reason,
	gbw_expiry
	)
	SELECT
	gbw_id,
	gbw_address,
	gbw_target_central_id,
	gbw_by,
	gbw_by_text,
	gbw_reason,
	gbw_expiry
	FROM
	/_/__temp__global_block_whitelist;
	DROP TABLE /_/__temp__global_block_whitelist;

	CREATE INDEX gbw_by ON /_/global_block_whitelist (gbw_by);

Mime Type: text/plain
Expires: Aug 19 2026, 16:59 (4 w, 4 d ago)
Storage Engine: local-disk
Storage Format: Raw Data
Storage Handle: b5/e3/519e9869a8106cbc22020fbbe08b
Default Alt Text: patch-global_block_whitelist-default-gbw_address.sql (1 KB)