Add New Column in admin_user table Magento 2.

You can add a new column field under the admin_user core table using the db_schema.xml file for Magento 2.3 and the Higher version.

The client has a requirement like, store the current user location based on their geographical area. Continue reading “Add New Column in admin_user table Magento 2.”

Create Unique Key Column in db_schema.xml file Magento 2.

Unique Key column in the database table used to avoid the duplication of data in the same column.

Using a unique column key, Table gives guarantees to unique value for the column from the set of records in a table. Continue reading “Create Unique Key Column in db_schema.xml file Magento 2.”

Drop or remove Table from Database using DataPatchInterface Magento 2.

Drop or Remove a database Table in Magento 2 using the Setup folder DataPatchInterface approach.

From Magento 2.3 New Concept Setup Patch¬† Data was introduced. Continue reading “Drop or remove Table from Database using DataPatchInterface Magento 2.”