/*

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

Sample grant for SQLite

CREATE ROLE queue LOGIN

  PASSWORD '[CHANGE ME]'

  NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;

*/

--

-- Table structure for table `queue`

--

CREATE TABLE queue

(

  queue_id INTEGER PRIMARY KEY AUTOINCREMENT,

  queue_name VARCHAR(100) NOT NULL,

  timeout INTEGER NOT NULL DEFAULT 30

);

-- --------------------------------------------------------

--

-- Table structure for table `message`

--

CREATE TABLE message

(

  message_id INTEGER PRIMARY KEY AUTOINCREMENT,

  queue_id INTEGER PRIMARY KEY,

  handle CHAR(32),

  body VARCHAR(8192) NOT NULL,

  md5 CHAR(32) NOT NULL,

  timeout REAL,

  created INTEGER,

  FOREIGN KEY (queue_id) REFERENCES queue(queue_id)

);