Schema change for T189101
ActivePublic
Actions

Authored by Lucas_Werkmeister_WMDE on Aug 31 2018, 5:26 PM.

Tags

Referenced Files

	F25563389: Schema change for T189101
	Aug 31 2018, 5:26 PM

Subscribers

None

	--
	-- T180834: Add numeric primary key to wbqc_constraints
	-- (replacing constraint_guid as primary key)

	ALTER TABLE /_/wbqc_constraints
	ADD COLUMN constraint_id int unsigned NOT NULL AUTO_INCREMENT FIRST,
	DROP PRIMARY KEY,
	ADD PRIMARY KEY (constraint_id);

	CREATE UNIQUE INDEX /i/wbqc_constraints_guid_uniq ON /_/wbqc_constraints (constraint_guid);

Schema change for T189101ActivePublicActions