From f45386a3a4882e40faebbe80babcb70c5eda571f Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 13 Nov 2007 16:23:57 -0600 Subject: [PATCH] matcher serialization -- added matcher code and some keys Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/data/mysql/kohastructure.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 183b2a7e28..739e08d402 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1194,10 +1194,13 @@ CREATE TABLE `marc_tag_structure` ( DROP TABLE IF EXISTS `marc_matchers`; CREATE TABLE `marc_matchers` ( `matcher_id` int(11) NOT NULL auto_increment, + `code` varchar(10) NOT NULL default '', `description` varchar(255) NOT NULL default '', `record_type` varchar(10) NOT NULL default 'biblio', `threshold` int(11) NOT NULL default 0, - PRIMARY KEY (`matcher_id`) + PRIMARY KEY (`matcher_id`), + KEY `code` (`code`), + KEY `record_type` (`record_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- @@ -1228,6 +1231,7 @@ CREATE TABLE `matchpoint_components` ( offset int(4) NOT NULL default 0, length int(4) NOT NULL default 0, PRIMARY KEY (`matchpoint_component_id`), + KEY `by_sequence` (`matchpoint_id`, `sequence`), CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`) REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2