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 700-705 CREATE TABLE `export_format` ( Link Here
700
  KEY `staff_only_idx` (`staff_only`)
700
  KEY `staff_only_idx` (`staff_only`)
701
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
701
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
702
702
703
--
704
-- Table structure for table `import_batches_profile`
705
--
706
707
DROP TABLE IF EXISTS `import_batches_profile`;
708
CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported
709
  `id` int(11) NOT NULL auto_increment, -- unique identifier and primary key
710
  `name` varchar(100) NOT NULL, -- name of this profile
711
  `matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id)
712
  `template_id` int(11) default NULL, -- the id of the marc modification template
713
  `overlay_action` varchar(50) default NULL, -- how to handle duplicate records
714
  `nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found
715
  `item_action` varchar(50) default NULL, -- what to do with item records
716
  `parse_items` tinyint(1) default NULL, -- should items be parsed
717
  `record_type` varchar(50) default NULL, -- type of record in the batch
718
  `encoding` varchar(50) default NULL, -- file encoding
719
  `format` varchar(50) default NULL, -- marc format
720
  `comments` LONGTEXT, -- any comments added when the file was uploaded
721
  PRIMARY KEY (`id`),
722
  UNIQUE KEY `u_import_batches_profile__name` (`name`)
723
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
724
703
--
725
--
704
-- Table structure for table `import_batches`
726
-- Table structure for table `import_batches`
705
--
727
--
Lines 721-728 CREATE TABLE `import_batches` ( -- information about batches of marc records tha Link Here
721
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
743
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
722
  `file_name` varchar(100), -- the name of the file uploaded
744
  `file_name` varchar(100), -- the name of the file uploaded
723
  `comments` LONGTEXT, -- any comments added when the file was uploaded
745
  `comments` LONGTEXT, -- any comments added when the file was uploaded
746
  `profile_id` int(11) default NULL,
724
  PRIMARY KEY (`import_batch_id`),
747
  PRIMARY KEY (`import_batch_id`),
725
  KEY `branchcode` (`branchcode`)
748
  KEY `branchcode` (`branchcode`),
749
  CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`)
750
  REFERENCES `import_batches_profile` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
726
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
751
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
727
752
728
--
753
--
729
- 

Return to bug 23019