Jacek Pyziak
64bcc1a6be
- Created new index.php files for various directories to establish structure. - Added form.tpl and index.php for form helpers to enhance form handling. - Introduced suggestions.tpl and top.tpl for improved admin interface. - Implemented ajax-products.tpl and banners.tpl for front-end product display. - Developed content.tpl and widget-blocks.tpl for dynamic content rendering. - Enhanced widget-tabs.tpl and widget-wrapper.tpl for better tabbed navigation. - Included necessary licensing information in all new files.
97 lines
3.7 KiB
PHP
97 lines
3.7 KiB
PHP
<?php
|
|
/**
|
|
* 2022 Anvanto
|
|
*
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This file is not open source! Each license that you purchased is only available for 1 wesite only.
|
|
* If you want to use this file on more websites (or projects), you need to purchase additional licenses.
|
|
* You are not allowed to redistribute, resell, lease, license, sub-license or offer our resources to any third party.
|
|
*
|
|
* @author Anvanto <anvantoco@gmail.com>
|
|
* @copyright 2022 Anvanto
|
|
* @license Valid for 1 website (or project) for each purchase of license
|
|
* International Registered Trademark & Property of Anvanto
|
|
*/
|
|
|
|
if (!defined('_PS_VERSION_')) {
|
|
exit;
|
|
}
|
|
|
|
$sql = [];
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_blocks` (
|
|
`id_block` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`special_id_block` varchar(50) NOT NULL,
|
|
`type` varchar(25) NOT NULL,
|
|
`active` tinyint(1) unsigned NOT NULL DEFAULT 1,
|
|
`show_sort` tinyint(1) unsigned NOT NULL DEFAULT 0,
|
|
`products_display` int(10) NOT NULL DEFAULT 8,
|
|
`id_category` int(10) NOT NULL DEFAULT 0,
|
|
`show_sub_cat` tinyint(1) unsigned NOT NULL DEFAULT 0,
|
|
`position` int(10) NOT NULL,
|
|
PRIMARY KEY(`id_block`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_blocks_products` (
|
|
`id_block` int(10) unsigned NOT NULL,
|
|
`id_product` int(10) unsigned NOT NULL,
|
|
`position` int(10) NOT NULL,
|
|
PRIMARY KEY(`id_block`, `id_product`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_blocks_categories` (
|
|
`id_block` int(10) unsigned NOT NULL,
|
|
`id_category` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY(`id_block`, `id_category`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'an_homeproducts_blocks_shop` (
|
|
`id_block` int(10) unsigned NOT NULL,
|
|
`id_shop` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY (`id_block`, `id_shop`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_blocks_lang` (
|
|
`id_block` int(10) unsigned NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`text` text,
|
|
`link` varchar(255) NOT NULL,
|
|
`id_lang` varchar(255) NOT NULL,
|
|
PRIMARY KEY(`id_block`, `id_lang`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_banners` (
|
|
`id_banner` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`special_id_banner` varchar(50) NOT NULL,
|
|
`block` varchar(255) NOT NULL,
|
|
`block_position` int(10) unsigned NOT NULL,
|
|
`col` int(10) NOT NULL DEFAULT 12,
|
|
`color_title` varchar(20) NOT NULL,
|
|
`color_text` varchar(20) NOT NULL,
|
|
`template` varchar(255) NOT NULL,
|
|
`show_on` int(10) unsigned NOT NULL,
|
|
`active` tinyint(1) unsigned NOT NULL DEFAULT 1,
|
|
`position` int(10) NOT NULL,
|
|
PRIMARY KEY(`id_banner`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeproducts_banners_lang` (
|
|
`id_banner` int(10) unsigned NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`text` text,
|
|
`link` varchar(255) NOT NULL,
|
|
`image` varchar(255) NOT NULL,
|
|
`id_lang` varchar(255) NOT NULL,
|
|
PRIMARY KEY(`id_banner`, `id_lang`)
|
|
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'an_homeproducts_banners_shop` (
|
|
`id_banner` int(10) unsigned NOT NULL,
|
|
`id_shop` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY (`id_banner`, `id_shop`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
|
|
|
|
return $sql; |