gnunet-svn
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[GNUnet-SVN] r6501 - in GNUnet/src/applications: dstore_mysql dstore_sql


From: gnunet
Subject: [GNUnet-SVN] r6501 - in GNUnet/src/applications: dstore_mysql dstore_sqlite
Date: Sat, 1 Mar 2008 23:10:08 -0700 (MST)

Author: grothoff
Date: 2008-03-01 23:10:07 -0700 (Sat, 01 Mar 2008)
New Revision: 6501

Modified:
   GNUnet/src/applications/dstore_mysql/dstore_mysql.c
   GNUnet/src/applications/dstore_sqlite/dstore.c
Log:
use of primary key may cause warnings

Modified: GNUnet/src/applications/dstore_mysql/dstore_mysql.c
===================================================================
--- GNUnet/src/applications/dstore_mysql/dstore_mysql.c 2008-03-02 06:08:16 UTC 
(rev 6500)
+++ GNUnet/src/applications/dstore_mysql/dstore_mysql.c 2008-03-02 06:10:07 UTC 
(rev 6501)
@@ -203,7 +203,7 @@
                "  puttime BIGINT UNSIGNED NOT NULL DEFAULT 0,"
                "  expire BIGINT UNSIGNED NOT NULL DEFAULT 0,"
                "  hash BINARY(64) NOT NULL DEFAULT '',"
-               "  vhash BINARY(64) PRIMARY KEY,"
+               "  vhash BINARY(64) NOT NULL DEFAULT '',"
                "  value BLOB NOT NULL DEFAULT '',"
                "  INDEX hashidx (hash(64),type,expire),"
                "  INDEX allidx (hash(64),vhash(64),type,size),"

Modified: GNUnet/src/applications/dstore_sqlite/dstore.c
===================================================================
--- GNUnet/src/applications/dstore_sqlite/dstore.c      2008-03-02 06:08:16 UTC 
(rev 6500)
+++ GNUnet/src/applications/dstore_sqlite/dstore.c      2008-03-02 06:10:07 UTC 
(rev 6501)
@@ -115,7 +115,7 @@
                 "  puttime INTEGER NOT NULL DEFAULT 0,"
                 "  expire INTEGER NOT NULL DEFAULT 0,"
                 "  key BLOB NOT NULL DEFAULT '',"
-                "  vhash BLOB PRIMARY KEY,"
+                "  vhash BLOB NOT NULL DEFAULT '',"
                 "  value BLOB NOT NULL DEFAULT '')");
   SQLITE3_EXEC (dbh, "CREATE INDEX idx_hashidx ON ds080 (key,type,expire)");
   SQLITE3_EXEC (dbh, "CREATE INDEX idx_allidx ON ds080 (key,vhash,type,size)");





reply via email to

[Prev in Thread] Current Thread [Next in Thread]