<?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-report
* @version 1.3.101
* @copyright Copyright (C) 2020 Mirasvit (https://mirasvit.com/)
*/



namespace Mirasvit\Report\Setup\UpgradeSchema;

use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Mirasvit\Report\Api\Data\EmailInterface;

class UpgradeSchema101 implements UpgradeSchemaInterface
{
/**
* @param SchemaSetupInterface $installer
* @param ModuleContextInterface $context
* @throws \Zend_Db_Exception
*/
public function upgrade(SchemaSetupInterface $installer, ModuleContextInterface $context)
{
$table = $installer->getConnection()->newTable(
$installer->getTable('mst_report_email')
)->addColumn(
EmailInterface::ID,
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
null,
['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
'Email Id'
)->addColumn(
EmailInterface::TITLE,
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => false],
'Title'
)->addColumn(
EmailInterface::IS_ACTIVE,
\Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
1,
['nullable' => false, 'default' => 0],
'Is Active'
)->addColumn(
EmailInterface::SUBJECT,
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => false],
'Subject'
)->addColumn(
EmailInterface::RECIPIENT,
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => false],
'Recipient'
)->addColumn(
EmailInterface::SCHEDULE,
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
255,
['nullable' => false],
'Schedule'
)->addColumn(
EmailInterface::BLOCKS_SERIALIZED,
\Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'64k',
['nullable' => false],
'Content'
)->setComment(
'Report Email'
);

$installer->getConnection()->createTable($table);
}
}