Attachment #105600 for bug #23019

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
  # you can use $dbh here like:
  # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );

  # or perform some test and warn
  if( !TableExists( 'import_batches_profile' ) ) {
    $dbh->do(q{
      CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported
        `id` int(11) NOT NULL auto_increment, -- unique identifier and primary key
        `name` varchar(100) NOT NULL, -- name of this profile
        `matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id)
        `template_id` int(11) default NULL, -- the id of the marc modification template
        `overlay_action` varchar(50) default NULL, -- how to handle duplicate records
        `nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found
        `item_action` varchar(50) default NULL, -- what to do with item records
        `parse_items` tinyint(1) default NULL, -- should items be parsed
        `record_type` varchar(50) default NULL, -- type of record in the batch
        `encoding` varchar(50) default NULL, -- file encoding
        `format` varchar(50) default NULL, -- marc format
        `comments` LONGTEXT, -- any comments added when the file was uploaded
        PRIMARY KEY (`id`),
        UNIQUE KEY `u_import_batches_profile__name` (`name`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    });
  }

  if(!column_exists('import_batches', 'profile_id')) {
    $dbh->do(q{
      ALTER TABLE import_batches ADD COLUMN `profile_id` int(11) default NULL AFTER comments
    });

    $dbh->do(q{
      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
    });
  }

  # Always end with this (adjust the bug info)
  NewVersion( $DBversion, 23019, "Add import_batches_profile table and profile_id column in import_batches");
}




) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';

--
-- Table structure for table `import_batches_profile`
--

DROP TABLE IF EXISTS `import_batches_profile`;
CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported
  `id` int(11) NOT NULL auto_increment, -- unique identifier and primary key
  `name` varchar(100) NOT NULL, -- name of this profile
  `matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id)
  `template_id` int(11) default NULL, -- the id of the marc modification template
  `overlay_action` varchar(50) default NULL, -- how to handle duplicate records
  `nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found
  `item_action` varchar(50) default NULL, -- what to do with item records
  `parse_items` tinyint(1) default NULL, -- should items be parsed
  `record_type` varchar(50) default NULL, -- type of record in the batch
  `encoding` varchar(50) default NULL, -- file encoding
  `format` varchar(50) default NULL, -- marc format
  `comments` LONGTEXT, -- any comments added when the file was uploaded
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_import_batches_profile__name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `import_batches`
--


  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
  `file_name` varchar(100), -- the name of the file uploaded
  `comments` LONGTEXT, -- any comments added when the file was uploaded
  `profile_id` int(11) default NULL,
  PRIMARY KEY (`import_batch_id`),
  KEY `branchcode` (`branchcode`),
  CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`)
  REFERENCES `import_batches_profile` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
- 

Return to bug 23019

Lines 693-698 CREATE TABLE `export_format` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +26 lines)
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	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-23019.perl (+40 lines)
	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	}