Customizing the Database Schema

You can use the platform to customize the database of an MYOB Acumatica instance. The database customization can include changes in both the data and the schema of the database.

To change the database schema, you can add to a customization project the following scripts:

• A script to create a custom table
• A script to create a custom column in an existing table
• A script to create an extension table for an existing table
• A custom script

When you publish a customization project with a database script, which changes the database schema, the script is executed. Changes to the database schema aren't deleted when you unpublish the project or delete the script and publish the project once more. You have to remove the changes to the database schema manually.

For detailed information on creating custom database scripts and adding the scripts to a customization project, see the following topics:

• To Create a Custom Table
• To Create a Custom Column in an Existing Table
• To Create an Extension Table
• To Add a Custom SQL Script to a Customization Project