More SQL fixes on update. Closes: #654297.

diff --git a/debian/changelog b/debian/changelog
index 0c7555b88f353f3029beba620a26980117caf845..0ddd225482e2b2d60af1c5e7047d88c19d78d41a 100644 (file)
--- a/debian/changelog
+++ b/debian/changelog
@@ -4,8 +4,9 @@ roundcube (0.7-3) unstable; urgency=low
       + Depend on libjs-jquery-ui package (instead of builtin copy).
       + Conflict with versions of roundcube-plugins-extra providing this
         plugin.
+  * More SQL fixes on update. Closes: #654297.
 
- -- Vincent Bernat <bernat@debian.org>  Mon, 26 Dec 2011 21:24:11 +0100
+ -- Vincent Bernat <bernat@debian.org>  Mon, 02 Jan 2012 21:45:42 +0100
 
 roundcube (0.7-2) unstable; urgency=low
 

diff --git a/debian/patches/sql-fixes.patch b/debian/patches/sql-fixes.patch
index 1b1174945086f38f81f2aa2729d6030417363c06..a0c15eed816d10fc5bbd619042d84f32af481db3 100644 (file)
--- a/debian/patches/sql-fixes.patch
+++ b/debian/patches/sql-fixes.patch
@@ -33,3 +33,12 @@ Various SQL fixes for 0.7.
 +CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
  
  -- --------------------------------------------------------
+--- roundcubemail/SQL/postgres.update.sql      (revision 5468)
++++ roundcubemail/SQL/postgres.update.sql      (revision 5627)
+@@ -128,5 +128,5 @@
+ );
+ 
+-DROP SEQUENCE messages_ids;
++DROP SEQUENCE message_ids;
+ DROP TABLE messages;
+ 

diff --git a/debian/sql/pgsql/0.7-1 b/debian/sql/pgsql/0.7-1
index cb4ae9bb99b20b8450333c6b97f7207d6a9f8661..10c7f23381f7a517911dc307b0673a7f48c224b8 100644 (file)
--- a/debian/sql/pgsql/0.7-1
+++ b/debian/sql/pgsql/0.7-1
@@ -24,7 +24,7 @@ CREATE TABLE searches (
     CONSTRAINT searches_user_id_key UNIQUE (user_id, "type", name)
 );
 
-DROP SEQUENCE messages_ids;
+DROP SEQUENCE message_ids;
 DROP TABLE messages;
 
 CREATE TABLE cache_index (