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)");
_______________________________________________
GNUnet-SVN mailing list
GNUnet-SVN@gnu.org
http://lists.gnu.org/mailman/listinfo/gnunet-svn
