Lesson 3: Structure a push request

The Notifier sends a message to a device when it detects a push request.

To create a simple table for storing push requests

  1. Execute the following command 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;

  2. Close Interactive SQL.

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1