INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added)
  select 'SMTP: Server URL', 'EMAIL_SMTP_HOST_SERVER', 'smtp.yourmailserver.com', 'URL for your SMTP server. Google Apps users: "ssl://smtp.gmail.com" to send the STARTTLS command ;-)', '12', '10', NULL, now()
       from dual
       where not exists (select * from `configuration` where `configuration_key`='EMAIL_SMTP_HOST_SERVER');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added)
  select 'SMTP: Access port', 'EMAIL_SMTP_PORT_SERVER', '25', 'Port to be used for connecting to the server. Default: 25. SSL: 465 (use with Google Apps)', '12', '12', NULL, now()
       from dual
       where not exists (select * from `configuration` where `configuration_key`='EMAIL_SMTP_PORT_SERVER');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added)
  select 'SMTP: Username', 'EMAIL_SMTP_USERNAME', 'username', 'Username for authenticating your connection. (Google Apps users: type your full email address here)', '12', '14', NULL, now()
       from dual
       where not exists (select * from `configuration` where `configuration_key`='EMAIL_SMTP_USERNAME');

