Create the database tables manually
The setup application can create database tables when you install the Push Service SDK or you can create the tables manually if you prefer. If you choose not to let the setup application create the database tables, the setup application displays the SQL scripts that you can copy and use to create the database tables manually. To retrieve the SQL scripts, you can also navigate to the pushsdk_schema_mysql.sql file in the high-level distribution after you run the setup application.
Before you begin, run the Push Service SDK setup application to install either the distribution package with Apache Tomcat and the sample Push Initiators deployed on the server or the distribution package without Apache Tomcat.
- On the Home screen for the MySQL Workbench, in the SQL Development section, double-click the new connection that you created.
- On your computer, navigate to the folder containing the database scripts. For Windows the default location is C:/BPSS/pushsdk-high-level/database-scripts/mysql.
- Double-click pushsdk_schema_mysql.sql and copy the contents of the file.
- On the SQL Editor screen, in the SQL Statements section, paste the contents of pushsdk_schema_mysql.sql.
- Click Execute.