Create the Oracle database tables manually

For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.

Create the Oracle database tables manually

Use the SQL scripts that are provided in the MobileFirst Server installation to create the Oracle database tables.

Before you begin
The Oracle database must fulfill the requirement as described in Oracle database and user requirements.

As described in Set 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. The details are described in Database users and privileges.
The tables must be created in the default schema of the runtime user. The scripts to create the tables are as follows:
For the administration service, in mfp_install_dir/MobileFirstServer/databases/create-mfp-admin-oracle.sql.
For the live update service, in mfp_install_dir/MobileFirstServer/databases/create-configservice-oracle.sql.
For the runtime component, in mfp_install_dir/MobileFirstServer/databases/create-runtime-oracle.sql.
For the push service, in mfp_install_dir/PushService/databases/create-push-oracle.sql.

The following procedure creates the tables for all the applications for the same user (MFPUSER). It assumes that a database and a user are already created. For more information, see Oracle database and user requirements.

Procedure

Run the following commands in Oracle SQLPlus:
CONNECT MFPUSER/MFPUSER_password@ORCL
@mfp_install_dir/MobileFirstServer/databases/create-mfp-admin-oracle.sql
@mfp_install_dir/MobileFirstServer/databases/create-configservice-oracle.sql
@mfp_install_dir/MobileFirstServer/databases/create-runtime-oracle.sql
@mfp_install_dir/PushService/databases/create-push-oracle.sql
DISCONNECT;
If the tables are created by MFPUSER, this user has the privileges on the tables automatically and can use them at run time. The tables are created in the user's default schema. If we want to restrict the privileges of the runtime user as described in Database users and privileges or have a finer control of privileges, refer to the Oracle documentation.

Parent topic: Create the database tables manually