xref: /webtrees/app/Schema/Migration20.php (revision 3bfb94b0b402ff08e5888afb946384316f6d3e60) 
1<?php
2namespace Fisharebest\Webtrees\Schema;
3
4/**
5 * webtrees: online genealogy
6 * Copyright (C) 2015 webtrees development team
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation, either version 3 of the License, or
10 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License
16 * along with this program. If not, see <http://www.gnu.org/licenses/>.
17 */
18use Fisharebest\Webtrees\Database;
19use PDOException;
20
21/**
22 * Class Migration20 - upgrade the database schema from version 20 to version 21.
23 */
24class Migration20 implements MigrationInterface {
25	/** {@inheritDoc} */
26	public function upgrade() {
27		// Delete some old/unused configuration settings
28		Database::exec("DELETE FROM `##gedcom_setting` WHERE setting_name IN ('MEDIA_EXTERNAL')");
29
30		// Delete old table
31		Database::exec("DROP TABLE IF EXISTS `##media_mapping`");
32
33		// Make this table look like all the others
34		try {
35			Database::exec(
36				"ALTER TABLE `##media`" .
37				" DROP   m_id," .
38				" CHANGE m_media   m_id       VARCHAR(20)  COLLATE utf8_unicode_ci NOT NULL," .
39				" CHANGE m_file    m_filename VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL," .
40				" CHANGE m_gedfile m_file     INTEGER                              NOT NULL," .
41				" CHANGE m_gedrec  m_gedcom   MEDIUMTEXT   COLLATE utf8_unicode_ci DEFAULT NULL," .
42				" ADD    m_type               VARCHAR(20)  COLLATE utf8_unicode_ci NULL AFTER m_ext," .
43				" ADD    PRIMARY KEY     (m_file, m_id)," .
44				" ADD            KEY ix2 (m_ext, m_type)," .
45				" ADD            KEY ix3 (m_titl)"
46			);
47		} catch (PDOException $ex) {
48			// Assume we've already done this
49		}
50
51		// Populate the new column
52		Database::exec("UPDATE `##media` SET m_type = SUBSTRING_INDEX(SUBSTRING_INDEX(m_gedcom, '\n3 TYPE ', -1), '\n', 1) WHERE m_gedcom LIKE '%\n3 TYPE %'");
53	}
54}
55