Page MenuHomeWickedGov Phorge

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

Size
818 B
Referenced Files
None
Subscribers
None

patch-cn_notice_languages-unique-to-pk.sql

-- 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
Fri, Jul 3, 19:11 (1 d, 15 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
54/30/bc79100ff3fb19f948927a3b4010
Default Alt Text
patch-cn_notice_languages-unique-to-pk.sql (818 B)

Event Timeline