5 description => "Add password expiration",
8 my ($dbh, $out) = @$args{qw(dbh out)};
9 unless( column_exists('categories', 'password_expiry_days') ){
11 ALTER TABLE categories ADD password_expiry_days SMALLINT(5) NULL DEFAULT NULL AFTER enrolmentperioddate
13 say $out "Added password_expiry_days to categories";
15 unless( column_exists('borrowers', 'password_expiration_date') ){
17 ALTER TABLE borrowers ADD password_expiration_date DATE NULL DEFAULT NULL AFTER dateexpiry
19 say $out "Added password_expiration_date field to borrowers";
21 unless( column_exists('deletedborrowers', 'password_expiration_date') ){
23 ALTER TABLE deletedborrowers ADD password_expiration_date DATE NULL DEFAULT NULL AFTER dateexpiry
25 say $out "Added password_expiration_date field to borrowers";