aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/upgrades/2008101701.sql
blob: 3e6fc96534728ca6666be31a8988a2422fdc748b (plain)
1
2
3
4
5
6
7
ALTER TABLE `prefix_system_log` ADD COLUMN `owner_guid` int(11) NOT NULL AFTER `performed_by_guid`;

ALTER TABLE `prefix_system_log` DROP KEY `owner_guid`;
ALTER TABLE `prefix_system_log` ADD KEY `owner_guid` (`owner_guid`);

ALTER TABLE `prefix_system_log` DROP KEY `river_key`;
ALTER TABLE `prefix_system_log` ADD KEY `river_key` (`object_type`, `object_subtype`, `event`, `access_id`);