Ttdfjt

How can I improve readability and length of a method with many if statements?

How many times to repeat an event with known probability before it has occurred a number of times

How to ask if I can mow my neighbor's lawn

logarithmic rules with functions

newcommand with parameter blank or zero

Is it a bad idea to have an pen name with only an initial for a surname?

Is it possible to install Firefox on Ubuntu with no desktop enviroment?

Leveraging cash for buying car

How can religions without a hell discourage evil-doing?

Will users know a CardView is clickable

For Saintsbury, which English novelists constituted the "great quartet of the mid-eighteenth century"?

Can artificial satellite positions affect tides?

Manager wants to hire me; HR does not. How to proceed?

How to search for Android apps without ads?

Is there a term for someone whose preferred policies are a mix of Left and Right?

Reflecting Telescope Blind Spot?

Print the phrase "And she said, 'But that's his.'" using only the alphabet

Cant bend fingertip when finger is straight

Is it possible for underground bunkers on different continents to be connected?

Having some issue with notation in a Hilbert space

Why not make one big CPU core?

Why can't we feel the Earth's revolution?

How do I become a better writer when I hate reading?

How could I create a situation in which a PC has to make a saving throw or be forced to pet a dog?

Magento2: How to add new column in admin_user table?

how i can get the column value of admin user table in magento 2Can I remove module info from Column “Extra” in Magento Admin_User Table?Magento2 InstallSchema add new column to existing tableHow to add new column in quote_item table?magento 2 - How to add new column to table customer_grid_flatMagento 2 How to Add a New Column to Orders GridMagento 2 add new column to existing table on a running webshopMagento2 - Add Custom Column in cart item table and insert data to custom column when product add to cartHow to Join custom table to customer grid collection and show new column in Grid in Magento2How to add New Column in Magento 2 beginning of the table using Magento 2 way?Magento 2 How to Add a New Column to Newsletter Subscribers Grid

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

How to add a new column in admin_user table Magento 2 ?

magento2 admin-user installdata

share|improve this question

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

add a comment | 

0

How to add a new column in admin_user table Magento 2 ?

magento2 admin-user installdata

share|improve this question

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

add a comment | 

How to add a new column in admin_user table Magento 2 ?

magento2 admin-user installdata

share|improve this question

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

share|improve this question

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

share|improve this question

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

edited Jun 8 at 6:17

Teja Bhagavan Kollepara

2,92942051

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

asked Jun 8 at 4:58

prabhakaran7prabhakaran7

33513

1 Answer
1

active

oldest

votes

1

app/code/vendor/modulename/Setup/UpgradeSchema.php

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;

use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupSchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface



public function upgrade(SchemaSetupInterface $setup,

ModuleContextInterface $context)

$setup->startSetup();

if (version_compare($context->getVersion(), '1.0.1') < 0) 

// Get module table

$tableName = $setup->getTable('admin_user');

// Check if the table already exists

if ($setup->getConnection()->isTableExists($tableName) == true) 

// Declare data

$columns = [

'tok_value' => [

'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,

'nullable' => true,

'comment' => 'Token Value',

],

];

$connection = $setup->getConnection();

foreach ($columns as $name => $definition) 

$connection->addColumn($tableName, $name, $definition);









$setup->endSetup();

Note: If you face any issue, it may be due to the module that you have already installed. As you know, if the module is already installed then setup:upgrade command does not install schema. You will need to look into your setup_module table, delete your module from the table and re-run the php bin/magento setup:upgrade command.

share|improve this answer

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  why i get down vote...
  
  – prabhakaran7
  Jun 8 at 7:09
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277685%2fmagento2-how-to-add-new-column-in-admin-user-table%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

app/code/vendor/modulename/Setup/UpgradeSchema.php

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;

use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupSchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface



public function upgrade(SchemaSetupInterface $setup,

ModuleContextInterface $context)

$setup->startSetup();

