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

(-)a/Koha/Schema/Result/Branch.pm (-2 / +10 lines)
Lines 128-133 __PACKAGE__->table("branches"); Link Here
128
  data_type: 'text'
128
  data_type: 'text'
129
  is_nullable: 1
129
  is_nullable: 1
130
130
131
=head2 pickup_location
132
133
  data_type: 'tinyint'
134
  default_value: 1
135
  is_nullable: 0
136
131
=cut
137
=cut
132
138
133
__PACKAGE__->add_columns(
139
__PACKAGE__->add_columns(
Lines 171-176 __PACKAGE__->add_columns( Link Here
171
  { data_type => "mediumtext", is_nullable => 1 },
177
  { data_type => "mediumtext", is_nullable => 1 },
172
  "opac_info",
178
  "opac_info",
173
  { data_type => "text", is_nullable => 1 },
179
  { data_type => "text", is_nullable => 1 },
180
  "pickup_location",
181
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
174
);
182
);
175
183
176
=head1 PRIMARY KEY
184
=head1 PRIMARY KEY
Lines 543-550 Composing rels: L</branchrelations> -> categorycode Link Here
543
__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode");
551
__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode");
544
552
545
553
546
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21
554
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2017-02-07 19:53:28
547
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/9YwsU+GXK+fzc6IX2Tj5g
555
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p0gmtxzcyjb8JetqS+RsDg
548
556
549
557
550
# You can replace this text with custom code or comments, and it will be preserved on regeneration
558
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)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 277-282 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
277
  `branchprinter` varchar(100) default NULL, -- unused in Koha
277
  `branchprinter` varchar(100) default NULL, -- unused in Koha
278
  `branchnotes` mediumtext, -- notes related to your library or branch
278
  `branchnotes` mediumtext, -- notes related to your library or branch
279
  opac_info text, -- HTML that displays in OPAC
279
  opac_info text, -- HTML that displays in OPAC
280
  `pickup_location` tinyint(1) NOT NULL default 1, -- the ability to act as a pickup location
280
  PRIMARY KEY (`branchcode`)
281
  PRIMARY KEY (`branchcode`)
281
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
282
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
282
283
283
- 

Return to bug 7534