Questions tagged [db-schema]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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?