<?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;