[GitHub/WoltLab/WCF.git] / com.woltlab.wcf / update_4.sql

ALTER TABLE wcf1_user_notification ADD KEY (confirmTime);

DELETE FROM wcf1_user_profile_visitor WHERE userID IS NULL OR ownerID IS NULL;
ALTER TABLE wcf1_user_profile_visitor CHANGE ownerID ownerID INT(10) NOT NULL;
ALTER TABLE wcf1_user_profile_visitor CHANGE userID userID INT(10) NOT NULL;

ALTER TABLE wcf1_user_storage ADD KEY (field);

ALTER TABLE wcf1_moderation_queue ADD KEY objectTypeAndID (objectTypeID, objectID);

ALTER TABLE wcf1_modification_log ADD KEY objectTypeAndID (objectTypeID, objectID);
Commit	Line	Data
ae03c54e AE	1	ALTER TABLE wcf1_user_notification ADD KEY (confirmTime);
	2
	3	DELETE FROM wcf1_user_profile_visitor WHERE userID IS NULL OR ownerID IS NULL;
	4	ALTER TABLE wcf1_user_profile_visitor CHANGE ownerID ownerID INT(10) NOT NULL;
	5	ALTER TABLE wcf1_user_profile_visitor CHANGE userID userID INT(10) NOT NULL;
	6
	7	ALTER TABLE wcf1_user_storage ADD KEY (field);
671e90c1 AE	8
	9	ALTER TABLE wcf1_moderation_queue ADD KEY objectTypeAndID (objectTypeID, objectID);
	10
	11	ALTER TABLE wcf1_modification_log ADD KEY objectTypeAndID (objectTypeID, objectID);