Magento

Questions tagged [db-schema]

Ask Question

The tag has no usage guidance.

34 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
23 views

How to add new Foriegn Key in existing table in Magento 2.4.5

I am trying to add a new foriegn key in existing table using db_schema.xml but it is not working at all I tried to delete the table and delete module from setup_module table as well but still nothing ...
Syed Hassan Zamir
  • 170
0 votes
0 answers
13 views

After new compilation , my custom module's table data was reset in magento 2?

I have a custom module with the custom table, When i am doing compilation in some time the table data was completely removing and only the empty data base table is exist. I created this table using ...
Mujahidh
  • 2,651
1 vote
1 answer
384 views

db_schema.xml setup:db-declaration:generate-whitelist: Constraints/index changes are not applied/refreshed - (Is there cached db_schema.xml?)

Magento 2.3 Question Is there any place where db_schema.xml for your module is cached/restored from? Issue I need to refresh/get the recently changed db_schema.xml changes to apply, which is not ...
CvRChameleon
  • 651
1 vote
1 answer
129 views

Magento 2: How to increase the column max length?

I want to increase the customer firstname max length so I have updated the length of that column using my custom module dbschema.xml. After updating the length, I can see the updated length in ...
Siv
  • 512
0 votes
1 answer
48 views

Custom order Status on Magento 2 programmatically

I have built a Payment Module and I want to add some custom status on table sales_order_status using etc/db_schema.xml. Is this possible? Thank you.
phpDev
  • 1
2 votes
1 answer
234 views

database schema vs schema patch in magento 2

I have doubts about the database schema and schema patch so can anyone help me to understand the difference between
Kushal Dani
  • 2,034
0 votes
2 answers
147 views

How to force my db_schema.xml to run after a third-party InstallData.php?

I'm working with a legacy module where they used the old InstallData.php script to build their tables, and now I need to make some changes to them. If I wrote those changes in a db_schema.xml, it gets ...
Code Slicer
  • 123
0 votes
1 answer
143 views

How to make id field auto increment in db_schema.xml in mageno 2.4?

I have a custom table created through db_schema.xml (code below): <?xml version="1.0"?> <schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
LosMos
  • 31
0 votes
1 answer
333 views

Magento 2 - can't add foreign key constraint with declarative schema (db_schema.xml) - Reference column X in reference table Y do not have index

I try to add this table: MODULE/etc/db_schema.xml: <?xml version="1.0"?> <schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="...
Black
  • 2,903
1 vote
3 answers
395 views

Declare length of int column in db schema

How to declare int length in Magento 2.4 db_schema file?
Vamsi Krishna
  • 21
1 vote
1 answer
157 views

can not create db_schema_whitelist.json file in magento 2.4.4

I have issue to create custom mysql table from xml schema. i have create app/code/Vendor_Name/Module_Name/etc/db_schema.xml db_schema.xml <?xml version="1.0"?> <schema xmlns:xsi=&...
ketty
  • 107
0 votes
0 answers
85 views

Compare DB changes between Magento 2.3.4 and Magento 2.4.3

I am in the middle of a migration process between Magento 2.3.4 and Magento 2.4.3. Regarding the code changes, I am in a good spot. Everything is under control. However, it is not 100% clear to me how ...
Kloppo
  • 95
0 votes
1 answer
703 views

Magento 2.3 How can add primary key constraint combination of multiple column using db_schema.xml?

There are some custom tables in the database which don't have a primary key. A single column can not be a primary key. So I want to make a primary key with the help of existing two-column combinations....
Vinod Kumar
  • 2,025
0 votes
2 answers
188 views

Is there any way to update installschema.php to dbschema.xml?

How to create dbschema.xml from installschema.php
user12
  • 1
0 votes
1 answer
179 views

setup:db-declaration:generate-whitelist does nothing - no results or errors

M2.4.3-p1. Trying to use db_schema.xml as that appears to be the way forward. setup:upgrade is not adding my tables. setup:db-declaration:generate-whitelist is not generating the whitelist. Basically ...
Adam Lavery
  • 458
0 votes
1 answer
365 views

foreign key db_schema.xml automatic renamed to FK_ magento 2

