INSERT IGNORE INTO `#__rsform_config` (`SettingName`, `SettingValue`) VALUES ('mailchimp.key', '');
INSERT IGNORE INTO `#__rsform_config` (`SettingName`, `SettingValue`) VALUES ('mailchimp.list_count', '10');
INSERT IGNORE INTO `#__rsform_config` (`SettingName`, `SettingValue`) VALUES ('mailchimp.timeout', '5');

CREATE TABLE IF NOT EXISTS `#__rsform_mailchimp` (
  `form_id` int(11) NOT NULL,
  `mc_list_id` varchar(16) NOT NULL,
  `mc_action` tinyint(1) NOT NULL,
  `mc_action_field` varchar(255) NOT NULL,
  `mc_merge_vars` text NOT NULL,
  `mc_cached_values` text NOT NULL,
  `mc_interest_groups` text NOT NULL,
  `mc_tags` text NOT NULL,
  `mc_append_tags` tinyint(1) NOT NULL,
  `mc_trigger_tags_automation` tinyint(1) NOT NULL,
  `mc_email_type` varchar(32) NOT NULL,
  `mc_email_type_field` varchar(255) NOT NULL,
  `mc_double_optin` tinyint(1) NOT NULL,
  `mc_update_existing` tinyint(1) NOT NULL,
  `mc_replace_interests` tinyint(1) NOT NULL,
  `mc_delete_member` tinyint(1) NOT NULL,
  `mc_language` varchar(255) NOT NULL DEFAULT '',
  `mc_published` tinyint(1) NOT NULL,
  PRIMARY KEY  (`form_id`)
) DEFAULT CHARSET=utf8;