Current path: home/webdevt/www/schtroumpf.fr/modules/an_homeslider/sql/
?? Go up: /home/webdevt/www/schtroumpf.fr/modules/an_homeslider
<?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_homeslider_sliders` (
`id_slider` int(10) unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) unsigned NOT NULL DEFAULT 1,
`hook` varchar(255) NOT NULL,
`preloader` tinyint(1) unsigned NOT NULL DEFAULT 1,
`preloader_height_1920` int(10) unsigned NOT NULL,
`preloader_height_1600` int(10) unsigned NOT NULL,
`preloader_height_1366` int(10) unsigned NOT NULL,
`preloader_height_991` int(10) unsigned NOT NULL,
`preloader_height_767` int(10) unsigned NOT NULL,
`lazy_load` tinyint(1) unsigned NOT NULL DEFAULT 1,
`loop` tinyint(1) unsigned NOT NULL DEFAULT 1,
`nav` tinyint(1) unsigned NOT NULL DEFAULT 1,
`dots` tinyint(1) unsigned NOT NULL DEFAULT 1,
`autoplay` tinyint(1) unsigned NOT NULL DEFAULT 1,
`smartspeed` int(10) unsigned NOT NULL,
`autoplay_timeout` int(10) unsigned NOT NULL,
`responsive_image` tinyint(1) unsigned NOT NULL DEFAULT 1,
`show_on` int(10) unsigned NOT NULL,
`show_content_on` int(10) unsigned NOT NULL,
PRIMARY KEY(`id_slider`)
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeslider_slides` (
`id_slide` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_parent` int(10) unsigned NOT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 1,
`show_button` tinyint(1) unsigned NOT NULL DEFAULT 1,
`position` int(10) NOT NULL,
PRIMARY KEY(`id_slide`)
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeslider_slides_lang` (
`id_slide` int(10) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`text` text,
`text_of_button` varchar(255) NOT NULL,
`link` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`id_lang` varchar(255) NOT NULL,
PRIMARY KEY(`id_slide`, `id_lang`)
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'an_homeslider_sliders_lang` (
`id_slider` int(10) unsigned NOT NULL,
`title_slider` varchar(255) NOT NULL,
`id_lang` varchar(255) NOT NULL,
PRIMARY KEY(`id_lang`, `id_slider`)
) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET = utf8';
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'an_homeslider_slides_shop` (
`id_slide` int(10) unsigned NOT NULL,
`id_shop` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_slide`, `id_shop`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'an_homeslider_sliders_shop` (
`id_slider` int(10) unsigned NOT NULL,
`id_shop` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_slider`, `id_shop`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
return $sql;