1 /*

     2  * @version    $Id: queue_sqlite.sql 20874 2010-02-03 13:14:59Z matthew $

     3 Sample grant for SQLite

     4 

     5 CREATE ROLE queue LOGIN

     6   PASSWORD '[CHANGE ME]'

     7   NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;

     8 

     9 */

    10 

    11 --

    12 -- Table structure for table `queue`

    13 --

    14 

    15 CREATE TABLE queue

    16 (

    17   queue_id INTEGER PRIMARY KEY AUTOINCREMENT,

    18   queue_name VARCHAR(100) NOT NULL,

    19   timeout INTEGER NOT NULL DEFAULT 30

    20 );

    21 

    22 

    23 

    24 

    25 -- --------------------------------------------------------

    26 --

    27 -- Table structure for table `message`

    28 --

    29 

    30 CREATE TABLE message

    31 (

    32   message_id INTEGER PRIMARY KEY AUTOINCREMENT,

    33   queue_id INTEGER PRIMARY KEY,

    34   handle CHAR(32),

    35   body VARCHAR(8192) NOT NULL,

    36   md5 CHAR(32) NOT NULL,

    37   timeout REAL,

    38   created INTEGER,

    39   FOREIGN KEY (queue_id) REFERENCES queue(queue_id)

    40 );

    41