Bugzilla – Attachment 71153 Details for
Bug 19066
Add branchcode to accountlines
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19066 - Update Database
Bug-19066---Update-Database.patch (text/plain), 1.39 KB, created by
Kyle M Hall (khall)
on 2018-02-02 16:53:42 UTC
(
hide
)
Description:
Bug 19066 - Update Database
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2018-02-02 16:53:42 UTC
Size:
1.39 KB
patch
obsolete
>From 82c497483dcbf216ca067f08831471395ac524b7 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Wed, 9 Aug 2017 09:50:21 -0400 >Subject: [PATCH] Bug 19066 - Update Database > >--- > installer/data/mysql/atomicupdate/bug_19066.sql | 1 + > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 2 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_19066.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_19066.sql b/installer/data/mysql/atomicupdate/bug_19066.sql >new file mode 100644 >index 0000000..8fe161a >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_19066.sql >@@ -0,0 +1 @@ >+ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f031503..19f44db 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2714,6 +2714,7 @@ CREATE TABLE `accountlines` ( > `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, > `note` text NULL default NULL, > `manager_id` int(11) NULL, >+ `branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc. > PRIMARY KEY (`accountlines_id`), > KEY `acctsborridx` (`borrowernumber`), > KEY `timeidx` (`timestamp`), >-- >2.10.2
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 19066
:
65769
|
65770
|
65771
|
67756
|
67757
|
71153
|
71154
|
71155
|
73185
|
73186
|
73187
|
73595
|
77281
|
77282
|
77283
|
78900
|
78901
|
81144
|
81145
|
81146
|
81253
|
81254
|
81255
|
81684
|
81912
|
81918
|
82047
|
82048
|
82084
|
82086
|
82087
|
82469
|
82470
|
82471
|
82473
|
82474
|
82475
|
82476
|
82477
|
82478
|
83067
|
83068
|
83069
|
83070
|
83071
|
83072
|
83073
|
83074
|
83075
|
83076
|
83077
|
83078
|
83079
|
83080
|
83081
|
83082
|
83083
|
83084
|
83275
|
83519
|
83520
|
83521
|
83522
|
83523
|
83524
|
83525
|
83526
|
83527
|
83528
|
83628