[GitHub/WoltLab/WCF.git] / com.woltlab.wcf / update_3.1_1.sql

ALTER TABLE wcf1_comment DROP FOREIGN KEY objectTypeID;
ALTER TABLE wcf1_comment DROP KEY objectTypeID;
ALTER TABLE wcf1_comment ADD KEY (objectTypeID, objectID, isDisabled, time);
ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
Commit	Line	Data
94acb043 AE	1	ALTER TABLE wcf1_comment DROP FOREIGN KEY objectTypeID;
	2	ALTER TABLE wcf1_comment DROP KEY objectTypeID;
	3	ALTER TABLE wcf1_comment ADD KEY (objectTypeID, objectID, isDisabled, time);
	4	ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;