diff options
author | Simon Rettberg | 2019-05-28 17:57:29 +0200 |
---|---|---|
committer | Simon Rettberg | 2019-05-28 17:57:29 +0200 |
commit | 3f12e235abf1cad562bf5df94164bf3c2146924e (patch) | |
tree | ce0ea8cdd004303edcf619be19081ef340cc0c61 /modules-available/news/install.inc.php | |
parent | [dnbd3] Put proxies from other locations into SLX_DNBD3_FALLBACK (diff) | |
download | slx-admin-3f12e235abf1cad562bf5df94164bf3c2146924e.tar.gz slx-admin-3f12e235abf1cad562bf5df94164bf3c2146924e.tar.xz slx-admin-3f12e235abf1cad562bf5df94164bf3c2146924e.zip |
[news] Modularize; add 'login-news' category
TODO: Use date/time picker for expire time
Diffstat (limited to 'modules-available/news/install.inc.php')
-rw-r--r-- | modules-available/news/install.inc.php | 16 |
1 files changed, 14 insertions, 2 deletions
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 |