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

(-)a/installer/data/mysql/atomicupdate/bug_7534.perl (+7 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE branches ADD COLUMN pickup_location TINYINT(1) not null default 1" );
4
5
    SetVersion( $DBversion );
6
    print "Upgrade to $DBversion done (Bug 7534 - Let libraries have configuration for pickup locations)\n";
7
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 267-272 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
267
  opac_info MEDIUMTEXT, -- HTML that displays in OPAC
267
  opac_info MEDIUMTEXT, -- HTML that displays in OPAC
268
  `geolocation` VARCHAR(255) default NULL, -- geolocation of your library
268
  `geolocation` VARCHAR(255) default NULL, -- geolocation of your library
269
  `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
269
  `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
270
  `pickup_location` tinyint(1) NOT NULL default 1, -- the ability to act as a pickup location
270
  PRIMARY KEY (`branchcode`)
271
  PRIMARY KEY (`branchcode`)
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
272
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
272
273
273
- 

Return to bug 7534