aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-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 '',