Chapter 5. Install Database Schema

After creating the schema you are now ready to install the openCRX database schema. Start the MySQL Query Browser. Select the schema crx-CRX, then create a new script tab with File -> New Script Tab. Copy/paste the database script dbcreate-tables.sql and execute it as shown in Figure 5-1.

Figure 5-1. Install Database Schema

enlarge

Similarly, load and exec the files dbcreate-indexs.sql and dbcreate-views.sql.

The scripts should run without errors. After execution the pane Schemata should list all created tables as shown in Figure 5-2.

Figure 5-2. Verify the schema installation.

enlarge

Similarly, load and exec the files dbcreate-indexs.sql.

The script dbcreate-views.sql is not supported for MySQL.