From 9da6560177a2e7898c7ca07ce4b3f0bc13ec2811 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 29 Nov 2017 16:13:37 +0100
Subject: [news] install: Better index for table

---
 modules-available/news/install.inc.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'modules-available/news')

diff --git a/modules-available/news/install.inc.php b/modules-available/news/install.inc.php
index 620a4580..e5e52256 100644
--- a/modules-available/news/install.inc.php
+++ b/modules-available/news/install.inc.php
@@ -27,9 +27,11 @@ $res[] = tableCreate('vmchooser_pages', "
 	`content` text,
 	`type` varchar(10),
 	PRIMARY KEY (`newsid`),
-	KEY `dateline` (`dateline`)
+	KEY `type` (`type`, `dateline`)
 ");
 
+Database::exec('ALTER TABLE vmchooser_pages DROP KEY `dateline`, ADD KEY `type` (`type`, `dateline`)');
+
 // Create response for browser
 
 if (in_array(UPDATE_DONE, $res)) {
-- 
cgit v1.2.3-55-g7522