From a680eb3a73710eb38fc6e77fb79d017f4a20c6a5 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 17 Oct 2012 16:18:36 -0700
Subject: output queue (merges the old deliverq and queue and adds some
 zotness)

---
 database.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index fc162833a..c096c0f12 100644
--- a/database.sql
+++ b/database.sql
@@ -660,6 +660,24 @@ CREATE TABLE IF NOT EXISTS `notify-threads` (
   KEY `receiver-uid` (`receiver-uid`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `outq` (
+  `outq_hash` char(255) NOT NULL,
+  `outq_account` int(10) unsigned NOT NULL DEFAULT '0',
+  `outq_channel` int(10) unsigned NOT NULL DEFAULT '0',
+  `outq_xchan` char(255) NOT NULL DEFAULT '',
+  `outq_hub` char(255) NOT NULL DEFAULT '',
+  `outq_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `outq_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `outq_msg` mediumtext NOT NULL,
+  PRIMARY KEY (`outq_hash`),
+  KEY `outq_account` (`outq_account`),
+  KEY `outq_channel` (`outq_channel`),
+  KEY `outq_xchan` (`outq_xchan`),
+  KEY `outq_hub` (`outq_hub`),
+  KEY `outq_created` (`outq_created`),
+  KEY `outq_updated` (`outq_updated`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 CREATE TABLE IF NOT EXISTS `pconfig` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL DEFAULT '0',
-- 
cgit v1.2.3

