From f379b92c304964a4694abe4c1391ccc2947349b0 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Wed, 18 Jul 2012 10:11:34 -0400 Subject: [PATCH] Bug 6716: document import_record_matches table --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..e0614b3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/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`) -- 1.7.2.3