patch-cn_notice_languages-unique-to-pk.sql
No OneTemporary
Actions

Size

818 B

Referenced Files

None

Subscribers

None

patch-cn_notice_languages-unique-to-pk.sql
View Options

	-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
	-- Source: sql/abstractSchemaChanges/patch-cn_notice_languages-unique-to-pk.json
	-- Do not modify this file directly.
	-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
	DROP INDEX nl_notice_id_language;
	CREATE TEMPORARY TABLE /_/__temp__cn_notice_languages AS
	SELECT nl_notice_id, nl_language
	FROM /_/cn_notice_languages;
	DROP TABLE /_/cn_notice_languages;
	CREATE TABLE /_/cn_notice_languages ( nl_notice_id INTEGER UNSIGNED NOT NULL, nl_language VARCHAR(32) NOT NULL, PRIMARY KEY(nl_notice_id, nl_language) );
	INSERT INTO /_/cn_notice_languages (nl_notice_id, nl_language)
	SELECT nl_notice_id, nl_language
	FROM /_/__temp__cn_notice_languages;
	DROP TABLE /_/__temp__cn_notice_languages;

File Metadata

Mime Type: text/plain
Expires: Sun, Oct 4, 01:24 (3 w, 4 d ago)
Storage Engine: local-disk
Storage Format: Raw Data
Storage Handle: fc/c3/24114c097739439711307581c3e1
Default Alt Text: patch-cn_notice_languages-unique-to-pk.sql (818 B)

Event Timeline