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