[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r37535 - gnunet/src/psycstore
From: |
gnunet |
Subject: |
[GNUnet-SVN] r37535 - gnunet/src/psycstore |
Date: |
Wed, 13 Jul 2016 11:41:19 +0200 |
Author: christophe.genevey
Date: 2016-07-13 11:41:19 +0200 (Wed, 13 Jul 2016)
New Revision: 37535
Modified:
gnunet/src/psycstore/plugin_psycstore_mysql.c
Log:
start to fix psycstore mysql
Modified: gnunet/src/psycstore/plugin_psycstore_mysql.c
===================================================================
--- gnunet/src/psycstore/plugin_psycstore_mysql.c 2016-07-13 07:13:04 UTC
(rev 37534)
+++ gnunet/src/psycstore/plugin_psycstore_mysql.c 2016-07-13 09:41:19 UTC
(rev 37535)
@@ -358,12 +358,13 @@
" PRIMARY KEY(id),\n"
" UNIQUE KEY(pub_key(10))\n"
");");
-
-/** ERROR **/
+
GNUNET_MYSQL_statement_run (plugin->mc,
"CREATE TABLE IF NOT EXISTS slaves (\n"
- " id INT PRIMARY KEY,\n"
- " pub_key BLOB UNIQUE\n"
+ " id INT,\n"
+ " pub_key BLOB,\n"
+ " PRIMARY KEY(id),\n"
+ " UNIQUE KEY(pub_key(10))\n"
");");
GNUNET_MYSQL_statement_run (plugin->mc,
@@ -376,8 +377,9 @@
" group_generation INT NOT NULL\n"
");");
+/*** FIX because IF NOT EXISTS doesn't work ***/
GNUNET_MYSQL_statement_run (plugin->mc,
- "CREATE INDEX IF NOT EXISTS
idx_membership_channel_id_slave_id "
+ "CREATE INDEX idx_membership_channel_id_slave_id
"
"ON membership (channel_id, slave_id);");
/** @todo messages table: add method_name column */
@@ -395,7 +397,7 @@
" psycstore_flags INT NOT NULL,\n"
" data BLOB,\n"
" PRIMARY KEY (channel_id, fragment_id),\n"
- " UNIQUE (channel_id, message_id,
fragment_offset)\n"
+ " UNIQUE KEY(channel_id, message_id,
fragment_offset)\n"
");");
GNUNET_MYSQL_statement_run (plugin->mc,
@@ -404,7 +406,7 @@
" name TEXT NOT NULL,\n"
" value_current BLOB,\n"
" value_signed BLOB,\n"
- " PRIMARY KEY (channel_id, name)\n"
+ " PRIMARY KEY (channel_id, name(10))\n"
");");
GNUNET_MYSQL_statement_run (plugin->mc,
@@ -412,7 +414,7 @@
" channel_id INT NOT NULL REFERENCES
channels(id),\n"
" name TEXT NOT NULL,\n"
" value BLOB,\n"
- " PRIMARY KEY (channel_id, name)\n"
+ " PRIMARY KEY (channel_id, name(10))\n"
");");
/* Prepare statements */
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [GNUnet-SVN] r37535 - gnunet/src/psycstore,
gnunet <=