From 9e46fb535ddce461a11f57d4ce75a43c3ad651e8 Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Tue, 19 Feb 2013 08:27:26 -0500
Subject: [PATCH] Fix typo in DB version strings (there should be no .sql suffix)

---
 SQL/postgres.initial.sql |    2 +-
 bin/updatedb.sh          |    2 +-
 SQL/mysql.initial.sql    |    2 +-
 SQL/sqlite.initial.sql   |    2 +-
 SQL/mssql.initial.sql    |    2 +-
 5 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql
index 694fe7e..9139509 100644
--- a/SQL/mssql.initial.sql
+++ b/SQL/mssql.initial.sql
@@ -371,6 +371,6 @@
     WHERE [contact_id] IN (SELECT [contact_id] FROM deleted)
 GO
 
-INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2013011700.sql')
+INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2013011700')
 GO
 
\ No newline at end of file
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql
index 3d6bae4..cb750c5 100644
--- a/SQL/mysql.initial.sql
+++ b/SQL/mysql.initial.sql
@@ -196,4 +196,4 @@
 
 /*!40014 SET FOREIGN_KEY_CHECKS=1 */;
 
-INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700.sql');
+INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700');
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql
index d6acb5d..32d8ede 100644
--- a/SQL/postgres.initial.sql
+++ b/SQL/postgres.initial.sql
@@ -274,4 +274,4 @@
     value text
 );
 
-INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700.sql');
+INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700');
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index a9c7f50..83874ce 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -209,4 +209,4 @@
   value text NOT NULL
 );
 
-INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700.sql');
+INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700');
diff --git a/bin/updatedb.sh b/bin/updatedb.sh
index 4b922ea..c856e0d 100755
--- a/bin/updatedb.sh
+++ b/bin/updatedb.sh
@@ -63,7 +63,7 @@
         $opts['package'] . '-version');
 
     $row     = $DB->fetch_array();
-    $version = $row[0];
+    $version = preg_replace('/[^0-9]/', '', $row[0]);
 }
 
 // DB version not found, but release version is specified

--
Gitblit v1.9.1