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 */;
--
-- Datenbank: `BLLA`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ttemplateeinstellungen`
--
CREATE TABLE `ttemplateeinstellungen` (
`cTemplate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cSektion` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cWert` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Daten für Tabelle `ttemplateeinstellungen`
--
INSERT INTO `ttemplateeinstellungen` (`cTemplate`, `cSektion`, `cName`, `cWert`) VALUES
('NOVA', 'general', 'use_minify', 'N'),
('NOVA', 'general', 'use_cron', 'N'),
('NOVA', 'theme', 'theme_default', 'clear'),
('NOVA', 'theme', 'slider_full_width', 'N'),
('NOVA', 'theme', 'banner_full_width', 'N'),
('NOVA', 'theme', 'static_header', 'Y'),
('NOVA', 'megamenu', 'show_categories', 'Y'),
('NOVA', 'megamenu', 'show_maincategory_info', 'Y'),
('NOVA', 'megamenu', 'show_category_images', 'Y'),
('NOVA', 'megamenu', 'show_subcategories', 'Y'),
('NOVA', 'megamenu', 'show_pages', 'Y'),
('NOVA', 'megamenu', 'show_manufacturers', 'N'),
('NOVA', 'productlist', 'hover_productlist', 'N'),
('NOVA', 'productlist', 'variation_select_productlist', 'N'),
('NOVA', 'productlist', 'variation_max_werte_productlist', '3'),
('NOVA', 'productlist', 'initial_display_filter', 'Y'),
('NOVA', 'productlist', 'filter_max_options', '5'),
('NOVA', 'productlist', 'ribbon_type', 'c'),
('NOVA', 'productlist', 'ribbon_position', 'top-left'),
('NOVA', 'sidebar_settings', 'always_show_price_range', 'Y'),
('NOVA', 'footer', 'newsletter_footer', 'N'),
('NOVA', 'footer', 'socialmedia_footer', 'N'),
('NOVA', 'footer', 'facebook', ''),
('NOVA', 'footer', 'twitter', ''),
('NOVA', 'footer', 'youtube', ''),
('NOVA', 'footer', 'xing', ''),
('NOVA', 'footer', 'linkedin', ''),
('NOVA', 'footer', 'vimeo', ''),
('NOVA', 'footer', 'instagram', ''),
('NOVA', 'footer', 'pinterest', ''),
('NOVA', 'footer', 'skype', '');
--
-- Indizes der exportierten Tabellen
--
--
-- Indizes für die Tabelle `ttemplateeinstellungen`
--
ALTER TABLE `ttemplateeinstellungen`
ADD KEY `kTemplateEinstellungenSektion` (`cTemplate`,`cSektion`,`cName`);
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 */;