From 0ffb1a7af33bddd30d52080c99e5cf4fd5757416 Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Tue, 19 Feb 2013 08:29:42 -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