@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -899,10 +899,10 @@ CREATE TABLE `import_records` ( -- Table structure for `import_record_matches` -- DROP TABLE IF EXISTS `import_record_matches`; -CREATE TABLE `import_record_matches` ( - `import_record_id` int(11) NOT NULL, - `candidate_match_id` int(11) NOT NULL, - `score` int(11) NOT NULL default 0, +CREATE TABLE `import_record_matches` ( -- matches found when importing a batch of records + `import_record_id` int(11) NOT NULL, -- the id given to the imported bib record (import_records.import_record_id) + `candidate_match_id` int(11) NOT NULL, -- the biblio the imported record matches (biblio.biblionumber) + `score` int(11) NOT NULL default 0, -- the match score CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`) REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, KEY `record_score` (`import_record_id`, `score`) @@ -2135,7 +2135,7 @@ CREATE TABLE `z3950servers` ( -- connection information for the Z39.50 targets u `checked` smallint(6) default NULL, -- whether this target is checked by default (1 for yes, 0 for no) `rank` int(11) default NULL, -- where this target appears in the list of targets `syntax` varchar(80) default NULL, -- marc format provided by this target - `timeout` int(11) NOT NULL DEFAULT '0', + `timeout` int(11) NOT NULL DEFAULT '0', -- number of seconds before Koha stops trying to access this server `icon` text, -- unused in Koha `position` enum('primary','secondary','') NOT NULL default 'primary', `type` enum('zed','opensearch') NOT NULL default 'zed', --