Questions tagged [db-schema]

The tag has no usage guidance.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
28 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&...
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
23 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
52 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" ?> <...