From b709fa7937e671b1a5f6e941c9a2ea7c342e23f2 Mon Sep 17 00:00:00 2001 From: Daniel Golle Date: Tue, 18 Oct 2016 11:28:23 +0000 Subject: [PATCH] psycstore: postgres: add LENGTH checks for signature and purpose --- src/psycstore/plugin_psycstore_postgres.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/psycstore/plugin_psycstore_postgres.c b/src/psycstore/plugin_psycstore_postgres.c index c6d274a78..273ab4e80 100644 --- a/src/psycstore/plugin_psycstore_postgres.c +++ b/src/psycstore/plugin_psycstore_postgres.c @@ -158,8 +158,8 @@ database_setup (struct Plugin *plugin) "CREATE TABLE IF NOT EXISTS messages (\n" " channel_id BIGINT NOT NULL REFERENCES channels(id),\n" " hop_counter INT NOT NULL,\n" - " signature BYTEA,\n" - " purpose BYTEA,\n" + " signature BYTEA CHECK (LENGTH(signature)=64),\n" + " purpose BYTEA CHECK (LENGTH(purpose)=8),\n" " fragment_id BIGINT NOT NULL,\n" " fragment_offset BIGINT NOT NULL,\n" " message_id BIGINT NOT NULL,\n" -- 2.25.1