Modifying Schema and Catalog Data
Modifying Schema and Catalog Data
The following steps outline how to modify the database schema and catalog data.
Schema Modifications
- Open schema-customizations-changelog.xml, located in extensions/database/ext-data/src/main/resources/schema.
- Add one or more changesets to schema-customizations-changelog.xml with the desired changes. For details on the possible database modifications you can make using changesets, see the Liquibase Changeset Refactoring manual.
- Run the Data Population tool to update the database as described in Populate the Database.
Once a changeset has been committed, it must never be edited. Instead, commit additional changesets to counteract your change.
Data Modifications
When you're working on the initial implementation of a project, the catalog data you create will usually be used for testing or for deployment to all environments. Test data should be added to the extensions/database/ext-data/src/main/resources/data/test-data folder and data for all environments to the extensions/database/ext-data/src/main/resources/data/rel-1.0-data folder.
Easiest ways to create catalog data:
- Use the Commerce Manager Client to configure the catalog and export the changes using the Import/Export tool.
- Manually create the Import/Export XML files using the data in the commerce-data project as examples.
Then run the Data Population tool to update the database as described in Populate the Database.
Unlike Liquibase changes sets which only process once, Import/Export change sets process every time the Data Population tool runs in your local development environment.
For more more information, see: