From 671e90c17ff0cf3146081596bffb7b0163e07654 Mon Sep 17 00:00:00 2001
From: Alexander Ebert <ebert@woltlab.com>
Date: Wed, 14 Dec 2016 12:07:18 +0100
Subject: [PATCH] Updating instructions / cleanup

---
 com.woltlab.wcf/package.xml  | 2 +-
 com.woltlab.wcf/update_4.sql | 4 ++++
 com.woltlab.wcf/update_5.sql | 3 ++-
 3 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/com.woltlab.wcf/package.xml b/com.woltlab.wcf/package.xml
index ed5b48a0da..1b5b5ff1ed 100644
--- a/com.woltlab.wcf/package.xml
+++ b/com.woltlab.wcf/package.xml
@@ -6,7 +6,7 @@
 		<packagedescription language="de">Freies CMS und Web-Framework, das eindrucksvolle Websites und Communities ermöglicht.</packagedescription>
 		<isapplication>1</isapplication>
 		<version>3.0.0 RC 1</version> <!-- codename: vortex -->
-		<date>2016-12-07</date>
+		<date>2016-12-15</date>
 	</packageinformation>
 	
 	<authorinformation>
diff --git a/com.woltlab.wcf/update_4.sql b/com.woltlab.wcf/update_4.sql
index 4414a25f8b..4ac5a261f9 100644
--- a/com.woltlab.wcf/update_4.sql
+++ b/com.woltlab.wcf/update_4.sql
@@ -5,3 +5,7 @@ ALTER TABLE wcf1_user_profile_visitor CHANGE ownerID ownerID INT(10) NOT NULL;
 ALTER TABLE wcf1_user_profile_visitor CHANGE userID userID INT(10) NOT NULL;
 
 ALTER TABLE wcf1_user_storage ADD KEY (field);
+
+ALTER TABLE wcf1_moderation_queue ADD KEY objectTypeAndID (objectTypeID, objectID);
+
+ALTER TABLE wcf1_modification_log ADD KEY objectTypeAndID (objectTypeID, objectID);
\ No newline at end of file
diff --git a/com.woltlab.wcf/update_5.sql b/com.woltlab.wcf/update_5.sql
index 0e8a309283..8c4c2c2a59 100644
--- a/com.woltlab.wcf/update_5.sql
+++ b/com.woltlab.wcf/update_5.sql
@@ -156,7 +156,7 @@ INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPl
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholderActive', 'rgba(204, 204, 204, 1)');
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '1400px');
-INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '1240px');
+INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '1025px');
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationBackground', 'rgba(236, 239, 241, 1)');
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLink', 'rgba(44, 62, 80, 1)');
 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLinkActive', 'rgba(44, 62, 80, 1)');
@@ -206,3 +206,4 @@ INSERT INTO wcf1_template_group (parentTemplateGroupID, templateGroupName, templ
 -- media providers
 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube Playlist', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/)playlist\\?(?:.*?&)?list=(?P<ID>[a-zA-Z0-9_-]+)', '<div class="videoContainer"><iframe src="https://www.youtube.com/embed/videoseries?list={$ID}" allowfullscreen></iframe></div>');
 UPDATE wcf1_bbcode_media_provider SET regex = 'https?://vimeo\\.com/(?:channels/[^/]+/)?(?P<ID>\\d+)' WHERE title = 'Vimeo';
+UPDATE wcf1_bbcode_media_provider SET regex = 'https?://(?:www\\.)?dailymotion\\.com/video/(?P<ID>[a-zA-Z0-9_-]+)', html = '<iframe width="480" height="270" src="//www.dailymotion.com/embed/video/{$ID}"></iframe>' WHERE title = 'DailyMotion';
-- 
2.20.1