blob: cd10eb0242790eb5c5240032b9adadc373d71e14 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
ALTER TABLE `prefix_system_log` ADD COLUMN `access_id` int(11) NOT NULL AFTER `performed_by_guid`;
ALTER TABLE `prefix_system_log` ADD COLUMN `enabled` enum ('yes', 'no') NOT NULL default 'yes' AFTER `access_id`;
ALTER TABLE `prefix_system_log` DROP KEY `access_id`;
ALTER TABLE `prefix_system_log` ADD KEY `access_id` (`access_id`);
ALTER TABLE `prefix_system_log` DROP KEY `enabled`;
ALTER TABLE `prefix_system_log` ADD KEY `enabled` (`enabled`);
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`, `enabled`);
|
