patch-translate_message_group_subscriptions-composite-primary-key.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-translate_message_group_subscriptions-composite-primary-key.sql
View Options

	-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
	-- Source: extensions/Translate/sql/abstractSchemaChanges/patch-translate_message_group_subscriptions-composite-primary-key.json
	-- Do not modify this file directly.
	-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
	CREATE TEMPORARY TABLE /_/__temp__translate_message_group_subscriptions AS
	SELECT
	tmgs_user_id,
	tmgs_group
	FROM /_/translate_message_group_subscriptions;
	DROP TABLE /_/translate_message_group_subscriptions;


	CREATE TABLE /_/translate_message_group_subscriptions (
	tmgs_user_id INTEGER UNSIGNED NOT NULL,
	tmgs_group BLOB NOT NULL,
	PRIMARY KEY(tmgs_group, tmgs_user_id)
	);
	INSERT INTO /_/translate_message_group_subscriptions (tmgs_user_id, tmgs_group)
	SELECT
	tmgs_user_id,
	tmgs_group
	FROM
	/_/__temp__translate_message_group_subscriptions;
	DROP TABLE /_/__temp__translate_message_group_subscriptions;

	CREATE INDEX translate_tmgs_user_id ON /_/translate_message_group_subscriptions (tmgs_user_id);

Mime Type: text/plain
Expires: Aug 19 2026, 17:34 (5 w, 3 d ago)
Storage Engine: local-disk
Storage Format: Raw Data
Storage Handle: 5c/e8/81eaf2553feaeb65d8ede5c52229
Default Alt Text: patch-translate_message_group_subscriptions-composite-primary-key.sql (1 KB)