|
Apache/2.4.41 (Ubuntu) Linux vmi616275.contaboserver.net 5.4.0-84-generic #94-Ubuntu SMP Thu Aug 26 20:27:37 UTC 2021 x86_64 uid=33(www-data) gid=33(www-data) groups=33(www-data) server ip : 62.171.164.128 | your ip : 127.0.0.1 safemode OFF > / home / Mirasvit / SearchLanding / Setup / |
Filename | /home/Mirasvit/SearchLanding/Setup/InstallSchema.php |
Size | 3.1 kb |
Permission | rw-r--r-- |
Owner | root : root |
Create time | 01-Jul-2024 20:52 |
Last modified | 06-Apr-2021 18:06 |
Last accessed | 22-Aug-2025 01:16 |
Actions | edit | rename | delete | download (gzip) |
View | text | code | image |
<?php
/**
* Mirasvit
*
* This source file is subject to the Mirasvit Software License, which is available at https://mirasvit.com/license/.
* Do not edit or add to this file if you wish to upgrade the to newer versions in the future.
* If you wish to customize this module for your needs.
* Please refer to http://www.magentocommerce.com for more information.
*
* @category Mirasvit
* @package mirasvit/module-search-landing
* @version 1.0.10
* @copyright Copyright (C) 2020 Mirasvit (https://mirasvit.com/)
*/
namespace Mirasvit\SearchLanding\Setup;
use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;
use Mirasvit\Search\Api\Data\IndexInterface;
use Mirasvit\Search\Api\Repository\IndexRepositoryInterface;
use Mirasvit\SearchLanding\Api\Data\PageInterface;
use Mirasvit\SearchLanding\Model\Page;
class InstallSchema implements InstallSchemaInterface
{
/**
* {@inheritdoc}
* @SuppressWarnings(PHPMD)
*/
public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
$installer = $setup;
/**
* Create table 'mst_search_landing_page'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('mst_search_landing_page')
)->addColumn(
PageInterface::ID,
Table::TYPE_INTEGER,
null,
['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
'Page Id'
)->addColumn(
PageInterface::QUERY_TEXT,
Table::TYPE_TEXT,
255,
['nullable' => false],
'Query Text'
)->addColumn(
PageInterface::URL_KEY,
Table::TYPE_TEXT,
255,
['nullable' => false],
'Url Key'
)->addColumn(
PageInterface::TITLE,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::META_DESCRIPTION,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::META_KEYWORDS,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::LAYOUT_UPDATE,
Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Layout Update'
)->addColumn(
PageInterface::STORE_IDS,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Store Ids'
)->addColumn(
'is_active',
Table::TYPE_INTEGER,
1,
['nullable' => false, 'default' => '0'],
'Is Active'
)->setComment(
'Landing Page'
);
$installer->getConnection()->dropTable($installer->getTable('mst_search_landing_page'));
$installer->getConnection()->createTable($table);
}
}
/**
* Mirasvit
*
* This source file is subject to the Mirasvit Software License, which is available at https://mirasvit.com/license/.
* Do not edit or add to this file if you wish to upgrade the to newer versions in the future.
* If you wish to customize this module for your needs.
* Please refer to http://www.magentocommerce.com for more information.
*
* @category Mirasvit
* @package mirasvit/module-search-landing
* @version 1.0.10
* @copyright Copyright (C) 2020 Mirasvit (https://mirasvit.com/)
*/
namespace Mirasvit\SearchLanding\Setup;
use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;
use Mirasvit\Search\Api\Data\IndexInterface;
use Mirasvit\Search\Api\Repository\IndexRepositoryInterface;
use Mirasvit\SearchLanding\Api\Data\PageInterface;
use Mirasvit\SearchLanding\Model\Page;
class InstallSchema implements InstallSchemaInterface
{
/**
* {@inheritdoc}
* @SuppressWarnings(PHPMD)
*/
public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
$installer = $setup;
/**
* Create table 'mst_search_landing_page'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('mst_search_landing_page')
)->addColumn(
PageInterface::ID,
Table::TYPE_INTEGER,
null,
['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
'Page Id'
)->addColumn(
PageInterface::QUERY_TEXT,
Table::TYPE_TEXT,
255,
['nullable' => false],
'Query Text'
)->addColumn(
PageInterface::URL_KEY,
Table::TYPE_TEXT,
255,
['nullable' => false],
'Url Key'
)->addColumn(
PageInterface::TITLE,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::META_DESCRIPTION,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::META_KEYWORDS,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Title'
)->addColumn(
PageInterface::LAYOUT_UPDATE,
Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Layout Update'
)->addColumn(
PageInterface::STORE_IDS,
Table::TYPE_TEXT,
255,
['nullable' => true],
'Store Ids'
)->addColumn(
'is_active',
Table::TYPE_INTEGER,
1,
['nullable' => false, 'default' => '0'],
'Is Active'
)->setComment(
'Landing Page'
);
$installer->getConnection()->dropTable($installer->getTable('mst_search_landing_page'));
$installer->getConnection()->createTable($table);
}
}