I have this db_schema.xml <?xml version="1.0"?> <!-- /** * Copyright © Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ --> <schema xmlns:xsi=&...
fudu
  • 1,228
0 votes
1 answer
758 views

Magento 2 - create a table with foreign key constraint

I try to add this database table. It has a foreign key constraint to the customer_entity table. I need to configure it so if the customer is getting deleted that record is also getting deleted. This ...
Black
  • 2,903
1 vote
3 answers
410 views

How to change table column nullable definition using declarative schema?

I have added a table using declarative schema given below: <table name="trade_item_brand_category"> <column xsi:type="int" name="id" padding="10&...
amitshree
  • 6,827
0 votes
1 answer
265 views

Magento2: what is the purpose of having db_schema_whitelist.json?

I'm looking for some sort of explanation for the below topics but I'm not able to find the exact answers on the internet. What is the need for db_schema_whitelist.json? (I have read that this file ...
Siv
  • 512
0 votes
1 answer
113 views

How to filter products out with custom created field on catalog_product_entity

I have added 2 fields in db_schema.xml there created on table catalog_product_entity the challenges for me now are I'm using the one field as custom state and this state is the field I need to filter ...
ParisNakitaKejser
  • 126
0 votes
1 answer
328 views

How to update Magento core column from type int to decimal using declarative schema?

I want to update the core table column from type int to decimal. <column xsi:type="int" name="column_name" padding="10" unsigned="true" nullable="false&...
Sri
  • 1
5 votes
1 answer
2k views

Magento 2.4 Error: The attribute 'length' is not allowed

I want to change the field type of catalogrule_product table from varchar to text. <column xsi:type="varchar" name="action_operator" nullable="true" length="10&...
VIPIN A ROY
  • 510
0 votes
1 answer
197 views

Change type of field in db (table: quote, field: customer_note, current type: varchar, wanted type: text)

I try to change the type of the field customer_note in the quote table from varchar to text. I went the declarative way: VendorName/Module/etc/db_schema.xml: <?xml version="1.0" ?> <...
Hawkeye_00
  • 11
0 votes
1 answer
36 views

Unable to create table with foreign key?

<table name="profile_products" resource="default" engine="innodb" comment="profile products"> <column xsi:type="smallint" ...
bagish
  • 1
0 votes
2 answers
1k views

Magento 2 how to increase text type field length?

I have a module where I save a PDF file in a text type field, however I just realized that the pdf was not stored completly, it misses some characters. This is how I created the field: $installer->...
Oscar Vazquez
  • 533
0 votes
1 answer
131 views

Base DB schema didn't create table

In my report_sales > coupons page I get exception Base table or view not found: 1146 Table salesrule_coupon_aggregated doesn't exist And I find out that system didn't create this table (It doesn't ...
Mikhaylo HODOVANIUK
  • 29
0 votes
1 answer
618 views

How to add created at and updated at column and update it on values save?

I want to add created_at and updated_at columns in a custom table and update both columns on saving the data.
Kazim Noorani
  • 2,771
1 vote
2 answers
4k views

Auto increment in db_schema.xml

In M2 dev docs there is this regarding auto increment: identity Indicates whether a column is auto incremented. Here's excerpt from my db_schema.xml: <column xsi:type="int" name="entity_id" ...
Vadim Shmyrov
  • 33
1 vote
1 answer
759 views

Can't create unique and fulltext index on the same column

My table in db_schema looks like below. <table name="test"> <column xsi:type="int" identity="true" name="test_id" padding="10" unsigned="true" nullable="false" comment="Entity Id"/> ...
zsDev
  • 11
0 votes
2 answers
11k views

How to create table and field using db_schema.xml in magento 2

I want to create table and fields using db_schema.xml rather than InstallSchema in custom module. Can anyone help please?
Naresh Sharma
  • 1
0 votes
1 answer
495 views

Allow tinytext in db_schema.xml magento 2

I'm doing a custom migration from Magento 1.9 to Magento 2.3.4 , in one of the custom module on Magento 1.9 it uses tinytext as table column type, therefore I tried to recreate this module using ...
jojo
  • 99
1 vote
2 answers
400 views

Magento2.3 - What is the benefit of Declarative DB Schema over Traditional installation schema for DB management?

At the Magento Imagine Conference, Magento announced the next noteworthy release on the Magento platform – Magento 2.3. It has enormous features, back-end enhancements, and optimizations. So I just ...
user avatar
user43082
3 votes
2 answers
4k views

Created at and Updated at columns using db schema xml - Magento 2

I have a custom table. Using the InstallSchema, I was able to add default values using: )->addColumn( 'created_at', \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP, null, ['...
Attila Naghi
  • 3,736
2 votes
3 answers
2k views

add custom attribute for customer in magento 2.3 using db schema

how I can add a custom attribute for customer using DB schema in Magento 2.3 does anyone is already tried Just help me?
prabhakaran7
  • 1,057

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.