xref: /webtrees/app/Schema/Migration6.php (revision 76692c8b291f16d9251d67f27078779f6737fe7e)
13bfb94b0SGreg Roach<?php
23bfb94b0SGreg Roach/**
33bfb94b0SGreg Roach * webtrees: online genealogy
43bfb94b0SGreg Roach * Copyright (C) 2015 webtrees development team
53bfb94b0SGreg Roach * This program is free software: you can redistribute it and/or modify
63bfb94b0SGreg Roach * it under the terms of the GNU General Public License as published by
73bfb94b0SGreg Roach * the Free Software Foundation, either version 3 of the License, or
83bfb94b0SGreg Roach * (at your option) any later version.
93bfb94b0SGreg Roach * This program is distributed in the hope that it will be useful,
103bfb94b0SGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of
113bfb94b0SGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
123bfb94b0SGreg Roach * GNU General Public License for more details.
133bfb94b0SGreg Roach * You should have received a copy of the GNU General Public License
143bfb94b0SGreg Roach * along with this program. If not, see <http://www.gnu.org/licenses/>.
153bfb94b0SGreg Roach */
16*76692c8bSGreg Roachnamespace Fisharebest\Webtrees\Schema;
17*76692c8bSGreg Roach
183bfb94b0SGreg Roachuse Fisharebest\Webtrees\Database;
193bfb94b0SGreg Roachuse PDOException;
203bfb94b0SGreg Roach
213bfb94b0SGreg Roach/**
22*76692c8bSGreg Roach * Upgrade the database schema from version 6 to version 7.
233bfb94b0SGreg Roach */
243bfb94b0SGreg Roachclass Migration6 implements MigrationInterface {
25*76692c8bSGreg Roach	/**
26*76692c8bSGreg Roach	 * Upgrade to to the next version
27*76692c8bSGreg Roach	 */
283bfb94b0SGreg Roach	public function upgrade() {
293bfb94b0SGreg Roach		// Remove tables/columns relating to remote linking
303bfb94b0SGreg Roach
313bfb94b0SGreg Roach		try {
323bfb94b0SGreg Roach			Database::exec(
333bfb94b0SGreg Roach				"DROP TABLE `##remotelinks`"
343bfb94b0SGreg Roach			);
353bfb94b0SGreg Roach		} catch (PDOException $ex) {
363bfb94b0SGreg Roach			// already been done?
373bfb94b0SGreg Roach		}
383bfb94b0SGreg Roach
393bfb94b0SGreg Roach		try {
403bfb94b0SGreg Roach			Database::exec(
413bfb94b0SGreg Roach				"ALTER TABLE `##sources` DROP INDEX ix2"
423bfb94b0SGreg Roach			);
433bfb94b0SGreg Roach		} catch (PDOException $ex) {
443bfb94b0SGreg Roach			// already been done?
453bfb94b0SGreg Roach		}
463bfb94b0SGreg Roach
473bfb94b0SGreg Roach		try {
483bfb94b0SGreg Roach			Database::exec(
493bfb94b0SGreg Roach				"ALTER TABLE `##sources` DROP COLUMN s_dbid"
503bfb94b0SGreg Roach			);
513bfb94b0SGreg Roach		} catch (PDOException $ex) {
523bfb94b0SGreg Roach			// already been done?
533bfb94b0SGreg Roach		}
543bfb94b0SGreg Roach	}
553bfb94b0SGreg Roach}
56