aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-10-04 03:13:57 -0700
committerfriendica <info@friendica.com>2012-10-04 03:13:57 -0700
commitff43d62e445422a40271855dcd9933499da501fa (patch)
tree2a44942f74e86f1a0f1ad240dc040689a3a776d6 /database.sql
parente124c9fa5ca046d48eb927fe80706cf6d42f6bff (diff)
downloadvolse-hubzilla-ff43d62e445422a40271855dcd9933499da501fa.tar.gz
volse-hubzilla-ff43d62e445422a40271855dcd9933499da501fa.tar.bz2
volse-hubzilla-ff43d62e445422a40271855dcd9933499da501fa.zip
add hash to channel structure for consistency/redundancy
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql10
1 files changed, 7 insertions, 3 deletions
diff --git a/database.sql b/database.sql
index 67a789aff..0488a9243 100644
--- a/database.sql
+++ b/database.sql
@@ -100,7 +100,9 @@ CREATE TABLE IF NOT EXISTS `channel` (
`channel_primary` tinyint(1) unsigned NOT NULL DEFAULT '0',
`channel_name` char(255) NOT NULL DEFAULT '',
`channel_address` char(255) NOT NULL DEFAULT '',
- `channel_global_id` char(255) NOT NULL DEFAULT '',
+ `channel_guid` char(255) NOT NULL DEFAULT '',
+ `channel_guid_sig` char(255) NOT NULL DEFAULT '',
+ `channel_hash` char(255) NOT NULL DEFAULT '',
`channel_timezone` char(128) NOT NULL DEFAULT 'UTC',
`channel_location` char(255) NOT NULL DEFAULT '',
`channel_theme` char(255) NOT NULL DEFAULT '',
@@ -133,7 +135,6 @@ CREATE TABLE IF NOT EXISTS `channel` (
KEY `channel_primary` (`channel_primary`),
KEY `channel_name` (`channel_name`),
KEY `channel_address` (`channel_address`),
- KEY `channel_global_id` (`channel_global_id`),
KEY `channel_timezone` (`channel_timezone`),
KEY `channel_location` (`channel_location`),
KEY `channel_theme` (`channel_theme`),
@@ -152,7 +153,10 @@ CREATE TABLE IF NOT EXISTS `channel` (
KEY `channel_w_comment` (`channel_w_comment`),
KEY `channel_w_mail` (`channel_w_mail`),
KEY `channel_w_photos` (`channel_w_photos`),
- KEY `channel_w_chat` (`channel_w_chat`)
+ KEY `channel_w_chat` (`channel_w_chat`),
+ KEY `channel_guid` (`channel_guid`),
+ KEY `channel_guid_sig` (`channel_guid_sig`),
+ KEY `channel_hash` (`channel_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `clients` (