aboutsummaryrefslogtreecommitdiff
path: root/src/datacache/plugin_datacache_postgres.c
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2017-06-25 17:05:09 +0200
committerChristian Grothoff <christian@grothoff.org>2017-06-25 17:05:22 +0200
commit169f1c8c1db0a6d8cebf308ced1de064eadcdc4d (patch)
tree27b86aa84b65360df50a91c5ada878f590700a7d /src/datacache/plugin_datacache_postgres.c
parent2c6b87e1974c502a2fc074050c41daa4674dbdc0 (diff)
allow NULL fields for varsize
Diffstat (limited to 'src/datacache/plugin_datacache_postgres.c')
-rw-r--r--src/datacache/plugin_datacache_postgres.c10
1 files changed, 5 insertions, 5 deletions
diff --git a/src/datacache/plugin_datacache_postgres.c b/src/datacache/plugin_datacache_postgres.c
index 5c497cdf8e..2fe6498a51 100644
--- a/src/datacache/plugin_datacache_postgres.c
+++ b/src/datacache/plugin_datacache_postgres.c
@@ -68,11 +68,11 @@ init_connection (struct Plugin *plugin)
{
struct GNUNET_PQ_ExecuteStatement es[] = {
GNUNET_PQ_make_execute ("CREATE TEMPORARY TABLE IF NOT EXISTS gn090dc ("
- " type INTEGER NOT NULL DEFAULT 0,"
- " discard_time BIGINT NOT NULL DEFAULT 0,"
- " key BYTEA NOT NULL DEFAULT '',"
- " value BYTEA NOT NULL DEFAULT '',"
- " path BYTEA DEFAULT '')"
+ " type INTEGER NOT NULL,"
+ " discard_time BIGINT NOT NULL,"
+ " key BYTEA NOT NULL,"
+ " value BYTEA NOT NULL,"
+ " path BYTEA DEFAULT NULL)"
"WITH OIDS"),
GNUNET_PQ_make_try_execute ("CREATE INDEX IF NOT EXISTS idx_key ON gn090dc (key)"),
GNUNET_PQ_make_try_execute ("CREATE INDEX IF NOT EXISTS idx_dt ON gn090dc (discard_time)"),