blob: 2576487bdb77fe46b5f3821cf9856b57e50d49f6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
ALTER TABLE `prefix_system_log` ADD COLUMN `object_type` varchar(50) NOT NULL AFTER `object_class`;
ALTER TABLE `prefix_system_log` ADD COLUMN `object_subtype` varchar(50) NOT NULL AFTER `object_type`;
ALTER TABLE `prefix_system_log` MODIFY `object_type` varchar(50) NOT NULL;
ALTER TABLE `prefix_system_log` DROP KEY `object_type`;
ALTER TABLE `prefix_system_log` DROP KEY `object_subtype`;
ALTER TABLE `prefix_system_log` DROP KEY `river_key`;
ALTER TABLE `prefix_system_log` ADD KEY `object_type` (`object_type`);
ALTER TABLE `prefix_system_log` ADD KEY `object_subtype` (`object_subtype`);
ALTER TABLE `prefix_system_log` ADD KEY `river_key` (`object_type`, `object_subtype`, `event`);
|
