aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-11-16 14:23:00 -0800
committerfriendica <info@friendica.com>2012-11-16 14:23:00 -0800
commit661d418222f97a3fca18357b9d136b5817e2450d (patch)
treed028bbb6577b95a2e1b234cdf16e5fe35d876822
parent125d1283acbb6f5756ce1569b6d5739aae9ee3d2 (diff)
downloadvolse-hubzilla-661d418222f97a3fca18357b9d136b5817e2450d.tar.gz
volse-hubzilla-661d418222f97a3fca18357b9d136b5817e2450d.tar.bz2
volse-hubzilla-661d418222f97a3fca18357b9d136b5817e2450d.zip
DATABASE: minor changes in group_member and outq tables
-rw-r--r--install/database.sql22
1 files changed, 7 insertions, 15 deletions
diff --git a/install/database.sql b/install/database.sql
index 3c80247df..c1746455d 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -439,12 +439,12 @@ CREATE TABLE IF NOT EXISTS `group_member` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL,
`gid` int(10) unsigned NOT NULL,
- `contact-id` int(10) unsigned NOT NULL,
+ `xchan` char(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `gid` (`gid`),
- KEY `contact-id` (`contact-id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ KEY `xchan` (`xchan`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `guid` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
@@ -591,13 +591,6 @@ CREATE TABLE IF NOT EXISTS `item_id` (
KEY `iid` (`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-CREATE TABLE IF NOT EXISTS `locks` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` char(128) NOT NULL,
- `locked` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
CREATE TABLE IF NOT EXISTS `mail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`aid` int(10) unsigned NOT NULL DEFAULT '0',
@@ -681,16 +674,15 @@ 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_posturl` 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_notify` mediumtext NOT NULL,
`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_hub` (`outq_posturl`),
KEY `outq_created` (`outq_created`),
KEY `outq_updated` (`outq_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -887,7 +879,7 @@ CREATE TABLE IF NOT EXISTS `term` (
KEY `term` (`term`),
KEY `uid` (`uid`),
KEY `aid` (`aid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `tokens` (
`id` varchar(40) NOT NULL,