Lesson 3: Creating a table to store push request

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.

Prérequis

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.

Task

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.

Résultat

A push request table is created for storing push requests.

Suivant

Proceed to Lesson 4: Creating a MobiLink project.

Lesson 3: Creating a table to store push request

Task

See also