Create the rockwell_ab

Create the rockwell_ab_clgx table

This table is required by the ControlLogix beans. Create the table either via the MySQL Administrator tool or via the command line.

Creating the table via MySQL Administrator.

Open the MySQL Administrator by navigating to Start->Programs->MySQL->MySQL Administrator. You will see a screen similar to Figure 3.22, “MySQL Administrator (Main screen)”.
Click on Catalogs, which is the last entry on the menu on the left part of screen. You will see a screen similar to the one below.
Figure 5.1. MySQL Administrator (Catalogs)
Click on mysql under Schemata from the menu on the bottom left. You will see a screen similar to the one below.
Figure 5.2. MySQL Administrator (mysql)
In Figure 5.2, “MySQL Administrator (mysql)”, click on the Create Table button and you will see a screen similar to the one below.
Figure 5.3. MySQL Table Editor (empty)
Populate Figure 5.3, “MySQL Table Editor (empty)” by creating the columns shown below. Click Apply Changes when you are done.
Figure 5.4. MySQL Table Editor (populated)
You will now a see a window as shown below. Click Execute.
Figure 5.5. Confirm Table Edit window
The table creation is now complete.

Creating the table via Command Line Client. If the command line client is used, issue the following commands.

CREATE TABLE `mysql`.`rockwell_ab_clgx` (
  `hashstring` VARCHAR(15) NOT NULL PRIMARY KEY,
  `name` VARCHAR(30),
  `location` LONGBLOB,
  `abbrv_to_descriptor_map` LONGBLOB,
  `tag_names` LONGBLOB,
  `program_names` LONGBLOB,
  `epath` LONGBLOB,
  `tag_descriptors` LONGBLOB,
  `string_details_map` LONGBLOB,
  `struct_details_map` LONGBLOB
)
TYPE = InnoDB;
commit;

Use the Command line client to examine and confirm the structure of the rockwell_ab_clgx table using the describe command.

desc rockwell_ab_clgx;

The following should be displayed.

+-------------------------+-------------+------+-----+---------+-------+
| Field                   | Type        | Null | Key | Default | Extra |
+-------------------------+-------------+------+-----+---------+-------+
| hashstring              | varchar(15) |      | PRI |         |       |
| name                    | varchar(30) | YES  |     | NULL    |       |
| location                | longblob    | YES  |     | NULL    |       |
| abbrv_to_descriptor_map | longblob    | YES  |     | NULL    |       |
| tag_names               | longblob    | YES  |     | NULL    |       |
| program_names           | longblob    | YES  |     | NULL    |       |
| epath                   | longblob    | YES  |     | NULL    |       |
| tag_descriptors         | longblob    | YES  |     | NULL    |       |
| string_details_map      | longblob    | YES  |     | NULL    |       |
| struct_details_map      | longblob    | YES  |     | NULL    |       |
+-------------------------+-------------+------+-----+---------+-------+


Grant the user rights to the MySQL schema