-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Genereertijd: 21 dec 2014 om 21:56
-- Serverversie: 5.5.32-log
-- PHP-versie: 5.4.35

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databank: `picatoys_nl_joomla`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `jos_csvi_template_settings`
--

CREATE TABLE IF NOT EXISTS `jos_csvi_template_settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the saved setting',
  `name` varchar(255) NOT NULL COMMENT 'Name for the saved setting',
  `settings` text NOT NULL COMMENT 'The actual settings',
  `process` enum('import','export') NOT NULL DEFAULT 'import' COMMENT 'The type of template',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Stores the template settings for CSVI' AUTO_INCREMENT=3 ;

--
-- Gegevens worden uitgevoerd voor tabel `jos_csvi_template_settings`
--

INSERT INTO `jos_csvi_template_settings` (`id`, `name`, `settings`, `process`) VALUES
(1, '[Shotsmedia Toys]', '{"options":{"action":"import","component":"com_virtuemart","operation":"productimport"},"general":{"source":"fromupload","local_csv_file":"","urlfile":"","ftphost":"","ftpport":"","ftpusername":"janwil","ftppass":"SecretPWD","ftproot":"","ftpfile":"","auto_detect_delimiters":"1","field_delimiter":"","text_enclosure":"","use_file_extension":"xml","im_mac":"0","use_column_headers":"0","add_extra_fields":"0","skip_first_line":"0","overwrite_existing_data":"1","ignore_non_exist":"0","skip_default_value":"0","collect_debug_info":"1","xml_record_name":"product","language":"en-GB","category_separator":","},"product":{"append_categories":"0","update_based_on":"product_sku","mpn_column_name":"","unpublish_before_import":"0","recreate_alias":"0","update_stockable_parent":"0","use_icecat":"0","similar_sku":"0","icecat_update_fields":[""]},"image":{"process_image":"1","delete_product_images":"0","auto_generate_image_name":"1","type_generate_image_name":"product_sku","autogenerateext":"png","change_case":"lcase","autofill":"1","keep_original":"0","convert_type":"none","save_images_on_server":"1","redownload_external_image":"1","full_resize":"0","full_width":"","full_height":"","full_watermark":"0","full_watermark_right":"","full_watermark_bottom":"","full_watermark_image":"","thumb_check_filetype":"1","thumb_create":"1","thumb_extension":"png","thumb_width":"90","thumb_height":"90","resize_max_width":"1024","resize_max_height":"768"},"path":{"file_location_product_files":"images\\/stories\\/virtuemart\\/product\\/Toys\\/"},"limit":{"use_system_limits":"0","max_execution_time":"","memory_limit":"","post_max_size":"","upload_max_filesize":""}}', 'import'),
(2, 'toys test2 bewaren', '{"options":{"action":"import","component":"com_virtuemart","operation":"productimport"},"general":{"source":"fromupload","local_csv_file":"","urlfile":"","ftphost":"","ftpport":"","ftpusername":"janwil","ftppass":"SecretPWD","ftproot":"","ftpfile":"","auto_detect_delimiters":"1","field_delimiter":"","text_enclosure":"","use_file_extension":"xml","im_mac":"0","use_column_headers":"0","add_extra_fields":"0","skip_first_line":"0","overwrite_existing_data":"1","ignore_non_exist":"0","skip_default_value":"0","collect_debug_info":"1","xml_record_name":"product","language":"en-GB","category_separator":","},"product":{"append_categories":"0","update_based_on":"product_sku","mpn_column_name":"","unpublish_before_import":"0","recreate_alias":"0","update_stockable_parent":"0","use_icecat":"0","similar_sku":"0","icecat_update_fields":[""]},"image":{"process_image":"1","delete_product_images":"0","auto_generate_image_name":"1","type_generate_image_name":"product_sku","autogenerateext":"png","change_case":"lcase","autofill":"1","keep_original":"0","convert_type":"none","save_images_on_server":"1","redownload_external_image":"1","full_resize":"0","full_width":"","full_height":"","full_watermark":"0","full_watermark_right":"","full_watermark_bottom":"","full_watermark_image":"","thumb_check_filetype":"1","thumb_create":"1","thumb_extension":"png","thumb_width":"90","thumb_height":"90","resize_max_width":"1024","resize_max_height":"768"},"path":{"file_location_product_files":"images\\/stories\\/virtuemart\\/product\\/Toys\\/"},"limit":{"use_system_limits":"0","max_execution_time":"","memory_limit":"","post_max_size":"","upload_max_filesize":""}}', 'import'),

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;