if (version_compare($context->getVersion(), '1.0.1') < 0) 

// Get module table

$tableName = $setup->getTable('admin_user');

// Check if the table already exists

if ($setup->getConnection()->isTableExists($tableName) == true) 

// Declare data

$columns = [

'tok_value' => [

'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,

'nullable' => true,

'comment' => 'Token Value',

],

];

$connection = $setup->getConnection();

foreach ($columns as $name => $definition) 

$connection->addColumn($tableName, $name, $definition);









$setup->endSetup();

Note: If you face any issue, it may be due to the module that you have already installed. As you know, if the module is already installed then setup:upgrade command does not install schema. You will need to look into your setup_module table, delete your module from the table and re-run the php bin/magento setup:upgrade command.

share|improve this answer

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  why i get down vote...
  
  – prabhakaran7
  Jun 8 at 7:09
  

  
  
  
  

add a comment | 

1

app/code/vendor/modulename/Setup/UpgradeSchema.php

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;

use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupSchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface



public function upgrade(SchemaSetupInterface $setup,

ModuleContextInterface $context)

$setup->startSetup();

if (version_compare($context->getVersion(), '1.0.1') < 0) 

// Get module table

$tableName = $setup->getTable('admin_user');

// Check if the table already exists

if ($setup->getConnection()->isTableExists($tableName) == true) 

// Declare data

$columns = [

'tok_value' => [

'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,

'nullable' => true,

'comment' => 'Token Value',

],

];

$connection = $setup->getConnection();

foreach ($columns as $name => $definition) 

$connection->addColumn($tableName, $name, $definition);









$setup->endSetup();

Note: If you face any issue, it may be due to the module that you have already installed. As you know, if the module is already installed then setup:upgrade command does not install schema. You will need to look into your setup_module table, delete your module from the table and re-run the php bin/magento setup:upgrade command.

share|improve this answer

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  why i get down vote...
  
  – prabhakaran7
  Jun 8 at 7:09
  

  
  
  
  

add a comment | 

app/code/vendor/modulename/Setup/UpgradeSchema.php

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;

use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupSchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface



public function upgrade(SchemaSetupInterface $setup,

ModuleContextInterface $context)

$setup->startSetup();

if (version_compare($context->getVersion(), '1.0.1') < 0) 

// Get module table

$tableName = $setup->getTable('admin_user');

// Check if the table already exists

if ($setup->getConnection()->isTableExists($tableName) == true) 

// Declare data

$columns = [

'tok_value' => [

'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,

'nullable' => true,

'comment' => 'Token Value',

],

];

$connection = $setup->getConnection();

foreach ($columns as $name => $definition) 

$connection->addColumn($tableName, $name, $definition);









$setup->endSetup();

Note: If you face any issue, it may be due to the module that you have already installed. As you know, if the module is already installed then setup:upgrade command does not install schema. You will need to look into your setup_module table, delete your module from the table and re-run the php bin/magento setup:upgrade command.

share|improve this answer

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;

use MagentoFrameworkSetupModuleContextInterface;

use MagentoFrameworkSetupSchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface



public function upgrade(SchemaSetupInterface $setup,

ModuleContextInterface $context)

$setup->startSetup();

if (version_compare($context->getVersion(), '1.0.1') < 0) 

// Get module table

$tableName = $setup->getTable('admin_user');

// Check if the table already exists

if ($setup->getConnection()->isTableExists($tableName) == true) 

// Declare data

$columns = [

'tok_value' => [

'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,

'nullable' => true,

'comment' => 'Token Value',

],

];

$connection = $setup->getConnection();

foreach ($columns as $name => $definition) 

$connection->addColumn($tableName, $name, $definition);









$setup->endSetup();

share|improve this answer

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

edited Jun 8 at 7:04

divya sekar

504118

edited Jun 8 at 7:04

divya sekar

504118

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513

answered Jun 8 at 5:22

prabhakaran7prabhakaran7

33513