- Commerce Tutorials
- Getting Started
- Commerce Cloud
- Commerce for Developers
- Commerce for Business Users
- 1.1 - Admin Menus
- 1.2 - Data Grids
- 1.3 - Scopes, Sites, and Stores
- 1.4 - Store Views and Caches
- 1.5 - Admin User Accounts and Roles
- 1.6 - Role Scopes
- 1.7 - Business Settings
- 2.1 - Categories
- 2.2 - Category Landing Pages
- 3.1 - Product Types and Options
- 3.2 - Product Settings
- 3.3 - Product Attributes
- 3.4 - Product Attribute Sets
- 3.5 - Create a Simple Product
- 3.6 - Configurable Attributes
- 3.7 - Import/Export Products
- 3.8 - Gift Cards
- 4.1 - Layered Navigation
- 4.2 - Arrange Product Categories
- 5.1 - Storefront Experience
- 5.2 - Customer Management
- 5.3 - Email Communications
- 5.4 - Global Reference Architecture
- GraphQL and REST
- Adobe Developer App Builder
- Store Administration
- Customer Management
- Catalog Management
- Content Management
- Marketing Tools
- Orders and Fulfillment
- B2B for Adobe Commerce
- Tools and External services
- MBI
- Commerce Upgrades
- Backend Development
- Native Frontend Luma Development
- Headless Architecture
Add a table to a database
IMPORTANT
This is no longer recommended, please refer to https://developer.adobe.com/commerce/php/development/components/declarative-schema/
Commerce has a special mechanism that enables you to create database tables, modify existing ones, and even add some data into them - like setup data, which has to be added when a module is installed. This mechanism allows those changes to be transferable between different installations.
Rather than doing manual SQL operations repeatedly when reinstalling the system, developers create an install (or upgrade) script that contains the data. The script runs every time a module is installed.
Who is this video for?
- Developers
Video content
- Create a module
- Create InstallSchema Script
- Create InstallData Script
- Add new module and verify that a table with data was created
- Create an UpgradeSchema script
- Create an UpgradeData script
- Run upgrade scripts and verify that the table has changed
Useful resources
Business.Adobe.com resources
Resources
Adobe Account
Change language
Copyright © 2023 Adobe. All Rights Reserved.
