Schema change for T189101
No One
Actions

Authored By

	Lucas_Werkmeister_WMDE
	Aug 31 2018, 5:26 PM

Size

364 B

Referenced Files

None

Subscribers

None

Schema change for T189101
View Options

	--
	-- 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);