Skip to main content

Questions tagged [ddl]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
2 answers

User Error: DDL statements are not allowed in transactions Magento 2.2.6

I want to achieve following functionality: Whenever user tries to insert new data, i want to remove all old data from my custom table and insert new data. For this, i want to use truncateTable() ...
Khushbu's user avatar
  • 825
2 votes
0 answers

What is the DDL cache, and what is it used for?

I never found any resource what the DDL cache is used for, and what kind of data it contains. Also it always worked for me, so I had no need to look into this yet.
Flyingmana's user avatar
  • 6,137
6 votes
2 answers

How to set CURRENT_TIMESTAMP as a default value in Magento DDL

I am updating my table structure and everything work good, but default value for column created_at is 0000-00-00 00:00:00 again and again. I want it to be equal to current time (CURRENT_TIMESTAMP); ...
Kyrylo Romantsov's user avatar
0 votes
1 answer

What `null` size means in Framework/DB/Ddl/Table.php?

I refer to this file, function addColumn I need to confirm whether I have understood correctly or not the null value of field size. When I set size null , does this mean that the index's size will be ...
Irini Koutaki's user avatar
1 vote
1 answer

Magento 2: Any Difference between TYPE_NUMERIC and TYPE_DECIMAL?

In Magento 2's migration/data-definition-language, there are two column type constants #File: vendor/magento/framework/DB/Ddl/Table.php const TYPE_NUMERIC = 'numeric'; const TYPE_DECIMAL = 'decimal';...
Alana Storm's user avatar
  • 44.4k