5 description => "Make subscription.staffdisplaycount and opacdisplaycount integer columns",
8 my ($dbh, $out) = @$args{qw(dbh out)};
12 SET staffdisplaycount = NULL
13 WHERE staffdisplaycount = ""
16 ALTER TABLE subscription
17 MODIFY COLUMN staffdisplaycount INT(11) NULL DEFAULT NULL
18 COMMENT 'how many issues to show to the staff'
23 SET opacdisplaycount = NULL
24 WHERE opacdisplaycount = ""
27 ALTER TABLE subscription
28 MODIFY COLUMN opacdisplaycount INT(11) NULL DEFAULT NULL
29 COMMENT 'how many issues to show to the public'