From 87a06027086de00142c6221caac6779fecf61571 Mon Sep 17 00:00:00 2001
From: tonnesen <tonnesen>
Date: Thu, 16 May 2002 20:42:55 +0000
Subject: [PATCH] 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)

---
 marc/marcschema.sql | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

diff --git a/marc/marcschema.sql b/marc/marcschema.sql
index 31013a1547..9556196a82 100644
--- a/marc/marcschema.sql
+++ b/marc/marcschema.sql
@@ -115,7 +115,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_1XX_subfield_table (
@@ -126,7 +126,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_2XX_subfield_table (
@@ -137,7 +137,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_3XX_subfield_table (
@@ -148,7 +148,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_4XX_subfield_table (
@@ -159,7 +159,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_5XX_subfield_table (
@@ -170,7 +170,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_6XX_subfield_table (
@@ -181,7 +181,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_7XX_subfield_table (
@@ -192,7 +192,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_8XX_subfield_table (
@@ -203,7 +203,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 	CREATE TABLE marc_9XX_subfield_table (
@@ -214,7 +214,7 @@
 		subfieldcode char(1) NOT NULL default '',
 		subfieldvalue varchar(255) default NULL,
 		valuebloblink bigint(20) default NULL,
-		PRIMARY KEY (subfieldcode),
+		PRIMARY KEY (subfieldid),
 		KEY (bibid,tagid,subfieldcode)
 		) TYPE=MyISAM;
 
-- 
2.39.2