-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Machine: 95.170.72.83
-- Genereertijd: 21 dec 2014 om 22:50
-- 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_fields`
--
CREATE TABLE IF NOT EXISTS `jos_csvi_template_fields` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for the template field',
`template_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The template ID',
`ordering` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The order of the field',
`field_name` VARCHAR(255) NOT NULL COMMENT 'Name for the field',
`file_field_name` VARCHAR(255) NOT NULL COMMENT 'Name for the field from the file',
`template_field_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name for the field from the template',
`column_header` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Header for the column',
`default_value` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Default value for the field',
`process` enum('0','1') NOT NULL DEFAULT '1' COMMENT 'Process the field',
`combine_char` VARCHAR(5) NOT NULL DEFAULT '' COMMENT 'The character(s) to combine the fields',
`sort` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Sort the field',
`cdata` enum('0','1') NOT NULL DEFAULT '1' COMMENT 'Use the CDATA tag',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds the fields for a CSVI template' AUTO_INCREMENT=47 ;
--
-- Gegevens worden uitgevoerd voor tabel `jos_csvi_template_fields`
--
INSERT INTO `jos_csvi_template_fields` (`id`, `template_id`, `ordering`, `field_name`, `file_field_name`, `template_field_name`, `column_header`, `default_value`, `process`, `combine_char`, `sort`, `cdata`) VALUES
(1, 1, 1, 'product_sku', 'product_number', '', '', '', '1', '', '0', '1'),
(2, 1, 2, 'product_name', 'product_name', '', '', '', '1', '', '0', '1'),
(3, 1, 3, 'product_price', 'price', '', '', '', '1', '', '0', '1'),
(4, 1, 4, 'product_desc', 'description', '', '', '', '1', '', '0', '1'),
(5, 1, 5, 'manufacturer_name', 'manufacturer', '', '', '', '1', ',', '0', '1'),
(6, 1, 6, 'Genre', 'category', '', '', '', '1', '', '0', '1'),
(7, 1, 7, 'category_path', '', '', '', 'Toys', '1', '', '0', '1'),
(8, 1, 8, 'product_in_stock', 'stock', '', '', '', '1', '', '0', '1'),
(9, 1, 9, 'product_gtin', 'eancode', '', '', '', '1', '', '0', '1'),
(10, 1, 10, 'combine', 'image_1', '', '', '', '1', '', '0', '1'),
(11, 1, 11, 'combine', 'image_2', '', '', '', '1', '', '0', '1'),
(12, 1, 12, 'combine', 'image_3', '', '', '', '1', '', '0', '1'),
(13, 1, 13, 'combine', 'image_4', '', '', '', '1', '', '0', '1'),
(14, 1, 14, 'file_url', '', '', '', '', '1', '|', '0', '1'),
(15, 1, 15, 'product_tax', 'vat_value', '', '', '', '1', '', '0', '1'),
(16, 1, 16, 'product_weight', 'package_weight', '', '', '', '1', '', '0', '1'),
(17, 1, 17, 'product_length', 'package_length', '', '', '', '1', '', '0', '1'),
(18, 1, 18, 'product_width', 'package_width', '', '', '', '1', '', '0', '1'),
(19, 1, 19, 'product_height', 'package_height', '', '', '', '1', '', '0', '1'),
(20, 1, 20, 'Colors', 'colors', 'custom_multiple', '', '', '1', ',', '0', '1'),
(21, 1, 21, 'Material', 'material', '', '', '', '1', '', '0', '1'),
(22, 1, 22, 'Washing_Instructions', 'washing', '', '', '', '1', '', '0', '1'),
(23, 1, 23, 'published', '', '', '', '1', '1', '', '0', '1'),
(24, 2, 1, 'product_sku', 'product_number', '', '', '', '1', '', '0', '1'),
(25, 2, 2, 'product_name', 'product_name', '', '', '', '1', '', '0', '1'),
(26, 2, 3, 'product_price', 'price', '', '', '', '1', '', '0', '1'),
(27, 2, 4, 'product_desc', 'description', '', '', '', '1', '', '0', '1'),
(28, 2, 5, 'manufacturer_name', 'manufacturer', '', '', '', '1', ',', '0', '1'),
(29, 2, 6, 'Genre', 'category', '', '', '', '1', '', '0', '1'),
(30, 2, 7, 'category_path', '', '', '', 'Toys', '1', '', '0', '1'),
(31, 2, 8, 'product_in_stock', 'stock', '', '', '', '1', '', '0', '1'),
(32, 2, 9, 'product_gtin', 'eancode', '', '', '', '1', '', '0', '1'),
(33, 2, 10, 'combine', 'image_1', '', '', '', '1', '', '0', '1'),
(34, 2, 11, 'combine', 'image_2', '', '', '', '1', '', '0', '1'),
(35, 2, 12, 'combine', 'image_3', '', '', '', '1', '', '0', '1'),
(36, 2, 13, 'combine', 'image_4', '', '', '', '1', '', '0', '1'),
(37, 2, 14, 'file_url', '', '', '', '', '1', '|', '0', '1'),
(38, 2, 15, 'product_tax', 'vat_value', '', '', '', '1', '', '0', '1'),
(39, 2, 16, 'product_weight', 'package_weight', '', '', '', '1', '', '0', '1'),
(40, 2, 17, 'product_length', 'package_length', '', '', '', '1', '', '0', '1'),
(41, 2, 18, 'product_width', 'package_width', '', '', '', '1', '', '0', '1'),
(42, 2, 19, 'product_height', 'package_height', '', '', '', '1', '', '0', '1'),
(43, 2, 20, 'Colors', 'colors', 'custom_multiple', '', '', '1', ',', '0', '1'),
(44, 2, 21, 'Material', 'material', '', '', '', '1', '', '0', '1'),
(45, 2, 22, 'Washing_Instructions', 'washing', '', '', '', '1', '', '0', '1'),
(46, 2, 23, 'published', '', '', '', '1', '1', '', '0', '1');
/*!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 */;