function install()
{
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_STATUS', 'True', '6', '1', 'xtc_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_SHOP_TOKEN', '" . EasymarketingHelper::generateShopToken() . "', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_API_TOKEN', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_ACTIVATE_GOOGLE_TRACKING', 'False', '6', '1', 'xtc_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_ACTIVATE_FACEBOOK_TRACKING', 'False', '6', '1', 'xtc_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_REMARKETING_STATUS', 'False', '6', '1', 'xtc_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_ROOT_CATEGORY', '0', '6', '1', 'xtc_cfg_select_root_category(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_PRODUCTS_DESCRIPTION_DEFAULT', 'products_description', '6', '1', 'xtc_cfg_select_products_description(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_CONDITION_DEFAULT', 'new', '6', '1', 'xtc_cfg_select_condition(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_GENDER_DEFAULT', 'unisex', '6', '1', 'xtc_cfg_select_gender(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_AGE_GROUP_DEFAULT', 'adult', '6', '1', 'xtc_cfg_select_age_group(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_AVAILABILITY_STOCK_0', 'available for order', '6', '1', 'xtc_cfg_select_availibility(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_AVAILABILITY_STOCK_1', 'in stock', '6', '1', 'xtc_cfg_select_availibility(', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_SHIPPING_COUNTRIES', 'DE,AT,CH', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_API_STATUS', '0', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_CONFIGURE_ENDPOINTS_STATUS', '0', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_GOOGLE_CONVERSION_TRACKING_CODE', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_FACEBOOK_CONVERSION_TRACKING_CODE', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_GOOGLE_LEAD_TRACKING_CODE', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_FACEBOOK_LEAD_TRACKING_CODE', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_GOOGLE_SITE_VERIFICATION_STATUS', '0', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_GOOGLE_SITE_VERIFICATION_META_TAG', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_REMARKETING_USER_ID', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_REMARKETING_CODE', '', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_LAST_CRAWL_DATE', '0', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_LAST_CRAWL_PRODUCTS_COUNT', '0', '6', '1', '', now())");
xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value, configuration_group_id, sort_order, set_function, date_added) values ('MODULE_EM_LAST_CRAWL_CATEGORIES_COUNT', '0', '6', '1', '', now())");
$sql = "CREATE TABLE IF NOT EXISTS `easymarketing_mappings` (\n\t\t\t\t`id` int(2) NOT NULL,\n\t\t\t\t `mapping_field` varchar(30) NOT NULL,\n\t\t\t\t `mapping_field_values` varchar(255) NOT NULL,\n\t\t\t\t `mapping_field_default_value` varchar(255) NOT NULL,\n\t\t\t\t `disabled_shop_fields` varchar(200) NOT NULL,\n\t\t\t\t `disable_default_value` int(1) NOT NULL DEFAULT '0',\n\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9";
xtc_db_query($sql);
$sql = "INSERT INTO `easymarketing_mappings` (`id`, `mapping_field`, `disabled_shop_fields`, `disable_default_value`) VALUES\n\t\t\t\t(1, 'name', 'p,o', 1),\n\t\t\t\t(2, 'description', 'p,o', 1),\n\t\t\t\t(3, 'color', '', 0),\n\t\t\t\t(4, 'size', '', 0),\n\t\t\t\t(5, 'size_type', '', 0),\n\t\t\t\t(6, 'size_system', '', 0),\n\t\t\t\t(7, 'material', '', 0),\n\t\t\t\t(8, 'pattern', '', 0)";
xtc_db_query($sql);
}
