SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;


CREATE TABLE `tl_iso_attribute` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `field_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `legend` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `optionsSource` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `options` blob DEFAULT NULL,
  `foreignKey` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `includeBlankOption` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `blankOptionLabel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `variant_option` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `be_search` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `be_filter` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `customer_defined` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `mandatory` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fe_filter` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fe_search` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fe_sorting` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `multiple` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `size` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `chosen` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `extensions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `rte` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `multilingual` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `rgxp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `placeholder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `minlength` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `maxlength` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `conditionField` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fieldType` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `files` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `filesOnly` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `isGallery` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sortBy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `path` binary(16) DEFAULT NULL,
  `rootNodes` blob DEFAULT NULL,
  `checkoutRelocate` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `checkoutTargetFolder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `checkoutTargetFile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `datepicker` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `storeFile` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `uploadFolder` binary(16) DEFAULT NULL,
  `useHomeDir` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `doNotOverwrite` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(2, 1622108971, 'Colour', 'colour', 'select', 'pricing_legend', '', 'attribute', 0x613a31303a7b693a303b613a323a7b733a353a2276616c7565223b733a353a227768697465223b733a353a226c6162656c223b733a353a225768697465223b7d693a313b613a323a7b733a353a2276616c7565223b733a363a2279656c6c6f77223b733a353a226c6162656c223b733a363a2259656c6c6f77223b7d693a323b613a323a7b733a353a2276616c7565223b733a333a22726564223b733a353a226c6162656c223b733a333a22526564223b7d693a333b613a323a7b733a353a2276616c7565223b733a363a226f72616e6765223b733a353a226c6162656c223b733a363a224f72616e6765223b7d693a343b613a323a7b733a353a2276616c7565223b733a353a22677265656e223b733a353a226c6162656c223b733a353a22477265656e223b7d693a353b613a323a7b733a353a2276616c7565223b733a343a22626c7565223b733a353a226c6162656c223b733a343a22426c7565223b7d693a363b613a323a7b733a353a2276616c7565223b733a353a22626c61636b223b733a353a226c6162656c223b733a353a22426c61636b223b7d693a373b613a323a7b733a353a2276616c7565223b733a343a2267726579223b733a353a226c6162656c223b733a343a2247726175223b7d693a383b613a323a7b733a353a2276616c7565223b733a353a2262726f776e223b733a353a226c6162656c223b733a353a22427261756e223b7d693a393b613a323a7b733a353a2276616c7565223b733a393a226c69676874626c7565223b733a353a226c6162656c223b733a383a2248656c6c626c6175223b7d7d, '', '', '', '1', '', '', '', '', '1', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', '', 0x30000000000000000000000000000000, NULL, '', '', '', '', '', 0x00000000000000000000000000000000, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(4, 1622108985, 'Size', 'size', 'select', 'pricing_legend', '', 'attribute', 0x613a343a7b693a303b613a323a7b733a353a2276616c7565223b733a313a2253223b733a353a226c6162656c223b733a313a2253223b7d693a313b613a323a7b733a353a2276616c7565223b733a313a224d223b733a353a226c6162656c223b733a313a224d223b7d693a323b613a323a7b733a353a2276616c7565223b733a313a224c223b733a353a226c6162656c223b733a313a224c223b7d693a333b613a323a7b733a353a2276616c7565223b733a323a22584c223b733a353a226c6162656c223b733a323a22584c223b7d7d, '', '', '', '1', '', '', '', '', '1', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', '', NULL, NULL, '', '', '', '', '', NULL, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(6, 1388498032, 'Tracks', 'tracks', 'text', 'general_legend', '', 'attribute', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', 'digit', '', 0, 4, '', '', '', '', '', '', NULL, NULL, '', '', '', '', '', NULL, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(8, 1388585312, 'Date', 'date', 'text', 'general_legend', '', 'attribute', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', 'date', '', 0, 0, '', '', '', '', '', '', NULL, NULL, '', '', '', '1', '', NULL, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(10, 1416419248, 'Version', 'version', 'select', 'pricing_legend', '', 'attribute', 0x613a353a7b693a303b613a323a7b733a353a2276616c7565223b733a303a22223b733a353a226c6162656c223b733a31333a22506c656173652073656c656374223b7d693a313b613a323a7b733a353a2276616c7565223b733a373a22322e31312e3136223b733a353a226c6162656c223b733a31373a22436f6e74616f20434d5320322e31312e36223b7d693a323b613a323a7b733a353a2276616c7565223b733a353a22332e302e36223b733a353a226c6162656c223b733a31363a22436f6e74616f20434d5320332e302e36223b7d693a333b613a323a7b733a353a2276616c7565223b733a353a22332e312e35223b733a353a226c6162656c223b733a31363a22436f6e74616f20434d5320332e312e35223b7d693a343b613a323a7b733a353a2276616c7565223b733a353a22332e322e37223b733a353a226c6162656c223b733a31363a22436f6e74616f20434d5320332e322e37223b7d7d, '', '', '', '1', '', '', '', '', '1', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', '', 0x30000000000000000000000000000000, NULL, '', '', '', '', '', 0x00000000000000000000000000000000, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(15, 1566481301, 'Contao-Versionen', 'contao', 'select', 'general_legend', '', 'table', NULL, NULL, '', '', '', '', '', '1', '', '', '', '', '', 5, '1', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', 'name_asc', NULL, NULL, '', 'files/orders/##document_number##/##product_position##__{{flag::##product_name##|standardize}}/##attribute_field##', '##file_target##', '', '', NULL, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(16, 1566570979, '', '', 'text', 'options_legend', '', 'attribute', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', 'name_asc', NULL, NULL, '', 'files/orders/##document_number##/##product_position##__{{flag::##product_name##|standardize}}/##attribute_field##', '##file_target##', '', '', NULL, '', '');
INSERT INTO `tl_iso_attribute` (`id`, `tstamp`, `name`, `field_name`, `type`, `legend`, `description`, `optionsSource`, `options`, `foreignKey`, `includeBlankOption`, `blankOptionLabel`, `variant_option`, `be_search`, `be_filter`, `customer_defined`, `mandatory`, `fe_filter`, `fe_search`, `fe_sorting`, `multiple`, `size`, `chosen`, `extensions`, `rte`, `multilingual`, `rgxp`, `placeholder`, `minlength`, `maxlength`, `conditionField`, `fieldType`, `files`, `filesOnly`, `isGallery`, `sortBy`, `path`, `rootNodes`, `checkoutRelocate`, `checkoutTargetFolder`, `checkoutTargetFile`, `datepicker`, `storeFile`, `uploadFolder`, `useHomeDir`, `doNotOverwrite`) VALUES(18, 1618304474, 'Featured', 'featured', 'checkbox', 'general_legend', 'Wählen Sie diese Option aus um bestimmte Produkte z. B. in einem eigenen Bereich auf der Startseite hervorzuheben.', 'name', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 5, '', 'jpg,jpeg,gif,png', '', '', '', '', 0, 0, '', '', '', '', '', 'name_asc', NULL, NULL, '', 'files/orders/##document_number##/##product_position##__{{flag::##product_name##|standardize}}/##attribute_field##', '##file_target##', '', '', NULL, '', '');


ALTER TABLE `tl_iso_attribute`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`);


ALTER TABLE `tl_iso_attribute`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
COMMIT;

/*!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 */;
