[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;