--- TABLE deliverq
---
-CREATE TABLE IF NOT EXISTS `deliverq` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `cmd` varbinary(32) NOT NULL DEFAULT '',
- `item` int(11) NOT NULL DEFAULT 0,
- `contact` int(11) NOT NULL DEFAULT 0,
- PRIMARY KEY(`id`),
- UNIQUE INDEX `cmd_item_contact` (`cmd`,`item`,`contact`)
-) DEFAULT CHARSET=utf8mb4;
+-- TABLE conversation
+--
+CREATE TABLE IF NOT EXISTS `conversation` (
+ `item-uri` varbinary(255) NOT NULL,
+ `reply-to-uri` varbinary(255) NOT NULL DEFAULT '',
+ `conversation-uri` varbinary(255) NOT NULL DEFAULT '',
+ `conversation-href` varbinary(255) NOT NULL DEFAULT '',
+ `protocol` tinyint(1) unsigned NOT NULL DEFAULT 0,
+ `source` mediumtext,
+ `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
+ PRIMARY KEY(`item-uri`),
+ INDEX `conversation-uri` (`conversation-uri`)
+) DEFAULT COLLATE utf8mb4_general_ci;