ALTER TABLE `notification`
  ADD COLUMN `category` VARCHAR(191) NOT NULL DEFAULT 'general',
  ADD COLUMN `actor_id` INT NULL,
  ADD COLUMN `actor_name` TEXT NULL;

CREATE INDEX `notification_actor_id_idx` ON `notification`(`actor_id`);

ALTER TABLE `notification`
  ADD CONSTRAINT `notification_actor_id_fkey`
  FOREIGN KEY (`actor_id`) REFERENCES `Kezelo`(`Azonosito`)
  ON DELETE SET NULL
  ON UPDATE CASCADE;
