INSERT INTO notification (id, type) VALUES 
(18, 'new_emailing'),
(19, 'emailing_validated');

INSERT INTO `message_template` (`id`, `notification_id`, `culture`, `reminder`, `subject`, `text`, `grouped_text`, `grouped`, `number_of_days_delay`) VALUES
(NULL, 18, 'fr',0,'Emailing en attente de validation','Un nouvel emailing (n° %order_id%) est en attente de validation. Vous pouvez le consulter <a href="%easycreadoc_url%/emailingOrders">ici</a>','',0,0),
(NULL, 19, 'fr',0,'Emailing en cours d''envoi','Votre emailing (n° %order_id%) est validé. Vous pourrez consulter les statistiques de l''envoi <a href="%easycreadoc_url%/emailingOrders">ici</a>','',0,0);

INSERT INTO `message_recipient` (`message_template_id`, `type`, `email`) 
SELECT id, 'validator', '' FROM message_template WHERE notification_id = 18;

INSERT INTO `message_recipient` (`message_template_id`, `type`, `email`) 
SELECT id, 'user', '' FROM message_template WHERE notification_id = 19;