Altering and Creating Database Fields

The iEnterprise Mobile™ Server Application allows the creation of new database fields, as well as changing the length of existing fields. This section has been included for reference only as the necessity of these actions is rare.

New fields should only be created if there are none available for mapping. Adding fields is not supported and is done so at your own risk. The ability to perform future upgrades may be affected which can require additional consultation and programming to complete.

It is recommended that you back up your current configuration prior to making any changes by exporting the current configuration scripts.

To create a new database field:

Select Utility in the Navigation Menu on the left of the page.
Select Configuration Tools in the Navigation Menu.
You will be prompted to enter your MySQL username and password. These are different than the standard Administrator login information.
Click on a module name to select the module you wish to add a field to.
Select the button next to New in the box labelled Fields
Type the name of the field you wish to create and select the character length using the drop down selection box in the New Length column.
Click Execute to save.

To alter the length of an existing field:

Select Utility in the Navigation Menu on the left of the page.
Select Configuration Tools in the Navigation Menu.
You will be prompted to enter your MySQL username and password:
Click on a module name to select the module that contains the field you wish to change the length of.
Select the button next to Update in the box labeled Fields:
Select a field from the drop down selection list.
Select a new field length in the New Length dropdown selection list.
Click Execute to save.