[Koha-cvs] CVS: koha/updater updatedatabase,1.86,1.87

[Paul POULAIN]

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

Modified Files:
	updatedatabase 
Log Message:
fixes in DB structure

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.86
retrieving revision 1.87
diff -C2 -r1.86 -r1.87
*** updatedatabase	22 Jun 2004 11:30:57 -0000	1.86
--- updatedatabase	23 Jun 2004 13:03:09 -0000	1.87
***************
*** 252,255 ****
--- 252,256 ----
      auth_header => "(
  						authid bigint(20) unsigned NOT NULL auto_increment,
+ 						authtypecode char(10) NOT NULL default '',
  						datecreated date NOT NULL default '0000-00-00',
  						datemodified date default NULL,
***************
*** 285,288 ****
--- 286,305 ----
  				KEY sndx_word (sndx_word)
  			)",
+ 	suggestions => "(
+ 				suggestionnumber int(8) NOT NULL auto_increment,
+ 				suggestedby int(11) NOT NULL default '0',
+ 				managedby int(11) default NULL,
+ 				status varchar(10) NOT NULL default '',
+ 				note text,
+ 				author varchar(80) default NULL,
+ 				title varchar(80) default NULL,
+ 				copyrightdate smallint(6) default NULL,
+ 				publishercode varchar(255) default NULL,
+ 				date timestamp(8) NOT NULL,
+ 				mailoverseeing smallint(1) default 0,
+ 				PRIMARY KEY  (suggestionnumber),
+ 				KEY suggestedby (suggestedby),
+ 				KEY managedby (managedby)
+ 			)",
  );
  
***************
*** 826,829 ****
--- 843,849 ----
  unless ( $existingtables{'issuingrules'} ) {
  	$dbh->do("alter table categoryitem rename issuingrules");
+ 	$dbh->do("ALTER TABLE issuingrules ADD maxissueqty int(4) default NULL");
+ 	$dbh->do("ALTER TABLE issuingrules ADD issuelength int(4) detault NULL");
+ 	$dbh->do("ALTER TABLE issuingrules ADD branchcode varchar(4) NOT NULL default ''");
  	print "renaming categoryitem\n" unless $silent;
  }
***************
*** 1226,1229 ****
--- 1246,1252 ----
  
  # $Log$
+ # Revision 1.87  2004/06/23 13:03:09  tipaul
+ # fixes in DB structure
+ #
  # Revision 1.86  2004/06/22 11:30:57  tipaul
  # adding -s (silent) flag, to have a silent install.