Attachment #60878 for bug #7534

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

Lines 128-133 __PACKAGE__->table("branches"); Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +10 lines)
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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_7534.perl (+7 lines)
	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	}

Lines 277-282 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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