Questions tagged [db-schema]
The db-schema tag has no usage guidance.
35
questions
5
votes
1
answer
3k
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&...
- 510
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,
['...
- 3,775
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?
- 1,057
2
votes
1
answer
323
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
- 2,044
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" ...
1
vote
2
answers
12k
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?
1
vote
2
answers
422
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 ...
user43082
1
vote
1
answer
831
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"/>
...
- 11
1
vote
3
answers
533
views
Declare length of int column in db schema
How to declare int length in Magento 2.4 db_schema file?
1
vote
1
answer
220
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=&...
- 107
1
vote
1
answer
573
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 ...
- 651
1
vote
1
answer
166
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 ...
- 512
1
vote
3
answers
471
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&...
- 6,847
0
votes
2
answers
2k
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->...
- 533
0
votes
2
answers
219
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 ...
- 143
0
votes
1
answer
825
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....
- 2,025
0
votes
2
answers
199
views
Is there any way to update installschema.php to dbschema.xml?
How to create dbschema.xml from installschema.php
- 1
0
votes
0
answers
4
views
Create a custom component to create display design options in admin and design option dropdown and selected will be displayed on product page
Create a custom component to add/edit/delete and view the detail of design information into admin. Associate the multiple design option to product and show selected design option product detail page.
...
- 541
0
votes
1
answer
27
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 ...
0
votes
0
answers
14
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 ...
- 2,651
0
votes
1
answer
57
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.
- 1
0
votes
1
answer
178
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:...
- 31
0
votes
1
answer
423
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="...
- 2,993
0
votes
0
answers
91
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 ...
- 95
0
votes
1
answer
209
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 ...
- 457
0
votes
1
answer
413
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=&...
- 1,228
0
votes
1
answer
837
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 ...
- 2,993
0
votes
1
answer
303
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 ...
- 512
0
votes
1
answer
138
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 ...
0
votes
1
answer
353
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&...
- 1
0
votes
1
answer
230
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" ?>
<...
- 11
0
votes
1
answer
38
views
Unable to create table with foreign key?
<table name="profile_products" resource="default" engine="innodb" comment="profile products">
<column xsi:type="smallint" ...
- 1
0
votes
1
answer
170
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 ...
0
votes
1
answer
725
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.
- 2,821
0
votes
1
answer
559
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 ...
- 119