From 41f2b9356fb9649d7b1732603aad2831648da323 Mon Sep 17 00:00:00 2001 From: Gabor X Toth <*@tg-x.net> Date: Wed, 12 Oct 2016 22:07:34 +0000 Subject: [PATCH] psycstore --- src/psycstore/plugin_psycstore_mysql.c | 2 +- src/psycstore/plugin_psycstore_sqlite.c | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/psycstore/plugin_psycstore_mysql.c b/src/psycstore/plugin_psycstore_mysql.c index 01a0282c8..c76e7e6b1 100644 --- a/src/psycstore/plugin_psycstore_mysql.c +++ b/src/psycstore/plugin_psycstore_mysql.c @@ -296,7 +296,7 @@ database_setup (struct Plugin *plugin) /* Create tables */ STMT_RUN ("CREATE TABLE IF NOT EXISTS channels (\n" " id BIGINT UNSIGNED AUTO_INCREMENT,\n" - " pub_key BLOB(23),\n" + " pub_key BLOB(32),\n" " max_state_message_id BIGINT UNSIGNED,\n" " state_hash_message_id BIGINT UNSIGNED,\n" " PRIMARY KEY(id),\n" diff --git a/src/psycstore/plugin_psycstore_sqlite.c b/src/psycstore/plugin_psycstore_sqlite.c index 4d21696ce..69291b440 100644 --- a/src/psycstore/plugin_psycstore_sqlite.c +++ b/src/psycstore/plugin_psycstore_sqlite.c @@ -348,7 +348,7 @@ database_setup (struct Plugin *plugin) sql_exec (plugin->dbh, "CREATE TABLE IF NOT EXISTS channels (\n" " id INTEGER PRIMARY KEY,\n" - " pub_key BLOB UNIQUE,\n" + " pub_key BLOB(32) UNIQUE,\n" " max_state_message_id INTEGER,\n" // last applied state message ID " state_hash_message_id INTEGER\n" // last message ID with a state hash ");"); @@ -356,7 +356,7 @@ database_setup (struct Plugin *plugin) sql_exec (plugin->dbh, "CREATE TABLE IF NOT EXISTS slaves (\n" " id INTEGER PRIMARY KEY,\n" - " pub_key BLOB UNIQUE\n" + " pub_key BLOB(32) UNIQUE\n" ");"); sql_exec (plugin->dbh, -- 2.25.1