[Koha-cvs] koha/updater updatedatabase [rel_2_2]

[Joshua Ferraro]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_2_2
Changes by:	Joshua Ferraro <kados>	07/05/30 16:16:31

Modified files:
	updater        : updatedatabase 

Log message:
	use the same definition for aqbudgetid in all places (int(11))
	set default value to NULL instead of '0'

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_2_2&r1=1.100.2.60&r2=1.100.2.61

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.100.2.60
retrieving revision 1.100.2.61
diff -u -b -r1.100.2.60 -r1.100.2.61
--- updatedatabase	12 Feb 2007 23:56:11 -0000	1.100.2.60
+++ updatedatabase	30 May 2007 16:16:30 -0000	1.100.2.61
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.100.2.60 2007/02/12 23:56:11 rangi Exp $
+# $Id: updatedatabase,v 1.100.2.61 2007/05/30 16:16:30 kados Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -330,7 +330,7 @@
 						startdate date default '0000-00-00',
 						aqbooksellerid int(11) default '0',
 						cost int(11) default '0',
-						aqbudgetid int(11) default '0',
+						aqbudgetid int(11) default NULL,
 						weeklength tinyint(4) default '0',
 						monthlength tinyint(4) default '0',
 						numberlength tinyint(4) default '0',
@@ -465,7 +465,7 @@
         'sort2'      => 'char(80)',
     },
     aqbudget => {
-        'aqbudgetid' => 'tinyint(4) auto_increment primary key',
+        'aqbudgetid' => 'int(11) auto_increment primary key',
         'branchcode' => 'varchar(4)',
     },
     aqbookfund => { 'branchcode' => 'varchar(4)', },
@@ -1513,7 +1513,7 @@
     aqbudget => [
         {
             field   => 'aqbudgetid',
-            type    => 'tinyint(4)',
+            type    => 'int(11)',
             null    => '',
             key     => 'PRI',
             default => '',
@@ -2324,6 +2324,10 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.100.2.61  2007/05/30 16:16:30  kados
+# use the same definition for aqbudgetid in all places (int(11))
+# set default value to NULL instead of '0'
+#
 # Revision 1.100.2.60  2007/02/12 23:56:11  rangi
 # Adding in missing tables to make the Holiday code work
 #