From f31b474e1f720e94b37cfedfe0febe453284f158 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 28 May 2019 17:57:29 +0200
Subject: [news] Modularize; add 'login-news' category

TODO: Use date/time picker for expire time
---
 modules-available/news/install.inc.php | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

(limited to 'modules-available/news/install.inc.php')

diff --git a/modules-available/news/install.inc.php b/modules-available/news/install.inc.php
index e5e52256..43336290 100644
--- a/modules-available/news/install.inc.php
+++ b/modules-available/news/install.inc.php
@@ -23,14 +23,26 @@ if (tableExists('news')) {
 $res[] = tableCreate('vmchooser_pages', "
 	`newsid` int(10) unsigned NOT NULL AUTO_INCREMENT,
 	`dateline` int(10) unsigned NOT NULL,
+	`expires` int(10) unsigned NOT NULL,
 	`title` varchar(200) DEFAULT NULL,
 	`content` text,
 	`type` varchar(10),
 	PRIMARY KEY (`newsid`),
-	KEY `type` (`type`, `dateline`)
+	KEY `type` (`type`, `dateline`),
+	KEY `all3` (`type`, `expires`, `dateline`)
 ");
 
-Database::exec('ALTER TABLE vmchooser_pages DROP KEY `dateline`, ADD KEY `type` (`type`, `dateline`)');
+if (tableHasIndex('vmchooser_pages', ['dateline'])) {
+	Database::exec('ALTER TABLE vmchooser_pages DROP KEY `dateline`');
+	Database::exec('ALTER TABLE vmchooser_pages ADD KEY `type` (`type`, `dateline`)');
+}
+if (!tableHasIndex('vmchooser_pages', ['type', 'expires', 'dateline'])) {
+	Database::exec('ALTER TABLE vmchooser_pages ADD KEY `all3` (`type`, `expires`, `dateline`)');
+}
+if (!tableHasColumn('vmchooser_pages', 'expires')) {
+	Database::exec('ALTER TABLE vmchooser_pages ADD COLUMN `expires` int(10) unsigned NOT NULL AFTER `dateline`');
+	Database::exec('UPDATE vmchooser_pages SET expires = dateline + 86400 * 3650 WHERE expires = 0'); // ~10 Years
+}
 
 // Create response for browser
 
-- 
cgit v1.2.3-55-g7522