ALTER TABLE pp_log ADD COLUMN `action` VARCHAR(100) NULL DEFAULT NULL AFTER `id`; ALTER TABLE pp_log ADD COLUMN `order_id` INT NULL DEFAULT NULL AFTER `action`; ALTER TABLE pp_log ADD COLUMN `context` TEXT NULL DEFAULT NULL AFTER `message`; ALTER TABLE pp_log ADD INDEX `idx_action` (`action`); ALTER TABLE pp_log ADD INDEX `idx_order_id` (`order_id`);