[Koha-cvs] CVS: koha/updater updatedatabase,1.53,1.54

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1:/tmp/cvs-serv12503/updater

Modified Files:
        updatedatabase 
Log Message:
fix to avoid errors when creating fields that are primary keys and a previous 
primary key exist.

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.53
retrieving revision 1.54
diff -C2 -r1.53 -r1.54
*** updatedatabase      7 Jul 2003 14:11:16 -0000       1.53
--- updatedatabase      7 Jul 2003 15:23:56 -0000       1.54
***************
*** 711,714 ****
--- 711,716 ----
              }
              if ( $key eq 'PRI' ) {
+ # if it's a primary key, drop the previous pk, before altering the table
+                       $dbh->do("alter table $table drop primary key");
                  $key = 'PRIMARY KEY';
              }
***************
*** 867,870 ****
--- 869,875 ----
  
  # $Log$
+ # Revision 1.54  2003/07/07 15:23:56  tipaul
+ # fix to avoid errors when creating fields that are primary keys and a 
previous primary key exist.
+ #
  # Revision 1.53  2003/07/07 14:11:16  tipaul
  # fixing bug #526 : gst rate is now calculated through systempref gist entry.