View | Details | Raw Unified | Return to bug 34789
Collapse All | Expand All

(-)a/api/v1/swagger/definitions/erm_eholdings_title.yaml (-2 / +2 lines)
Lines 124-131 properties: Link Here
124
    type:
124
    type:
125
      - string
125
      - string
126
      - "null"
126
      - "null"
127
  preceeding_publication_title_id:
127
  preceding_publication_title_id:
128
    description: preceeding_publication_title_id of the title
128
    description: preceding_publication_title_id of the title
129
    type:
129
    type:
130
      - string
130
      - string
131
      - "null"
131
      - "null"
(-)a/api/v1/swagger/paths/erm_eholdings_titles.yaml (-2 / +2 lines)
Lines 134-142 Link Here
134
        name: parent_publication_title_id
134
        name: parent_publication_title_id
135
        required: false
135
        required: false
136
        type: string
136
        type: string
137
      - description: Case insensitive search on title preceeding_publication_title_id
137
      - description: Case insensitive search on title preceding_publication_title_id
138
        in: query
138
        in: query
139
        name: preceeding_publication_title_id
139
        name: preceding_publication_title_id
140
        required: false
140
        required: false
141
        type: string
141
        type: string
142
      - description: Case insensitive search on title access_type
142
      - description: Case insensitive search on title access_type
(-)a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl (+35 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "34789",
5
    description => "A single line description",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        if ( column_exists( 'erm_eholdings_titles', 'preceeding_publication_title_id' ) ) {
11
            $dbh->do(
12
                q{
13
                ALTER TABLE erm_eholdings_titles RENAME COLUMN preceeding_publication_title_id TO preceding_publication_title_id
14
            }
15
            );
16
            say $out 'Column renamed to preceding_publication_title_id';
17
        }
18
        if ( column_exists( 'erm_eholdings_titles', 'publication_title' ) ) {
19
            $dbh->do(
20
                q{
21
                ALTER TABLE erm_eholdings_titles MODIFY COLUMN publication_title mediumtext
22
            }
23
            );
24
            say $out 'Column datatype amended to mediumtext';
25
        }
26
        if ( column_exists( 'erm_eholdings_titles', 'notes' ) ) {
27
            $dbh->do(
28
                q{
29
                ALTER TABLE erm_eholdings_titles MODIFY COLUMN notes mediumtext
30
            }
31
            );
32
            say $out 'Column datatype amended to mediumtext';
33
        }
34
    },
35
};
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 3010-3016 DROP TABLE IF EXISTS `erm_eholdings_titles`; Link Here
3010
CREATE TABLE `erm_eholdings_titles` (
3010
CREATE TABLE `erm_eholdings_titles` (
3011
  `title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
3011
  `title_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
3012
  `biblio_id` int(11) DEFAULT NULL,
3012
  `biblio_id` int(11) DEFAULT NULL,
3013
  `publication_title` varchar(255) DEFAULT NULL,
3013
  `publication_title` mediumtext DEFAULT NULL,
3014
  `external_id` varchar(255) DEFAULT NULL,
3014
  `external_id` varchar(255) DEFAULT NULL,
3015
  `print_identifier` varchar(255) DEFAULT NULL,
3015
  `print_identifier` varchar(255) DEFAULT NULL,
3016
  `online_identifier` varchar(255) DEFAULT NULL,
3016
  `online_identifier` varchar(255) DEFAULT NULL,
Lines 3024-3030 CREATE TABLE `erm_eholdings_titles` ( Link Here
3024
  `first_author` varchar(255) DEFAULT NULL,
3024
  `first_author` varchar(255) DEFAULT NULL,
3025
  `embargo_info` varchar(255) DEFAULT NULL,
3025
  `embargo_info` varchar(255) DEFAULT NULL,
3026
  `coverage_depth` varchar(255) DEFAULT NULL,
3026
  `coverage_depth` varchar(255) DEFAULT NULL,
3027
  `notes` varchar(255) DEFAULT NULL,
3027
  `notes` mediumtext DEFAULT NULL,
3028
  `publisher_name` varchar(255) DEFAULT NULL,
3028
  `publisher_name` varchar(255) DEFAULT NULL,
3029
  `publication_type` varchar(80) DEFAULT NULL,
3029
  `publication_type` varchar(80) DEFAULT NULL,
3030
  `date_monograph_published_print` varchar(255) DEFAULT NULL,
3030
  `date_monograph_published_print` varchar(255) DEFAULT NULL,
Lines 3033-3039 CREATE TABLE `erm_eholdings_titles` ( Link Here
3033
  `monograph_edition` varchar(255) DEFAULT NULL,
3033
  `monograph_edition` varchar(255) DEFAULT NULL,
3034
  `first_editor` varchar(255) DEFAULT NULL,
3034
  `first_editor` varchar(255) DEFAULT NULL,
3035
  `parent_publication_title_id` varchar(255) DEFAULT NULL,
3035
  `parent_publication_title_id` varchar(255) DEFAULT NULL,
3036
  `preceeding_publication_title_id` varchar(255) DEFAULT NULL,
3036
  `preceding_publication_title_id` varchar(255) DEFAULT NULL,
3037
  `access_type` varchar(255) DEFAULT NULL,
3037
  `access_type` varchar(255) DEFAULT NULL,
3038
  PRIMARY KEY (`title_id`),
3038
  PRIMARY KEY (`title_id`),
3039
  KEY `erm_eholdings_titles_ibfk_2` (`biblio_id`),
3039
  KEY `erm_eholdings_titles_ibfk_2` (`biblio_id`),
3040
- 

Return to bug 34789