[GNUnet-SVN] r37535 - gnunet/src/psycstore

[gnunet]

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 */