diff options
-rw-r--r-- | src/psycstore/plugin_psycstore_postgres.c | 4 |
1 files 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) | |||
158 | "CREATE TABLE IF NOT EXISTS messages (\n" | 158 | "CREATE TABLE IF NOT EXISTS messages (\n" |
159 | " channel_id BIGINT NOT NULL REFERENCES channels(id),\n" | 159 | " channel_id BIGINT NOT NULL REFERENCES channels(id),\n" |
160 | " hop_counter INT NOT NULL,\n" | 160 | " hop_counter INT NOT NULL,\n" |
161 | " signature BYTEA,\n" | 161 | " signature BYTEA CHECK (LENGTH(signature)=64),\n" |
162 | " purpose BYTEA,\n" | 162 | " purpose BYTEA CHECK (LENGTH(purpose)=8),\n" |
163 | " fragment_id BIGINT NOT NULL,\n" | 163 | " fragment_id BIGINT NOT NULL,\n" |
164 | " fragment_offset BIGINT NOT NULL,\n" | 164 | " fragment_offset BIGINT NOT NULL,\n" |
165 | " message_id BIGINT NOT NULL,\n" | 165 | " message_id BIGINT NOT NULL,\n" |