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

(-)a/installer/data/mysql/atomicupdate/bug-23019.perl (+40 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
  # you can use $dbh here like:
4
  # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
5
6
  # or perform some test and warn
7
  if( !TableExists( 'import_batches_profile' ) ) {
8
    $dbh->do(q{
9
      CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported
10
        `id` int(11) NOT NULL auto_increment, -- unique identifier and primary key
11
        `name` varchar(100) NOT NULL, -- name of this profile
12
        `matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id)
13
        `template_id` int(11) default NULL, -- the id of the marc modification template
14
        `overlay_action` varchar(50) default NULL, -- how to handle duplicate records
15
        `nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found
16
        `item_action` varchar(50) default NULL, -- what to do with item records
17
        `parse_items` tinyint(1) default NULL, -- should items be parsed
18
        `record_type` varchar(50) default NULL, -- type of record in the batch
19
        `encoding` varchar(50) default NULL, -- file encoding
20
        `format` varchar(50) default NULL, -- marc format
21
        `comments` LONGTEXT, -- any comments added when the file was uploaded
22
        PRIMARY KEY (`id`),
23
        UNIQUE KEY `u_import_batches_profile__name` (`name`)
24
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
25
    });
26
  }
27
28
  if(!column_exists('import_batches', 'profile_id')) {
29
    $dbh->do(q{
30
      ALTER TABLE import_batches ADD COLUMN `profile_id` int(11) default NULL AFTER comments
31
    });
32
33
    $dbh->do(q{
34
      ALTER TABLE import_batches ADD CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`) REFERENCES `import_batches_profile` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
35
    });
36
  }
37
38
  # Always end with this (adjust the bug info)
39
  NewVersion( $DBversion, 23019, "Add import_batches_profile table and profile_id column in import_batches");
40
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +26 lines)
Lines 693-698 CREATE TABLE `export_format` ( Link Here
693
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
693
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
694
694
695
--
695
--
696
-- Table structure for table `import_batches_profile`
697
--
698
699
DROP TABLE IF EXISTS `import_batches_profile`;
700
CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported
701
  `id` int(11) NOT NULL auto_increment, -- unique identifier and primary key
702
  `name` varchar(100) NOT NULL, -- name of this profile
703
  `matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id)
704
  `template_id` int(11) default NULL, -- the id of the marc modification template
705
  `overlay_action` varchar(50) default NULL, -- how to handle duplicate records
706
  `nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found
707
  `item_action` varchar(50) default NULL, -- what to do with item records
708
  `parse_items` tinyint(1) default NULL, -- should items be parsed
709
  `record_type` varchar(50) default NULL, -- type of record in the batch
710
  `encoding` varchar(50) default NULL, -- file encoding
711
  `format` varchar(50) default NULL, -- marc format
712
  `comments` LONGTEXT, -- any comments added when the file was uploaded
713
  PRIMARY KEY (`id`),
714
  UNIQUE KEY `u_import_batches_profile__name` (`name`)
715
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
716
717
--
696
-- Table structure for table `import_batches`
718
-- Table structure for table `import_batches`
697
--
719
--
698
720
Lines 713-720 CREATE TABLE `import_batches` ( -- information about batches of marc records tha Link Here
713
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
735
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
714
  `file_name` varchar(100), -- the name of the file uploaded
736
  `file_name` varchar(100), -- the name of the file uploaded
715
  `comments` LONGTEXT, -- any comments added when the file was uploaded
737
  `comments` LONGTEXT, -- any comments added when the file was uploaded
738
  `profile_id` int(11) default NULL,
716
  PRIMARY KEY (`import_batch_id`),
739
  PRIMARY KEY (`import_batch_id`),
717
  KEY `branchcode` (`branchcode`)
740
  KEY `branchcode` (`branchcode`),
741
  CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`)
742
  REFERENCES `import_batches_profile` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
718
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
743
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
719
744
720
--
745
--
721
- 

Return to bug 23019