diff -r 000000000000 -r 4eba9c11703f web/Zend/Queue/Adapter/Db/queue_sqlite.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/Zend/Queue/Adapter/Db/queue_sqlite.sql Mon Dec 13 18:29:26 2010 +0100 @@ -0,0 +1,41 @@ +/* + * @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) +); +