From 2110c580eb7a2a90af83b1a865802697a2cbf751 Mon Sep 17 00:00:00 2001 From: tipaul Date: Thu, 30 May 2002 08:00:56 +0000 Subject: [PATCH] some more cleaning : removed duplicated row, added indexes --- marc/marcschema.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/marc/marcschema.sql b/marc/marcschema.sql index b19197adf8..abb8ccd3ed 100644 --- a/marc/marcschema.sql +++ b/marc/marcschema.sql @@ -14,15 +14,17 @@ CREATE TABLE marc_subfield_table ( subfieldid bigint(20) unsigned NOT NULL auto_increment, - tagid bigint(20) NOT NULL default '0', - tag char(3) NOT NULL default '', bibid bigint(20) NOT NULL default '0', - subfieldorder tinyint(4) NOT NULL default '0', + tag char(3) NOT NULL default '', subfieldcode char(1) NOT NULL default '', + subfieldorder tinyint(4) NOT NULL default '0', subfieldvalue varchar(255) default NULL, valuebloblink bigint(20) default NULL, PRIMARY KEY (subfieldid), - KEY (bibid,tagid,tag,subfieldcode), + KEY bibid (bibid), + KEY (tag), + KEY (subfieldcode), + KEY (subfieldorder) ) TYPE=MyISAM; # marc_blob_tag containts tag longer than 255 car. -- 2.39.2