Guest User

Untitled

a guest
Dec 17th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. namespace Vendor\ModuleName\Setup;
  2.  
  3. use Magento\Framework\Setup\UpgradeSchemaInterface;
  4. use Magento\Framework\Setup\ModuleContextInterface;
  5. use Magento\Framework\Setup\SchemaSetupInterface;
  6. class UpgradeSchema implements UpgradeSchemaInterface
  7. {
  8. public function upgrade(SchemaSetupInterface $setup,
  9. ModuleContextInterface $context){
  10. $setup->startSetup();
  11. if (version_compare($context->getVersion(), '1.0.1') < 0) {
  12.  
  13. // Get module table
  14. $tableName = $setup->getTable('table_name');
  15.  
  16. // Check if the table already exists
  17. if ($setup->getConnection()->isTableExists($tableName) == true) {
  18. // Declare data
  19. $columns = [
  20. 'imagename' => [
  21. 'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
  22. 'nullable' => false,
  23. 'comment' => 'image name',
  24. ],
  25. ];
  26.  
  27. $connection = $setup->getConnection();
  28. foreach ($columns as $name => $definition) {
  29. $connection->addColumn($tableName, $name, $definition);
  30. }
  31.  
  32. }
  33. }
  34.  
  35. $setup->endSetup();
  36. }
  37. }
Add Comment
Please, Sign In to add comment