From 51ba770b8203c78337338137426fea94ef3e12a6 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Thu, 17 Jan 2019 22:55:11 -0300 Subject: [PATCH] Bug 22155: DB update --- .../data/mysql/atomicupdate/bug_22155.perl | 20 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 8 ++++---- 2 files changed, 24 insertions(+), 4 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_22155.perl diff --git a/installer/data/mysql/atomicupdate/bug_22155.perl b/installer/data/mysql/atomicupdate/bug_22155.perl new file mode 100644 index 0000000000..2b90205b82 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_22155.perl @@ -0,0 +1,20 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + + if ( column_exists( 'biblio_metadata', 'marcflavour' ) ) { + $dbh->do(q{ + ALTER TABLE biblio_metadata + CHANGE COLUMN marcflavour `schema` VARCHAR(16) + }); + } + + if ( column_exists( 'deletedbiblio_metadata', 'marcflavour' ) ) { + $dbh->do(q{ + ALTER TABLE deletedbiblio_metadata + CHANGE COLUMN marcflavour `schema` VARCHAR(16) + }); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 22155 - biblio_metadata.marcflavour should be renamed 'schema')\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 2575d5b474..7c6ca2d947 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4007,11 +4007,11 @@ CREATE TABLE biblio_metadata ( `id` INT(11) NOT NULL AUTO_INCREMENT, `biblionumber` INT(11) NOT NULL, `format` VARCHAR(16) NOT NULL, - `marcflavour` VARCHAR(16) NOT NULL, + `schema` VARCHAR(16) NOT NULL, `metadata` LONGTEXT NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY(id), - UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), + UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`), CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE, KEY `timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4025,11 +4025,11 @@ CREATE TABLE deletedbiblio_metadata ( `id` INT(11) NOT NULL AUTO_INCREMENT, `biblionumber` INT(11) NOT NULL, `format` VARCHAR(16) NOT NULL, - `marcflavour` VARCHAR(16) NOT NULL, + `schema` VARCHAR(16) NOT NULL, `metadata` LONGTEXT NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY(id), - UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), + UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`), CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE, KEY `timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2.20.1