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