ALTER TABLE `notifications`
  ADD COLUMN `admin_id` int(10) unsigned DEFAULT NULL AFTER `user_id`,
  ADD KEY `idx_admin_read` (`admin_id`, `is_read`),
  ADD CONSTRAINT `fk_notifications_admin` FOREIGN KEY (`admin_id`) REFERENCES `admin_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
