5 description => "Add patron category to the statistics table",
8 my ($dbh, $out) = @$args{qw(dbh out)};
10 if( !column_exists( 'statistics', 'categorycode' ) ) {
12 ALTER TABLE statistics
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'
15 say $out "Added column 'statistics.categorycode'";