Creating the MySQL database tables manually
Use the SQL scripts that are provided in the MobileFirst Server installation to create the MySQL database tables.
Before you begin
About this task
As described in Setting up databases, all the four MobileFirst Server components need tables. They can be created in the same schema or in different schemas. However, some constraints apply depending on how the MobileFirst Server applications are deployed to the Java™ application server. They are the similar to the topic about the possible users for MySQL as described in Database users and privileges.
- Installation with the Server Configuration Tool
- The same database is used for all components (MobileFirst Server administration service, MobileFirst Server live update service, MobileFirst Server push service, and MobileFirst runtime)
- Installation with Ant tasks
- The sample Ant files that are provided in the product distribution
use the same database for all components. However, it is possible
to modify the Ant files to have different database:
- The same database for the administration service and the live update service as they cannot be installed separately with Ant tasks.
- A different database for the runtime
- A different database for the push service.
- Manual installation
- It is possible to assign a different data source, and thus a different database, to each of the MobileFirst Server components.
The scripts to create the tables are as follows:
- For the administration service, in mfp_install_dir/MobileFirstServer/databases/create-mfp-admin-mysql.sql.
- For the live update service, in mfp_install_dir/MobileFirstServer/databases/create-configservice-mysql.sql.
- For the runtime component, in mfp_install_dir/MobileFirstServer/databases/create-runtime-mysql.sql.
- For the push service, in mfp_install_dir/PushService/databases/create-push-mysql.sql.
The following example creates the tables for all the applications for the same user and database. It assumes that a database and a user has been created as in 'Requirements for the databases/MySQL'
The following procedure creates the tables for all the applications for the same user (mfpuser) and database (MFPDATA). It assumes that a database and a user are already created. For more information, see MySQL database and user requirements.