Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/vendor/magefan/module-blog/Setup/ |
<?php
/**
* Copyright © Magefan ([email protected]). All rights reserved.
* Please visit Magefan.com for license details (https://magefan.com/end-user-license-agreement).
*
* Glory to Ukraine! Glory to the heroes!
*/
namespace Magefan\Blog\Setup;
use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Adapter\AdapterInterface;
/**
* Blog setup
*/
class InstallSchema implements InstallSchemaInterface
{
/**
* {@inheritdoc}
* @SuppressWarnings(PHPMD.ExcessiveMethodLength)
*/
public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
$installer = $setup;
$installer->startSetup();
/**
* Create table 'magefan_blog_post'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_post')
)->addColumn(
'post_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['identity' => true, 'nullable' => false, 'primary' => true],
'Post ID'
)->addColumn(
'title',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => true],
'Post Title'
)->addColumn(
'meta_keywords',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Post Meta Keywords'
)->addColumn(
'meta_description',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Post Meta Description'
)->addColumn(
'identifier',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
100,
['nullable' => true, 'default' => null],
'Post String Identifier'
)->addColumn(
'content_heading',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => true],
'Post Content Heading'
)->addColumn(
'content',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'2M',
[],
'Post Content'
)->addColumn(
'creation_time',
\Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,
null,
[],
'Post Creation Time'
)->addColumn(
'update_time',
\Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,
null,
[],
'Post Modification Time'
)->addColumn(
'publish_time',
\Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,
null,
[],
'Post Publish Time'
)->addColumn(
'is_active',
\Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
null,
['nullable' => false, 'default' => '1'],
'Is Post Active'
)->addIndex(
$installer->getIdxName('magefan_blog_post', ['identifier']),
['identifier']
)->addIndex(
$setup->getIdxName(
$installer->getTable('magefan_blog_post'),
['title', 'meta_keywords', 'meta_description', 'identifier', 'content'],
AdapterInterface::INDEX_TYPE_FULLTEXT
),
['title', 'meta_keywords', 'meta_description', 'identifier', 'content'],
['type' => AdapterInterface::INDEX_TYPE_FULLTEXT]
)->setComment(
'Magefan Blog Post Table'
);
$installer->getConnection()->createTable($table);
/**
* Create table 'magefan_blog_post_store'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_post_store')
)->addColumn(
'post_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Post ID'
)->addColumn(
'store_id',
\Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
null,
['unsigned' => true, 'nullable' => false, 'primary' => true],
'Store ID'
)->addIndex(
$installer->getIdxName('magefan_blog_post_store', ['store_id']),
['store_id']
)->addForeignKey(
$installer->getFkName('magefan_blog_post_store', 'post_id', 'magefan_blog_post', 'post_id'),
'post_id',
$installer->getTable('magefan_blog_post'),
'post_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->addForeignKey(
$installer->getFkName('magefan_blog_post_store', 'store_id', 'store', 'store_id'),
'store_id',
$installer->getTable('store'),
'store_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->setComment(
'Magefan Blog Post To Store Linkage Table'
);
$installer->getConnection()->createTable($table);
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_category')
)->addColumn(
'category_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['identity' => true, 'nullable' => false, 'primary' => true],
'Category ID'
)->addColumn(
'title',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => true],
'Category Title'
)->addColumn(
'meta_keywords',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Category Meta Keywords'
)->addColumn(
'meta_description',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'64k',
['nullable' => true],
'Category Meta Description'
)->addColumn(
'identifier',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
100,
['nullable' => true, 'default' => null],
'Category String Identifier'
)->addColumn(
'content_heading',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => true],
'Category Content Heading'
)->addColumn(
'content',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'2M',
[],
'Category Content'
)->addColumn(
'path',
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => true],
'Category Path'
)->addColumn(
'position',
\Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
null,
['nullable' => false],
'Category Position'
)->addColumn(
'is_active',
\Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
null,
['nullable' => false, 'default' => '1'],
'Is Category Active'
)->addIndex(
$installer->getIdxName('magefan_blog_category', ['identifier']),
['identifier']
)->addIndex(
$setup->getIdxName(
$installer->getTable('magefan_blog_category'),
['title', 'meta_keywords', 'meta_description', 'identifier', 'content'],
AdapterInterface::INDEX_TYPE_FULLTEXT
),
['title', 'meta_keywords', 'meta_description', 'identifier', 'content'],
['type' => AdapterInterface::INDEX_TYPE_FULLTEXT]
)->setComment(
'Magefan Blog Category Table'
);
$installer->getConnection()->createTable($table);
/**
* Create table 'magefan_blog_category_store'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_category_store')
)->addColumn(
'category_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Category ID'
)->addColumn(
'store_id',
\Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
null,
['unsigned' => true, 'nullable' => false, 'primary' => true],
'Store ID'
)->addIndex(
$installer->getIdxName('magefan_blog_category_store', ['store_id']),
['store_id']
)->addForeignKey(
$installer->getFkName('magefan_blog_category_store', 'category_id', 'magefan_blog_category', 'category_id'),
'category_id',
$installer->getTable('magefan_blog_category'),
'category_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->addForeignKey(
$installer->getFkName('magefan_blog_category_store', 'store_id', 'store', 'store_id'),
'store_id',
$installer->getTable('store'),
'store_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->setComment(
'Magefan Blog Category To Store Linkage Table'
);
$installer->getConnection()->createTable($table);
/**
* Create table 'magefan_blog_post_category'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_post_category')
)->addColumn(
'post_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Post ID'
)->addColumn(
'category_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Category ID'
)->addIndex(
$installer->getIdxName('magefan_blog_post_category', ['category_id']),
['category_id']
)->addForeignKey(
$installer->getFkName('magefan_blog_post_category', 'post_id', 'magefan_blog_post', 'post_id'),
'post_id',
$installer->getTable('magefan_blog_post'),
'post_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->addForeignKey(
$installer->getFkName('magefan_blog_post_category', 'category_id', 'magefan_blog_category', 'category_id'),
'category_id',
$installer->getTable('magefan_blog_category'),
'category_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->setComment(
'Magefan Blog Post To Category Linkage Table'
);
$installer->getConnection()->createTable($table);
/**
* Create table 'magefan_blog_post_relatedproduct'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_post_relatedproduct')
)->addColumn(
'post_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Post ID'
)->addColumn(
'related_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['unsigned' => true, 'nullable' => false, 'primary' => true],
'Related Product ID'
)->addIndex(
$installer->getIdxName(
'magefan_blog_post_relatedproduct',
['related_id']
),
['related_id']
)->addForeignKey(
$installer->getFkName(
'magefan_blog_post_relatedproduct',
'post_id',
'magefan_blog_post',
'post_id'
),
'post_id',
$installer->getTable('magefan_blog_post'),
'post_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->addForeignKey(
$installer->getFkName(
'magefan_blog_post_relatedproduct',
'related_id',
'catalog_product_entity',
'entity_id'
),
'related_id',
$installer->getTable('catalog_product_entity'),
'entity_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->setComment(
'Magefan Blog Post To Product Linkage Table'
);
$installer->getConnection()->createTable($table);
/**
* Create table 'magefan_blog_post_relatedproduct'
*/
$table = $installer->getConnection()->newTable(
$installer->getTable('magefan_blog_post_relatedpost')
)->addColumn(
'post_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Post ID'
)->addColumn(
'related_id',
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['nullable' => false, 'primary' => true],
'Related Post ID'
)->addIndex(
$installer->getIdxName('magefan_blog_post_relatedproduct', ['related_id']),
['related_id']
)->addForeignKey(
$installer->getFkName('magefan_blog_post_relatedproduct1', 'post_id', 'magefan_blog_post', 'post_id'),
'post_id',
$installer->getTable('magefan_blog_post'),
'post_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->addForeignKey(
$installer->getFkName('magefan_blog_post_relatedproduct2', 'related_id', 'magefan_blog_post', 'post_id'),
'post_id',
$installer->getTable('magefan_blog_post'),
'post_id',
\Magento\Framework\DB\Ddl\Table::ACTION_CASCADE
)->setComment(
'Magefan Blog Post To Post Linkage Table'
);
$installer->getConnection()->createTable($table);
$installer->endSetup();
}
}