qUvBWsex

1// memo for Zend_Queue_Adapter_Db/mysql's sql  => sqlite3
2// *****this wouldn' work now
3CREATE TABLE IF NOT EXISTS `message` (
4  `message_id` INTEGER PRIMARY KEY,
5  `queue_id` int(10) NOT NULL,
6  `handle` char(32) default NULL,
7  `body` varchar(8192) NOT NULL,
8  `md5` char(32) NOT NULL,
9  `timeout` decimal(14,4) default NULL,
10  `created` int(10) NOT NULL,
11  UNIQUE (`handle`, `queue_id`)
12);