86 lines
3.0 KiB
PHP
86 lines
3.0 KiB
PHP
<?php
|
|
|
|
$sql = array();
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'phstickers` (
|
|
`id_sticker` int(11) NOT NULL AUTO_INCREMENT,
|
|
`price_on` int(11) NOT NULL,
|
|
`price_min` double(20,6) NOT NULL,
|
|
`price_max` double(20,6) NOT NULL,
|
|
`qty_on` int(11) NOT NULL,
|
|
`qty_min` int(11) NOT NULL,
|
|
`qty_max` int(11) NOT NULL,
|
|
`manu_on` int(11) NOT NULL,
|
|
`id_manufacturer` int(11) NOT NULL,
|
|
`date_add` datetime NOT NULL,
|
|
PRIMARY KEY (`id_sticker`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'phstickers_lang` (
|
|
`id_sticker` int(11) NOT NULL,
|
|
`file_name` varchar(500) NOT NULL,
|
|
`id_lang` int(11) NOT NULL,
|
|
PRIMARY KEY (`id_sticker`, `id_lang`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'phstickers_product` (
|
|
`id_sticker_product` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_sticker` int(11) NOT NULL,
|
|
`id_product` int(11) NOT NULL,
|
|
`position` int(11) NOT NULL,
|
|
`inherit` int(11) NOT NULL,
|
|
PRIMARY KEY (`id_sticker_product`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'phstickers_category` (
|
|
`id_sticker_category` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_sticker` int(11) NOT NULL,
|
|
`id_category` int(11) NOT NULL,
|
|
`position` int(11) NOT NULL,
|
|
PRIMARY KEY (`id_sticker_category`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;';
|
|
|
|
$date = date('Y-m-d H:i:s');
|
|
$sql[] = "INSERT INTO `"._DB_PREFIX_."phstickers` (`id_sticker`, `date_add`) VALUES
|
|
(1, '".$date."'),
|
|
(2, '".$date."'),
|
|
(3, '".$date."'),
|
|
(4, '".$date."'),
|
|
(5, '".$date."'),
|
|
(6, '".$date."'),
|
|
(7, '".$date."'),
|
|
(8, '".$date."'),
|
|
(9, '".$date."'),
|
|
(10, '".$date."'),
|
|
(11, '".$date."'),
|
|
(12, '".$date."'),
|
|
(13, '".$date."'),
|
|
(14, '".$date."'),
|
|
(15, '".$date."'),
|
|
(16, '".$date."')";
|
|
|
|
$id_lang = (int)$this->context->cookie->id_lang;
|
|
$sql[] = "INSERT INTO `"._DB_PREFIX_."phstickers_lang` (`id_sticker`, `file_name`, `id_lang`) VALUES
|
|
(1, 'darmowa-dostawa.png', ".$id_lang."),
|
|
(2, 'koncowka-promocji.png', ".$id_lang."),
|
|
(3, 'najlepsza-sprzedaz.png', ".$id_lang."),
|
|
(4, 'top-produkt.png', ".$id_lang."),
|
|
(5, 'wysoka-jakosc.png', ".$id_lang."),
|
|
(6, 'wysylka-3dni.png', ".$id_lang."),
|
|
(7, 'wysylka-7dni.png', ".$id_lang."),
|
|
(8, 'wysylka-24h.png', ".$id_lang."),
|
|
(9, 'najtanszy produkt.png', ".$id_lang."),
|
|
(10, 'ostatnie-sztuki.png', ".$id_lang."),
|
|
(11, 'wyprzedaz.png', ".$id_lang."),
|
|
(12, 'produkt-dnia.png', ".$id_lang."),
|
|
(13, 'produkt-roku.png', ".$id_lang."),
|
|
(14, 'produkt-tygodnia.png', ".$id_lang."),
|
|
(15, '100proc.png', ".$id_lang."),
|
|
(16, 'polecany.png', ".$id_lang.");";
|
|
|
|
foreach ($sql as $query) {
|
|
if (Db::getInstance()->execute($query) === false) {
|
|
return false;
|
|
}
|
|
}
|
|
return true; |