Skip to main content
View as Markdown

Changing the Database

Read this page before you write code if your core contribution adds or changes Application Dictionary records (tables, columns, windows, messages and so on) or the database schema. It explains how to get official IDs from the central ID server and how iDempiere records your changes as migration scripts for your pull request.

Plug-in changes do not need official IDs. Ship them with 2Pack or with migration scripts in the plug-in instead.

TL;DR​

  1. Ask for a user name and password for the central ID server in the forum or on Mattermost.
  2. Set the DICTIONARY_ID_* keys in the System Configurator. See Configure the ID server.
  3. Log in as System Administrator. In Preference, turn on Dictionary Maintenance and Log Migration Scripts, and enter a Migration Script Comment with the ticket number. Turn both options on again after every login, because they are not saved.
  4. Create or change the dictionary records. New records get IDs below 1,000,000 from the central ID server.
  5. Review the generated migration script, remove failed or unrelated statements, and commit it with your code.

Pages in this section​