From ff43d62e445422a40271855dcd9933499da501fa Mon Sep 17 00:00:00 2001 From: friendica 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