Page MenuHomeWickedGov Phorge
Files F5969769

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

Size
789 B
Referenced Files
None
Subscribers
None

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

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

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 13:59 (19 h, 56 m ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
04/93/ad1fe4cbf12816b76f519f83543c
Default Alt Text
patch-cn_notice_regions-unique-to-pk.sql (789 B)

Event Timeline