From 31bf7a70d542434415815b091ba5708cae416369 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Wed, 10 Jan 2018 18:13:18 +0100 Subject: [PATCH] Set the default value for the search engine visibility for non-system pages. Closes #2482 This sets the default value, the `page.xml` runs shortly afterwards to set the actual values, making this merely a safe-guard for backwards-compatibility. --- com.woltlab.wcf/update_3.1_3.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/com.woltlab.wcf/update_3.1_3.sql b/com.woltlab.wcf/update_3.1_3.sql index 886a8f0efc..4715f0d3b5 100644 --- a/com.woltlab.wcf/update_3.1_3.sql +++ b/com.woltlab.wcf/update_3.1_3.sql @@ -138,3 +138,6 @@ INSERT INTO wcf1_contact_option (optionID, optionTitle, optionDescription, optio -- default recipient: site administrator INSERT INTO wcf1_contact_recipient (recipientID, name, email, isAdministrator, originIsSystem) VALUES (1, 'wcf.contact.recipient.name1', '', 1, 1); + +-- force-enable the visibility of all non-system pages (the page.xml is shortly after and sets the exact values) +ALTER TABLE wcf1_page SET allowSpidersToIndex = 1 WHERE pageType <> 'system'; -- 2.20.1