Adding objects to main.dbi

To add objects to main.dbi, do the following:

1. Open the main.dbi file in the text editor that is located in the Axxon PSIM root folder.

2. Add objects to main.dbi. For this, you must specify the name used for the object identification in brackets and then declare its fields. The fields' declaration syntax looks in the following way:
   <Field name>, <Type> [, <Size>] 

   Note

   You can set Size only with the fields of the CHAR type.

   The table below shows the fields mandatory for all objects in Axxon PSIM.

   Field	Description
   id	Unique object ID
   name	Object name
   parent_id	Parent object ID
   flags	Parameter for internal system use

   Attention!

   The flags field cannot be used by external applications.

   The following table describes the allowed data types.

   Data type	Description
   BIT	Used for creating the flag field that takes logical values "Yes" or "No"
   CHAR	Used for fields that are filled in by the small number of characters
   DATETIME	Used for fields in which you must enter the date and time. The date format is YYYY-MM-DD, and the time format is HH:MM:SS.XXX
   DOUBLE	Used for fields that contain floating-point numbers
   INTEGER	Used for fields that contain integer numbers
   SMALLINT	Used for fields that contain integer numbers in the range from -32 768 to 32 767
   TEXT	Used for fields that contain text strings
   UNIQUEIDENTIFIER	Used for fields where you must enter unique identifiers that guarantee the uniqueness not only within the table but also between different databases and servers

   Besides the mandatory fields for the objects of the DEMO module, the following fields are added:

   1. port—COM port address;
   2. address—device address.
   The result of adding objects and declaring fields in main.dbi is given in the figure.
   
3. Save the changes to the main.dbi file.
4. Run the idb.exe utility that is located in the Axxon PSIM root folder.
   
   
5. From the Select data source: list, select Basic data (1).
6. Click the Update database button (2).
   As a result, the process of updating the database structure starts. The progress is displayed in the Protocol window of the idb.exe utility.
   
   
7. Click the OK button to shut down the idb.exe utility.

As a result of the structure update, tables are created in the Axxon PSIM configuration database.