USE provisioning;

INSERT
  INTO voip_subscribers
    (username, domain_id, uuid, password, create_timestamp, modify_timestamp)
  SELECT
    'nagios',
    id,
    'ac1697cf-6933-45ef-9abf-b1278054ded0',
    'nagios4Sipwise!',
    '0',
    '1970-01-01 00:00:00'
  FROM voip_domains
  WHERE domain = 'voip.sipwise.local';
