Attachment #22868 for bug #11237

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

Lines 1-6 Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
1	INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES	1	INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
2	('AcqCreateItem','ordering','ordering\|receiving\|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),	2	('AcqCreateItem','ordering','ordering\|receiving\|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'),
3	('AcqItemSetSubfieldsWhenReceived','0','','This syspref set a status for item when items are created when receiving (e.g. 995\$o=5)','Free'),	3	('AcqItemSetSubfieldsWhenReceived','0','','Update subfields in items on receive when items are created when ordering (e.g. 995\$o=5)','Free'),
4	('AcqViewBaskets','user','user\|branch\|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),	4	('AcqViewBaskets','user','user\|branch\|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),
5	('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),	5	('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
6	('AddPatronLists','categorycode','categorycode\|category_type','Allow user to choose what list to pick up from when adding patrons','Choice'),	6	('AddPatronLists','categorycode','categorycode\|category_type','Allow user to choose what list to pick up from when adding patrons','Choice'),




    SetVersion($DBversion);
}


$DBversion = "3.13.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        UPDATE systempreferences
        SET explanation = 'Update subfields in items on receive when items are created when ordering (e.g. o=5|a="foo bar")'
        WHERE variable = "AcqItemSetSubfieldsWhenReceived"
    });
    print "Upgrade to $DBversion done (Bug 11237: Update explanation for AcqItemSetSubfieldsWhenReceived syspref)\n";
    SetVersion($DBversion);
}


=head1 FUNCTIONS

=head2 TableExists($table)

Lines 44-50 Acquisitions: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref (-2 / +1 lines)
44	- when the librarian tries to create an invoice with a duplicate number.	44	- when the librarian tries to create an invoice with a duplicate number.
45	-	45	-
46	- pref: AcqItemSetSubfieldsWhenReceived	46	- pref: AcqItemSetSubfieldsWhenReceived
47	- Set subfields for item when items are created when receiving (e.g. o=5\|a="foo bar")	47	- Update subfields in items on receive when items are created when ordering (e.g. o=5\|a="foo bar")
48		48
49	Printing:	49	Printing:
50	-	50	-
51	-

Return to bug 11237

Lines 7743-7748 if(CheckVersion($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+13 lines)
7743	SetVersion($DBversion);	7743	SetVersion($DBversion);
7744	}	7744	}
7745		7745
		7746
		7747	$DBversion = "3.13.00.XXX";
		7748	if(CheckVersion($DBversion)) {
		7749	$dbh->do(q{
		7750	UPDATE systempreferences
		7751	SET explanation = 'Update subfields in items on receive when items are created when ordering (e.g. o=5\|a="foo bar")'
		7752	WHERE variable = "AcqItemSetSubfieldsWhenReceived"
		7753	});
		7754	print "Upgrade to $DBversion done (Bug 11237: Update explanation for AcqItemSetSubfieldsWhenReceived syspref)\n";
		7755	SetVersion($DBversion);
		7756	}
		7757
		7758
7746	=head1 FUNCTIONS	7759	=head1 FUNCTIONS
7747		7760
7748	=head2 TableExists($table)	7761	=head2 TableExists($table)