Attachment 2564 Details for Bug 4310 – patch proposed for updatedatabase

[patch] patch proposed for updatedatabase

0001-Bug-4310-Fixing-aqorder-migration.patch (text/plain), 1.31 KB, created by dev_patches on 2010-08-24 11:30:26 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: dev_patches

Created: 2010-08-24 11:30:26 UTC

Size: 1.31 KB

patch

obsolete

>From d66f9b303e8394f6c58b7c659784fe31f3f00537 Mon Sep 17 00:00:00 2001
>From: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
>Date: Tue, 24 Aug 2010 12:28:08 +0200
>Subject: [PATCH] Bug #4310 Fixing aqorder migration
>
>setting correct values and migrating aqorderbreakdown
>---
> installer/data/mysql/updatedatabase.pl |    2 ++
> 1 files changed, 2 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index a0b5c4a..7e04455 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -2997,6 +2997,8 @@ BUDGETDROPDATES
>                     ADD COLUMN  `sort2_authcat` varchar(10) default NULL" );
> 
>                 # cannot do until aqorderbreakdown removed
>+    $dbh->do("UPDATE  aqorders, aqorderbreakdown set aqorders.budget_id=aqorderbreakdown.bookfundid where aqorders.ordernumber=aqorderbreakdown.ordernumber ");
>+    $dbh->do("UPDATE  aqorders, aqorderbreakdown,aqbudgets set aqorders.budget_group_id=aqbudgets.budget_period_id where aqorders.ordernumber=aqorderbreakdown.ordernumber  and aqbudgets=aqorderbreakdown.bookfundid");
> #    $dbh->do("DROP TABLE aqbookfund ");
> 
> #    $dbh->do("ALTER TABLE aqorders  ADD FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON UPDATE CASCADE  " ); ????
>-- 
>1.7.0.4
>

Actions: View | Diff | Splinter Review

Attachments on bug 4310: 2564 | 2603