Lesson 3: Create 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.

 To create a simple table for storing push requests

  1. Connect to your database using Interactive SQL.

    You can start Interactive SQL from Sybase Central or from a command prompt.

    • To start Interactive SQL from Sybase Central, right-click the sis_cons - DBA database and click Open Interactive SQL.

    • To start Interactive SQL at a command prompt, run the following command:

      dbisql -c "dsn=sis_cons"

  2. Run the following SQL script 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;

  3. Close Interactive SQL.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0