aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-10-31 17:11:05 -0700
committerfriendica <info@friendica.com>2012-10-31 17:11:05 -0700
commiteef329abe9a00da23c350f04c3f5f309086f27f7 (patch)
tree51900d6d46cdf04792c2343558855e35a9080879 /install/database.sql
parent62a8298b549c8985a7817be046d7e25cbaf17cb5 (diff)
downloadvolse-hubzilla-eef329abe9a00da23c350f04c3f5f309086f27f7.tar.gz
volse-hubzilla-eef329abe9a00da23c350f04c3f5f309086f27f7.tar.bz2
volse-hubzilla-eef329abe9a00da23c350f04c3f5f309086f27f7.zip
increase size of signature stores
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql8
1 files changed, 3 insertions, 5 deletions
diff --git a/install/database.sql b/install/database.sql
index 667b59bed..e73a34c29 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -467,11 +467,11 @@ CREATE TABLE IF NOT EXISTS `hook` (
CREATE TABLE IF NOT EXISTS `hubloc` (
`hubloc_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hubloc_guid` char(255) NOT NULL DEFAULT '',
- `hubloc_guid_sig` char(255) NOT NULL,
+ `hubloc_guid_sig` text NOT NULL,
`hubloc_hash` char(255) NOT NULL,
`hubloc_flags` int(10) unsigned NOT NULL DEFAULT '0',
`hubloc_url` char(255) NOT NULL DEFAULT '',
- `hubloc_url_sig` char(255) NOT NULL,
+ `hubloc_url_sig` text NOT NULL,
`hubloc_host` char(255) NOT NULL DEFAULT '',
`hubloc_callback` char(255) NOT NULL DEFAULT '',
`hubloc_connect` char(255) NOT NULL DEFAULT '',
@@ -480,8 +480,6 @@ CREATE TABLE IF NOT EXISTS `hubloc` (
KEY `hubloc_url` (`hubloc_url`),
KEY `hubloc_guid` (`hubloc_guid`),
KEY `hubloc_flags` (`hubloc_flags`),
- KEY `hubloc_guid_sig` (`hubloc_guid_sig`),
- KEY `hubloc_url_sig` (`hubloc_url_sig`),
KEY `hubloc_connect` (`hubloc_connect`),
KEY `hubloc_host` (`hubloc_host`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -902,7 +900,7 @@ CREATE TABLE IF NOT EXISTS `tokens` (
CREATE TABLE IF NOT EXISTS `xchan` (
`xchan_hash` char(255) NOT NULL,
`xchan_guid` char(255) NOT NULL DEFAULT '',
- `xchan_guid_sig` char(255) NOT NULL DEFAULT '',
+ `xchan_guid_sig` text NOT NULL,
`xchan_pubkey` text NOT NULL,
`xchan_photo_mimetype` char(32) NOT NULL DEFAULT 'image/jpeg',
`xchan_photo_l` char(255) NOT NULL DEFAULT '',