View | Details | Raw Unified | Return to bug 29144
Collapse All | Expand All

(-)a/api/v1/swagger/definitions/library.yaml (-5 lines)
Lines 89-99 properties: Link Here
89
      - string
89
      - string
90
      - "null"
90
      - "null"
91
    description: notes related to your library or branch
91
    description: notes related to your library or branch
92
  opac_info:
93
    type:
94
      - string
95
      - "null"
96
    description: HTML that displays in OPAC
97
  geolocation:
92
  geolocation:
98
    type:
93
    type:
99
      - string
94
      - string
(-)a/api/v1/swagger/paths/libraries.yaml (-5 lines)
Lines 87-97 Link Here
87
        description: Case insensitive 'starts_with' search on notes
87
        description: Case insensitive 'starts_with' search on notes
88
        required: false
88
        required: false
89
        type: string
89
        type: string
90
      - name: opac_info
91
        in: query
92
        description: Case insensitive 'starts-with' search on OPAC info
93
        required: false
94
        type: string
95
      - $ref: "../swagger.yaml#/parameters/match"
90
      - $ref: "../swagger.yaml#/parameters/match"
96
      - $ref: "../swagger.yaml#/parameters/order_by"
91
      - $ref: "../swagger.yaml#/parameters/order_by"
97
      - $ref: "../swagger.yaml#/parameters/page"
92
      - $ref: "../swagger.yaml#/parameters/page"
(-)a/installer/data/mysql/atomicupdate/bug_29144.pl (+19 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => 29144,
5
    description => "Copy and remove branches.opac_info",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
INSERT IGNORE INTO additional_contents ( category,code,location,branchcode,title,content,lang,published_on )
11
SELECT 'html_customizations', CONCAT('OpacLibraryInfo_', branches.branchcode), 'OpacLibraryInfo', branches.branchcode, branches.branchname, branches.opac_info, 'default', NOW()
12
FROM branches
13
WHERE branches.opac_info IS NOT NULL
14
        });
15
        $dbh->do(q{
16
ALTER TABLE branches DROP COLUMN opac_info;
17
        });
18
    },
19
};
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 1531-1537 CREATE TABLE `branches` ( Link Here
1531
  `issuing` tinyint(4) DEFAULT NULL COMMENT 'unused in Koha',
1531
  `issuing` tinyint(4) DEFAULT NULL COMMENT 'unused in Koha',
1532
  `branchip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the IP address for your library or branch',
1532
  `branchip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the IP address for your library or branch',
1533
  `branchnotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'notes related to your library or branch',
1533
  `branchnotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'notes related to your library or branch',
1534
  `opac_info` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'HTML that displays in OPAC',
1535
  `geolocation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'geolocation of your library',
1534
  `geolocation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'geolocation of your library',
1536
  `marcorgcode` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode',
1535
  `marcorgcode` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode',
1537
  `pickup_location` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'the ability to act as a pickup location',
1536
  `pickup_location` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'the ability to act as a pickup location',
1538
- 

Return to bug 29144