5 description => "Ability to allow guarantor relationship for all patron category types",
8 my ($dbh,$out) = @$args{qw(dbh out)};
10 unless ( column_exists( 'categories', 'can_be_guarantee' ) ) {
12 ALTER TABLE categories
13 ADD COLUMN `can_be_guarantee` tinyint(1) NOT NULL default 0 COMMENT 'if patrons of this category can be guarantees'
14 AFTER `checkprevcheckout`
16 say $out "Added column 'categories.can_be_guarantee'";
21 SET can_be_guarantee = 1
22 WHERE category_type = 'P' OR category_type = 'C'