[Koha-cvs] CVS: koha/updater updatedatabase,1.78,1.79

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16557/updater

Modified Files:
	updatedatabase 
Log Message:


Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.78
retrieving revision 1.79
diff -C2 -r1.78 -r1.79
*** updatedatabase	10 May 2004 09:29:33 -0000	1.78
--- updatedatabase	18 May 2004 09:50:07 -0000	1.79
***************
*** 249,253 ****
  			   'options' => 'text' },
      z3950servers      => { 'syntax'      => 'char(80)' },
!     marc_subfield_structure =>{'seealso'  => 'char(255)'},
      bookshelf => {'owner' => 'char(80)',
      					'category' => 'char(1)',
--- 249,256 ----
  			   'options' => 'text' },
      z3950servers      => { 'syntax'      => 'char(80)' },
! 	marc_tag_structure =>{
! 							'itemtype' => 'char(4) not NULL default \'\''},
!     marc_subfield_structure =>{'seealso'  => 'char(255)',
! 							'itemtype' => 'char(4) not NULL default \'\''},
      bookshelf => {'owner' => 'char(80)',
      					'category' => 'char(1)',
***************
*** 1016,1019 ****
--- 1019,1027 ----
  $dbh->do('ALTER TABLE issuingrules ADD PRIMARY KEY ( branchcode, categorycode, itemtype )') unless $exists;
  
+ $dbh->do('ALTER TABLE marc_tag_structure drop primary key');
+ $dbh->do('ALTER TABLE marc_tag_structure ADD PRIMARY KEY ( itemtype, tagfield )');
+ 
+ $dbh->do('ALTER TABLE marc_subfield_structure drop primary key');
+ $dbh->do('ALTER TABLE marc_subfield_structure ADD PRIMARY KEY ( itemtype, tagfield, tagsubfield )');
  
  # Populate tables with required data
***************
*** 1068,1071 ****
--- 1076,1082 ----
  
  # $Log$
+ # Revision 1.79  2004/05/18 09:50:07  tipaul
+ # *** empty log message ***
+ #
  # Revision 1.78  2004/05/10 09:29:33  tipaul
  # css is now the default theme for OPAC.