@@ -, +, @@ --- .../definitions/erm_eholdings_title.yaml | 4 +-- .../swagger/paths/erm_eholdings_titles.yaml | 4 +-- .../atomicupdate/bug_34789-rename-column.pl | 35 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 6 ++-- 4 files changed, 42 insertions(+), 7 deletions(-) create mode 100755 installer/data/mysql/atomicupdate/bug_34789-rename-column.pl --- a/api/v1/swagger/definitions/erm_eholdings_title.yaml +++ a/api/v1/swagger/definitions/erm_eholdings_title.yaml @@ -124,8 +124,8 @@ properties: type: - string - "null" - preceeding_publication_title_id: - description: preceeding_publication_title_id of the title + preceding_publication_title_id: + description: preceding_publication_title_id of the title type: - string - "null" --- a/api/v1/swagger/paths/erm_eholdings_titles.yaml +++ a/api/v1/swagger/paths/erm_eholdings_titles.yaml @@ -134,9 +134,9 @@ name: parent_publication_title_id required: false type: string - - description: Case insensitive search on title preceeding_publication_title_id + - description: Case insensitive search on title preceding_publication_title_id in: query - name: preceeding_publication_title_id + name: preceding_publication_title_id required: false type: string - description: Case insensitive search on title access_type --- a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl +++ a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl @@ -0,0 +1,35 @@ +use Modern::Perl; + +return { + bug_number => "34789", + description => "A single line description", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + if ( column_exists( 'erm_eholdings_titles', 'preceeding_publication_title_id' ) ) { + $dbh->do( + q{ + ALTER TABLE erm_eholdings_titles RENAME COLUMN preceeding_publication_title_id TO preceding_publication_title_id + } + ); + say $out 'Column renamed to preceding_publication_title_id'; + } + if ( column_exists( 'erm_eholdings_titles', 'publication_title' ) ) { + $dbh->do( + q{ + ALTER TABLE erm_eholdings_titles MODIFY COLUMN publication_title mediumtext + } + ); + say $out 'Column datatype amended to mediumtext'; + } + if ( column_exists( 'erm_eholdings_titles', 'notes' ) ) { + $dbh->do( + q{ + ALTER TABLE erm_eholdings_titles MODIFY COLUMN notes mediumtext + } + ); + say $out 'Column datatype amended to mediumtext'; + } + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3010,7 +3010,7 @@ DROP TABLE IF EXISTS `erm_eholdings_titles`; CREATE TABLE `erm_eholdings_titles` ( `title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', `biblio_id` int(11) DEFAULT NULL, - `publication_title` varchar(255) DEFAULT NULL, + `publication_title` mediumtext DEFAULT NULL, `external_id` varchar(255) DEFAULT NULL, `print_identifier` varchar(255) DEFAULT NULL, `online_identifier` varchar(255) DEFAULT NULL, @@ -3024,7 +3024,7 @@ CREATE TABLE `erm_eholdings_titles` ( `first_author` varchar(255) DEFAULT NULL, `embargo_info` varchar(255) DEFAULT NULL, `coverage_depth` varchar(255) DEFAULT NULL, - `notes` varchar(255) DEFAULT NULL, + `notes` mediumtext DEFAULT NULL, `publisher_name` varchar(255) DEFAULT NULL, `publication_type` varchar(80) DEFAULT NULL, `date_monograph_published_print` varchar(255) DEFAULT NULL, @@ -3033,7 +3033,7 @@ CREATE TABLE `erm_eholdings_titles` ( `monograph_edition` varchar(255) DEFAULT NULL, `first_editor` varchar(255) DEFAULT NULL, `parent_publication_title_id` varchar(255) DEFAULT NULL, - `preceeding_publication_title_id` varchar(255) DEFAULT NULL, + `preceding_publication_title_id` varchar(255) DEFAULT NULL, `access_type` varchar(255) DEFAULT NULL, PRIMARY KEY (`title_id`), KEY `erm_eholdings_titles_ibfk_2` (`biblio_id`), --