From ff43d62e445422a40271855dcd9933499da501fa Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 4 Oct 2012 03:13:57 -0700
Subject: add hash to channel structure for consistency/redundancy

---
 database.sql | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

(limited to 'database.sql')

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` (
-- 
cgit v1.2.3

