In this lesson, you create a push request table for storing push requests. The Notifier sends a message to a device when it detects a push request.
This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up the consolidated database.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Configuring server-initiated synchronization using gateways.
You should be connected to your database in Interactive SQL from the previous lesson.
If you are not connected to your database, you can start Interactive SQL from Sybase Central or at a command prompt.
To start Interactive SQL from Sybase Central, right-click the MLconsolidated - DBA database and click Open Interactive SQL.
To start Interactive SQL at a command prompt, run the following command:
dbisql -c "dsn=sis_cons"
Run the following SQL statements in Interactive SQL:
CREATE TABLE PushRequest ( req_id INTEGER DEFAULT AUTOINCREMENT PRIMARY KEY, mluser VARCHAR(128), subject VARCHAR(128), content VARCHAR(128), resend_interval VARCHAR(30) DEFAULT '20s', time_to_live VARCHAR(30) DEFAULT '1m', status VARCHAR(128) DEFAULT 'created' ) COMMIT;
Close Interactive SQL.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|