[Koha-cvs] CVS: koha/marc marcschema.sql,1.4,1.5

[Steve Tonnesen]

Update of /cvsroot/koha/koha/marc
In directory usw-pr-cvs1:/tmp/cvs-serv19660

Modified Files:
        marcschema.sql 
Log Message:
Used subfieldcode where I should have used subfieldid (in primary key) Note
that I changed bibcode and tagcode to bibid and tagid as well to avoid
confusion with subfieldcode (which is the one letter subfield code)


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** marcschema.sql      16 May 2002 20:27:12 -0000      1.4
--- marcschema.sql      16 May 2002 20:42:55 -0000      1.5
***************
*** 116,120 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 116,120 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 127,131 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 127,131 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 138,142 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 138,142 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 149,153 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 149,153 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 160,164 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 160,164 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 171,175 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 171,175 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 182,186 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 182,186 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 193,197 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 193,197 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 204,208 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 204,208 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
***************
*** 215,219 ****
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldcode),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;
--- 215,219 ----
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
!               PRIMARY KEY (subfieldid),
                KEY (bibid,tagid,subfieldcode)
                ) TYPE=MyISAM;