diff options
| author | friendica <info@friendica.com> | 2012-10-04 03:13:57 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-10-04 03:13:57 -0700 |
| commit | ff43d62e445422a40271855dcd9933499da501fa (patch) | |
| tree | 2a44942f74e86f1a0f1ad240dc040689a3a776d6 /database.sql | |
| parent | e124c9fa5ca046d48eb927fe80706cf6d42f6bff (diff) | |
| download | volse-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.sql | 10 |
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` ( |