aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-10-17 16:18:36 -0700
committerfriendica <info@friendica.com>2012-10-17 16:18:36 -0700
commita680eb3a73710eb38fc6e77fb79d017f4a20c6a5 (patch)
treef6dd2a08b359fe1a79a61881df84572d3f6a850e /database.sql
parentcdeb43f987862a3955700c6ac7b3b84231e5e062 (diff)
downloadvolse-hubzilla-a680eb3a73710eb38fc6e77fb79d017f4a20c6a5.tar.gz
volse-hubzilla-a680eb3a73710eb38fc6e77fb79d017f4a20c6a5.tar.bz2
volse-hubzilla-a680eb3a73710eb38fc6e77fb79d017f4a20c6a5.zip
output queue (merges the old deliverq and queue and adds some zotness)
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql18
1 files changed, 18 insertions, 0 deletions
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',