magento 2 add unique key on multiple columns using installschemaMagento2 InstallSchema add new column to existing tableCollection addAttributeToSelect multiple columns in queryMagento 2 - Display eav attribute in customer grid (explanation & questions)How can I add UNIQUE Constraint in table via 'InstallSchema'?Notice: Undefined index: modules in ../Converter.php line 47 - Magento 2 - (Solved)Product showing “out of stock” and php error while saving again. magento 2PDOException: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'magento 2 cannot add text swatch option via php codeDeleted ShipperHQ module causing error in “All Customers” section of Magento 2Error Add Foreign Key Using Install Schema Magento 2
Alternative to sending password over mail?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Forgetting the musical notes while performing in concert
Watching something be piped to a file live with tail
What mechanic is there to disable a threat instead of killing it?
Size of subfigure fitting its content (tikzpicture)
How could indestructible materials be used in power generation?
How do I handle a potential work/personal life conflict as the manager of one of my friends?
Why can't we play rap on piano?
How does a predictive coding aid in lossless compression?
What exploit are these user agents trying to use?
What does “the session was packed” mean in this context?
Why doesn't using multiple commands with a || or && conditional work?
What's the in-universe reasoning behind sorcerers needing material components?
Should I cover my bicycle overnight while bikepacking?
Dreadful Dastardly Diseases, or Always Atrocious Ailments
How dangerous is XSS?
Gatling : Performance testing tool
How to show a landlord what we have in savings?
Avoiding direct proof while writing proof by induction
Could the museum Saturn V's be refitted for one more flight?
How to compactly explain secondary and tertiary characters without resorting to stereotypes?
How do I deal with an unproductive colleague in a small company?
How can saying a song's name be a copyright violation?
magento 2 add unique key on multiple columns using installschema
Magento2 InstallSchema add new column to existing tableCollection addAttributeToSelect multiple columns in queryMagento 2 - Display eav attribute in customer grid (explanation & questions)How can I add UNIQUE Constraint in table via 'InstallSchema'?Notice: Undefined index: modules in ../Converter.php line 47 - Magento 2 - (Solved)Product showing “out of stock” and php error while saving again. magento 2PDOException: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'magento 2 cannot add text swatch option via php codeDeleted ShipperHQ module causing error in “All Customers” section of Magento 2Error Add Foreign Key Using Install Schema Magento 2
Here i am trying to create unique key using installSchema . Array of
column names is defined here on which columns combinedly i want to
apply unique key
$arrayOfColumnsName = array('column1', 'column2');
here defined the addIndex method for creating the unique key
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
$arrayOfColumnsName,
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
$arrayOfColumnsName,
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
This creates unique key for only first column instead of both columns, needs help for the same
php database magento2.2
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Here i am trying to create unique key using installSchema . Array of
column names is defined here on which columns combinedly i want to
apply unique key
$arrayOfColumnsName = array('column1', 'column2');
here defined the addIndex method for creating the unique key
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
$arrayOfColumnsName,
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
$arrayOfColumnsName,
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
This creates unique key for only first column instead of both columns, needs help for the same
php database magento2.2
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Here i am trying to create unique key using installSchema . Array of
column names is defined here on which columns combinedly i want to
apply unique key
$arrayOfColumnsName = array('column1', 'column2');
here defined the addIndex method for creating the unique key
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
$arrayOfColumnsName,
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
$arrayOfColumnsName,
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
This creates unique key for only first column instead of both columns, needs help for the same
php database magento2.2
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Here i am trying to create unique key using installSchema . Array of
column names is defined here on which columns combinedly i want to
apply unique key
$arrayOfColumnsName = array('column1', 'column2');
here defined the addIndex method for creating the unique key
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
$arrayOfColumnsName,
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
$arrayOfColumnsName,
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
This creates unique key for only first column instead of both columns, needs help for the same
php database magento2.2
php database magento2.2
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
TusharGTusharG
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 mins ago
TusharGTusharG
12
asked 5 mins ago
TusharGTusharG
12
12
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
TusharG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Try This :-
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
['column1','column2'],
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
['column1','column2'],
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
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
);
);
TusharG is a new contributor. Be nice, and check out our Code of Conduct.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268667%2fmagento-2-add-unique-key-on-multiple-columns-using-installschema%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try This :-
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
['column1','column2'],
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
['column1','column2'],
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
add a comment |
Try This :-
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
['column1','column2'],
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
['column1','column2'],
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
add a comment |
Try This :-
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
['column1','column2'],
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
['column1','column2'],
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
Try This :-
->addIndex(
$installer->getIdxName(
$installer->getTable('table_name'),
['column1','column2'],
MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE
),
['column1','column2'],
['type' => MagentoFrameworkDBAdapterAdapterInterface::INDEX_TYPE_UNIQUE]
)
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
answered 2 mins ago
Ronak RathodRonak Rathod
1,018212
1,018212
add a comment |
add a comment |
TusharG is a new contributor. Be nice, and check out our Code of Conduct.
TusharG is a new contributor. Be nice, and check out our Code of Conduct.
TusharG is a new contributor. Be nice, and check out our Code of Conduct.
TusharG is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268667%2fmagento-2-add-unique-key-on-multiple-columns-using-installschema%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
