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

[Steve Tonnesen]

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

Modified Files:
	marcschema.sql 
Log Message:
removed fieldid in favour of tagid, removed _sergey from table names, added
tagorder field to tag table, renamed marc_field_table to marc_tag_table.


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** marcschema.sql	31 May 2002 19:36:08 -0000	1.10
--- marcschema.sql	31 May 2002 19:41:29 -0000	1.11
***************
*** 1,3 ****
! 
  #  These first three tables store the data from a MARC record.
  	
--- 1,11 ----
! #  $Id$
! #  
! #  $Log$
! #  Revision 1.11  2002/05/31 19:41:29  tonnesen
! #  removed fieldid in favour of tagid, removed _sergey from table names, added
! #  tagorder field to tag table, renamed marc_field_table to marc_tag_table.
! #
! #
! #
  #  These first three tables store the data from a MARC record.
  	
***************
*** 12,23 ****
  		) 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)
  );
--- 20,30 ----
  		) TYPE=MyISAM;
  
! CREATE TABLE marc_tag_table (
!        tagid    bigint(20) unsigned NOT NULL auto_increment,	# tag identifier
         bibid    bigint(20) NOT NULL default '0',                # biblio identifier
         tag      char(3) NOT NULL default '',			# tag number (eg 110)
!        tagorder tinyint(4) NOT NULL default '0',		# display order of tag within a record
!        PRIMARY KEY (tagid),
         KEY (bibid),
         KEY (tag)
  );
***************
*** 25,35 ****
  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)
  );
  
--- 32,42 ----
  CREATE TABLE marc_subfield_table_sergey (
         subfieldid  bigint(20) unsigned NOT NULL auto_increment,	# subfield identifier
!        tagid bigint(20),					# tag identifier
!        subfieldorder tinyint(4) NOT NULL default '0',		# display order for subfields within a tag
         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 (tagid)
  );