Attachment #170231 for bug #37593

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

Lines 61-67 item barcode (MARC21 952$p) Link Here

(-)a/Koha/Schema/Result/Deleteditem.pm (-1 / +1 lines)
61	default_value: 0	61	default_value: 0
62	is_nullable: 0	62	is_nullable: 0
63		63
64	boolean value defining whether this this item is available for bookings or not	64	boolean value defining whether this item is available for bookings or not
65		65
66	=head2 dateaccessioned	66	=head2 dateaccessioned
67		67

Lines 63-69 item barcode (MARC21 952$p) Link Here

(-)a/Koha/Schema/Result/Item.pm (-1 / +1 lines)
63	default_value: 0	63	default_value: 0
64	is_nullable: 0	64	is_nullable: 0
65		65
66	boolean value defining whether this this item is available for bookings or not	66	boolean value defining whether this item is available for bookings or not
67		67
68	=head2 dateaccessioned	68	=head2 dateaccessioned
69		69

Lines 80-86 return { Link Here

(-)a/installer/data/mysql/db_revs/230600061.pl (-2 / +2 lines)
80	if ( !column_exists( 'items', 'bookable' ) ) {	80	if ( !column_exists( 'items', 'bookable' ) ) {
81	$dbh->do(	81	$dbh->do(
82	q{	82	q{
83	ALTER TABLE items ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not' AFTER `barcode`	83	ALTER TABLE items ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not' AFTER `barcode`
84	}	84	}
85	);	85	);
86		86
Lines 90-96 return { Link Here
90	if ( !column_exists( 'deleteditems', 'bookable' ) ) {	90	if ( !column_exists( 'deleteditems', 'bookable' ) ) {
91	$dbh->do(	91	$dbh->do(
92	q{	92	q{
93	ALTER TABLE deleteditems ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not' AFTER `barcode`	93	ALTER TABLE deleteditems ADD COLUMN `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not' AFTER `barcode`
94	}	94	}
95	);	95	);
96		96

Lines 100635-100641 this.pdfMake = this.pdfMake \|\| {}; this.pdfMake.vfs = { Link Here

(-)a/koha-tmpl/intranet-tmpl/lib/datatables/datatables.js (-2 / +1 lines)
100635	// on destroy, while the `dt` namespaced event is the one we are	100635	// on destroy, while the `dt` namespaced event is the one we are
100636	// listening for	100636	// listening for
100637	$(settings.nTable).on( 'order.dt.DT', function ( e, ctx, sorting, columns ) {	100637	$(settings.nTable).on( 'order.dt.DT', function ( e, ctx, sorting, columns ) {
100638	if ( settings !== ctx ) { // need to check this this is the host	100638	if ( settings !== ctx ) { // need to check this is the host
100639	return; // table, not a nested one	100639	return; // table, not a nested one
100640	}	100640	}
100641		100641
100642	-

Return to bug 37593

Lines 2750-2756 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
2750	`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',	2750	`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',
2751	`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',	2751	`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',
2752	`barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',	2752	`barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',
2753	`bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not',	2753	`bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not',
2754	`dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',	2754	`dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',
2755	`booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',	2755	`booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',
2756	`homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',	2756	`homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',
Lines 4008-4014 CREATE TABLE `items` ( Link Here
4008	`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',	4008	`biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from biblio table used to link this item to the right bib record',
4009	`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',	4009	`biblioitemnumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblioitems table to link to item to additional information',
4010	`barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',	4010	`barcode` varchar(20) DEFAULT NULL COMMENT 'item barcode (MARC21 952$p)',
4011	`bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this this item is available for bookings or not',	4011	`bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean value defining whether this item is available for bookings or not',
4012	`dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',	4012	`dateaccessioned` date DEFAULT NULL COMMENT 'date the item was acquired or added to Koha (MARC21 952$d)',
4013	`booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',	4013	`booksellerid` longtext DEFAULT NULL COMMENT 'where the item was purchased (MARC21 952$e)',
4014	`homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',	4014	`homebranch` varchar(10) DEFAULT NULL COMMENT 'foreign key from the branches table for the library that owns this item (MARC21 952$a)',