Bugzilla – Attachment 67060 Details for
Bug 10132
Add option to set MarcOrgCode on branch level
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10132: Database changes
Bug-10132-Database-changes.patch (text/plain), 2.03 KB, created by
Tomás Cohen Arazi
on 2017-09-11 19:15:50 UTC
(
hide
)
Description:
Bug 10132: Database changes
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi
Created:
2017-09-11 19:15:50 UTC
Size:
2.03 KB
patch
obsolete
>From cd13475dc57ca22d2dc07d45b4614a886e71a171 Mon Sep 17 00:00:00 2001 >From: Josef Moravec <josef.moravec@gmail.com> >Date: Sun, 11 Jun 2017 19:19:38 +0000 >Subject: [PATCH] Bug 10132: Database changes > >Signed-off-by: Hugo Agud <hagud@orex.es> >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > .../atomicupdate/bug10132_add_marcorgcode_to_library.perl | 10 ++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 11 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug10132_add_marcorgcode_to_library.perl > >diff --git a/installer/data/mysql/atomicupdate/bug10132_add_marcorgcode_to_library.perl b/installer/data/mysql/atomicupdate/bug10132_add_marcorgcode_to_library.perl >new file mode 100644 >index 0000000..d781f71 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug10132_add_marcorgcode_to_library.perl >@@ -0,0 +1,10 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ >+ if( !column_exists( 'branches', 'marcorgcode' ) ) { >+ $dbh->do( "ALTER TABLE branches ADD COLUMN marcorgcode VARCHAR(16) default NULL AFTER geolocation" ); >+ } >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 10132 - MARCOrgCode on branch level)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index e227125..bb222ef 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -280,6 +280,7 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st > `branchnotes` mediumtext, -- notes related to your library or branch > opac_info text, -- HTML that displays in OPAC > `geolocation` VARCHAR(255) default NULL, -- geolocation of your library >+ `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode > PRIMARY KEY (`branchcode`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >-- >2.7.4
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 10132
:
64183
|
64184
|
64185
|
64186
|
64187
| 67060 |
67061
|
67062
|
67063
|
67064
|
67065
|
67066
|
67067
|
67208
|
67211