Jacek Pyziak
e888c81aef
- Created `pp_carousel.tpl` for rendering product carousel with Swiper integration. - Added `plan.md` detailing module architecture, database schema, and implementation steps. - Initialized log files for development and production environments.
28 lines
1.1 KiB
SQL
28 lines
1.1 KiB
SQL
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;
|