[Koha-cvs] CVS: koha/updater updatedatabase,1.105,1.106

[Henri-Damien LAURENT]

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

Modified Files:
        updatedatabase 
Log Message:
Add branch selection and filter for budgets and funds.
May be too much... Funds could be enough....

It works provided you update your base adding branchcode both in aqbookfund AND 
aqbudget.
If selection in budget is not needed, I shall remove.


Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.105
retrieving revision 1.106
diff -C2 -r1.105 -r1.106
*** updatedatabase      20 Jun 2005 14:36:44 -0000      1.105
--- updatedatabase      6 Jul 2005 17:47:22 -0000       1.106
***************
*** 419,423 ****
                                'sort1' => 'char(80)',
                                'sort2' => 'char(80)', },
!     aqbudget => {'aqbudgetid' => 'tinyint(4) auto_increment primary key'},
      items => {'paidfor' => 'text', 'location' => 'char(80)'},
  
--- 419,424 ----
                                'sort1' => 'char(80)',
                                'sort2' => 'char(80)', },
!     aqbookfund =>{'branchcode'=> 'varchar(4) NULL'},
!     aqbudget => {'aqbudgetid' => 'tinyint(4) auto_increment primary key', 
'branchcode'=> 'varchar(4) NULL'},
      items => {'paidfor' => 'text', 'location' => 'char(80)'},
  
***************
*** 923,926 ****
--- 924,935 ----
              default => ''
          },
+         {
+             field   => 'branchcode',
+             type    => 'varchar(4)',
+             null    => 'NULL',
+             key     => '',
+           default =>'',
+             extra => ''
+         },
      ],
      aqbudget => [
***************
*** 933,936 ****
--- 942,953 ----
              extra => 'auto_increment'
          },
+         {
+             field   => 'branchcode',
+             type    => 'varchar(4)',
+             null    => 'NULL',
+             key     => '',
+           default =>'',
+             extra => ''
+         },
      ],
      z3950servers => [
***************
*** 1486,1489 ****
--- 1503,1513 ----
  
  # $Log$
+ # Revision 1.106  2005/07/06 17:47:22  hdl
+ # Add branch selection and filter for budgets and funds.
+ # May be too much... Funds could be enough....
+ #
+ # It works provided you update your base adding branchcode both in aqbookfund 
AND aqbudget.
+ # If selection in budget is not needed, I shall remove.
+ #
  # Revision 1.105  2005/06/20 14:36:44  tipaul
  # synch'ing 2.2 and head