Bugzilla – Attachment 1849 Details for
Bug 4118
Add Collection Code (CCODE) to Statistics Table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Updates the database to support ccodes in stats table
0002-Bugfix-4118-Add-Collection-Code-to-Statistics-Tabl.patch (text/plain), 1.38 KB, created by
Chris Cormack
on 2010-02-05 16:50:00 UTC
(
hide
)
Description:
Updates the database to support ccodes in stats table
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2010-02-05 16:50:00 UTC
Size:
1.38 KB
patch
obsolete
>From d361850d8fe96c8c55c8056380d4b3f0eeaf23e5 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle.m.hall@gmail.com> >Date: Fri, 5 Feb 2010 15:29:36 +0000 >Subject: [PATCH] Bugfix 4118 - Add Collection Code to Statistics Table - DB Update > >--- > installer/data/mysql/updatedatabase.pl | 12 ++++++++++++ > 1 files changed, 12 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index f44c257..8a33590 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -3398,6 +3398,18 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion ($DBversion); > } > >+$DBversion = '3.01.00.113'; >+if (C4::Context->preference("Version") < TransformToNum($DBversion)) { >+ $dbh->do("ALTER TABLE `statistics` ADD `ccode` VARCHAR( 80 ) NULL ;"); >+ $dbh->do("UPDATE statistics SET statistics.ccode = ( SELECT items.ccode FROM items WHERE statistics.itemnumber = items.itemnumber )"); >+ $dbh->do("UPDATE statistics SET statistics.ccode = ( >+ SELECT deleteditems.ccode FROM deleteditems >+ WHERE statistics.itemnumber = deleteditems.itemnumber >+ ) WHERE statistics.ccode IS NULL"); >+ print "Upgrade done ( Added Category Code to Statistics table. )\n"; >+ SetVersion ($DBversion); >+} >+ > =item DropAllForeignKeys($table) > > Drop all foreign keys of the table $table >-- >1.5.6.5 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 4118
:
1848
|
1849
|
10164
|
10165
|
10213
|
10214
|
10602
|
10603
|
10604
|
10605
|
10887
|
11322
|
12172
|
12173
|
12792
|
12793
|
12795