File indexing completed on 2025-01-19 05:21:24

 /*
  * @version    $Id$
 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)
 );