Jordan Morin
84 lines
2.8 KiB
PHP
84 lines
2.8 KiB
PHP
<?php
|
|
|
|
namespace Edeclic\News\Setup;
|
|
|
|
use Magento\Framework\Setup\UpgradeSchemaInterface;
|
|
use Magento\Framework\Setup\ModuleContextInterface;
|
|
use Magento\Framework\Setup\SchemaSetupInterface;
|
|
use Magento\Framework\DB\Ddl\Table;
|
|
|
|
class UpgradeSchema implements UpgradeSchemaInterface
|
|
{
|
|
/**
|
|
* Upgrades DB schema for a module
|
|
*
|
|
* @param SchemaSetupInterface $setup
|
|
* @param ModuleContextInterface $context
|
|
* @return void
|
|
*/
|
|
public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
|
|
{
|
|
$installer = $setup;
|
|
$installer->startSetup();
|
|
|
|
// Action to do if module version is less than 1.0.0.0
|
|
if (version_compare($context->getVersion(), '1.1.0') < 0) {
|
|
|
|
$tableName = $installer->getTable('edeclic_news');
|
|
$setup->getConnection()->addColumn($tableName,'img_miniature',[
|
|
'type' => Table::TYPE_TEXT,
|
|
'length' => 255,
|
|
'unsigned' => true,
|
|
'nullable' => false,
|
|
'default' => '',
|
|
'comment' => 'image miniature'
|
|
]);
|
|
|
|
$setup->getConnection()->addColumn($tableName,'img_grande',[
|
|
'type' => Table::TYPE_TEXT,
|
|
'length' => 255,
|
|
'unsigned' => true,
|
|
'nullable' => false,
|
|
'default' => '',
|
|
'comment' => 'grande image'
|
|
]);
|
|
|
|
}
|
|
if (version_compare($context->getVersion(), '1.2.0') < 0) {
|
|
$tableName = $installer->getTable('edeclic_news');
|
|
$setup->getConnection()->addColumn($tableName,'store_ids',[
|
|
'type' => Table::TYPE_TEXT,
|
|
'length' => 255,
|
|
'unsigned' => true,
|
|
'nullable' => false,
|
|
'default' => '',
|
|
'comment' => 'store view'
|
|
]);
|
|
}
|
|
if (version_compare($context->getVersion(), '1.3.0') < 0) {
|
|
$tableName = $installer->getTable('edeclic_news');
|
|
$setup->getConnection()->addColumn($tableName,'description_courte',[
|
|
'type' => Table::TYPE_TEXT,
|
|
'length' => 255,
|
|
'unsigned' => true,
|
|
'nullable' => false,
|
|
'default' => '',
|
|
'comment' => 'description courte'
|
|
]);
|
|
}
|
|
if (version_compare($context->getVersion(), '1.4.0') < 0) {
|
|
$tableName = $installer->getTable('edeclic_news');
|
|
$setup->getConnection()->addColumn($tableName,'url',[
|
|
'type' => Table::TYPE_TEXT,
|
|
'length' => 50,
|
|
'unsigned' => true,
|
|
'nullable' => false,
|
|
'default' => '',
|
|
'comment' => 'url'
|
|
]);
|
|
}
|
|
$setup->endSetup();
|
|
}
|
|
|
|
|
|
} |