@@verze
4
@@sql
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
CREATE TABLE `mod_eshop_landings_cache` (  `idparametr` int(11) NOT NULL,  `jazyk` int(11) NOT NULL,  `escaped_value` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `original_value` varchar(200) COLLATE utf8_czech_ci NOT NULL,  PRIMARY KEY (`idparametr`,`jazyk`,`escaped_value`),  KEY `escaped_value` (`escaped_value`),  KEY `original_value` (`original_value`),  KEY `jazyk` (`jazyk`),  CONSTRAINT `mod_eshop_landings_cache_ibfk_2` FOREIGN KEY (`idparametr`) REFERENCES `mod_eshop_landings_parametr` (`idparametr`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_group` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `ipopis` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `param_names` varchar(500) COLLATE utf8_czech_ci NOT NULL,  `kateg` int(11) DEFAULT NULL,  `allow_other` tinyint(4) DEFAULT '1',  `sitemap` tinyint(4) NOT NULL COMMENT 'Má se dávat do sitemapy?',  `text_nadpis` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_title` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_popis` text COLLATE utf8_czech_ci NOT NULL,  `text_description` text COLLATE utf8_czech_ci NOT NULL,  PRIMARY KEY (`id`),  KEY `kategorie` (`kateg`),  CONSTRAINT `mod_eshop_landings_group_ibfk_1` FOREIGN KEY (`kateg`) REFERENCES `mod_eshop_kategorie` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_group2parametr` (  `idgroup` int(11) NOT NULL,  `idparametr` int(11) NOT NULL,  KEY `idgroup` (`idgroup`),  KEY `idparametr` (`idparametr`),  CONSTRAINT `mod_eshop_landings_group2parametr_ibfk_3` FOREIGN KEY (`idgroup`) REFERENCES `mod_eshop_landings_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,  CONSTRAINT `mod_eshop_landings_group2parametr_ibfk_5` FOREIGN KEY (`idparametr`) REFERENCES `mod_eshop_landings_parametr` (`idparametr`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_page` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `ipopis` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `as_string` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `kateg` int(11) DEFAULT NULL,  `text_nadpis` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_title` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_popis` text COLLATE utf8_czech_ci NOT NULL,  `text_description` text COLLATE utf8_czech_ci NOT NULL,  PRIMARY KEY (`id`),  KEY `kateg` (`kateg`),  CONSTRAINT `mod_eshop_landings_page_ibfk_1` FOREIGN KEY (`kateg`) REFERENCES `mod_eshop_kategorie` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_page2parametr` (  `idpage` int(11) NOT NULL,  `idparametr` int(11) NOT NULL,  `value` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL COMMENT 'Null znamená pro jakoukoliv hodnotu',  KEY `value` (`value`(10)),  KEY `idpage` (`idpage`),  KEY `idparametr` (`idparametr`),  CONSTRAINT `mod_eshop_landings_page2parametr_ibfk_3` FOREIGN KEY (`idpage`) REFERENCES `mod_eshop_landings_page` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,  CONSTRAINT `mod_eshop_landings_page2parametr_ibfk_5` FOREIGN KEY (`idparametr`) REFERENCES `mod_eshop_landings_parametr` (`idparametr`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_parametr` (  `idparametr` int(11) NOT NULL,  `priorita` int(11) NOT NULL,  `prefix_url` varchar(32) COLLATE utf8_czech_ci DEFAULT NULL,  `always_prefix` tinyint(4) NOT NULL,  `placeholder` varchar(32) COLLATE utf8_czech_ci DEFAULT NULL,  `sitemap` tinyint(4) NOT NULL DEFAULT '1',  `text_nadpis` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_title` varchar(200) COLLATE utf8_czech_ci NOT NULL,  `text_popis` text COLLATE utf8_czech_ci NOT NULL,  `text_description` text COLLATE utf8_czech_ci NOT NULL,  PRIMARY KEY (`idparametr`),  UNIQUE KEY `prefix_url` (`prefix_url`),  UNIQUE KEY `placeholder` (`placeholder`),  CONSTRAINT `mod_eshop_landings_parametr_ibfk_2` FOREIGN KEY (`idparametr`) REFERENCES `mod_eshop_parametr` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
CREATE TABLE `mod_eshop_landings_sklonovani` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `slovo` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s2` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s3` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s4` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s5` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s6` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `s7` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `sa` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `sb` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `sc` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `sd` varchar(50) COLLATE utf8_czech_ci NOT NULL,  `se` varchar(50) COLLATE utf8_czech_ci NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `slovo` (`slovo`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
@@conf+:eshop_conf.php
$povolit_landings = true;
@@conf:landings_conf_auto.php
$urlPrefix="katalog"; 
$maxSitemapDepth=1; 
$vedlejsiKategorie=false; 
@@reflection
if (!isset($moduly["eshop"])) return "nelze";
eval(nactinastavenimodulu("eshop"));
if (isset($povolit_landings) and $povolit_landings) return "ano";
return "ne";