Create the database tables manually

When you install the Push Service SDK, the setup application can create database tables automatically or you can create the tables manually. If you don't 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 server-side push initiator that is deployed on the server, or the distribution package without Apache Tomcat.

  1. On the Home screen for the MySQL Workbench, in the SQL Development section, double-click the new connection that you created.
  2. On your computer, navigate to the folder containing the database scripts. In Windows, the default location is C:/BPSS/pushsdk-high-level/database-scripts/mysql.
  3. Double-click the pushsdk_schema_mysql.sql file and copy the contents of the file.
  4. On the SQL Editor screen, in the SQL Statements section, paste the contents of pushsdk_schema_mysql.sql file.
  5. Click Execute.

Last modified: 2015-06-11

Got questions about leaving a comment? Get answers from our Disqus FAQ.

comments powered by Disqus