Attachment #140845 for bug #7021

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

Lines 8-16 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_7201.pl (-3 / +4 lines)
8	my ($dbh, $out) = @$args{qw(dbh out)};	8	my ($dbh, $out) = @$args{qw(dbh out)};
9		9
10	if( !column_exists( 'statistics', 'categorycode' ) ) {	10	if( !column_exists( 'statistics', 'categorycode' ) ) {
11	$dbh->do(	11	$dbh->do(q{
12	"ALTER TABLE statistics ADD COLUMN categorycode varchar(10) AFTER ccode"	12	ALTER TABLE statistics
13	);	13	ADD COLUMN categorycode varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category'
		14	});
14	}	15	}
15	},	16	},
16	};	17	};

Lines 4937-4943 CREATE TABLE `statistics` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
4937	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',	4937	`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
4938	`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower',	4938	`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower',
4939	`ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code',	4939	`ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code',
4940	`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',,	4940	`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',
4941	KEY `timeidx` (`datetime`),	4941	KEY `timeidx` (`datetime`),
4942	KEY `branch_idx` (`branch`),	4942	KEY `branch_idx` (`branch`),
4943	KEY `type_idx` (`type`),	4943	KEY `type_idx` (`type`),
4944	-

Return to bug 7021