Questions tagged [db-schema]
The db-schema tag has no usage guidance.
9
questions
0
votes
1answer
16 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
14 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
2answers
91 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
0answers
32 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
2answers
437 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
1answer
19 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
vote
2answers
45 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
245 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,
['...
2
votes
3answers
686 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?
