Magento 2 How to create table and field using db_schema.xml
In this blog, we’re going to show you how to use the db_schema.xml file to create a new database table.
Once you Create file db_schema.xml in this directory app/code/VName/MName/etc. We will create a table named “table_name”.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd"> <table name="table_name"> <column xsi:type="int" name="id" padding="10" unsigned="true" nullable="false" comment="Entity Id"/> <column xsi:type="varchar" name="title" nullable="false" length="255" comment="Title"/> <column xsi:type="timestamp" name="time_occurred" comment="Time of event"/> <column xsi:type="int" name="status" nullable="false" default="0" comment="status"/> <column xsi:type="mediumtext" name="description" nullable="true" comment="Description"/> <constraint xsi:type="primary" referenceId="PRIMARY"> <column name="id"/> </constraint> </table> </schema> |
After will running the below command :
- php bin/magento setup:upgrade
As you run the upgrade command, a new database table will be created in your database.
If you have any questions let me know in the comment section.
Thank you!
