Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-schema]

A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc... that make up the database.Normally defined in the text, generally SQL in an RDBMS, the schema describes the complete blueprint for the database, defining everything about the database except that data itself.

1
vote
1answer
11 views

Magento 2.3.0: How to add TIMESTAMP_INIT as a default value in declarative schema?

As I'm adding CURRENT_TIMESTAMP as a default value for created_datetime and updated_datetime columns in my database table named faqs, I'm getting both the columns updated while edit the FAQ in admin ...
2
votes
3answers
38 views

How to add foreign key in db_schema.xml

I'm using magento 2.3 to create a custom module, i tried to create database tables for my custom module in etc/db_schema.xml like this: <table comment="province Table" engine="innodb" name="...
1
vote
0answers
29 views

InstallScheme Script for dynamic rows Magento 2

I have created dynamic rows on product creation form. I have to save their value in custom table and retrieve as a dropdown on frontend product detail page w.r.t product ID. I am aware of the event ...
0
votes
1answer
92 views

Magento 2 - add a custom input field below the cash on delivery radio button and save to quote_payment table

Need to add an input field below the Cash on delivery radio button. Implemented the code by this link where the input is added below COD radio but the value is not added to the database. Can anyone ...
1
vote
1answer
143 views

Magento 2 : Please upgrade your database while database is newer than required

I am getting this error when moving Magento 2 website to Google Cloud (Click to Deploy). I have merged theme files and media files and it worked fine. When I have connected to my old database it ...
0
votes
0answers
49 views

I need to create a new module to table exists with another prefix of mam

I need to create a new module and this project have tables with other prefixes, How I omit this default prefix in my file /Model/ModelTable.php this is the code inside: namespace Arkix\Zonas\Model\...
1
vote
2answers
607 views

How to create custom table in magento 2.3(via XML) by module?

After reading change log for Magento2.3, I come to know now onward in Magento we can add custom table via xml. so there would be no PHP way to create a table. So can any one tell me how can I add a ...
7
votes
2answers
2k views

Magento 2.3 : How to implement declarative schema in custom module

I install the magento 2.3 and I'm creating custom module. But, I don't know how to create custom database in magento 2.3 version.
0
votes
1answer
41 views

How to delete table from mysql when uninstall extension frommagento 2.2.6?

I have created an extension with the schema. It is installed correctly and tables are created correctly in the database. But, now I want to uninstall that extension. But with uninstall, I also want ...
0
votes
1answer
112 views

Customer_Eav db schema version is not properly set

I am using Magento 2.2.5 and getting this error. 1 exception(s): Exception #0 (Magento\Framework\Exception\LocalizedException): Please update your modules: Run "composer install" from the Magento ...