INSERT IGNORE INTO util.notification (name, description) VALUES ('backup-printer-selected','A backup printer has been selected'); INSERT IGNORE INTO util.notificationSubscription (notificationFk, userFk) SELECT id, 10435 FROM util.notification WHERE name = 'backup-printer-selected'; INSERT IGNORE INTO util.notificationAcl (notificationFk, roleFk) SELECT id, 66 FROM util.notification WHERE name = 'backup-printer-selected';