[Koha-cvs] CVS: koha/updater updatedatabase,1.4.2.7,1.4.2.8

[Steve Tonnesen]

Update of /cvsroot/koha/koha/updater
In directory usw-pr-cvs1:/tmp/cvs-serv4324

Modified Files:
      Tag: rel-1-2
	updatedatabase 
Log Message:
Populate systempreferences table with values for acquisitions and
autoMemberNum.  I have picked acquisitions='simple' and autoMemberNum='1' as
the defaults for these two variables.  Comments?


Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.4.2.7
retrieving revision 1.4.2.8
diff -C2 -r1.4.2.7 -r1.4.2.8
*** updatedatabase	24 Jun 2002 22:01:26 -0000	1.4.2.7
--- updatedatabase	25 Jun 2002 16:56:29 -0000	1.4.2.8
***************
*** 250,253 ****
--- 250,269 ----
  
  
+ # Populate systempreferences if it is empty
+ 
+ $sth=$dbh->prepare("select value from systempreferences where variable='autoMemberNum'")
+ $sth->execute;
+ unless ($sth->rows) {
+     my $sth=$dbh->prepare("insert into systempreferences (variable, value) values ('autoMemberNum', '1')");
+     $sth->execute;
+ }
+ $sth=$dbh->prepare("select value from systempreferences where variable='acquisitions'")
+ $sth->execute;
+ unless ($sth->rows) {
+     my $sth=$dbh->prepare("insert into systempreferences (variable, value) values ('acquisitions', 'simple')");
+     $sth->execute;
+ }
+ 
+ 
  $sth->finish;
  $dbh->disconnect;
***************
*** 256,259 ****
--- 272,280 ----
  
  # $Log$
+ # Revision 1.4.2.8  2002/06/25 16:56:29  tonnesen
+ # Populate systempreferences table with values for acquisitions and
+ # autoMemberNum.  I have picked acquisitions='simple' and autoMemberNum='1' as
+ # the defaults for these two variables.  Comments?
+ #
  # Revision 1.4.2.7  2002/06/24 22:01:26  rangi
  # Have added missing borrowernumber field to the statistics table