Attachment #112715 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 701-706 CREATE TABLE `export_format` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +26 lines)
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	--	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
		725	--
704	-- Table structure for table `import_batches`	726	-- Table structure for table `import_batches`
705	--	727	--
706		728
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	-

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	}