[ejabberd] src/odbc/mysql.sql patch

bekanosky bekanosky at gmail.com
Sat Mar 5 05:59:18 MSK 2011

When i import mysql.sql from git master, it give me error:
ERROR 1072 (42000) at line 50: Key column 'username' doesn't exist in table.

The patch below solve the import problem. But i don't know if this is 
the correct solution or not.

diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql
index 2e2d672..55cd3d2 100644
--- a/src/odbc/mysql.sql
+++ b/src/odbc/mysql.sql
@@ -49,7 +49,7 @@ CREATE TABLE last (

  CREATE TABLE rosteritem (
      host varchar(250) NOT NULL,
-    user varchar(250) NOT NULL,
+    username varchar(250) NOT NULL,
      jid varchar(250) NOT NULL,
      name text,
      subscription text NOT NULL,

More information about the ejabberd mailing list