Questions tagged [ddl]
The ddl tag has no usage guidance.
5
questions
2
votes
2answers
131 views
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() ...
2
votes
0answers
227 views
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.
6
votes
2answers
3k views
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);
...
0
votes
1answer
152 views
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 ...
1
vote
1answer
670 views
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';...
