[Koha-cvs] CVS: koha/marc marcschema.sql,1.9,1.10

[Steve Tonnesen]

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

Modified Files:
	marcschema.sql 
Log Message:
Splitting into separate tag and subfield tables


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** marcschema.sql	30 May 2002 08:11:51 -0000	1.9
--- marcschema.sql	31 May 2002 19:36:08 -0000	1.10
***************
*** 3,7 ****
  	
  # marc_biblio contains 1 record for each biblio in the DB
! 	CREATE TABLE marc_biblio (
  		bibid bigint(20) unsigned NOT NULL auto_increment,
  		datecreated date NOT NULL default '0000-00-00',
--- 3,7 ----
  	
  # marc_biblio contains 1 record for each biblio in the DB
! CREATE TABLE marc_biblio (
  		bibid bigint(20) unsigned NOT NULL auto_increment,
  		datecreated date NOT NULL default '0000-00-00',
***************
*** 12,32 ****
  		) TYPE=MyISAM;
  
  
- CREATE TABLE marc_subfield_table (
- 		subfieldid bigint(20) unsigned NOT NULL auto_increment,
- 		bibid bigint(20) NOT NULL default '0',			# biblio idendifier
- 		tag char(3) NOT NULL default '',			# tag number (110)
- 		tagorder tinyint(4) NOT NULL default '1',		# used when a tag is repeatable, from 1 to N
- 		subfieldcode char(1) NOT NULL default '',		# subfieldcode (a)
- 		subfieldorder tinyint(4) NOT NULL default '1',		# used when a subfield is repeatable, from 1 to N
- 		subfieldvalue varchar(255) default NULL,		# the subfield value, is not longer than 255 char
- 		valuebloblink bigint(20) default NULL,			# the link to the blob, if subfield value is longer than 255 char
- 		PRIMARY KEY (subfieldid),
- 		KEY bibid (bibid),					# BRUTE indexes : we index all the fields except subfieldvalue
- 		KEY (tag),						# should have to be optimized later
- 		KEY (tagorder),
- 		KEY (subfieldcode),
- 		KEY (subfieldorder)
- 		) TYPE=MyISAM;
  
  # marc_blob_subfield containts subfields longer than 255 car.
--- 12,37 ----
  		) TYPE=MyISAM;
  
+ CREATE TABLE marc_field_table_sergey (
+        fieldid  bigint(20) unsigned NOT NULL auto_increment,    # field identifier
+        bibid    bigint(20) NOT NULL default '0',                # biblio identifier
+        tagid    bigint(20) NOT NULL default '0',		# tag identifier
+        tag      char(3) NOT NULL default '',			# tag number (eg 110)
+        PRIMARY KEY (fieldid),
+        KEY (bibid),
+        KEY (tagid),
+        KEY (tag)
+ );
+ 
+ CREATE TABLE marc_subfield_table_sergey (
+        subfieldid  bigint(20) unsigned NOT NULL auto_increment,	# subfield identifier
+        fieldid bigint(20),					# field identifier
+        subfieldorder tinyint(4) NOT NULL default '0',		# display order for subfields
+        subfieldcode char(1) NOT NULL default '',		# subfield code
+        subfieldvalue varchar(255) default NULL,			# the subfields value if not longer than 255 char
+        valuebloblink bigint(20) default NULL,			# the link to the blob, if value is longer than 255 char
+        PRIMARY KEY (subfieldid),
+        KEY (fieldid)
+ );
  
  
  # marc_blob_subfield containts subfields longer than 255 car.