# HG changeset patch
# User Alexandre Fayolle <alexandre.fayolle@logilab.fr>
# Date 1285142436 -7200
# Node ID a1535abe6ab2a08753c5de075d8bca9af36825ae
# Parent  f6cba3be6ba2a441b62b62d87cc6bbfb1788405b
use new logilab.database interface for multicol indexes

diff -r f6cba3be6ba2 -r a1535abe6ab2 hooks/syncschema.py
--- a/hooks/syncschema.py	Mon Sep 20 15:58:45 2010 +0200
+++ b/hooks/syncschema.py	Wed Sep 22 10:00:36 2010 +0200
@@ -707,8 +707,9 @@
         cols = ['%s%s' % (prefix, r.rtype.name)
                 for r in self.entity.relations]
         dbhelper= session.pool.source('system').dbhelper
-        sql = dbhelper.sql_create_multicol_unique_index(table, cols)
-        session.system_sql(sql)
+        sqls = dbhelper.sqls_create_multicol_unique_index(table, cols)
+        for sql in sqls:
+            session.system_sql(sql)
 
     # XXX revertprecommit_event
 
@@ -726,8 +727,9 @@
         table = '%s%s' % (prefix, self.entity.type)
         dbhelper= session.pool.source('system').dbhelper
         cols = ['%s%s' % (prefix, c) for c in self.cols]
-        sql = dbhelper.sql_drop_multicol_unique_index(table, cols)
-        session.system_sql(sql)
+        sqls = dbhelper.sqls_drop_multicol_unique_index(table, cols)
+        for sql in sqls:
+            session.system_sql(sql)
 
     # XXX revertprecommit_event