From 1737ec6a4348a4ef06d7ab2bff512dbecb01180e Mon Sep 17 00:00:00 2001
From: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
Date: Mon, 17 Aug 2009 16:26:14 +0200
Subject: [PATCH] Adding AUTO_INCREMENT to aqbudgets table

---
 installer/data/mysql/updatedatabase.pl | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index b87639bf45..b239c256b5 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2808,10 +2808,17 @@ ADDPERIODS
     $dbh->do(<<BUDGETNAME);
 ALTER TABLE aqbudget RENAME`aqbudgets` 
 BUDGETNAME
+    my $maxbudgetid=$dbh->selectcol_arrayref(<<IDsBUDGET);
+SELECT MAX(aqbudgetid) from aqbudgets 
+BUDGETNAME
+
+    $dbh->do(<<BUDGETAUTOINCREMENT);
+ALTER TABLE `aqbudgets` AUTO_INCREMENT=$$maxbudgetid[0]
+BUDGETAUTOINCREMENT
 
     $dbh->do(<<BUDGETS);
 ALTER TABLE `aqbudgets` 
-   CHANGE  COLUMN aqbudgetid `budget_id` int(11) NOT NULL,
+   CHANGE  COLUMN aqbudgetid `budget_id` int(11) NOT NULL AUTO_INCREMENT,
    CHANGE  COLUMN branchcode `budget_branchcode` varchar(10) default NULL,
    CHANGE  COLUMN budgetamount `budget_amount` decimal(28,6) NOT NULL default '0.00',
    CHANGE  COLUMN bookfundid   `budget_code` varchar(30) default NULL,
-- 
2.39.5