Added: SQL update to add ending / to existing redirect path entries.

mcramer

2012-11-14 1bb3f3e84953c373b3d1e03675efb94fa53f28c3

Added: SQL update to add ending / to existing redirect path entries.

 install/sql/incremental/upd_0045.sql

New file
@@ -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]://');