Page MenuHomeWickedGov Phorge
Files F5985563

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

Size
804 B
Referenced Files
None
Subscribers
None

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

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

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 23:49 (2 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
d1/4d/2c4a2deee46ffdfebf2815a886ba
Default Alt Text
patch-cn_notice_projects-unique-to-pk.sql (804 B)

Event Timeline