diff options
Diffstat (limited to 'app/Schema/Migration2.php')
| -rw-r--r-- | app/Schema/Migration2.php | 56 |
1 files changed, 29 insertions, 27 deletions
diff --git a/app/Schema/Migration2.php b/app/Schema/Migration2.php index 8352aae5af..d0f35be514 100644 --- a/app/Schema/Migration2.php +++ b/app/Schema/Migration2.php @@ -22,34 +22,36 @@ use PDOException; /** * Upgrade the database schema from version 2 to version 2. */ -class Migration2 implements MigrationInterface { - /** - * Upgrade to to the next version - */ - public function upgrade() { - // - create the wt_gedcom_chunk table to import gedcoms in - // blocks of data smaller than the max_allowed_packet restriction. +class Migration2 implements MigrationInterface +{ + /** + * Upgrade to to the next version + */ + public function upgrade() + { + // - create the wt_gedcom_chunk table to import gedcoms in + // blocks of data smaller than the max_allowed_packet restriction. - Database::exec( - "CREATE TABLE IF NOT EXISTS `##gedcom_chunk` (" . - " gedcom_chunk_id INTEGER AUTO_INCREMENT NOT NULL," . - " gedcom_id INTEGER NOT NULL," . - " chunk_data MEDIUMBLOB NOT NULL," . - " imported BOOLEAN NOT NULL DEFAULT FALSE," . - " PRIMARY KEY (gedcom_chunk_id)," . - " KEY ix1 (gedcom_id, imported)," . - " FOREIGN KEY `##gedcom_chunk_fk1` (gedcom_id) REFERENCES `##gedcom` (gedcom_id)" . - ") COLLATE utf8_unicode_ci ENGINE=InnoDB" - ); + Database::exec( + "CREATE TABLE IF NOT EXISTS `##gedcom_chunk` (" . + " gedcom_chunk_id INTEGER AUTO_INCREMENT NOT NULL," . + " gedcom_id INTEGER NOT NULL," . + " chunk_data MEDIUMBLOB NOT NULL," . + " imported BOOLEAN NOT NULL DEFAULT FALSE," . + " PRIMARY KEY (gedcom_chunk_id)," . + " KEY ix1 (gedcom_id, imported)," . + " FOREIGN KEY `##gedcom_chunk_fk1` (gedcom_id) REFERENCES `##gedcom` (gedcom_id)" . + ") COLLATE utf8_unicode_ci ENGINE=InnoDB" + ); - try { - Database::exec( - "ALTER TABLE `##gedcom` DROP import_gedcom, DROP import_offset" - ); - } catch (PDOException $ex) { - DebugBar::addThrowable($ex); + try { + Database::exec( + "ALTER TABLE `##gedcom` DROP import_gedcom, DROP import_offset" + ); + } catch (PDOException $ex) { + DebugBar::addThrowable($ex); - // Perhaps we have already deleted these columns? - } - } + // Perhaps we have already deleted these columns? + } + } } |
