Questions tagged [db-schema]
The db-schema tag has no usage guidance.
13
questions
2
votes
3answers
1k 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?
2
votes
1answer
36 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&...
1
vote
2answers
104 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 ...
0
votes
2answers
2k 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?
0
votes
2answers
776 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,
['...
0
votes
2answers
144 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->...
0
votes
2answers
773 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" ...
0
votes
1answer
21 views
Unable to create table with foreign key?
<table name="profile_products" resource="default" engine="innodb" comment="profile products">
<column xsi:type="smallint" ...
0
votes
1answer
22 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
1answer
24 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.
0
votes
0answers
55 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"/>
...
0
votes
1answer
56 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 ...
-1
votes
1answer
16 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" ?>
<...
