[GNUnet-SVN] r38169 - gnunet/src/psycstore

[gnunet]

Author: daniel
Date: 2016-10-18 13:28:23 +0200 (Tue, 18 Oct 2016)
New Revision: 38169

Modified:
   gnunet/src/psycstore/plugin_psycstore_postgres.c
Log:
psycstore: postgres: add LENGTH checks for signature and purpose

Modified: gnunet/src/psycstore/plugin_psycstore_postgres.c
===================================================================
--- gnunet/src/psycstore/plugin_psycstore_postgres.c    2016-10-18 10:36:46 UTC 
(rev 38168)
+++ gnunet/src/psycstore/plugin_psycstore_postgres.c    2016-10-18 11:28:23 UTC 
(rev 38169)
@@ -158,8 +158,8 @@
                               "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"