From 1bb3f3e84953c373b3d1e03675efb94fa53f28c3 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Wed, 14 Nov 2012 05:54:06 -0500
Subject: [PATCH] Added: SQL update to add ending / to existing redirect path entries.

---
 install/sql/incremental/upd_0045.sql |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/install/sql/incremental/upd_0045.sql b/install/sql/incremental/upd_0045.sql
new file mode 100644
index 0000000..3be8b34
--- /dev/null
+++ b/install/sql/incremental/upd_0045.sql
@@ -0,0 +1 @@
+UPDATE `web_domain` SET `redirect_path` = CONCAT(`redirect_path`, '/') WHERE `redirect_path` != '' AND RIGHT(`redirect_path`, 1) != '/' AND (LEFT(`redirect_path`, 7) = 'http://' OR  LEFT(`redirect_path`, 8) = 'https://' OR LEFT(`redirect_path`, 11) = '[scheme]://'); 

--
Gitblit v1.9.1