CREATE TABLE IF NOT EXISTS `PREFIX_pp_carousel` (
    `id_carousel` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `hook_name` VARCHAR(128) NOT NULL DEFAULT 'displayHome',
    `source_type` VARCHAR(20) NOT NULL DEFAULT 'new',
    `id_category` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `product_ids` TEXT,
    `limit_products` INT(11) UNSIGNED NOT NULL DEFAULT 12,
    `button_url` VARCHAR(512) DEFAULT '',
    `position` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
    `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT 1,
    `date_add` DATETIME NOT NULL,
    `date_upd` DATETIME NOT NULL,
    PRIMARY KEY (`id_carousel`),
    KEY `hook_name` (`hook_name`),
    KEY `active` (`active`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `PREFIX_pp_carousel_lang` (
    `id_carousel` INT(11) UNSIGNED NOT NULL,
    `id_lang` INT(11) UNSIGNED NOT NULL,
    `title` VARCHAR(255) DEFAULT '',
    `subtitle` VARCHAR(255) DEFAULT '',
    `button_label` VARCHAR(255) DEFAULT '',
    `price_suffix` VARCHAR(64) DEFAULT '',
    PRIMARY KEY (`id_carousel`, `id_lang`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4;