From d4f1383c220289b0e64c55fd6b30283fa153cf44 Mon Sep 17 00:00:00 2001
From: Alexander Ebert <ebert@woltlab.com>
Date: Fri, 31 May 2013 14:11:20 +0200
Subject: [PATCH] Added SQL update

---
 com.woltlab.wcf/package.xml   | 1 +
 com.woltlab.wcf/update_b2.sql | 1 +
 2 files changed, 2 insertions(+)
 create mode 100644 com.woltlab.wcf/update_b2.sql

diff --git a/com.woltlab.wcf/package.xml b/com.woltlab.wcf/package.xml
index d0ebf3bd8f..d9faac5a15 100644
--- a/com.woltlab.wcf/package.xml
+++ b/com.woltlab.wcf/package.xml
@@ -45,6 +45,7 @@
 	<instructions type="update" fromversion="2.0.0 Beta 1">
 		<instruction type="file">files_update.tar</instruction>
 		<instruction type="option">option.xml</instruction>
+		<instruction type="sql">update_b2.sql</instruction>
 		<instruction type="template">templates_update.tar</instruction>
 	</instructions>
 </package>
diff --git a/com.woltlab.wcf/update_b2.sql b/com.woltlab.wcf/update_b2.sql
new file mode 100644
index 0000000000..ce9be38882
--- /dev/null
+++ b/com.woltlab.wcf/update_b2.sql
@@ -0,0 +1 @@
+UPDATE wcf1_bbcode_media_provider SET regex = 'http://(?:www\\.)?clipfish\\.de/(?:.*?/)?video/(?<ID>\\d+)/' WHERE title = 'Clipfish';
\ No newline at end of file
-- 
2.20.1